Symfony Profiler

SELECT
  o0_.id AS id_0,
  c1_.id AS id_1,
  c1_.captain_name AS captain_name_2,
  c1_.created_at AS created_at_3,
  o0_.created_at AS created_at_4,
  i2_.image_path AS image_path_5,
  e3_.id AS id_6,
  e3_.company_name AS company_name_7,
  o4_.created_at AS created_at_8
FROM
  order_entity o0_
  LEFT JOIN order_status_entity o5_ ON (o5_.order_id_id = o0_.id)
  LEFT JOIN captain_entity c1_ ON (c1_.id = o5_.captain_profile_id)
  LEFT JOIN image_entity i2_ ON (
    i2_.item_id = c1_.id
    AND i2_.entity_type = ?
    AND i2_.used_as = ?
  )
  LEFT JOIN externally_delivered_order_entity e6_ ON (
    e6_.order_id_id = o0_.id
    AND e6_.status IN (?, ?, ?, ?, ?, ?, ?)
  )
  LEFT JOIN external_delivery_company_entity e3_ ON (
    e3_.id = e6_.external_delivery_company_id
  )
  LEFT JOIN order_log_entity o4_ ON (o4_.order_id_id = o0_.id)
WHERE
  o0_.state = ?
  AND (
    o4_.state = ?
    AND o4_.action IN (?, ?, ?, ?, ?)
  )
ORDER BY
  o0_.id DESC
LIMIT
  5

SELECT o0_.id AS id_0, c1_.id AS id_1, c1_.captain_name AS captain_name_2, c1_.created_at AS created_at_3, o0_.created_at AS created_at_4, i2_.image_path AS image_path_5, e3_.id AS id_6, e3_.company_name AS company_name_7, o4_.created_at AS created_at_8 FROM order_entity o0_ LEFT JOIN order_status_entity o5_ ON (o5_.order_id_id = o0_.id) LEFT JOIN captain_entity c1_ ON (c1_.id = o5_.captain_profile_id) LEFT JOIN image_entity i2_ ON (i2_.item_id = c1_.id AND i2_.entity_type = 2 AND i2_.used_as = 0) LEFT JOIN externally_delivered_order_entity e6_ ON (e6_.order_id_id = o0_.id AND e6_.status IN ('DELIVERED', 'Delivered', 'Pending order preparation', 'Order delivered', 'delivered', 'RAP', 'Delivered')) LEFT JOIN external_delivery_company_entity e3_ ON (e3_.id = e6_.external_delivery_company_id) LEFT JOIN order_log_entity o4_ ON (o4_.order_id_id = o0_.id) WHERE o0_.state = 'delivered' AND (o4_.state = 6 AND o4_.action IN (43, 44, 20, 14, 72)) ORDER BY o0_.id DESC LIMIT 5;

SELECT
  DATE_FORMAT(o0_.created_at, '%Y-%m-%d') AS sclr_0,
  COUNT(o0_.id) AS sclr_1
FROM
  order_entity o0_
WHERE
  o0_.state = ?
  AND o0_.created_at >= ?
  AND o0_.created_at <= ?
GROUP BY
  sclr_0
ORDER BY
  sclr_0 DESC

SELECT DATE_FORMAT(o0_.created_at, '%Y-%m-%d') AS sclr_0, COUNT(o0_.id) AS sclr_1 FROM order_entity o0_ WHERE o0_.state = 'delivered' AND o0_.created_at >= '2025-12-11 03:00:00' AND o0_.created_at <= '2025-12-18 02:59:59' GROUP BY sclr_0 ORDER BY sclr_0 DESC;

SELECT
  COUNT(*)
FROM
  order_status_entity t0
WHERE
  t0.status = ?
  AND t0.is_hide = ?

SELECT COUNT(*) FROM order_status_entity t0 WHERE t0.status = 1 AND t0.is_hide = 2;

SELECT
  DATE_FORMAT(w0_.created_at, '%Y-%m-%d') AS sclr_0,
  COUNT(w0_.id) AS sclr_1
