GET https://esya.ru/sitemap.xml

Query Metrics

8 Database Queries
7 Different statements
6.29 ms Query time
5 Invalid entities
1035 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.18 ms
"START TRANSACTION"
Parameters:
[]
2 0.66 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:
[
  "bsd2595472925"
  "95.108.213.126"
  ""
  ""
  ""
  "/sitemap.xml"
  null
  null
  "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
  null
  null
  null
  null
  "GET"
  null
  "2026-11-15 00:17:37"
  null
  null
]
3 0.28 ms
"COMMIT"
Parameters:
[]
4 0.35 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.is_private = ? ORDER BY t0.created_at ASC
Parameters:
[
  0
]
5 1.56 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.trip_type AS trip_type_6, t0.time_start AS time_start_7, t0.time_finish AS time_finish_8, t0.distance AS distance_9, t0.distance_fact AS distance_fact_10, t0.proportion AS proportion_11, t0.count_people_start AS count_people_start_12, t0.count_people_max AS count_people_max_13, t0.count_people_finish AS count_people_finish_14, t0.link_social AS link_social_15, t0.link_photoalbum AS link_photoalbum_16, t0.contact_name AS contact_name_17, t0.contact_phone AS contact_phone_18, t0.contact_link AS contact_link_19, t0.weather AS weather_20, t0.is_active AS is_active_21, t0.is_publish AS is_publish_22, t0.publish_time AS publish_time_23, t0.unpublish_time AS unpublish_time_24, t0.is_deleted AS is_deleted_25, t0.parent_mode AS parent_mode_26, t0.progress AS progress_27, t0.live_route_progress AS live_route_progress_28, t0.difficulty AS difficulty_29, t0.difficulty_fact AS difficulty_fact_30, t0.count_photo AS count_photo_31, t0.avg_event_user_rating AS avg_event_user_rating_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.group_id AS group_id_35, t0.owner_id AS owner_id_36, t0.parent_id AS parent_id_37, t0.route_id AS route_id_38 FROM event t0 WHERE t0.is_active = ? ORDER BY t0.time_start ASC
Parameters:
[
  1
]
6 2.74 ms
SELECT trip.id, trip.updated_at
            FROM trip
            WHERE trip.is_private = false AND trip.is_deleted = false AND trip.distance > 10
            ORDER BY trip.updated_at DESC
            LIMIT 50
Parameters:
[]
7 0.32 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.id = ?
Parameters:
[
  "018f45a8-c9e1-73e2-8a49-68d2220b44ef"
]
8 0.21 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.id = ?
Parameters:
[
  "018f45a8-c9e6-7cca-b50c-484c7d264828"
]

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\Event 498
App\Entity\Route 498
App\Entity\Group 22
App\Entity\User 16
App\Entity\Stat 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.