GET http://doc.smarton.app/p/lt/settings/integrations/devices/device-troubleshoot

Query Metrics

7 Database Queries
4 Different statements
5.62 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.87 ms
(50.95%)
4
SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.slug = ? AND t0.parent_id = ? LIMIT 1
Parameters:
[
  "settings"
  20
]
1.29 ms
(22.87%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.slug = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "documentation-en"
]
0.80 ms
(14.24%)
1
SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = ? AND s0_.structure_id = ? AND s2_.slug <> ?
Parameters:
[
  "lt"
  638
  "media"
]
0.67 ms
(11.95%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  638
]

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\Structure No errors.
App\Entity\ContentStructure No errors.
App\Entity\Content No errors.
App\Entity\StructureTranslation No errors.
App\Entity\Language No errors.