Symfony Profiler

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

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 = 'dzebada@sifogroup.com' LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.super AS super_1,
  b0_.gasoil AS gasoil_2,
  b0_.fuel AS fuel_3,
  b0_.petrol AS petrol_4,
  b0_.date_de_chargement AS date_de_chargement_5,
  b0_.photo_bl AS photo_bl_6,
  b0_.numero AS numero_7,
  b0_.chauffeur AS chauffeur_8,
  b0_.isdepoted AS isdepoted_9,
  b0_.isdraft AS isdraft_10,
  b0_.date_edition AS date_edition_11,
  b0_.is_agent_traited AS is_agent_traited_12,
  b0_.is_validated AS is_validated_13,
  b0_.is_started AS is_started_14,
  b0_.date_arrivee_camion AS date_arrivee_camion_15,
  b0_.date_depart_camion AS date_depart_camion_16,
  b0_.date_debut_depotage AS date_debut_depotage_17,
  b0_.date_fin_depotage AS date_fin_depotage_18,
  b0_.temps_depotage AS temps_depotage_19,
  b0_.is_charged AS is_charged_20,
  b0_.granted AS granted_21,
  b0_.prix_super AS prix_super_22,
  b0_.prix_gasoil AS prix_gasoil_23,
  b0_.prix_fuel AS prix_fuel_24,
  b0_.prix_petrol AS prix_petrol_25,
  b0_.regime_douanier AS regime_douanier_26,
  b0_.differentiel_transport AS differentiel_transport_27,
  b0_.bc_client AS bc_client_28,
  b0_.created_at AS created_at_29,
  b0_.updated_at AS updated_at_30,
  s1_.id AS id_31,
  s1_.libelle AS libelle_32,
  s1_.ref_client AS ref_client_33,
  s1_.latitude AS latitude_34,
  s1_.longitude AS longitude_35,
  s1_.created_at AS created_at_36,
  s1_.updated_at AS updated_at_37,
  b0_.station_service_id AS station_service_id_38,
  b0_.camion_id AS camion_id_39,
  b0_.lieux_empotage_id AS lieux_empotage_id_40,
  b0_.operation_user_id AS operation_user_id_41,
  b0_.agent_granted_id AS agent_granted_id_42,
  s1_.localite_id AS localite_id_43
FROM
  bon_de_livraison b0_
  LEFT JOIN station_service s1_ ON b0_.station_service_id = s1_.id
WHERE
  b0_.isdraft = 0
  AND b0_.granted = 1
  AND s1_.id = ?
  AND b0_.isdepoted = 1
  AND b0_.is_validated = 0
ORDER BY
  b0_.created_at DESC

SELECT b0_.id AS id_0, b0_.super AS super_1, b0_.gasoil AS gasoil_2, b0_.fuel AS fuel_3, b0_.petrol AS petrol_4, b0_.date_de_chargement AS date_de_chargement_5, b0_.photo_bl AS photo_bl_6, b0_.numero AS numero_7, b0_.chauffeur AS chauffeur_8, b0_.isdepoted AS isdepoted_9, b0_.isdraft AS isdraft_10, b0_.date_edition AS date_edition_11, b0_.is_agent_traited AS is_agent_traited_12, b0_.is_validated AS is_validated_13, b0_.is_started AS is_started_14, b0_.date_arrivee_camion AS date_arrivee_camion_15, b0_.date_depart_camion AS date_depart_camion_16, b0_.date_debut_depotage AS date_debut_depotage_17, b0_.date_fin_depotage AS date_fin_depotage_18, b0_.temps_depotage AS temps_depotage_19, b0_.is_charged AS is_charged_20, b0_.granted AS granted_21, b0_.prix_super AS prix_super_22, b0_.prix_gasoil AS prix_gasoil_23, b0_.prix_fuel AS prix_fuel_24, b0_.prix_petrol AS prix_petrol_25, b0_.regime_douanier AS regime_douanier_26, b0_.differentiel_transport AS differentiel_transport_27, b0_.bc_client AS bc_client_28, b0_.created_at AS created_at_29, b0_.updated_at AS updated_at_30, s1_.id AS id_31, s1_.libelle AS libelle_32, s1_.ref_client AS ref_client_33, s1_.latitude AS latitude_34, s1_.longitude AS longitude_35, s1_.created_at AS created_at_36, s1_.updated_at AS updated_at_37, b0_.station_service_id AS station_service_id_38, b0_.camion_id AS camion_id_39, b0_.lieux_empotage_id AS lieux_empotage_id_40, b0_.operation_user_id AS operation_user_id_41, b0_.agent_granted_id AS agent_granted_id_42, s1_.localite_id AS localite_id_43 FROM bon_de_livraison b0_ LEFT JOIN station_service s1_ ON b0_.station_service_id = s1_.id WHERE b0_.isdraft = 0 AND b0_.granted = 1 AND s1_.id = 4 AND b0_.isdepoted = 1 AND b0_.is_validated = 0 ORDER BY b0_.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 = 3;