Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.creux_gestoci AS creux_gestoci_2,
  t0.dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3,
  t0.creux_station AS creux_station_4,
  t0.dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5,
  t0.ecart AS ecart_6,
  t0.contre_plain AS contre_plain_7,
  t0.date_debut_depotage AS date_debut_depotage_8,
  t0.date_fin_depotage AS date_fin_depotage_9,
  t0.temps_depotage AS temps_depotage_10,
  t0.commentaire AS commentaire_11,
  t0.stock_avant_depotage AS stock_avant_depotage_12,
  t0.stock_apres_depotage AS stock_apres_depotage_13,
  t0.stock_theorique AS stock_theorique_14,
  t0.stock_reel AS stock_reel_15,
  t0.bon_de_livraison_id AS bon_de_livraison_id_16,
  t0.compartiment_id AS compartiment_id_17,
  t0.produit_id AS produit_id_18,
  t0.jaugeur_id AS jaugeur_id_19,
  t0.gerant_id AS gerant_id_20
FROM
  detail_bon_de_livraison t0
WHERE
  t0.bon_de_livraison_id = ?

SELECT t0.id AS id_1, t0.creux_gestoci AS creux_gestoci_2, t0.dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3, t0.creux_station AS creux_station_4, t0.dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5, t0.ecart AS ecart_6, t0.contre_plain AS contre_plain_7, t0.date_debut_depotage AS date_debut_depotage_8, t0.date_fin_depotage AS date_fin_depotage_9, t0.temps_depotage AS temps_depotage_10, t0.commentaire AS commentaire_11, t0.stock_avant_depotage AS stock_avant_depotage_12, t0.stock_apres_depotage AS stock_apres_depotage_13, t0.stock_theorique AS stock_theorique_14, t0.stock_reel AS stock_reel_15, t0.bon_de_livraison_id AS bon_de_livraison_id_16, t0.compartiment_id AS compartiment_id_17, t0.produit_id AS produit_id_18, t0.jaugeur_id AS jaugeur_id_19, t0.gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0.bon_de_livraison_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.capacity AS capacity_3,
  t0.creux_certificat AS creux_certificat_4,
  t0.status AS status_5,
  t0.trailer_id AS trailer_id_6
FROM
  compartiment t0
WHERE
  t0.trailer_id = ?

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.capacity AS capacity_3, t0.creux_certificat AS creux_certificat_4, t0.status AS status_5, t0.trailer_id AS trailer_id_6 FROM compartiment t0 WHERE t0.trailer_id = 13;

SELECT
  t0.id AS id_1,
  t0.immatriculation AS immatriculation_2,
  t0.capacity AS capacity_3,
  t0.nbrcompatiment AS nbrcompatiment_4,
  t0.typeatelage AS typeatelage_5,
  t0.company AS company_6,
  t0.slug AS slug_7,
  t0.marque AS marque_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.tractor_id AS tractor_id_11,
  t0.carburant_id AS carburant_id_12
FROM
  trailer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.immatriculation AS immatriculation_2, t0.capacity AS capacity_3, t0.nbrcompatiment AS nbrcompatiment_4, t0.typeatelage AS typeatelage_5, t0.company AS company_6, t0.slug AS slug_7, t0.marque AS marque_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.tractor_id AS tractor_id_11, t0.carburant_id AS carburant_id_12 FROM trailer t0 WHERE t0.id = 13;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.fonction AS fonction_5,
  t0.photo AS photo_6,
  t0.roles AS roles_7,
  t0.refresh_token AS refresh_token_8,
  t0.refresh_token_expires_at AS refresh_token_expires_at_9,
  t0.apps AS apps_10,
  t0.signature AS signature_11,
  t0.fleet_refresh_token AS fleet_refresh_token_12,
  t0.password AS password_13,
  t0.slug AS slug_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.station_id AS station_id_17,
  t0.lieu_empotage_id AS lieu_empotage_id_18
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.fonction AS fonction_5, t0.photo AS photo_6, t0.roles AS roles_7, t0.refresh_token AS refresh_token_8, t0.refresh_token_expires_at AS refresh_token_expires_at_9, t0.apps AS apps_10, t0.signature AS signature_11, t0.fleet_refresh_token AS fleet_refresh_token_12, t0.password AS password_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.station_id AS station_id_17, t0.lieu_empotage_id AS lieu_empotage_id_18 FROM `user` t0 WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.chauffeur AS chauffeur_2,
  t0.parking AS parking_3,
  t0.status AS status_4,
  t0.tractor_id AS tractor_id_5,
  t0.trailer_id AS trailer_id_6
