Symfony Profiler

SELECT
  *
FROM
  tl_hideaway_combis
WHERE
  published = 1
ORDER BY
  title

SELECT * FROM tl_hideaway_combis WHERE published=1 ORDER BY title;

SELECT
  tl_content.*
FROM
  tl_content
WHERE
  tl_content.pid = ?
  AND (
    tl_content.ptable = ?
    OR tl_content.ptable = ''
  )
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= 1776508620
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > 1776508620
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

SELECT tl_content.* FROM tl_content WHERE tl_content.pid=45 AND (tl_content.ptable='tl_article' OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1776508620) AND (tl_content.stop='' OR tl_content.stop>1776508620) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid = UNHEX(?)
LIMIT
  0, 1

SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('f85faff664c911e4b27f47d86675191d') LIMIT 0,1;

SELECT
  *
FROM
  tl_hideaway_country
WHERE
  published = 1
  AND id = ?

SELECT * FROM tl_hideaway_country WHERE published=1 AND id = NULL;

SELECT
  *
FROM
  tl_hideaway_trip
WHERE
  published = 1
  AND regions LIKE ?

SELECT * FROM tl_hideaway_trip WHERE published=1 AND regions LIKE '%\"4\"%';

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  BINARY tl_article.alias = ?
LIMIT
  0, 1

SELECT tl_article.* FROM tl_article WHERE BINARY tl_article.alias='header' LIMIT 0,1;

SELECT
  *
FROM
  tl_hideaway_region
WHERE
  published = 1
  AND id = ?

SELECT * FROM tl_hideaway_region WHERE published=1 AND id = 6;

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

SELECT tl_page.* FROM tl_page WHERE tl_page.id='2' LIMIT 0,1;

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  tl_article.pid = ?
  AND tl_article.inColumn = ?
  AND tl_article.published = '1'
  AND (
    tl_article.start = ''
    OR tl_article.start <= 1776508620
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > 1776508620
  )
ORDER BY
  tl_article.sorting

SELECT tl_article.* FROM tl_article WHERE tl_article.pid=45 AND tl_article.inColumn='header' AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<=1776508620) AND (tl_article.stop='' OR tl_article.stop>1776508620) ORDER BY tl_article.sorting;

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

SELECT tl_content.* FROM tl_content WHERE tl_content.`id`=413 LIMIT 0,1;

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

SELECT tl_user.* FROM tl_user WHERE tl_user.`id`=3 LIMIT 0,1;

SELECT
  *
FROM
  tl_page
WHERE
  id = ?

SELECT * FROM tl_page WHERE id = 44;

SELECT
  *
FROM
  tl_hideaway_region
WHERE
  published = 1
  AND country = ?
ORDER BY
  title

SELECT * FROM tl_hideaway_region WHERE published=1 AND country=3 ORDER BY title;

SELECT
  *
FROM
  tl_hideaway_country
WHERE
  published = 1
  AND alias = ?

SELECT * FROM tl_hideaway_country WHERE published=1 AND alias = 'thailand-urlaub';

SELECT
  *
FROM
  tl_hideaway_trip
WHERE
  published = 1
  AND id = ?
  OR alias = ?

SELECT * FROM tl_hideaway_trip WHERE published=1 AND id = 1 OR alias = 1;

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

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

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type NOT IN (
        'error_401', 'error_403', 'error_404',
        'error_503'
      )
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= 1776508620
      )
      AND (
        p2.stop = ''
        OR p2.stop > 1776508620
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = ?
  AND p1.type != 'root'
  AND p1.type NOT IN (
    'error_401', 'error_403', 'error_404',
    'error_503'
  )
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= 1776508620
  )
  AND (
    p1.stop = ''
    OR p1.stop > 1776508620
  )
ORDER BY
  p1.sorting

SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<=1776508620) AND (p2.stop='' OR p2.stop>1776508620)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=1 AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<=1776508620) AND (p1.stop='' OR p1.stop>1776508620) ORDER BY p1.sorting;

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

SELECT tl_form.* FROM tl_form WHERE tl_form.id='4' LIMIT 0,1;

SELECT
  *
FROM
  tl_hideaway_region
WHERE
  published = 1
  AND country = ?

SELECT * FROM tl_hideaway_region WHERE published=1 AND country = 3;

SELECT
  *
FROM
  tl_hideaway_hotel
WHERE
  published = 1
  AND region = ?

