Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.recunumero AS recunumero_1,
  r0_.date_operation AS date_operation_2,
  r0_.trucking_number AS trucking_number_3,
  r0_.supplier AS supplier_4,
  r0_.destination AS destination_5,
  r0_.alert AS alert_6,
  r0_.type AS type_7,
  r0_.is_charge AS is_charge_8,
  r0_.is_calcule AS is_calcule_9,
  r0_.conteneurtype AS conteneurtype_10,
  r0_.image_bon AS image_bon_11,
  r0_.image_colis AS image_colis_12,
  r0_.fret AS fret_13,
  r0_.alias AS alias_14,
  r0_.numero AS numero_15,
  r0_.werehouse AS werehouse_16,
  r0_.fournisseur AS fournisseur_17,
  r0_.flutterid AS flutterid_18,
  r0_.provenance AS provenance_19,
  r0_.numero_recu_store AS numero_recu_store_20,
  r0_.montant_valeur AS montant_valeur_21,
  r0_.charge AS charge_22,
  r0_.quantite AS quantite_23,
  r0_.quantite_charge AS quantite_charge_24,
  r0_.client_id AS client_id_25,
  r0_.user_id AS user_id_26,
  r0_.ville_id AS ville_id_27,
  r0_.destville_id AS destville_id_28
FROM
  reception r0_
  LEFT JOIN tmp_reception t1_ ON r0_.id = t1_.reception_id
  LEFT JOIN tmp_conteneur_reception t2_ ON t1_.id = t2_.tmp_reception_id
  LEFT JOIN agent a3_ ON r0_.client_id = a3_.id
WHERE
  a3_.code = ?
  AND a3_.prefixcode = ?
GROUP BY
  t2_.programme_id

SELECT r0_.id AS id_0, r0_.recunumero AS recunumero_1, r0_.date_operation AS date_operation_2, r0_.trucking_number AS trucking_number_3, r0_.supplier AS supplier_4, r0_.destination AS destination_5, r0_.alert AS alert_6, r0_.type AS type_7, r0_.is_charge AS is_charge_8, r0_.is_calcule AS is_calcule_9, r0_.conteneurtype AS conteneurtype_10, r0_.image_bon AS image_bon_11, r0_.image_colis AS image_colis_12, r0_.fret AS fret_13, r0_.alias AS alias_14, r0_.numero AS numero_15, r0_.werehouse AS werehouse_16, r0_.fournisseur AS fournisseur_17, r0_.flutterid AS flutterid_18, r0_.provenance AS provenance_19, r0_.numero_recu_store AS numero_recu_store_20, r0_.montant_valeur AS montant_valeur_21, r0_.charge AS charge_22, r0_.quantite AS quantite_23, r0_.quantite_charge AS quantite_charge_24, r0_.client_id AS client_id_25, r0_.user_id AS user_id_26, r0_.ville_id AS ville_id_27, r0_.destville_id AS destville_id_28 FROM reception r0_ LEFT JOIN tmp_reception t1_ ON r0_.id = t1_.reception_id LEFT JOIN tmp_conteneur_reception t2_ ON t1_.id = t2_.tmp_reception_id LEFT JOIN agent a3_ ON r0_.client_id = a3_.id WHERE a3_.code = '13077' AND a3_.prefixcode = 'l' GROUP BY t2_.programme_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.reception_id AS reception_id_10,
  t0.user_id AS user_id_11
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.reception_id AS reception_id_10, t0.user_id AS user_id_11 FROM tmp_reception t0 WHERE t0.reception_id = 11951;

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
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 FROM ville t0 WHERE t0.id = 4;

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

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.id = 11779;

SELECT
  t0.id AS id_1,
  t0.isflag AS isflag_2,
  t0.quantite AS quantite_3,
  t0.destination_air_cargo AS destination_air_cargo_4,
  t0.pkg AS pkg_5,
  t0.programme_id AS programme_id_6,
  t0.user_id AS user_id_7,
  t0.tmp_reception_id AS tmp_reception_id_8
FROM
  tmp_conteneur_reception t0
