API tools faq
paste
jindan

Untitled

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