Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.vat AS vat_4, t0.fiscal_code AS fiscal_code_5, t0.address AS address_6, t0.zip AS zip_7, t0.city AS city_8, t0.country AS country_9, t0.email AS email_10, t0.phone AS phone_11, t0.website AS website_12, t0.logo_path AS logo_path_13, t0.directory_name AS directory_name_14, t0.warranty_email AS warranty_email_15, t16.id AS id_17, t16.logo_path AS logo_path_18, t16.splash_path AS splash_path_19, t16.color_splash_back AS color_splash_back_20, t16.color_back AS color_back_21, t16.brand_id AS brand_id_22 FROM prim_brand t0 LEFT JOIN prim_application t16 ON t16.brand_id = t0.id WHERE t0.id = ? LIMIT 1

[
  "1"
]

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.vat AS vat_4,
  t0.fiscal_code AS fiscal_code_5,
  t0.address AS address_6,
  t0.zip AS zip_7,
  t0.city AS city_8,
  t0.country AS country_9,
  t0.email AS email_10,
  t0.phone AS phone_11,
  t0.website AS website_12,
  t0.logo_path AS logo_path_13,
  t0.directory_name AS directory_name_14,
  t0.warranty_email AS warranty_email_15,
  t16.id AS id_17,
  t16.logo_path AS logo_path_18,
  t16.splash_path AS splash_path_19,
  t16.color_splash_back AS color_splash_back_20,
  t16.color_back AS color_back_21,
  t16.brand_id AS brand_id_22
FROM
  prim_brand t0
  LEFT JOIN prim_application t16 ON t16.brand_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.vat AS vat_4, t0.fiscal_code AS fiscal_code_5, t0.address AS address_6, t0.zip AS zip_7, t0.city AS city_8, t0.country AS country_9, t0.email AS email_10, t0.phone AS phone_11, t0.website AS website_12, t0.logo_path AS logo_path_13, t0.directory_name AS directory_name_14, t0.warranty_email AS warranty_email_15, t16.id AS id_17, t16.logo_path AS logo_path_18, t16.splash_path AS splash_path_19, t16.color_splash_back AS color_splash_back_20, t16.color_back AS color_back_21, t16.brand_id AS brand_id_22 FROM prim_brand t0 LEFT JOIN prim_application t16 ON t16.brand_id = t0.id WHERE t0.id = '1' LIMIT 1;

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_producer p0_ LEFT JOIN prim_join_table_brand_producer p2_ ON p0_.id = p2_.producer_id LEFT JOIN prim_brand p1_ ON p1_.id = p2_.brand_id WHERE p1_.id = ?

[
  "1"
]

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  prim_producer p0_
  LEFT JOIN prim_join_table_brand_producer p2_ ON p0_.id = p2_.producer_id
  LEFT JOIN prim_brand p1_ ON p1_.id = p2_.brand_id
WHERE
  p1_.id = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_producer p0_ LEFT JOIN prim_join_table_brand_producer p2_ ON p0_.id = p2_.producer_id LEFT JOIN prim_brand p1_ ON p1_.id = p2_.brand_id WHERE p1_.id = '1';

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1 FROM prim_producer p0_ LEFT JOIN prim_join_table_brand_producer p2_ ON p0_.id = p2_.producer_id LEFT JOIN prim_brand p1_ ON p1_.id = p2_.brand_id WHERE p1_.id = ? ORDER BY p0_.name ASC LIMIT 30

[
  "1"
]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.name AS name_1
FROM
  prim_producer p0_
  LEFT JOIN prim_join_table_brand_producer p2_ ON p0_.id = p2_.producer_id
  LEFT JOIN prim_brand p1_ ON p1_.id = p2_.brand_id
WHERE
  p1_.id = ?
ORDER BY
  p0_.name ASC
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1 FROM prim_producer p0_ LEFT JOIN prim_join_table_brand_producer p2_ ON p0_.id = p2_.producer_id LEFT JOIN prim_brand p1_ ON p1_.id = p2_.brand_id WHERE p1_.id = '1' ORDER BY p0_.name ASC LIMIT 30;

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.vat AS vat_2, p0_.fiscal_code AS fiscal_code_3, p0_.address AS address_4, p0_.zip AS zip_5, p0_.city AS city_6, p0_.country AS country_7, p0_.email AS email_8, p0_.phone AS phone_9, p0_.website AS website_10 FROM prim_producer p0_ LEFT JOIN prim_join_table_brand_producer p2_ ON p0_.id = p2_.producer_id LEFT JOIN prim_brand p1_ ON p1_.id = p2_.brand_id WHERE p1_.id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.name ASC

