GET https://pemb-baignades-dev.anakrys.biz/bateaux

Query Metrics

14 Database Queries
6 Different statements
8.67 ms Query time
1 Invalid entities
42 Managed entities

Queries

Group similar statements

# Time Info
1 1.66 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.photo_principale AS photo_principale_4, t0.photos AS photos_5, t0.actif AS actif_6, t0.indisponible AS indisponible_7, t0.ordre AS ordre_8, t0.lien_facebook AS lien_facebook_9, t0.lien_instagram AS lien_instagram_10, t0.lien_tripadvisor AS lien_tripadvisor_11, t0.created_at AS created_at_12, t0.bateau_type_id AS bateau_type_id_13 FROM bateau t0 WHERE t0.actif = ? ORDER BY t0.ordre ASC, t0.id ASC
Parameters:
[
  1
]
2 1.10 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.capacite AS capacite_4, t0.photo_principale AS photo_principale_5 FROM bateau_type t0
Parameters:
[]
3 0.96 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.duree_minutes AS duree_minutes_3, t0.actif AS actif_4, t0.ordre AS ordre_5 FROM bateau_crenau t0 WHERE t0.actif = ? ORDER BY t0.ordre ASC
Parameters:
[
  1
]
4 0.69 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.tarif AS tarif_4, t0.actif AS actif_5, t0.crenau_id AS crenau_id_6 FROM bateau_pack t0 WHERE t0.actif = ?
Parameters:
[
  1
]
5 0.85 ms
SELECT t0.id AS id_1, t0.tarif AS tarif_2, t0.crenau_id AS crenau_id_3, t0.bateau_type_id AS bateau_type_id_4 FROM bateau_crenau_tarif t0 WHERE t0.crenau_id = ? AND t0.bateau_type_id = ? LIMIT 1
Parameters:
[
  1
  1
]
6 0.25 ms
SELECT t0.id AS id_1, t0.tarif AS tarif_2, t0.crenau_id AS crenau_id_3, t0.bateau_type_id AS bateau_type_id_4 FROM bateau_crenau_tarif t0 WHERE t0.crenau_id = ? AND t0.bateau_type_id = ? LIMIT 1
Parameters:
[
  1
  2
]
7 0.28 ms
SELECT t0.id AS id_1, t0.tarif AS tarif_2, t0.crenau_id AS crenau_id_3, t0.bateau_type_id AS bateau_type_id_4 FROM bateau_crenau_tarif t0 WHERE t0.crenau_id = ? AND t0.bateau_type_id = ? LIMIT 1
Parameters:
[
  2
  1
]
8 0.32 ms
SELECT t0.id AS id_1, t0.tarif AS tarif_2, t0.crenau_id AS crenau_id_3, t0.bateau_type_id AS bateau_type_id_4 FROM bateau_crenau_tarif t0 WHERE t0.crenau_id = ? AND t0.bateau_type_id = ? LIMIT 1
Parameters:
[
  2
  2
]
9 0.23 ms
SELECT t0.id AS id_1, t0.tarif AS tarif_2, t0.crenau_id AS crenau_id_3, t0.bateau_type_id AS bateau_type_id_4 FROM bateau_crenau_tarif t0 WHERE t0.crenau_id = ? AND t0.bateau_type_id = ? LIMIT 1
Parameters:
[
  3
  1
]
10 0.36 ms
SELECT t0.id AS id_1, t0.tarif AS tarif_2, t0.crenau_id AS crenau_id_3, t0.bateau_type_id AS bateau_type_id_4 FROM bateau_crenau_tarif t0 WHERE t0.crenau_id = ? AND t0.bateau_type_id = ? LIMIT 1
Parameters:
[
  3
  2
]
11 0.34 ms
SELECT t0.id AS id_1, t0.tarif AS tarif_2, t0.crenau_id AS crenau_id_3, t0.bateau_type_id AS bateau_type_id_4 FROM bateau_crenau_tarif t0 WHERE t0.crenau_id = ? AND t0.bateau_type_id = ? LIMIT 1
Parameters:
[
  4
  1
]
12 0.22 ms
SELECT t0.id AS id_1, t0.tarif AS tarif_2, t0.crenau_id AS crenau_id_3, t0.bateau_type_id AS bateau_type_id_4 FROM bateau_crenau_tarif t0 WHERE t0.crenau_id = ? AND t0.bateau_type_id = ? LIMIT 1
Parameters:
[
  4
  2
]
13 0.97 ms
SELECT t0.id AS id_1, t0.date_expiration AS date_expiration_2, t0.message AS message_3, t0.icon AS icon_4, t0.type AS type_5 FROM alerte t0 WHERE t0.type = ?
Parameters:
[
  "baignade"
]
14 0.43 ms
SELECT t0.id AS id_1, t0.date_expiration AS date_expiration_2, t0.message AS message_3, t0.icon AS icon_4, t0.type AS type_5 FROM alerte t0 WHERE t0.type = ?
Parameters:
[
  "bateau"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Alerte 23
App\Entity\BateauCrenauTarif 8
App\Entity\BateauCrenau 4
App\Entity\BateauPack 3
App\Entity\Bateau 2
App\Entity\BateauType 2

Entities Mapping

Class Mapping errors
App\Entity\Bateau No errors.
App\Entity\BateauType No errors.
App\Entity\BateauIndisponibilite No errors.
App\Entity\BateauReservation No errors.
App\Entity\BateauCrenau
  • The field App\Entity\BateauCrenau#tarifs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\BateauCrenauTarif#crenau does not contain the required 'inversedBy: "tarifs"' attribute.
App\Entity\BateauPack No errors.
App\Entity\BateauCrenauTarif No errors.
App\Entity\BateauOption No errors.
App\Entity\Alerte No errors.