USA TODAY Cruise Log with Gene Sloan


Car Rental Deals

Today's Top Car Rental Deals

18 queries took 41 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'o3f534asd15s5lnn8a8c64sn96'000
2SELECT * FROM site_pages WHERE url='/deals/index/cars/'111
3DESCRIBE `visitors`331
4INSERT INTO visitors SET created = NOW(), refer_id = 010
5SELECT * FROM visitors WHERE id = LAST_INSERT_ID()110
6DESCRIBE `visits`661
7DESCRIBE `refers`991
8INSERT INTO visits SET created = NOW(), visitor_id = 111000794, refer_id = 0, ip_address = '38.103.63.18', is_usatoday = 110
9SELECT LAST_INSERT_ID() AS id110
10select tags1.name as tag_name, data.* from deals data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'car' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.sponsor_listing='0' and (data.parent_id is null or data.parent_id='0') order by rand()131320
11select tr.association_id as id from tags t inner join tag_records tr on t.id=tr.tag_id where association_type = 'Deal' and t.name='PSN Only' and tr.association_id in (1100570, 1100799, 1102079, 1101967, 1100614, 1102078, 1102080, 1100234, 1101336, 1101795, 31688, 1100571, 1102353) union select s.deal_id as id from snapshots s where s.deal_id in (1100570, 1100799, 1102079, 1101967, 1100614, 1102078, 1102080, 1100234, 1101336, 1101795, 31688, 1100571, 1102353)333
12select tags1.name as tag_name, data.*, sponsors.image from deals data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id left join sponsors on sponsors.id = data.sponsor_id where tr1.association_type='Deal' and tags1.name = 'car' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.sponsor_listing='1' order by data.sort_order asc, data.created desc557
13select tr.association_id as id from tags t inner join tag_records tr on t.id=tr.tag_id where association_type = 'Deal' and t.name='PSN Only' and tr.association_id in (1101993, 1101990, 1101987, 1100748, 1099565) union select s.deal_id as id from snapshots s where s.deal_id in (1101993, 1101990, 1101987, 1100748, 1099565)000
14select tags1.name as tag_name, data.* from deals data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'car' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.parent_id IN (1101993, 1101990, 1101987, 1100748, 1099565) order by data.sort_order asc, data.created desc15153
15select tr.association_id as id from tags t inner join tag_records tr on t.id=tr.tag_id where association_type = 'Deal' and t.name='PSN Only' and tr.association_id in (1101991, 1101992, 1100749, 1100750, 1100751, 1101995, 1101988, 1099567, 1102002, 1101994, 1099568, 1102294, 1101989, 1099566, 1100503) union select s.deal_id as id from snapshots s where s.deal_id in (1101991, 1101992, 1100749, 1100750, 1100751, 1101995, 1101988, 1099567, 1102002, 1101994, 1099568, 1102294, 1101989, 1099566, 1100503)000
16select tags1.name as tag_name, data.* from articles data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type IN ('TravelGuide', 'Guide101', 'Spotlight', 'TopTen', 'PerfectTrip', 'Slideshow') and tags1.name = 'car' limit 8004
17SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'o3f534asd15s5lnn8a8c64sn96'110
18INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config|a:3:{s:9:\"userAgent\";s:32:\"b260d25dcd9c138e5e653c28eaa88044\";s:4:\"time\";i:1210615003;s:4:\"rand\";i:2035811153;}userAgent|s:7:\"Unknown\";refer_id|i:0;refer_id_visitor_id|i:0;visit_id|s:8:\"14691942\";refer_id_visit_id|i:0;', 1210615004, 'o3f534asd15s5lnn8a8c64sn96')10