Query Metrics
32
Database Queries
30
Different statements
183.28 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
153.21 ms (83.59%) |
2 |
"COMMIT"
Parameters:
[] |
9.62 ms (5.25%) |
1 |
SELECT COUNT(*) as count FROM recommandation
Parameters:
[] |
2.35 ms (1.28%) |
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.96 ms (1.07%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='3')
Parameters:
[] |
1.82 ms (0.99%) |
1 |
INSERT INTO visitor (ip, date) VALUES (?, ?)
Parameters:
[ 1 => "178.211.139.188" 2 => "2024-10-01 07:36:31" ] |
1.73 ms (0.94%) |
1 |
INSERT INTO log_con (type, date, user_id) VALUES (?, ?, ?)
Parameters:
[ 1 => "Accueil" 2 => "2024-10-01 07:36:31" 3 => null ] |
1.69 ms (0.92%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='2')
Parameters:
[] |
0.75 ms (0.41%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='2'
Parameters:
[] |
0.74 ms (0.40%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.72 ms (0.39%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='3'
Parameters:
[] |
0.71 ms (0.38%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='7')
Parameters:
[] |
0.60 ms (0.33%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='4')
Parameters:
[] |
0.60 ms (0.33%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='5')
Parameters:
[] |
0.57 ms (0.31%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='6')
Parameters:
[] |
0.53 ms (0.29%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='2'
Parameters:
[] |
0.50 ms (0.27%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='8')
Parameters:
[] |
0.47 ms (0.26%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='6'
Parameters:
[] |
0.45 ms (0.25%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='4'
Parameters:
[] |
0.41 ms (0.23%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='8'
Parameters:
[] |
0.41 ms (0.22%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='7'
Parameters:
[] |
0.41 ms (0.22%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='9'
Parameters:
[] |
0.41 ms (0.22%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='5'
Parameters:
[] |
0.40 ms (0.22%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='4'
Parameters:
[] |
0.38 ms (0.21%) |
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.19%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='3'
Parameters:
[] |
0.32 ms (0.18%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='6'
Parameters:
[] |
0.31 ms (0.17%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='8'
Parameters:
[] |
0.31 ms (0.17%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='7'
Parameters:
[] |
0.28 ms (0.15%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='9'
Parameters:
[] |
0.27 ms (0.15%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='5'
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. |