Query Metrics
32
Database Queries
30
Different statements
111.78 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
87.57 ms (78.34%) |
2 |
"COMMIT"
Parameters:
[] |
5.83 ms (5.22%) |
1 |
SELECT COUNT(*) as count FROM recommandation
Parameters:
[] |
2.29 ms (2.05%) |
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.62 ms (1.45%) |
1 |
INSERT INTO visitor (ip, date) VALUES (?, ?)
Parameters:
[ 1 => "178.211.139.188" 2 => "2024-09-30 18:29:40" ] |
1.41 ms (1.26%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='2')
Parameters:
[] |
1.02 ms (0.92%) |
1 |
INSERT INTO log_con (type, date, user_id) VALUES (?, ?, ?)
Parameters:
[ 1 => "Accueil" 2 => "2024-09-30 18:29:41" 3 => null ] |
0.87 ms (0.78%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='3')
Parameters:
[] |
0.80 ms (0.71%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='7')
Parameters:
[] |
0.73 ms (0.65%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='3'
Parameters:
[] |
0.69 ms (0.62%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.68 ms (0.61%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='2'
Parameters:
[] |
0.66 ms (0.59%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='4')
Parameters:
[] |
0.61 ms (0.54%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='5')
Parameters:
[] |
0.58 ms (0.51%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='8')
Parameters:
[] |
0.52 ms (0.47%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='3'
Parameters:
[] |
0.52 ms (0.47%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='6')
Parameters:
[] |
0.51 ms (0.46%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='9'
Parameters:
[] |
0.48 ms (0.43%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='4'
Parameters:
[] |
0.47 ms (0.42%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='6'
Parameters:
[] |
0.45 ms (0.40%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='5'
Parameters:
[] |
0.41 ms (0.36%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='8'
Parameters:
[] |
0.40 ms (0.36%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='5'
Parameters:
[] |
0.39 ms (0.35%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='7'
Parameters:
[] |
0.37 ms (0.33%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='9')
Parameters:
[] |
0.35 ms (0.32%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='2'
Parameters:
[] |
0.35 ms (0.31%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='6'
Parameters:
[] |
0.34 ms (0.31%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='4'
Parameters:
[] |
0.30 ms (0.27%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='8'
Parameters:
[] |
0.28 ms (0.25%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='9'
Parameters:
[] |
0.26 ms (0.23%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='7'
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. |