GET https://learngolang.itdevs.in/golang/data-hiding

Query Metrics

7 Database Queries
6 Different statements
4.64 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.55 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.status AS status_5, t0.position AS position_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_tags AS meta_tags_9, t0.content AS content_10 FROM categories t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "golang"
]
2 1.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.status AS status_4, t0.position AS position_5, t0.has_submenu AS has_submenu_6, t0.published_by_id AS published_by_id_7, t0.published_by_name AS published_by_name_8, t0.date_add AS date_add_9, t0.date_upd AS date_upd_10, t11.id AS id_12, t11.title AS title_13, t11.slug AS slug_14, t11.content AS content_15, t11.author AS author_16, t11.description AS description_17, t11.tags AS tags_18, t11.meta_title AS meta_title_19, t11.meta_desc AS meta_desc_20, t11.meta_tags AS meta_tags_21, t11.date_add AS date_add_22, t11.date_upd AS date_upd_23, t11.submenu_id_id AS submenu_id_id_24, t0.category_id_id AS category_id_id_25, t0.parent_id_id AS parent_id_id_26 FROM submenus t0 LEFT JOIN articles t11 ON t11.submenu_id_id = t0.id WHERE t0.category_id_id = ? AND t0.slug = ? LIMIT 1
Parameters:
[
  1
  "data-hiding"
]
3 0.38 ms
SELECT t0.id AS id_1, t0.menu_json AS menu_json_2 FROM menus t0 LIMIT 1
Parameters:
[]
4 0.57 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.status AS status_3, s0_.position AS position_4, s0_.has_submenu AS has_submenu_5, s0_.published_by_id AS published_by_id_6, s0_.published_by_name AS published_by_name_7, s0_.date_add AS date_add_8, s0_.date_upd AS date_upd_9, s0_.category_id_id AS category_id_id_10, s0_.parent_id_id AS parent_id_id_11 FROM submenus s0_ WHERE s0_.category_id_id = ? AND s0_.status = ? AND s0_.parent_id_id IS NULL ORDER BY s0_.position ASC
Parameters:
[
  1
  1
]
5 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.author AS author_5, t0.description AS description_6, t0.tags AS tags_7, t0.meta_title AS meta_title_8, t0.meta_desc AS meta_desc_9, t0.meta_tags AS meta_tags_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.submenu_id_id AS submenu_id_id_13 FROM articles t0 WHERE t0.submenu_id_id = ?
Parameters:
[
  6
]
6 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.author AS author_5, t0.description AS description_6, t0.tags AS tags_7, t0.meta_title AS meta_title_8, t0.meta_desc AS meta_desc_9, t0.meta_tags AS meta_tags_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.submenu_id_id AS submenu_id_id_13 FROM articles t0 WHERE t0.submenu_id_id = ?
Parameters:
[
  3
]
7 0.40 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.status AS status_4, t0.position AS position_5, t0.has_submenu AS has_submenu_6, t0.published_by_id AS published_by_id_7, t0.published_by_name AS published_by_name_8, t0.date_add AS date_add_9, t0.date_upd AS date_upd_10, t11.id AS id_12, t11.title AS title_13, t11.slug AS slug_14, t11.content AS content_15, t11.author AS author_16, t11.description AS description_17, t11.tags AS tags_18, t11.meta_title AS meta_title_19, t11.meta_desc AS meta_desc_20, t11.meta_tags AS meta_tags_21, t11.date_add AS date_add_22, t11.date_upd AS date_upd_23, t11.submenu_id_id AS submenu_id_id_24, t0.category_id_id AS category_id_id_25, t0.parent_id_id AS parent_id_id_26 FROM submenus t0 LEFT JOIN articles t11 ON t11.submenu_id_id = t0.id WHERE t0.parent_id_id = ?
Parameters:
[
  3
]

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\Categories No errors.
App\Entity\Submenus No errors.
App\Entity\Articles No errors.
App\Entity\Menus No errors.