Query Metrics
245
Database Queries
33
Different statements
357.33 ms
Query time
19
Invalid entities
Grouped Statements
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 |
|
App\Entity\Intervenant |
|
App\Entity\SessionSalon |
|
App\Entity\Product |
|
App\Entity\Parameter | No errors. |
App\Entity\RDV |
|
App\Entity\Contract |
|
App\Entity\CancelReason | No errors. |
App\Entity\Client |
|
App\Entity\Salon |
|
App\Entity\Recurrence | No errors. |
App\Entity\PromoCode | No errors. |
App\Entity\RDVProduct |
|
App\Entity\Billing | No errors. |
App\Entity\RDVBilling | No errors. |
App\Entity\WorkContract |
|
App\Entity\Countries |
|
App\Entity\Departement | No errors. |
App\Entity\Address | No errors. |
App\Entity\Absence | No errors. |
App\Entity\LogPlanning |
|
App\Entity\LogCancel | No errors. |
App\Entity\GridPrice | No errors. |
App\Entity\Site |
|
App\Entity\IntervenantSalon | No errors. |
App\Entity\Product\ProductType |
|
App\Entity\Product\Famille |
|
App\Entity\Product\SousFamille | No errors. |
App\Entity\Contact |
|
App\Entity\Client\BillingInfos | No errors. |
App\Entity\Client\FamilyMember |
|
App\Entity\Reglement | No errors. |
App\Entity\RecurrenceProduct | No errors. |
App\Entity\ProductService |
|
App\Entity\Company | No errors. |
App\Entity\Site\Logistique |
|