Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.name AS name_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.password_change_date AS password_change_date_7,
  t0.activated_mail AS activated_mail_8,
  t0.balance AS balance_9,
  t0.fp_token AS fp_token_10,
  t0.fp_token_expires_at AS fp_token_expires_at_11,
  t0.su_token AS su_token_12,
  t0.su_token_created_at AS su_token_created_at_13,
  t0.phone_number AS phone_number_14,
  t0.avatar_url AS avatar_url_15,
  t0.google_id AS google_id_16,
  t0.apple_id AS apple_id_17,
  t0.is_read_term AS is_read_term_18,
  t0.address AS address_19,
  t0.is_phone_verified AS is_phone_verified_20,
  t0.is_new AS is_new_21,
  t0.citizen_identification AS citizen_identification_22,
  t0.is_citizen_verified AS is_citizen_verified_23,
  t0.date_of_birth AS date_of_birth_24,
  t0.auto_charge AS auto_charge_25,
  t0.auto_apply_promotion_code AS auto_apply_promotion_code_26,
  t0.activity_point AS activity_point_27,
  t0.charge_point AS charge_point_28,
  t0.pay_point AS pay_point_29,
  t0.referral_point AS referral_point_30,
  t0.token_version AS token_version_31,
  t0.created_at AS created_at_32,
  t0.updated_at AS updated_at_33,
  t0.deleted_at AS deleted_at_34,
  t0.enabled AS enabled_35,
  t0.third_party_id AS third_party_id_36,
  t0.language_id AS language_id_37,
  t0.ward_id AS ward_id_38,
  t0.user_level_id AS user_level_id_39
FROM
  user t0
WHERE
  t0.username = ?
  AND t0.enabled = ?
  AND t0.deleted_at IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.password AS password_5, t0.roles AS roles_6, t0.password_change_date AS password_change_date_7, t0.activated_mail AS activated_mail_8, t0.balance AS balance_9, t0.fp_token AS fp_token_10, t0.fp_token_expires_at AS fp_token_expires_at_11, t0.su_token AS su_token_12, t0.su_token_created_at AS su_token_created_at_13, t0.phone_number AS phone_number_14, t0.avatar_url AS avatar_url_15, t0.google_id AS google_id_16, t0.apple_id AS apple_id_17, t0.is_read_term AS is_read_term_18, t0.address AS address_19, t0.is_phone_verified AS is_phone_verified_20, t0.is_new AS is_new_21, t0.citizen_identification AS citizen_identification_22, t0.is_citizen_verified AS is_citizen_verified_23, t0.date_of_birth AS date_of_birth_24, t0.auto_charge AS auto_charge_25, t0.auto_apply_promotion_code AS auto_apply_promotion_code_26, t0.activity_point AS activity_point_27, t0.charge_point AS charge_point_28, t0.pay_point AS pay_point_29, t0.referral_point AS referral_point_30, t0.token_version AS token_version_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.deleted_at AS deleted_at_34, t0.enabled AS enabled_35, t0.third_party_id AS third_party_id_36, t0.language_id AS language_id_37, t0.ward_id AS ward_id_38, t0.user_level_id AS user_level_id_39 FROM user t0 WHERE t0.username = 'gg_118286328737968663671' AND t0.enabled = 1 AND t0.deleted_at IS NULL LIMIT 1;

SELECT
  id,
  ip_address,
  device_type,
  device_id,
  app_version,
  valid
FROM
  refresh_token
WHERE
  username = ?
  AND role = ?
ORDER BY
  valid DESC

