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.country AS country_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.customer_id AS customer_id_5, t0.last_order_id AS last_order_id_6 FROM carts t0 WHERE t0.id = ?

[
  "01a10bfa-1ddf-7047-b457-90399695adf0"
]

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.updated_at AS updated_at_3,
  t0.created_at AS created_at_4,
  t0.customer_id AS customer_id_5,
  t0.last_order_id AS last_order_id_6
FROM
  carts t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.country AS country_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.customer_id AS customer_id_5, t0.last_order_id AS last_order_id_6 FROM carts t0 WHERE t0.id = '01a10bfa-1ddf-7047-b457-90399695adf0';

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

[
  "01a10bfa-1de9-7973-9231-3d0cd8142547"
]

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 = '01a10bfa-1de9-7973-9231-3d0cd8142547';

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('coolbox_filter_0','freezebox_filter_3','sparset_filter_0','family_376','family_693','vendor_1258','art_der_suessigkeiten_34384','vendor_196','art_der_suessigkeiten_35208','vendor_1292','vendor_1240','vendor_267','art_der_suessigkeiten_39991','art_der_suessigkeiten_40018','vendor_1440','vendor_158','vendor_216','vendor_230','art_der_suessigkeiten_34102','family_594','family_716','serie_33808','sparset_filter_1','vendor_114','vendor_1232','vendor_134','vendor_1433','vendor_1441','vendor_152','vendor_156','vendor_162','vendor_441','vendor_685','vendor_695') 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(
    'coolbox_filter_0', 'freezebox_filter_3',
    'sparset_filter_0', 'family_376',
    'family_693', 'vendor_1258', 'art_der_suessigkeiten_34384',
    'vendor_196', 'art_der_suessigkeiten_35208',
    'vendor_1292', 'vendor_1240', 'vendor_267',
    'art_der_suessigkeiten_39991',
    'art_der_suessigkeiten_40018',
    'vendor_1440', 'vendor_158', 'vendor_216',
    'vendor_230', 'art_der_suessigkeiten_34102',
    'family_594', 'family_716', 'serie_33808',
    'sparset_filter_1', 'vendor_114',
    'vendor_1232', 'vendor_134', 'vendor_1433',
    'vendor_1441', 'vendor_152', 'vendor_156',
    'vendor_162', 'vendor_441', 'vendor_685',
    'vendor_695'
  )
  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('coolbox_filter_0','freezebox_filter_3','sparset_filter_0','family_376','family_693','vendor_1258','art_der_suessigkeiten_34384','vendor_196','art_der_suessigkeiten_35208','vendor_1292','vendor_1240','vendor_267','art_der_suessigkeiten_39991','art_der_suessigkeiten_40018','vendor_1440','vendor_158','vendor_216','vendor_230','art_der_suessigkeiten_34102','family_594','family_716','serie_33808','sparset_filter_1','vendor_114','vendor_1232','vendor_134','vendor_1433','vendor_1441','vendor_152','vendor_156','vendor_162','vendor_441','vendor_685','vendor_695') AND  a.is_filterable = true;