GET https://esya.ru/MixWheels/piterring-parki-promzony-i-zabroshki-09-08-2021

Query Metrics

22 Database Queries
16 Different statements
11.28 ms Query time
5 Invalid entities
15 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.02 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.template_social AS template_social_4, t0.slug AS slug_5, t0.is_private AS is_private_6, t0.timezone AS timezone_7, t0.website AS website_8, t0.link_vk AS link_vk_9, t0.link_tg AS link_tg_10, t0.contact_name AS contact_name_11, t0.contact_phone AS contact_phone_12, t0.contact_link AS contact_link_13, t0.image_name AS image_name_14, t0.image_size AS image_size_15, t0.count_users AS count_users_16, t0.count_points AS count_points_17, t0.count_routes AS count_routes_18, t0.count_events AS count_events_19, t0.s3_access_key AS s3_access_key_20, t0.s3_base_url AS s3_base_url_21, t0.s3_bucket_name AS s3_bucket_name_22, t0.s3_endpoint AS s3_endpoint_23, t0.s3_region AS s3_region_24, t0.s3_secret_key AS s3_secret_key_25, t0.banner_name AS banner_name_26, t0.banner_size AS banner_size_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.owner_id AS owner_id_30 FROM "group" t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "MixWheels"
]
2 0.14 ms
"START TRANSACTION"
Parameters:
[]
3 0.88 ms
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "bsd1134438395"
  "114.119.136.99"
  ""
  ""
  ""
  "/MixWheels/piterring-parki-promzony-i-zabroshki-09-08-2021"
  null
  "https://esya.ru/MixWheels/piterring-parki-promzony-i-zabroshki-09-08-2021"
  "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (HTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
  null
  null
  null
  null
  "GET"
  null
  "2026-11-15 00:09:43"
  null
  null
]
4 0.55 ms
"COMMIT"
Parameters:
[]
5 1.05 ms
SELECT e0_.id AS id_0, e0_.status AS status_1, e0_.name AS name_2, e0_.description AS description_3, e0_.slug AS slug_4, e0_.trip_type AS trip_type_5, e0_.time_start AS time_start_6, e0_.time_finish AS time_finish_7, e0_.distance AS distance_8, e0_.distance_fact AS distance_fact_9, e0_.proportion AS proportion_10, e0_.count_people_start AS count_people_start_11, e0_.count_people_max AS count_people_max_12, e0_.count_people_finish AS count_people_finish_13, e0_.link_social AS link_social_14, e0_.link_photoalbum AS link_photoalbum_15, e0_.contact_name AS contact_name_16, e0_.contact_phone AS contact_phone_17, e0_.contact_link AS contact_link_18, e0_.weather AS weather_19, e0_.is_active AS is_active_20, e0_.is_publish AS is_publish_21, e0_.publish_time AS publish_time_22, e0_.unpublish_time AS unpublish_time_23, e0_.is_deleted AS is_deleted_24, e0_.parent_mode AS parent_mode_25, e0_.progress AS progress_26, e0_.live_route_progress AS live_route_progress_27, e0_.difficulty AS difficulty_28, e0_.difficulty_fact AS difficulty_fact_29, e0_.count_photo AS count_photo_30, e0_.avg_event_user_rating AS avg_event_user_rating_31, e0_.created_at AS created_at_32, e0_.updated_at AS updated_at_33, r1_.id AS id_34, r1_.slug AS slug_35, r1_.scale AS scale_36, r1_.name AS name_37, r1_.description AS description_38, r1_.legend AS legend_39, r1_.website AS website_40, r1_.distance AS distance_41, r1_.is_publish AS is_publish_42, r1_.brouter_url AS brouter_url_43, r1_.osmo_id AS osmo_id_44, r1_.timezone_start AS timezone_start_45, r1_.timezone_finish AS timezone_finish_46, r1_.event_count AS event_count_47, r1_.difficulty AS difficulty_48, r1_.season AS season_49, r1_.is_deleted AS is_deleted_50, r1_.is_shared AS is_shared_51, r1_.created_at AS created_at_52, r1_.updated_at AS updated_at_53, r1_.point_start AS point_start_54, r1_.point_finish AS point_finish_55, g2_.id AS id_56, g2_.name AS name_57, g2_.description AS description_58, g2_.template_social AS template_social_59, g2_.slug AS slug_60, g2_.is_private AS is_private_61, g2_.timezone AS timezone_62, g2_.website AS website_63, g2_.link_vk AS link_vk_64, g2_.link_tg AS link_tg_65, g2_.contact_name AS contact_name_66, g2_.contact_phone AS contact_phone_67, g2_.contact_link AS contact_link_68, g2_.image_name AS image_name_69, g2_.image_size AS image_size_70, g2_.count_users AS count_users_71, g2_.count_points AS count_points_72, g2_.count_routes AS count_routes_73, g2_.count_events AS count_events_74, g2_.s3_access_key AS s3_access_key_75, g2_.s3_base_url AS s3_base_url_76, g2_.s3_bucket_name AS s3_bucket_name_77, g2_.s3_endpoint AS s3_endpoint_78, g2_.s3_region AS s3_region_79, g2_.s3_secret_key AS s3_secret_key_80, g2_.banner_name AS banner_name_81, g2_.banner_size AS banner_size_82, g2_.created_at AS created_at_83, g2_.updated_at AS updated_at_84, u3_.id AS id_85, u3_.email AS email_86, u3_.slug AS slug_87, u3_.roles AS roles_88, u3_.password AS password_89, u3_.name AS name_90, u3_.gender AS gender_91, u3_.timezone AS timezone_92, u3_.locale AS locale_93, u3_.latitude AS latitude_94, u3_.longitude AS longitude_95, u3_.is_verified AS is_verified_96, u3_.is_active AS is_active_97, u3_.logined_at AS logined_at_98, u3_.password_updated_at AS password_updated_at_99, u3_.day_limit AS day_limit_100, u3_.stat_transport_type AS stat_transport_type_101, u3_.email_authentication_code AS email_authentication_code_102, u3_.email_authentication_enabled AS email_authentication_enabled_103, u3_.google_authenticator_enabled AS google_authenticator_enabled_104, u3_.google_authenticator_secret AS google_authenticator_secret_105, u3_.image_name AS image_name_106, u3_.image_size AS image_size_107, u3_.updated_at AS updated_at_108, u3_.google_id AS google_id_109, u3_.google_access_token AS google_access_token_110, u3_.birthdate AS birthdate_111, u3_.contact_phone AS contact_phone_112, u3_.contact_email AS contact_email_113, u3_.contact_link AS contact_link_114, u3_.contact_telegram AS contact_telegram_115, u3_.contact_meshtastic AS contact_meshtastic_116, u3_.real_name AS real_name_117, u3_.photo_name AS photo_name_118, u3_.navigator_model AS navigator_model_119, u3_.wear_top_size AS wear_top_size_120, u3_.wear_bottom_size AS wear_bottom_size_121, u3_.created_at AS created_at_122, e0_.group_id AS group_id_123, e0_.owner_id AS owner_id_124, e0_.parent_id AS parent_id_125, e0_.route_id AS route_id_126, r1_.group_id AS group_id_127, r1_.owner_id AS owner_id_128, r1_.geo_data_id AS geo_data_id_129, g2_.owner_id AS owner_id_130 FROM event e0_ INNER JOIN route r1_ ON e0_.route_id = r1_.id INNER JOIN "group" g2_ ON e0_.group_id = g2_.id INNER JOIN "user" u3_ ON e0_.owner_id = u3_.id WHERE e0_.is_deleted = false AND e0_.slug = ?
Parameters:
[
  "piterring-parki-promzony-i-zabroshki-09-08-2021"
]
6 0.37 ms
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.osm_type AS osm_type_4, t0.osm_id AS osm_id_5, t0.data AS data_6, t0.place_id AS place_id_7, t0.place_latitude AS place_latitude_8, t0.place_longitude AS place_longitude_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM cache_nominatim_reverse t0 WHERE t0.latitude = ? AND t0.longitude = ? LIMIT 1
Parameters:
[
  59.95633
  30.31943
]
7 0.58 ms
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.query AS query_3, t0.data AS data_4, t0.data_timestamp AS data_timestamp_5, t0.created_at AS created_at_6 FROM cache_overpass t0 WHERE t0.hash = ? LIMIT 1
Parameters:
[
  "f96e3a51ff09aa6f20862df65f4c994048872fa8e4ef8f6fbfe0e88f6ac8e54e"
]
8 0.74 ms
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.query AS query_3, t0.data AS data_4, t0.data_timestamp AS data_timestamp_5, t0.created_at AS created_at_6 FROM cache_overpass t0 WHERE t0.hash = ? LIMIT 1
Parameters:
[
  "679aceec14912ac2d7e21fd95e18179f47d7df44ea4e651798b51d44c89e68bd"
]
9 0.25 ms
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.query AS query_3, t0.data AS data_4, t0.data_timestamp AS data_timestamp_5, t0.created_at AS created_at_6 FROM cache_overpass t0 WHERE t0.hash = ? LIMIT 1
Parameters:
[
  "b251c4442863a8582d433c7f6f0ebcfc97226a613d6ed44940373917522491ce"
]
10 0.53 ms
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.osm_type AS osm_type_4, t0.osm_id AS osm_id_5, t0.data AS data_6, t0.place_id AS place_id_7, t0.place_latitude AS place_latitude_8, t0.place_longitude AS place_longitude_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM cache_nominatim_reverse t0 WHERE t0.latitude = ? AND t0.longitude = ? LIMIT 1
Parameters:
[
  59.95505
  30.35583
]
11 0.25 ms
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.query AS query_3, t0.data AS data_4, t0.data_timestamp AS data_timestamp_5, t0.created_at AS created_at_6 FROM cache_overpass t0 WHERE t0.hash = ? LIMIT 1
Parameters:
[
  "5d8e580a63c07445b9ed5b4e2dd2bf820301506e36301cbe34b147c829fbe933"
]
12 0.51 ms
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.query AS query_3, t0.data AS data_4, t0.data_timestamp AS data_timestamp_5, t0.created_at AS created_at_6 FROM cache_overpass t0 WHERE t0.hash = ? LIMIT 1
Parameters:
[
  "d0e184d42e3236e676a729687b3e2c71162792a8d6dbd9235cbcf8bd5c7fe2ad"
]
13 0.46 ms
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.query AS query_3, t0.data AS data_4, t0.data_timestamp AS data_timestamp_5, t0.created_at AS created_at_6 FROM cache_overpass t0 WHERE t0.hash = ? LIMIT 1
Parameters:
[
  "bda3ffa2561accf3f703a5f67e3147ab4a4f44d887b26d55c8e661bfa60a7a35"
]
14 0.25 ms
SELECT t0.is_primary AS is_primary_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.event_id AS event_id_4, t0.trip_id AS trip_id_5, t0.route_trip_route_id AS route_trip_route_id_6, t0.route_trip_trip_id AS route_trip_trip_id_7, t0.user_id AS user_id_8, t0.event_user_id AS event_user_id_9 FROM event_trip t0 WHERE t0.event_id = ?
Parameters:
[
  "018f45a8-e1c1-7ca7-8ae2-3840c6dba32b"
]
15 0.22 ms
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 = ?
Parameters:
[
  "018f45a8-e1c1-7ca7-8ae2-3840c62263ab"
]
16 0.71 ms
SELECT e0_.id AS id_0, e0_.join_at AS join_at_1, e0_.leave_at AS leave_at_2, e0_.time_start AS time_start_3, e0_.time_finish AS time_finish_4, e0_.rating AS rating_5, e0_.review AS review_6, e0_.difficulty AS difficulty_7, e0_.comment AS comment_8, e0_.status AS status_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, g1_.id AS id_12, g1_.show_private_data AS show_private_data_13, g1_.show_trip_stat AS show_trip_stat_14, g1_.date_join AS date_join_15, g1_.date_leave AS date_leave_16, g1_.role AS role_17, g1_.name AS name_18, g1_.status AS status_19, g1_.subscribe_email AS subscribe_email_20, g1_.subscribe_sms AS subscribe_sms_21, g1_.subscribe_telegram AS subscribe_telegram_22, g1_.created_at AS created_at_23, g1_.updated_at AS updated_at_24, u2_.id AS id_25, u2_.email AS email_26, u2_.slug AS slug_27, u2_.roles AS roles_28, u2_.password AS password_29, u2_.name AS name_30, u2_.gender AS gender_31, u2_.timezone AS timezone_32, u2_.locale AS locale_33, u2_.latitude AS latitude_34, u2_.longitude AS longitude_35, u2_.is_verified AS is_verified_36, u2_.is_active AS is_active_37, u2_.logined_at AS logined_at_38, u2_.password_updated_at AS password_updated_at_39, u2_.day_limit AS day_limit_40, u2_.stat_transport_type AS stat_transport_type_41, u2_.email_authentication_code AS email_authentication_code_42, u2_.email_authentication_enabled AS email_authentication_enabled_43, u2_.google_authenticator_enabled AS google_authenticator_enabled_44, u2_.google_authenticator_secret AS google_authenticator_secret_45, u2_.image_name AS image_name_46, u2_.image_size AS image_size_47, u2_.updated_at AS updated_at_48, u2_.google_id AS google_id_49, u2_.google_access_token AS google_access_token_50, u2_.birthdate AS birthdate_51, u2_.contact_phone AS contact_phone_52, u2_.contact_email AS contact_email_53, u2_.contact_link AS contact_link_54, u2_.contact_telegram AS contact_telegram_55, u2_.contact_meshtastic AS contact_meshtastic_56, u2_.real_name AS real_name_57, u2_.photo_name AS photo_name_58, u2_.navigator_model AS navigator_model_59, u2_.wear_top_size AS wear_top_size_60, u2_.wear_bottom_size AS wear_bottom_size_61, u2_.created_at AS created_at_62, e0_.group_id AS group_id_63, e0_.event_id AS event_id_64, e0_.group_user_id AS group_user_id_65, g1_.group_id AS group_id_66, g1_.user_id AS user_id_67 FROM event_user e0_ INNER JOIN group_user g1_ ON e0_.group_user_id = g1_.id INNER JOIN "user" u2_ ON g1_.user_id = u2_.id WHERE e0_.event_id = ? AND (e0_.status IS NULL OR e0_.status <> ?) ORDER BY e0_.join_at ASC
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#34427
    __toString(): "018f45a8-e1c1-7ca7-8ae2-3840c6dba32b"
  }
  "missing"
]
17 0.24 ms
SELECT t0.id AS id_1, t0.rating_overall AS rating_overall_2, t0.rating_interest AS rating_interest_3, t0.rating_track_quality AS rating_track_quality_4, t0.rating_pace_balance AS rating_pace_balance_5, t0.rating_organizer_care AS rating_organizer_care_6, t0.difficulty AS difficulty_7, t0.text AS text_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.group_id AS group_id_11, t0.group_user_id AS group_user_id_12, t0.event_user_id AS event_user_id_13, t0.event_id AS event_id_14 FROM event_feedback t0 WHERE t0.event_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  "018f45a8-e1c1-7ca7-8ae2-3840c6dba32b"
]
18 1.16 ms
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 = ?
Parameters:
[
  "019f0439-7c3a-7af9-9dec-2b199e6813e6"
]
19 0.55 ms
SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.name AS name_2, e0_.time_start AS time_start_3 FROM event e0_ WHERE e0_.is_active = ? AND e0_.id <> ? AND e0_.status IN (?, ?, ?, ?) AND e0_.group_id = ? AND e0_.time_start <= ? ORDER BY e0_.time_start DESC, e0_.id DESC LIMIT 1
Parameters:
[
  1
  Symfony\Component\Uid\UuidV7 {#34427
    __toString(): "018f45a8-e1c1-7ca7-8ae2-3840c6dba32b"
  }
  "planned"
  "in_progress"
  "finish"
  "completed"
  Symfony\Component\Uid\UuidV7 {#34526
    __toString(): "018f45a8-c9ec-743c-9017-fe3989e24713"
  }
  "2021-08-09 16:30:00"
]
20 0.30 ms
SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.name AS name_2, e0_.time_start AS time_start_3 FROM event e0_ WHERE e0_.is_active = ? AND e0_.id <> ? AND e0_.status IN (?, ?, ?, ?) AND e0_.group_id = ? AND e0_.time_start >= ? ORDER BY e0_.time_start ASC, e0_.id ASC LIMIT 1
Parameters:
[
  1
  Symfony\Component\Uid\UuidV7 {#34427
    __toString(): "018f45a8-e1c1-7ca7-8ae2-3840c6dba32b"
  }
  "planned"
  "in_progress"
  "finish"
  "completed"
  Symfony\Component\Uid\UuidV7 {#34526
    __toString(): "018f45a8-c9ec-743c-9017-fe3989e24713"
  }
  "2021-08-09 16:30:00"
]
21 0.22 ms
SELECT t0.id AS id_1, t0.join_at AS join_at_2, t0.leave_at AS leave_at_3, t0.time_start AS time_start_4, t0.time_finish AS time_finish_5, t0.rating AS rating_6, t0.review AS review_7, t0.difficulty AS difficulty_8, t0.comment AS comment_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.group_id AS group_id_13, t0.event_id AS event_id_14, t0.group_user_id AS group_user_id_15 FROM event_user t0 WHERE t0.event_id = ?
Parameters:
[
  "018f45a8-e1c1-7ca7-8ae2-3840c6dba32b"
]
22 0.29 ms
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 = ?
Parameters:
[
  "018f45a8-e1c1-7ca7-8ae2-3840c62263ab"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CacheOverpass 6
App\Entity\CacheNominatimReverse 2
App\Entity\Group 1
App\Entity\User 1
App\Entity\Stat 1
App\Entity\Event 1
App\Entity\Route 1
App\Entity\GeoDataJson 1
App\Entity\CatalogTransportType 1

Entities Mapping

Class Mapping errors
App\Entity\Group No errors.
App\Entity\User
  • The field App\Entity\User#ownedGroups is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Group#owner does not contain the required 'inversedBy: "ownedGroups"' attribute.
App\Entity\Stat No errors.
App\Entity\Event
  • The field App\Entity\Event#eventUsers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\EventUser#event does not contain the required 'inversedBy: "eventUsers"' attribute.
App\Entity\Route No errors.
App\Entity\GeoDataJson No errors.
App\Entity\EventTrip No errors.
App\Entity\EventFeedback No errors.
App\Entity\EventUser No errors.
App\Entity\RouteTrip No errors.
App\Entity\RouteSharing No errors.
App\Entity\CatalogTransportType No errors.
App\Entity\CacheNominatimReverse No errors.
App\Entity\Place No errors.
App\Entity\CacheOverpass No errors.
App\Entity\Trip
  • The association App\Entity\Trip#linkedEvent refers to the inverse side field App\Entity\Event#trips which does not exist.
App\Entity\Transport
  • The association App\Entity\Transport#owner refers to the inverse side field App\Entity\User#transports which does not exist.
App\Entity\TripStat No errors.
App\Entity\TripGeoIndex No errors.
App\Entity\TripGeoDataJson No errors.
App\Entity\Journey No errors.
App\Entity\GroupUser
  • The field App\Entity\GroupUser#eventReviews is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\EventFeedback#groupUser does not contain the required 'inversedBy: "eventReviews"' attribute.
App\Entity\CacheWeather No errors.
App\Entity\DevicePairingSession No errors.
App\Entity\TrackingLink No errors.
App\Entity\PlaceShort No errors.
App\Entity\PermanentRedirect No errors.
App\Entity\EventPhoto No errors.
App\Entity\TransportDetail No errors.
App\Entity\Family No errors.
App\Entity\TrackingDevice No errors.
App\Entity\PlaceLink No errors.
App\Entity\TrackingPoint No errors.
App\Entity\TripHundredMeter No errors.
App\Entity\TransportDetailPeriod No errors.
App\Entity\FamilyMember No errors.
App\Entity\OsmoLinkViewStat No errors.
App\Entity\UserGeoZone No errors.