Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 82
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 2
• Debug
• Messages
• E-mails
• Notifications
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.city AS city_4, t0.postcode AS postcode_5, t0.account_number AS account_number_6, t0.bank_number AS bank_number_7, t0.ic AS ic_8, t0.vat AS vat_9, t0.bank_name AS bank_name_10, t0.cost_center_email AS cost_center_email_11, t0.cost_center_phone AS cost_center_phone_12, t0.dic AS dic_13, t0.is_active AS is_active_14, t0.payment_provider AS payment_provider_15 FROM cost_center t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.street AS street_3,
  t0.city AS city_4,
  t0.postcode AS postcode_5,
  t0.account_number AS account_number_6,
  t0.bank_number AS bank_number_7,
  t0.ic AS ic_8,
  t0.vat AS vat_9,
  t0.bank_name AS bank_name_10,
  t0.cost_center_email AS cost_center_email_11,
  t0.cost_center_phone AS cost_center_phone_12,
  t0.dic AS dic_13,
  t0.is_active AS is_active_14,
  t0.payment_provider AS payment_provider_15
FROM
  cost_center t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.city AS city_4, t0.postcode AS postcode_5, t0.account_number AS account_number_6, t0.bank_number AS bank_number_7, t0.ic AS ic_8, t0.vat AS vat_9, t0.bank_name AS bank_name_10, t0.cost_center_email AS cost_center_email_11, t0.cost_center_phone AS cost_center_phone_12, t0.dic AS dic_13, t0.is_active AS is_active_14, t0.payment_provider AS payment_provider_15 FROM cost_center t0;

SELECT SUM(c0_.value * (CASE WHEN c0_.type < 5 THEN 1 ELSE -1 END)) AS sclr_0, c1_.name AS name_1, c1_.id AS id_2 FROM credit_transaction c0_ INNER JOIN cost_center c1_ ON c0_.cost_center_id = c1_.id WHERE c0_.type IN (1, 2, 6, 7, 11) AND c0_.client_id = ? AND c1_.id = ? AND c0_.state = 1

[
  null
  1
]

SELECT
  SUM(
    c0_.value * (
      CASE WHEN c0_.type < 5 THEN 1 ELSE -1 END
    )
  ) AS sclr_0,
  c1_.name AS name_1,
  c1_.id AS id_2
FROM
  credit_transaction c0_
  INNER JOIN cost_center c1_ ON c0_.cost_center_id = c1_.id
WHERE
  c0_.type IN (1, 2, 6, 7, 11)
  AND c0_.client_id = ?
  AND c1_.id = ?
  AND c0_.state = 1

SELECT SUM(c0_.value * (CASE WHEN c0_.type < 5 THEN 1 ELSE -1 END)) AS sclr_0, c1_.name AS name_1, c1_.id AS id_2 FROM credit_transaction c0_ INNER JOIN cost_center c1_ ON c0_.cost_center_id = c1_.id WHERE c0_.type IN (1, 2, 6, 7, 11) AND c0_.client_id = NULL AND c1_.id = 1 AND c0_.state = 1;

SELECT SUM(c0_.value * (CASE WHEN c0_.type < 5 THEN 1 ELSE -1 END)) AS sclr_0, c1_.name AS name_1, c1_.id AS id_2 FROM credit_transaction c0_ INNER JOIN cost_center c1_ ON c0_.cost_center_id = c1_.id WHERE c0_.type IN (1, 2, 6, 7, 11) AND c0_.client_id = ? AND c1_.id = ? AND c0_.state = 1

[
  null
  2
]

SELECT
  SUM(
    c0_.value * (
      CASE WHEN c0_.type < 5 THEN 1 ELSE -1 END
    )
  ) AS sclr_0,
  c1_.name AS name_1,
  c1_.id AS id_2
FROM
  credit_transaction c0_
  INNER JOIN cost_center c1_ ON c0_.cost_center_id = c1_.id
WHERE
  c0_.type IN (1, 2, 6, 7, 11)
  AND c0_.client_id = ?
  AND c1_.id = ?
  AND c0_.state = 1

