Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 43
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

SELECT m0_.id AS id_0, m0_.last_version AS last_version_1, m0_.last_synced_at AS last_synced_at_2, m0_.stop_list_updated_at AS stop_list_updated_at_3, m0_.catalog_revision AS catalog_revision_4 FROM menu_sync_state m0_ ORDER BY m0_.id ASC LIMIT 1

[]

SELECT
  m0_.id AS id_0,
  m0_.last_version AS last_version_1,
  m0_.last_synced_at AS last_synced_at_2,
  m0_.stop_list_updated_at AS stop_list_updated_at_3,
  m0_.catalog_revision AS catalog_revision_4
FROM
  menu_sync_state m0_
ORDER BY
  m0_.id ASC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.last_version AS last_version_1, m0_.last_synced_at AS last_synced_at_2, m0_.stop_list_updated_at AS stop_list_updated_at_3, m0_.catalog_revision AS catalog_revision_4 FROM menu_sync_state m0_ ORDER BY m0_.id ASC LIMIT 1;

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dishes d0_ INNER JOIN dish_category_link d2_ ON d0_.id = d2_.dish_id INNER JOIN dish_categories d1_ ON d1_.id = d2_.dish_category_id WHERE d1_.is_visible = 1 AND d0_.is_visible = 1 AND d0_.keeper_deleted_at IS NULL

[]

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  dishes d0_
  INNER JOIN dish_category_link d2_ ON d0_.id = d2_.dish_id
  INNER JOIN dish_categories d1_ ON d1_.id = d2_.dish_category_id
WHERE
  d1_.is_visible = 1
  AND d0_.is_visible = 1
  AND d0_.keeper_deleted_at IS NULL

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dishes d0_ INNER JOIN dish_category_link d2_ ON d0_.id = d2_.dish_id INNER JOIN dish_categories d1_ ON d1_.id = d2_.dish_category_id WHERE d1_.is_visible = 1 AND d0_.is_visible = 1 AND d0_.keeper_deleted_at IS NULL;

SELECT MAX(d0_.updated_at) AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dish_categories d0_ WHERE d0_.is_visible = 1

[]

SELECT
  MAX(d0_.updated_at) AS sclr_0,
  COUNT(d0_.id) AS sclr_1
FROM
  dish_categories d0_
WHERE
  d0_.is_visible = 1

SELECT MAX(d0_.updated_at) AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dish_categories d0_ WHERE d0_.is_visible = 1;

SELECT m0_.id AS id_0, m0_.last_version AS last_version_1, m0_.last_synced_at AS last_synced_at_2, m0_.stop_list_updated_at AS stop_list_updated_at_3, m0_.catalog_revision AS catalog_revision_4 FROM menu_sync_state m0_ ORDER BY m0_.id ASC LIMIT 1

[]

SELECT
  m0_.id AS id_0,
  m0_.last_version AS last_version_1,
  m0_.last_synced_at AS last_synced_at_2,
  m0_.stop_list_updated_at AS stop_list_updated_at_3,
  m0_.catalog_revision AS catalog_revision_4
FROM
  menu_sync_state m0_
ORDER BY
  m0_.id ASC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.last_version AS last_version_1, m0_.last_synced_at AS last_synced_at_2, m0_.stop_list_updated_at AS stop_list_updated_at_3, m0_.catalog_revision AS catalog_revision_4 FROM menu_sync_state m0_ ORDER BY m0_.id ASC LIMIT 1;

SELECT t0.id AS id_1, t0.keeper_id AS keeper_id_2, t0.keeper_guid AS keeper_guid_3, t0.name AS name_4, t0.price AS price_5, t0.is_stop AS is_stop_6, t0.keeper_deleted_at AS keeper_deleted_at_7, t0.last_synced_at AS last_synced_at_8, t0.keeper_description AS keeper_description_9, t0.description AS description_10, t0.photo_name AS photo_name_11, t0.is_visible AS is_visible_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM dishes t0

[]

SELECT
  t0.id AS id_1,
  t0.keeper_id AS keeper_id_2,
  t0.keeper_guid AS keeper_guid_3,
  t0.name AS name_4,
  t0.price AS price_5,
  t0.is_stop AS is_stop_6,
  t0.keeper_deleted_at AS keeper_deleted_at_7,
  t0.last_synced_at AS last_synced_at_8,
  t0.keeper_description AS keeper_description_9,
  t0.description AS description_10,
  t0.photo_name AS photo_name_11,
  t0.is_visible AS is_visible_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14
FROM
  dishes t0

SELECT t0.id AS id_1, t0.keeper_id AS keeper_id_2, t0.keeper_guid AS keeper_guid_3, t0.name AS name_4, t0.price AS price_5, t0.is_stop AS is_stop_6, t0.keeper_deleted_at AS keeper_deleted_at_7, t0.last_synced_at AS last_synced_at_8, t0.keeper_description AS keeper_description_9, t0.description AS description_10, t0.photo_name AS photo_name_11, t0.is_visible AS is_visible_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM dishes t0;

SELECT m0_.id AS id_0, m0_.last_version AS last_version_1, m0_.last_synced_at AS last_synced_at_2, m0_.stop_list_updated_at AS stop_list_updated_at_3, m0_.catalog_revision AS catalog_revision_4 FROM menu_sync_state m0_ ORDER BY m0_.id ASC LIMIT 1

[]

SELECT
  m0_.id AS id_0,
  m0_.last_version AS last_version_1,
  m0_.last_synced_at AS last_synced_at_2,
  m0_.stop_list_updated_at AS stop_list_updated_at_3,
  m0_.catalog_revision AS catalog_revision_4
FROM
  menu_sync_state m0_
