Query Metrics
32
Database Queries
12
Different statements
9.16 ms
Query time
9
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.09 ms |
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.nom AS nom_2, c0_.description AS description_3, c0_.adresse AS adresse_4, c0_.cp AS cp_5, c0_.ville AS ville_6, c0_.tel AS tel_7, c0_.tel_comment AS tel_comment_8, c0_.tel2 AS tel2_9, c0_.email AS email_10, c0_.formalites AS formalites_11, c0_.frequence_contact AS frequence_contact_12, c0_.create_at AS create_at_13, c0_.update_at AS update_at_14, c0_.meteo AS meteo_15, c0_.client_id AS client_id_16 FROM capitainerie c0_ INNER JOIN client c1_ ON c0_.client_id = c1_.id WHERE c1_.id = ?
Parameters:
[
24
]
|
| 2 | 0.57 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lien AS lien_3, t0.capitainerie_id AS capitainerie_id_4 FROM camera t0 WHERE t0.capitainerie_id = ?
Parameters:
[
43
]
|
| 3 | 0.55 ms |
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.capitainerie_id = ?
Parameters:
[
43
]
|
| 4 | 0.42 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.valeur AS valeur_3, t0.icone_id AS icone_id_4, t0.capitainerie_id AS capitainerie_id_5 FROM capitainerie_service t0 WHERE t0.capitainerie_id = ?
Parameters:
[
43
]
|
| 5 | 0.50 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.tourin_soft_id AS tourin_soft_id_4, t0.est_synchronise AS est_synchronise_5, t0.partenaire_id AS partenaire_id_6, t0.capitainerie_id AS capitainerie_id_7 FROM saison t0 WHERE t0.capitainerie_id = ?
Parameters:
[
43
]
|
| 6 | 0.25 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
5981
]
|
| 7 | 0.34 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
5984
]
|
| 8 | 0.25 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
5987
]
|
| 9 | 0.22 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6936
]
|
| 10 | 0.20 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6937
]
|
| 11 | 0.19 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6938
]
|
| 12 | 0.18 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6939
]
|
| 13 | 0.18 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6940
]
|
| 14 | 0.20 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6941
]
|
| 15 | 0.22 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6942
]
|
| 16 | 0.22 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6943
]
|
| 17 | 0.20 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6944
]
|
| 18 | 0.23 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6945
]
|
| 19 | 0.23 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6946
]
|
| 20 | 0.22 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6984
]
|
| 21 | 0.20 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6985
]
|
| 22 | 0.20 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6986
]
|
| 23 | 0.20 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6987
]
|
| 24 | 0.19 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6988
]
|
| 25 | 0.19 ms |
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.horaire AS horaire_3, t0.saison_id AS saison_id_4 FROM horaire t0 WHERE t0.saison_id = ?
Parameters:
[
6989
]
|
| 26 | 0.20 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.capitainerie_id AS capitainerie_id_4 FROM capitainerie_annuaire t0 WHERE t0.capitainerie_id = ?
Parameters:
[
43
]
|
| 27 | 0.28 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.numero AS numero_3, t0.email AS email_4, t0.annuaire_id AS annuaire_id_5 FROM numero t0 WHERE t0.annuaire_id = ?
Parameters:
[
6
]
|
| 28 | 0.28 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.numero AS numero_3, t0.email AS email_4, t0.annuaire_id AS annuaire_id_5 FROM numero t0 WHERE t0.annuaire_id = ?
Parameters:
[
7
]
|
| 29 | 0.22 ms |
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.capitainerie_id = ?
Parameters:
[
43
]
|
| 30 | 0.19 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image_url AS image_url_3, t0.lien AS lien_4, t0.capitainerie_id AS capitainerie_id_5 FROM institution t0 WHERE t0.capitainerie_id = ?
Parameters:
[
43
]
|
| 31 | 0.24 ms |
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 capitainerie_image ON t0.id = capitainerie_image.image_id WHERE capitainerie_image.capitainerie_id = ?
Parameters:
[
43
]
|
| 32 | 0.34 ms |
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\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\Actualite | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\Institution | No errors. |
| App\Entity\Camera | No errors. |
| App\Entity\Administrateur |
|
| App\Entity\Partenaire |
|
| App\Entity\Icone |
|
| App\Entity\Horaire | No errors. |
| App\Entity\Numero | No errors. |
| App\Entity\Entite |
|
| App\Entity\Categorie | No errors. |
| App\Entity\MobileApp | No errors. |