(1) |
connect |
0.0007469654083252 |
(2) |
DESCRIBE `ports` |
0.0023040771484375 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'yokohama-japan') AND (orchid_available = 1) LIMIT 1 |
0.0075721740722656 |
(4) |
DESCRIBE `destinations` |
0.0026509761810303 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 35))) |
0.00046491622924805 |
(6) |
DESCRIBE `avid_specials` |
0.0015780925750732 |
(7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((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.0016140937805176 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') |
0.0003211498260498 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '833') |
0.0019910335540771 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '833') |
0.0019910335540771 |
(11) |
DESCRIBE `cruises` |
0.0039091110229492 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (67820, 69467, 69468, 71890, 71891, 71892, 75291, 69469, 71571, 71572)) ORDER BY FIND_IN_SET(id, '67820,69467,69468,71890,71891,71892,75291,69469,71571,71572') |
0.0018868446350098 |
(13) |
DESCRIBE `cruiselines` |
0.0030930042266846 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '18', '8', '15', '187', '12', '33', '91', '24', '26', '151', '20', '29', '105', '19')) ORDER BY FIND_IN_SET(id, '23,18,8,15,187,12,33,91,24,26,151,20,29,105,19') |
0.0019440650939941 |
(15) |
DESCRIBE `ships` |
0.0042080879211426 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '780', '45', '401', '1454', '105', '75', '62', '508', '1266', '1168', '652', '1738', '506', '776', '1141', '1398', '448', '485', '738', '1409')) ORDER BY FIND_IN_SET(id, '349,780,45,401,1454,105,75,62,508,1266,1168,652,1738,506,776,1141,1398,448,485,738,1409') |
0.0028059482574463 |
(17) |
DESCRIBE `cruisetypes` |
0.0019209384918213 |
(18) |
DESCRIBE `destinations` |
0.0030829906463623 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('35', '40', '2', '43')) ORDER BY FIND_IN_SET(id, '35,40,2,43') |
0.0010888576507568 |
(20) |
DESCRIBE `ports` |
0.0020890235900879 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) |
0.00050997734069824 |