iStock International

Venice: Restaurants

As expected, Venice serves up excellent Italian dishes that are heavy on the seafood. Steer clear of touristy options on the main thoroughfares and opt for trusted recommendations (like those below) instead to avoid disappointment.

ALL
EXPENSIVE
MODERATE
BUDGET

Al Covo
This seafood restaurant’s bossy wait staff will bring the perfect plates to you if you describe what ingredients you prefer;...
seafood | reservations | pasta

Vino Vino
Right near the Teatro Fenice, this popular wine bar serves delicious reasonably priced food like octopus salad and rabbit...

Cip's Club
The fantastic view, the sound of the water lapping up against the shore, the delicious prawns with capers – not the most...
seafood | reservations | view

Corte Sconta
Call well ahead to get into this gem, especially if you want a table in the sought-after courtyard; savor fresh seafood dishes...
seafood | patio

Osteria da Fiore
This Michelin-starred restaurant serves some of the city’s best Venetian seafood; try the shrimp crostini and the striped bass.
seafood | notable chef

Gam-Gam
Known for falafels and fresh salads with cucumber and tomato, this Israeli restaurant run by Hasids is good for those hot days...
middle eastern

Iguana
When the endless seafood and pasta gets to be too much, stop in at this popular Mexican restaurant for guacamole and chips,...
mexican

Al Covo
This seafood restaurant’s bossy wait staff will bring the perfect plates to you if you describe what ingredients you prefer;...
seafood | reservations | pasta

Vino Vino
Right near the Teatro Fenice, this popular wine bar serves delicious reasonably priced food like octopus salad and rabbit...

Cip's Club
The fantastic view, the sound of the water lapping up against the shore, the delicious prawns with capers – not the most...
seafood | reservations | view

Corte Sconta
Call well ahead to get into this gem, especially if you want a table in the sought-after courtyard; savor fresh seafood dishes...
seafood | patio

Osteria da Fiore
This Michelin-starred restaurant serves some of the city’s best Venetian seafood; try the shrimp crostini and the striped bass.
seafood | notable chef

Gam-Gam
Known for falafels and fresh salads with cucumber and tomato, this Israeli restaurant run by Hasids is good for those hot days...
middle eastern

Iguana
When the endless seafood and pasta gets to be too much, stop in at this popular Mexican restaurant for guacamole and chips,...
mexican

Venice Travel Guide: Deals to Venice | Venice Neighborhoods | Things to do in Venice | Venice Hotels | Venice Restaurants | Venice Nightlife | Venice Shopping | Venice Day Trips | When to go to Venice | Getting to Venice | Venice Tips | Venice Additional Resources

Sponsored Links

