Informacje o wydajności

Użycie pamięci

19.2 MB (20,128,616 Bytes)

20 zapytań zarejestrowanych

1. SELECT `data` 
     FROM `jos_session` 
     WHERE `session_id` = '4vhnbiq125riva05sbcgq4gqj7'
2. DELETE 
     FROM `jos_session` 
     WHERE `time` < 1318830587
3. SELECT folder AS type, element AS name, params 
     FROM jos_extensions 
     WHERE enabled >= 1 
     AND type ='plugin' 
     AND state >= 0 
     AND access IN (1,1) 
     ORDER BY ordering
4. SELECT extension_id AS "id", element AS "option", params, enabled 
     FROM jos_extensions 
     WHERE `type` = 'component' 
     AND `element` = 'com_languages'
5. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component 
     FROM jos_menu AS m 
     LEFT JOIN jos_extensions AS e 
     ON m.component_id = e.extension_id 
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0 
     AND m.access IN (1,1) 
     ORDER BY m.lft
6. SELECT extension_id AS "id", element AS "option", params, enabled 
     FROM jos_extensions 
     WHERE `type` = 'component' 
     AND `element` = 'com_rokcandy'
7. SELECT * 
     FROM jos_rokcandy 
     WHERE published=1
8. SELECT id, home, template, s.params 
     FROM jos_template_styles as s 
     LEFT JOIN jos_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id 
     WHERE s.client_id = 0 
     AND e.enabled = 1
9. SELECT extension_id AS "id", element AS "option", params, enabled 
     FROM jos_extensions 
     WHERE `type` = 'component' 
     AND `element` = 'com_content'
10. SELECT * 
      FROM jos_languages 
      WHERE published=1 
      ORDER BY ordering ASC
11. SELECT b.rules 
      FROM jos_assets AS a 
      LEFT JOIN jos_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt 
      WHERE a.name = 'com_content' 
      ORDER BY b.lft
12. SELECT extension_id AS "id", element AS "option", params, enabled 
      FROM jos_extensions 
      WHERE `type` = 'component' 
      AND `element` = 'com_users'
13. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,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,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 ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
      FROM jos_content AS a 
      LEFT JOIN jos_categories AS c 
      ON c.id = a.catid 
      LEFT JOIN jos_users AS ua 
      ON ua.id = a.created_by 
      LEFT JOIN jos_users AS uam 
      ON uam.id = a.modified_by 
      LEFT JOIN jos_contact_details AS contact 
      on contact.user_id = a.created_by 
      LEFT JOIN jos_categories as parent 
      ON parent.id = c.parent_id 
      LEFT JOIN jos_content_rating AS v 
      ON a.id = v.content_id 
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM jos_categories AS cat JOIN jos_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id 
      INNER JOIN jos_content_frontpage AS fp 
      ON fp.content_id = a.id 
      WHERE a.access IN (1,1) 
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2011-10-17 06:04:49') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2011-10-17 06:04:49') 
      ORDER BY c.lft, fp.ordering, a.created DESC 
      LIMIT 0, 5
14. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,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,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 ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
      FROM jos_content AS a 
      LEFT JOIN jos_categories AS c 
      ON c.id = a.catid 
      LEFT JOIN jos_users AS ua 
      ON ua.id = a.created_by 
      LEFT JOIN jos_users AS uam 
      ON uam.id = a.modified_by 
      LEFT JOIN jos_contact_details AS contact 
      on contact.user_id = a.created_by 
      LEFT JOIN jos_categories as parent 
      ON parent.id = c.parent_id 
      LEFT JOIN jos_content_rating AS v 
      ON a.id = v.content_id 
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM jos_categories AS cat JOIN jos_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id 
      INNER JOIN jos_content_frontpage AS fp 
      ON fp.content_id = a.id 
      WHERE a.access IN (1,1) 
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2011-10-17 06:04:49') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2011-10-17 06:04:49') 
      ORDER BY c.lft, fp.ordering, a.created DESC
15. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug 
      FROM jos_categories as c 
      LEFT JOIN jos_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt) 
      LEFT JOIN (SELECT cat.id as id 
      FROM jos_categories AS cat JOIN jos_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id 
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=2 
      AND badcats.id is null 
      GROUP BY c.id 
      ORDER BY c.lft
16. SELECT id, home, template, params 
      FROM jos_template_styles 
      WHERE client_id = 0
17. SELECT ts.template 
      FROM jos_template_styles AS ts 
      INNER JOIN jos_menu AS m 
      ON ts.id=m.template_style_id 
      WHERE m.id = 101 
      AND m.template_style_id != 0
18. SELECT template 
      FROM jos_template_styles 
      WHERE home = 1 
      AND client_id = 0
19. SELECT extension_id AS "id", element AS "option", params, enabled 
      FROM jos_extensions 
      WHERE `type` = 'component' 
      AND `element` = 'com_rokgallery'
20. UPDATE `jos_session`