(1) |
connect |
0.0080420970916748 |
(2) |
DESCRIBE `cruises` |
0.0032660961151123 |
(3) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (75092, 71061, 56368, 75087, 71423, 63940, 63941, 75085, 43678, 67915)) ORDER BY FIND_IN_SET(id, '75092,71061,56368,75087,71423,63940,63941,75085,43678,67915') |
0.0087559223175049 |
(4) |
DESCRIBE `specials` |
0.0060601234436035 |
(5) |
SELECT `specials`.* FROM `specials` WHERE (id = '1535066') AND (specials.orchid_available = 1) LIMIT 1 |
0.00080108642578125 |
(6) |
DESCRIBE `specials` |
0.0062639713287354 |
(7) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1535066') |
0.00071382522583008 |
(8) |
DESCRIBE `ships` |
0.0039689540863037 |
(9) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) |
0.00075197219848633 |
(10) |
DESCRIBE `ships` |
0.0039420127868652 |
(11) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') |
0.00054597854614258 |
(12) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00032782554626465 |
(13) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00037598609924316 |
(14) |
DESCRIBE `itineraries` |
0.0018270015716553 |
(15) |
SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75092') ORDER BY `day` ASC, `itineraries`.`portorder` ASC |
0.0010209083557129 |
(16) |
DESCRIBE `ports` |
0.0021719932556152 |
(17) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) |
0.012754917144775 |
(18) |
DESCRIBE `ports` |
0.0038750171661377 |
(19) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) |
0.00376296043396 |
(20) |
DESCRIBE `ports` |
0.0045220851898193 |
(21) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') |
0.00053000450134277 |
(22) |
DESCRIBE `specialsailingdates` |
0.0036721229553223 |
(23) |
SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates`
INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1535066') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC |
0.0014388561248779 |
(24) |
DESCRIBE `sailingdates` |
0.0026590824127197 |
(25) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 474285))) |
0.00042414665222168 |
(26) |
DESCRIBE `ports` |
0.006248950958252 |
(27) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) |
0.0014908313751221 |
(28) |
DESCRIBE `ports` |
0.0078220367431641 |
(29) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') |
0.00050997734069824 |
(30) |
DESCRIBE `ports` |
0.0021440982818604 |
(31) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5923))) |
0.002918004989624 |
(32) |
DESCRIBE `ports` |
0.0055999755859375 |
(33) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5923') |
0.0004570484161377 |
(34) |
DESCRIBE `ports` |
0.0019299983978271 |
(35) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) |
0.00049185752868652 |
(36) |
DESCRIBE `ports` |
0.0019071102142334 |
(37) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') |
0.00045204162597656 |
(38) |
DESCRIBE `ports` |
0.0020289421081543 |
(39) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) |
0.00050497055053711 |
(40) |
DESCRIBE `ports` |
0.0077781677246094 |
(41) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') |
0.00052404403686523 |
(42) |
DESCRIBE `ports` |
0.0025978088378906 |
(43) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) |
0.00056791305541992 |
(44) |
DESCRIBE `ports` |
0.0023589134216309 |
(45) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') |
0.00055694580078125 |
(46) |
DESCRIBE `ports` |
0.0021038055419922 |
(47) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5914))) |
0.0005650520324707 |
(48) |
DESCRIBE `ports` |
0.0020999908447266 |
(49) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5914') |
0.00057196617126465 |
(50) |
DESCRIBE `ports` |
0.0070250034332275 |
(51) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) |
0.00057291984558105 |
(52) |
DESCRIBE `ports` |
0.0069279670715332 |
(53) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') |
0.00048494338989258 |
(54) |
DESCRIBE `ports` |
0.0019538402557373 |
(55) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) |
0.0004580020904541 |
(56) |
DESCRIBE `ports` |
0.0020301342010498 |
(57) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') |
0.00046610832214355 |
(58) |
DESCRIBE `ports` |
0.0026669502258301 |
(59) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) |
0.00050187110900879 |
(60) |
DESCRIBE `ports` |
0.0019969940185547 |
(61) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') |
0.0003359317779541 |
(62) |
DESCRIBE `cruises` |
0.0032880306243896 |
(63) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75092))) |
0.00047397613525391 |
(64) |
DESCRIBE `avid_specials` |
0.0015769004821777 |
(65) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1535066 and class = 'Special') OR (item_id = 75092 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 35 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.0016789436340332 |
(66) |
DESCRIBE `cruiselines` |
0.0028340816497803 |
(67) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) |
0.00054812431335449 |
(68) |
DESCRIBE `orchid_image` |
0.0022621154785156 |
(69) |
DESCRIBE `cruiselines` |
0.0028030872344971 |
(70) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') |
0.00046014785766602 |
(71) |
DESCRIBE `specials` |
0.013910055160522 |
(72) |
SELECT `specials`.* FROM `specials` WHERE (id = '1529945') AND (specials.orchid_available = 1) LIMIT 1 |
0.00092411041259766 |
(73) |
DESCRIBE `specials` |
0.0066430568695068 |
(74) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1529945') |
0.008591890335083 |
(75) |
DESCRIBE `ships` |
0.004396915435791 |
(76) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) |
0.0012130737304688 |
(77) |
DESCRIBE `ships` |
0.0040628910064697 |
(78) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') |
0.0085020065307617 |
(79) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00034284591674805 |
(80) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00031399726867676 |
(81) |
DESCRIBE `itineraries` |
0.0021231174468994 |
(82) |
SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71061') ORDER BY `day` ASC, `itineraries`.`portorder` ASC |
0.00099802017211914 |
(83) |
DESCRIBE `ports` |
0.0021250247955322 |
(84) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) |
0.00051498413085938 |
(85) |
DESCRIBE `ports` |
0.0016810894012451 |
(86) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) |
0.0081658363342285 |
(87) |
DESCRIBE `ports` |
0.0019750595092773 |
(88) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') |
0.0004420280456543 |
(89) |
DESCRIBE `specialsailingdates` |
0.0015511512756348 |
(90) |
SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates`
INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1529945') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC |
0.0010030269622803 |
(91) |
DESCRIBE `sailingdates` |
0.00211501121521 |
(92) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 445908))) |
0.0074460506439209 |
(93) |
DESCRIBE `ports` |
0.0022430419921875 |
(94) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) |
0.00047683715820312 |
(95) |
DESCRIBE `ports` |
0.0019369125366211 |
(96) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') |
0.00039291381835938 |
(97) |
DESCRIBE `ports` |
0.0015439987182617 |
(98) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) |
0.00042295455932617 |
(99) |
DESCRIBE `ports` |
0.01004695892334 |
(100) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') |
0.00046610832214355 |
(101) |
DESCRIBE `ports` |
0.0019240379333496 |
(102) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1778))) |
0.0004429817199707 |
(103) |
DESCRIBE `ports` |
0.0018391609191895 |
(104) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1778') |
0.00040102005004883 |
(105) |
DESCRIBE `ports` |
0.0018930435180664 |
(106) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1328))) |
0.0069649219512939 |
(107) |
DESCRIBE `ports` |
0.0019798278808594 |
(108) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1328') |
0.00043916702270508 |
(109) |
DESCRIBE `ports` |
0.0018651485443115 |
(110) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5361))) |
0.00060701370239258 |
(111) |
DESCRIBE `ports` |
0.0019810199737549 |
(112) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5361') |
0.0093739032745361 |
(113) |
DESCRIBE `ports` |
0.0020020008087158 |
(114) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5360))) |
0.0004730224609375 |
(115) |
DESCRIBE `ports` |
0.0020020008087158 |
(116) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5360') |
0.00055885314941406 |
(117) |
DESCRIBE `ports` |
0.0019409656524658 |
(118) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 870))) |
0.00058698654174805 |
(119) |
DESCRIBE `ports` |
0.0020668506622314 |
(120) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '870') |
0.00048017501831055 |
(121) |
DESCRIBE `ports` |
0.0017478466033936 |
(122) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3631))) |
0.00038409233093262 |
(123) |
DESCRIBE `ports` |
0.0017437934875488 |
(124) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3631') |
0.00039911270141602 |
(125) |
DESCRIBE `ports` |
0.0020129680633545 |
(126) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) |
0.0043849945068359 |
(127) |
DESCRIBE `ports` |
0.0021979808807373 |
(128) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') |
0.0004119873046875 |
(129) |
DESCRIBE `ports` |
0.0019268989562988 |
(130) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) |
0.00044608116149902 |
(131) |
DESCRIBE `ports` |
0.0018360614776611 |
(132) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') |
0.00043797492980957 |
(133) |
DESCRIBE `ports` |
0.0019600391387939 |
(134) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) |
0.00045585632324219 |
(135) |
DESCRIBE `ports` |
0.0019381046295166 |
(136) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') |
0.0005040168762207 |
(137) |
DESCRIBE `cruises` |
0.0037870407104492 |
(138) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71061))) |
0.00071597099304199 |
(139) |
DESCRIBE `avid_specials` |
0.001945972442627 |
(140) |
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.0018830299377441 |
(141) |
DESCRIBE `cruiselines` |
0.0028519630432129 |
(142) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) |
0.00054597854614258 |
(143) |
DESCRIBE `orchid_image` |
0.0059070587158203 |
(144) |
DESCRIBE `cruiselines` |
0.0030081272125244 |
(145) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') |
0.00047683715820312 |
(146) |
DESCRIBE `specials` |
0.017117023468018 |
(147) |
SELECT `specials`.* FROM `specials` WHERE (id = '1529878') AND (specials.orchid_available = 1) LIMIT 1 |
0.00091099739074707 |
(148) |
DESCRIBE `specials` |
0.0066177845001221 |
(149) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1529878') |
0.0078091621398926 |
(150) |
DESCRIBE `ships` |
0.0057680606842041 |
(151) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) |
0.011365175247192 |
(152) |
DESCRIBE `ships` |
0.006479024887085 |
(153) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') |
0.00054001808166504 |
(154) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00040102005004883 |
(155) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00052380561828613 |
(156) |
DESCRIBE `itineraries` |
0.0022368431091309 |
(157) |
DESCRIBE `ports` |
0.002781867980957 |
(158) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) |
0.0059099197387695 |
(159) |
DESCRIBE `ports` |
0.0020420551300049 |
(160) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) |
0.00049614906311035 |
(161) |
DESCRIBE `ports` |
0.0019218921661377 |
(162) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') |
0.0059549808502197 |
(163) |
DESCRIBE `specialsailingdates` |
0.0018608570098877 |
(164) |
DESCRIBE `sailingdates` |
0.002004861831665 |
(165) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 445879))) |
0.00048089027404785 |
(166) |
DESCRIBE `ports` |
0.0080509185791016 |
(167) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) |
0.00058317184448242 |
(168) |
DESCRIBE `ports` |
0.0020220279693604 |
(169) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') |
0.00048303604125977 |
(170) |
DESCRIBE `ports` |
0.0024280548095703 |
(171) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) |
0.0087161064147949 |
(172) |
DESCRIBE `ports` |
0.002079963684082 |
(173) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') |
0.00056982040405273 |
(174) |
DESCRIBE `ports` |
0.0020411014556885 |
(175) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 802))) |
0.00053310394287109 |
(176) |
DESCRIBE `ports` |
0.0019428730010986 |
(177) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '802') |
0.00043582916259766 |
(178) |
DESCRIBE `ports` |
0.0042409896850586 |
(179) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 802))) |
0.0032389163970947 |
(180) |
DESCRIBE `ports` |
0.0021231174468994 |
(181) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '802') |
0.00045490264892578 |
(182) |
DESCRIBE `ports` |
0.0024199485778809 |
(183) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 708))) |
0.00049591064453125 |
(184) |
DESCRIBE `ports` |
0.0019159317016602 |
(185) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '708') |
0.00040984153747559 |
(186) |
DESCRIBE `ports` |
0.0017590522766113 |
(187) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) |
0.00045394897460938 |
(188) |
DESCRIBE `ports` |
0.0017969608306885 |
(189) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') |
0.00044703483581543 |
(190) |
DESCRIBE `ports` |
0.0017921924591064 |
(191) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) |
0.00051307678222656 |
(192) |
DESCRIBE `ports` |
0.0017678737640381 |
(193) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') |
0.00035190582275391 |
(194) |
DESCRIBE `cruises` |
0.0032730102539062 |
(195) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 56368))) |
0.00065207481384277 |
(196) |
DESCRIBE `avid_specials` |
0.0017359256744385 |
(197) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1529878 and class = 'Special') OR (item_id = 56368 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 52 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.0017580986022949 |
(198) |
DESCRIBE `cruiselines` |
0.0026049613952637 |
(199) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) |
0.00050997734069824 |
(200) |
DESCRIBE `orchid_image` |
0.0021262168884277 |
(201) |
DESCRIBE `cruiselines` |
0.0027389526367188 |
(202) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') |
0.00044584274291992 |
(203) |
DESCRIBE `specials` |
0.0063281059265137 |
(204) |
SELECT `specials`.* FROM `specials` WHERE (id = '1535086') AND (specials.orchid_available = 1) LIMIT 1 |
0.0010318756103516 |
(205) |
DESCRIBE `specials` |
0.0055909156799316 |
(206) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1535086') |
0.0023479461669922 |
(207) |
DESCRIBE `ships` |
0.0050230026245117 |
(208) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) |
0.00069904327392578 |
(209) |
DESCRIBE `ships` |
0.0044519901275635 |
(210) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') |
0.00058507919311523 |
(211) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00034308433532715 |
(212) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00032901763916016 |
(213) |
DESCRIBE `itineraries` |
0.0021390914916992 |
(214) |
DESCRIBE `ports` |
0.0094671249389648 |
(215) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) |
0.00048303604125977 |
(216) |
DESCRIBE `ports` |
0.0018718242645264 |
(217) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) |
0.00044894218444824 |
(218) |
DESCRIBE `ports` |
0.0022029876708984 |
(219) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') |
0.0057461261749268 |
(220) |
DESCRIBE `specialsailingdates` |
0.0017340183258057 |
(221) |
DESCRIBE `sailingdates` |
0.001690149307251 |
(222) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 474261))) |
0.00053906440734863 |
(223) |
DESCRIBE `ports` |
0.005997896194458 |
(224) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) |
0.00052785873413086 |
(225) |
DESCRIBE `ports` |
0.0080080032348633 |
(226) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') |
0.00046992301940918 |
(227) |
DESCRIBE `ports` |
0.0018210411071777 |
(228) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) |
0.0023758411407471 |
(229) |
DESCRIBE `ports` |
0.0063929557800293 |
(230) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') |
0.00041484832763672 |
(231) |
DESCRIBE `ports` |
0.0017580986022949 |
(232) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4862))) |
0.00041484832763672 |
(233) |
DESCRIBE `ports` |
0.0016829967498779 |
(234) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4862') |
0.0024631023406982 |
(235) |
DESCRIBE `ports` |
0.0017220973968506 |
(236) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) |
0.00038814544677734 |
(237) |
DESCRIBE `ports` |
0.0017299652099609 |
(238) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') |
0.00034284591674805 |
(239) |
DESCRIBE `ports` |
0.0015709400177002 |
(240) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) |
0.00044918060302734 |
(241) |
DESCRIBE `ports` |
0.0015771389007568 |
(242) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') |
0.00042104721069336 |
(243) |
DESCRIBE `ports` |
0.0016441345214844 |
(244) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) |
0.00041508674621582 |
(245) |
DESCRIBE `ports` |
0.0016930103302002 |
(246) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') |
0.00035881996154785 |
(247) |
DESCRIBE `ports` |
0.0017580986022949 |
(248) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5923))) |
0.00036907196044922 |
(249) |
DESCRIBE `ports` |
0.0015420913696289 |
(250) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5923') |
0.00035500526428223 |
(251) |
DESCRIBE `ports` |
0.0016169548034668 |
(252) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) |
0.00045990943908691 |
(253) |
DESCRIBE `ports` |
0.0018529891967773 |
(254) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') |
0.00041294097900391 |
(255) |
DESCRIBE `ports` |
0.002349853515625 |
(256) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2355))) |
0.00049591064453125 |
(257) |
DESCRIBE `ports` |
0.0027720928192139 |
(258) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2355') |
0.00041604042053223 |
(259) |
DESCRIBE `ports` |
0.0020730495452881 |
(260) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) |
0.0009620189666748 |
(261) |
DESCRIBE `ports` |
0.0018670558929443 |
(262) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') |
0.0075130462646484 |
(263) |
DESCRIBE `cruises` |
0.0038058757781982 |
(264) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75087))) |
0.0007779598236084 |
(265) |
DESCRIBE `avid_specials` |
0.0019190311431885 |
(266) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1535086 and class = 'Special') OR (item_id = 75087 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 35 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.0021340847015381 |
(267) |
DESCRIBE `cruiselines` |
0.0034480094909668 |
(268) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) |
0.00058507919311523 |
(269) |
DESCRIBE `orchid_image` |
0.0017890930175781 |
(270) |
DESCRIBE `cruiselines` |
0.0023510456085205 |
(271) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') |
0.00045394897460938 |
(272) |
DESCRIBE `specials` |
0.0056660175323486 |
(273) |
DESCRIBE `specials` |
0.0063910484313965 |
(274) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1533273') |
0.00053501129150391 |
(275) |
DESCRIBE `ships` |
0.012773990631104 |
(276) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) |
0.0005950927734375 |
(277) |
DESCRIBE `ships` |
0.0038518905639648 |
(278) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') |
0.0004279613494873 |
(279) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00026607513427734 |
(280) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00033283233642578 |
(281) |
DESCRIBE `itineraries` |
0.0018830299377441 |
(282) |
DESCRIBE `ports` |
0.0020730495452881 |
(283) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) |
0.00048685073852539 |
(284) |
DESCRIBE `ports` |
0.0019659996032715 |
(285) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) |
0.00045394897460938 |
(286) |
DESCRIBE `ports` |
0.0018911361694336 |
(287) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') |
0.0004429817199707 |
(288) |
DESCRIBE `specialsailingdates` |
0.0015909671783447 |
(289) |
DESCRIBE `sailingdates` |
0.0016670227050781 |
(290) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453298))) |
0.00073909759521484 |
(291) |
DESCRIBE `ports` |
0.0028219223022461 |
(292) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) |
0.00050997734069824 |
(293) |
DESCRIBE `ports` |
0.0019359588623047 |
(294) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') |
0.00037479400634766 |
(295) |
DESCRIBE `ports` |
0.0018370151519775 |
(296) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) |
0.001370906829834 |
(297) |
DESCRIBE `ports` |
0.013614177703857 |
(298) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') |
0.00058102607727051 |
(299) |
DESCRIBE `ports` |
0.0021038055419922 |
(300) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) |
0.00045418739318848 |
(301) |
DESCRIBE `ports` |
0.0018248558044434 |
(302) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') |
0.00049281120300293 |
(303) |
DESCRIBE `ports` |
0.001986026763916 |
(304) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2066))) |
0.00052094459533691 |
(305) |
DESCRIBE `ports` |
0.0019400119781494 |
(306) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2066') |
0.00046491622924805 |
(307) |
DESCRIBE `ports` |
0.001816987991333 |
(308) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) |
0.00045108795166016 |
(309) |
DESCRIBE `ports` |
0.001924991607666 |
(310) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') |
0.00038909912109375 |
(311) |
DESCRIBE `ports` |
0.0019259452819824 |
(312) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) |
0.00043702125549316 |
(313) |
DESCRIBE `ports` |
0.0018711090087891 |
(314) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') |
0.00039887428283691 |
(315) |
DESCRIBE `ports` |
0.0019199848175049 |
(316) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) |
0.00045394897460938 |
(317) |
DESCRIBE `ports` |
0.0023291110992432 |
(318) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') |
0.0011110305786133 |
(319) |
DESCRIBE `ports` |
0.0021660327911377 |
(320) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 88))) |
0.00057005882263184 |
(321) |
DESCRIBE `ports` |
0.002223014831543 |
(322) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '88') |
0.00045895576477051 |
(323) |
DESCRIBE `ports` |
0.0029070377349854 |
(324) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) |
0.0010509490966797 |
(325) |
DESCRIBE `ports` |
0.016875982284546 |
(326) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') |
0.00066494941711426 |
(327) |
DESCRIBE `ports` |
0.0024631023406982 |
(328) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5565))) |
0.00065112113952637 |
(329) |
DESCRIBE `ports` |
0.0020711421966553 |
(330) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5565') |
0.005094051361084 |
(331) |
DESCRIBE `ports` |
0.0022928714752197 |
(332) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) |
0.0073881149291992 |
(333) |
DESCRIBE `ports` |
0.0041499137878418 |
(334) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') |
0.00049614906311035 |
(335) |
DESCRIBE `ports` |
0.0021059513092041 |
(336) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) |
0.00050115585327148 |
(337) |
DESCRIBE `ports` |
0.0085849761962891 |
(338) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') |
0.00046300888061523 |
(339) |
DESCRIBE `cruises` |
0.0044000148773193 |
(340) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71423))) |
0.0088591575622559 |
(341) |
DESCRIBE `avid_specials` |
0.0047972202301025 |
(342) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1533273 and class = 'Special') OR (item_id = 71423 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 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.0064618587493896 |
(343) |
DESCRIBE `cruiselines` |
0.0025420188903809 |
(344) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) |
0.0071620941162109 |
(345) |
DESCRIBE `orchid_image` |
0.0020589828491211 |
(346) |
DESCRIBE `cruiselines` |
0.0024151802062988 |
(347) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') |
0.00042009353637695 |
(348) |
DESCRIBE `specials` |
0.0051910877227783 |
(349) |
SELECT `specials`.* FROM `specials` WHERE (id = '1523581') AND (specials.orchid_available = 1) LIMIT 1 |
0.0066461563110352 |
(350) |
DESCRIBE `specials` |
0.0052599906921387 |
(351) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1523581') |
0.0055139064788818 |
(352) |
DESCRIBE `ships` |
0.0029869079589844 |
(353) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1491))) |
0.0092840194702148 |
(354) |
DESCRIBE `ships` |
0.0027379989624023 |
(355) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1491') |
0.0095300674438477 |
(356) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00032520294189453 |
(357) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.0003511905670166 |
(358) |
DESCRIBE `itineraries` |
0.0020570755004883 |
(359) |
DESCRIBE `ports` |
0.0070428848266602 |
(360) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) |
0.00050902366638184 |
(361) |
DESCRIBE `ports` |
0.0018661022186279 |
(362) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) |
0.0031099319458008 |
(363) |
DESCRIBE `ports` |
0.0019237995147705 |
(364) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') |
0.007580041885376 |
(365) |
DESCRIBE `specialsailingdates` |
0.0016448497772217 |
(366) |
DESCRIBE `sailingdates` |
0.0013408660888672 |
(367) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 484528))) |
0.00040197372436523 |
(368) |
DESCRIBE `sailingdates` |
0.0028350353240967 |
(369) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 484530))) |
0.00050187110900879 |
(370) |
DESCRIBE `ports` |
0.0020802021026611 |
(371) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) |
0.0050349235534668 |
(372) |
DESCRIBE `ports` |
0.0016090869903564 |
(373) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') |
0.00034308433532715 |
(374) |
DESCRIBE `ports` |
0.0019371509552002 |
(375) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1548))) |
0.0010080337524414 |
(376) |
DESCRIBE `ports` |
0.0028181076049805 |
(377) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1548') |
0.002608060836792 |
(378) |
DESCRIBE `ports` |
0.002507209777832 |
(379) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1547))) |
0.0026969909667969 |
(380) |
DESCRIBE `ports` |
0.0027041435241699 |
(381) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1547') |
0.0025360584259033 |
(382) |
DESCRIBE `ports` |
0.0024759769439697 |
(383) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 947))) |
0.0025570392608643 |
(384) |
DESCRIBE `ports` |
0.0042250156402588 |
(385) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '947') |
0.00084996223449707 |
(386) |
DESCRIBE `ports` |
0.0025680065155029 |
(387) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) |
0.0021209716796875 |
(388) |
DESCRIBE `ports` |
0.0021860599517822 |
(389) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') |
0.0027511119842529 |
(390) |
DESCRIBE `ports` |
0.0018129348754883 |
(391) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) |
0.0029499530792236 |
(392) |
DESCRIBE `ports` |
0.0025959014892578 |
(393) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') |
0.0068619251251221 |
(394) |
DESCRIBE `ports` |
0.0023550987243652 |
(395) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) |
0.002100944519043 |
(396) |
DESCRIBE `ports` |
0.0023550987243652 |
(397) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') |
0.0039041042327881 |
(398) |
DESCRIBE `ports` |
0.0024890899658203 |
(399) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) |
0.0035490989685059 |
(400) |
DESCRIBE `ports` |
0.0023550987243652 |
(401) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') |
0.0076069831848145 |
(402) |
DESCRIBE `ports` |
0.009005069732666 |
(403) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5733))) |
0.00046706199645996 |
(404) |
DESCRIBE `ports` |
0.0021240711212158 |
(405) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5733') |
0.00045299530029297 |
(406) |
DESCRIBE `ports` |
0.0018320083618164 |
(407) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3213))) |
0.00047802925109863 |
(408) |
DESCRIBE `ports` |
0.001910924911499 |
(409) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3213') |
0.0064690113067627 |
(410) |
DESCRIBE `ports` |
0.0019991397857666 |
(411) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) |
0.00051498413085938 |
(412) |
DESCRIBE `ports` |
0.0017778873443604 |
(413) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') |
0.00041604042053223 |
(414) |
DESCRIBE `cruises` |
0.0034871101379395 |
(415) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63940))) |
0.011123895645142 |
(416) |
DESCRIBE `avid_specials` |
0.0015950202941895 |
(417) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1523581 and class = 'Special') OR (item_id = 63940 and class = 'Cruise') OR (item_id = 1491 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine') OR (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.0017669200897217 |
(418) |
DESCRIBE `cruiselines` |
0.0028879642486572 |
(419) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) |
0.00042486190795898 |
(420) |
DESCRIBE `orchid_image` |
0.0019111633300781 |
(421) |
DESCRIBE `cruiselines` |
0.01400089263916 |
(422) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') |
0.00040817260742188 |
(423) |
DESCRIBE `specials` |
0.0052621364593506 |
(424) |
SELECT `specials`.* FROM `specials` WHERE (id = '1523597') AND (specials.orchid_available = 1) LIMIT 1 |
0.00096893310546875 |
(425) |
DESCRIBE `specials` |
0.017835855484009 |
(426) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1523597') |
0.00043416023254395 |
(427) |
DESCRIBE `ships` |
0.0035181045532227 |
(428) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 741))) |
0.00047802925109863 |
(429) |
DESCRIBE `ships` |
0.0093510150909424 |
(430) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '741') |
0.00047993659973145 |
(431) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00032901763916016 |
(432) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00030398368835449 |
(433) |
DESCRIBE `itineraries` |
0.0096302032470703 |
(434) |
DESCRIBE `ports` |
0.0018138885498047 |
(435) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) |
0.00054001808166504 |
(436) |
DESCRIBE `ports` |
0.0018620491027832 |
(437) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) |
0.00049710273742676 |
(438) |
DESCRIBE `ports` |
0.0021231174468994 |
(439) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') |
0.0003669261932373 |
(440) |
DESCRIBE `specialsailingdates` |
0.001446008682251 |
(441) |
DESCRIBE `sailingdates` |
0.0076267719268799 |
(442) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 484539))) |
0.00052380561828613 |
(443) |
DESCRIBE `ports` |
0.0019161701202393 |
(444) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) |
0.00046992301940918 |
(445) |
DESCRIBE `ports` |
0.0018370151519775 |
(446) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') |
0.00037598609924316 |
(447) |
DESCRIBE `ports` |
0.0017361640930176 |
(448) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2966))) |
0.0079011917114258 |
(449) |
DESCRIBE `ports` |
0.0018589496612549 |
(450) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2966') |
0.00044488906860352 |
(451) |
DESCRIBE `ports` |
0.002161979675293 |
(452) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) |
0.00053906440734863 |
(453) |
DESCRIBE `ports` |
0.0025029182434082 |
(454) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') |
0.0084319114685059 |
(455) |
DESCRIBE `ports` |
0.0019180774688721 |
(456) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) |
0.00049495697021484 |
(457) |
DESCRIBE `ports` |
0.0019278526306152 |
(458) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') |
0.00040483474731445 |
(459) |
DESCRIBE `ports` |
0.0017931461334229 |
(460) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) |
0.00043702125549316 |
(461) |
DESCRIBE `ports` |
0.0097939968109131 |
(462) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') |
0.0004889965057373 |
(463) |
DESCRIBE `ports` |
0.0022368431091309 |
(464) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) |
0.00042510032653809 |
(465) |
DESCRIBE `ports` |
0.0019500255584717 |
(466) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') |
0.00037217140197754 |
(467) |
DESCRIBE `ports` |
0.0022261142730713 |
(468) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) |
0.00044417381286621 |
(469) |
DESCRIBE `ports` |
0.0017509460449219 |
(470) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') |
0.007688045501709 |
(471) |
DESCRIBE `ports` |
0.0019700527191162 |
(472) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) |
0.00055098533630371 |
(473) |
DESCRIBE `ports` |
0.0019779205322266 |
(474) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') |
0.00037503242492676 |
(475) |
DESCRIBE `ports` |
0.0016570091247559 |
(476) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5753))) |
0.00040888786315918 |
(477) |
DESCRIBE `ports` |
0.0018019676208496 |
(478) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5753') |
0.0048999786376953 |
(479) |
DESCRIBE `ports` |
0.0091278553009033 |
(480) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) |
0.00051212310791016 |
(481) |
DESCRIBE `ports` |
0.0018520355224609 |
(482) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') |
0.00038599967956543 |
(483) |
DESCRIBE `ports` |
0.0016651153564453 |
(484) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) |
0.00042891502380371 |
(485) |
DESCRIBE `ports` |
0.0017411708831787 |
(486) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') |
0.00035405158996582 |
(487) |
DESCRIBE `cruises` |
0.0033721923828125 |
(488) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63941))) |
0.0073380470275879 |
(489) |
DESCRIBE `avid_specials` |
0.0016970634460449 |
(490) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1523597 and class = 'Special') OR (item_id = 63941 and class = 'Cruise') OR (item_id = 741 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine') OR (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.0018548965454102 |
(491) |
DESCRIBE `cruiselines` |
0.0025601387023926 |
(492) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) |
0.0063850879669189 |
(493) |
DESCRIBE `orchid_image` |
0.0023901462554932 |
(494) |
DESCRIBE `cruiselines` |
0.0025680065155029 |
(495) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') |
0.007375955581665 |
(496) |
DESCRIBE `specials` |
0.005626916885376 |
(497) |
SELECT `specials`.* FROM `specials` WHERE (id = '1535106') AND (specials.orchid_available = 1) LIMIT 1 |
0.00083589553833008 |
(498) |
DESCRIBE `specials` |
0.012477159500122 |
(499) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1535106') |
0.00053310394287109 |
(500) |
DESCRIBE `ships` |
0.0097231864929199 |
(501) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) |
0.00057601928710938 |
(502) |
DESCRIBE `ships` |
0.0036799907684326 |
(503) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') |
0.0093388557434082 |
(504) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00034403800964355 |
(505) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00031685829162598 |
(506) |
DESCRIBE `itineraries` |
0.0024349689483643 |
(507) |
SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75085') ORDER BY `day` ASC, `itineraries`.`portorder` ASC |
0.00095701217651367 |
(508) |
DESCRIBE `ports` |
0.002255916595459 |
(509) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) |
0.0032150745391846 |
(510) |
DESCRIBE `ports` |
0.001990795135498 |
(511) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) |
0.0006558895111084 |
(512) |
DESCRIBE `ports` |
0.0016939640045166 |
(513) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') |
0.0013489723205566 |
(514) |
DESCRIBE `specialsailingdates` |
0.0057871341705322 |
(515) |
SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates`
INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1535106') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC |
0.00084710121154785 |
(516) |
DESCRIBE `sailingdates` |
0.001640796661377 |
(517) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 474259))) |
0.00037789344787598 |
(518) |
DESCRIBE `ports` |
0.0069441795349121 |
(519) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) |
0.00046396255493164 |
(520) |
DESCRIBE `ports` |
0.0017931461334229 |
(521) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') |
0.00033998489379883 |
(522) |
DESCRIBE `ports` |
0.0016520023345947 |
(523) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2355))) |
0.00046896934509277 |
(524) |
DESCRIBE `ports` |
0.0016508102416992 |
(525) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2355') |
0.0055429935455322 |
(526) |
DESCRIBE `ports` |
0.0018260478973389 |
(527) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) |
0.00040221214294434 |
(528) |
DESCRIBE `ports` |
0.0016970634460449 |
(529) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') |
0.0016589164733887 |
(530) |
DESCRIBE `ports` |
0.0020229816436768 |
(531) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5923))) |
0.0089099407196045 |
(532) |
DESCRIBE `ports` |
0.0018458366394043 |
(533) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5923') |
0.00034594535827637 |
(534) |
DESCRIBE `ports` |
0.0017669200897217 |
(535) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) |
0.00035405158996582 |
(536) |
DESCRIBE `ports` |
0.0021369457244873 |
(537) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') |
0.00042891502380371 |
(538) |
DESCRIBE `ports` |
0.0018439292907715 |
(539) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) |
0.0070710182189941 |
(540) |
DESCRIBE `ports` |
0.0044238567352295 |
(541) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') |
0.00049591064453125 |
(542) |
DESCRIBE `ports` |
0.0023288726806641 |
(543) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) |
0.00051522254943848 |
(544) |
DESCRIBE `ports` |
0.0093481540679932 |
(545) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') |
0.0004889965057373 |
(546) |
DESCRIBE `ports` |
0.0015411376953125 |
(547) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4862))) |
0.00038385391235352 |
(548) |
DESCRIBE `ports` |
0.0015249252319336 |
(549) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4862') |
0.00035214424133301 |
(550) |
DESCRIBE `ports` |
0.0016829967498779 |
(551) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) |
0.00036907196044922 |
(552) |
DESCRIBE `ports` |
0.010457992553711 |
(553) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') |
0.00047516822814941 |
(554) |
DESCRIBE `ports` |
0.0020198822021484 |
(555) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) |
0.00048303604125977 |
(556) |
DESCRIBE `ports` |
0.0019230842590332 |
(557) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') |
0.00036787986755371 |
(558) |
DESCRIBE `cruises` |
0.003148078918457 |
(559) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75085))) |
0.0092370510101318 |
(560) |
DESCRIBE `avid_specials` |
0.0018720626831055 |
(561) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1535106 and class = 'Special') OR (item_id = 75085 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 35 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.0021300315856934 |
(562) |
DESCRIBE `cruiselines` |
0.0025551319122314 |
(563) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) |
0.0006251335144043 |
(564) |
DESCRIBE `orchid_image` |
0.0022599697113037 |
(565) |
DESCRIBE `cruiselines` |
0.0093698501586914 |
(566) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') |
0.00054311752319336 |
(567) |
DESCRIBE `specials` |
0.0056149959564209 |
(568) |
SELECT `specials`.* FROM `specials` WHERE (id = '1524704') AND (specials.orchid_available = 1) LIMIT 1 |
0.009537935256958 |
(569) |
DESCRIBE `specials` |
0.0049729347229004 |
(570) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1524704') |
0.00045895576477051 |
(571) |
DESCRIBE `ships` |
0.0031349658966064 |
(572) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 404))) |
0.00063085556030273 |
(573) |
DESCRIBE `ships` |
0.0031571388244629 |
(574) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '404') |
0.00043201446533203 |
(575) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00030899047851562 |
(576) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00028109550476074 |
(577) |
DESCRIBE `itineraries` |
0.0017218589782715 |
(578) |
DESCRIBE `ports` |
0.0019388198852539 |
(579) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) |
0.00047087669372559 |
(580) |
DESCRIBE `ports` |
0.0020439624786377 |
(581) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) |
0.00046491622924805 |
(582) |
DESCRIBE `ports` |
0.002007007598877 |
(583) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') |
0.00041794776916504 |
(584) |
DESCRIBE `specialsailingdates` |
0.0016629695892334 |
(585) |
DESCRIBE `sailingdates` |
0.0020511150360107 |
(586) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 386454))) |
0.00059199333190918 |
(587) |
DESCRIBE `ports` |
0.0019581317901611 |
(588) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) |
0.00046801567077637 |
(589) |
DESCRIBE `ports` |
0.0018198490142822 |
(590) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') |
0.0004420280456543 |
(591) |
DESCRIBE `ports` |
0.0017518997192383 |
(592) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) |
0.0005650520324707 |
(593) |
DESCRIBE `ports` |
0.0019810199737549 |
(594) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') |
0.00045204162597656 |
(595) |
DESCRIBE `ports` |
0.0017869472503662 |
(596) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) |
0.00060200691223145 |
(597) |
DESCRIBE `ports` |
0.0021681785583496 |
(598) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') |
0.0005040168762207 |
(599) |
DESCRIBE `ports` |
0.0014598369598389 |
(600) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) |
0.00042915344238281 |
(601) |
DESCRIBE `ports` |
0.00180983543396 |
(602) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') |
0.00037097930908203 |
(603) |
DESCRIBE `ports` |
0.0017850399017334 |
(604) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) |
0.00041103363037109 |
(605) |
DESCRIBE `ports` |
0.0019848346710205 |
(606) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') |
0.00044703483581543 |
(607) |
DESCRIBE `ports` |
0.0016670227050781 |
(608) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) |
0.0004429817199707 |
(609) |
DESCRIBE `ports` |
0.0018279552459717 |
(610) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') |
0.00042200088500977 |
(611) |
DESCRIBE `ports` |
0.0016939640045166 |
(612) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) |
0.00043201446533203 |
(613) |
DESCRIBE `ports` |
0.0019690990447998 |
(614) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') |
0.0004570484161377 |
(615) |
DESCRIBE `ports` |
0.0020451545715332 |
(616) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) |
0.00047087669372559 |
(617) |
DESCRIBE `ports` |
0.0017361640930176 |
(618) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') |
0.00038385391235352 |
(619) |
DESCRIBE `cruises` |
0.0036499500274658 |
(620) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 43678))) |
0.00063490867614746 |
(621) |
DESCRIBE `avid_specials` |
0.0017809867858887 |
(622) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1524704 and class = 'Special') OR (item_id = 43678 and class = 'Cruise') OR (item_id = 404 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 29 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.0017848014831543 |
(623) |
DESCRIBE `cruiselines` |
0.0025041103363037 |
(624) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) |
0.00044107437133789 |
(625) |
DESCRIBE `orchid_image` |
0.0021510124206543 |
(626) |
DESCRIBE `cruiselines` |
0.0029041767120361 |
(627) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') |
0.00049304962158203 |
(628) |
DESCRIBE `specials` |
0.0059211254119873 |
(629) |
DESCRIBE `specials` |
0.0056300163269043 |
(630) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1524717') |
0.0004889965057373 |
(631) |
DESCRIBE `ships` |
0.0038628578186035 |
(632) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 669))) |
0.00064396858215332 |
(633) |
DESCRIBE `ships` |
0.0038211345672607 |
(634) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '669') |
0.0005190372467041 |
(635) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00037908554077148 |
(636) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00031709671020508 |
(637) |
DESCRIBE `itineraries` |
0.0017931461334229 |
(638) |
DESCRIBE `ports` |
0.0019838809967041 |
(639) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00043177604675293 |
(640) |
DESCRIBE `ports` |
0.0019950866699219 |
(641) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00056600570678711 |
(642) |
DESCRIBE `ports` |
0.0019540786743164 |
(643) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') |
0.00046706199645996 |
(644) |
DESCRIBE `specialsailingdates` |
0.0013439655303955 |
(645) |
DESCRIBE `sailingdates` |
0.0016608238220215 |
(646) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428518))) |
0.0004580020904541 |
(647) |
DESCRIBE `ports` |
0.0017249584197998 |
(648) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00042605400085449 |
(649) |
DESCRIBE `ports` |
0.0016629695892334 |
(650) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') |
0.00041604042053223 |
(651) |
DESCRIBE `ports` |
0.0016689300537109 |
(652) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) |
0.00042104721069336 |
(653) |
DESCRIBE `ports` |
0.0017991065979004 |
(654) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') |
0.00031590461730957 |
(655) |
DESCRIBE `ports` |
0.0018701553344727 |
(656) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) |
0.0004889965057373 |
(657) |
DESCRIBE `ports` |
0.0016310214996338 |
(658) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') |
0.00032401084899902 |
(659) |
DESCRIBE `ports` |
0.0032451152801514 |
(660) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) |
0.00058889389038086 |
(661) |
DESCRIBE `ports` |
0.0020339488983154 |
(662) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') |
0.00053095817565918 |
(663) |
DESCRIBE `ports` |
0.0020120143890381 |
(664) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00053906440734863 |
(665) |
DESCRIBE `ports` |
0.00205397605896 |
(666) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') |
0.00053310394287109 |
(667) |
DESCRIBE `cruises` |
0.003715991973877 |
(668) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67915))) |
0.00066614151000977 |
(669) |
DESCRIBE `avid_specials` |
0.0018610954284668 |
(670) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1524717 and class = 'Special') OR (item_id = 67915 and class = 'Cruise') OR (item_id = 669 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.0018608570098877 |
(671) |
DESCRIBE `cruiselines` |
0.0029261112213135 |
(672) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) |
0.00057506561279297 |
(673) |
DESCRIBE `orchid_image` |
0.0026800632476807 |
(674) |
DESCRIBE `cruiselines` |
0.0026028156280518 |
(675) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') |
0.00043606758117676 |
(676) |
DESCRIBE `cruiselines` |
0.002655029296875 |
(677) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('212', '33', '218', '114', '23', '18', '191', '264', '20', '140', '24', '19', '29', '4', '91', '151')) ORDER BY FIND_IN_SET(id, '212,33,218,114,23,18,191,264,20,140,24,19,29,4,91,151') |
0.0014050006866455 |
(678) |
DESCRIBE `ships` |
0.00357985496521 |
(679) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('1163', '1526', '1013', '1303', '160', '1282', '163', '1159', '1266', '1767', '1772', '1788', '1032', '338', '451', '547', '1262', '75', '162', '404', '580', '1073', '1205', '1491', '1539', '4', '74', '105', '147', '452', '622', '626', '652', '669', '678', '717', '741', '835', '1108', '1168', '1193', '1415', '1540', '1569', '1711')) ORDER BY FIND_IN_SET(id, '1163,1526,1013,1303,160,1282,163,1159,1266,1767,1772,1788,1032,338,451,547,1262,75,162,404,580,1073,1205,1491,1539,4,74,105,147,452,622,626,652,669,678,717,741,835,1108,1168,1193,1415,1540,1569,1711') |
0.0045969486236572 |
(680) |
DESCRIBE `cruisetypes` |
0.0015709400177002 |
(681) |
DESCRIBE `destinations` |
0.0019581317901611 |
(682) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '22', '43', '12', '49', '2', '28', '40', '50', '8', '35', '53', '55', '34', '11', '29', '38', '54', '25', '26', '37', '45', '52')) ORDER BY FIND_IN_SET(id, '39,22,43,12,49,2,28,40,50,8,35,53,55,34,11,29,38,54,25,26,37,45,52') |
0.0017631053924561 |