SELECT id, ip_address, device_type, device_id, app_version, valid
                FROM refresh_token
                WHERE username = 'gg_118286328737968663671' AND role = 'ROLE_GOOGLE'
                ORDER BY valid DESC;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.name AS name_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.password_change_date AS password_change_date_7,
  t0.activated_mail AS activated_mail_8,
  t0.balance AS balance_9,
  t0.fp_token AS fp_token_10,
  t0.fp_token_expires_at AS fp_token_expires_at_11,
  t0.su_token AS su_token_12,
  t0.su_token_created_at AS su_token_created_at_13,
  t0.phone_number AS phone_number_14,
  t0.avatar_url AS avatar_url_15,
  t0.google_id AS google_id_16,
  t0.apple_id AS apple_id_17,
  t0.is_read_term AS is_read_term_18,
  t0.address AS address_19,
  t0.is_phone_verified AS is_phone_verified_20,
  t0.is_new AS is_new_21,
  t0.citizen_identification AS citizen_identification_22,
  t0.is_citizen_verified AS is_citizen_verified_23,
  t0.date_of_birth AS date_of_birth_24,
  t0.auto_charge AS auto_charge_25,
  t0.auto_apply_promotion_code AS auto_apply_promotion_code_26,
  t0.activity_point AS activity_point_27,
  t0.charge_point AS charge_point_28,
  t0.pay_point AS pay_point_29,
  t0.referral_point AS referral_point_30,
  t0.token_version AS token_version_31,
  t0.created_at AS created_at_32,
  t0.updated_at AS updated_at_33,
  t0.deleted_at AS deleted_at_34,
  t0.enabled AS enabled_35,
  t0.third_party_id AS third_party_id_36,
  t0.language_id AS language_id_37,
  t0.ward_id AS ward_id_38,
  t0.user_level_id AS user_level_id_39
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.password AS password_5, t0.roles AS roles_6, t0.password_change_date AS password_change_date_7, t0.activated_mail AS activated_mail_8, t0.balance AS balance_9, t0.fp_token AS fp_token_10, t0.fp_token_expires_at AS fp_token_expires_at_11, t0.su_token AS su_token_12, t0.su_token_created_at AS su_token_created_at_13, t0.phone_number AS phone_number_14, t0.avatar_url AS avatar_url_15, t0.google_id AS google_id_16, t0.apple_id AS apple_id_17, t0.is_read_term AS is_read_term_18, t0.address AS address_19, t0.is_phone_verified AS is_phone_verified_20, t0.is_new AS is_new_21, t0.citizen_identification AS citizen_identification_22, t0.is_citizen_verified AS is_citizen_verified_23, t0.date_of_birth AS date_of_birth_24, t0.auto_charge AS auto_charge_25, t0.auto_apply_promotion_code AS auto_apply_promotion_code_26, t0.activity_point AS activity_point_27, t0.charge_point AS charge_point_28, t0.pay_point AS pay_point_29, t0.referral_point AS referral_point_30, t0.token_version AS token_version_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.deleted_at AS deleted_at_34, t0.enabled AS enabled_35, t0.third_party_id AS third_party_id_36, t0.language_id AS language_id_37, t0.ward_id AS ward_id_38, t0.user_level_id AS user_level_id_39 FROM user t0 WHERE t0.username = 'gg_118286328737968663671' LIMIT 1;

SELECT
  s0_.id AS id_0
FROM
  station_favorite s1_
  INNER JOIN station s0_ ON s1_.station_id = s0_.id
WHERE
  s1_.user_id = ?

SELECT s0_.id AS id_0 FROM station_favorite s1_ INNER JOIN station s0_ ON s1_.station_id = s0_.id WHERE s1_.user_id = 5202;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  station s0_
  LEFT JOIN location l1_ ON s0_.location_id = l1_.id
  LEFT JOIN ward w2_ ON l1_.ward_id = w2_.id
  LEFT JOIN province p3_ ON w2_.province_id = p3_.id
  LEFT JOIN station_area_type s4_ ON s0_.station_area_type_id = s4_.id
  LEFT JOIN current_direction c5_ ON s0_.current_direction_id = c5_.id
WHERE
  s0_.visible = 1
  AND s0_.deleted_at IS NULL

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM station s0_ LEFT JOIN location l1_ ON s0_.location_id = l1_.id LEFT JOIN ward w2_ ON l1_.ward_id = w2_.id LEFT JOIN province p3_ ON w2_.province_id = p3_.id LEFT JOIN station_area_type s4_ ON s0_.station_area_type_id = s4_.id LEFT JOIN current_direction c5_ ON s0_.current_direction_id = c5_.id WHERE s0_.visible = 1 AND s0_.deleted_at IS NULL;

SELECT
  s.id,
  (
    6371 * acos(
      cos(
        radians(:lat)
      ) * cos(
        radians(l.latitude)
      ) * cos(
        radians(l.longitude) - radians(:lon)
      ) + sin(
        radians(:lat)
      ) * sin(
        radians(l.latitude)
      )
    )
  ) AS distance_km
FROM
  station s
  INNER JOIN location l ON l.id = s.location_id
WHERE
  s.visible = 1
  AND s.deleted_at IS NULL
  AND l.deleted_at IS NULL
HAVING
  distance_km <= :radius
ORDER BY
  distance_km ASC,
  s.id DESC
LIMIT
  :limit