[
  "1"
  "88"
  "119"
  "347"
  "346"
  "350"
  "84"
  "265"
  "149"
  "71"
  "102"
  "190"
  "262"
  "157"
  "93"
  "151"
  "292"
  "284"
  "116"
  "171"
  "194"
  "99"
  "367"
  "294"
  "239"
  "349"
  "30"
  "235"
  "274"
  "155"
  "27"
]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.vat AS vat_2,
  p0_.fiscal_code AS fiscal_code_3,
  p0_.address AS address_4,
  p0_.zip AS zip_5,
  p0_.city AS city_6,
  p0_.country AS country_7,
  p0_.email AS email_8,
  p0_.phone AS phone_9,
  p0_.website AS website_10
FROM
  prim_producer p0_
  LEFT JOIN prim_join_table_brand_producer p2_ ON p0_.id = p2_.producer_id
  LEFT JOIN prim_brand p1_ ON p1_.id = p2_.brand_id
WHERE
  p1_.id = ?
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.vat AS vat_2, p0_.fiscal_code AS fiscal_code_3, p0_.address AS address_4, p0_.zip AS zip_5, p0_.city AS city_6, p0_.country AS country_7, p0_.email AS email_8, p0_.phone AS phone_9, p0_.website AS website_10 FROM prim_producer p0_ LEFT JOIN prim_join_table_brand_producer p2_ ON p0_.id = p2_.producer_id LEFT JOIN prim_brand p1_ ON p1_.id = p2_.brand_id WHERE p1_.id = '1' AND p0_.id IN ('88', '119', '347', '346', '350', '84', '265', '149', '71', '102', '190', '262', '157', '93', '151', '292', '284', '116', '171', '194', '99', '367', '294', '239', '349', '30', '235', '274', '155', '27') ORDER BY p0_.name ASC;

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.vat AS vat_2, p0_.fiscal_code AS fiscal_code_3, p0_.address AS address_4, p0_.zip AS zip_5, p0_.city AS city_6, p0_.country AS country_7, p0_.email AS email_8, p0_.phone AS phone_9, p0_.website AS website_10 FROM prim_producer p0_ ORDER BY p0_.name ASC

[]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.vat AS vat_2,
  p0_.fiscal_code AS fiscal_code_3,
  p0_.address AS address_4,
  p0_.zip AS zip_5,
  p0_.city AS city_6,
  p0_.country AS country_7,
  p0_.email AS email_8,
  p0_.phone AS phone_9,
  p0_.website AS website_10
FROM
  prim_producer p0_
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.vat AS vat_2, p0_.fiscal_code AS fiscal_code_3, p0_.address AS address_4, p0_.zip AS zip_5, p0_.city AS city_6, p0_.country AS country_7, p0_.email AS email_8, p0_.phone AS phone_9, p0_.website AS website_10 FROM prim_producer p0_ ORDER BY p0_.name ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.vat AS vat_3, t0.fiscal_code AS fiscal_code_4, t0.address AS address_5, t0.zip AS zip_6, t0.city AS city_7, t0.country AS country_8, t0.email AS email_9, t0.phone AS phone_10, t0.website AS website_11 FROM prim_producer t0 INNER JOIN prim_join_table_brand_producer ON t0.id = prim_join_table_brand_producer.producer_id WHERE prim_join_table_brand_producer.brand_id = ?

[
  "1"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.vat AS vat_3,
  t0.fiscal_code AS fiscal_code_4,
  t0.address AS address_5,
  t0.zip AS zip_6,
  t0.city AS city_7,
  t0.country AS country_8,
  t0.email AS email_9,
  t0.phone AS phone_10,
  t0.website AS website_11
FROM
  prim_producer t0
  INNER JOIN prim_join_table_brand_producer ON t0.id = prim_join_table_brand_producer.producer_id
WHERE
  prim_join_table_brand_producer.brand_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.vat AS vat_3, t0.fiscal_code AS fiscal_code_4, t0.address AS address_5, t0.zip AS zip_6, t0.city AS city_7, t0.country AS country_8, t0.email AS email_9, t0.phone AS phone_10, t0.website AS website_11 FROM prim_producer t0 INNER JOIN prim_join_table_brand_producer ON t0.id = prim_join_table_brand_producer.producer_id WHERE prim_join_table_brand_producer.brand_id = '1';