Symfony Profiler

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
  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 = ?
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 = 'App\\Entity\\BikeBox' AND t0.entity_id = 23 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.vendor_id AS vendor_id_2,
  t0.unique_id AS unique_id_3,
  t0.name AS name_4,
  t0.standby_meter_value AS standby_meter_value_5,
  t0.meter_reading_enabled AS meter_reading_enabled_6,
  t0.is_franchised AS is_franchised_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.enabled AS enabled_11,
  t0.max_ampere AS max_ampere_12,
  t0.vehicle_type AS vehicle_type_13,
  t0.visible AS visible_14,
  t0.station_id AS station_id_15,
  t0.brand_id AS brand_id_16
FROM
  car_box t0
WHERE
  t0.station_id = ?

SELECT t0.id AS id_1, t0.vendor_id AS vendor_id_2, t0.unique_id AS unique_id_3, t0.name AS name_4, t0.standby_meter_value AS standby_meter_value_5, t0.meter_reading_enabled AS meter_reading_enabled_6, t0.is_franchised AS is_franchised_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.enabled AS enabled_11, t0.max_ampere AS max_ampere_12, t0.vehicle_type AS vehicle_type_13, t0.visible AS visible_14, t0.station_id AS station_id_15, t0.brand_id AS brand_id_16 FROM car_box t0 WHERE t0.station_id = 10;

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.name AS name_3,
  t0.vendor_id AS vendor_id_4,
  t0.standby_meter_value AS standby_meter_value_5,
  t0.meter_reading_enabled AS meter_reading_enabled_6,
  t0.is_franchised AS is_franchised_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.enabled AS enabled_11,
  t0.max_ampere AS max_ampere_12,
  t0.vehicle_type AS vehicle_type_13,
  t0.visible AS visible_14,
  t0.station_id AS station_id_15,
  t0.brand_id AS brand_id_16
FROM
  bike_box t0
WHERE
  t0.station_id = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.name AS name_3, t0.vendor_id AS vendor_id_4, t0.standby_meter_value AS standby_meter_value_5, t0.meter_reading_enabled AS meter_reading_enabled_6, t0.is_franchised AS is_franchised_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.enabled AS enabled_11, t0.max_ampere AS max_ampere_12, t0.vehicle_type AS vehicle_type_13, t0.visible AS visible_14, t0.station_id AS station_id_15, t0.brand_id AS brand_id_16 FROM bike_box t0 WHERE t0.station_id = 10;

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.unique_id AS unique_id_2,
  t0.status AS status_3,
  t0.order_on_box AS order_on_box_4,
  t0.qr_code AS qr_code_5,
  t0.qr_text AS qr_text_6,
  t0.name AS name_7,
  t0.is_reserved AS is_reserved_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.max_ampere AS max_ampere_12,
  t0.visible AS visible_13,
  t0.bike_box_id AS bike_box_id_14,
  t0.port_profile_id AS port_profile_id_15
FROM
  outlet t0
WHERE
  t0.bike_box_id = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.status AS status_3, t0.order_on_box AS order_on_box_4, t0.qr_code AS qr_code_5, t0.qr_text AS qr_text_6, t0.name AS name_7, t0.is_reserved AS is_reserved_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.max_ampere AS max_ampere_12, t0.visible AS visible_13, t0.bike_box_id AS bike_box_id_14, t0.port_profile_id AS port_profile_id_15 FROM outlet t0 WHERE t0.bike_box_id = 23;

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.name AS name_2,
  t0.name_vn AS name_vn_3,
  t0.outside AS outside_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7
FROM
  station_area_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_vn AS name_vn_3, t0.outside AS outside_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM station_area_type t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.power AS power_2,
  t0.unique_id AS unique_id_3,
  t0.status AS status_4,
  t0.order_on_box AS order_on_box_5,
  t0.qr_code AS qr_code_6,
  t0.qr_text AS qr_text_7,
  t0.phase AS phase_8,
  t0.name AS name_9,
  t0.is_reserved AS is_reserved_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.max_ampere AS max_ampere_14,
  t0.visible AS visible_15,
  t0.car_box_id AS car_box_id_16,
  t0.port_type_id AS port_type_id_17,
  t0.port_profile_id AS port_profile_id_18
FROM
  car_connector t0
WHERE
  t0.car_box_id = ?

SELECT t0.id AS id_1, t0.power AS power_2, t0.unique_id AS unique_id_3, t0.status AS status_4, t0.order_on_box AS order_on_box_5, t0.qr_code AS qr_code_6, t0.qr_text AS qr_text_7, t0.phase AS phase_8, t0.name AS name_9, t0.is_reserved AS is_reserved_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.max_ampere AS max_ampere_14, t0.visible AS visible_15, t0.car_box_id AS car_box_id_16, t0.port_type_id AS port_type_id_17, t0.port_profile_id AS port_profile_id_18 FROM car_connector t0 WHERE t0.car_box_id = 140;

SELECT
  status,
  online_status
FROM
  car_box_status
WHERE
  box_id = ?
  AND connector_id = ?
ORDER BY
  updated_at DESC
LIMIT
  1

SELECT status, online_status
                 FROM car_box_status
                 WHERE box_id = '244900000013'
                 AND connector_id = '1'
                 ORDER BY updated_at DESC
                 LIMIT 1;

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
  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
  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.start_time AS start_time_2,
  t0.end_time AS end_time_3,
  t0.charging_fee AS charging_fee_4,
  t0.activation_fee AS activation_fee_5,
  t0.parking_fee AS parking_fee_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.port_profile_id AS port_profile_id_10,
  t0.current_direction_id AS current_direction_id_11,
  t0.weekday_id AS weekday_id_12
FROM
  port_fee_schedule t0
WHERE
  t0.port_profile_id = ?

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.charging_fee AS charging_fee_4, t0.activation_fee AS activation_fee_5, t0.parking_fee AS parking_fee_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.port_profile_id AS port_profile_id_10, t0.current_direction_id AS current_direction_id_11, t0.weekday_id AS weekday_id_12 FROM port_fee_schedule t0 WHERE t0.port_profile_id = 2;

SELECT
  t0.id AS id_1,
  t0.type AS type_2
FROM
  current_direction t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2 FROM current_direction t0 WHERE t0.id = 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
  port_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 port_profile t0 WHERE t0.id = 2;

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
  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.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;