Viking River Cruises

Your 'Cruise Line' has been chosenClear this filter or visit another page to change

Viking River Cruises

When it comes to river cruising, Viking River Cruises is the world leader. From Europe to Russia, from China to Southeast Asia, we offer cruises... ... Read More »

Star Rating River

Star Rating	River

#	Query	Time
(1)	connect	0.0015110969543457
(2)	DESCRIBE `cruiselines`	0.004666805267334
(3)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'viking-river-cruises') AND (orchid_available = 1) LIMIT 1	0.0014231204986572
(4)	DESCRIBE `avid_specials`	0.0034468173980713
(5)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '77' AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))	0.0029420852661133
(6)	DESCRIBE `orchid_image`	0.0033299922943115
(7)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77')	0.00075697898864746
(8)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14')	0.00050091743469238
(9)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14')	0.00048708915710449
(10)	DESCRIBE `cruises`	0.0062448978424072
(11)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (69663, 69797, 69843, 74832, 74882, 74899, 74904, 74932, 74936, 75016)) ORDER BY FIND_IN_SET(id, '69663,69797,69843,74832,74882,74899,74904,74932,74936,75016')	0.0018129348754883
(12)	DESCRIBE `ships`	0.0058739185333252
(13)	SELECT `ships`.* FROM `ships` WHERE (id IN ('1233', '1602', '1733', '883', '1145', '1149', '1027', '1367', '1151', '1326', '1327', '1820', '1715', '1344', '1716', '1143', '1144', '1226', '1229', '1343', '1452', '1453', '1604', '1137', '1152', '1136', '1150', '1448', '1025', '1090', '1026', '1146', '1713', '1230', '1231', '1458', '1714', '1366', '1148', '1340', '1368', '1459', '1708', '1360', '1361', '1362', '1339', '299', '300', '1225', '1451', '1709', '1710', '1142', '1316', '1341', '1298', '1342', '1024', '1113', '1089', '1167', '1640', '1345', '962', '994', '995')) ORDER BY FIND_IN_SET(id, '1233,1602,1733,883,1145,1149,1027,1367,1151,1326,1327,1820,1715,1344,1716,1143,1144,1226,1229,1343,1452,1453,1604,1137,1152,1136,1150,1448,1025,1090,1026,1146,1713,1230,1231,1458,1714,1366,1148,1340,1368,1459,1708,1360,1361,1362,1339,299,300,1225,1451,1709,1710,1142,1316,1341,1298,1342,1024,1113,1089,1167,1640,1345,962,994,995')	0.018526077270508
(14)	DESCRIBE `cruisetypes`	0.0027148723602295
(15)	DESCRIBE `destinations`	0.003896951675415
(16)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '44', '54')) ORDER BY FIND_IN_SET(id, '50,44,54')	0.0012860298156738
(17)	DESCRIBE `cruiselines`	0.0043601989746094
(18)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77)))	0.00073719024658203
(19)	DESCRIBE `cruiselines`	0.004673957824707
(20)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77)))	0.00095391273498535

Query

Time

(1)

connect

0.0015110969543457

(2)

DESCRIBE `cruiselines`

0.004666805267334

(3)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'viking-river-cruises') AND (orchid_available = 1) LIMIT 1

0.0014231204986572

(4)

DESCRIBE `avid_specials`

0.0034468173980713

(5)

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

0.0029420852661133

(6)

DESCRIBE `orchid_image`

0.0033299922943115

(7)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77')

0.00075697898864746

(8)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14')

0.00050091743469238

(9)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14')

0.00048708915710449

(10)

DESCRIBE `cruises`

0.0062448978424072

(11)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (69663, 69797, 69843, 74832, 74882, 74899, 74904, 74932, 74936, 75016)) ORDER BY FIND_IN_SET(id, '69663,69797,69843,74832,74882,74899,74904,74932,74936,75016')

0.0018129348754883

(12)

DESCRIBE `ships`

0.0058739185333252

(13)

SELECT `ships`.* FROM `ships` WHERE (id IN ('1233', '1602', '1733', '883', '1145', '1149', '1027', '1367', '1151', '1326', '1327', '1820', '1715', '1344', '1716', '1143', '1144', '1226', '1229', '1343', '1452', '1453', '1604', '1137', '1152', '1136', '1150', '1448', '1025', '1090', '1026', '1146', '1713', '1230', '1231', '1458', '1714', '1366', '1148', '1340', '1368', '1459', '1708', '1360', '1361', '1362', '1339', '299', '300', '1225', '1451', '1709', '1710', '1142', '1316', '1341', '1298', '1342', '1024', '1113', '1089', '1167', '1640', '1345', '962', '994', '995')) ORDER BY FIND_IN_SET(id, '1233,1602,1733,883,1145,1149,1027,1367,1151,1326,1327,1820,1715,1344,1716,1143,1144,1226,1229,1343,1452,1453,1604,1137,1152,1136,1150,1448,1025,1090,1026,1146,1713,1230,1231,1458,1714,1366,1148,1340,1368,1459,1708,1360,1361,1362,1339,299,300,1225,1451,1709,1710,1142,1316,1341,1298,1342,1024,1113,1089,1167,1640,1345,962,994,995')

0.018526077270508

(14)

DESCRIBE `cruisetypes`

0.0027148723602295

(15)

DESCRIBE `destinations`

0.003896951675415

(16)

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

0.0012860298156738

(17)

DESCRIBE `cruiselines`

0.0043601989746094

(18)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77)))

0.00073719024658203

(19)

DESCRIBE `cruiselines`

0.004673957824707

(20)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77)))

0.00095391273498535

Find Your Cruise

Database Profiling Report