Symfony Profiler

[
  "route" => "_api_/admin/paiement-reliquats_get_collection"
  "route_parameters" => [
    "_route" => "_api_/admin/paiement-reliquats_get_collection"
    "_controller" => "api_platform.symfony.main_controller"
    "_stateless" => false
    "_api_resource_class" => "App\Entity\PaiementReliquat"
    "_api_operation_name" => "_api_/admin/paiement-reliquats_get_collection"
    "_format" => null
  ]
  "request_uri" => "https://nutrizaza.com/api/admin/paiement-reliquats?itemsPerPage=1&page=1&status=OPEN"
  "method" => "GET"
]

[
  "firewall_name" => "admin_data"
  "authenticators" => 0
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "ua6fa9.myd.infomaniak.com"
    "port" => null
    "user" => "ua6fa9_anim"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ua6fa9_anim"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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.is_enabled AS is_enabled_8, t0.last_activity_at AS last_activity_at_9, t0.last_visite_at AS last_visite_at_10, t0.last_update_at AS last_update_at_11, t0.last_login_at AS last_login_at_12, t0.utilisateur_role_id AS utilisateur_role_id_13, t0.region_id AS region_id_14 FROM utilisateur t0 WHERE t0.id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1092
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "ast.soc@nutrizaza.mg"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "OPEN"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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_.risque_level AS risque_level_46, a3_.risque_reasons AS risque_reasons_47, a3_.risque_evaluated_at AS risque_evaluated_at_48, a3_.last_visite_at AS last_visite_at_49, a3_.is_enabled AS is_enabled_50, u4_.id AS id_51, u4_.code AS code_52, u4_.username AS username_53, u4_.roles AS roles_54, u4_.password AS password_55, u4_.created_at AS created_at_56, u4_.nom_prenom AS nom_prenom_57, u4_.is_enabled AS is_enabled_58, u4_.last_activity_at AS last_activity_at_59, u4_.last_visite_at AS last_visite_at_60, u4_.last_update_at AS last_update_at_61, u4_.last_login_at AS last_login_at_62, p5_.id AS id_63, p5_.code AS code_64, p5_.numero AS numero_65, p5_.designation AS designation_66, p5_.unit AS unit_67, p5_.price AS price_68, p5_.filename AS filename_69, p5_.color AS color_70, p5_.survente AS survente_71, p5_.is_enabled AS is_enabled_72, p5_.last_update_at AS last_update_at_73, p5_.multiplier AS multiplier_74, u6_.id AS id_75, u6_.code AS code_76, u6_.username AS username_77, u6_.roles AS roles_78, u6_.password AS password_79, u6_.created_at AS created_at_80, u6_.nom_prenom AS nom_prenom_81, u6_.is_enabled AS is_enabled_82, u6_.last_activity_at AS last_activity_at_83, u6_.last_visite_at AS last_visite_at_84, u6_.last_update_at AS last_update_at_85, u6_.last_login_at AS last_login_at_86, u7_.id AS id_87, u7_.code AS code_88, u7_.username AS username_89, u7_.roles AS roles_90, u7_.password AS password_91, u7_.created_at AS created_at_92, u7_.nom_prenom AS nom_prenom_93, u7_.is_enabled AS is_enabled_94, u7_.last_activity_at AS last_activity_at_95, u7_.last_visite_at AS last_visite_at_96, u7_.last_update_at AS last_update_at_97, u7_.last_login_at AS last_login_at_98, p0_.paiement_id AS paiement_id_99, p0_.last_regularised_by_id AS last_regularised_by_id_100, p1_.animatrice_numero_id AS animatrice_numero_id_101, p1_.coach_id AS coach_id_102, a2_.animatrice_id AS animatrice_id_103, a2_.created_by_id AS created_by_id_104, a2_.product_id AS product_id_105, a3_.region_id AS region_id_106, a3_.coach_id AS coach_id_107, u4_.utilisateur_role_id AS utilisateur_role_id_108, u4_.region_id AS region_id_109, u6_.utilisateur_role_id AS utilisateur_role_id_110, u6_.region_id AS region_id_111, u7_.utilisateur_role_id AS utilisateur_role_id_112, u7_.region_id AS region_id_113 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"
  "params" => [
    1 => "OPEN"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 2284
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1092
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]