SELECT
    s.id,
    (
    6371 * acos(
        cos(radians(10.7769)) * cos(radians(l.latitude)) *
        cos(radians(l.longitude) - radians(106.7009)) +
        sin(radians(10.7769)) * sin(radians(l.latitude))
    )
) AS distance_km
FROM station s
INNER JOIN location l ON l.id = s.location_id
WHERE s.visible = 1
AND s.deleted_at IS NULL
AND l.deleted_at IS NULL
HAVING distance_km <= 50
ORDER BY distance_km ASC, s.id DESC
LIMIT 21;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.public AS public_1,
  s0_.full_time AS full_time_2,
  s0_.latitude AS latitude_3,
  s0_.longitude AS longitude_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.deleted_at AS deleted_at_7,
  s0_.name AS name_8,
  s0_.name_vn AS name_vn_9,
  s0_.description AS description_10,
  s0_.description_vn AS description_vn_11,
  s0_.max_ampere AS max_ampere_12,
  s0_.visible AS visible_13,
  l1_.id AS id_14,
  l1_.address AS address_15,
  l1_.address_vn AS address_vn_16,
  l1_.latitude AS latitude_17,
  l1_.longitude AS longitude_18,
  l1_.location_code AS location_code_19,
  l1_.created_at AS created_at_20,
  l1_.updated_at AS updated_at_21,
  l1_.deleted_at AS deleted_at_22,
  l1_.name AS name_23,
  l1_.name_vn AS name_vn_24,
  l1_.description AS description_25,
  l1_.description_vn AS description_vn_26,
  l1_.max_ampere AS max_ampere_27,
  l1_.note AS note_28,
  l1_.visible AS visible_29,
  w2_.id AS id_30,
  w2_.name AS name_31,
  w2_.name_vn AS name_vn_32,
  p3_.id AS id_33,
  p3_.name AS name_34,
  p3_.name_vn AS name_vn_35,
  p3_.postal_code AS postal_code_36,
  s0_.station_area_type_id AS station_area_type_id_37,
  s0_.location_id AS location_id_38,
  s0_.station_open_profile_id AS station_open_profile_id_39,
  s0_.current_direction_id AS current_direction_id_40,
  l1_.ward_id AS ward_id_41,
  l1_.province_id AS province_id_42,
  l1_.operation_status_id AS operation_status_id_43,
  l1_.location_type_id AS location_type_id_44,
  w2_.province_id AS province_id_45,
  p3_.country_id AS country_id_46
FROM
  station s0_
  LEFT JOIN location l1_ ON s0_.location_id = l1_.id
  LEFT JOIN ward w2_ ON l1_.ward_id = w2_.id
  LEFT JOIN province p3_ ON w2_.province_id = p3_.id
  LEFT JOIN station_area_type s4_ ON s0_.station_area_type_id = s4_.id
  LEFT JOIN current_direction c5_ ON s0_.current_direction_id = c5_.id
WHERE
  s0_.visible = 1
  AND s0_.deleted_at IS NULL
  AND s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT DISTINCT s0_.id AS id_0, s0_.public AS public_1, s0_.full_time AS full_time_2, s0_.latitude AS latitude_3, s0_.longitude AS longitude_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.deleted_at AS deleted_at_7, s0_.name AS name_8, s0_.name_vn AS name_vn_9, s0_.description AS description_10, s0_.description_vn AS description_vn_11, s0_.max_ampere AS max_ampere_12, s0_.visible AS visible_13, l1_.id AS id_14, l1_.address AS address_15, l1_.address_vn AS address_vn_16, l1_.latitude AS latitude_17, l1_.longitude AS longitude_18, l1_.location_code AS location_code_19, l1_.created_at AS created_at_20, l1_.updated_at AS updated_at_21, l1_.deleted_at AS deleted_at_22, l1_.name AS name_23, l1_.name_vn AS name_vn_24, l1_.description AS description_25, l1_.description_vn AS description_vn_26, l1_.max_ampere AS max_ampere_27, l1_.note AS note_28, l1_.visible AS visible_29, w2_.id AS id_30, w2_.name AS name_31, w2_.name_vn AS name_vn_32, p3_.id AS id_33, p3_.name AS name_34, p3_.name_vn AS name_vn_35, p3_.postal_code AS postal_code_36, s0_.station_area_type_id AS station_area_type_id_37, s0_.location_id AS location_id_38, s0_.station_open_profile_id AS station_open_profile_id_39, s0_.current_direction_id AS current_direction_id_40, l1_.ward_id AS ward_id_41, l1_.province_id AS province_id_42, l1_.operation_status_id AS operation_status_id_43, l1_.location_type_id AS location_type_id_44, w2_.province_id AS province_id_45, p3_.country_id AS country_id_46 FROM station s0_ LEFT JOIN location l1_ ON s0_.location_id = l1_.id LEFT JOIN ward w2_ ON l1_.ward_id = w2_.id LEFT JOIN province p3_ ON w2_.province_id = p3_.id LEFT JOIN station_area_type s4_ ON s0_.station_area_type_id = s4_.id LEFT JOIN current_direction c5_ ON s0_.current_direction_id = c5_.id WHERE s0_.visible = 1 AND s0_.deleted_at IS NULL AND s0_.id IN (10, 253, 233, 54, 17, 4, 87, 86, 130, 190, 158, 176, 6, 48, 267, 53, 7, 249, 222, 107);

