Query Metrics
32
Database Queries
30
Different statements
175.44 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
75.63 ms (43.11%) |
1 |
INSERT INTO log_con (type, date, user_id) VALUES (?, ?, ?)
Parameters:
[ 1 => "Accueil" 2 => "2024-10-01 02:26:57" 3 => null ] |
74.63 ms (42.54%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='5'
Parameters:
[] |
4.67 ms (2.66%) |
2 |
"COMMIT"
Parameters:
[] |
4.36 ms (2.49%) |
1 |
SELECT COUNT(*) as count FROM recommandation
Parameters:
[] |
1.99 ms (1.14%) |
1 |
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"
]
|
1.28 ms (0.73%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='2')
Parameters:
[] |
1.10 ms (0.63%) |
1 |
INSERT INTO visitor (ip, date) VALUES (?, ?)
Parameters:
[ 1 => "64.62.156.85" 2 => "2024-10-01 02:26:56" ] |
0.85 ms (0.48%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='6')
Parameters:
[] |
0.84 ms (0.48%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='3')
Parameters:
[] |
0.81 ms (0.46%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='7')
Parameters:
[] |
0.78 ms (0.45%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='5'
Parameters:
[] |
0.76 ms (0.43%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.60 ms (0.34%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='2'
Parameters:
[] |
0.57 ms (0.33%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='3'
Parameters:
[] |
0.57 ms (0.33%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='8')
Parameters:
[] |
0.57 ms (0.32%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='5')
Parameters:
[] |
0.50 ms (0.29%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='6'
Parameters:
[] |
0.48 ms (0.28%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='9')
Parameters:
[] |
0.43 ms (0.25%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='4')
Parameters:
[] |
0.43 ms (0.25%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='4'
Parameters:
[] |
0.43 ms (0.25%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='8'
Parameters:
[] |
0.42 ms (0.24%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='9'
Parameters:
[] |
0.41 ms (0.23%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='7'
Parameters:
[] |
0.37 ms (0.21%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='4'
Parameters:
[] |
0.36 ms (0.20%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='7'
Parameters:
[] |
0.34 ms (0.19%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='3'
Parameters:
[] |
0.34 ms (0.19%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='6'
Parameters:
[] |
0.32 ms (0.18%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='9'
Parameters:
[] |
0.31 ms (0.18%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='8'
Parameters:
[] |
0.29 ms (0.16%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='2'
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. |