Guest User

Untitled

a guest
Jul 11th, 2013
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 27.78 KB | None | 0 0
  1. # Original legacy.php, shipped WITH Joomla 3.1.1
  2. Joomla! Debug Console
  3. SESSION
  4. Profile Information
  5. Application 0.000 seconds (+0.000); 0.18 MB (+0.185) - afterLoad
  6. Application 0.027 seconds (+0.027); 0.92 MB (+0.731) - afterInitialise
  7. Application 0.036 seconds (+0.009); 1.10 MB (+0.181) - afterRoute
  8. Application 13.770 seconds (+13.734); 1.87 MB (+0.770) - afterDispatch
  9. Application 13.776 seconds (+0.006); 1.97 MB (+0.098) - beforeRenderModule mod_articles_latest (Latest Article)
  10. Application 18.244 seconds (+4.469); 1.99 MB (+0.023) - afterRenderModule mod_articles_latest (Latest Article)
  11. Application 18.245 seconds (+0.000); 1.98 MB (-0.005) - beforeRenderModule mod_login (Login Form)
  12. Application 18.251 seconds (+0.006); 2.00 MB (+0.014) - afterRenderModule mod_login (Login Form)
  13. Application 18.251 seconds (+0.000); 2.00 MB (+0.001) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  14. Application 18.254 seconds (+0.003); 2.01 MB (+0.008) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  15. Application 18.255 seconds (+0.001); 2.00 MB (-0.001) - beforeRenderModule mod_menu (Main Menu)
  16. Application 18.266 seconds (+0.011); 2.10 MB (+0.093) - afterRenderModule mod_menu (Main Menu)
  17. Application 18.271 seconds (+0.005); 2.12 MB (+0.020) - afterRender
  18. Memory Usage
  19. 2.14 MB (2,240,692 Bytes)
  20. DATABASE Queries
  21. 34 Queries Logged
  22.  
  23.     SELECT `data`
  24.       FROM `w0z9v_session`
  25.       WHERE `session_id` = '6gjmun4gaa3bd258p039c4gsb6'
  26.     SELECT extension_id AS id, element AS "option", params, enabled
  27.       FROM w0z9v_extensions
  28.       WHERE `type` = 'component'
  29.       AND `element` = 'com_users'
  30.     SELECT folder AS TYPE, element AS name, params
  31.       FROM w0z9v_extensions
  32.       WHERE enabled >= 1
  33.       AND TYPE ='plugin'
  34.       AND state >= 0
  35.       AND access IN (1,1,5)
  36.       ORDER BY ordering
  37.     SELECT extension_id AS id, element AS "option", params, enabled
  38.       FROM w0z9v_extensions
  39.       WHERE `type` = 'component'
  40.       AND `element` = 'com_languages'
  41.     SELECT extension_id AS id, element AS "option", params, enabled
  42.       FROM w0z9v_extensions
  43.       WHERE `type` = 'component'
  44.       AND `element` = 'com_kunena'
  45.     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
  46.       FROM w0z9v_menu AS m
  47.       LEFT JOIN w0z9v_extensions AS e
  48.       ON m.component_id = e.extension_id
  49.       WHERE m.published = 1
  50.       AND m.parent_id > 0
  51.       AND m.client_id = 0
  52.       ORDER BY m.lft
  53.     SELECT extension_id AS id, element AS "option", params, enabled
  54.       FROM w0z9v_extensions
  55.       WHERE `type` = 'component'
  56.       AND `element` = 'com_content'
  57.     SELECT *
  58.       FROM w0z9v_languages
  59.       WHERE published=1
  60.       ORDER BY ordering ASC
  61.     SELECT id, home, template, s.params
  62.       FROM w0z9v_template_styles AS s
  63.       LEFT JOIN w0z9v_extensions AS e
  64.       ON e.element=s.template
  65.       AND e.TYPE='template'
  66.       AND e.client_id=s.client_id
  67.       WHERE s.client_id = 0
  68.       AND e.enabled = 1
  69.     SELECT b.rules
  70.       FROM w0z9v_assets AS a
  71.       LEFT JOIN w0z9v_assets AS b
  72.       ON b.lft <= a.lft
  73.       AND b.rgt >= a.rgt
  74.       WHERE (a.name = 'com_content')
  75.       GROUP BY b.id, b.rules, b.lft
  76.       ORDER BY b.lft
  77.     SELECT b.id
  78.       FROM w0z9v_usergroups AS a
  79.       LEFT JOIN w0z9v_usergroups AS b
  80.       ON b.lft <= a.lft
  81.       AND b.rgt >= a.rgt
  82.       WHERE a.id = 9
  83.     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,
  84.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug,COUNT(i.`id`) AS numitems
  85.       FROM w0z9v_categories AS c
  86.       LEFT JOIN w0z9v_categories AS s
  87.       ON (s.lft <= c.lft
  88.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  89.       AND s.rgt < c.rgt)
  90.       LEFT JOIN (SELECT cat.id AS id
  91.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  92.       ON cat.lft BETWEEN parent.lft
  93.       AND parent.rgt
  94.       WHERE parent.extension = 'com_content'
  95.       AND parent.published != 1
  96.       GROUP BY cat.id) AS badcats
  97.       ON badcats.id = c.id
  98.       LEFT JOIN `w0z9v_content` AS i
  99.       ON i.`catid` = c.id
  100.       AND i.state = 1
  101.       WHERE (c.extension='com_content' OR c.extension='system')
  102.       AND c.access IN (1,1,5)
  103.       AND c.published = 1
  104.       AND s.id=8
  105.       AND badcats.id IS NULL
  106.       GROUP BY 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
  107.       ORDER BY c.lft
  108.     SELECT b.rules
  109.       FROM w0z9v_assets AS a
  110.       LEFT JOIN w0z9v_assets AS b
  111.       ON b.lft <= a.lft
  112.       AND b.rgt >= a.rgt
  113.       WHERE (a.name = 'com_content.category.8')
  114.       GROUP BY b.id, b.rules, b.lft
  115.       ORDER BY b.lft
  116.     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,
  117.       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,
  118.       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,
  119.       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,
  120.       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,
  121.       CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
  122.       FROM w0z9v_content AS a
  123.       LEFT JOIN w0z9v_content_frontpage AS fp
  124.       ON fp.content_id = a.id
  125.       LEFT JOIN w0z9v_categories AS c
  126.       ON c.id = a.catid
  127.       LEFT JOIN w0z9v_users AS ua
  128.       ON ua.id = a.created_by
  129.       LEFT JOIN w0z9v_users AS uam
  130.       ON uam.id = a.modified_by
  131.       LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  132.       FROM w0z9v_contact_details AS contact
  133.       WHERE contact.published = 1
  134.       GROUP BY contact.user_id, contact.LANGUAGE) AS contact
  135.       ON contact.user_id = a.created_by
  136.       LEFT JOIN w0z9v_categories AS parent
  137.       ON parent.id = c.parent_id
  138.       LEFT JOIN w0z9v_content_rating AS v
  139.       ON a.id = v.content_id
  140.       LEFT
  141.       OUTER JOIN (SELECT cat.id AS id
  142.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  143.       ON cat.lft BETWEEN parent.lft
  144.       AND parent.rgt
  145.       WHERE parent.extension = 'com_content'
  146.       AND parent.published != 1
  147.       GROUP BY cat.id ) AS badcats
  148.       ON badcats.id = c.id
  149.       WHERE a.access IN (1,1,5)
  150.       AND c.access IN (1,1,5)
  151.       AND
  152.       CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END = 1
  153.       AND a.catid = 8
  154.       AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-11 17:33:10')
  155.       AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-11 17:33:10')
  156.       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
  157.       ORDER BY c.lft,
  158.       CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
  159.       LIMIT 0, 10
  160.     SELECT extension_id AS id, element AS "option", params, enabled
  161.       FROM w0z9v_extensions
  162.       WHERE `type` = 'component'
  163.       AND `element` = 'com_tags'
  164.     SELECT `m`.`tag_id`,`t`.*
  165.       FROM `w0z9v_contentitem_tag_map` AS m
  166.       INNER JOIN `w0z9v_tags` AS t
  167.       ON `m`.`tag_id` = `t`.`id`
  168.       WHERE `m`.`type_alias` = 'com_content.article'
  169.       AND `m`.`content_item_id` = 5913
  170.       AND `t`.`published` = 1
  171.       AND t.access IN (1,1,5)
  172.     SELECT `m`.`tag_id`,`t`.*
  173.       FROM `w0z9v_contentitem_tag_map` AS m
  174.       INNER JOIN `w0z9v_tags` AS t
  175.       ON `m`.`tag_id` = `t`.`id`
  176.       WHERE `m`.`type_alias` = 'com_content.article'
  177.       AND `m`.`content_item_id` = 9170
  178.       AND `t`.`published` = 1
  179.       AND t.access IN (1,1,5)
  180.     SELECT `m`.`tag_id`,`t`.*
  181.       FROM `w0z9v_contentitem_tag_map` AS m
  182.       INNER JOIN `w0z9v_tags` AS t
  183.       ON `m`.`tag_id` = `t`.`id`
  184.       WHERE `m`.`type_alias` = 'com_content.article'
  185.       AND `m`.`content_item_id` = 9169
  186.       AND `t`.`published` = 1
  187.       AND t.access IN (1,1,5)
  188.     SELECT `m`.`tag_id`,`t`.*
  189.       FROM `w0z9v_contentitem_tag_map` AS m
  190.       INNER JOIN `w0z9v_tags` AS t
  191.       ON `m`.`tag_id` = `t`.`id`
  192.       WHERE `m`.`type_alias` = 'com_content.article'
  193.       AND `m`.`content_item_id` = 9168
  194.       AND `t`.`published` = 1
  195.       AND t.access IN (1,1,5)
  196.     SELECT `m`.`tag_id`,`t`.*
  197.       FROM `w0z9v_contentitem_tag_map` AS m
  198.       INNER JOIN `w0z9v_tags` AS t
  199.       ON `m`.`tag_id` = `t`.`id`
  200.       WHERE `m`.`type_alias` = 'com_content.article'
  201.       AND `m`.`content_item_id` = 9167
  202.       AND `t`.`published` = 1
  203.       AND t.access IN (1,1,5)
  204.     SELECT `m`.`tag_id`,`t`.*
  205.       FROM `w0z9v_contentitem_tag_map` AS m
  206.       INNER JOIN `w0z9v_tags` AS t
  207.       ON `m`.`tag_id` = `t`.`id`
  208.       WHERE `m`.`type_alias` = 'com_content.article'
  209.       AND `m`.`content_item_id` = 9166
  210.       AND `t`.`published` = 1
  211.       AND t.access IN (1,1,5)
  212.     SELECT `m`.`tag_id`,`t`.*
  213.       FROM `w0z9v_contentitem_tag_map` AS m
  214.       INNER JOIN `w0z9v_tags` AS t
  215.       ON `m`.`tag_id` = `t`.`id`
  216.       WHERE `m`.`type_alias` = 'com_content.article'
  217.       AND `m`.`content_item_id` = 9165
  218.       AND `t`.`published` = 1
  219.       AND t.access IN (1,1,5)
  220.     SELECT `m`.`tag_id`,`t`.*
  221.       FROM `w0z9v_contentitem_tag_map` AS m
  222.       INNER JOIN `w0z9v_tags` AS t
  223.       ON `m`.`tag_id` = `t`.`id`
  224.       WHERE `m`.`type_alias` = 'com_content.article'
  225.       AND `m`.`content_item_id` = 9164
  226.       AND `t`.`published` = 1
  227.       AND t.access IN (1,1,5)
  228.     SELECT `m`.`tag_id`,`t`.*
  229.       FROM `w0z9v_contentitem_tag_map` AS m
  230.       INNER JOIN `w0z9v_tags` AS t
  231.       ON `m`.`tag_id` = `t`.`id`
  232.       WHERE `m`.`type_alias` = 'com_content.article'
  233.       AND `m`.`content_item_id` = 9163
  234.       AND `t`.`published` = 1
  235.       AND t.access IN (1,1,5)
  236.     SELECT `m`.`tag_id`,`t`.*
  237.       FROM `w0z9v_contentitem_tag_map` AS m
  238.       INNER JOIN `w0z9v_tags` AS t
  239.       ON `m`.`tag_id` = `t`.`id`
  240.       WHERE `m`.`type_alias` = 'com_content.article'
  241.       AND `m`.`content_item_id` = 9162
  242.       AND `t`.`published` = 1
  243.       AND t.access IN (1,1,5)
  244.     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,
  245.       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,
  246.       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,
  247.       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,
  248.       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,
  249.       CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
  250.       FROM w0z9v_content AS a
  251.       LEFT JOIN w0z9v_content_frontpage AS fp
  252.       ON fp.content_id = a.id
  253.       LEFT JOIN w0z9v_categories AS c
  254.       ON c.id = a.catid
  255.       LEFT JOIN w0z9v_users AS ua
  256.       ON ua.id = a.created_by
  257.       LEFT JOIN w0z9v_users AS uam
  258.       ON uam.id = a.modified_by
  259.       LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  260.       FROM w0z9v_contact_details AS contact
  261.       WHERE contact.published = 1
  262.       GROUP BY contact.user_id, contact.LANGUAGE) AS contact
  263.       ON contact.user_id = a.created_by
  264.       LEFT JOIN w0z9v_categories AS parent
  265.       ON parent.id = c.parent_id
  266.       LEFT JOIN w0z9v_content_rating AS v
  267.       ON a.id = v.content_id
  268.       LEFT
  269.       OUTER JOIN (SELECT cat.id AS id
  270.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  271.       ON cat.lft BETWEEN parent.lft
  272.       AND parent.rgt
  273.       WHERE parent.extension = 'com_content'
  274.       AND parent.published != 1
  275.       GROUP BY cat.id ) AS badcats
  276.       ON badcats.id = c.id
  277.       WHERE a.access IN (1,1,5)
  278.       AND c.access IN (1,1,5)
  279.       AND
  280.       CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END = 1
  281.       AND a.catid = 8
  282.       AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-11 17:33:10')
  283.       AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-11 17:33:10')
  284.       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
  285.       ORDER BY c.lft,
  286.       CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
  287.     UPDATE w0z9v_categories
  288.       SET hits = hits + 1
  289.       WHERE id = 8
  290.     SELECT `m`.`tag_id`,`t`.*
  291.       FROM `w0z9v_contentitem_tag_map` AS m
  292.       INNER JOIN `w0z9v_tags` AS t
  293.       ON `m`.`tag_id` = `t`.`id`
  294.       WHERE `m`.`type_alias` = 'com_content.category'
  295.       AND `m`.`content_item_id` = 8
  296.       AND `t`.`published` = 1
  297.       AND t.access IN (1,1,5)
  298.     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,
  299.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
  300.       FROM w0z9v_categories AS c
  301.       LEFT JOIN w0z9v_categories AS s
  302.       ON (s.lft <= c.lft
  303.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  304.       AND s.rgt < c.rgt)
  305.       LEFT JOIN (SELECT cat.id AS id
  306.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  307.       ON cat.lft BETWEEN parent.lft
  308.       AND parent.rgt
  309.       WHERE parent.extension = 'com_content'
  310.       AND parent.published != 1
  311.       GROUP BY cat.id) AS badcats
  312.       ON badcats.id = c.id
  313.       WHERE (c.extension='com_content' OR c.extension='system')
  314.       AND c.access IN (1,1,5)
  315.       AND c.published = 1
  316.       AND s.id=8
  317.       AND badcats.id IS NULL
  318.       GROUP BY 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
  319.       ORDER BY c.lft
  320.     SELECT m.id, m.title, m.module, m.POSITION, m.content, m.showtitle, m.params, mm.menuid
  321.       FROM w0z9v_modules AS m
  322.       LEFT JOIN w0z9v_modules_menu AS mm
  323.       ON mm.moduleid = m.id
  324.       LEFT JOIN w0z9v_extensions AS e
  325.       ON e.element = m.module
  326.       AND e.client_id = m.client_id
  327.       WHERE m.published = 1
  328.       AND e.enabled = 1
  329.       AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-07-11 17:33:10')
  330.       AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-07-11 17:33:10')
  331.       AND m.access IN (1,1,5)
  332.       AND m.client_id = 0
  333.       AND (mm.menuid = 435 OR mm.menuid <= 0)
  334.       ORDER BY m.POSITION, m.ordering
  335.     SELECT id, rules
  336.       FROM `w0z9v_viewlevels`
  337.     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,
  338.       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,
  339.       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,
  340.       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,
  341.       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,
  342.       CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
  343.       FROM w0z9v_content AS a
  344.       LEFT JOIN w0z9v_content_frontpage AS fp
  345.       ON fp.content_id = a.id
  346.       LEFT JOIN w0z9v_categories AS c
  347.       ON c.id = a.catid
  348.       LEFT JOIN w0z9v_users AS ua
  349.       ON ua.id = a.created_by
  350.       LEFT JOIN w0z9v_users AS uam
  351.       ON uam.id = a.modified_by
  352.       LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  353.       FROM w0z9v_contact_details AS contact
  354.       WHERE contact.published = 1
  355.       GROUP BY contact.user_id, contact.LANGUAGE) AS contact
  356.       ON contact.user_id = a.created_by
  357.       LEFT JOIN w0z9v_categories AS parent
  358.       ON parent.id = c.parent_id
  359.       LEFT JOIN w0z9v_content_rating AS v
  360.       ON a.id = v.content_id
  361.       LEFT
  362.       OUTER JOIN (SELECT cat.id AS id
  363.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  364.       ON cat.lft BETWEEN parent.lft
  365.       AND parent.rgt
  366.       WHERE parent.extension = 'com_content'
  367.       AND parent.published != 1
  368.       GROUP BY cat.id ) AS badcats
  369.       ON badcats.id = c.id
  370.       WHERE a.access IN (1,1,5)
  371.       AND c.access IN (1,1,5)
  372.       AND
  373.       CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END = 1
  374.       AND a.catid IN (8,10,11,12,13)
  375.       AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-11 17:33:10')
  376.       AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-11 17:33:10')
  377.       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
  378.       ORDER BY a.created DESC
  379.       LIMIT 0, 10
  380.     SELECT *
  381.       FROM w0z9v_kunena_configuration
  382.       WHERE id=1
  383.     UPDATE `w0z9v_session`
  384.       SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1373563586;s:18:\"session.timer.last\";i:1373563586;s:17:\"session.timer.now\";i:1373563990;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:\"fa4e650b96ce8ea312b268c70645b71b\";}' , `time` = '1373564008'
  385.       WHERE `session_id` = '6gjmun4gaa3bd258p039c4gsb6'
  386.  
  387. 17 Query Types Logged, Sorted BY Occurrences.
  388. SELECT TABLES:
  389.  
  390.     11 × SELECT `m`.`tag_id`,`t`.*
  391.       FROM `w0z9v_contentitem_tag_map` AS m
  392.       INNER JOIN `w0z9v_tags` AS t
  393.       ON `m`.`tag_id` = `t`.`id`
  394.     5 × SELECT extension_id AS id, element AS "option", params, enabled
  395.       FROM w0z9v_extensions
  396.     3 × 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,
  397.       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,
  398.       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,
  399.       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,
  400.       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,
  401.       CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
  402.       FROM w0z9v_content AS a
  403.       LEFT JOIN w0z9v_content_frontpage AS fp
  404.       ON fp.content_id = a.id
  405.       LEFT JOIN w0z9v_categories AS c
  406.       ON c.id = a.catid
  407.       LEFT JOIN w0z9v_users AS ua
  408.       ON ua.id = a.created_by
  409.       LEFT JOIN w0z9v_users AS uam
  410.       ON uam.id = a.modified_by
  411.       LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.LANGUAGE
  412.       FROM w0z9v_contact_details AS contact
  413.     2 × SELECT b.rules
  414.       FROM w0z9v_assets AS a
  415.       LEFT JOIN w0z9v_assets AS b
  416.       ON b.lft <= a.lft
  417.       AND b.rgt >= a.rgt
  418.     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,
  419.       CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
  420.       FROM w0z9v_categories AS c
  421.       LEFT JOIN w0z9v_categories AS s
  422.       ON (s.lft <= c.lft
  423.       AND s.rgt >= c.rgt) OR (s.lft > c.lft
  424.       AND s.rgt < c.rgt)
  425.       LEFT JOIN (SELECT cat.id AS id
  426.       FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  427.       ON cat.lft BETWEEN parent.lft
  428.       AND parent.rgt
  429.     1 × SELECT id, rules
  430.       FROM `w0z9v_viewlevels
  431.    1 × SELECT *
  432.      FROM w0z9v_kunena_configuration
  433.    1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  434.      FROM w0z9v_modules AS m
  435.      LEFT JOIN w0z9v_modules_menu AS mm
  436.      ON mm.moduleid = m.id
  437.      LEFT JOIN w0z9v_extensions AS e
  438.      ON e.element = m.module
  439.      AND e.client_id = m.client_id
  440.    1 × SELECT b.id
  441.      FROM w0z9v_usergroups AS a
  442.      LEFT JOIN w0z9v_usergroups AS b
  443.      ON b.lft <= a.lft
  444.      AND b.rgt >= a.rgt
  445.    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
  446.      FROM w0z9v_menu AS m
  447.      LEFT JOIN w0z9v_extensions AS e
  448.      ON m.component_id = e.extension_id
  449.    1 × SELECT folder AS type, element AS name, params
  450.      FROM w0z9v_extensions
  451.    1 × SELECT *
  452.      FROM w0z9v_languages
  453.    1 × SELECT id, home, template, s.params
  454.      FROM w0z9v_template_styles as s
  455.      LEFT JOIN w0z9v_extensions as e
  456.      ON e.element=s.template
  457.      AND e.type='template'
  458.      AND e.client_id=s.client_id
  459.    1 × SELECT `DATA`
  460.      FROM `w0z9v_session`
  461.    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,
  462.      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
  463.      FROM w0z9v_categories as c
  464.      LEFT JOIN w0z9v_categories AS s
  465.      ON (s.lft <= c.lft
  466.      AND s.rgt >= c.rgt) OR (s.lft > c.lft
  467.      AND s.rgt < c.rgt)
  468.      LEFT JOIN (SELECT cat.id as id
  469.      FROM w0z9v_categories AS cat JOIN w0z9v_categories AS parent
  470.      ON cat.lft BETWEEN parent.lft
  471.      AND parent.rgt
  472.  
  473. OTHER Tables:
  474.  
  475.    1 × UPDATE `w0z9v_session`
  476.      SET `DATA` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1373563586;s:18:\"session.timer.last\";i:1373563586;s:17:\"session.timer.now\";i:1373563990;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:\"fa4e650b96ce8ea312b268c70645b71b\";}' , `TIME` = '1373564008'
  477.    1 × UPDATE w0z9v_categories
  478.      SET hits = hits + 1
Advertisement
Add Comment
Please, Sign In to add comment