SELECT * FROM tl_hideaway_hotel WHERE published=1 AND region = 0;

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 = 'hideaway4you'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias IN (?, ?)

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('reisen/thailand-urlaub','reisen');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`id` = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=20;

SELECT
  id
FROM
  tl_content
WHERE
  pid = ?
  AND ptable = 'tl_hideaway_country'
  AND hideaway_content_area = 'bottom'
  AND invisible = ''
  AND (
    start = ''
    OR start <= ?
  )
  AND (
    stop = ''
    OR stop > ?
  )
ORDER BY
  sorting ASC

SELECT id FROM tl_content
			 WHERE pid=3 AND ptable='tl_hideaway_country'
			   AND hideaway_content_area='bottom'
			   AND invisible=''
			   AND (start='' OR start<=1776508629) AND (stop='' OR stop>1776508629)
			 ORDER BY sorting ASC;

SELECT
  tl_form_field.*
FROM
  tl_form_field
WHERE
  tl_form_field.pid = ?
  AND tl_form_field.invisible = ''
  AND tl_form_field.tstamp != 0
ORDER BY
  tl_form_field.sorting

SELECT tl_form_field.* FROM tl_form_field WHERE tl_form_field.pid=4 AND tl_form_field.invisible='' AND tl_form_field.tstamp!=0 ORDER BY tl_form_field.sorting;

SELECT
  id
FROM
  tl_content
WHERE
  pid = ?
  AND ptable = 'tl_hideaway_country'
  AND (
    hideaway_content_area = 'top'
    OR hideaway_content_area = ''
  )
  AND invisible = ''
  AND (
    start = ''
    OR start <= ?
  )
  AND (
    stop = ''
    OR stop > ?
  )
ORDER BY
  sorting ASC

SELECT id FROM tl_content
			 WHERE pid=3 AND ptable='tl_hideaway_country'
			   AND (hideaway_content_area='top' OR hideaway_content_area='')
			   AND invisible=''
			   AND (start='' OR start<=1776508629) AND (stop='' OR stop>1776508629)
			 ORDER BY sorting ASC;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(25, 3, 23, 4, 41)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '24,25,3,23,4,41'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(25,3,23,4,41) ORDER BY FIND_IN_SET(`tl_page`.`id`, '24,25,3,23,4,41');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  BINARY tl_page.alias = ?
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE BINARY tl_page.alias='merkzettel' LIMIT 0,1;

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(5, 0, 0, 0)
ORDER BY
  FIND_IN_SET(`tl_module`.`id`, '5,0,0,0')

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(5,0,0,0) ORDER BY FIND_IN_SET(`tl_module`.`id`, '5,0,0,0');

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

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=24 LIMIT 0,1;

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

SELECT
  *
FROM
  tl_hideaway_country
WHERE
  published = 1
ORDER BY
  sorting

