Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine 5
• Messages
• Emails
• Doctrine MongoDB 0
• Configuration

Query Metrics

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

[
  "966570649726"
]

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

SELECT o0_.id AS id_0, o0_.primary_order_id AS sclr_1 FROM order_entity o0_ WHERE o0_.primary_order_id <> ? ORDER BY o0_.id DESC

[
  ""
]

SELECT
  o0_.id AS id_0,
  o0_.primary_order_id AS sclr_1
FROM
  order_entity o0_
WHERE
  o0_.primary_order_id <> ?
ORDER BY
  o0_.id DESC

SELECT o0_.id AS id_0, o0_.primary_order_id AS sclr_1 FROM order_entity o0_ WHERE o0_.primary_order_id <> '' ORDER BY o0_.id DESC;

SELECT c0_.status AS status_0, c0_.is_online AS is_online_1, c0_.cities AS cities_2, c1_.id AS id_3 FROM captain_entity c0_ LEFT JOIN city_entity c1_ ON (c1_.id = c0_.city_id_id) WHERE c0_.captain_id = ?

[
  4145
]

SELECT
  c0_.status AS status_0,
  c0_.is_online AS is_online_1,
  c0_.cities AS cities_2,
  c1_.id AS id_3
FROM
  captain_entity c0_
  LEFT JOIN city_entity c1_ ON (c1_.id = c0_.city_id_id)
WHERE
  c0_.captain_id = ?

SELECT c0_.status AS status_0, c0_.is_online AS is_online_1, c0_.cities AS cities_2, c1_.id AS id_3 FROM captain_entity c0_ LEFT JOIN city_entity c1_ ON (c1_.id = c0_.city_id_id) WHERE c0_.captain_id = 4145;

SELECT c0_.status AS status_0, c0_.captain_financial_system_type AS captain_financial_system_type_1, c0_.captain_financial_system_id AS captain_financial_system_id_2, c1_.id AS id_3 FROM captain_entity c1_ LEFT JOIN captain_financial_system_detail_entity c0_ ON (c0_.captain_id = c1_.id) WHERE c1_.captain_id = ? ORDER BY c0_.id DESC LIMIT 1

[
  4145
]

SELECT
  c0_.status AS status_0,
  c0_.captain_financial_system_type AS captain_financial_system_type_1,
  c0_.captain_financial_system_id AS captain_financial_system_id_2,
  c1_.id AS id_3
FROM
  captain_entity c1_
  LEFT JOIN captain_financial_system_detail_entity c0_ ON (c0_.captain_id = c1_.id)
WHERE
  c1_.captain_id = ?
ORDER BY
  c0_.id DESC
LIMIT
  1

SELECT c0_.status AS status_0, c0_.captain_financial_system_type AS captain_financial_system_type_1, c0_.captain_financial_system_id AS captain_financial_system_id_2, c1_.id AS id_3 FROM captain_entity c1_ LEFT JOIN captain_financial_system_detail_entity c0_ ON (c0_.captain_id = c1_.id) WHERE c1_.captain_id = 4145 ORDER BY c0_.id DESC LIMIT 1;

SELECT DISTINCT o0_.id AS id_0, o0_.payment AS payment_1, o0_.order_cost AS order_cost_2, o0_.order_type AS order_type_3, o0_.note AS note_4, o0_.state AS state_5, o0_.order_is_main AS order_is_main_6, o0_.created_at AS created_at_7, s1_.id AS id_8, s1_.name AS name_9, c2_.id AS id_10, o3_.store_branch_to_client_duration AS store_branch_to_client_duration_11, o3_.store_branch_to_client_distance AS store_branch_to_client_distance_12, o3_.captain_to_store_branch_duration AS captain_to_store_branch_duration_13, o3_.captain_to_store_branch_distance AS captain_to_store_branch_distance_14, o3_.dest_lat AS dest_lat_15, o3_.dest_lon AS dest_lon_16, o3_.dest_link AS dest_link_17, o3_.source_lat AS source_lat_18, o3_.source_lon AS source_lon_19, o4_.status AS status_20 FROM order_entity o0_ LEFT JOIN order_status_entity o4_ ON (o4_.order_id_id = o0_.id) LEFT JOIN order_geo_entity o3_ ON (o3_.order_id_id = o0_.id) LEFT JOIN store_order_details_entity s5_ ON (o0_.id = s5_.order_id_id) LEFT JOIN store_owner_branch_entity s1_ ON (s1_.id = s5_.branch_id) LEFT JOIN city_entity c2_ ON (c2_.id = s1_.city_id_id) WHERE o0_.state = ? AND o4_.is_hide = ? AND (o0_.delivery_date <= ?) AND o0_.visibility LIKE ? AND ((s1_.city_id_id IS NULL) OR (s1_.city_id_id IN (?))) ORDER BY o0_.id DESC

