Query Metrics
32
Database Queries
30
Different statements
175.44 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.49 ms |
"START TRANSACTION"
Parameters:
[] |
2 | 1.10 ms |
INSERT INTO visitor (ip, date) VALUES (?, ?)
Parameters:
[ 1 => "64.62.156.85" 2 => "2024-10-01 02:26:56" ] |
3 | 2.20 ms |
"COMMIT"
Parameters:
[] |
4 | 4.36 ms |
SELECT COUNT(*) as count FROM recommandation
Parameters:
[] |
5 | 1.99 ms |
SELECT a0_.id AS id_0, a0_.intitule AS intitule_1, a0_.lien AS lien_2, a0_.commission AS commission_3, a0_.annee AS annee_4, a0_.domaine AS domaine_5, a0_.source AS source_6, a0_.ar_id AS ar_id_7, a0_.domaine_id_id AS domaine_id_id_8, a0_.commission_id_id AS commission_id_id_9 FROM avis a0_ WHERE a0_.source = ? ORDER BY a0_.id DESC LIMIT 5
Parameters:
[
"CESE"
]
|
6 | 1.28 ms |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='2')
Parameters:
[] |
7 | 0.60 ms |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='2'
Parameters:
[] |
8 | 0.29 ms |
SELECT COUNT(*) as count FROM avis where domaine_id_id='2'
Parameters:
[] |
9 | 0.84 ms |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='3')
Parameters:
[] |
10 | 0.57 ms |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='3'
Parameters:
[] |
11 | 0.34 ms |
SELECT COUNT(*) as count FROM avis where domaine_id_id='3'
Parameters:
[] |
12 | 0.43 ms |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='4')
Parameters:
[] |
13 | 0.43 ms |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='4'
Parameters:
[] |
14 | 0.37 ms |
SELECT COUNT(*) as count FROM avis where domaine_id_id='4'
Parameters:
[] |
15 | 0.57 ms |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='5')
Parameters:
[] |
16 | 74.63 ms |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='5'
Parameters:
[] |
17 | 0.78 ms |
SELECT COUNT(*) as count FROM avis where domaine_id_id='5'
Parameters:
[] |
18 | 0.85 ms |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='6')
Parameters:
[] |
19 | 0.50 ms |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='6'
Parameters:
[] |
20 | 0.34 ms |
SELECT COUNT(*) as count FROM avis where domaine_id_id='6'
Parameters:
[] |
21 | 0.81 ms |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='7')
Parameters:
[] |
22 | 0.41 ms |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='7'
Parameters:
[] |
23 | 0.36 ms |
SELECT COUNT(*) as count FROM avis where domaine_id_id='7'
Parameters:
[] |
24 | 0.57 ms |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='8')
Parameters:
[] |
25 | 0.43 ms |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='8'
Parameters:
[] |
26 | 0.31 ms |
SELECT COUNT(*) as count FROM avis where domaine_id_id='8'
Parameters:
[] |
27 | 0.48 ms |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='9')
Parameters:
[] |
28 | 0.42 ms |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='9'
Parameters:
[] |
29 | 0.32 ms |
SELECT COUNT(*) as count FROM avis where domaine_id_id='9'
Parameters:
[] |
30 | 0.27 ms |
"START TRANSACTION"
Parameters:
[] |
31 | 75.63 ms |
INSERT INTO log_con (type, date, user_id) VALUES (?, ?, ?)
Parameters:
[ 1 => "Accueil" 2 => "2024-10-01 02:26:57" 3 => null ] |
32 | 2.47 ms |
"COMMIT"
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Visitor | No errors. |
App\Entity\Recommandation | No errors. |
App\Entity\Avis | No errors. |
App\Entity\AvisAr | No errors. |
App\Entity\Domaine | No errors. |
App\Entity\Commission | No errors. |
App\Entity\Terme | No errors. |
App\Entity\LogCon | No errors. |