Query Metrics
5
Database Queries
5
Different statements
16.40 ms
Query time
12
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
13.50 ms (82.28%) |
1 |
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:
[ 107 "cancel" ] |
1.79 ms (10.94%) |
1 |
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:
[ 107 1 "2024-10-23" "plan" "modifier" ] |
0.39 ms (2.40%) |
1 |
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:
[
107
]
|
0.38 ms (2.34%) |
1 |
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:
[
55
]
|
0.33 ms (2.04%) |
1 |
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:
[
59
]
|
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 |
|
App\Entity\Intervenant |
|
App\Entity\SessionSalon |
|
App\Entity\Salon |
|
App\Entity\RDV |
|
App\Entity\Address | No errors. |
App\Entity\GridPrice | No errors. |
App\Entity\Site |
|
App\Entity\IntervenantSalon | No errors. |
App\Entity\Site\Logistique |
|
App\Entity\Contact |
|
App\Entity\Contract |
|
App\Entity\CancelReason | No errors. |
App\Entity\Client |
|
App\Entity\Recurrence | No errors. |
App\Entity\RDVProduct |
|
App\Entity\Billing | No errors. |
App\Entity\RDVBilling | No errors. |
App\Entity\LogPlanning |
|
App\Entity\LogCancel | No errors. |