https://emmaconnect.fr/planning/555901/edit Return to referer URL

Query Metrics

245 Database Queries
33 Different statements
357.33 ms Query time
19 Invalid entities

Grouped Statements

Show all queries

Time Count Info
207.40 ms
(58.04%)
1
SELECT c0_.id AS id_0, c0_.identifier AS identifier_1, c0_.firstname AS firstname_2, c0_.numeroClient AS numeroClient_3, c0_.civilite AS civilite_4, c0_.lastname AS lastname_5, c0_.birthday AS birthday_6, c0_.deathday AS deathday_7, c0_.gender AS gender_8, c0_.email AS email_9, c0_.phone AS phone_10, c0_.comments AS comments_11, c0_.suivi_client AS suivi_client_12, c0_.room_number AS room_number_13, c0_.building_room AS building_room_14, c0_.stairs AS stairs_15, c0_.nom_tuteur AS nom_tuteur_16, c0_.civilite_tuteur AS civilite_tuteur_17, c0_.prenom_tuteur AS prenom_tuteur_18, c0_.email_tuteur AS email_tuteur_19, c0_.email_notaire AS email_notaire_20, c0_.num_tuteur AS num_tuteur_21, c0_.type_tuteur AS type_tuteur_22, c0_.days_of_week AS days_of_week_23, c0_.comment_tuteur AS comment_tuteur_24, c0_.consignes_client AS consignes_client_25, c0_.status_prospect AS status_prospect_26, c0_.profil_client AS profil_client_27, c0_.address_tuteur AS address_tuteur_28, c0_.address_tuteur2 AS address_tuteur2_29, c0_.city_tuteur AS city_tuteur_30, c0_.zipcode AS zipcode_31, c0_.created AS created_32, c0_.updated AS updated_33, c0_.privacy_policy_accepted AS privacy_policy_accepted_34, c0_.email_agreement AS email_agreement_35, c0_.cgv_accepted AS cgv_accepted_36, c0_.has_signed_easy_collect AS has_signed_easy_collect_37, c0_.address_facturation AS address_facturation_38, c0_.complement_adresse_facturation AS complement_adresse_facturation_39, c0_.code_postal_facturation AS code_postal_facturation_40, c0_.ville_facturation AS ville_facturation_41, c0_.nom_facturation AS nom_facturation_42, c0_.prenom_facturation AS prenom_facturation_43, c0_.civilite_facturation AS civilite_facturation_44, c0_.site_id AS site_id_45, c0_.contact_id AS contact_id_46, c0_.billing_infos_id AS billing_infos_id_47, c0_.creator_id AS creator_id_48, c0_.maj_id AS maj_id_49 FROM client c0_ WHERE (c0_.status_prospect <> ? AND c0_.status_prospect <> ?) OR c0_.status_prospect IS NULL
Parameters:
[
  "Inactif"
  "Parti"
]
46.54 ms
(13.03%)
15
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_ WHERE s0_.start > ? AND s0_.salon_id = ? AND s0_.status <> ? ORDER BY s0_.start ASC LIMIT 1
Parameters:
[
  "2024-11-23 10:00:00"
  160
  "indisponible"
]
29.08 ms
(8.14%)
83
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:
[
  23
]
18.92 ms
(5.29%)
83
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.zipcode AS zipcode_4, t0.city AS city_5 FROM address t0 WHERE t0.id = ?
Parameters:
[
  99
]
12.72 ms
(3.56%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.marque AS marque_2, p0_.gamme AS gamme_3, p0_.compte AS compte_4, p0_.facturation AS facturation_5, p0_.type_taux_tva AS type_taux_tva_6, p0_.ui AS ui_7, p0_.mesure AS mesure_8, p0_.type AS type_9, p0_.fournisseur AS fournisseur_10, p0_.remiseGenerale AS remiseGenerale_11, p0_.tempsNormatif AS tempsNormatif_12, p0_.forfaitIllimite AS forfaitIllimite_13, p0_.reference AS reference_14, p0_.price_sell_ht_a AS price_sell_ht_a_15, p0_.price_ht_b AS price_ht_b_16, p0_.price_ht_c AS price_ht_c_17, p0_.price_ht_c_d AS price_ht_c_d_18, p0_.price_ht AS price_ht_19, p0_.marge AS marge_20, p0_.tva AS tva_21, p0_.type_tva AS type_tva_22, p0_.stock_quantity AS stock_quantity_23, p0_.gestion_stock AS gestion_stock_24, p0_.order_multiple AS order_multiple_25, p0_.indisponible_vente AS indisponible_vente_26, p0_.unitVente AS unitVente_27, p0_.mandatory AS mandatory_28, p0_.no_reservation AS no_reservation_29, p0_.commercial_name AS commercial_name_30, p0_.checked AS checked_31, p0_.ordering AS ordering_32, p0_.product_type AS product_type_33, p0_.famille AS famille_34, p0_.sous_famille AS sous_famille_35 FROM product p0_ WHERE p0_.type = ? AND p0_.indisponible_vente = ?
Parameters:
[
  "coiffure"
  0
]
6.18 ms
(1.73%)
3
"COMMIT"
Parameters:
[]
5.26 ms
(1.47%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.service AS service_2, s0_.status AS status_3, s0_.openingDays AS openingDays_4, s0_.date_activity_end AS date_activity_end_5, s0_.specific_billing AS specific_billing_6, s0_.date_open AS date_open_7, s0_.date_end AS date_end_8, s0_.opening_time AS opening_time_9, s0_.closing_time AS closing_time_10, s0_.address_id AS address_id_11, s0_.gridprice_id AS gridprice_id_12, s0_.site_id AS site_id_13 FROM salon s0_
Parameters:
[]
4.54 ms
(1.27%)
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_.cheque_reception AS cheque_reception_14, r0_.info_cheque AS info_cheque_15, r0_.code_promo_applied AS code_promo_applied_16, r0_.intervenant_type AS intervenant_type_17, r0_.contract AS contract_18, r0_.cancel_reason_id AS cancel_reason_id_19, r0_.client_id AS client_id_20, r0_.salon_id AS salon_id_21, r0_.author_id AS author_id_22, r0_.recurrence_rdvs_id AS recurrence_rdvs_id_23, r0_.code_promo_id AS code_promo_id_24 FROM `rdv` r0_ WHERE r0_.new_recurrence = 1 AND r0_.status = ? AND r0_.client_id = ? AND r0_.salon_id = ? AND r0_.`start` > ? ORDER BY r0_.`start` ASC
Parameters:
[
  "plan"
  15917
  160
  "2024-11-22"
]
4.29 ms
(1.20%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.purcent AS purcent_2, p0_.type AS type_3, p0_.code AS code_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.service AS service_7 FROM promo_code p0_
Parameters:
[]
3.53 ms
(0.99%)
14
UPDATE `rdv` SET `start` = ?, `end` = ? WHERE id = ?
Parameters:
[
  "2024-12-02 10:00:00"
  "2024-12-02 10:00:00"
  490829
]
2.13 ms
(0.60%)
4
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.marque AS marque_2, p0_.gamme AS gamme_3, p0_.compte AS compte_4, p0_.facturation AS facturation_5, p0_.type_taux_tva AS type_taux_tva_6, p0_.ui AS ui_7, p0_.mesure AS mesure_8, p0_.type AS type_9, p0_.fournisseur AS fournisseur_10, p0_.remiseGenerale AS remiseGenerale_11, p0_.tempsNormatif AS tempsNormatif_12, p0_.forfaitIllimite AS forfaitIllimite_13, p0_.reference AS reference_14, p0_.price_sell_ht_a AS price_sell_ht_a_15, p0_.price_ht_b AS price_ht_b_16, p0_.price_ht_c AS price_ht_c_17, p0_.price_ht_c_d AS price_ht_c_d_18, p0_.price_ht AS price_ht_19, p0_.marge AS marge_20, p0_.tva AS tva_21, p0_.type_tva AS type_tva_22, p0_.stock_quantity AS stock_quantity_23, p0_.gestion_stock AS gestion_stock_24, p0_.order_multiple AS order_multiple_25, p0_.indisponible_vente AS indisponible_vente_26, p0_.unitVente AS unitVente_27, p0_.mandatory AS mandatory_28, p0_.no_reservation AS no_reservation_29, p0_.commercial_name AS commercial_name_30, p0_.checked AS checked_31, p0_.ordering AS ordering_32, p0_.product_type AS product_type_33, p0_.famille AS famille_34, p0_.sous_famille AS sous_famille_35 FROM product p0_ WHERE p0_.type = ? AND p0_.indisponible_vente = ? AND p0_.id IN (?)
Parameters:
[
  "coiffure"
  0
  "2"
]
1.83 ms
(0.51%)
8
INSERT INTO rdv_product (product_id, rdv_id) VALUES (?, ?)
Parameters:
[
  34
  557926
]
1.75 ms
(0.49%)
4
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.rdv_id AS rdv_id_3 FROM rdv_product t0 WHERE t0.product_id = ? AND t0.rdv_id = ? LIMIT 1
Parameters:
[
  "2"
  555901
]
1.68 ms
(0.47%)
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:
[
  160
]
1.11 ms
(0.31%)
1
SELECT i0_.birthday_place AS birthday_place_0, i0_.num_identite AS num_identite_1, i0_.metier AS metier_2, i0_.status AS status_3, i0_.email_pro AS email_pro_4, i0_.situationFamille AS situationFamille_5, i0_.transport_mode AS transport_mode_6, i0_.num_secu AS num_secu_7, i0_.contact_nom AS contact_nom_8, i0_.contact_tel AS contact_tel_9, i0_.image AS image_10, i0_.cni AS cni_11, i0_.nb_blouse AS nb_blouse_12, i0_.taille_blouse AS taille_blouse_13, i0_.model_tablette AS model_tablette_14, i0_.ref_tablette AS ref_tablette_15, i0_.carte_sim AS carte_sim_16, i0_.date_retour_tablette AS date_retour_tablette_17, i0_.date_remise_tablette AS date_remise_tablette_18, i0_.identifiantEmma AS identifiantEmma_19, i0_.motdepassemma AS motdepassemma_20, i0_.mailpro AS mailpro_21, i0_.mot_de_passe_email_pro AS mot_de_passe_email_pro_22, i0_.id AS id_23, i0_.firstname AS firstname_24, i0_.lastname AS lastname_25, i0_.nom_jeune_fille AS nom_jeune_fille_26, i0_.birthday AS birthday_27, i0_.deathday AS deathday_28, i0_.gender AS gender_29, i0_.email AS email_30, i0_.phone AS phone_31, i0_.phone_gcm AS phone_gcm_32, i0_.comments AS comments_33, i0_.user_id AS user_id_34, i0_.workContract_id AS workContract_id_35, i0_.country_id AS country_id_36, i0_.departement_id AS departement_id_37, i0_.nationality_id AS nationality_id_38, i0_.address_id AS address_id_39 FROM intervenant i0_
Parameters:
[]
1.09 ms
(0.31%)
4
DELETE FROM rdv_product WHERE id = ?
Parameters:
[
  2061185
]
0.95 ms
(0.27%)
1
SELECT t0.birthday_place AS birthday_place_1, t0.num_identite AS num_identite_2, t0.metier AS metier_3, t0.status AS status_4, t0.email_pro AS email_pro_5, t0.situationFamille AS situationFamille_6, t0.transport_mode AS transport_mode_7, t0.num_secu AS num_secu_8, t0.contact_nom AS contact_nom_9, t0.contact_tel AS contact_tel_10, t0.image AS image_11, t0.cni AS cni_12, t0.nb_blouse AS nb_blouse_13, t0.taille_blouse AS taille_blouse_14, t0.model_tablette AS model_tablette_15, t0.ref_tablette AS ref_tablette_16, t0.carte_sim AS carte_sim_17, t0.date_retour_tablette AS date_retour_tablette_18, t0.date_remise_tablette AS date_remise_tablette_19, t0.identifiantEmma AS identifiantEmma_20, t0.motdepassemma AS motdepassemma_21, t0.mailpro AS mailpro_22, t0.mot_de_passe_email_pro AS mot_de_passe_email_pro_23, t0.id AS id_24, t0.firstname AS firstname_25, t0.lastname AS lastname_26, t0.nom_jeune_fille AS nom_jeune_fille_27, t0.birthday AS birthday_28, t0.deathday AS deathday_29, t0.gender AS gender_30, t0.email AS email_31, t0.phone AS phone_32, t0.phone_gcm AS phone_gcm_33, t0.comments AS comments_34, t0.user_id AS user_id_35, t0.workContract_id AS workContract_id_36, t0.country_id AS country_id_37, t0.departement_id AS departement_id_38, t0.nationality_id AS nationality_id_39, t0.address_id AS address_id_40 FROM intervenant t0 WHERE t0.id = ?
Parameters:
[
  30
]
0.94 ms
(0.26%)
2
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.rdv_id AS rdv_id_3 FROM rdv_product t0 WHERE t0.rdv_id = ?
Parameters:
[
  555901
]
0.64 ms
(0.18%)
3
"START TRANSACTION"
Parameters:
[]
0.64 ms
(0.18%)
1
SELECT t0.id AS id_1, t0.priorite AS priorite_2, t0.validated AS validated_3, t0.status AS status_4, t0.`start` AS start_5, t0.`end` AS end_6, t0.comment AS comment_7, t0.comment_forfait AS comment_forfait_8, t0.recurrence AS recurrence_9, t0.has_add_service AS has_add_service_10, t0.order_id AS order_id_11, t0.payment_link AS payment_link_12, t0.is_platform AS is_platform_13, t0.new_recurrence AS new_recurrence_14, t0.cheque_reception AS cheque_reception_15, t0.info_cheque AS info_cheque_16, t0.code_promo_applied AS code_promo_applied_17, t0.intervenant_type AS intervenant_type_18, t0.contract AS contract_19, t0.cancel_reason_id AS cancel_reason_id_20, t0.client_id AS client_id_21, t0.salon_id AS salon_id_22, t0.author_id AS author_id_23, t0.recurrence_rdvs_id AS recurrence_rdvs_id_24, t0.code_promo_id AS code_promo_id_25 FROM `rdv` t0 WHERE t0.id = ?
Parameters:
[
  "555901"
]
0.62 ms
(0.17%)
1
SELECT t0.id AS id_1, t0.dateBilling AS dateBilling_2, t0.sendingDate AS sendingDate_3, t0.modeFacturation AS modeFacturation_4, t0.code AS code_5, t0.comment AS comment_6, t0.paidPaytweak AS paidPaytweak_7, t0.ht AS ht_8, t0.ttc AS ttc_9, t0.solde AS solde_10, t0.status AS status_11, t0.accompte AS accompte_12, t0.linkPaytweak AS linkPaytweak_13, t0.linkPaytweakExpire AS linkPaytweakExpire_14, t0.type AS type_15, t0.created AS created_16, t0.updated AS updated_17, t0.client_id AS client_id_18, t0.site_id AS site_id_19, t0.company_id AS company_id_20, t0.reglement_id AS reglement_id_21, t0.rdv_id AS rdv_id_22, t0.creator_id AS creator_id_23, t0.maj_id AS maj_id_24 FROM billing t0 WHERE t0.rdv_id = ?
Parameters:
[
  555901
]
0.61 ms
(0.17%)
1
SELECT i0_.birthday_place AS birthday_place_0, i0_.num_identite AS num_identite_1, i0_.metier AS metier_2, i0_.status AS status_3, i0_.email_pro AS email_pro_4, i0_.situationFamille AS situationFamille_5, i0_.transport_mode AS transport_mode_6, i0_.num_secu AS num_secu_7, i0_.contact_nom AS contact_nom_8, i0_.contact_tel AS contact_tel_9, i0_.image AS image_10, i0_.cni AS cni_11, i0_.nb_blouse AS nb_blouse_12, i0_.taille_blouse AS taille_blouse_13, i0_.model_tablette AS model_tablette_14, i0_.ref_tablette AS ref_tablette_15, i0_.carte_sim AS carte_sim_16, i0_.date_retour_tablette AS date_retour_tablette_17, i0_.date_remise_tablette AS date_remise_tablette_18, i0_.identifiantEmma AS identifiantEmma_19, i0_.motdepassemma AS motdepassemma_20, i0_.mailpro AS mailpro_21, i0_.mot_de_passe_email_pro AS mot_de_passe_email_pro_22, i0_.id AS id_23, i0_.firstname AS firstname_24, i0_.lastname AS lastname_25, i0_.nom_jeune_fille AS nom_jeune_fille_26, i0_.birthday AS birthday_27, i0_.deathday AS deathday_28, i0_.gender AS gender_29, i0_.email AS email_30, i0_.phone AS phone_31, i0_.phone_gcm AS phone_gcm_32, i0_.comments AS comments_33, i0_.user_id AS user_id_34, i0_.workContract_id AS workContract_id_35, i0_.country_id AS country_id_36, i0_.departement_id AS departement_id_37, i0_.nationality_id AS nationality_id_38, i0_.address_id AS address_id_39 FROM intervenant i0_ WHERE i0_.id IN (?)
Parameters:
[
  "30"
]
0.60 ms
(0.17%)
1
INSERT INTO `rdv` (priorite, validated, status, `start`, `end`, comment, comment_forfait, recurrence, has_add_service, order_id, payment_link, is_platform, new_recurrence, cheque_reception, info_cheque, code_promo_applied, intervenant_type, contract, cancel_reason_id, client_id, salon_id, author_id, recurrence_rdvs_id, code_promo_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "1"
  null
  "rescheduled"
  "2024-11-25 10:00:00"
  "2024-11-25 10:00:00"
  null
  null
  null
  null
  null
  null
  0
  0
  null
  null
  null
  30
  null
  null
  15917
  160
  null
  1603
  null
]
0.56 ms
(0.16%)
1
SELECT c0_.id AS id_0, c0_.identifier AS identifier_1, c0_.firstname AS firstname_2, c0_.numeroClient AS numeroClient_3, c0_.civilite AS civilite_4, c0_.lastname AS lastname_5, c0_.birthday AS birthday_6, c0_.deathday AS deathday_7, c0_.gender AS gender_8, c0_.email AS email_9, c0_.phone AS phone_10, c0_.comments AS comments_11, c0_.suivi_client AS suivi_client_12, c0_.room_number AS room_number_13, c0_.building_room AS building_room_14, c0_.stairs AS stairs_15, c0_.nom_tuteur AS nom_tuteur_16, c0_.civilite_tuteur AS civilite_tuteur_17, c0_.prenom_tuteur AS prenom_tuteur_18, c0_.email_tuteur AS email_tuteur_19, c0_.email_notaire AS email_notaire_20, c0_.num_tuteur AS num_tuteur_21, c0_.type_tuteur AS type_tuteur_22, c0_.days_of_week AS days_of_week_23, c0_.comment_tuteur AS comment_tuteur_24, c0_.consignes_client AS consignes_client_25, c0_.status_prospect AS status_prospect_26, c0_.profil_client AS profil_client_27, c0_.address_tuteur AS address_tuteur_28, c0_.address_tuteur2 AS address_tuteur2_29, c0_.city_tuteur AS city_tuteur_30, c0_.zipcode AS zipcode_31, c0_.created AS created_32, c0_.updated AS updated_33, c0_.privacy_policy_accepted AS privacy_policy_accepted_34, c0_.email_agreement AS email_agreement_35, c0_.cgv_accepted AS cgv_accepted_36, c0_.has_signed_easy_collect AS has_signed_easy_collect_37, c0_.address_facturation AS address_facturation_38, c0_.complement_adresse_facturation AS complement_adresse_facturation_39, c0_.code_postal_facturation AS code_postal_facturation_40, c0_.ville_facturation AS ville_facturation_41, c0_.nom_facturation AS nom_facturation_42, c0_.prenom_facturation AS prenom_facturation_43, c0_.civilite_facturation AS civilite_facturation_44, c0_.site_id AS site_id_45, c0_.contact_id AS contact_id_46, c0_.billing_infos_id AS billing_infos_id_47, c0_.creator_id AS creator_id_48, c0_.maj_id AS maj_id_49 FROM client c0_ WHERE ((c0_.status_prospect <> ? AND c0_.status_prospect <> ?) OR c0_.status_prospect IS NULL) AND c0_.id IN (?)
Parameters:
[
  "Inactif"
  "Parti"
  "15917"
]
0.56 ms
(0.16%)
1
INSERT INTO log_cancel (created_at, intervenant_old_id, new_intervenant_id, session_salon_id) VALUES (?, ?, ?, ?)
Parameters:
[
  "2024-11-22 17:39:08"
  30
  30
  142513
]
0.47 ms
(0.13%)
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:
[
  29
]
0.45 ms
(0.13%)
1
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.firstname AS firstname_3, t0.numeroClient AS numeroClient_4, t0.civilite AS civilite_5, t0.lastname AS lastname_6, t0.birthday AS birthday_7, t0.deathday AS deathday_8, t0.gender AS gender_9, t0.email AS email_10, t0.phone AS phone_11, t0.comments AS comments_12, t0.suivi_client AS suivi_client_13, t0.room_number AS room_number_14, t0.building_room AS building_room_15, t0.stairs AS stairs_16, t0.nom_tuteur AS nom_tuteur_17, t0.civilite_tuteur AS civilite_tuteur_18, t0.prenom_tuteur AS prenom_tuteur_19, t0.email_tuteur AS email_tuteur_20, t0.email_notaire AS email_notaire_21, t0.num_tuteur AS num_tuteur_22, t0.type_tuteur AS type_tuteur_23, t0.days_of_week AS days_of_week_24, t0.comment_tuteur AS comment_tuteur_25, t0.consignes_client AS consignes_client_26, t0.status_prospect AS status_prospect_27, t0.profil_client AS profil_client_28, t0.address_tuteur AS address_tuteur_29, t0.address_tuteur2 AS address_tuteur2_30, t0.city_tuteur AS city_tuteur_31, t0.zipcode AS zipcode_32, t0.created AS created_33, t0.updated AS updated_34, t0.privacy_policy_accepted AS privacy_policy_accepted_35, t0.email_agreement AS email_agreement_36, t0.cgv_accepted AS cgv_accepted_37, t0.has_signed_easy_collect AS has_signed_easy_collect_38, t0.address_facturation AS address_facturation_39, t0.complement_adresse_facturation AS complement_adresse_facturation_40, t0.code_postal_facturation AS code_postal_facturation_41, t0.ville_facturation AS ville_facturation_42, t0.nom_facturation AS nom_facturation_43, t0.prenom_facturation AS prenom_facturation_44, t0.civilite_facturation AS civilite_facturation_45, t0.site_id AS site_id_46, t0.contact_id AS contact_id_47, t0.billing_infos_id AS billing_infos_id_48, t0.creator_id AS creator_id_49, t0.maj_id AS maj_id_50 FROM client t0 WHERE t0.id = ?
Parameters:
[
  15917
]
0.44 ms
(0.12%)
1
UPDATE `rdv` SET status = ?, has_add_service = ?, cheque_reception = ?, cancel_reason_id = ? WHERE id = ?
Parameters:
[
  "cancel"
  "Ne sait pas"
  0
  4
  555901
]
0.44 ms
(0.12%)
1
SELECT t0.id AS id_1, t0.rdv_id AS rdv_id_2, t3.id AS id_4, t3.priorite AS priorite_5, t3.validated AS validated_6, t3.status AS status_7, t3.`start` AS start_8, t3.`end` AS end_9, t3.comment AS comment_10, t3.comment_forfait AS comment_forfait_11, t3.recurrence AS recurrence_12, t3.has_add_service AS has_add_service_13, t3.order_id AS order_id_14, t3.payment_link AS payment_link_15, t3.is_platform AS is_platform_16, t3.new_recurrence AS new_recurrence_17, t3.cheque_reception AS cheque_reception_18, t3.info_cheque AS info_cheque_19, t3.code_promo_applied AS code_promo_applied_20, t3.intervenant_type AS intervenant_type_21, t3.contract AS contract_22, t3.cancel_reason_id AS cancel_reason_id_23, t3.client_id AS client_id_24, t3.salon_id AS salon_id_25, t3.author_id AS author_id_26, t3.recurrence_rdvs_id AS recurrence_rdvs_id_27, t3.code_promo_id AS code_promo_id_28, t0.billing_id AS billing_id_29 FROM rdvbilling t0 LEFT JOIN `rdv` t3 ON t0.rdv_id = t3.id WHERE t0.rdv_id = ?
Parameters:
[
  555901
]
0.43 ms
(0.12%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.marque AS marque_2, p0_.gamme AS gamme_3, p0_.compte AS compte_4, p0_.facturation AS facturation_5, p0_.type_taux_tva AS type_taux_tva_6, p0_.ui AS ui_7, p0_.mesure AS mesure_8, p0_.type AS type_9, p0_.fournisseur AS fournisseur_10, p0_.remiseGenerale AS remiseGenerale_11, p0_.tempsNormatif AS tempsNormatif_12, p0_.forfaitIllimite AS forfaitIllimite_13, p0_.reference AS reference_14, p0_.price_sell_ht_a AS price_sell_ht_a_15, p0_.price_ht_b AS price_ht_b_16, p0_.price_ht_c AS price_ht_c_17, p0_.price_ht_c_d AS price_ht_c_d_18, p0_.price_ht AS price_ht_19, p0_.marge AS marge_20, p0_.tva AS tva_21, p0_.type_tva AS type_tva_22, p0_.stock_quantity AS stock_quantity_23, p0_.gestion_stock AS gestion_stock_24, p0_.order_multiple AS order_multiple_25, p0_.indisponible_vente AS indisponible_vente_26, p0_.unitVente AS unitVente_27, p0_.mandatory AS mandatory_28, p0_.no_reservation AS no_reservation_29, p0_.commercial_name AS commercial_name_30, p0_.checked AS checked_31, p0_.ordering AS ordering_32, p0_.product_type AS product_type_33, p0_.famille AS famille_34, p0_.sous_famille AS sous_famille_35 FROM product p0_ WHERE p0_.type = ? AND p0_.indisponible_vente = ? AND p0_.id IN (?, ?, ?, ?)
Parameters:
[
  "coiffure"
  0
  "2"
  "8"
  "34"
  "35"
]
0.36 ms
(0.10%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.service AS service_2, s0_.status AS status_3, s0_.openingDays AS openingDays_4, s0_.date_activity_end AS date_activity_end_5, s0_.specific_billing AS specific_billing_6, s0_.date_open AS date_open_7, s0_.date_end AS date_end_8, s0_.opening_time AS opening_time_9, s0_.closing_time AS closing_time_10, s0_.address_id AS address_id_11, s0_.gridprice_id AS gridprice_id_12, s0_.site_id AS site_id_13 FROM salon s0_ WHERE s0_.id IN (?)
Parameters:
[
  "160"
]
0.32 ms
(0.09%)
1
SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.plannedAgain AS plannedAgain_2 FROM cancel_reason c0_
Parameters:
[]
0.28 ms
(0.08%)
1
SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.plannedAgain AS plannedAgain_2 FROM cancel_reason c0_ WHERE c0_.id IN (?)
Parameters:
[
  "4"
]

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\Product
  • The mappings App\Entity\Product#rdvProducts and App\Entity\RDVProduct#product are inconsistent with each other.
App\Entity\Parameter No errors.
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\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\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\Recurrence No errors.
App\Entity\PromoCode 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\WorkContract
  • The field App\Entity\WorkContract#intervenant is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Intervenant#workContract does not contain the required 'mappedBy="intervenant"' attribute.
App\Entity\Countries
  • The field App\Entity\Countries#personn1 is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Intervenant#country does not contain the required 'inversedBy="personn1"' attribute.
App\Entity\Departement No errors.
App\Entity\Address No errors.
App\Entity\Absence 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.
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\Product\ProductType
  • The field App\Entity\Product\ProductType#familles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\Famille#productType does not contain the required 'inversedBy="familles"' attribute.
App\Entity\Product\Famille
  • The field App\Entity\Product\Famille#sousFamilles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\SousFamille#famille does not contain the required 'inversedBy="sousFamilles"' attribute.
App\Entity\Product\SousFamille No errors.
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\Client\BillingInfos No errors.
App\Entity\Client\FamilyMember
  • The association App\Entity\Client\FamilyMember#address refers to the inverse side field App\Entity\Address#personn which does not exist.
App\Entity\Reglement No errors.
App\Entity\RecurrenceProduct No errors.
App\Entity\ProductService
  • The mappings App\Entity\ProductService#option and App\Entity\Product#productServices are inconsistent with each other.
App\Entity\Company 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.