Symfony Profiler

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 = 4;

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 = 4;

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 = 1;

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.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 = 41;

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 = 42;

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 = 44;

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 = 45;

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 = 46;

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 = 48;

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 = 49;

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 = 50;

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 = 51;

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 = 54;

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 = ?
ORDER BY
  t0.numero 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 ORDER BY t0.numero DESC;

SELECT
  c0_.id AS id_0,
  c0_.chauffeur AS chauffeur_1,
  c0_.parking AS parking_2,
  c0_.status AS status_3,
  c0_.tractor_id AS tractor_id_4,
  c0_.trailer_id AS trailer_id_5
FROM
  camion c0_
  LEFT JOIN trailer t1_ ON (c0_.trailer_id = t1_.id)
  LEFT JOIN tractor t2_ ON (c0_.tractor_id = t2_.id)
WHERE
  (
    t2_.carburant_id IS NOT NULL
    OR t1_.carburant_id IS NOT NULL
  )

SELECT c0_.id AS id_0, c0_.chauffeur AS chauffeur_1, c0_.parking AS parking_2, c0_.status AS status_3, c0_.tractor_id AS tractor_id_4, c0_.trailer_id AS trailer_id_5 FROM camion c0_ LEFT JOIN trailer t1_ ON (c0_.trailer_id = t1_.id) LEFT JOIN tractor t2_ ON (c0_.tractor_id = t2_.id) WHERE (t2_.carburant_id IS NOT NULL OR t1_.carburant_id IS NOT NULL);

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 = 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 = 1;

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 = 3;

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 = 4;