Query Metrics
24
Database Queries
24
Different statements
1177.03 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1148.10 ms (97.54%) |
1 |
SELECT s.`idspectacle` FROM spectacles s LEFT JOIN spectacle_person sp ON sp.`idspectacle`=s.`idspectacle` LEFT JOIN text_spectacle ts ON ts.`idspectacle`=s.`idspectacle` WHERE s.`publish`=1 AND s.`valid`=1 AND (sp.`idperson`=1671 OR ts.`idtext` IN (6327,7017,7018,7175,11256,20452,28122,28265,28533,30296,36305,37433,37434,37909,38902,42583,42587,45109,43355) )
Parameters:
[]
|
||||||||||||||||||||||||||||||
4.56 ms (0.39%) |
1 |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND t2_.idtext IN (6327, 7017, 7018, 7175, 11256, 20452, 28122, 28265, 28533, 30296, 36305, 37433, 37434, 37909, 38902, 42583, 42587, 45109, 43355) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
4.40 ms (0.37%) |
1 |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s0_.idspectacle IN (1399, 4475, 11879, 15190, 18439, 22951, 23790, 24489, 24606, 26199, 29077, 29083, 29126, 30205, 30516, 30887, 31224, 33661, 36848) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||
2.11 ms (0.18%) |
1 |
SELECT r.idrole, r.role, r.role_male, r.role_female, lg.fr FROM spectacle_person sp JOIN roles r ON sp.idrole=r.idrole JOIN langterms lg ON lg.id=r.role WHERE sp.idperson=1671 GROUP BY r.idrole
Parameters:
[]
|
||||||||||||||||||||||||||||||
1.93 ms (0.16%) |
1 |
SELECT * FROM object_content oc, contents c, content_classification cc, classifications cl WHERE oc.idcontent=c.idcontent AND c.idcontent=cc.idcontent AND oc.idobject='1671' AND oc.object='persons' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_biotxt'))) ORDER BY c.`range`,c.idcontent
Parameters:
[]
|
||||||||||||||||||||||||||||||
1.78 ms (0.15%) |
1 |
SELECT COUNT(DISTINCT(ct.`idcontent`)) FROM spectacles s JOIN object_content oc ON s.`idspectacle`=oc.`idobject` JOIN contents ct ON oc.`idcontent`=ct.`idcontent` JOIN content_classification cc ON ct.`idcontent`=cc.`idcontent` WHERE s.`publish`=1 AND s.`valid`=1 AND ct.`publish`=1 AND ct.`valid`=1 AND cc.`idclassification`=101 AND s.`idspectacle` IN (1399,4475,11879,15190,18439,22951,23790,24489,24606,26199,29077,29083,29126,30205,30516,30887,31224,33661,36848)
Parameters:
[]
|
||||||||||||||||||||||||||||||
1.77 ms (0.15%) |
1 |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s0_.idspectacle IN (1399, 4475, 11879, 15190, 18439, 22951, 23790, 24489, 24606, 26199, 29077, 29083, 29126, 30205, 30516, 30887, 31224, 33661, 36848) AND ((s1_.date BETWEEN '2024-03-28' AND '2026-03-18')) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
1.51 ms (0.13%) |
1 |
SELECT schedules.`date`, YEAR(schedules.`date`) as annee FROM schedules, spectacles WHERE schedules.`idspectacle`=spectacles.`idspectacle` AND spectacles.`publish`=1 AND schedules.`idspectacle` IN (1399,4475,11879,15190,18439,22951,23790,24489,24606,26199,29077,29083,29126,30205,30516,30887,31224,33661,36848) ORDER BY schedules.`date`
Parameters:
[]
|
||||||||||||||||||||||||||||||
1.45 ms (0.12%) |
1 |
SELECT COUNT(DISTINCT(t.idtext)) FROM text_author ta, texts t WHERE t.idtext=ta.idtext AND t.textfictif=0 AND ta.idperson=1671 AND t.publish=1 AND t.type IN (0,2)
Parameters:
[]
|
||||||||||||||||||||||||||||||
1.42 ms (0.12%) |
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='1671' AND of.object='persons' AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_photo_person'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters:
[]
|
||||||||||||||||||||||||||||||
1.42 ms (0.12%) |
1 |
SELECT COUNT(DISTINCT(tt.idtext)) as total FROM text_translator tt, texts t WHERE 1 AND t.idtext=tt.idtext AND t.textfictif=0 AND tt.idperson=1671 AND t.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.99 ms (0.08%) |
1 |
SELECT COUNT(DISTINCT(sp.idspectacle)) as total FROM spectacle_person sp, spectacles s WHERE 1 AND sp.idspectacle=s.idspectacle AND sp.idperson=1671 AND sp.idrole=1 AND s.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.97 ms (0.08%) |
1 |
SELECT tt.`idtexttraduction` FROM text_traduction tt JOIN text_author ta ON tt.`idtext`=ta.`idtext` JOIN texts t ON tt.`idtext`=t.`idtext` WHERE ta.`idperson` IN (1671)
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.75 ms (0.06%) |
1 |
SELECT p0_.idperson AS idperson_0, p0_.lastname AS lastname_1, p0_.firstname AS firstname_2, p0_.sexe AS sexe_3, p0_.datestart AS datestart_4, p0_.dateend AS dateend_5, p0_.language AS language_6, p0_.language2 AS language2_7, p0_.email AS email_8, p0_.comment AS comment_9, p0_.cname AS cname_10, p0_.caddress AS caddress_11, p0_.czip AS czip_12, p0_.ccity AS ccity_13, p0_.ccountry AS ccountry_14, p0_.cphone AS cphone_15, p0_.cfax AS cfax_16, p0_.cemail AS cemail_17, p0_.cmobile AS cmobile_18, p0_.url_redirect AS url_redirect_19, p0_.url_clean AS url_clean_20, p0_.url_mav AS url_mav_21, p0_.dateupdate AS dateupdate_22, p0_.dateinsert AS dateinsert_23, p0_.publish AS publish_24, p0_.valid AS valid_25, p0_.idcorvin AS idcorvin_26, p0_.country AS country_27, p0_.idrole AS idrole_28, p0_.idextranetuser AS idextranetuser_29 FROM persons p0_ WHERE p0_.idperson = ?
Parameters:
[
1671
]
|
||||||||||||||||||||||||||||||
0.73 ms (0.06%) |
1 |
SELECT tad.`idtextadaptation` FROM text_adaptation tad JOIN texts t ON t.`idtext`=tad.`idtext` JOIN text_author ta ON t.`idtext`=ta.`idtext` WHERE ta.`idperson` IN (1671)
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.69 ms (0.06%) |
1 |
SELECT t.`idtext` FROM text_translator tt JOIN texts t ON tt.`idtext`=t.`idtext` WHERE tt.`idperson` IN (1671)
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.65 ms (0.06%) |
1 |
SELECT j1.idcontact,j1.organisation,j1.url_clean,j2.idoffice,j2.date_start,j2.date_end ,j3.idperson FROM theatreok_dev.contacts j1, theatreok_dev.contact_person j2, theatreok_dev.persons j3 WHERE j3.idperson=j2.idperson AND j1.idcontact=j2.idcontact AND j3.idperson=1671 AND j2.idoffice=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.51 ms (0.04%) |
1 |
SELECT idperson FROM persons WHERE url_clean='Guy-Junior-Regis'
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.48 ms (0.04%) |
1 |
SELECT t.`idtext` FROM text_author ta JOIN texts t ON ta.`idtext`=t.`idtext` WHERE ta.`idperson` IN (1671)
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.36 ms (0.03%) |
1 |
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3 WHERE j3.idcontent=j2.idcontent AND j1.idclassification=j2.idclassification AND j3.idcontent=104567
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.22 ms (0.02%) |
1 |
SELECT fr FROM countries WHERE id='HT'
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.09 ms (0.01%) |
1 |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.08 ms (0.01%) |
1 |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_biotxt'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.06 ms (0.01%) |
1 |
SELECT fr FROM languages WHERE id='fr'
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\Persons | No errors. |
TheatreCore\Entity\Contents | No errors. |
TheatreCore\Entity\Multimedias | No errors. |
TheatreCore\Entity\Countries | No errors. |
TheatreCore\Entity\Roles | No errors. |
TheatreCore\Entity\News | No errors. |
TheatreCore\Entity\Classifications | No errors. |
TheatreCore\Entity\Contacts | No errors. |
TheatreCore\Entity\Podcasts | No errors. |
TheatreCore\Entity\Spectacles | No errors. |
TheatreCore\Entity\Texts | No errors. |
TheatreCore\Entity\Files | No errors. |
TheatreCore\Entity\Typesspectacles | No errors. |
TheatreCore\Entity\Schedules | No errors. |