USA TODAY Cruise Log with Gene Sloan


Today's Travel Deals

24 queries took 200 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'be0da0a74725c3c192a3ef16f78d188b'000
2DESCRIBE `travel_guides`17171
3DESCRIBE `slideshows`19191
4DESCRIBE `slides`12121
5DESCRIBE `hotels`11111
6DESCRIBE `addresses`12121
7DESCRIBE `top_tens`17171
8SELECT * FROM site_pages WHERE url='/'110
9DESCRIBE `visitors`331
10INSERT INTO visitors SET created = NOW(), refer_id = 010
11SELECT * FROM visitors WHERE id = LAST_INSERT_ID()110
12DESCRIBE `visits`661
13DESCRIBE `refers`991
14INSERT INTO visits SET created = NOW(), visitor_id = 111000804, refer_id = 0, ip_address = '38.103.63.18', is_usatoday = 110
15SELECT LAST_INSERT_ID() AS id110
16(select 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 = 'Top 25' 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 order by rand() limit 8) union (select 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 = 'Air' 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 order by rand() limit 8) union (select 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 = 'Hotel' 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 order by rand() limit 8) union (select 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 = 'Package' 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 order by rand() limit 8) union (select 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 = 'Cruise' 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 order by rand() limit 8) union (select 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 order by rand() limit 8) union (select 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 = 'Luxury' 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 order by rand() limit 8)5656135
17select 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 (1102571, 1102028, 1102765, 1102579, 1102854, 1102461, 1102118, 1102641, 1102866, 1102328, 1098502, 1102890, 1099709, 1102603, 1102726, 1102839, 1102076, 1102857, 1102184, 1100398, 1102874, 1102179, 1099034, 1102368, 1102873, 1102856, 1102885, 1102305, 1102477, 1102772, 1102601, 1101480, 1102009, 1102737, 1102374, 1101442, 1102822, 1102778, 1102288, 1102738, 1101795, 1100614, 1102079, 1100571, 1102078, 1102353, 1100799, 1100234, 1101231, 1101611, 1102093, 1102688, 1102404) union select s.deal_id as id from snapshots s where s.deal_id in (1102571, 1102028, 1102765, 1102579, 1102854, 1102461, 1102118, 1102641, 1102866, 1102328, 1098502, 1102890, 1099709, 1102603, 1102726, 1102839, 1102076, 1102857, 1102184, 1100398, 1102874, 1102179, 1099034, 1102368, 1102873, 1102856, 1102885, 1102305, 1102477, 1102772, 1102601, 1101480, 1102009, 1102737, 1102374, 1101442, 1102822, 1102778, 1102288, 1102738, 1101795, 1100614, 1102079, 1100571, 1102078, 1102353, 1100799, 1100234, 1101231, 1101611, 1102093, 1102688, 1102404)557
18SELECT Establishment.*, ThumbnailImage.*, Place.geotag_short FROM establishments Establishment LEFT JOIN images ThumbnailImage ON (ThumbnailImage.type = 'Thumbnail' AND ThumbnailImage.association_id = Establishment.id) JOIN geotags Geotag ON Geotag.association_id = Establishment.id AND Geotag.association_type = 'Establishment' LEFT JOIN places Place ON Place.id = Geotag.place_id WHERE is_featured = 1 AND ThumbnailImage.url IS NOT NULL ORDER BY rand() LIMIT 11134
19SELECT TravelGuide.title, TravelGuide.subtitle, ArticleElement.content FROM travel_guides TravelGuide LEFT JOIN article_pages ArticlePage ON ArticlePage.article_id = TravelGuide.id AND ArticlePage.position = 1 LEFT JOIN article_elements ArticleElement ON ArticleElement.article_page_id = ArticlePage.id AND ArticleElement.position = 1 WHERE TravelGuide.is_published = 1 AND TravelGuide.is_featured = 1 ORDER BY rand() LIMIT 1113
20SELECT DISTINCT TopTen.title, TopTen.subtitle, ArticleElement.content, ThumbnailImage.url FROM top_tens TopTen JOIN images AS ThumbnailImage ON (ThumbnailImage.type = 'Thumbnail' AND ThumbnailImage.association_id = TopTen.id) JOIN article_pages ArticlePage ON ArticlePage.article_id = TopTen.id AND ArticlePage.position = 1 JOIN article_elements ArticleElement ON ArticleElement.article_page_id = ArticlePage.id AND ArticleElement.position = 1 WHERE TopTen.is_published = 1 GROUP BY TopTen.title ORDER BY rand() LIMIT 1118
21SELECT Slideshow.id, Slideshow.title, Slideshow.subtitle, Slideshow.display_date, Slideshow.unpublish_date, Slideshow.is_featured, Slideshow.is_published, Slide.* FROM slideshows Slideshow LEFT JOIN slides Slide ON Slide.association_id = Slideshow.id AND Slide.position = 1 WHERE Slideshow.article_type_id = 11 AND Slideshow.is_published = 1 AND CURDATE() BETWEEN Slideshow.display_date AND Slideshow.unpublish_date ORDER BY rand() LIMIT 1112
22SELECT Slide.* FROM slideshows Slideshow LEFT JOIN slides Slide ON Slide.association_id = Slideshow.id AND Slide.published = 1 WHERE Slideshow.article_type_id = 10 AND Slideshow.title = 'Homepage' 991
23SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'be0da0a74725c3c192a3ef16f78d188b'110
24INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config|a:3:{s:9:\"userAgent\";s:32:\"b260d25dcd9c138e5e653c28eaa88044\";s:4:\"time\";i:1210615028;s:4:\"rand\";i:1151276988;}userAgent|s:7:\"Unknown\";refer_id|i:0;refer_id_visitor_id|i:0;visit_id|s:8:\"14691953\";refer_id_visit_id|i:0;', 1210615029, 'be0da0a74725c3c192a3ef16f78d188b')11