GET https://ava.gipa.ge/api/menu?locale=ka&slug=main-menu

Query Metrics

9 Database Queries
4 Different statements
23.55 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 4.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM menu t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "main-menu"
]
2 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM menu t0 WHERE t0.id = ?
Parameters:
[
  4
]
3 15.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.visible AS visible_4, t0.external AS external_5, t0.icon AS icon_6, t0.position AS position_7, t0.weight AS weight_8, t0.menu_id AS menu_id_9 FROM menu_item t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  4
]
4 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.visible AS visible_4, t0.external AS external_5, t0.icon AS icon_6, t0.position AS position_7, t0.weight AS weight_8, t0.menu_id AS menu_id_9 FROM menu_item t0 WHERE t0.id = ?
Parameters:
[
  10
]
5 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.visible AS visible_4, t0.external AS external_5, t0.icon AS icon_6, t0.position AS position_7, t0.weight AS weight_8, t0.menu_id AS menu_id_9 FROM menu_item t0 WHERE t0.id = ?
Parameters:
[
  11
]
6 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.visible AS visible_4, t0.external AS external_5, t0.icon AS icon_6, t0.position AS position_7, t0.weight AS weight_8, t0.menu_id AS menu_id_9 FROM menu_item t0 WHERE t0.id = ?
Parameters:
[
  12
]
7 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.visible AS visible_4, t0.external AS external_5, t0.icon AS icon_6, t0.position AS position_7, t0.weight AS weight_8, t0.menu_id AS menu_id_9 FROM menu_item t0 WHERE t0.id = ?
Parameters:
[
  13
]
8 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.visible AS visible_4, t0.external AS external_5, t0.icon AS icon_6, t0.position AS position_7, t0.weight AS weight_8, t0.menu_id AS menu_id_9 FROM menu_item t0 WHERE t0.id = ?
Parameters:
[
  14
]
9 0.82 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.visible AS visible_4, t0.external AS external_5, t0.icon AS icon_6, t0.position AS position_7, t0.weight AS weight_8, t0.menu_id AS menu_id_9 FROM menu_item t0 WHERE t0.id = ?
Parameters:
[
  15
]

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\Menu
  • The mappings App\Entity\Menu#items and App\Entity\MenuItem#menu are inconsistent with each other.
App\Entity\MenuItem
  • The association App\Entity\MenuItem#menu refers to the inverse side field App\Entity\Menu#menuItems which does not exist.