Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 187
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Emails
• Notifications
• Serializer
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.shop_id AS shop_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1

[
  "rate_eur_czk"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.shop_id AS shop_id_4
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.shop_id AS shop_id_4 FROM configuration t0 WHERE t0.name = 'rate_eur_czk' LIMIT 1;

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.content AS content_2, m0_.valid_to AS valid_to_3, m0_.created_at AS created_at_4, m0_.severity AS severity_5, m0_.valid_from AS valid_from_6, m0_.active AS active_7, m0_.display_homepage AS display_homepage_8, m0_.display_on_side AS display_on_side_9, m0_.position AS position_10, m0_.author_id AS author_id_11 FROM message m0_ WHERE m0_.active = ? AND m0_.display_on_side = ? AND m0_.valid_from <= ? AND m0_.valid_to >= ? ORDER BY m0_.position ASC LIMIT 100

[
  1
  1
  "2025-04-02 00:19:06"
  "2025-04-02 00:19:06"
]

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.content AS content_2,
  m0_.valid_to AS valid_to_3,
  m0_.created_at AS created_at_4,
  m0_.severity AS severity_5,
  m0_.valid_from AS valid_from_6,
  m0_.active AS active_7,
  m0_.display_homepage AS display_homepage_8,
  m0_.display_on_side AS display_on_side_9,
  m0_.position AS position_10,
  m0_.author_id AS author_id_11
FROM
  message m0_
WHERE
  m0_.active = ?
  AND m0_.display_on_side = ?
  AND m0_.valid_from <= ?
  AND m0_.valid_to >= ?
ORDER BY
  m0_.position ASC
LIMIT
  100

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.content AS content_2, m0_.valid_to AS valid_to_3, m0_.created_at AS created_at_4, m0_.severity AS severity_5, m0_.valid_from AS valid_from_6, m0_.active AS active_7, m0_.display_homepage AS display_homepage_8, m0_.display_on_side AS display_on_side_9, m0_.position AS position_10, m0_.author_id AS author_id_11 FROM message m0_ WHERE m0_.active = 1 AND m0_.display_on_side = 1 AND m0_.valid_from <= '2025-04-02 00:19:06' AND m0_.valid_to >= '2025-04-02 00:19:06' ORDER BY m0_.position ASC LIMIT 100;

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.company AS company_4, t0.ico AS ico_5, t0.dic AS dic_6, t0.phone AS phone_7, t0.zip AS zip_8, t0.country AS country_9, t0.billing_country AS billing_country_10, t0.billing_zip AS billing_zip_11, t0.email AS email_12, t0.street AS street_13, t0.city AS city_14, t0.billing_street AS billing_street_15, t0.billing_city AS billing_city_16, t0.trx AS trx_17, t0.paid AS paid_18, t0.status AS status_19, t0.synchro_status AS synchro_status_20, t0.current_curency AS current_curency_21, t0.exchange_rate AS exchange_rate_22, t0.synchronize_count AS synchronize_count_23, t0.customer_note AS customer_note_24, t0.partner_code AS partner_code_25, t0.center_nr AS center_nr_26, t0.admin_note AS admin_note_27, t0.created AS created_28, t0.in_raynet AS in_raynet_29, t0.discount AS discount_30, t0.simple_order AS simple_order_31, t0.process_check_time AS process_check_time_32, t0.shop_id AS shop_id_33, t0.user_id AS user_id_34, t0.impersonator_id AS impersonator_id_35 FROM sale_order t0 WHERE t0.status = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.company AS company_4,
  t0.ico AS ico_5,
  t0.dic AS dic_6,
  t0.phone AS phone_7,
  t0.zip AS zip_8,
  t0.country AS country_9,
  t0.billing_country AS billing_country_10,
  t0.billing_zip AS billing_zip_11,
  t0.email AS email_12,
  t0.street AS street_13,
  t0.city AS city_14,
  t0.billing_street AS billing_street_15,
  t0.billing_city AS billing_city_16,
  t0.trx AS trx_17,
  t0.paid AS paid_18,
  t0.status AS status_19,
  t0.synchro_status AS synchro_status_20,
  t0.current_curency AS current_curency_21,
  t0.exchange_rate AS exchange_rate_22,
  t0.synchronize_count AS synchronize_count_23,
  t0.customer_note AS customer_note_24,
  t0.partner_code AS partner_code_25,
  t0.center_nr AS center_nr_26,
  t0.admin_note AS admin_note_27,
  t0.created AS created_28,
  t0.in_raynet AS in_raynet_29,
  t0.discount AS discount_30,
  t0.simple_order AS simple_order_31,
  t0.process_check_time AS process_check_time_32,
  t0.shop_id AS shop_id_33,
  t0.user_id AS user_id_34,
  t0.impersonator_id AS impersonator_id_35
FROM
  sale_order t0
WHERE
  t0.status = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.company AS company_4, t0.ico AS ico_5, t0.dic AS dic_6, t0.phone AS phone_7, t0.zip AS zip_8, t0.country AS country_9, t0.billing_country AS billing_country_10, t0.billing_zip AS billing_zip_11, t0.email AS email_12, t0.street AS street_13, t0.city AS city_14, t0.billing_street AS billing_street_15, t0.billing_city AS billing_city_16, t0.trx AS trx_17, t0.paid AS paid_18, t0.status AS status_19, t0.synchro_status AS synchro_status_20, t0.current_curency AS current_curency_21, t0.exchange_rate AS exchange_rate_22, t0.synchronize_count AS synchronize_count_23, t0.customer_note AS customer_note_24, t0.partner_code AS partner_code_25, t0.center_nr AS center_nr_26, t0.admin_note AS admin_note_27, t0.created AS created_28, t0.in_raynet AS in_raynet_29, t0.discount AS discount_30, t0.simple_order AS simple_order_31, t0.process_check_time AS process_check_time_32, t0.shop_id AS shop_id_33, t0.user_id AS user_id_34, t0.impersonator_id AS impersonator_id_35 FROM sale_order t0 WHERE t0.status = 1;

SELECT COUNT(s0_.id) AS sclr_0 FROM sale_order s0_ WHERE s0_.status = ?

[
  1
]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sale_order s0_
WHERE
  s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sale_order s0_ WHERE s0_.status = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.shop_id AS shop_id_4 FROM configuration t0 WHERE t0.shop_id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.shop_id AS shop_id_4
FROM
  configuration t0
WHERE
  t0.shop_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.shop_id AS shop_id_4 FROM configuration t0 WHERE t0.shop_id = 4;

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.currency_id AS currency_id_4 FROM shop t0 WHERE t0.domain = ?

[
  "shop.zebra-systems.com"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domain AS domain_3,
  t0.currency_id AS currency_id_4
FROM
  shop t0
WHERE
  t0.domain = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.currency_id AS currency_id_4 FROM shop t0 WHERE t0.domain = 'shop.zebra-systems.com';