https://preprod.theatre-contemporain.net/biographies/?lettre=%7BD%7D&path=biographies&start=800

Query Metrics

5 Database Queries
5 Different statements
153.91 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 34.55 ms
SELECT COUNT(*) as total FROM persons
Parameters:
[]
2 60.69 ms
SELECT COUNT(DISTINCT(T1.idperson)) as total  FROM persons T1 WHERE 1  AND T1.`publish`=1 AND T1.lastname REGEXP '^X'
Parameters:
[]
3 57.00 ms
SELECT DISTINCT(T1.idperson), T1.lastname,T1.firstname,T1.url_clean  FROM persons T1 WHERE 1  AND T1.`publish`=1 AND T1.lastname REGEXP '^X'  GROUP BY T1.idperson  ORDER BY T1.lastname ASC LIMIT 800,402
Parameters:
[]
4 0.78 ms
SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_national=1
                AND date_start<='2024-06-16'
                AND date_end>='2024-06-16'
                ORDER BY bannieres.order ASC
                LIMIT 0,10
Parameters:
[]
5 0.88 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