SELECT * FROM tl_hideaway_country WHERE published=1 ORDER BY sorting;

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      'ffd34c580c1a11f1aae25401092cbe39'
    ),
    UNHEX(
      'ffd34c4e0c1a11f1aae25401092cbe39'
    ),
    UNHEX(
      'ffd7c4400c1a11f1aae25401092cbe39'
    ),
    UNHEX(
      'ffd7c3500c1a11f1aae25401092cbe39'
    ),
    UNHEX(
      'ffd7c3320c1a11f1aae25401092cbe39'
    ),
    UNHEX(
      'ffdb40c00c1a11f1aae25401092cbe39'
    ),
    UNHEX(
      'ffdb408e0c1a11f1aae25401092cbe39'
    ),
    UNHEX(
      'a1b37bec0d8311f1aae25401092cbe39'
    ),
    UNHEX(
      '18017688135511f18b957cc35e8b9f7c'
    ),
    UNHEX(
      'b4e7faca195011f1ab27e68b07806fa9'
    ),
    UNHEX(
      'b4e7fab6195011f1ab27e68b07806fa9'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    'ffd34c580c1a11f1aae25401092cbe39'
  ),
  tl_files.uuid != UNHEX(
    'ffd34c4e0c1a11f1aae25401092cbe39'
  ),
  tl_files.uuid != UNHEX(
    'ffd7c4400c1a11f1aae25401092cbe39'
  ),
  tl_files.uuid != UNHEX(
    'ffd7c3500c1a11f1aae25401092cbe39'
  ),
  tl_files.uuid != UNHEX(
    'ffd7c3320c1a11f1aae25401092cbe39'
  ),
  tl_files.uuid != UNHEX(
    'ffdb40c00c1a11f1aae25401092cbe39'
  ),
  tl_files.uuid != UNHEX(
    'ffdb408e0c1a11f1aae25401092cbe39'
  ),
  tl_files.uuid != UNHEX(
    'a1b37bec0d8311f1aae25401092cbe39'
  ),
  tl_files.uuid != UNHEX(
    '18017688135511f18b957cc35e8b9f7c'
  ),
  tl_files.uuid != UNHEX(
    'b4e7faca195011f1ab27e68b07806fa9'
  ),
  tl_files.uuid != UNHEX(
    'b4e7fab6195011f1ab27e68b07806fa9'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('ffd34c580c1a11f1aae25401092cbe39'),UNHEX('ffd34c4e0c1a11f1aae25401092cbe39'),UNHEX('ffd7c4400c1a11f1aae25401092cbe39'),UNHEX('ffd7c3500c1a11f1aae25401092cbe39'),UNHEX('ffd7c3320c1a11f1aae25401092cbe39'),UNHEX('ffdb40c00c1a11f1aae25401092cbe39'),UNHEX('ffdb408e0c1a11f1aae25401092cbe39'),UNHEX('a1b37bec0d8311f1aae25401092cbe39'),UNHEX('18017688135511f18b957cc35e8b9f7c'),UNHEX('b4e7faca195011f1ab27e68b07806fa9'),UNHEX('b4e7fab6195011f1ab27e68b07806fa9')) ORDER BY tl_files.uuid!=UNHEX('ffd34c580c1a11f1aae25401092cbe39'), tl_files.uuid!=UNHEX('ffd34c4e0c1a11f1aae25401092cbe39'), tl_files.uuid!=UNHEX('ffd7c4400c1a11f1aae25401092cbe39'), tl_files.uuid!=UNHEX('ffd7c3500c1a11f1aae25401092cbe39'), tl_files.uuid!=UNHEX('ffd7c3320c1a11f1aae25401092cbe39'), tl_files.uuid!=UNHEX('ffdb40c00c1a11f1aae25401092cbe39'), tl_files.uuid!=UNHEX('ffdb408e0c1a11f1aae25401092cbe39'), tl_files.uuid!=UNHEX('a1b37bec0d8311f1aae25401092cbe39'), tl_files.uuid!=UNHEX('18017688135511f18b957cc35e8b9f7c'), tl_files.uuid!=UNHEX('b4e7faca195011f1ab27e68b07806fa9'), tl_files.uuid!=UNHEX('b4e7fab6195011f1ab27e68b07806fa9');

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  id
FROM
  tl_hideaway_region
WHERE
  published = 1
  AND country = ?

SELECT id FROM tl_hideaway_region WHERE published=1 AND country = 3;

SELECT
  tl_faq.*
FROM
  tl_faq
WHERE
  tl_faq.pid IN(1)
  AND tl_faq.published = '1'
ORDER BY
  tl_faq.pid,
  tl_faq.sorting

SELECT tl_faq.* FROM tl_faq WHERE tl_faq.pid IN(1) AND tl_faq.published='1' ORDER BY tl_faq.pid, tl_faq.sorting;

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

SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=3 LIMIT 0,1;

SELECT
  *
FROM
  tl_dma_eg
WHERE
  tl_dma_eg.`content` = ?

SELECT * FROM tl_dma_eg WHERE tl_dma_eg.`content`=1;

SELECT
  *
FROM
  tl_hideaway_experience
WHERE
  published = 1
ORDER BY
  title

SELECT * FROM tl_hideaway_experience WHERE published=1 ORDER BY title;

SELECT
  *
FROM
  tl_hideaway_testimonial
WHERE
  published = '1'
ORDER BY
  sorting ASC

SELECT * FROM tl_hideaway_testimonial WHERE published='1' ORDER BY sorting ASC;

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

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

SELECT
  *
FROM
  tl_hideaway_testimonial
WHERE
  published = '1'
  AND country = ?
ORDER BY
  sorting ASC

SELECT * FROM tl_hideaway_testimonial WHERE published='1' AND country=3 ORDER BY sorting ASC;

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

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

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

SELECT tl_article.* FROM tl_article WHERE tl_article.id='89' LIMIT 0,1;