Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom_ag AS nom_ag_2,
  t0.contact_ag AS contact_ag_3,
  t0.image_ag AS image_ag_4,
  t0.token_flutter AS token_flutter_5,
  t0.contact_whatsapp AS contact_whatsapp_6,
  t0.sexe AS sexe_7,
  t0.type_client_agent AS type_client_agent_8,
  t0.contact_ag1 AS contact_ag1_9,
  t0.code AS code_10,
  t0.prefixcode AS prefixcode_11,
  t0.langue AS langue_12,
  t0.mco AS mco_13,
  t0.cargo_agent AS cargo_agent_14,
  t0.ancien AS ancien_15,
  t0.is_verifier AS is_verifier_16,
  t0.codeverification AS codeverification_17,
  t0.clientblocker AS clientblocker_18,
  t0.admin AS admin_19,
  t0.face_signature AS face_signature_20,
  t0.daily_rate AS daily_rate_21,
  t0.ville_id AS ville_id_22,
  t23.id AS id_24,
  t23.etat AS etat_25,
  t23.role AS role_26,
  t23.date_created AS date_created_27,
  t23.date_connected AS date_connected_28,
  t23.status AS status_29,
  t23.user_name AS user_name_30,
  t23.password AS password_31,
  t23.langue AS langue_32,
  t23.flag_sms AS flag_sms_33,
  t23.flag_voice_sms AS flag_voice_sms_34,
  t23.flag_voice_whatsapp AS flag_voice_whatsapp_35,
  t23.is_mco AS is_mco_36,
  t23.i_sflag_calacul AS i_sflag_calacul_37,
  t23.caisse_localite AS caisse_localite_38,
  t23.ville_id AS ville_id_39,
  t23.id_ag_id AS id_ag_id_40
FROM
  agent t0
  LEFT JOIN utilisateur t23 ON t23.id_ag_id = t0.id
WHERE
  t0.prefixcode = ?
  AND t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom_ag AS nom_ag_2, t0.contact_ag AS contact_ag_3, t0.image_ag AS image_ag_4, t0.token_flutter AS token_flutter_5, t0.contact_whatsapp AS contact_whatsapp_6, t0.sexe AS sexe_7, t0.type_client_agent AS type_client_agent_8, t0.contact_ag1 AS contact_ag1_9, t0.code AS code_10, t0.prefixcode AS prefixcode_11, t0.langue AS langue_12, t0.mco AS mco_13, t0.cargo_agent AS cargo_agent_14, t0.ancien AS ancien_15, t0.is_verifier AS is_verifier_16, t0.codeverification AS codeverification_17, t0.clientblocker AS clientblocker_18, t0.admin AS admin_19, t0.face_signature AS face_signature_20, t0.daily_rate AS daily_rate_21, t0.ville_id AS ville_id_22, t23.id AS id_24, t23.etat AS etat_25, t23.role AS role_26, t23.date_created AS date_created_27, t23.date_connected AS date_connected_28, t23.status AS status_29, t23.user_name AS user_name_30, t23.password AS password_31, t23.langue AS langue_32, t23.flag_sms AS flag_sms_33, t23.flag_voice_sms AS flag_voice_sms_34, t23.flag_voice_whatsapp AS flag_voice_whatsapp_35, t23.is_mco AS is_mco_36, t23.i_sflag_calacul AS i_sflag_calacul_37, t23.caisse_localite AS caisse_localite_38, t23.ville_id AS ville_id_39, t23.id_ag_id AS id_ag_id_40 FROM agent t0 LEFT JOIN utilisateur t23 ON t23.id_ag_id = t0.id WHERE t0.prefixcode = 'L' AND t0.code = '10310' LIMIT 1;

SELECT
  SUM(p0_.montant_paye) AS sclr_0
FROM
  paiement_reception p0_
WHERE
  p0_.tmp_reception_id = ?

SELECT SUM(p0_.montant_paye) AS sclr_0 FROM paiement_reception p0_ WHERE p0_.tmp_reception_id = 28036;

SELECT
  t0.id AS id_1,
  t0.volume AS volume_2,
  t0.tonne AS tonne_3,
  t0.isflag AS isflag_4,
  t0.unite AS unite_5,
  t0.nature AS nature_6,
  t0.classementdepot AS classementdepot_7,
  t0.quantite AS quantite_8,
  t0.flutterid AS flutterid_9,
  t0.prix_fixe AS prix_fixe_10,
  t0.reception_id AS reception_id_11,
  t0.user_id AS user_id_12,
  t0.categorie_prix_id AS categorie_prix_id_13
FROM
  tmp_reception t0
WHERE
  t0.reception_id = ?

SELECT t0.id AS id_1, t0.volume AS volume_2, t0.tonne AS tonne_3, t0.isflag AS isflag_4, t0.unite AS unite_5, t0.nature AS nature_6, t0.classementdepot AS classementdepot_7, t0.quantite AS quantite_8, t0.flutterid AS flutterid_9, t0.prix_fixe AS prix_fixe_10, t0.reception_id AS reception_id_11, t0.user_id AS user_id_12, t0.categorie_prix_id AS categorie_prix_id_13 FROM tmp_reception t0 WHERE t0.reception_id = 27789;