FROM
  camion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chauffeur AS chauffeur_2, t0.parking AS parking_3, t0.status AS status_4, t0.tractor_id AS tractor_id_5, t0.trailer_id AS trailer_id_6 FROM camion t0 WHERE t0.id = 31;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.entity AS entity_3,
  t0.value AS value_4
FROM
  permission t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 137;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.ref_client AS ref_client_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.localite_id AS localite_id_8
FROM
  station_service t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ref_client AS ref_client_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.localite_id AS localite_id_8 FROM station_service t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.differentiel_transport AS differentiel_transport_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.slug AS slug_8
FROM
  localite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.differentiel_transport AS differentiel_transport_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8 FROM localite t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.fonction AS fonction_5,
  t0.photo AS photo_6,
  t0.roles AS roles_7,
  t0.refresh_token AS refresh_token_8,
  t0.refresh_token_expires_at AS refresh_token_expires_at_9,
  t0.apps AS apps_10,
  t0.signature AS signature_11,
  t0.fleet_refresh_token AS fleet_refresh_token_12,
  t0.password AS password_13,
  t0.slug AS slug_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.station_id AS station_id_17,
  t0.lieu_empotage_id AS lieu_empotage_id_18
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.fonction AS fonction_5, t0.photo AS photo_6, t0.roles AS roles_7, t0.refresh_token AS refresh_token_8, t0.refresh_token_expires_at AS refresh_token_expires_at_9, t0.apps AS apps_10, t0.signature AS signature_11, t0.fleet_refresh_token AS fleet_refresh_token_12, t0.password AS password_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.station_id AS station_id_17, t0.lieu_empotage_id AS lieu_empotage_id_18 FROM `user` t0 WHERE t0.email = 'gbetta@sifogroup.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.immatriculation AS immatriculation_2,
  t0.company AS company_3,
  t0.marque AS marque_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t8.id AS id_9,
  t8.immatriculation AS immatriculation_10,
  t8.capacity AS capacity_11,
  t8.nbrcompatiment AS nbrcompatiment_12,
  t8.typeatelage AS typeatelage_13,
  t8.company AS company_14,
  t8.slug AS slug_15,
  t8.marque AS marque_16,
  t8.created_at AS created_at_17,
  t8.updated_at AS updated_at_18,
  t8.tractor_id AS tractor_id_19,
  t8.carburant_id AS carburant_id_20,
  t0.carburant_id AS carburant_id_21
FROM
  tractor t0
  LEFT JOIN trailer t8 ON t8.tractor_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.immatriculation AS immatriculation_2, t0.company AS company_3, t0.marque AS marque_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t8.id AS id_9, t8.immatriculation AS immatriculation_10, t8.capacity AS capacity_11, t8.nbrcompatiment AS nbrcompatiment_12, t8.typeatelage AS typeatelage_13, t8.company AS company_14, t8.slug AS slug_15, t8.marque AS marque_16, t8.created_at AS created_at_17, t8.updated_at AS updated_at_18, t8.tractor_id AS tractor_id_19, t8.carburant_id AS carburant_id_20, t0.carburant_id AS carburant_id_21 FROM tractor t0 LEFT JOIN trailer t8 ON t8.tractor_id = t0.id WHERE t0.id = 19;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.slug AS slug_7
FROM
  lieu_empotage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.slug AS slug_7 FROM lieu_empotage t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  role t0
  INNER JOIN role_user ON t0.id = role_user.role_id
