API tools faq
paste
jindan

Untitled

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