| (1) |
connect |
0.0017671585083008 |
| (2) |
DESCRIBE `cruiselines` |
0.0044090747833252 |
| (3) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'crystal-cruises') AND (orchid_available = 1) LIMIT 1 |
0.0013220310211182 |
| (4) |
DESCRIBE `avid_specials` |
0.0031318664550781 |
| (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.002518892288208 |
| (6) |
DESCRIBE `orchid_image` |
0.0032889842987061 |
| (7) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '14') |
0.0012819766998291 |
| (8) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.0008089542388916 |
| (9) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.00054001808166504 |
| (10) |
DESCRIBE `cruises` |
0.0057108402252197 |
| (11) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (67994, 60498, 81802, 67995, 60368, 81803, 68056, 81804, 68057, 81800)) ORDER BY FIND_IN_SET(id, '67994,60498,81802,67995,60368,81803,68056,81804,68057,81800') |
0.0025038719177246 |
| (12) |
DESCRIBE `ships` |
0.0061969757080078 |
| (13) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('332', '66', '1372', '1749')) ORDER BY FIND_IN_SET(id, '332,66,1372,1749') |
0.0017001628875732 |
| (14) |
DESCRIBE `cruisetypes` |
0.0027179718017578 |
| (15) |
SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes`
LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '14') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC |
0.044252157211304 |
| (16) |
DESCRIBE `destinations` |
0.0037338733673096 |
| (17) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '35', '30', '45', '40', '12', '11', '43', '2', '25', '28', '48', '7', '21', '8', '26', '38', '37', '29', '34', '49', '52')) ORDER BY FIND_IN_SET(id, '22,35,30,45,40,12,11,43,2,25,28,48,7,21,8,26,38,37,29,34,49,52') |
0.0032010078430176 |
| (18) |
DESCRIBE `cruiselines` |
0.0039041042327881 |
| (19) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 14))) |
0.00094795227050781 |
| (20) |
DESCRIBE `cruiselines` |
0.0043351650238037 |
| (21) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 14))) |
0.00085902214050293 |
