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 = ?

[
  "019befa2-1d2f-77ef-9558-5628c220c98b"
]

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 = '019befa2-1d2f-77ef-9558-5628c220c98b';

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 = ?

[
  "019befa2-1d3a-7157-bd29-0dc9a621c804"
]

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 = '019befa2-1d3a-7157-bd29-0dc9a621c804';

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=42642

[]

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 = 42642

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=42642 ;

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_214','netto_fuellmenge_filter_5','netto_gewicht_filter_5','verwendungszweck_146','verwendungszweck_2251','verwendungszweck_2257','verwendungszweck_2258','volumen_2490','haar_typ_1819','anwendungszeit_2288','serie_42642','anwendungsgebiet_30890','vendor_1367') 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_214', 'netto_fuellmenge_filter_5',
    'netto_gewicht_filter_5', 'verwendungszweck_146',
    'verwendungszweck_2251', 'verwendungszweck_2257',
    'verwendungszweck_2258', 'volumen_2490',
    'haar_typ_1819', 'anwendungszeit_2288',
    'serie_42642', 'anwendungsgebiet_30890',
    'vendor_1367'
  )
  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_214','netto_fuellmenge_filter_5','netto_gewicht_filter_5','verwendungszweck_146','verwendungszweck_2251','verwendungszweck_2257','verwendungszweck_2258','volumen_2490','haar_typ_1819','anwendungszeit_2288','serie_42642','anwendungsgebiet_30890','vendor_1367') 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;