Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Serializer
• Redis
• Payum
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.customer_id AS customer_id_4 FROM carts t0 WHERE t0.id = ?

[
  "019bf046-4095-7e03-bf95-f0b140e902ba"
]

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.created_at AS created_at_3,
  t0.customer_id AS customer_id_4
FROM
  carts t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.customer_id AS customer_id_4 FROM carts t0 WHERE t0.id = '019bf046-4095-7e03-bf95-f0b140e902ba';

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.customer_id AS customer_id_4 FROM wishlists t0 WHERE t0.id = ?

[
  "019bf046-409e-7bc3-861f-6dfe50c03dbb"
]

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.created_at AS created_at_3,
  t0.customer_id AS customer_id_4
FROM
  wishlists t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.customer_id AS customer_id_4 FROM wishlists t0 WHERE t0.id = '019bf046-409e-7bc3-861f-6dfe50c03dbb';

SELECT a.id as attr_id, a.code, a.name_ru, a.name_de, 
			av.uid, av.id as value_id, av.name_ru as value_name_ru, av.name_de as value_name_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.code = 'serie' AND av.id=53024

[]

SELECT
  a.id as attr_id,
  a.code,
  a.name_ru,
  a.name_de,
  av.uid,
  av.id as value_id,
  av.name_ru as value_name_ru,
  av.name_de as value_name_de
FROM
  attribute_value AS av
  JOIN attribute AS a on a.code = av.code
WHERE
  av.code = 'serie'
  AND av.id = 53024

SELECT a.id as attr_id, a.code, a.name_ru, a.name_de, 
			av.uid, av.id as value_id, av.name_ru as value_name_ru, av.name_de as value_name_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.code = 'serie' AND av.id=53024 ;

SELECT a.id as group_id, a.code, a.name_ru, a.name_de, a.sort, 
			a.is_metric, a.is_deeplink, a.is_filterable, a.use_deeplink_code, 
			a.group_sort, a.group_name_ru, a.group_name_de,
			av.uid as value_id,  av.name_ru as value_ru, av.name_de as value_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.uid IN('family_238','netto_fuellmenge_filter_1','netto_gewicht_filter_3','verwendungszweck_1782','verwendungszweck_2251','verwendungszweck_2264','altergruppierung_5964','geschlecht_66','hauttyp_2285','volumen_2487','anwendungszeit_2286','anwendungszeit_2287','serie_53024','anwendungsgebiet_30906','vendor_46') AND  a.is_filterable = true

[]

SELECT
  a.id as group_id,
  a.code,
  a.name_ru,
  a.name_de,
  a.sort,
  a.is_metric,
  a.is_deeplink,
  a.is_filterable,
  a.use_deeplink_code,
  a.group_sort,
  a.group_name_ru,
  a.group_name_de,
  av.uid as value_id,
  av.name_ru as value_ru,
  av.name_de as value_de
FROM
  attribute_value AS av
  JOIN attribute AS a on a.code = av.code
WHERE
  av.uid IN(
    'family_238', 'netto_fuellmenge_filter_1',
    'netto_gewicht_filter_3', 'verwendungszweck_1782',
    'verwendungszweck_2251', 'verwendungszweck_2264',
    'altergruppierung_5964', 'geschlecht_66',
    'hauttyp_2285', 'volumen_2487',
    'anwendungszeit_2286', 'anwendungszeit_2287',
    'serie_53024', 'anwendungsgebiet_30906',
    'vendor_46'
  )
  AND a.is_filterable = true

SELECT a.id as group_id, a.code, a.name_ru, a.name_de, a.sort, 
			a.is_metric, a.is_deeplink, a.is_filterable, a.use_deeplink_code, 
			a.group_sort, a.group_name_ru, a.group_name_de,
			av.uid as value_id,  av.name_ru as value_ru, av.name_de as value_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.uid IN('family_238','netto_fuellmenge_filter_1','netto_gewicht_filter_3','verwendungszweck_1782','verwendungszweck_2251','verwendungszweck_2264','altergruppierung_5964','geschlecht_66','hauttyp_2285','volumen_2487','anwendungszeit_2286','anwendungszeit_2287','serie_53024','anwendungsgebiet_30906','vendor_46') AND  a.is_filterable = true;

SELECT code FROM attribute WHERE is_filterable = true

[]

SELECT
  code
FROM
  attribute
WHERE
  is_filterable = true

SELECT code FROM attribute WHERE is_filterable = true;