Query Metrics
114
Database Queries
105
Different statements
1461.69 ms
Query time
1
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.33 ms |
SELECT idcontact FROM contacts WHERE url_clean='Centre-Dramatique-National-dOrleans-Loiret-Centre'
Parameters:
[]
|
||||||||||||||||||||||||||||||||
2 | 0.53 ms |
SELECT c0_.idcontact AS idcontact_0, c0_.type AS type_1, c0_.organisation AS organisation_2, c0_.nom_suite AS nom_suite_3, c0_.lastname AS lastname_4, c0_.firstname AS firstname_5, c0_.idtypestructure AS idtypestructure_6, c0_.license AS license_7, c0_.comment AS comment_8, c0_.private_comment AS private_comment_9, c0_.address1 AS address1_10, c0_.address2 AS address2_11, c0_.zip AS zip_12, c0_.city AS city_13, c0_.phone1 AS phone1_14, c0_.phone2 AS phone2_15, c0_.fax AS fax_16, c0_.email1 AS email1_17, c0_.email1_online AS email1_online_18, c0_.email2_online AS email2_online_19, c0_.email2 AS email2_20, c0_.url AS url_21, c0_.url_ticket AS url_ticket_22, c0_.facebook AS facebook_23, c0_.twitter AS twitter_24, c0_.instagram AS instagram_25, c0_.mobile AS mobile_26, c0_.geocodable AS geocodable_27, c0_.x AS x_28, c0_.y AS y_29, c0_.idmultimedia AS idmultimedia_30, c0_.type_view AS type_view_31, c0_.stats_access AS stats_access_32, c0_.ga_tracking_id AS ga_tracking_id_33, c0_.is_festival AS is_festival_34, c0_.link_on_video AS link_on_video_35, c0_.is_partenaire AS is_partenaire_36, c0_.valid_version AS valid_version_37, c0_.other_versions AS other_versions_38, c0_.url_redirect AS url_redirect_39, c0_.url_clean AS url_clean_40, c0_.dateupdate AS dateupdate_41, c0_.dateinsert AS dateinsert_42, c0_.publish AS publish_43, c0_.valid AS valid_44, c1_.id AS id_45, c1_.fr AS fr_46, c1_.en AS en_47, c1_.es AS es_48, c1_.pt AS pt_49, c1_.de AS de_50, c1_.ru AS ru_51, c1_.orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_.country = c1_.id WHERE c0_.idcontact = ?
Parameters:
[
522
]
|
||||||||||||||||||||||||||||||||
3 | 0.16 ms |
SELECT fr FROM countries WHERE id='FR'
Parameters:
[]
|
||||||||||||||||||||||||||||||||
4 | 0.55 ms |
SELECT t0_.idtypestructure AS idtypestructure_0, t0_.typestructure_pluriel AS typestructure_pluriel_1, t0_.typestructure AS typestructure_2, t0_.public_view AS public_view_3, t0_.order_view AS order_view_4 FROM typesstructures t0_ WHERE t0_.idtypestructure = ?
Parameters:
[
"CDN"
]
|
||||||||||||||||||||||||||||||||
5 | 0.41 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j2.idoffice,j2.date_start,j2.date_end ,j3.idcontact FROM theatreok_dev.persons j1, theatreok_dev.contact_person j2, theatreok_dev.contacts j3 WHERE j3.idcontact=j2.idcontact AND j1.idperson=j2.idperson AND j3.idcontact=522 AND j2.idoffice=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
6 | 0.06 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (100))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
7 | 1.79 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='522' AND of.object='contacts' AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (100))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters:
[]
|
||||||||||||||||||||||||||||||||
8 | 0.05 ms |
SELECT classification FROM classifications WHERE idclassification=100
Parameters:
[]
|
||||||||||||||||||||||||||||||||
9 | 8.19 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM schedules, spectacles WHERE schedules.idspectacle=spectacles.idspectacle AND spectacles.publish=1 AND (schedules.idcontact=522 OR schedules.idcontact_festival=522)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
10 | 95.61 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle` WHERE spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=522 OR spectacles.`idcontact_production`=522) AND spectacle_contact.`idrole` IN (17,18,19)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
11 | 2.09 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle` WHERE spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=522 OR spectacles.`idcontact_production`=522) AND spectacle_contact.`idrole` = 77
Parameters:
[]
|
||||||||||||||||||||||||||||||||
12 | 0.37 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle` INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide` WHERE spectacles.`publish`=1 AND aides.`idcontact`=522
Parameters:
[]
|
||||||||||||||||||||||||||||||||
13 | 0.26 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle` INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide` WHERE spectacles.`publish`=1 AND aides.`idcontact`=522 AND aides.type_aide IN (2,3)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
14 | 0.36 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle` INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide` WHERE spectacles.`publish`=1 AND aides.`idcontact`=522 AND aides.type_aide IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
15 | 0.20 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle` INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide` WHERE spectacles.`publish`=1 AND aides.`idcontact`=522 AND aides.type_aide IN (4)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
16 | 20.75 ms |
SELECT COUNT(DISTINCT(multimedias.idmultimedia)) FROM multimedias WHERE multimedias.`publish`=1 AND (multimedias.`idmultimedia` IN ( SELECT multimedias.`idmultimedia` FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia` AND object_multimedia.`object` IN ('contacts', 'spectacles') AND object_multimedia.idobject IN (11,27,29,14,34,35,279,669,683,760,838,915,1172,1178,1179,1180,1778,1966,1970,1984,2076,2163,1526,2389,2606,2167,1751,2978,2056,3153,3242,1749,2138,2105,1815,1642,2003,2002,1791,1748,2183,3482,3558,3470,3703,3773,3774,2826,3804,3903,3302,4034,2831,4072,4068,3420,4079,3988,4251,4235,4471,4528,4523,4791,4918,4265,3037,4990,5103,5099,4744,4530,4823,4896,1243,3301,5137,5385,5582,6068,6251,6076,5758,6180,7018,340,6675,7408,4146,8229,7062,8336,8895,8224,8596,9612,9614,9615,10574,6135,8443,11511,11678,11574,11684,8388,6154,11706,11410,13409,13795,15056,15128,12943,13553,15328,12495,12201,17529,13732,18148,17557,17587,17575,17823,18222,19379,17717,13202,20327,5406,16746,20752,20994,21390,21743,23546,23928,23981,23321,24753,21071,20867,23912,21844,20528,21401,21478,24424,23885,25754,23959,23678,26441,10975,20856,28550,28695,27749,26948,29770,25827,26864,26865,30848,29221,26667,30711,31150,29395,32106,31369,29872,30974,29247,28201,24046,32134,32555,32795,31212,28102,33041,33043,33048,29774,30934,31716,28607,33933,33767,33580,34579,29024,30214,29782,8957,31336,31060,31930,29233,29588,14729,24144,33712,34955,7380,35710,26991,34391,31843,36712,33637,29,1178,1179,1180,1748,1749,1778,1791,1815,1966,1970,2002,2004,2005,2138,2183,2807,2822,2978,3302,3432,3464,3465,3482,3511,3558,3570,3703,3740,3773,3774,3804,3903,4034,4068,4072,4079,4471,4523,4528,4530,4791,4918,4990,5099,5103,5137,5356,5385,5406,5582,6076,6180,6251,6675,7408,8229,8336,8443,8562,8596,8895,9499,9612,9614,9615,11410,11574,11678,11684,11692,13308,13551,13553,13795,14990,15056,15328,16253,17254,17280,17390,17529,17557,17575,17587,17717,17823,18148,18222,19379,20327,20783,20786,21440,21443,21743,24424,24753,26864,26865,26948,29247,29395,29770,29870,29883,30214,30580,31150,31235,31843,32106,32249,32555,32795,33043,33580,33712,33933,34391,35541,35710,36597,36712) ) OR multimedias.`idmultimedia` IN ( SELECT multimedias.idmultimedia FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia` AND object_multimedia.object IN ('contacts') AND object_multimedia.idobject=522 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||
17 | 718.08 ms |
SELECT COUNT(DISTINCT(ct.`idcontent`)) FROM schedules sc JOIN spectacles s ON s.`idspectacle`=sc.`idspectacle` 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 ( sc.`idspectacle` IN ('29','1178','1179','1180','1748','1749','1778','1791','1815','1966','1970','2002','2004','2005','2138','2183','2807','2822','2978','3302','3432','3464','3465','3482','3511','3558','3570','3703','3740','3773','3774','3804','3903','4034','4068','4072','4079','4471','4523','4528','4530','4791','4918','4990','5099','5103','5137','5356','5385','5406','5582','6076','6180','6251','6675','7408','8229','8336','8443','8562','8596','8895','9499','9612','9614','9615','11410','11574','11678','11684','11692','13308','13551','13553','13795','14990','15056','15328','16253','17254','17280','17390','17529','17557','17575','17587','17717','17823','18148','18222','19379','20327','20783','20786','21440','21443','21743','24424','24753','26864','26865','26948','29247','29395','29770','29870','29883','30214','30580','31150','31235','31843','32106','32249','32555','32795','33043','33580','33712','33933','34391','35541','35710','36597','36712','11','27','14','34','35','279','669','683','760','838','915','1172','1984','2076','2163','1526','2389','2606','2167','1751','2056','3153','3242','2105','1642','2003','3470','2826','2831','3420','3988','4251','4235','4265','3037','4744','4823','4896','1243','3301','6068','5758','7018','340','4146','7062','8224','10574','6135','11511','8388','6154','11706','13409','15128','12943','12495','12201','13732','13202','16746','20752','20994','21390','23546','23928','23981','23321','21071','20867','23912','21844','20528','21401','21478','23885','25754','23959','23678','26441','10975','20856','28550','28695','27749','25827','30848','29221','26667','30711','31369','29872','30974','28201','24046','32134','31212','28102','33041','33048','29774','30934','31716','28607','33767','34579','29024','29782','8957','31336','31060','31930','29233','29588','14729','24144','34955','7380','26991','33637') OR ( sc.`idcontact`=522 OR sc.`idcontact_festival`=522 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||
18 | 1.34 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_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=522 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=0 AND (( T3.date>='2024-04-18' )) GROUP BY T1.idnew ORDER BY T3.date ASC LIMIT 0,200
Parameters:
[]
|
||||||||||||||||||||||||||||||||
19 | 1.44 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_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=522 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=0 AND (( T3.date<'2024-04-18' )) GROUP BY T1.idnew ORDER BY T3.date DESC LIMIT 0,200
Parameters:
[]
|
||||||||||||||||||||||||||||||||
20 | 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:
[
"10667"
]
|
||||||||||||||||||||||||||||||||
21 | 0.84 ms |
SELECT url_file FROM news WHERE idnew=10667
Parameters:
[]
|
||||||||||||||||||||||||||||||||
22 | 0.29 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=10667 AND sc.date<'2024-04-18' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
23 | 0.27 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=10667 AND sc.date<'2024-04-18' AND sc.idcontact=638 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||||
24 | 0.50 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=10667
Parameters:
[]
|
||||||||||||||||||||||||||||||||
25 | 0.75 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=10667
Parameters:
[]
|
||||||||||||||||||||||||||||||||
26 | 0.34 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=10667
Parameters:
[]
|
||||||||||||||||||||||||||||||||
27 | 0.22 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=24231
Parameters:
[]
|
||||||||||||||||||||||||||||||||
28 | 0.45 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=10667
Parameters:
[]
|
||||||||||||||||||||||||||||||||
29 | 0.29 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
28049
]
|
||||||||||||||||||||||||||||||||
30 | 0.52 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=28049 ORDER BY j2.classement ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
31 | 0.14 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
28543
]
|
||||||||||||||||||||||||||||||||
32 | 0.35 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=28543 ORDER BY j2.classement ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
33 | 0.15 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
31275
]
|
||||||||||||||||||||||||||||||||
34 | 0.30 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=31275 ORDER BY j2.classement ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
35 | 0.19 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
29802
]
|
||||||||||||||||||||||||||||||||
36 | 0.28 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=29802 ORDER BY j2.classement ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
37 | 0.15 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
31008
]
|
||||||||||||||||||||||||||||||||
38 | 0.23 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=31008 ORDER BY j2.classement ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
39 | 0.13 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
29796
]
|
||||||||||||||||||||||||||||||||
40 | 0.48 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=29796 ORDER BY j2.classement ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
41 | 0.44 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:
[
"9718"
]
|
||||||||||||||||||||||||||||||||
42 | 0.21 ms |
SELECT url_file FROM news WHERE idnew=9718
Parameters:
[]
|
||||||||||||||||||||||||||||||||
43 | 0.29 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=9718 AND sc.date<'2024-04-18' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
44 | 0.24 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=9718 AND sc.date<'2024-04-18' AND sc.idcontact=638 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||||
45 | 0.50 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=9718
Parameters:
[]
|
||||||||||||||||||||||||||||||||
46 | 0.30 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=9718
Parameters:
[]
|
||||||||||||||||||||||||||||||||
47 | 0.25 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=9718
Parameters:
[]
|
||||||||||||||||||||||||||||||||
48 | 0.30 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=21684
Parameters:
[]
|
||||||||||||||||||||||||||||||||
49 | 0.20 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=9718
Parameters:
[]
|
||||||||||||||||||||||||||||||||
50 | 0.18 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:
[
"6095"
]
|
||||||||||||||||||||||||||||||||
51 | 0.21 ms |
SELECT url_file FROM news WHERE idnew=6095
Parameters:
[]
|
||||||||||||||||||||||||||||||||
52 | 0.37 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=6095 AND sc.date<'2024-04-18' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
53 | 0.22 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=6095 AND sc.date<'2024-04-18' AND sc.idcontact=522 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||||
54 | 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=6095
Parameters:
[]
|
||||||||||||||||||||||||||||||||
55 | 0.23 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=6095
Parameters:
[]
|
||||||||||||||||||||||||||||||||
56 | 0.16 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=6095
Parameters:
[]
|
||||||||||||||||||||||||||||||||
57 | 0.28 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=6095
Parameters:
[]
|
||||||||||||||||||||||||||||||||
58 | 0.26 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:
[
"5511"
]
|
||||||||||||||||||||||||||||||||
59 | 0.09 ms |
SELECT url_file FROM news WHERE idnew=5511
Parameters:
[]
|
||||||||||||||||||||||||||||||||
60 | 0.18 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=5511 AND sc.date<'2024-04-18' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
61 | 0.59 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=5511 AND sc.date<'2024-04-18' AND sc.idcontact=522 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||||
62 | 0.27 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=5511
Parameters:
[]
|
||||||||||||||||||||||||||||||||
63 | 0.20 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=5511
Parameters:
[]
|
||||||||||||||||||||||||||||||||
64 | 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=5511
Parameters:
[]
|
||||||||||||||||||||||||||||||||
65 | 0.24 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=5511
Parameters:
[]
|
||||||||||||||||||||||||||||||||
66 | 0.99 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_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=522 ) AND T1.idnew NOT IN (10667,9718,6095,5511) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=1 AND (( T3.date>='2024-04-18' )) GROUP BY T1.idnew ORDER BY T3.date ASC LIMIT 0,200
Parameters:
[]
|
||||||||||||||||||||||||||||||||
67 | 0.76 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_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=522 ) AND T1.idnew NOT IN (10667,9718,6095,5511) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=1 AND (( T3.date<'2024-04-18' )) GROUP BY T1.idnew ORDER BY T3.date DESC LIMIT 0,200
Parameters:
[]
|
||||||||||||||||||||||||||||||||
68 | 0.05 ms |
SELECT COUNT(DISTINCT(multimedias.idmultimedia)) FROM multimedias WHERE multimedias.`publish`=1 AND (multimedias.`idmultimedia` IN ( SELECT multimedias.`idmultimedia` FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia` AND object_multimedia.`object` IN ('contacts', 'spectacles') AND object_multimedia.idobject IN (11,27,29,14,34,35,279,669,683,760,838,915,1172,1178,1179,1180,1778,1966,1970,1984,2076,2163,1526,2389,2606,2167,1751,2978,2056,3153,3242,1749,2138,2105,1815,1642,2003,2002,1791,1748,2183,3482,3558,3470,3703,3773,3774,2826,3804,3903,3302,4034,2831,4072,4068,3420,4079,3988,4251,4235,4471,4528,4523,4791,4918,4265,3037,4990,5103,5099,4744,4530,4823,4896,1243,3301,5137,5385,5582,6068,6251,6076,5758,6180,7018,340,6675,7408,4146,8229,7062,8336,8895,8224,8596,9612,9614,9615,10574,6135,8443,11511,11678,11574,11684,8388,6154,11706,11410,13409,13795,15056,15128,12943,13553,15328,12495,12201,17529,13732,18148,17557,17587,17575,17823,18222,19379,17717,13202,20327,5406,16746,20752,20994,21390,21743,23546,23928,23981,23321,24753,21071,20867,23912,21844,20528,21401,21478,24424,23885,25754,23959,23678,26441,10975,20856,28550,28695,27749,26948,29770,25827,26864,26865,30848,29221,26667,30711,31150,29395,32106,31369,29872,30974,29247,28201,24046,32134,32555,32795,31212,28102,33041,33043,33048,29774,30934,31716,28607,33933,33767,33580,34579,29024,30214,29782,8957,31336,31060,31930,29233,29588,14729,24144,33712,34955,7380,35710,26991,34391,31843,36712,33637,29,1178,1179,1180,1748,1749,1778,1791,1815,1966,1970,2002,2004,2005,2138,2183,2807,2822,2978,3302,3432,3464,3465,3482,3511,3558,3570,3703,3740,3773,3774,3804,3903,4034,4068,4072,4079,4471,4523,4528,4530,4791,4918,4990,5099,5103,5137,5356,5385,5406,5582,6076,6180,6251,6675,7408,8229,8336,8443,8562,8596,8895,9499,9612,9614,9615,11410,11574,11678,11684,11692,13308,13551,13553,13795,14990,15056,15328,16253,17254,17280,17390,17529,17557,17575,17587,17717,17823,18148,18222,19379,20327,20783,20786,21440,21443,21743,24424,24753,26864,26865,26948,29247,29395,29770,29870,29883,30214,30580,31150,31235,31843,32106,32249,32555,32795,33043,33580,33712,33933,34391,35541,35710,36597,36712) ) OR multimedias.`idmultimedia` IN ( SELECT multimedias.idmultimedia FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia` AND object_multimedia.object IN ('contacts') AND object_multimedia.idobject=522 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||
69 | 0.04 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_presentation_structure'))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
70 | 0.90 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='522' AND oc.object='contacts' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_presentation_structure'))) ORDER BY c.`range`,c.idcontent
Parameters:
[]
|
||||||||||||||||||||||||||||||||
71 | 0.04 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_article'))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
72 | 0.89 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='522' AND oc.object='contacts' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_article'))) ORDER BY c.`range`,c.idcontent
Parameters:
[]
|
||||||||||||||||||||||||||||||||
73 | 0.21 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||
74 | 0.46 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||
75 | 0.19 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||
76 | 0.27 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||
77 | 0.19 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||
78 | 0.18 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||
79 | 0.13 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||
80 | 0.11 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||
81 | 0.23 ms |
SELECT COUNT(p.idplaylist) FROM playlists p LEFT JOIN playlist_classification pc ON p.idplaylist = pc.idplaylist LEFT JOIN aides a ON a.idcontact=522 LEFT JOIN text_aide ta ON a.`idaide`=ta.`idaide` WHERE 1 AND a.`publish`=1 AND a.`type_aide` IN (2,3) AND pc.idclassification = 144 AND p.idtext = ta.idtext GROUP BY p.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||
82 | 0.12 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
83 | 0.17 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
84 | 0.11 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
85 | 0.17 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
86 | 0.17 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||
87 | 0.22 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||
88 | 0.15 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||
89 | 0.14 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=522 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||
90 | 0.58 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN text_aide t8_ ON t2_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE s0_.textfictif = 0 AND a9_.idcontact IN (522) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-04-18' AND '2026-04-08')) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
91 | 0.57 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN text_aide t8_ ON t2_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE s0_.textfictif = 0 AND a9_.idcontact IN (522) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date < '2024-04-18' ORDER BY s1_.date DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
92 | 3.13 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-04-18' AND (s0_.publish = 1 AND (s1_.idcontact = 522 OR s1_.idcontact_festival = 522)) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
93 | 10.96 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, c2_.idcontact AS idcontact_2 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 c2_ ON s1_.idcontact = c2_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c2_.idcontact OR s1_.idcontact_festival = c2_.idcontact) AND (s0_.publish = 1 AND (s1_.idcontact = 522 OR s1_.idcontact_festival = 522)) ORDER BY s1_.date DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
94 | 0.69 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND (s8_.idrole IN (77) AND s8_.idcontact = 522)) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
95 | 250.25 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 522 OR s0_.idcontact_production = 522)) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
96 | 36.26 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-04-18' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 522 OR s0_.idcontact_production = 522)) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
97 | 2.68 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN podcast_spectacle p9_ ON s0_.idspectacle = p9_.idspectacle INNER JOIN podcasts p8_ ON p8_.idpodcast = p9_.idpodcast WHERE p8_.code_franceinter IS NOT NULL AND p8_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-04-18' AND (s0_.publish = 1 AND (s1_.idcontact = 522 OR s1_.idcontact_festival = 522)) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
98 | 7.02 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, c2_.idcontact AS idcontact_2 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 c2_ ON s1_.idcontact = c2_.idcontact INNER JOIN podcast_spectacle p9_ ON s0_.idspectacle = p9_.idspectacle INNER JOIN podcasts p8_ ON p8_.idpodcast = p9_.idpodcast WHERE p8_.code_franceinter IS NOT NULL AND p8_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c2_.idcontact OR s1_.idcontact_festival = c2_.idcontact) AND (s0_.publish = 1 AND (s1_.idcontact = 522 OR s1_.idcontact_festival = 522)) ORDER BY s1_.date DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
99 | 0.77 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_.idspectacle = p10_.idspectacle INNER JOIN podcasts p9_ ON p9_.idpodcast = p10_.idpodcast WHERE p9_.code_franceinter IS NOT NULL AND p9_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND (s8_.idrole IN (77) AND s8_.idcontact = 522)) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
100 | 71.17 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_.idspectacle = p10_.idspectacle INNER JOIN podcasts p9_ ON p9_.idpodcast = p10_.idpodcast WHERE p9_.code_franceinter IS NOT NULL AND p9_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 522 OR s0_.idcontact_production = 522)) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
101 | 16.38 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_.idspectacle = p10_.idspectacle INNER JOIN podcasts p9_ ON p9_.idpodcast = p10_.idpodcast WHERE p9_.code_franceinter IS NOT NULL AND p9_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-04-18' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 522 OR s0_.idcontact_production = 522)) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
102 | 0.65 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN text_aide t8_ ON t2_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE s0_.textfictif = 0 AND a9_.idcontact IN (522) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
103 | 0.63 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_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=522 ) AND T1.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
104 | 2.30 ms |
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total FROM podcasts d, podcast_spectacle do WHERE d.`publish`=1 AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle` IN(29,1178,1179,1180,1748,1749,1778,1791,1815,1966,1970,2002,2004,2005,2138,2183,2807,2822,2978,3302,3432,3464,3465,3482,3511,3558,3570,3703,3740,3773,3774,3804,3903,4034,4068,4072,4079,4471,4523,4528,4530,4791,4918,4990,5099,5103,5137,5356,5385,5406,5582,6076,6180,6251,6675,7408,8229,8336,8443,8562,8596,8895,9499,9612,9614,9615,11410,11574,11678,11684,11692,13308,13551,13553,13795,14990,15056,15328,16253,17254,17280,17390,17529,17557,17575,17587,17717,17823,18148,18222,19379,20327,20783,20786,21440,21443,21743,24424,24753,26864,26865,26948,29247,29395,29770,29870,29883,30214,30580,31150,31235,31843,32106,32249,32555,32795,33043,33580,33712,33933,34391,35541,35710,36597,36712,11,27,14,34,35,279,669,683,760,838,915,1172,1984,2076,2163,1526,2389,2606,2167,1751,2056,3153,3242,2105,1642,2003,3470,2826,2831,3420,3988,4251,4235,4265,3037,4744,4823,4896,1243,3301,6068,5758,7018,340,4146,7062,8224,10574,6135,11511,8388,6154,11706,13409,15128,12943,12495,12201,13732,13202,16746,20752,20994,21390,23546,23928,23981,23321,21071,20867,23912,21844,20528,21401,21478,23885,25754,23959,23678,26441,10975,20856,28550,28695,27749,25827,30848,29221,26667,30711,31369,29872,30974,28201,24046,32134,31212,28102,33041,33048,29774,30934,31716,28607,33767,34579,29024,29782,8957,31336,31060,31930,29233,29588,14729,24144,34955,7380,26991,33637) AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||||
105 | 0.37 ms |
SELECT count(p0_.idpodcast) AS sclr_0 FROM podcasts p0_ INNER JOIN podcast_contact p2_ ON p0_.idpodcast = p2_.idpodcast INNER JOIN contacts c1_ ON c1_.idcontact = p2_.idcontact WHERE c1_.idcontact = ?
Parameters:
[
522
]
|
||||||||||||||||||||||||||||||||
106 | 169.12 ms |
SELECT COUNT(DISTINCT(spectacles.`idspectacle`)) as total FROM schedules, spectacles JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle` JOIN object_content ON spectacle_contact.`idspectacle`=object_content.`idobject` JOIN contents ON contents.`idcontent`=object_content.`idcontent` JOIN content_classification ON contents.`idcontent`=content_classification.`idcontent` WHERE schedules.idspectacle=spectacles.idspectacle AND spectacles.publish=1 AND (schedules.idcontact=522 OR schedules.idcontact_festival=522) AND contents.`publish`=1 AND contents.`valid`=1 AND object_content.`object`='spectacles' AND content_classification.`idclassification` IN (125)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
107 | 10.17 ms |
SELECT COUNT(DISTINCT(spectacles.`idspectacle`)) as total FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle` JOIN object_content ON spectacle_contact.`idspectacle`=object_content.`idobject` JOIN contents ON contents.`idcontent`=object_content.`idcontent` JOIN content_classification ON contents.`idcontent`=content_classification.`idcontent` WHERE spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=522 OR spectacles.`idcontact_production`=522) AND spectacle_contact.`idrole` IN (17,18,19) AND contents.`publish`=1 AND contents.`valid`=1 AND object_content.`object`='spectacles' AND content_classification.`idclassification` IN (125)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
108 | 0.07 ms |
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND contacts=1 AND lagarce!=1 AND is_public IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
109 | 0.05 ms |
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
110 | 0.91 ms |
SELECT COUNT(DISTINCT(of.idfile)) as total 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='522' AND of.object='contacts' AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (112,168,33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
Parameters:
[]
|
||||||||||||||||||||||||||||||||
111 | 0.52 ms |
SELECT COUNT(DISTINCT(idperson)) FROM person_ecole WHERE 1 AND idcontact=522
Parameters:
[]
|
||||||||||||||||||||||||||||||||
112 | 0.48 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:
[ "541895160a4c9fcb48c47b073d5618fe-25b1" 0 "dd15fc2802e47fd6b47c67b26436e703" ]
|
||||||||||||||||||||||||||||||||
113 | 1.94 ms |
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "article" "thnet" "/contacts/Centre-Dramatique-National-dOrleans-Loiret-Centre/evenements" "dd15fc2802e47fd6b47c67b26436e703" 0 "contacts" 522 0 "fr" "541895160a4c9fcb48c47b073d5618fe-25b1" "/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829" ]
|
||||||||||||||||||||||||||||||||
114 | 0.66 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