gfh16 queries executed
1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2 SELECT name, value FROM jos_opensef_config WHERE scope = 'com_sef' ORDER BY name ASC
3 SELECT * FROM jos_opensef_sef_component
4 SELECT * FROM jos_opensef_sef_component
5 SELECT * FROM jos_opensef_sef WHERE published = '1' AND valid = '1' AND (direction IS NULL OR direction = '' OR direction = 'o') AND (site_id IS NULL OR site_id = -1) ORDER BY site_id DESC, published DESC, valid DESC, LENGTH(direction) DESC
6 SELECT * FROM jos_opensef_sef WHERE published = '1' AND valid = '1' AND (direction IS NULL OR direction = '' OR direction = 'o') AND (site_id IS NULL OR site_id = -1) ORDER BY site_id DESC, published DESC, valid DESC, LENGTH(direction) DESC
7 SELECT * FROM jos_opensef_sef WHERE 1 AND (direction IS NULL OR direction = '' OR direction = 'i') AND (site_id IS NULL OR site_id = -1) AND (external = '/scanner-frequencies/arizona-highway-patrol/') AND use_internal = '1' ORDER BY site_id DESC, LENGTH(external) ASC, published DESC, valid DESC, LENGTH(direction) DESC, link_prio DESC LIMIT 1
8 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 95 ) ORDER BY menuid DESC LIMIT 1
9 DELETE FROM jos_session WHERE ( ( time < '1246586319' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1246586319' ) AND guest = 1 AND userid = 0 )
10 SELECT * FROM jos_menu WHERE id = 95
11 SELECT * FROM jos_categories WHERE id = '13'
12 SELECT * FROM jos_sections WHERE id = '6'
13 SELECT c.*, COUNT( b.id ) AS numitems FROM jos_categories AS c LEFT JOIN jos_content AS b ON b.catid = c.id AND b.state = 1 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2009-07-02 20:13' ) AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2009-07-02 20:13' ) AND b.access <= 0 WHERE c.section = '6' AND c.parent_id = '13' AND c.published = 1 AND c.access <= 0 GROUP BY c.id HAVING COUNT( b.id ) > 0 ORDER BY c.ordering
14 SELECT COUNT(a.id) as numitems FROM jos_content AS a LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.catid = 13 AND a.state = 1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-07-02 20:13' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-07-02 20:13' ) AND a.access <= 0 AND 0 <= 0 ORDER BY a.created DESC
15 SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups FROM jos_content AS a LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.catid = 13 AND a.state = 1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-07-02 20:13' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-07-02 20:13' ) AND a.access <= 0 AND 0 <= 0 ORDER BY a.created DESC
16 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_content'