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

Query Metrics

6 Database Queries
6 Different statements
15.52 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time Count Info
13.50 ms
(87.03%)
1
SELECT count(idannonce) FROM ann_annonces a
                  WHERE a.online=1
                  AND a.valid=1
                  AND a.attente=0
                  AND a.idcategorie=3
Parameters:
[]
1.19 ms
(7.65%)
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:
[]
0.35 ms
(2.24%)
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:
[]
0.30 ms
(1.95%)
1
SELECT idcategorie FROM ann_categories WHERE url_clean='Offres-emploi-remunere'
Parameters:
[]
0.12 ms
(0.78%)
1
SELECT name,url_clean FROM ann_categories
            WHERE idcategorie=3
Parameters:
[]
0.05 ms
(0.34%)
1
SELECT url_clean, name FROM ann_categories WHERE online=1
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