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

Hotel Deals

Hotel Deals: Las Vegas; Florida; New York; California; Hawaii; Other USA/ Canada; Caribbean/ Mexico; Europe; Luxury; Villas; More

25 queries took 17 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'pouboqbf19plbpnpiqd53pmg80'	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/hotels/'	1	1	0
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 = 111000789, 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 = 'hotel' limit 8	0	0	1
24	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'pouboqbf19plbpnpiqd53pmg80'	1	1	0
25	INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config\|a:3:{s:9:\"userAgent\";s:32:\"b260d25dcd9c138e5e653c28eaa88044\";s:4:\"time\";i:1210614988;s:4:\"rand\";i:1070004911;}userAgent\|s:7:\"Unknown\";refer_id\|i:0;refer_id_visitor_id\|i:0;visit_id\|s:8:\"14691937\";refer_id_visit_id\|i:0;', 1210614988, 'pouboqbf19plbpnpiqd53pmg80')	1		0

25 queries took 17 ms

Query

Error

Affected

Num. rows

Took (ms)

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

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

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 = 111000789, 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 = 'hotel' limit 8

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

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

USA TODAY Cruise Log with Gene Sloan

Hotel Deals