https://preprod.theatre-contemporain.net/biographies/Cecile-P/biographie/?path=biographies%2FCecile-P%2Fbiographie%2F

Query Metrics

75 Database Queries
59 Different statements
10.84 ms Query time
1 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 0.33 ms
SELECT idperson FROM persons WHERE url_clean='Cecile-P'
Parameters:
[]
2 0.23 ms
SELECT p0_.idperson AS idperson_0, p0_.lastname AS lastname_1, p0_.firstname AS firstname_2, p0_.sexe AS sexe_3, p0_.datestart AS datestart_4, p0_.dateend AS dateend_5, p0_.language AS language_6, p0_.language2 AS language2_7, p0_.email AS email_8, p0_.comment AS comment_9, p0_.cname AS cname_10, p0_.caddress AS caddress_11, p0_.czip AS czip_12, p0_.ccity AS ccity_13, p0_.ccountry AS ccountry_14, p0_.cphone AS cphone_15, p0_.cfax AS cfax_16, p0_.cemail AS cemail_17, p0_.cmobile AS cmobile_18, p0_.url_redirect AS url_redirect_19, p0_.url_clean AS url_clean_20, p0_.url_mav AS url_mav_21, p0_.dateupdate AS dateupdate_22, p0_.dateinsert AS dateinsert_23, p0_.publish AS publish_24, p0_.valid AS valid_25, p0_.idcorvin AS idcorvin_26, p0_.country AS country_27, p0_.idrole AS idrole_28, p0_.idextranetuser AS idextranetuser_29 FROM persons p0_ WHERE p0_.idperson = ?
Parameters:
[
  41248
]
3 0.13 ms
SELECT COUNT(DISTINCT(t.idtext))
                FROM text_author ta, texts t
                WHERE t.idtext=ta.idtext AND t.textfictif=0
                AND ta.idperson=41248 AND t.publish=1 AND t.type IN (0,2)
Parameters:
[]
4 0.06 ms
SELECT COUNT(DISTINCT(tt.idtext)) as total
                FROM text_translator tt, texts t
                WHERE 1
                AND t.idtext=tt.idtext
                AND t.textfictif=0
                AND tt.idperson=41248 AND t.publish=1
Parameters:
[]
5 0.05 ms
SELECT COUNT(DISTINCT(sp.idspectacle)) as total
                FROM spectacle_person sp, spectacles s
                WHERE 1
                AND sp.idspectacle=s.idspectacle
                AND sp.idperson=41248
                AND sp.idrole=1 AND s.publish=1
Parameters:
[]
6 0.05 ms
SELECT fr FROM countries WHERE id='FR'
Parameters:
[]
7 0.05 ms
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
8 0.07 ms
SELECT j1.idcontact,j1.organisation,j1.url_clean,j2.idoffice,j2.date_start,j2.date_end ,j3.idperson FROM theatreok_dev.contacts j1, theatreok_dev.contact_person j2, theatreok_dev.persons j3
                        WHERE j3.idperson=j2.idperson
                        AND j1.idcontact=j2.idcontact
                        AND j3.idperson=41248  AND j2.idoffice=1
Parameters:
[]
9 0.06 ms
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_biotxt'))) AND persons=1
Parameters:
[]
10 0.10 ms
SELECT *
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='41248'
                   AND oc.object='persons'
                   AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_biotxt'))) ORDER BY c.`range`,c.idcontent
Parameters:
[]
11 0.06 ms
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
12 0.09 ms
SELECT *
                FROM object_file of,
                     files f,
                     file_classification fc,
                     classifications cl,typesfiles tf
                   WHERE of.idfile=f.idfile
                   AND f.idfile=fc.idfile
                   AND of.idobject='41248'
                   AND of.object='persons'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_photo_person'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters:
[]
13 0.05 ms
SELECT t.`idtext`
                           FROM text_author ta
                           JOIN texts t ON ta.`idtext`=t.`idtext`
                           WHERE ta.`idperson` IN (41248)
Parameters:
[]
14 0.05 ms
SELECT tad.`idtextadaptation`
                               FROM text_adaptation tad
                               JOIN texts t ON t.`idtext`=tad.`idtext`
                               JOIN text_author ta ON t.`idtext`=ta.`idtext`
                               WHERE ta.`idperson` IN (41248)
