Wellness treatment SEA HOLISTIC
Allow : 1h15
Durée de la prestation : 1h
Through soft effleurage strokes, targeted pressure, and stretching, this Thai-inspired massage eliminates areas of tension one by one using the gentle heat of warmed linen bundles. Gradually, your mind surrenders to an overall sense of well-being and long-lasting replenishment.
Through soft effleurage strokes, targeted pressure, and stretching, this Thai-inspired massage eliminates areas of tension one by one using the gentle heat of warmed linen bundles. Gradually, your mind surrenders to an overall sense of well-being and long-lasting replenishment.
Logs
info: Module appelé: app\lib\module\frontMarqueBlanche\ArticleFrontMarqueBlancheModuleinfo: Module chargé: app\lib\module\frontMarqueBlanche\ArticleFrontMarqueBlancheModule
SQL (0.246s)
0.000 : Connexion BDD sur localhost:ideospa_zenespace
0.000 : 57 : SELECT * FROM registry
0.000 : 1 : SELECT pdv_id FROM mag_pdv WHERE pdv_domaine_externe = 'trocadero.spaphytomer.com' AND pdv_actif = 1 AND pdv_enligne = 1 AND pdv_marque_blanche = 1
0.000 : 1 : SELECT * FROM mag_pdv_langues WHERE pdvl_pdv_id = '40'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.000 : 1 : SELECT * FROM mag_pdv LEFT JOIN mag_pdv_fiche mpf ON (pdv_id = pdvf_pdv_id ) JOIN niveau_adhesion ON (pdv_nvad_id = nvad_id) WHERE pdv_id = '40'
0.000 : 0 : SELECT mod_id
FROM cat_modeles
LEFT JOIN cat_modeles_pdv_complements ON (mod_id = cmp_mod_id AND cmp_pdv_id = '40')
WHERE mod_pdv_id = 0 && mod_activation_ideolog = 1 && cmp_statut_publication = 1
0.000 : 1 : SELECT * FROM mag_pdv_infos LEFT JOIN mag_pdv_infos_lang ON (mpi_pdv_id = lmpi_pdv_id AND lang = 'en') WHERE mpi_pdv_id = '40'
0.000 : 57 : SELECT * FROM mag_pdv_registry WHERE pdvr_pdv_id = 40
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.000 : 0 : SELECT * FROM cli_clients LEFT JOIN cli_groupes ON (grp_id = cli_grp_id) WHERE cli_id = '' AND cli_actif = 1 AND cli_archive = 0 AND cli_pdv_id = '40' AND cli_bloque_sur_pdv = 1
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.000 : 1 : SELECT * FROM cat_modeles WHERE mod_id='13865'
0.000 : 1 : SELECT modr_rayon_path FROM cat_modeles_rayons WHERE modr_principal = 1 AND modr_mod_id = '13865' ORDER BY length(modr_rayon_path) DESC
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.000 : 1 : SELECT grp_profil_tarif_id
FROM mag_pdv
JOIN cli_groupes ON (grp_id = pdv_grpclientdefaut)
WHERE pdv_id = '40'
0.000 : 1 : SELECT ent_id
FROM entrepots
WHERE ent_pdv_id = '40' AND ent_code = 'MAGASIN'
0.000 : 1 : SHOW TABLES LIKE 'frn_fournisseurs'
0.001 : 887 : SELECT marque_nom, marque_id, marque_image, frn_delai_reappro, lmarque_nom as delai_reappro FROM cat_marques LEFT JOIN frn_fournisseurs ON (marque_fournisseur_id = frn_id) LEFT JOIN cat_marques_lang ON (lmarque_id = marque_id AND lang = 'en')
0.005 : 1406 : SELECT * FROM cat_familles LEFT JOIN cat_familles_lang ON (lfam_id=fam_id AND lang='en') ORDER BY fam_libelle
0.004 : 2940 : SELECT * FROM cat_sous_familles LEFT JOIN cat_sous_familles_lang ON (lsfam_id=sfam_id AND lang='en')
0.001 : 1 : SELECT cat_modeles.*,
cat_modeles_lang.*,
cat_articles.*,
cat_modeles_pdv_complements.*,
cat_articles_stocks.*,
GROUP_CONCAT(decg_libelle, ' : ', deca_libelle ORDER BY artd_ordre, artd_id SEPARATOR ', ') as art_info_decli,
GROUP_CONCAT(deca_id ORDER BY artd_ordre, artd_id SEPARATOR '_') as art_decli_attributs,
GROUP_CONCAT(decg_id ORDER BY artd_ordre, artd_id SEPARATOR '_') as art_decli_groupes
FROM cat_modeles
LEFT JOIN cat_modeles_lang ON (lmod_id = mod_id AND lang = 'en')
LEFT JOIN cat_articles ON (art_modele_id = mod_id)
LEFT JOIN cat_articles_declinaisons on (artd_art_id = art_id)
LEFT JOIN cat_declinaisons_attributs ON (artd_deca_id = deca_id)
LEFT JOIN cat_declinaisons_groupes ag ON (deca_decg_id = decg_id)
LEFT JOIN cat_modeles_pdv_complements ON (mod_id = cmp_mod_id AND cmp_pdv_id = '40')
LEFT JOIN cat_articles_stocks ON (sto_art_id = art_id AND sto_ent_id = '170')
WHERE mod_id = '13865'
GROUP BY cat_articles.art_id
ORDER BY art_reference
0.017 : 50965 : SELECT art_modele_id, count(*) AS count FROM cat_articles GROUP BY art_modele_id
0.000 : 5 : SELECT *
FROM cat_marques
WHERE marque_pdv_id = '40'
ORDER BY marque_nom
0.000 : 2 : SELECT prmd_mod_id, prm_libelle, prm_libelle_commercial FROM cat_promos_detail JOIN cat_promos ON (prm_id = prmd_prm_id) WHERE prm_web_actif=1 GROUP BY prmd_mod_id
0.007 : 0 : SELECT mod_id FROM cat_modeles JOIN cat_modeles_attributs ON (att_mod_reference=mod_id) WHERE att_code='pa' AND att_web_valeur='oui' GROUP BY mod_id
0.000 : 1 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang='en') WHERE rub_id='1360'
0.001 : 23 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = 'en') WHERE rub_pdv_id = '40' ORDER BY rub_id_parent,rub_ordre, rub_libelle
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.007 : 23 : SELECT DISTINCT modr_rayon_path
FROM cat_modeles_rayons
JOIN cat_modeles ON (mod_id=modr_mod_id)
LEFT JOIN cat_modeles_niveau_adhesion ON ( cmna_mod_id = mod_id )
LEFT JOIN niveau_adhesion ON ( nvad_id = cmna_nvad_id )
LEFT JOIN cat_modeles_pdv_complements ON ( cmp_mod_id = mod_id AND cmp_pdv_id = '40' )
WHERE mod_vente_web != 0 AND
(
( mod_pdv_id = 0
AND ( ( nvad_lvl IS NOT NULL AND nvad_lvl <= '1') OR ( cmp_surcharge_adhesion IS NOT NULL AND cmp_surcharge_adhesion = 1 ) )
AND mod_activation_ideolog = 1
)
OR
mod_pdv_id = '40'
)
0.000 : 1 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = 'en') WHERE rub_id = '1355'
0.000 : 1 : SELECT * FROM cat_modeles WHERE mod_id = '13865'
0.010 : 0 : (
SELECT m.*, cat_modeles_lang.*, cat_modeles_pdv_complements.*
FROM cat_produits_lies
JOIN cat_produits_lies_detail ON (lipd_lip_id = lip_id)
JOIN cat_modeles m ON (m.mod_id = lipd_dst_id)
LEFT JOIN cat_modeles_lang ON (lmod_id = m.mod_id AND lang = 'en')
LEFT JOIN cat_modeles_pdv_complements ON (m.mod_id = cmp_mod_id AND cmp_pdv_id = '40')
WHERE lip_actif = 1 AND lip_src_id = '13865'
AND (lip_type = 'produits_fils' OR lip_type = 'groupe')
AND m.mod_id!=:mod_id
AND m.mod_vente_web != 0
GROUP BY m.mod_id
)
UNION
(
SELECT m.*, cat_modeles_lang.*, cat_modeles_pdv_complements.*
FROM cat_produits_lies
JOIN cat_modeles m_src ON (m_src.mod_id = lip_src_id)
JOIN cat_modeles m ON (m.mod_famille = m_src.mod_famille)
LEFT JOIN cat_modeles_lang ON (lmod_id = m.mod_id AND lang = :lang)
LEFT JOIN cat_modeles_pdv_complements ON (m.mod_id = cmp_mod_id AND cmp_pdv_id = :pdv_id)
WHERE lip_actif = 1 AND lip_src_id = :mod_id
AND lip_type = 'ma_famille'
AND m.mod_id != :mod_id
AND m.mod_vente_web != 0
GROUP BY m.mod_id
)
UNION
(
SELECT m.*, cat_modeles_lang.*, cat_modeles_pdv_complements.*
FROM cat_produits_lies
JOIN cat_produits_lies_detail ON (lipd_lip_id = lip_id)
JOIN cat_modeles m ON (m.mod_famille = lipd_dst_id)
LEFT JOIN cat_modeles_lang ON (lmod_id = m.mod_id AND lang = :lang)
LEFT JOIN cat_modeles_pdv_complements ON (m.mod_id = cmp_mod_id AND cmp_pdv_id = :pdv_id)
WHERE lip_actif = 1 AND lip_src_id = :mod_id
AND lip_type = 'familles'
AND m.mod_id != :mod_id
AND m.mod_vente_web != 0
GROUP BY m.mod_id
)
UNION
(
SELECT m.*, cat_modeles_lang.*, cat_modeles_pdv_complements.*
FROM cat_produits_lies_detail
JOIN cat_produits_lies ON (lipd_lip_id = lip_id)
JOIN cat_modeles m ON (m.mod_id = lip_src_id)
LEFT JOIN cat_modeles_lang ON (lmod_id = m.mod_id AND lang = :lang)
LEFT JOIN cat_modeles_pdv_complements ON (m.mod_id = cmp_mod_id AND cmp_pdv_id = :pdv_id)
WHERE lip_actif = 1 AND lipd_dst_id = :mod_id
AND lip_type = 'produits_peres'
AND m.mod_id != :mod_id
AND m.mod_vente_web != 0
GROUP BY m.mod_id
)
UNION
(
SELECT m.*, cat_modeles_lang.*, cat_modeles_pdv_complements.*
FROM cat_produits_lies_detail d1
JOIN cat_produits_lies ON (d1.lipd_lip_id = lip_id)
LEFT JOIN cat_produits_lies_detail d2 ON (d2.lipd_lip_id = lip_id)
JOIN cat_modeles m ON (m.mod_id = lip_src_id OR (m.mod_id = d2.lipd_dst_id AND m.mod_id != :mod_id))
LEFT JOIN cat_modeles_lang ON (lmod_id = m.mod_id AND lang = :lang)
LEFT JOIN cat_modeles_pdv_complements ON (m.mod_id = cmp_mod_id AND cmp_pdv_id = :pdv_id)
WHERE lip_actif = 1 AND d1.lipd_dst_id = :mod_id
AND lip_type = 'groupe'
AND m.mod_id != :mod_id
AND m.mod_vente_web != 0
GROUP BY m.mod_id
)
ORDER BY RAND()
0.001 : 0 : SELECT m.*, cat_modeles_lang.*, cat_modeles_pdv_complements.*
FROM cat_sous_familles_lies
JOIN cat_sous_familles_lies_detail ON (lifd_lif_id = lif_id)
JOIN cat_modeles m ON (m.mod_sous_famille = lifd_dst_id)
LEFT JOIN cat_modeles_lang ON (lmod_id = m.mod_id AND lang = 'en')
LEFT JOIN cat_modeles_pdv_complements ON (m.mod_id = cmp_mod_id AND cmp_pdv_id = '40')
WHERE lif_actif = 1 AND lif_src_id = '476'
AND m.mod_id != '13865'
AND m.mod_vente_web != 0
GROUP BY m.mod_id
ORDER BY RAND()
0.001 : 0 : SELECT m.*, cat_modeles_lang.*, cat_modeles_pdv_complements.*
FROM cat_familles_lies
JOIN cat_familles_lies_detail ON (lifd_lif_id = lif_id)
JOIN cat_modeles m ON (m.mod_famille = lifd_dst_id)
LEFT JOIN cat_modeles_lang ON (lmod_id = m.mod_id AND lang = 'en')
LEFT JOIN cat_modeles_pdv_complements ON (m.mod_id = cmp_mod_id AND cmp_pdv_id = '40')
WHERE lif_actif = 1 AND lif_src_id = '602'
AND m.mod_id != '13865'
AND m.mod_vente_web != 0
GROUP BY m.mod_id
ORDER BY RAND()
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.008 : 0 : SELECT att_val FROM cat_modeles_attributs WHERE att_mod_reference = '13865' AND att_code = 'id_parent'
0.009 : 0 : SELECT SQL_CALC_FOUND_ROWS distinct mod_id, cat_modeles.*, cat_modeles_lang.*, cat_modeles_pdv_complements.*
FROM cat_modeles
LEFT JOIN cat_modeles_pdv_complements ON (cat_modeles.mod_id = cmp_mod_id AND cmp_pdv_id = 40)
JOIN cat_articles on (cat_modeles.mod_id = cat_articles.art_modele_id)
LEFT JOIN cat_modeles_lang ON (lmod_id = mod_id AND lang='en')
LEFT JOIN cat_modeles_attributs ON (att_mod_reference = mod_id AND att_code = 'id_parent')
WHERE mod_vente_web!=0
AND ( mod_gestion_stock = 0 OR (art_stock >= 1 OR art_dispo_fournisseur!=1) )
AND (mod_pdv_id = 40 OR mod_instance = 'IDEOSPA' )
AND cat_modeles_attributs.att_val = 13865
GROUP BY mod_id
ORDER BY mod_id ASC
0.000 : 1 : SHOW TABLES LIKE 'frn_fournisseurs'
0.000 : 1 : SELECT frn_delai_reappro FROM cat_marques
LEFT JOIN frn_fournisseurs ON (marque_fournisseur_id = frn_id)
WHERE marque_id = '198'
0.021 : 1200 : SELECT p.*, prix_vente as prix_unitaire
FROM cat_prix p
WHERE prix_vente IS NOT NULL AND prix_unite = 1 AND (prix_pdv_id = '40' OR prix_pdv_id = 0)
0.000 : 2 : SELECT *
FROM cat_promos_detail
JOIN cat_promos ON (prm_id = prmd_prm_id AND prm_web_actif = 1)
LEFT JOIN cat_prix ON (prix_mod_id = prmd_mod_id AND prix_art_id = prmd_art_id AND prix_unite = 1 AND prix_profil_tarif_id = prm_profil_tarif_id AND prmd_prix_id IS NULL AND prix_pdv_id = '40')
0.002 : 1035 : SELECT p.*, prix_vente as prix_unitaire
FROM cat_prix p
WHERE prix_vente IS NOT NULL
AND prix_unite = 1
AND prix_profil_tarif_id = '38'
AND prix_pdv_id = '40'
0.000 : 0 : SELECT * FROM cat_dispos_statiques
0.002 : 1040 : SELECT * FROM cat_prix WHERE prix_profil_tarif_id = '38' AND prix_pdv_id = '40' ORDER BY prix_unite ASC
0.000 : 0 : SELECT deca_id, deca_libelle, decg_id, decg_libelle
FROM cat_declinaisons_attributs
LEFT JOIN cat_declinaisons_groupes ON (deca_decg_id = decg_id)
ORDER BY decg_libelle, deca_libelle
0.045 : 18230 : SELECT * FROM cat_modeles_attributs ORDER BY att_ordre
0.005 : 0 : SELECT * FROM cat_images WHERE img_mod_id = '13865' ORDER BY img_num
0.002 : 1 : SELECT count(*)
FROM yield_jours
JOIN yield_semaines ON (yiej_yies_id = yies_id)
WHERE yies_pdv_id = '40' AND yiej_fam_id = '602' AND yiej_type in ('2', '1') AND yiej_date >= DATE(NOW())
0.000 : 1 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang='en') WHERE rub_id='1355'
0.001 : 23 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = 'en') WHERE rub_pdv_id = '40' ORDER BY rub_id_parent,rub_ordre, rub_libelle
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.006 : 23 : SELECT DISTINCT modr_rayon_path
FROM cat_modeles_rayons
JOIN cat_modeles ON (mod_id=modr_mod_id)
LEFT JOIN cat_modeles_niveau_adhesion ON ( cmna_mod_id = mod_id )
LEFT JOIN niveau_adhesion ON ( nvad_id = cmna_nvad_id )
LEFT JOIN cat_modeles_pdv_complements ON ( cmp_mod_id = mod_id AND cmp_pdv_id = '40' )
WHERE mod_vente_web != 0 AND
(
( mod_pdv_id = 0
AND ( ( nvad_lvl IS NOT NULL AND nvad_lvl <= '1') OR ( cmp_surcharge_adhesion IS NOT NULL AND cmp_surcharge_adhesion = 1 ) )
AND mod_activation_ideolog = 1
)
OR
mod_pdv_id = '40'
)
0.037 : 2850 : SELECT modr_rayon_id, count(mod_id) as nb
FROM cat_modeles_rayons
JOIN cat_modeles ON (mod_id = modr_mod_id)
WHERE mod_vente_web!=0
GROUP BY modr_rayon_id
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1360'
0.000 : 0 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = 'en') WHERE rub_id = '0'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1355'
0.000 : 1 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang='en') WHERE rub_id='1360'
0.001 : 23 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = 'en') WHERE rub_pdv_id = '40' ORDER BY rub_id_parent,rub_ordre, rub_libelle
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.005 : 23 : SELECT DISTINCT modr_rayon_path
FROM cat_modeles_rayons
JOIN cat_modeles ON (mod_id=modr_mod_id)
LEFT JOIN cat_modeles_niveau_adhesion ON ( cmna_mod_id = mod_id )
LEFT JOIN niveau_adhesion ON ( nvad_id = cmna_nvad_id )
LEFT JOIN cat_modeles_pdv_complements ON ( cmp_mod_id = mod_id AND cmp_pdv_id = '40' )
WHERE mod_vente_web != 0 AND
(
( mod_pdv_id = 0
AND ( ( nvad_lvl IS NOT NULL AND nvad_lvl <= '1') OR ( cmp_surcharge_adhesion IS NOT NULL AND cmp_surcharge_adhesion = 1 ) )
AND mod_activation_ideolog = 1
)
OR
mod_pdv_id = '40'
)
0.000 : 1 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = 'en') WHERE rub_id = '1355'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1355'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1360'
0.000 : 0 : SELECT cli_avis.*, cli_prenom, cli_nom
FROM cli_avis
LEFT JOIN cli_clients ON (cli_id = avis_cli_id)
WHERE avis_mod_id = '13865' AND avis_etat = 'VAL'
ORDER BY avis_date_add DESC
0.000 : 0 : SELECT * FROM cms LEFT JOIN cms_lang ON (lcms_id = cms_id AND lang = 'en') WHERE cms_code = 'guide_tailles' AND cms_pdv_id = '0' AND cms_etat = 'VAL'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.000 : 1 : SELECT * FROM cms_bribes LEFT JOIN cms_bribes_lang ON (lbribe_id = bribe_id AND lang = 'en') WHERE bribe_code = 'home' AND bribe_etat = 'VAL'
0.000 : 0 : SELECT * FROM cms_bribes LEFT JOIN cms_bribes_lang ON (lbribe_id = bribe_id AND lang = 'en') WHERE bribe_code = 'seo' AND bribe_etat = 'VAL'
0.000 : 0 : SELECT * FROM cms_bribes LEFT JOIN cms_bribes_lang ON (lbribe_id = bribe_id AND lang = 'en') WHERE bribe_code = 'seo-home' AND bribe_etat = 'VAL'
0.000 : 1 : SELECT * FROM menus WHERE code='menu_footer'
0.001 : 4 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_menu='65' AND id_parent=0 AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='575' AND actif=1 ORDER BY ordre_rubrique ASC
0.005 : 1238 : SELECT * FROM cms
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='576' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='577' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='578' AND actif=1 ORDER BY ordre_rubrique ASC
0.000 : 100 : SELECT * FROM menus WHERE code='navigation'
0.001 : 7 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_menu='1' AND id_parent=0 AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 3 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='1' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='713' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='743' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 12 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='8' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 4 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='18' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='712' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='579' AND actif=1 ORDER BY ordre_rubrique ASC
0.000 : 0 : SELECT * FROM menus WHERE code='acces'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.000 : 1 : SELECT pdv_id FROM mag_pdv WHERE pdv_code = 'WEB'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.000 : 13 : SELECT mp_code as id, mp_nom as label FROM mode_paiements JOIN mag_pdv_mode_paiements ON (mp_code = pdvmp_mp_code AND pdvmp_pdv_id = '40') WHERE mp_actif_pos = 1
0.000 : 2 : SELECT * FROM mag_pdv_theme_images JOIN banque_images ON (pdvti_bimg_id = bimg_id) WHERE pdvti_pdv_id = '40'
0.001 : 23 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = 'en') WHERE rub_pdv_id = '40' ORDER BY rub_id_parent,rub_ordre, rub_libelle
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '40'
0.005 : 23 : SELECT DISTINCT modr_rayon_path
FROM cat_modeles_rayons
JOIN cat_modeles ON (mod_id=modr_mod_id)
LEFT JOIN cat_modeles_niveau_adhesion ON ( cmna_mod_id = mod_id )
LEFT JOIN niveau_adhesion ON ( nvad_id = cmna_nvad_id )
LEFT JOIN cat_modeles_pdv_complements ON ( cmp_mod_id = mod_id AND cmp_pdv_id = '40' )
WHERE mod_vente_web != 0 AND
(
( mod_pdv_id = 0
AND ( ( nvad_lvl IS NOT NULL AND nvad_lvl <= '1') OR ( cmp_surcharge_adhesion IS NOT NULL AND cmp_surcharge_adhesion = 1 ) )
AND mod_activation_ideolog = 1
)
OR
mod_pdv_id = '40'
)
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '2429'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '2429'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '2430'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '2429'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '2437'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '2429'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '2438'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1351'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1351'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1357'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1351'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1358'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1351'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '2451'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1351'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1359'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1352'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1352'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1364'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1353'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1353'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1361'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1354'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1354'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1363'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1354'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1362'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1355'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1355'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1360'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1356'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1356'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1365'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1367'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1367'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '1368'
0.000 : 1 : SELECT * FROM menus WHERE code='navigation' AND pdv_id ='40'
0.001 : 8 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_menu='89' AND id_parent=0 AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 3 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='775' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='776' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='777' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 2 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='778' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 1 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='779' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='780' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='781' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='2672' AND actif=1 ORDER BY ordre_rubrique ASC
0.000 : 1 : SELECT * FROM menus WHERE code='footer' AND pdv_id ='40'
0.001 : 4 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_menu='90' AND id_parent=0 AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='852' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='771' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='807' AND actif=1 ORDER BY ordre_rubrique ASC
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='en') WHERE id_parent='772' AND actif=1 ORDER BY ordre_rubrique ASC
0.000 : 0 : SELECT * FROM menus WHERE code='prefooter' AND pdv_id ='40'
0.000 : 1 : SELECT * FROM sliders WHERE sli_code = 'univers-slider' AND sli_pdv_id = '40'
0.000 : 3 : SELECT *
FROM sliders_images
LEFT JOIN sliders_images_lang ON (lsli_img_id = sli_img_id AND lang = 'en')
WHERE sli_id = '104' AND sli_img_active = 1
ORDER BY sli_img_ordre
0.000 : 2 : SELECT *
FROM sliders_images_complement
LEFT JOIN sliders_images_complement_lang ON (comp_sli_img_id = lcomp_sli_img_id AND comp_code = lcomp_code AND lang = 'en')
WHERE comp_sli_img_id = '696'
0.000 : 2 : SELECT *
FROM sliders_images_complement
LEFT JOIN sliders_images_complement_lang ON (comp_sli_img_id = lcomp_sli_img_id AND comp_code = lcomp_code AND lang = 'en')
WHERE comp_sli_img_id = '697'
0.000 : 2 : SELECT *
FROM sliders_images_complement
LEFT JOIN sliders_images_complement_lang ON (comp_sli_img_id = lcomp_sli_img_id AND comp_code = lcomp_code AND lang = 'en')
WHERE comp_sli_img_id = '698'
0.000 : 0 : SELECT * FROM sliders WHERE sli_code = 'sliderSoins' AND sli_pdv_id = '40'
0.000 : 1 : SELECT *,
TIME_FORMAT(hou_ouverture_am, '%H:%i') hou_ouverture_am,
TIME_FORMAT(hou_fermeture_am, '%H:%i') hou_fermeture_am,
TIME_FORMAT(hou_ouverture_pm, '%H:%i') hou_ouverture_pm,
TIME_FORMAT(hou_fermeture_pm, '%H:%i') hou_fermeture_pm
FROM horaire_ouverture
WHERE hou_pdv_id = '40' AND hou_jour = 'mercredi'
0.000 : 7 : SELECT *,
TIME_FORMAT(hou_ouverture_am, '%H:%i') hou_ouverture_am,
TIME_FORMAT(hou_fermeture_am, '%H:%i') hou_fermeture_am,
TIME_FORMAT(hou_ouverture_pm, '%H:%i') hou_ouverture_pm,
TIME_FORMAT(hou_fermeture_pm, '%H:%i') hou_fermeture_pm
FROM horaire_ouverture
WHERE hou_pdv_id = '40'
0.000 : 0 : SELECT * FROM tracking_analytics WHERE trk_actif = 1 AND trk_pdv_id = '40'