API tools faq
paste
Guest User

Untitled

a guest
Jul 11th, 2013
83
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 80.02 KB | None | 0 0
raw download clone embed print report
  1. Joomla! Debug Console
  2. SESSION
  3. __default
  4. Profile Information
  5. TIME
  6. Memory
  7. TIME: 0.1 ms / 0.1 ms Memory: 0.182 MB / 0.18 MB Application: afterLoad
  8. TIME: 64.0 ms / 64.0 ms Memory: 0.775 MB / 0.96 MB Application: afterInitialise
  9. TIME: 28.0 ms / 92.1 ms Memory: 0.351 MB / 1.31 MB Application: afterRoute
  10. TIME: 9573.4 ms / 9665.5 ms Memory: 1.930 MB / 3.24 MB Application: afterDispatch
  11. TIME: 8.5 ms / 9674.0 ms Memory: 0.064 MB / 3.30 MB Application: beforeRenderModule mod_articles_latest (Latest Article)
  12. TIME: 4470.5 ms / 14144.5 ms Memory: 0.084 MB / 3.39 MB Application: afterRenderModule mod_articles_latest (Latest Article)
  13. TIME: 0.2 ms / 14144.7 ms Memory: 0.000 MB / 3.38 MB Application: beforeRenderModule mod_login (Login Form)
  14. TIME: 7.9 ms / 14152.6 ms Memory: 0.051 MB / 3.43 MB Application: afterRenderModule mod_login (Login Form)
  15. TIME: 0.4 ms / 14153.0 ms Memory: 0.001 MB / 3.43 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  16. TIME: 3.7 ms / 14156.7 ms Memory: 0.019 MB / 3.45 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
  17. TIME: 0.7 ms / 14157.3 ms Memory: 0.000 MB / 3.45 MB Application: beforeRenderModule mod_menu (Main Menu)
  18. TIME: 6.6 ms / 14163.9 ms Memory: 0.046 MB / 3.50 MB Application: afterRenderModule mod_menu (Main Menu)
  19. TIME: 4.5 ms / 14168.5 ms Memory: 0.018 MB / 3.52 MB Application: afterRender
  20.  
  21. DATABASE queries total: 13977.9 ms
  22. Memory Usage
  23. 3.84 MB (4,026,892 Bytes)
  24. DATABASE Queries
  25. 95 Queries Logged 13977.9 ms
  26.  
  27. 2 duplicate found!
  28. 2 duplicates: #11  #28
  29.  
  30.     Query TIME: 0.95 ms Query memory: 0.008 MB Memory BEFORE query: 0.501 MB ROWS returned: 1
  31.  
  32.     SELECT `data`
  33.  
  34.       FROM `w0z9v_session`
  35.  
  36.       WHERE `session_id` = 'tjl2iv5e7e5kjfu03l9ul0tt30'
  37.  
  38.     EXPLAIN
  39.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  40.     1   SIMPLE  w0z9v_session   const   PRIMARY PRIMARY 602 const   1  
  41.     Profile
  42.     STATUS  Duration
  43.     starting    0.0 ms
  44.     Waiting FOR query cache LOCK    0.0 ms
  45.     checking query cache FOR query  0.1 ms
  46.     checking permissions    0.0 ms
  47.     Opening TABLES  0.1 ms
  48.     System LOCK 0.0 ms
  49.     Waiting FOR query cache LOCK    0.1 ms
  50.     init    0.1 ms
  51.     optimizing  0.0 ms
  52.     statistics  0.1 ms
  53.     preparing   0.1 ms
  54.     executing   0.0 ms
  55.     Sending DATA    0.0 ms
  56.     END 0.0 ms
  57.     query END   0.0 ms
  58.     closing TABLES  0.0 ms
  59.     freeing items   0.0 ms
  60.     Waiting FOR query cache LOCK    0.0 ms
  61.     freeing items   0.0 ms
  62.     Waiting FOR query cache LOCK    0.0 ms
  63.     freeing items   0.0 ms
  64.     storing RESULT IN query cache   0.1 ms
  65.     logging slow query  0.0 ms
  66.     cleaning up 0.0 ms
  67.     CALL Stack
  68.     JROOT/libraries/joomla/SESSION/storage/DATABASE.php:46
  69.     JROOT/libraries/joomla/SESSION/SESSION.php:654
  70.     JROOT/libraries/joomla/SESSION/SESSION.php:592
  71.     JROOT/libraries/legacy/application/application.php:982
  72.     JROOT/libraries/legacy/application/application.php:140
  73.     JROOT/includes/application.php:47
  74.     JROOT/libraries/legacy/application/application.php:175
  75.     JROOT/libraries/joomla/factory.php:104
  76.     JROOT/INDEX.php:37
  77.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  78.     Query TIME: 0.36 ms After LAST query: 6.27 ms Query memory: 0.005 MB Memory BEFORE query: 0.635 MB ROWS returned: 1
  79.  
  80.     SELECT extension_id AS id, element AS "option", params, enabled
  81.  
  82.       FROM w0z9v_extensions
  83.  
  84.       WHERE `type` = 'component'
  85.       AND `element` = 'com_users'
  86.  
  87.     EXPLAIN
  88.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  89.     1   SIMPLE  w0z9v_extensions    REF element_clientid,element_folder_clientid,extension  element_clientid    302 const   1   USING WHERE
  90.     Profile
  91.     STATUS  Duration
  92.     starting    0.0 ms
  93.     Waiting FOR query cache LOCK    0.0 ms
  94.     checking query cache FOR query  0.0 ms
  95.     checking privileges ON cached   0.0 ms
  96.     checking permissions    0.0 ms
  97.     sending cached RESULT TO clien  0.0 ms
  98.     logging slow query  0.0 ms
  99.     cleaning up 0.0 ms
  100.     CALL Stack
  101.     JROOT/libraries/joomla/cache/controller/callback.php:158
  102.     JROOT/libraries/legacy/component/helper.php:384
  103.     JROOT/libraries/legacy/component/helper.php:43
  104.     JROOT/libraries/legacy/component/helper.php:91
  105.     JROOT/includes/application.php:63
  106.     JROOT/INDEX.php:40
  107.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  108.     Query TIME: 0.35 ms After LAST query: 3.70 ms Query memory: 0.004 MB Memory BEFORE query: 0.638 MB ROWS returned: 42
  109.  
  110.     SELECT folder AS TYPE, element AS name, params
  111.  
  112.       FROM w0z9v_extensions
  113.  
  114.       WHERE enabled >= 1
  115.       AND TYPE ='plugin'
  116.       AND state >= 0
  117.       AND access IN (1,1,5)
  118.  
  119.       ORDER BY ordering
  120.  
  121.     EXPLAIN
  122.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  123.     1   SIMPLE  w0z9v_extensions    REF extension   extension   62  const   58  USING WHERE; USING filesort
  124.     Profile
  125.     STATUS  Duration
  126.     starting    0.0 ms
  127.     Waiting FOR query cache LOCK    0.0 ms
  128.     checking query cache FOR query  0.0 ms
  129.     checking privileges ON cached   0.0 ms
  130.     checking permissions    0.0 ms
  131.     sending cached RESULT TO clien  0.0 ms
  132.     logging slow query  0.0 ms
  133.     cleaning up 0.0 ms
  134.     CALL Stack
  135.     JROOT/libraries/joomla/plugin/helper.php:280
  136.     JROOT/libraries/joomla/plugin/helper.php:165
  137.     JROOT/includes/application.php:69
  138.     JROOT/INDEX.php:40
  139.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  140.     Query TIME: 0.28 ms After LAST query: 3.27 ms Query memory: 0.005 MB Memory BEFORE query: 0.680 MB ROWS returned: 1
  141.  
  142.     SELECT extension_id AS id, element AS "option", params, enabled
  143.  
  144.       FROM w0z9v_extensions
  145.  
  146.       WHERE `type` = 'component'
  147.       AND `element` = 'com_languages'
  148.  
  149.     EXPLAIN
  150.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  151.     1   SIMPLE  w0z9v_extensions    REF element_clientid,element_folder_clientid,extension  element_clientid    302 const   1   USING WHERE
  152.     Profile
  153.     STATUS  Duration
  154.     starting    0.0 ms
  155.     Waiting FOR query cache LOCK    0.0 ms
  156.     checking query cache FOR query  0.0 ms
  157.     checking privileges ON cached   0.0 ms
  158.     checking permissions    0.0 ms
  159.     sending cached RESULT TO clien  0.0 ms
  160.     logging slow query  0.0 ms
  161.     cleaning up 0.0 ms
  162.     CALL Stack
  163.     JROOT/libraries/joomla/cache/controller/callback.php:158
  164.     JROOT/libraries/legacy/component/helper.php:384
  165.     JROOT/libraries/legacy/component/helper.php:43
  166.     JROOT/libraries/legacy/component/helper.php:91
  167.     JROOT/includes/application.php:116
  168.     JROOT/INDEX.php:40
  169.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  170.     Query TIME: 0.48 ms After LAST query: 40.94 ms Query memory: 0.009 MB Memory BEFORE query: 1.105 MB ROWS returned: 17
  171.  
  172.     SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.TYPE, m.level, m.LANGUAGE,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element AS component
  173.  
  174.       FROM w0z9v_menu AS m
  175.  
  176.       LEFT JOIN w0z9v_extensions AS e
  177.       ON m.component_id = e.extension_id
  178.  
  179.       WHERE m.published = 1
  180.       AND m.parent_id > 0
  181.       AND m.client_id = 0
  182.  
  183.       ORDER BY m.lft
  184.  
  185.     EXPLAIN
  186.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  187.     1   SIMPLE  m   REF idx_client_id_parent_id_alias_language  idx_client_id_parent_id_alias_language  1   const   17  USING WHERE; USING filesort
  188.     1   SIMPLE  e   eq_ref  PRIMARY PRIMARY 4   m31.m.component_id  1  
  189.     Profile
  190.     STATUS  Duration
  191.     starting    0.0 ms
  192.     Waiting FOR query cache LOCK    0.0 ms
  193.     checking query cache FOR query  0.0 ms
  194.     checking privileges ON cached   0.0 ms
  195.     checking permissions    0.0 ms
  196.     checking permissions    0.0 ms
  197.     sending cached RESULT TO clien  0.1 ms
  198.     logging slow query  0.0 ms
  199.     cleaning up 0.0 ms
  200.     CALL Stack
  201.     JROOT/libraries/cms/menu/site.php:45
  202.     JROOT/libraries/legacy/menu/menu.php:61
  203.     JROOT/libraries/legacy/menu/menu.php:113
  204.     JROOT/libraries/legacy/application/application.php:893
  205.     JROOT/includes/application.php:593
  206.     JROOT/libraries/cms/router/site.php:203
  207.     JROOT/libraries/joomla/application/router.php:182
  208.     JROOT/libraries/cms/router/site.php:83
  209.     JROOT/libraries/legacy/application/application.php:246
  210.     JROOT/includes/application.php:155
  211.     JROOT/INDEX.php:46
  212.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  213.     Query TIME: 0.16 ms After LAST query: 15.40 ms Query memory: 0.012 MB Memory BEFORE query: 1.307 MB ROWS returned: 1
  214.  
  215.     SELECT extension_id AS id, element AS "option", params, enabled
  216.  
  217.       FROM w0z9v_extensions
  218.  
  219.       WHERE `type` = 'component'
  220.       AND `element` = 'com_content'
  221.  
  222.     EXPLAIN
  223.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  224.     1   SIMPLE  w0z9v_extensions    REF element_clientid,element_folder_clientid,extension  element_clientid    302 const   1   USING WHERE
  225.     Profile
  226.     STATUS  Duration
  227.     starting    0.0 ms
  228.     Waiting FOR query cache LOCK    0.0 ms
  229.     checking query cache FOR query  0.0 ms
  230.     checking privileges ON cached   0.0 ms
  231.     checking permissions    0.0 ms
  232.     sending cached RESULT TO clien  0.0 ms
  233.     logging slow query  0.0 ms
  234.     cleaning up 0.0 ms
  235.     CALL Stack
  236.     JROOT/libraries/joomla/cache/controller/callback.php:158
  237.     JROOT/libraries/legacy/component/helper.php:384
  238.     JROOT/libraries/legacy/component/helper.php:43
  239.     JROOT/libraries/legacy/component/helper.php:91
  240.     JROOT/components/com_content/router.php:26
  241.     JROOT/libraries/cms/router/site.php:426
  242.     JROOT/libraries/joomla/application/router.php:214
  243.     JROOT/libraries/cms/router/site.php:97
  244.     JROOT/libraries/joomla/application/route.php:62
  245.     JROOT/plugins/system/sef/sef.php:49
  246.     JROOT/libraries/joomla/event/event.php:71
  247.     JROOT/libraries/joomla/event/dispatcher.php:161
  248.     JROOT/libraries/joomla/application/base.php:106
  249.     JROOT/libraries/legacy/application/application.php:255
  250.     JROOT/includes/application.php:155
  251.     JROOT/INDEX.php:46
  252.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  253.     Query TIME: 0.16 ms After LAST query: 3.03 ms Query memory: 0.004 MB Memory BEFORE query: 1.341 MB ROWS returned: 1
  254.  
  255.     SELECT *
  256.  
  257.       FROM w0z9v_languages
  258.  
  259.       WHERE published=1
  260.  
  261.       ORDER BY ordering ASC
  262.  
  263.     EXPLAIN
  264.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  265.     1   SIMPLE  w0z9v_languages ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    1   USING WHERE; USING filesort
  266.     Profile
  267.     STATUS  Duration
  268.     starting    0.0 ms
  269.     Waiting FOR query cache LOCK    0.0 ms
  270.     checking query cache FOR query  0.0 ms
  271.     checking privileges ON cached   0.0 ms
  272.     checking permissions    0.0 ms
  273.     sending cached RESULT TO clien  0.0 ms
  274.     logging slow query  0.0 ms
  275.     cleaning up 0.0 ms
  276.     CALL Stack
  277.     JROOT/libraries/joomla/LANGUAGE/helper.php:159
  278.     JROOT/includes/application.php:381
  279.     JROOT/includes/application.php:177
  280.     JROOT/INDEX.php:52
  281.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  282.     Query TIME: 0.19 ms After LAST query: 2.31 ms Query memory: 0.004 MB Memory BEFORE query: 1.352 MB ROWS returned: 2
  283.  
  284.     SELECT id, home, template, s.params
  285.  
  286.       FROM w0z9v_template_styles AS s
  287.  
  288.       LEFT JOIN w0z9v_extensions AS e
  289.       ON e.element=s.template
  290.       AND e.TYPE='template'
  291.       AND e.client_id=s.client_id
  292.  
  293.       WHERE s.client_id = 0
  294.       AND e.enabled = 1
  295.  
  296.     EXPLAIN
  297.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  298.     1   SIMPLE  s   ALL idx_template    NO INDEX KEY COULD BE USED  NULL    NULL    4   USING WHERE
  299.     1   SIMPLE  e   REF element_clientid,element_folder_clientid,extension  element_clientid    303 m31.s.template,const    1   USING WHERE
  300.     Profile
  301.     STATUS  Duration
  302.     starting    0.0 ms
  303.     Waiting FOR query cache LOCK    0.0 ms
  304.     checking query cache FOR query  0.0 ms
  305.     checking privileges ON cached   0.0 ms
  306.     checking permissions    0.0 ms
  307.     checking permissions    0.0 ms
  308.     sending cached RESULT TO clien  3.4 ms
  309.     logging slow query  0.0 ms
  310.     cleaning up 0.0 ms
  311.     CALL Stack
  312.     JROOT/includes/application.php:495
  313.     JROOT/libraries/legacy/component/helper.php:291
  314.     JROOT/includes/application.php:220
  315.     JROOT/INDEX.php:52
  316.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  317.     Query TIME: 0.19 ms After LAST query: 16.46 ms Query memory: 0.012 MB Memory BEFORE query: 1.895 MB ROWS returned: 2
  318.  
  319.     SELECT b.rules
  320.  
  321.       FROM w0z9v_assets AS a
  322.  
  323.       LEFT JOIN w0z9v_assets AS b
  324.       ON b.lft <= a.lft
  325.       AND b.rgt >= a.rgt
  326.  
  327.       WHERE (a.name = 'com_content')
  328.  
  329.       GROUP BY b.id, b.rules, b.lft
  330.  
  331.       ORDER BY b.lft
  332.  
  333.     EXPLAIN
  334.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  335.     1   SIMPLE  a   const   idx_asset_name  idx_asset_name  152 const   1   USING TEMPORARY; USING filesort
  336.     1   SIMPLE  b   range   idx_lft_rgt idx_lft_rgt 4   NULL    11  USING WHERE
  337.     Profile
  338.     STATUS  Duration
  339.     starting    0.0 ms
  340.     Waiting FOR query cache LOCK    0.0 ms
  341.     checking query cache FOR query  0.0 ms
  342.     checking privileges ON cached   0.0 ms
  343.     checking permissions    0.0 ms
  344.     checking permissions    0.0 ms
  345.     sending cached RESULT TO clien  0.0 ms
  346.     logging slow query  0.0 ms
  347.     cleaning up 0.0 ms
  348.     CALL Stack
  349.     JROOT/libraries/joomla/access/access.php:250
  350.     JROOT/libraries/joomla/access/access.php:110
  351.     JROOT/libraries/joomla/USER/USER.php:362
  352.     JROOT/components/com_content/models/category.php:129
  353.     JROOT/libraries/legacy/model/legacy.php:412
  354.     JROOT/components/com_content/models/category.php:326
  355.     JROOT/libraries/legacy/VIEW/legacy.php:398
  356.     JROOT/components/com_content/views/category/VIEW.html.php:44
  357.     JROOT/libraries/legacy/controller/legacy.php:685
  358.     JROOT/components/com_content/controller.php:79
  359.     JROOT/libraries/legacy/controller/legacy.php:722
  360.     JROOT/components/com_content/content.php:16
  361.     JROOT/libraries/legacy/component/helper.php:355
  362.     JROOT/libraries/legacy/component/helper.php:335
  363.     JROOT/includes/application.php:220
  364.     JROOT/INDEX.php:52
  365.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  366.     Query TIME: 0.16 ms After LAST query: 2.04 ms Query memory: 0.012 MB Memory BEFORE query: 1.936 MB ROWS returned: 2
  367.  
  368.     SELECT b.id
  369.  
  370.       FROM w0z9v_usergroups AS a
  371.  
  372.       LEFT JOIN w0z9v_usergroups AS b
  373.       ON b.lft <= a.lft
  374.       AND b.rgt >= a.rgt
  375.  
  376.       WHERE a.id = 9
  377.  
  378.     EXPLAIN
  379.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  380.     1   SIMPLE  a   const   PRIMARY PRIMARY 4   const   1  
  381.     1   SIMPLE  b   range   idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4   NULL    3   USING WHERE; USING INDEX
  382.     Profile
  383.     STATUS  Duration
  384.     starting    0.0 ms
  385.     Waiting FOR query cache LOCK    0.0 ms
  386.     checking query cache FOR query  0.0 ms
  387.     checking privileges ON cached   0.0 ms
  388.     checking permissions    0.0 ms
  389.     checking permissions    0.0 ms
  390.     sending cached RESULT TO clien  0.0 ms
  391.     logging slow query  0.0 ms
  392.     cleaning up 0.0 ms
  393.     CALL Stack
  394.     JROOT/libraries/joomla/access/access.php:336
  395.     JROOT/libraries/joomla/access/access.php:114
  396.     JROOT/libraries/joomla/USER/USER.php:362
  397.     JROOT/components/com_content/models/category.php:129
  398.     JROOT/libraries/legacy/model/legacy.php:412
  399.     JROOT/components/com_content/models/category.php:326
  400.     JROOT/libraries/legacy/VIEW/legacy.php:398
  401.     JROOT/components/com_content/views/category/VIEW.html.php:44
  402.     JROOT/libraries/legacy/controller/legacy.php:685
  403.     JROOT/components/com_content/controller.php:79
  404.     JROOT/libraries/legacy/controller/legacy.php:722
  405.     JROOT/components/com_content/content.php:16
  406.     JROOT/libraries/legacy/component/helper.php:355
  407.     JROOT/libraries/legacy/component/helper.php:335
  408.     JROOT/includes/application.php:220
  409.     JROOT/INDEX.php:52
  410.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  411.     Query TIME: 0.20 ms After LAST query: 2.36 ms Query memory: 0.010 MB Memory BEFORE query: 1.961 MB ROWS returned: 3
  412.     Duplicate queries: #28
  413.  
  414.     SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  415.                 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  416.                 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  417.                 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
  418.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
  419.  
  420.       FROM w0z9v_categories AS c
  421.  
  422.       LEFT JOIN w0z9v_categories AS s
  423.       ON (s.lft <= c.lft
  424.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  425.       AND s.rgt < c.rgt)
  426.  
  427.       LEFT JOIN  (SELECT cat.id AS id
  428.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  429.       ON cat.lft BETWEEN parent.lft
  430.       AND parent.rgt
  431.       WHERE parent.extension = 'com_content'
  432.       AND parent.published != 1
  433.       GROUP BY cat.id) AS badcats
  434.       ON badcats.id = c.id
  435.  
  436.       WHERE (c.extension='com_content' OR c.extension='system')
  437.       AND c.access IN (1,1,5)
  438.       AND c.published = 1
  439.       AND s.id=8
  440.       AND badcats.id IS NULL
  441.  
  442.       GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  443.                  c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  444.                  c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  445.                  c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
  446.  
  447.       ORDER BY c.lft
  448.  
  449.     EXPLAIN
  450.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  451.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  452.     1   PRIMARY s   const   PRIMARY,idx_left_right  PRIMARY 4   const   1   USING filesort
  453.     1   PRIMARY c   ALL cat_idx,idx_access,idx_left_right   NO INDEX KEY COULD BE USED  NULL    NULL    13  USING WHERE
  454.     2   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  455.     2   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  456.     Profile
  457.     STATUS  Duration
  458.     starting    0.0 ms
  459.     Waiting FOR query cache LOCK    0.0 ms
  460.     checking query cache FOR query  0.0 ms
  461.     checking privileges ON cached   0.0 ms
  462.     checking permissions    0.0 ms
  463.     checking permissions    0.0 ms
  464.     checking permissions    0.0 ms
  465.     checking permissions    0.0 ms
  466.     sending cached RESULT TO clien  0.0 ms
  467.     logging slow query  0.0 ms
  468.     cleaning up 0.0 ms
  469.     CALL Stack
  470.     JROOT/libraries/legacy/categories/categories.php:288
  471.     JROOT/libraries/legacy/categories/categories.php:181
  472.     JROOT/components/com_content/models/category.php:326
  473.     JROOT/libraries/legacy/VIEW/legacy.php:398
  474.     JROOT/components/com_content/views/category/VIEW.html.php:44
  475.     JROOT/libraries/legacy/controller/legacy.php:685
  476.     JROOT/components/com_content/controller.php:79
  477.     JROOT/libraries/legacy/controller/legacy.php:722
  478.     JROOT/components/com_content/content.php:16
  479.     JROOT/libraries/legacy/component/helper.php:355
  480.     JROOT/libraries/legacy/component/helper.php:335
  481.     JROOT/includes/application.php:220
  482.     JROOT/INDEX.php:52
  483.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  484.     Query TIME: 0.13 ms After LAST query: 1.33 ms Query memory: 0.011 MB Memory BEFORE query: 1.982 MB ROWS returned: 4
  485.  
  486.     SELECT b.rules
  487.  
  488.       FROM w0z9v_assets AS a
  489.  
  490.       LEFT JOIN w0z9v_assets AS b
  491.       ON b.lft <= a.lft
  492.       AND b.rgt >= a.rgt
  493.  
  494.       WHERE (a.name = 'com_content.category.8')
  495.  
  496.       GROUP BY b.id, b.rules, b.lft
  497.  
  498.       ORDER BY b.lft
  499.  
  500.     EXPLAIN
  501.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  502.     1   SIMPLE  a   const   idx_asset_name  idx_asset_name  152 const   1   USING TEMPORARY; USING filesort
  503.     1   SIMPLE  b   range   idx_lft_rgt idx_lft_rgt 4   NULL    14  USING WHERE
  504.     Profile
  505.     STATUS  Duration
  506.     starting    0.0 ms
  507.     Waiting FOR query cache LOCK    0.0 ms
  508.     checking query cache FOR query  0.0 ms
  509.     checking privileges ON cached   0.0 ms
  510.     checking permissions    0.0 ms
  511.     checking permissions    0.0 ms
  512.     sending cached RESULT TO clien  0.0 ms
  513.     logging slow query  0.0 ms
  514.     cleaning up 0.0 ms
  515.     CALL Stack
  516.     JROOT/libraries/joomla/access/access.php:250
  517.     JROOT/libraries/joomla/access/access.php:110
  518.     JROOT/libraries/joomla/USER/USER.php:362
  519.     JROOT/components/com_content/models/category.php:335
  520.     JROOT/libraries/legacy/VIEW/legacy.php:398
  521.     JROOT/components/com_content/views/category/VIEW.html.php:44
  522.     JROOT/libraries/legacy/controller/legacy.php:685
  523.     JROOT/components/com_content/controller.php:79
  524.     JROOT/libraries/legacy/controller/legacy.php:722
  525.     JROOT/components/com_content/content.php:16
  526.     JROOT/libraries/legacy/component/helper.php:355
  527.     JROOT/libraries/legacy/component/helper.php:335
  528.     JROOT/includes/application.php:220
  529.     JROOT/INDEX.php:52
  530.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  531.     Query TIME: 4829.64 ms After LAST query: 6.01 ms Query memory: 0.011 MB Memory BEFORE query: 2.129 MB ROWS returned: 10
  532.  
  533.     SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
  534.       CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END AS modified, a.modified_by, uam.name AS modified_by_name,
  535.       CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END AS publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  536.       CASE WHEN badcats.id IS NOT NULL THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  537.       CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id AS contactid,parent.title AS parent_title, parent.id AS parent_id, parent.path AS parent_route, parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count AS rating_count,c.published,
  538.       CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
  539.  
  540.       FROM w0z9v_content AS a
  541.  
  542.       LEFT JOIN w0z9v_content_frontpage AS fp
  543.       ON fp.content_id = a.id
  544.  
  545.       LEFT JOIN w0z9v_categories AS c
  546.       ON c.id = a.catid
  547.  
  548.       LEFT JOIN w0z9v_users AS ua
  549.       ON ua.id = a.created_by
  550.  
  551.       LEFT JOIN w0z9v_users AS uam
  552.       ON uam.id = a.modified_by
  553.  
  554.       LEFT JOIN (
  555.     SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  556.  
  557.       FROM w0z9v_contact_details AS contact
  558.  
  559.       WHERE contact.published = 1
  560.  
  561.       GROUP BY contact.user_id, contact.LANGUAGE) AS contact
  562.       ON contact.user_id = a.created_by
  563.  
  564.       LEFT JOIN w0z9v_categories AS parent
  565.       ON parent.id = c.parent_id
  566.  
  567.       LEFT JOIN w0z9v_content_rating AS v
  568.       ON a.id = v.content_id
  569.  
  570.       LEFT
  571.       OUTER JOIN (SELECT cat.id AS id
  572.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  573.       ON cat.lft BETWEEN parent.lft
  574.       AND parent.rgt
  575.       WHERE parent.extension = 'com_content'
  576.       AND parent.published != 1
  577.       GROUP BY cat.id ) AS badcats
  578.       ON badcats.id = c.id
  579.  
  580.       WHERE a.access IN (1,1,5)
  581.       AND c.access IN (1,1,5)
  582.       AND
  583.       CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END = 1
  584.       AND a.catid = 8
  585.       AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-11 13:35:12')
  586.       AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-11 13:35:12')
  587.  
  588.       GROUP BY a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
  589.  
  590.       ORDER BY  c.lft,  
  591.       CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created
  592.       LIMIT 0, 10
  593.  
  594.     EXPLAIN
  595.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  596.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  597.     1   PRIMARY <derived3>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  598.     1   PRIMARY c   const   PRIMARY,idx_access  PRIMARY 4   const   1   USING TEMPORARY; USING filesort
  599.     1   PRIMARY a   REF idx_access,idx_catid    idx_catid   4   const   26398   USING WHERE
  600.     1   PRIMARY fp  eq_ref  PRIMARY PRIMARY 4   m31.a.id    1  
  601.     1   PRIMARY ua  eq_ref  PRIMARY PRIMARY 4   m31.a.created_by    1  
  602.     1   PRIMARY uam eq_ref  PRIMARY PRIMARY 4   m31.a.modified_by   1  
  603.     1   PRIMARY parent  eq_ref  PRIMARY PRIMARY 4   const   1  
  604.     1   PRIMARY v   eq_ref  PRIMARY PRIMARY 4   m31.a.id    1  
  605.     3   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  606.     3   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  607.     2   DERIVED contact REF idx_state   idx_state   1       1   USING WHERE; USING TEMPORARY; USING filesort
  608.     Profile
  609.     STATUS  Duration
  610.     starting    0.0 ms
  611.     Waiting FOR query cache LOCK    0.0 ms
  612.     checking query cache FOR query  0.4 ms
  613.     checking permissions    0.0 ms
  614.     checking permissions    0.0 ms
  615.     checking permissions    0.0 ms
  616.     checking permissions    0.0 ms
  617.     checking permissions    0.0 ms
  618.     checking permissions    0.0 ms
  619.     checking permissions    0.0 ms
  620.     checking permissions    0.0 ms
  621.     checking permissions    0.0 ms
  622.     checking permissions    0.0 ms
  623.     Opening TABLES  0.1 ms
  624.     System LOCK 0.1 ms
  625.     optimizing  0.0 ms
  626.     statistics  0.1 ms
  627.     preparing   0.0 ms
  628.     Creating tmp TABLE  0.0 ms
  629.     executing   0.0 ms
  630.     Copying TO tmp TABLE    0.0 ms
  631.     Sorting RESULT  0.0 ms
  632.     Sending DATA    0.0 ms
  633.     optimizing  0.0 ms
  634.     statistics  0.1 ms
  635.     preparing   0.0 ms
  636.     Creating tmp TABLE  0.0 ms
  637.     executing   0.0 ms
  638.     Copying TO tmp TABLE    0.0 ms
  639.     Sorting RESULT  0.0 ms
  640.     Sending DATA    0.0 ms
  641.     removing tmp TABLE  0.0 ms
  642.     Sending DATA    0.0 ms
  643.     removing tmp TABLE  0.0 ms
  644.     Sending DATA    0.0 ms
  645.     Waiting FOR query cache LOCK    0.0 ms
  646.     Sending DATA    0.1 ms
  647.     init    0.3 ms
  648.     optimizing  0.0 ms
  649.     statistics  0.3 ms
  650.     preparing   0.1 ms
  651.     Creating tmp TABLE  0.5 ms
  652.     executing   0.0 ms
  653.     Copying TO tmp TABLE    3695.0 ms
  654.     Sorting RESULT  1003.9 ms
  655.     Sending DATA    0.5 ms
  656.     END 0.0 ms
  657.     removing tmp TABLE  127.3 ms
  658.     END 0.0 ms
  659.     query END   0.0 ms
  660.     closing TABLES  0.0 ms
  661.     removing tmp TABLE  0.0 ms
  662.     closing TABLES  0.0 ms
  663.     removing tmp TABLE  0.0 ms
  664.     closing TABLES  0.0 ms
  665.     freeing items   0.1 ms
  666.     Waiting FOR query cache LOCK    0.0 ms
  667.     freeing items   0.1 ms
  668.     Waiting FOR query cache LOCK    0.0 ms
  669.     freeing items   0.0 ms
  670.     storing RESULT IN query cache   0.0 ms
  671.     logging slow query  0.0 ms
  672.     cleaning up 0.0 ms
  673.     CALL Stack
  674.     JROOT/libraries/legacy/model/legacy.php:301
  675.     JROOT/libraries/legacy/model/list.php:129
  676.     JROOT/components/com_content/models/articles.php:522
  677.     JROOT/components/com_content/models/category.php:234
  678.     JROOT/libraries/legacy/VIEW/legacy.php:398
  679.     JROOT/components/com_content/views/category/VIEW.html.php:61
  680.     JROOT/libraries/legacy/controller/legacy.php:685
  681.     JROOT/components/com_content/controller.php:79
  682.     JROOT/libraries/legacy/controller/legacy.php:722
  683.     JROOT/components/com_content/content.php:16
  684.     JROOT/libraries/legacy/component/helper.php:355
  685.     JROOT/libraries/legacy/component/helper.php:335
  686.     JROOT/includes/application.php:220
  687.     JROOT/INDEX.php:52
  688.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  689.     Query TIME: 0.19 ms After LAST query: 6.49 ms Query memory: 0.013 MB Memory BEFORE query: 2.397 MB ROWS returned: 1
  690.  
  691.     SELECT extension_id AS id, element AS "option", params, enabled
  692.  
  693.       FROM w0z9v_extensions
  694.  
  695.       WHERE `type` = 'component'
  696.       AND `element` = 'com_tags'
  697.  
  698.     EXPLAIN
  699.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  700.     1   SIMPLE  w0z9v_extensions    REF element_clientid,element_folder_clientid,extension  element_clientid    302 const   1   USING WHERE
  701.     Profile
  702.     STATUS  Duration
  703.     starting    0.0 ms
  704.     Waiting FOR query cache LOCK    0.0 ms
  705.     checking query cache FOR query  0.0 ms
  706.     checking privileges ON cached   0.0 ms
  707.     checking permissions    0.0 ms
  708.     sending cached RESULT TO clien  0.0 ms
  709.     logging slow query  0.0 ms
  710.     cleaning up 0.0 ms
  711.     CALL Stack
  712.     JROOT/libraries/joomla/cache/controller/callback.php:158
  713.     JROOT/libraries/legacy/component/helper.php:384
  714.     JROOT/libraries/legacy/component/helper.php:43
  715.     JROOT/libraries/legacy/component/helper.php:91
  716.     JROOT/libraries/cms/helper/tags.php:392
  717.     JROOT/components/com_content/models/articles.php:648
  718.     JROOT/components/com_content/models/category.php:234
  719.     JROOT/libraries/legacy/VIEW/legacy.php:398
  720.     JROOT/components/com_content/views/category/VIEW.html.php:61
  721.     JROOT/libraries/legacy/controller/legacy.php:685
  722.     JROOT/components/com_content/controller.php:79
  723.     JROOT/libraries/legacy/controller/legacy.php:722
  724.     JROOT/components/com_content/content.php:16
  725.     JROOT/libraries/legacy/component/helper.php:355
  726.     JROOT/libraries/legacy/component/helper.php:335
  727.     JROOT/includes/application.php:220
  728.     JROOT/INDEX.php:52
  729.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  730.     Query TIME: 0.16 ms After LAST query: 0.97 ms Query memory: 0.010 MB Memory BEFORE query: 2.397 MB ROWS returned: 0
  731.  
  732.     SELECT `m`.`tag_id`,`t`.*
  733.  
  734.       FROM `w0z9v_contentitem_tag_map` AS m
  735.  
  736.       INNER JOIN `w0z9v_tags` AS t  
  737.       ON `m`.`tag_id` = `t`.`id`
  738.  
  739.       WHERE `m`.`type_alias` = 'com_content.article'
  740.       AND `m`.`content_item_id` = 5913
  741.       AND `t`.`published` = 1
  742.       AND t.access IN (1,1,5)
  743.  
  744.     EXPLAIN
  745.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  746.     1   SIMPLE  t   ALL PRIMARY,tag_idx,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    35  USING WHERE
  747.     1   SIMPLE  m   REF idx_tag_type,idx_tag    idx_tag_type    4   m31.t.id    109 USING WHERE
  748.     Profile
  749.     STATUS  Duration
  750.     starting    0.0 ms
  751.     Waiting FOR query cache LOCK    0.0 ms
  752.     checking query cache FOR query  0.0 ms
  753.     checking privileges ON cached   0.0 ms
  754.     checking permissions    0.0 ms
  755.     checking permissions    0.0 ms
  756.     sending cached RESULT TO clien  0.0 ms
  757.     logging slow query  0.0 ms
  758.     cleaning up 0.0 ms
  759.     CALL Stack
  760.     JROOT/libraries/cms/helper/tags.php:411
  761.     JROOT/components/com_content/models/articles.php:648
  762.     JROOT/components/com_content/models/category.php:234
  763.     JROOT/libraries/legacy/VIEW/legacy.php:398
  764.     JROOT/components/com_content/views/category/VIEW.html.php:61
  765.     JROOT/libraries/legacy/controller/legacy.php:685
  766.     JROOT/components/com_content/controller.php:79
  767.     JROOT/libraries/legacy/controller/legacy.php:722
  768.     JROOT/components/com_content/content.php:16
  769.     JROOT/libraries/legacy/component/helper.php:355
  770.     JROOT/libraries/legacy/component/helper.php:335
  771.     JROOT/includes/application.php:220
  772.     JROOT/INDEX.php:52
  773.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  774.     Query TIME: 0.18 ms After LAST query: 1.50 ms Query memory: 0.010 MB Memory BEFORE query: 2.417 MB ROWS returned: 0
  775.  
  776.     SELECT `m`.`tag_id`,`t`.*
  777.  
  778.       FROM `w0z9v_contentitem_tag_map` AS m
  779.  
  780.       INNER JOIN `w0z9v_tags` AS t  
  781.       ON `m`.`tag_id` = `t`.`id`
  782.  
  783.       WHERE `m`.`type_alias` = 'com_content.article'
  784.       AND `m`.`content_item_id` = 9170
  785.       AND `t`.`published` = 1
  786.       AND t.access IN (1,1,5)
  787.  
  788.     EXPLAIN
  789.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  790.     1   SIMPLE  t   ALL PRIMARY,tag_idx,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    35  USING WHERE
  791.     1   SIMPLE  m   REF idx_tag_type,idx_tag    idx_tag_type    4   m31.t.id    109 USING WHERE
  792.     Profile
  793.     STATUS  Duration
  794.     starting    0.0 ms
  795.     Waiting FOR query cache LOCK    0.0 ms
  796.     checking query cache FOR query  0.0 ms
  797.     checking privileges ON cached   0.0 ms
  798.     checking permissions    0.0 ms
  799.     checking permissions    0.0 ms
  800.     sending cached RESULT TO clien  0.0 ms
  801.     logging slow query  0.0 ms
  802.     cleaning up 0.0 ms
  803.     CALL Stack
  804.     JROOT/libraries/cms/helper/tags.php:411
  805.     JROOT/components/com_content/models/articles.php:648
  806.     JROOT/components/com_content/models/category.php:234
  807.     JROOT/libraries/legacy/VIEW/legacy.php:398
  808.     JROOT/components/com_content/views/category/VIEW.html.php:61
  809.     JROOT/libraries/legacy/controller/legacy.php:685
  810.     JROOT/components/com_content/controller.php:79
  811.     JROOT/libraries/legacy/controller/legacy.php:722
  812.     JROOT/components/com_content/content.php:16
  813.     JROOT/libraries/legacy/component/helper.php:355
  814.     JROOT/libraries/legacy/component/helper.php:335
  815.     JROOT/includes/application.php:220
  816.     JROOT/INDEX.php:52
  817.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  818.     Query TIME: 0.19 ms After LAST query: 1.46 ms Query memory: 0.010 MB Memory BEFORE query: 2.437 MB ROWS returned: 0
  819.  
  820.     SELECT `m`.`tag_id`,`t`.*
  821.  
  822.       FROM `w0z9v_contentitem_tag_map` AS m
  823.  
  824.       INNER JOIN `w0z9v_tags` AS t  
  825.       ON `m`.`tag_id` = `t`.`id`
  826.  
  827.       WHERE `m`.`type_alias` = 'com_content.article'
  828.       AND `m`.`content_item_id` = 9169
  829.       AND `t`.`published` = 1
  830.       AND t.access IN (1,1,5)
  831.  
  832.     EXPLAIN
  833.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  834.     1   SIMPLE  t   ALL PRIMARY,tag_idx,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    35  USING WHERE
  835.     1   SIMPLE  m   REF idx_tag_type,idx_tag    idx_tag_type    4   m31.t.id    109 USING WHERE
  836.     Profile
  837.     STATUS  Duration
  838.     starting    0.0 ms
  839.     Waiting FOR query cache LOCK    0.0 ms
  840.     checking query cache FOR query  0.0 ms
  841.     checking privileges ON cached   0.0 ms
  842.     checking permissions    0.0 ms
  843.     checking permissions    0.0 ms
  844.     sending cached RESULT TO clien  0.0 ms
  845.     logging slow query  0.0 ms
  846.     cleaning up 0.0 ms
  847.     CALL Stack
  848.     JROOT/libraries/cms/helper/tags.php:411
  849.     JROOT/components/com_content/models/articles.php:648
  850.     JROOT/components/com_content/models/category.php:234
  851.     JROOT/libraries/legacy/VIEW/legacy.php:398
  852.     JROOT/components/com_content/views/category/VIEW.html.php:61
  853.     JROOT/libraries/legacy/controller/legacy.php:685
  854.     JROOT/components/com_content/controller.php:79
  855.     JROOT/libraries/legacy/controller/legacy.php:722
  856.     JROOT/components/com_content/content.php:16
  857.     JROOT/libraries/legacy/component/helper.php:355
  858.     JROOT/libraries/legacy/component/helper.php:335
  859.     JROOT/includes/application.php:220
  860.     JROOT/INDEX.php:52
  861.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  862.     Query TIME: 0.19 ms After LAST query: 1.46 ms Query memory: 0.010 MB Memory BEFORE query: 2.458 MB ROWS returned: 0
  863.  
  864.     SELECT `m`.`tag_id`,`t`.*
  865.  
  866.       FROM `w0z9v_contentitem_tag_map` AS m
  867.  
  868.       INNER JOIN `w0z9v_tags` AS t  
  869.       ON `m`.`tag_id` = `t`.`id`
  870.  
  871.       WHERE `m`.`type_alias` = 'com_content.article'
  872.       AND `m`.`content_item_id` = 9168
  873.       AND `t`.`published` = 1
  874.       AND t.access IN (1,1,5)
  875.  
  876.     EXPLAIN
  877.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  878.     1   SIMPLE  t   ALL PRIMARY,tag_idx,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    35  USING WHERE
  879.     1   SIMPLE  m   REF idx_tag_type,idx_tag    idx_tag_type    4   m31.t.id    109 USING WHERE
  880.     Profile
  881.     STATUS  Duration
  882.     starting    0.0 ms
  883.     Waiting FOR query cache LOCK    0.0 ms
  884.     checking query cache FOR query  0.0 ms
  885.     checking privileges ON cached   0.0 ms
  886.     checking permissions    0.0 ms
  887.     checking permissions    0.0 ms
  888.     sending cached RESULT TO clien  0.0 ms
  889.     logging slow query  0.0 ms
  890.     cleaning up 0.0 ms
  891.     CALL Stack
  892.     JROOT/libraries/cms/helper/tags.php:411
  893.     JROOT/components/com_content/models/articles.php:648
  894.     JROOT/components/com_content/models/category.php:234
  895.     JROOT/libraries/legacy/VIEW/legacy.php:398
  896.     JROOT/components/com_content/views/category/VIEW.html.php:61
  897.     JROOT/libraries/legacy/controller/legacy.php:685
  898.     JROOT/components/com_content/controller.php:79
  899.     JROOT/libraries/legacy/controller/legacy.php:722
  900.     JROOT/components/com_content/content.php:16
  901.     JROOT/libraries/legacy/component/helper.php:355
  902.     JROOT/libraries/legacy/component/helper.php:335
  903.     JROOT/includes/application.php:220
  904.     JROOT/INDEX.php:52
  905.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  906.     Query TIME: 0.18 ms After LAST query: 1.46 ms Query memory: 0.010 MB Memory BEFORE query: 2.478 MB ROWS returned: 1
  907.  
  908.     SELECT `m`.`tag_id`,`t`.*
  909.  
  910.       FROM `w0z9v_contentitem_tag_map` AS m
  911.  
  912.       INNER JOIN `w0z9v_tags` AS t  
  913.       ON `m`.`tag_id` = `t`.`id`
  914.  
  915.       WHERE `m`.`type_alias` = 'com_content.article'
  916.       AND `m`.`content_item_id` = 9167
  917.       AND `t`.`published` = 1
  918.       AND t.access IN (1,1,5)
  919.  
  920.     EXPLAIN
  921.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  922.     1   SIMPLE  t   ALL PRIMARY,tag_idx,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    35  USING WHERE
  923.     1   SIMPLE  m   REF idx_tag_type,idx_tag    idx_tag_type    4   m31.t.id    109 USING WHERE
  924.     Profile
  925.     STATUS  Duration
  926.     starting    0.0 ms
  927.     Waiting FOR query cache LOCK    0.0 ms
  928.     checking query cache FOR query  0.0 ms
  929.     checking privileges ON cached   0.0 ms
  930.     checking permissions    0.0 ms
  931.     checking permissions    0.0 ms
  932.     sending cached RESULT TO clien  0.0 ms
  933.     logging slow query  0.0 ms
  934.     cleaning up 0.0 ms
  935.     CALL Stack
  936.     JROOT/libraries/cms/helper/tags.php:411
  937.     JROOT/components/com_content/models/articles.php:648
  938.     JROOT/components/com_content/models/category.php:234
  939.     JROOT/libraries/legacy/VIEW/legacy.php:398
  940.     JROOT/components/com_content/views/category/VIEW.html.php:61
  941.     JROOT/libraries/legacy/controller/legacy.php:685
  942.     JROOT/components/com_content/controller.php:79
  943.     JROOT/libraries/legacy/controller/legacy.php:722
  944.     JROOT/components/com_content/content.php:16
  945.     JROOT/libraries/legacy/component/helper.php:355
  946.     JROOT/libraries/legacy/component/helper.php:335
  947.     JROOT/includes/application.php:220
  948.     JROOT/INDEX.php:52
  949.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  950.     Query TIME: 0.19 ms After LAST query: 1.49 ms Query memory: 0.010 MB Memory BEFORE query: 2.501 MB ROWS returned: 0
  951.  
  952.     SELECT `m`.`tag_id`,`t`.*
  953.  
  954.       FROM `w0z9v_contentitem_tag_map` AS m
  955.  
  956.       INNER JOIN `w0z9v_tags` AS t  
  957.       ON `m`.`tag_id` = `t`.`id`
  958.  
  959.       WHERE `m`.`type_alias` = 'com_content.article'
  960.       AND `m`.`content_item_id` = 9166
  961.       AND `t`.`published` = 1
  962.       AND t.access IN (1,1,5)
  963.  
  964.     EXPLAIN
  965.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  966.     1   SIMPLE  t   ALL PRIMARY,tag_idx,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    35  USING WHERE
  967.     1   SIMPLE  m   REF idx_tag_type,idx_tag    idx_tag_type    4   m31.t.id    109 USING WHERE
  968.     Profile
  969.     STATUS  Duration
  970.     starting    0.0 ms
  971.     Waiting FOR query cache LOCK    0.0 ms
  972.     checking query cache FOR query  0.0 ms
  973.     checking privileges ON cached   0.0 ms
  974.     checking permissions    0.0 ms
  975.     checking permissions    0.0 ms
  976.     sending cached RESULT TO clien  0.0 ms
  977.     logging slow query  0.0 ms
  978.     cleaning up 0.0 ms
  979.     CALL Stack
  980.     JROOT/libraries/cms/helper/tags.php:411
  981.     JROOT/components/com_content/models/articles.php:648
  982.     JROOT/components/com_content/models/category.php:234
  983.     JROOT/libraries/legacy/VIEW/legacy.php:398
  984.     JROOT/components/com_content/views/category/VIEW.html.php:61
  985.     JROOT/libraries/legacy/controller/legacy.php:685
  986.     JROOT/components/com_content/controller.php:79
  987.     JROOT/libraries/legacy/controller/legacy.php:722
  988.     JROOT/components/com_content/content.php:16
  989.     JROOT/libraries/legacy/component/helper.php:355
  990.     JROOT/libraries/legacy/component/helper.php:335
  991.     JROOT/includes/application.php:220
  992.     JROOT/INDEX.php:52
  993.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  994.     Query TIME: 0.18 ms After LAST query: 1.51 ms Query memory: 0.010 MB Memory BEFORE query: 2.521 MB ROWS returned: 0
  995.  
  996.     SELECT `m`.`tag_id`,`t`.*
  997.  
  998.       FROM `w0z9v_contentitem_tag_map` AS m
  999.  
  1000.       INNER JOIN `w0z9v_tags` AS t  
  1001.       ON `m`.`tag_id` = `t`.`id`
  1002.  
  1003.       WHERE `m`.`type_alias` = 'com_content.article'
  1004.       AND `m`.`content_item_id` = 9165
  1005.       AND `t`.`published` = 1
  1006.       AND t.access IN (1,1,5)
  1007.  
  1008.     EXPLAIN
  1009.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1010.     1   SIMPLE  t   ALL PRIMARY,tag_idx,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    35  USING WHERE
  1011.     1   SIMPLE  m   REF idx_tag_type,idx_tag    idx_tag_type    4   m31.t.id    109 USING WHERE
  1012.     Profile
  1013.     STATUS  Duration
  1014.     starting    0.0 ms
  1015.     Waiting FOR query cache LOCK    0.0 ms
  1016.     checking query cache FOR query  0.0 ms
  1017.     checking privileges ON cached   0.0 ms
  1018.     checking permissions    0.0 ms
  1019.     checking permissions    0.0 ms
  1020.     sending cached RESULT TO clien  0.0 ms
  1021.     logging slow query  0.0 ms
  1022.     cleaning up 0.0 ms
  1023.     CALL Stack
  1024.     JROOT/libraries/cms/helper/tags.php:411
  1025.     JROOT/components/com_content/models/articles.php:648
  1026.     JROOT/components/com_content/models/category.php:234
  1027.     JROOT/libraries/legacy/VIEW/legacy.php:398
  1028.     JROOT/components/com_content/views/category/VIEW.html.php:61
  1029.     JROOT/libraries/legacy/controller/legacy.php:685
  1030.     JROOT/components/com_content/controller.php:79
  1031.     JROOT/libraries/legacy/controller/legacy.php:722
  1032.     JROOT/components/com_content/content.php:16
  1033.     JROOT/libraries/legacy/component/helper.php:355
  1034.     JROOT/libraries/legacy/component/helper.php:335
  1035.     JROOT/includes/application.php:220
  1036.     JROOT/INDEX.php:52
  1037.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1038.     Query TIME: 0.18 ms After LAST query: 1.47 ms Query memory: 0.010 MB Memory BEFORE query: 2.542 MB ROWS returned: 0
  1039.  
  1040.     SELECT `m`.`tag_id`,`t`.*
  1041.  
  1042.       FROM `w0z9v_contentitem_tag_map` AS m
  1043.  
  1044.       INNER JOIN `w0z9v_tags` AS t  
  1045.       ON `m`.`tag_id` = `t`.`id`
  1046.  
  1047.       WHERE `m`.`type_alias` = 'com_content.article'
  1048.       AND `m`.`content_item_id` = 9164
  1049.       AND `t`.`published` = 1
  1050.       AND t.access IN (1,1,5)
  1051.  
  1052.     EXPLAIN
  1053.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1054.     1   SIMPLE  t   ALL PRIMARY,tag_idx,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    35  USING WHERE
  1055.     1   SIMPLE  m   REF idx_tag_type,idx_tag    idx_tag_type    4   m31.t.id    109 USING WHERE
  1056.     Profile
  1057.     STATUS  Duration
  1058.     starting    0.0 ms
  1059.     Waiting FOR query cache LOCK    0.0 ms
  1060.     checking query cache FOR query  0.0 ms
  1061.     checking privileges ON cached   0.0 ms
  1062.     checking permissions    0.0 ms
  1063.     checking permissions    0.0 ms
  1064.     sending cached RESULT TO clien  0.0 ms
  1065.     logging slow query  0.0 ms
  1066.     cleaning up 0.0 ms
  1067.     CALL Stack
  1068.     JROOT/libraries/cms/helper/tags.php:411
  1069.     JROOT/components/com_content/models/articles.php:648
  1070.     JROOT/components/com_content/models/category.php:234
  1071.     JROOT/libraries/legacy/VIEW/legacy.php:398
  1072.     JROOT/components/com_content/views/category/VIEW.html.php:61
  1073.     JROOT/libraries/legacy/controller/legacy.php:685
  1074.     JROOT/components/com_content/controller.php:79
  1075.     JROOT/libraries/legacy/controller/legacy.php:722
  1076.     JROOT/components/com_content/content.php:16
  1077.     JROOT/libraries/legacy/component/helper.php:355
  1078.     JROOT/libraries/legacy/component/helper.php:335
  1079.     JROOT/includes/application.php:220
  1080.     JROOT/INDEX.php:52
  1081.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1082.     Query TIME: 0.17 ms After LAST query: 1.51 ms Query memory: 0.010 MB Memory BEFORE query: 2.562 MB ROWS returned: 0
  1083.  
  1084.     SELECT `m`.`tag_id`,`t`.*
  1085.  
  1086.       FROM `w0z9v_contentitem_tag_map` AS m
  1087.  
  1088.       INNER JOIN `w0z9v_tags` AS t  
  1089.       ON `m`.`tag_id` = `t`.`id`
  1090.  
  1091.       WHERE `m`.`type_alias` = 'com_content.article'
  1092.       AND `m`.`content_item_id` = 9163
  1093.       AND `t`.`published` = 1
  1094.       AND t.access IN (1,1,5)
  1095.  
  1096.     EXPLAIN
  1097.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1098.     1   SIMPLE  t   ALL PRIMARY,tag_idx,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    35  USING WHERE
  1099.     1   SIMPLE  m   REF idx_tag_type,idx_tag    idx_tag_type    4   m31.t.id    109 USING WHERE
  1100.     Profile
  1101.     STATUS  Duration
  1102.     starting    0.0 ms
  1103.     Waiting FOR query cache LOCK    0.0 ms
  1104.     checking query cache FOR query  0.0 ms
  1105.     checking privileges ON cached   0.0 ms
  1106.     checking permissions    0.0 ms
  1107.     checking permissions    0.0 ms
  1108.     sending cached RESULT TO clien  0.0 ms
  1109.     logging slow query  0.0 ms
  1110.     cleaning up 0.0 ms
  1111.     CALL Stack
  1112.     JROOT/libraries/cms/helper/tags.php:411
  1113.     JROOT/components/com_content/models/articles.php:648
  1114.     JROOT/components/com_content/models/category.php:234
  1115.     JROOT/libraries/legacy/VIEW/legacy.php:398
  1116.     JROOT/components/com_content/views/category/VIEW.html.php:61
  1117.     JROOT/libraries/legacy/controller/legacy.php:685
  1118.     JROOT/components/com_content/controller.php:79
  1119.     JROOT/libraries/legacy/controller/legacy.php:722
  1120.     JROOT/components/com_content/content.php:16
  1121.     JROOT/libraries/legacy/component/helper.php:355
  1122.     JROOT/libraries/legacy/component/helper.php:335
  1123.     JROOT/includes/application.php:220
  1124.     JROOT/INDEX.php:52
  1125.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1126.     Query TIME: 0.19 ms After LAST query: 1.46 ms Query memory: 0.010 MB Memory BEFORE query: 2.582 MB ROWS returned: 0
  1127.  
  1128.     SELECT `m`.`tag_id`,`t`.*
  1129.  
  1130.       FROM `w0z9v_contentitem_tag_map` AS m
  1131.  
  1132.       INNER JOIN `w0z9v_tags` AS t  
  1133.       ON `m`.`tag_id` = `t`.`id`
  1134.  
  1135.       WHERE `m`.`type_alias` = 'com_content.article'
  1136.       AND `m`.`content_item_id` = 9162
  1137.       AND `t`.`published` = 1
  1138.       AND t.access IN (1,1,5)
  1139.  
  1140.     EXPLAIN
  1141.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1142.     1   SIMPLE  t   ALL PRIMARY,tag_idx,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    35  USING WHERE
  1143.     1   SIMPLE  m   REF idx_tag_type,idx_tag    idx_tag_type    4   m31.t.id    109 USING WHERE
  1144.     Profile
  1145.     STATUS  Duration
  1146.     starting    0.0 ms
  1147.     Waiting FOR query cache LOCK    0.0 ms
  1148.     checking query cache FOR query  0.0 ms
  1149.     checking privileges ON cached   0.0 ms
  1150.     checking permissions    0.0 ms
  1151.     checking permissions    0.0 ms
  1152.     sending cached RESULT TO clien  0.0 ms
  1153.     logging slow query  0.0 ms
  1154.     cleaning up 0.0 ms
  1155.     CALL Stack
  1156.     JROOT/libraries/cms/helper/tags.php:411
  1157.     JROOT/components/com_content/models/articles.php:648
  1158.     JROOT/components/com_content/models/category.php:234
  1159.     JROOT/libraries/legacy/VIEW/legacy.php:398
  1160.     JROOT/components/com_content/views/category/VIEW.html.php:61
  1161.     JROOT/libraries/legacy/controller/legacy.php:685
  1162.     JROOT/components/com_content/controller.php:79
  1163.     JROOT/libraries/legacy/controller/legacy.php:722
  1164.     JROOT/components/com_content/content.php:16
  1165.     JROOT/libraries/legacy/component/helper.php:355
  1166.     JROOT/libraries/legacy/component/helper.php:335
  1167.     JROOT/includes/application.php:220
  1168.     JROOT/INDEX.php:52
  1169.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1170.     Query TIME: 4578.82 ms After LAST query: 3.52 ms Query memory: 0.011 MB Memory BEFORE query: 2.695 MB
  1171.  
  1172.     SELECT COUNT(*)
  1173.  
  1174.       FROM w0z9v_content AS a
  1175.  
  1176.       LEFT JOIN w0z9v_content_frontpage AS fp
  1177.       ON fp.content_id = a.id
  1178.  
  1179.       LEFT JOIN w0z9v_categories AS c
  1180.       ON c.id = a.catid
  1181.  
  1182.       LEFT JOIN w0z9v_users AS ua
  1183.       ON ua.id = a.created_by
  1184.  
  1185.       LEFT JOIN w0z9v_users AS uam
  1186.       ON uam.id = a.modified_by
  1187.  
  1188.       LEFT JOIN (
  1189.     SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  1190.  
  1191.       FROM w0z9v_contact_details AS contact
  1192.  
  1193.       WHERE contact.published = 1
  1194.  
  1195.       GROUP BY contact.user_id, contact.LANGUAGE) AS contact
  1196.       ON contact.user_id = a.created_by
  1197.  
  1198.       LEFT JOIN w0z9v_categories AS parent
  1199.       ON parent.id = c.parent_id
  1200.  
  1201.       LEFT JOIN w0z9v_content_rating AS v
  1202.       ON a.id = v.content_id
  1203.  
  1204.       LEFT
  1205.       OUTER JOIN (SELECT cat.id AS id
  1206.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  1207.       ON cat.lft BETWEEN parent.lft
  1208.       AND parent.rgt
  1209.       WHERE parent.extension = 'com_content'
  1210.       AND parent.published != 1
  1211.       GROUP BY cat.id ) AS badcats
  1212.       ON badcats.id = c.id
  1213.  
  1214.       WHERE a.access IN (1,1,5)
  1215.       AND c.access IN (1,1,5)
  1216.       AND
  1217.       CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END = 1
  1218.       AND a.catid = 8
  1219.       AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-11 13:35:12')
  1220.       AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-11 13:35:12')
  1221.  
  1222.       GROUP BY a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
  1223.  
  1224.     EXPLAIN
  1225.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1226.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  1227.     1   PRIMARY <derived3>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  1228.     1   PRIMARY c   const   PRIMARY,idx_access  PRIMARY 4   const   1   USING TEMPORARY; USING filesort
  1229.     1   PRIMARY a   REF idx_access,idx_catid    idx_catid   4   const   26398   USING WHERE
  1230.     1   PRIMARY fp  eq_ref  PRIMARY PRIMARY 4   m31.a.id    1  
  1231.     1   PRIMARY ua  eq_ref  PRIMARY PRIMARY 4   m31.a.created_by    1  
  1232.     1   PRIMARY uam eq_ref  PRIMARY PRIMARY 4   m31.a.modified_by   1  
  1233.     1   PRIMARY parent  eq_ref  PRIMARY PRIMARY 4   const   1  
  1234.     1   PRIMARY v   eq_ref  PRIMARY PRIMARY 4   m31.a.id    1  
  1235.     3   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  1236.     3   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  1237.     2   DERIVED contact REF idx_state   idx_state   1       1   USING WHERE; USING TEMPORARY; USING filesort
  1238.     Profile
  1239.     STATUS  Duration
  1240.     starting    0.0 ms
  1241.     Waiting FOR query cache LOCK    0.0 ms
  1242.     checking query cache FOR query  0.3 ms
  1243.     checking permissions    0.0 ms
  1244.     checking permissions    0.0 ms
  1245.     checking permissions    0.0 ms
  1246.     checking permissions    0.0 ms
  1247.     checking permissions    0.0 ms
  1248.     checking permissions    0.0 ms
  1249.     checking permissions    0.0 ms
  1250.     checking permissions    0.0 ms
  1251.     checking permissions    0.0 ms
  1252.     checking permissions    0.0 ms
  1253.     Opening TABLES  0.1 ms
  1254.     System LOCK 0.1 ms
  1255.     optimizing  0.0 ms
  1256.     statistics  0.1 ms
  1257.     preparing   0.0 ms
  1258.     Creating tmp TABLE  0.0 ms
  1259.     executing   0.0 ms
  1260.     Copying TO tmp TABLE    0.0 ms
  1261.     Sorting RESULT  0.0 ms
  1262.     Sending DATA    0.0 ms
  1263.     optimizing  0.0 ms
  1264.     statistics  0.1 ms
  1265.     preparing   0.0 ms
  1266.     Creating tmp TABLE  0.0 ms
  1267.     executing   0.0 ms
  1268.     Copying TO tmp TABLE    0.0 ms
  1269.     Sorting RESULT  0.0 ms
  1270.     Sending DATA    0.0 ms
  1271.     removing tmp TABLE  0.0 ms
  1272.     Sending DATA    0.0 ms
  1273.     removing tmp TABLE  0.0 ms
  1274.     Sending DATA    0.0 ms
  1275.     Waiting FOR query cache LOCK    0.0 ms
  1276.     Sending DATA    0.1 ms
  1277.     init    0.1 ms
  1278.     optimizing  0.0 ms
  1279.     statistics  0.3 ms
  1280.     preparing   0.1 ms
  1281.     Creating tmp TABLE  0.5 ms
  1282.     executing   0.0 ms
  1283.     Copying TO tmp TABLE    3638.8 ms
  1284.     Sorting RESULT  783.6 ms
  1285.     Waiting FOR query cache LOCK    0.0 ms
  1286.     Sorting RESULT  0.0 ms
  1287.     storing RESULT IN query cache   16.1 ms
  1288.     END 0.0 ms
  1289.     removing tmp TABLE  137.9 ms
  1290.     END 0.0 ms
  1291.     query END   0.0 ms
  1292.     closing TABLES  0.0 ms
  1293.     removing tmp TABLE  0.0 ms
  1294.     closing TABLES  0.0 ms
  1295.     removing tmp TABLE  0.0 ms
  1296.     closing TABLES  0.0 ms
  1297.     freeing items   0.1 ms
  1298.     logging slow query  0.0 ms
  1299.     cleaning up 0.0 ms
  1300.     CALL Stack
  1301.     JROOT/libraries/legacy/model/legacy.php:324
  1302.     JROOT/libraries/legacy/model/list.php:232
  1303.     JROOT/libraries/legacy/model/list.php:178
  1304.     JROOT/components/com_content/models/category.php:246
  1305.     JROOT/libraries/legacy/VIEW/legacy.php:398
  1306.     JROOT/components/com_content/views/category/VIEW.html.php:61
  1307.     JROOT/libraries/legacy/controller/legacy.php:685
  1308.     JROOT/components/com_content/controller.php:79
  1309.     JROOT/libraries/legacy/controller/legacy.php:722
  1310.     JROOT/components/com_content/content.php:16
  1311.     JROOT/libraries/legacy/component/helper.php:355
  1312.     JROOT/libraries/legacy/component/helper.php:335
  1313.     JROOT/includes/application.php:220
  1314.     JROOT/INDEX.php:52
  1315.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1316.     Query TIME: 53.22 ms After LAST query: 13.77 ms Query memory: 0.007 MB Memory BEFORE query: 2.919 MB
  1317.  
  1318.     UPDATE w0z9v_categories
  1319.  
  1320.       SET hits = hits + 1
  1321.  
  1322.       WHERE id = 8
  1323.  
  1324.     EXPLAIN
  1325.     EXPLAIN NOT possible ON query: UPDATE w0z9v_categories SET hits = hits + 1 WHERE id = 8
  1326.     Profile
  1327.     STATUS  Duration
  1328.     starting    0.1 ms
  1329.     checking permissions    0.0 ms
  1330.     Opening TABLES  0.0 ms
  1331.     System LOCK 0.0 ms
  1332.     init    0.1 ms
  1333.     Updating    0.1 ms
  1334.     END 0.0 ms
  1335.     Waiting FOR query cache LOCK    0.0 ms
  1336.     END 0.1 ms
  1337.     query END   52.6 ms
  1338.     closing TABLES  0.0 ms
  1339.     freeing items   0.0 ms
  1340.     logging slow query  0.0 ms
  1341.     cleaning up 0.0 ms
  1342.     CALL Stack
  1343.     JROOT/components/com_content/models/category.php:461
  1344.     JROOT/components/com_content/views/category/VIEW.html.php:205
  1345.     JROOT/libraries/legacy/controller/legacy.php:685
  1346.     JROOT/components/com_content/controller.php:79
  1347.     JROOT/libraries/legacy/controller/legacy.php:722
  1348.     JROOT/components/com_content/content.php:16
  1349.     JROOT/libraries/legacy/component/helper.php:355
  1350.     JROOT/libraries/legacy/component/helper.php:335
  1351.     JROOT/includes/application.php:220
  1352.     JROOT/INDEX.php:52
  1353.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1354.     Query TIME: 0.29 ms After LAST query: 1.03 ms Query memory: 0.008 MB Memory BEFORE query: 2.929 MB ROWS returned: 0
  1355.  
  1356.     SELECT `m`.`tag_id`,`t`.*
  1357.  
  1358.       FROM `w0z9v_contentitem_tag_map` AS m
  1359.  
  1360.       INNER JOIN `w0z9v_tags` AS t  
  1361.       ON `m`.`tag_id` = `t`.`id`
  1362.  
  1363.       WHERE `m`.`type_alias` = 'com_content.category'
  1364.       AND `m`.`content_item_id` = 8
  1365.       AND `t`.`published` = 1
  1366.       AND t.access IN (1,1,5)
  1367.  
  1368.     EXPLAIN
  1369.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1370.     1   SIMPLE  t   ALL PRIMARY,tag_idx,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    35  USING WHERE
  1371.     1   SIMPLE  m   REF idx_tag_type,idx_tag    idx_tag_type    4   m31.t.id    109 USING WHERE
  1372.     Profile
  1373.     STATUS  Duration
  1374.     starting    0.0 ms
  1375.     Waiting FOR query cache LOCK    0.0 ms
  1376.     checking query cache FOR query  0.0 ms
  1377.     checking privileges ON cached   0.0 ms
  1378.     checking permissions    0.0 ms
  1379.     checking permissions    0.0 ms
  1380.     sending cached RESULT TO clien  0.0 ms
  1381.     logging slow query  0.0 ms
  1382.     cleaning up 0.0 ms
  1383.     CALL Stack
  1384.     JROOT/libraries/cms/helper/tags.php:411
  1385.     JROOT/components/com_content/views/category/VIEW.html.php:208
  1386.     JROOT/libraries/legacy/controller/legacy.php:685
  1387.     JROOT/components/com_content/controller.php:79
  1388.     JROOT/libraries/legacy/controller/legacy.php:722
  1389.     JROOT/components/com_content/content.php:16
  1390.     JROOT/libraries/legacy/component/helper.php:355
  1391.     JROOT/libraries/legacy/component/helper.php:335
  1392.     JROOT/includes/application.php:220
  1393.     JROOT/INDEX.php:52
  1394.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1395.     Query TIME: 1.94 ms After LAST query: 21.25 ms Query memory: 0.015 MB Memory BEFORE query: 3.333 MB ROWS returned: 3
  1396.     Duplicate queries: #11
  1397.  
  1398.     SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  1399.                 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  1400.                 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  1401.                 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
  1402.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
  1403.  
  1404.       FROM w0z9v_categories AS c
  1405.  
  1406.       LEFT JOIN w0z9v_categories AS s
  1407.       ON (s.lft <= c.lft
  1408.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  1409.       AND s.rgt < c.rgt)
  1410.  
  1411.       LEFT JOIN  (SELECT cat.id AS id
  1412.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  1413.       ON cat.lft BETWEEN parent.lft
  1414.       AND parent.rgt
  1415.       WHERE parent.extension = 'com_content'
  1416.       AND parent.published != 1
  1417.       GROUP BY cat.id) AS badcats
  1418.       ON badcats.id = c.id
  1419.  
  1420.       WHERE (c.extension='com_content' OR c.extension='system')
  1421.       AND c.access IN (1,1,5)
  1422.       AND c.published = 1
  1423.       AND s.id=8
  1424.       AND badcats.id IS NULL
  1425.  
  1426.       GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  1427.                  c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  1428.                  c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  1429.                  c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
  1430.  
  1431.       ORDER BY c.lft
  1432.  
  1433.     EXPLAIN
  1434.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1435.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  1436.     1   PRIMARY s   const   PRIMARY,idx_left_right  PRIMARY 4   const   1   USING filesort
  1437.     1   PRIMARY c   ALL cat_idx,idx_access,idx_left_right   NO INDEX KEY COULD BE USED  NULL    NULL    13  USING WHERE
  1438.     2   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  1439.     2   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  1440.     Profile
  1441.     STATUS  Duration
  1442.     starting    0.0 ms
  1443.     Waiting FOR query cache LOCK    0.0 ms
  1444.     checking query cache FOR query  0.3 ms
  1445.     checking permissions    0.0 ms
  1446.     checking permissions    0.0 ms
  1447.     checking permissions    0.0 ms
  1448.     checking permissions    0.0 ms
  1449.     Opening TABLES  0.0 ms
  1450.     System LOCK 0.1 ms
  1451.     optimizing  0.0 ms
  1452.     statistics  0.1 ms
  1453.     preparing   0.0 ms
  1454.     Creating tmp TABLE  0.0 ms
  1455.     executing   0.0 ms
  1456.     Copying TO tmp TABLE    0.1 ms
  1457.     Sorting RESULT  0.0 ms
  1458.     Sending DATA    0.0 ms
  1459.     removing tmp TABLE  0.0 ms
  1460.     Sending DATA    0.0 ms
  1461.     Waiting FOR query cache LOCK    0.0 ms
  1462.     Sending DATA    0.1 ms
  1463.     init    0.2 ms
  1464.     optimizing  0.0 ms
  1465.     statistics  0.2 ms
  1466.     preparing   0.0 ms
  1467.     executing   0.0 ms
  1468.     Sorting RESULT  0.1 ms
  1469.     Sending DATA    0.1 ms
  1470.     END 0.0 ms
  1471.     query END   0.0 ms
  1472.     closing TABLES  0.0 ms
  1473.     removing tmp TABLE  0.0 ms
  1474.     closing TABLES  0.0 ms
  1475.     freeing items   0.0 ms
  1476.     Waiting FOR query cache LOCK    0.0 ms
  1477.     freeing items   0.0 ms
  1478.     Waiting FOR query cache LOCK    0.0 ms
  1479.     freeing items   0.0 ms
  1480.     storing RESULT IN query cache   0.0 ms
  1481.     logging slow query  0.0 ms
  1482.     cleaning up 0.0 ms
  1483.     CALL Stack
  1484.     JROOT/libraries/legacy/categories/categories.php:288
  1485.     JROOT/libraries/legacy/categories/categories.php:181
  1486.     JROOT/components/com_content/helpers/route.php:37
  1487.     JROOT/components/com_content/views/category/tmpl/default_articles.php:115
  1488.     JROOT/libraries/legacy/VIEW/legacy.php:675
  1489.     JROOT/layouts/joomla/content/category_default.php:52
  1490.     JROOT/libraries/cms/layout/file.php:75
  1491.     JROOT/libraries/cms/layout/helper.php:49
  1492.     JROOT/components/com_content/views/category/tmpl/DEFAULT.php:20
  1493.     JROOT/libraries/legacy/VIEW/legacy.php:675
  1494.     JROOT/libraries/legacy/VIEW/legacy.php:211
  1495.     JROOT/components/com_content/views/category/VIEW.html.php:212
  1496.     JROOT/libraries/legacy/controller/legacy.php:685
  1497.     JROOT/components/com_content/controller.php:79
  1498.     JROOT/libraries/legacy/controller/legacy.php:722
  1499.     JROOT/components/com_content/content.php:16
  1500.     JROOT/libraries/legacy/component/helper.php:355
  1501.     JROOT/libraries/legacy/component/helper.php:335
  1502.     JROOT/includes/application.php:220
  1503.     JROOT/INDEX.php:52
  1504.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1505.     Query TIME: 1.61 ms After LAST query: 17.25 ms Query memory: 0.007 MB Memory BEFORE query: 3.305 MB ROWS returned: 5
  1506.  
  1507.     SELECT m.id, m.title, m.module, m.POSITION, m.content, m.showtitle, m.params, mm.menuid
  1508.  
  1509.       FROM w0z9v_modules AS m
  1510.  
  1511.       LEFT JOIN w0z9v_modules_menu AS mm
  1512.       ON mm.moduleid = m.id
  1513.  
  1514.       LEFT JOIN w0z9v_extensions AS e
  1515.       ON e.element = m.module
  1516.       AND e.client_id = m.client_id
  1517.  
  1518.       WHERE m.published = 1
  1519.       AND e.enabled = 1
  1520.       AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-07-11 13:35:12')
  1521.       AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-07-11 13:35:12')
  1522.       AND m.access IN (1,1,5)
  1523.       AND m.client_id = 0
  1524.       AND (mm.menuid = 435 OR mm.menuid <= 0)
  1525.  
  1526.       ORDER BY m.POSITION, m.ordering
  1527.  
  1528.     EXPLAIN
  1529.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1530.     1   SIMPLE  m   REF PRIMARY,published,newsfeeds published   1   const   26  USING WHERE; USING filesort
  1531.     1   SIMPLE  mm  REF PRIMARY PRIMARY 4   m31.m.id    1   USING WHERE; USING INDEX
  1532.     1   SIMPLE  e   REF element_clientid,element_folder_clientid    element_clientid    303 m31.m.module,const  1   USING WHERE
  1533.     Profile
  1534.     STATUS  Duration
  1535.     starting    0.0 ms
  1536.     Waiting FOR query cache LOCK    0.0 ms
  1537.     checking query cache FOR query  0.2 ms
  1538.     checking permissions    0.0 ms
  1539.     checking permissions    0.0 ms
  1540.     checking permissions    0.0 ms
  1541.     Opening TABLES  0.0 ms
  1542.     System LOCK 0.0 ms
  1543.     Waiting FOR query cache LOCK    0.0 ms
  1544.     init    0.1 ms
  1545.     optimizing  0.0 ms
  1546.     statistics  0.1 ms
  1547.     preparing   0.1 ms
  1548.     executing   0.0 ms
  1549.     Sorting RESULT  0.3 ms
  1550.     Sending DATA    0.4 ms
  1551.     END 0.0 ms
  1552.     query END   0.0 ms
  1553.     closing TABLES  0.0 ms
  1554.     freeing items   0.0 ms
  1555.     Waiting FOR query cache LOCK    0.0 ms
  1556.     freeing items   0.0 ms
  1557.     Waiting FOR query cache LOCK    0.0 ms
  1558.     freeing items   0.0 ms
  1559.     storing RESULT IN query cache   0.0 ms
  1560.     logging slow query  0.0 ms
  1561.     cleaning up 0.0 ms
  1562.     CALL Stack
  1563.     JROOT/libraries/legacy/module/helper.php:348
  1564.     JROOT/libraries/legacy/module/helper.php:84
  1565.     JROOT/libraries/joomla/document/html/html.php:502
  1566.     JROOT/templates/protostar/INDEX.php:51
  1567.     JROOT/libraries/joomla/document/html/html.php:570
  1568.     JROOT/libraries/joomla/document/html/html.php:630
  1569.     JROOT/libraries/joomla/document/html/html.php:452
  1570.     JROOT/includes/application.php:278
  1571.     JROOT/INDEX.php:58
  1572.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1573.     Query TIME: 0.22 ms After LAST query: 7.58 ms Query memory: 0.009 MB Memory BEFORE query: 3.351 MB ROWS returned: 4
  1574.  
  1575.     SELECT id, rules
  1576.  
  1577.       FROM `w0z9v_viewlevels`
  1578.  
  1579.     EXPLAIN
  1580.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1581.     1   SIMPLE  w0z9v_viewlevels    ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    4  
  1582.     Profile
  1583.     STATUS  Duration
  1584.     starting    0.0 ms
  1585.     Waiting FOR query cache LOCK    0.0 ms
  1586.     checking query cache FOR query  0.0 ms
  1587.     checking privileges ON cached   0.0 ms
  1588.     checking permissions    0.0 ms
  1589.     sending cached RESULT TO clien  0.0 ms
  1590.     logging slow query  0.0 ms
  1591.     cleaning up 0.0 ms
  1592.     CALL Stack
  1593.     JROOT/libraries/joomla/access/access.php:422
  1594.     JROOT/modules/mod_articles_latest/helper.php:44
  1595.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  1596.     JROOT/libraries/legacy/module/helper.php:176
  1597.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  1598.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  1599.     JROOT/libraries/joomla/document/html/html.php:408
  1600.     JROOT/libraries/joomla/document/html/html.php:692
  1601.     JROOT/libraries/joomla/document/html/html.php:471
  1602.     JROOT/includes/application.php:291
  1603.     JROOT/INDEX.php:58
  1604.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1605.     Query TIME: 4460.75 ms After LAST query: 3.21 ms Query memory: 0.010 MB Memory BEFORE query: 3.374 MB
  1606.  
  1607.     SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
  1608.       CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END AS modified, a.modified_by, uam.name AS modified_by_name,
  1609.       CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END AS publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  1610.       CASE WHEN badcats.id IS NOT NULL THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  1611.       CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id AS contactid,parent.title AS parent_title, parent.id AS parent_id, parent.path AS parent_route, parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count AS rating_count,c.published,
  1612.       CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
  1613.  
  1614.       FROM w0z9v_content AS a
  1615.  
  1616.       LEFT JOIN w0z9v_content_frontpage AS fp
  1617.       ON fp.content_id = a.id
  1618.  
  1619.       LEFT JOIN w0z9v_categories AS c
  1620.       ON c.id = a.catid
  1621.  
  1622.       LEFT JOIN w0z9v_users AS ua
  1623.       ON ua.id = a.created_by
  1624.  
  1625.       LEFT JOIN w0z9v_users AS uam
  1626.       ON uam.id = a.modified_by
  1627.  
  1628.       LEFT JOIN (
  1629.     SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  1630.  
  1631.       FROM w0z9v_contact_details AS contact
  1632.  
  1633.       WHERE contact.published = 1
  1634.  
  1635.       GROUP BY contact.user_id, contact.LANGUAGE) AS contact
  1636.       ON contact.user_id = a.created_by
  1637.  
  1638.       LEFT JOIN w0z9v_categories AS parent
  1639.       ON parent.id = c.parent_id
  1640.  
  1641.       LEFT JOIN w0z9v_content_rating AS v
  1642.       ON a.id = v.content_id
  1643.  
  1644.       LEFT
  1645.       OUTER JOIN (SELECT cat.id AS id
  1646.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  1647.       ON cat.lft BETWEEN parent.lft
  1648.       AND parent.rgt
  1649.       WHERE parent.extension = 'com_content'
  1650.       AND parent.published != 1
  1651.       GROUP BY cat.id ) AS badcats
  1652.       ON badcats.id = c.id
  1653.  
  1654.       WHERE a.access IN (1,1,5)
  1655.       AND c.access IN (1,1,5)
  1656.       AND
  1657.       CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END = 1
  1658.       AND a.catid IN (8,10,11,12,13)
  1659.       AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-11 13:35:12')
  1660.       AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-11 13:35:12')
  1661.  
  1662.       GROUP BY a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
  1663.  
  1664.       ORDER BY a.created DESC
  1665.       LIMIT 0, 10
  1666.  
  1667.     EXPLAIN
  1668.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1669.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  1670.     1   PRIMARY <derived3>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  1671.     1   PRIMARY c   ALL PRIMARY,idx_access  NO INDEX KEY COULD BE USED  NULL    NULL    13  USING WHERE; USING TEMPORARY; USING filesort
  1672.     1   PRIMARY a   REF idx_access,idx_catid    idx_catid   4   m31.c.id    1885    USING WHERE
  1673.     1   PRIMARY ua  eq_ref  PRIMARY PRIMARY 4   m31.a.created_by    1  
  1674.     1   PRIMARY uam eq_ref  PRIMARY PRIMARY 4   m31.a.modified_by   1  
  1675.     1   PRIMARY fp  eq_ref  PRIMARY PRIMARY 4   m31.a.id    1  
  1676.     1   PRIMARY parent  eq_ref  PRIMARY PRIMARY 4   m31.c.parent_id 1  
  1677.     1   PRIMARY v   eq_ref  PRIMARY PRIMARY 4   m31.a.id    1  
  1678.     3   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  1679.     3   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  1680.     2   DERIVED contact REF idx_state   idx_state   1       1   USING WHERE; USING TEMPORARY; USING filesort
  1681.     Profile
  1682.     STATUS  Duration
  1683.     starting    0.0 ms
  1684.     Waiting FOR query cache LOCK    0.0 ms
  1685.     checking query cache FOR query  0.5 ms
  1686.     checking permissions    0.0 ms
  1687.     checking permissions    0.0 ms
  1688.     checking permissions    0.0 ms
  1689.     checking permissions    0.0 ms
  1690.     checking permissions    0.0 ms
  1691.     checking permissions    0.0 ms
  1692.     checking permissions    0.0 ms
  1693.     checking permissions    0.0 ms
  1694.     checking permissions    0.0 ms
  1695.     checking permissions    0.0 ms
  1696.     Opening TABLES  0.1 ms
  1697.     System LOCK 0.2 ms
  1698.     optimizing  0.0 ms
  1699.     statistics  0.1 ms
  1700.     preparing   0.0 ms
  1701.     Creating tmp TABLE  0.0 ms
  1702.     executing   0.0 ms
  1703.     Copying TO tmp TABLE    0.0 ms
  1704.     Sorting RESULT  0.0 ms
  1705.     Sending DATA    0.0 ms
  1706.     optimizing  0.0 ms
  1707.     statistics  0.1 ms
  1708.     preparing   0.0 ms
  1709.     Creating tmp TABLE  0.0 ms
  1710.     executing   0.0 ms
  1711.     Copying TO tmp TABLE    0.1 ms
  1712.     Sorting RESULT  0.0 ms
  1713.     Sending DATA    0.0 ms
  1714.     removing tmp TABLE  0.0 ms
  1715.     Sending DATA    0.0 ms
  1716.     removing tmp TABLE  0.0 ms
  1717.     Sending DATA    0.0 ms
  1718.     Waiting FOR query cache LOCK    0.0 ms
  1719.     Sending DATA    0.1 ms
  1720.     init    0.4 ms
  1721.     optimizing  0.0 ms
  1722.     statistics  0.5 ms
  1723.     preparing   0.1 ms
  1724.     Creating tmp TABLE  0.7 ms
  1725.     executing   0.0 ms
  1726.     Copying TO tmp TABLE    4306.0 ms
  1727.     Waiting FOR query cache LOCK    0.0 ms
  1728.     Copying TO tmp TABLE    0.0 ms
  1729.     storing RESULT IN query cache   0.1 ms
  1730.     END 0.0 ms
  1731.     removing tmp TABLE  151.0 ms
  1732.     END 0.0 ms
  1733.     query END   0.0 ms
  1734.     closing TABLES  0.0 ms
  1735.     removing tmp TABLE  0.0 ms
  1736.     closing TABLES  0.0 ms
  1737.     removing tmp TABLE  0.0 ms
  1738.     closing TABLES  0.0 ms
  1739.     freeing items   0.1 ms
  1740.     logging slow query  0.0 ms
  1741.     cleaning up 0.0 ms
  1742.     CALL Stack
  1743.     JROOT/libraries/legacy/model/legacy.php:301
  1744.     JROOT/libraries/legacy/model/list.php:129
  1745.     JROOT/components/com_content/models/articles.php:522
  1746.     JROOT/modules/mod_articles_latest/helper.php:100
  1747.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  1748.     JROOT/libraries/legacy/module/helper.php:176
  1749.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  1750.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  1751.     JROOT/libraries/joomla/document/html/html.php:408
  1752.     JROOT/libraries/joomla/document/html/html.php:692
  1753.     JROOT/libraries/joomla/document/html/html.php:471
  1754.     JROOT/includes/application.php:291
  1755.     JROOT/INDEX.php:58
  1756.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1757.     Query TIME: 45.78 ms After LAST query: 27.19 ms Query memory: 0.002 MB Memory BEFORE query: 3.506 MB
  1758.  
  1759.     UPDATE `w0z9v_session`
  1760.  
  1761.       SET `data` = '__default|a:8:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1373548759;s:18:\"session.timer.last\";i:1373549350;s:17:\"session.timer.now\";i:1373549712;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"a54201180514197c5fe6d1c16ab420b7\";}'
  1762.         , `time` = '1373549726'
  1763.  
  1764.       WHERE `session_id` = 'tjl2iv5e7e5kjfu03l9ul0tt30'
  1765.  
  1766.     EXPLAIN
  1767.     EXPLAIN NOT possible ON query: UPDATE `w0z9v_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1373548759;s:18:\"session.timer.last\";i:1373549350;s:17:\"session.timer.now\";i:1373549712;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"a54201180514197c5fe6d1c16ab420b7\";}' , `time` = '1373549726' WHERE `session_id` = 'tjl2iv5e7e5kjfu03l9ul0tt30'
  1768.     Profile
  1769.     STATUS  Duration
  1770.     starting    0.1 ms
  1771.     checking permissions    0.0 ms
  1772.     Opening TABLES  0.0 ms
  1773.     System LOCK 0.0 ms
  1774.     init    0.1 ms
  1775.     Updating    0.1 ms
  1776.     END 0.0 ms
  1777.     Waiting FOR query cache LOCK    0.0 ms
  1778.     END 0.0 ms
  1779.     query END   45.2 ms
  1780.     closing TABLES  0.0 ms
  1781.     freeing items   0.0 ms
  1782.     logging slow query  0.0 ms
  1783.     cleaning up 0.0 ms
  1784.     CALL Stack
  1785.     JROOT/libraries/joomla/SESSION/storage/DATABASE.php:85
  1786.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1787.  
  1788. 16 Query Types Logged, Sorted BY Occurrences.
  1789. SELECT TABLES:
  1790.  
  1791.     11 × SELECT `m`.`tag_id`,`t`.*
  1792.       FROM `w0z9v_contentitem_tag_map` AS m  
  1793.       INNER JOIN `w0z9v_tags` AS t  
  1794.       ON `m`.`tag_id` = `t`.`id`
  1795.  
  1796.     4 × SELECT extension_id AS id, element AS "option", params, enabled
  1797.       FROM w0z9v_extensions
  1798.  
  1799.     2 × SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
  1800.       CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END AS modified, a.modified_by, uam.name AS modified_by_name,
  1801.       CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END AS publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  1802.       CASE WHEN badcats.id IS NOT NULL THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  1803.       CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id AS contactid,parent.title AS parent_title, parent.id AS parent_id, parent.path AS parent_route, parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count AS rating_count,c.published,
  1804.       CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
  1805.       FROM w0z9v_content AS a
  1806.       LEFT JOIN w0z9v_content_frontpage AS fp
  1807.       ON fp.content_id = a.id
  1808.       LEFT JOIN w0z9v_categories AS c
  1809.       ON c.id = a.catid
  1810.       LEFT JOIN w0z9v_users AS ua
  1811.       ON ua.id = a.created_by
  1812.       LEFT JOIN w0z9v_users AS uam
  1813.       ON uam.id = a.modified_by
  1814.       LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  1815.       FROM w0z9v_contact_details AS contact
  1816.  
  1817.     2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
  1818.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
  1819.       FROM w0z9v_categories AS c
  1820.       LEFT JOIN w0z9v_categories AS s
  1821.       ON (s.lft <= c.lft
  1822.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  1823.       AND s.rgt < c.rgt)
  1824.       LEFT JOIN  (SELECT cat.id AS id
  1825.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  1826.       ON cat.lft BETWEEN parent.lft
  1827.       AND parent.rgt
  1828.  
  1829.     2 × SELECT b.rules
  1830.       FROM w0z9v_assets AS a
  1831.       LEFT JOIN w0z9v_assets AS b
  1832.       ON b.lft <= a.lft
  1833.       AND b.rgt >= a.rgt
  1834.  
  1835.     1 × SELECT COUNT(*)
  1836.       FROM w0z9v_content AS a
  1837.       LEFT JOIN w0z9v_content_frontpage AS fp
  1838.       ON fp.content_id = a.id
  1839.       LEFT JOIN w0z9v_categories AS c
  1840.       ON c.id = a.catid
  1841.       LEFT JOIN w0z9v_users AS ua
  1842.       ON ua.id = a.created_by
  1843.       LEFT JOIN w0z9v_users AS uam
  1844.       ON uam.id = a.modified_by
  1845.       LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  1846.       FROM w0z9v_contact_details AS contact
  1847.  
  1848.     1 × SELECT m.id, m.title, m.module, m.POSITION, m.content, m.showtitle, m.params, mm.menuid
  1849.       FROM w0z9v_modules AS m
  1850.       LEFT JOIN w0z9v_modules_menu AS mm
  1851.       ON mm.moduleid = m.id
  1852.       LEFT JOIN w0z9v_extensions AS e
  1853.       ON e.element = m.module
  1854.       AND e.client_id = m.client_id
  1855.  
  1856.     1 × SELECT id, rules
  1857.       FROM `w0z9v_viewlevels
  1858.  
  1859.    1 × SELECT folder AS type, element AS name, params
  1860.      FROM w0z9v_extensions
  1861.  
  1862.    1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  1863.      FROM w0z9v_menu AS m
  1864.      LEFT JOIN w0z9v_extensions AS e
  1865.      ON m.component_id = e.extension_id
  1866.  
  1867.    1 × SELECT `DATA`
  1868.      FROM `w0z9v_session`
  1869.  
  1870.    1 × SELECT b.id
  1871.      FROM w0z9v_usergroups AS a
  1872.      LEFT JOIN w0z9v_usergroups AS b
  1873.      ON b.lft <= a.lft
  1874.      AND b.rgt >= a.rgt
  1875.  
  1876.    1 × SELECT *
  1877.      FROM w0z9v_languages
  1878.  
  1879.    1 × SELECT id, home, template, s.params
  1880.      FROM w0z9v_template_styles as s
  1881.      LEFT JOIN w0z9v_extensions as e
  1882.      ON e.element=s.template
  1883.      AND e.type='template'
  1884.      AND e.client_id=s.client_id
  1885.  
  1886. OTHER Tables:
  1887.  
  1888.    1 × UPDATE `w0z9v_session`
  1889.      SET `DATA` = '__default|a:8:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1373548759;s:18:\"session.timer.last\";i:1373549350;s:17:\"session.timer.now\";i:1373549712;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"a54201180514197c5fe6d1c16ab420b7\";}'  , `TIME` = '1373549726'
  1890.  
  1891.    1 × UPDATE w0z9v_categories
  1892.      SET hits = hits + 1
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!