(1) |
connect |
0.0014069080352783 |
(2) |
DESCRIBE `cruiselines` |
0.00341796875 |
(3) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'crystal-cruises') AND (orchid_available = 1) LIMIT 1 |
0.00085711479187012 |
(4) |
DESCRIBE `avid_specials` |
0.0019350051879883 |
(5) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '14' 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.0031819343566895 |
(6) |
DESCRIBE `orchid_image` |
0.0024487972259521 |
(7) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '14') |
0.00059199333190918 |
(8) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.00031709671020508 |
(9) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.0003199577331543 |
(10) |
DESCRIBE `cruises` |
0.0036489963531494 |
(11) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (66300, 78139, 67580, 62072, 67581, 38412, 67582, 80808, 80809, 78158)) ORDER BY FIND_IN_SET(id, '66300,78139,67580,62072,67581,38412,67582,80808,80809,78158') |
0.0018870830535889 |
(12) |
DESCRIBE `ships` |
0.0039558410644531 |
(13) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('1372', '66', '332', '1749')) ORDER BY FIND_IN_SET(id, '1372,66,332,1749') |
0.0012040138244629 |
(14) |
DESCRIBE `cruisetypes` |
0.001662015914917 |
(15) |
DESCRIBE `destinations` |
0.0026030540466309 |
(16) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '35', '12', '30', '45', '11', '40', '2', '43', '25', '28', '21', '26', '48', '8', '34', '7', '29', '38', '37', '52')) ORDER BY FIND_IN_SET(id, '22,35,12,30,45,11,40,2,43,25,28,21,26,48,8,34,7,29,38,37,52') |
0.00211501121521 |
(17) |
DESCRIBE `cruiselines` |
0.0029029846191406 |
(18) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 14))) |
0.00052881240844727 |
(19) |
DESCRIBE `cruiselines` |
0.0030310153961182 |
(20) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 14))) |
0.00055098533630371 |