https://preprod.theatre-contemporain.net/video/tmpurl_g0cLjvZ8?autostart=&path=video%2Ftmpurl_g0cLjvZ8

Method
GET
HTTP Status
200
IP
52.54.103.76
Profiled on
Token
0640b0

Query Metrics

199 Database Queries
153 Different statements
621.98 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time▼ Count Info
35.63 ms
(5.73%) 		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=6678
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
26.19 ms
(4.21%) 		4 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=29897
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
24.62 ms
(3.96%) 		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=15672
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
23.71 ms
(3.81%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14583 AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
19.06 ms
(3.06%) 		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=15672
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
18.92 ms
(3.04%) 		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=13046
                    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
18.30 ms
(2.94%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14583 AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
17.07 ms
(2.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=16589
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
16.76 ms
(2.69%) 		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=15672
                    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
16.67 ms
(2.68%) 		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=16589
                    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
15.39 ms
(2.47%) 		1 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=14134
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
13.34 ms
(2.14%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=22443
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
12.72 ms
(2.04%) 		1 
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
12.64 ms
(2.03%) 		2 
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=22443
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
11.28 ms
(1.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=14583
                    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
11.28 ms
(1.81%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=14581 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
11.22 ms
(1.80%) 		6 
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=37005  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
10.97 ms
(1.76%) 		1 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=7460
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
10.73 ms
(1.73%) 		3 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  "37006"
]
View formatted query    View runnable query    Explain query    View query backtrace
10.40 ms
(1.67%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=79549
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
10.01 ms
(1.61%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=18207
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
9.92 ms
(1.59%) 		7 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  "14583"
]
View formatted query    View runnable query    Explain query    View query backtrace
9.24 ms
(1.49%) 		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=14583
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
8.67 ms
(1.39%) 		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=14581
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
8.64 ms
(1.39%) 		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=14583
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
8.43 ms
(1.36%) 		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=13046
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.96 ms
(1.28%) 		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=16589
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.83 ms
(1.26%) 		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=13046
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.45 ms
(1.20%) 		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=14581
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6.62 ms
(1.06%) 		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=6678
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6.58 ms
(1.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=16589
                    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
6.10 ms
(0.98%) 		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=14581
                    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.00 ms
(0.80%) 		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=14583
                    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
4.87 ms
(0.78%) 		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=5535
                    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
4.65 ms
(0.75%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14583 AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.47 ms
(0.72%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=24469
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.37 ms
(0.70%) 		1 
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts
                WHERE 1
                AND ts.idspectacle=29897
                AND t.idtext=ts.idtext
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.09 ms
(0.66%) 		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
                            INNER JOIN contacts T4 ON T4.idcontact=T3.idcontact  LEFT JOIN new_spectacle T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idspectacle=29897 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.04 ms
(0.65%) 		3 
SELECT t0_.idtext AS idtext_0, t0_.type AS type_1, t0_.idtypetext AS idtypetext_2, t0_.special_text AS special_text_3, t0_.title AS title_4, t0_.subtitle AS subtitle_5, t0_.date AS date_6, t0_.language AS language_7, t0_.markdown AS markdown_8, t0_.abstract AS abstract_9, t0_.abstract_author AS abstract_author_10, t0_.abstract_date AS abstract_date_11, t0_.abstract_url AS abstract_url_12, t0_.publisher_url_text AS publisher_url_text_13, t0_.publication_year AS publication_year_14, t0_.publication_month AS publication_month_15, t0_.isbn AS isbn_16, t0_.ean AS ean_17, t0_.publishinfos AS publishinfos_18, t0_.urltextaccess AS urltextaccess_19, t0_.emailtextaccess AS emailtextaccess_20, t0_.idfiletextaccess AS idfiletextaccess_21, t0_.filetextaccesssave AS filetextaccesssave_22, t0_.textaccessmore AS textaccessmore_23, t0_.request_translation_text AS request_translation_text_24, t0_.request_performing_text AS request_performing_text_25, t0_.help_translation AS help_translation_26, t0_.help_publishing AS help_publishing_27, t0_.help_other AS help_other_28, t0_.moreinfo AS moreinfo_29, t0_.nmale AS nmale_30, t0_.nfemale AS nfemale_31, t0_.npeople AS npeople_32, t0_.textorder AS textorder_33, t0_.nbpages AS nbpages_34, t0_.price AS price_35, t0_.selection_aneth AS selection_aneth_36, t0_.idtext_aneth AS idtext_aneth_37, t0_.aide_creation AS aide_creation_38, t0_.comments AS comments_39, t0_.url_clean AS url_clean_40, t0_.textfictif AS textfictif_41, t0_.valid_opendata AS valid_opendata_42, t0_.dateupdate AS dateupdate_43, t0_.dateinsert AS dateinsert_44, t0_.publish AS publish_45, t0_.statut AS statut_46, t0_.valid AS valid_47, e1_.idextranetuser AS idextranetuser_48, e1_.lastname AS lastname_49, e1_.firstname AS firstname_50, e1_.avatar AS avatar_51, e1_.signature AS signature_52, e1_.email AS email_53, e1_.token AS token_54, e1_.public_api_token AS public_api_token_55, e1_.public_api_desc AS public_api_desc_56, e1_.address AS address_57, e1_.zip AS zip_58, e1_.city AS city_59, e1_.secteur AS secteur_60, e1_.structure AS structure_61, e1_.fonction AS fonction_62, e1_.phone AS phone_63, e1_.enseignant_fonction AS enseignant_fonction_64, e1_.enseignant_matiere AS enseignant_matiere_65, e1_.enseignant_etablissement AS enseignant_etablissement_66, e1_.enseignant_qualite AS enseignant_qualite_67, e1_.enseignant_precision_qualite AS enseignant_precision_qualite_68, e1_.enseignant_active AS enseignant_active_69, e1_.stats_acces AS stats_acces_70, e1_.alerte_bac AS alerte_bac_71, e1_.email_validation AS email_validation_72, e1_.connexion_theduc AS connexion_theduc_73, e1_.inscription_from AS inscription_from_74, e1_.private_comment AS private_comment_75, e1_.login AS login_76, e1_.other_email AS other_email_77, e1_.code_chge_email AS code_chge_email_78, e1_.old_login AS old_login_79, e1_.password AS password_80, e1_.thnetuser AS thnetuser_81, e1_.last_visit_annonces AS last_visit_annonces_82, e1_.address_ip AS address_ip_83, e1_.verified AS verified_84, e1_.activekey AS activekey_85, e1_.token_cookie AS token_cookie_86, e1_.date_resend AS date_resend_87, e1_.tokenpass AS tokenpass_88, e1_.sub_subscriber_id AS sub_subscriber_id_89, e1_.userrights AS userrights_90, e1_.special_user AS special_user_91, e1_.pseudo_streaming AS pseudo_streaming_92, e1_.contact_owner AS contact_owner_93, e1_.justification AS justification_94, e1_.sent AS sent_95, e1_.dateupdate AS dateupdate_96, e1_.dateinsert AS dateinsert_97, e1_.active AS active_98, c2_.idcontact AS idcontact_99, c2_.type AS type_100, c2_.organisation AS organisation_101, c2_.nom_suite AS nom_suite_102, c2_.lastname AS lastname_103, c2_.firstname AS firstname_104, c2_.idtypestructure AS idtypestructure_105, c2_.license AS license_106, c2_.comment AS comment_107, c2_.private_comment AS private_comment_108, c2_.address1 AS address1_109, c2_.address2 AS address2_110, c2_.zip AS zip_111, c2_.city AS city_112, c2_.phone1 AS phone1_113, c2_.phone2 AS phone2_114, c2_.fax AS fax_115, c2_.email1 AS email1_116, c2_.email1_online AS email1_online_117, c2_.email2_online AS email2_online_118, c2_.email2 AS email2_119, c2_.url AS url_120, c2_.url_ticket AS url_ticket_121, c2_.facebook AS facebook_122, c2_.twitter AS twitter_123, c2_.instagram AS instagram_124, c2_.mobile AS mobile_125, c2_.geocodable AS geocodable_126, c2_.x AS x_127, c2_.y AS y_128, c2_.idmultimedia AS idmultimedia_129, c2_.type_view AS type_view_130, c2_.stats_access AS stats_access_131, c2_.ga_tracking_id AS ga_tracking_id_132, c2_.is_festival AS is_festival_133, c2_.link_on_video AS link_on_video_134, c2_.is_partenaire AS is_partenaire_135, c2_.valid_version AS valid_version_136, c2_.other_versions AS other_versions_137, c2_.url_redirect AS url_redirect_138, c2_.url_clean AS url_clean_139, c2_.dateupdate AS dateupdate_140, c2_.dateinsert AS dateinsert_141, c2_.publish AS publish_142, c2_.valid AS valid_143, g3_.idgenretext AS idgenretext_144, g3_.genretext AS genretext_145, g3_.ordergenre AS ordergenre_146, g3_.visibility AS visibility_147, c4_.id AS id_148, c4_.fr AS fr_149, c4_.en AS en_150, c4_.es AS es_151, c4_.pt AS pt_152, c4_.de AS de_153, c4_.ru AS ru_154, c4_.orderby AS orderby_155 FROM texts t0_ LEFT JOIN extranetusers e1_ ON t0_.idextranetuser = e1_.idextranetuser LEFT JOIN contacts c2_ ON t0_.idcontact_publisher = c2_.idcontact LEFT JOIN genretexts g3_ ON t0_.idgenretext = g3_.idgenretext LEFT JOIN contacts c5_ ON t0_.idcontact_performing = c5_.idcontact LEFT JOIN countries c4_ ON t0_.country = c4_.id WHERE t0_.idtext = ?
Parameters: 
[
  37006
]
View formatted query    View runnable query    Explain query    View query backtrace
3.69 ms
(0.59%) 		1 
SELECT COUNT(DISTINCT(of.idfile)) as total
                FROM object_file of,
                     files f,
                     file_classification fc,
                     classifications cl,typesfiles tf
                   WHERE of.idfile=f.idfile
                   AND f.idfile=fc.idfile
                   AND of.idobject='29897'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3.48 ms
(0.56%) 		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
3.35 ms
(0.54%) 		1 
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='37006'
                   AND of.object='texts'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_couv'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3.24 ms
(0.52%) 		1 
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=29897
                AND om.object='spectacles'
                AND m.publish=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3.17 ms
(0.51%) 		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=6678
                    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.51%) 		6 
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean
                  FROM texts t, text_traduction tt
                  WHERE t.idtext=tt.idtext
                  AND tt.idtexttraduction=37006
                  ORDER BY t.title
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3.09 ms
(0.50%) 		5 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=29897
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.74 ms
(0.44%) 		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=13046
                    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
2.66 ms
(0.43%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=87103
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.64 ms
(0.42%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=161
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.64 ms
(0.42%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=47966
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.55 ms
(0.41%) 		2 
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=29897 AND cc.idclassification=6 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.50 ms
(0.40%) 		1 
SELECT * FROM multimedias
                WHERE idmultimedia IN (15672,5535,13046,16589,6678,14581)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.38 ms
(0.38%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=6678 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
2.35 ms
(0.38%) 		1 
SELECT s0_.idspectacle AS idspectacle_0, s0_.title AS title_1, s0_.language AS language_2, s0_.creation_date AS creation_date_3, s0_.url_page AS url_page_4, s0_.infos AS infos_5, s0_.tag AS tag_6, s0_.id_rubrique AS id_rubrique_7, s0_.duration AS duration_8, s0_.interlude AS interlude_9, s0_.textfictif AS textfictif_10, s0_.url_redirect AS url_redirect_11, s0_.url_clean AS url_clean_12, s0_.dateupdate AS dateupdate_13, s0_.dateinsert AS dateinsert_14, s0_.publish AS publish_15, s0_.statut AS statut_16, s0_.valid AS valid_17, t1_.idtypespectacle AS idtypespectacle_18, c2_.idcontact AS idcontact_19, c2_.type AS type_20, c2_.organisation AS organisation_21, c2_.nom_suite AS nom_suite_22, c2_.lastname AS lastname_23, c2_.firstname AS firstname_24, c2_.idtypestructure AS idtypestructure_25, c2_.license AS license_26, c2_.comment AS comment_27, c2_.private_comment AS private_comment_28, c2_.address1 AS address1_29, c2_.address2 AS address2_30, c2_.zip AS zip_31, c2_.city AS city_32, c2_.phone1 AS phone1_33, c2_.phone2 AS phone2_34, c2_.fax AS fax_35, c2_.email1 AS email1_36, c2_.email1_online AS email1_online_37, c2_.email2_online AS email2_online_38, c2_.email2 AS email2_39, c2_.url AS url_40, c2_.url_ticket AS url_ticket_41, c2_.facebook AS facebook_42, c2_.twitter AS twitter_43, c2_.instagram AS instagram_44, c2_.mobile AS mobile_45, c2_.geocodable AS geocodable_46, c2_.x AS x_47, c2_.y AS y_48, c2_.idmultimedia AS idmultimedia_49, c2_.type_view AS type_view_50, c2_.stats_access AS stats_access_51, c2_.ga_tracking_id AS ga_tracking_id_52, c2_.is_festival AS is_festival_53, c2_.link_on_video AS link_on_video_54, c2_.is_partenaire AS is_partenaire_55, c2_.valid_version AS valid_version_56, c2_.other_versions AS other_versions_57, c2_.url_redirect AS url_redirect_58, c2_.url_clean AS url_clean_59, c2_.dateupdate AS dateupdate_60, c2_.dateinsert AS dateinsert_61, c2_.publish AS publish_62, c2_.valid AS valid_63, c3_.idcontact AS idcontact_64, c3_.type AS type_65, c3_.organisation AS organisation_66, c3_.nom_suite AS nom_suite_67, c3_.lastname AS lastname_68, c3_.firstname AS firstname_69, c3_.idtypestructure AS idtypestructure_70, c3_.license AS license_71, c3_.comment AS comment_72, c3_.private_comment AS private_comment_73, c3_.address1 AS address1_74, c3_.address2 AS address2_75, c3_.zip AS zip_76, c3_.city AS city_77, c3_.phone1 AS phone1_78, c3_.phone2 AS phone2_79, c3_.fax AS fax_80, c3_.email1 AS email1_81, c3_.email1_online AS email1_online_82, c3_.email2_online AS email2_online_83, c3_.email2 AS email2_84, c3_.url AS url_85, c3_.url_ticket AS url_ticket_86, c3_.facebook AS facebook_87, c3_.twitter AS twitter_88, c3_.instagram AS instagram_89, c3_.mobile AS mobile_90, c3_.geocodable AS geocodable_91, c3_.x AS x_92, c3_.y AS y_93, c3_.idmultimedia AS idmultimedia_94, c3_.type_view AS type_view_95, c3_.stats_access AS stats_access_96, c3_.ga_tracking_id AS ga_tracking_id_97, c3_.is_festival AS is_festival_98, c3_.link_on_video AS link_on_video_99, c3_.is_partenaire AS is_partenaire_100, c3_.valid_version AS valid_version_101, c3_.other_versions AS other_versions_102, c3_.url_redirect AS url_redirect_103, c3_.url_clean AS url_clean_104, c3_.dateupdate AS dateupdate_105, c3_.dateinsert AS dateinsert_106, c3_.publish AS publish_107, c3_.valid AS valid_108, e4_.idextranetuser AS idextranetuser_109 FROM spectacles s0_ LEFT JOIN typesspectacles t1_ ON s0_.idtypespectacle = t1_.idtypespectacle LEFT JOIN contacts c2_ ON s0_.idcontact_creation = c2_.idcontact LEFT JOIN contacts c3_ ON s0_.idcontact_production = c3_.idcontact LEFT JOIN extranetusers e4_ ON s0_.idextranetuser = e4_.idextranetuser WHERE s0_.idspectacle = ?
Parameters: 
[
  29897
]
View formatted query    View runnable query    Explain query    View query backtrace
2.33 ms
(0.37%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=161
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.32 ms
(0.37%) 		2 
SELECT idtext,title,type,url_clean,valid
                        FROM texts
                        WHERE idtext=37006
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.27 ms
(0.36%) 		1 
SELECT COUNT(DISTINCT(oc.idcontent)) as total
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='29897'
                   AND oc.object='spectacles'
                   AND cl.idclassification=cc.idclassification AND c.publish=1 AND c.publish=1 AND c.valid=1  AND ((cl.classification IN ('class_critique')))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.24 ms
(0.36%) 		2 
SELECT  DISTINCT(dvds.iddvd), dvds.* 
FROM  `dvd_multimedia` ,
 `dvds`  
 WHERE 1  AND dvds.`publish`=1  AND dvd_multimedia.`idmultimedia` IN (14583) AND dvds.`iddvd`=dvd_multimedia.`iddvd` 
GROUP BY dvds.iddvd 
ORDER BY dvds.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.18 ms
(0.35%) 		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=14581
                    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
2.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=15672
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.13 ms
(0.34%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=16589 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
2.07 ms
(0.33%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=14583 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
2.06 ms
(0.33%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=13046 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
2.01 ms
(0.32%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=5535
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.00 ms
(0.32%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=14581
                    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.99 ms
(0.32%) 		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=13046
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.89 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=16589
                    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.86 ms
(0.30%) 		1 
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='29897'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_affiche_spec'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.82 ms
(0.29%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14583 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.77 ms
(0.28%) 		1 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=14134
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.68 ms
(0.27%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=87103
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.66 ms
(0.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=13046
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.62 ms
(0.26%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=5535
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.61 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=13046
                    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.60 ms
(0.26%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=37006
                AND om.object='contents'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.60 ms
(0.26%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=6678
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.59 ms
(0.26%) 		2 
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
                        lt.`fr`,
                        r.`idrole`, r.`role`, r.`type`,
                        sp.`comment`,sp.`date_start`,sp.`date_end`
                        FROM persons p
                            JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
                            JOIN roles r ON r.`idrole`=sp.`idrole`
                            JOIN langterms lt ON r.`role`=lt.`id`
                        WHERE sp.idspectacle=29897  AND r.type_creator=1 ORDER BY sp.`classement`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.58 ms
(0.25%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14583 AND object_multimedia.idrole IS NULL ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.56 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=6678
                    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.55 ms
(0.25%) 		3 
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_translator j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=37006  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.53 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=15672
                    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.52 ms
(0.24%) 		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.`idtext` IN ('37006')  AND c.`classification`='class_texte_parauteur'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.51 ms
(0.24%) 		1 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=19087
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.49 ms
(0.24%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=14323
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.46 ms
(0.23%) 		1 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=19087
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.45 ms
(0.23%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=5535
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.39 ms
(0.22%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=6678
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.38 ms
(0.22%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=29897
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.37 ms
(0.22%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=6678
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.37 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=13046
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.36 ms
(0.22%) 		2 
SELECT COUNT(sc.idspectacle)
                                FROM schedules sc
                                WHERE sc.idspectacle=29897
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.33 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=5535
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.32 ms
(0.21%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14583 AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.31 ms
(0.21%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=624
                AND om.object='contacts'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.31 ms
(0.21%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=624
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.28 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=14583
                    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.26 ms
(0.20%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=18207
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.24 ms
(0.20%) 		2 
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=14323
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.24 ms
(0.20%) 		1 
SELECT COUNT(DISTINCT(oc.idcontent)) as total
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='37006'
                   AND oc.object='texts'
                   AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.idclassification IN (125)))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.19 ms
(0.19%) 		1 
SELECT COUNT(DISTINCT om.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND m.audio_video=2
                AND m.publish=1
                AND om.idobject=624
                AND om.object='contacts'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.18 ms
(0.19%) 		1 
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=29897 AND d.code_franceinter IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.15 ms
(0.19%) 		2 
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=87103
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.12 ms
(0.18%) 		2 
SELECT c0_.idcontact AS idcontact_0, c0_.type AS type_1, c0_.organisation AS organisation_2, c0_.nom_suite AS nom_suite_3, c0_.lastname AS lastname_4, c0_.firstname AS firstname_5, c0_.idtypestructure AS idtypestructure_6, c0_.license AS license_7, c0_.comment AS comment_8, c0_.private_comment AS private_comment_9, c0_.address1 AS address1_10, c0_.address2 AS address2_11, c0_.zip AS zip_12, c0_.city AS city_13, c0_.phone1 AS phone1_14, c0_.phone2 AS phone2_15, c0_.fax AS fax_16, c0_.email1 AS email1_17, c0_.email1_online AS email1_online_18, c0_.email2_online AS email2_online_19, c0_.email2 AS email2_20, c0_.url AS url_21, c0_.url_ticket AS url_ticket_22, c0_.facebook AS facebook_23, c0_.twitter AS twitter_24, c0_.instagram AS instagram_25, c0_.mobile AS mobile_26, c0_.geocodable AS geocodable_27, c0_.x AS x_28, c0_.y AS y_29, c0_.idmultimedia AS idmultimedia_30, c0_.type_view AS type_view_31, c0_.stats_access AS stats_access_32, c0_.ga_tracking_id AS ga_tracking_id_33, c0_.is_festival AS is_festival_34, c0_.link_on_video AS link_on_video_35, c0_.is_partenaire AS is_partenaire_36, c0_.valid_version AS valid_version_37, c0_.other_versions AS other_versions_38, c0_.url_redirect AS url_redirect_39, c0_.url_clean AS url_clean_40, c0_.dateupdate AS dateupdate_41, c0_.dateinsert AS dateinsert_42, c0_.publish AS publish_43, c0_.valid AS valid_44 FROM contacts c0_ WHERE c0_.idcontact = ?
Parameters: 
[
  "624"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.12 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=16589
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.07 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=14581
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(0.17%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=37006
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.01 ms
(0.16%) 		2 
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=29897 AND cc.idclassification=1 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.00 ms
(0.16%) 		1 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=28117
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.99 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=16589
                    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.99 ms
(0.16%) 		1 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=27327
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.99 ms
(0.16%) 		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=6678
                    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.97 ms
(0.16%) 		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=5535
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.93 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=14581
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(0.15%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=24469
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.91 ms
(0.15%) 		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=14583
                    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.91 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=15672
                    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.91 ms
(0.15%) 		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=14581
                    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.91 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=5535
                    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.90 ms
(0.14%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=47966
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.88 ms
(0.14%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15672 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.86 ms
(0.14%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=14323
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.85 ms
(0.14%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=29897
                AND om.object='contents'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.82 ms
(0.13%) 		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=5535
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.82 ms
(0.13%) 		1 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=27327
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.79 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=16589
                    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.76 ms
(0.12%) 		2 
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=79549
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.70 ms
(0.11%) 		1 
SELECT idmultimedia FROM multimedias WHERE url_clean='tmpurl_g0cLjvZ8'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(0.11%) 		2 
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=161
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.66 ms
(0.11%) 		2 
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=29897 AND cc.idclassification=101 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.66 ms
(0.11%) 		2 
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=24469
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(0.10%) 		1 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=28117
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(0.10%) 		2 
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=18207
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 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=14583
                    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.57 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=15672
                    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.55 ms
(0.09%) 		1 
SELECT COUNT(idspectacle)
                FROM spectacle_classification
                WHERE idspectacle=29897
                AND idclassification=60
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(0.08%) 		1 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=7460
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(0.08%) 		2 
SELECT idperson,lastname,firstname,url_clean
                        FROM persons
                        WHERE idperson=47966
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(0.08%) 		2 
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=29897 AND cc.idclassification=125 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.08%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14583 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.07%) 		1 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=5535 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.43 ms
(0.07%) 		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.`idtext` IN ('37006')  AND c.`classification`='class_texte_par_traducteur'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.07%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=79549
                AND om.object='persons'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.06%) 		1 
SELECT DISTINCT(m.idmultimedia)
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=22443
                AND om.object='spectacles'
                AND m.publish=1 AND m.mp3=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 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=14583
                    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.36 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=15672
                    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.35 ms
(0.06%) 		1 
SELECT object_multimedia.object, object_multimedia.idobject
                    FROM object_multimedia
                    WHERE 1
                    AND idmultimedia=14583 AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.04%) 		1 
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_critique'))) AND spectacles=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.02%) 		1 
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (125))) AND texts=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(0.02%) 		1 
SELECT l.fr
                      FROM typesmultimedias tm,langterms l
                      WHERE tm.typemultimedia=l.id
                      AND tm.idtypemultimedia=0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(0.02%) 		1 
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_couv'))) AND texts=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(0.02%) 		1 
SELECT lt.fr 
                    FROM typesspectacles e, langterms lt 
                    WHERE typespectacle=lt.id
                    AND idtypespectacle=4
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(0.01%) 		1 
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_affiche_spec'))) AND spectacles=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.06 ms
(0.01%) 		1 
SELECT fr FROM languages WHERE id='fr'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Entities Mapping

Class Mapping errors
TheatreCore\Entity\Extranetusers No errors.
TheatreCore\Entity\Multimedias No errors.
TheatreCore\Entity\Typesmultimedias No errors.
TheatreCore\Entity\Contacts No errors.
TheatreCore\Entity\Dvds No errors.
TheatreCore\Entity\Classifications No errors.
TheatreCore\Entity\Keywords No errors.
TheatreCore\Entity\Spectacles No errors.
TheatreCore\Entity\Playlists No errors.
TheatreCore\Entity\ObjectMultimedia No errors.
TheatreCore\Entity\Persons No errors.
TheatreCore\Entity\Texts No errors.
TheatreCore\Entity\Contents No errors.
TheatreCore\Entity\Typesspectacles No errors.
TheatreCore\Entity\Genretexts No errors.
TheatreCore\Entity\Countries No errors.
TheatreCore\Entity\Files No errors.
TheatreCore\Entity\News No errors.
TheatreCore\Entity\Podcasts No errors.
TheatreCore\Entity\Abonnements No errors.
TheatreCore\Entity\Bannieres No errors.