| 0.0021 | SELECT *
FROM `ophorus_rezdy` ?>
|
| 0.0012 | SELECT *
FROM `ophorus_products` `a`
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 `c`.`destination_id` IN('14')
GROUP BY `a`.`product_id` ?>
|
| 0.0006 | SELECT *
FROM `ophorus_destinations`
WHERE `destination_id` = '14' ?>
|
| 0.0014 | SELECT *
FROM `ophorus_products_comments` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`product_id` = `a`.`product_id`
JOIN `ophorus_products` `c` ON `c`.`product_id` = `a`.`product_id`
WHERE `b`.`destination_id` = '14'
AND `c`.`product_activ` = 'Y'
AND `c`.`product_force_desactiv` = 'N'
AND `c`.`product_from` = 'PROD'
ORDER BY `a`.`comment_date` DESC
LIMIT 4 ?>
|
| 0.0007 | SELECT *
FROM `ophorus_destinations_faq` `a`
WHERE `a`.`destination_id` = '14' ?>
|
| 0.0095 | 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.0035 | SELECT *
FROM `ophorus_infos` ?>
|
| 0.0015 | SELECT *
FROM `ophorus_contents` ?>
|
| 0.0074 | 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.0086 | 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.0111 | 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.0007 | SELECT *
FROM `ophorus_destinations_shore`
ORDER BY `shore_order` DESC ?>
|
| 0.0005 | 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.0003 | 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.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '13' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '29' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '31' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '38' ?>
|
| 0.0003 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '8' ?>
|
| 0.0003 | 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.0005 | SELECT *
FROM `ophorus_modal`
WHERE `modal_activ` = 'Y' ?>
|
| 0.0004 | SELECT *
FROM `ophorus_brochures`
ORDER BY `brochure_order` DESC ?>
|
| 0.0004 | SELECT *
FROM `ophorus_footer_bg`
ORDER BY RAND() ?>
|
| 0.0003 | SELECT *
FROM `ophorus_destinations_regions`
WHERE `region_id` IS NULL ?>
|
Please wait
