Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.created_at AS created_at_6,
  t0.nom_prenom AS nom_prenom_7,
  t0.ebp_client_code AS ebp_client_code_8,
  t0.is_enabled AS is_enabled_9,
  t0.last_activity_at AS last_activity_at_10,
  t0.last_visite_at AS last_visite_at_11,
  t0.last_update_at AS last_update_at_12,
  t0.last_login_at AS last_login_at_13,
  t0.utilisateur_role_id AS utilisateur_role_id_14,
  t0.region_id AS region_id_15
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.nom_prenom AS nom_prenom_7, t0.ebp_client_code AS ebp_client_code_8, t0.is_enabled AS is_enabled_9, t0.last_activity_at AS last_activity_at_10, t0.last_visite_at AS last_visite_at_11, t0.last_update_at AS last_update_at_12, t0.last_login_at AS last_login_at_13, t0.utilisateur_role_id AS utilisateur_role_id_14, t0.region_id AS region_id_15 FROM utilisateur t0 WHERE t0.id = 19;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  paiement_reliquat p0_
  INNER JOIN paiement p1_ ON p0_.paiement_id = p1_.id
  INNER JOIN animatrice_numero a2_ ON p1_.animatrice_numero_id = a2_.id
  INNER JOIN animatrice a3_ ON a2_.animatrice_id = a3_.id
  LEFT JOIN utilisateur u4_ ON a3_.coach_id = u4_.id
  LEFT JOIN product p5_ ON a2_.product_id = p5_.id
  LEFT JOIN utilisateur u6_ ON p1_.coach_id = u6_.id
  LEFT JOIN utilisateur u7_ ON p0_.last_regularised_by_id = u7_.id
