Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations 8
• Debug
• Emails
• Notifications
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed AS password_changed_5, t6.id AS id_7, t6.lastname AS lastname_8, t6.firstname AS firstname_9, t6.phone AS phone_10, t6.agency AS agency_11, t6.photo AS photo_12, t6.prev_contract AS prev_contract_13, t6.sante_contract AS sante_contract_14, t6.birthdate AS birthdate_15, t6.prevcommission AS prevcommission_16, t6.married AS married_17, t6.children AS children_18, t6.famcode AS famcode_19, t6.clause AS clause_20, t6.user_id AS user_id_21, t6.region_id AS region_id_22, t6.contract_id AS contract_id_23 FROM app_user t0 LEFT JOIN agent t6 ON t6.user_id = t0.id WHERE t0.email = ? LIMIT 1

[
  "fabien.dupuis@allianz.fr"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.password_changed AS password_changed_5,
  t6.id AS id_7,
  t6.lastname AS lastname_8,
  t6.firstname AS firstname_9,
  t6.phone AS phone_10,
  t6.agency AS agency_11,
  t6.photo AS photo_12,
  t6.prev_contract AS prev_contract_13,
  t6.sante_contract AS sante_contract_14,
  t6.birthdate AS birthdate_15,
  t6.prevcommission AS prevcommission_16,
  t6.married AS married_17,
  t6.children AS children_18,
  t6.famcode AS famcode_19,
  t6.clause AS clause_20,
  t6.user_id AS user_id_21,
  t6.region_id AS region_id_22,
  t6.contract_id AS contract_id_23
FROM
  app_user t0
  LEFT JOIN agent t6 ON t6.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed AS password_changed_5, t6.id AS id_7, t6.lastname AS lastname_8, t6.firstname AS firstname_9, t6.phone AS phone_10, t6.agency AS agency_11, t6.photo AS photo_12, t6.prev_contract AS prev_contract_13, t6.sante_contract AS sante_contract_14, t6.birthdate AS birthdate_15, t6.prevcommission AS prevcommission_16, t6.married AS married_17, t6.children AS children_18, t6.famcode AS famcode_19, t6.clause AS clause_20, t6.user_id AS user_id_21, t6.region_id AS region_id_22, t6.contract_id AS contract_id_23 FROM app_user t0 LEFT JOIN agent t6 ON t6.user_id = t0.id WHERE t0.email = 'fabien.dupuis@allianz.fr' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.delegue_id AS delegue_id_4 FROM region t0 WHERE t0.id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.delegue_id AS delegue_id_4
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.delegue_id AS delegue_id_4 FROM region t0 WHERE t0.id = 4;

SELECT t0.id AS id_1, t0.name AS name_2, t0.lvl_child AS lvl_child_3, t0.lvl_1 AS lvl_1_4, t0.lvl_2 AS lvl_2_5, t0.lvl_3 AS lvl_3_6, t0.lvl_4 AS lvl_4_7, t0.lvl_5 AS lvl_5_8, t0.lvl6 AS lvl6_9, t0.lvl7 AS lvl7_10, t0.lvl8 AS lvl8_11, t0.lvl9 AS lvl9_12, t0.nonresponsable AS nonresponsable_13, t0.reference AS reference_14, t0.guaranties AS guaranties_15 FROM produit t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lvl_child AS lvl_child_3,
  t0.lvl_1 AS lvl_1_4,
  t0.lvl_2 AS lvl_2_5,
  t0.lvl_3 AS lvl_3_6,
  t0.lvl_4 AS lvl_4_7,
  t0.lvl_5 AS lvl_5_8,
  t0.lvl6 AS lvl6_9,
  t0.lvl7 AS lvl7_10,
  t0.lvl8 AS lvl8_11,
  t0.lvl9 AS lvl9_12,
  t0.nonresponsable AS nonresponsable_13,
  t0.reference AS reference_14,
  t0.guaranties AS guaranties_15
FROM
  produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lvl_child AS lvl_child_3, t0.lvl_1 AS lvl_1_4, t0.lvl_2 AS lvl_2_5, t0.lvl_3 AS lvl_3_6, t0.lvl_4 AS lvl_4_7, t0.lvl_5 AS lvl_5_8, t0.lvl6 AS lvl6_9, t0.lvl7 AS lvl7_10, t0.lvl8 AS lvl8_11, t0.lvl9 AS lvl9_12, t0.nonresponsable AS nonresponsable_13, t0.reference AS reference_14, t0.guaranties AS guaranties_15 FROM produit t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.obligatory AS obligatory_3, t0.daily AS daily_4, t0.code AS code_5, t0.contract AS contract_6, t0.percent AS percent_7, t0.subname AS subname_8 FROM prevoyance_option t0 INNER JOIN agent_prevoyance_option ON t0.id = agent_prevoyance_option.prevoyance_option_id WHERE agent_prevoyance_option.agent_id = ?

[
  52
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.obligatory AS obligatory_3,
  t0.daily AS daily_4,
  t0.code AS code_5,
  t0.contract AS contract_6,
  t0.percent AS percent_7,
  t0.subname AS subname_8
FROM
  prevoyance_option t0
  INNER JOIN agent_prevoyance_option ON t0.id = agent_prevoyance_option.prevoyance_option_id
WHERE
  agent_prevoyance_option.agent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.obligatory AS obligatory_3, t0.daily AS daily_4, t0.code AS code_5, t0.contract AS contract_6, t0.percent AS percent_7, t0.subname AS subname_8 FROM prevoyance_option t0 INNER JOIN agent_prevoyance_option ON t0.id = agent_prevoyance_option.prevoyance_option_id WHERE agent_prevoyance_option.agent_id = 52;