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.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';

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 OFFSET 180

[
  "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
OFFSET
  180

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 OFFSET 180;

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 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 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 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"
  "104"
  "126"
  "134"
  "285"
  "193"
  "73"
  "206"
  "110"
  "167"
  "191"
  "290"
  "10"
  "147"
  "37"
  "145"
  "287"
  "252"
  "267"
  "304"
  "41"
  "164"
  "174"
  "3"
  "316"
  "44"
  "56"
  "228"
  "196"
  "276"
  "243"
]

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 ('104', '126', '134', '285', '193', '73', '206', '110', '167', '191', '290', '10', '147', '37', '145', '287', '252', '267', '304', '41', '164', '174', '3', '316', '44', '56', '228', '196', '276', '243') ORDER BY p0_.name ASC;