Symfony Profiler

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.state AS state_2,
  o0_.payment AS payment_3,
  o0_.whatsapp_order_id AS whatsapp_order_id_4,
  s1_.name AS name_5,
  s2_.id AS id_6,
  s2_.store_owner_name AS store_owner_name_7,
  c3_.id AS id_8,
  c3_.captain_name AS captain_name_9,
  c3_.phone AS phone_10,
  c3_.captain_id AS captain_id_11,
  c3_.room_id AS room_id_12,
  CASE WHEN e4_.company_name IS NOT NULL THEN
    e4_.company_name
  ELSE
    'C4D'
  END AS sclr_13,
  e4_.id AS id_14,
  i5_.image_path AS image_path_15,
  CASE WHEN a6_.id IS NOT NULL THEN
    1
  ELSE
    0
  END AS sclr_16,
  a6_.created_at AS created_at_17,
  a6_.sent_date AS sent_date_18,
  a7_.title AS title_19,
  w8_.has_rice_gift AS has_rice_gift_20,
  c9_.id AS id_21,
  c9_.name AS name_22
FROM
  order_entity o0_
  LEFT JOIN order_status_entity o10_ ON (o10_.order_id_id = o0_.id)
  LEFT JOIN store_order_details_entity s11_ ON (o0_.id = s11_.order_id_id)
  LEFT JOIN store_owner_branch_entity s1_ ON (s1_.id = s11_.branch_id)
  LEFT JOIN captain_entity c3_ ON (c3_.id = o10_.captain_profile_id)
  LEFT JOIN store_owner_profile_entity s2_ ON (s2_.id = o0_.store_owner_id)
  LEFT JOIN image_entity i5_ ON (
    i5_.item_id = c3_.id
    AND i5_.entity_type = ?
    AND i5_.used_as = ?
  )
  LEFT JOIN externally_delivered_order_entity e12_ ON (
    e12_.order_id_id = o0_.id
    AND e12_.status IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  LEFT JOIN external_delivery_company_entity e4_ ON (
    e4_.id = e12_.external_delivery_company_id
  )
  LEFT JOIN auto_client_promotion_entity a6_ ON (
    a6_.whatsapp_order_id = o0_.whatsapp_order_id
    AND a6_.status IN (?, ?)
  )
  LEFT JOIN whatsapp_order_details_entity w8_ ON (w8_.id = o0_.whatsapp_order_id)
  LEFT JOIN auto_promotion_entity a7_ ON (a7_.id = a6_.auto_promotion_id)
  LEFT JOIN city_entity c9_ ON (c9_.id = s1_.city_id_id)
WHERE
  o0_.state IN (?, ?, ?, ?)
  AND o10_.is_hide = ?
  AND s2_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  o0_.id DESC

SELECT DISTINCT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.state AS state_2, o0_.payment AS payment_3, o0_.whatsapp_order_id AS whatsapp_order_id_4, s1_.name AS name_5, s2_.id AS id_6, s2_.store_owner_name AS store_owner_name_7, c3_.id AS id_8, c3_.captain_name AS captain_name_9, c3_.phone AS phone_10, c3_.captain_id AS captain_id_11, c3_.room_id AS room_id_12, CASE WHEN e4_.company_name IS NOT NULL THEN e4_.company_name ELSE 'C4D' END AS sclr_13, e4_.id AS id_14, i5_.image_path AS image_path_15, CASE WHEN a6_.id IS NOT NULL THEN 1 ELSE 0 END AS sclr_16, a6_.created_at AS created_at_17, a6_.sent_date AS sent_date_18, a7_.title AS title_19, w8_.has_rice_gift AS has_rice_gift_20, c9_.id AS id_21, c9_.name AS name_22 FROM order_entity o0_ LEFT JOIN order_status_entity o10_ ON (o10_.order_id_id = o0_.id) LEFT JOIN store_order_details_entity s11_ ON (o0_.id = s11_.order_id_id) LEFT JOIN store_owner_branch_entity s1_ ON (s1_.id = s11_.branch_id) LEFT JOIN captain_entity c3_ ON (c3_.id = o10_.captain_profile_id) LEFT JOIN store_owner_profile_entity s2_ ON (s2_.id = o0_.store_owner_id) LEFT JOIN image_entity i5_ ON (i5_.item_id = c3_.id AND i5_.entity_type = 2 AND i5_.used_as = 0) LEFT JOIN externally_delivered_order_entity e12_ ON (e12_.order_id_id = o0_.id AND e12_.status IN ('COLLECTING', 'DELIVERING', 'DROPOFF_ARRIVED', 'DriverAssigned', 'PickingUp', 'Delivering', 'Pending order preparation', 'Arrived to pickup', 'Order picked up', 'Arrived to dropoff', 'Driver accepted the order', 'on way to pick order', 'in store', 'ongoing', 'AC', 'GTP', 'ATP', 'PU', 'GTC', 'ATC', 'Order Accept', 'Start Ride', 'Reached Shop', 'Order Picked', 'Shipped')) LEFT JOIN external_delivery_company_entity e4_ ON (e4_.id = e12_.external_delivery_company_id) LEFT JOIN auto_client_promotion_entity a6_ ON (a6_.whatsapp_order_id = o0_.whatsapp_order_id AND a6_.status IN (2, 3)) LEFT JOIN whatsapp_order_details_entity w8_ ON (w8_.id = o0_.whatsapp_order_id) LEFT JOIN auto_promotion_entity a7_ ON (a7_.id = a6_.auto_promotion_id) LEFT JOIN city_entity c9_ ON (c9_.id = s1_.city_id_id) WHERE o0_.state IN ('ongoing', 'on way to pick order', 'in store', 'picked') AND o10_.is_hide = 2 AND s2_.id IN (2721, 2729, 2731, 2734, 2737, 2742, 2754, 2755, 2756, 2757, 2758, 2759, 2760, 2761, 2762, 2765, 2766, 2780, 2781, 2784, 2786, 2788, 2792, 2794, 2795, 2799, 2800, 2804, 2806, 2807, 2810, 2812, 2813, 2815, 2819, 2820, 2822, 2824, 2826, 2831, 2834, 2835, 2839, 2840, 2845, 2848, 2849, 2851, 2852, 2853, 2854, 2855, 2860, 2861, 2865, 2875, 2876, 2877, 2878, 2879, 2890, 2886, 2884, 2910, 2864) ORDER BY o0_.id DESC;

SELECT
  a0_.stores_allow AS stores_allow_0
FROM
  admin_profile_entity a0_
WHERE
  a0_.user_id = ?

SELECT a0_.stores_allow AS stores_allow_0 FROM admin_profile_entity a0_ WHERE a0_.user_id = 3508;

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 = '966567319306' LIMIT 1;