Parameters:
[]
15 0.05 ms
SELECT t.`idtext`
                               FROM text_translator tt
                               JOIN texts t ON tt.`idtext`=t.`idtext`
                               WHERE
                               tt.`idperson` IN (41248)
Parameters:
[]
16 0.05 ms
SELECT tt.`idtexttraduction`
                                FROM text_traduction tt
                                JOIN text_author ta ON tt.`idtext`=ta.`idtext`
                                JOIN texts t ON tt.`idtext`=t.`idtext`
                                WHERE ta.`idperson` IN (41248)
Parameters:
[]
17 0.06 ms
SELECT  DISTINCT(multimedias.idmultimedia) 
FROM  `object_multimedia` ,
 `multimedias`  
 WHERE 1 AND object_multimedia.`idrole`=25  AND multimedias.`publish`=1  AND object_multimedia.`object`='persons'  AND object_multimedia.`idobject`=41248 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.dateinsert 
DESC 
LIMIT 0,10
Parameters:
[]
18 0.21 ms
SELECT COUNT(DISTINCT(ct.`idcontent`))
            FROM spectacles s
            JOIN object_content oc ON s.`idspectacle`=oc.`idobject`
            JOIN contents ct ON oc.`idcontent`=ct.`idcontent`
            JOIN content_classification cc ON ct.`idcontent`=cc.`idcontent`
            WHERE s.`publish`=1 AND s.`valid`=1
            AND ct.`publish`=1 AND ct.`valid`=1
            AND cc.`idclassification`=101
            AND s.`idspectacle` IN (10989)
Parameters:
[]
19 0.09 ms
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (206))) AND persons=1
Parameters:
[]
20 0.12 ms
SELECT c.idcontent, c.idextranetuser, c.publish, c.title, c.language, oc.object, oc.idobject, l.fr, cl.classification
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl,languages l
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='41248'
                   AND oc.object='persons'
                   AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.idclassification IN (206))) AND c.language=l.id ORDER BY c.language,cc.idclassification,c.dateinsert
Parameters:
[]
21 0.07 ms
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
22 0.15 ms
SELECT *
                FROM object_file of,
                     files f,
                     file_classification fc,
                     classifications cl,typesfiles tf
                   WHERE of.idfile=f.idfile
                   AND f.idfile=fc.idfile
                   AND of.idobject='41248'
                   AND of.object='persons'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_photo_person'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters:
[]
23 0.07 ms
SELECT t.`idtext`
                           FROM text_author ta
                           JOIN texts t ON ta.`idtext`=t.`idtext`
                           WHERE ta.`idperson` IN (41248)
Parameters:
[]
24 0.07 ms
SELECT tad.`idtextadaptation`
                               FROM text_adaptation tad
                               JOIN texts t ON t.`idtext`=tad.`idtext`
                               JOIN text_author ta ON t.`idtext`=ta.`idtext`
                               WHERE ta.`idperson` IN (41248)
Parameters:
[]
25 0.07 ms
SELECT t.`idtext`
                               FROM text_translator tt
                               JOIN texts t ON tt.`idtext`=t.`idtext`
                               WHERE
                               tt.`idperson` IN (41248)
Parameters:
[]
26 0.07 ms
SELECT tt.`idtexttraduction`
                                FROM text_traduction tt
                                JOIN text_author ta ON tt.`idtext`=ta.`idtext`
                                JOIN texts t ON tt.`idtext`=t.`idtext`
                                WHERE ta.`idperson` IN (41248)
Parameters:
[]
27 0.08 ms
SELECT  DISTINCT(multimedias.idmultimedia) 
FROM  `object_multimedia` ,
 `multimedias`  
 WHERE 1 AND object_multimedia.`idrole`=25  AND multimedias.`publish`=1  AND object_multimedia.`object`='persons'  AND object_multimedia.`idobject`=41248 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.dateinsert 
DESC 
LIMIT 0,10
Parameters:
[]
28 0.11 ms
SELECT  COUNT(DISTINCT(`schedules`.`idspectacle`)) as total , MIN(schedules.date) AS datemin,MAX(schedules.date) AS datemax 
FROM  `schedules`  
 WHERE 1  AND schedules.`idspectacle` IN (10989)   AND schedules.`publish`=1 
 HAVING 1  AND MIN(schedules.`date`) >='2024-03-10' 
