Symfony Profiler

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

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

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

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

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

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? 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 (?);

SELECT
  templates
FROM
  tl_theme

SELECT templates FROM tl_theme;

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

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

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

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

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(55, 0, 56, 0, 0, 0, 52, 53)
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '55,0,56,0,0,0,52,53'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(55,0,56,0,0,0,52,53) ORDER BY FIND_IN_SET(`tl_module`.`id`, '55,0,56,0,0,0,52,53');

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

SELECT tl_article.* FROM tl_article WHERE tl_article.pid='main' AND tl_article.inColumn=? AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1766601960') AND (tl_article.stop='' OR tl_article.stop>'1766601960') 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 <= '1766601960'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1766601960'
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

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

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

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

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=? AND tl_form_field.invisible='' AND tl_form_field.tstamp!=0 ORDER BY tl_form_field.sorting;

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  *
FROM
  tl_zLinkUserRight
WHERE
  pid = ?
  AND fkModuleAction = 'MOD09EDITUNIT'
ORDER BY
  fkModuleAction,
  fkUnit

SELECT * 
				                  FROM tl_zLinkUserRight 
								 WHERE pid=?
                                      AND fkModuleAction='MOD09EDITUNIT'
				              ORDER BY fkModuleAction, fkUnit;

SELECT
  DATABASE()

SELECT DATABASE();

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  *
FROM
  tl_zUnit
WHERE
  1 = 1
ORDER BY
  uName

SELECT * 
														 FROM tl_zUnit 
														WHERE 
														  1=1 
                                                          
													 ORDER BY uName;

SELECT
  DATABASE()

SELECT DATABASE();

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  *
FROM
  tl_zMasterdataValue
WHERE
  mvKey = ?
  AND 1 = 1
ORDER BY
  mvDefault DESC,
  mvOrder,
  mvName

SELECT * 
                                                          FROM tl_zMasterdataValue 
                                                         WHERE mvKey=?
                                                           AND 1=1
                                                               
                                                      ORDER BY mvDefault DESC, mvOrder, mvName;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

SELECT
  *
FROM
  tl_calendar_events
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_calendar_events WHERE id=? LIMIT 0,1;

SELECT
  id,
  title AS value
FROM
  tl_calendar
WHERE
  id IN (2)

SELECT id, title AS value FROM tl_calendar WHERE id IN (2);

SELECT
  id,
  name AS value
FROM
  tl_user
WHERE
  id IN (235)

SELECT id, name AS value FROM tl_user WHERE id IN (235);

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

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

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

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

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

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

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '1de07832e4dd11e3a1624f25cb8a5407'
    ),
    UNHEX(
      'f87889dc52be11e3aedaf5cf2c70ab0a'
    ),
    UNHEX(
      '1de07846e4dd11e3a1624f25cb8a5407'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '1de07832e4dd11e3a1624f25cb8a5407'
  ),
  tl_files.uuid != UNHEX(
    'f87889dc52be11e3aedaf5cf2c70ab0a'
  ),
  tl_files.uuid != UNHEX(
    '1de07846e4dd11e3a1624f25cb8a5407'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('1de07832e4dd11e3a1624f25cb8a5407'),UNHEX('f87889dc52be11e3aedaf5cf2c70ab0a'),UNHEX('1de07846e4dd11e3a1624f25cb8a5407')) ORDER BY tl_files.uuid!=UNHEX('1de07832e4dd11e3a1624f25cb8a5407'), tl_files.uuid!=UNHEX('f87889dc52be11e3aedaf5cf2c70ab0a'), tl_files.uuid!=UNHEX('1de07846e4dd11e3a1624f25cb8a5407');

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '1de07832e4dd11e3a1624f25cb8a5407'
    ),
    UNHEX(
      'f87889dc52be11e3aedaf5cf2c70ab0a'
    ),
    UNHEX(
      '1de07846e4dd11e3a1624f25cb8a5407'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '1de07832e4dd11e3a1624f25cb8a5407'
  ),
  tl_files.uuid != UNHEX(
    'f87889dc52be11e3aedaf5cf2c70ab0a'
  ),
  tl_files.uuid != UNHEX(
    '1de07846e4dd11e3a1624f25cb8a5407'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('1de07832e4dd11e3a1624f25cb8a5407'),UNHEX('f87889dc52be11e3aedaf5cf2c70ab0a'),UNHEX('1de07846e4dd11e3a1624f25cb8a5407')) ORDER BY tl_files.uuid!=UNHEX('1de07832e4dd11e3a1624f25cb8a5407'), tl_files.uuid!=UNHEX('f87889dc52be11e3aedaf5cf2c70ab0a'), tl_files.uuid!=UNHEX('1de07846e4dd11e3a1624f25cb8a5407');