Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Typesense
• Logs 591
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• Twig Components
• Doctrine
• HTTP Client
• Debug
• Httplug 0/0
• Messages
• Redis
• Blocks 0
• JMS Serializer 0
• Emails
• Workflow
• VichUploader
• Configuration

Query Metrics

SELECT t0.section AS section_1, t0.name AS name_2, t0.value AS value_3 FROM craue_config_setting t0 WHERE t0.name = ? LIMIT 1

[
  "motto"
]

SELECT
  t0.section AS section_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  craue_config_setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.section AS section_1, t0.name AS name_2, t0.value AS value_3 FROM craue_config_setting t0 WHERE t0.name = 'motto' LIMIT 1;

SELECT r0_.type AS type_0, COUNT(r0_.id) AS sclr_1 FROM restaurant r0_ WHERE (r0_.enabled = '1') AND (r0_.deleted_at IS NULL) GROUP BY r0_.type ORDER BY sclr_1 DESC

[]

SELECT
  r0_.type AS type_0,
  COUNT(r0_.id) AS sclr_1
FROM
  restaurant r0_
WHERE
  (r0_.enabled = '1')
  AND (r0_.deleted_at IS NULL)
GROUP BY
  r0_.type
ORDER BY
  sclr_1 DESC

SELECT r0_.type AS type_0, COUNT(r0_.id) AS sclr_1 FROM restaurant r0_ WHERE (r0_.enabled = '1') AND (r0_.deleted_at IS NULL) GROUP BY r0_.type ORDER BY sclr_1 DESC;

SELECT c0_.name AS name_0, COUNT(r1_.id) AS sclr_1 FROM restaurant r1_ INNER JOIN restaurant_cuisine r2_ ON r1_.id = r2_.restaurant_id INNER JOIN cuisine c0_ ON c0_.id = r2_.cuisine_id WHERE (r1_.enabled = '1') AND (r1_.deleted_at IS NULL) GROUP BY c0_.name ORDER BY sclr_1 DESC

[]

SELECT
  c0_.name AS name_0,
  COUNT(r1_.id) AS sclr_1
FROM
  restaurant r1_
  INNER JOIN restaurant_cuisine r2_ ON r1_.id = r2_.restaurant_id
  INNER JOIN cuisine c0_ ON c0_.id = r2_.cuisine_id
WHERE
  (r1_.enabled = '1')
  AND (r1_.deleted_at IS NULL)
GROUP BY
  c0_.name
ORDER BY
  sclr_1 DESC

SELECT c0_.name AS name_0, COUNT(r1_.id) AS sclr_1 FROM restaurant r1_ INNER JOIN restaurant_cuisine r2_ ON r1_.id = r2_.restaurant_id INNER JOIN cuisine c0_ ON c0_.id = r2_.cuisine_id WHERE (r1_.enabled = '1') AND (r1_.deleted_at IS NULL) GROUP BY c0_.name ORDER BY sclr_1 DESC;

SELECT d0_.with_vehicle AS with_vehicle_0, d0_.with_weight AS with_weight_1, d0_.show_homepage AS show_homepage_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.id AS id_5, d0_.pricing_rule_set_id AS pricing_rule_set_id_6, d0_.time_slot_id AS time_slot_id_7, d0_.package_set_id AS package_set_id_8 FROM delivery_form d0_ WHERE d0_.show_homepage = ? LIMIT 1

[
  1
]

SELECT
  d0_.with_vehicle AS with_vehicle_0,
  d0_.with_weight AS with_weight_1,
  d0_.show_homepage AS show_homepage_2,
  d0_.created_at AS created_at_3,
  d0_.updated_at AS updated_at_4,
  d0_.id AS id_5,
  d0_.pricing_rule_set_id AS pricing_rule_set_id_6,
  d0_.time_slot_id AS time_slot_id_7,
  d0_.package_set_id AS package_set_id_8
FROM
  delivery_form d0_
WHERE
  d0_.show_homepage = ?
LIMIT
  1

SELECT d0_.with_vehicle AS with_vehicle_0, d0_.with_weight AS with_weight_1, d0_.show_homepage AS show_homepage_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.id AS id_5, d0_.pricing_rule_set_id AS pricing_rule_set_id_6, d0_.time_slot_id AS time_slot_id_7, d0_.package_set_id AS package_set_id_8 FROM delivery_form d0_ WHERE d0_.show_homepage = 1 LIMIT 1;

SELECT COUNT(r0_.id) AS sclr_0 FROM restaurant r0_ WHERE (r0_.enabled = ? AND (r0_.deposit_refund_enabled = ? OR r0_.loopeat_enabled = ?)) AND (r0_.enabled = '1') AND (r0_.deleted_at IS NULL)

[
  1
  1
  1
]

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  restaurant r0_
WHERE
  (
    r0_.enabled = ?
    AND (
      r0_.deposit_refund_enabled = ?
      OR r0_.loopeat_enabled = ?
    )
  )
  AND (r0_.enabled = '1')
  AND (r0_.deleted_at IS NULL)

SELECT COUNT(r0_.id) AS sclr_0 FROM restaurant r0_ WHERE (r0_.enabled = 1 AND (r0_.deposit_refund_enabled = 1 OR r0_.loopeat_enabled = 1)) AND (r0_.enabled = '1') AND (r0_.deleted_at IS NULL);