| (1) |
connect |
0.0010519027709961 |
| (2) |
DESCRIBE `specials` |
0.0065419673919678 |
| (3) |
SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '7-night-yachtman-s-harbors-of-the-rivieras-yacht-cruise-from-barcelona-to-rome') AND (orchid_available = 1) LIMIT 1 |
0.0020849704742432 |
| (4) |
DESCRIBE `cruises` |
0.005051851272583 |
| (5) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 87461))) |
0.00080204010009766 |
| (6) |
DESCRIBE `avid_specials` |
0.0025229454040527 |
| (7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1643844 and class = 'Special') OR (item_id = 87461 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 22 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.0016849040985107 |
| (8) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1643844') |
0.00046300888061523 |
| (9) |
DESCRIBE `ships` |
0.0049839019775391 |
| (10) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) |
0.0005638599395752 |
| (11) |
DESCRIBE `ships` |
0.0038731098175049 |
| (12) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') |
0.00069403648376465 |
| (13) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00041317939758301 |
| (14) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00034618377685547 |
| (15) |
DESCRIBE `itineraries` |
0.001957893371582 |
| (16) |
DESCRIBE `ports` |
0.0024340152740479 |
| (17) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) |
0.00048995018005371 |
| (18) |
DESCRIBE `ports` |
0.0019829273223877 |
| (19) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) |
0.0004570484161377 |
| (20) |
DESCRIBE `ports` |
0.0019371509552002 |
| (21) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') |
0.00040888786315918 |
| (22) |
DESCRIBE `specialsailingdates` |
0.0018110275268555 |
| (23) |
DESCRIBE `sailingdates` |
0.0018129348754883 |
| (24) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 547367))) |
0.00049281120300293 |
| (25) |
DESCRIBE `ports` |
0.0018119812011719 |
| (26) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) |
0.00047588348388672 |
| (27) |
DESCRIBE `ports` |
0.0020418167114258 |
| (28) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') |
0.00040698051452637 |
| (29) |
DESCRIBE `ports` |
0.0018410682678223 |
| (30) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 909))) |
0.00053000450134277 |
| (31) |
DESCRIBE `ports` |
0.0018000602722168 |
| (32) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '909') |
0.00043511390686035 |
| (33) |
DESCRIBE `ports` |
0.0018858909606934 |
| (34) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 910))) |
0.0003819465637207 |
| (35) |
DESCRIBE `ports` |
0.0017819404602051 |
| (36) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '910') |
0.00050806999206543 |
| (37) |
DESCRIBE `ports` |
0.0018801689147949 |
| (38) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) |
0.0004420280456543 |
| (39) |
DESCRIBE `ports` |
0.0022120475769043 |
| (40) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') |
0.00055193901062012 |
| (41) |
DESCRIBE `ports` |
0.0021600723266602 |
| (42) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3014))) |
0.00044703483581543 |
| (43) |
DESCRIBE `ports` |
0.0019900798797607 |
| (44) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3014') |
0.00039219856262207 |
| (45) |
DESCRIBE `ports` |
0.0017590522766113 |
| (46) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) |
0.00051498413085938 |
| (47) |
DESCRIBE `ports` |
0.0018861293792725 |
| (48) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') |
0.00040197372436523 |
| (49) |
DESCRIBE `ports` |
0.0018661022186279 |
| (50) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) |
0.00043010711669922 |
| (51) |
DESCRIBE `ports` |
0.0018961429595947 |
| (52) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') |
0.00042390823364258 |
| (53) |
DESCRIBE `ports` |
0.0018310546875 |
| (54) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) |
0.00046992301940918 |
| (55) |
DESCRIBE `ports` |
0.0019421577453613 |
| (56) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') |
0.0005180835723877 |
| (57) |
DESCRIBE `specialsmultipricing` |
0.0020229816436768 |
| (58) |
DESCRIBE `leadpricing` |
0.0018260478973389 |
| (59) |
DESCRIBE `specialspricing` |
0.0018320083618164 |
| (60) |
DESCRIBE `cabins` |
0.0019381046295166 |
| (61) |
SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 7414))) |
0.00046610832214355 |
| (62) |
DESCRIBE `currencies` |
0.0016028881072998 |
| (63) |
SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) |
0.00040721893310547 |
| (64) |
DESCRIBE `cruiselines` |
0.0029628276824951 |
| (65) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) |
0.00054597854614258 |
| (66) |
DESCRIBE `orchid_image` |
0.0021181106567383 |
| (67) |
DESCRIBE `cruiselines` |
0.0028021335601807 |
| (68) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') |
0.00043702125549316 |
| (69) |
DESCRIBE `cruises` |
0.0035698413848877 |
| (70) |
SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '87461') |
0.00046682357788086 |
| (71) |
DESCRIBE `deckplans` |
0.0019161701202393 |
| (72) |
DESCRIBE `cabins` |
0.0018818378448486 |
| (73) |
DESCRIBE `shipphotos` |
0.0019421577453613 |
| (74) |
DESCRIBE `cruiselines` |
0.002525806427002 |
| (75) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) |
0.00046920776367188 |
| (76) |
DESCRIBE `orchid_image` |
0.002173900604248 |
| (77) |
DESCRIBE `cruiselines` |
0.0026490688323975 |
| (78) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') |
0.00044798851013184 |
| (79) |
DESCRIBE `cruises` |
0.0037379264831543 |
| (80) |
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.0016429424285889 |
| (81) |
DESCRIBE `cruiselines` |
0.0028479099273682 |
| (82) |
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.0019059181213379 |
| (83) |
DESCRIBE `ships` |
0.0037240982055664 |
| (84) |
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.013745069503784 |
| (85) |
DESCRIBE `cruisetypes` |
0.0024809837341309 |
| (86) |
DESCRIBE `destinations` |
0.0036318302154541 |
| (87) |
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.0020480155944824 |