GET https://d.advroad.ru/api/skills?language=tk

Query Metrics

295 Database Queries
5 Different statements
60.65 ms Query time
0 Invalid entities
381 Managed entities

Grouped Statements

Show all queries

Time Count Info
27.47 ms
(45.29%)
134
SELECT name, description FROM skill_translations WHERE skill_id = ? AND language = ? LIMIT 1
Parameters:
[
  28
  "tk"
]
26.52 ms
(43.72%)
134
SELECT name, description FROM category_translations WHERE category_id = ? AND language = ? LIMIT 1
Parameters:
[
  17
  "tk"
]
5.40 ms
(8.90%)
25
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.synonyms AS synonyms_6, t0.icon AS icon_7, t0.image AS image_8, t0.sort_order AS sort_order_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.parent_id AS parent_id_12 FROM categories t0 WHERE t0.id = ?
Parameters:
[
  17
]
0.64 ms
(1.05%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.region_id AS region_id_8 FROM cities t0
Parameters:
[]
0.63 ms
(1.03%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.synonyms AS synonyms_6, t0.level AS level_7, t0.sort_order AS sort_order_8, t0.is_popular AS is_popular_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category_id AS category_id_13 FROM skills t0
Parameters:
[]

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\City 179
App\Entity\Skill 134
App\Entity\Region 37
App\Entity\Category 31

Entities Mapping

Class Mapping errors
App\Entity\City No errors.
App\Entity\Region No errors.
App\Entity\Skill No errors.
App\Entity\Category No errors.