https://preprod.theatre-contemporain.net/biographies/Simon-Falguieres/videos/type/all?path=biographies%2FSimon-Falguieres%2Fvideos%2Ftype%2Fall

Method
GET
HTTP Status
200
IP
18.222.119.148
Profiled on
Token
260fcf

Query Metrics

246 Database Queries
202 Different statements
331.75 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time▼ Count Info
11.89 ms
(3.58%) 		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=16447
                    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
11.15 ms
(3.36%) 		17 
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: 
[
  "16802"
]
View formatted query    View runnable query    Explain query    View query backtrace
9.60 ms
(2.89%) 		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=16447
                    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
9.25 ms
(2.79%) 		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=16447
                    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
9.12 ms
(2.75%) 		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=16354
                    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
8.32 ms
(2.51%) 		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=16447
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.93 ms
(2.39%) 		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=16354
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.44 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=16354
                    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
7.41 ms
(2.23%) 		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=16378
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.39 ms
(2.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=16354
                    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
6.38 ms
(1.92%) 		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=16447
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6.32 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=16378
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6.25 ms
(1.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=15770
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6.10 ms
(1.84%) 		1 
SELECT DISTINCT(m.idmultimedia),m.*
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=55469
                AND om.object='persons'
                AND m.publish=1 ORDER BY m.date DESC LIMIT 0, 20
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.77 ms
(1.74%) 		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=16354
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.65 ms
(1.70%) 		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=16718
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.43 ms
(1.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=16447
                    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.18 ms
(1.56%) 		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=15895
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.18 ms
(1.56%) 		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=15771
                    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
(1.55%) 		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=15896
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.12 ms
(1.54%) 		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=16607
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.11 ms
(1.54%) 		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=15891
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.98 ms
(1.50%) 		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=15892
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.93 ms
(1.49%) 		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=15949
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.90 ms
(1.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=16607
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.88 ms
(1.47%) 		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=16718
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.81 ms
(1.45%) 		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=15894
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.77 ms
(1.44%) 		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=15770
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.75 ms
(1.43%) 		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=15892
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.70 ms
(1.42%) 		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=15896
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.40 ms
(1.33%) 		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=15771
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.37 ms
(1.32%) 		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=15891
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.31 ms
(1.30%) 		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=15894
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.27 ms
(1.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=15949
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.22 ms
(1.27%) 		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=15895
                    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
(1.27%) 		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=16378
                    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
3.84 ms
(1.16%) 		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=15770
                    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
3.70 ms
(1.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=16354
                    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
3.69 ms
(1.11%) 		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=14301
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3.23 ms
(0.97%) 		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=16607
                    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
3.14 ms
(0.95%) 		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=15894
                    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
3.12 ms
(0.94%) 		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=15891
                    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
3.11 ms
(0.94%) 		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=15771
                    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
3.10 ms
(0.93%) 		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=16718
                    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
3.05 ms
(0.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=15896
                    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
3.03 ms
(0.91%) 		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=15949
                    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.85 ms
(0.86%) 		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=15892
                    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.69 ms
(0.81%) 		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=15895
                    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.12 ms
(0.64%) 		1 
SELECT  DISTINCT(multimedias.idmultimedia), multimedias.* 
FROM  `object_multimedia` ,
 `multimedias`  
 WHERE 1  AND multimedias.`audio_video`=2  AND multimedias.`publish`=1  AND object_multimedia.`object` IN ('persons')  AND object_multimedia.`idobject`=55469 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.date 
DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.09 ms
(0.63%) 		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=14301
                    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.07 ms
(0.63%) 		1 
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "article"
  "thnet"
  "/biographies/Simon-Falguieres/videos/type/all"
  "b29fa8c72a846b17bbb98f7d50736c4b"
  0
  "persons"
  55469
  0
  "fr"
  "c1fb8c477475572d54cb8eb506e2bff7-cdbe"
  "/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.74 ms
(0.52%) 		1 
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND t2_.idtext IN (29538, 33399, 36242, 43147) ORDER BY s1_.date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.65 ms
(0.50%) 		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.40 ms
(0.42%) 		1 
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 (15176,23841,26841,29366,34839)  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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.35 ms
(0.41%) 		2 
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=55469
                AND om.object='persons'
                AND m.publish=1 ORDER BY m.date DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.32 ms
(0.40%) 		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=16447
                    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.17 ms
(0.35%) 		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=15770
                    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.14 ms
(0.34%) 		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=16378
                    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.02 ms
(0.31%) 		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=15892
                    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.99 ms
(0.30%) 		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=16378
                    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.93 ms
(0.28%) 		1 
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 (15176,23841,26841,29366,34839) AND s.date>='2024-04-19' ORDER BY s.date ASC LIMIT 0,1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.87 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=15894
                    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.85 ms
(0.25%) 		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=15770
                    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.84 ms
(0.25%) 		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=16802
                    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.25%) 		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=16802
                    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.80 ms
(0.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=15771
                    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.79 ms
(0.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=16447
                    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.78 ms
(0.23%) 		1 
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=55469
                AND om.object='persons'
                AND m.publish=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.76 ms
(0.23%) 		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=16802
                    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.76 ms
(0.23%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15894 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.75 ms
(0.23%) 		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=15895
                    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.74 ms
(0.22%) 		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=15949
                    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.71 ms
(0.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=16378
                    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.68 ms
(0.21%) 		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=16354
                    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.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=16378
                    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.20%) 		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=15891
                    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.67 ms
(0.20%) 		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=15896
                    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.64 ms
(0.19%) 		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=15895
                    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.64 ms
(0.19%) 		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=17355
                    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.63 ms
(0.19%) 		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=15894
                    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.63 ms
(0.19%) 		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=16718
                    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.63 ms
(0.19%) 		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=16338
                    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.63 ms
(0.19%) 		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=16802
                    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.62 ms
(0.19%) 		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=15771
                    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.61 ms
(0.18%) 		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=15896
                    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.61 ms
(0.18%) 		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=16607
                    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.60 ms
(0.18%) 		1 
SELECT r.idrole, r.role, r.role_male, r.role_female, lg.fr
                FROM
                    spectacle_person sp
                    JOIN roles r ON sp.idrole=r.idrole
                    JOIN langterms lg ON lg.id=r.role
                WHERE sp.idperson=55469
                GROUP BY r.idrole
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(0.18%) 		1 
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: 
[
  "c1fb8c477475572d54cb8eb506e2bff7-cdbe"
  0
  "b29fa8c72a846b17bbb98f7d50736c4b"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(0.18%) 		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=15771
                    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.57 ms
(0.17%) 		1 
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 (29538,33399,36242,43147)  ORDER BY publication_year DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.17%) 		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=14301
                    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.57 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=14301
                    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.56 ms
(0.17%) 		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=15892
                    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.53 ms
(0.16%) 		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=15895
                    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.53 ms
(0.16%) 		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=15949
                    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.53 ms
(0.16%) 		6 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=29366
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(0.16%) 		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=16802
                    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.50 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=16802
                    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.50 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=15770
                    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.50 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=16354
                    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.50 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=16378
                    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.49 ms
(0.15%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15896 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.48 ms
(0.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=14301
                    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.47 ms
(0.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=16607
                    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.46 ms
(0.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=15892
                    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.45 ms
(0.13%) 		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=15771
                    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.44 ms
(0.13%) 		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=15770
                    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.44 ms
(0.13%) 		6 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=29366
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 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=15891
                    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.41 ms
(0.12%) 		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=16338
                    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.41 ms
(0.12%) 		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=16802
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.12%) 		1 
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`=55469 AND d.code_franceinter IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 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=15770
                    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.39 ms
(0.12%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=16447 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.39 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=17355
                    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.39 ms
(0.12%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15770 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.39 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=16718
                    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.38 ms
(0.11%) 		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=16802
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.11%) 		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=15896
                    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.37 ms
(0.11%) 		1 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=26841
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.11%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=16338 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.37 ms
(0.11%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15892 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.36 ms
(0.11%) 		5 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=23841
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.11%) 		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=15771
                    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.36 ms
(0.11%) 		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=15895
                    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.36 ms
(0.11%) 		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=17355
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.11%) 		1 
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=55469 ) AND T1.publish=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.10%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=16802 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.10%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15895 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.10%) 		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=15949
                    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.32 ms
(0.10%) 		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=14301
                    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.32 ms
(0.10%) 		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=16607
                    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.32 ms
(0.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=16338
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.10%) 		2 
SELECT  COUNT(DISTINCT(dvds.iddvd)) as total  
FROM  `dvds` ,
 `dvd_spectacle`  
 WHERE 1  AND dvds.`publish`=1  AND dvd_spectacle.`idspectacle` IN (15176,23841,26841,29366,34839) AND dvds.`iddvd`=dvd_spectacle.`iddvd`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.10%) 		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=15949
                    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.32 ms
(0.10%) 		1 
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 (55469)  AND c.`classification`='class_auteur_meme'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.09%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15771 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.31 ms
(0.09%) 		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=17355
                    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.31 ms
(0.09%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=16607 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.31 ms
(0.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=16607
                    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.31 ms
(0.09%) 		1 
SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson`=55469  AND podcasts.`code_ft` IS NOT NULL AND podcasts.`debut_visionnage_ft`<='2024-04-19' AND podcasts.`fin_visionnage_ft`>'2024-04-19' AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0)  AND podcasts.`is_integrale`=1 AND podcasts.`idpodcast`=podcast_person.`idpodcast`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.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=16338
                    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.30 ms
(0.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=16718
                    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.29 ms
(0.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=16718
                    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.29 ms
(0.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=16607
                    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.28 ms
(0.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=15894
                    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.28 ms
(0.09%) 		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=15894
                    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.28 ms
(0.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=15894
                    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.28 ms
(0.08%) 		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=15896
                    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.28 ms
(0.08%) 		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=16338
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.08%) 		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=15895
                    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.28 ms
(0.08%) 		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=15896
                    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.27 ms
(0.08%) 		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=14301
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.08%) 		7 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=23841
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.08%) 		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=15891
                    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.27 ms
(0.08%) 		1 
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`=55469 AND d.code_soundcloud IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.08%) 		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=16338
                    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.26 ms
(0.08%) 		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=16718
                    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.26 ms
(0.08%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15949 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.26 ms
(0.08%) 		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=17355
                    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.25 ms
(0.08%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15891 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.25 ms
(0.08%) 		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=15949
                    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.25 ms
(0.07%) 		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=15891
                    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.25 ms
(0.07%) 		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=15892
                    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.25 ms
(0.07%) 		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=16338
                    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.24 ms
(0.07%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=16718 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.24 ms
(0.07%) 		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=17355
                    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.07%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=16378 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.24 ms
(0.07%) 		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=15891
                    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.24 ms
(0.07%) 		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=15892
                    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.24 ms
(0.07%) 		1 
SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson`=55469  AND podcasts.`code_ft` IS NOT NULL  AND podcasts.`type_diffusion`=1 AND podcasts.`idpodcast`=podcast_person.`idpodcast`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.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=14301
                    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.23 ms
(0.07%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=16354 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.23 ms
(0.07%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=14301 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.22 ms
(0.07%) 		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=17355
                    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.22 ms
(0.07%) 		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=16338
                    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.21 ms
(0.06%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=17355 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.06%) 		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=17355
                    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.20 ms
(0.06%) 		1 
SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_person` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_person.`idperson`=55469  AND podcasts.`code_ft` IS NOT NULL  AND podcasts.`type_diffusion`=2 AND podcasts.`idpodcast`=podcast_person.`idpodcast`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.05%) 		2 
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='55469'
                   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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.04%) 		2 
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.04%) 		1 
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=113535
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.04%) 		1 
SELECT fr FROM countries WHERE id='FR'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.04%) 		1 
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: 
[
  55469
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.04%) 		1 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=26841
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.04%) 		1 
SELECT COUNT(DISTINCT(t.idtext))
                FROM text_author ta, texts t
                WHERE t.idtext=ta.idtext AND t.textfictif=0
                AND ta.idperson=55469 AND t.publish=1 AND t.type IN (0,2)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(0.03%) 		2 
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`=55469 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(0.03%) 		1 
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='55469'
                   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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(0.03%) 		2 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=17355
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(0.03%) 		1 
SELECT t.`idtext`
                           FROM text_author ta
                           JOIN texts t ON ta.`idtext`=t.`idtext`
                           WHERE ta.`idperson` IN (55469)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(0.02%) 		2 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=16802
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.07 ms
(0.02%) 		1 
SELECT idperson FROM persons WHERE url_clean='Simon-Falguieres'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.07 ms
(0.02%) 		2 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=16607
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.05 ms
(0.01%) 		1 
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=55469  AND j2.idoffice=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.04 ms
(0.01%) 		1 
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_biotxt'))) AND persons=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.04 ms
(0.01%) 		1 
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 (55469)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.04 ms
(0.01%) 		1 
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=55469 AND t.publish=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.04 ms
(0.01%) 		1 
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 (15176,23841,26841,29366,34839)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.04 ms
(0.01%) 		1 
SELECT COUNT(DISTINCT(sp.idspectacle)) as total
                FROM spectacle_person sp, spectacles s
                WHERE 1
                AND sp.idspectacle=s.idspectacle
                AND sp.idperson=55469
                AND sp.idrole=1 AND s.publish=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.04 ms
(0.01%) 		1 
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 (55469)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.03 ms
(0.01%) 		1 
SELECT fr FROM languages WHERE id='fr'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.03 ms
(0.01%) 		1 
SELECT t.`idtext`
                               FROM text_translator tt
                               JOIN texts t ON tt.`idtext`=t.`idtext`
                               WHERE
                               tt.`idperson` IN (55469)
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\Persons No errors.
TheatreCore\Entity\Contents No errors.
TheatreCore\Entity\Multimedias No errors.
TheatreCore\Entity\Countries No errors.
TheatreCore\Entity\Roles No errors.
TheatreCore\Entity\News No errors.
TheatreCore\Entity\Classifications No errors.
TheatreCore\Entity\Contacts No errors.
TheatreCore\Entity\Podcasts No errors.
TheatreCore\Entity\Spectacles No errors.
TheatreCore\Entity\Texts No errors.
TheatreCore\Entity\Files No errors.
TheatreCore\Entity\ObjectMultimedia No errors.
TheatreCore\Entity\Typesmultimedias No errors.
TheatreCore\Entity\Dvds No errors.
TheatreCore\Entity\Keywords No errors.
TheatreCore\Entity\Playlists No errors.
TheatreCore\Entity\Typesspectacles No errors.
TheatreCore\Entity\Schedules No errors.
TheatreCore\Entity\ObjectContent No errors.
TheatreCore\Entity\BookmarkExtranetuser No errors.
TheatreCore\Entity\Stats No errors.
TheatreCore\Entity\Abonnements No errors.
TheatreCore\Entity\Bannieres No errors.