Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.group_id AS group_id_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.validation_date AS validation_date_5, t0.start_cash AS start_cash_6, t0.end_cash AS end_cash_7, t0.bank_cash AS bank_cash_8, t0.total_weight AS total_weight_9, t0.total AS total_10, t0.num_item AS num_item_11, t0.num_refund AS num_refund_12, t0.num_membership AS num_membership_13, t0.num_payment AS num_payment_14, t0.sales AS sales_15, t0.memberships AS memberships_16, t0.payments AS payments_17, t0.cash_inventory AS cash_inventory_18, t0.status AS status_19, t0.comment AS comment_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22, t0.deleted_by AS deleted_by_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26, t0.shop_uuid AS shop_uuid_27 FROM order_groups t0 WHERE t0.shop_uuid IN (?, ?, ?, ?, ?, ?, ?) AND ((t0.deleted_at IS NULL))

[
  Symfony\Component\Uid\UuidV4 {#2045
    __toString(): "26057091-014f-4fed-bf81-020cc39d4e58"
  }
  Symfony\Component\Uid\UuidV4 {#2261
    __toString(): "39592778-f5ce-4fb6-8383-c25852d78516"
  }
  Symfony\Component\Uid\UuidV4 {#2269
    __toString(): "68e2d9f8-68ac-4f78-bd72-b99337e52b34"
  }
  Symfony\Component\Uid\UuidV4 {#2291
    __toString(): "763d43ff-54d5-4b23-9b00-d9861122d204"
  }
  Symfony\Component\Uid\UuidV4 {#2313
    __toString(): "91cf7234-eb0c-4cc8-8d20-b07a5883bf30"
  }
  Symfony\Component\Uid\UuidV4 {#2335
    __toString(): "dbe606c6-2502-4545-88bf-b74de95a5202"
  }
  Symfony\Component\Uid\UuidV4 {#2357
    __toString(): "f78017d8-b74a-4064-897e-f8b47ed16adb"
  }
]

SELECT
  t0.id AS id_1,
  t0.group_id AS group_id_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.validation_date AS validation_date_5,
  t0.start_cash AS start_cash_6,
  t0.end_cash AS end_cash_7,
  t0.bank_cash AS bank_cash_8,
  t0.total_weight AS total_weight_9,
  t0.total AS total_10,
  t0.num_item AS num_item_11,
  t0.num_refund AS num_refund_12,
  t0.num_membership AS num_membership_13,
  t0.num_payment AS num_payment_14,
  t0.sales AS sales_15,
  t0.memberships AS memberships_16,
  t0.payments AS payments_17,
  t0.cash_inventory AS cash_inventory_18,
  t0.status AS status_19,
  t0.comment AS comment_20,
  t0.created_by AS created_by_21,
  t0.updated_by AS updated_by_22,
  t0.deleted_by AS deleted_by_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.deleted_at AS deleted_at_26,
  t0.shop_uuid AS shop_uuid_27
FROM
  order_groups t0
WHERE
  t0.shop_uuid IN (?, ?, ?, ?, ?, ?, ?)
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.group_id AS group_id_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.validation_date AS validation_date_5, t0.start_cash AS start_cash_6, t0.end_cash AS end_cash_7, t0.bank_cash AS bank_cash_8, t0.total_weight AS total_weight_9, t0.total AS total_10, t0.num_item AS num_item_11, t0.num_refund AS num_refund_12, t0.num_membership AS num_membership_13, t0.num_payment AS num_payment_14, t0.sales AS sales_15, t0.memberships AS memberships_16, t0.payments AS payments_17, t0.cash_inventory AS cash_inventory_18, t0.status AS status_19, t0.comment AS comment_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22, t0.deleted_by AS deleted_by_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26, t0.shop_uuid AS shop_uuid_27 FROM order_groups t0 WHERE t0.shop_uuid IN ('26057091-014f-4fed-bf81-020cc39d4e58', '39592778-f5ce-4fb6-8383-c25852d78516', '68e2d9f8-68ac-4f78-bd72-b99337e52b34', '763d43ff-54d5-4b23-9b00-d9861122d204', '91cf7234-eb0c-4cc8-8d20-b07a5883bf30', 'dbe606c6-2502-4545-88bf-b74de95a5202', 'f78017d8-b74a-4064-897e-f8b47ed16adb') AND ((t0.deleted_at IS NULL));

