(1) |
connect |
0.0010240077972412 |
(2) |
DESCRIBE `cruiselines` |
0.0032851696014404 |
(3) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'norwegian-cruise-line') AND (orchid_available = 1) LIMIT 1 |
0.00094795227050781 |
(4) |
DESCRIBE `avid_specials` |
0.0022690296173096 |
(5) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '20' AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) |
0.0012748241424561 |
(6) |
DESCRIBE `orchid_image` |
0.0025181770324707 |
(7) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') |
0.00060582160949707 |
(8) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00039196014404297 |
(9) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00035810470581055 |
(10) |
DESCRIBE `cruises` |
0.0044929981231689 |
(11) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (74509, 75569, 78257, 83879, 81113, 78518, 84077, 25397, 48184, 51044)) ORDER BY FIND_IN_SET(id, '74509,75569,78257,83879,81113,78518,84077,25397,48184,51044') |
0.0023691654205322 |
(12) |
DESCRIBE `ships` |
0.0039799213409424 |
(13) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('404', '770', '1721', '1008', '1569', '1742', '626', '314', '1088', '1193', '485', '405', '574', '665', '212', '448', '93')) ORDER BY FIND_IN_SET(id, '404,770,1721,1008,1569,1742,626,314,1088,1193,485,405,574,665,212,448,93') |
0.0027320384979248 |
(14) |
DESCRIBE `cruisetypes` |
0.0020158290863037 |
(15) |
DESCRIBE `destinations` |
0.0028560161590576 |
(16) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '22', '29', '2', '10', '9', '11', '35', '26', '34', '43', '53', '48', '37', '38', '21', '25', '45', '52', '30')) ORDER BY FIND_IN_SET(id, '12,22,29,2,10,9,11,35,26,34,43,53,48,37,38,21,25,45,52,30') |
0.0032620429992676 |
(17) |
DESCRIBE `cruiselines` |
0.0041918754577637 |
(18) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) |
0.00069093704223633 |
(19) |
DESCRIBE `cruiselines` |
0.0038838386535645 |
(20) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) |
0.00063109397888184 |