API tools faq
paste
jindan

Untitled

jindan
Jul 13th, 2013
112
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 109.39 KB | None | 0 0
raw download clone embed print report
  1. Joomla! Debug Console
  2. SESSION
  3. __default
  4. Profile Information
  5. TIME
  6. Memory
  7. TIME: 0.0 ms / 0.0 ms Memory: 0.172 MB / 0.17 MB Application: afterLoad
  8. TIME: 54.1 ms / 54.2 ms Memory: 0.670 MB / 0.84 MB Application: afterInitialise
  9. TIME: 21.5 ms / 75.6 ms Memory: 0.228 MB / 1.07 MB Application: afterRoute
  10. TIME: 814.4 ms / 890.0 ms Memory: 1.038 MB / 2.11 MB Application: afterDispatch
  11. TIME: 5.6 ms / 895.7 ms Memory: 0.065 MB / 2.17 MB Application: beforeRenderModule mod_articles_latest (Latest Article)
  12. TIME: 397.5 ms / 1293.2 ms Memory: 0.321 MB / 2.49 MB Application: afterRenderModule mod_articles_latest (Latest Article)
  13. TIME: 0.5 ms / 1293.7 ms Memory: 0.000 MB / 2.34 MB Application: beforeRenderModule mod_login (Login Form)
  14. TIME: 6.0 ms / 1299.8 ms Memory: 0.018 MB / 2.36 MB Application: afterRenderModule mod_login (Login Form)
  15. TIME: 0.4 ms / 1300.1 ms Memory: 0.002 MB / 2.36 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  16. TIME: 3.0 ms / 1303.1 ms Memory: 0.009 MB / 2.37 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
  17. TIME: 0.7 ms / 1303.8 ms Memory: 0.000 MB / 2.37 MB Application: beforeRenderModule mod_menu (Main Menu)
  18. TIME: 5.1 ms / 1308.8 ms Memory: 0.018 MB / 2.38 MB Application: afterRenderModule mod_menu (Main Menu)
  19. TIME: 4.9 ms / 1313.7 ms Memory: 0.021 MB / 2.41 MB Application: afterRender
  20.  
  21. DATABASE queries total: 1116.4 ms
  22. Memory Usage
  23. 2.89 MB (3,031,492 Bytes)
  24. DATABASE Queries
  25. 133 Queries Logged 1116.4 ms
  26.  
  27. 2 duplicate found!
  28. 2 duplicates: #12  #29
  29.  
  30.     Query TIME: 0.94 ms Query memory: 0.008 MB Memory BEFORE query: 0.421 MB ROWS returned: 1
  31.  
  32.     SELECT `data`
  33.  
  34.       FROM `w0z9v_session`
  35.  
  36.       WHERE `session_id` = 'bpm9s8014lqv89rh61r9h69tq3'
  37.  
  38.     EXPLAIN
  39.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  40.     1   SIMPLE  w0z9v_session   const   PRIMARY PRIMARY 602 const   1  
  41.     Profile
  42.     STATUS  Duration
  43.     starting    0.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.1 ms
  48.     System LOCK 0.0 ms
  49.     Waiting FOR query cache LOCK    0.1 ms
  50.     init    0.1 ms
  51.     optimizing  0.0 ms
  52.     statistics  0.1 ms
  53.     preparing   0.0 ms
  54.     executing   0.0 ms
  55.     Sending DATA    0.0 ms
  56.     END 0.0 ms
  57.     query END   0.0 ms
  58.     closing TABLES  0.0 ms
  59.     freeing items   0.0 ms
  60.     Waiting FOR query cache LOCK    0.0 ms
  61.     freeing items   0.0 ms
  62.     Waiting FOR query cache LOCK    0.0 ms
  63.     freeing items   0.0 ms
  64.     storing RESULT IN query cache   0.0 ms
  65.     logging slow query  0.0 ms
  66.     cleaning up 0.0 ms
  67.     CALL Stack
  68.     JROOT/libraries/joomla/SESSION/storage/DATABASE.php:46
  69.     JROOT/libraries/joomla/SESSION/SESSION.php:654
  70.     JROOT/libraries/joomla/SESSION/SESSION.php:592
  71.     JROOT/libraries/legacy/application/application.php:982
  72.     JROOT/libraries/legacy/application/application.php:140
  73.     JROOT/includes/application.php:47
  74.     JROOT/libraries/legacy/application/application.php:175
  75.     JROOT/libraries/joomla/factory.php:104
  76.     JROOT/INDEX.php:37
  77.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  78.     Query TIME: 0.58 ms After LAST query: 1.91 ms Query memory: 0.004 MB Memory BEFORE query: 0.443 MB
  79.  
  80.     DELETE
  81.  
  82.       FROM `w0z9v_session`
  83.  
  84.       WHERE `time` < '1373752873'
  85.  
  86.     EXPLAIN
  87.     EXPLAIN NOT possible ON query: DELETE FROM `w0z9v_session` WHERE `time` < '1373752873'
  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   0.0 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.34 ms After LAST query: 4.52 ms Query memory: 0.005 MB Memory BEFORE query: 0.560 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  0.0 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.35 ms After LAST query: 3.42 ms Query memory: 0.004 MB Memory BEFORE query: 0.563 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  0.0 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.28 ms After LAST query: 3.09 ms Query memory: 0.005 MB Memory BEFORE query: 0.605 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.44 ms After LAST query: 31.35 ms Query memory: 0.009 MB Memory BEFORE query: 0.905 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.41 ms After LAST query: 12.85 ms Query memory: 0.012 MB Memory BEFORE query: 1.070 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  4.1 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.38 ms After LAST query: 5.03 ms Query memory: 0.004 MB Memory BEFORE query: 1.084 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.33 ms After LAST query: 4.75 ms Query memory: 0.004 MB Memory BEFORE query: 1.095 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.33 ms After LAST query: 19.22 ms Query memory: 0.012 MB Memory BEFORE query: 1.347 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.29 ms After LAST query: 2.64 ms Query memory: 0.012 MB Memory BEFORE query: 1.367 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.41 ms After LAST query: 3.96 ms Query memory: 0.010 MB Memory BEFORE query: 1.384 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.28 ms After LAST query: 2.73 ms Query memory: 0.011 MB Memory BEFORE query: 1.405 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: 277.95 ms After LAST query: 8.08 ms Query memory: 0.011 MB Memory BEFORE query: 1.449 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-13 22:16:13')
  618.       AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-13 22:16:13')
  619.  
  620.       ORDER BY  c.lft,  
  621.       CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created
  622.       LIMIT 0, 10
  623.  
  624.     EXPLAIN
  625.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  626.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  627.     1   PRIMARY <derived3>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  628.     1   PRIMARY c   const   PRIMARY,idx_access  PRIMARY 4   const   1   USING filesort
  629.     1   PRIMARY a   REF idx_access,idx_catid    idx_catid   4   const   22679   USING WHERE
  630.     1   PRIMARY fp  eq_ref  PRIMARY PRIMARY 4   m31.a.id    1   USING INDEX
  631.     1   PRIMARY parent  eq_ref  PRIMARY PRIMARY 4   const   1  
  632.     1   PRIMARY v   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.     3   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  636.     3   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  637.     2   DERIVED contact REF idx_state   idx_state   1       1   USING WHERE; USING TEMPORARY; USING filesort
  638.     Profile
  639.     STATUS  Duration
  640.     starting    0.0 ms
  641.     Waiting FOR query cache LOCK    0.0 ms
  642.     checking query cache FOR query  0.8 ms
  643.     checking permissions    0.0 ms
  644.     checking permissions    0.0 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.     Opening TABLES  0.1 ms
  654.     System LOCK 0.2 ms
  655.     optimizing  0.0 ms
  656.     statistics  0.1 ms
  657.     preparing   0.0 ms
  658.     Creating tmp TABLE  0.1 ms
  659.     executing   0.0 ms
  660.     Copying TO tmp TABLE    0.1 ms
  661.     Sorting RESULT  0.0 ms
  662.     Sending DATA    0.0 ms
  663.     optimizing  0.0 ms
  664.     statistics  0.1 ms
  665.     preparing   0.0 ms
  666.     Creating tmp TABLE  0.0 ms
  667.     executing   0.0 ms
  668.     Copying TO tmp TABLE    0.1 ms
  669.     Sorting RESULT  0.0 ms
  670.     Sending DATA    0.0 ms
  671.     removing tmp TABLE  0.0 ms
  672.     Sending DATA    0.0 ms
  673.     removing tmp TABLE  0.0 ms
  674.     Sending DATA    0.0 ms
  675.     Waiting FOR query cache LOCK    0.0 ms
  676.     Sending DATA    0.1 ms
  677.     init    0.3 ms
  678.     optimizing  0.1 ms
  679.     statistics  0.3 ms
  680.     preparing   0.1 ms
  681.     executing   0.0 ms
  682.     Sorting RESULT  273.8 ms
  683.     Sending DATA    0.5 ms
  684.     END 0.0 ms
  685.     query END   0.0 ms
  686.     closing TABLES  0.0 ms
  687.     removing tmp TABLE  0.0 ms
  688.     closing TABLES  0.0 ms
  689.     removing tmp TABLE  0.0 ms
  690.     closing TABLES  0.0 ms
  691.     freeing items   0.0 ms
  692.     Waiting FOR query cache LOCK    0.0 ms
  693.     freeing items   0.0 ms
  694.     Waiting FOR query cache LOCK    0.0 ms
  695.     freeing items   0.0 ms
  696.     storing RESULT IN query cache   0.0 ms
  697.     logging slow query  0.0 ms
  698.     cleaning up 0.0 ms
  699.     CALL Stack
  700.     JROOT/libraries/legacy/model/legacy.php:301
  701.     JROOT/libraries/legacy/model/list.php:129
  702.     JROOT/components/com_content/models/articles.php:522
  703.     JROOT/components/com_content/models/category.php:234
  704.     JROOT/libraries/legacy/VIEW/legacy.php:398
  705.     JROOT/components/com_content/views/category/VIEW.html.php:61
  706.     JROOT/libraries/legacy/controller/legacy.php:685
  707.     JROOT/components/com_content/controller.php:79
  708.     JROOT/libraries/legacy/controller/legacy.php:722
  709.     JROOT/components/com_content/content.php:16
  710.     JROOT/libraries/legacy/component/helper.php:355
  711.     JROOT/libraries/legacy/component/helper.php:335
  712.     JROOT/includes/application.php:220
  713.     JROOT/INDEX.php:52
  714.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  715.     Query TIME: 0.18 ms After LAST query: 4.05 ms Query memory: 0.013 MB Memory BEFORE query: 1.623 MB ROWS returned: 1
  716.  
  717.     SELECT extension_id AS id, element AS "option", params, enabled
  718.  
  719.       FROM w0z9v_extensions
  720.  
  721.       WHERE `type` = 'component'
  722.       AND `element` = 'com_tags'
  723.  
  724.     EXPLAIN
  725.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  726.     1   SIMPLE  w0z9v_extensions    REF element_clientid,element_folder_clientid,extension  element_clientid    302 const   1   USING WHERE
  727.     Profile
  728.     STATUS  Duration
  729.     starting    0.0 ms
  730.     Waiting FOR query cache LOCK    0.0 ms
  731.     checking query cache FOR query  0.0 ms
  732.     checking privileges ON cached   0.0 ms
  733.     checking permissions    0.0 ms
  734.     sending cached RESULT TO clien  0.0 ms
  735.     logging slow query  0.0 ms
  736.     cleaning up 0.0 ms
  737.     CALL Stack
  738.     JROOT/libraries/joomla/cache/controller/callback.php:158
  739.     JROOT/libraries/legacy/component/helper.php:384
  740.     JROOT/libraries/legacy/component/helper.php:43
  741.     JROOT/libraries/legacy/component/helper.php:91
  742.     JROOT/libraries/cms/helper/tags.php:392
  743.     JROOT/components/com_content/models/articles.php:648
  744.     JROOT/components/com_content/models/category.php:234
  745.     JROOT/libraries/legacy/VIEW/legacy.php:398
  746.     JROOT/components/com_content/views/category/VIEW.html.php:61
  747.     JROOT/libraries/legacy/controller/legacy.php:685
  748.     JROOT/components/com_content/controller.php:79
  749.     JROOT/libraries/legacy/controller/legacy.php:722
  750.     JROOT/components/com_content/content.php:16
  751.     JROOT/libraries/legacy/component/helper.php:355
  752.     JROOT/libraries/legacy/component/helper.php:335
  753.     JROOT/includes/application.php:220
  754.     JROOT/INDEX.php:52
  755.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  756.     Query TIME: 0.16 ms After LAST query: 0.81 ms Query memory: 0.010 MB Memory BEFORE query: 1.623 MB ROWS returned: 0
  757.  
  758.     SELECT `m`.`tag_id`,`t`.*
  759.  
  760.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  761.  
  762.       WHERE `m`.`tag_id` = `t`.`id`
  763.       AND `ct`.`type_id` = `m`.`type_id`
  764.       AND `ct`.`type_alias` = 'com_content.article'
  765.       AND `m`.`content_item_id` = 5913
  766.       AND `t`.`published` = 1
  767.       AND t.access IN (1,1,5)
  768.  
  769.     EXPLAIN
  770.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  771.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  772.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  773.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  774.     Profile
  775.     STATUS  Duration
  776.     starting    0.0 ms
  777.     Waiting FOR query cache LOCK    0.0 ms
  778.     checking query cache FOR query  0.0 ms
  779.     checking privileges ON cached   0.0 ms
  780.     checking permissions    0.0 ms
  781.     checking permissions    0.0 ms
  782.     checking permissions    0.0 ms
  783.     sending cached RESULT TO clien  0.0 ms
  784.     logging slow query  0.0 ms
  785.     cleaning up 0.0 ms
  786.     CALL Stack
  787.     JROOT/libraries/cms/helper/tags.php:409
  788.     JROOT/components/com_content/models/articles.php:648
  789.     JROOT/components/com_content/models/category.php:234
  790.     JROOT/libraries/legacy/VIEW/legacy.php:398
  791.     JROOT/components/com_content/views/category/VIEW.html.php:61
  792.     JROOT/libraries/legacy/controller/legacy.php:685
  793.     JROOT/components/com_content/controller.php:79
  794.     JROOT/libraries/legacy/controller/legacy.php:722
  795.     JROOT/components/com_content/content.php:16
  796.     JROOT/libraries/legacy/component/helper.php:355
  797.     JROOT/libraries/legacy/component/helper.php:335
  798.     JROOT/includes/application.php:220
  799.     JROOT/INDEX.php:52
  800.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  801.     Query TIME: 0.18 ms After LAST query: 1.62 ms Query memory: 0.010 MB Memory BEFORE query: 1.643 MB ROWS returned: 0
  802.  
  803.     SELECT `m`.`tag_id`,`t`.*
  804.  
  805.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  806.  
  807.       WHERE `m`.`tag_id` = `t`.`id`
  808.       AND `ct`.`type_id` = `m`.`type_id`
  809.       AND `ct`.`type_alias` = 'com_content.article'
  810.       AND `m`.`content_item_id` = 9170
  811.       AND `t`.`published` = 1
  812.       AND t.access IN (1,1,5)
  813.  
  814.     EXPLAIN
  815.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  816.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  817.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  818.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  819.     Profile
  820.     STATUS  Duration
  821.     starting    0.0 ms
  822.     Waiting FOR query cache LOCK    0.0 ms
  823.     checking query cache FOR query  0.0 ms
  824.     checking privileges ON cached   0.0 ms
  825.     checking permissions    0.0 ms
  826.     checking permissions    0.0 ms
  827.     checking permissions    0.0 ms
  828.     sending cached RESULT TO clien  0.0 ms
  829.     logging slow query  0.0 ms
  830.     cleaning up 0.0 ms
  831.     CALL Stack
  832.     JROOT/libraries/cms/helper/tags.php:409
  833.     JROOT/components/com_content/models/articles.php:648
  834.     JROOT/components/com_content/models/category.php:234
  835.     JROOT/libraries/legacy/VIEW/legacy.php:398
  836.     JROOT/components/com_content/views/category/VIEW.html.php:61
  837.     JROOT/libraries/legacy/controller/legacy.php:685
  838.     JROOT/components/com_content/controller.php:79
  839.     JROOT/libraries/legacy/controller/legacy.php:722
  840.     JROOT/components/com_content/content.php:16
  841.     JROOT/libraries/legacy/component/helper.php:355
  842.     JROOT/libraries/legacy/component/helper.php:335
  843.     JROOT/includes/application.php:220
  844.     JROOT/INDEX.php:52
  845.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  846.     Query TIME: 0.17 ms After LAST query: 1.59 ms Query memory: 0.010 MB Memory BEFORE query: 1.663 MB ROWS returned: 0
  847.  
  848.     SELECT `m`.`tag_id`,`t`.*
  849.  
  850.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  851.  
  852.       WHERE `m`.`tag_id` = `t`.`id`
  853.       AND `ct`.`type_id` = `m`.`type_id`
  854.       AND `ct`.`type_alias` = 'com_content.article'
  855.       AND `m`.`content_item_id` = 9169
  856.       AND `t`.`published` = 1
  857.       AND t.access IN (1,1,5)
  858.  
  859.     EXPLAIN
  860.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  861.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  862.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  863.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  864.     Profile
  865.     STATUS  Duration
  866.     starting    0.0 ms
  867.     Waiting FOR query cache LOCK    0.0 ms
  868.     checking query cache FOR query  0.0 ms
  869.     checking privileges ON cached   0.0 ms
  870.     checking permissions    0.0 ms
  871.     checking permissions    0.0 ms
  872.     checking permissions    0.0 ms
  873.     sending cached RESULT TO clien  0.0 ms
  874.     logging slow query  0.0 ms
  875.     cleaning up 0.0 ms
  876.     CALL Stack
  877.     JROOT/libraries/cms/helper/tags.php:409
  878.     JROOT/components/com_content/models/articles.php:648
  879.     JROOT/components/com_content/models/category.php:234
  880.     JROOT/libraries/legacy/VIEW/legacy.php:398
  881.     JROOT/components/com_content/views/category/VIEW.html.php:61
  882.     JROOT/libraries/legacy/controller/legacy.php:685
  883.     JROOT/components/com_content/controller.php:79
  884.     JROOT/libraries/legacy/controller/legacy.php:722
  885.     JROOT/components/com_content/content.php:16
  886.     JROOT/libraries/legacy/component/helper.php:355
  887.     JROOT/libraries/legacy/component/helper.php:335
  888.     JROOT/includes/application.php:220
  889.     JROOT/INDEX.php:52
  890.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  891.     Query TIME: 0.17 ms After LAST query: 1.60 ms Query memory: 0.010 MB Memory BEFORE query: 1.683 MB ROWS returned: 0
  892.  
  893.     SELECT `m`.`tag_id`,`t`.*
  894.  
  895.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  896.  
  897.       WHERE `m`.`tag_id` = `t`.`id`
  898.       AND `ct`.`type_id` = `m`.`type_id`
  899.       AND `ct`.`type_alias` = 'com_content.article'
  900.       AND `m`.`content_item_id` = 9168
  901.       AND `t`.`published` = 1
  902.       AND t.access IN (1,1,5)
  903.  
  904.     EXPLAIN
  905.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  906.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  907.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  908.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  909.     Profile
  910.     STATUS  Duration
  911.     starting    0.0 ms
  912.     Waiting FOR query cache LOCK    0.0 ms
  913.     checking query cache FOR query  0.0 ms
  914.     checking privileges ON cached   0.0 ms
  915.     checking permissions    0.0 ms
  916.     checking permissions    0.0 ms
  917.     checking permissions    0.0 ms
  918.     sending cached RESULT TO clien  0.0 ms
  919.     logging slow query  0.0 ms
  920.     cleaning up 0.0 ms
  921.     CALL Stack
  922.     JROOT/libraries/cms/helper/tags.php:409
  923.     JROOT/components/com_content/models/articles.php:648
  924.     JROOT/components/com_content/models/category.php:234
  925.     JROOT/libraries/legacy/VIEW/legacy.php:398
  926.     JROOT/components/com_content/views/category/VIEW.html.php:61
  927.     JROOT/libraries/legacy/controller/legacy.php:685
  928.     JROOT/components/com_content/controller.php:79
  929.     JROOT/libraries/legacy/controller/legacy.php:722
  930.     JROOT/components/com_content/content.php:16
  931.     JROOT/libraries/legacy/component/helper.php:355
  932.     JROOT/libraries/legacy/component/helper.php:335
  933.     JROOT/includes/application.php:220
  934.     JROOT/INDEX.php:52
  935.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  936.     Query TIME: 0.17 ms After LAST query: 1.57 ms Query memory: 0.010 MB Memory BEFORE query: 1.703 MB ROWS returned: 1
  937.  
  938.     SELECT `m`.`tag_id`,`t`.*
  939.  
  940.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  941.  
  942.       WHERE `m`.`tag_id` = `t`.`id`
  943.       AND `ct`.`type_id` = `m`.`type_id`
  944.       AND `ct`.`type_alias` = 'com_content.article'
  945.       AND `m`.`content_item_id` = 9167
  946.       AND `t`.`published` = 1
  947.       AND t.access IN (1,1,5)
  948.  
  949.     EXPLAIN
  950.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  951.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  952.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  953.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  954.     Profile
  955.     STATUS  Duration
  956.     starting    0.0 ms
  957.     Waiting FOR query cache LOCK    0.0 ms
  958.     checking query cache FOR query  0.0 ms
  959.     checking privileges ON cached   0.0 ms
  960.     checking permissions    0.0 ms
  961.     checking permissions    0.0 ms
  962.     checking permissions    0.0 ms
  963.     sending cached RESULT TO clien  0.0 ms
  964.     logging slow query  0.0 ms
  965.     cleaning up 0.0 ms
  966.     CALL Stack
  967.     JROOT/libraries/cms/helper/tags.php:409
  968.     JROOT/components/com_content/models/articles.php:648
  969.     JROOT/components/com_content/models/category.php:234
  970.     JROOT/libraries/legacy/VIEW/legacy.php:398
  971.     JROOT/components/com_content/views/category/VIEW.html.php:61
  972.     JROOT/libraries/legacy/controller/legacy.php:685
  973.     JROOT/components/com_content/controller.php:79
  974.     JROOT/libraries/legacy/controller/legacy.php:722
  975.     JROOT/components/com_content/content.php:16
  976.     JROOT/libraries/legacy/component/helper.php:355
  977.     JROOT/libraries/legacy/component/helper.php:335
  978.     JROOT/includes/application.php:220
  979.     JROOT/INDEX.php:52
  980.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  981.     Query TIME: 0.16 ms After LAST query: 1.65 ms Query memory: 0.010 MB Memory BEFORE query: 1.727 MB ROWS returned: 0
  982.  
  983.     SELECT `m`.`tag_id`,`t`.*
  984.  
  985.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  986.  
  987.       WHERE `m`.`tag_id` = `t`.`id`
  988.       AND `ct`.`type_id` = `m`.`type_id`
  989.       AND `ct`.`type_alias` = 'com_content.article'
  990.       AND `m`.`content_item_id` = 9166
  991.       AND `t`.`published` = 1
  992.       AND t.access IN (1,1,5)
  993.  
  994.     EXPLAIN
  995.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  996.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  997.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  998.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  999.     Profile
  1000.     STATUS  Duration
  1001.     starting    0.0 ms
  1002.     Waiting FOR query cache LOCK    0.0 ms
  1003.     checking query cache FOR query  0.0 ms
  1004.     checking privileges ON cached   0.0 ms
  1005.     checking permissions    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:409
  1013.     JROOT/components/com_content/models/articles.php:648
  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.17 ms After LAST query: 1.57 ms Query memory: 0.010 MB Memory BEFORE query: 1.747 MB ROWS returned: 0
  1027.  
  1028.     SELECT `m`.`tag_id`,`t`.*
  1029.  
  1030.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  1031.  
  1032.       WHERE `m`.`tag_id` = `t`.`id`
  1033.       AND `ct`.`type_id` = `m`.`type_id`
  1034.       AND `ct`.`type_alias` = 'com_content.article'
  1035.       AND `m`.`content_item_id` = 9165
  1036.       AND `t`.`published` = 1
  1037.       AND t.access IN (1,1,5)
  1038.  
  1039.     EXPLAIN
  1040.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1041.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  1042.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  1043.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   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.     checking permissions    0.0 ms
  1053.     sending cached RESULT TO clien  0.0 ms
  1054.     logging slow query  0.0 ms
  1055.     cleaning up 0.0 ms
  1056.     CALL Stack
  1057.     JROOT/libraries/cms/helper/tags.php:409
  1058.     JROOT/components/com_content/models/articles.php:648
  1059.     JROOT/components/com_content/models/category.php:234
  1060.     JROOT/libraries/legacy/VIEW/legacy.php:398
  1061.     JROOT/components/com_content/views/category/VIEW.html.php:61
  1062.     JROOT/libraries/legacy/controller/legacy.php:685
  1063.     JROOT/components/com_content/controller.php:79
  1064.     JROOT/libraries/legacy/controller/legacy.php:722
  1065.     JROOT/components/com_content/content.php:16
  1066.     JROOT/libraries/legacy/component/helper.php:355
  1067.     JROOT/libraries/legacy/component/helper.php:335
  1068.     JROOT/includes/application.php:220
  1069.     JROOT/INDEX.php:52
  1070.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1071.     Query TIME: 0.19 ms After LAST query: 1.56 ms Query memory: 0.010 MB Memory BEFORE query: 1.767 MB ROWS returned: 0
  1072.  
  1073.     SELECT `m`.`tag_id`,`t`.*
  1074.  
  1075.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  1076.  
  1077.       WHERE `m`.`tag_id` = `t`.`id`
  1078.       AND `ct`.`type_id` = `m`.`type_id`
  1079.       AND `ct`.`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  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  1087.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  1088.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  1089.     Profile
  1090.     STATUS  Duration
  1091.     starting    0.0 ms
  1092.     Waiting FOR query cache LOCK    0.0 ms
  1093.     checking query cache FOR query  0.0 ms
  1094.     checking privileges ON cached   0.0 ms
  1095.     checking permissions    0.0 ms
  1096.     checking permissions    0.0 ms
  1097.     checking permissions    0.0 ms
  1098.     sending cached RESULT TO clien  0.0 ms
  1099.     logging slow query  0.0 ms
  1100.     cleaning up 0.0 ms
  1101.     CALL Stack
  1102.     JROOT/libraries/cms/helper/tags.php:409
  1103.     JROOT/components/com_content/models/articles.php:648
  1104.     JROOT/components/com_content/models/category.php:234
  1105.     JROOT/libraries/legacy/VIEW/legacy.php:398
  1106.     JROOT/components/com_content/views/category/VIEW.html.php:61
  1107.     JROOT/libraries/legacy/controller/legacy.php:685
  1108.     JROOT/components/com_content/controller.php:79
  1109.     JROOT/libraries/legacy/controller/legacy.php:722
  1110.     JROOT/components/com_content/content.php:16
  1111.     JROOT/libraries/legacy/component/helper.php:355
  1112.     JROOT/libraries/legacy/component/helper.php:335
  1113.     JROOT/includes/application.php:220
  1114.     JROOT/INDEX.php:52
  1115.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1116.     Query TIME: 0.17 ms After LAST query: 1.57 ms Query memory: 0.010 MB Memory BEFORE query: 1.787 MB ROWS returned: 0
  1117.  
  1118.     SELECT `m`.`tag_id`,`t`.*
  1119.  
  1120.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  1121.  
  1122.       WHERE `m`.`tag_id` = `t`.`id`
  1123.       AND `ct`.`type_id` = `m`.`type_id`
  1124.       AND `ct`.`type_alias` = 'com_content.article'
  1125.       AND `m`.`content_item_id` = 9163
  1126.       AND `t`.`published` = 1
  1127.       AND t.access IN (1,1,5)
  1128.  
  1129.     EXPLAIN
  1130.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1131.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  1132.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  1133.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  1134.     Profile
  1135.     STATUS  Duration
  1136.     starting    0.0 ms
  1137.     Waiting FOR query cache LOCK    0.0 ms
  1138.     checking query cache FOR query  0.0 ms
  1139.     checking privileges ON cached   0.0 ms
  1140.     checking permissions    0.0 ms
  1141.     checking permissions    0.0 ms
  1142.     checking permissions    0.0 ms
  1143.     sending cached RESULT TO clien  0.0 ms
  1144.     logging slow query  0.0 ms
  1145.     cleaning up 0.0 ms
  1146.     CALL Stack
  1147.     JROOT/libraries/cms/helper/tags.php:409
  1148.     JROOT/components/com_content/models/articles.php:648
  1149.     JROOT/components/com_content/models/category.php:234
  1150.     JROOT/libraries/legacy/VIEW/legacy.php:398
  1151.     JROOT/components/com_content/views/category/VIEW.html.php:61
  1152.     JROOT/libraries/legacy/controller/legacy.php:685
  1153.     JROOT/components/com_content/controller.php:79
  1154.     JROOT/libraries/legacy/controller/legacy.php:722
  1155.     JROOT/components/com_content/content.php:16
  1156.     JROOT/libraries/legacy/component/helper.php:355
  1157.     JROOT/libraries/legacy/component/helper.php:335
  1158.     JROOT/includes/application.php:220
  1159.     JROOT/INDEX.php:52
  1160.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1161.     Query TIME: 0.26 ms After LAST query: 1.57 ms Query memory: 0.010 MB Memory BEFORE query: 1.807 MB ROWS returned: 0
  1162.  
  1163.     SELECT `m`.`tag_id`,`t`.*
  1164.  
  1165.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  1166.  
  1167.       WHERE `m`.`tag_id` = `t`.`id`
  1168.       AND `ct`.`type_id` = `m`.`type_id`
  1169.       AND `ct`.`type_alias` = 'com_content.article'
  1170.       AND `m`.`content_item_id` = 9162
  1171.       AND `t`.`published` = 1
  1172.       AND t.access IN (1,1,5)
  1173.  
  1174.     EXPLAIN
  1175.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1176.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  1177.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  1178.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  1179.     Profile
  1180.     STATUS  Duration
  1181.     starting    0.0 ms
  1182.     Waiting FOR query cache LOCK    0.0 ms
  1183.     checking query cache FOR query  0.0 ms
  1184.     checking privileges ON cached   0.0 ms
  1185.     checking permissions    0.0 ms
  1186.     checking permissions    0.0 ms
  1187.     checking permissions    0.0 ms
  1188.     sending cached RESULT TO clien  0.0 ms
  1189.     logging slow query  0.0 ms
  1190.     cleaning up 0.0 ms
  1191.     CALL Stack
  1192.     JROOT/libraries/cms/helper/tags.php:409
  1193.     JROOT/components/com_content/models/articles.php:648
  1194.     JROOT/components/com_content/models/category.php:234
  1195.     JROOT/libraries/legacy/VIEW/legacy.php:398
  1196.     JROOT/components/com_content/views/category/VIEW.html.php:61
  1197.     JROOT/libraries/legacy/controller/legacy.php:685
  1198.     JROOT/components/com_content/controller.php:79
  1199.     JROOT/libraries/legacy/controller/legacy.php:722
  1200.     JROOT/components/com_content/content.php:16
  1201.     JROOT/libraries/legacy/component/helper.php:355
  1202.     JROOT/libraries/legacy/component/helper.php:335
  1203.     JROOT/includes/application.php:220
  1204.     JROOT/INDEX.php:52
  1205.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1206.     Query TIME: 394.03 ms After LAST query: 1.58 ms Query memory: 0.011 MB Memory BEFORE query: 1.834 MB ROWS returned: 1
  1207.  
  1208.     SELECT COUNT(*)
  1209.  
  1210.       FROM w0z9v_content AS a
  1211.  
  1212.       LEFT JOIN w0z9v_content_frontpage AS fp
  1213.       ON fp.content_id = a.id
  1214.  
  1215.       LEFT JOIN w0z9v_categories AS c
  1216.       ON c.id = a.catid
  1217.  
  1218.       LEFT JOIN w0z9v_users AS ua
  1219.       ON ua.id = a.created_by
  1220.  
  1221.       LEFT JOIN w0z9v_users AS uam
  1222.       ON uam.id = a.modified_by
  1223.  
  1224.       LEFT JOIN (
  1225.     SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  1226.  
  1227.       FROM w0z9v_contact_details AS contact
  1228.  
  1229.       WHERE contact.published = 1
  1230.  
  1231.       GROUP BY contact.user_id, contact.LANGUAGE) AS contact
  1232.       ON contact.user_id = a.created_by
  1233.  
  1234.       LEFT JOIN w0z9v_categories AS parent
  1235.       ON parent.id = c.parent_id
  1236.  
  1237.       LEFT JOIN w0z9v_content_rating AS v
  1238.       ON a.id = v.content_id
  1239.  
  1240.       LEFT
  1241.       OUTER JOIN (SELECT cat.id AS id
  1242.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  1243.       ON cat.lft BETWEEN parent.lft
  1244.       AND parent.rgt
  1245.       WHERE parent.extension = 'com_content'
  1246.       AND parent.published != 1
  1247.       GROUP BY cat.id ) AS badcats
  1248.       ON badcats.id = c.id
  1249.  
  1250.       WHERE a.access IN (1,1,5)
  1251.       AND c.access IN (1,1,5)
  1252.       AND
  1253.       CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END = 1
  1254.       AND a.catid = 8
  1255.       AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-13 22:16:13')
  1256.       AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-13 22:16:13')
  1257.  
  1258.     EXPLAIN
  1259.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1260.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  1261.     1   PRIMARY <derived3>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  1262.     1   PRIMARY c   const   PRIMARY,idx_access  PRIMARY 4   const   1  
  1263.     1   PRIMARY a   REF idx_access,idx_catid    idx_catid   4   const   22679   USING WHERE
  1264.     1   PRIMARY fp  eq_ref  PRIMARY PRIMARY 4   m31.a.id    1   USING INDEX
  1265.     1   PRIMARY parent  eq_ref  PRIMARY PRIMARY 4   const   1   USING INDEX
  1266.     1   PRIMARY v   eq_ref  PRIMARY PRIMARY 4   m31.a.id    1   USING INDEX
  1267.     1   PRIMARY ua  eq_ref  PRIMARY PRIMARY 4   m31.a.created_by    1   USING INDEX
  1268.     1   PRIMARY uam eq_ref  PRIMARY PRIMARY 4   m31.a.modified_by   1   USING INDEX
  1269.     3   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  1270.     3   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  1271.     2   DERIVED contact REF idx_state   idx_state   1       1   USING WHERE; USING TEMPORARY; USING filesort
  1272.     Profile
  1273.     STATUS  Duration
  1274.     starting    0.0 ms
  1275.     Waiting FOR query cache LOCK    0.0 ms
  1276.     checking query cache FOR query  0.2 ms
  1277.     checking permissions    0.0 ms
  1278.     checking permissions    0.0 ms
  1279.     checking permissions    0.0 ms
  1280.     checking permissions    0.0 ms
  1281.     checking permissions    0.0 ms
  1282.     checking permissions    0.0 ms
  1283.     checking permissions    0.0 ms
  1284.     checking permissions    0.0 ms
  1285.     checking permissions    0.0 ms
  1286.     checking permissions    0.0 ms
  1287.     Opening TABLES  0.1 ms
  1288.     System LOCK 0.1 ms
  1289.     optimizing  0.0 ms
  1290.     statistics  0.1 ms
  1291.     preparing   0.0 ms
  1292.     Creating tmp TABLE  0.0 ms
  1293.     executing   0.0 ms
  1294.     Copying TO tmp TABLE    0.0 ms
  1295.     Sorting RESULT  0.0 ms
  1296.     Sending DATA    0.0 ms
  1297.     optimizing  0.0 ms
  1298.     statistics  0.1 ms
  1299.     preparing   0.0 ms
  1300.     Creating tmp TABLE  0.0 ms
  1301.     executing   0.0 ms
  1302.     Copying TO tmp TABLE    0.1 ms
  1303.     Sorting RESULT  0.0 ms
  1304.     Sending DATA    0.0 ms
  1305.     removing tmp TABLE  0.0 ms
  1306.     Sending DATA    0.0 ms
  1307.     removing tmp TABLE  0.0 ms
  1308.     Sending DATA    0.0 ms
  1309.     Waiting FOR query cache LOCK    0.0 ms
  1310.     Sending DATA    0.0 ms
  1311.     init    0.1 ms
  1312.     optimizing  0.0 ms
  1313.     statistics  0.1 ms
  1314.     preparing   0.0 ms
  1315.     executing   0.0 ms
  1316.     Sending DATA    392.4 ms
  1317.     END 0.0 ms
  1318.     query END   0.0 ms
  1319.     closing TABLES  0.0 ms
  1320.     removing tmp TABLE  0.0 ms
  1321.     closing TABLES  0.0 ms
  1322.     removing tmp TABLE  0.0 ms
  1323.     closing TABLES  0.0 ms
  1324.     freeing items   0.0 ms
  1325.     Waiting FOR query cache LOCK    0.0 ms
  1326.     freeing items   0.2 ms
  1327.     Waiting FOR query cache LOCK    0.0 ms
  1328.     freeing items   0.0 ms
  1329.     storing RESULT IN query cache   0.0 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: 34.78 ms After LAST query: 8.45 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.1 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.2 ms
  1369.     query END   34.1 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.18 ms After LAST query: 1.10 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_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  1391.  
  1392.       WHERE `m`.`tag_id` = `t`.`id`
  1393.       AND `ct`.`type_id` = `m`.`type_id`
  1394.       AND `ct`.`type_alias` = 'com_content.category'
  1395.       AND `m`.`content_item_id` = 8
  1396.       AND `t`.`published` = 1
  1397.       AND t.access IN (1,1,5)
  1398.  
  1399.     EXPLAIN
  1400.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1401.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  1402.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  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.     checking permissions    0.0 ms
  1413.     sending cached RESULT TO clien  0.0 ms
  1414.     logging slow query  0.0 ms
  1415.     cleaning up 0.0 ms
  1416.     CALL Stack
  1417.     JROOT/libraries/cms/helper/tags.php:409
  1418.     JROOT/components/com_content/views/category/VIEW.html.php:208
  1419.     JROOT/libraries/legacy/controller/legacy.php:685
  1420.     JROOT/components/com_content/controller.php:79
  1421.     JROOT/libraries/legacy/controller/legacy.php:722
  1422.     JROOT/components/com_content/content.php:16
  1423.     JROOT/libraries/legacy/component/helper.php:355
  1424.     JROOT/libraries/legacy/component/helper.php:335
  1425.     JROOT/includes/application.php:220
  1426.     JROOT/INDEX.php:52
  1427.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1428.     Query TIME: 1.44 ms After LAST query: 10.76 ms Query memory: 0.015 MB Memory BEFORE query: 2.129 MB ROWS returned: 3
  1429.     Duplicate queries: #12
  1430.  
  1431.     SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  1432.                 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  1433.                 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  1434.                 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
  1435.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
  1436.  
  1437.       FROM w0z9v_categories AS c
  1438.  
  1439.       LEFT JOIN w0z9v_categories AS s
  1440.       ON (s.lft <= c.lft
  1441.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  1442.       AND s.rgt < c.rgt)
  1443.  
  1444.       LEFT JOIN  (SELECT cat.id AS id
  1445.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  1446.       ON cat.lft BETWEEN parent.lft
  1447.       AND parent.rgt
  1448.       WHERE parent.extension = 'com_content'
  1449.       AND parent.published != 1
  1450.       GROUP BY cat.id) AS badcats
  1451.       ON badcats.id = c.id
  1452.  
  1453.       WHERE (c.extension='com_content' OR c.extension='system')
  1454.       AND c.access IN (1,1,5)
  1455.       AND c.published = 1
  1456.       AND s.id=8
  1457.       AND badcats.id IS NULL
  1458.  
  1459.       GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  1460.                  c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  1461.                  c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  1462.                  c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
  1463.  
  1464.       ORDER BY c.lft
  1465.  
  1466.     EXPLAIN
  1467.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1468.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  1469.     1   PRIMARY s   const   PRIMARY,idx_left_right  PRIMARY 4   const   1   USING filesort
  1470.     1   PRIMARY c   ALL cat_idx,idx_access,idx_left_right   NO INDEX KEY COULD BE USED  NULL    NULL    13  USING WHERE
  1471.     2   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  1472.     2   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  1473.     Profile
  1474.     STATUS  Duration
  1475.     starting    0.0 ms
  1476.     Waiting FOR query cache LOCK    0.0 ms
  1477.     checking query cache FOR query  0.2 ms
  1478.     checking permissions    0.0 ms
  1479.     checking permissions    0.0 ms
  1480.     checking permissions    0.0 ms
  1481.     checking permissions    0.0 ms
  1482.     Opening TABLES  0.0 ms
  1483.     System LOCK 0.1 ms
  1484.     optimizing  0.0 ms
  1485.     statistics  0.1 ms
  1486.     preparing   0.0 ms
  1487.     Creating tmp TABLE  0.0 ms
  1488.     executing   0.0 ms
  1489.     Copying TO tmp TABLE    0.1 ms
  1490.     Sorting RESULT  0.0 ms
  1491.     Sending DATA    0.0 ms
  1492.     removing tmp TABLE  0.0 ms
  1493.     Sending DATA    0.0 ms
  1494.     Waiting FOR query cache LOCK    0.0 ms
  1495.     Sending DATA    0.0 ms
  1496.     init    0.1 ms
  1497.     optimizing  0.0 ms
  1498.     statistics  0.1 ms
  1499.     preparing   0.0 ms
  1500.     executing   0.0 ms
  1501.     Sorting RESULT  0.1 ms
  1502.     Sending DATA    0.1 ms
  1503.     END 0.0 ms
  1504.     query END   0.0 ms
  1505.     closing TABLES  0.0 ms
  1506.     removing tmp TABLE  0.0 ms
  1507.     closing TABLES  0.0 ms
  1508.     freeing items   0.0 ms
  1509.     Waiting FOR query cache LOCK    0.0 ms
  1510.     freeing items   0.0 ms
  1511.     Waiting FOR query cache LOCK    0.0 ms
  1512.     freeing items   0.0 ms
  1513.     storing RESULT IN query cache   0.0 ms
  1514.     logging slow query  0.0 ms
  1515.     cleaning up 0.0 ms
  1516.     CALL Stack
  1517.     JROOT/libraries/legacy/categories/categories.php:288
  1518.     JROOT/libraries/legacy/categories/categories.php:181
  1519.     JROOT/components/com_content/helpers/route.php:37
  1520.     JROOT/components/com_content/views/category/tmpl/default_articles.php:115
  1521.     JROOT/libraries/legacy/VIEW/legacy.php:675
  1522.     JROOT/layouts/joomla/content/category_default.php:52
  1523.     JROOT/libraries/cms/layout/file.php:75
  1524.     JROOT/libraries/cms/layout/helper.php:49
  1525.     JROOT/components/com_content/views/category/tmpl/DEFAULT.php:20
  1526.     JROOT/libraries/legacy/VIEW/legacy.php:675
  1527.     JROOT/libraries/legacy/VIEW/legacy.php:211
  1528.     JROOT/components/com_content/views/category/VIEW.html.php:212
  1529.     JROOT/libraries/legacy/controller/legacy.php:685
  1530.     JROOT/components/com_content/controller.php:79
  1531.     JROOT/libraries/legacy/controller/legacy.php:722
  1532.     JROOT/components/com_content/content.php:16
  1533.     JROOT/libraries/legacy/component/helper.php:355
  1534.     JROOT/libraries/legacy/component/helper.php:335
  1535.     JROOT/includes/application.php:220
  1536.     JROOT/INDEX.php:52
  1537.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1538.     Query TIME: 1.22 ms After LAST query: 19.07 ms Query memory: 0.007 MB Memory BEFORE query: 2.147 MB ROWS returned: 5
  1539.  
  1540.     SELECT m.id, m.title, m.module, m.POSITION, m.content, m.showtitle, m.params, mm.menuid
  1541.  
  1542.       FROM w0z9v_modules AS m
  1543.  
  1544.       LEFT JOIN w0z9v_modules_menu AS mm
  1545.       ON mm.moduleid = m.id
  1546.  
  1547.       LEFT JOIN w0z9v_extensions AS e
  1548.       ON e.element = m.module
  1549.       AND e.client_id = m.client_id
  1550.  
  1551.       WHERE m.published = 1
  1552.       AND e.enabled = 1
  1553.       AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-07-13 22:16:13')
  1554.       AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-07-13 22:16:13')
  1555.       AND m.access IN (1,1,5)
  1556.       AND m.client_id = 0
  1557.       AND (mm.menuid = 435 OR mm.menuid <= 0)
  1558.  
  1559.       ORDER BY m.POSITION, m.ordering
  1560.  
  1561.     EXPLAIN
  1562.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1563.     1   SIMPLE  m   REF PRIMARY,published,newsfeeds published   1   const   26  USING WHERE; USING filesort
  1564.     1   SIMPLE  mm  REF PRIMARY PRIMARY 4   m31.m.id    1   USING WHERE; USING INDEX
  1565.     1   SIMPLE  e   REF element_clientid,element_folder_clientid    element_clientid    303 m31.m.module,const  1   USING WHERE
  1566.     Profile
  1567.     STATUS  Duration
  1568.     starting    0.0 ms
  1569.     Waiting FOR query cache LOCK    0.0 ms
  1570.     checking query cache FOR query  0.1 ms
  1571.     checking permissions    0.0 ms
  1572.     checking permissions    0.0 ms
  1573.     checking permissions    0.0 ms
  1574.     Opening TABLES  0.0 ms
  1575.     System LOCK 0.0 ms
  1576.     Waiting FOR query cache LOCK    0.0 ms
  1577.     init    0.1 ms
  1578.     optimizing  0.0 ms
  1579.     statistics  0.1 ms
  1580.     preparing   0.0 ms
  1581.     executing   0.0 ms
  1582.     Sorting RESULT  0.2 ms
  1583.     Sending DATA    0.3 ms
  1584.     END 0.0 ms
  1585.     query END   0.0 ms
  1586.     closing TABLES  0.0 ms
  1587.     freeing items   0.0 ms
  1588.     Waiting FOR query cache LOCK    0.0 ms
  1589.     freeing items   0.0 ms
  1590.     Waiting FOR query cache LOCK    0.0 ms
  1591.     freeing items   0.0 ms
  1592.     storing RESULT IN query cache   0.0 ms
  1593.     logging slow query  0.0 ms
  1594.     cleaning up 0.0 ms
  1595.     CALL Stack
  1596.     JROOT/libraries/legacy/module/helper.php:348
  1597.     JROOT/libraries/legacy/module/helper.php:84
  1598.     JROOT/libraries/joomla/document/html/html.php:502
  1599.     JROOT/templates/protostar/INDEX.php:51
  1600.     JROOT/libraries/joomla/document/html/html.php:570
  1601.     JROOT/libraries/joomla/document/html/html.php:630
  1602.     JROOT/libraries/joomla/document/html/html.php:452
  1603.     JROOT/includes/application.php:278
  1604.     JROOT/INDEX.php:58
  1605.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1606.     Query TIME: 0.20 ms After LAST query: 5.06 ms Query memory: 0.009 MB Memory BEFORE query: 2.200 MB ROWS returned: 4
  1607.  
  1608.     SELECT id, rules
  1609.  
  1610.       FROM `w0z9v_viewlevels`
  1611.  
  1612.     EXPLAIN
  1613.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1614.     1   SIMPLE  w0z9v_viewlevels    ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    4  
  1615.     Profile
  1616.     STATUS  Duration
  1617.     starting    0.0 ms
  1618.     Waiting FOR query cache LOCK    0.0 ms
  1619.     checking query cache FOR query  0.0 ms
  1620.     checking privileges ON cached   0.0 ms
  1621.     checking permissions    0.0 ms
  1622.     sending cached RESULT TO clien  2.6 ms
  1623.     logging slow query  0.0 ms
  1624.     cleaning up 0.0 ms
  1625.     CALL Stack
  1626.     JROOT/libraries/joomla/access/access.php:422
  1627.     JROOT/modules/mod_articles_latest/helper.php:44
  1628.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  1629.     JROOT/libraries/legacy/module/helper.php:176
  1630.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  1631.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  1632.     JROOT/libraries/joomla/document/html/html.php:408
  1633.     JROOT/libraries/joomla/document/html/html.php:692
  1634.     JROOT/libraries/joomla/document/html/html.php:471
  1635.     JROOT/includes/application.php:291
  1636.     JROOT/INDEX.php:58
  1637.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1638.     Query TIME: 358.59 ms After LAST query: 2.52 ms Query memory: 0.010 MB Memory BEFORE query: 2.220 MB ROWS returned: 10
  1639.  
  1640.     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,
  1641.       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,
  1642.       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,
  1643.       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,
  1644.       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,
  1645.       CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
  1646.  
  1647.       FROM w0z9v_content AS a
  1648.  
  1649.       LEFT JOIN w0z9v_content_frontpage AS fp
  1650.       ON fp.content_id = a.id
  1651.  
  1652.       LEFT JOIN w0z9v_categories AS c
  1653.       ON c.id = a.catid
  1654.  
  1655.       LEFT JOIN w0z9v_users AS ua
  1656.       ON ua.id = a.created_by
  1657.  
  1658.       LEFT JOIN w0z9v_users AS uam
  1659.       ON uam.id = a.modified_by
  1660.  
  1661.       LEFT JOIN (
  1662.     SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  1663.  
  1664.       FROM w0z9v_contact_details AS contact
  1665.  
  1666.       WHERE contact.published = 1
  1667.  
  1668.       GROUP BY contact.user_id, contact.LANGUAGE) AS contact
  1669.       ON contact.user_id = a.created_by
  1670.  
  1671.       LEFT JOIN w0z9v_categories AS parent
  1672.       ON parent.id = c.parent_id
  1673.  
  1674.       LEFT JOIN w0z9v_content_rating AS v
  1675.       ON a.id = v.content_id
  1676.  
  1677.       LEFT
  1678.       OUTER JOIN (SELECT cat.id AS id
  1679.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  1680.       ON cat.lft BETWEEN parent.lft
  1681.       AND parent.rgt
  1682.       WHERE parent.extension = 'com_content'
  1683.       AND parent.published != 1
  1684.       GROUP BY cat.id ) AS badcats
  1685.       ON badcats.id = c.id
  1686.  
  1687.       WHERE a.access IN (1,1,5)
  1688.       AND c.access IN (1,1,5)
  1689.       AND
  1690.       CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END = 1
  1691.       AND a.catid IN (8,10,11,12,13)
  1692.       AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-13 22:16:13')
  1693.       AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-13 22:16:13')
  1694.  
  1695.       ORDER BY a.created DESC
  1696.       LIMIT 0, 10
  1697.  
  1698.     EXPLAIN
  1699.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1700.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  1701.     1   PRIMARY <derived3>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  1702.     1   PRIMARY a   range   idx_access,idx_catid    idx_access  4   NULL    22680   USING WHERE; USING filesort
  1703.     1   PRIMARY fp  eq_ref  PRIMARY PRIMARY 4   m31.a.id    1   USING INDEX
  1704.     1   PRIMARY c   eq_ref  PRIMARY,idx_access  PRIMARY 4   m31.a.catid 1   USING WHERE
  1705.     1   PRIMARY parent  eq_ref  PRIMARY PRIMARY 4   m31.c.parent_id 1  
  1706.     1   PRIMARY v   eq_ref  PRIMARY PRIMARY 4   m31.a.id    1  
  1707.     1   PRIMARY ua  eq_ref  PRIMARY PRIMARY 4   m31.a.created_by    1  
  1708.     1   PRIMARY uam eq_ref  PRIMARY PRIMARY 4   m31.a.modified_by   1  
  1709.     3   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  1710.     3   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  1711.     2   DERIVED contact REF idx_state   idx_state   1       1   USING WHERE; USING TEMPORARY; USING filesort
  1712.     Profile
  1713.     STATUS  Duration
  1714.     starting    0.0 ms
  1715.     Waiting FOR query cache LOCK    0.0 ms
  1716.     checking query cache FOR query  0.3 ms
  1717.     checking permissions    0.0 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.     Opening TABLES  0.1 ms
  1728.     System LOCK 0.1 ms
  1729.     optimizing  0.0 ms
  1730.     statistics  0.1 ms
  1731.     preparing   0.0 ms
  1732.     Creating tmp TABLE  0.0 ms
  1733.     executing   0.0 ms
  1734.     Copying TO tmp TABLE    0.0 ms
  1735.     Sorting RESULT  0.0 ms
  1736.     Sending DATA    0.0 ms
  1737.     optimizing  0.0 ms
  1738.     statistics  0.1 ms
  1739.     preparing   0.0 ms
  1740.     Creating tmp TABLE  0.0 ms
  1741.     executing   0.0 ms
  1742.     Copying TO tmp TABLE    0.1 ms
  1743.     Sorting RESULT  0.0 ms
  1744.     Sending DATA    0.0 ms
  1745.     removing tmp TABLE  0.0 ms
  1746.     Sending DATA    0.0 ms
  1747.     removing tmp TABLE  0.0 ms
  1748.     Sending DATA    0.0 ms
  1749.     Waiting FOR query cache LOCK    0.0 ms
  1750.     Sending DATA    0.1 ms
  1751.     init    0.1 ms
  1752.     optimizing  0.0 ms
  1753.     statistics  0.2 ms
  1754.     preparing   0.1 ms
  1755.     executing   0.0 ms
  1756.     Sorting RESULT  355.9 ms
  1757.     Sending DATA    0.6 ms
  1758.     Waiting FOR query cache LOCK    0.0 ms
  1759.     Sending DATA    0.1 ms
  1760.     END 0.0 ms
  1761.     query END   0.0 ms
  1762.     closing TABLES  0.0 ms
  1763.     removing tmp TABLE  0.0 ms
  1764.     closing TABLES  0.0 ms
  1765.     removing tmp TABLE  0.0 ms
  1766.     closing TABLES  0.0 ms
  1767.     freeing items   0.0 ms
  1768.     Waiting FOR query cache LOCK    0.0 ms
  1769.     freeing items   0.0 ms
  1770.     Waiting FOR query cache LOCK    0.0 ms
  1771.     freeing items   0.0 ms
  1772.     storing RESULT IN query cache   0.0 ms
  1773.     logging slow query  0.0 ms
  1774.     cleaning up 0.0 ms
  1775.     CALL Stack
  1776.     JROOT/libraries/legacy/model/legacy.php:301
  1777.     JROOT/libraries/legacy/model/list.php:129
  1778.     JROOT/components/com_content/models/articles.php:522
  1779.     JROOT/modules/mod_articles_latest/helper.php:100
  1780.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  1781.     JROOT/libraries/legacy/module/helper.php:176
  1782.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  1783.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  1784.     JROOT/libraries/joomla/document/html/html.php:408
  1785.     JROOT/libraries/joomla/document/html/html.php:692
  1786.     JROOT/libraries/joomla/document/html/html.php:471
  1787.     JROOT/includes/application.php:291
  1788.     JROOT/INDEX.php:58
  1789.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1790.     Query TIME: 0.21 ms After LAST query: 4.65 ms Query memory: 0.010 MB Memory BEFORE query: 2.300 MB ROWS returned: 0
  1791.  
  1792.     SELECT `m`.`tag_id`,`t`.*
  1793.  
  1794.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  1795.  
  1796.       WHERE `m`.`tag_id` = `t`.`id`
  1797.       AND `ct`.`type_id` = `m`.`type_id`
  1798.       AND `ct`.`type_alias` = 'com_content.article'
  1799.       AND `m`.`content_item_id` = 59079
  1800.       AND `t`.`published` = 1
  1801.       AND t.access IN (1,1,5)
  1802.  
  1803.     EXPLAIN
  1804.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1805.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  1806.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  1807.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  1808.     Profile
  1809.     STATUS  Duration
  1810.     starting    0.0 ms
  1811.     Waiting FOR query cache LOCK    0.0 ms
  1812.     checking query cache FOR query  0.0 ms
  1813.     checking privileges ON cached   0.0 ms
  1814.     checking permissions    0.0 ms
  1815.     checking permissions    0.0 ms
  1816.     checking permissions    0.0 ms
  1817.     sending cached RESULT TO clien  0.0 ms
  1818.     logging slow query  0.0 ms
  1819.     cleaning up 0.0 ms
  1820.     CALL Stack
  1821.     JROOT/libraries/cms/helper/tags.php:409
  1822.     JROOT/components/com_content/models/articles.php:648
  1823.     JROOT/modules/mod_articles_latest/helper.php:100
  1824.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  1825.     JROOT/libraries/legacy/module/helper.php:176
  1826.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  1827.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  1828.     JROOT/libraries/joomla/document/html/html.php:408
  1829.     JROOT/libraries/joomla/document/html/html.php:692
  1830.     JROOT/libraries/joomla/document/html/html.php:471
  1831.     JROOT/includes/application.php:291
  1832.     JROOT/INDEX.php:58
  1833.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1834.     Query TIME: 0.18 ms After LAST query: 1.65 ms Query memory: 0.010 MB Memory BEFORE query: 2.319 MB ROWS returned: 0
  1835.  
  1836.     SELECT `m`.`tag_id`,`t`.*
  1837.  
  1838.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  1839.  
  1840.       WHERE `m`.`tag_id` = `t`.`id`
  1841.       AND `ct`.`type_id` = `m`.`type_id`
  1842.       AND `ct`.`type_alias` = 'com_content.article'
  1843.       AND `m`.`content_item_id` = 59078
  1844.       AND `t`.`published` = 1
  1845.       AND t.access IN (1,1,5)
  1846.  
  1847.     EXPLAIN
  1848.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1849.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  1850.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  1851.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  1852.     Profile
  1853.     STATUS  Duration
  1854.     starting    0.0 ms
  1855.     Waiting FOR query cache LOCK    0.0 ms
  1856.     checking query cache FOR query  0.0 ms
  1857.     checking privileges ON cached   0.0 ms
  1858.     checking permissions    0.0 ms
  1859.     checking permissions    0.0 ms
  1860.     checking permissions    0.0 ms
  1861.     sending cached RESULT TO clien  0.0 ms
  1862.     logging slow query  0.0 ms
  1863.     cleaning up 0.0 ms
  1864.     CALL Stack
  1865.     JROOT/libraries/cms/helper/tags.php:409
  1866.     JROOT/components/com_content/models/articles.php:648
  1867.     JROOT/modules/mod_articles_latest/helper.php:100
  1868.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  1869.     JROOT/libraries/legacy/module/helper.php:176
  1870.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  1871.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  1872.     JROOT/libraries/joomla/document/html/html.php:408
  1873.     JROOT/libraries/joomla/document/html/html.php:692
  1874.     JROOT/libraries/joomla/document/html/html.php:471
  1875.     JROOT/includes/application.php:291
  1876.     JROOT/INDEX.php:58
  1877.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1878.     Query TIME: 0.17 ms After LAST query: 1.61 ms Query memory: 0.009 MB Memory BEFORE query: 2.339 MB ROWS returned: 0
  1879.  
  1880.     SELECT `m`.`tag_id`,`t`.*
  1881.  
  1882.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  1883.  
  1884.       WHERE `m`.`tag_id` = `t`.`id`
  1885.       AND `ct`.`type_id` = `m`.`type_id`
  1886.       AND `ct`.`type_alias` = 'com_content.article'
  1887.       AND `m`.`content_item_id` = 59077
  1888.       AND `t`.`published` = 1
  1889.       AND t.access IN (1,1,5)
  1890.  
  1891.     EXPLAIN
  1892.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1893.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  1894.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  1895.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  1896.     Profile
  1897.     STATUS  Duration
  1898.     starting    0.0 ms
  1899.     Waiting FOR query cache LOCK    0.0 ms
  1900.     checking query cache FOR query  0.0 ms
  1901.     checking privileges ON cached   0.0 ms
  1902.     checking permissions    0.0 ms
  1903.     checking permissions    0.0 ms
  1904.     checking permissions    0.0 ms
  1905.     sending cached RESULT TO clien  0.0 ms
  1906.     logging slow query  0.0 ms
  1907.     cleaning up 0.0 ms
  1908.     CALL Stack
  1909.     JROOT/libraries/cms/helper/tags.php:409
  1910.     JROOT/components/com_content/models/articles.php:648
  1911.     JROOT/modules/mod_articles_latest/helper.php:100
  1912.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  1913.     JROOT/libraries/legacy/module/helper.php:176
  1914.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  1915.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  1916.     JROOT/libraries/joomla/document/html/html.php:408
  1917.     JROOT/libraries/joomla/document/html/html.php:692
  1918.     JROOT/libraries/joomla/document/html/html.php:471
  1919.     JROOT/includes/application.php:291
  1920.     JROOT/INDEX.php:58
  1921.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1922.     Query TIME: 0.18 ms After LAST query: 1.62 ms Query memory: 0.009 MB Memory BEFORE query: 2.358 MB ROWS returned: 0
  1923.  
  1924.     SELECT `m`.`tag_id`,`t`.*
  1925.  
  1926.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  1927.  
  1928.       WHERE `m`.`tag_id` = `t`.`id`
  1929.       AND `ct`.`type_id` = `m`.`type_id`
  1930.       AND `ct`.`type_alias` = 'com_content.article'
  1931.       AND `m`.`content_item_id` = 59076
  1932.       AND `t`.`published` = 1
  1933.       AND t.access IN (1,1,5)
  1934.  
  1935.     EXPLAIN
  1936.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1937.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  1938.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  1939.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  1940.     Profile
  1941.     STATUS  Duration
  1942.     starting    0.0 ms
  1943.     Waiting FOR query cache LOCK    0.0 ms
  1944.     checking query cache FOR query  0.0 ms
  1945.     checking privileges ON cached   0.0 ms
  1946.     checking permissions    0.0 ms
  1947.     checking permissions    0.0 ms
  1948.     checking permissions    0.0 ms
  1949.     sending cached RESULT TO clien  0.0 ms
  1950.     logging slow query  0.0 ms
  1951.     cleaning up 0.0 ms
  1952.     CALL Stack
  1953.     JROOT/libraries/cms/helper/tags.php:409
  1954.     JROOT/components/com_content/models/articles.php:648
  1955.     JROOT/modules/mod_articles_latest/helper.php:100
  1956.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  1957.     JROOT/libraries/legacy/module/helper.php:176
  1958.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  1959.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  1960.     JROOT/libraries/joomla/document/html/html.php:408
  1961.     JROOT/libraries/joomla/document/html/html.php:692
  1962.     JROOT/libraries/joomla/document/html/html.php:471
  1963.     JROOT/includes/application.php:291
  1964.     JROOT/INDEX.php:58
  1965.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1966.     Query TIME: 0.17 ms After LAST query: 1.62 ms Query memory: 0.009 MB Memory BEFORE query: 2.377 MB ROWS returned: 0
  1967.  
  1968.     SELECT `m`.`tag_id`,`t`.*
  1969.  
  1970.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  1971.  
  1972.       WHERE `m`.`tag_id` = `t`.`id`
  1973.       AND `ct`.`type_id` = `m`.`type_id`
  1974.       AND `ct`.`type_alias` = 'com_content.article'
  1975.       AND `m`.`content_item_id` = 59075
  1976.       AND `t`.`published` = 1
  1977.       AND t.access IN (1,1,5)
  1978.  
  1979.     EXPLAIN
  1980.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  1981.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  1982.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  1983.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  1984.     Profile
  1985.     STATUS  Duration
  1986.     starting    0.0 ms
  1987.     Waiting FOR query cache LOCK    0.0 ms
  1988.     checking query cache FOR query  0.0 ms
  1989.     checking privileges ON cached   0.0 ms
  1990.     checking permissions    0.0 ms
  1991.     checking permissions    0.0 ms
  1992.     checking permissions    0.0 ms
  1993.     sending cached RESULT TO clien  0.0 ms
  1994.     logging slow query  0.0 ms
  1995.     cleaning up 0.0 ms
  1996.     CALL Stack
  1997.     JROOT/libraries/cms/helper/tags.php:409
  1998.     JROOT/components/com_content/models/articles.php:648
  1999.     JROOT/modules/mod_articles_latest/helper.php:100
  2000.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  2001.     JROOT/libraries/legacy/module/helper.php:176
  2002.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  2003.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  2004.     JROOT/libraries/joomla/document/html/html.php:408
  2005.     JROOT/libraries/joomla/document/html/html.php:692
  2006.     JROOT/libraries/joomla/document/html/html.php:471
  2007.     JROOT/includes/application.php:291
  2008.     JROOT/INDEX.php:58
  2009.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  2010.     Query TIME: 0.18 ms After LAST query: 1.67 ms Query memory: 0.009 MB Memory BEFORE query: 2.397 MB ROWS returned: 0
  2011.  
  2012.     SELECT `m`.`tag_id`,`t`.*
  2013.  
  2014.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  2015.  
  2016.       WHERE `m`.`tag_id` = `t`.`id`
  2017.       AND `ct`.`type_id` = `m`.`type_id`
  2018.       AND `ct`.`type_alias` = 'com_content.article'
  2019.       AND `m`.`content_item_id` = 58868
  2020.       AND `t`.`published` = 1
  2021.       AND t.access IN (1,1,5)
  2022.  
  2023.     EXPLAIN
  2024.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  2025.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  2026.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  2027.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  2028.     Profile
  2029.     STATUS  Duration
  2030.     starting    0.0 ms
  2031.     Waiting FOR query cache LOCK    0.0 ms
  2032.     checking query cache FOR query  0.0 ms
  2033.     checking privileges ON cached   0.0 ms
  2034.     checking permissions    0.0 ms
  2035.     checking permissions    0.0 ms
  2036.     checking permissions    0.0 ms
  2037.     sending cached RESULT TO clien  0.0 ms
  2038.     logging slow query  0.0 ms
  2039.     cleaning up 0.0 ms
  2040.     CALL Stack
  2041.     JROOT/libraries/cms/helper/tags.php:409
  2042.     JROOT/components/com_content/models/articles.php:648
  2043.     JROOT/modules/mod_articles_latest/helper.php:100
  2044.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  2045.     JROOT/libraries/legacy/module/helper.php:176
  2046.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  2047.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  2048.     JROOT/libraries/joomla/document/html/html.php:408
  2049.     JROOT/libraries/joomla/document/html/html.php:692
  2050.     JROOT/libraries/joomla/document/html/html.php:471
  2051.     JROOT/includes/application.php:291
  2052.     JROOT/INDEX.php:58
  2053.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  2054.     Query TIME: 0.18 ms After LAST query: 1.59 ms Query memory: 0.009 MB Memory BEFORE query: 2.416 MB ROWS returned: 0
  2055.  
  2056.     SELECT `m`.`tag_id`,`t`.*
  2057.  
  2058.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  2059.  
  2060.       WHERE `m`.`tag_id` = `t`.`id`
  2061.       AND `ct`.`type_id` = `m`.`type_id`
  2062.       AND `ct`.`type_alias` = 'com_content.article'
  2063.       AND `m`.`content_item_id` = 58676
  2064.       AND `t`.`published` = 1
  2065.       AND t.access IN (1,1,5)
  2066.  
  2067.     EXPLAIN
  2068.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  2069.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  2070.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  2071.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  2072.     Profile
  2073.     STATUS  Duration
  2074.     starting    0.0 ms
  2075.     Waiting FOR query cache LOCK    0.0 ms
  2076.     checking query cache FOR query  0.0 ms
  2077.     checking privileges ON cached   0.0 ms
  2078.     checking permissions    0.0 ms
  2079.     checking permissions    0.0 ms
  2080.     checking permissions    0.0 ms
  2081.     sending cached RESULT TO clien  0.0 ms
  2082.     logging slow query  0.0 ms
  2083.     cleaning up 0.0 ms
  2084.     CALL Stack
  2085.     JROOT/libraries/cms/helper/tags.php:409
  2086.     JROOT/components/com_content/models/articles.php:648
  2087.     JROOT/modules/mod_articles_latest/helper.php:100
  2088.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  2089.     JROOT/libraries/legacy/module/helper.php:176
  2090.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  2091.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  2092.     JROOT/libraries/joomla/document/html/html.php:408
  2093.     JROOT/libraries/joomla/document/html/html.php:692
  2094.     JROOT/libraries/joomla/document/html/html.php:471
  2095.     JROOT/includes/application.php:291
  2096.     JROOT/INDEX.php:58
  2097.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  2098.     Query TIME: 0.19 ms After LAST query: 1.59 ms Query memory: 0.009 MB Memory BEFORE query: 2.436 MB ROWS returned: 0
  2099.  
  2100.     SELECT `m`.`tag_id`,`t`.*
  2101.  
  2102.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  2103.  
  2104.       WHERE `m`.`tag_id` = `t`.`id`
  2105.       AND `ct`.`type_id` = `m`.`type_id`
  2106.       AND `ct`.`type_alias` = 'com_content.article'
  2107.       AND `m`.`content_item_id` = 33109
  2108.       AND `t`.`published` = 1
  2109.       AND t.access IN (1,1,5)
  2110.  
  2111.     EXPLAIN
  2112.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  2113.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  2114.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  2115.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  2116.     Profile
  2117.     STATUS  Duration
  2118.     starting    0.0 ms
  2119.     Waiting FOR query cache LOCK    0.0 ms
  2120.     checking query cache FOR query  0.0 ms
  2121.     checking privileges ON cached   0.0 ms
  2122.     checking permissions    0.0 ms
  2123.     checking permissions    0.0 ms
  2124.     checking permissions    0.0 ms
  2125.     sending cached RESULT TO clien  0.0 ms
  2126.     logging slow query  0.0 ms
  2127.     cleaning up 0.0 ms
  2128.     CALL Stack
  2129.     JROOT/libraries/cms/helper/tags.php:409
  2130.     JROOT/components/com_content/models/articles.php:648
  2131.     JROOT/modules/mod_articles_latest/helper.php:100
  2132.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  2133.     JROOT/libraries/legacy/module/helper.php:176
  2134.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  2135.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  2136.     JROOT/libraries/joomla/document/html/html.php:408
  2137.     JROOT/libraries/joomla/document/html/html.php:692
  2138.     JROOT/libraries/joomla/document/html/html.php:471
  2139.     JROOT/includes/application.php:291
  2140.     JROOT/INDEX.php:58
  2141.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  2142.     Query TIME: 0.18 ms After LAST query: 1.59 ms Query memory: 0.009 MB Memory BEFORE query: 2.455 MB ROWS returned: 0
  2143.  
  2144.     SELECT `m`.`tag_id`,`t`.*
  2145.  
  2146.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  2147.  
  2148.       WHERE `m`.`tag_id` = `t`.`id`
  2149.       AND `ct`.`type_id` = `m`.`type_id`
  2150.       AND `ct`.`type_alias` = 'com_content.article'
  2151.       AND `m`.`content_item_id` = 33080
  2152.       AND `t`.`published` = 1
  2153.       AND t.access IN (1,1,5)
  2154.  
  2155.     EXPLAIN
  2156.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  2157.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  2158.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  2159.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  2160.     Profile
  2161.     STATUS  Duration
  2162.     starting    0.0 ms
  2163.     Waiting FOR query cache LOCK    0.0 ms
  2164.     checking query cache FOR query  0.0 ms
  2165.     checking privileges ON cached   0.0 ms
  2166.     checking permissions    0.0 ms
  2167.     checking permissions    0.0 ms
  2168.     checking permissions    0.0 ms
  2169.     sending cached RESULT TO clien  0.0 ms
  2170.     logging slow query  0.0 ms
  2171.     cleaning up 0.0 ms
  2172.     CALL Stack
  2173.     JROOT/libraries/cms/helper/tags.php:409
  2174.     JROOT/components/com_content/models/articles.php:648
  2175.     JROOT/modules/mod_articles_latest/helper.php:100
  2176.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  2177.     JROOT/libraries/legacy/module/helper.php:176
  2178.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  2179.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  2180.     JROOT/libraries/joomla/document/html/html.php:408
  2181.     JROOT/libraries/joomla/document/html/html.php:692
  2182.     JROOT/libraries/joomla/document/html/html.php:471
  2183.     JROOT/includes/application.php:291
  2184.     JROOT/INDEX.php:58
  2185.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  2186.     Query TIME: 0.17 ms After LAST query: 1.60 ms Query memory: 0.009 MB Memory BEFORE query: 2.474 MB ROWS returned: 0
  2187.  
  2188.     SELECT `m`.`tag_id`,`t`.*
  2189.  
  2190.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  2191.  
  2192.       WHERE `m`.`tag_id` = `t`.`id`
  2193.       AND `ct`.`type_id` = `m`.`type_id`
  2194.       AND `ct`.`type_alias` = 'com_content.article'
  2195.       AND `m`.`content_item_id` = 33008
  2196.       AND `t`.`published` = 1
  2197.       AND t.access IN (1,1,5)
  2198.  
  2199.     EXPLAIN
  2200.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  2201.     1   SIMPLE  ct  REF PRIMARY,idx_alias   idx_alias   767 const   1   USING WHERE; USING INDEX
  2202.     1   SIMPLE  m   REF uc_ItemnameTagid,idx_tag_type,idx_tag,idx_type  uc_ItemnameTagid    7   m31.ct.type_id,const    1   USING WHERE; USING INDEX
  2203.     1   SIMPLE  t   eq_ref  PRIMARY,tag_idx,idx_access  PRIMARY 4   m31.m.tag_id    1   USING WHERE
  2204.     Profile
  2205.     STATUS  Duration
  2206.     starting    0.0 ms
  2207.     Waiting FOR query cache LOCK    0.0 ms
  2208.     checking query cache FOR query  0.0 ms
  2209.     checking privileges ON cached   0.0 ms
  2210.     checking permissions    0.0 ms
  2211.     checking permissions    0.0 ms
  2212.     checking permissions    0.0 ms
  2213.     sending cached RESULT TO clien  0.0 ms
  2214.     logging slow query  0.0 ms
  2215.     cleaning up 0.0 ms
  2216.     CALL Stack
  2217.     JROOT/libraries/cms/helper/tags.php:409
  2218.     JROOT/components/com_content/models/articles.php:648
  2219.     JROOT/modules/mod_articles_latest/helper.php:100
  2220.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  2221.     JROOT/libraries/legacy/module/helper.php:176
  2222.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  2223.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  2224.     JROOT/libraries/joomla/document/html/html.php:408
  2225.     JROOT/libraries/joomla/document/html/html.php:692
  2226.     JROOT/libraries/joomla/document/html/html.php:471
  2227.     JROOT/includes/application.php:291
  2228.     JROOT/INDEX.php:58
  2229.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  2230.     Query TIME: 1.38 ms After LAST query: 0.93 ms Query memory: 0.010 MB Memory BEFORE query: 2.488 MB ROWS returned: 3
  2231.  
  2232.     SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  2233.                 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  2234.                 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  2235.                 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
  2236.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
  2237.  
  2238.       FROM w0z9v_categories AS c
  2239.  
  2240.       LEFT JOIN w0z9v_categories AS s
  2241.       ON (s.lft <= c.lft
  2242.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  2243.       AND s.rgt < c.rgt)
  2244.  
  2245.       LEFT JOIN  (SELECT cat.id AS id
  2246.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  2247.       ON cat.lft BETWEEN parent.lft
  2248.       AND parent.rgt
  2249.       WHERE parent.extension = 'com_content'
  2250.       AND parent.published != 1
  2251.       GROUP BY cat.id) AS badcats
  2252.       ON badcats.id = c.id
  2253.  
  2254.       WHERE (c.extension='com_content' OR c.extension='system')
  2255.       AND c.access IN (1,1,5)
  2256.       AND c.published = 1
  2257.       AND s.id=11
  2258.       AND badcats.id IS NULL
  2259.  
  2260.       GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  2261.                  c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  2262.                  c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  2263.                  c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
  2264.  
  2265.       ORDER BY c.lft
  2266.  
  2267.     EXPLAIN
  2268.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  2269.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  2270.     1   PRIMARY s   const   PRIMARY,idx_left_right  PRIMARY 4   const   1   USING filesort
  2271.     1   PRIMARY c   ALL cat_idx,idx_access,idx_left_right   NO INDEX KEY COULD BE USED  NULL    NULL    13  USING WHERE
  2272.     2   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  2273.     2   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  2274.     Profile
  2275.     STATUS  Duration
  2276.     starting    0.0 ms
  2277.     Waiting FOR query cache LOCK    0.0 ms
  2278.     checking query cache FOR query  0.2 ms
  2279.     checking permissions    0.0 ms
  2280.     checking permissions    0.0 ms
  2281.     checking permissions    0.0 ms
  2282.     checking permissions    0.0 ms
  2283.     Opening TABLES  0.0 ms
  2284.     System LOCK 0.1 ms
  2285.     optimizing  0.0 ms
  2286.     statistics  0.1 ms
  2287.     preparing   0.0 ms
  2288.     Creating tmp TABLE  0.0 ms
  2289.     executing   0.0 ms
  2290.     Copying TO tmp TABLE    0.1 ms
  2291.     Sorting RESULT  0.0 ms
  2292.     Sending DATA    0.0 ms
  2293.     removing tmp TABLE  0.0 ms
  2294.     Sending DATA    0.0 ms
  2295.     Waiting FOR query cache LOCK    0.0 ms
  2296.     Sending DATA    0.0 ms
  2297.     init    0.1 ms
  2298.     optimizing  0.0 ms
  2299.     statistics  0.1 ms
  2300.     preparing   0.0 ms
  2301.     executing   0.0 ms
  2302.     Sorting RESULT  0.1 ms
  2303.     Sending DATA    0.1 ms
  2304.     END 0.0 ms
  2305.     query END   0.0 ms
  2306.     closing TABLES  0.0 ms
  2307.     removing tmp TABLE  0.0 ms
  2308.     closing TABLES  0.0 ms
  2309.     freeing items   0.0 ms
  2310.     Waiting FOR query cache LOCK    0.0 ms
  2311.     freeing items   0.0 ms
  2312.     Waiting FOR query cache LOCK    0.0 ms
  2313.     freeing items   0.0 ms
  2314.     storing RESULT IN query cache   0.0 ms
  2315.     logging slow query  0.0 ms
  2316.     cleaning up 0.0 ms
  2317.     CALL Stack
  2318.     JROOT/libraries/legacy/categories/categories.php:288
  2319.     JROOT/libraries/legacy/categories/categories.php:181
  2320.     JROOT/components/com_content/helpers/route.php:37
  2321.     JROOT/modules/mod_articles_latest/helper.php:110
  2322.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  2323.     JROOT/libraries/legacy/module/helper.php:176
  2324.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  2325.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  2326.     JROOT/libraries/joomla/document/html/html.php:408
  2327.     JROOT/libraries/joomla/document/html/html.php:692
  2328.     JROOT/libraries/joomla/document/html/html.php:471
  2329.     JROOT/includes/application.php:291
  2330.     JROOT/INDEX.php:58
  2331.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  2332.     Query TIME: 1.60 ms After LAST query: 5.86 ms Query memory: 0.010 MB Memory BEFORE query: 2.506 MB ROWS returned: 3
  2333.  
  2334.     SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  2335.                 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  2336.                 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  2337.                 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
  2338.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
  2339.  
  2340.       FROM w0z9v_categories AS c
  2341.  
  2342.       LEFT JOIN w0z9v_categories AS s
  2343.       ON (s.lft <= c.lft
  2344.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  2345.       AND s.rgt < c.rgt)
  2346.  
  2347.       LEFT JOIN  (SELECT cat.id AS id
  2348.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  2349.       ON cat.lft BETWEEN parent.lft
  2350.       AND parent.rgt
  2351.       WHERE parent.extension = 'com_content'
  2352.       AND parent.published != 1
  2353.       GROUP BY cat.id) AS badcats
  2354.       ON badcats.id = c.id
  2355.  
  2356.       WHERE (c.extension='com_content' OR c.extension='system')
  2357.       AND c.access IN (1,1,5)
  2358.       AND c.published = 1
  2359.       AND s.id=13
  2360.       AND badcats.id IS NULL
  2361.  
  2362.       GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  2363.                  c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  2364.                  c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  2365.                  c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
  2366.  
  2367.       ORDER BY c.lft
  2368.  
  2369.     EXPLAIN
  2370.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  2371.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  2372.     1   PRIMARY s   const   PRIMARY,idx_left_right  PRIMARY 4   const   1   USING filesort
  2373.     1   PRIMARY c   ALL cat_idx,idx_access,idx_left_right   NO INDEX KEY COULD BE USED  NULL    NULL    13  USING WHERE
  2374.     2   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  2375.     2   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  2376.     Profile
  2377.     STATUS  Duration
  2378.     starting    0.0 ms
  2379.     Waiting FOR query cache LOCK    0.0 ms
  2380.     checking query cache FOR query  0.3 ms
  2381.     checking permissions    0.0 ms
  2382.     checking permissions    0.0 ms
  2383.     checking permissions    0.0 ms
  2384.     checking permissions    0.0 ms
  2385.     Opening TABLES  0.0 ms
  2386.     System LOCK 0.1 ms
  2387.     optimizing  0.0 ms
  2388.     statistics  0.1 ms
  2389.     preparing   0.0 ms
  2390.     Creating tmp TABLE  0.0 ms
  2391.     executing   0.0 ms
  2392.     Copying TO tmp TABLE    0.1 ms
  2393.     Sorting RESULT  0.0 ms
  2394.     Sending DATA    0.0 ms
  2395.     removing tmp TABLE  0.0 ms
  2396.     Sending DATA    0.0 ms
  2397.     Waiting FOR query cache LOCK    0.0 ms
  2398.     Sending DATA    0.0 ms
  2399.     init    0.1 ms
  2400.     optimizing  0.0 ms
  2401.     statistics  0.1 ms
  2402.     preparing   0.0 ms
  2403.     executing   0.0 ms
  2404.     Sorting RESULT  0.1 ms
  2405.     Sending DATA    0.1 ms
  2406.     END 0.0 ms
  2407.     query END   0.0 ms
  2408.     closing TABLES  0.0 ms
  2409.     removing tmp TABLE  0.0 ms
  2410.     closing TABLES  0.0 ms
  2411.     freeing items   0.0 ms
  2412.     Waiting FOR query cache LOCK    0.0 ms
  2413.     freeing items   0.2 ms
  2414.     Waiting FOR query cache LOCK    0.0 ms
  2415.     freeing items   0.0 ms
  2416.     storing RESULT IN query cache   0.0 ms
  2417.     logging slow query  0.0 ms
  2418.     cleaning up 0.0 ms
  2419.     CALL Stack
  2420.     JROOT/libraries/legacy/categories/categories.php:288
  2421.     JROOT/libraries/legacy/categories/categories.php:181
  2422.     JROOT/components/com_content/helpers/route.php:37
  2423.     JROOT/modules/mod_articles_latest/helper.php:110
  2424.     JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
  2425.     JROOT/libraries/legacy/module/helper.php:176
  2426.     JROOT/libraries/joomla/document/html/renderer/module.php:105
  2427.     JROOT/libraries/joomla/document/html/renderer/modules.php:39
  2428.     JROOT/libraries/joomla/document/html/html.php:408
  2429.     JROOT/libraries/joomla/document/html/html.php:692
  2430.     JROOT/libraries/joomla/document/html/html.php:471
  2431.     JROOT/includes/application.php:291
  2432.     JROOT/INDEX.php:58
  2433.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  2434.     Query TIME: 35.93 ms After LAST query: 24.40 ms Query memory: 0.002 MB Memory BEFORE query: 2.426 MB
  2435.  
  2436.     UPDATE `w0z9v_session`
  2437.  
  2438.       SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1373753310;s:18:\"session.timer.last\";i:1373753765;s:17:\"session.timer.now\";i:1373753773;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.2; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"fc426c6ade21a0b8e3600169883dbe70\";}'
  2439.         , `time` = '1373753774'
  2440.  
  2441.       WHERE `session_id` = 'bpm9s8014lqv89rh61r9h69tq3'
  2442.  
  2443.     EXPLAIN
  2444.     EXPLAIN NOT possible ON query: UPDATE `w0z9v_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1373753310;s:18:\"session.timer.last\";i:1373753765;s:17:\"session.timer.now\";i:1373753773;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.2; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"fc426c6ade21a0b8e3600169883dbe70\";}' , `time` = '1373753774' WHERE `session_id` = 'bpm9s8014lqv89rh61r9h69tq3'
  2445.     Profile
  2446.     STATUS  Duration
  2447.     starting    0.1 ms
  2448.     checking permissions    0.0 ms
  2449.     Opening TABLES  0.0 ms
  2450.     System LOCK 0.0 ms
  2451.     init    0.1 ms
  2452.     Updating    0.1 ms
  2453.     END 0.0 ms
  2454.     Waiting FOR query cache LOCK    0.0 ms
  2455.     END 0.1 ms
  2456.     query END   35.2 ms
  2457.     closing TABLES  0.0 ms
  2458.     freeing items   0.0 ms
  2459.     logging slow query  0.0 ms
  2460.     cleaning up 0.0 ms
  2461.     CALL Stack
  2462.     JROOT/libraries/joomla/SESSION/storage/DATABASE.php:85
  2463.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  2464.  
  2465. 17 Query Types Logged, Sorted BY Occurrences.
  2466. SELECT TABLES:
  2467.  
  2468.     21 × SELECT `m`.`tag_id`,`t`.*
  2469.       FROM `w0z9v_tags` AS t ,`w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  2470.  
  2471.     4 × SELECT extension_id AS id, element AS "option", params, enabled
  2472.       FROM w0z9v_extensions
  2473.  
  2474.     4 × 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,
  2475.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
  2476.       FROM w0z9v_categories AS c
  2477.       LEFT JOIN w0z9v_categories AS s
  2478.       ON (s.lft <= c.lft
  2479.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  2480.       AND s.rgt < c.rgt)
  2481.       LEFT JOIN  (SELECT cat.id AS id
  2482.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  2483.       ON cat.lft BETWEEN parent.lft
  2484.       AND parent.rgt
  2485.  
  2486.     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,
  2487.       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,
  2488.       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,
  2489.       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,
  2490.       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,
  2491.       CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
  2492.       FROM w0z9v_content AS a
  2493.       LEFT JOIN w0z9v_content_frontpage AS fp
  2494.       ON fp.content_id = a.id
  2495.       LEFT JOIN w0z9v_categories AS c
  2496.       ON c.id = a.catid
  2497.       LEFT JOIN w0z9v_users AS ua
  2498.       ON ua.id = a.created_by
  2499.       LEFT JOIN w0z9v_users AS uam
  2500.       ON uam.id = a.modified_by
  2501.       LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  2502.       FROM w0z9v_contact_details AS contact
  2503.  
  2504.     2 × SELECT b.rules
  2505.       FROM w0z9v_assets AS a
  2506.       LEFT JOIN w0z9v_assets AS b
  2507.       ON b.lft <= a.lft
  2508.       AND b.rgt >= a.rgt
  2509.  
  2510.     1 × SELECT COUNT(*)
  2511.       FROM w0z9v_content AS a
  2512.       LEFT JOIN w0z9v_content_frontpage AS fp
  2513.       ON fp.content_id = a.id
  2514.       LEFT JOIN w0z9v_categories AS c
  2515.       ON c.id = a.catid
  2516.       LEFT JOIN w0z9v_users AS ua
  2517.       ON ua.id = a.created_by
  2518.       LEFT JOIN w0z9v_users AS uam
  2519.       ON uam.id = a.modified_by
  2520.       LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  2521.       FROM w0z9v_contact_details AS contact
  2522.  
  2523.     1 × SELECT m.id, m.title, m.module, m.POSITION, m.content, m.showtitle, m.params, mm.menuid
  2524.       FROM w0z9v_modules AS m
  2525.       LEFT JOIN w0z9v_modules_menu AS mm
  2526.       ON mm.moduleid = m.id
  2527.       LEFT JOIN w0z9v_extensions AS e
  2528.       ON e.element = m.module
  2529.       AND e.client_id = m.client_id
  2530.  
  2531.     1 × SELECT id, rules
  2532.       FROM `w0z9v_viewlevels
  2533.  
  2534.    1 × SELECT folder AS type, element AS name, params
  2535.      FROM w0z9v_extensions
  2536.  
  2537.    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
  2538.      FROM w0z9v_menu AS m
  2539.      LEFT JOIN w0z9v_extensions AS e
  2540.      ON m.component_id = e.extension_id
  2541.  
  2542.    1 × SELECT `DATA`
  2543.      FROM `w0z9v_session`
  2544.  
  2545.    1 × SELECT b.id
  2546.      FROM w0z9v_usergroups AS a
  2547.      LEFT JOIN w0z9v_usergroups AS b
  2548.      ON b.lft <= a.lft
  2549.      AND b.rgt >= a.rgt
  2550.  
  2551.    1 × SELECT *
  2552.      FROM w0z9v_languages
  2553.  
  2554.    1 × SELECT id, home, template, s.params
  2555.      FROM w0z9v_template_styles as s
  2556.      LEFT JOIN w0z9v_extensions as e
  2557.      ON e.element=s.template
  2558.      AND e.type='template'
  2559.      AND e.client_id=s.client_id
  2560.  
  2561. OTHER Tables:
  2562.  
  2563.    1 × UPDATE `w0z9v_session`
  2564.      SET `DATA` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1373753310;s:18:\"session.timer.last\";i:1373753765;s:17:\"session.timer.now\";i:1373753773;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.2; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"fc426c6ade21a0b8e3600169883dbe70\";}'  , `TIME` = '1373753774'
  2565.  
  2566.    1 × UPDATE w0z9v_categories
  2567.      SET hits = hits + 1
  2568.  
  2569.    1 × DELETE  
  2570.      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!