https://emmaconnect.fr/reservation/search/for/get-salon-availability?salonId=126

Query Metrics

5 Database Queries
5 Different statements
3.46 ms Query time
12 Invalid entities

Queries

Group similar statements

# Time Info
1 0.36 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.intervenant_id AS intervenant_id_5 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  594
]
2 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.service AS service_3, t0.status AS status_4, t0.openingDays AS openingDays_5, t0.date_activity_end AS date_activity_end_6, t0.specific_billing AS specific_billing_7, t0.date_open AS date_open_8, t0.date_end AS date_end_9, t0.opening_time AS opening_time_10, t0.closing_time AS closing_time_11, t0.address_id AS address_id_12, t0.gridprice_id AS gridprice_id_13, t0.site_id AS site_id_14 FROM salon t0 WHERE t0.id = ?
Parameters:
[
  126
]
3 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.enseigne AS enseigne_4, t0.phone AS phone_5, t0.status AS status_6, t0.zoneGeographique AS zoneGeographique_7, t0.consignesLingeries AS consignesLingeries_8, t0.parking AS parking_9, t0.rangementCles AS rangementCles_10, t0.localPoubelles AS localPoubelles_11, t0.codeAccess AS codeAccess_12, t0.filename AS filename_13, t0.autresInformations AS autresInformations_14, t0.emailSite AS emailSite_15, t0.no_display_reservation AS no_display_reservation_16, t0.no_display_annuaire AS no_display_annuaire_17, t0.created AS created_18, t0.updated AS updated_19, t0.logistique_id AS logistique_id_20, t0.address_id AS address_id_21, t0.contactCommercial_id AS contactCommercial_id_22, t0.contactBilling_id AS contactBilling_id_23, t0.contact_id AS contact_id_24, t0.creator_id AS creator_id_25, t0.maj_id AS maj_id_26 FROM site t0 WHERE t0.id = ?
Parameters:
[
  68
]
4 1.23 ms
SELECT r0_.id AS id_0, r0_.priorite AS priorite_1, r0_.validated AS validated_2, r0_.status AS status_3, r0_.`start` AS start_4, r0_.`end` AS end_5, r0_.comment AS comment_6, r0_.comment_forfait AS comment_forfait_7, r0_.recurrence AS recurrence_8, r0_.has_add_service AS has_add_service_9, r0_.order_id AS order_id_10, r0_.payment_link AS payment_link_11, r0_.is_platform AS is_platform_12, r0_.new_recurrence AS new_recurrence_13, r0_.intervenant_type AS intervenant_type_14, r0_.contract AS contract_15, r0_.cancel_reason_id AS cancel_reason_id_16, r0_.client_id AS client_id_17, r0_.salon_id AS salon_id_18, r0_.author_id AS author_id_19, r0_.recurrence_rdvs_id AS recurrence_rdvs_id_20 FROM `rdv` r0_ WHERE r0_.salon_id = ? AND r0_.status <> ?
Parameters:
[
  126
  "cancel"
]
5 0.98 ms
SELECT s0_.id AS id_0, s0_.start AS start_1, s0_.end AS end_2, s0_.comment AS comment_3, s0_.horaires AS horaires_4, s0_.status AS status_5, s0_.action_arealiser AS action_arealiser_6, s0_.observation AS observation_7, s0_.created_at AS created_at_8, s0_.salon_id AS salon_id_9, s0_.intervenant_id AS intervenant_id_10 FROM session_salon s0_ INNER JOIN salon s1_ ON s0_.salon_id = s1_.id WHERE s0_.salon_id = ? AND s1_.status = ? AND s0_.start >= ? AND (s0_.status = ? OR s0_.status = ?) ORDER BY s0_.start ASC LIMIT 5
Parameters:
[
  126
  1
  "2024-10-17"
  "plan"
  "modifier"
]

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
  • The field App\Entity\User#intervenant is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Intervenant#user does not contain the required 'mappedBy="intervenant"' attribute.
App\Entity\Intervenant
  • The field App\Entity\Intervenant#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#intervenant does not contain the required 'mappedBy="user"' attribute.
  • The field App\Entity\Intervenant#workContract is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\WorkContract#intervenant does not contain the required 'mappedBy="workContract"' attribute.
  • The field App\Entity\Intervenant#absences is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Absence#intervenant does not contain the required 'inversedBy="absences"' attribute.
  • The mappings App\Entity\Intervenant#rdvs and App\Entity\RDV#intervenant are inconsistent with each other.
  • The association App\Entity\Intervenant#address refers to the inverse side field App\Entity\Address#personn which does not exist.
App\Entity\SessionSalon
  • The association App\Entity\SessionSalon#salon refers to the inverse side field App\Entity\Salon#session which does not exist.
  • The association App\Entity\SessionSalon#intervenant refers to the inverse side field App\Entity\Intervenant#session which does not exist.
App\Entity\Salon
  • The field App\Entity\Salon#intervenantSalons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\IntervenantSalon#salon does not contain the required 'inversedBy="intervenantSalons"' attribute.
App\Entity\RDV
  • The mappings App\Entity\RDV#rdvProducts and App\Entity\RDVProduct#rdv are inconsistent with each other.
  • The mappings App\Entity\RDV#billings and App\Entity\Billing#RDV are inconsistent with each other.
  • The association App\Entity\RDV#intervenant refers to the inverse side field App\Entity\Intervenant#rdv which does not exist.
  • The association App\Entity\RDV#client refers to the inverse side field App\Entity\Client#rdv which does not exist.
  • The association App\Entity\RDV#author refers to the inverse side field App\Entity\User#rdv which does not exist.
App\Entity\Address No errors.
App\Entity\GridPrice No errors.
App\Entity\Site
  • The field App\Entity\Site#logistique is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Site\Logistique#site does not contain the required 'mappedBy="logistique"' attribute.
  • The field App\Entity\Site#salons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Salon#site does not contain the required 'inversedBy="salons"' attribute.
  • The field App\Entity\Site#othersContacts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contact#site does not contain the required 'inversedBy="othersContacts"' attribute.
App\Entity\IntervenantSalon No errors.
App\Entity\Site\Logistique
  • The field App\Entity\Site\Logistique#site is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Site#logistique does not contain the required 'mappedBy="site"' attribute.
App\Entity\Contact
  • The association App\Entity\Contact#address refers to the inverse side field App\Entity\Address#personn which does not exist.
App\Entity\Contract
  • The mappings App\Entity\Contract#contractProducts and App\Entity\ContractProduct#contract are inconsistent with each other.
App\Entity\CancelReason No errors.
App\Entity\Client
  • The field App\Entity\Client#contract is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contract#client does not contain the required 'inversedBy="contract"' attribute.
  • The field App\Entity\Client#familyMembers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Client\FamilyMember#client does not contain the required 'inversedBy="familyMembers"' attribute.
App\Entity\Recurrence No errors.
App\Entity\RDVProduct
  • The association App\Entity\RDVProduct#product refers to the inverse side field App\Entity\Product#rdvProduct which does not exist.
  • The association App\Entity\RDVProduct#rdv refers to the inverse side field App\Entity\RDV#rdvProduct which does not exist.
App\Entity\Billing No errors.
App\Entity\RDVBilling No errors.
App\Entity\LogPlanning
  • The mappings App\Entity\LogPlanning#newIntervenant and App\Entity\Intervenant#logPlannings are inconsistent with each other.
App\Entity\LogCancel No errors.