API tools faq
paste
jindan

Untitled

jindan
Jul 11th, 2013
80
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 47.85 KB | None | 0 0
raw download clone embed print report
  1. Joomla! Debug Console
  2. SESSION
  3. Profile Information
  4. TIME
  5. Memory
  6. TIME: 0.0 ms / 0.0 ms Memory: 0.169 MB / 0.17 MB Application: afterLoad
  7. TIME: 119.9 ms / 120.0 ms Memory: 0.713 MB / 0.88 MB Application: afterInitialise
  8. TIME: 21.5 ms / 141.4 ms Memory: 0.227 MB / 1.11 MB Application: afterRoute
  9. TIME: 5088.1 ms / 5229.5 ms Memory: 0.643 MB / 1.75 MB Application: beforeRenderModule mod_menu (Main Menu)
  10. TIME: 5.0 ms / 5234.5 ms Memory: 0.019 MB / 1.77 MB Application: afterRenderModule mod_menu (Main Menu)
  11.  
  12. DATABASE queries total: 5138.5 ms
  13. Memory Usage
  14. 1.94 MB (2,039,396 Bytes)
  15. DATABASE Queries
  16. 64 Queries Logged 5138.5 ms
  17.  
  18.     Query TIME: 0.87 ms Query memory: 0.007 MB Memory BEFORE query: 0.417 MB ROWS returned: 0
  19.  
  20.     SELECT `data`
  21.  
  22.       FROM `w0z9v_session`
  23.  
  24.       WHERE `session_id` = 'fhaftvt733sh7a97mqp83ovil2'
  25.  
  26.     EXPLAIN
  27.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  28.     1   SIMPLE  w0z9v_session   const   PRIMARY PRIMARY 602 const   1  
  29.     Profile
  30.     STATUS  Duration
  31.     starting    0.0 ms
  32.     Waiting FOR query cache LOCK    0.0 ms
  33.     checking query cache FOR query  0.1 ms
  34.     checking permissions    0.0 ms
  35.     Opening TABLES  0.1 ms
  36.     System LOCK 0.0 ms
  37.     Waiting FOR query cache LOCK    0.1 ms
  38.     init    0.1 ms
  39.     optimizing  0.0 ms
  40.     statistics  0.1 ms
  41.     preparing   0.0 ms
  42.     executing   0.0 ms
  43.     END 0.0 ms
  44.     query END   0.0 ms
  45.     closing TABLES  0.0 ms
  46.     freeing items   0.0 ms
  47.     Waiting FOR query cache LOCK    0.0 ms
  48.     freeing items   0.0 ms
  49.     Waiting FOR query cache LOCK    0.0 ms
  50.     freeing items   0.0 ms
  51.     storing RESULT IN query cache   0.0 ms
  52.     logging slow query  0.0 ms
  53.     cleaning up 0.0 ms
  54.     CALL Stack
  55.     JROOT/libraries/joomla/SESSION/storage/DATABASE.php:46
  56.     JROOT/libraries/joomla/SESSION/SESSION.php:654
  57.     JROOT/libraries/joomla/SESSION/SESSION.php:592
  58.     JROOT/libraries/legacy/application/application.php:982
  59.     JROOT/libraries/legacy/application/application.php:140
  60.     JROOT/includes/application.php:47
  61.     JROOT/libraries/legacy/application/application.php:175
  62.     JROOT/libraries/joomla/factory.php:104
  63.     JROOT/INDEX.php:37
  64.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  65.     Query TIME: 0.55 ms After LAST query: 3.39 ms Query memory: 0.004 MB Memory BEFORE query: 0.456 MB
  66.  
  67.     DELETE
  68.  
  69.       FROM `w0z9v_session`
  70.  
  71.       WHERE `time` < '1373600103'
  72.  
  73.     EXPLAIN
  74.     EXPLAIN NOT possible ON query: DELETE FROM `w0z9v_session` WHERE `time` < '1373600103'
  75.     Profile
  76.     STATUS  Duration
  77.     starting    0.1 ms
  78.     checking permissions    0.0 ms
  79.     Opening TABLES  0.0 ms
  80.     System LOCK 0.0 ms
  81.     init    0.1 ms
  82.     updating    0.1 ms
  83.     END 0.0 ms
  84.     query END   0.0 ms
  85.     closing TABLES  0.0 ms
  86.     freeing items   0.0 ms
  87.     logging slow query  0.0 ms
  88.     cleaning up 0.0 ms
  89.     CALL Stack
  90.     JROOT/libraries/legacy/application/application.php:999
  91.     JROOT/libraries/legacy/application/application.php:140
  92.     JROOT/includes/application.php:47
  93.     JROOT/libraries/legacy/application/application.php:175
  94.     JROOT/libraries/joomla/factory.php:104
  95.     JROOT/INDEX.php:37
  96.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  97.     Query TIME: 0.57 ms After LAST query: 1.08 ms Query memory: 0.006 MB Memory BEFORE query: 0.462 MB ROWS returned: 0
  98.  
  99.     SELECT `session_id`
  100.  
  101.       FROM `w0z9v_session`
  102.  
  103.       WHERE `session_id` = 'fhaftvt733sh7a97mqp83ovil2'
  104.       LIMIT 0, 1
  105.  
  106.     EXPLAIN
  107.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  108.     1   SIMPLE  w0z9v_session   const   PRIMARY PRIMARY 602 const   1   USING INDEX
  109.     Profile
  110.     STATUS  Duration
  111.     starting    0.0 ms
  112.     Waiting FOR query cache LOCK    0.0 ms
  113.     checking query cache FOR query  0.1 ms
  114.     checking permissions    0.0 ms
  115.     Opening TABLES  0.0 ms
  116.     System LOCK 0.0 ms
  117.     Waiting FOR query cache LOCK    0.0 ms
  118.     init    0.0 ms
  119.     optimizing  0.0 ms
  120.     statistics  0.1 ms
  121.     preparing   0.0 ms
  122.     executing   0.0 ms
  123.     END 0.0 ms
  124.     query END   0.0 ms
  125.     closing TABLES  0.0 ms
  126.     freeing items   0.0 ms
  127.     Waiting FOR query cache LOCK    0.0 ms
  128.     freeing items   0.0 ms
  129.     Waiting FOR query cache LOCK    0.0 ms
  130.     freeing items   0.0 ms
  131.     storing RESULT IN query cache   0.1 ms
  132.     logging slow query  0.0 ms
  133.     cleaning up 0.0 ms
  134.     CALL Stack
  135.     JROOT/libraries/legacy/application/application.php:1035
  136.     JROOT/libraries/legacy/application/application.php:1007
  137.     JROOT/libraries/legacy/application/application.php:140
  138.     JROOT/includes/application.php:47
  139.     JROOT/libraries/legacy/application/application.php:175
  140.     JROOT/libraries/joomla/factory.php:104
  141.     JROOT/INDEX.php:37
  142.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  143.     Query TIME: 59.89 ms After LAST query: 1.14 ms Query memory: 0.005 MB Memory BEFORE query: 0.469 MB
  144.  
  145.     INSERT INTO `w0z9v_session`
  146.     (`session_id`, `client_id`, `time`)
  147.       VALUES
  148.     ('fhaftvt733sh7a97mqp83ovil2', 0, '1373601003')
  149.  
  150.     EXPLAIN
  151.     EXPLAIN NOT possible ON query: INSERT INTO `w0z9v_session` (`session_id`, `client_id`, `time`) VALUES ('fhaftvt733sh7a97mqp83ovil2', 0, '1373601003')
  152.     Profile
  153.     STATUS  Duration
  154.     starting    0.1 ms
  155.     checking permissions    0.0 ms
  156.     Opening TABLES  0.0 ms
  157.     System LOCK 0.0 ms
  158.     init    0.0 ms
  159.     UPDATE  0.1 ms
  160.     Waiting FOR query cache LOCK    0.0 ms
  161.     UPDATE  0.0 ms
  162.     END 0.0 ms
  163.     query END   59.3 ms
  164.     closing TABLES  0.0 ms
  165.     freeing items   0.0 ms
  166.     logging slow query  0.0 ms
  167.     cleaning up 0.0 ms
  168.     CALL Stack
  169.     JROOT/libraries/legacy/application/application.php:1066
  170.     JROOT/libraries/legacy/application/application.php:1007
  171.     JROOT/libraries/legacy/application/application.php:140
  172.     JROOT/includes/application.php:47
  173.     JROOT/libraries/legacy/application/application.php:175
  174.     JROOT/libraries/joomla/factory.php:104
  175.     JROOT/INDEX.php:37
  176.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  177.     Query TIME: 0.41 ms After LAST query: 4.50 ms Query memory: 0.005 MB Memory BEFORE query: 0.585 MB ROWS returned: 1
  178.  
  179.     SELECT extension_id AS id, element AS "option", params, enabled
  180.  
  181.       FROM w0z9v_extensions
  182.  
  183.       WHERE `type` = 'component'
  184.       AND `element` = 'com_users'
  185.  
  186.     EXPLAIN
  187.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  188.     1   SIMPLE  w0z9v_extensions    REF element_clientid,element_folder_clientid,extension  element_clientid    302 const   1   USING WHERE
  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.     sending cached RESULT TO clien  0.0 ms
  197.     logging slow query  0.0 ms
  198.     cleaning up 0.0 ms
  199.     CALL Stack
  200.     JROOT/libraries/joomla/cache/controller/callback.php:158
  201.     JROOT/libraries/legacy/component/helper.php:384
  202.     JROOT/libraries/legacy/component/helper.php:43
  203.     JROOT/libraries/legacy/component/helper.php:91
  204.     JROOT/includes/application.php:63
  205.     JROOT/INDEX.php:40
  206.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  207.     Query TIME: 0.28 ms After LAST query: 2.54 ms Query memory: 0.006 MB Memory BEFORE query: 0.585 MB ROWS returned: 2
  208.  
  209.     SELECT b.id
  210.  
  211.       FROM w0z9v_usergroups AS a
  212.  
  213.       LEFT JOIN w0z9v_usergroups AS b
  214.       ON b.lft <= a.lft
  215.       AND b.rgt >= a.rgt
  216.  
  217.       WHERE a.id = 9
  218.  
  219.     EXPLAIN
  220.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  221.     1   SIMPLE  a   const   PRIMARY PRIMARY 4   const   1  
  222.     1   SIMPLE  b   range   idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4   NULL    3   USING WHERE; USING INDEX
  223.     Profile
  224.     STATUS  Duration
  225.     starting    0.0 ms
  226.     Waiting FOR query cache LOCK    0.0 ms
  227.     checking query cache FOR query  0.0 ms
  228.     checking privileges ON cached   0.0 ms
  229.     checking permissions    0.0 ms
  230.     checking permissions    0.0 ms
  231.     sending cached RESULT TO clien  0.0 ms
  232.     logging slow query  0.0 ms
  233.     cleaning up 0.0 ms
  234.     CALL Stack
  235.     JROOT/libraries/joomla/access/access.php:336
  236.     JROOT/libraries/joomla/access/access.php:405
  237.     JROOT/libraries/joomla/USER/USER.php:415
  238.     JROOT/libraries/joomla/plugin/helper.php:266
  239.     JROOT/libraries/joomla/plugin/helper.php:165
  240.     JROOT/includes/application.php:69
  241.     JROOT/INDEX.php:40
  242.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  243.     Query TIME: 0.28 ms After LAST query: 1.17 ms Query memory: 0.005 MB Memory BEFORE query: 0.594 MB ROWS returned: 4
  244.  
  245.     SELECT id, rules
  246.  
  247.       FROM `w0z9v_viewlevels`
  248.  
  249.     EXPLAIN
  250.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  251.     1   SIMPLE  w0z9v_viewlevels    ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    4  
  252.     Profile
  253.     STATUS  Duration
  254.     starting    0.0 ms
  255.     Waiting FOR query cache LOCK    0.0 ms
  256.     checking query cache FOR query  0.0 ms
  257.     checking privileges ON cached   0.0 ms
  258.     checking permissions    0.0 ms
  259.     sending cached RESULT TO clien  0.0 ms
  260.     logging slow query  0.0 ms
  261.     cleaning up 0.0 ms
  262.     CALL Stack
  263.     JROOT/libraries/joomla/access/access.php:422
  264.     JROOT/libraries/joomla/USER/USER.php:415
  265.     JROOT/libraries/joomla/plugin/helper.php:266
  266.     JROOT/libraries/joomla/plugin/helper.php:165
  267.     JROOT/includes/application.php:69
  268.     JROOT/INDEX.php:40
  269.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  270.     Query TIME: 0.29 ms After LAST query: 1.61 ms Query memory: 0.004 MB Memory BEFORE query: 0.603 MB ROWS returned: 42
  271.  
  272.     SELECT folder AS TYPE, element AS name, params
  273.  
  274.       FROM w0z9v_extensions
  275.  
  276.       WHERE enabled >= 1
  277.       AND TYPE ='plugin'
  278.       AND state >= 0
  279.       AND access IN (1,1,5)
  280.  
  281.       ORDER BY ordering
  282.  
  283.     EXPLAIN
  284.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  285.     1   SIMPLE  w0z9v_extensions    REF extension   extension   62  const   58  USING WHERE; USING filesort
  286.     Profile
  287.     STATUS  Duration
  288.     starting    0.0 ms
  289.     Waiting FOR query cache LOCK    0.0 ms
  290.     checking query cache FOR query  0.0 ms
  291.     checking privileges ON cached   0.0 ms
  292.     checking permissions    0.0 ms
  293.     sending cached RESULT TO clien  0.0 ms
  294.     logging slow query  0.0 ms
  295.     cleaning up 0.0 ms
  296.     CALL Stack
  297.     JROOT/libraries/joomla/plugin/helper.php:280
  298.     JROOT/libraries/joomla/plugin/helper.php:165
  299.     JROOT/includes/application.php:69
  300.     JROOT/INDEX.php:40
  301.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  302.     Query TIME: 0.27 ms After LAST query: 3.01 ms Query memory: 0.005 MB Memory BEFORE query: 0.645 MB ROWS returned: 1
  303.  
  304.     SELECT extension_id AS id, element AS "option", params, enabled
  305.  
  306.       FROM w0z9v_extensions
  307.  
  308.       WHERE `type` = 'component'
  309.       AND `element` = 'com_languages'
  310.  
  311.     EXPLAIN
  312.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  313.     1   SIMPLE  w0z9v_extensions    REF element_clientid,element_folder_clientid,extension  element_clientid    302 const   1   USING WHERE
  314.     Profile
  315.     STATUS  Duration
  316.     starting    0.0 ms
  317.     Waiting FOR query cache LOCK    0.0 ms
  318.     checking query cache FOR query  0.0 ms
  319.     checking privileges ON cached   0.0 ms
  320.     checking permissions    0.0 ms
  321.     sending cached RESULT TO clien  0.0 ms
  322.     logging slow query  0.0 ms
  323.     cleaning up 0.0 ms
  324.     CALL Stack
  325.     JROOT/libraries/joomla/cache/controller/callback.php:158
  326.     JROOT/libraries/legacy/component/helper.php:384
  327.     JROOT/libraries/legacy/component/helper.php:43
  328.     JROOT/libraries/legacy/component/helper.php:91
  329.     JROOT/includes/application.php:116
  330.     JROOT/INDEX.php:40
  331.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  332.     Query TIME: 0.42 ms After LAST query: 30.70 ms Query memory: 0.008 MB Memory BEFORE query: 0.945 MB ROWS returned: 17
  333.  
  334.     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
  335.  
  336.       FROM w0z9v_menu AS m
  337.  
  338.       LEFT JOIN w0z9v_extensions AS e
  339.       ON m.component_id = e.extension_id
  340.  
  341.       WHERE m.published = 1
  342.       AND m.parent_id > 0
  343.       AND m.client_id = 0
  344.  
  345.       ORDER BY m.lft
  346.  
  347.     EXPLAIN
  348.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  349.     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
  350.     1   SIMPLE  e   eq_ref  PRIMARY PRIMARY 4   m31.m.component_id  1  
  351.     Profile
  352.     STATUS  Duration
  353.     starting    0.0 ms
  354.     Waiting FOR query cache LOCK    0.0 ms
  355.     checking query cache FOR query  0.0 ms
  356.     checking privileges ON cached   0.0 ms
  357.     checking permissions    0.0 ms
  358.     checking permissions    0.0 ms
  359.     sending cached RESULT TO clien  0.0 ms
  360.     logging slow query  0.0 ms
  361.     cleaning up 0.0 ms
  362.     CALL Stack
  363.     JROOT/libraries/cms/menu/site.php:45
  364.     JROOT/libraries/legacy/menu/menu.php:61
  365.     JROOT/libraries/legacy/menu/menu.php:113
  366.     JROOT/libraries/legacy/application/application.php:893
  367.     JROOT/includes/application.php:593
  368.     JROOT/libraries/cms/router/site.php:203
  369.     JROOT/libraries/joomla/application/router.php:182
  370.     JROOT/libraries/cms/router/site.php:83
  371.     JROOT/libraries/legacy/application/application.php:246
  372.     JROOT/includes/application.php:155
  373.     JROOT/INDEX.php:46
  374.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  375.     Query TIME: 0.43 ms After LAST query: 12.83 ms Query memory: 0.012 MB Memory BEFORE query: 1.109 MB ROWS returned: 1
  376.  
  377.     SELECT extension_id AS id, element AS "option", params, enabled
  378.  
  379.       FROM w0z9v_extensions
  380.  
  381.       WHERE `type` = 'component'
  382.       AND `element` = 'com_content'
  383.  
  384.     EXPLAIN
  385.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  386.     1   SIMPLE  w0z9v_extensions    REF element_clientid,element_folder_clientid,extension  element_clientid    302 const   1   USING WHERE
  387.     Profile
  388.     STATUS  Duration
  389.     starting    0.0 ms
  390.     Waiting FOR query cache LOCK    0.0 ms
  391.     checking query cache FOR query  0.0 ms
  392.     checking privileges ON cached   0.0 ms
  393.     checking permissions    0.0 ms
  394.     sending cached RESULT TO clien  0.0 ms
  395.     logging slow query  0.0 ms
  396.     cleaning up 0.0 ms
  397.     CALL Stack
  398.     JROOT/libraries/joomla/cache/controller/callback.php:158
  399.     JROOT/libraries/legacy/component/helper.php:384
  400.     JROOT/libraries/legacy/component/helper.php:43
  401.     JROOT/libraries/legacy/component/helper.php:91
  402.     JROOT/components/com_content/router.php:26
  403.     JROOT/libraries/cms/router/site.php:426
  404.     JROOT/libraries/joomla/application/router.php:214
  405.     JROOT/libraries/cms/router/site.php:97
  406.     JROOT/libraries/joomla/application/route.php:62
  407.     JROOT/plugins/system/sef/sef.php:49
  408.     JROOT/libraries/joomla/event/event.php:71
  409.     JROOT/libraries/joomla/event/dispatcher.php:161
  410.     JROOT/libraries/joomla/application/base.php:106
  411.     JROOT/libraries/legacy/application/application.php:255
  412.     JROOT/includes/application.php:155
  413.     JROOT/INDEX.php:46
  414.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  415.     Query TIME: 0.41 ms After LAST query: 5.02 ms Query memory: 0.004 MB Memory BEFORE query: 1.123 MB ROWS returned: 1
  416.  
  417.     SELECT *
  418.  
  419.       FROM w0z9v_languages
  420.  
  421.       WHERE published=1
  422.  
  423.       ORDER BY ordering ASC
  424.  
  425.     EXPLAIN
  426.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  427.     1   SIMPLE  w0z9v_languages ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    1   USING WHERE; USING filesort
  428.     Profile
  429.     STATUS  Duration
  430.     starting    0.1 ms
  431.     Waiting FOR query cache LOCK    0.0 ms
  432.     checking query cache FOR query  0.0 ms
  433.     checking privileges ON cached   0.0 ms
  434.     checking permissions    0.0 ms
  435.     sending cached RESULT TO clien  0.0 ms
  436.     logging slow query  0.0 ms
  437.     cleaning up 0.0 ms
  438.     CALL Stack
  439.     JROOT/libraries/joomla/LANGUAGE/helper.php:159
  440.     JROOT/includes/application.php:381
  441.     JROOT/includes/application.php:177
  442.     JROOT/INDEX.php:52
  443.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  444.     Query TIME: 0.32 ms After LAST query: 4.81 ms Query memory: 0.004 MB Memory BEFORE query: 1.133 MB ROWS returned: 2
  445.  
  446.     SELECT id, home, template, s.params
  447.  
  448.       FROM w0z9v_template_styles AS s
  449.  
  450.       LEFT JOIN w0z9v_extensions AS e
  451.       ON e.element=s.template
  452.       AND e.TYPE='template'
  453.       AND e.client_id=s.client_id
  454.  
  455.       WHERE s.client_id = 0
  456.       AND e.enabled = 1
  457.  
  458.     EXPLAIN
  459.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  460.     1   SIMPLE  s   ALL idx_template    NO INDEX KEY COULD BE USED  NULL    NULL    4   USING WHERE
  461.     1   SIMPLE  e   REF element_clientid,element_folder_clientid,extension  element_clientid    303 m31.s.template,const    1   USING WHERE
  462.     Profile
  463.     STATUS  Duration
  464.     starting    0.0 ms
  465.     Waiting FOR query cache LOCK    0.0 ms
  466.     checking query cache FOR query  0.0 ms
  467.     checking privileges ON cached   0.0 ms
  468.     checking permissions    0.0 ms
  469.     checking permissions    0.0 ms
  470.     sending cached RESULT TO clien  0.0 ms
  471.     logging slow query  0.0 ms
  472.     cleaning up 0.0 ms
  473.     CALL Stack
  474.     JROOT/includes/application.php:495
  475.     JROOT/libraries/legacy/component/helper.php:291
  476.     JROOT/includes/application.php:220
  477.     JROOT/INDEX.php:52
  478.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  479.     Query TIME: 0.30 ms After LAST query: 18.42 ms Query memory: 0.011 MB Memory BEFORE query: 1.380 MB ROWS returned: 1
  480.  
  481.     SELECT a.rules
  482.  
  483.       FROM w0z9v_assets AS a
  484.  
  485.       WHERE (a.id = 1)
  486.  
  487.       GROUP BY a.id, a.rules, a.lft
  488.  
  489.     EXPLAIN
  490.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  491.     1   SIMPLE  a   const   PRIMARY PRIMARY 4   const   1  
  492.     Profile
  493.     STATUS  Duration
  494.     starting    0.0 ms
  495.     Waiting FOR query cache LOCK    0.0 ms
  496.     checking query cache FOR query  0.0 ms
  497.     checking privileges ON cached   0.0 ms
  498.     checking permissions    0.0 ms
  499.     sending cached RESULT TO clien  0.0 ms
  500.     logging slow query  0.0 ms
  501.     cleaning up 0.0 ms
  502.     CALL Stack
  503.     JROOT/libraries/joomla/access/access.php:250
  504.     JROOT/libraries/joomla/USER/USER.php:354
  505.     JROOT/components/com_content/models/category.php:129
  506.     JROOT/libraries/legacy/model/legacy.php:412
  507.     JROOT/components/com_content/models/category.php:326
  508.     JROOT/libraries/legacy/VIEW/legacy.php:398
  509.     JROOT/components/com_content/views/category/VIEW.html.php:44
  510.     JROOT/libraries/legacy/controller/legacy.php:685
  511.     JROOT/components/com_content/controller.php:79
  512.     JROOT/libraries/legacy/controller/legacy.php:722
  513.     JROOT/components/com_content/content.php:16
  514.     JROOT/libraries/legacy/component/helper.php:355
  515.     JROOT/libraries/legacy/component/helper.php:335
  516.     JROOT/includes/application.php:220
  517.     JROOT/INDEX.php:52
  518.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  519.     Query TIME: 0.28 ms After LAST query: 2.58 ms Query memory: 0.012 MB Memory BEFORE query: 1.397 MB ROWS returned: 2
  520.  
  521.     SELECT b.rules
  522.  
  523.       FROM w0z9v_assets AS a
  524.  
  525.       LEFT JOIN w0z9v_assets AS b
  526.       ON b.lft <= a.lft
  527.       AND b.rgt >= a.rgt
  528.  
  529.       WHERE (a.name = 'com_content')
  530.  
  531.       GROUP BY b.id, b.rules, b.lft
  532.  
  533.       ORDER BY b.lft
  534.  
  535.     EXPLAIN
  536.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  537.     1   SIMPLE  a   const   idx_asset_name  idx_asset_name  152 const   1   USING TEMPORARY; USING filesort
  538.     1   SIMPLE  b   range   idx_lft_rgt idx_lft_rgt 4   NULL    11  USING WHERE
  539.     Profile
  540.     STATUS  Duration
  541.     starting    0.0 ms
  542.     Waiting FOR query cache LOCK    0.0 ms
  543.     checking query cache FOR query  0.0 ms
  544.     checking privileges ON cached   0.0 ms
  545.     checking permissions    0.0 ms
  546.     checking permissions    0.0 ms
  547.     sending cached RESULT TO clien  0.0 ms
  548.     logging slow query  0.0 ms
  549.     cleaning up 0.0 ms
  550.     CALL Stack
  551.     JROOT/libraries/joomla/access/access.php:250
  552.     JROOT/libraries/joomla/access/access.php:110
  553.     JROOT/libraries/joomla/USER/USER.php:362
  554.     JROOT/components/com_content/models/category.php:129
  555.     JROOT/libraries/legacy/model/legacy.php:412
  556.     JROOT/components/com_content/models/category.php:326
  557.     JROOT/libraries/legacy/VIEW/legacy.php:398
  558.     JROOT/components/com_content/views/category/VIEW.html.php:44
  559.     JROOT/libraries/legacy/controller/legacy.php:685
  560.     JROOT/components/com_content/controller.php:79
  561.     JROOT/libraries/legacy/controller/legacy.php:722
  562.     JROOT/components/com_content/content.php:16
  563.     JROOT/libraries/legacy/component/helper.php:355
  564.     JROOT/libraries/legacy/component/helper.php:335
  565.     JROOT/includes/application.php:220
  566.     JROOT/INDEX.php:52
  567.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  568.     Query TIME: 0.45 ms After LAST query: 4.51 ms Query memory: 0.010 MB Memory BEFORE query: 1.412 MB ROWS returned: 3
  569.  
  570.     SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  571.                 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  572.                 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  573.                 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
  574.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
  575.  
  576.       FROM w0z9v_categories AS c
  577.  
  578.       LEFT JOIN w0z9v_categories AS s
  579.       ON (s.lft <= c.lft
  580.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  581.       AND s.rgt < c.rgt)
  582.  
  583.       LEFT JOIN  (SELECT cat.id AS id
  584.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  585.       ON cat.lft BETWEEN parent.lft
  586.       AND parent.rgt
  587.       WHERE parent.extension = 'com_content'
  588.       AND parent.published != 1
  589.       GROUP BY cat.id) AS badcats
  590.       ON badcats.id = c.id
  591.  
  592.       WHERE (c.extension='com_content' OR c.extension='system')
  593.       AND c.access IN (1,1,5)
  594.       AND c.published = 1
  595.       AND s.id=8
  596.       AND badcats.id IS NULL
  597.  
  598.       GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  599.                  c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.LANGUAGE, c.level,
  600.                  c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  601.                  c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
  602.  
  603.       ORDER BY c.lft
  604.  
  605.     EXPLAIN
  606.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  607.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  608.     1   PRIMARY s   const   PRIMARY,idx_left_right  PRIMARY 4   const   1   USING filesort
  609.     1   PRIMARY c   ALL cat_idx,idx_access,idx_left_right   NO INDEX KEY COULD BE USED  NULL    NULL    13  USING WHERE
  610.     2   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  611.     2   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  612.     Profile
  613.     STATUS  Duration
  614.     starting    0.0 ms
  615.     Waiting FOR query cache LOCK    0.0 ms
  616.     checking query cache FOR query  0.0 ms
  617.     checking privileges ON cached   0.0 ms
  618.     checking permissions    0.0 ms
  619.     checking permissions    0.0 ms
  620.     checking permissions    0.0 ms
  621.     checking permissions    0.0 ms
  622.     sending cached RESULT TO clien  0.0 ms
  623.     logging slow query  0.0 ms
  624.     cleaning up 0.0 ms
  625.     CALL Stack
  626.     JROOT/libraries/legacy/categories/categories.php:288
  627.     JROOT/libraries/legacy/categories/categories.php:181
  628.     JROOT/components/com_content/models/category.php:326
  629.     JROOT/libraries/legacy/VIEW/legacy.php:398
  630.     JROOT/components/com_content/views/category/VIEW.html.php:44
  631.     JROOT/libraries/legacy/controller/legacy.php:685
  632.     JROOT/components/com_content/controller.php:79
  633.     JROOT/libraries/legacy/controller/legacy.php:722
  634.     JROOT/components/com_content/content.php:16
  635.     JROOT/libraries/legacy/component/helper.php:355
  636.     JROOT/libraries/legacy/component/helper.php:335
  637.     JROOT/includes/application.php:220
  638.     JROOT/INDEX.php:52
  639.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  640.     Query TIME: 0.29 ms After LAST query: 2.80 ms Query memory: 0.010 MB Memory BEFORE query: 1.433 MB ROWS returned: 4
  641.  
  642.     SELECT b.rules
  643.  
  644.       FROM w0z9v_assets AS a
  645.  
  646.       LEFT JOIN w0z9v_assets AS b
  647.       ON b.lft <= a.lft
  648.       AND b.rgt >= a.rgt
  649.  
  650.       WHERE (a.name = 'com_content.category.8')
  651.  
  652.       GROUP BY b.id, b.rules, b.lft
  653.  
  654.       ORDER BY b.lft
  655.  
  656.     EXPLAIN
  657.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  658.     1   SIMPLE  a   const   idx_asset_name  idx_asset_name  152 const   1   USING TEMPORARY; USING filesort
  659.     1   SIMPLE  b   range   idx_lft_rgt idx_lft_rgt 4   NULL    14  USING WHERE
  660.     Profile
  661.     STATUS  Duration
  662.     starting    0.0 ms
  663.     Waiting FOR query cache LOCK    0.0 ms
  664.     checking query cache FOR query  0.0 ms
  665.     checking privileges ON cached   0.0 ms
  666.     checking permissions    0.0 ms
  667.     checking permissions    0.0 ms
  668.     sending cached RESULT TO clien  0.0 ms
  669.     logging slow query  0.0 ms
  670.     cleaning up 0.0 ms
  671.     CALL Stack
  672.     JROOT/libraries/joomla/access/access.php:250
  673.     JROOT/libraries/joomla/access/access.php:110
  674.     JROOT/libraries/joomla/USER/USER.php:362
  675.     JROOT/components/com_content/models/category.php:335
  676.     JROOT/libraries/legacy/VIEW/legacy.php:398
  677.     JROOT/components/com_content/views/category/VIEW.html.php:44
  678.     JROOT/libraries/legacy/controller/legacy.php:685
  679.     JROOT/components/com_content/controller.php:79
  680.     JROOT/libraries/legacy/controller/legacy.php:722
  681.     JROOT/components/com_content/content.php:16
  682.     JROOT/libraries/legacy/component/helper.php:355
  683.     JROOT/libraries/legacy/component/helper.php:335
  684.     JROOT/includes/application.php:220
  685.     JROOT/INDEX.php:52
  686.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  687.     Query TIME: 5029.87 ms After LAST query: 8.10 ms Query memory: 0.010 MB Memory BEFORE query: 1.477 MB ROWS returned: 10
  688.  
  689.     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,
  690.       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,
  691.       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,
  692.       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,
  693.       CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id AS contactid,parent.title AS parent_title, parent.id AS parent_id, parent.path AS parent_route, parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count AS rating_count,c.published,
  694.       CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
  695.  
  696.       FROM w0z9v_content AS a
  697.  
  698.       LEFT JOIN w0z9v_content_frontpage AS fp
  699.       ON fp.content_id = a.id
  700.  
  701.       LEFT JOIN w0z9v_categories AS c
  702.       ON c.id = a.catid
  703.  
  704.       LEFT JOIN w0z9v_users AS ua
  705.       ON ua.id = a.created_by
  706.  
  707.       LEFT JOIN w0z9v_users AS uam
  708.       ON uam.id = a.modified_by
  709.  
  710.       LEFT JOIN (
  711.     SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  712.  
  713.       FROM w0z9v_contact_details AS contact
  714.  
  715.       WHERE contact.published = 1
  716.  
  717.       GROUP BY contact.user_id, contact.LANGUAGE) AS contact
  718.       ON contact.user_id = a.created_by
  719.  
  720.       LEFT JOIN w0z9v_categories AS parent
  721.       ON parent.id = c.parent_id
  722.  
  723.       LEFT JOIN w0z9v_content_rating AS v
  724.       ON a.id = v.content_id
  725.  
  726.       LEFT
  727.       OUTER JOIN (SELECT cat.id AS id
  728.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  729.       ON cat.lft BETWEEN parent.lft
  730.       AND parent.rgt
  731.       WHERE parent.extension = 'com_content'
  732.       AND parent.published != 1
  733.       GROUP BY cat.id ) AS badcats
  734.       ON badcats.id = c.id
  735.  
  736.       WHERE a.access IN (1,1,5)
  737.       AND c.access IN (1,1,5)
  738.       AND
  739.       CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END = 1
  740.       AND a.catid = 8
  741.       AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-12 03:50:04')
  742.       AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-12 03:50:04')
  743.  
  744.       GROUP BY a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
  745.  
  746.       ORDER BY  c.lft,  
  747.       CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created
  748.       LIMIT 0, 10
  749.  
  750.     EXPLAIN
  751.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  752.     1   PRIMARY <derived2>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  753.     1   PRIMARY <derived3>  system  NULL    NO INDEX KEY COULD BE USED  NULL    NULL    0   const ROW NOT found
  754.     1   PRIMARY c   const   PRIMARY,idx_access  PRIMARY 4   const   1   USING TEMPORARY; USING filesort
  755.     1   PRIMARY a   REF idx_access,idx_catid    idx_catid   4   const   32636   USING WHERE
  756.     1   PRIMARY fp  eq_ref  PRIMARY PRIMARY 4   m31.a.id    1  
  757.     1   PRIMARY ua  eq_ref  PRIMARY PRIMARY 4   m31.a.created_by    1  
  758.     1   PRIMARY uam eq_ref  PRIMARY PRIMARY 4   m31.a.modified_by   1  
  759.     1   PRIMARY parent  eq_ref  PRIMARY PRIMARY 4   const   1  
  760.     1   PRIMARY v   eq_ref  PRIMARY PRIMARY 4   m31.a.id    1  
  761.     3   DERIVED parent  range   cat_idx,idx_left_right  cat_idx 153 NULL    2   USING WHERE; USING TEMPORARY; USING filesort
  762.     3   DERIVED cat INDEX   idx_left_right  idx_left_right  8   NULL    13  USING WHERE; USING INDEX; USING JOIN buffer
  763.     2   DERIVED contact REF idx_state   idx_state   1       1   USING WHERE; USING TEMPORARY; USING filesort
  764.     Profile
  765.     STATUS  Duration
  766.     starting    0.0 ms
  767.     Waiting FOR query cache LOCK    0.0 ms
  768.     checking query cache FOR query  0.9 ms
  769.     checking permissions    0.0 ms
  770.     checking permissions    0.0 ms
  771.     checking permissions    0.0 ms
  772.     checking permissions    0.0 ms
  773.     checking permissions    0.0 ms
  774.     checking permissions    0.0 ms
  775.     checking permissions    0.0 ms
  776.     checking permissions    0.0 ms
  777.     checking permissions    0.0 ms
  778.     checking permissions    0.0 ms
  779.     Opening TABLES  0.1 ms
  780.     System LOCK 0.3 ms
  781.     optimizing  0.0 ms
  782.     statistics  0.1 ms
  783.     preparing   0.0 ms
  784.     Creating tmp TABLE  0.1 ms
  785.     executing   0.0 ms
  786.     Copying TO tmp TABLE    0.1 ms
  787.     Sorting RESULT  0.0 ms
  788.     Sending DATA    0.0 ms
  789.     optimizing  0.0 ms
  790.     statistics  0.1 ms
  791.     preparing   0.0 ms
  792.     Creating tmp TABLE  0.0 ms
  793.     executing   0.0 ms
  794.     Copying TO tmp TABLE    0.1 ms
  795.     Sorting RESULT  0.0 ms
  796.     Sending DATA    0.0 ms
  797.     removing tmp TABLE  0.0 ms
  798.     Sending DATA    0.0 ms
  799.     removing tmp TABLE  0.0 ms
  800.     Sending DATA    0.0 ms
  801.     Waiting FOR query cache LOCK    0.0 ms
  802.     Sending DATA    0.1 ms
  803.     init    0.7 ms
  804.     optimizing  0.1 ms
  805.     statistics  0.7 ms
  806.     preparing   0.2 ms
  807.     Creating tmp TABLE  1.0 ms
  808.     executing   0.0 ms
  809.     Copying TO tmp TABLE    3874.9 ms
  810.     Sorting RESULT  1019.7 ms
  811.     Sending DATA    0.5 ms
  812.     END 0.0 ms
  813.     removing tmp TABLE  128.8 ms
  814.     END 0.0 ms
  815.     query END   0.0 ms
  816.     closing TABLES  0.0 ms
  817.     removing tmp TABLE  0.0 ms
  818.     closing TABLES  0.0 ms
  819.     removing tmp TABLE  0.0 ms
  820.     closing TABLES  0.0 ms
  821.     freeing items   0.1 ms
  822.     Waiting FOR query cache LOCK    0.0 ms
  823.     freeing items   0.2 ms
  824.     Waiting FOR query cache LOCK    0.0 ms
  825.     freeing items   0.0 ms
  826.     storing RESULT IN query cache   0.0 ms
  827.     logging slow query  0.0 ms
  828.     cleaning up 0.0 ms
  829.     CALL Stack
  830.     JROOT/libraries/legacy/model/legacy.php:301
  831.     JROOT/libraries/legacy/model/list.php:129
  832.     JROOT/components/com_content/models/articles.php:522
  833.     JROOT/components/com_content/models/category.php:234
  834.     JROOT/libraries/legacy/VIEW/legacy.php:398
  835.     JROOT/components/com_content/views/category/VIEW.html.php:61
  836.     JROOT/libraries/legacy/controller/legacy.php:685
  837.     JROOT/components/com_content/controller.php:79
  838.     JROOT/libraries/legacy/controller/legacy.php:722
  839.     JROOT/components/com_content/content.php:16
  840.     JROOT/libraries/legacy/component/helper.php:355
  841.     JROOT/libraries/legacy/component/helper.php:335
  842.     JROOT/includes/application.php:220
  843.     JROOT/INDEX.php:52
  844.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  845.     Query TIME: 0.22 ms After LAST query: 3.58 ms Query memory: 0.013 MB Memory BEFORE query: 1.638 MB ROWS returned: 1
  846.  
  847.     SELECT extension_id AS id, element AS "option", params, enabled
  848.  
  849.       FROM w0z9v_extensions
  850.  
  851.       WHERE `type` = 'component'
  852.       AND `element` = 'com_tags'
  853.  
  854.     EXPLAIN
  855.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  856.     1   SIMPLE  w0z9v_extensions    REF element_clientid,element_folder_clientid,extension  element_clientid    302 const   1   USING WHERE
  857.     Profile
  858.     STATUS  Duration
  859.     starting    0.0 ms
  860.     Waiting FOR query cache LOCK    0.0 ms
  861.     checking query cache FOR query  0.0 ms
  862.     checking privileges ON cached   0.0 ms
  863.     checking permissions    0.0 ms
  864.     sending cached RESULT TO clien  1.2 ms
  865.     logging slow query  0.0 ms
  866.     cleaning up 0.0 ms
  867.     CALL Stack
  868.     JROOT/libraries/joomla/cache/controller/callback.php:158
  869.     JROOT/libraries/legacy/component/helper.php:384
  870.     JROOT/libraries/legacy/component/helper.php:43
  871.     JROOT/libraries/legacy/component/helper.php:91
  872.     JROOT/libraries/cms/helper/tags.php:394
  873.     JROOT/components/com_content/models/articles.php:648
  874.     JROOT/components/com_content/models/category.php:234
  875.     JROOT/libraries/legacy/VIEW/legacy.php:398
  876.     JROOT/components/com_content/views/category/VIEW.html.php:61
  877.     JROOT/libraries/legacy/controller/legacy.php:685
  878.     JROOT/components/com_content/controller.php:79
  879.     JROOT/libraries/legacy/controller/legacy.php:722
  880.     JROOT/components/com_content/content.php:16
  881.     JROOT/libraries/legacy/component/helper.php:355
  882.     JROOT/libraries/legacy/component/helper.php:335
  883.     JROOT/includes/application.php:220
  884.     JROOT/INDEX.php:52
  885.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  886.     Query TIME: 0.55 ms After LAST query: 1.10 ms Query memory: 0.010 MB Memory BEFORE query: 1.637 MB
  887.  
  888.     SELECT `m`.`tag_id`,`t`.*
  889.  
  890.       FROM `w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct
  891.  
  892.       INNER JOIN `w0z9v_tags` AS t  
  893.       ON `m`.`tag_id` = `t`.`id`
  894.  
  895.       WHERE `ct`.`type_id` = `m`.`type_id`
  896.       AND `ct`.`type_alias` = 'com_content.article'
  897.       AND `m`.`content_item_id` = 5913
  898.       AND `t`.`published` = 1
  899.       AND t.access IN (1,1,5)
  900.  
  901.     EXPLAIN
  902.     Error
  903.     UNKNOWN COLUMN 'm.tag_id' IN 'on clause' SQL=EXPLAIN SELECT `m`.`tag_id`,`t`.* FROM `w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct INNER JOIN `w0z9v_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `ct`.`type_id` = `m`.`type_id` AND `ct`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 5913 AND `t`.`published` = 1 AND t.access IN (1,1,5)
  904.     Profile
  905.     STATUS  Duration
  906.     starting    0.0 ms
  907.     Waiting FOR query cache LOCK    0.0 ms
  908.     checking query cache FOR query  0.1 ms
  909.     checking permissions    0.0 ms
  910.     checking permissions    0.0 ms
  911.     checking permissions    0.0 ms
  912.     Opening TABLES  0.0 ms
  913.     System LOCK 0.0 ms
  914.     Waiting FOR query cache LOCK    0.0 ms
  915.     init    0.1 ms
  916.     Waiting FOR query cache LOCK    0.0 ms
  917.     init    0.0 ms
  918.     storing RESULT IN query cache   0.0 ms
  919.     END 0.0 ms
  920.     query END   0.0 ms
  921.     closing TABLES  0.0 ms
  922.     freeing items   0.0 ms
  923.     logging slow query  0.0 ms
  924.     cleaning up 0.0 ms
  925.     CALL Stack
  926.     JROOT/libraries/cms/helper/tags.php:413
  927.     JROOT/components/com_content/models/articles.php:648
  928.     JROOT/components/com_content/models/category.php:234
  929.     JROOT/libraries/legacy/VIEW/legacy.php:398
  930.     JROOT/components/com_content/views/category/VIEW.html.php:61
  931.     JROOT/libraries/legacy/controller/legacy.php:685
  932.     JROOT/components/com_content/controller.php:79
  933.     JROOT/libraries/legacy/controller/legacy.php:722
  934.     JROOT/components/com_content/content.php:16
  935.     JROOT/libraries/legacy/component/helper.php:355
  936.     JROOT/libraries/legacy/component/helper.php:335
  937.     JROOT/includes/application.php:220
  938.     JROOT/INDEX.php:52
  939.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  940.     Query TIME: 1.23 ms After LAST query: 5.28 ms Query memory: 0.007 MB Memory BEFORE query: 1.736 MB ROWS returned: 5
  941.  
  942.     SELECT m.id, m.title, m.module, m.POSITION, m.content, m.showtitle, m.params, mm.menuid
  943.  
  944.       FROM w0z9v_modules AS m
  945.  
  946.       LEFT JOIN w0z9v_modules_menu AS mm
  947.       ON mm.moduleid = m.id
  948.  
  949.       LEFT JOIN w0z9v_extensions AS e
  950.       ON e.element = m.module
  951.       AND e.client_id = m.client_id
  952.  
  953.       WHERE m.published = 1
  954.       AND e.enabled = 1
  955.       AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-07-12 03:50:04')
  956.       AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-07-12 03:50:04')
  957.       AND m.access IN (1,1,5)
  958.       AND m.client_id = 0
  959.       AND (mm.menuid = 435 OR mm.menuid <= 0)
  960.  
  961.       ORDER BY m.POSITION, m.ordering
  962.  
  963.     EXPLAIN
  964.     id  select_type TABLE   TYPE    possible_keys   KEY key_len REF ROWS    Extra
  965.     1   SIMPLE  m   REF PRIMARY,published,newsfeeds published   1   const   26  USING WHERE; USING filesort
  966.     1   SIMPLE  mm  REF PRIMARY PRIMARY 4   m31.m.id    1   USING WHERE; USING INDEX
  967.     1   SIMPLE  e   REF element_clientid,element_folder_clientid    element_clientid    303 m31.m.module,const  1   USING WHERE
  968.     Profile
  969.     STATUS  Duration
  970.     starting    0.0 ms
  971.     Waiting FOR query cache LOCK    0.0 ms
  972.     checking query cache FOR query  0.1 ms
  973.     checking permissions    0.0 ms
  974.     checking permissions    0.0 ms
  975.     checking permissions    0.0 ms
  976.     Opening TABLES  0.0 ms
  977.     System LOCK 0.0 ms
  978.     Waiting FOR query cache LOCK    0.1 ms
  979.     init    0.1 ms
  980.     optimizing  0.0 ms
  981.     statistics  0.1 ms
  982.     preparing   0.0 ms
  983.     executing   0.0 ms
  984.     Sorting RESULT  0.2 ms
  985.     Sending DATA    0.3 ms
  986.     END 0.0 ms
  987.     query END   0.0 ms
  988.     closing TABLES  0.0 ms
  989.     freeing items   0.0 ms
  990.     Waiting FOR query cache LOCK    0.0 ms
  991.     freeing items   0.0 ms
  992.     Waiting FOR query cache LOCK    0.0 ms
  993.     freeing items   0.0 ms
  994.     storing RESULT IN query cache   0.1 ms
  995.     logging slow query  0.0 ms
  996.     cleaning up 0.0 ms
  997.     CALL Stack
  998.     JROOT/libraries/legacy/module/helper.php:348
  999.     JROOT/libraries/legacy/module/helper.php:84
  1000.     JROOT/libraries/joomla/document/html/renderer/modules.php:37
  1001.     JROOT/libraries/joomla/document/html/html.php:408
  1002.     JROOT/templates/protostar/error.php:143
  1003.     JROOT/libraries/joomla/document/error/error.php:135
  1004.     JROOT/libraries/joomla/document/error/error.php:107
  1005.     JROOT/libraries/cms/error/page.php:62
  1006.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1007.     Query TIME: 40.26 ms After LAST query: 7.37 ms Query memory: 0.002 MB Memory BEFORE query: 1.758 MB
  1008.  
  1009.     UPDATE `w0z9v_session`
  1010.  
  1011.       SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1373601003;s:18:\"session.timer.last\";i:1373601003;s:17:\"session.timer.now\";i:1373601003;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;}}'
  1012.         , `time` = '1373601009'
  1013.  
  1014.       WHERE `session_id` = 'fhaftvt733sh7a97mqp83ovil2'
  1015.  
  1016.     EXPLAIN
  1017.     EXPLAIN NOT possible ON query: UPDATE `w0z9v_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1373601003;s:18:\"session.timer.last\";i:1373601003;s:17:\"session.timer.now\";i:1373601003;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;}}' , `time` = '1373601009' WHERE `session_id` = 'fhaftvt733sh7a97mqp83ovil2'
  1018.     Profile
  1019.     STATUS  Duration
  1020.     starting    0.1 ms
  1021.     checking permissions    0.0 ms
  1022.     Opening TABLES  0.0 ms
  1023.     System LOCK 0.0 ms
  1024.     init    0.1 ms
  1025.     Updating    0.1 ms
  1026.     END 0.0 ms
  1027.     Waiting FOR query cache LOCK    0.0 ms
  1028.     END 0.0 ms
  1029.     query END   39.7 ms
  1030.     closing TABLES  0.0 ms
  1031.     freeing items   0.0 ms
  1032.     logging slow query  0.0 ms
  1033.     cleaning up 0.0 ms
  1034.     CALL Stack
  1035.     JROOT/libraries/joomla/SESSION/storage/DATABASE.php:85
  1036.     [ADD xdebug.file_link_format directive TO your php.ini file TO have links FOR files]
  1037.  
  1038. 18 Query Types Logged, Sorted BY Occurrences.
  1039. SELECT TABLES:
  1040.  
  1041.     4 × SELECT extension_id AS id, element AS "option", params, enabled
  1042.       FROM w0z9v_extensions
  1043.  
  1044.     2 × SELECT b.rules
  1045.       FROM w0z9v_assets AS a
  1046.       LEFT JOIN w0z9v_assets AS b
  1047.       ON b.lft <= a.lft
  1048.       AND b.rgt >= a.rgt
  1049.  
  1050.     1 × SELECT a.rules
  1051.       FROM w0z9v_assets AS a
  1052.  
  1053.     1 × 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,
  1054.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
  1055.       FROM w0z9v_categories AS c
  1056.       LEFT JOIN w0z9v_categories AS s
  1057.       ON (s.lft <= c.lft
  1058.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  1059.       AND s.rgt < c.rgt)
  1060.       LEFT JOIN  (SELECT cat.id AS id
  1061.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  1062.       ON cat.lft BETWEEN parent.lft
  1063.       AND parent.rgt
  1064.  
  1065.     1 × SELECT `m`.`tag_id`,`t`.*
  1066.       FROM `w0z9v_contentitem_tag_map` AS m ,`w0z9v_content_types` AS ct  
  1067.       INNER JOIN `w0z9v_tags` AS t  
  1068.       ON `m`.`tag_id` = `t`.`id`
  1069.  
  1070.     1 × SELECT m.id, m.title, m.module, m.POSITION, m.content, m.showtitle, m.params, mm.menuid
  1071.       FROM w0z9v_modules AS m
  1072.       LEFT JOIN w0z9v_modules_menu AS mm
  1073.       ON mm.moduleid = m.id
  1074.       LEFT JOIN w0z9v_extensions AS e
  1075.       ON e.element = m.module
  1076.       AND e.client_id = m.client_id
  1077.  
  1078.     1 × SELECT id, home, template, s.params
  1079.       FROM w0z9v_template_styles AS s
  1080.       LEFT JOIN w0z9v_extensions AS e
  1081.       ON e.element=s.template
  1082.       AND e.TYPE='template'
  1083.       AND e.client_id=s.client_id
  1084.  
  1085.     1 × 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,
  1086.       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,
  1087.       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,
  1088.       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,
  1089.       CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id AS contactid,parent.title AS parent_title, parent.id AS parent_id, parent.path AS parent_route, parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count AS rating_count,c.published,
  1090.       CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
  1091.       FROM w0z9v_content AS a
  1092.       LEFT JOIN w0z9v_content_frontpage AS fp
  1093.       ON fp.content_id = a.id
  1094.       LEFT JOIN w0z9v_categories AS c
  1095.       ON c.id = a.catid
  1096.       LEFT JOIN w0z9v_users AS ua
  1097.       ON ua.id = a.created_by
  1098.       LEFT JOIN w0z9v_users AS uam
  1099.       ON uam.id = a.modified_by
  1100.       LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  1101.       FROM w0z9v_contact_details AS contact
  1102.  
  1103.     1 × SELECT *
  1104.       FROM w0z9v_languages
  1105.  
  1106.     1 × SELECT b.id
  1107.       FROM w0z9v_usergroups AS a
  1108.       LEFT JOIN w0z9v_usergroups AS b
  1109.       ON b.lft <= a.lft
  1110.       AND b.rgt >= a.rgt
  1111.  
  1112.     1 × SELECT `session_id`
  1113.       FROM `w0z9v_session`
  1114.  
  1115.     1 × SELECT id, rules
  1116.       FROM `w0z9v_viewlevels
  1117.  
  1118.    1 × SELECT folder AS type, element AS name, params
  1119.      FROM w0z9v_extensions
  1120.  
  1121.    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
  1122.      FROM w0z9v_menu AS m
  1123.      LEFT JOIN w0z9v_extensions AS e
  1124.      ON m.component_id = e.extension_id
  1125.  
  1126.    1 × SELECT `DATA`
  1127.      FROM `w0z9v_session`
  1128.  
  1129. OTHER Tables:
  1130.  
  1131.    1 × UPDATE `w0z9v_session`
  1132.      SET `DATA` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1373601003;s:18:\"session.timer.last\";i:1373601003;s:17:\"session.timer.now\";i:1373601003;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;}}'  , `TIME` = '1373601009'
  1133.  
  1134.    1 × INSERT INTO `w0z9v_session` (`session_id`, `client_id`, `TIME`)
  1135.      VALUES  ('fhaftvt733sh7a97mqp83ovil2', 0, '1373601003'
  1136.  
  1137.    1 × DELETE  
  1138.      FROM `w0z9v_session`
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!