| 0.0004 | SELECT *
FROM `ophorus_rezdy` ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products`
WHERE `product_activ` = 'Y'
AND `product_force_desactiv` = 'N'
AND `product_id` = '1612' ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products`
WHERE `product_id` = '1612' ?>
|
| 0.0008 | SELECT *
FROM `ophorus_vouchers`
WHERE `categorie_market_id` != ''
AND `voucher_status` = 'ISSUED'
AND `voucher_issueDate` < '2026-03-13 17:17:22'
AND `voucher_expiryDate` >= '2026-03-13 17:17:22'
AND `voucher_from` = 'PROD' ?>
|
| 0.0008 | SELECT *
FROM `ophorus_products_liaison_categories_market`
WHERE `categorie_id` = '540300'
AND `product_id` = '1612' ?>
|
| 0.0008 | SELECT *
FROM `ophorus_products_liaison_categories_market`
WHERE `categorie_id` = '377268'
AND `product_id` = '1612' ?>
|
| 0.0021 | SELECT *
FROM `ophorus_products_options`
WHERE `product_id` = '1612'
ORDER BY `option_minQuantity` ASC ?>
|
| 0.0006 | SELECT *
FROM `ophorus_products_extras` `a`
JOIN `ophorus_extras` `b` ON `b`.`extra_id` = `a`.`extra_id`
WHERE `a`.`product_id` = '1612' ?>
|
| 0.0007 | SELECT *
FROM `ophorus_products_categories` `a`
JOIN `ophorus_products_liaison_categories` `b` ON `b`.`categorie_id` = `a`.`categorie_id`
WHERE `b`.`product_id` = '1612' ?>
|
| 0.0006 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = '1612' ?>
|
| 0.0031 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1612'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC ?>
|
| 0.0033 | SELECT *
FROM `ophorus_products_comments` `a`
WHERE `a`.`product_id` = '1612'
AND `comment_statut` = 'VALID'
ORDER BY `a`.`comment_date` DESC
LIMIT 4 ?>
|
| 0.0007 | SELECT *
FROM `ophorus_products_langs` `a`
JOIN `ophorus_langs` `b` ON `b`.`lang_code` = `a`.`lang_code`
WHERE `a`.`product_id` = '1612'
ORDER BY `b`.`lang_label` ASC ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_taxes`
WHERE `product_id` = '1612' ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_faq`
WHERE `product_id` = '1612'
ORDER BY `faq_order` DESC ?>
|
| 0.0015 | SELECT *
FROM `ophorus_products_others` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_other_id`
WHERE `a`.`product_id` = '1612'
LIMIT 3 ?>
|
| 0.0010 | SELECT *
FROM `ophorus_products` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `a`.`product_activ` = 'Y'
AND `a`.`product_from` = 'PROD'
AND `a`.`productType` = 'PRIVATE_TOUR'
AND `a`.`product_id` != '1612'
AND `b`.`destination_id` = '9'
ORDER BY RAND()
LIMIT 3 ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '1612'
ORDER BY `media_order` DESC ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_videos`
WHERE `product_id` = '1612' ?>
|
| 0.0045 | SELECT *
FROM `ophorus_products_tags` `a`
JOIN `ophorus_tags` `b` ON `b`.`tag_id` = `a`.`tag_id`
WHERE `a`.`product_id` = '1612' ?>
|
| 0.0020 | SELECT *
FROM `ophorus_products_highlights`
WHERE `product_id` = '1612'
ORDER BY `highlight_order` DESC ?>
|
| 0.0055 | SELECT *
FROM `ophorus_products_plan`
WHERE `product_id` = '1612'
ORDER BY `plan_day` ASC, `plan_heure_deb` ASC ?>
|
| 0.0009 | SELECT *
FROM `ophorus_products_inc`
WHERE `product_id` = '1612' ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_meeting`
WHERE `product_id` = '1612' ?>
|
| 0.0010 | SELECT *
FROM `ophorus_products_location`
WHERE `product_id` = '1612' ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_accomodations`
WHERE `product_id` = '1612' ?>
|
| 0.0006 | SELECT *
FROM `ophorus_products_accomodations_medias`
WHERE `product_id` = '1612'
ORDER BY `media_order` DESC ?>
|
| 0.0005 | SELECT *
FROM `ophorus_products_offres` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_id_2`
WHERE `a`.`product_id_1` = '1612'
AND `a`.`offre_activ` = 'Y'
AND `b`.`product_activ` = 'Y' ?>
|
| 0.0058 | 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.0011 | SELECT *
FROM `ophorus_contents` ?>
|
| 0.0058 | 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.0057 | 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.0100 | 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.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '36' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '5' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '43' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '30' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '7' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '13' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '29' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '31' ?>
|
| 0.0002 | 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.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '26' ?>
|
| 0.0002 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '4' ?>
|
| 0.0002 | 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.0003 | SELECT *
FROM `location_cities`
WHERE `id` = '33164' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 784
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` = 784
LIMIT 2 ?>
|
| 0.0015 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 784 ?>
|
| 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` = 784 ?>
|
| 0.0003 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = 1613
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` = 1613
LIMIT 2 ?>
|
| 0.0015 | SELECT *
FROM `ophorus_products_comments`
WHERE `product_id` = 1613 ?>
|
| 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` = 1613 ?>
|
Please wait
Your order is being processed, please wait