WHERE
  t0.tmp_reception_id = ?

SELECT t0.id AS id_1, t0.isflag AS isflag_2, t0.quantite AS quantite_3, t0.destination_air_cargo AS destination_air_cargo_4, t0.pkg AS pkg_5, t0.programme_id AS programme_id_6, t0.user_id AS user_id_7, t0.tmp_reception_id AS tmp_reception_id_8 FROM tmp_conteneur_reception t0 WHERE t0.tmp_reception_id = 12132;

SELECT
  t0.id AS id_1,
  t0.date_chargement AS date_chargement_2,
  t0.date_depart AS date_depart_3,
  t0.date_arriver AS date_arriver_4,
  t0.date_operation AS date_operation_5,
  t0.nom_bateau AS nom_bateau_6,
  t0.id_ag AS id_ag_7,
  t0.flag AS flag_8,
  t0.numero_contenaire AS numero_contenaire_9,
  t0.transporteur AS transporteur_10,
  t0.complet_flag AS complet_flag_11,
  t0.proprietaire_conteneur AS proprietaire_conteneur_12,
  t0.destination AS destination_13,
  t0.validation AS validation_14,
  t0.depenses_prevue AS depenses_prevue_15,
  t0.remarque_conteneur AS remarque_conteneur_16,
  t0.is_mco AS is_mco_17,
  t0.is_rapport AS is_rapport_18,
  t0.date_rapport_at AS date_rapport_at_19,
  t0.is_clients AS is_clients_20,
  t0.rapport AS rapport_21,
  t0.id_ct_id AS id_ct_id_22,
  t0.id_ville_id AS id_ville_id_23,
  t0.ville_initiale_id AS ville_initiale_id_24
FROM
  programme_contenaire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_chargement AS date_chargement_2, t0.date_depart AS date_depart_3, t0.date_arriver AS date_arriver_4, t0.date_operation AS date_operation_5, t0.nom_bateau AS nom_bateau_6, t0.id_ag AS id_ag_7, t0.flag AS flag_8, t0.numero_contenaire AS numero_contenaire_9, t0.transporteur AS transporteur_10, t0.complet_flag AS complet_flag_11, t0.proprietaire_conteneur AS proprietaire_conteneur_12, t0.destination AS destination_13, t0.validation AS validation_14, t0.depenses_prevue AS depenses_prevue_15, t0.remarque_conteneur AS remarque_conteneur_16, t0.is_mco AS is_mco_17, t0.is_rapport AS is_rapport_18, t0.date_rapport_at AS date_rapport_at_19, t0.is_clients AS is_clients_20, t0.rapport AS rapport_21, t0.id_ct_id AS id_ct_id_22, t0.id_ville_id AS id_ville_id_23, t0.ville_initiale_id AS ville_initiale_id_24 FROM programme_contenaire t0 WHERE t0.id = 4732;

SELECT
  t0.id AS id_1,
  t0.lieu AS lieu_2,
  t0.id_position AS id_position_3,
  t0.date_operation AS date_operation_4,
  t0.position_actuelle_flag AS position_actuelle_flag_5,
  t0.id_ct_pr_id AS id_ct_pr_id_6
FROM
  suivi_contenaire t0
WHERE
  t0.id_ct_pr_id = ?

SELECT t0.id AS id_1, t0.lieu AS lieu_2, t0.id_position AS id_position_3, t0.date_operation AS date_operation_4, t0.position_actuelle_flag AS position_actuelle_flag_5, t0.id_ct_pr_id AS id_ct_pr_id_6 FROM suivi_contenaire t0 WHERE t0.id_ct_pr_id = 4732;

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.reception_id AS reception_id_10,
  t0.user_id AS user_id_11
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.reception_id AS reception_id_10, t0.user_id AS user_id_11 FROM tmp_reception t0 WHERE t0.reception_id = 9806;

SELECT
  t0.id AS id_1,
  t0.isflag AS isflag_2,
  t0.quantite AS quantite_3,
  t0.destination_air_cargo AS destination_air_cargo_4,
  t0.pkg AS pkg_5,
  t0.programme_id AS programme_id_6,
  t0.user_id AS user_id_7,
  t0.tmp_reception_id AS tmp_reception_id_8
