| (1) |
connect |
0.0010561943054199 |
| (2) |
DESCRIBE `specials` |
0.0077869892120361 |
| (3) |
SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'southbound-alaskan-escape-free-air-credit') AND (orchid_available = 1) LIMIT 1 |
0.0016870498657227 |
| (4) |
DESCRIBE `cruises` |
0.0051078796386719 |
| (5) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79367))) |
0.00082111358642578 |
| (6) |
DESCRIBE `avid_specials` |
0.002500057220459 |
| (7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1641090 and class = 'Special') OR (item_id = 79367 and class = 'Cruise') OR (item_id = 1398 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 2 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.0020220279693604 |
| (8) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1641090') |
0.0005180835723877 |
| (9) |
DESCRIBE `ships` |
0.0046799182891846 |
| (10) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1398))) |
0.00075697898864746 |
| (11) |
DESCRIBE `ships` |
0.0053520202636719 |
| (12) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1398') |
0.00067496299743652 |
| (13) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.00043201446533203 |
| (14) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.00040698051452637 |
| (15) |
DESCRIBE `itineraries` |
0.0027039051055908 |
| (16) |
DESCRIBE `ports` |
0.0028669834136963 |
| (17) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) |
0.00047898292541504 |
| (18) |
DESCRIBE `ports` |
0.0019187927246094 |
| (19) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) |
0.00049805641174316 |
| (20) |
DESCRIBE `ports` |
0.0018470287322998 |
| (21) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') |
0.00063014030456543 |
| (22) |
DESCRIBE `specialsailingdates` |
0.0021400451660156 |
| (23) |
DESCRIBE `sailingdates` |
0.0025720596313477 |
| (24) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 492795))) |
0.00060105323791504 |
| (25) |
DESCRIBE `ports` |
0.0027360916137695 |
| (26) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) |
0.00063991546630859 |
| (27) |
DESCRIBE `ports` |
0.0028500556945801 |
| (28) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') |
0.00041079521179199 |
| (29) |
DESCRIBE `ports` |
0.0023128986358643 |
| (30) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) |
0.00050997734069824 |
| (31) |
DESCRIBE `ports` |
0.0019960403442383 |
| (32) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') |
0.00040698051452637 |
| (33) |
DESCRIBE `ports` |
0.0020549297332764 |
| (34) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) |
0.00042390823364258 |
| (35) |
DESCRIBE `ports` |
0.0019519329071045 |
| (36) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') |
0.00037503242492676 |
| (37) |
DESCRIBE `ports` |
0.0023031234741211 |
| (38) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) |
0.00069308280944824 |
| (39) |
DESCRIBE `ports` |
0.0030930042266846 |
| (40) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') |
0.00062799453735352 |
| (41) |
DESCRIBE `ports` |
0.002830982208252 |
| (42) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) |
0.0005180835723877 |
| (43) |
DESCRIBE `ports` |
0.0028271675109863 |
| (44) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') |
0.00068497657775879 |
| (45) |
DESCRIBE `ports` |
0.0026829242706299 |
| (46) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) |
0.00063991546630859 |
| (47) |
DESCRIBE `ports` |
0.0027110576629639 |
| (48) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') |
0.0005791187286377 |
| (49) |
DESCRIBE `ports` |
0.0026531219482422 |
| (50) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) |
0.00060915946960449 |
| (51) |
DESCRIBE `ports` |
0.0022060871124268 |
| (52) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') |
0.00043702125549316 |
| (53) |
DESCRIBE `ports` |
0.0022869110107422 |
| (54) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) |
0.00057196617126465 |
| (55) |
DESCRIBE `ports` |
0.0021779537200928 |
| (56) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') |
0.00043702125549316 |
| (57) |
DESCRIBE `specialsmultipricing` |
0.0018310546875 |
| (58) |
DESCRIBE `leadpricing` |
0.0018558502197266 |
| (59) |
DESCRIBE `specialspricing` |
0.002295970916748 |
| (60) |
DESCRIBE `cabins` |
0.0019528865814209 |
| (61) |
SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 12089))) |
0.00049090385437012 |
| (62) |
DESCRIBE `currencies` |
0.0018889904022217 |
| (63) |
SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) |
0.00040197372436523 |
| (64) |
DESCRIBE `cruiselines` |
0.0026469230651855 |
| (65) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) |
0.00048303604125977 |
| (66) |
DESCRIBE `orchid_image` |
0.0020759105682373 |
| (67) |
DESCRIBE `cruises` |
0.0039019584655762 |
| (68) |
SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79367') |
0.00047707557678223 |
| (69) |
DESCRIBE `deckplans` |
0.0018229484558105 |
| (70) |
DESCRIBE `cabins` |
0.0018701553344727 |
| (71) |
DESCRIBE `shipphotos` |
0.0020639896392822 |
| (72) |
DESCRIBE `cruiselines` |
0.0026960372924805 |
| (73) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) |
0.00064301490783691 |
| (74) |
DESCRIBE `orchid_image` |
0.0020561218261719 |
| (75) |
DESCRIBE `cruises` |
0.003809928894043 |
| (76) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 4425, 6056, 45258, 76235, 4424, 81017, 78347, 37234, 80905)) ORDER BY FIND_IN_SET(id, '45259,4425,6056,45258,76235,4424,81017,78347,37234,80905') |
0.0016169548034668 |
| (77) |
DESCRIBE `cruiselines` |
0.0040020942687988 |
| (78) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '216', '47', '20', '191', '33', '8', '14', '26', '151', '19', '91', '101', '114', '15', '24', '29', '37', '96', '18')) ORDER BY FIND_IN_SET(id, '23,216,47,20,191,33,8,14,26,151,19,91,101,114,15,24,29,37,96,18') |
0.0022268295288086 |
| (79) |
DESCRIBE `ships` |
0.0038750171661377 |
| (80) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('855', '517', '1808', '66', '1282', '338', '780', '148', '652', '683', '776', '1021', '1746', '1766', '124', '290', '332', '404', '448', '542', '616', '966', '1088', '1159', '1193', '1321', '1409', '1672', '75', '160', '163', '286', '287', '291', '349', '406', '434', '573', '580', '585', '766', '1028', '1318', '1319', '1330', '1359', '1402', '1539', '1569', '1771', '45', '98', '105', '149', '253', '262', '285', '341', '389', '394', '422', '508', '547', '553', '559', '665', '674', '678', '726', '738', '748', '768', '770', '907', '968', '1029', '1073', '1108', '1135', '1157', '1262', '1283', '1415', '1587', '1682', '1721', '1758')) ORDER BY FIND_IN_SET(id, '855,517,1808,66,1282,338,780,148,652,683,776,1021,1746,1766,124,290,332,404,448,542,616,966,1088,1159,1193,1321,1409,1672,75,160,163,286,287,291,349,406,434,573,580,585,766,1028,1318,1319,1330,1359,1402,1539,1569,1771,45,98,105,149,253,262,285,341,389,394,422,508,547,553,559,665,674,678,726,738,748,768,770,907,968,1029,1073,1108,1135,1157,1262,1283,1415,1587,1682,1721,1758') |
0.011775016784668 |
| (81) |
DESCRIBE `cruisetypes` |
0.0018100738525391 |
| (82) |
DESCRIBE `destinations` |
0.0024030208587646 |
| (83) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '35', '2', '54', '50', '26', '8', '12', '25', '48', '49', '29', '53', '40', '11', '28', '37')) ORDER BY FIND_IN_SET(id, '43,22,35,2,54,50,26,8,12,25,48,49,29,53,40,11,28,37') |
0.0021071434020996 |