Symfony Profiler

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  (
    tl_page.type = 'root'
    AND (
      tl_page.dns = 'ylem.metamodels-playground.de'
      OR tl_page.dns = ''
    )
  )

SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns='ylem.metamodels-playground.de' OR tl_page.dns=''));

SELECT
  *
FROM
  tl_metamodel
WHERE
  tableName = :tableName
LIMIT
  1

SELECT * FROM tl_metamodel WHERE tableName='mm_handydaten' LIMIT 1;

SELECT
  *
FROM
  tl_metamodel_attribute
WHERE
  pid = :pid
ORDER BY
  sorting ASC

SELECT * FROM tl_metamodel_attribute WHERE pid='12' ORDER BY sorting ASC;

SELECT
  *
FROM
  tl_metamodel_dcasetting
WHERE
  (pid = :pid)
  AND (published = :published)
ORDER BY
  sorting ASC

SELECT * FROM tl_metamodel_dcasetting WHERE (pid='13') AND (published=1) ORDER BY sorting ASC;

SELECT
  cond.*,
  setting.attr_id AS setting_attr_id
FROM
  tl_metamodel_dcasetting_condition cond
  LEFT JOIN tl_metamodel_dcasetting setting ON cond.settingId = setting.id
  LEFT JOIN tl_metamodel_dca dca ON setting.pid = dca.id
WHERE
  (cond.enabled = 1)
  AND (setting.published = 1)
  AND (dca.id = :screenId)
ORDER BY
  pid ASC,
  sorting ASC

SELECT cond.*, setting.attr_id AS setting_attr_id FROM tl_metamodel_dcasetting_condition cond LEFT JOIN tl_metamodel_dcasetting setting ON cond.settingId=setting.id LEFT JOIN tl_metamodel_dca dca ON setting.pid=dca.id WHERE (cond.enabled=1) AND (setting.published=1) AND (dca.id='13') ORDER BY pid ASC, sorting ASC;

SELECT
  *
FROM
  tl_metamodel_dca_sortgroup
WHERE
  pid = :screenId
ORDER BY
  sorting ASC

SELECT * FROM tl_metamodel_dca_sortgroup WHERE pid='13' ORDER BY sorting ASC;

SELECT
  *
FROM
  tl_metamodel_dca_combine
WHERE
  (
    fe_group IN (:groupList)
  )
  OR (fe_group = 0)
ORDER BY
  pid ASC,
  sorting ASC

SELECT * FROM tl_metamodel_dca_combine WHERE (fe_group IN (-1)) OR (fe_group=0) ORDER BY pid ASC, sorting ASC;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias = 'index'
  OR tl_page.alias = '/'

SELECT tl_page.* FROM tl_page WHERE tl_page.alias='index' OR tl_page.alias='/';

SELECT
  d.*
FROM
  tl_metamodel_dca d
  LEFT JOIN tl_metamodel m ON m.id = d.pid
WHERE
  d.id IN (:idList)
ORDER BY
  m.sorting ASC

SELECT d.* FROM tl_metamodel_dca d LEFT JOIN tl_metamodel m ON m.id=d.pid WHERE d.id IN ('11', '12', '13') ORDER BY m.sorting ASC;

SELECT
  *
FROM
  tl_metamodel
ORDER BY
  sorting ASC

SELECT * FROM tl_metamodel ORDER BY sorting ASC;