GET https://dev.riva-siberia.ru/jobs

Query Metrics

5 Database Queries
5 Different statements
2.49 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.56 ms
(22.38%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.in_menu AS in_menu_4, t0.position AS position_5, t0.slug AS slug_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.parent_id AS parent_id_11 FROM regular_page t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "jobs"
  1
]
0.53 ms
(21.34%)
1
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.slug AS slug_4, t0.position AS position_5, t0.external_id AS external_id_6 FROM category t0 WHERE t0.active = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.51 ms
(20.50%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.in_menu AS in_menu_4, t0.position AS position_5, t0.slug AS slug_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.parent_id AS parent_id_11 FROM regular_page t0 WHERE t0.active = ? AND t0.in_menu = ? ORDER BY t0.position ASC
Parameters:
[
  1
  1
]
0.45 ms
(18.09%)
1
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.conditions AS conditions_4, t0.work AS work_5, t0.position AS position_6 FROM vacancy t0 WHERE t0.active = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.44 ms
(17.69%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.content AS content_4 FROM setting 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.

Entities Mapping

Class Mapping errors
App\Entity\RegularPage No errors.
App\Entity\Vacancy No errors.
App\Entity\Setting No errors.
App\Entity\Category No errors.
App\Entity\Product No errors.