Symfony Profiler

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

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

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

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

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

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

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  DATABASE()

SELECT DATABASE();

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
  *
FROM
  tl_dma_eg
WHERE
  tl_dma_eg.`content` = ?

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

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

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

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

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

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

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

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 <= 1776508800
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > 1776508800
  )
ORDER BY
  tl_article.sorting

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

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 <= 1776508800
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > 1776508800
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

SELECT tl_content.* FROM tl_content WHERE tl_content.pid=77 AND (tl_content.ptable='tl_article' OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1776508800) AND (tl_content.stop='' OR tl_content.stop>1776508800) 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('4e9470720de611e5840bd43d7ed6cb8e') LIMIT 0,1;

SELECT
  *
FROM
  tl_hideaway_testimonial
WHERE
  published = '1'
ORDER BY
  rating DESC,
  sorting ASC
LIMIT
  5

SELECT * FROM tl_hideaway_testimonial WHERE published='1' ORDER BY rating DESC, sorting ASC LIMIT 5;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.pid = ?
  AND tl_page.type != 'root'
  AND tl_page.type NOT IN (
    'error_401', 'error_403', 'error_404',
    'error_503'
  )
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= 1776508800
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1776508800
  )
ORDER BY
  tl_page.sorting
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.pid=1 AND tl_page.type!='root' AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1776508800) AND (tl_page.stop='' OR tl_page.stop>1776508800) ORDER BY tl_page.sorting 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 <= 1776508800
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > 1776508800
  )
ORDER BY
  tl_article.sorting

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

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 <= 1776508800
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > 1776508800
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

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

SELECT
  *
FROM
  tl_hideaway_combis
WHERE
  published = 1
ORDER BY
  title

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM tl_hideaway_target WHERE published=1 AND alias = NULL;

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

SELECT * FROM tl_hideaway_experience WHERE published=1 AND alias = NULL;

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

SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('4724e03f71a911e4b27f47d86675191d') 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 <= 1776508800
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > 1776508800
  )
ORDER BY
  tl_article.sorting

SELECT tl_article.* FROM tl_article WHERE tl_article.pid=56 AND tl_article.inColumn='FooterJS' AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<=1776508800) AND (tl_article.stop='' OR tl_article.stop>1776508800) ORDER BY tl_article.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
  *
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');