(1) |
connect |
0.0013430118560791 |
(2) |
DESCRIBE `specials` |
0.0090358257293701 |
(3) |
SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'stunning-alaska-free-air-credit') AND (orchid_available = 1) LIMIT 1 |
0.0022439956665039 |
(4) |
DESCRIBE `cruises` |
0.0042691230773926 |
(5) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79367))) |
0.00065803527832031 |
(6) |
DESCRIBE `avid_specials` |
0.0023190975189209 |
(7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1641957 and class = 'Special') OR (item_id = 79367 and class = 'Cruise') OR (item_id = 1398 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 2 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.0014059543609619 |
(8) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1641957') |
0.00040316581726074 |
(9) |
DESCRIBE `ships` |
0.0042979717254639 |
(10) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1398))) |
0.00055217742919922 |
(11) |
DESCRIBE `ships` |
0.0046689510345459 |
(12) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1398') |
0.00063490867614746 |
(13) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.00046515464782715 |
(14) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.00052380561828613 |
(15) |
DESCRIBE `itineraries` |
0.0023949146270752 |
(16) |
DESCRIBE `ports` |
0.0029981136322021 |
(17) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) |
0.00067782402038574 |
(18) |
DESCRIBE `ports` |
0.0028729438781738 |
(19) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) |
0.00071191787719727 |
(20) |
DESCRIBE `ports` |
0.002875804901123 |
(21) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') |
0.00067806243896484 |
(22) |
DESCRIBE `specialsailingdates` |
0.002453088760376 |
(23) |
DESCRIBE `sailingdates` |
0.0028340816497803 |
(24) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 492800))) |
0.00067591667175293 |
(25) |
DESCRIBE `ports` |
0.00301194190979 |
(26) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) |
0.0010318756103516 |
(27) |
DESCRIBE `ports` |
0.0030498504638672 |
(28) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') |
0.00069904327392578 |
(29) |
DESCRIBE `ports` |
0.002997875213623 |
(30) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) |
0.00074887275695801 |
(31) |
DESCRIBE `ports` |
0.0030028820037842 |
(32) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') |
0.00073409080505371 |
(33) |
DESCRIBE `ports` |
0.0028350353240967 |
(34) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) |
0.00086116790771484 |
(35) |
DESCRIBE `ports` |
0.0026099681854248 |
(36) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') |
0.00061511993408203 |
(37) |
DESCRIBE `ports` |
0.0029950141906738 |
(38) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) |
0.0007021427154541 |
(39) |
DESCRIBE `ports` |
0.002777099609375 |
(40) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') |
0.00064420700073242 |
(41) |
DESCRIBE `ports` |
0.0024330615997314 |
(42) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) |
0.00069999694824219 |
(43) |
DESCRIBE `ports` |
0.0028281211853027 |
(44) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') |
0.00066494941711426 |
(45) |
DESCRIBE `ports` |
0.0026068687438965 |
(46) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) |
0.00068116188049316 |
(47) |
DESCRIBE `ports` |
0.0028347969055176 |
(48) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') |
0.00062894821166992 |
(49) |
DESCRIBE `ports` |
0.002810001373291 |
(50) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) |
0.00068283081054688 |
(51) |
DESCRIBE `ports` |
0.0027859210968018 |
(52) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') |
0.00068283081054688 |
(53) |
DESCRIBE `ports` |
0.002932071685791 |
(54) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) |
0.00071096420288086 |
(55) |
DESCRIBE `ports` |
0.0028131008148193 |
(56) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') |
0.0007178783416748 |
(57) |
DESCRIBE `specialsmultipricing` |
0.0027239322662354 |
(58) |
DESCRIBE `leadpricing` |
0.0027680397033691 |
(59) |
DESCRIBE `specialspricing` |
0.0028140544891357 |
(60) |
DESCRIBE `cabins` |
0.0029871463775635 |
(61) |
SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 12089))) |
0.00073099136352539 |
(62) |
DESCRIBE `currencies` |
0.0023670196533203 |
(63) |
SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) |
0.00059199333190918 |
(64) |
DESCRIBE `cruiselines` |
0.0032799243927002 |
(65) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) |
0.00079107284545898 |
(66) |
DESCRIBE `orchid_image` |
0.0025360584259033 |
(67) |
DESCRIBE `cruises` |
0.004072904586792 |
(68) |
SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79367') |
0.00065994262695312 |
(69) |
DESCRIBE `deckplans` |
0.0025389194488525 |
(70) |
DESCRIBE `cabins` |
0.0024349689483643 |
(71) |
DESCRIBE `shipphotos` |
0.0029599666595459 |
(72) |
DESCRIBE `cruiselines` |
0.00364089012146 |
(73) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) |
0.00076198577880859 |
(74) |
DESCRIBE `orchid_image` |
0.0030851364135742 |
(75) |
DESCRIBE `cruises` |
0.0084090232849121 |
(76) |
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.0016350746154785 |
(77) |
DESCRIBE `cruiselines` |
0.0043330192565918 |
(78) |
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.0031280517578125 |
(79) |
DESCRIBE `ships` |
0.0051810741424561 |
(80) |
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.014656066894531 |
(81) |
DESCRIBE `cruisetypes` |
0.0024750232696533 |
(82) |
DESCRIBE `destinations` |
0.0039529800415039 |
(83) |
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.0023550987243652 |