0.0010 | SELECT *
FROM `ophorus_rezdy` ?>
|
0.0028 | SELECT *
FROM `ophorus_headers`
WHERE `header_id` = 1 ?>
|
0.0021 | SELECT *
FROM `ophorus_accueil_slideshow`
ORDER BY `slide_order` DESC ?>
|
0.0014 | SELECT *
FROM `ophorus_accueil_trendings`
WHERE `trending_activ` = 'Y' ?>
|
0.0032 | SELECT *
FROM `ophorus_accueil_trendings_liaisons` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `a`.`trending_id` = '14'
AND `b`.`product_from` = 'PROD'
AND `b`.`product_activ` = 'Y' ?>
|
0.0043 | SELECT *
FROM `ophorus_products` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `a`.`product_lastminute` = 'Y' ?>
|
0.0028 | SELECT *
FROM `ophorus_products` `a`
WHERE `a`.`product_from` = 'STAGE' ?>
|
0.0021 | SELECT *
FROM `ophorus_articles` `a`
WHERE `a`.`article_activ` = 'Y'
ORDER BY `a`.`article_date` DESC
LIMIT 3 ?>
|
0.0012 | SELECT *
FROM `ophorus_destinations`
WHERE `destination_accueil` = 'Y' ?>
|
0.0014 | SELECT *
FROM `ophorus_accueil_difference`
ORDER BY `difference_order` DESC ?>
|
0.0012 | SELECT *
FROM `ophorus_accueil_team` ?>
|
0.0014 | SELECT *
FROM `ophorus_team`
ORDER BY `team_order` DESC ?>
|
0.0017 | SELECT *
FROM `ophorus_products_categories`
ORDER BY RAND()
LIMIT 5 ?>
|
0.0012 | SELECT *
FROM `ophorus_partenaires`
ORDER BY `partenaire_order` DESC ?>
|
0.0017 | SELECT *
FROM `ophorus_accueil_popular` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `b`.`productType` != 'TRANSFER'
AND `b`.`product_from` = 'PROD'
AND `b`.`product_activ` = 'Y'
ORDER BY `a`.`product_nb_booking` DESC
LIMIT 6 ?>
|
0.0013 | SELECT *
FROM `ophorus_accueil_mobile` ?>
|
0.0080 | 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.0013 | SELECT *
FROM `ophorus_infos` ?>
|
0.0017 | SELECT *
FROM `ophorus_contents` ?>
|
0.0010 | SELECT *
FROM `ophorus_products_categories`
WHERE `categorie_activ` = 'Y'
ORDER BY `categorie_order` DESC ?>
|
0.0236 | 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`
WHERE `e`.`productType` != 'TRANSFER'
GROUP BY `a`.`destination_id`
ORDER BY `c`.`region_order` DESC, `a`.`destination_label` ASC ?>
|
0.0303 | 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.0019 | SELECT *
FROM `ophorus_destinations_shore`
ORDER BY `shore_order` DESC ?>
|
0.0012 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '40' ?>
|
0.0008 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '40' ?>
|
0.0023 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '5' ?>
|
0.0015 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '5' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '21' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '21' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '22' ?>
|
0.0008 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '22' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '23' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '23' ?>
|
0.0008 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '44' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '44' ?>
|
0.0008 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '17' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '17' ?>
|
0.0011 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '6' ?>
|
0.0008 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '6' ?>
|
0.0008 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '33' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '33' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '49' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '49' ?>
|
0.0014 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '7' ?>
|
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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '7' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '92' ?>
|
0.0006 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '92' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '93' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '93' ?>
|
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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '30' ?>
|
0.0009 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '30' ?>
|
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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '31' ?>
|
0.0008 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '31' ?>
|
0.0013 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '18' ?>
|
0.0011 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '18' ?>
|
0.0013 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '12' ?>
|
0.0011 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '12' ?>
|
0.0019 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '32' ?>
|
0.0020 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '32' ?>
|
0.0025 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '102' ?>
|
0.0012 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '102' ?>
|
0.0021 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '99' ?>
|
0.0011 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '99' ?>
|
0.0009 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '20' ?>
|
0.0009 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '20' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '107' ?>
|
0.0013 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '107' ?>
|
0.0015 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '13' ?>
|
0.0012 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '13' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '98' ?>
|
0.0009 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '98' ?>
|
0.0009 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '115' ?>
|
0.0008 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '115' ?>
|
0.0009 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '101' ?>
|
0.0006 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '101' ?>
|
0.0018 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '4' ?>
|
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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '4' ?>
|
0.0008 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '25' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '25' ?>
|
0.0008 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '48' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '48' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '26' ?>
|
0.0008 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '26' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '96' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '96' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '91' ?>
|
0.0008 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '91' ?>
|
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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '10' ?>
|
0.0009 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '10' ?>
|
0.0008 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '35' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '35' ?>
|
0.0013 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '34' ?>
|
0.0009 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '34' ?>
|
0.0014 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '16' ?>
|
0.0009 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '16' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '95' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '95' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '27' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '27' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '39' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '39' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '19' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '19' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '24' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '24' ?>
|
0.0012 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '36' ?>
|
0.0008 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '36' ?>
|
0.0008 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '9' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '9' ?>
|
0.0009 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '11' ?>
|
0.0008 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '11' ?>
|
0.0006 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '97' ?>
|
0.0008 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '97' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '14' ?>
|
0.0008 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '14' ?>
|
0.0007 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '38' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '38' ?>
|
0.0009 | 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_shore_excursion` = 'N'
AND `a`.`productType` != 'TRANSFER'
AND `b`.`destination_id` = '108' ?>
|
0.0007 | 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_shore_excursion` = 'Y'
AND `b`.`destination_id` = '108' ?>
|
0.0022 | SELECT *
FROM `ophorus_footer_links`
ORDER BY `link_order` DESC ?>
|
0.0023 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '32' ?>
|
0.0005 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '35' ?>
|
0.0005 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '33' ?>
|
0.0005 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '30' ?>
|
0.0009 | SELECT *
FROM `ophorus_products_categories`
WHERE `categorie_id` = '4'
AND `categorie_activ` = 'Y' ?>
|
0.0004 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '4' ?>
|
0.0004 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '5' ?>
|
0.0005 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '36' ?>
|
0.0004 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '34' ?>
|
0.0004 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '8' ?>
|
0.0005 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '7' ?>
|
0.0005 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '31' ?>
|
0.0005 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '13' ?>
|
0.0004 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '37' ?>
|
0.0004 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '25' ?>
|
0.0005 | SELECT *
FROM `ophorus_custom_search`
WHERE `custom_id` = '38' ?>
|
0.0009 | SELECT *
FROM `ophorus_rezdy` ?>
|
0.0016 | SELECT *
FROM `ophorus_modal`
WHERE `modal_activ` = 'Y' ?>
|
0.0013 | SELECT *
FROM `ophorus_brochures`
ORDER BY `brochure_order` DESC ?>
|
0.0014 | SELECT *
FROM `ophorus_footer_bg`
ORDER BY RAND() ?>
|
0.0022 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '163'
ORDER BY `media_order` DESC ?>
|
0.0017 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = '163'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '174'
ORDER BY `media_order` DESC ?>
|
0.0009 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = '174'
LIMIT 2 ?>
|
0.0004 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '247'
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` = '247'
LIMIT 2 ?>
|
0.0007 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '25'
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` = '25'
LIMIT 2 ?>
|
0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '26'
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` = '26'
LIMIT 2 ?>
|
0.0007 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '121'
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` = '121'
LIMIT 2 ?>
|
0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '23'
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` = '23'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '255'
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` = '255'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '180'
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` = '180'
LIMIT 2 ?>
|
0.0004 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '258'
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` = '258'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '17'
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` = '17'
LIMIT 2 ?>
|
0.0004 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '79'
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` = '79'
LIMIT 2 ?>
|
0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '24'
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` = '24'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '18'
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` = '18'
LIMIT 2 ?>
|
0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '5'
ORDER BY `media_order` DESC ?>
|
0.0009 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = '5'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '189'
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` = '189'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '227'
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` = '227'
LIMIT 2 ?>
|
0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '72'
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` = '72'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '218'
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` = '218'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '219'
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` = '219'
LIMIT 2 ?>
|
0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '157'
ORDER BY `media_order` DESC ?>
|
0.0012 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = '157'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '155'
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` = '155'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '615'
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` = '615'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '694'
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` = '694'
LIMIT 2 ?>
|
0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '798'
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` = '798'
LIMIT 2 ?>
|
0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '800'
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` = '800'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '801'
ORDER BY `media_order` DESC ?>
|
0.0010 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = '801'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '821'
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` = '821'
LIMIT 2 ?>
|
0.0005 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '822'
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` = '822'
LIMIT 2 ?>
|
0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '898'
ORDER BY `media_order` DESC ?>
|
0.0012 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = '898'
LIMIT 2 ?>
|
0.0006 | SELECT *
FROM `ophorus_products_medias`
WHERE `product_id` = '936'
ORDER BY `media_order` DESC ?>
|
0.0016 | SELECT *
FROM `ophorus_destinations` `a`
JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`destination_id` = `a`.`destination_id`
WHERE `b`.`product_id` = '936'
LIMIT 2 ?>
|
0.0023 | SELECT *
FROM `ophorus_products_liaison_destinations` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `a`.`destination_id` = '40'
AND `b`.`productType` != 'TRANSFER'
AND `b`.`product_from` = 'PROD'
AND `b`.`product_activ` = 'Y' ?>
|
0.0040 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '617' ?>
|
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` = '619' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '618' ?>
|
0.0035 | SELECT *
FROM `ophorus_products_liaison_destinations` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `a`.`destination_id` = '5'
AND `b`.`productType` != 'TRANSFER'
AND `b`.`product_from` = 'PROD'
AND `b`.`product_activ` = 'Y' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '60' ?>
|
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` = '55' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '239' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '240' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '241' ?>
|
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` = '278' ?>
|
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` = '7' ?>
|
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` = '31' ?>
|
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` = '32' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '35' ?>
|
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` = '218' ?>
|
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` = '219' ?>
|
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` = '414' ?>
|
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` = '415' ?>
|
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` = '157' ?>
|
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` = '158' ?>
|
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` = '159' ?>
|
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` = '155' ?>
|
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` = '238' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '140' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '142' ?>
|
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` = '500' ?>
|
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` = '501' ?>
|
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` = '423' ?>
|
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` = '220' ?>
|
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` = '509' ?>
|
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` = '504' ?>
|
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` = '505' ?>
|
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` = '198' ?>
|
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` = '507' ?>
|
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` = '217' ?>
|
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` = '421' ?>
|
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` = '221' ?>
|
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` = '143' ?>
|
0.0005 | 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.0004 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '514' ?>
|
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` = '303' ?>
|
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` = '81' ?>
|
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` = '624' ?>
|
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` = '83' ?>
|
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` = '115' ?>
|
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` = '640' ?>
|
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` = '641' ?>
|
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` = '642' ?>
|
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` = '655' ?>
|
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` = '795' ?>
|
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` = '796' ?>
|
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` = '797' ?>
|
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` = '613' ?>
|
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` = '658' ?>
|
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` = '831' ?>
|
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` = '867' ?>
|
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` = '868' ?>
|
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` = '869' ?>
|
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` = '871' ?>
|
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` = '872' ?>
|
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` = '261' ?>
|
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` = '886' ?>
|
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` = '887' ?>
|
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` = '908' ?>
|
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` = '905' ?>
|
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` = '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` = '1051' ?>
|
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` = '1053' ?>
|
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` = '1101' ?>
|
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` = '1099' ?>
|
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` = '1127' ?>
|
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` = '1132' ?>
|
0.0014 | SELECT *
FROM `ophorus_products_liaison_destinations` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `a`.`destination_id` = '21'
AND `b`.`productType` != 'TRANSFER'
AND `b`.`product_from` = 'PROD'
AND `b`.`product_activ` = 'Y' ?>
|
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` = '620' ?>
|
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` = '621' ?>
|
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` = '734' ?>
|
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` = '735' ?>
|
0.0015 | SELECT *
FROM `ophorus_products_liaison_destinations` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `a`.`destination_id` = '17'
AND `b`.`productType` != 'TRANSFER'
AND `b`.`product_from` = 'PROD'
AND `b`.`product_activ` = 'Y' ?>
|
0.0007 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '508' ?>
|
0.0007 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '541' ?>
|
0.0007 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '223' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '909' ?>
|
0.0029 | SELECT *
FROM `ophorus_products_liaison_destinations` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `a`.`destination_id` = '6'
AND `b`.`productType` != 'TRANSFER'
AND `b`.`product_from` = 'PROD'
AND `b`.`product_activ` = 'Y' ?>
|
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` = '3' ?>
|
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` = '22' ?>
|
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` = '25' ?>
|
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` = '26' ?>
|
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` = '84' ?>
|
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` = '121' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '122' ?>
|
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` = '257' ?>
|
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` = '23' ?>
|
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` = '118' ?>
|
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` = '585' ?>
|
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` = '653' ?>
|
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` = '1045' ?>
|
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` = '1116' ?>
|
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` = '1117' ?>
|
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` = '1118' ?>
|
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` = '1119' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1120' ?>
|
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` = '1121' ?>
|
0.0010 | SELECT *
FROM `ophorus_products_liaison_destinations` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `a`.`destination_id` = '33'
AND `b`.`productType` != 'TRANSFER'
AND `b`.`product_from` = 'PROD'
AND `b`.`product_activ` = 'Y' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '578' ?>
|
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` = '582' ?>
|
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` = '581' ?>
|
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` = '844' ?>
|
0.0009 | SELECT *
FROM `ophorus_products_liaison_destinations` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `a`.`destination_id` = '49'
AND `b`.`productType` != 'TRANSFER'
AND `b`.`product_from` = 'PROD'
AND `b`.`product_activ` = 'Y' ?>
|
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` = '579' ?>
|
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` = '584' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '1057' ?>
|
0.0015 | SELECT *
FROM `ophorus_products_liaison_destinations` `a`
JOIN `ophorus_products` `b` ON `b`.`product_id` = `a`.`product_id`
WHERE `a`.`destination_id` = '7'
AND `b`.`productType` != 'TRANSFER'
AND `b`.`product_from` = 'PROD'
AND `b`.`product_activ` = 'Y' ?>
|
0.0005 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '19' ?>
|
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` = '144' ?>
|
0.0007 | SELECT *
FROM `ophorus_products_packages` `a`
JOIN `ophorus_products_liaison_packages` `b` ON `b`.`package_id` = `a`.`package_id`
WHERE `b`.`product_id` = '17' ?>
|
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` = '201' ?>
|
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` = '123' ?>
|
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` = '79' ?>
|
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` = '4' ?>
|
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` = '24' ?>
|
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` = '18' ?>
|
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` = '42' ?>
|
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` = '5' ?>
|
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` = '119' ?>
|
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` = '190' ?>
|
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` = '234' ?>
|
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` = '235' ?>
|
0.0003 | SELECT *
FROM `ophorus_prod
|