Query Metrics
32
Database Queries
30
Different statements
109.29 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
74.15 ms (67.84%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='5'
Parameters:
[] |
10.97 ms (10.04%) |
2 |
"COMMIT"
Parameters:
[] |
6.30 ms (5.76%) |
1 |
SELECT COUNT(*) as count FROM recommandation
Parameters:
[] |
2.23 ms (2.04%) |
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"
]
|
2.22 ms (2.03%) |
1 |
INSERT INTO visitor (ip, date) VALUES (?, ?)
Parameters:
[ 1 => "95.214.55.138" 2 => "2024-09-29 16:31:32" ] |
1.28 ms (1.17%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='2')
Parameters:
[] |
0.99 ms (0.91%) |
1 |
INSERT INTO log_con (type, date, user_id) VALUES (?, ?, ?)
Parameters:
[ 1 => "Accueil" 2 => "2024-09-29 16:31:33" 3 => null ] |
0.99 ms (0.90%) |
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.73%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.67 ms (0.62%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='6')
Parameters:
[] |
0.67 ms (0.61%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='7')
Parameters:
[] |
0.64 ms (0.58%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='2'
Parameters:
[] |
0.63 ms (0.58%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='5'
Parameters:
[] |
0.52 ms (0.48%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='5')
Parameters:
[] |
0.51 ms (0.47%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='3'
Parameters:
[] |
0.50 ms (0.46%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='6'
Parameters:
[] |
0.49 ms (0.45%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='8')
Parameters:
[] |
0.44 ms (0.40%) |
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.39%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='7'
Parameters:
[] |
0.43 ms (0.39%) |
1 |
SELECT COUNT(*) as count FROM recommandation where Avis_URL_id in (SELECT id from avis where Domaine_id_id='9')
Parameters:
[] |
0.42 ms (0.38%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='8'
Parameters:
[] |
0.42 ms (0.38%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='6'
Parameters:
[] |
0.40 ms (0.36%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='4'
Parameters:
[] |
0.38 ms (0.35%) |
1 |
SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='9'
Parameters:
[] |
0.35 ms (0.32%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='8'
Parameters:
[] |
0.32 ms (0.29%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='2'
Parameters:
[] |
0.29 ms (0.27%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='3'
Parameters:
[] |
0.29 ms (0.26%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='7'
Parameters:
[] |
0.28 ms (0.26%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='4'
Parameters:
[] |
0.28 ms (0.25%) |
1 |
SELECT COUNT(*) as count FROM avis where domaine_id_id='9'
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. |