Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.contact AS contact_5,
  t0.fonction AS fonction_6,
  t0.nom AS nom_7,
  t0.statut AS statut_8,
  t0.image AS image_9,
  t0.role AS role_10,
  t0.created_at AS created_at_11
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.contact AS contact_5, t0.fonction AS fonction_6, t0.nom AS nom_7, t0.statut AS statut_8, t0.image AS image_9, t0.role AS role_10, t0.created_at AS created_at_11 FROM users t0 WHERE t0.id = 10;

SELECT
  f0_.id AS id_0,
  f0_.dates_session AS dates_session_1,
  f0_.prix AS prix_2,
  f0_.devise AS devise_3,
  t1_.nom AS nom_4,
  t2_.nom AS nom_5,
  v3_.nom AS nom_6,
  v3_.pays AS pays_7,
  f0_.created_at AS created_at_8,
  t1_.slug AS slug_9,
  t1_.description AS description_10,
  f0_.devise AS devise_11
FROM
  formations f0_
  INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id)
  INNER JOIN villes v3_ ON (f0_.ville_id = v3_.id)
  INNER JOIN thematiques t2_ ON (t1_.thematique_id = t2_.id)

SELECT f0_.id AS id_0, f0_.dates_session AS dates_session_1, f0_.prix AS prix_2, f0_.devise AS devise_3, t1_.nom AS nom_4, t2_.nom AS nom_5, v3_.nom AS nom_6, v3_.pays AS pays_7, f0_.created_at AS created_at_8, t1_.slug AS slug_9, t1_.description AS description_10, f0_.devise AS devise_11 FROM formations f0_ INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id) INNER JOIN villes v3_ ON (f0_.ville_id = v3_.id) INNER JOIN thematiques t2_ ON (t1_.thematique_id = t2_.id);

SELECT
  t0_.id AS id_0,
  t0_.nom AS nom_1,
  t0_.slug AS slug_2,
  t0_.description AS description_3,
  t0_.thematique_id AS thematique_id_4
FROM
  themes t0_

SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.slug AS slug_2, t0_.description AS description_3, t0_.thematique_id AS thematique_id_4 FROM themes t0_;

SELECT
  v0_.id AS id_0,
  v0_.nom AS nom_1,
  v0_.slug AS slug_2,
  v0_.image AS image_3,
  v0_.pays AS pays_4,
  v0_.texte AS texte_5,
  v0_.longitude AS longitude_6,
  v0_.latitude AS latitude_7,
  v0_.adminsid AS adminsid_8,
  v0_.created_at AS created_at_9
FROM
  villes v0_

SELECT v0_.id AS id_0, v0_.nom AS nom_1, v0_.slug AS slug_2, v0_.image AS image_3, v0_.pays AS pays_4, v0_.texte AS texte_5, v0_.longitude AS longitude_6, v0_.latitude AS latitude_7, v0_.adminsid AS adminsid_8, v0_.created_at AS created_at_9 FROM villes v0_;

SELECT
  t0.id AS id_1,
  t0.dates_session AS dates_session_2,
  t0.prix AS prix_3,
  t0.devise AS devise_4,
  t0.image AS image_5,
  t0.created_at AS created_at_6,
  t0.theme_id AS theme_id_7,
  t0.ville_id AS ville_id_8
FROM
  formations t0
WHERE
  t0.theme_id = ?
  AND t0.ville_id = ?
  AND t0.dates_session = ?
  AND t0.prix = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.dates_session AS dates_session_2, t0.prix AS prix_3, t0.devise AS devise_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.theme_id AS theme_id_7, t0.ville_id AS ville_id_8 FROM formations t0 WHERE t0.theme_id = 648 AND t0.ville_id = 3 AND t0.dates_session = '12 au 23 oct' AND t0.prix = '4500' LIMIT 2;

SELECT
  COUNT(*)
FROM
  formations t0
WHERE
  t0.theme_id = ?
  AND t0.ville_id = ?
  AND t0.prix = ?
  AND t0.dates_session = ?

SELECT COUNT(*) FROM formations t0 WHERE t0.theme_id = 648 AND t0.ville_id = 3 AND t0.prix = '4500' AND t0.dates_session = '12 au 23 oct';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO formations (
  dates_session, prix, devise, image,
  created_at, theme_id, ville_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO formations (dates_session, prix, devise, image, created_at, theme_id, ville_id) VALUES ('12 au 23 oct', '4500', 'EURO', 'CIMEF-0003-6984e46daab87.jpg', '2026-02-05 13:41:49', 648, 3);

"COMMIT"

"COMMIT";