FROM
  tmp_conteneur_reception t0
WHERE
  t0.tmp_reception_id = ?

SELECT t0.id AS id_1, t0.isflag AS isflag_2, t0.quantite AS quantite_3, t0.destination_air_cargo AS destination_air_cargo_4, t0.pkg AS pkg_5, t0.programme_id AS programme_id_6, t0.user_id AS user_id_7, t0.tmp_reception_id AS tmp_reception_id_8 FROM tmp_conteneur_reception t0 WHERE t0.tmp_reception_id = 9857;

SELECT
  t0.id AS id_1,
  t0.date_chargement AS date_chargement_2,
  t0.date_depart AS date_depart_3,
  t0.date_arriver AS date_arriver_4,
  t0.date_operation AS date_operation_5,
  t0.nom_bateau AS nom_bateau_6,
  t0.id_ag AS id_ag_7,
  t0.flag AS flag_8,
  t0.numero_contenaire AS numero_contenaire_9,
  t0.transporteur AS transporteur_10,
  t0.complet_flag AS complet_flag_11,
  t0.proprietaire_conteneur AS proprietaire_conteneur_12,
  t0.destination AS destination_13,
  t0.validation AS validation_14,
  t0.depenses_prevue AS depenses_prevue_15,
  t0.remarque_conteneur AS remarque_conteneur_16,
  t0.is_mco AS is_mco_17,
  t0.is_rapport AS is_rapport_18,
  t0.date_rapport_at AS date_rapport_at_19,
  t0.is_clients AS is_clients_20,
  t0.rapport AS rapport_21,
  t0.id_ct_id AS id_ct_id_22,
  t0.id_ville_id AS id_ville_id_23,
  t0.ville_initiale_id AS ville_initiale_id_24
FROM
  programme_contenaire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_chargement AS date_chargement_2, t0.date_depart AS date_depart_3, t0.date_arriver AS date_arriver_4, t0.date_operation AS date_operation_5, t0.nom_bateau AS nom_bateau_6, t0.id_ag AS id_ag_7, t0.flag AS flag_8, t0.numero_contenaire AS numero_contenaire_9, t0.transporteur AS transporteur_10, t0.complet_flag AS complet_flag_11, t0.proprietaire_conteneur AS proprietaire_conteneur_12, t0.destination AS destination_13, t0.validation AS validation_14, t0.depenses_prevue AS depenses_prevue_15, t0.remarque_conteneur AS remarque_conteneur_16, t0.is_mco AS is_mco_17, t0.is_rapport AS is_rapport_18, t0.date_rapport_at AS date_rapport_at_19, t0.is_clients AS is_clients_20, t0.rapport AS rapport_21, t0.id_ct_id AS id_ct_id_22, t0.id_ville_id AS id_ville_id_23, t0.ville_initiale_id AS ville_initiale_id_24 FROM programme_contenaire t0 WHERE t0.id = 4615;

SELECT
  t0.id AS id_1,
  t0.lieu AS lieu_2,
  t0.id_position AS id_position_3,
  t0.date_operation AS date_operation_4,
  t0.position_actuelle_flag AS position_actuelle_flag_5,
  t0.id_ct_pr_id AS id_ct_pr_id_6
FROM
  suivi_contenaire t0
WHERE
  t0.id_ct_pr_id = ?

SELECT t0.id AS id_1, t0.lieu AS lieu_2, t0.id_position AS id_position_3, t0.date_operation AS date_operation_4, t0.position_actuelle_flag AS position_actuelle_flag_5, t0.id_ct_pr_id AS id_ct_pr_id_6 FROM suivi_contenaire t0 WHERE t0.id_ct_pr_id = 4615;

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.reception_id AS reception_id_10,
  t0.user_id AS user_id_11
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.reception_id AS reception_id_10, t0.user_id AS user_id_11 FROM tmp_reception t0 WHERE t0.reception_id = 9591;

