or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  5. Catch up on Cruising: Latest news in bite size

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 698

Total elapsed time: 0.40332889556885

# Query Time
(1) connect 0.00063395500183105
(2) DESCRIBE `cruises` 0.0017120838165283
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (63701, 64796, 64794, 58910, 64795, 67017, 63804, 65021, 70952, 70038)) ORDER BY FIND_IN_SET(id, '63701,64796,64794,58910,64795,67017,63804,65021,70952,70038') 0.0011630058288574
(4) DESCRIBE `cruises` 0.0015990734100342
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63701') 0.0002439022064209
(6) DESCRIBE `ships` 0.0013110637664795
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84))) 0.00026202201843262
(8) DESCRIBE `ships` 0.0013928413391113
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '84') 0.00021219253540039
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017499923706055
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017905235290527
(12) DESCRIBE `itineraries` 0.00066804885864258
(13) DESCRIBE `ports` 0.00078701972961426
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00023484230041504
(15) DESCRIBE `ports` 0.00071215629577637
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00020503997802734
(17) DESCRIBE `ports` 0.00067400932312012
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00019407272338867
(19) DESCRIBE `sailingdates` 0.00065398216247559
(20) DESCRIBE `ports` 0.00069284439086914
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00021004676818848
(22) DESCRIBE `ports` 0.00066590309143066
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00019001960754395
(24) DESCRIBE `ports` 0.00066494941711426
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00021004676818848
(26) DESCRIBE `ports` 0.00066518783569336
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00018215179443359
(28) DESCRIBE `ports` 0.00066304206848145
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 882))) 0.00020194053649902
(30) DESCRIBE `ports` 0.00066494941711426
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '882') 0.00017976760864258
(32) DESCRIBE `ports` 0.00066399574279785
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 325))) 0.0001981258392334
(34) DESCRIBE `ports` 0.00069093704223633
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '325') 0.00018095970153809
(36) DESCRIBE `ports` 0.00066399574279785
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00020384788513184
(38) DESCRIBE `ports` 0.00067996978759766
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00018191337585449
(40) DESCRIBE `ports` 0.00070905685424805
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1495))) 0.00020408630371094
(42) DESCRIBE `ports` 0.0006711483001709
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1495') 0.00018787384033203
(44) DESCRIBE `ports` 0.00067400932312012
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00020384788513184
(46) DESCRIBE `ports` 0.00072097778320312
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00018310546875
(48) DESCRIBE `ports` 0.00068187713623047
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00020194053649902
(50) DESCRIBE `ports` 0.00066494941711426
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00018692016601562
(52) DESCRIBE `ports` 0.00068092346191406
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00019383430480957
(54) DESCRIBE `ports` 0.00066804885864258
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00018095970153809
(56) DESCRIBE `ports` 0.00068283081054688
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00020790100097656
(58) DESCRIBE `ports` 0.0006859302520752
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.0001838207244873
(60) DESCRIBE `ports` 0.00067591667175293
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021100044250488
(62) DESCRIBE `ports` 0.00072288513183594
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0001828670501709
(64) DESCRIBE `ports` 0.00067901611328125
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020384788513184
(66) DESCRIBE `ports` 0.00093793869018555
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00021815299987793
(68) DESCRIBE `ports` 0.00086498260498047
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00024819374084473
(70) DESCRIBE `ports` 0.00084805488586426
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00026893615722656
(72) DESCRIBE `ports` 0.0008399486541748
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00028395652770996
(74) DESCRIBE `ports` 0.0007779598236084
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00039410591125488
(76) DESCRIBE `ports` 0.0010879039764404
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.0002739429473877
(78) DESCRIBE `ports` 0.00090599060058594
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00023508071899414
(80) DESCRIBE `ports` 0.00089406967163086
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 476))) 0.00025582313537598
(82) DESCRIBE `ports` 0.00087904930114746
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '476') 0.00022506713867188
(84) DESCRIBE `ports` 0.00087189674377441
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.0002591609954834
(86) DESCRIBE `ports` 0.00089216232299805
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00023102760314941
(88) DESCRIBE `ports` 0.00086283683776855
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00024294853210449
(90) DESCRIBE `ports` 0.00088000297546387
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00021791458129883
(92) DESCRIBE `ports` 0.0008690357208252
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00023794174194336
(94) DESCRIBE `ports` 0.00088810920715332
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00022482872009277
(96) DESCRIBE `avid_specials` 0.0008091926574707
(97) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63701 and class = 'Cruise') OR (item_id = 84 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 37 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.0016710758209229
(98) DESCRIBE `cruiselines` 0.0014121532440186
(99) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00030779838562012
(100) DESCRIBE `orchid_image` 0.0010449886322021
(101) DESCRIBE `cruiselines` 0.0012919902801514
(102) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00025486946105957
(103) DESCRIBE `cruises` 0.0016961097717285
(104) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64796') 0.00026488304138184
(105) DESCRIBE `ships` 0.0017321109771729
(106) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00031805038452148
(107) DESCRIBE `ships` 0.0018188953399658
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00028085708618164
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00022196769714355
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021100044250488
(111) DESCRIBE `itineraries` 0.00092792510986328
(112) DESCRIBE `ports` 0.00095200538635254
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00028896331787109
(114) DESCRIBE `ports` 0.00098204612731934
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0002751350402832
(116) DESCRIBE `ports` 0.00099301338195801
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.000244140625
(118) DESCRIBE `sailingdates` 0.00085210800170898
(119) DESCRIBE `ports` 0.0010449886322021
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00029182434082031
(121) DESCRIBE `ports` 0.00091910362243652
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00023603439331055
(123) DESCRIBE `ports` 0.00090718269348145
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00025796890258789
(125) DESCRIBE `ports` 0.00088095664978027
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00022602081298828
(127) DESCRIBE `ports` 0.00090909004211426
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00024700164794922
(129) DESCRIBE `ports` 0.00089192390441895
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00022387504577637
(131) DESCRIBE `ports` 0.00090408325195312
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00026082992553711
(133) DESCRIBE `ports` 0.00087404251098633
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00022602081298828
(135) DESCRIBE `ports` 0.00092887878417969
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00025391578674316
(137) DESCRIBE `ports` 0.00086617469787598
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00022792816162109
(139) DESCRIBE `ports` 0.00094509124755859
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00025415420532227
(141) DESCRIBE `ports` 0.00082683563232422
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00023889541625977
(143) DESCRIBE `ports` 0.0008690357208252
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00025701522827148
(145) DESCRIBE `ports` 0.00092005729675293
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00024318695068359
(147) DESCRIBE `ports` 0.00097417831420898
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00027799606323242
(149) DESCRIBE `ports` 0.00099992752075195
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00025391578674316
(151) DESCRIBE `ports` 0.00095295906066895
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00028896331787109
(153) DESCRIBE `ports` 0.00095200538635254
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00022196769714355
(155) DESCRIBE `ports` 0.00088095664978027
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00025296211242676
(157) DESCRIBE `ports` 0.00089287757873535
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00022983551025391
(159) DESCRIBE `ports` 0.00088119506835938
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00025415420532227
(161) DESCRIBE `ports` 0.00088095664978027
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00025081634521484
(163) DESCRIBE `ports` 0.00089406967163086
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00025296211242676
(165) DESCRIBE `ports` 0.00091195106506348
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.0002751350402832
(167) DESCRIBE `ports` 0.00091385841369629
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00026202201843262
(169) DESCRIBE `ports` 0.00089406967163086
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00022292137145996
(171) DESCRIBE `ports` 0.00084710121154785
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.0002589225769043
(173) DESCRIBE `ports` 0.00097894668579102
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00025796890258789
(175) DESCRIBE `ports` 0.00087499618530273
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00024580955505371
(177) DESCRIBE `ports` 0.00087499618530273
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00024199485778809
(179) DESCRIBE `ports` 0.00087404251098633
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00028014183044434
(181) DESCRIBE `ports` 0.00099396705627441
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00026106834411621
(183) DESCRIBE `avid_specials` 0.00094103813171387
(184) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64796 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 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.0017251968383789
(185) DESCRIBE `cruiselines` 0.0013108253479004
(186) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00027799606323242
(187) DESCRIBE `orchid_image` 0.00088000297546387
(188) DESCRIBE `cruiselines` 0.0009768009185791
(189) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00021481513977051
(190) DESCRIBE `cruises` 0.0012989044189453
(191) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64794') 0.00023388862609863
(192) DESCRIBE `ships` 0.0012681484222412
(193) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00029897689819336
(194) DESCRIBE `ships` 0.0014259815216064
(195) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00025486946105957
(196) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018692016601562
(197) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021505355834961
(198) DESCRIBE `itineraries` 0.00084090232849121
(199) DESCRIBE `ports` 0.00072216987609863
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00027894973754883
(201) DESCRIBE `ports` 0.00067996978759766
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020909309387207
(203) DESCRIBE `ports` 0.0007319450378418
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00020313262939453
(205) DESCRIBE `sailingdates` 0.00061678886413574
(206) DESCRIBE `ports` 0.00096297264099121
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00029087066650391
(208) DESCRIBE `ports` 0.00088906288146973
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024104118347168
(210) DESCRIBE `ports` 0.00083398818969727
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00025606155395508
(212) DESCRIBE `ports` 0.0009000301361084
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00023818016052246
(214) DESCRIBE `ports` 0.00083494186401367
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00024104118347168
(216) DESCRIBE `ports` 0.00082492828369141
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00021505355834961
(218) DESCRIBE `ports` 0.0008389949798584
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00024604797363281
(220) DESCRIBE `ports` 0.00083613395690918
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00023698806762695
(222) DESCRIBE `ports` 0.00088286399841309
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00024199485778809
(224) DESCRIBE `ports` 0.00068402290344238
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00019192695617676
(226) DESCRIBE `ports` 0.00071978569030762
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022792816162109
(228) DESCRIBE `ports` 0.00075411796569824
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00021100044250488
(230) DESCRIBE `ports` 0.00087594985961914
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00023102760314941
(232) DESCRIBE `ports` 0.00068306922912598
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00020503997802734
(234) DESCRIBE `ports` 0.00066995620727539
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00021910667419434
(236) DESCRIBE `ports` 0.00069189071655273
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00018596649169922
(238) DESCRIBE `ports` 0.00066304206848145
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00020003318786621
(240) DESCRIBE `ports` 0.0006721019744873
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00017905235290527
(242) DESCRIBE `ports` 0.00066614151000977
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00020408630371094
(244) DESCRIBE `ports` 0.00068402290344238
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00018501281738281
(246) DESCRIBE `ports` 0.00066208839416504
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020313262939453
(248) DESCRIBE `ports` 0.00068497657775879
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018596649169922
(250) DESCRIBE `avid_specials` 0.00061917304992676
(251) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64794 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 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.0010299682617188
(252) DESCRIBE `cruiselines` 0.00099802017211914
(253) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00022315979003906
(254) DESCRIBE `orchid_image` 0.00076007843017578
(255) DESCRIBE `cruiselines` 0.0010511875152588
(256) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0004429817199707
(257) DESCRIBE `cruises` 0.0015909671783447
(258) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58910') 0.0002739429473877
(259) DESCRIBE `ships` 0.001453161239624
(260) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 335))) 0.00030612945556641
(261) DESCRIBE `ships` 0.0015261173248291
(262) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '335') 0.0001990795135498
(263) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023698806762695
(264) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023293495178223
(265) DESCRIBE `itineraries` 0.00069904327392578
(266) DESCRIBE `ports` 0.00070905685424805
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022792816162109
(268) DESCRIBE `ports` 0.00067591667175293
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020194053649902
(270) DESCRIBE `ports` 0.00067400932312012
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019192695617676
(272) DESCRIBE `sailingdates` 0.00061511993408203
(273) DESCRIBE `ports` 0.00084996223449707
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024700164794922
(275) DESCRIBE `ports` 0.00071310997009277
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019502639770508
(277) DESCRIBE `ports` 0.00073909759521484
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00024318695068359
(279) DESCRIBE `ports` 0.00069284439086914
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00019097328186035
(281) DESCRIBE `ports` 0.00067305564880371
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00022506713867188
(283) DESCRIBE `ports` 0.0006709098815918
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00018501281738281
(285) DESCRIBE `ports` 0.00067400932312012
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00021004676818848
(287) DESCRIBE `ports` 0.00066781044006348
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00018310546875
(289) DESCRIBE `ports` 0.00077390670776367
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.0001988410949707
(291) DESCRIBE `ports` 0.00067305564880371
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00017881393432617
(293) DESCRIBE `ports` 0.00068783760070801
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2089))) 0.00020790100097656
(295) DESCRIBE `ports` 0.00066709518432617
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2089') 0.00018119812011719
(297) DESCRIBE `ports` 0.00066804885864258
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00020194053649902
(299) DESCRIBE `ports` 0.00073695182800293
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00018191337585449
(301) DESCRIBE `ports` 0.00067496299743652
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1155))) 0.00020885467529297
(303) DESCRIBE `ports` 0.00066685676574707
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1155') 0.00018310546875
(305) DESCRIBE `ports` 0.0007011890411377
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020408630371094
(307) DESCRIBE `ports` 0.00067901611328125
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0001838207244873
(309) DESCRIBE `avid_specials` 0.00090599060058594
(310) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58910 and class = 'Cruise') OR (item_id = 335 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 48 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.0010590553283691
(311) DESCRIBE `cruiselines` 0.0010621547698975
(312) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00023102760314941
(313) DESCRIBE `orchid_image` 0.0007929801940918
(314) DESCRIBE `cruiselines` 0.00094008445739746
(315) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00020599365234375
(316) DESCRIBE `cruises` 0.0013358592987061
(317) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64795') 0.00022077560424805
(318) DESCRIBE `ships` 0.0015828609466553
(319) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00035595893859863
(320) DESCRIBE `ships` 0.0013349056243896
(321) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00021505355834961
(322) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023818016052246
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023698806762695
(324) DESCRIBE `itineraries` 0.00088000297546387
(325) DESCRIBE `ports` 0.00072097778320312
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024604797363281
(327) DESCRIBE `ports` 0.00068402290344238
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020408630371094
(329) DESCRIBE `ports` 0.00068402290344238
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00023007392883301
(331) DESCRIBE `sailingdates` 0.00066113471984863
(332) DESCRIBE `ports` 0.0010180473327637
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030183792114258
(334) DESCRIBE `ports` 0.00090694427490234
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024080276489258
(336) DESCRIBE `ports` 0.00089502334594727
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00025510787963867
(338) DESCRIBE `ports` 0.00095987319946289
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00027608871459961
(340) DESCRIBE `ports` 0.0010838508605957
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00027799606323242
(342) DESCRIBE `ports` 0.0010302066802979
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00024509429931641
(344) DESCRIBE `ports` 0.0010089874267578
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00029492378234863
(346) DESCRIBE `ports` 0.0010619163513184
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00031399726867676
(348) DESCRIBE `ports` 0.00099492073059082
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00029897689819336
(350) DESCRIBE `ports` 0.00095701217651367
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00024890899658203
(352) DESCRIBE `ports` 0.00095510482788086
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030303001403809
(354) DESCRIBE `ports` 0.0011570453643799
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002899169921875
(356) DESCRIBE `avid_specials` 0.00090503692626953
(357) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64795 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 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.0017590522766113
(358) DESCRIBE `cruiselines` 0.0015830993652344
(359) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00035691261291504
(360) DESCRIBE `orchid_image` 0.0011279582977295
(361) DESCRIBE `cruiselines` 0.0015220642089844
(362) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00026297569274902
(363) DESCRIBE `cruises` 0.0019199848175049
(364) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67017') 0.00031709671020508
(365) DESCRIBE `ships` 0.0020902156829834
(366) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 78))) 0.00029301643371582
(367) DESCRIBE `ships` 0.0013401508331299
(368) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '78') 0.00019097328186035
(369) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018405914306641
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017285346984863
(371) DESCRIBE `itineraries` 0.00067996978759766
(372) DESCRIBE `ports` 0.00068902969360352
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00022602081298828
(374) DESCRIBE `ports` 0.0006718635559082
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00020098686218262
(376) DESCRIBE `ports` 0.00070595741271973
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00019097328186035
(378) DESCRIBE `sailingdates` 0.00060510635375977
(379) DESCRIBE `ports` 0.00076389312744141
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00023388862609863
(381) DESCRIBE `ports` 0.0006871223449707
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00019311904907227
(383) DESCRIBE `ports` 0.00068497657775879
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00020599365234375
(385) DESCRIBE `ports` 0.00069022178649902
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00018405914306641
(387) DESCRIBE `ports` 0.00067019462585449
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00021481513977051
(389) DESCRIBE `ports` 0.00068998336791992
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00018596649169922
(391) DESCRIBE `ports` 0.00072598457336426
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1082))) 0.00020694732666016
(393) DESCRIBE `ports` 0.00067400932312012
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1082') 0.00024008750915527
(395) DESCRIBE `ports` 0.00086092948913574
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00024199485778809
(397) DESCRIBE `ports` 0.00069904327392578
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00018477439880371
(399) DESCRIBE `ports` 0.00067591667175293
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00021004676818848
(401) DESCRIBE `ports` 0.00067687034606934
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00018715858459473
(403) DESCRIBE `avid_specials` 0.00060796737670898
(404) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67017 and class = 'Cruise') OR (item_id = 78 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 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.00099015235900879
(405) DESCRIBE `cruiselines` 0.0010240077972412
(406) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00022101402282715
(407) DESCRIBE `orchid_image` 0.00076007843017578
(408) DESCRIBE `cruiselines` 0.00098395347595215
(409) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00020408630371094
(410) DESCRIBE `cruises` 0.0013418197631836
(411) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63804') 0.00023412704467773
(412) DESCRIBE `ships` 0.0012669563293457
(413) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 313))) 0.00026392936706543
(414) DESCRIBE `ships` 0.0013461112976074
(415) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '313') 0.00018596649169922
(416) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018215179443359
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017595291137695
(418) DESCRIBE `itineraries` 0.00066995620727539
(419) DESCRIBE `ports` 0.00084900856018066
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030684471130371
(421) DESCRIBE `ports` 0.00081300735473633
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024318695068359
(423) DESCRIBE `ports` 0.00068211555480957
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019407272338867
(425) DESCRIBE `sailingdates` 0.00060296058654785
(426) DESCRIBE `ports` 0.00068998336791992
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0002138614654541
(428) DESCRIBE `ports` 0.00066900253295898
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019383430480957
(430) DESCRIBE `ports` 0.0006718635559082
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00020503997802734
(432) DESCRIBE `ports` 0.00070095062255859
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00018596649169922
(434) DESCRIBE `ports` 0.00067305564880371
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1090))) 0.00021195411682129
(436) DESCRIBE `ports` 0.00067710876464844
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1090') 0.0001838207244873
(438) DESCRIBE `ports` 0.00067901611328125
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2128))) 0.00020194053649902
(440) DESCRIBE `ports` 0.00066804885864258
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2128') 0.00018405914306641
(442) DESCRIBE `ports` 0.00067901611328125
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1185))) 0.0002589225769043
(444) DESCRIBE `ports` 0.00067281723022461
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1185') 0.0001838207244873
(446) DESCRIBE `ports` 0.00066518783569336
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00020003318786621
(448) DESCRIBE `ports` 0.00066590309143066
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00017976760864258
(450) DESCRIBE `ports` 0.00066590309143066
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 314))) 0.00020813941955566
(452) DESCRIBE `ports` 0.00066399574279785
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '314') 0.00018501281738281
(454) DESCRIBE `ports` 0.00066995620727539
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 665))) 0.00020289421081543
(456) DESCRIBE `ports` 0.0006709098815918
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '665') 0.00018310546875
(458) DESCRIBE `ports` 0.00066494941711426
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.0002129077911377
(460) DESCRIBE `ports` 0.00069904327392578
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.0001838207244873
(462) DESCRIBE `ports` 0.00068283081054688
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00022006034851074
(464) DESCRIBE `ports` 0.00068998336791992
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00021791458129883
(466) DESCRIBE `ports` 0.00073504447937012
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00020289421081543
(468) DESCRIBE `ports` 0.00072097778320312
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00018501281738281
(470) DESCRIBE `ports` 0.00066900253295898
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022196769714355
(472) DESCRIBE `ports` 0.00068497657775879
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019001960754395
(474) DESCRIBE `avid_specials` 0.00060677528381348
(475) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63804 and class = 'Cruise') OR (item_id = 313 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 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.0010359287261963
(476) DESCRIBE `cruiselines` 0.0010080337524414
(477) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00023698806762695
(478) DESCRIBE `orchid_image` 0.00081801414489746
(479) DESCRIBE `cruiselines` 0.00099992752075195
(480) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00021791458129883
(481) DESCRIBE `cruises` 0.0012941360473633
(482) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65021') 0.00022506713867188
(483) DESCRIBE `ships` 0.0013110637664795
(484) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00025701522827148
(485) DESCRIBE `ships` 0.0013010501861572
(486) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00019288063049316
(487) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001828670501709
(488) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017309188842773
(489) DESCRIBE `itineraries` 0.00074291229248047
(490) DESCRIBE `ports` 0.00072193145751953
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0002291202545166
(492) DESCRIBE `ports` 0.00067496299743652
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020599365234375
(494) DESCRIBE `ports` 0.00076007843017578
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00019192695617676
(496) DESCRIBE `sailingdates` 0.00063896179199219
(497) DESCRIBE `ports` 0.00073409080505371
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00021195411682129
(499) DESCRIBE `ports` 0.00071120262145996
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00019502639770508
(501) DESCRIBE `ports` 0.00068092346191406
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00028085708618164
(503) DESCRIBE `ports` 0.00072216987609863
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00018882751464844
(505) DESCRIBE `ports` 0.00083589553833008
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026798248291016
(507) DESCRIBE `ports` 0.00073504447937012
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021886825561523
(509) DESCRIBE `ports` 0.0008089542388916
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00028300285339355
(511) DESCRIBE `ports` 0.00072813034057617
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00019502639770508
(513) DESCRIBE `ports` 0.00067496299743652
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00026583671569824
(515) DESCRIBE `ports` 0.00099921226501465
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00019097328186035
(517) DESCRIBE `ports` 0.0010170936584473
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00027799606323242
(519) DESCRIBE `ports` 0.0010631084442139
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00019693374633789
(521) DESCRIBE `ports` 0.00069594383239746
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0002589225769043
(523) DESCRIBE `ports` 0.00073480606079102
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00024199485778809
(525) DESCRIBE `ports` 0.00087189674377441
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00028896331787109
(527) DESCRIBE `ports` 0.0010230541229248
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00025701522827148
(529) DESCRIBE `ports` 0.0009760856628418
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00021600723266602
(531) DESCRIBE `ports` 0.00082802772521973
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00025796890258789
(533) DESCRIBE `ports` 0.00090384483337402
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00025510787963867
(535) DESCRIBE `ports` 0.00079607963562012
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00021505355834961
(537) DESCRIBE `ports` 0.00071597099304199
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00023818016052246
(539) DESCRIBE `ports` 0.00071001052856445
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00018405914306641
(541) DESCRIBE `ports` 0.00068807601928711
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0002129077911377
(543) DESCRIBE `ports` 0.00070595741271973
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00019693374633789
(545) DESCRIBE `ports` 0.000701904296875
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00022101402282715
(547) DESCRIBE `ports` 0.00074195861816406
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00019407272338867
(549) DESCRIBE `avid_specials` 0.0006248950958252
(550) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65021 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.00099396705627441
(551) DESCRIBE `cruiselines` 0.0010380744934082
(552) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00023007392883301
(553) DESCRIBE `orchid_image` 0.00078916549682617
(554) DESCRIBE `cruiselines` 0.0010089874267578
(555) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00022792816162109
(556) DESCRIBE `cruises` 0.0013811588287354
(557) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70952') 0.00025510787963867
(558) DESCRIBE `ships` 0.0013401508331299
(559) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00027990341186523
(560) DESCRIBE `ships` 0.0014379024505615
(561) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00023603439331055
(562) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001828670501709
(563) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020909309387207
(564) DESCRIBE `itineraries` 0.0010390281677246
(565) DESCRIBE `ports` 0.00097298622131348
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032901763916016
(567) DESCRIBE `ports` 0.00094485282897949
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00028300285339355
(569) DESCRIBE `ports` 0.0009160041809082
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00024604797363281
(571) DESCRIBE `sailingdates` 0.0007929801940918
(572) DESCRIBE `ports` 0.00093603134155273
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029301643371582
(574) DESCRIBE `ports` 0.00091099739074707
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00024700164794922
(576) DESCRIBE `ports` 0.00099897384643555
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00029516220092773
(578) DESCRIBE `ports` 0.00086307525634766
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00020408630371094
(580) DESCRIBE `ports` 0.00071811676025391
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023603439331055
(582) DESCRIBE `ports` 0.00070381164550781
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001978874206543
(584) DESCRIBE `avid_specials` 0.00065207481384277
(585) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70952 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.0012109279632568
(586) DESCRIBE `cruiselines` 0.0011038780212402
(587) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0002598762512207
(588) DESCRIBE `orchid_image` 0.00095987319946289
(589) DESCRIBE `cruiselines` 0.0012860298156738
(590) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00022792816162109
(591) DESCRIBE `cruises` 0.0013079643249512
(592) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70038') 0.0002439022064209
(593) DESCRIBE `ships` 0.0013730525970459
(594) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 82))) 0.00028681755065918
(595) DESCRIBE `ships` 0.0022680759429932
(596) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '82') 0.00031113624572754
(597) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022697448730469
(598) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021600723266602
(599) DESCRIBE `itineraries` 0.0010418891906738
(600) DESCRIBE `ports` 0.0010569095611572
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00025701522827148
(602) DESCRIBE `ports` 0.00069284439086914
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020217895507812
(604) DESCRIBE `ports` 0.00075697898864746
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00019717216491699
(606) DESCRIBE `sailingdates` 0.00072598457336426
(607) DESCRIBE `ports` 0.00070691108703613
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00024199485778809
(609) DESCRIBE `ports` 0.00067710876464844
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0002138614654541
(611) DESCRIBE `ports` 0.00067996978759766
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00020813941955566
(613) DESCRIBE `ports` 0.00082492828369141
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00018405914306641
(615) DESCRIBE `ports` 0.00077199935913086
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00020694732666016
(617) DESCRIBE `ports` 0.00072813034057617
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00018191337585449
(619) DESCRIBE `ports` 0.0007319450378418
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00020599365234375
(621) DESCRIBE `ports` 0.00076794624328613
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00019097328186035
(623) DESCRIBE `ports` 0.00067591667175293
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00022602081298828
(625) DESCRIBE `ports` 0.00068116188049316
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00018000602722168
(627) DESCRIBE `ports` 0.00068807601928711
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 596))) 0.0002140998840332
(629) DESCRIBE `ports` 0.00091385841369629
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '596') 0.00024914741516113
(631) DESCRIBE `ports` 0.00092911720275879
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00027298927307129
(633) DESCRIBE `ports` 0.00098013877868652
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00023198127746582
(635) DESCRIBE `ports` 0.00087594985961914
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00022006034851074
(637) DESCRIBE `ports` 0.00080108642578125
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00018692016601562
(639) DESCRIBE `ports` 0.00069999694824219
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00024700164794922
(641) DESCRIBE `ports` 0.00086784362792969
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00023794174194336
(643) DESCRIBE `ports` 0.00086307525634766
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0002589225769043
(645) DESCRIBE `ports` 0.00087785720825195
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0002598762512207
(647) DESCRIBE `ports` 0.00087094306945801
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3763))) 0.00025200843811035
(649) DESCRIBE `ports` 0.00086402893066406
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3763') 0.00023198127746582
(651) DESCRIBE `ports` 0.00086808204650879
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 417))) 0.00026297569274902
(653) DESCRIBE `ports` 0.00087499618530273
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '417') 0.00022196769714355
(655) DESCRIBE `ports` 0.00078296661376953
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1047))) 0.0002138614654541
(657) DESCRIBE `ports` 0.00069808959960938
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1047') 0.00018692016601562
(659) DESCRIBE `ports` 0.00070405006408691
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00021505355834961
(661) DESCRIBE `ports` 0.00068402290344238
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.0001828670501709
(663) DESCRIBE `ports` 0.00067806243896484
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 593))) 0.00021004676818848
(665) DESCRIBE `ports` 0.00076794624328613
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '593') 0.00018405914306641
(667) DESCRIBE `ports` 0.00068807601928711
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00020909309387207
(669) DESCRIBE `ports` 0.00070810317993164
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.0002138614654541
(671) DESCRIBE `ports` 0.00069713592529297
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00020408630371094
(673) DESCRIBE `ports` 0.00068783760070801
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00017881393432617
(675) DESCRIBE `ports` 0.00070095062255859
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4083))) 0.00021100044250488
(677) DESCRIBE `ports` 0.00069308280944824
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4083') 0.00017881393432617
(679) DESCRIBE `ports` 0.00072312355041504
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020694732666016
(681) DESCRIBE `ports` 0.00070500373840332
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00023317337036133
(683) DESCRIBE `avid_specials` 0.0009160041809082
(684) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70038 and class = 'Cruise') OR (item_id = 82 AND class = 'Ship') OR (item_id = 18 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.0018079280853271
(685) DESCRIBE `cruiselines` 0.0015289783477783
(686) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00035214424133301
(687) DESCRIBE `orchid_image` 0.001060962677002
(688) DESCRIBE `cruiselines` 0.0015568733215332
(689) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00027990341186523
(690) DESCRIBE `ships` 0.0016601085662842
(691) SELECT `ships`.* FROM `ships` WHERE (id IN ('792', '78', '340', '657', '82', '1302', '401', '81', '1607', '75', '313', '547', '74', '335', '84')) ORDER BY FIND_IN_SET(id, '792,78,340,657,82,1302,401,81,1607,75,313,547,74,335,84') 0.00085687637329102
(692) DESCRIBE `cruisetypes` 0.0009620189666748
(693) DESCRIBE `destinations` 0.0010578632354736
(694) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '2', '48', '11', '25', '35', '22', '43', '26', '37', '38', '40', '53', '49', '21', '34', '28', '29', '8', '10', '9', '30')) ORDER BY FIND_IN_SET(id, '12,2,48,11,25,35,22,43,26,37,38,40,53,49,21,34,28,29,8,10,9,30') 0.00098490715026855
(695) DESCRIBE `cruiselines` 0.0012578964233398
(696) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00035905838012695
(697) DESCRIBE `cruiselines` 0.0013041496276855
(698) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0002899169921875