SELECT
  status,
  car_box_status,
  bike_box_status
FROM
  station_status
WHERE
  station_id = ?
ORDER BY
  updated_at DESC
LIMIT
  1

SELECT status, car_box_status, bike_box_status FROM station_status WHERE station_id = 4 ORDER BY updated_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_vn AS name_vn_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  station_open_profile t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_vn AS name_vn_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM station_open_profile t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.start_time AS start_time_2,
  t0.end_time AS end_time_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.station_open_profile_id AS station_open_profile_id_7,
  t0.weekday_id AS weekday_id_8
FROM
  station_open_time t0
WHERE
  t0.station_open_profile_id = ?

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.station_open_profile_id AS station_open_profile_id_7, t0.weekday_id AS weekday_id_8 FROM station_open_time t0 WHERE t0.station_open_profile_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_vn AS name_vn_3,
  t0.shorten AS shorten_4
FROM
  weekday t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_vn AS name_vn_3, t0.shorten AS shorten_4 FROM weekday t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.file_path AS file_path_3,
  t0.original_name AS original_name_4,
  t0.mime_type AS mime_type_5,
  t0.file_size AS file_size_6,
  t0.entity_type AS entity_type_7,
  t0.entity_id AS entity_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11
FROM
  media t0
WHERE
  t0.entity_type = ?
  AND t0.entity_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_path AS file_path_3, t0.original_name AS original_name_4, t0.mime_type AS mime_type_5, t0.file_size AS file_size_6, t0.entity_type AS entity_type_7, t0.entity_id AS entity_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11 FROM media t0 WHERE t0.entity_type = 'App\\Entity\\Station' AND t0.entity_id = 4;

SELECT
  status,
  car_box_status,
  bike_box_status
FROM
  location_status
WHERE
  location_id = ?

SELECT status, car_box_status, bike_box_status FROM location_status WHERE location_id = 4;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.file_path AS file_path_3,
  t0.original_name AS original_name_4,
  t0.mime_type AS mime_type_5,
  t0.file_size AS file_size_6,
  t0.entity_type AS entity_type_7,
  t0.entity_id AS entity_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11
FROM
  media t0
WHERE
  t0.entity_type = ?
  AND t0.entity_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_path AS file_path_3, t0.original_name AS original_name_4, t0.mime_type AS mime_type_5, t0.file_size AS file_size_6, t0.entity_type AS entity_type_7, t0.entity_id AS entity_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11 FROM media t0 WHERE t0.entity_type = 'App\\Entity\\Location' AND t0.entity_id = 4;

SELECT
  status,
  car_box_status,
  bike_box_status
FROM
  station_status
WHERE
  station_id = ?
ORDER BY
  updated_at DESC
LIMIT
  1

SELECT status, car_box_status, bike_box_status FROM station_status WHERE station_id = 6 ORDER BY updated_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.file_path AS file_path_3,
  t0.original_name AS original_name_4,
  t0.mime_type AS mime_type_5,
  t0.file_size AS file_size_6,
  t0.entity_type AS entity_type_7,
  t0.entity_id AS entity_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11
FROM
  media t0
WHERE
  t0.entity_type = ?
  AND t0.entity_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_path AS file_path_3, t0.original_name AS original_name_4, t0.mime_type AS mime_type_5, t0.file_size AS file_size_6, t0.entity_type AS entity_type_7, t0.entity_id AS entity_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11 FROM media t0 WHERE t0.entity_type = 'App\\Entity\\Station' AND t0.entity_id = 6;

SELECT
  status,
  car_box_status,
  bike_box_status
FROM
  location_status
WHERE
  location_id = ?

SELECT status, car_box_status, bike_box_status FROM location_status WHERE location_id = 6;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.file_path AS file_path_3,
  t0.original_name AS original_name_4,
  t0.mime_type AS mime_type_5,
  t0.file_size AS file_size_6,
  t0.entity_type AS entity_type_7,
  t0.entity_id AS entity_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11
FROM
  media t0
WHERE
  t0.entity_type = ?
  AND t0.entity_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_path AS file_path_3, t0.original_name AS original_name_4, t0.mime_type AS mime_type_5, t0.file_size AS file_size_6, t0.entity_type AS entity_type_7, t0.entity_id AS entity_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11 FROM media t0 WHERE t0.entity_type = 'App\\Entity\\Location' AND t0.entity_id = 6;