| (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 |
