Query Metrics
166
Database Queries
6
Different statements
164.06 ms
Query time
8
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
61.70 ms (37.61%) |
41 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5 FROM image t0 INNER JOIN actualite_image ON t0.id = actualite_image.image_id WHERE actualite_image.actualite_id = ?
Parameters:
[
227
]
|
|
42.48 ms (25.89%) |
41 |
SELECT t0.id AS id_1, t0.icone AS icone_2, t0.lien AS lien_3, t0.evenement_id AS evenement_id_4, t0.actualite_id AS actualite_id_5, t0.partenaire_id AS partenaire_id_6, t0.capitainerie_id AS capitainerie_id_7 FROM reseau t0 WHERE t0.actualite_id = ?
Parameters:
[
227
]
|
|
27.52 ms (16.78%) |
41 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4, t0.adresse AS adresse_5, t0.cp AS cp_6, t0.ville AS ville_7, t0.tel AS tel_8, t0.tel_comment AS tel_comment_9, t0.tel2 AS tel2_10, t0.email AS email_11, t0.formalites AS formalites_12, t0.frequence_contact AS frequence_contact_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.meteo AS meteo_16, t0.client_id AS client_id_17 FROM capitainerie t0 INNER JOIN actualite_capitainerie ON t0.id = actualite_capitainerie.capitainerie_id WHERE actualite_capitainerie.actualite_id = ?
Parameters:
[
227
]
|
|
16.89 ms (10.29%) |
1 |
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.description AS description_2, a0_.create_at AS create_at_3, a0_.update_at AS update_at_4, a0_.sort_order AS sort_order_5, a0_.client_id AS client_id_6 FROM actualite a0_ INNER JOIN actualite_capitainerie a2_ ON a0_.id = a2_.actualite_id INNER JOIN capitainerie c1_ ON c1_.id = a2_.capitainerie_id WHERE c1_.id IN (?) ORDER BY a0_.sort_order DESC
Parameters:
[
43
]
|
|
15.20 ms (9.26%) |
41 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lien AS lien_3, t0.entite_id AS entite_id_4, t0.partenaire_id AS partenaire_id_5, t0.evenement_id AS evenement_id_6, t0.actualite_id AS actualite_id_7, t0.capitainerie_id AS capitainerie_id_8 FROM lien t0 WHERE t0.actualite_id = ?
Parameters:
[
227
]
|
|
0.27 ms (0.16%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.image_type AS image_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.version AS version_8, t0.latest_features AS latest_features_9, t0.code AS code_10 FROM client t0 WHERE t0.id = ?
Parameters:
[
24
]
|
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\Actualite | No errors. |
| App\Entity\Capitainerie |
|
| App\Entity\Client |
|
| App\Entity\Lien |
|
| App\Entity\Reseau | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Saison | No errors. |
| App\Entity\Annuaire | No errors. |
| App\Entity\CapitainerieService |
|
| App\Entity\PieceJointe |
|
| App\Entity\Evenement | No errors. |
| App\Entity\Institution | No errors. |
| App\Entity\Camera | No errors. |
| App\Entity\Administrateur |
|
| App\Entity\Partenaire |
|
| App\Entity\Entite |
|
| App\Entity\Categorie | No errors. |
| App\Entity\MobileApp | No errors. |