Symfony Profiler

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 = ?

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='357';

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

SELECT tl_article.* FROM tl_article WHERE tl_article.pid='62' 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;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`pid` = ?
ORDER BY
  sorting

SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=61 ORDER BY sorting;

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

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;

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
  )

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);

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'gncyonsi_tmpsympathiemagazin'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  tl_newsletter.*
FROM
  tl_newsletter
WHERE
  tl_newsletter.pid = ?
  AND tl_newsletter.sent = 1
ORDER BY
  tl_newsletter.date DESC

SELECT tl_newsletter.* FROM tl_newsletter WHERE tl_newsletter.pid='1' AND tl_newsletter.sent=1 ORDER BY tl_newsletter.date DESC;

SELECT
  *
FROM
  tl_iso_producttype
WHERE
  tl_iso_producttype.`id` = ?
LIMIT
  0, 1

SELECT * FROM tl_iso_producttype WHERE tl_iso_producttype.`id`='1' LIMIT 0,1;

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(61)

SELECT id, pid FROM tl_page WHERE pid IN(61);

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

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

SELECT tl_news.* FROM tl_news WHERE tl_news.pid='3' 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;

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(
    117, 118, 109, 123, 132, 133, 134, 137
  )

SELECT id, pid FROM tl_page WHERE pid IN(117,118,109,123,132,133,134,137);

SELECT
  COUNT(*) AS total
FROM
  tl_iso_product
WHERE
  language != ''

SELECT COUNT(*) AS total FROM tl_iso_product WHERE language!='';

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
  )

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);

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'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND tl_page.dns='tmp-sympathiemagazin.47gn.cyon.site' AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1777802400') AND (tl_page.stop='' OR tl_page.stop>'1777802400');

SELECT
  *
FROM
  tl_iso_label
WHERE
  tl_iso_label.`language` = ?

SELECT * FROM tl_iso_label WHERE tl_iso_label.`language`='en';

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 = ?

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='61';

SELECT
  *
FROM
  tl_iso_attribute
WHERE
  tl_iso_attribute.type != ''
  AND tl_iso_attribute.field_name != ''

SELECT * FROM tl_iso_attribute WHERE tl_iso_attribute.type!='' AND tl_iso_attribute.field_name!='';

SELECT
  tl_calendar.*
FROM
  tl_calendar
WHERE
  tl_calendar.`protected` = ?

SELECT tl_calendar.* FROM tl_calendar WHERE tl_calendar.`protected`='';

SELECT
  tl_news_archive.*
FROM
  tl_news_archive
WHERE
  tl_news_archive.`protected` = ?

SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.`protected`='';

SELECT
  COUNT(*) AS total
FROM
  tl_iso_producttype
WHERE
  variants = '1'

SELECT COUNT(*) AS total FROM tl_iso_producttype WHERE variants='1';

SELECT
  tl_faq_category.*
FROM
  tl_faq_category

SELECT tl_faq_category.* FROM tl_faq_category;

SELECT
  tl_newsletter_channel.*
FROM
  tl_newsletter_channel

SELECT tl_newsletter_channel.* FROM tl_newsletter_channel;