Your 'Port' has been chosen Clear this filter or visit another page to change

Caudebec, France

Caudebec is a commune in the Seine-Maritime department in the Haute-Normandie region in northern France. It is located 27 miles (43 km) W.N.W. of Rouen, on the right bank of the River Seine.

Attractions in Caudebec include the Marine Museum of the Seine, the House of the Templars and the Church of Caudebec-en-Caux.

Things to see and do

* Church of Caudebec-en-Caux
* Maison des Templiers (The Templars' House)
* The riverside embankments (Les Quais)
* Musée de la marine de Seine – Museum on the history of river navigation
* The former prison from the fourteenth century

Cruise Season – March - Dec
Currency – Euro (EUR)
Language – French
Land Area – 4.93 km²
Population – 2,322 approx
Electricity – 2 round pins European style.
Time – UTC plus five hours
International Country Telephone Code – + 44

Port Location – The river port at Caudebec is located on the River Seine.

#	Query	Time
(1)	connect	0.00086092948913574
(2)	DESCRIBE `ports`	0.0023870468139648
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'caudebec-france') AND (orchid_available = 1) LIMIT 1	0.013816118240356
(4)	DESCRIBE `destinations`	0.0025038719177246
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 50)))	0.00060606002807617
(6)	DESCRIBE `avid_specials`	0.0017440319061279
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '50' AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))	0.0018129348754883
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558')	0.00038695335388184
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1558')	0.0022008419036865
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1558')	0.0020458698272705
(11)	DESCRIBE `cruises`	0.0033109188079834
(12)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (75812, 76334, 76388, 76391, 78560, 80366, 75144, 63941, 78671, 75813)) ORDER BY FIND_IN_SET(id, '75812,76334,76388,76391,78560,80366,75144,63941,78671,75813')	0.0021231174468994
(13)	DESCRIBE `cruiselines`	0.0031437873840332
(14)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('96', '101', '131', '156', '276', '181', '140', '153')) ORDER BY FIND_IN_SET(id, '96,101,131,156,276,181,140,153')	0.0012109279632568
(15)	DESCRIBE `ships`	0.0041179656982422
(16)	SELECT `ships`.* FROM `ships` WHERE (id IN ('1455', '761', '1156', '1223', '1650', '559', '741', '672', '798', '1139', '804', '1157')) ORDER BY FIND_IN_SET(id, '1455,761,1156,1223,1650,559,741,672,798,1139,804,1157')	0.0021848678588867
(17)	DESCRIBE `cruisetypes`	0.0016500949859619
(18)	DESCRIBE `destinations`	0.0025341510772705
(19)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50')) ORDER BY FIND_IN_SET(id, '50')	0.00049996376037598
(20)	DESCRIBE `ports`	0.00201416015625
(21)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558)))	0.00045990943908691

Query

Time

(1)

connect

0.00086092948913574

(2)

DESCRIBE `ports`

0.0023870468139648

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'caudebec-france') AND (orchid_available = 1) LIMIT 1

0.013816118240356

(4)

DESCRIBE `destinations`

0.0025038719177246

(5)

SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 50)))

0.00060606002807617

(6)

DESCRIBE `avid_specials`

0.0017440319061279

(7)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '50' AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))

0.0018129348754883

(8)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558')

0.00038695335388184

(9)

SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1558')

0.0022008419036865

(10)

SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1558')

0.0020458698272705

(11)

DESCRIBE `cruises`

0.0033109188079834

(12)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (75812, 76334, 76388, 76391, 78560, 80366, 75144, 63941, 78671, 75813)) ORDER BY FIND_IN_SET(id, '75812,76334,76388,76391,78560,80366,75144,63941,78671,75813')

0.0021231174468994

(13)

DESCRIBE `cruiselines`

0.0031437873840332

(14)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('96', '101', '131', '156', '276', '181', '140', '153')) ORDER BY FIND_IN_SET(id, '96,101,131,156,276,181,140,153')

0.0012109279632568

(15)

DESCRIBE `ships`

0.0041179656982422

(16)

SELECT `ships`.* FROM `ships` WHERE (id IN ('1455', '761', '1156', '1223', '1650', '559', '741', '672', '798', '1139', '804', '1157')) ORDER BY FIND_IN_SET(id, '1455,761,1156,1223,1650,559,741,672,798,1139,804,1157')

0.0021848678588867

(17)

DESCRIBE `cruisetypes`

0.0016500949859619

(18)

DESCRIBE `destinations`

0.0025341510772705

(19)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50')) ORDER BY FIND_IN_SET(id, '50')

0.00049996376037598

(20)

DESCRIBE `ports`

0.00201416015625

(21)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558)))

0.00045990943908691

Find Your Cruise

Caudebec, France

Database Profiling Report