Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 12
• Events
• Routing
• Cache
• Translation 11
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT DISTINCT f0_.id AS id_0, f0_.scenario_id AS sclr_1 FROM fichier f0_ LEFT JOIN scenario s1_ ON f0_.scenario_id = s1_.id ORDER BY f0_.scenario_id ASC LIMIT 20 OFFSET 120

[]

SELECT
  DISTINCT f0_.id AS id_0,
  f0_.scenario_id AS sclr_1
FROM
  fichier f0_
  LEFT JOIN scenario s1_ ON f0_.scenario_id = s1_.id
ORDER BY
  f0_.scenario_id ASC
LIMIT
  20 OFFSET 120

SELECT DISTINCT f0_.id AS id_0, f0_.scenario_id AS sclr_1 FROM fichier f0_ LEFT JOIN scenario s1_ ON f0_.scenario_id = s1_.id ORDER BY f0_.scenario_id ASC LIMIT 20 OFFSET 120;

SELECT f0_.id AS id_0, f0_.fichier AS fichier_1, f0_.cheptel_id AS cheptel_id_2, f0_.scenario_id AS scenario_id_3, f0_.typologie_paturage_id AS typologie_paturage_id_4, f0_.zone_geographique_id AS zone_geographique_id_5 FROM fichier f0_ LEFT JOIN scenario s1_ ON f0_.scenario_id = s1_.id WHERE f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.scenario_id ASC

[
  52
  23
  38
  53
  24
  39
  54
  25
  40
  148
  26
  41
  149
  27
  42
  58
  56
  57
  61
  65
]

SELECT
  f0_.id AS id_0,
  f0_.fichier AS fichier_1,
  f0_.cheptel_id AS cheptel_id_2,
  f0_.scenario_id AS scenario_id_3,
  f0_.typologie_paturage_id AS typologie_paturage_id_4,
  f0_.zone_geographique_id AS zone_geographique_id_5
FROM
  fichier f0_
  LEFT JOIN scenario s1_ ON f0_.scenario_id = s1_.id
WHERE
  f0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  f0_.scenario_id ASC

SELECT f0_.id AS id_0, f0_.fichier AS fichier_1, f0_.cheptel_id AS cheptel_id_2, f0_.scenario_id AS scenario_id_3, f0_.typologie_paturage_id AS typologie_paturage_id_4, f0_.zone_geographique_id AS zone_geographique_id_5 FROM fichier f0_ LEFT JOIN scenario s1_ ON f0_.scenario_id = s1_.id WHERE f0_.id IN (52, 23, 38, 53, 24, 39, 54, 25, 40, 148, 26, 41, 149, 27, 42, 58, 56, 57, 61, 65) ORDER BY f0_.scenario_id ASC;

SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM fichier f0_ LEFT JOIN scenario s1_ ON f0_.scenario_id = s1_.id

[]

SELECT
  COUNT(DISTINCT f0_.id) AS sclr_0
FROM
  fichier f0_
  LEFT JOIN scenario s1_ ON f0_.scenario_id = s1_.id

SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM fichier f0_ LEFT JOIN scenario s1_ ON f0_.scenario_id = s1_.id;

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nom AS nom_3 FROM cheptel t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.nom AS nom_3
FROM
  cheptel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nom AS nom_3 FROM cheptel t0 WHERE t0.id = 2;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = ?

[
  15
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  scenario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = 15;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM typologie_paturage t0 WHERE t0.id = ?

[
  6
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  typologie_paturage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM typologie_paturage t0 WHERE t0.id = 6;

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nom AS nom_3, t0.description AS description_4 FROM zone_geographique t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.nom AS nom_3,
  t0.description AS description_4
FROM
  zone_geographique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nom AS nom_3, t0.description AS description_4 FROM zone_geographique t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = ?

[
  16
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  scenario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = 16;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM typologie_paturage t0 WHERE t0.id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  typologie_paturage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM typologie_paturage t0 WHERE t0.id = 4;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM typologie_paturage t0 WHERE t0.id = ?

[
  5
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  typologie_paturage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM typologie_paturage t0 WHERE t0.id = 5;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = ?

[
  17
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  scenario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = 17;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = ?

[
  18
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  scenario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = 18;

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nom AS nom_3, t0.description AS description_4 FROM zone_geographique t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.nom AS nom_3,
  t0.description AS description_4
FROM
  zone_geographique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nom AS nom_3, t0.description AS description_4 FROM zone_geographique t0 WHERE t0.id = 3;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = ?

[
  19
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  scenario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = 19;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = ?

[
  20
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  scenario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = 20;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = ?

[
  21
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  scenario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = 21;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = ?

[
  22
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  scenario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = 22;

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nom AS nom_3 FROM cheptel t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.nom AS nom_3
FROM
  cheptel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nom AS nom_3 FROM cheptel t0 WHERE t0.id = 3;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = ?

[
  23
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  scenario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM scenario t0 WHERE t0.id = 23;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM typologie_paturage t0 WHERE t0.id = ?

[
  7
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  typologie_paturage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM typologie_paturage t0 WHERE t0.id = 7;

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM typologie_paturage t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  typologie_paturage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM typologie_paturage t0 WHERE t0.id = 3;