API tools faq
paste
Guest User

Untitled

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