| 0.0003 | SELECT *
FROM `ophorus_rezdy` ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '43' ?>
|
| 0.0006 | SELECT *
FROM `ophorus_destinations`
WHERE `region_id` = '4' ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations`
WHERE `region_id` = '10' ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations`
WHERE `region_id` = '14' ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations`
WHERE `region_id` = '15' ?>
|
| 0.0005 | SELECT *
FROM `ophorus_destinations`
WHERE `region_id` = '13' ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations`
WHERE `region_id` = '17' ?>
|
| 0.0005 | SELECT *
FROM `ophorus_destinations`
WHERE `region_id` = '9' ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations`
WHERE `region_id` = '6' ?>
|
| 0.0061 | SELECT *
FROM `ophorus_products` `a`
JOIN `ophorus_products_liaison_categories` `b` ON `b`.`product_id` = `a`.`product_id`
JOIN `ophorus_products_liaison_destinations` `c` ON `c`.`product_id` = `a`.`product_id`
JOIN `ophorus_destinations` `d` ON `d`.`destination_id` = `c`.`destination_id`
WHERE `a`.`productType` != 'TRANSFER'
AND `a`.`product_activ` = 'Y'
AND `a`.`product_force_desactiv` = 'N'
AND `a`.`product_from` = 'PROD'
AND `b`.`categorie_id` IN('1', '9')
AND `c`.`destination_id` IN('4', '6', '7', '33', '49', '50', '62', '30', '31', '12', '18', '32', '37', '65', '102', '13', '20', '83', '89', '98', '99', '107', '34', '35', '94', '117', '16', '19', '24', '27', '39', '77', '95', '105', '112', '9', '11', '14', '36', '79', '80', '81', '84', '86', '87', '88', '97', '109', '111')
GROUP BY `a`.`product_id` ?>
|
| 0.0439 | SELECT DISTINCT product_id
FROM `ophorus_products_avaibilities`
WHERE `avaibility_date` >= '2026-03-13'
AND `avaibility_date` <= '2027-01-13'
AND `product_id` IN('136', '54', '131', '518', '517', '725', '727', '736', '751', '875', '920', '917', '1102', '1113', '1115', '144', '512', '1545', '1546', '1547', '881', '1421', '1444', '1445', '1446', '1538', '1539', '1447', '1448', '1449', '1542', '1543', '1544', '1431', '1432', '1433', '1450', '1531', '1532', '1548', '1549', '1536', '1537', '1541', '1540', '1441', '1442', '1443', '1580', '1164', '1361', '1535', '1168', '1169', '1170', '1423', '1424', '1425', '1581', '1582', '527', '1418', '1426', '870', '1419', '1171', '1172', '1176', '1173', '1174', '1175', '1420', '1422', '1438', '1439', '1440', '1427', '864', '1533', '1534', '1437', '1611') ?>
|
| 0.0006 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '136' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '54' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '131' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '518' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '517' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '725' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '727' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '736' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '751' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '875' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '920' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '917' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1102' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1113' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1115' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '144' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '512' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1545' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1546' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1547' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '881' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1421' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1444' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1445' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1446' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1538' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1539' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1447' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1448' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1449' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1542' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1543' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1544' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1431' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1432' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1433' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1450' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1531' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1532' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1548' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1549' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1536' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1537' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1541' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1540' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1441' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1442' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1443' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1580' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1164' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1361' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1535' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1168' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1169' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1170' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1423' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1424' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1425' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1581' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1582' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '527' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1418' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1426' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '870' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1419' ?>
|
| 0.0008 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1171' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1172' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1176' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1173' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1174' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1175' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1420' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1422' ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1438' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1439' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1440' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1427' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '864' ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1533' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1534' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1437' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1611' ?>
|
| 0.0100 | SELECT product_id, COUNT(*) AS nb
FROM `ophorus_bookings_items`
WHERE `product_id` IN('136', '54', '131', '517', '725', '736', '751', '875', '920', '917', '1113', '144', '1545', '881', '1421', '1444', '1447', '1542', '1431', '1450', '1441', '1361', '1168', '1423', '527', '1418', '1173', '1438', '1427', '1533', '1611')
GROUP BY `product_id` ?>
|
| 0.0014 | SELECT b.product_id, a.categorie_id
FROM `ophorus_products_categories` `a`
INNER JOIN `ophorus_products_liaison_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`categorie_activ` = 'Y'
AND `b`.`product_id` IN('136', '54', '131', '517', '725', '736', '751', '875', '920', '917', '1113', '144', '1545', '881', '1421', '1444', '1447', '1542', '1431', '1450', '1441', '1361', '1168', '1423', '527', '1418', '1173', '1438', '1427', '1533', '1611') ?>
|
| 0.0018 | SELECT a.product_id, a.tag_value
FROM `ophorus_products_tags` `a`
INNER JOIN `ophorus_tags` `b` ON `b`.`tag_id` = `a`.`tag_id`
WHERE `b`.`tag_label` = 'INTENSITY'
AND `a`.`product_id` IN('136', '54', '131', '517', '725', '736', '751', '875', '920', '917', '1113', '144', '1545', '881', '1421', '1444', '1447', '1542', '1431', '1450', '1441', '1361', '1168', '1423', '527', '1418', '1173', '1438', '1427', '1533', '1611') ?>
|
| 0.0004 | SELECT a.product_id, a.destination_id
FROM `ophorus_products_liaison_destinations` `a`
WHERE `a`.`product_id` IN('136', '54', '131', '517', '725', '736', '751', '875', '920', '917', '1113', '144', '1545', '881', '1421', '1444', '1447', '1542', '1431', '1450', '1441', '1361', '1168', '1423', '527', '1418', '1173', '1438', '1427', '1533', '1611') ?>
|
| 0.0024 | SELECT MAX(a.tag_value) AS tag_value, `a`.`tag_slug`
FROM `ophorus_products_tags` `a`
JOIN `ophorus_tags` `b` ON `b`.`tag_id` = `a`.`tag_id`
WHERE `a`.`tag_slug` != ''
AND `b`.`tag_label` = 'INTENSITY'
GROUP BY `a`.`tag_slug`
ORDER BY `a`.`tag_value` ASC ?>
|
| 0.0003 | SELECT *
FROM `ophorus_infos` ?>
|
| 0.0004 | SELECT *
FROM `ophorus_contents` ?>
|
| 0.0034 | SELECT c.categorie_id, c.categorie_icon, c.categorie_description, c.categorie_short_description, c.categorie_img, c.categorie_label, COUNT(DISTINCT p.product_id) AS nb_produits
FROM `ophorus_products_categories` `c`
LEFT JOIN `ophorus_products_liaison_categories` `lc` ON `lc`.`categorie_id` = `c`.`categorie_id`
LEFT JOIN ophorus_products p ON p.product_id = lc.product_id
AND p.product_activ = 'Y'
WHERE `c`.`categorie_activ` = 'Y'
GROUP BY `c`.`categorie_id`
HAVING COUNT(DISTINCT p.product_id) > 0
ORDER BY `c`.`categorie_order` DESC ?>
|
| 0.0056 | SELECT a.destination_id, a.destination_label, a.destination_background, a.destination_phare, a.destination_short_description, a.destination_description, a.destination_accueil, c.region_label, c.region_ss_label, c.region_id, COUNT(DISTINCT e.product_id) AS nb_produits, SUM(CASE
WHEN e.product_id IS NOT NULL
AND e.product_activ = 'Y'
AND e.product_shore_excursion = 'N'
AND e.productType <> 'TRANSFER'
AND e.product_from = 'PROD'
THEN 1 ELSE 0 END
) AS has_non_shore, SUM(CASE
WHEN e.product_id IS NOT NULL
AND e.product_activ = 'Y'
AND e.product_shore_excursion = 'Y'
THEN 1 ELSE 0 END
) AS has_shore
FROM `ophorus_destinations` `a`
INNER JOIN `location_cities` `b` ON `b`.`id` = `a`.`destination_ville`
INNER JOIN `ophorus_destinations_regions` `c` ON `c`.`region_id` = `a`.`region_id`
LEFT JOIN `ophorus_products_liaison_destinations` `d` ON `d`.`destination_id` = `a`.`destination_id`
LEFT JOIN ophorus_products e ON e.product_id = d.product_id
GROUP BY `a`.`destination_id`
HAVING COUNT(DISTINCT e.product_id) > 0
ORDER BY `c`.`region_order` DESC, `a`.`destination_label` ASC ?>
|
| 0.0102 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `location_cities` `b` ON `b`.`id` = `a`.`destination_ville`
JOIN `ophorus_products_liaison_destinations` `d` ON `d`.`destination_id` = `a`.`destination_id`
JOIN `ophorus_products` `e` ON `e`.`product_id` = `d`.`product_id`
JOIN `ophorus_destinations_regions` `c` ON `c`.`region_id` = `a`.`region_id`
GROUP BY `a`.`destination_id`
ORDER BY `c`.`region_order` DESC, `a`.`destination_label` ASC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations_shore`
ORDER BY `shore_order` DESC ?>
|
| 0.0003 | SELECT *
FROM `ophorus_footer_links`
ORDER BY `link_order` DESC ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '41' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '36' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '5' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '43' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '30' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '7' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '13' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '29' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '31' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '38' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '8' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '25' ?>
|
| 0.0004 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '26' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '4' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_rezdy` ?>
|
| 0.0002 | SELECT *
FROM `ophorus_modal`
WHERE `modal_activ` = 'Y' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_brochures`
ORDER BY `brochure_order` DESC ?>
|
| 0.0003 | SELECT *
FROM `ophorus_footer_bg`
ORDER BY RAND() ?>
|
| 0.0020 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '144'
AND `comment_statut` = 'VALID' ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '131'
AND `comment_statut` = 'VALID' ?>
|
| 0.0021 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '54'
AND `comment_statut` = 'VALID' ?>
|
| 0.0016 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '725'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '751'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '917'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '136'
AND `comment_statut` = 'VALID' ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '517'
AND `comment_statut` = 'VALID' ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '736'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '875'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '920'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1113'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1545'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '881'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1421'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1444'
AND `comment_statut` = 'VALID' ?>
|
| 0.0015 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1447'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1542'
AND `comment_statut` = 'VALID' ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1431'
AND `comment_statut` = 'VALID' ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1450'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1441'
AND `comment_statut` = 'VALID' ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1361'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1168'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1423'
AND `comment_statut` = 'VALID' ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '527'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1418'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1173'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1438'
AND `comment_statut` = 'VALID' ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1427'
AND `comment_statut` = 'VALID' ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1533'
AND `comment_statut` = 'VALID' ?>
|
| 0.0015 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1611'
AND `comment_statut` = 'VALID' ?>
|
| 0.0033 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '144'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0026 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '131'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0027 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '54'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0026 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '725'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0016 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '751'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '917'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '136'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0015 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '517'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '736'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '875'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '920'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1113'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1545'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0015 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '881'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1421'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1444'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0016 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1447'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1542'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1431'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1450'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0015 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1441'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0020 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1361'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1168'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1423'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '527'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0016 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1418'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0029 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1173'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0026 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1438'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0028 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1427'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0029 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1533'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0042 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1611'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0007 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 144
ORDER BY `media_order` DESC ?>
|
| 0.0007 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 144
LIMIT 2 ?>
|
| 0.0032 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 144 ?>
|
| 0.0006 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 144 ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 131
ORDER BY `media_order` DESC ?>
|
| 0.0008 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 131
LIMIT 2 ?>
|
| 0.0041 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 131 ?>
|
| 0.0011 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 131 ?>
|
| 0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 54
ORDER BY `media_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 54
LIMIT 2 ?>
|
| 0.0015 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 54 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 54 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 725
ORDER BY `media_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 725
LIMIT 2 ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 725 ?>
|
| 0.0006 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 725 ?>
|
| 0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 751
ORDER BY `media_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 751
LIMIT 2 ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 751 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 751 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 917
ORDER BY `media_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 917
LIMIT 2 ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 917 ?>
|
| 0.0009 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 917 ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 136
ORDER BY `media_order` DESC ?>
|
| 0.0005 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 136
LIMIT 2 ?>
|
| 0.0016 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 136 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 136 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 517
ORDER BY `media_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 517
LIMIT 2 ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 517 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 517 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 736
ORDER BY `media_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 736
LIMIT 2 ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 736 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 736 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 875
ORDER BY `media_order` DESC ?>
|
| 0.0003 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 875
LIMIT 2 ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 875 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 875 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 920
ORDER BY `media_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 920
LIMIT 2 ?>
|
| 0.0022 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 920 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 920 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1113
ORDER BY `media_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 1113
LIMIT 2 ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1113 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 1113 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1545
ORDER BY `media_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 1545
LIMIT 2 ?>
|
| 0.0029 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1545 ?>
|
| 0.0007 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 1545 ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 881
ORDER BY `media_order` DESC ?>
|
| 0.0006 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 881
LIMIT 2 ?>
|
| 0.0026 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 881 ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 881 ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1421
ORDER BY `media_order` DESC ?>
|
| 0.0006 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 1421
LIMIT 2 ?>
|
| 0.0025 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1421 ?>
|
| 0.0006 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 1421 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1444
ORDER BY `media_order` DESC ?>
|
| 0.0006 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 1444
LIMIT 2 ?>
|
| 0.0024 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1444 ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 1444 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1447
ORDER BY `media_order` DESC ?>
|
| 0.0006 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 1447
LIMIT 2 ?>
|
| 0.0024 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1447 ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 1447 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1542
ORDER BY `media_order` DESC ?>
|
| 0.0007 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 1542
LIMIT 2 ?>
|
| 0.0025 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1542 ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 1542 ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1431
ORDER BY `media_order` DESC ?>
|
| 0.0006 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 1431
LIMIT 2 ?>
|
| 0.0063 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1431 ?>
|
| 0.0008 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 1431 ?>
|
| 0.0010 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1450
ORDER BY `media_order` DESC ?>
|
| 0.0018 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 1450
LIMIT 2 ?>
|
| 0.0018 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1450 ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 1450 ?>
|
| 0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1441
ORDER BY `media_order` DESC ?>
|
| 0.0011 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 1441
LIMIT 2 ?>
|
| 0.0024 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1441 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 1441 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1361
ORDER BY `media_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 1361
LIMIT 2 ?>
|
| 0.0017 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1361 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 1361 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1168
ORDER BY `media_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = 1168
LIMIT 2 ?>
|
| 0.0013 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1168 ?>
|
| 0.0004 | SELECT *
FROM `ophorus_products_liaison_categories` `a`
JOIN `ophorus_products_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `a`.`product_id` = 1168 ?>
|
Please wait
Your order is being processed, please wait
