(1) |
connect |
0.00083208084106445 |
(2) |
DESCRIBE `specials` |
0.0053541660308838 |
(3) |
SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '15-night-french-polynesia-hawaii-cruise-from-papeete-to-honolulu') AND (orchid_available = 1) LIMIT 1 |
0.0011470317840576 |
(4) |
DESCRIBE `cruises` |
0.003061056137085 |
(5) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71061))) |
0.00055289268493652 |
(6) |
DESCRIBE `avid_specials` |
0.0014710426330566 |
(7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1529945 and class = 'Special') OR (item_id = 71061 and class = 'Cruise') OR (item_id = 1073 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 43 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.001305103302002 |
(8) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1529945') |
0.00040197372436523 |
(9) |
DESCRIBE `ships` |
0.003917932510376 |
(10) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) |
0.00056099891662598 |
(11) |
DESCRIBE `ships` |
0.0039081573486328 |
(12) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') |
0.00056791305541992 |
(13) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00037980079650879 |
(14) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00034403800964355 |
(15) |
DESCRIBE `itineraries` |
0.0021529197692871 |
(16) |
DESCRIBE `ports` |
0.0021870136260986 |
(17) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) |
0.00050115585327148 |
(18) |
DESCRIBE `ports` |
0.0020370483398438 |
(19) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) |
0.00053977966308594 |
(20) |
DESCRIBE `ports` |
0.0021021366119385 |
(21) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') |
0.00045919418334961 |
(22) |
DESCRIBE `specialsailingdates` |
0.0015261173248291 |
(23) |
DESCRIBE `sailingdates` |
0.0018541812896729 |
(24) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 445908))) |
0.00059103965759277 |
(25) |
DESCRIBE `ports` |
0.0020740032196045 |
(26) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) |
0.00043487548828125 |
(27) |
DESCRIBE `ports` |
0.0014560222625732 |
(28) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') |
0.00035595893859863 |
(29) |
DESCRIBE `ports` |
0.0014939308166504 |
(30) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) |
0.00040507316589355 |
(31) |
DESCRIBE `ports` |
0.0014369487762451 |
(32) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') |
0.00057220458984375 |
(33) |
DESCRIBE `ports` |
0.0019500255584717 |
(34) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1778))) |
0.00047779083251953 |
(35) |
DESCRIBE `ports` |
0.0018370151519775 |
(36) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1778') |
0.00048589706420898 |
(37) |
DESCRIBE `ports` |
0.0016651153564453 |
(38) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1328))) |
0.00038599967956543 |
(39) |
DESCRIBE `ports` |
0.0015499591827393 |
(40) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1328') |
0.00050020217895508 |
(41) |
DESCRIBE `ports` |
0.0019729137420654 |
(42) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5361))) |
0.00063490867614746 |
(43) |
DESCRIBE `ports` |
0.0018868446350098 |
(44) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5361') |
0.00050806999206543 |
(45) |
DESCRIBE `ports` |
0.001917839050293 |
(46) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5360))) |
0.00051498413085938 |
(47) |
DESCRIBE `ports` |
0.0020761489868164 |
(48) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5360') |
0.00054001808166504 |
(49) |
DESCRIBE `ports` |
0.002032995223999 |
(50) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 870))) |
0.00047111511230469 |
(51) |
DESCRIBE `ports` |
0.0016350746154785 |
(52) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '870') |
0.00033903121948242 |
(53) |
DESCRIBE `ports` |
0.0015869140625 |
(54) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3631))) |
0.00050497055053711 |
(55) |
DESCRIBE `ports` |
0.0020170211791992 |
(56) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3631') |
0.00044798851013184 |
(57) |
DESCRIBE `ports` |
0.0019800662994385 |
(58) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) |
0.00055909156799316 |
(59) |
DESCRIBE `ports` |
0.0019550323486328 |
(60) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') |
0.00045514106750488 |
(61) |
DESCRIBE `ports` |
0.0019428730010986 |
(62) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) |
0.0004580020904541 |
(63) |
DESCRIBE `ports` |
0.0021810531616211 |
(64) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') |
0.00052595138549805 |
(65) |
DESCRIBE `ports` |
0.0018529891967773 |
(66) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) |
0.00047588348388672 |
(67) |
DESCRIBE `ports` |
0.0018398761749268 |
(68) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') |
0.0004279613494873 |
(69) |
DESCRIBE `specialsmultipricing` |
0.0019040107727051 |
(70) |
DESCRIBE `leadpricing` |
0.0019481182098389 |
(71) |
DESCRIBE `specialspricing` |
0.002072811126709 |
(72) |
DESCRIBE `cabins` |
0.0022950172424316 |
(73) |
SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 13988))) |
0.00066304206848145 |
(74) |
DESCRIBE `currencies` |
0.001849889755249 |
(75) |
SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) |
0.00051283836364746 |
(76) |
DESCRIBE `cruiselines` |
0.002842903137207 |
(77) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) |
0.00054001808166504 |
(78) |
DESCRIBE `orchid_image` |
0.0022919178009033 |
(79) |
DESCRIBE `cruiselines` |
0.003040075302124 |
(80) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') |
0.00046086311340332 |
(81) |
DESCRIBE `cruises` |
0.0028319358825684 |
(82) |
SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71061') |
0.00042414665222168 |
(83) |
DESCRIBE `deckplans` |
0.0015919208526611 |
(84) |
DESCRIBE `cabins` |
0.0019071102142334 |
(85) |
DESCRIBE `shipphotos` |
0.0019161701202393 |
(86) |
DESCRIBE `cruiselines` |
0.002777099609375 |
(87) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) |
0.00051093101501465 |
(88) |
DESCRIBE `orchid_image` |
0.0020999908447266 |
(89) |
DESCRIBE `cruiselines` |
0.0028350353240967 |
(90) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') |
0.00046300888061523 |
(91) |
DESCRIBE `cruises` |
0.0058300495147705 |
(92) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (71061, 56368, 75087, 63940, 71423, 63941, 43678, 67915, 75085, 71425)) ORDER BY FIND_IN_SET(id, '71061,56368,75087,63940,71423,63941,43678,67915,75085,71425') |
0.001676082611084 |
(93) |
DESCRIBE `cruiselines` |
0.0031731128692627 |
(94) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('212', '218', '33', '23', '191', '264', '18', '140', '24', '101', '114', '19', '29', '4', '20', '151')) ORDER BY FIND_IN_SET(id, '212,218,33,23,191,264,18,140,24,101,114,19,29,4,20,151') |
0.002100944519043 |
(95) |
DESCRIBE `ships` |
0.0042469501495361 |
(96) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('1163', '1526', '1013', '1303', '1767', '1266', '1772', '1788', '1032', '163', '338', '451', '1237', '75', '547', '580', '1073', '1159', '1205', '1491', '4', '74', '105', '147', '404', '452', '622', '652', '669', '717', '741', '835', '1168', '1224', '1262', '1282', '1415', '1540', '1711')) ORDER BY FIND_IN_SET(id, '1163,1526,1013,1303,1767,1266,1772,1788,1032,163,338,451,1237,75,547,580,1073,1159,1205,1491,4,74,105,147,404,452,622,652,669,717,741,835,1168,1224,1262,1282,1415,1540,1711') |
0.0055007934570312 |
(97) |
DESCRIBE `cruisetypes` |
0.0019450187683105 |
(98) |
DESCRIBE `destinations` |
0.0029840469360352 |
(99) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '22', '43', '12', '50', '2', '54', '8', '40', '55', '28', '34', '35', '53', '11', '25', '26', '29', '37', '38', '45', '52')) ORDER BY FIND_IN_SET(id, '39,22,43,12,50,2,54,8,40,55,28,34,35,53,11,25,26,29,37,38,45,52') |
0.0025250911712646 |