LIMIT 0,10
Parameters:
[]
29 0.69 ms
SELECT  DISTINCT(schedules.idschedule), MIN(schedules.date) AS datemin,MAX(schedules.date) AS datemax,schedules.* 
FROM  `schedules`  
 WHERE 1  AND schedules.`idspectacle` IN (10989)   AND schedules.`publish`=1 
 GROUP BY schedules.`idspectacle` 
 HAVING 1  AND MIN(schedules.`date`) >='2024-03-10' 
ORDER BY datemin ASC,datemax 
DESC 
LIMIT 0,3
Parameters:
[]
30 0.13 ms
SELECT DISTINCT(T1.idnew), T1.*,T2.idextranetuser,T2.lastname,T2.firstname,T2.signature,T2.city as city_extranetuser,T2.enseignant_etablissement,T2.enseignant_active,T3.idnewschedule,T3.date,T3.hour,T3.idcontact,T3.note  FROM news T1 INNER JOIN newschedules T3
                            ON T3.idnew=T1.idnew
                            INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser
                            LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact  LEFT JOIN new_person T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idperson=41248 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND T1.type_news=0 AND (( T3.date>='2024-03-10' ))  GROUP BY T1.idnew  ORDER BY T3.date DESC LIMIT 0,7
Parameters:
[]
31 0.11 ms
SELECT DISTINCT(T1.idnew), T1.*,T2.idextranetuser,T2.lastname,T2.firstname,T2.signature,T2.city as city_extranetuser,T2.enseignant_etablissement,T2.enseignant_active,T3.idnewschedule,T3.date,T3.hour,T3.idcontact,T3.note  FROM news T1 INNER JOIN newschedules T3
                            ON T3.idnew=T1.idnew
                            INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser
                            LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact  LEFT JOIN new_person T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idperson=41248 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND T1.type_news=0 AND (( T3.date<'2024-03-10' ))  GROUP BY T1.idnew  ORDER BY T3.date DESC LIMIT 0,3
Parameters:
[]
32 0.21 ms
SELECT  DISTINCT(playlists.idplaylist), playlists.* 
FROM  `playlist_classification` ,
 `playlists`  
 WHERE 1  AND playlists.`publish`=1  AND playlists.`idtext` IN ('')  AND playlist_classification.`idclassification`=144 AND playlists.`idplaylist`=playlist_classification.`idplaylist` 
GROUP BY playlists.idplaylist 
ORDER BY playlists.dateinsert 
DESC 
LIMIT 0,2
Parameters:
[]
33 0.10 ms
SELECT  DISTINCT(playlists.idplaylist), playlists.* 
FROM  `playlist_classification` ,
 `playlists`  
 WHERE 1  AND playlists.`publish`=1  AND playlists.`idtext` IN ('')  AND playlist_classification.`idclassification`=144 AND playlists.`idplaylist`=playlist_classification.`idplaylist` 
