[eluser]dreamynsx[/eluser]
I'm not sure why there are a lot of queries to update the ci_sessions table just for this single page load? I get this on every page on my site. Any ideas on why there are so many queries? I'm not explicitly saving anything to the session on this particular page load.
I'm also using freakauth authentication system if that matters.
Quote:0.0004 SELECT * FROM (`ci_sessions`) WHERE `session_id` = '66d8742f0e3ace45944a9ee3bf2b6f9a' AND last_activity > 1211150642
0.0005 UPDATE ci_sessions SET last_activity = 1211157842, user_agent = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', ip_address = '99.202.109.186', user_id = 0, session_data = 'a:2:{s:7:\"user_id\";i:0;s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '66d8742f0e3ace45944a9ee3bf2b6f9a'
0.0002 UPDATE ci_sessions SET last_activity = 1211157842, user_agent = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', ip_address = '99.202.109.186', user_id = 0, session_data = 'a:3:{s:7:\"user_id\";i:0;s:24:\"flash:new:requested_page\";b:0;s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '66d8742f0e3ace45944a9ee3bf2b6f9a'
0.0002 UPDATE ci_sessions SET last_activity = 1211157842, user_agent = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', ip_address = '99.202.109.186', user_id = 0, session_data = 'a:2:{s:7:\"user_id\";i:0;s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '66d8742f0e3ace45944a9ee3bf2b6f9a'
0.0044 SELECT * FROM (`banners`) WHERE (did = '1') AND publish_date <= '2008-05-18 19:44:02' ORDER BY `publish_date` DESC, id DESC LIMIT 10
0.0002 SELECT * FROM (`news`) WHERE `domain` = 1 ORDER BY `date` DESC LIMIT 1
0.0020 SELECT * FROM (`products`) LEFT JOIN `products_camp_info` ON products_camp_info.product_id = products.id WHERE products.domain = '1' AND display = '1' AND end_date >= '2008-05-18' ORDER BY RAND() LIMIT 4
0.0002 SELECT * FROM (`photos`) WHERE `id` = '9676'
0.0004 UPDATE ci_sessions SET last_activity = 1211157842, user_agent = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', ip_address = '99.202.109.186', user_id = 0, session_data = 'a:3:{s:7:\"user_id\";i:0;s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";s:1:\"/\";}' WHERE session_id = '66d8742f0e3ace45944a9ee3bf2b6f9a'
0.0002 UPDATE ci_sessions SET last_activity = 1211157842, user_agent = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', ip_address = '99.202.109.186', user_id = 0, session_data = 'a:3:{s:7:\"user_id\";i:0;s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '66d8742f0e3ace45944a9ee3bf2b6f9a'
0.0003 UPDATE ci_sessions SET last_activity = 1211157842, user_agent = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', ip_address = '99.202.109.186', user_id = 0, session_data = 'a:3:{s:7:\"user_id\";i:0;s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";s:1:\"/\";}' WHERE session_id = '66d8742f0e3ace45944a9ee3bf2b6f9a'
0.0002 UPDATE ci_sessions SET last_activity = 1211157842, user_agent = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', ip_address = '99.202.109.186', user_id = 0, session_data = 'a:3:{s:7:\"user_id\";i:0;s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '66d8742f0e3ace45944a9ee3bf2b6f9a'
[code]
