(1) |
connect |
0.0010130405426025 |
(2) |
DESCRIBE `ports` |
0.002418041229248 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'tauranga-new-zealand') AND (orchid_available = 1) LIMIT 1 |
0.0056211948394775 |
(4) |
DESCRIBE `destinations` |
0.0029318332672119 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) |
0.0005488395690918 |
(6) |
DESCRIBE `avid_specials` |
0.0017251968383789 |
(7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((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.0019831657409668 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') |
0.00045990943908691 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '488') |
0.0027718544006348 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '488') |
0.0025479793548584 |
(11) |
DESCRIBE `cruises` |
0.0036900043487549 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (68752, 70760, 70761, 67334, 69311, 71200, 69301, 71131, 66817, 69294)) ORDER BY FIND_IN_SET(id, '68752,70760,70761,67334,69311,71200,69301,71131,66817,69294') |
0.0018141269683838 |
(13) |
DESCRIBE `cruiselines` |
0.0028350353240967 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '18', '8', '20', '24', '262', '28', '187', '26', '50', '14', '114', '29', '151', '15', '19', '91', '12', '159', '105', '37')) ORDER BY FIND_IN_SET(id, '23,18,8,20,24,262,28,187,26,50,14,114,29,151,15,19,91,12,159,105,37') |
0.0022411346435547 |
(15) |
DESCRIBE `ships` |
0.0042078495025635 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('253', '547', '683', '485', '75', '678', '1325', '1454', '483', '1409', '1492', '1539', '451', '111', '1330', '1398', '287', '338', '394', '766', '780', '66', '332', '775', '1474', '1672', '108', '506', '616', '776', '74', '652', '692', '695', '717', '997', '1168', '1749', '1758')) ORDER BY FIND_IN_SET(id, '253,547,683,485,75,678,1325,1454,483,1409,1492,1539,451,111,1330,1398,287,338,394,766,780,66,332,775,1474,1672,108,506,616,776,74,652,692,695,717,997,1168,1749,1758') |
0.0040900707244873 |
(17) |
DESCRIBE `cruisetypes` |
0.0018508434295654 |
(18) |
DESCRIBE `destinations` |
0.0027589797973633 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '40', '8')) ORDER BY FIND_IN_SET(id, '43,40,8') |
0.00093698501586914 |
(20) |
DESCRIBE `ports` |
0.0023329257965088 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) |
0.0005180835723877 |