Symfony Profiler

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'emmaconnect'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  c.COLUMN_NAME AS field,
  c.COLUMN_TYPE AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE        AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'emmaconnect' AND t.TABLE_SCHEMA = 'emmaconnect' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'emmaconnect' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'emmaconnect' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'emmaconnect' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'emmaconnect' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

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_.indisponible_vente = ?
  AND p0_.id IN (?)

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_.indisponible_vente = 0 AND p0_.id IN ('72');

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 s0_.start >= ?
  AND s0_.start <= ?

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 = 14 AND s0_.start >= '2024-11-23' AND s0_.start <= '2024-11-23 18:00';

SELECT
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  SEQ_IN_INDEX

SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'emmaconnect' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

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 = ?

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 = 11;

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 (?)

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 <> 'Inactif' AND c0_.status_prospect <> 'Parti') OR c0_.status_prospect IS NULL) AND c0_.id IN ('20210');

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 = ?

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 = 1003;

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_.indisponible_vente = ?
  AND p0_.id IN (?, ?)

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_.indisponible_vente = 0 AND p0_.id IN ('72', '74');

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 (?)

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 ('14');

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;