ATELIER FLORENTIN (THÉÂTRE DE L')

0.000 : Connexion BDD sur foa-bdmaster:festival_off_avignon

0.001 : Connexion BDD sur foa-bdslave:festival_off_avignon

0.000 : 46 : SELECT * FROM registry

0.000 : 1 : SELECT traduction FROM i18n_seo WHERE hash = '1203ceac2586a9ca1a3a7e7f2f9b673c' AND lang = 'fr' AND page = 'Théâtre'

0.000 : 1 : SELECT traduction FROM i18n_seo WHERE hash = '41d77b6c2008318e3d489c47191de79e' AND lang = 'fr' AND page = 'Théâtre'

0.000 : 1 : SELECT * FROM foa_theatre WHERE the_id = '30'

0.000 : 1 : SELECT thi_id as id,thi_original_filename as original_filename,thi_filename as filename,thi_type_file as type, thi_dateCreation as dateCreation FROM foa_theatre_image WHERE thi_idTheatre = '30' AND thi_type_file = '1'

0.001 : 1 : SELECT lie_id as id, lie_nom as nom, the_nom as theatre, lie_fiche_technique_filename, lie_salle_label_off as salle_label_off, lim.lim_filename as image_filename, description.pim_value as description_lieu, creneau.pim_value as creneau_disponible, plein_air.pim_value as plein_air, chapiteau.pim_value as chapiteau, jauge.pim_value as jauge, adresse_salle.adr_ville as ville_salle, adresse_theatre.adr_ville as ville_theatre FROM foa_lieu LEFT JOIN foa_theatre ON the_id = lie_idTheatre LEFT JOIN foa_adresse AS adresse_salle ON lie_idAdresse = adresse_salle.adr_id LEFT JOIN foa_adresse AS adresse_theatre ON the_idAdresse = adresse_theatre.adr_id LEFT JOIN foa_lieu_image lim ON lim.lim_idLieu = lie_id AND lim.lim_dateDelete IS NULL AND lim.lim_ordre = (SELECT MIN(lim_ordre) FROM foa_lieu_image WHERE lim_idLieu = lie_id AND lim_dateDelete IS NULL) LEFT JOIN foa_pim description ON description.pim_idLieu = lie_id AND description.pim_idFeature = (SELECT fea_id FROM foa_pim_feature WHERE fea_solr_field = 'description_lieu') LEFT JOIN foa_pim creneau ON creneau.pim_idLieu = lie_id AND creneau.pim_idFeature = (SELECT fea_id FROM foa_pim_feature WHERE fea_solr_field = 'creneau_disponible') LEFT JOIN foa_pim plein_air ON plein_air.pim_idLieu = lie_id AND plein_air.pim_idFeature = (SELECT fea_id FROM foa_pim_feature WHERE fea_solr_field = 'plein_air') LEFT JOIN foa_pim chapiteau ON chapiteau.pim_idLieu = lie_id AND chapiteau.pim_idFeature = (SELECT fea_id FROM foa_pim_feature WHERE fea_solr_field = 'chapiteau') LEFT JOIN foa_pim jauge ON jauge.pim_idLieu = lie_id AND jauge.pim_idFeature = (SELECT fea_id FROM foa_pim_feature WHERE fea_solr_field = 'jauge') WHERE lie_inactif = 0 AND lie_dateDelete IS NULL AND lie_idTheatre = '30' ORDER BY lie_nom, lie_id

0.000 : 1 : SELECT * FROM foa_festival WHERE fes_inactif = 0 AND fes_dateDelete is null ORDER BY fes_dateCreation DESC LIMIT 1

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

0.000 : 1 : SELECT * FROM cms_bribes LEFT JOIN cms_bribes_lang ON (lbribe_id = bribe_id AND lang = 'fr') WHERE bribe_code = 'seo-home' AND bribe_etat = 'VAL'

0.001 : 75 : SELECT md.id_menu_detail ,md.id_parent ,md.url_type, md.url_data, mdl.lnom_rubrique, md.nom_rubrique, md.class, md.onclick, md.target, md.icone FROM menus m LEFT JOIN menus_details md ON (md.id_menu = m.id_menu) LEFT JOIN menus_details_lang mdl ON (mdl.lid_menu_detail=md.id_menu_detail AND mdl.lang='fr') WHERE m.code = 'navigation' AND md.actif = 1 ORDER BY ordre_rubrique ASC

0.001 : 95 : SELECT * FROM cms

0.001 : 13 : SELECT md.id_menu_detail ,md.id_parent ,md.url_type, md.url_data, mdl.lnom_rubrique, md.nom_rubrique, md.class, md.onclick, md.target, md.icone FROM menus m LEFT JOIN menus_details md ON (md.id_menu = m.id_menu) LEFT JOIN menus_details_lang mdl ON (mdl.lid_menu_detail=md.id_menu_detail AND mdl.lang='fr') WHERE m.code = 'footer' AND md.actif = 1 ORDER BY ordre_rubrique ASC

0.001 : 4 : SELECT md.id_menu_detail ,md.id_parent ,md.url_type, md.url_data, mdl.lnom_rubrique, md.nom_rubrique, md.class, md.onclick, md.target, md.icone FROM menus m LEFT JOIN menus_details md ON (md.id_menu = m.id_menu) LEFT JOIN menus_details_lang mdl ON (mdl.lid_menu_detail=md.id_menu_detail AND mdl.lang='fr') WHERE m.code = 'acces' AND md.actif = 1 ORDER BY ordre_rubrique ASC

0.001 : 9 : SELECT * FROM rgpd_cookies LEFT JOIN rgpd_cookies_lang lrgpdc ON (rgpdc_code = lrgpdc.lrgpdc_code AND lrgpdc.lang = 'fr') LEFT JOIN rgpd_cookies_details ON (rgpdc_code = rcd_lrgpdc_code) LEFT JOIN rgpd_cookies_details_lang lrcd ON (rcd_id = lrcd.lrcd_id AND lrcd.lang = 'fr') WHERE rgpdc_active = 1 ORDER BY rgpdc_code ASC

0.000 : 1 : SELECT * FROM rgpd_cookies_parametres LEFT JOIN rgpd_cookies_parametres_lang ON (lrcp_id = rcp_id AND lang = 'fr')

0.000 : 1 : SELECT * FROM tracking_analytics WHERE trk_actif = 1