GET https://www.renovaweb.hb-preprod.com/en/guide-for-homeowners

Response
200 OK
IP
216.73.216.223
Profiled on
Token
8a7780

Query Metrics

7 Database Queries
6 Different statements
4.57 ms Query time
0 Invalid entities
77 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
2.72 ms
(59.41%) 		1 
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.field AS field_2, c0_.controller AS controller_3, c0_.action AS action_4, c0_.type AS type_5, c0_.is_sitemap AS is_sitemap_6, c0_.is_contain_default_content_generator AS is_contain_default_content_generator_7, c0_.sort AS sort_8, c1_.id AS id_9, c1_.path AS path_10, c1_.seo_title AS seo_title_11, c1_.seo_description AS seo_description_12, c1_.seo_image AS seo_image_13, c1_.locale AS locale_14, c2_.id AS id_15, c2_.is_deletable AS is_deletable_16, c2_.sort AS sort_17, c3_.id AS id_18, c3_.name AS name_19, c3_.field AS field_20, c3_.type AS type_21, c4_.id AS id_22, c4_.name AS name_23, c4_.field AS field_24, c4_.type AS type_25, c4_.description AS description_26, c4_.options AS options_27, c4_.is_translation AS is_translation_28, c4_.is_required AS is_required_29, c4_.sort AS sort_30, c5_.id AS id_31, c5_.value AS value_32, c6_.id AS id_33, c6_.translation AS translation_34, c6_.locale AS locale_35, c7_.id AS id_36, c7_.name AS name_37, c7_.field AS field_38, c7_.type AS type_39, c7_.description AS description_40, c7_.options AS options_41, c7_.is_translation AS is_translation_42, c7_.is_required AS is_required_43, c7_.sort AS sort_44, c1_.translatable_id AS translatable_id_45, c2_.cms_generator_id AS cms_generator_id_46, c2_.cms_page_id AS cms_page_id_47, c4_.cms_generator_id AS cms_generator_id_48, c5_.cms_generator_page_id AS cms_generator_page_id_49, c5_.cms_generator_content_id AS cms_generator_content_id_50, c6_.translatable_id AS translatable_id_51, c7_.cms_generator_id AS cms_generator_id_52 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = ?) LEFT JOIN cms_generator_page c2_ ON c0_.id = c2_.cms_page_id LEFT JOIN cms_generator c3_ ON c2_.cms_generator_id = c3_.id LEFT JOIN cms_generator_content c4_ ON c3_.id = c4_.cms_generator_id LEFT JOIN cms_page_content c5_ ON c2_.id = c5_.cms_generator_page_id LEFT JOIN cms_page_content_translation c6_ ON c5_.id = c6_.translatable_id AND (c6_.locale = ?) LEFT JOIN cms_generator_content c7_ ON c5_.cms_generator_content_id = c7_.id WHERE c0_.field = ? ORDER BY c2_.sort ASC, c4_.sort ASC
Parameters: 
[
  "en"
  "en"
  "index_guide_particular"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(10.95%) 		1 
SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.type AS type_17, t11.is_sitemap AS is_sitemap_18, t11.is_contain_default_content_generator AS is_contain_default_content_generator_19, t11.sort AS sort_20 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_generator_id IN (?, ?, ?) ORDER BY t0.sort ASC
Parameters: 
[
  20
  38
  40
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(10.46%) 		2 
SELECT t0.id AS id_1, t0.value AS value_2, t0.cms_generator_page_id AS cms_generator_page_id_3, t0.cms_generator_content_id AS cms_generator_content_id_4 FROM cms_page_content t0 WHERE t0.cms_generator_page_id IN (?, ?)
Parameters: 
[
  51
  53
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(6.84%) 		1 
SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.type AS type_17, t11.is_sitemap AS is_sitemap_18, t11.is_contain_default_content_generator AS is_contain_default_content_generator_19, t11.sort AS sort_20 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_generator_id IN (?, ?) ORDER BY t0.sort ASC
Parameters: 
[
  41
  39
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(6.71%) 		1 
SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.type AS type_17, t11.is_sitemap AS is_sitemap_18, t11.is_contain_default_content_generator AS is_contain_default_content_generator_19, t11.sort AS sort_20 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_page_id IN (?) ORDER BY t0.sort ASC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(5.62%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.field AS field_3, t0.type AS type_4, t0.description AS description_5, t0.options AS options_6, t0.is_translation AS is_translation_7, t0.is_required AS is_required_8, t0.sort AS sort_9, t0.cms_generator_id AS cms_generator_id_10 FROM cms_generator_content t0 WHERE t0.cms_generator_id IN (?, ?) ORDER BY t0.sort ASC
Parameters: 
[
  41
  39
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Core\Entity\CmsPageContent 30
App\Core\Entity\CmsGeneratorContent 22
App\Core\Entity\CmsPageContentTranslation 10
App\Core\Entity\CmsGeneratorPage 7
App\Core\Entity\CmsGenerator 5
App\Core\Entity\CmsPage 2
App\Core\Entity\CmsPageTranslation 1

Entities Mapping

Class Mapping errors
App\Core\Entity\CmsPage No errors.
App\Core\Entity\CmsPageTranslation No errors.
App\Core\Entity\CmsGeneratorPage No errors.
App\Core\Entity\CmsGenerator No errors.
App\Core\Entity\CmsGeneratorContent No errors.
App\Core\Entity\CmsPageContent No errors.
App\Core\Entity\CmsPageContentTranslation No errors.
App\Core\Entity\CmsGeneratorFlexiblePage No errors.
App\Core\Entity\CmsGeneratorEmail No errors.
App\Core\Entity\CmsEmailContent No errors.