Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.designation AS designation_4,
  u0_.phone AS phone_5,
  u0_.phonetwo AS phonetwo_6,
  u0_.phonethree AS phonethree_7,
  u0_.ordre AS ordre_8,
  u0_.is_active AS is_active_9,
  u0_.firstname AS firstname_10,
  u0_.lastname AS lastname_11,
  u0_.is_acceptcgv AS is_acceptcgv_12,
  u0_.address AS address_13,
  u0_.pays AS pays_14,
  u0_.urlexcelcmd AS urlexcelcmd_15,
  u0_.is_paid AS is_paid_16,
  u0_.image AS image_17,
  u0_.updated_at AS updated_at_18,
  u0_.verification_code AS verification_code_19,
  u0_.verified AS verified_20,
  u0_.latitude AS latitude_21,
  u0_.logitude AS logitude_22,
  u0_.cguaccepted AS cguaccepted_23,
  u0_.is_admin AS is_admin_24,
  u0_.cin AS cin_25,
  u0_.reinitmdp AS reinitmdp_26,
  u0_.validate_code AS validate_code_27,
  u0_.expiredreinitmdp AS expiredreinitmdp_28,
  u0_.reference_client_tp AS reference_client_tp_29,
  u0_.societename AS societename_30,
  u0_.datenaissance AS datenaissance_31,
  u0_.fcm_token AS fcm_token_32,
  u0_.rangphoto AS rangphoto_33,
  u0_.service_sopharmad AS service_sopharmad_34,
  u0_.is_remise_auto AS is_remise_auto_35,
  u0_.sexe AS sexe_36,
  u0_.deleted_at AS deleted_at_37,
  u0_.speciality_id AS speciality_id_38,
  u0_.ville_id AS ville_id_39,
  u0_.quartier_id AS quartier_id_40,
  u0_.grossiste_id AS grossiste_id_41,
  u0_.payslocalisation_id AS payslocalisation_id_42,
  u0_.ictus_pharmacie_id AS ictus_pharmacie_id_43,
  u0_.societe_livraison_id AS societe_livraison_id_44,
  u0_.last_type_livraison_id AS last_type_livraison_id_45,
  u0_.last_type_paiement_id AS last_type_paiement_id_46
FROM
  user u0_
WHERE
  (
    u0_.roles = ?
    AND u0_.verified = 1
  )
  AND (
    u0_.deleted_at IS NULL
    OR u0_.deleted_at >= CURRENT_TIMESTAMP
  )
ORDER BY
  u0_.id ASC
LIMIT
  2

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.designation AS designation_4, u0_.phone AS phone_5, u0_.phonetwo AS phonetwo_6, u0_.phonethree AS phonethree_7, u0_.ordre AS ordre_8, u0_.is_active AS is_active_9, u0_.firstname AS firstname_10, u0_.lastname AS lastname_11, u0_.is_acceptcgv AS is_acceptcgv_12, u0_.address AS address_13, u0_.pays AS pays_14, u0_.urlexcelcmd AS urlexcelcmd_15, u0_.is_paid AS is_paid_16, u0_.image AS image_17, u0_.updated_at AS updated_at_18, u0_.verification_code AS verification_code_19, u0_.verified AS verified_20, u0_.latitude AS latitude_21, u0_.logitude AS logitude_22, u0_.cguaccepted AS cguaccepted_23, u0_.is_admin AS is_admin_24, u0_.cin AS cin_25, u0_.reinitmdp AS reinitmdp_26, u0_.validate_code AS validate_code_27, u0_.expiredreinitmdp AS expiredreinitmdp_28, u0_.reference_client_tp AS reference_client_tp_29, u0_.societename AS societename_30, u0_.datenaissance AS datenaissance_31, u0_.fcm_token AS fcm_token_32, u0_.rangphoto AS rangphoto_33, u0_.service_sopharmad AS service_sopharmad_34, u0_.is_remise_auto AS is_remise_auto_35, u0_.sexe AS sexe_36, u0_.deleted_at AS deleted_at_37, u0_.speciality_id AS speciality_id_38, u0_.ville_id AS ville_id_39, u0_.quartier_id AS quartier_id_40, u0_.grossiste_id AS grossiste_id_41, u0_.payslocalisation_id AS payslocalisation_id_42, u0_.ictus_pharmacie_id AS ictus_pharmacie_id_43, u0_.societe_livraison_id AS societe_livraison_id_44, u0_.last_type_livraison_id AS last_type_livraison_id_45, u0_.last_type_paiement_id AS last_type_paiement_id_46 FROM user u0_ WHERE (u0_.roles = '[\"ROLE_GROSSISTE\"]' AND u0_.verified = 1) AND (u0_.deleted_at IS NULL OR u0_.deleted_at >= CURRENT_TIMESTAMP) ORDER BY u0_.id ASC LIMIT 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.codepays AS codepays_3,
  t0.currency AS currency_4,
  t0.coursechange AS coursechange_5,
  t0.updated_at AS updated_at_6,
  t0.tva AS tva_7
FROM
  pays t0
WHERE
  t0.codepays = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.codepays AS codepays_3, t0.currency AS currency_4, t0.coursechange AS coursechange_5, t0.updated_at AS updated_at_6, t0.tva AS tva_7 FROM pays t0 WHERE t0.codepays = 'MG' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.nom AS nom_1,
  t0_.name_en AS name_en_2
FROM
  typepaiement t0_

SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.name_en AS name_en_2 FROM typepaiement t0_;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.codepays AS codepays_2,
  p0_.currency AS currency_3,
  p0_.coursechange AS coursechange_4,
  p0_.updated_at AS updated_at_5,
  p0_.tva AS tva_6
FROM
  pays p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.codepays AS codepays_2, p0_.currency AS currency_3, p0_.coursechange AS coursechange_4, p0_.updated_at AS updated_at_5, p0_.tva AS tva_6 FROM pays p0_;