Query Metrics
68
Database Queries
63
Different statements
737.53 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.21 ms |
SELECT idperson FROM persons WHERE url_clean='Jon-Fosse'
Parameters:
[]
|
||||||||||||||||||||||||||||||
2 | 0.33 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:
[
75
]
|
||||||||||||||||||||||||||||||
3 | 0.65 ms |
SELECT COUNT(DISTINCT(t.idtext)) FROM text_author ta, texts t WHERE t.idtext=ta.idtext AND t.textfictif=0 AND ta.idperson=75 AND t.publish=1 AND t.type IN (0,2)
Parameters:
[]
|
||||||||||||||||||||||||||||||
4 | 0.26 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=75 AND t.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
5 | 0.42 ms |
SELECT COUNT(DISTINCT(sp.idspectacle)) as total FROM spectacle_person sp, spectacles s WHERE 1 AND sp.idspectacle=s.idspectacle AND sp.idperson=75 AND sp.idrole=1 AND s.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
6 | 0.64 ms |
SELECT fr FROM countries WHERE id='NO'
Parameters:
[]
|
||||||||||||||||||||||||||||||
7 | 0.14 ms |
SELECT fr FROM languages WHERE id='no'
Parameters:
[]
|
||||||||||||||||||||||||||||||
8 | 0.38 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=75 AND j2.idoffice=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
9 | 0.07 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_biotxt'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
10 | 1.59 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='75' 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.56 ms |
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3 WHERE j3.idcontent=j2.idcontent AND j1.idclassification=j2.idclassification AND j3.idcontent=35
Parameters:
[]
|
||||||||||||||||||||||||||||||
12 | 0.06 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
13 | 1.18 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='75' 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:
[]
|
||||||||||||||||||||||||||||||
14 | 0.53 ms |
SELECT t.`idtext` FROM text_author ta JOIN texts t ON ta.`idtext`=t.`idtext` WHERE ta.`idperson` IN (75)
Parameters:
[]
|
||||||||||||||||||||||||||||||
15 | 0.82 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 (75)
Parameters:
[]
|
||||||||||||||||||||||||||||||
16 | 0.29 ms |
SELECT t.`idtext` FROM text_translator tt JOIN texts t ON tt.`idtext`=t.`idtext` WHERE tt.`idperson` IN (75)
Parameters:
[]
|
||||||||||||||||||||||||||||||
17 | 0.66 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 (75)
Parameters:
[]
|
||||||||||||||||||||||||||||||
18 | 681.68 ms |
SELECT s.`idspectacle` FROM spectacles s LEFT JOIN spectacle_person sp ON sp.`idspectacle`=s.`idspectacle` LEFT JOIN text_spectacle ts ON ts.`idspectacle`=s.`idspectacle` WHERE s.`publish`=1 AND s.`valid`=1 AND (sp.`idperson`=75 OR ts.`idtext` IN (287,294,296,298,300,303,305,1567,1647,2007,2032,2197,3064,3208,3412,5316,5352,5465,5467,6721,6722,6790,6792,6887,7022,7280,8825,10628,34609,35088,36498,36499,38543,40878,13981,6889,30086,8221,6889,23589,6889,6889,10630,292,12136,295,2028,297,299,301,22278,304,1648,2008,2033,2202,3066,3209,3413,5317,5353,5466,5468,6723,6724,6791,7304,6793,6888,7023,7281,8826,10629,34610,36500,36501,38544) )
Parameters:
[]
|
||||||||||||||||||||||||||||||
19 | 0.49 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`=75 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` GROUP BY multimedias.idmultimedia ORDER BY multimedias.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||
20 | 3.27 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 (1192,1266,1569,1587,1588,1589,1590,1591,1593,1594,1736,1926,2042,2475,2532,2628,2798,3058,3060,3538,3765,3831,3858,3885,3890,3891,3892,3963,4105,4159,4455,4528,4543,4656,4827,4928,4948,5089,5196,5418,5492,5862,7051,7342,7431,7514,7520,8120,8845,9532,10052,10473,10568,11349,12254,13638,14552,15040,17714,18726,18872,20782,21857,22742,23855,24099,27259,30999,31209,31616,32369,34749,35281,35455,36080)
Parameters:
[]
|
||||||||||||||||||||||||||||||
21 | 1.39 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=75 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=0 AND (( T3.date>='2024-04-28' )) GROUP BY T1.idnew ORDER BY T3.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||
22 | 2.16 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=75 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=0 AND (( T3.date<'2024-04-28' )) GROUP BY T1.idnew ORDER BY T3.date DESC LIMIT 0,3
Parameters:
[]
|
||||||||||||||||||||||||||||||
23 | 0.28 ms |
SELECT t0.idnew AS idnew_1, t0.title AS title_2, t0.type_news AS type_news_3, t0.description AS description_4, t0.markdown AS markdown_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.hour AS hour_8, t0.location AS location_9, t0.city AS city_10, t0.zip AS zip_11, t0.contacts AS contacts_12, t0.url AS url_13, t0.url_more AS url_more_14, t0.infos_contacts AS infos_contacts_15, t0.url_file AS url_file_16, t0.copyright_file AS copyright_file_17, t0.is_homepage AS is_homepage_18, t0.publish AS publish_19, t0.valid AS valid_20, t0.statut AS statut_21, t0.dateinsert AS dateinsert_22, t0.dateupdate AS dateupdate_23, t0.idextranetuser_lock AS idextranetuser_lock_24, t0.idextranetuser AS idextranetuser_25, t0.idregion AS idregion_26, t0.country AS country_27 FROM news t0 WHERE t0.idnew = ?
Parameters:
[
"11857"
]
|
||||||||||||||||||||||||||||||
24 | 0.38 ms |
SELECT url_file FROM news WHERE idnew=11857
Parameters:
[]
|
||||||||||||||||||||||||||||||
25 | 0.39 ms |
SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c WHERE sc.idcontact=c.idcontact AND sc.idnew=11857 AND sc.date<'2024-04-28' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||
26 | 0.31 ms |
SELECT MIN(sc.date) as datestart, MAX(sc.date) as dateend, c.city, c.country FROM newschedules sc, contacts c WHERE sc.idcontact=c.idcontact AND sc.idnew=11857 AND sc.date<'2024-04-28' AND sc.idcontact=3967 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||
27 | 0.25 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idnew FROM theatreok_dev.persons j1, theatreok_dev.new_person j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idperson=j2.idperson AND j3.idnew=11857
Parameters:
[]
|
||||||||||||||||||||||||||||||
28 | 0.33 ms |
SELECT j1.idcontact,j1.lastname,j1.firstname,j1.organisation,j1.type,j1.url_clean ,j3.idnew FROM theatreok_dev.contacts j1, theatreok_dev.new_contact j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idcontact=j2.idcontact AND j3.idnew=11857
Parameters:
[]
|
||||||||||||||||||||||||||||||
29 | 0.26 ms |
SELECT j1.idspectacle,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.spectacles j1, theatreok_dev.new_spectacle j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idspectacle=j2.idspectacle AND j3.idnew=11857
Parameters:
[]
|
||||||||||||||||||||||||||||||
30 | 0.22 ms |
SELECT j1.idtext,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.texts j1, theatreok_dev.new_text j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idtext=j2.idtext AND j3.idnew=11857
Parameters:
[]
|
||||||||||||||||||||||||||||||
31 | 0.33 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
295
]
|
||||||||||||||||||||||||||||||
32 | 0.28 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=295 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||
33 | 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=294 ORDER BY j2.classement ASC
Parameters:
[] |
||||||||||||||||||||||||||||||
34 | 0.15 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
5013
]
|
||||||||||||||||||||||||||||||
35 | 0.24 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=5013 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||
36 | 0.33 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=5012 ORDER BY j2.classement ASC
Parameters:
[] |
||||||||||||||||||||||||||||||
37 | 0.36 ms |
SELECT t0.idnew AS idnew_1, t0.title AS title_2, t0.type_news AS type_news_3, t0.description AS description_4, t0.markdown AS markdown_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.hour AS hour_8, t0.location AS location_9, t0.city AS city_10, t0.zip AS zip_11, t0.contacts AS contacts_12, t0.url AS url_13, t0.url_more AS url_more_14, t0.infos_contacts AS infos_contacts_15, t0.url_file AS url_file_16, t0.copyright_file AS copyright_file_17, t0.is_homepage AS is_homepage_18, t0.publish AS publish_19, t0.valid AS valid_20, t0.statut AS statut_21, t0.dateinsert AS dateinsert_22, t0.dateupdate AS dateupdate_23, t0.idextranetuser_lock AS idextranetuser_lock_24, t0.idextranetuser AS idextranetuser_25, t0.idregion AS idregion_26, t0.country AS country_27 FROM news t0 WHERE t0.idnew = ?
Parameters:
[
"8136"
]
|
||||||||||||||||||||||||||||||
38 | 0.12 ms |
SELECT url_file FROM news WHERE idnew=8136
Parameters:
[]
|
||||||||||||||||||||||||||||||
39 | 0.32 ms |
SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c WHERE sc.idcontact=c.idcontact AND sc.idnew=8136 AND sc.date<'2024-04-28' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||
40 | 0.60 ms |
SELECT MIN(sc.date) as datestart, MAX(sc.date) as dateend, c.city, c.country FROM newschedules sc, contacts c WHERE sc.idcontact=c.idcontact AND sc.idnew=8136 AND sc.date<'2024-04-28' AND sc.idcontact=2469 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||
41 | 0.34 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idnew FROM theatreok_dev.persons j1, theatreok_dev.new_person j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idperson=j2.idperson AND j3.idnew=8136
Parameters:
[]
|
||||||||||||||||||||||||||||||
42 | 0.25 ms |
SELECT j1.idcontact,j1.lastname,j1.firstname,j1.organisation,j1.type,j1.url_clean ,j3.idnew FROM theatreok_dev.contacts j1, theatreok_dev.new_contact j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idcontact=j2.idcontact AND j3.idnew=8136
Parameters:
[]
|
||||||||||||||||||||||||||||||
43 | 0.18 ms |
SELECT j1.idspectacle,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.spectacles j1, theatreok_dev.new_spectacle j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idspectacle=j2.idspectacle AND j3.idnew=8136
Parameters:
[]
|
||||||||||||||||||||||||||||||
44 | 0.16 ms |
SELECT j1.idtext,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.texts j1, theatreok_dev.new_text j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idtext=j2.idtext AND j3.idnew=8136
Parameters:
[]
|
||||||||||||||||||||||||||||||
45 | 0.21 ms |
SELECT t0.idnew AS idnew_1, t0.title AS title_2, t0.type_news AS type_news_3, t0.description AS description_4, t0.markdown AS markdown_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.hour AS hour_8, t0.location AS location_9, t0.city AS city_10, t0.zip AS zip_11, t0.contacts AS contacts_12, t0.url AS url_13, t0.url_more AS url_more_14, t0.infos_contacts AS infos_contacts_15, t0.url_file AS url_file_16, t0.copyright_file AS copyright_file_17, t0.is_homepage AS is_homepage_18, t0.publish AS publish_19, t0.valid AS valid_20, t0.statut AS statut_21, t0.dateinsert AS dateinsert_22, t0.dateupdate AS dateupdate_23, t0.idextranetuser_lock AS idextranetuser_lock_24, t0.idextranetuser AS idextranetuser_25, t0.idregion AS idregion_26, t0.country AS country_27 FROM news t0 WHERE t0.idnew = ?
Parameters:
[
"4545"
]
|
||||||||||||||||||||||||||||||
46 | 0.16 ms |
SELECT url_file FROM news WHERE idnew=4545
Parameters:
[]
|
||||||||||||||||||||||||||||||
47 | 0.30 ms |
SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c WHERE sc.idcontact=c.idcontact AND sc.idnew=4545 AND sc.date<'2024-04-28' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||
48 | 0.41 ms |
SELECT MIN(sc.date) as datestart, MAX(sc.date) as dateend, c.city, c.country FROM newschedules sc, contacts c WHERE sc.idcontact=c.idcontact AND sc.idnew=4545 AND sc.date<'2024-04-28' AND sc.idcontact=450 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||
49 | 0.33 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idnew FROM theatreok_dev.persons j1, theatreok_dev.new_person j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idperson=j2.idperson AND j3.idnew=4545
Parameters:
[]
|
||||||||||||||||||||||||||||||
50 | 0.31 ms |
SELECT j1.idcontact,j1.lastname,j1.firstname,j1.organisation,j1.type,j1.url_clean ,j3.idnew FROM theatreok_dev.contacts j1, theatreok_dev.new_contact j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idcontact=j2.idcontact AND j3.idnew=4545
Parameters:
[]
|
||||||||||||||||||||||||||||||
51 | 0.22 ms |
SELECT j1.idspectacle,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.spectacles j1, theatreok_dev.new_spectacle j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idspectacle=j2.idspectacle AND j3.idnew=4545
Parameters:
[]
|
||||||||||||||||||||||||||||||
52 | 0.32 ms |
SELECT j1.idtext,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.texts j1, theatreok_dev.new_text j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idtext=j2.idtext AND j3.idnew=4545
Parameters:
[]
|
||||||||||||||||||||||||||||||
53 | 0.35 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 (75) AND c.`classification`='class_auteur_meme'
Parameters:
[]
|
||||||||||||||||||||||||||||||
54 | 2.68 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 (1192,1266,1569,1587,1588,1589,1590,1591,1593,1594,1736,1926,2042,2475,2532,2628,2798,3058,3060,3538,3765,3831,3858,3885,3890,3891,3892,3963,4105,4159,4455,4528,4543,4656,4827,4928,4948,5089,5196,5418,5492,5862,7051,7342,7431,7514,7520,8120,8845,9532,10052,10473,10568,11349,12254,13638,14552,15040,17714,18726,18872,20782,21857,22742,23855,24099,27259,30999,31209,31616,32369,34749,35281,35455,36080) AND s.date>='2024-04-28' ORDER BY s.date ASC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||
55 | 5.54 ms |
SELECT schedules.`date`, YEAR(schedules.`date`) as annee FROM schedules, spectacles WHERE schedules.`idspectacle`=spectacles.`idspectacle` AND spectacles.`publish`=1 AND schedules.`idspectacle` IN (1192,1266,1569,1587,1588,1589,1590,1591,1593,1594,1736,1926,2042,2475,2532,2628,2798,3058,3060,3538,3765,3831,3858,3885,3890,3891,3892,3963,4105,4159,4455,4528,4543,4656,4827,4928,4948,5089,5196,5418,5492,5862,7051,7342,7431,7514,7520,8120,8845,9532,10052,10473,10568,11349,12254,13638,14552,15040,17714,18726,18872,20782,21857,22742,23855,24099,27259,30999,31209,31616,32369,34749,35281,35455,36080) GROUP BY spectacles.`idspectacle` ORDER BY schedules.`date`
Parameters:
[]
|
||||||||||||||||||||||||||||||
56 | 1.29 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=75 ) AND T1.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
57 | 0.60 ms |
SELECT COUNT(DISTINCT(m.idmultimedia)) FROM object_multimedia om, multimedias m WHERE om.idmultimedia=m.idmultimedia AND om.idobject=75 AND om.object='persons' AND m.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
58 | 0.37 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`=75 AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||
59 | 0.28 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`=75 AND d.code_soundcloud IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||
60 | 1.46 ms |
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1 LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` ,object_content oc2, contents c2, content_classification cc2 WHERE 1 AND oc2.idcontent=c2.idcontent AND cc2.idcontent=c2.idcontent AND oc2.idobject=T1.idtext AND cc2.idclassification IN (125) AND oc2.object='texts' AND T1.`idtext` IN (287,294,296,298,300,303,305,1567,1647,2007,2032,2197,3064,3208,3412,5316,5352,5465,5467,6721,6722,6790,6792,6887,7022,7280,8825,10628,34609,35088,36498,36499,38543,40878,13981,6889,30086,8221,6889,23589,6889,6889,10630,292,12136,295,2028,297,299,301,22278,304,1648,2008,2033,2202,3066,3209,3413,5317,5353,5466,5468,6723,6724,6791,7304,6793,6888,7023,7281,8826,10629,34610,36500,36501,38544) ORDER BY publication_year DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||
61 | 7.38 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (125) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND s0_.idspectacle IN (1192, 1266, 1569, 1587, 1588, 1589, 1590, 1591, 1593, 1594, 1736, 1926, 2042, 2475, 2532, 2628, 2798, 3058, 3060, 3538, 3765, 3831, 3858, 3885, 3890, 3891, 3892, 3963, 4105, 4159, 4455, 4528, 4543, 4656, 4827, 4928, 4948, 5089, 5196, 5418, 5492, 5862, 7051, 7342, 7431, 7514, 7520, 8120, 8845, 9532, 10052, 10473, 10568, 11349, 12254, 13638, 14552, 15040, 17714, 18726, 18872, 20782, 21857, 22742, 23855, 24099, 27259, 30999, 31209, 31616, 32369, 34749, 35281, 35455, 36080) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||
62 | 3.69 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (82) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND s0_.idspectacle IN (1192, 1266, 1569, 1587, 1588, 1589, 1590, 1591, 1593, 1594, 1736, 1926, 2042, 2475, 2532, 2628, 2798, 3058, 3060, 3538, 3765, 3831, 3858, 3885, 3890, 3891, 3892, 3963, 4105, 4159, 4455, 4528, 4543, 4656, 4827, 4928, 4948, 5089, 5196, 5418, 5492, 5862, 7051, 7342, 7431, 7514, 7520, 8120, 8845, 9532, 10052, 10473, 10568, 11349, 12254, 13638, 14552, 15040, 17714, 18726, 18872, 20782, 21857, 22742, 23855, 24099, 27259, 30999, 31209, 31616, 32369, 34749, 35281, 35455, 36080) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||
63 | 2.62 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 (1192,1266,1569,1587,1588,1589,1590,1591,1593,1594,1736,1926,2042,2475,2532,2628,2798,3058,3060,3538,3765,3831,3858,3885,3890,3891,3892,3963,4105,4159,4455,4528,4543,4656,4827,4928,4948,5089,5196,5418,5492,5862,7051,7342,7431,7514,7520,8120,8845,9532,10052,10473,10568,11349,12254,13638,14552,15040,17714,18726,18872,20782,21857,22742,23855,24099,27259,30999,31209,31616,32369,34749,35281,35455,36080) 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:
[]
|
||||||||||||||||||||||||||||||
64 | 0.98 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:
[ "c9968f4068738db43bff90f4715e2ada-aeff" 0 "f3d76222450cf799651403016cf763a9" ]
|
||||||||||||||||||||||||||||||
65 | 1.32 ms |
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "article" "thnet" "/biographies/Jon-Fosse/evenements/" "f3d76222450cf799651403016cf763a9" 0 "persons" 75 0 "fr" "c9968f4068738db43bff90f4715e2ada-aeff" "/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553" ]
|
||||||||||||||||||||||||||||||
66 | 0.06 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
67 | 0.10 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='75' 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:
[]
|
||||||||||||||||||||||||||||||
68 | 2.38 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\Regions | No errors. |
TheatreCore\Entity\Newschedules | No errors. |
TheatreCore\Entity\Playlists | No errors. |
TheatreCore\Entity\Schedules | No errors. |
TheatreCore\Entity\Typesspectacles | 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. |