Query Metrics
6
Database Queries
5
Different statements
65.59 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 43.49 ms |
SELECT DISTINCT(T1.`idtext`), T1.`title`,T1.`url_clean`,T1.`publication_year`,T1.`publication_month`,T1.`isbn`,T1.`textfictif`,T1.`dateinsert`,T1.`textorder`,T1.`type`,T1.`publish`,T1.`statut`,T1.`valid`,T2.`idcontact`,T2.`url_clean` as `url_clean_publisher`,T2.`organisation`, CONCAT(T1.`publication_year`, T1.`publication_month`) AS publication_date, CAST(CONCAT(T1.`publication_year`, T1.`publication_month`) AS DATE) AS publication_date_full FROM texts T1,contacts T2 ,text_aide tai, aides ai, aidecontacts aic WHERE 1 AND tai.`idtext`=T1.`idtext` AND tai.`idaide`=ai.`idaide` AND ai.`idaidecontact`=aic.`idaidecontact` AND ( aic.`idaidecontact`=102 OR ai.`type_aide`IN (2,3 )) AND T2.idcontact=T1.idcontact_publisher GROUP BY T1.idtext HAVING COUNT(DISTINCT tai.idaide) = 4 ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
Parameters:
[]
|
||||||||||||||||||||
2 | 3.25 ms |
SELECT COUNT(DISTINCT(text_aide.idtextaide)) as total , text_aide.*,aides.*,`text_aide`.`publish` as text_aide_publish FROM `texts` , `aides` , `text_aide` WHERE 1 AND text_aide.`idtext` = texts.`idtext` AND aides.`publish`=1 AND (aides.`type_aide` IN (2,3) OR aides.`idaidecontact` IN (102) ) AND texts.idtext IN (2291,3474,4766,4810,16351,8289,6176,20146,6754,7935,8995,8996,8974,15083,15129,10307,17193,20529,20869,19819,21159,23963,22344,22361,24474,25069,23874,25071,25404,22384,22698,20613,18737,22347,27382,24059,25117,23534,30931,27533,31265,25403,33949,29820,31275,26004,33802,36327,37441,37864,38217,34587,33801,36471,37467) AND aides.`idaide`=text_aide.`idaide`
Parameters:
[]
|
||||||||||||||||||||
3 | 0.17 ms |
SELECT COUNT(DISTINCT(text_aide.idtextaide)) as total , text_aide.*,aides.*,`text_aide`.`publish` as text_aide_publish FROM `texts` , `aides` , `text_aide` WHERE 1 AND text_aide.`idtext` = texts.`idtext` AND aides.`publish`=1 AND (aides.`type_aide` IN (2,3) OR aides.`idaidecontact` IN (102) ) AND texts.idtext IN (2291,3474,4766,4810,16351,8289,6176,20146,6754,7935,8995,8996,8974,15083,15129,10307,17193,20529,20869,19819,21159,23963,22344,22361,24474,25069,23874,25071,25404,22384,22698,20613,18737,22347,27382,24059,25117,23534,30931,27533,31265,25403,33949,29820,31275,26004,33802,36327,37441,37864,38217,34587,33801,36471,37467) AND aides.`idaide`=text_aide.`idaide`
Parameters:
[]
|
||||||||||||||||||||
4 | 3.35 ms |
SELECT text_aide.*,aides.*,`text_aide`.`publish` as text_aide_publish FROM `texts` , `aides` , `text_aide` WHERE 1 AND text_aide.`idtext` = texts.`idtext` AND aides.`publish`=1 AND (aides.`type_aide` IN (2,3) OR aides.`idaidecontact` IN (102) ) AND texts.idtext IN (2291,3474,4766,4810,16351,8289,6176,20146,6754,7935,8995,8996,8974,15083,15129,10307,17193,20529,20869,19819,21159,23963,22344,22361,24474,25069,23874,25071,25404,22384,22698,20613,18737,22347,27382,24059,25117,23534,30931,27533,31265,25403,33949,29820,31275,26004,33802,36327,37441,37864,38217,34587,33801,36471,37467) AND aides.`idaide`=text_aide.`idaide` GROUP BY text_aide.`idtext` ORDER BY text_aide.`date_start` DESC LIMIT 200,50
Parameters:
[]
|
||||||||||||||||||||
5 | 14.64 ms |
SELECT totalCount.totalAide FROM (SELECT COUNT(DISTINCT text_aide.idtext) AS totalText, COUNT(DISTINCT text_aide.idaide) AS totalAide FROM `aides`, `text_aide` WHERE 1 AND aides.`publish` = 1 AND ( aides.`type_aide` IN (2,3) OR aides.`idaidecontact` IN (102) ) AND aides.`idaide` = text_aide.`idaide` GROUP BY text_aide.idtext ORDER BY totalAide DESC ) AS totalCount GROUP BY totalCount.totalAide ORDER BY totalCount.totalAide DESC
Parameters:
[]
|
||||||||||||||||||||
6 | 0.70 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\TextAide | No errors. |
TheatreCore\Entity\Texts | No errors. |
TheatreCore\Entity\Bannieres | No errors. |