GROUP BY playlists.idplaylist 
ORDER BY playlists.dateinsert 
DESC 
LIMIT 0,2
Parameters:
[]
34 0.12 ms
SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson` IN (41248)  AND podcasts.`code_ft` IS NOT NULL AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_person.`idpodcast` 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,1
Parameters:
[]
35 0.10 ms
SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson` IN (41248)  AND podcasts.`code_ft` IS NOT NULL  AND podcasts.`type_diffusion`=1 AND podcasts.`idpodcast`=podcast_person.`idpodcast` 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,1
Parameters:
[]
36 0.09 ms
SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson` IN (41248)  AND podcasts.`code_ft` IS NOT NULL  AND podcasts.`type_diffusion`=2 AND podcasts.`idpodcast`=podcast_person.`idpodcast` 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,1
Parameters:
[]
37 0.08 ms
SELECT DISTINCT(s.idschedule),hour,date,s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,s.idspectacle,
                    c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,
                    ft.idcontact as festival_idcontact,ft.organisation as festival_organisation,ft.city as festival_city,ft.url_clean as festival_url_clean
                    FROM schedules s
                    JOIN contacts c ON s.idcontact=c.idcontact
                    LEFT JOIN contacts ft ON s.idcontact_festival=ft.idcontact
                    WHERE 1 AND s.idspectacle IN (10989) AND s.date>='2024-03-10' ORDER BY s.date ASC LIMIT 0,3
Parameters:
[]
38 0.10 ms
SELECT DISTINCT(m.idmultimedia),m.*
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=41248
                AND om.object='persons'
                AND m.publish=1 ORDER BY m.date DESC LIMIT 0, 4
Parameters:
[]
39 0.07 ms
SELECT DISTINCT(t.idtext),t.title,t.url_clean,c.organisation,
                     c.url_clean as url_clean_publisher, c.country as publisher_country,
		             CONCAT_WS('-',t.publication_year,t.publication_month,'01') as datepublication,
		             t.publication_month,t.publication_year,t.date as datewrite,t.textorder
		    FROM texts t, contacts c, text_author ta
		    WHERE 1
		    AND ta.idtext=t.idtext
		    AND c.idcontact=t.idcontact_publisher
		    AND ta.idperson=41248
		    AND t.type=0
		    AND t.publish=1 ORDER BY datepublication DESC LIMIT 0,2
Parameters:
[]
40 0.07 ms
SELECT DISTINCT(t.idtext),t.title,t.url_clean,c.organisation,
                     c.url_clean as url_clean_publisher, c.country as publisher_country,
		             CONCAT_WS('-',t.publication_year,t.publication_month,'01') as datepublication,
		             t.publication_month,t.publication_year,t.date as datewrite,t.textorder, t.type
		    FROM text_traduction tt, texts t
		    LEFT OUTER JOIN contacts c ON c.idcontact=t.idcontact_publisher
		    WHERE 1
		    AND tt.idtexttraduction=t.idtext
            AND t.publish=1
		    AND tt.idtext IN (
                SELECT idtext
                FROM text_author
                WHERE idperson=41248
                )
		    ORDER BY datepublication DESC LIMIT 0,2
Parameters:
[]
41 0.07 ms
SELECT DISTINCT(t.idtext),t.title,t.url_clean,c.organisation,
                     c.url_clean as url_clean_publisher, c.country as publisher_country,
		             CONCAT_WS('-',t.publication_year,t.publication_month,'01') as datepublication,
		             t.publication_month,t.publication_year,t.date as datewrite,t.textorder, t.type
		    FROM text_translator tt, texts t
		    LEFT OUTER JOIN contacts c ON c.idcontact=t.idcontact_publisher
		    WHERE 1
		    AND tt.idtext=t.idtext
            AND t.publish=1
		    AND tt.idperson=41248
		    ORDER BY datepublication DESC LIMIT 0,2
Parameters:
[]
42 0.06 ms
SELECT t.`idtext`
                           FROM text_author ta
                           JOIN texts t ON ta.`idtext`=t.`idtext`
                           WHERE ta.`idperson` IN (41248)
Parameters:
[]
43 0.06 ms
SELECT tad.`idtextadaptation`
                               FROM text_adaptation tad
                               JOIN texts t ON t.`idtext`=tad.`idtext`
                               JOIN text_author ta ON t.`idtext`=ta.`idtext`
                               WHERE ta.`idperson` IN (41248)
Parameters:
[]
44 0.06 ms
SELECT t.`idtext`
                               FROM text_translator tt
                               JOIN texts t ON tt.`idtext`=t.`idtext`
                               WHERE
                               tt.`idperson` IN (41248)
Parameters:
[]
45 0.06 ms
SELECT tt.`idtexttraduction`
                                FROM text_traduction tt
                                JOIN text_author ta ON tt.`idtext`=ta.`idtext`
                                JOIN texts t ON tt.`idtext`=t.`idtext`
                                WHERE ta.`idperson` IN (41248)
Parameters:
[]
46 0.08 ms
SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson`=41248  AND ( `podcasts`.`code_franceinter` IS NOT NULL  OR `podcasts`.`code_soundcloud` IS NOT NULL ) AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_person.`idpodcast` 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,1
Parameters:
[]
47 0.07 ms
SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson`=41248  AND ( `podcasts`.`code_franceinter` IS NOT NULL  OR `podcasts`.`code_soundcloud` IS NOT NULL ) AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_person.`idpodcast` 
LIMIT 0,1
Parameters:
[]
48 0.07 ms
SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcasts.`code_arte` IS NOT NULL AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,1
Parameters:
[]
49 0.06 ms
SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcasts.`code_arte` IS NOT NULL AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) 
LIMIT 0,1
Parameters:
[]
50 0.08 ms
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters:
[
  4
]
51 0.16 ms
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
  14429
]
52 0.31 ms
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=14429  ORDER BY j2.classement ASC
Parameters:
[]
53 0.20 ms
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
                        lt.`fr`,
                        r.`idrole`, r.`role`, r.`type`,
                        sp.`comment`,sp.`date_start`,sp.`date_end`
                        FROM persons p
                            JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
                            JOIN roles r ON r.`idrole`=sp.`idrole`
                            JOIN langterms lt ON r.`role`=lt.`id`
                        WHERE sp.idspectacle=10989  ORDER BY p.`lastname`
Parameters:
[]
54 0.40 ms
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters:
[
  10989
  "2024-03-10"
]
55 0.07 ms
SELECT sp.idrole,r.role_male,r.role_female,lg.fr
            FROM spectacle_person sp, roles r, langterms lg
            WHERE 1
            AND sp.idrole=r.idrole
            AND r.role=lg.id
            AND sp.idspectacle=10989
            AND sp.idperson=41248
Parameters:
[]
56 0.16 ms
SELECT person_ecole.*, contacts.`organisation`, contacts.`url_clean` 
                FROM person_ecole 
                    JOIN contacts ON contacts.`idcontact`=person_ecole.`idcontact` 
                WHERE  person_ecole.`idperson`=41248 AND contacts.`idcontact`!=3914
Parameters:
[]
57 0.09 ms
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total
                FROM playlists p
                    LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist`
                    LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification`
                WHERE p.`publish`=1
                AND p.`idperson` IN (41248)  AND c.`classification`='class_auteur_meme'
Parameters:
[]
58 0.09 ms
SELECT  DISTINCT(dvds.iddvd), dvds.* 
FROM  `dvd_spectacle` ,
 `dvds`  
 WHERE 1  AND dvds.`publish`=1  AND dvd_spectacle.`idspectacle` IN (10989) AND dvds.`iddvd`=dvd_spectacle.`iddvd` 
GROUP BY dvds.iddvd 
ORDER BY dvds.dateinsert 
DESC 
LIMIT 0,1
Parameters:
[]
59 0.07 ms
SELECT  DISTINCT(dvds.iddvd), dvds.* 
FROM  `dvd_spectacle` ,
 `dvds`  
 WHERE 1  AND dvds.`publish`=1  AND dvd_spectacle.`idspectacle` IN (10989) AND dvds.`iddvd`=dvd_spectacle.`iddvd` 
GROUP BY dvds.iddvd 
ORDER BY dvds.dateinsert 
DESC 
LIMIT 0,1
Parameters:
[]
60 0.06 ms
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (6))) AND persons=1
Parameters:
[]
61 0.07 ms
SELECT COUNT(DISTINCT(oc.idcontent)) as total
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='41248'
                   AND oc.object='persons'
                   AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.idclassification IN (6)))
Parameters:
[]
62 0.06 ms
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total
                FROM playlists p
                    LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist`
                    LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification`
                WHERE p.`publish`=1
                AND p.`idperson` IN (41248)  AND c.`classification`='class_auteur_meme'
Parameters:
[]
63 0.08 ms
SELECT DISTINCT(s.idschedule),hour,date,s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,s.idspectacle,
                    c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,
                    ft.idcontact as festival_idcontact,ft.organisation as festival_organisation,ft.city as festival_city,ft.url_clean as festival_url_clean
                    FROM schedules s
                    JOIN contacts c ON s.idcontact=c.idcontact
                    LEFT JOIN contacts ft ON s.idcontact_festival=ft.idcontact
                    WHERE 1 AND s.idspectacle IN (10989) AND s.date>='2024-03-10' ORDER BY s.date ASC LIMIT 0,1
Parameters:
[]
64 0.06 ms
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_biotextes'))) AND persons=1
Parameters:
[]
65 0.07 ms
SELECT COUNT(DISTINCT(oc.idcontent)) as total
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='41248'
                   AND oc.object='persons'
                   AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_biotextes')))
Parameters:
[]
66 0.06 ms
SELECT COUNT(DISTINCT(T1.idnew)) as total  FROM news T1 INNER JOIN newschedules T3
                            ON T3.idnew=T1.idnew
                            INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser
                            LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact  LEFT JOIN new_person T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idperson=41248 ) AND T1.publish=1
Parameters:
[]
67 0.05 ms
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=41248
                AND om.object='persons'
                AND m.publish=1
Parameters:
[]
68 0.06 ms
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_person do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idperson`=41248 AND d.code_franceinter IS NOT NULL
Parameters:
[]
69 0.05 ms
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_person do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idperson`=41248 AND d.code_soundcloud IS NOT NULL
Parameters:
[]
70 0.12 ms
SELECT  DISTINCT(multimedias.idmultimedia), multimedias.*,spectacles.`idspectacle`,schedules.`idcontact` 
FROM  `object_multimedia` ,
 `schedules` ,
 `spectacles` ,
 `contacts` ,
 `multimedias` ,
 `multimedia_classification`  
 WHERE 1  AND multimedias.`publish`=1  AND object_multimedia.`object`='spectacles'  AND object_multimedia.`idrole` IS NULL  AND schedules.`date` BETWEEN '1999-01-01' AND '2030-01-01'   AND object_multimedia.`object`='spectacles'  AND object_multimedia.`idobject` IN (10989)  AND multimedia_classification.`idclassification`=145 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` AND schedules.`idspectacle`=spectacles.`idspectacle` AND spectacles.`idspectacle`=object_multimedia.`idobject` AND contacts.`idcontact`=schedules.`idcontact` AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` AND multimedias.`idmultimedia`=multimedia_classification.`idmultimedia` 
 GROUP BY object_multimedia.`idobject` 
ORDER BY schedules.`date` 
ASC 
LIMIT 0,100
Parameters:
[]
71 1.22 ms
SELECT t0.idstat AS idstat_1, t0.type AS type_2, t0.module AS module_3, t0.url AS url_4, t0.idcontent AS idcontent_5, t0.object AS object_6, t0.idobject AS idobject_7, t0.video AS video_8, t0.remote_addr AS remote_addr_9, t0.lng AS lng_10, t0.source AS source_11, t0.md5url AS md5url_12, t0.dateinsert AS dateinsert_13 FROM stats t0 WHERE t0.remote_addr = ? AND t0.idcontent = ? AND t0.md5url = ?
Parameters:
[
  "d0926e8a13e1b1e80e0b2ce1f1deb234-c2a1"
  0
  "917d75b5e4ea7f16bbf4417bf6069c5d"
]
72 1.27 ms
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "article"
  "thnet"
  "/biographies/Cecile-P/biographie/"
  "917d75b5e4ea7f16bbf4417bf6069c5d"
  0
  "persons"
  41248
  0
  "fr"
  "d0926e8a13e1b1e80e0b2ce1f1deb234-c2a1"
  "/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553"
]
73 0.06 ms
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
74 0.06 ms
SELECT *
                FROM object_file of,
                     files f,
                     file_classification fc,
                     classifications cl,typesfiles tf
                   WHERE of.idfile=f.idfile
                   AND f.idfile=fc.idfile
                   AND of.idobject='41248'
                   AND of.object='persons'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_photo_person'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters:
[]
75 0.76 ms
SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_bottom=1
                AND date_start<=NOW()
                AND date_end>=NOW()
                ORDER BY bannieres.order ASC
                LIMIT 0,10
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Entities Mapping

Class Mapping errors
TheatreCore\Entity\Extranetusers No errors.
TheatreCore\Entity\Persons No errors.
TheatreCore\Entity\Contents No errors.
TheatreCore\Entity\Multimedias No errors.
TheatreCore\Entity\Countries No errors.
TheatreCore\Entity\Roles No errors.
TheatreCore\Entity\News No errors.
TheatreCore\Entity\Classifications No errors.
TheatreCore\Entity\Contacts No errors.
TheatreCore\Entity\Podcasts No errors.
TheatreCore\Entity\Spectacles No errors.
TheatreCore\Entity\Texts No errors.
TheatreCore\Entity\Files No errors.
TheatreCore\Entity\ObjectMultimedia No errors.
TheatreCore\Entity\Schedules No errors.
TheatreCore\Entity\Playlists No errors.
TheatreCore\Entity\Typesspectacles No errors.
TheatreCore\Entity\PersonEcole
  • The referenced column name 'idcontact' has to be a primary key column on the target entity class 'TheatreCore\Entity\PersonEcole'.
  • The referenced column name 'idcontact' has to be a primary key column on the target entity class 'TheatreCore\Entity\PersonEcole'.
TheatreCore\Entity\Dvds No errors.
TheatreCore\Entity\ObjectContent No errors.
TheatreCore\Entity\BookmarkExtranetuser No errors.
TheatreCore\Entity\Stats No errors.
TheatreCore\Entity\Abonnements No errors.
TheatreCore\Entity\Bannieres No errors.