53 queries executed
1
SET sql_mode = 'MYSQL40'
2 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 SELECT id, link FROM jos_menu WHERE menutype = 'mainmenu' AND published = 1 ORDER BY parent, ordering LIMIT 1
4 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 1 ) ORDER BY menuid DESC LIMIT 1
5 DELETE FROM jos_session WHERE ( ( time < '1327760399' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1327760399' ) AND guest = 1 AND userid = 0 )
6 SELECT * FROM `jos_jstats_configuration`
7 SELECT exclude, type, tld, id FROM jos_jstats_ipaddresses WHERE ip = '38.107.179.213' AND useragent = 'ccbot/1.0 (+http://www.commoncrawl.org/bot.html)'
8 SELECT country_code2 FROM jos_jstats_iptocountry WHERE inet_aton('38.107.179.213') >= ip_from AND inet_aton('38.107.179.213') <= ip_to
9 SELECT LENGTH(browser_string) AS strlen, browser_string, browser_fullname FROM jos_jstats_browsers ORDER BY strlen DESC
10 SELECT LENGTH(bot_string) AS strlen, bot_string,bot_fullname FROM jos_jstats_bots ORDER BY strlen DESC
11 SELECT LENGTH(sys_string) AS strlen, sys_string, sys_fullname FROM jos_jstats_systems ORDER BY strlen DESC
12 INSERT INTO jos_jstats_ipaddresses (ip, nslookup, useragent, tld, system, browser, type) VALUES ('38.107.179.213', '38.107.179.213', 'ccbot/1.0 (+http://www.commoncrawl.org/bot.html)', 'us', '', 'Unknown robot (identified by crawl)', 2)
13 SELECT id FROM jos_jstats_ipaddresses WHERE ip = '38.107.179.213' AND useragent = 'ccbot/1.0 (+http://www.commoncrawl.org/bot.html)'
14 SELECT id FROM jos_jstats_visits WHERE month = MONTH(DATE_ADD(NOW(), INTERVAL -3 HOUR)) AND year = YEAR(DATE_ADD(NOW(), INTERVAL -3 HOUR)) AND ip_id = '18632' AND time >= DATE_ADD(DATE_ADD(NOW(), INTERVAL -3 HOUR), INTERVAL -480 MINUTE)
15 INSERT INTO jos_jstats_visits (ip_id, hour, day, month, year, time, userid) VALUES (18632, HOUR(DATE_ADD(NOW(), INTERVAL -3 HOUR)), DAYOFMONTH(DATE_ADD(NOW(), INTERVAL -3 HOUR)), MONTH(DATE_ADD(NOW(), INTERVAL -3 HOUR)), YEAR(DATE_ADD(NOW(), INTERVAL -3 HOUR)), DATE_ADD(NOW(), INTERVAL -3 HOUR), '0')
16 SELECT page_id, page_title FROM jos_jstats_pages WHERE page = '/Sausee/'
17 INSERT INTO jos_jstats_page_request (page_id, hour, day, month, year, ip_id) VALUES (3, HOUR(DATE_ADD(NOW(), INTERVAL -3 HOUR)), DAYOFMONTH(DATE_ADD(NOW(), INTERVAL -3 HOUR)), MONTH(DATE_ADD(NOW(), INTERVAL -3 HOUR)), YEAR(DATE_ADD(NOW(), INTERVAL -3 HOUR)), 39568)
18 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 0
19 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 0
20 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 1
21 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 1
22 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 2
23 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 2
24 SELECT * FROM jos_menu WHERE id = 1
25 SELECT COUNT(a.id) FROM jos_content AS a INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid 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.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 08:34' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 08:34' ) AND s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0
26 SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits, CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups , s.id AS sec_id, cc.id as cat_id FROM jos_content AS a INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid 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.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 08:34' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 08:34' ) AND s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0 ORDER BY f.ordering LIMIT 4
27 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
28 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
29 SELECT * FROM jos_mambots WHERE id = '48'
30 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
31 SELECT * FROM jos_mambots WHERE id = '48'
32 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
33 SELECT * FROM jos_mambots WHERE id = '48'
34 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
35 SELECT * FROM jos_mambots WHERE id = '48'
36 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
37 SELECT m.* FROM jos_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
38 SELECT m.* FROM jos_menu AS m WHERE menutype = 'othermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
39 SELECT m.* FROM jos_menu AS m WHERE menutype = 'usermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
40 SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 OR mm.menuid = 1 ) ORDER BY ordering
41 SELECT a.* FROM jos_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'
42 SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM jos_comprofiler_plugin WHERE published = 1 AND access <= 0 AND type = 'user' ORDER BY ordering
43 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
44 SELECT * FROM jos_mambots WHERE id = '48'
45 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
46 SELECT * FROM jos_mambots WHERE id = '48'
47 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
48 SELECT * FROM jos_mambots WHERE id = '48'
49 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
50 SELECT * FROM jos_mambots WHERE id = '48'
51 SELECT id, name, link, parent, type, menutype, access FROM jos_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
52 SELECT DATE_FORMAT(modified,'%W %e %M %Y, %k:%i') AS mod_date, modified FROM jos_content ORDER BY modified DESC LIMIT 1
53 SELECT DATE_FORMAT(created,'%W %e %M %Y, %k:%i') AS create_date, created FROM jos_content ORDER BY created DESC LIMIT 1