USA TODAY Airfare Specials and Deals from Sherman's Travel

FLIGHT DEALS: USA/ Canada Europe Carribean/ Mexico
Asia More
HOTEL DEALS: Las Vegas Florida New York California Hawaii Other USA/ Canada
Caribbean/ Mexico Europe Luxury Villas More
VACATION DEALS: Hawaii Las Vegas Florida New York California Other USA/ Canada
Caribbean/ Mexico Europe Luxury More
CRUISE DEALS: Caribbean/ Bermuda Alaska Hawaii Mexico New England
Pacific Coast Europe More

Cruise Deals

Cruise Deals: Caribbean/ Bermuda; Alaska; Hawaii; Mexico; New England; Pacific Coast; Europe; More

26 queries took 54 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'obsu8q188jm00k0iumr4pmfin7'	0	0	0
2	DESCRIBE `deals`	30	30	1
3	DESCRIBE `geotags`	5	5	1
4	DESCRIBE `places`	15	15	1
5	DESCRIBE `tag_types`	2	2	1
6	DESCRIBE `tags`	3	3	1
7	DESCRIBE `site_pages`	10	10	1
8	DESCRIBE `article_pages`	5	5	1
9	DESCRIBE `articles`	19	19	1
10	DESCRIBE `article_types`	2	2	1
11	DESCRIBE `authors`	5	5	1
12	DESCRIBE `images`	12	12	1
13	DESCRIBE `tag_records`	4	4	1
14	DESCRIBE `article_elements`	9	9	1
15	SELECT * FROM site_pages WHERE url='/deals/index/cruises/'	1	1	1
16	DESCRIBE `visitors`	3	3	1
17	INSERT INTO visitors SET created = NOW(), refer_id = 0	1		0
18	SELECT * FROM visitors WHERE id = LAST_INSERT_ID()	1	1	0
19	DESCRIBE `visits`	6	6	1
20	DESCRIBE `refers`	9	9	1
21	INSERT INTO visits SET created = NOW(), visitor_id = 110807652, refer_id = 0, ip_address = '38.103.63.18', is_usatoday = 1	1		0
22	SELECT LAST_INSERT_ID() AS id	1	1	0
23	select 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 = 'cruise' limit 8	5	5	5
24	SELECT DISTINCT p.id, p.geotag_short FROM deals d INNER JOIN geotags g ON g.association_id = d.id AND g.association_type = 'Deal' INNER JOIN tag_records tr ON tr.association_id = d.id AND tr.association_type = 'Deal' INNER JOIN tags t ON tr.tag_id = t.id INNER JOIN places p ON g.place_id = p.id WHERE g.tag_type_id = 4 AND d.date_to_remove > now() AND t.name = 'Cruise' ORDER BY p.geotag_short	49	49	32
25	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'obsu8q188jm00k0iumr4pmfin7'	1	1	0
26	INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config\|a:3:{s:9:\"userAgent\";s:32:\"b260d25dcd9c138e5e653c28eaa88044\";s:4:\"time\";i:1210413485;s:4:\"rand\";i:1703689456;}userAgent\|s:7:\"Unknown\";refer_id\|i:0;refer_id_visitor_id\|i:0;visit_id\|s:8:\"14486154\";refer_id_visit_id\|i:0;', 1210413486, 'obsu8q188jm00k0iumr4pmfin7')	1		0

26 queries took 54 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'obsu8q188jm00k0iumr4pmfin7'

DESCRIBE `deals`

DESCRIBE `geotags`

DESCRIBE `places`

DESCRIBE `tag_types`

DESCRIBE `tags`

DESCRIBE `site_pages`

DESCRIBE `article_pages`

DESCRIBE `articles`

DESCRIBE `article_types`

DESCRIBE `authors`

DESCRIBE `images`

DESCRIBE `tag_records`

DESCRIBE `article_elements`

SELECT * FROM site_pages WHERE url='/deals/index/cruises/'

DESCRIBE `visitors`

INSERT INTO visitors SET created = NOW(), refer_id = 0

SELECT * FROM visitors WHERE id = LAST_INSERT_ID()

DESCRIBE `visits`

DESCRIBE `refers`

INSERT INTO visits SET created = NOW(), visitor_id = 110807652, refer_id = 0, ip_address = '38.103.63.18', is_usatoday = 1

SELECT LAST_INSERT_ID() AS id

select 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 = 'cruise' limit 8

SELECT DISTINCT p.id, p.geotag_short FROM deals d INNER JOIN geotags g ON g.association_id = d.id AND g.association_type = 'Deal' INNER JOIN tag_records tr ON tr.association_id = d.id AND tr.association_type = 'Deal' INNER JOIN tags t ON tr.tag_id = t.id INNER JOIN places p ON g.place_id = p.id WHERE g.tag_type_id = 4 AND d.date_to_remove > now() AND t.name = 'Cruise' ORDER BY p.geotag_short

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'obsu8q188jm00k0iumr4pmfin7'

INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config|a:3:{s:9:\"userAgent\";s:32:\"b260d25dcd9c138e5e653c28eaa88044\";s:4:\"time\";i:1210413485;s:4:\"rand\";i:1703689456;}userAgent|s:7:\"Unknown\";refer_id|i:0;refer_id_visitor_id|i:0;visit_id|s:8:\"14486154\";refer_id_visit_id|i:0;', 1210413486, 'obsu8q188jm00k0iumr4pmfin7')

USA TODAY Cruise Log with Gene Sloan

Cruise Deals