WHERE
  p0_.status = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM paiement_reliquat p0_ INNER JOIN paiement p1_ ON p0_.paiement_id = p1_.id INNER JOIN animatrice_numero a2_ ON p1_.animatrice_numero_id = a2_.id INNER JOIN animatrice a3_ ON a2_.animatrice_id = a3_.id LEFT JOIN utilisateur u4_ ON a3_.coach_id = u4_.id LEFT JOIN product p5_ ON a2_.product_id = p5_.id LEFT JOIN utilisateur u6_ ON p1_.coach_id = u6_.id LEFT JOIN utilisateur u7_ ON p0_.last_regularised_by_id = u7_.id WHERE p0_.status = 'OPEN';

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.created_at AS created_at_2,
  p0_.quantite_demandee AS quantite_demandee_3,
  p0_.quantite_servie AS quantite_servie_4,
  p0_.quantite_impayee AS quantite_impayee_5,
  p0_.unit_price AS unit_price_6,
  p0_.stock_policy_used AS stock_policy_used_7,
  p0_.status AS status_8,
  p0_.regularised_at AS regularised_at_9,
  p0_.last_regularisation_at AS last_regularisation_at_10,
  p1_.id AS id_11,
  p1_.code AS code_12,
  p1_.created_at AS created_at_13,
  p1_.paiement_at AS paiement_at_14,
  p1_.total_amount AS total_amount_15,
  p1_.paiement_ref AS paiement_ref_16,
  p1_.method_name AS method_name_17,
  p1_.stock_processing_status AS stock_processing_status_18,
  p1_.stock_processing_reason AS stock_processing_reason_19,
  a2_.id AS id_20,
  a2_.code AS code_21,
  a2_.created_at AS created_at_22,
  a2_.updated_at AS updated_at_23,
  a2_.numero AS numero_24,
  a2_.is_enabled AS is_enabled_25,
  a2_.last_sync_at AS last_sync_at_26,
  a3_.id AS id_27,
  a3_.code AS code_28,
  a3_.nom_prenom AS nom_prenom_29,
  a3_.created_at AS created_at_30,
  a3_.code_collaborateur AS code_collaborateur_31,
  a3_.last_updated_at AS last_updated_at_32,
  a3_.adresse AS adresse_33,
  a3_.phone_number AS phone_number_34,
  a3_.total_vente AS total_vente_35,
  a3_.valeur_stock AS valeur_stock_36,
  a3_.total_paiement_restant AS total_paiement_restant_37,
  a3_.is_soazaza AS is_soazaza_38,
  a3_.soazaza_started_at AS soazaza_started_at_39,
  a3_.soazaza_funnel_status AS soazaza_funnel_status_40,
  a3_.soazaza_recommended_decision AS soazaza_recommended_decision_41,
  a3_.soazaza_stagnation_alert AS soazaza_stagnation_alert_42,
  a3_.soazaza_funnel_months AS soazaza_funnel_months_43,
  a3_.soazaza_funnel_evaluated_at AS soazaza_funnel_evaluated_at_44,
  a3_.is_risque AS is_risque_45,
  a3_.is_eligible_relegation AS is_eligible_relegation_46,
  a3_.risque_level AS risque_level_47,
  a3_.risque_reasons AS risque_reasons_48,
  a3_.risque_evaluated_at AS risque_evaluated_at_49,
  a3_.objectif_unites_mois AS objectif_unites_mois_50,
  a3_.projection_unites_fin_mois AS projection_unites_fin_mois_51,
  a3_.trajectoire_status AS trajectoire_status_52,
  a3_.alerte_projection AS alerte_projection_53,
  a3_.objectif_evaluated_at AS objectif_evaluated_at_54,
  a3_.objectif_ventes_mois AS objectif_ventes_mois_55,
  a3_.projection_ventes_fin_mois AS projection_ventes_fin_mois_56,
  a3_.trajectoire_status_ventes AS trajectoire_status_ventes_57,
  a3_.paiements_projetes_fin_mois AS paiements_projetes_fin_mois_58,
  a3_.exposition_cash_projetee AS exposition_cash_projetee_59,
  a3_.last_visite_at AS last_visite_at_60,
  a3_.is_enabled AS is_enabled_61,
  u4_.id AS id_62,
  u4_.code AS code_63,
  u4_.username AS username_64,
  u4_.roles AS roles_65,
  u4_.password AS password_66,
  u4_.created_at AS created_at_67,
  u4_.nom_prenom AS nom_prenom_68,
  u4_.ebp_client_code AS ebp_client_code_69,
  u4_.is_enabled AS is_enabled_70,
  u4_.last_activity_at AS last_activity_at_71,
  u4_.last_visite_at AS last_visite_at_72,
  u4_.last_update_at AS last_update_at_73,
  u4_.last_login_at AS last_login_at_74,
  p5_.id AS id_75,
  p5_.code AS code_76,
  p5_.numero AS numero_77,
  p5_.designation AS designation_78,
  p5_.unit AS unit_79,
  p5_.price AS price_80,
  p5_.filename AS filename_81,
  p5_.color AS color_82,
  p5_.survente AS survente_83,
  p5_.is_enabled AS is_enabled_84,
  p5_.last_update_at AS last_update_at_85,
  p5_.multiplier AS multiplier_86,
  u6_.id AS id_87,
  u6_.code AS code_88,
  u6_.username AS username_89,
  u6_.roles AS roles_90,
  u6_.password AS password_91,
  u6_.created_at AS created_at_92,
  u6_.nom_prenom AS nom_prenom_93,
  u6_.ebp_client_code AS ebp_client_code_94,
  u6_.is_enabled AS is_enabled_95,
  u6_.last_activity_at AS last_activity_at_96,
  u6_.last_visite_at AS last_visite_at_97,
  u6_.last_update_at AS last_update_at_98,
  u6_.last_login_at AS last_login_at_99,
  u7_.id AS id_100,
  u7_.code AS code_101,
  u7_.username AS username_102,
  u7_.roles AS roles_103,
  u7_.password AS password_104,
  u7_.created_at AS created_at_105,
  u7_.nom_prenom AS nom_prenom_106,
  u7_.ebp_client_code AS ebp_client_code_107,
  u7_.is_enabled AS is_enabled_108,
  u7_.last_activity_at AS last_activity_at_109,
  u7_.last_visite_at AS last_visite_at_110,
  u7_.last_update_at AS last_update_at_111,
  u7_.last_login_at AS last_login_at_112,
  p0_.paiement_id AS paiement_id_113,
  p0_.last_regularised_by_id AS last_regularised_by_id_114,
  p1_.animatrice_numero_id AS animatrice_numero_id_115,
  p1_.coach_id AS coach_id_116,
  a2_.animatrice_id AS animatrice_id_117,
  a2_.created_by_id AS created_by_id_118,
  a2_.product_id AS product_id_119,
  a3_.region_id AS region_id_120,
  a3_.coach_id AS coach_id_121,
  u4_.utilisateur_role_id AS utilisateur_role_id_122,
  u4_.region_id AS region_id_123,
  u6_.utilisateur_role_id AS utilisateur_role_id_124,
  u6_.region_id AS region_id_125,
  u7_.utilisateur_role_id AS utilisateur_role_id_126,
  u7_.region_id AS region_id_127
