Symfony Profiler

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

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

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
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias IN (?, ?)

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

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

SELECT * FROM tl_calendar_events WHERE 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
  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 (207)

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

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

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
  *
FROM
  tl_zUnit
WHERE
  1 = 1
ORDER BY
  uName

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

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.id = ?
  AND tl_calendar_events.pid IN(2)
  AND tl_calendar_events.published = '1'
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1766595120'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1766595120'
  )
LIMIT
  0, 1

SELECT tl_calendar_events.* FROM tl_calendar_events WHERE tl_calendar_events.id=? AND tl_calendar_events.pid IN(2) AND tl_calendar_events.published='1' AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1766595120') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1766595120') 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
  count(*) AS anzahl
FROM
  tl_zEventBooking
WHERE
  pid = ?

SELECT count(*) AS anzahl
													 FROM tl_zEventBooking
												    WHERE pid=?;

SELECT
  startDate,
  addTime,
  startTime,
  endTime,
  cmMoreDate,
  cmMoreDateTime
FROM
  tl_calendar_events
WHERE
  id = ?

SELECT startDate,addTime,startTime,endTime,cmMoreDate,cmMoreDateTime FROM tl_calendar_events 
												    WHERE id=?;

SELECT
  DATABASE()

SELECT DATABASE();

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

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

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

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

SELECT
  templates
FROM
  tl_theme

SELECT templates FROM tl_theme;

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
  uName,
  uUrl
FROM
  tl_zUnit
WHERE
  id = ?
LIMIT
  0, 1

SELECT uName,uUrl FROM tl_zUnit WHERE id = ? LIMIT 0,1;