SELECT
  t0.id AS id_1,
  t0.isflag AS isflag_2,
  t0.quantite AS quantite_3,
  t0.destination_air_cargo AS destination_air_cargo_4,
  t0.pkg AS pkg_5,
  t0.programme_id AS programme_id_6,
  t0.user_id AS user_id_7,
  t0.tmp_reception_id AS tmp_reception_id_8
FROM
  tmp_conteneur_reception t0
WHERE
  t0.tmp_reception_id = ?

SELECT t0.id AS id_1, t0.isflag AS isflag_2, t0.quantite AS quantite_3, t0.destination_air_cargo AS destination_air_cargo_4, t0.pkg AS pkg_5, t0.programme_id AS programme_id_6, t0.user_id AS user_id_7, t0.tmp_reception_id AS tmp_reception_id_8 FROM tmp_conteneur_reception t0 WHERE t0.tmp_reception_id = 9629;

SELECT
  t0.id AS id_1,
  t0.date_chargement AS date_chargement_2,
  t0.date_depart AS date_depart_3,
  t0.date_arriver AS date_arriver_4,
  t0.date_operation AS date_operation_5,
  t0.nom_bateau AS nom_bateau_6,
  t0.id_ag AS id_ag_7,
  t0.flag AS flag_8,
  t0.numero_contenaire AS numero_contenaire_9,
  t0.transporteur AS transporteur_10,
  t0.complet_flag AS complet_flag_11,
  t0.proprietaire_conteneur AS proprietaire_conteneur_12,
  t0.destination AS destination_13,
  t0.validation AS validation_14,
  t0.depenses_prevue AS depenses_prevue_15,
  t0.remarque_conteneur AS remarque_conteneur_16,
  t0.is_mco AS is_mco_17,
  t0.is_rapport AS is_rapport_18,
  t0.date_rapport_at AS date_rapport_at_19,
  t0.is_clients AS is_clients_20,
  t0.rapport AS rapport_21,
  t0.id_ct_id AS id_ct_id_22,
  t0.id_ville_id AS id_ville_id_23,
  t0.ville_initiale_id AS ville_initiale_id_24
FROM
  programme_contenaire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_chargement AS date_chargement_2, t0.date_depart AS date_depart_3, t0.date_arriver AS date_arriver_4, t0.date_operation AS date_operation_5, t0.nom_bateau AS nom_bateau_6, t0.id_ag AS id_ag_7, t0.flag AS flag_8, t0.numero_contenaire AS numero_contenaire_9, t0.transporteur AS transporteur_10, t0.complet_flag AS complet_flag_11, t0.proprietaire_conteneur AS proprietaire_conteneur_12, t0.destination AS destination_13, t0.validation AS validation_14, t0.depenses_prevue AS depenses_prevue_15, t0.remarque_conteneur AS remarque_conteneur_16, t0.is_mco AS is_mco_17, t0.is_rapport AS is_rapport_18, t0.date_rapport_at AS date_rapport_at_19, t0.is_clients AS is_clients_20, t0.rapport AS rapport_21, t0.id_ct_id AS id_ct_id_22, t0.id_ville_id AS id_ville_id_23, t0.ville_initiale_id AS ville_initiale_id_24 FROM programme_contenaire t0 WHERE t0.id = 4594;

SELECT
  t0.id AS id_1,
  t0.lieu AS lieu_2,
  t0.id_position AS id_position_3,
  t0.date_operation AS date_operation_4,
  t0.position_actuelle_flag AS position_actuelle_flag_5,
  t0.id_ct_pr_id AS id_ct_pr_id_6
FROM
  suivi_contenaire t0
WHERE
  t0.id_ct_pr_id = ?

SELECT t0.id AS id_1, t0.lieu AS lieu_2, t0.id_position AS id_position_3, t0.date_operation AS date_operation_4, t0.position_actuelle_flag AS position_actuelle_flag_5, t0.id_ct_pr_id AS id_ct_pr_id_6 FROM suivi_contenaire t0 WHERE t0.id_ct_pr_id = 4594;