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

[
  "019bf25b-03a4-7c3f-ae4d-e67f5ab67f35"
]

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 = '019bf25b-03a4-7c3f-ae4d-e67f5ab67f35';

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

[
  "019bf25b-03af-7a14-9430-c3845a0b4341"
]

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 = '019bf25b-03af-7a14-9430-c3845a0b4341';

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

[]

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

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

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_61','netto_gewicht_filter_4','geschlecht_65','farbgruppierung_576','farbgruppierung_588','materialgruppierung_1535','volumen_2164','hoehe_3085','verpackung_3948','inschrift_23460','serie_36815','modelname_36816','modelname_36817','modelname_36818','modelname_36819','modelname_36820','feiertage_826','modelname_36821','modelname_36822','modelname_36823','modelname_36824','modelname_36825','modelname_36826','modelname_36827','modelname_54145','beschriftungssprache_25380','farbgruppierung_579','modelname_36723') 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_61', 'netto_gewicht_filter_4',
    'geschlecht_65', 'farbgruppierung_576',
    'farbgruppierung_588', 'materialgruppierung_1535',
    'volumen_2164', 'hoehe_3085', 'verpackung_3948',
    'inschrift_23460', 'serie_36815',
    'modelname_36816', 'modelname_36817',
    'modelname_36818', 'modelname_36819',
    'modelname_36820', 'feiertage_826',
    'modelname_36821', 'modelname_36822',
    'modelname_36823', 'modelname_36824',
    'modelname_36825', 'modelname_36826',
    'modelname_36827', 'modelname_54145',
    'beschriftungssprache_25380', 'farbgruppierung_579',
    'modelname_36723'
  )
  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_61','netto_gewicht_filter_4','geschlecht_65','farbgruppierung_576','farbgruppierung_588','materialgruppierung_1535','volumen_2164','hoehe_3085','verpackung_3948','inschrift_23460','serie_36815','modelname_36816','modelname_36817','modelname_36818','modelname_36819','modelname_36820','feiertage_826','modelname_36821','modelname_36822','modelname_36823','modelname_36824','modelname_36825','modelname_36826','modelname_36827','modelname_54145','beschriftungssprache_25380','farbgruppierung_579','modelname_36723') 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;