(1) |
connect |
0.0016739368438721 |
(2) |
DESCRIBE `specials` |
0.0084109306335449 |
(3) |
SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'norwegian-fjords-fly-free-to-europe') AND (orchid_available = 1) LIMIT 1 |
0.0046870708465576 |
(4) |
DESCRIBE `cruises` |
0.0054700374603271 |
(5) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79433))) |
0.00078797340393066 |
(6) |
DESCRIBE `avid_specials` |
0.0019519329071045 |
(7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1641980 and class = 'Special') OR (item_id = 79433 and class = 'Cruise') OR (item_id = 768 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 25 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.0019080638885498 |
(8) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1641980') |
0.00074911117553711 |
(9) |
DESCRIBE `ships` |
0.0062601566314697 |
(10) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 768))) |
0.0012459754943848 |
(11) |
DESCRIBE `ships` |
0.0062739849090576 |
(12) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '768') |
0.00066304206848145 |
(13) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.00048518180847168 |
(14) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.00043892860412598 |
(15) |
DESCRIBE `itineraries` |
0.0024411678314209 |
(16) |
DESCRIBE `ports` |
0.0089750289916992 |
(17) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) |
0.00080394744873047 |
(18) |
DESCRIBE `ports` |
0.0032470226287842 |
(19) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) |
0.00070881843566895 |
(20) |
DESCRIBE `ports` |
0.0031909942626953 |
(21) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') |
0.00082206726074219 |
(22) |
DESCRIBE `specialsailingdates` |
0.0028128623962402 |
(23) |
DESCRIBE `sailingdates` |
0.002877950668335 |
(24) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 492874))) |
0.00066399574279785 |
(25) |
DESCRIBE `ports` |
0.0030977725982666 |
(26) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) |
0.00073814392089844 |
(27) |
DESCRIBE `ports` |
0.0029928684234619 |
(28) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') |
0.00068283081054688 |
(29) |
DESCRIBE `ports` |
0.0031099319458008 |
(30) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) |
0.00083684921264648 |
(31) |
DESCRIBE `ports` |
0.0031559467315674 |
(32) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') |
0.00066399574279785 |
(33) |
DESCRIBE `ports` |
0.0030078887939453 |
(34) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) |
0.00074315071105957 |
(35) |
DESCRIBE `ports` |
0.0028719902038574 |
(36) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') |
0.00073909759521484 |
(37) |
DESCRIBE `ports` |
0.0031309127807617 |
(38) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 656))) |
0.00075197219848633 |
(39) |
DESCRIBE `ports` |
0.0028369426727295 |
(40) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '656') |
0.00065183639526367 |
(41) |
DESCRIBE `ports` |
0.0028479099273682 |
(42) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) |
0.0006711483001709 |
(43) |
DESCRIBE `ports` |
0.0028560161590576 |
(44) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') |
0.00065398216247559 |
(45) |
DESCRIBE `ports` |
0.0024750232696533 |
(46) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) |
0.00076103210449219 |
(47) |
DESCRIBE `ports` |
0.0028009414672852 |
(48) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') |
0.00070500373840332 |
(49) |
DESCRIBE `ports` |
0.0030879974365234 |
(50) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 223))) |
0.00076198577880859 |
(51) |
DESCRIBE `ports` |
0.002863883972168 |
(52) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '223') |
0.00060892105102539 |
(53) |
DESCRIBE `ports` |
0.0022439956665039 |
(54) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) |
0.00046682357788086 |
(55) |
DESCRIBE `ports` |
0.0024490356445312 |
(56) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') |
0.00059103965759277 |
(57) |
DESCRIBE `ports` |
0.0021858215332031 |
(58) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) |
0.00060892105102539 |
(59) |
DESCRIBE `ports` |
0.0023338794708252 |
(60) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') |
0.00059795379638672 |
(61) |
DESCRIBE `ports` |
0.0020499229431152 |
(62) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2079))) |
0.00073099136352539 |
(63) |
DESCRIBE `ports` |
0.0024788379669189 |
(64) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2079') |
0.00046205520629883 |
(65) |
DESCRIBE `ports` |
0.0022540092468262 |
(66) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) |
0.00054597854614258 |
(67) |
DESCRIBE `ports` |
0.0021770000457764 |
(68) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') |
0.00049805641174316 |
(69) |
DESCRIBE `specialsmultipricing` |
0.0018188953399658 |
(70) |
DESCRIBE `leadpricing` |
0.0018899440765381 |
(71) |
DESCRIBE `specialspricing` |
0.0027010440826416 |
(72) |
DESCRIBE `cabins` |
0.0028200149536133 |
(73) |
SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 15780))) |
0.00061678886413574 |
(74) |
DESCRIBE `currencies` |
0.0024709701538086 |
(75) |
SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) |
0.00063800811767578 |
(76) |
DESCRIBE `cruiselines` |
0.0040950775146484 |
(77) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) |
0.00083494186401367 |
(78) |
DESCRIBE `orchid_image` |
0.0031130313873291 |
(79) |
DESCRIBE `cruises` |
0.0054569244384766 |
(80) |
SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79433') |
0.00074386596679688 |
(81) |
DESCRIBE `deckplans` |
0.0023808479309082 |
(82) |
DESCRIBE `cabins` |
0.0019190311431885 |
(83) |
DESCRIBE `shipphotos` |
0.0022158622741699 |
(84) |
DESCRIBE `cruiselines` |
0.012264966964722 |
(85) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) |
0.00058102607727051 |
(86) |
DESCRIBE `orchid_image` |
0.0026121139526367 |
(87) |
DESCRIBE `cruises` |
0.0059530735015869 |
(88) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 85799, 45258, 81015, 4425, 6056, 76113, 4424, 79285, 76235)) ORDER BY FIND_IN_SET(id, '45259,85799,45258,81015,4425,6056,76113,4424,79285,76235') |
0.0023288726806641 |
(89) |
DESCRIBE `cruiselines` |
0.0033349990844727 |
(90) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '216', '47', '20', '191', '33', '26', '8', '14', '151', '19', '91', '101', '114', '15', '24', '29', '37', '96', '18')) ORDER BY FIND_IN_SET(id, '23,216,47,20,191,33,26,8,14,151,19,91,101,114,15,24,29,37,96,18') |
0.0026209354400635 |
(91) |
DESCRIBE `ships` |
0.0046908855438232 |
(92) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('855', '517', '1808', '66', '1282', '338', '780', '148', '652', '683', '776', '1021', '1746', '1766', '124', '287', '290', '332', '404', '448', '542', '616', '966', '1088', '1159', '1193', '1321', '1409', '1672', '75', '160', '163', '286', '291', '349', '406', '434', '547', '573', '580', '585', '665', '766', '1028', '1318', '1319', '1330', '1359', '1402', '1539', '1569', '1771', '45', '98', '105', '108', '149', '253', '262', '285', '341', '389', '394', '422', '508', '553', '559', '674', '678', '726', '738', '748', '768', '770', '907', '968', '1029', '1073', '1108', '1135', '1157', '1262', '1283', '1415', '1587', '1682', '1721', '1758')) ORDER BY FIND_IN_SET(id, '855,517,1808,66,1282,338,780,148,652,683,776,1021,1746,1766,124,287,290,332,404,448,542,616,966,1088,1159,1193,1321,1409,1672,75,160,163,286,291,349,406,434,547,573,580,585,665,766,1028,1318,1319,1330,1359,1402,1539,1569,1771,45,98,105,108,149,253,262,285,341,389,394,422,508,553,559,674,678,726,738,748,768,770,907,968,1029,1073,1108,1135,1157,1262,1283,1415,1587,1682,1721,1758') |
0.012732028961182 |
(93) |
DESCRIBE `cruisetypes` |
0.0023598670959473 |
(94) |
DESCRIBE `destinations` |
0.0028040409088135 |
(95) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '35', '2', '54', '50', '26', '8', '12', '25', '48', '49', '29', '53', '40', '11', '28', '37')) ORDER BY FIND_IN_SET(id, '43,22,35,2,54,50,26,8,12,25,48,49,29,53,40,11,28,37') |
0.0019261837005615 |