https://preprod.theatre-contemporain.net/annonces/?path=annonces%2F

Query Metrics

15 Database Queries
15 Different statements
385.84 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time Count Info
96.77 ms
(25.08%)
1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=1
Parameters:
[]
66.84 ms
(17.32%)
1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=7
Parameters:
[]
59.71 ms
(15.48%)
1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=3
Parameters:
[]
39.30 ms
(10.18%)
1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=6
Parameters:
[]
38.47 ms
(9.97%)
1
SELECT idcategorie, COUNT(*) AS count FROM ann_annonces WHERE online=1 AND valid=1 AND attente=0 GROUP BY idcategorie
Parameters:
[]
29.28 ms
(7.59%)
1
SELECT a.*,e.login FROM ann_annonces a, extranetusers e
             WHERE e.idextranetuser=a.idextranetuser
             AND a.online=1 AND a.valid=1 AND a.attente=0 ORDER BY a.dateinsert DESC LIMIT 0,1
Parameters:
[]
28.74 ms
(7.45%)
1
SELECT COUNT(idannonce) FROM ann_annonces WHERE online=1 AND valid=1 AND attente=0
Parameters:
[]
15.08 ms
(3.91%)
1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=4
Parameters:
[]
4.04 ms
(1.05%)
1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=8
Parameters:
[]
3.11 ms
(0.81%)
1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=9
Parameters:
[]
2.19 ms
(0.57%)
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:
[]
1.64 ms
(0.43%)
1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=2
Parameters:
[]
0.23 ms
(0.06%)
1
SELECT * FROM ann_categories WHERE online=1 ORDER BY class
Parameters:
[]
0.22 ms
(0.06%)
1
SELECT idcategorie, name FROM ann_categories WHERE online=1
Parameters:
[]
0.22 ms
(0.06%)
1
SELECT *,`bigregions`.idbigregion as idbigregion
                    FROM `bigregions`
                        JOIN `regions` ON `regions`.`idbigregion`=`bigregions`.`idbigregion`
                        JOIN `departements` ON `regions`.`idregion`=`departements`.`idregion`
                    ORDER BY `bigregions`.`bigregion` ASC, `departements`.`departement` ASC
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