0.000 : Connexion BDD sur localhost:ideospa_zenespace

0.000 : 57 : SELECT * FROM registry

0.000 : 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.001 : 1 : SELECT * FROM cms LEFT JOIN cms_lang ON (lcms_id = cms_id AND lang = '') WHERE cms_code = 'avis-client' AND cms_pdv_id = '116' AND cms_etat = 'VAL'

0.001 : 2 : SELECT * FROM cms_box WHERE cms_id='1696' ORDER BY ordre

0.001 : 1 : SELECT * FROM cms_contents LEFT JOIN cms_contents_lang ON (lid_content = id_content AND lang = '') WHERE id_box= '104732' ORDER BY ordre

0.001 : 1 : SELECT * FROM cms_contents LEFT JOIN cms_contents_lang ON (lid_content = id_content AND lang = '') WHERE id_box= '104733' ORDER BY ordre

0.000 : 1 : SELECT * FROM forms WHERE form_code = 'avis' AND form_pdv_id = '116'

0.002 : 10 : SELECT * FROM forms_champs LEFT JOIN forms_champs_lang ON(champ_id = lchamp_id AND lang = '') WHERE form_id='185' ORDER BY champs_ordre

0.000 : 1 : SELECT * FROM cms_row WHERE cms_id='1696' AND id_row = '1'

0.000 : 1 : SELECT * FROM cms_row WHERE cms_id='1696' AND id_row = '2'

0.000 : 1 : SELECT pdv_marque_blanche FROM mag_pdv WHERE pdv_id = '116'

0.000 : 1 : SELECT id_menu FROM menus WHERE code='navigation' AND pdv_id = '116'

0.002 : 0 : SELECT * FROM menus_details WHERE id_menu = '274' AND url_type = 'cms' AND url_data = 'avis-client' AND cms_dossier = '370'

0.001 : 0 : SELECT * FROM menus_details WHERE id_menu_detail = (SELECT id_parent FROM menus_details WHERE id_menu = '274' AND url_type='cms' AND url_data = 'avis-client')

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.040 : 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 = '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'