(1) |
connect |
0.00099492073059082 |
(2) |
DESCRIBE `ports` |
0.0025899410247803 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'san-francisco-california-usa') AND (orchid_available = 1) LIMIT 1 |
0.0024540424346924 |
(4) |
DESCRIBE `destinations` |
0.0028610229492188 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 34))) |
0.0006101131439209 |
(6) |
DESCRIBE `avid_specials` |
0.0021519660949707 |
(7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '34' 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.0013439655303955 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') |
0.00049495697021484 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '142') |
0.003652811050415 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '142') |
0.0025489330291748 |
(11) |
DESCRIBE `cruises` |
0.0039489269256592 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (76929, 63072, 28282, 75774, 75775, 75776, 75777, 74531, 78017, 50803)) ORDER BY FIND_IN_SET(id, '76929,63072,28282,75774,75775,75776,75777,74531,78017,50803') |
0.0021200180053711 |
(13) |
DESCRIBE `cruiselines` |
0.0037381649017334 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '91', '218', '15', '50', '24', '18', '20', '28', '14', '19', '8', '29', '159', '16', '26', '33')) ORDER BY FIND_IN_SET(id, '23,91,218,15,50,24,18,20,28,14,19,8,29,159,16,26,33') |
0.0026140213012695 |
(15) |
DESCRIBE `ships` |
0.0045490264892578 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('441', '290', '678', '1108', '98', '483', '394', '585', '111', '1021', '105', '790', '580', '780', '1854', '332', '674', '82', '657', '1569', '75', '147', '626', '692', '776', '1302', '1742', '66', '70', '340', '389', '1282', '1721')) ORDER BY FIND_IN_SET(id, '441,290,678,1108,98,483,394,585,111,1021,105,790,580,780,1854,332,674,82,657,1569,75,147,626,692,776,1302,1742,66,70,340,389,1282,1721') |
0.0061440467834473 |
(17) |
DESCRIBE `cruisetypes` |
0.00199294090271 |
(18) |
DESCRIBE `destinations` |
0.0025169849395752 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('40', '34', '2', '53', '29', '48', '43', '35', '32')) ORDER BY FIND_IN_SET(id, '40,34,2,53,29,48,43,35,32') |
0.0016608238220215 |
(20) |
DESCRIBE `ports` |
0.0023348331451416 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) |
0.00054097175598145 |