https://tmp-sympathiemagazin.47gn.cyon.site/sitemap.xml

Query Metrics

260 Database Queries
24 Different statements
168.29 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
89.16 ms
(52.98%)
95
SELECT tl_iso_product.*, 'en' AS language, IF(tl_iso_product.pid>0, parent.type, tl_iso_product.type) AS type, tl_iso_product.images AS images_fallback, tl_iso_product.hauptbild AS hauptbild_fallback, tl_iso_product.bildergalerie AS bildergalerie_fallback, GROUP_CONCAT(c.page_id) AS product_categories FROM tl_iso_product LEFT OUTER JOIN tl_iso_product parent ON tl_iso_product.pid=parent.id LEFT OUTER JOIN tl_iso_product_category c ON IFNULL(parent.id, tl_iso_product.id)=c.pid WHERE tl_iso_product.language='' AND tl_iso_product.id=?
Parameters:
[
  "357"
]
26.65 ms
(15.84%)
58
SELECT tl_article.* FROM tl_article WHERE tl_article.pid=? AND tl_article.showTeaser=1 AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1777802400') AND (tl_article.stop='' OR tl_article.stop>'1777802400') ORDER BY tl_article.sorting
Parameters:
[
  "62"
]
25.58 ms
(15.20%)
67
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  61
]
5.68 ms
(3.37%)
1
SELECT tl_iso_product.*, 'en' AS language, IF(tl_iso_product.pid>0, parent.type, tl_iso_product.type) AS type, tl_iso_product.images AS images_fallback, tl_iso_product.hauptbild AS hauptbild_fallback, tl_iso_product.bildergalerie AS bildergalerie_fallback, GROUP_CONCAT(c.page_id) AS product_categories FROM tl_iso_product LEFT OUTER JOIN tl_iso_product parent ON tl_iso_product.pid=parent.id LEFT OUTER JOIN tl_iso_product_category c ON IFNULL(parent.id, tl_iso_product.id)=c.pid WHERE tl_iso_product.language='' AND tl_iso_product.published='1' AND (tl_iso_product.start='' OR tl_iso_product.start<'1777802400') AND (tl_iso_product.stop='' OR tl_iso_product.stop>'1777802460') AND c.page_id IN (85,89,65,67,68,88,97,62,64,66,69,92,113,114,121,124,125,126,128,136,138,63,70,71,72,73,74,75,76,77,86,87,110,83,108,111,135,78,79,80,81,82,103,104,105,130,141,122,106,112,115,91,93,107,119,94,102,98,99,101,116,127,139,140,117,118,109,123,132,133,134,137,61) GROUP BY tl_iso_product.id
Parameters:
[]
2.46 ms
(1.46%)
5
SELECT id, pid FROM tl_page WHERE pid IN(85,89,65,67,68,88,97,62,64,66,69,92,113,114,121,124,125,126,128,136,138)
Parameters:
[]
2.27 ms
(1.35%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "gncyonsi_tmpsympathiemagazin"
]
1.92 ms
(1.14%)
1
SELECT tl_newsletter.* FROM tl_newsletter WHERE tl_newsletter.pid=? AND tl_newsletter.sent=1 ORDER BY tl_newsletter.date DESC
Parameters:
[
  "1"
]
1.66 ms
(0.98%)
3
SELECT * FROM tl_iso_producttype WHERE tl_iso_producttype.`id`=? LIMIT 0,1
Parameters:
[
  "1"
]
1.49 ms
(0.89%)
5
SELECT id, pid FROM tl_page WHERE pid IN(61)
Parameters:
[]
1.44 ms
(0.85%)
2
SELECT DATABASE()
Parameters:
[]
1.00 ms
(0.59%)
1
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[]
0.94 ms
(0.56%)
1
SELECT tl_news.* FROM tl_news WHERE tl_news.pid=? AND tl_news.source='default' AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<='1777802400') AND (tl_news.stop='' OR tl_news.stop>'1777802400') ORDER BY tl_news.date DESC
Parameters:
[
  "3"
]
0.91 ms
(0.54%)
5
SELECT id, pid FROM tl_page WHERE pid IN(117,118,109,123,132,133,134,137)
Parameters:
[]
0.90 ms
(0.53%)
1
SELECT COUNT(*) AS total FROM tl_iso_product WHERE language!=''
Parameters:
[]
0.87 ms
(0.51%)
5
SELECT id, pid FROM tl_page WHERE pid IN(63,70,71,72,73,74,75,76,77,86,87,110,83,108,111,135,78,79,80,81,82,103,104,105,130,141,122,106,112,115,91,93,107,119,94,102,98,99,101,116,127,139,140)
Parameters:
[]
0.83 ms
(0.49%)
1
SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND tl_page.dns=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1777802400') AND (tl_page.stop='' OR tl_page.stop>'1777802400')
Parameters:
[
  "tmp-sympathiemagazin.47gn.cyon.site"
]
0.82 ms
(0.49%)
1
SELECT * FROM tl_iso_label WHERE tl_iso_label.`language`=?
Parameters:
[
  "en"
]
0.77 ms
(0.46%)
1
SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<'1777802400') AND (tl_page.stop='' OR tl_page.stop>'1777802460') AND tl_page.id=?
Parameters:
[
  "61"
]
0.71 ms
(0.42%)
1
SELECT * FROM tl_iso_attribute WHERE tl_iso_attribute.type!='' AND tl_iso_attribute.field_name!=''
Parameters:
[
  null
]
0.69 ms
(0.41%)
1
SELECT tl_calendar.* FROM tl_calendar WHERE tl_calendar.`protected`=?
Parameters:
[
  ""
]
0.49 ms
(0.29%)
1
SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.`protected`=?
Parameters:
[
  ""
]
0.45 ms
(0.27%)
1
SELECT COUNT(*) AS total FROM tl_iso_producttype WHERE variants='1'
Parameters:
[]
0.32 ms
(0.19%)
1
SELECT tl_faq_category.* FROM tl_faq_category
Parameters:
[]
0.29 ms
(0.17%)
1
SELECT tl_newsletter_channel.* FROM tl_newsletter_channel
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
Contao\CoreBundle\Entity\RememberMe No errors.