API tools faq
paste
Guest User

Untitled

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