API tools faq
paste
jindan

Untitled

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