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

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

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

SELECT
  tl_calendar.*
FROM
  tl_calendar
WHERE
  tl_calendar.id IN(2)
ORDER BY
  FIND_IN_SET(`tl_calendar`.`id`, '2')

SELECT tl_calendar.* FROM tl_calendar WHERE tl_calendar.id IN(2) ORDER BY FIND_IN_SET(`tl_calendar`.`id`, '2');

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
  tl_calendar_events.*
FROM
  tl_calendar_events
WHERE
  tl_calendar_events.pid = ?
  AND (
    (
      tl_calendar_events.startTime >= 1766564934
      AND tl_calendar_events.startTime <= 4294967295
    )
    OR (
      tl_calendar_events.endTime >= 1766564934
      AND tl_calendar_events.endTime <= 4294967295
    )
    OR (
      tl_calendar_events.startTime <= 1766564934
      AND tl_calendar_events.endTime >= 4294967295
    )
    OR (
      tl_calendar_events.recurring = '1'
      AND (
        tl_calendar_events.recurrences = 0
        OR tl_calendar_events.repeatEnd >= 1766564934
      )
      AND tl_calendar_events.startTime <= 4294967295
    )
  )
  AND tl_calendar_events.published = '1'
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1766564880'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1766564880'
  )
ORDER BY
  tl_calendar_events.startTime

SELECT tl_calendar_events.* FROM tl_calendar_events WHERE tl_calendar_events.pid=? AND ((tl_calendar_events.startTime>=1766564934 AND tl_calendar_events.startTime<=4294967295) OR (tl_calendar_events.endTime>=1766564934 AND tl_calendar_events.endTime<=4294967295) OR (tl_calendar_events.startTime<=1766564934 AND tl_calendar_events.endTime>=4294967295) OR (tl_calendar_events.recurring='1' AND (tl_calendar_events.recurrences=0 OR tl_calendar_events.repeatEnd>=1766564934) AND tl_calendar_events.startTime<=4294967295)) AND tl_calendar_events.published='1' AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1766564880') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1766564880') ORDER BY tl_calendar_events.startTime;

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 <= '1766564880'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1766564880'
  )
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<='1766564880') AND (tl_article.stop='' OR tl_article.stop>'1766564880') 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 <= '1766564880'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1766564880'
  )
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<='1766564880') AND (tl_article.stop='' OR tl_article.stop>'1766564880') 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 <= '1766564880'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1766564880'
  )
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<='1766564880') AND (tl_article.stop='' OR tl_article.stop>'1766564880') 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');