Espace collaborateur

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 = 'spa-reference' 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 = '92'

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

0.001 : 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 = '92'

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 = '92') 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 = '92'

0.000 : 59 : SELECT * FROM mag_pdv_registry WHERE pdvr_pdv_id = 92

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

0.000 : 0 : SELECT * FROM personnel WHERE pers_id = '' AND pers_espace_collaborateur_actif = 1 AND pers_pdv_id = '92'

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

0.000 : 0 : SELECT * FROM cms_bribes LEFT JOIN cms_bribes_lang ON (lbribe_id = bribe_id AND lang = '') WHERE bribe_code = 'connexion_guest' AND bribe_etat = 'VAL'

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

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

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

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

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

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 = '92'

0.001 : 9 : 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 = '92') WHERE mp_actif_pos = 1

0.001 : 1 : SELECT * FROM mag_pdv_theme_images JOIN banque_images ON (pdvti_bimg_id = bimg_id) WHERE pdvti_pdv_id = '92'

0.005 : 28 : SELECT * FROM cat_rubriques LEFT JOIN cat_rubriques_lang ON (lrub_id = rub_id AND lang = '') WHERE rub_pdv_id = '92' 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 = '92'

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 = '92') 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 = '92'

0.004 : 24 : 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 = '92' ) 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 = '92' )

0.057 : 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 = '3471'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3471'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '5110'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3474'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3474'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3490'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3474'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3489'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3473'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3473'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3476'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3473'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3483'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3472'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3472'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3477'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3472'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3478'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3472'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3524'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3475'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3475'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3496'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3479'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3479'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3500'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3479'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3501'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3481'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3481'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3502'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3481'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3503'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3482'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3482'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3519'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3482'

0.000 : 1 : SELECT rub_libelle FROM cat_rubriques WHERE rub_id = '3513'

0.000 : 1 : SELECT * FROM menus WHERE code='navigation' AND pdv_id ='92'

0.001 : 10 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='') WHERE id_menu='193' 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='1986' 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='1987' 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='1988' 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='1989' 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='1990' 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='1992' 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='1993' 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='') WHERE id_parent='1994' 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='1995' 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='1996' AND actif=1 ORDER BY ordre_rubrique ASC

0.000 : 1 : SELECT * FROM menus WHERE code='footer' AND pdv_id ='92'

0.001 : 5 : SELECT * FROM menus_details LEFT JOIN menus_details_lang ON (lid_menu_detail=id_menu_detail AND lang='') WHERE id_menu='194' 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='3205' 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='1980' 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='1981' 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='1982' 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='1983' AND actif=1 ORDER BY ordre_rubrique ASC

0.000 : 0 : SELECT * FROM menus WHERE code='prefooter' AND pdv_id ='92'

0.000 : 1 : SELECT * FROM sliders WHERE sli_code = 'univers-slider' AND sli_pdv_id = '92'

0.000 : 0 : SELECT * FROM sliders_images LEFT JOIN sliders_images_lang ON (lsli_img_id = sli_img_id AND lang = '') WHERE sli_id = '215' AND sli_img_active = 1 ORDER BY sli_img_ordre

0.000 : 0 : SELECT * FROM sliders WHERE sli_code = 'sliderSoins' AND sli_pdv_id = '92'

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 = '92' 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 = '92'

0.000 : 0 : SELECT * FROM tracking_analytics WHERE trk_actif = 1 AND trk_pdv_id = '92'