API tools faq
paste
Guest User

Untitled

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