SELECT SUM(c0_.value * (CASE WHEN c0_.type < 5 THEN 1 ELSE -1 END)) AS sclr_0, c1_.name AS name_1, c1_.id AS id_2 FROM credit_transaction c0_ INNER JOIN cost_center c1_ ON c0_.cost_center_id = c1_.id WHERE c0_.type IN (1, 2, 6, 7, 11) AND c0_.client_id = NULL AND c1_.id = 2 AND c0_.state = 1;

SELECT SUM(c0_.value * (CASE WHEN c0_.type < 5 THEN 1 ELSE -1 END)) AS sclr_0, c1_.name AS name_1, c1_.id AS id_2 FROM credit_transaction c0_ INNER JOIN cost_center c1_ ON c0_.cost_center_id = c1_.id WHERE c0_.type IN (1, 2, 6, 7, 11) AND c0_.client_id = ? AND c1_.id = ? AND c0_.state = 1

[
  null
  3
]

SELECT
  SUM(
    c0_.value * (
      CASE WHEN c0_.type < 5 THEN 1 ELSE -1 END
    )
  ) AS sclr_0,
  c1_.name AS name_1,
  c1_.id AS id_2
FROM
  credit_transaction c0_
  INNER JOIN cost_center c1_ ON c0_.cost_center_id = c1_.id
WHERE
  c0_.type IN (1, 2, 6, 7, 11)
  AND c0_.client_id = ?
  AND c1_.id = ?
  AND c0_.state = 1

SELECT SUM(c0_.value * (CASE WHEN c0_.type < 5 THEN 1 ELSE -1 END)) AS sclr_0, c1_.name AS name_1, c1_.id AS id_2 FROM credit_transaction c0_ INNER JOIN cost_center c1_ ON c0_.cost_center_id = c1_.id WHERE c0_.type IN (1, 2, 6, 7, 11) AND c0_.client_id = NULL AND c1_.id = 3 AND c0_.state = 1;

SELECT s0_.id AS id_0, s0_.length AS length_1, s0_.is_active AS is_active_2, s0_.price AS price_3, s0_.name AS name_4, s0_.description AS description_5, s0_.vat AS vat_6 FROM subscription s0_ WHERE s0_.is_active = ? ORDER BY s0_.id ASC

[
  1
]

SELECT
  s0_.id AS id_0,
  s0_.length AS length_1,
  s0_.is_active AS is_active_2,
  s0_.price AS price_3,
  s0_.name AS name_4,
  s0_.description AS description_5,
  s0_.vat AS vat_6
FROM
  subscription s0_
WHERE
  s0_.is_active = ?
ORDER BY
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.length AS length_1, s0_.is_active AS is_active_2, s0_.price AS price_3, s0_.name AS name_4, s0_.description AS description_5, s0_.vat AS vat_6 FROM subscription s0_ WHERE s0_.is_active = 1 ORDER BY s0_.id ASC;

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_super_id WHERE (p0_.id > 10 OR p0_.id = 2) AND p0_.is_menu = 1 GROUP BY p0_.name ORDER BY p0_.sequence ASC

[]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  p0_.slug AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14
FROM
  p_category p0_
  LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_super_id
WHERE
  (
    p0_.id > 10
    OR p0_.id = 2
  )
  AND p0_.is_menu = 1
GROUP BY
  p0_.name
ORDER BY
  p0_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_super_id WHERE (p0_.id > 10 OR p0_.id = 2) AND p0_.is_menu = 1 GROUP BY p0_.name ORDER BY p0_.sequence ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15 FROM p_category t0 WHERE t0.slug = ? LIMIT 1

[
  "robots.txt"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.menu_name AS menu_name_3,
  t0.description AS description_4,
  t0.html AS html_5,
  t0.title AS title_6,
  t0.is_active AS is_active_7,
  t0.slug AS slug_8,
  t0.javascript AS javascript_9,
  t0.sequence AS sequence_10,
  t0.is_menu AS is_menu_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.state AS state_14,
  t0.has_comments AS has_comments_15
FROM
  p_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15 FROM p_category t0 WHERE t0.slug = 'robots.txt' LIMIT 1;