42 queries took 945 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '75ko4uqqbdcd9q4hsphs1fug84'	0	0	0
2	DESCRIBE `travel_guides`	17	17	2
3	DESCRIBE `article_types`	2	2	1
4	DESCRIBE `authors`	5	5	1
5	DESCRIBE `images`	13	13	1
6	DESCRIBE `article_pages`	5	5	1
7	DESCRIBE `articles`	19	19	2
8	DESCRIBE `geotags`	5	5	1
9	DESCRIBE `places`	15	15	1
10	DESCRIBE `tag_types`	2	2	1
11	DESCRIBE `tags`	3	3	1
12	DESCRIBE `site_pages`	10	10	1
13	DESCRIBE `tag_records`	4	4	1
14	DESCRIBE `article_elements`	9	9	1
15	DESCRIBE `establishments`	15	15	1
16	DESCRIBE `addresses`	12	12	1
17	DESCRIBE `slideshows`	19	19	2
18	DESCRIBE `slides`	14	14	1
19	DESCRIBE `geocodes`	9	9	1
20	SELECT TravelGuide., ArticlePage., ArticleElement., ArticleImage., Place.lineage_display, Place.place_type_id FROM travel_guides AS TravelGuide LEFT JOIN article_pages ArticlePage ON ArticlePage.article_id = TravelGuide.id LEFT JOIN article_elements ArticleElement ON ArticleElement.article_page_id = ArticlePage.id AND ArticlePage.name IN ('Intro.','Hotels','Restaurants','Restaurants') LEFT JOIN geotags Geotag ON Geotag.association_id = TravelGuide.id AND Geotag.association_type = 'TravelGuide' LEFT JOIN places Place ON Geotag.place_id = Place.id LEFT JOIN images ArticleImage ON (ArticleImage.association_type='TravelGuide' AND ArticleImage.association_id=TravelGuide.id AND ArticleImage.type='Article') WHERE TravelGuide.title = 'Venice' AND (TravelGuide.is_published=1 OR 1=1) ORDER BY ArticlePage.position ASC, ArticleElement.position ASC	13	13	204
21	SELECT `Place`.`id`, `Place`.`country`, `Place`.`region`, `Place`.`city`, `Place`.`postal_code`, `Place`.`latitude`, `Place`.`longitude`, `Place`.`dma`, `Place`.`area_code`, `Place`.`place_type_id`, `Place`.`parent_id`, `Place`.`geotag_short`, `Place`.`geotag_full`, `Place`.`lineage`, `Place`.`lineage_display` FROM `places` AS `Place` WHERE `Place`.`geotag_short` = 'Venice' LIMIT 1	1	1	0
22	SELECT `Geotag`.`association_id`, `Geotag`.`place_id`, `Geotag`.`tag_type_id`, `Geotag`.`association_type`, `Geotag`.`id` FROM `geotags` AS `Geotag` WHERE `Geotag`.`place_id` = 56802	223	223	35
23	SELECT api_key FROM googlemaps_api_keys WHERE host = "usatoday.shermanstravel.com" LIMIT 1	0	0	17
24	SELECT * FROM site_pages WHERE url='/travel_guides/venice/restaurants/'	1	1	16
25	DESCRIBE `visitors`	3	3	1
26	INSERT INTO `visitors` (`refer_id`,`created`) VALUES (0,'2008-12-04 14:23:23')	1		0
27	DESCRIBE `visits`	6	6	1
28	DESCRIBE `refers`	9	9	1
29	INSERT INTO `visits` (`visitor_id`,`refer_id`,`ip_address`,`is_usatoday`,`created`) VALUES (124514257,0,'38.103.63.60','1','2008-12-04 14:23:23')	1		0
30	SELECT `ArticleType`.`id` FROM `article_types` AS `ArticleType` WHERE name = 'Travel Guide' LIMIT 1	1	1	0
31	SELECT Establishment., Address., GROUP_CONCAT(DISTINCT Tag.name SEPARATOR ',') as tags, Place.geotag_short FROM establishments Establishment LEFT JOIN addresses Address ON Address.id = Establishment.address_id LEFT JOIN tag_records tr ON tr.association_type = 'Establishment' AND tr.association_id = Establishment.id LEFT JOIN tags Tag ON tr.tag_id = Tag.id LEFT JOIN geotags g ON g.association_type = 'Establishment' AND g.association_id = Establishment.id LEFT JOIN places Place ON Place.id = g.place_id WHERE Establishment.is_published = 1 AND g.place_id IN ( SELECT place_id FROM geotags WHERE association_type = 'ArticlePage' AND association_id IN (1) UNION SELECT place_id FROM geotags WHERE association_type = 'TravelGuide' AND association_id = 1099467 ) GROUP BY Establishment.id ORDER BY Establishment.name ASC	40	40	496
32	(select tags1.name as tag_name, data.* from (select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) 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' order by data.modified desc limit 8) union (select tags1.name as tag_name, data.* from (select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) 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' order by data.modified desc limit 8) union (select tags1.name as tag_name, data.* from (select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) 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' order by data.modified desc limit 8) union (select tags1.name as tag_name, data.* from (select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) 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' order by data.modified desc limit 8) union (select tags1.name as tag_name, data.* from (select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) 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' order by data.modified desc limit 8)	1	1	25
33	select 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' or t.name='Search Results Only') and tr.association_id in (1079533) union select s.deal_id as id from snapshots s where s.deal_id in (1079533)	0	0	2
34	SELECT at.name FROM articles a JOIN article_types at ON (at.id = a.article_type_id) WHERE a.id ='1099467'	1	1	0
35	SELECT p.geotag_short FROM geotags g JOIN places p ON ( p.id = g.place_id) WHERE g.association_type = 'TravelGuide' and g.association_id = '1099467'	1	1	1
36	SELECT t.name FROM tag_records tr JOIN tags t ON ( t.id = tr.tag_id) WHERE tr.association_type = 'TravelGuide' and tr.association_id = '1099467' AND t.name IN ('Air', 'Hotel', 'Package', 'Cruise', 'Car')	0	0	1
37	SELECT a.id as id, a.title, a.subtitle, a.article_type_id, at.name as type from articles a join article_types at on (at.id = a.article_type_id) join geotags g on (g.association_type IN ("TravelGuide", "Guide101", "Spotlight", "TopTen", "PerfectTrip", "Slideshow") and g.association_id = a.id) join places p on (p.id = g.place_id) where a.id != "1099467" and (p.geotag_short IN ("Venice") or ( p.id in (select child_id from place_descendents where geotag_short IN ("Venice")))) and g.tag_type_id not in (4, 11) and a.is_published=1 GROUP BY a.id ORDER BY rand() LIMIT 5	3	3	121
38	select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4)	0	0	2
39	DESCRIBE `pixels`	10	10	1
40	SELECT `Pixel`.`code`, `Pixel`.`refer` FROM `pixels` AS `Pixel` WHERE `Pixel`.`type` = 'widersite-page' and `Pixel`.`page` = '' and `Pixel`.`published` = 1 and start_date < NOW() and end_date > NOW()	0	0	0
41	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '75ko4uqqbdcd9q4hsphs1fug84'	1	1	0
42	INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config\|a:3:{s:9:\"userAgent\";s:32:\"b260d25dcd9c138e5e653c28eaa88044\";s:4:\"time\";i:1228454602;s:4:\"rand\";i:1051978732;}userAgent\|s:7:\"Unknown\";refer_id\|i:0;refer_id_visitor_id\|i:0;visit_id\|i:19437104;refer_id_visit_id\|i:0;', 1228454604, '75ko4uqqbdcd9q4hsphs1fug84')	1		0

42 queries took 945 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '75ko4uqqbdcd9q4hsphs1fug84'

DESCRIBE `travel_guides`

DESCRIBE `article_types`

DESCRIBE `authors`

DESCRIBE `images`

DESCRIBE `article_pages`

DESCRIBE `articles`

DESCRIBE `geotags`

DESCRIBE `places`

DESCRIBE `tag_types`

DESCRIBE `tags`

DESCRIBE `site_pages`

DESCRIBE `tag_records`

DESCRIBE `article_elements`

DESCRIBE `establishments`

DESCRIBE `addresses`

DESCRIBE `slideshows`

DESCRIBE `slides`

DESCRIBE `geocodes`

SELECT TravelGuide.*, ArticlePage.*, ArticleElement.*, ArticleImage.*, Place.lineage_display, Place.place_type_id FROM travel_guides AS TravelGuide LEFT JOIN article_pages ArticlePage ON ArticlePage.article_id = TravelGuide.id LEFT JOIN article_elements ArticleElement ON ArticleElement.article_page_id = ArticlePage.id AND ArticlePage.name IN ('Intro.','Hotels','Restaurants','Restaurants') LEFT JOIN geotags Geotag ON Geotag.association_id = TravelGuide.id AND Geotag.association_type = 'TravelGuide' LEFT JOIN places Place ON Geotag.place_id = Place.id LEFT JOIN images ArticleImage ON (ArticleImage.association_type='TravelGuide' AND ArticleImage.association_id=TravelGuide.id AND ArticleImage.type='Article') WHERE TravelGuide.title = 'Venice' AND (TravelGuide.is_published=1 OR 1=1) ORDER BY ArticlePage.position ASC, ArticleElement.position ASC

204

SELECT `Place`.`id`, `Place`.`country`, `Place`.`region`, `Place`.`city`, `Place`.`postal_code`, `Place`.`latitude`, `Place`.`longitude`, `Place`.`dma`, `Place`.`area_code`, `Place`.`place_type_id`, `Place`.`parent_id`, `Place`.`geotag_short`, `Place`.`geotag_full`, `Place`.`lineage`, `Place`.`lineage_display` FROM `places` AS `Place` WHERE `Place`.`geotag_short` = 'Venice' LIMIT 1

SELECT `Geotag`.`association_id`, `Geotag`.`place_id`, `Geotag`.`tag_type_id`, `Geotag`.`association_type`, `Geotag`.`id` FROM `geotags` AS `Geotag` WHERE `Geotag`.`place_id` = 56802

223

SELECT api_key FROM googlemaps_api_keys WHERE host = "usatoday.shermanstravel.com" LIMIT 1

SELECT * FROM site_pages WHERE url='/travel_guides/venice/restaurants/'

DESCRIBE `visitors`

INSERT INTO `visitors` (`refer_id`,`created`) VALUES (0,'2008-12-04 14:23:23')

DESCRIBE `visits`

DESCRIBE `refers`

INSERT INTO `visits` (`visitor_id`,`refer_id`,`ip_address`,`is_usatoday`,`created`) VALUES (124514257,0,'38.103.63.60','1','2008-12-04 14:23:23')

SELECT `ArticleType`.`id` FROM `article_types` AS `ArticleType` WHERE name = 'Travel Guide' LIMIT 1

SELECT Establishment.*, Address.*, GROUP_CONCAT(DISTINCT Tag.name SEPARATOR ',') as tags, Place.geotag_short FROM establishments Establishment LEFT JOIN addresses Address ON Address.id = Establishment.address_id LEFT JOIN tag_records tr ON tr.association_type = 'Establishment' AND tr.association_id = Establishment.id LEFT JOIN tags Tag ON tr.tag_id = Tag.id LEFT JOIN geotags g ON g.association_type = 'Establishment' AND g.association_id = Establishment.id LEFT JOIN places Place ON Place.id = g.place_id WHERE Establishment.is_published = 1 AND g.place_id IN ( SELECT place_id FROM geotags WHERE association_type = 'ArticlePage' AND association_id IN (1) UNION SELECT place_id FROM geotags WHERE association_type = 'TravelGuide' AND association_id = 1099467 ) GROUP BY Establishment.id ORDER BY Establishment.name ASC

496

(select tags1.name as tag_name, data.* from (select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) 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' order by data.modified desc limit 8) union (select tags1.name as tag_name, data.* from (select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) 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' order by data.modified desc limit 8) union (select tags1.name as tag_name, data.* from (select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) 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' order by data.modified desc limit 8) union (select tags1.name as tag_name, data.* from (select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) 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' order by data.modified desc limit 8) union (select tags1.name as tag_name, data.* from (select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) 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' order by data.modified desc limit 8)

select 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' or t.name='Search Results Only') and tr.association_id in (1079533) union select s.deal_id as id from snapshots s where s.deal_id in (1079533)

SELECT at.name FROM articles a JOIN article_types at ON (at.id = a.article_type_id) WHERE a.id ='1099467'

SELECT p.geotag_short FROM geotags g JOIN places p ON ( p.id = g.place_id) WHERE g.association_type = 'TravelGuide' and g.association_id = '1099467'

SELECT t.name FROM tag_records tr JOIN tags t ON ( t.id = tr.tag_id) WHERE tr.association_type = 'TravelGuide' and tr.association_id = '1099467' AND t.name IN ('Air', 'Hotel', 'Package', 'Cruise', 'Car')

SELECT a.id as id, a.title, a.subtitle, a.article_type_id, at.name as type from articles a join article_types at on (at.id = a.article_type_id) join geotags g on (g.association_type IN ("TravelGuide", "Guide101", "Spotlight", "TopTen", "PerfectTrip", "Slideshow") and g.association_id = a.id) join places p on (p.id = g.place_id) where a.id != "1099467" and (p.geotag_short IN ("Venice") or ( p.id in (select child_id from place_descendents where geotag_short IN ("Venice")))) and g.tag_type_id not in (4, 11) and a.is_published=1 GROUP BY a.id ORDER BY rand() LIMIT 5

121

select STRAIGHT_JOIN data.* from places p0 inner join geotags g on p0.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Venice' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4)

DESCRIBE `pixels`

SELECT `Pixel`.`code`, `Pixel`.`refer` FROM `pixels` AS `Pixel` WHERE `Pixel`.`type` = 'widersite-page' and `Pixel`.`page` = '' and `Pixel`.`published` = 1 and start_date < NOW() and end_date > NOW()

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

INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config|a:3:{s:9:\"userAgent\";s:32:\"b260d25dcd9c138e5e653c28eaa88044\";s:4:\"time\";i:1228454602;s:4:\"rand\";i:1051978732;}userAgent|s:7:\"Unknown\";refer_id|i:0;refer_id_visitor_id|i:0;visit_id|i:19437104;refer_id_visit_id|i:0;', 1228454604, '75ko4uqqbdcd9q4hsphs1fug84')

USA TODAY Cruise Log with Gene Sloan

Venice: Restaurants

Sponsored Links