Symfony Profiler

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

Query Metrics

SELECT i0_.image_path AS image_path_0, i0_.used_as AS used_as_1 FROM captain_entity c1_ LEFT JOIN image_entity i0_ ON (i0_.item_id = c1_.id AND i0_.entity_type = ?) WHERE c1_.id = ?

[
  2
  1039
]

SELECT
  i0_.image_path AS image_path_0,
  i0_.used_as AS used_as_1
FROM
  captain_entity c1_
  LEFT JOIN image_entity i0_ ON (
    i0_.item_id = c1_.id
    AND i0_.entity_type = ?
  )
WHERE
  c1_.id = ?

SELECT i0_.image_path AS image_path_0, i0_.used_as AS used_as_1 FROM captain_entity c1_ LEFT JOIN image_entity i0_ ON (i0_.item_id = c1_.id AND i0_.entity_type = 2) WHERE c1_.id = 1039;

SELECT c0_.id AS id_0, c0_.captain_id AS captain_id_1, c0_.captain_name AS captain_name_2, c0_.location AS location_3, c0_.age AS age_4, c0_.car AS car_5, c0_.salary AS salary_6, c0_.salary AS salary_7, c0_.bounce AS bounce_8, c0_.phone AS phone_9, c0_.is_online AS is_online_10, c0_.bank_name AS bank_name_11, c0_.bank_account_number AS bank_account_number_12, c0_.stc_pay AS stc_pay_13, c0_.complete_account_status AS complete_account_status_14, c0_.status AS status_15, c0_.address AS address_16, c0_.room_id AS room_id_17, c0_.release_version AS release_version_18, c0_.cities AS cities_19, c0_.car_type AS car_type_20, u1_.user_id AS user_id_21, u1_.verification_status AS verification_status_22, c2_.id AS id_23, c2_.name AS name_24 FROM captain_entity c0_ LEFT JOIN city_entity c2_ ON (c2_.id = c0_.city_id_id) LEFT JOIN user_entity u1_ ON (u1_.id = c0_.captain_id) WHERE c0_.id = ?

[
  1039
]

SELECT
  c0_.id AS id_0,
  c0_.captain_id AS captain_id_1,
  c0_.captain_name AS captain_name_2,
  c0_.location AS location_3,
  c0_.age AS age_4,
  c0_.car AS car_5,
  c0_.salary AS salary_6,
  c0_.salary AS salary_7,
  c0_.bounce AS bounce_8,
  c0_.phone AS phone_9,
  c0_.is_online AS is_online_10,
  c0_.bank_name AS bank_name_11,
  c0_.bank_account_number AS bank_account_number_12,
  c0_.stc_pay AS stc_pay_13,
  c0_.complete_account_status AS complete_account_status_14,
  c0_.status AS status_15,
  c0_.address AS address_16,
  c0_.room_id AS room_id_17,
  c0_.release_version AS release_version_18,
  c0_.cities AS cities_19,
  c0_.car_type AS car_type_20,
  u1_.user_id AS user_id_21,
  u1_.verification_status AS verification_status_22,
  c2_.id AS id_23,
  c2_.name AS name_24
FROM
  captain_entity c0_
  LEFT JOIN city_entity c2_ ON (c2_.id = c0_.city_id_id)
  LEFT JOIN user_entity u1_ ON (u1_.id = c0_.captain_id)
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.captain_id AS captain_id_1, c0_.captain_name AS captain_name_2, c0_.location AS location_3, c0_.age AS age_4, c0_.car AS car_5, c0_.salary AS salary_6, c0_.salary AS salary_7, c0_.bounce AS bounce_8, c0_.phone AS phone_9, c0_.is_online AS is_online_10, c0_.bank_name AS bank_name_11, c0_.bank_account_number AS bank_account_number_12, c0_.stc_pay AS stc_pay_13, c0_.complete_account_status AS complete_account_status_14, c0_.status AS status_15, c0_.address AS address_16, c0_.room_id AS room_id_17, c0_.release_version AS release_version_18, c0_.cities AS cities_19, c0_.car_type AS car_type_20, u1_.user_id AS user_id_21, u1_.verification_status AS verification_status_22, c2_.id AS id_23, c2_.name AS name_24 FROM captain_entity c0_ LEFT JOIN city_entity c2_ ON (c2_.id = c0_.city_id_id) LEFT JOIN user_entity u1_ ON (u1_.id = c0_.captain_id) WHERE c0_.id = 1039;

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.captain_financial_system_type AS captain_financial_system_type_3, c0_.status AS status_4, a1_.name AS name_5, c0_.captain_financial_system_type AS captain_financial_system_type_6 FROM captain_financial_system_detail_entity c0_ LEFT JOIN admin_profile_entity a1_ ON (a1_.user_id = c0_.updated_by) WHERE c0_.captain_id = ? ORDER BY c0_.id DESC LIMIT 1

[
  1039
]

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.captain_financial_system_type AS captain_financial_system_type_3,
  c0_.status AS status_4,
  a1_.name AS name_5,
  c0_.captain_financial_system_type AS captain_financial_system_type_6
FROM
  captain_financial_system_detail_entity c0_
  LEFT JOIN admin_profile_entity a1_ ON (a1_.user_id = c0_.updated_by)
WHERE
  c0_.captain_id = ?
ORDER BY
  c0_.id DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.captain_financial_system_type AS captain_financial_system_type_3, c0_.status AS status_4, a1_.name AS name_5, c0_.captain_financial_system_type AS captain_financial_system_type_6 FROM captain_financial_system_detail_entity c0_ LEFT JOIN admin_profile_entity a1_ ON (a1_.user_id = c0_.updated_by) WHERE c0_.captain_id = 1039 ORDER BY c0_.id DESC 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 = ? LIMIT 1

[
  "966551111113"
]

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

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.captain_financial_system_type AS captain_financial_system_type_3, c0_.status AS status_4, a1_.name AS name_5, c0_.captain_financial_system_type AS captain_financial_system_type_6 FROM captain_financial_system_detail_entity c0_ LEFT JOIN admin_profile_entity a1_ ON (a1_.user_id = c0_.updated_by) WHERE c0_.captain_id = ?

[
  1039
]

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.captain_financial_system_type AS captain_financial_system_type_3,
  c0_.status AS status_4,
  a1_.name AS name_5,
  c0_.captain_financial_system_type AS captain_financial_system_type_6
FROM
  captain_financial_system_detail_entity c0_
  LEFT JOIN admin_profile_entity a1_ ON (a1_.user_id = c0_.updated_by)
WHERE
  c0_.captain_id = ?

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.captain_financial_system_type AS captain_financial_system_type_3, c0_.status AS status_4, a1_.name AS name_5, c0_.captain_financial_system_type AS captain_financial_system_type_6 FROM captain_financial_system_detail_entity c0_ LEFT JOIN admin_profile_entity a1_ ON (a1_.user_id = c0_.updated_by) WHERE c0_.captain_id = 1039;

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM city_entity c0_ WHERE c0_.id IN (?)

[
  1
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  city_entity c0_
WHERE
  c0_.id IN (?)

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM city_entity c0_ WHERE c0_.id IN (1);