ORDER BY
  m0_.id ASC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.last_version AS last_version_1, m0_.last_synced_at AS last_synced_at_2, m0_.stop_list_updated_at AS stop_list_updated_at_3, m0_.catalog_revision AS catalog_revision_4 FROM menu_sync_state m0_ ORDER BY m0_.id ASC LIMIT 1;

SELECT s0_.id AS id_0, s0_.keeper_url AS keeper_url_1, s0_.keeper_listen_url AS keeper_listen_url_2, s0_.keeper_token AS keeper_token_3, s0_.object_id AS object_id_4, s0_.rkeeper_callback_secret AS rkeeper_callback_secret_5, s0_.payment_currency_guid AS payment_currency_guid_6, s0_.default_table_code AS default_table_code_7, s0_.rkeeper_rate_limit_per_min AS rkeeper_rate_limit_per_min_8, s0_.rkeeper_event_driven AS rkeeper_event_driven_9, s0_.stop_list_poll_sec AS stop_list_poll_sec_10, s0_.order_cancel_window_sec AS order_cancel_window_sec_11, s0_.time_window_grace_sec AS time_window_grace_sec_12, s0_.restaurant_timezone AS restaurant_timezone_13, s0_.max_bot_token AS max_bot_token_14, s0_.device_api_key AS device_api_key_15, s0_.sentry_info_logs AS sentry_info_logs_16, s0_.kiosk_sentry_investigation AS kiosk_sentry_investigation_17, s0_.vtb_tips_enabled AS vtb_tips_enabled_18, s0_.vtb_compliment_bid AS vtb_compliment_bid_19, s0_.vtb_merchant_id AS vtb_merchant_id_20, s0_.show_webhook_log AS show_webhook_log_21 FROM settings s0_ ORDER BY s0_.id ASC LIMIT 1

[]

SELECT
  s0_.id AS id_0,
  s0_.keeper_url AS keeper_url_1,
  s0_.keeper_listen_url AS keeper_listen_url_2,
  s0_.keeper_token AS keeper_token_3,
  s0_.object_id AS object_id_4,
  s0_.rkeeper_callback_secret AS rkeeper_callback_secret_5,
  s0_.payment_currency_guid AS payment_currency_guid_6,
  s0_.default_table_code AS default_table_code_7,
  s0_.rkeeper_rate_limit_per_min AS rkeeper_rate_limit_per_min_8,
  s0_.rkeeper_event_driven AS rkeeper_event_driven_9,
  s0_.stop_list_poll_sec AS stop_list_poll_sec_10,
  s0_.order_cancel_window_sec AS order_cancel_window_sec_11,
  s0_.time_window_grace_sec AS time_window_grace_sec_12,
  s0_.restaurant_timezone AS restaurant_timezone_13,
  s0_.max_bot_token AS max_bot_token_14,
  s0_.device_api_key AS device_api_key_15,
  s0_.sentry_info_logs AS sentry_info_logs_16,
  s0_.kiosk_sentry_investigation AS kiosk_sentry_investigation_17,
  s0_.vtb_tips_enabled AS vtb_tips_enabled_18,
  s0_.vtb_compliment_bid AS vtb_compliment_bid_19,
  s0_.vtb_merchant_id AS vtb_merchant_id_20,
  s0_.show_webhook_log AS show_webhook_log_21
FROM
  settings s0_
ORDER BY
  s0_.id ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.keeper_url AS keeper_url_1, s0_.keeper_listen_url AS keeper_listen_url_2, s0_.keeper_token AS keeper_token_3, s0_.object_id AS object_id_4, s0_.rkeeper_callback_secret AS rkeeper_callback_secret_5, s0_.payment_currency_guid AS payment_currency_guid_6, s0_.default_table_code AS default_table_code_7, s0_.rkeeper_rate_limit_per_min AS rkeeper_rate_limit_per_min_8, s0_.rkeeper_event_driven AS rkeeper_event_driven_9, s0_.stop_list_poll_sec AS stop_list_poll_sec_10, s0_.order_cancel_window_sec AS order_cancel_window_sec_11, s0_.time_window_grace_sec AS time_window_grace_sec_12, s0_.restaurant_timezone AS restaurant_timezone_13, s0_.max_bot_token AS max_bot_token_14, s0_.device_api_key AS device_api_key_15, s0_.sentry_info_logs AS sentry_info_logs_16, s0_.kiosk_sentry_investigation AS kiosk_sentry_investigation_17, s0_.vtb_tips_enabled AS vtb_tips_enabled_18, s0_.vtb_compliment_bid AS vtb_compliment_bid_19, s0_.vtb_merchant_id AS vtb_merchant_id_20, s0_.show_webhook_log AS show_webhook_log_21 FROM settings s0_ ORDER BY s0_.id ASC LIMIT 1;

SELECT MAX(i0_.updated_at) AS sclr_0, COUNT(i0_.id) AS sclr_1 FROM idle_materials i0_ WHERE i0_.is_active = 1 AND i0_.file_name IS NOT NULL AND ((i0_.type = ? OR i0_.file_name LIKE ?))

[
  "image"
  "%.webm"
]

SELECT
  MAX(i0_.updated_at) AS sclr_0,
  COUNT(i0_.id) AS sclr_1
FROM
  idle_materials i0_
WHERE
  i0_.is_active = 1
  AND i0_.file_name IS NOT NULL
  AND (
    (
      i0_.type = ?
      OR i0_.file_name LIKE ?
    )
  )

SELECT MAX(i0_.updated_at) AS sclr_0, COUNT(i0_.id) AS sclr_1 FROM idle_materials i0_ WHERE i0_.is_active = 1 AND i0_.file_name IS NOT NULL AND ((i0_.type = 'image' OR i0_.file_name LIKE '%.webm'));