GET https://bo.twoo-way.com/api/navs/d4791997-72a1-4fab-ae5a-862571fa1596?locale=en

Query Metrics

43 Database Queries
10 Different statements
1.93 ms Query time
1 Invalid entities
37 Managed entities

Queries

Group similar statements

# Time Info
1 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.is_main = ? LIMIT 1
Parameters:
[
  1
]
2 0.09 ms
SELECT t0.id AS id_1, t0.keyname AS keyname_2, t0.title AS title_3, t0.main AS main_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7 FROM nav t0 WHERE t0.keyname = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "d4791997-72a1-4fab-ae5a-862571fa1596"
  1
]
3 0.08 ms
SELECT t0.id AS id_1, t0.redirection_type AS redirection_type_2, t0.redirection_video AS redirection_video_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.format AS format_7, t0.background_class AS background_class_8, t0.page_id AS page_id_9, t0.title_id AS title_id_10, t0.redirection_link_id AS redirection_link_id_11, t0.redirection_page_id AS redirection_page_id_12, t13.id AS id_14, t13.created_at AS created_at_15, t13.updated_at AS updated_at_16, t13.enabled AS enabled_17, t13.publication_start_date AS publication_start_date_18, t13.publication_end_date AS publication_end_date_19, t13.is_nav_back_button_enabled AS is_nav_back_button_enabled_20, t13.title_id AS title_id_21, t13.slug_id AS slug_id_22, t13.template_id AS template_id_23, t13.internal_template_id AS internal_template_id_24, t13.article_template_id AS article_template_id_25, t13.list_articles_template_id AS list_articles_template_id_26, t13.switch_home_template_id AS switch_home_template_id_27, t13.switch_home_location_template_id AS switch_home_location_template_id_28, t13.seo_id AS seo_id_29, t13.contact_template_id AS contact_template_id_30, t13.sitemap_template_id AS sitemap_template_id_31, t13.landing_template_id AS landing_template_id_32, t13.nav_back_button_title_id AS nav_back_button_title_id_33, t13.nav_back_button_page_id AS nav_back_button_page_id_34, t13.parent_id AS parent_id_35, t0.nav_id AS nav_id_36, t0.sub_nav_id AS sub_nav_id_37 FROM nav_link t0 LEFT JOIN page t13 ON t0.redirection_page_id = t13.id WHERE t0.nav_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
4 0.21 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.publication_start_date AS publication_start_date_5, t0.publication_end_date AS publication_end_date_6, t0.is_nav_back_button_enabled AS is_nav_back_button_enabled_7, t0.title_id AS title_id_8, t0.slug_id AS slug_id_9, t0.template_id AS template_id_10, t0.internal_template_id AS internal_template_id_11, t0.article_template_id AS article_template_id_12, t0.list_articles_template_id AS list_articles_template_id_13, t0.switch_home_template_id AS switch_home_template_id_14, t0.switch_home_location_template_id AS switch_home_location_template_id_15, t0.seo_id AS seo_id_16, t0.contact_template_id AS contact_template_id_17, t0.sitemap_template_id AS sitemap_template_id_18, t0.landing_template_id AS landing_template_id_19, t0.nav_back_button_title_id AS nav_back_button_title_id_20, t0.nav_back_button_page_id AS nav_back_button_page_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.enabled AS enabled_26, t22.publication_start_date AS publication_start_date_27, t22.publication_end_date AS publication_end_date_28, t22.is_nav_back_button_enabled AS is_nav_back_button_enabled_29, t22.title_id AS title_id_30, t22.slug_id AS slug_id_31, t22.template_id AS template_id_32, t22.internal_template_id AS internal_template_id_33, t22.article_template_id AS article_template_id_34, t22.list_articles_template_id AS list_articles_template_id_35, t22.switch_home_template_id AS switch_home_template_id_36, t22.switch_home_location_template_id AS switch_home_location_template_id_37, t22.seo_id AS seo_id_38, t22.contact_template_id AS contact_template_id_39, t22.sitemap_template_id AS sitemap_template_id_40, t22.landing_template_id AS landing_template_id_41, t22.nav_back_button_title_id AS nav_back_button_title_id_42, t22.nav_back_button_page_id AS nav_back_button_page_id_43, t22.parent_id AS parent_id_44, t0.parent_id AS parent_id_45 FROM page t0 LEFT JOIN page t22 ON t0.nav_back_button_page_id = t22.id WHERE t0.parent_id IN (?, ?, ?)
Parameters:
[
  17
  14
  1
]
5 0.05 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keyname AS keyname_3 FROM template t0 WHERE t0.id = ?
Parameters:
[
  9
]
6 0.05 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  348
]
7 0.05 ms
SELECT t0.id AS id_1, t0.translated_text AS translated_text_2, t0.language_id AS language_id_3, t0.text_content_id AS text_content_id_4 FROM translation t0 WHERE t0.text_content_id = ?
Parameters:
[
  348
]
8 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "en"
]
9 0.04 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  1108
]
10 0.04 ms
SELECT t0.id AS id_1, t0.translated_text AS translated_text_2, t0.language_id AS language_id_3, t0.text_content_id AS text_content_id_4 FROM translation t0 WHERE (t0.language_id = ? AND t0.text_content_id = ?) LIMIT 1
Parameters:
[
  2
  1108
]
11 0.06 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.parent_id AS parent_id_4 FROM sub_nav t0 WHERE t0.parent_id = ?
Parameters:
[
  27
]
12 0.04 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keyname AS keyname_3 FROM template t0 WHERE t0.id = ?
Parameters:
[
  1
]
13 0.04 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  252
]
14 0.03 ms
SELECT t0.id AS id_1, t0.translated_text AS translated_text_2, t0.language_id AS language_id_3, t0.text_content_id AS text_content_id_4 FROM translation t0 WHERE t0.text_content_id = ?
Parameters:
[
  252
]
15 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "en"
]
16 0.04 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  1109
]
17 0.03 ms
SELECT t0.id AS id_1, t0.translated_text AS translated_text_2, t0.language_id AS language_id_3, t0.text_content_id AS text_content_id_4 FROM translation t0 WHERE (t0.language_id = ? AND t0.text_content_id = ?) LIMIT 1
Parameters:
[
  2
  1109
]
18 0.04 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.parent_id AS parent_id_4 FROM sub_nav t0 WHERE t0.parent_id = ?
Parameters:
[
  28
]
19 0.03 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keyname AS keyname_3 FROM template t0 WHERE t0.id = ?
Parameters:
[
  3
]
20 0.03 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  6
]
21 0.03 ms
SELECT t0.id AS id_1, t0.translated_text AS translated_text_2, t0.language_id AS language_id_3, t0.text_content_id AS text_content_id_4 FROM translation t0 WHERE t0.text_content_id = ?
Parameters:
[
  6
]
22 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "en"
]
23 0.03 ms
SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = ?
Parameters:
[
  36
]
24 0.04 ms
SELECT t0.id AS id_1, t0.translated_text AS translated_text_2, t0.language_id AS language_id_3, t0.text_content_id AS text_content_id_4 FROM translation t0 WHERE (t0.language_id = ? AND t0.text_content_id = ?) LIMIT 1
Parameters:
[
  2
  36
]
25 0.04 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.parent_id AS parent_id_4 FROM sub_nav t0 WHERE t0.parent_id = ?
Parameters:
[
  6
]
26 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
27 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
28 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
29 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
30 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
31 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
32 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
33 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
34 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
35 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
36 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
37 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
38 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
39 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
40 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
41 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
42 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
43 0.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]

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\TextContent 12
App\Entity\Translation 5
App\Entity\NavLink 3
App\Entity\Page 3
App\Entity\Template 3
App\Entity\Seo 3
App\Entity\Language 2
App\Entity\Uploadable\LanguageImage 2
App\Entity\Nav 1
App\Entity\SwitchHomeTemplate 1
App\Entity\InternalTemplate 1
App\Entity\ListArticlesTemplate 1

Entities Mapping

Class Mapping errors
App\Entity\Language No errors.
App\Entity\Uploadable\LanguageImage No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\Nav No errors.
App\Entity\NavLink No errors.
App\Entity\Page No errors.
App\Entity\TextContent No errors.
App\Entity\Template No errors.
App\Entity\InternalTemplate No errors.
App\Entity\ArticleTemplate No errors.
App\Entity\ListArticlesTemplate No errors.
App\Entity\SwitchHomeTemplate No errors.
App\Entity\SwitchHomeLocationTemplate No errors.
App\Entity\Seo No errors.
App\Entity\ContactTemplate No errors.
App\Entity\SitemapTemplate
  • The association App\Entity\SitemapTemplate#template refers to the inverse side field App\Entity\Template#sitemapTemplates which does not exist.
App\Entity\LandingTemplate No errors.
App\Entity\SubNav No errors.
App\Entity\Asset No errors.
App\Entity\Translation No errors.