FROM
  whatsapp_order_details_entity w0_
WHERE
  (
    (w0_.is_delivery = ?)
    OR (
      w0_.is_delivery = ?
      AND w0_.delivery_company <> ?
    )
  )
  AND w0_.order_status = ?
  AND w0_.created_at >= ?
  AND w0_.created_at <= ?
GROUP BY
  sclr_0
ORDER BY
  sclr_0 DESC

SELECT DATE_FORMAT(w0_.created_at, '%Y-%m-%d') AS sclr_0, COUNT(w0_.id) AS sclr_1 FROM whatsapp_order_details_entity w0_ WHERE ((w0_.is_delivery = 0) OR (w0_.is_delivery = 1 AND w0_.delivery_company <> 1)) AND w0_.order_status = 8 AND w0_.created_at >= '2025-12-11 03:00:00' AND w0_.created_at <= '2025-12-18 02:59:59' GROUP BY sclr_0 ORDER BY sclr_0 DESC;

SELECT
  COUNT(*)
FROM
  order_status_entity t0
WHERE
  t0.status IN (?, ?, ?)

SELECT COUNT(*) FROM order_status_entity t0 WHERE t0.status IN (2, 3, 5);

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.whatsapp_order_id AS whatsapp_order_id_2,
  s1_.id AS id_3,
  s1_.store_owner_name AS store_owner_name_4,
  s1_.images AS images_5,
  s1_.created_at AS created_at_6
FROM
  order_entity o0_
  LEFT JOIN store_owner_profile_entity s1_ ON (s1_.id = o0_.store_owner_id)
WHERE
  o0_.state IN (?, ?, ?, ?, ?, ?)
ORDER BY
  o0_.id DESC
LIMIT
  5

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.whatsapp_order_id AS whatsapp_order_id_2, s1_.id AS id_3, s1_.store_owner_name AS store_owner_name_4, s1_.images AS images_5, s1_.created_at AS created_at_6 FROM order_entity o0_ LEFT JOIN store_owner_profile_entity s1_ ON (s1_.id = o0_.store_owner_id) WHERE o0_.state IN ('pending', 'on way to pick order', 'in store', 'picked', 'ongoing', 'delivered') ORDER BY o0_.id DESC LIMIT 5;

SELECT
  w0_.id AS id_0,
  w0_.created_at AS created_at_1,
  s1_.id AS id_2,
  s1_.store_owner_name AS store_owner_name_3,
  s1_.images AS images_4,
  s1_.created_at AS created_at_5
FROM
  whatsapp_order_details_entity w0_
  LEFT JOIN store_owner_branch_entity s2_ ON (s2_.id = w0_.store_branch_id)
  LEFT JOIN store_owner_profile_entity s1_ ON (s1_.id = s2_.store_owner_id)
WHERE
  w0_.order_status IN (?, ?, ?)
ORDER BY
  w0_.id DESC
LIMIT
  5

SELECT w0_.id AS id_0, w0_.created_at AS created_at_1, s1_.id AS id_2, s1_.store_owner_name AS store_owner_name_3, s1_.images AS images_4, s1_.created_at AS created_at_5 FROM whatsapp_order_details_entity w0_ LEFT JOIN store_owner_branch_entity s2_ ON (s2_.id = w0_.store_branch_id) LEFT JOIN store_owner_profile_entity s1_ ON (s1_.id = s2_.store_owner_id) WHERE w0_.order_status IN (6, 7, 8) ORDER BY w0_.id DESC LIMIT 5;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  city_entity c0_
WHERE
  c0_.status = ?

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM city_entity c0_ WHERE c0_.status = 1;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.verification_status AS verification_status_5,
  t0.status AS status_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  user_entity t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.roles AS roles_3, t0.password AS password_4, t0.verification_status AS verification_status_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM user_entity t0 WHERE t0.user_id = '966552222223' LIMIT 1;