Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO stat (
  owner_cookie, ip, google_id, yandex_id,
  microsoft_id, path, query, referer,
  user_agent, utm_source, utm_medium,
  utm_term, user_role, method, user_id,
  created_at, owner_id, owner_unlogined_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO stat (owner_cookie, ip, google_id, yandex_id, microsoft_id, path, query, referer, user_agent, utm_source, utm_medium, utm_term, user_role, method, user_id, created_at, owner_id, owner_unlogined_id) VALUES ('bsd2965380736', '40.77.167.131', '', '', '', '/route/zelyonoe-kolco-moskvy-6d962abd2df9f275', NULL, NULL, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36', NULL, NULL, NULL, NULL, 'GET', NULL, '2026-11-15 00:10:07', NULL, NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.scale AS scale_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.legend AS legend_6,
  t0.website AS website_7,
  t0.distance AS distance_8,
  t0.is_publish AS is_publish_9,
  t0.brouter_url AS brouter_url_10,
  t0.osmo_id AS osmo_id_11,
  t0.timezone_start AS timezone_start_12,
  t0.timezone_finish AS timezone_finish_13,
  t0.event_count AS event_count_14,
  t0.difficulty AS difficulty_15,
  t0.season AS season_16,
  t0.is_deleted AS is_deleted_17,
  t0.is_shared AS is_shared_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.point_start AS point_start_21,
  t0.point_finish AS point_finish_22,
  t0.group_id AS group_id_23,
  t0.owner_id AS owner_id_24,
  t0.geo_data_id AS geo_data_id_25
FROM
  route t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.scale AS scale_3, t0.name AS name_4, t0.description AS description_5, t0.legend AS legend_6, t0.website AS website_7, t0.distance AS distance_8, t0.is_publish AS is_publish_9, t0.brouter_url AS brouter_url_10, t0.osmo_id AS osmo_id_11, t0.timezone_start AS timezone_start_12, t0.timezone_finish AS timezone_finish_13, t0.event_count AS event_count_14, t0.difficulty AS difficulty_15, t0.season AS season_16, t0.is_deleted AS is_deleted_17, t0.is_shared AS is_shared_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.point_start AS point_start_21, t0.point_finish AS point_finish_22, t0.group_id AS group_id_23, t0.owner_id AS owner_id_24, t0.geo_data_id AS geo_data_id_25 FROM route t0 WHERE t0.slug = 'zelyonoe-kolco-moskvy-6d962abd2df9f275' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.lines AS lines_2,
  t0.points AS points_3,
  t0.size AS size_4,
  t0.hash AS hash_5,
  t0.is_virtual AS is_virtual_6,
  t0.is_main AS is_main_7,
  t0.version AS version_8,
  t0.count_lines AS count_lines_9,
  t0.count_points AS count_points_10,
  t0.thumbnail AS thumbnail_11,
  t0.bbox AS bbox_12,
  t0.track_hash_direct AS track_hash_direct_13,
  t0.track_hash_undirect AS track_hash_undirect_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16
FROM
  geo_data_json t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lines AS lines_2, t0.points AS points_3, t0.size AS size_4, t0.hash AS hash_5, t0.is_virtual AS is_virtual_6, t0.is_main AS is_main_7, t0.version AS version_8, t0.count_lines AS count_lines_9, t0.count_points AS count_points_10, t0.thumbnail AS thumbnail_11, t0.bbox AS bbox_12, t0.track_hash_direct AS track_hash_direct_13, t0.track_hash_undirect AS track_hash_undirect_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16 FROM geo_data_json t0 WHERE t0.id = '019f0439-80b0-7783-8fc3-0822999a29a9';

SELECT
  t0.match_percentage_direct AS match_percentage_direct_1,
  t0.match_percentage_undirect AS match_percentage_undirect_2,
  t0.is_completed_direct AS is_completed_direct_3,
  t0.is_completed_undirect AS is_completed_undirect_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.route_id AS route_id_7,
  t0.trip_id AS trip_id_8,
  t0.user_id AS user_id_9
FROM
  route_trip t0
WHERE
  t0.route_id = ?

SELECT t0.match_percentage_direct AS match_percentage_direct_1, t0.match_percentage_undirect AS match_percentage_undirect_2, t0.is_completed_direct AS is_completed_direct_3, t0.is_completed_undirect AS is_completed_undirect_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.route_id AS route_id_7, t0.trip_id AS trip_id_8, t0.user_id AS user_id_9 FROM route_trip t0 WHERE t0.route_id = '018f45a9-1071-7ecd-9bc3-32fc909aa846';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO cache_weather (
  hash, data, is_crop, data_timestamp,
  created_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO cache_weather (hash, data, is_crop, data_timestamp, created_at) VALUES ('55.84_37.59', '{\"main\":\"Clouds\",\"icon\":\"https:\\/\\/openweathermap.org\\/img\\/w\\/03n.png\",\"iconTitle\":\"scattered clouds\",\"clouds\":40,\"temperature\":1.3,\"temperature_feel\":-3.8,\"humidity\":86.0,\"pressure\":758.0,\"wind_speed\":22.0,\"wind_deg\":230,\"wind_gust\":0,\"visibility\":10000,\"name\":\"Likhobory\",\"sunrise\":\"08:04\",\"sunset\":\"16:23\"}', 0, '2026-11-15 00:10:07', '2026-11-15 00:10:07');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.slug AS slug_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.name AS name_6,
  t0.gender AS gender_7,
  t0.timezone AS timezone_8,
  t0.locale AS locale_9,
  t0.latitude AS latitude_10,
  t0.longitude AS longitude_11,
  t0.is_verified AS is_verified_12,
  t0.is_active AS is_active_13,
  t0.logined_at AS logined_at_14,
  t0.password_updated_at AS password_updated_at_15,
  t0.day_limit AS day_limit_16,
  t0.stat_transport_type AS stat_transport_type_17,
  t0.email_authentication_code AS email_authentication_code_18,
  t0.email_authentication_enabled AS email_authentication_enabled_19,
  t0.google_authenticator_enabled AS google_authenticator_enabled_20,
  t0.google_authenticator_secret AS google_authenticator_secret_21,
  t0.image_name AS image_name_22,
  t0.image_size AS image_size_23,
  t0.updated_at AS updated_at_24,
  t0.google_id AS google_id_25,
  t0.google_access_token AS google_access_token_26,
  t0.birthdate AS birthdate_27,
  t0.contact_phone AS contact_phone_28,
  t0.contact_email AS contact_email_29,
  t0.contact_link AS contact_link_30,
  t0.contact_telegram AS contact_telegram_31,
  t0.contact_meshtastic AS contact_meshtastic_32,
  t0.real_name AS real_name_33,
  t0.photo_name AS photo_name_34,
  t0.navigator_model AS navigator_model_35,
  t0.wear_top_size AS wear_top_size_36,
  t0.wear_bottom_size AS wear_bottom_size_37,
  t0.created_at AS created_at_38
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.slug AS slug_3, t0.roles AS roles_4, t0.password AS password_5, t0.name AS name_6, t0.gender AS gender_7, t0.timezone AS timezone_8, t0.locale AS locale_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.is_verified AS is_verified_12, t0.is_active AS is_active_13, t0.logined_at AS logined_at_14, t0.password_updated_at AS password_updated_at_15, t0.day_limit AS day_limit_16, t0.stat_transport_type AS stat_transport_type_17, t0.email_authentication_code AS email_authentication_code_18, t0.email_authentication_enabled AS email_authentication_enabled_19, t0.google_authenticator_enabled AS google_authenticator_enabled_20, t0.google_authenticator_secret AS google_authenticator_secret_21, t0.image_name AS image_name_22, t0.image_size AS image_size_23, t0.updated_at AS updated_at_24, t0.google_id AS google_id_25, t0.google_access_token AS google_access_token_26, t0.birthdate AS birthdate_27, t0.contact_phone AS contact_phone_28, t0.contact_email AS contact_email_29, t0.contact_link AS contact_link_30, t0.contact_telegram AS contact_telegram_31, t0.contact_meshtastic AS contact_meshtastic_32, t0.real_name AS real_name_33, t0.photo_name AS photo_name_34, t0.navigator_model AS navigator_model_35, t0.wear_top_size AS wear_top_size_36, t0.wear_bottom_size AS wear_bottom_size_37, t0.created_at AS created_at_38 FROM "user" t0 WHERE t0.id = '018f45a8-c9ce-797d-9aa2-13ca9d5da79c';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_rp AS name_rp_3,
  t0.trip_name AS trip_name_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.is_personal AS is_personal_7,
  t0.is_muscle AS is_muscle_8,
  t0.is_eco AS is_eco_9,
  t0.gpx_type AS gpx_type_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  catalog_transport_type t0
  INNER JOIN route_catalog_transport_type ON t0.id = route_catalog_transport_type.catalog_transport_type_id
WHERE
  route_catalog_transport_type.route_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_rp AS name_rp_3, t0.trip_name AS trip_name_4, t0.icon AS icon_5, t0.color AS color_6, t0.is_personal AS is_personal_7, t0.is_muscle AS is_muscle_8, t0.is_eco AS is_eco_9, t0.gpx_type AS gpx_type_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM catalog_transport_type t0 INNER JOIN route_catalog_transport_type ON t0.id = route_catalog_transport_type.catalog_transport_type_id WHERE route_catalog_transport_type.route_id = '018f45a9-1071-7ecd-9bc3-32fc909aa846';