Symfony Profiler

[
  "route" => "app_route_view"
  "route_parameters" => [
    "_route" => "app_route_view"
    "_controller" => "App\Controller\Public\Route\RouteViewAction"
    "slug" => "zelyonoe-kolco-moskvy-6d962abd2df9f275"
  ]
  "request_uri" => "https://esya.ru/route/zelyonoe-kolco-moskvy-6d962abd2df9f275"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "supporting_authenticators" => []
  "skipped_authenticators" => [
    "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
    "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
    "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
  ]
]

[
  "sql" => "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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "bsd2965380736"
    2 => "40.77.167.131"
    3 => ""
    4 => ""
    5 => ""
    6 => "/route/zelyonoe-kolco-moskvy-6d962abd2df9f275"
    7 => null
    8 => null
    9 => "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"
    10 => null
    11 => null
    12 => null
    13 => null
    14 => "GET"
    15 => null
    16 => "2026-11-15 00:10:07"
    17 => null
    18 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#493
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#493}
    3 => Doctrine\DBAL\ParameterType {#493}
    4 => Doctrine\DBAL\ParameterType {#493}
    5 => Doctrine\DBAL\ParameterType {#493}
    6 => Doctrine\DBAL\ParameterType {#493}
    7 => Doctrine\DBAL\ParameterType {#493}
    8 => Doctrine\DBAL\ParameterType {#493}
    9 => Doctrine\DBAL\ParameterType {#493}
    10 => Doctrine\DBAL\ParameterType {#493}
    11 => Doctrine\DBAL\ParameterType {#493}
    12 => Doctrine\DBAL\ParameterType {#493}
    13 => Doctrine\DBAL\ParameterType {#493}
    14 => Doctrine\DBAL\ParameterType {#493}
    15 => Doctrine\DBAL\ParameterType {#493}
    16 => Doctrine\DBAL\ParameterType {#493}
    17 => Doctrine\DBAL\ParameterType {#493}
    18 => Doctrine\DBAL\ParameterType {#493}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "zelyonoe-kolco-moskvy-6d962abd2df9f275"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#493
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "019f0439-80b0-7783-8fc3-0822999a29a9"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#493
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "018f45a9-1071-7ecd-9bc3-32fc909aa846"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#493
      +name: "STRING"
    }
  ]
]

[
  "key" => "weather_svc_55.84_37.59"
]

[
  "http_code" => 200
  "url" => "https://api.openweathermap.org/data/2.5/weather?lat=55.84&lon=37.59&units=metric&appid=cb48d347392b07d2f4481269d303ce01"
  "total_time" => 0.246128
]

[
  "sql" => "INSERT INTO cache_weather (hash, data, is_crop, data_timestamp, created_at) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "55.84_37.59"
    2 => "{"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"}"
    3 => 0
    4 => "2026-11-15 00:10:07"
    5 => "2026-11-15 00:10:07"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#493
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#493}
    3 => Doctrine\DBAL\ParameterType {#2878
      +name: "BOOLEAN"
    }
    4 => Doctrine\DBAL\ParameterType {#493}
    5 => Doctrine\DBAL\ParameterType {#493}
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "018f45a8-c9ce-797d-9aa2-13ca9d5da79c"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#493
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "018f45a9-1071-7ecd-9bc3-32fc909aa846"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#493
      +name: "STRING"
    }
  ]
]

[
  "profiler_url" => "https://esya.ru/_profiler/80faf2"
]