https://preprod.theatre-contemporain.net/video/Baptiste-Amann-La-Truite-l-origine-de-l-ecriture?path=video%2FBaptiste-Amann-La-Truite-l-origine-de-l-ecriture

Method
GET
HTTP Status
200
IP
54.208.238.160
Profiled on
Token
514022

Query Metrics

106 Database Queries
93 Different statements
165.94 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time▼ Count Info
11.18 ms
(6.74%) 		7 
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: 
[
  "10017"
]
View formatted query    View runnable query    Explain query    View query backtrace
8.17 ms
(4.92%) 		1 
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=15022
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
8.00 ms
(4.82%) 		1 
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=15022
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.44 ms
(4.48%) 		1 
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=15022
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.24 ms
(4.36%) 		1 
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=12064
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.62 ms
(3.39%) 		1 
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=13324
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.56 ms
(3.35%) 		1 
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=13324
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.53 ms
(3.33%) 		1 
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=13324
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.14 ms
(3.10%) 		1 
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=12064
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.78 ms
(2.88%) 		1 
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=11204
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.36 ms
(2.63%) 		1 
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=11204
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.21 ms
(2.54%) 		1 
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=15022
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3.85 ms
(2.32%) 		2 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  "23958"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.71 ms
(2.24%) 		1 
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=15022
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3.21 ms
(1.93%) 		1 
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=13324
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3.18 ms
(1.91%) 		1 
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=7719
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.89 ms
(1.74%) 		1 
SELECT * FROM multimedias
                WHERE idmultimedia IN (12064,7719,15022,13324,11204,7841)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.75 ms
(1.66%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=10017 AND object_multimedia.idrole IS NULL ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.73 ms
(1.65%) 		1 
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=11204
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.37 ms
(1.43%) 		2 
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=23958  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.34 ms
(1.41%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=10017 AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.28 ms
(1.37%) 		1 
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=10017
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.15 ms
(1.29%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=10017 AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.01 ms
(1.21%) 		1 
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=7719
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.95 ms
(1.18%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=5689
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.90 ms
(1.14%) 		1 
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=11204
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.81 ms
(1.09%) 		1 
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=13324
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.78 ms
(1.07%) 		1 
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=7841
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.73 ms
(1.04%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=10017 AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.71 ms
(1.03%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=23958
                AND om.object='contents'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.66 ms
(1.00%) 		1 
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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.63 ms
(0.98%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=10017 AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.60 ms
(0.97%) 		2 
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=5689
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.50 ms
(0.90%) 		2 
SELECT  DISTINCT(dvds.iddvd), dvds.* 
FROM  `dvd_multimedia` ,
 `dvds`  
 WHERE 1  AND dvds.`publish`=1  AND dvd_multimedia.`idmultimedia` IN (10017) AND dvds.`iddvd`=dvd_multimedia.`iddvd` 
GROUP BY dvds.iddvd 
ORDER BY dvds.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.43 ms
(0.86%) 		1 
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=11204
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.37 ms
(0.82%) 		1 
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=7719
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.27 ms
(0.77%) 		1 
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=15022
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.21 ms
(0.73%) 		2 
SELECT idtext,title,type,url_clean,valid
                        FROM texts
                        WHERE idtext=23958
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.18 ms
(0.71%) 		1 
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=7841
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.11 ms
(0.67%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=11204 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.11 ms
(0.67%) 		1 
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=12064
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.07 ms
(0.65%) 		1 
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=12064
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(0.64%) 		1 
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=13324
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.00 ms
(0.60%) 		1 
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=13324
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.98 ms
(0.59%) 		1 
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=11204
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.95 ms
(0.57%) 		1 
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=15022
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(0.55%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15022 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.89 ms
(0.54%) 		1 
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=7719
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.86 ms
(0.52%) 		1 
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=12064
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.83 ms
(0.50%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=7719 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.82 ms
(0.50%) 		1 
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=13324
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.81 ms
(0.49%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=23958
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.79 ms
(0.48%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=10017 AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.79 ms
(0.48%) 		1 
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=12064
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.78 ms
(0.47%) 		1 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=25641
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.75 ms
(0.45%) 		1 
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=7841
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(0.43%) 		1 
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=7719
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.70 ms
(0.42%) 		1 
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=15022
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(0.41%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=10017 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(0.41%) 		1 
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=10017
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(0.41%) 		1 
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=7719
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(0.41%) 		2 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=16025
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(0.38%) 		1 
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=7719
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.34%) 		1 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=22403
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.34%) 		1 
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=7841
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(0.34%) 		1 
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=7841
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(0.32%) 		1 
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=12064
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(0.31%) 		1 
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=7841
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(0.29%) 		1 
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=10017
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(0.29%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=5689
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(0.28%) 		1 
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=10017
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.27%) 		1 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=25641
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.26%) 		1 
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=7841
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.26%) 		1 
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=11204
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(0.25%) 		1 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=30604
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(0.25%) 		1 
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=7841
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.24%) 		1 
SELECT idmultimedia FROM multimedias WHERE url_clean='Baptiste-Amann-La-Truite-l-origine-de-l-ecriture'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.24%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=10017 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.23%) 		1 
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=10017
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.22%) 		1 
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=11204
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.21%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=7841 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.20%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=10017 AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.20%) 		1 
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=10017
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.20%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=13324 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.20%) 		2 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=16025
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.17%) 		1 
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=7719
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.15%) 		1 
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=12064
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.15%) 		1 
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=10017
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.14%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=12064 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.13%) 		1 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=22403
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.12%) 		1 
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=10017
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.10%) 		1 
SELECT l.fr
                      FROM typesmultimedias tm,langterms l
                      WHERE tm.typemultimedia=l.id
                      AND tm.idtypemultimedia=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.05 ms
(0.03%) 		1 
SELECT fr FROM languages WHERE id='fr'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Entities Mapping

Class Mapping errors
TheatreCore\Entity\Extranetusers No errors.
TheatreCore\Entity\Multimedias No errors.
TheatreCore\Entity\Typesmultimedias No errors.
TheatreCore\Entity\Contacts No errors.
TheatreCore\Entity\Dvds No errors.
TheatreCore\Entity\Classifications No errors.
TheatreCore\Entity\Keywords No errors.
TheatreCore\Entity\Spectacles No errors.
TheatreCore\Entity\Playlists No errors.
TheatreCore\Entity\ObjectMultimedia No errors.
TheatreCore\Entity\Persons No errors.
TheatreCore\Entity\Texts No errors.
TheatreCore\Entity\Contents No errors.
TheatreCore\Entity\Abonnements No errors.
TheatreCore\Entity\Bannieres No errors.