GET https://dev69.nexgen.cz/sitemap.xml

Query Metrics

48 Database Queries
7 Different statements
12.76 ms Query time
1 Invalid entities
151 Managed entities

Grouped Statements

Show all queries

Time Count Info
5.34 ms
(41.88%)
36
SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6 FROM web_seo t0 WHERE t0.id = ?
Parameters:
[
  21
]
2.64 ms
(20.68%)
3
SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.active = ?
Parameters:
[
  1
]
1.75 ms
(13.76%)
1
SELECT t0.entity_class AS entity_class_1, t0.request_id AS request_id_2, t0.property AS property_3, t0.media_order AS media_order_4, t0.created AS created_5, t0.entity_id AS entity_id_6, t0.id AS id_7 FROM media_order_record t0 WHERE t0.request_id = ?
Parameters:
[
  "3004b21aaa_69d1cf5f4710c1.33607177"
]
1.07 ms
(8.39%)
3
SELECT t0.title AS title_1, t0.description AS description_2, t0.keywords AS keywords_3, t0.name AS name_4, t0.url AS url_5, t0.`generated` AS generated_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM web_seo_translation t0 WHERE t0.locale = ?
Parameters:
[
  "cs"
]
0.74 ms
(5.82%)
2
SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1
Parameters:
[
  1
]
0.72 ms
(5.61%)
2
SELECT t0.name AS name_1, t0.menu AS menu_2, t0.iso_2 AS iso_2_3, t0.iso_3 AS iso_3_4, t0.default_lang AS default_lang_5, t0.active AS active_6, t0.id AS id_7, t0.country AS country_8 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1
Parameters:
[
  "cs"
]
0.49 ms
(3.86%)
1
SELECT t0.homepage AS homepage_1, t0.doc_files_order AS doc_files_order_2, t0.id AS id_3, t0.sort AS sort_4, t0.img_files_order AS img_files_order_5, t0.dms_img_updated AS dms_img_updated_6, t0.parent AS parent_7, t0.seo_id AS seo_id_8, t0.template_id AS template_id_9, t0.img_file_id AS img_file_id_10, t0.doc_file_id AS doc_file_id_11 FROM web_page t0 WHERE t0.homepage = ? LIMIT 1
Parameters:
[
  1
]

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
NexCRM\WebBundle\Entity\SEOTranslation 108
NexCRM\WebBundle\Entity\SEO 36
NexCRM\BaseBundle\Entity\Lang 3
NexCRM\BaseBundle\Entity\Country 3
NexCRM\WebBundle\Entity\Page 1

Entities Mapping

Class Mapping errors
NexCRM\BaseBundle\Entity\Lang No errors.
NexCRM\BaseBundle\Entity\Country No errors.
NexCRM\BaseBundle\Entity\Setting No errors.
App\Entity\VoucherOrders
  • The association App\Entity\VoucherOrders#type refers to the inverse side field App\Entity\VoucherTypes#voucher_orders which does not exist.
NexCRM\WebBundle\Entity\Page No errors.
NexCRM\WebBundle\Entity\SEO No errors.
NexCRM\WebBundle\Entity\Template No errors.
NexCRM\DMSBundle\Entity\File No errors.
NexCRM\WebBundle\Entity\Content No errors.
NexCRM\WebBundle\Entity\PageTranslation No errors.
NexCRM\WebBundle\Entity\SEOTranslation No errors.
NexCRM\BaseBundle\Entity\MediaOrderRecord No errors.