https://api-royal-palace.dix-demo.fr/fr/faq

Query Metrics

37 Database Queries
5 Different statements
10.11 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.50 ms
(44.51%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.url = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "faq"
  "fr"
]
4.05 ms
(40.07%)
33
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "faq"
  "de"
]
1.07 ms
(10.62%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM framework_translation t0
Parameters:
[]
0.32 ms
(3.21%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.faq_category_id AS faq_category_id_6, t7.id AS id_8, t7.position AS position_9, t7.slug AS slug_10, t7.name AS name_11, t7.published AS published_12, t7.created_at AS created_at_13, t7.updated_at AS updated_at_14 FROM framework_faq t0 LEFT JOIN framework_faq_category t7 ON t0.faq_category_id = t7.id ORDER BY t0.id ASC
Parameters:
[]
0.16 ms
(1.59%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.slug AS slug_3, t0.name AS name_4, t0.published AS published_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM framework_faq_category t0 ORDER BY t0.position ASC
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\Framework\AppBundle\Entity\Page No errors.
App\Framework\AppBundle\Entity\FaqCategory No errors.
App\Framework\AppBundle\Entity\Faq No errors.
App\Framework\AppBundle\Entity\Translation No errors.