SELECT
  t0.id AS id_1,
  t0.recunumero AS recunumero_2,
  t0.date_operation AS date_operation_3,
  t0.trucking_number AS trucking_number_4,
  t0.supplier AS supplier_5,
  t0.destination AS destination_6,
  t0.alert AS alert_7,
  t0.type AS type_8,
  t0.is_charge AS is_charge_9,
  t0.is_calcule AS is_calcule_10,
  t0.conteneurtype AS conteneurtype_11,
  t0.image_bon AS image_bon_12,
  t0.image_colis AS image_colis_13,
  t0.fret AS fret_14,
  t0.alias AS alias_15,
  t0.numero AS numero_16,
  t0.werehouse AS werehouse_17,
  t0.fournisseur AS fournisseur_18,
  t0.flutterid AS flutterid_19,
  t0.provenance AS provenance_20,
  t0.numero_recu_store AS numero_recu_store_21,
  t0.montant_valeur AS montant_valeur_22,
  t0.charge AS charge_23,
  t0.quantite AS quantite_24,
  t0.quantite_charge AS quantite_charge_25,
  t0.client_id AS client_id_26,
  t0.user_id AS user_id_27,
  t0.ville_id AS ville_id_28,
  t0.destville_id AS destville_id_29
FROM
  reception t0
WHERE
  t0.client_id = ?
ORDER BY
  t0.date_operation DESC
LIMIT
  50

SELECT t0.id AS id_1, t0.recunumero AS recunumero_2, t0.date_operation AS date_operation_3, t0.trucking_number AS trucking_number_4, t0.supplier AS supplier_5, t0.destination AS destination_6, t0.alert AS alert_7, t0.type AS type_8, t0.is_charge AS is_charge_9, t0.is_calcule AS is_calcule_10, t0.conteneurtype AS conteneurtype_11, t0.image_bon AS image_bon_12, t0.image_colis AS image_colis_13, t0.fret AS fret_14, t0.alias AS alias_15, t0.numero AS numero_16, t0.werehouse AS werehouse_17, t0.fournisseur AS fournisseur_18, t0.flutterid AS flutterid_19, t0.provenance AS provenance_20, t0.numero_recu_store AS numero_recu_store_21, t0.montant_valeur AS montant_valeur_22, t0.charge AS charge_23, t0.quantite AS quantite_24, t0.quantite_charge AS quantite_charge_25, t0.client_id AS client_id_26, t0.user_id AS user_id_27, t0.ville_id AS ville_id_28, t0.destville_id AS destville_id_29 FROM reception t0 WHERE t0.client_id = 9009 ORDER BY t0.date_operation DESC LIMIT 50;

SELECT
  t0.id AS id_1,
  t0.nomville AS nomville_2,
  t0.adresse1 AS adresse1_3,
  t0.adresse2 AS adresse2_4,
  t0.email AS email_5,
  t0.num_tel AS num_tel_6,
  t0.addresse3 AS addresse3_7,
  t0.addresse4 AS addresse4_8,
  t0.addresse5 AS addresse5_9,
  t0.addresse6 AS addresse6_10,
  t0.flag_ville AS flag_ville_11,
  t0.logo AS logo_12,
  t0.port_bateau AS port_bateau_13,
  t0.taux_du_jour_pays AS taux_du_jour_pays_14,
  t0.is_taux AS is_taux_15,
  t0.monnaie AS monnaie_16,
  t0.tokenurl AS tokenurl_17,
  t0.token_id AS token_id_18,
  t0.basdepage AS basdepage_19,
  t0.basdepagemco AS basdepagemco_20,
  t0.cbm AS cbm_21,
  t0.tonne AS tonne_22,
  t0.kg AS kg_23,
  t0.conteneur AS conteneur_24,
  t0.kgelec AS kgelec_25,
  t0.prefixe_code AS prefixe_code_26,
  t0.estimateddate_text_air_cargo AS estimateddate_text_air_cargo_27,
  t0.estimateddate_text_sea_cargo AS estimateddate_text_sea_cargo_28
FROM
  ville t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nomville AS nomville_2, t0.adresse1 AS adresse1_3, t0.adresse2 AS adresse2_4, t0.email AS email_5, t0.num_tel AS num_tel_6, t0.addresse3 AS addresse3_7, t0.addresse4 AS addresse4_8, t0.addresse5 AS addresse5_9, t0.addresse6 AS addresse6_10, t0.flag_ville AS flag_ville_11, t0.logo AS logo_12, t0.port_bateau AS port_bateau_13, t0.taux_du_jour_pays AS taux_du_jour_pays_14, t0.is_taux AS is_taux_15, t0.monnaie AS monnaie_16, t0.tokenurl AS tokenurl_17, t0.token_id AS token_id_18, t0.basdepage AS basdepage_19, t0.basdepagemco AS basdepagemco_20, t0.cbm AS cbm_21, t0.tonne AS tonne_22, t0.kg AS kg_23, t0.conteneur AS conteneur_24, t0.kgelec AS kgelec_25, t0.prefixe_code AS prefixe_code_26, t0.estimateddate_text_air_cargo AS estimateddate_text_air_cargo_27, t0.estimateddate_text_sea_cargo AS estimateddate_text_sea_cargo_28 FROM ville t0 WHERE t0.id = 4;