WHERE
  role_user.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = 15;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3
FROM
  produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM produit t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.super AS super_2,
  t0.gasoil AS gasoil_3,
  t0.fuel AS fuel_4,
  t0.petrol AS petrol_5,
  t0.date_de_chargement AS date_de_chargement_6,
  t0.photo_bl AS photo_bl_7,
  t0.numero AS numero_8,
  t0.chauffeur AS chauffeur_9,
  t0.isdepoted AS isdepoted_10,
  t0.isdraft AS isdraft_11,
  t0.date_edition AS date_edition_12,
  t0.is_agent_traited AS is_agent_traited_13,
  t0.is_validated AS is_validated_14,
  t0.is_started AS is_started_15,
  t0.date_arrivee_camion AS date_arrivee_camion_16,
  t0.date_depart_camion AS date_depart_camion_17,
  t0.date_debut_depotage AS date_debut_depotage_18,
  t0.date_fin_depotage AS date_fin_depotage_19,
  t0.temps_depotage AS temps_depotage_20,
  t0.is_charged AS is_charged_21,
  t0.granted AS granted_22,
  t0.prix_super AS prix_super_23,
  t0.prix_gasoil AS prix_gasoil_24,
  t0.prix_fuel AS prix_fuel_25,
  t0.prix_petrol AS prix_petrol_26,
  t0.regime_douanier AS regime_douanier_27,
  t0.differentiel_transport AS differentiel_transport_28,
  t0.bc_client AS bc_client_29,
  t0.created_at AS created_at_30,
  t0.updated_at AS updated_at_31,
  t0.station_service_id AS station_service_id_32,
  t0.camion_id AS camion_id_33,
  t0.lieux_empotage_id AS lieux_empotage_id_34,
  t0.operation_user_id AS operation_user_id_35,
  t0.agent_granted_id AS agent_granted_id_36
FROM
  bon_de_livraison t0
WHERE
  t0.isdraft = ?
  AND t0.granted = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.super AS super_2, t0.gasoil AS gasoil_3, t0.fuel AS fuel_4, t0.petrol AS petrol_5, t0.date_de_chargement AS date_de_chargement_6, t0.photo_bl AS photo_bl_7, t0.numero AS numero_8, t0.chauffeur AS chauffeur_9, t0.isdepoted AS isdepoted_10, t0.isdraft AS isdraft_11, t0.date_edition AS date_edition_12, t0.is_agent_traited AS is_agent_traited_13, t0.is_validated AS is_validated_14, t0.is_started AS is_started_15, t0.date_arrivee_camion AS date_arrivee_camion_16, t0.date_depart_camion AS date_depart_camion_17, t0.date_debut_depotage AS date_debut_depotage_18, t0.date_fin_depotage AS date_fin_depotage_19, t0.temps_depotage AS temps_depotage_20, t0.is_charged AS is_charged_21, t0.granted AS granted_22, t0.prix_super AS prix_super_23, t0.prix_gasoil AS prix_gasoil_24, t0.prix_fuel AS prix_fuel_25, t0.prix_petrol AS prix_petrol_26, t0.regime_douanier AS regime_douanier_27, t0.differentiel_transport AS differentiel_transport_28, t0.bc_client AS bc_client_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.station_service_id AS station_service_id_32, t0.camion_id AS camion_id_33, t0.lieux_empotage_id AS lieux_empotage_id_34, t0.operation_user_id AS operation_user_id_35, t0.agent_granted_id AS agent_granted_id_36 FROM bon_de_livraison t0 WHERE t0.isdraft = 0 AND t0.granted = 1 ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.entity AS entity_2,
  t0.role_id AS role_id_3,
  t0.permission_id AS permission_id_4
FROM
  role_permission t0
WHERE
  t0.role_id = ?

SELECT t0.id AS id_1, t0.entity AS entity_2, t0.role_id AS role_id_3, t0.permission_id AS permission_id_4 FROM role_permission t0 WHERE t0.role_id = 4;