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

Queries

Group similar statements

# Time Info
1 1.75 ms
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
]
2 0.46 ms
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
]
3 0.41 ms
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"
]
4 0.40 ms
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
]
5 0.28 ms
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
]
6 0.30 ms
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"
]
7 0.49 ms
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
]
8 0.49 ms
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
]
9 0.49 ms
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"
]
10 0.30 ms
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
]
11 0.15 ms
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:
[
  22
]
12 0.15 ms
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:
[
  23
]
13 0.15 ms
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:
[
  24
]
14 0.15 ms
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:
[
  25
]
15 0.14 ms
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:
[
  26
]
16 0.14 ms
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:
[
  27
]
17 0.16 ms
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:
[
  28
]
18 0.14 ms
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:
[
  29
]
19 0.14 ms
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:
[
  30
]
20 0.14 ms
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:
[
  31
]
21 0.14 ms
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:
[
  32
]
22 0.14 ms
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:
[
  33
]
23 0.14 ms
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:
[
  34
]
24 0.14 ms
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:
[
  35
]
25 0.14 ms
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:
[
  36
]
26 0.16 ms
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:
[
  37
]
27 0.14 ms
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:
[
  38
]
28 0.14 ms
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:
[
  40
]
29 0.13 ms
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:
[
  44
]
30 0.14 ms
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:
[
  45
]
31 0.14 ms
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:
[
  46
]
32 0.16 ms
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:
[
  47
]
33 0.18 ms
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:
[
  48
]
34 0.14 ms
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:
[
  49
]
35 0.14 ms
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:
[
  50
]
36 0.14 ms
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:
[
  51
]
37 0.14 ms
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:
[
  52
]
38 0.14 ms
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:
[
  53
]
39 0.14 ms
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:
[
  54
]
40 0.16 ms
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:
[
  55
]
41 0.15 ms
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:
[
  56
]
42 0.14 ms
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:
[
  58
]
43 0.14 ms
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:
[
  59
]
44 0.14 ms
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:
[
  60
]
45 0.14 ms
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:
[
  61
]
46 0.30 ms
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:
[
  "en"
]
47 0.28 ms
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:
[
  "de"
]
48 1.75 ms
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"
]

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.