GET https://asplaisancier.alizee-soft.com/api/v1/capitaineries/client/24?api%2Fv1%2Fcapitaineries%2Fclient%2F24=

Query Metrics

32 Database Queries
12 Different statements
9.16 ms Query time
9 Invalid entities

Queries

Group similar statements

# 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
  • The association App\Entity\Capitainerie#image refers to the owning side field App\Entity\Image#capitainerie which does not exist.
  • The mappings App\Entity\Capitainerie#piece_joint and App\Entity\PieceJointe#capitainerie are inconsistent with each other.
App\Entity\Client
  • The association App\Entity\Client#partenaire refers to the inverse side field App\Entity\Partenaire#clients which does not exist.
App\Entity\Lien
  • The association App\Entity\Lien#entite refers to the inverse side field App\Entity\Entite#liens which does not exist.
  • The association App\Entity\Lien#partenaire refers to the inverse side field App\Entity\Partenaire#liens which does not exist.
App\Entity\Reseau No errors.
App\Entity\Image No errors.
App\Entity\Saison No errors.
App\Entity\Annuaire No errors.
App\Entity\CapitainerieService
  • The mappings App\Entity\CapitainerieService#icone and App\Entity\Icone#capitainerieServices are inconsistent with each other.
App\Entity\PieceJointe
  • The association App\Entity\PieceJointe#capitainerie refers to the inverse side field App\Entity\Capitainerie#piece_jointe which does not exist.
App\Entity\Actualite No errors.
App\Entity\Evenement No errors.
App\Entity\Institution No errors.
App\Entity\Camera No errors.
App\Entity\Administrateur
  • The association App\Entity\Administrateur#client refers to the inverse side field App\Entity\Client#administrateurs which does not exist.
App\Entity\Partenaire
  • The association App\Entity\Partenaire#capitainerie refers to the inverse side field App\Entity\Capitainerie#partenaires which does not exist.
  • The association App\Entity\Partenaire#image refers to the owning side field App\Entity\Image#partenaire which does not exist.
App\Entity\Icone
  • The mappings App\Entity\Icone#partenaireReseaus and App\Entity\PartenaireReseau#icone are inconsistent with each other.
  • The mappings App\Entity\Icone#entiteReseaus and App\Entity\EntiteReseau#icone are inconsistent with each other.
  • The association App\Entity\Icone#capitainerieServices refers to the owning side field App\Entity\CapitainerieService#icon which does not exist.
App\Entity\Horaire No errors.
App\Entity\Numero No errors.
App\Entity\Entite
  • The association App\Entity\Entite#capitainerie refers to the inverse side field App\Entity\Capitainerie#entite which does not exist.
  • The association App\Entity\Entite#images refers to the owning side field App\Entity\Image#entite which does not exist.
App\Entity\Categorie No errors.
App\Entity\MobileApp No errors.