Query Metrics
186
Database Queries
160
Different statements
638.29 ms
Query time
1
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.34 ms |
SELECT idperson FROM persons WHERE url_clean='VARUPENNE-Stephane'
Parameters:
[]
|
||||||||||||||||||||||||||||
2 | 0.53 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:
[
9858
]
|
||||||||||||||||||||||||||||
3 | 1.39 ms |
SELECT COUNT(DISTINCT(t.idtext)) FROM text_author ta, texts t WHERE t.idtext=ta.idtext AND t.textfictif=0 AND ta.idperson=9858 AND t.publish=1 AND t.type IN (0,2)
Parameters:
[]
|
||||||||||||||||||||||||||||
4 | 0.62 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=9858 AND t.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||
5 | 0.80 ms |
SELECT COUNT(DISTINCT(sp.idspectacle)) as total FROM spectacle_person sp, spectacles s WHERE 1 AND sp.idspectacle=s.idspectacle AND sp.idperson=9858 AND sp.idrole=1 AND s.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||
6 | 0.08 ms |
SELECT fr FROM countries WHERE id='FR'
Parameters:
[]
|
||||||||||||||||||||||||||||
7 | 0.06 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||
8 | 1.00 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=9858 AND j2.idoffice=1
Parameters:
[]
|
||||||||||||||||||||||||||||
9 | 2.88 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_biotxt'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||
10 | 2.34 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='9858' 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.61 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=86991
Parameters:
[]
|
||||||||||||||||||||||||||||
12 | 0.08 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||
13 | 3.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='9858' 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 | 1.60 ms |
SELECT t.`idtext` FROM text_author ta JOIN texts t ON ta.`idtext`=t.`idtext` WHERE ta.`idperson` IN (9858)
Parameters:
[]
|
||||||||||||||||||||||||||||
15 | 3.78 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 (9858)
Parameters:
[]
|
||||||||||||||||||||||||||||
16 | 7.05 ms |
SELECT t.`idtext` FROM text_translator tt JOIN texts t ON tt.`idtext`=t.`idtext` WHERE tt.`idperson` IN (9858)
Parameters:
[]
|
||||||||||||||||||||||||||||
17 | 2.13 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 (9858)
Parameters:
[]
|
||||||||||||||||||||||||||||
18 | 1.85 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`=9858 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` GROUP BY multimedias.idmultimedia ORDER BY multimedias.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||
19 | 5.64 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 (3411,3526,3531,4855,5355,6506,7107,7199,7881,10380,10393,10396,10410,11840,12530,15268,15307,15334,15337,15339,15343,19414,19680,19768,22631,23569,23999,24066,25398,25850,26929,27133,28238,30377,30750,30872,31330,32416,32417,34316)
Parameters:
[]
|
||||||||||||||||||||||||||||
20 | 0.07 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (206))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||
21 | 1.65 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='9858' 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:
[]
|
||||||||||||||||||||||||||||
22 | 1.18 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||
23 | 0.16 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='9858' 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:
[]
|
||||||||||||||||||||||||||||
24 | 0.07 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`=9858 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` GROUP BY multimedias.idmultimedia ORDER BY multimedias.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||
25 | 33.06 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 (3411,3526,3531,4855,5355,6506,7107,7199,7881,10380,10393,10396,10410,11840,12530,15268,15307,15334,15337,15339,15343,19414,19680,19768,22631,23569,23999,24066,25398,25850,26929,27133,28238,30377,30750,30872,31330,32416,32417,34316) AND schedules.`publish`=1 HAVING 1 AND MIN(schedules.`date`) >='2024-04-27' LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||
26 | 18.46 ms |
SELECT DISTINCT(schedules.idschedule), MIN(schedules.date) AS datemin,MAX(schedules.date) AS datemax,schedules.* FROM `schedules` WHERE 1 AND schedules.`idspectacle` IN (3411,3526,3531,4855,5355,6506,7107,7199,7881,10380,10393,10396,10410,11840,12530,15268,15307,15334,15337,15339,15343,19414,19680,19768,22631,23569,23999,24066,25398,25850,26929,27133,28238,30377,30750,30872,31330,32416,32417,34316) AND schedules.`publish`=1 GROUP BY schedules.`idspectacle` HAVING 1 AND MIN(schedules.`date`) >='2024-04-27' ORDER BY datemin ASC,datemax DESC LIMIT 0,3
Parameters:
[]
|
||||||||||||||||||||||||||||
27 | 3.51 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=9858 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=0 AND (( T3.date>='2024-04-27' )) GROUP BY T1.idnew ORDER BY T3.date DESC LIMIT 0,7
Parameters:
[]
|
||||||||||||||||||||||||||||
28 | 2.00 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=9858 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=0 AND (( T3.date<'2024-04-27' )) GROUP BY T1.idnew ORDER BY T3.date DESC LIMIT 0,3
Parameters:
[]
|
||||||||||||||||||||||||||||
29 | 8.43 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:
[
"11043"
]
|
||||||||||||||||||||||||||||
30 | 10.15 ms |
SELECT url_file FROM news WHERE idnew=11043
Parameters:
[]
|
||||||||||||||||||||||||||||
31 | 0.70 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=11043 AND sc.date<'2024-04-27' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||
32 | 0.84 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=11043 AND sc.date<'2024-04-27' AND sc.idcontact=8717 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||
33 | 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=11043
Parameters:
[]
|
||||||||||||||||||||||||||||
34 | 0.88 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=11043
Parameters:
[]
|
||||||||||||||||||||||||||||
35 | 0.97 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=11043
Parameters:
[]
|
||||||||||||||||||||||||||||
36 | 1.10 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=11043
Parameters:
[]
|
||||||||||||||||||||||||||||
37 | 0.37 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:
[
"534"
]
|
||||||||||||||||||||||||||||
38 | 0.35 ms |
SELECT url_file FROM news WHERE idnew=534
Parameters:
[]
|
||||||||||||||||||||||||||||
39 | 0.72 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=534 AND sc.date<'2024-04-27' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||
40 | 0.40 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=534 AND sc.date>='2024-04-27' ORDER BY sc.date ASC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||
41 | 0.40 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=534 AND sc.date<='2024-04-27' ORDER BY sc.date ASC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||
42 | 0.46 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=534
Parameters:
[]
|
||||||||||||||||||||||||||||
43 | 0.52 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=534
Parameters:
[]
|
||||||||||||||||||||||||||||
44 | 0.36 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=534
Parameters:
[]
|
||||||||||||||||||||||||||||
45 | 0.38 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=534
Parameters:
[]
|
||||||||||||||||||||||||||||
46 | 0.49 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:
[
"1166"
]
|
||||||||||||||||||||||||||||
47 | 0.22 ms |
SELECT url_file FROM news WHERE idnew=1166
Parameters:
[]
|
||||||||||||||||||||||||||||
48 | 0.47 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=1166 AND sc.date<'2024-04-27' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||
49 | 0.60 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=1166 AND sc.date>='2024-04-27' ORDER BY sc.date ASC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||
50 | 0.57 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=1166 AND sc.date<='2024-04-27' ORDER BY sc.date ASC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||
51 | 0.54 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=1166
Parameters:
[]
|
||||||||||||||||||||||||||||
52 | 0.40 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=1166
Parameters:
[]
|
||||||||||||||||||||||||||||
53 | 0.38 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=1166
Parameters:
[]
|
||||||||||||||||||||||||||||
54 | 0.46 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=1166
Parameters:
[]
|
||||||||||||||||||||||||||||
55 | 1.43 ms |
SELECT DISTINCT(playlists.idplaylist), playlists.* FROM `playlist_classification` , `playlists` WHERE 1 AND playlists.`publish`=1 AND playlists.`idtext` IN (32166) AND playlist_classification.`idclassification`=144 AND playlists.`idplaylist`=playlist_classification.`idplaylist` GROUP BY playlists.idplaylist ORDER BY playlists.dateinsert DESC LIMIT 0,2
Parameters:
[]
|
||||||||||||||||||||||||||||
56 | 0.08 ms |
SELECT DISTINCT(playlists.idplaylist), playlists.* FROM `playlist_classification` , `playlists` WHERE 1 AND playlists.`publish`=1 AND playlists.`idtext` IN (32166) AND playlist_classification.`idclassification`=144 AND playlists.`idplaylist`=playlist_classification.`idplaylist` GROUP BY playlists.idplaylist ORDER BY playlists.dateinsert DESC LIMIT 0,2
Parameters:
[]
|
||||||||||||||||||||||||||||
57 | 1.51 ms |
SELECT DISTINCT(podcasts.idpodcast), podcasts.* FROM `podcast_person` , `podcasts` WHERE 1 AND podcasts.`publish`=1 AND podcast_person.`idperson` IN (9858) 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:
[]
|
||||||||||||||||||||||||||||
58 | 0.48 ms |
SELECT p0_.idpodcast AS idpodcast_0, p0_.title AS title_1, p0_.description AS description_2, p0_.title_program AS title_program_3, p0_.name_program AS name_program_4, p0_.date_podcast AS date_podcast_5, p0_.hour_podcast AS hour_podcast_6, p0_.code_franceinter AS code_franceinter_7, p0_.type_franceinter AS type_franceinter_8, p0_.integrate_player AS integrate_player_9, p0_.link AS link_10, p0_.duration AS duration_11, p0_.code_ft AS code_ft_12, p0_.is_integrale AS is_integrale_13, p0_.type_diffusion AS type_diffusion_14, p0_.fin_visionnage_ft AS fin_visionnage_ft_15, p0_.date_captation_ft AS date_captation_ft_16, p0_.debut_visionnage_ft AS debut_visionnage_ft_17, p0_.code_arte AS code_arte_18, p0_.code_soundcloud AS code_soundcloud_19, p0_.code_spotify AS code_spotify_20, p0_.url_file AS url_file_21, p0_.url_clean AS url_clean_22, p0_.dateupdate AS dateupdate_23, p0_.dateinsert AS dateinsert_24, p0_.publish AS publish_25, p0_.valid AS valid_26, p0_.idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_.idpodcast = ?
Parameters:
[
"82"
]
|
||||||||||||||||||||||||||||
59 | 0.81 ms |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idpodcast FROM theatreok_dev.spectacles j1, theatreok_dev.podcast_spectacle j2, theatreok_dev.podcasts j3 WHERE j3.idpodcast=j2.idpodcast AND j1.idspectacle=j2.idspectacle AND j3.idpodcast=82
Parameters:
[]
|
||||||||||||||||||||||||||||
60 | 0.84 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=10410
Parameters:
[]
|
||||||||||||||||||||||||||||
61 | 0.79 ms |
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idpodcast FROM theatreok_dev.contacts j1, theatreok_dev.podcast_contact j2, theatreok_dev.podcasts j3 WHERE j3.idpodcast=j2.idpodcast AND j1.idcontact=j2.idcontact AND j3.idpodcast=82
Parameters:
[]
|
||||||||||||||||||||||||||||
62 | 0.51 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idpodcast FROM theatreok_dev.persons j1, theatreok_dev.podcast_person j2, theatreok_dev.podcasts j3 WHERE j3.idpodcast=j2.idpodcast AND j1.idperson=j2.idperson AND j3.idpodcast=82
Parameters:
[]
|
||||||||||||||||||||||||||||
63 | 0.51 ms |
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idpodcast FROM theatreok_dev.texts j1, theatreok_dev.podcast_text j2, theatreok_dev.podcasts j3 WHERE j3.idpodcast=j2.idpodcast AND j1.idtext=j2.idtext AND j3.idpodcast=82
Parameters:
[]
|
||||||||||||||||||||||||||||
64 | 0.20 ms |
SELECT url_file FROM podcasts WHERE idpodcast=82
Parameters:
[]
|
||||||||||||||||||||||||||||
65 | 0.07 ms |
SELECT url_file FROM podcasts WHERE idpodcast=82
Parameters:
[]
|
||||||||||||||||||||||||||||
66 | 1.06 ms |
SELECT DISTINCT(podcasts.idpodcast), podcasts.* FROM `podcast_person` , `podcasts` WHERE 1 AND podcasts.`publish`=1 AND podcast_person.`idperson` IN (9858) 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:
[]
|
||||||||||||||||||||||||||||
67 | 0.85 ms |
SELECT DISTINCT(podcasts.idpodcast), podcasts.* FROM `podcast_person` , `podcasts` WHERE 1 AND podcasts.`publish`=1 AND podcast_person.`idperson` IN (9858) 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:
[]
|
||||||||||||||||||||||||||||
68 | 2.26 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 (3411,3526,3531,4855,5355,6506,7107,7199,7881,10380,10393,10396,10410,11840,12530,15268,15307,15334,15337,15339,15343,19414,19680,19768,22631,23569,23999,24066,25398,25850,26929,27133,28238,30377,30750,30872,31330,32416,32417,34316) AND s.date>='2024-04-27' ORDER BY s.date ASC LIMIT 0,3
Parameters:
[]
|
||||||||||||||||||||||||||||
69 | 3.24 ms |
SELECT DISTINCT(m.idmultimedia),m.* FROM object_multimedia om, multimedias m WHERE om.idmultimedia=m.idmultimedia AND om.idobject=9858 AND om.object='persons' AND m.publish=1 ORDER BY m.date DESC LIMIT 0, 4
Parameters:
[]
|
||||||||||||||||||||||||||||
70 | 1.20 ms |
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters:
[
"16501"
]
|
||||||||||||||||||||||||||||
71 | 0.59 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=16501 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
72 | 0.40 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=16501 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
73 | 0.58 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=16501 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
74 | 6.11 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=16501 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
75 | 1.05 ms |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video FROM object_multimedia, contacts WHERE object_multimedia.idobject=contacts.idcontact AND object_multimedia.idmultimedia=16501 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
76 | 0.46 ms |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video FROM object_multimedia, contacts WHERE object_multimedia.idobject=contacts.idcontact AND object_multimedia.idmultimedia=16501 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
77 | 7.19 ms |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle FROM object_multimedia, spectacles WHERE object_multimedia.idobject=spectacles.idspectacle AND object_multimedia.idmultimedia=16501 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
78 | 0.19 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=32417
Parameters:
[]
|
||||||||||||||||||||||||||||
79 | 0.24 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=32417
Parameters:
[]
|
||||||||||||||||||||||||||||
80 | 8.00 ms |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid FROM object_multimedia, texts WHERE object_multimedia.idobject=texts.idtext AND object_multimedia.idmultimedia=16501 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
81 | 0.66 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=16501 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||
82 | 0.55 ms |
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters:
[
"17622"
]
|
||||||||||||||||||||||||||||
83 | 0.55 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=17622 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
84 | 20.36 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=17622 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
85 | 0.70 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=17622 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
86 | 12.32 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=17622 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
87 | 1.86 ms |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video FROM object_multimedia, contacts WHERE object_multimedia.idobject=contacts.idcontact AND object_multimedia.idmultimedia=17622 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
88 | 0.58 ms |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video FROM object_multimedia, contacts WHERE object_multimedia.idobject=contacts.idcontact AND object_multimedia.idmultimedia=17622 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
89 | 8.84 ms |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle FROM object_multimedia, spectacles WHERE object_multimedia.idobject=spectacles.idspectacle AND object_multimedia.idmultimedia=17622 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
90 | 0.20 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=32416
Parameters:
[]
|
||||||||||||||||||||||||||||
91 | 0.55 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=32416
Parameters:
[]
|
||||||||||||||||||||||||||||
92 | 8.63 ms |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid FROM object_multimedia, texts WHERE object_multimedia.idobject=texts.idtext AND object_multimedia.idmultimedia=17622 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
93 | 5.53 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=17622 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||
94 | 30.95 ms |
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters:
[
"14584"
]
|
||||||||||||||||||||||||||||
95 | 5.78 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=14584 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
96 | 0.50 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=14584 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
97 | 0.55 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=14584 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
98 | 20.03 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=14584 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
99 | 3.02 ms |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video FROM object_multimedia, contacts WHERE object_multimedia.idobject=contacts.idcontact AND object_multimedia.idmultimedia=14584 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
100 | 15.23 ms |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video FROM object_multimedia, contacts WHERE object_multimedia.idobject=contacts.idcontact AND object_multimedia.idmultimedia=14584 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
101 | 22.21 ms |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle FROM object_multimedia, spectacles WHERE object_multimedia.idobject=spectacles.idspectacle AND object_multimedia.idmultimedia=14584 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
102 | 0.52 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=26929
Parameters:
[]
|
||||||||||||||||||||||||||||
103 | 2.95 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=26929
Parameters:
[]
|
||||||||||||||||||||||||||||
104 | 16.90 ms |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid FROM object_multimedia, texts WHERE object_multimedia.idobject=texts.idtext AND object_multimedia.idmultimedia=14584 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
105 | 4.63 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=14584 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||
106 | 31.32 ms |
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters:
[
"13831"
]
|
||||||||||||||||||||||||||||
107 | 14.70 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=13831 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
108 | 7.49 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=13831 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
109 | 0.70 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=13831 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
110 | 4.64 ms |
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean FROM object_multimedia, persons WHERE object_multimedia.idobject=persons.idperson AND object_multimedia.idmultimedia=13831 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
111 | 20.86 ms |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video FROM object_multimedia, contacts WHERE object_multimedia.idobject=contacts.idcontact AND object_multimedia.idmultimedia=13831 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
112 | 5.20 ms |
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video FROM object_multimedia, contacts WHERE object_multimedia.idobject=contacts.idcontact AND object_multimedia.idmultimedia=13831 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
113 | 6.20 ms |
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle FROM object_multimedia, spectacles WHERE object_multimedia.idobject=spectacles.idspectacle AND object_multimedia.idmultimedia=13831 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
114 | 9.98 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=23999
Parameters:
[]
|
||||||||||||||||||||||||||||
115 | 0.66 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=23999
Parameters:
[]
|
||||||||||||||||||||||||||||
116 | 9.03 ms |
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid FROM object_multimedia, texts WHERE object_multimedia.idobject=texts.idtext AND object_multimedia.idmultimedia=13831 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||
117 | 13.24 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=13831 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||
118 | 5.28 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=9858 AND t.type=0 AND t.publish=1 ORDER BY datepublication DESC LIMIT 0,2
Parameters:
[]
|
||||||||||||||||||||||||||||
119 | 7.73 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=9858 ) ORDER BY datepublication DESC LIMIT 0,2
Parameters:
[]
|
||||||||||||||||||||||||||||
120 | 1.55 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=9858 ORDER BY datepublication DESC LIMIT 0,2
Parameters:
[]
|
||||||||||||||||||||||||||||
121 | 1.44 ms |
SELECT text_aide.*,aides.*,`text_aide`.`publish` as text_aide_publish FROM `aides` , `text_aide` WHERE 1 AND aides.`publish`=1 AND aides.`type_aide` IN (1) AND text_aide.`idtext` IN (32166) AND aides.`idaide`=text_aide.`idaide` ORDER BY text_aide.`date_start` DESC LIMIT 0,3
Parameters:
[]
|
||||||||||||||||||||||||||||
122 | 2.41 ms |
SELECT DISTINCT(podcasts.idpodcast), podcasts.* FROM `podcast_person` , `podcasts` WHERE 1 AND podcasts.`publish`=1 AND podcast_person.`idperson`=9858 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:
[]
|
||||||||||||||||||||||||||||
123 | 1.28 ms |
SELECT p0_.idpodcast AS idpodcast_0, p0_.title AS title_1, p0_.description AS description_2, p0_.title_program AS title_program_3, p0_.name_program AS name_program_4, p0_.date_podcast AS date_podcast_5, p0_.hour_podcast AS hour_podcast_6, p0_.code_franceinter AS code_franceinter_7, p0_.type_franceinter AS type_franceinter_8, p0_.integrate_player AS integrate_player_9, p0_.link AS link_10, p0_.duration AS duration_11, p0_.code_ft AS code_ft_12, p0_.is_integrale AS is_integrale_13, p0_.type_diffusion AS type_diffusion_14, p0_.fin_visionnage_ft AS fin_visionnage_ft_15, p0_.date_captation_ft AS date_captation_ft_16, p0_.debut_visionnage_ft AS debut_visionnage_ft_17, p0_.code_arte AS code_arte_18, p0_.code_soundcloud AS code_soundcloud_19, p0_.code_spotify AS code_spotify_20, p0_.url_file AS url_file_21, p0_.url_clean AS url_clean_22, p0_.dateupdate AS dateupdate_23, p0_.dateinsert AS dateinsert_24, p0_.publish AS publish_25, p0_.valid AS valid_26, p0_.idextranetuser AS idextranetuser_27 FROM podcasts p0_ WHERE p0_.idpodcast = ?
Parameters:
[
"4469"
]
|
||||||||||||||||||||||||||||
124 | 2.16 ms |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.idpodcast FROM theatreok_dev.spectacles j1, theatreok_dev.podcast_spectacle j2, theatreok_dev.podcasts j3 WHERE j3.idpodcast=j2.idpodcast AND j1.idspectacle=j2.idspectacle AND j3.idpodcast=4469
Parameters:
[]
|
||||||||||||||||||||||||||||
125 | 1.29 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=30199
Parameters:
[]
|
||||||||||||||||||||||||||||
126 | 0.77 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=32360
Parameters:
[]
|
||||||||||||||||||||||||||||
127 | 25.30 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=32362
Parameters:
[]
|
||||||||||||||||||||||||||||
128 | 0.08 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=32417
Parameters:
[]
|
||||||||||||||||||||||||||||
129 | 0.28 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=32540
Parameters:
[]
|
||||||||||||||||||||||||||||
130 | 1.17 ms |
SELECT j1.idcontact,j1.organisation,j1.url_clean ,j3.idpodcast FROM theatreok_dev.contacts j1, theatreok_dev.podcast_contact j2, theatreok_dev.podcasts j3 WHERE j3.idpodcast=j2.idpodcast AND j1.idcontact=j2.idcontact AND j3.idpodcast=4469
Parameters:
[]
|
||||||||||||||||||||||||||||
131 | 0.74 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean ,j3.idpodcast FROM theatreok_dev.persons j1, theatreok_dev.podcast_person j2, theatreok_dev.podcasts j3 WHERE j3.idpodcast=j2.idpodcast AND j1.idperson=j2.idperson AND j3.idpodcast=4469
Parameters:
[]
|
||||||||||||||||||||||||||||
132 | 0.61 ms |
SELECT j1.idtext,j1.title,j1.url_clean ,j3.idpodcast FROM theatreok_dev.texts j1, theatreok_dev.podcast_text j2, theatreok_dev.podcasts j3 WHERE j3.idpodcast=j2.idpodcast AND j1.idtext=j2.idtext AND j3.idpodcast=4469
Parameters:
[]
|
||||||||||||||||||||||||||||
133 | 0.61 ms |
SELECT url_file FROM podcasts WHERE idpodcast=4469
Parameters:
[]
|
||||||||||||||||||||||||||||
134 | 0.07 ms |
SELECT url_file FROM podcasts WHERE idpodcast=4469
Parameters:
[]
|
||||||||||||||||||||||||||||
135 | 0.87 ms |
SELECT COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* FROM `podcast_person` , `podcasts` WHERE 1 AND podcasts.`publish`=1 AND podcast_person.`idperson`=9858 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:
[]
|
||||||||||||||||||||||||||||
136 | 0.08 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:
[]
|
||||||||||||||||||||||||||||
137 | 0.07 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:
[]
|
||||||||||||||||||||||||||||
138 | 0.09 ms |
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters:
[
4
]
|
||||||||||||||||||||||||||||
139 | 0.46 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
9703
]
|
||||||||||||||||||||||||||||
140 | 0.54 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=9703 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
141 | 2.19 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=10410 ORDER BY p.`lastname`
Parameters:
[]
|
||||||||||||||||||||||||||||
142 | 17.92 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:
[ 10410 "2024-04-27" ]
|
||||||||||||||||||||||||||||
143 | 0.43 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=10410 AND sp.idperson=9858
Parameters:
[]
|
||||||||||||||||||||||||||||
144 | 0.20 ms |
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters:
[
4
]
|
||||||||||||||||||||||||||||
145 | 0.51 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
7570
]
|
||||||||||||||||||||||||||||
146 | 0.78 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=7570 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
147 | 1.37 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=32416 ORDER BY p.`lastname`
Parameters:
[]
|
||||||||||||||||||||||||||||
148 | 1.81 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:
[ 32416 "2024-04-27" ]
|
||||||||||||||||||||||||||||
149 | 1.52 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=32416 AND sp.idperson=9858
Parameters:
[]
|
||||||||||||||||||||||||||||
150 | 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
]
|
||||||||||||||||||||||||||||
151 | 0.65 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
33488
]
|
||||||||||||||||||||||||||||
152 | 0.66 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=33488 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
153 | 1.74 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=26929 ORDER BY p.`lastname`
Parameters:
[]
|
||||||||||||||||||||||||||||
154 | 1.81 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:
[ 26929 "2024-04-27" ]
|
||||||||||||||||||||||||||||
155 | 0.78 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=26929 AND sp.idperson=9858
Parameters:
[]
|
||||||||||||||||||||||||||||
156 | 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
]
|
||||||||||||||||||||||||||||
157 | 10.57 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
42573
]
|
||||||||||||||||||||||||||||
158 | 2.98 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=42573 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
159 | 2.18 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=34316 ORDER BY p.`lastname`
Parameters:
[]
|
||||||||||||||||||||||||||||
160 | 3.88 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:
[ 34316 "2024-04-27" ]
|
||||||||||||||||||||||||||||
161 | 0.37 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=34316 AND sp.idperson=9858
Parameters:
[]
|
||||||||||||||||||||||||||||
162 | 0.94 ms |
SELECT DISTINCT(T1.`idtext`), T1.`title`,T1.`url_clean`,T1.`publication_year`,T1.`publication_month`,T1.`isbn`,T1.`textfictif`,T1.`dateinsert`,T1.`textorder`,T1.`type`,T1.`publish`,T1.`statut`,T1.`valid`,T2.`idcontact`,T2.`url_clean` as `url_clean_publisher`,T2.`organisation`, CONCAT(T1.`publication_year`, T1.`publication_month`) AS publication_date, CAST(CONCAT(T1.`publication_year`, T1.`publication_month`) AS DATE) AS publication_date_full FROM texts T1 LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` ,text_aide tai, aides ai, aidecontacts aic WHERE 1 AND tai.`idtext`=T1.`idtext` AND tai.`idaide`=ai.`idaide` AND ai.`idaidecontact`=aic.`idaidecontact` AND aic.`idaidecontact`=25 AND T1.`idtext` IN (32166) GROUP BY T1.idtext ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) DESC LIMIT 0,30
Parameters:
[]
|
||||||||||||||||||||||||||||
163 | 0.42 ms |
SELECT text_aide.*,aides.*,`text_aide`.`publish` as text_aide_publish FROM `aides` , `text_aide` WHERE 1 AND aides.`publish`=1 AND aides.`type_aide` IN (2,3) AND text_aide.`idtext` IN (32166) AND aides.`idaide`=text_aide.`idaide` ORDER BY text_aide.`date_start` DESC LIMIT 0,3
Parameters:
[]
|
||||||||||||||||||||||||||||
164 | 1.04 ms |
SELECT text_aide.*,aides.*,`text_aide`.`publish` as text_aide_publish FROM `aides` , `text_aide` WHERE 1 AND aides.`publish`=1 AND aides.`type_aide` IN (4) AND text_aide.`idtext` IN (32166) AND aides.`idaide`=text_aide.`idaide` ORDER BY text_aide.`date_start` DESC LIMIT 0,3
Parameters:
[]
|
||||||||||||||||||||||||||||
165 | 0.52 ms |
SELECT person_ecole.*, contacts.`organisation`, contacts.`url_clean` FROM person_ecole JOIN contacts ON contacts.`idcontact`=person_ecole.`idcontact` WHERE person_ecole.`idperson`=9858 AND contacts.`idcontact`!=3914
Parameters:
[]
|
||||||||||||||||||||||||||||
166 | 2.38 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 (9858) AND c.`classification`='class_auteur_meme'
Parameters:
[]
|
||||||||||||||||||||||||||||
167 | 2.07 ms |
SELECT DISTINCT(dvds.iddvd), dvds.* FROM `dvd_spectacle` , `dvds` WHERE 1 AND dvds.`publish`=1 AND dvd_spectacle.`idspectacle` IN (3411,3526,3531,4855,5355,6506,7107,7199,7881,10380,10393,10396,10410,11840,12530,15268,15307,15334,15337,15339,15343,19414,19680,19768,22631,23569,23999,24066,25398,25850,26929,27133,28238,30377,30750,30872,31330,32416,32417,34316) AND dvds.`iddvd`=dvd_spectacle.`iddvd` GROUP BY dvds.iddvd ORDER BY dvds.dateinsert DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||
168 | 0.26 ms |
SELECT DISTINCT(dvds.iddvd), dvds.* FROM `dvd_spectacle` , `dvds` WHERE 1 AND dvds.`publish`=1 AND dvd_spectacle.`idspectacle` IN (3411,3526,3531,4855,5355,6506,7107,7199,7881,10380,10393,10396,10410,11840,12530,15268,15307,15334,15337,15339,15343,19414,19680,19768,22631,23569,23999,24066,25398,25850,26929,27133,28238,30377,30750,30872,31330,32416,32417,34316) AND dvds.`iddvd`=dvd_spectacle.`iddvd` GROUP BY dvds.iddvd ORDER BY dvds.dateinsert DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||
169 | 0.07 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (6))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||
170 | 3.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='9858' AND oc.object='persons' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.idclassification IN (6)))
Parameters:
[]
|
||||||||||||||||||||||||||||
171 | 1.54 ms |
SELECT COUNT(DISTINCT(text_aide.idtextaide)) as total , text_aide.*,aides.*,`text_aide`.`publish` as text_aide_publish FROM `aides` , `text_aide` WHERE 1 AND aides.`publish`=1 AND aides.`type_aide` IN (2,3) AND text_aide.`idtext` IN (32166) AND aides.`idaide`=text_aide.`idaide` LIMIT 0,100
Parameters:
[]
|
||||||||||||||||||||||||||||
172 | 0.07 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 (9858) AND c.`classification`='class_auteur_meme'
Parameters:
[]
|
||||||||||||||||||||||||||||
173 | 2.73 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 (3411,3526,3531,4855,5355,6506,7107,7199,7881,10380,10393,10396,10410,11840,12530,15268,15307,15334,15337,15339,15343,19414,19680,19768,22631,23569,23999,24066,25398,25850,26929,27133,28238,30377,30750,30872,31330,32416,32417,34316) AND s.date>='2024-04-27' ORDER BY s.date ASC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||
174 | 0.07 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_biotextes'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||
175 | 0.73 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='9858' AND oc.object='persons' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_biotextes')))
Parameters:
[]
|
||||||||||||||||||||||||||||
176 | 16.61 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=9858 ) AND T1.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||
177 | 0.99 ms |
SELECT COUNT(DISTINCT(m.idmultimedia)) FROM object_multimedia om, multimedias m WHERE om.idmultimedia=m.idmultimedia AND om.idobject=9858 AND om.object='persons' AND m.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||
178 | 9.74 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`=9858 AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||
179 | 0.44 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`=9858 AND d.code_soundcloud IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||
180 | 2.19 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 (32166) ORDER BY publication_year DESC
Parameters:
[]
|
||||||||||||||||||||||||||||
181 | 3.51 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 (3411,3526,3531,4855,5355,6506,7107,7199,7881,10380,10393,10396,10410,11840,12530,15268,15307,15334,15337,15339,15343,19414,19680,19768,22631,23569,23999,24066,25398,25850,26929,27133,28238,30377,30750,30872,31330,32416,32417,34316) 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:
[]
|
||||||||||||||||||||||||||||
182 | 1.13 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:
[ "0563abb7eb36aabbbc0433e0e7128a9b-1e05" 0 "1c0d547f6f2694af8f8476be972da30b" ]
|
||||||||||||||||||||||||||||
183 | 1.74 ms |
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "article" "thnet" "/biographies/VARUPENNE-Stephane/" "1c0d547f6f2694af8f8476be972da30b" 0 "persons" 9858 0 "fr" "0563abb7eb36aabbbc0433e0e7128a9b-1e05" "/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553" ]
|
||||||||||||||||||||||||||||
184 | 0.09 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||
185 | 0.14 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='9858' 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:
[]
|
||||||||||||||||||||||||||||
186 | 1.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