Soin bien-être Aisselles-Maillot Simple -Jambes entières
Logs
2026-09-07 06:32:08 info: Module appelé: app\lib\module\frontMarqueBlanche\ArticleFrontMarqueBlancheModule2026-09-07 06:32:08 info: Module chargé: app\lib\module\frontMarqueBlanche\ArticleFrontMarqueBlancheModule
SQL (0.254s)
0.000 : Connexion BDD sur localhost:ideospa_zenespace
0.000 : 57 : SELECT * FROM registry
0.001 : 1 : SELECT pdv_id, pdv_code, pdv_domaine_externe FROM mag_pdv WHERE pdv_code = 'ava-spa' AND pdv_actif = 1 AND pdv_enligne = 1 AND pdv_marque_blanche = 1
0.000 : 0 : SELECT * FROM mag_pdv_langues WHERE pdvl_pdv_id = '116'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '116'
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 = '116'
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 = '116')
WHERE mod_pdv_id = 0 && mod_activation_ideolog = 1 && cmp_statut_publication = 1
0.000 : 0 : SELECT * FROM mag_pdv_infos LEFT JOIN mag_pdv_infos_lang ON (mpi_pdv_id = lmpi_pdv_id AND lang = '') WHERE mpi_pdv_id = '116'
0.000 : 51 : SELECT * FROM mag_pdv_registry WHERE pdvr_pdv_id = 116
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '116'
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 = '116' AND cli_bloque_sur_pdv = 1
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '116'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '116'
0.000 : 1 : SELECT * FROM cat_modeles WHERE mod_id='54780'
0.000 : 1 : SELECT modr_rayon_path FROM cat_modeles_rayons WHERE modr_principal = 1 AND modr_mod_id = '54780' ORDER BY length(modr_rayon_path) DESC
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '116'
0.000 : 1 : SELECT grp_profil_tarif_id
FROM mag_pdv
JOIN cli_groupes ON (grp_id = pdv_grpclientdefaut)
WHERE pdv_id = '116'
0.000 : 1 : SELECT ent_id
FROM entrepots
WHERE ent_pdv_id = '116' AND ent_code = 'MAGASIN'
0.000 : 1 : SHOW TABLES LIKE 'frn_fournisseurs'
0.001 : 889 : SELECT marque_nom, marque_id, marque_image, lmarque_nom, frn_delai_reappro 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 = '')
0.005 : 1442 : SELECT * FROM cat_familles LEFT JOIN cat_familles_lang ON (lfam_id=fam_id AND lang='') ORDER BY fam_libelle
0.005 : 2952 : SELECT * FROM cat_sous_familles LEFT JOIN cat_sous_familles_lang ON (lsfam_id=sfam_id AND lang='')
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 = '')
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 = '116')
LEFT JOIN cat_articles_stocks ON (sto_art_id = art_id AND sto_ent_id = '426')
WHERE mod_id = '54780'
GROUP BY cat_articles.art_id
ORDER BY art_reference
0.018 : 51962 : SELECT art_modele_id, count(*) AS count FROM cat_articles GROUP BY art_modele_id
0.000 : 0 : SELECT *
FROM cat_marques
WHERE marque_pdv_id = '116'
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='') WHERE rub_id='5141'
0.001 : 23 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = '') WHERE rub_pdv_id = '116' ORDER BY rub_id_parent,rub_ordre, rub_libelle
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 = '116'
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 = '116')
WHERE mod_pdv_id = 0 && mod_activation_ideolog = 1 && cmp_statut_publication = 1
0.000 : 0 : SELECT * FROM mag_pdv_infos LEFT JOIN mag_pdv_infos_lang ON (mpi_pdv_id = lmpi_pdv_id AND lang = '') WHERE mpi_pdv_id = '116'
0.002 : 14 : 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 = '116' )
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 = '116'
)
0.000 : 1 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = '') WHERE rub_id = '5128'
0.000 : 1 : SELECT * FROM cat_modeles WHERE mod_id = '54780'
0.011 : 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 = '')
LEFT JOIN cat_modeles_pdv_complements ON (m.mod_id = cmp_mod_id AND cmp_pdv_id = '116')
WHERE lip_actif = 1 AND lip_src_id = '54780'
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 = '')
LEFT JOIN cat_modeles_pdv_complements ON (m.mod_id = cmp_mod_id AND cmp_pdv_id = '116')
WHERE lif_actif = 1 AND lif_src_id = '3400'
AND m.mod_id != '54780'
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 = '')
LEFT JOIN cat_modeles_pdv_complements ON (m.mod_id = cmp_mod_id AND cmp_pdv_id = '116')
WHERE lif_actif = 1 AND lif_src_id = '1856'
AND m.mod_id != '54780'
AND m.mod_vente_web != 0
GROUP BY m.mod_id
ORDER BY RAND()
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 = '116'
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 = '116')
WHERE mod_pdv_id = 0 && mod_activation_ideolog = 1 && cmp_statut_publication = 1
0.000 : 0 : SELECT * FROM mag_pdv_infos LEFT JOIN mag_pdv_infos_lang ON (mpi_pdv_id = lmpi_pdv_id AND lang = '') WHERE mpi_pdv_id = '116'
0.009 : 0 : SELECT att_val FROM cat_modeles_attributs WHERE att_mod_reference = '54780' 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 = 116)
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='')
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 = 116 OR mod_instance = 'IDEOSPA' )
AND cat_modeles_attributs.att_val = 54780
GROUP BY mod_id
ORDER BY mod_id ASC
0.000 : 1 : SHOW TABLES LIKE 'frn_fournisseurs'
0.000 : 0 : SELECT frn_delai_reappro FROM cat_marques
LEFT JOIN frn_fournisseurs ON (marque_fournisseur_id = frn_id)
WHERE marque_id = ''
0.023 : 239 : 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 = '116' 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 = '116')
0.001 : 74 : 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 = '174'
AND prix_pdv_id = '116'
0.000 : 0 : SELECT * FROM cat_dispos_statiques
0.000 : 74 : SELECT * FROM cat_prix WHERE prix_profil_tarif_id = '174' AND prix_pdv_id = '116' ORDER BY prix_unite ASC
0.000 : 0 : SELECT *
FROM cat_declinaisons_attributs
LEFT JOIN cat_declinaisons_groupes ON (deca_decg_id = decg_id)
ORDER BY decg_libelle, deca_libelle
0.051 : 18734 : SELECT * FROM cat_modeles_attributs ORDER BY att_ordre
0.005 : 0 : SELECT * FROM cat_images WHERE img_mod_id = '54780' ORDER BY img_num
0.000 : 1 : SELECT count(*)
FROM yield_jours
JOIN yield_semaines ON (yiej_yies_id = yies_id)
WHERE yies_pdv_id = '116' AND yiej_fam_id = '1856' 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='') WHERE rub_id='5128'
0.002 : 23 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = '') WHERE rub_pdv_id = '116' ORDER BY rub_id_parent,rub_ordre, rub_libelle
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 = '116'
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 = '116')
WHERE mod_pdv_id = 0 && mod_activation_ideolog = 1 && cmp_statut_publication = 1
0.000 : 0 : SELECT * FROM mag_pdv_infos LEFT JOIN mag_pdv_infos_lang ON (mpi_pdv_id = lmpi_pdv_id AND lang = '') WHERE mpi_pdv_id = '116'
0.002 : 14 : 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 = '116' )
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 = '116'
)
0.042 : 2956 : 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 = '5141'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5142'
0.000 : 0 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = '') WHERE rub_id = '0'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5128'
0.000 : 1 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang='') WHERE rub_id='5141'
0.001 : 23 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = '') WHERE rub_pdv_id = '116' ORDER BY rub_id_parent,rub_ordre, rub_libelle
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 = '116'
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 = '116')
WHERE mod_pdv_id = 0 && mod_activation_ideolog = 1 && cmp_statut_publication = 1
0.000 : 0 : SELECT * FROM mag_pdv_infos LEFT JOIN mag_pdv_infos_lang ON (mpi_pdv_id = lmpi_pdv_id AND lang = '') WHERE mpi_pdv_id = '116'
0.002 : 14 : 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 = '116' )
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 = '116'
)
0.000 : 1 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = '') WHERE rub_id = '5128'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5128'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5141'
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 = '54780' 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 = '') 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 = '116'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '116'
0.000 : 1 : SELECT * FROM cms_bribes LEFT JOIN cms_bribes_lang ON (lbribe_id = bribe_id AND lang = '') 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 = '') 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 = '') 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='') 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='') WHERE id_parent='575' AND actif=1 ORDER BY ordre_rubrique ASC
0.004 : 1356 : SELECT * FROM cms
0.001 : 0 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='') 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='') 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='') WHERE id_parent='578' AND actif=1 ORDER BY ordre_rubrique ASC
0.000 : 101 : 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='') 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='') 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='') 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='') 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='') 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='') 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='') 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='') 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 = '116'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '116'
0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '116'
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 = '116'
0.000 : 11 : 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 = '116') WHERE mp_actif_pos = 1
0.000 : 4 : SELECT * FROM mag_pdv_theme_images JOIN banque_images ON (pdvti_bimg_id = bimg_id) WHERE pdvti_pdv_id = '116'
0.001 : 23 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = '') WHERE rub_pdv_id = '116' ORDER BY rub_id_parent,rub_ordre, rub_libelle
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 = '116'
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 = '116')
WHERE mod_pdv_id = 0 && mod_activation_ideolog = 1 && cmp_statut_publication = 1
0.000 : 0 : SELECT * FROM mag_pdv_infos LEFT JOIN mag_pdv_infos_lang ON (mpi_pdv_id = lmpi_pdv_id AND lang = '') WHERE mpi_pdv_id = '116'
0.002 : 14 : 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 = '116' )
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 = '116'
)
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5123'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5123'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5152'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5123'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5138'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5123'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5147'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5123'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5148'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5122'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5122'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5149'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5122'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5136'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5122'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5135'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5121'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5121'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5124'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5121'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5130'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5127'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5127'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5151'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5127'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5139'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5127'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5140'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5128'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5128'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5141'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5128'
0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5142'
0.000 : 1 : SELECT * FROM menus WHERE code='navigation' AND pdv_id ='116'
0.001 : 7 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='') WHERE id_menu='274' AND id_parent=0 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='') WHERE id_parent='3305' 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='') WHERE id_parent='3302' 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='') WHERE id_parent='3303' 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='') WHERE id_parent='3306' 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='') WHERE id_parent='3307' 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='') WHERE id_parent='3309' 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='') WHERE id_parent='3310' AND actif=1 ORDER BY ordre_rubrique ASC
0.000 : 1 : SELECT * FROM menus WHERE code='footer' AND pdv_id ='116'
0.001 : 5 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='') WHERE id_menu='275' 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='') WHERE id_parent='3297' 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='') WHERE id_parent='3298' 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='') WHERE id_parent='3299' 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='') WHERE id_parent='3300' 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='') WHERE id_parent='3311' AND actif=1 ORDER BY ordre_rubrique ASC
0.000 : 0 : SELECT * FROM menus WHERE code='prefooter' AND pdv_id ='116'
0.000 : 1 : SELECT * FROM sliders WHERE sli_code = 'univers-slider' AND sli_pdv_id = '116'
0.000 : 0 : SELECT *
FROM sliders_images
LEFT JOIN sliders_images_lang ON (lsli_img_id = sli_img_id AND lang = '')
WHERE sli_id = '297' AND sli_img_active = 1
ORDER BY sli_img_ordre
0.000 : 0 : SELECT * FROM sliders WHERE sli_code = 'sliderSoins' AND sli_pdv_id = '116'
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 = '116' AND hou_jour = 'lundi'
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 = '116'
0.000 : 0 : SELECT * FROM tracking_analytics WHERE trk_actif = 1 AND trk_pdv_id = '116'