API tools faq
paste
jindan

Untitled

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