Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• 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.username AS username_5, t0.currency AS currency_6, t0.recent_requests AS recent_requests_7, t0.recent_materials AS recent_materials_8, t0.recent_routings AS recent_routings_9 FROM user t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.currency AS currency_6,
  t0.recent_requests AS recent_requests_7,
  t0.recent_materials AS recent_materials_8,
  t0.recent_routings AS recent_routings_9
FROM
  user 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.username AS username_5, t0.currency AS currency_6, t0.recent_requests AS recent_requests_7, t0.recent_materials AS recent_materials_8, t0.recent_routings AS recent_routings_9 FROM user t0 WHERE t0.id = 1;

SELECT COUNT(m0_.id) AS sclr_0 FROM matiere_premiere m0_ WHERE m0_.refinterne <> ? AND m0_.checknotif <> ?

[
  "-"
  1
]

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  matiere_premiere m0_
WHERE
  m0_.refinterne <> ?
  AND m0_.checknotif <> ?

SELECT COUNT(m0_.id) AS sclr_0 FROM matiere_premiere m0_ WHERE m0_.refinterne <> '-' AND m0_.checknotif <> 1;

SELECT m0_.id AS id_0, m0_.refinterne AS refinterne_1, m0_.titre AS titre_2, m0_.pint AS pint_3, m0_.proctype AS proctype_4, m0_.mtyp AS mtyp_5, m0_.inforec AS inforec_6, m0_.prixref AS prixref_7, m0_.bomusage AS bomusage_8, m0_.crcy AS crcy_9, m0_.bomunit AS bomunit_10, m0_.updatedon AS updatedon_11 FROM matiere_premiere m0_ WHERE m0_.refinterne <> ? AND m0_.checknotif <> ? ORDER BY m0_.refinterne ASC LIMIT 30

[
  "-"
  1
]

SELECT
  m0_.id AS id_0,
  m0_.refinterne AS refinterne_1,
  m0_.titre AS titre_2,
  m0_.pint AS pint_3,
  m0_.proctype AS proctype_4,
  m0_.mtyp AS mtyp_5,
  m0_.inforec AS inforec_6,
  m0_.prixref AS prixref_7,
  m0_.bomusage AS bomusage_8,
  m0_.crcy AS crcy_9,
  m0_.bomunit AS bomunit_10,
  m0_.updatedon AS updatedon_11
FROM
  matiere_premiere m0_
WHERE
  m0_.refinterne <> ?
  AND m0_.checknotif <> ?
ORDER BY
  m0_.refinterne ASC
LIMIT
  30

SELECT m0_.id AS id_0, m0_.refinterne AS refinterne_1, m0_.titre AS titre_2, m0_.pint AS pint_3, m0_.proctype AS proctype_4, m0_.mtyp AS mtyp_5, m0_.inforec AS inforec_6, m0_.prixref AS prixref_7, m0_.bomusage AS bomusage_8, m0_.crcy AS crcy_9, m0_.bomunit AS bomunit_10, m0_.updatedon AS updatedon_11 FROM matiere_premiere m0_ WHERE m0_.refinterne <> '-' AND m0_.checknotif <> 1 ORDER BY m0_.refinterne ASC LIMIT 30;

SELECT
                         p1.matierepremiere_id AS mat_id,
                         p1.price             AS lastPrice,
                         p2.price             AS prevPrice,
                         p2.currency          AS prevCurrency
                     FROM matiere_premiere_price p1
                     LEFT JOIN matiere_premiere_price p2
                         ON  p2.matierepremiere_id = p1.matierepremiere_id
                         AND p2.id = (
                             SELECT MAX(id) FROM matiere_premiere_price
                             WHERE matierepremiere_id = p1.matierepremiere_id
                             AND id < p1.id
                         )
                     WHERE p1.id IN (
                         SELECT MAX(id) FROM matiere_premiere_price
                         WHERE matierepremiere_id IN (36630,36631,36632,36633,36634,36635,36636,36637,36638,36639,36640,36641,36642,36643,36644,36645,36646,36647,36648,36649,36650,36651,36652,36653,36654,36655,36656,36657,36658,36659)
                         GROUP BY matierepremiere_id
                     )

[]

SELECT
  p1.matierepremiere_id AS mat_id,
  p1.price AS lastPrice,
  p2.price AS prevPrice,
  p2.currency AS prevCurrency
FROM
  matiere_premiere_price p1
  LEFT JOIN matiere_premiere_price p2 ON p2.matierepremiere_id = p1.matierepremiere_id
  AND p2.id = (
    SELECT
      MAX(id)
    FROM
      matiere_premiere_price
    WHERE
      matierepremiere_id = p1.matierepremiere_id
      AND id < p1.id
  )
WHERE
  p1.id IN (
    SELECT
      MAX(id)
    FROM
      matiere_premiere_price
    WHERE
      matierepremiere_id IN (
        36630, 36631, 36632, 36633, 36634, 36635,
        36636, 36637, 36638, 36639, 36640,
        36641, 36642, 36643, 36644, 36645,
        36646, 36647, 36648, 36649, 36650,
        36651, 36652, 36653, 36654, 36655,
        36656, 36657, 36658, 36659
      )
    GROUP BY
      matierepremiere_id
  )

SELECT
                         p1.matierepremiere_id AS mat_id,
                         p1.price             AS lastPrice,
                         p2.price             AS prevPrice,
                         p2.currency          AS prevCurrency
                     FROM matiere_premiere_price p1
                     LEFT JOIN matiere_premiere_price p2
                         ON  p2.matierepremiere_id = p1.matierepremiere_id
                         AND p2.id = (
                             SELECT MAX(id) FROM matiere_premiere_price
                             WHERE matierepremiere_id = p1.matierepremiere_id
                             AND id < p1.id
                         )
                     WHERE p1.id IN (
                         SELECT MAX(id) FROM matiere_premiere_price
                         WHERE matierepremiere_id IN (36630,36631,36632,36633,36634,36635,36636,36637,36638,36639,36640,36641,36642,36643,36644,36645,36646,36647,36648,36649,36650,36651,36652,36653,36654,36655,36656,36657,36658,36659)
                         GROUP BY matierepremiere_id
                     );