USA TODAY Airfare Specials and Deals from Sherman's Travel

Airfare Deals

USA/ Canada | Europe | Carribean/ Mexico | Asia | More

Regions: Asia; Australia and Pacific; Caribbean

Countries: Aruba; Australia; Bermuda; Chile; China; Dominican Republic; Hong Kong; Italy; Jamaica; Japan; Mexico; New Zealand; Puerto Rico; Singapore; Thailand

Cities: Akron; Albany; Albuquerque; Amsterdam; Aspen; Athens; Atlanta; Auckland; Austin; Bali; Baltimore; Bangkok; Barcelona; Bari; Belo Horizonte; Berlin; more

28 queries took 64 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '01cro85385qu2r2uhoh4oddt46'	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/flights/'	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 = 111535631, refer_id = 0, ip_address = '38.103.63.17', 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 = 'air' limit 8	0	0	5
24	SELECT p.id, p.place_type_id, p.geotag_short, p.geotag_full, p.lineage_display FROM deals d INNER JOIN geotags g ON g.association_id = d.id AND g.association_type IN('Deal', 'EditorReview') AND g.tag_type_id NOT IN (4,11) INNER JOIN tag_records tr ON tr.association_id = d.id AND tr.association_type IN('Deal', 'EditorReview') INNER JOIN tags t ON t.id = tr.tag_id AND t.name IN ('air') INNER JOIN places p ON g.place_id = p.id WHERE d.is_published = 1 AND d.show_in_search_results = 1 AND d.sponsor_listing <> 1 AND d.date_to_show < NOW() AND d.date_to_remove > NOW() AND p.place_type_id IN (90) GROUP BY p.id ORDER BY p.geotag_full	169	169	23
25	SELECT p.id, p.place_type_id, p.geotag_short, p.geotag_full, p.lineage_display FROM deals d INNER JOIN geotags g ON g.association_id = d.id AND g.association_type IN('Deal', 'EditorReview') AND g.tag_type_id NOT IN (4,11) INNER JOIN tag_records tr ON tr.association_id = d.id AND tr.association_type IN('Deal', 'EditorReview') INNER JOIN tags t ON t.id = tr.tag_id AND t.name IN ('air') INNER JOIN places p ON g.place_id = p.id WHERE d.is_published = 1 AND d.show_in_search_results = 1 AND d.sponsor_listing <> 1 AND d.date_to_show < NOW() AND d.date_to_remove > NOW() AND p.place_type_id IN (30) GROUP BY p.id ORDER BY p.geotag_full	15	15	9
26	SELECT p.id, p.place_type_id, p.geotag_short, p.geotag_full, p.lineage_display FROM deals d INNER JOIN geotags g ON g.association_id = d.id AND g.association_type IN('Deal', 'EditorReview') AND g.tag_type_id NOT IN (4,11) INNER JOIN tag_records tr ON tr.association_id = d.id AND tr.association_type IN('Deal', 'EditorReview') INNER JOIN tags t ON t.id = tr.tag_id AND t.name IN ('air') INNER JOIN places p ON g.place_id = p.id WHERE d.is_published = 1 AND d.show_in_search_results = 1 AND d.sponsor_listing <> 1 AND d.date_to_show < NOW() AND d.date_to_remove > NOW() AND p.place_type_id IN (10, 20) GROUP BY p.id ORDER BY p.geotag_full	3	3	9
27	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '01cro85385qu2r2uhoh4oddt46'	1	1	0
28	INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config\|a:3:{s:9:\"userAgent\";s:32:\"b260d25dcd9c138e5e653c28eaa88044\";s:4:\"time\";i:1211126754;s:4:\"rand\";i:67636422;}userAgent\|s:7:\"Unknown\";refer_id\|i:0;refer_id_visitor_id\|i:0;visit_id\|s:8:\"15294900\";refer_id_visit_id\|i:0;', 1211126754, '01cro85385qu2r2uhoh4oddt46')	1		1

28 queries took 64 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '01cro85385qu2r2uhoh4oddt46'

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/flights/'

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 = 111535631, refer_id = 0, ip_address = '38.103.63.17', 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 = 'air' limit 8

SELECT p.id, p.place_type_id, p.geotag_short, p.geotag_full, p.lineage_display FROM deals d INNER JOIN geotags g ON g.association_id = d.id AND g.association_type IN('Deal', 'EditorReview') AND g.tag_type_id NOT IN (4,11) INNER JOIN tag_records tr ON tr.association_id = d.id AND tr.association_type IN('Deal', 'EditorReview') INNER JOIN tags t ON t.id = tr.tag_id AND t.name IN ('air') INNER JOIN places p ON g.place_id = p.id WHERE d.is_published = 1 AND d.show_in_search_results = 1 AND d.sponsor_listing <> 1 AND d.date_to_show < NOW() AND d.date_to_remove > NOW() AND p.place_type_id IN (90) GROUP BY p.id ORDER BY p.geotag_full

169

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

INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config|a:3:{s:9:\"userAgent\";s:32:\"b260d25dcd9c138e5e653c28eaa88044\";s:4:\"time\";i:1211126754;s:4:\"rand\";i:67636422;}userAgent|s:7:\"Unknown\";refer_id|i:0;refer_id_visitor_id|i:0;visit_id|s:8:\"15294900\";refer_id_visit_id|i:0;', 1211126754, '01cro85385qu2r2uhoh4oddt46')

USA TODAY Cruise Log with Gene Sloan

Airfare Deals

Cities