(1) |
connect |
0.00059294700622559 |
(2) |
DESCRIBE `cruises` |
0.0017940998077393 |
(3) |
SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'emmylou-overnight-cruise-ex-echuca-return') AND (orchid_available = 1) LIMIT 1 |
0.00056600570678711 |
(4) |
DESCRIBE `avid_specials` |
0.000701904296875 |
(5) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 289 and class = 'Cruise') OR (item_id = 198 AND class = 'Ship') OR (item_id = 48 AND class = 'CruiseLine') OR (item_id = 46 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.00091719627380371 |
(6) |
SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '289') |
0.00018692016601562 |
(7) |
DESCRIBE `ships` |
0.0014338493347168 |
(8) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 198))) |
0.00026106834411621 |
(9) |
DESCRIBE `ships` |
0.0012969970703125 |
(10) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '198') |
0.0001838207244873 |
(11) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00017809867858887 |
(12) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.0001680850982666 |
(13) |
DESCRIBE `itineraries` |
0.00067996978759766 |
(14) |
DESCRIBE `ports` |
0.00071406364440918 |
(15) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) |
0.00024795532226562 |
(16) |
DESCRIBE `ports` |
0.0006868839263916 |
(17) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) |
0.0001978874206543 |
(18) |
DESCRIBE `ports` |
0.0006861686706543 |
(19) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '257') |
0.00018000602722168 |
(20) |
DESCRIBE `sailingdates` |
0.00062394142150879 |
(21) |
DESCRIBE `ports` |
0.00073385238647461 |
(22) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) |
0.00023293495178223 |
(23) |
DESCRIBE `ports` |
0.00068497657775879 |
(24) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '257') |
0.00018095970153809 |
(25) |
DESCRIBE `ports` |
0.0006859302520752 |
(26) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) |
0.0001988410949707 |
(27) |
DESCRIBE `ports` |
0.00067901611328125 |
(28) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') |
0.00017809867858887 |
(29) |
DESCRIBE `ports` |
0.00067281723022461 |
(30) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) |
0.00019383430480957 |
(31) |
DESCRIBE `ports` |
0.00070500373840332 |
(32) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '257') |
0.00017404556274414 |
(33) |
DESCRIBE `cruiselines` |
0.001007080078125 |
(34) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 48))) |
0.0002131462097168 |
(35) |
DESCRIBE `orchid_image` |
0.00076913833618164 |
(36) |
DESCRIBE `cruiselines` |
0.00094485282897949 |
(37) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '48') |
0.00018095970153809 |
(38) |
DESCRIBE `cabins` |
0.00069403648376465 |
(39) |
DESCRIBE `deckplans` |
0.00065398216247559 |
(40) |
DESCRIBE `shipphotos` |
0.00087285041809082 |
(41) |
DESCRIBE `cruiselines` |
0.0018959045410156 |
(42) |
DESCRIBE `cruisetypes` |
0.00085806846618652 |
(43) |
DESCRIBE `destinations` |
0.0014431476593018 |
(44) |
DESCRIBE `ships` |
0.0014340877532959 |
(45) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 211))) |
0.00032591819763184 |
(46) |
DESCRIBE `ships` |
0.0018470287322998 |
(47) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 211))) |
0.00036191940307617 |
(48) |
DESCRIBE `ports` |
0.00082516670227051 |
(49) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) |
0.00021886825561523 |