Query Metrics
36
Database Queries
36
Different statements
36.32 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2.53 ms |
SELECT iddvd FROM dvds WHERE url_clean='Dialogue-d-un-chien-avec-son-maitre-sur-la-necessite-de-mordre-ses-amis-195'
Parameters:
[]
|
||||||||||||||||||||||||||
2 | 2.17 ms |
SELECT d0_.iddvd AS iddvd_0, d0_.title AS title_1, d0_.date_shooting AS date_shooting_2, d0_.place_shooting AS place_shooting_3, d0_.price AS price_4, d0_.comments AS comments_5, d0_.time_movie AS time_movie_6, d0_.url_vente AS url_vente_7, d0_.url_vente_bis AS url_vente_bis_8, d0_.import_copat AS import_copat_9, d0_.url_clean AS url_clean_10, d0_.dateupdate AS dateupdate_11, d0_.dateinsert AS dateinsert_12, d0_.publish AS publish_13 FROM dvds d0_ WHERE d0_.iddvd = ?
Parameters:
[
"195"
]
|
||||||||||||||||||||||||||
3 | 0.80 ms |
SELECT d0_.iddvd AS iddvd_0, d0_.title AS title_1, d0_.date_shooting AS date_shooting_2, d0_.place_shooting AS place_shooting_3, d0_.price AS price_4, d0_.comments AS comments_5, d0_.time_movie AS time_movie_6, d0_.url_vente AS url_vente_7, d0_.url_vente_bis AS url_vente_bis_8, d0_.import_copat AS import_copat_9, d0_.url_clean AS url_clean_10, d0_.dateupdate AS dateupdate_11, d0_.dateinsert AS dateinsert_12, d0_.publish AS publish_13, d0_.idextranetuser AS idextranetuser_14, d0_.iddvdzone AS iddvdzone_15, d0_.iddvdformat AS iddvdformat_16, d0_.iddvdtechno AS iddvdtechno_17 FROM dvds d0_ WHERE d0_.iddvd = ?
Parameters:
[
"195"
]
|
||||||||||||||||||||||||||
4 | 1.62 ms |
SELECT * FROM dvdzones WHERE iddvdzone=1
Parameters:
[]
|
||||||||||||||||||||||||||
5 | 0.83 ms |
SELECT * FROM dvdtechnos WHERE iddvdtechno=2
Parameters:
[]
|
||||||||||||||||||||||||||
6 | 1.20 ms |
SELECT * FROM dvdformats WHERE iddvdformat=1
Parameters:
[]
|
||||||||||||||||||||||||||
7 | 1.40 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3 WHERE j3.iddvd=j2.iddvd AND j1.idperson=j2.idperson AND j3.iddvd=195 AND j2.idrole=26
Parameters:
[]
|
||||||||||||||||||||||||||
8 | 1.44 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3 WHERE j3.iddvd=j2.iddvd AND j1.idperson=j2.idperson AND j3.iddvd=195 AND j2.idrole=21
Parameters:
[]
|
||||||||||||||||||||||||||
9 | 0.71 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3 WHERE j3.iddvd=j2.iddvd AND j1.idperson=j2.idperson AND j3.iddvd=195 AND j2.idrole=1
Parameters:
[]
|
||||||||||||||||||||||||||
10 | 1.80 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3 WHERE j3.iddvd=j2.iddvd AND j1.idperson=j2.idperson AND j3.iddvd=195 AND j2.idrole=25
Parameters:
[]
|
||||||||||||||||||||||||||
11 | 0.90 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3 WHERE j3.iddvd=j2.iddvd AND j1.idperson=j2.idperson AND j3.iddvd=195 AND j2.idrole=5
Parameters:
[]
|
||||||||||||||||||||||||||
12 | 1.78 ms |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3 WHERE j3.iddvd=j2.iddvd AND j1.idcontact=j2.idcontact AND j3.iddvd=195 AND j2.idrole=27
Parameters:
[]
|
||||||||||||||||||||||||||
13 | 0.87 ms |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3 WHERE j3.iddvd=j2.iddvd AND j1.idspectacle=j2.idspectacle AND j3.iddvd=195
Parameters:
[]
|
||||||||||||||||||||||||||
14 | 0.54 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=1960
Parameters:
[]
|
||||||||||||||||||||||||||
15 | 0.55 ms |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3 WHERE j3.iddvd=j2.iddvd AND j1.idmultimedia=j2.idmultimedia AND j3.iddvd=195
Parameters:
[]
|
||||||||||||||||||||||||||
16 | 0.90 ms |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3 WHERE j3.iddvd=j2.iddvd AND j1.idcontact=j2.idcontact AND j3.iddvd=195 AND j2.idrole=17
Parameters:
[]
|
||||||||||||||||||||||||||
17 | 0.78 ms |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3 WHERE j3.iddvd=j2.iddvd AND j1.idcontact=j2.idcontact AND j3.iddvd=195 AND j2.idrole=28
Parameters:
[]
|
||||||||||||||||||||||||||
18 | 1.10 ms |
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, s0_.idtypespectacle AS idtypespectacle_18, s0_.idcontact_creation AS idcontact_creation_19, s0_.idcontact_production AS idcontact_production_20, s0_.idspectaclegenre AS idspectaclegenre_21, s0_.idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_.idspectacle = ?
Parameters:
[
1960
]
|
||||||||||||||||||||||||||
19 | 3.23 ms |
SELECT t0.idcontact AS idcontact_1, t0.type AS type_2, t0.organisation AS organisation_3, t0.nom_suite AS nom_suite_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.idtypestructure AS idtypestructure_7, t0.license AS license_8, t0.comment AS comment_9, t0.private_comment AS private_comment_10, t0.address1 AS address1_11, t0.address2 AS address2_12, t0.zip AS zip_13, t0.city AS city_14, t0.phone1 AS phone1_15, t0.phone2 AS phone2_16, t0.fax AS fax_17, t0.email1 AS email1_18, t0.email1_online AS email1_online_19, t0.email2_online AS email2_online_20, t0.email2 AS email2_21, t0.url AS url_22, t0.url_ticket AS url_ticket_23, t0.facebook AS facebook_24, t0.twitter AS twitter_25, t0.instagram AS instagram_26, t0.mobile AS mobile_27, t0.geocodable AS geocodable_28, t0.x AS x_29, t0.y AS y_30, t0.idmultimedia AS idmultimedia_31, t0.type_view AS type_view_32, t0.stats_access AS stats_access_33, t0.ga_tracking_id AS ga_tracking_id_34, t0.is_festival AS is_festival_35, t0.link_on_video AS link_on_video_36, t0.is_partenaire AS is_partenaire_37, t0.valid_version AS valid_version_38, t0.other_versions AS other_versions_39, t0.url_redirect AS url_redirect_40, t0.url_clean AS url_clean_41, t0.dateupdate AS dateupdate_42, t0.dateinsert AS dateinsert_43, t0.publish AS publish_44, t0.valid AS valid_45, t0.country AS country_46, t0.idextranetuser AS idextranetuser_47 FROM contacts t0 WHERE t0.idcontact = ?
Parameters:
[
971
]
|
||||||||||||||||||||||||||
20 | 0.21 ms |
SELECT fr FROM countries WHERE id='FR'
Parameters:
[]
|
||||||||||||||||||||||||||
21 | 0.09 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||
22 | 0.06 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||
23 | 0.79 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=1960 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||
24 | 0.42 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"2442"
]
|
||||||||||||||||||||||||||
25 | 0.47 ms |
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=2442 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||
26 | 0.33 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3 WHERE j3.idtext=j2.idtext AND j1.idperson=j2.idperson AND j3.idtext=2441 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||
27 | 0.52 ms |
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`, lt.`fr`, r.`idrole`, r.`role`, r.`type`, sp.`comment`,sp.`date_start`,sp.`date_end` FROM persons p JOIN spectacle_person sp ON sp.`idperson`=p.`idperson` JOIN roles r ON r.`idrole`=sp.`idrole` JOIN langterms lt ON r.`role`=lt.`id` WHERE sp.idspectacle=1960 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||
28 | 0.92 ms |
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`, lt.`fr`, r.`idrole`, r.`role`, r.`type`, sp.`comment`,sp.`date_start`,sp.`date_end` FROM persons p JOIN spectacle_person sp ON sp.`idperson`=p.`idperson` JOIN roles r ON r.`idrole`=sp.`idrole` JOIN langterms lt ON r.`role`=lt.`id` WHERE sp.idspectacle=1960 AND sp.idrole=5 ORDER BY p.`lastname`
Parameters:
[]
|
||||||||||||||||||||||||||
29 | 1.03 ms |
SELECT c.`idcontact`, c.`organisation`, c.`lastname`, c.`firstname`, c.`url`, c.`url_clean`, c.`valid` FROM contacts c JOIN spectacle_contact sc ON sc.`idcontact`=c.`idcontact` WHERE sc.`idspectacle`=1960 AND sc.`idrole` IN (17) ORDER BY c.`organisation`
Parameters:
[]
|
||||||||||||||||||||||||||
30 | 0.61 ms |
SELECT c.`idcontact`, c.`organisation`, c.`lastname`, c.`firstname`, c.`url`, c.`url_clean`, c.`valid` FROM contacts c JOIN spectacle_contact sc ON sc.`idcontact`=c.`idcontact` WHERE sc.`idspectacle`=1960 AND sc.`idrole` IN (18) ORDER BY c.`organisation`
Parameters:
[]
|
||||||||||||||||||||||||||
31 | 0.54 ms |
SELECT c.`idcontact`, c.`organisation`, c.`lastname`, c.`firstname`, c.`url`, c.`url_clean`, c.`valid` FROM contacts c JOIN spectacle_contact sc ON sc.`idcontact`=c.`idcontact` WHERE sc.`idspectacle`=1960 AND sc.`idrole` IN (19) ORDER BY c.`organisation`
Parameters:
[]
|
||||||||||||||||||||||||||
32 | 0.83 ms |
SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`, lt.`fr`, r.`idrole`, r.`role`, r.`type`, sp.`comment`,sp.`date_start`,sp.`date_end` FROM persons p JOIN spectacle_person sp ON sp.`idperson`=p.`idperson` JOIN roles r ON r.`idrole`=sp.`idrole` JOIN langterms lt ON r.`role`=lt.`id` WHERE sp.idspectacle=1960 AND r.type=1 ORDER BY p.`lastname`
Parameters:
[]
|
||||||||||||||||||||||||||
33 | 0.11 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_distribution'))) AND spectacles=1
Parameters:
[]
|
||||||||||||||||||||||||||
34 | 2.77 ms |
SELECT * FROM object_content oc, contents c, content_classification cc, classifications cl WHERE oc.idcontent=c.idcontent AND c.idcontent=cc.idcontent AND oc.idobject='1960' AND oc.object='spectacles' AND cl.idclassification=cc.idclassification AND ((cl.classification IN ('class_distribution'))) ORDER BY c.`range`,c.idcontent
Parameters:
[]
|
||||||||||||||||||||||||||
35 | 0.44 ms |
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3 WHERE j3.idcontent=j2.idcontent AND j1.idclassification=j2.idclassification AND j3.idcontent=7382
Parameters:
[]
|
||||||||||||||||||||||||||
36 | 1.03 ms |
SELECT * FROM bannieres WHERE publish=1 AND valid=1 AND is_bottom=1 AND date_start<=NOW() AND date_end>=NOW() ORDER BY bannieres.order ASC LIMIT 0,10
Parameters:
[]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
Class | Mapping errors |
---|---|
TheatreCore\Entity\Extranetusers | No errors. |
TheatreCore\Entity\Dvds | No errors. |
TheatreCore\Entity\Dvdzones | No errors. |
TheatreCore\Entity\Dvdformats | No errors. |
TheatreCore\Entity\Dvdtechnos | No errors. |
TheatreCore\Entity\Multimedias | No errors. |
TheatreCore\Entity\Spectacles | No errors. |
TheatreCore\Entity\Texts | No errors. |
TheatreCore\Entity\Persons | No errors. |
TheatreCore\Entity\Contacts | No errors. |
TheatreCore\Entity\Typesspectacles | No errors. |
TheatreCore\Entity\Spectaclegenres | No errors. |
TheatreCore\Entity\Podcasts | No errors. |
TheatreCore\Entity\Classifications | No errors. |
TheatreCore\Entity\Schedules | No errors. |
TheatreCore\Entity\Contents | No errors. |
TheatreCore\Entity\SpectacleAide | No errors. |
TheatreCore\Entity\News | No errors. |
TheatreCore\Entity\Countries | No errors. |
TheatreCore\Entity\ContactAide | No errors. |
TheatreCore\Entity\Contactsaisons | No errors. |
TheatreCore\Entity\Bannieres | No errors. |