FROM
  paiement_reliquat p0_
  INNER JOIN paiement p1_ ON p0_.paiement_id = p1_.id
  INNER JOIN animatrice_numero a2_ ON p1_.animatrice_numero_id = a2_.id
  INNER JOIN animatrice a3_ ON a2_.animatrice_id = a3_.id
  LEFT JOIN utilisateur u4_ ON a3_.coach_id = u4_.id
  LEFT JOIN product p5_ ON a2_.product_id = p5_.id
  LEFT JOIN utilisateur u6_ ON p1_.coach_id = u6_.id
  LEFT JOIN utilisateur u7_ ON p0_.last_regularised_by_id = u7_.id
WHERE
  p0_.status = ?
ORDER BY
  p0_.id ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.created_at AS created_at_2, p0_.quantite_demandee AS quantite_demandee_3, p0_.quantite_servie AS quantite_servie_4, p0_.quantite_impayee AS quantite_impayee_5, p0_.unit_price AS unit_price_6, p0_.stock_policy_used AS stock_policy_used_7, p0_.status AS status_8, p0_.regularised_at AS regularised_at_9, p0_.last_regularisation_at AS last_regularisation_at_10, p1_.id AS id_11, p1_.code AS code_12, p1_.created_at AS created_at_13, p1_.paiement_at AS paiement_at_14, p1_.total_amount AS total_amount_15, p1_.paiement_ref AS paiement_ref_16, p1_.method_name AS method_name_17, p1_.stock_processing_status AS stock_processing_status_18, p1_.stock_processing_reason AS stock_processing_reason_19, a2_.id AS id_20, a2_.code AS code_21, a2_.created_at AS created_at_22, a2_.updated_at AS updated_at_23, a2_.numero AS numero_24, a2_.is_enabled AS is_enabled_25, a2_.last_sync_at AS last_sync_at_26, a3_.id AS id_27, a3_.code AS code_28, a3_.nom_prenom AS nom_prenom_29, a3_.created_at AS created_at_30, a3_.code_collaborateur AS code_collaborateur_31, a3_.last_updated_at AS last_updated_at_32, a3_.adresse AS adresse_33, a3_.phone_number AS phone_number_34, a3_.total_vente AS total_vente_35, a3_.valeur_stock AS valeur_stock_36, a3_.total_paiement_restant AS total_paiement_restant_37, a3_.is_soazaza AS is_soazaza_38, a3_.soazaza_started_at AS soazaza_started_at_39, a3_.soazaza_funnel_status AS soazaza_funnel_status_40, a3_.soazaza_recommended_decision AS soazaza_recommended_decision_41, a3_.soazaza_stagnation_alert AS soazaza_stagnation_alert_42, a3_.soazaza_funnel_months AS soazaza_funnel_months_43, a3_.soazaza_funnel_evaluated_at AS soazaza_funnel_evaluated_at_44, a3_.is_risque AS is_risque_45, a3_.is_eligible_relegation AS is_eligible_relegation_46, a3_.risque_level AS risque_level_47, a3_.risque_reasons AS risque_reasons_48, a3_.risque_evaluated_at AS risque_evaluated_at_49, a3_.objectif_unites_mois AS objectif_unites_mois_50, a3_.projection_unites_fin_mois AS projection_unites_fin_mois_51, a3_.trajectoire_status AS trajectoire_status_52, a3_.alerte_projection AS alerte_projection_53, a3_.objectif_evaluated_at AS objectif_evaluated_at_54, a3_.objectif_ventes_mois AS objectif_ventes_mois_55, a3_.projection_ventes_fin_mois AS projection_ventes_fin_mois_56, a3_.trajectoire_status_ventes AS trajectoire_status_ventes_57, a3_.paiements_projetes_fin_mois AS paiements_projetes_fin_mois_58, a3_.exposition_cash_projetee AS exposition_cash_projetee_59, a3_.last_visite_at AS last_visite_at_60, a3_.is_enabled AS is_enabled_61, u4_.id AS id_62, u4_.code AS code_63, u4_.username AS username_64, u4_.roles AS roles_65, u4_.password AS password_66, u4_.created_at AS created_at_67, u4_.nom_prenom AS nom_prenom_68, u4_.ebp_client_code AS ebp_client_code_69, u4_.is_enabled AS is_enabled_70, u4_.last_activity_at AS last_activity_at_71, u4_.last_visite_at AS last_visite_at_72, u4_.last_update_at AS last_update_at_73, u4_.last_login_at AS last_login_at_74, p5_.id AS id_75, p5_.code AS code_76, p5_.numero AS numero_77, p5_.designation AS designation_78, p5_.unit AS unit_79, p5_.price AS price_80, p5_.filename AS filename_81, p5_.color AS color_82, p5_.survente AS survente_83, p5_.is_enabled AS is_enabled_84, p5_.last_update_at AS last_update_at_85, p5_.multiplier AS multiplier_86, u6_.id AS id_87, u6_.code AS code_88, u6_.username AS username_89, u6_.roles AS roles_90, u6_.password AS password_91, u6_.created_at AS created_at_92, u6_.nom_prenom AS nom_prenom_93, u6_.ebp_client_code AS ebp_client_code_94, u6_.is_enabled AS is_enabled_95, u6_.last_activity_at AS last_activity_at_96, u6_.last_visite_at AS last_visite_at_97, u6_.last_update_at AS last_update_at_98, u6_.last_login_at AS last_login_at_99, u7_.id AS id_100, u7_.code AS code_101, u7_.username AS username_102, u7_.roles AS roles_103, u7_.password AS password_104, u7_.created_at AS created_at_105, u7_.nom_prenom AS nom_prenom_106, u7_.ebp_client_code AS ebp_client_code_107, u7_.is_enabled AS is_enabled_108, u7_.last_activity_at AS last_activity_at_109, u7_.last_visite_at AS last_visite_at_110, u7_.last_update_at AS last_update_at_111, u7_.last_login_at AS last_login_at_112, p0_.paiement_id AS paiement_id_113, p0_.last_regularised_by_id AS last_regularised_by_id_114, p1_.animatrice_numero_id AS animatrice_numero_id_115, p1_.coach_id AS coach_id_116, a2_.animatrice_id AS animatrice_id_117, a2_.created_by_id AS created_by_id_118, a2_.product_id AS product_id_119, a3_.region_id AS region_id_120, a3_.coach_id AS coach_id_121, u4_.utilisateur_role_id AS utilisateur_role_id_122, u4_.region_id AS region_id_123, u6_.utilisateur_role_id AS utilisateur_role_id_124, u6_.region_id AS region_id_125, u7_.utilisateur_role_id AS utilisateur_role_id_126, u7_.region_id AS region_id_127 FROM paiement_reliquat p0_ INNER JOIN paiement p1_ ON p0_.paiement_id = p1_.id INNER JOIN animatrice_numero a2_ ON p1_.animatrice_numero_id = a2_.id INNER JOIN animatrice a3_ ON a2_.animatrice_id = a3_.id LEFT JOIN utilisateur u4_ ON a3_.coach_id = u4_.id LEFT JOIN product p5_ ON a2_.product_id = p5_.id LEFT JOIN utilisateur u6_ ON p1_.coach_id = u6_.id LEFT JOIN utilisateur u7_ ON p0_.last_regularised_by_id = u7_.id WHERE p0_.status = 'OPEN' ORDER BY p0_.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.created_at AS created_at_3,
  t0.total_value AS total_value_4,
  t0.quantite_estimee AS quantite_estimee_5,
  t0.quantite_calculee_raw AS quantite_calculee_raw_6,
  t0.quantite_rounding_mode AS quantite_rounding_mode_7,
  t0.quantite_rounding_precision AS quantite_rounding_precision_8,
  t0.vente_at AS vente_at_9,
  t0.animatrice_numero_id AS animatrice_numero_id_10,
  t0.paiement_id AS paiement_id_11
FROM
  vente t0
WHERE
  t0.paiement_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.total_value AS total_value_4, t0.quantite_estimee AS quantite_estimee_5, t0.quantite_calculee_raw AS quantite_calculee_raw_6, t0.quantite_rounding_mode AS quantite_rounding_mode_7, t0.quantite_rounding_precision AS quantite_rounding_precision_8, t0.vente_at AS vente_at_9, t0.animatrice_numero_id AS animatrice_numero_id_10, t0.paiement_id AS paiement_id_11 FROM vente t0 WHERE t0.paiement_id = 2718;