[
  "pending"
  2
  "2025-12-16 16:13:04"
  "%1%"
  1
]

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.payment AS payment_1,
  o0_.order_cost AS order_cost_2,
  o0_.order_type AS order_type_3,
  o0_.note AS note_4,
  o0_.state AS state_5,
  o0_.order_is_main AS order_is_main_6,
  o0_.created_at AS created_at_7,
  s1_.id AS id_8,
  s1_.name AS name_9,
  c2_.id AS id_10,
  o3_.store_branch_to_client_duration AS store_branch_to_client_duration_11,
  o3_.store_branch_to_client_distance AS store_branch_to_client_distance_12,
  o3_.captain_to_store_branch_duration AS captain_to_store_branch_duration_13,
  o3_.captain_to_store_branch_distance AS captain_to_store_branch_distance_14,
  o3_.dest_lat AS dest_lat_15,
  o3_.dest_lon AS dest_lon_16,
  o3_.dest_link AS dest_link_17,
  o3_.source_lat AS source_lat_18,
  o3_.source_lon AS source_lon_19,
  o4_.status AS status_20
FROM
  order_entity o0_
  LEFT JOIN order_status_entity o4_ ON (o4_.order_id_id = o0_.id)
  LEFT JOIN order_geo_entity o3_ ON (o3_.order_id_id = o0_.id)
  LEFT JOIN store_order_details_entity s5_ ON (o0_.id = s5_.order_id_id)
  LEFT JOIN store_owner_branch_entity s1_ ON (s1_.id = s5_.branch_id)
  LEFT JOIN city_entity c2_ ON (c2_.id = s1_.city_id_id)
WHERE
  o0_.state = ?
  AND o4_.is_hide = ?
  AND (o0_.delivery_date <= ?)
  AND o0_.visibility LIKE ?
  AND (
    (s1_.city_id_id IS NULL)
    OR (
      s1_.city_id_id IN (?)
    )
  )
ORDER BY
  o0_.id DESC

SELECT DISTINCT o0_.id AS id_0, o0_.payment AS payment_1, o0_.order_cost AS order_cost_2, o0_.order_type AS order_type_3, o0_.note AS note_4, o0_.state AS state_5, o0_.order_is_main AS order_is_main_6, o0_.created_at AS created_at_7, s1_.id AS id_8, s1_.name AS name_9, c2_.id AS id_10, o3_.store_branch_to_client_duration AS store_branch_to_client_duration_11, o3_.store_branch_to_client_distance AS store_branch_to_client_distance_12, o3_.captain_to_store_branch_duration AS captain_to_store_branch_duration_13, o3_.captain_to_store_branch_distance AS captain_to_store_branch_distance_14, o3_.dest_lat AS dest_lat_15, o3_.dest_lon AS dest_lon_16, o3_.dest_link AS dest_link_17, o3_.source_lat AS source_lat_18, o3_.source_lon AS source_lon_19, o4_.status AS status_20 FROM order_entity o0_ LEFT JOIN order_status_entity o4_ ON (o4_.order_id_id = o0_.id) LEFT JOIN order_geo_entity o3_ ON (o3_.order_id_id = o0_.id) LEFT JOIN store_order_details_entity s5_ ON (o0_.id = s5_.order_id_id) LEFT JOIN store_owner_branch_entity s1_ ON (s1_.id = s5_.branch_id) LEFT JOIN city_entity c2_ ON (c2_.id = s1_.city_id_id) WHERE o0_.state = 'pending' AND o4_.is_hide = 2 AND (o0_.delivery_date <= '2025-12-16 16:13:04') AND o0_.visibility LIKE '%1%' AND ((s1_.city_id_id IS NULL) OR (s1_.city_id_id IN (1))) ORDER BY o0_.id DESC;