SELECT s0_.uuid AS uuid_0, s0_.current_cash AS current_cash_1, s0_.current_cash_date AS current_cash_date_2, s0_.active AS active_3, s0_.name AS name_4, s0_.created_by AS created_by_5, s0_.updated_by AS updated_by_6, s0_.deleted_by AS deleted_by_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.deleted_at AS deleted_at_10, p1_.id AS id_11, p1_.color AS color_12, p1_.description AS description_13, p1_.name AS name_14, p1_.slug AS slug_15, p1_.created_by AS created_by_16, p1_.updated_by AS updated_by_17, p1_.deleted_by AS deleted_by_18, p1_.created_at AS created_at_19, p1_.updated_at AS updated_at_20, s2_.opening_hours AS opening_hours_21, s2_.accept_donation AS accept_donation_22, s2_.donation_hours AS donation_hours_23, s0_.shop_id AS shop_id_24, p1_.type AS type_25, p1_.picture_id AS picture_id_26, p1_.address_id AS address_id_27 FROM shop_uuids s0_ INNER JOIN shops s2_ ON s0_.shop_id = s2_.id LEFT JOIN places p1_ ON s2_.id = p1_.id WHERE (s0_.deleted_at IS NULL) AND (s0_.deleted_at IS NULL) ORDER BY s0_.uuid ASC

[]

SELECT
  s0_.uuid AS uuid_0,
  s0_.current_cash AS current_cash_1,
  s0_.current_cash_date AS current_cash_date_2,
  s0_.active AS active_3,
  s0_.name AS name_4,
  s0_.created_by AS created_by_5,
  s0_.updated_by AS updated_by_6,
  s0_.deleted_by AS deleted_by_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9,
  s0_.deleted_at AS deleted_at_10,
  p1_.id AS id_11,
  p1_.color AS color_12,
  p1_.description AS description_13,
  p1_.name AS name_14,
  p1_.slug AS slug_15,
  p1_.created_by AS created_by_16,
  p1_.updated_by AS updated_by_17,
  p1_.deleted_by AS deleted_by_18,
  p1_.created_at AS created_at_19,
  p1_.updated_at AS updated_at_20,
  s2_.opening_hours AS opening_hours_21,
  s2_.accept_donation AS accept_donation_22,
  s2_.donation_hours AS donation_hours_23,
  s0_.shop_id AS shop_id_24,
  p1_.type AS type_25,
  p1_.picture_id AS picture_id_26,
  p1_.address_id AS address_id_27
FROM
  shop_uuids s0_
  INNER JOIN shops s2_ ON s0_.shop_id = s2_.id
  LEFT JOIN places p1_ ON s2_.id = p1_.id
WHERE
  (s0_.deleted_at IS NULL)
  AND (s0_.deleted_at IS NULL)
ORDER BY
  s0_.uuid ASC

SELECT s0_.uuid AS uuid_0, s0_.current_cash AS current_cash_1, s0_.current_cash_date AS current_cash_date_2, s0_.active AS active_3, s0_.name AS name_4, s0_.created_by AS created_by_5, s0_.updated_by AS updated_by_6, s0_.deleted_by AS deleted_by_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.deleted_at AS deleted_at_10, p1_.id AS id_11, p1_.color AS color_12, p1_.description AS description_13, p1_.name AS name_14, p1_.slug AS slug_15, p1_.created_by AS created_by_16, p1_.updated_by AS updated_by_17, p1_.deleted_by AS deleted_by_18, p1_.created_at AS created_at_19, p1_.updated_at AS updated_at_20, s2_.opening_hours AS opening_hours_21, s2_.accept_donation AS accept_donation_22, s2_.donation_hours AS donation_hours_23, s0_.shop_id AS shop_id_24, p1_.type AS type_25, p1_.picture_id AS picture_id_26, p1_.address_id AS address_id_27 FROM shop_uuids s0_ INNER JOIN shops s2_ ON s0_.shop_id = s2_.id LEFT JOIN places p1_ ON s2_.id = p1_.id WHERE (s0_.deleted_at IS NULL) AND (s0_.deleted_at IS NULL) ORDER BY s0_.uuid ASC;

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.complement AS complement_7, t0.city AS city_8, t0.postcode AS postcode_9, t0.valid AS valid_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.geo_city_id AS geo_city_id_15 FROM addresses t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?)

[
  2
  5
  4
  3
  4655
  10735
  1
]

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.address AS address_6,
  t0.complement AS complement_7,
  t0.city AS city_8,
  t0.postcode AS postcode_9,
  t0.valid AS valid_10,
  t0.latitude AS latitude_11,
  t0.longitude AS longitude_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.geo_city_id AS geo_city_id_15
FROM
  addresses t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.complement AS complement_7, t0.city AS city_8, t0.postcode AS postcode_9, t0.valid AS valid_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.geo_city_id AS geo_city_id_15 FROM addresses t0 WHERE t0.id IN (2, 5, 4, 3, 4655, 10735, 1);