Symfony Profiler

SELECT
  c.TABLE_NAME,
  c.COLUMN_NAME AS field,
  IF(
    c.COLUMN_TYPE = 'longtext'
    AND EXISTS(
      SELECT
        *
      from
        information_schema.CHECK_CONSTRAINTS i_c
      WHERE
        i_c.CONSTRAINT_SCHEMA = 'x85sfw_addictic'
        AND i_c.TABLE_NAME = c.TABLE_NAME
        AND i_c.CHECK_CLAUSE = CONCAT(
          'json_valid(`', c.COLUMN_NAME, '`)'
        )
    ),
    'json',
    c.COLUMN_TYPE
  ) AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY
  ORDINAL_POSITION

SELECT c.TABLE_NAME,       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'x85sfw_addictic'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = 'x85sfw_addictic' AND t.TABLE_SCHEMA = 'x85sfw_addictic' AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`pid` = ?
ORDER BY
  sorting

SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=1 ORDER BY sorting;

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  tl_article.pid = ?
  AND tl_article.showTeaser = 1
  AND tl_article.published = 1
  AND (
    tl_article.start = ''
    OR tl_article.start <= 1768275120
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > 1768275120
  )
ORDER BY
  tl_article.sorting

SELECT tl_article.* FROM tl_article WHERE tl_article.pid=60 AND tl_article.showTeaser=1 AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1768275120) AND (tl_article.stop='' OR tl_article.stop>1768275120) ORDER BY tl_article.sorting;

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'x85sfw_addictic' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  tl_news.*
FROM
  tl_news
WHERE
  tl_news.pid = ?
  AND tl_news.source = 'default'
  AND tl_news.published = 1
  AND (
    tl_news.start = ''
    OR tl_news.start <= 1768275120
  )
  AND (
    tl_news.stop = ''
    OR tl_news.stop > 1768275120
  )
ORDER BY
  tl_news.date DESC

SELECT tl_news.* FROM tl_news WHERE tl_news.pid=2 AND tl_news.source='default' AND tl_news.published=1 AND (tl_news.start='' OR tl_news.start<=1768275120) AND (tl_news.stop='' OR tl_news.stop>1768275120) ORDER BY tl_news.date DESC;

SELECT
  TABLE_NAME,
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
ORDER BY
  SEQ_IN_INDEX

SELECT TABLE_NAME,        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'x85sfw_addictic' ORDER BY SEQ_IN_INDEX;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  (
    tl_page.type = 'root'
    AND (
      tl_page.dns = ?
      OR tl_page.dns = ''
    )
  )

SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns='addictic.ci-com.fr' OR tl_page.dns=''));

SELECT
  DISTINCT k.TABLE_NAME,
  k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'x85sfw_addictic' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT k.TABLE_NAME,            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'x85sfw_addictic' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'x85sfw_addictic' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(1)

SELECT id, pid FROM tl_page WHERE pid IN(1);

SELECT
  tl_add_glossary_term.*
FROM
  tl_add_glossary_term
WHERE
  published = '1'

SELECT tl_add_glossary_term.* FROM tl_add_glossary_term WHERE published = '1';

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(
    51, 99, 100, 116, 87, 86, 7, 15, 39, 49,
    50, 60
  )

SELECT id, pid FROM tl_page WHERE pid IN(51,99,100,116,87,86,7,15,39,49,50,60);

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(
    16, 21, 45, 117, 40, 52, 54, 55, 56, 57,
    94, 95, 69, 70, 71, 72, 73, 74, 75, 76,
    77, 78, 79, 80, 81, 82, 10, 3, 4, 34, 17,
    25, 37, 42, 58, 84, 96, 98, 8, 11, 115
  )

SELECT id, pid FROM tl_page WHERE pid IN(16,21,45,117,40,52,54,55,56,57,94,95,69,70,71,72,73,74,75,76,77,78,79,80,81,82,10,3,4,34,17,25,37,42,58,84,96,98,8,11,115);

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias = ?
  OR tl_page.alias = ?

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

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(
    12, 101, 103, 104, 111, 112, 113, 114,
    13, 106, 107, 108, 109, 110, 14
  )

SELECT id, pid FROM tl_page WHERE pid IN(12,101,103,104,111,112,113,114,13,106,107,108,109,110,14);

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
  AND tl_page.published = 1
  AND (
    tl_page.start = ''
    OR tl_page.start <= 1768275120
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1768275120
  )
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id=1 AND tl_page.published=1 AND (tl_page.start='' OR tl_page.start<=1768275120) AND (tl_page.stop='' OR tl_page.stop>1768275120) LIMIT 0,1;

SELECT
  *
FROM
  tl_realisation
WHERE
  published = '1'

SELECT * FROM tl_realisation WHERE published = '1';

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(105, 36, 48, 97)

SELECT id, pid FROM tl_page WHERE pid IN(105,36,48,97);

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.type = 'root'
  AND tl_page.dns = ?
  AND tl_page.published = 1
  AND (
    tl_page.start = ''
    OR tl_page.start <= 1768275120
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1768275120
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND tl_page.dns='' AND tl_page.published=1 AND (tl_page.start='' OR tl_page.start<=1768275120) AND (tl_page.stop='' OR tl_page.stop>1768275120);

SELECT
  tl_calendar.*
FROM
  tl_calendar
WHERE
  tl_calendar.`protected` = ?

SELECT tl_calendar.* FROM tl_calendar WHERE tl_calendar.`protected`='';

SELECT
  tl_faq_category.*
FROM
  tl_faq_category

SELECT tl_faq_category.* FROM tl_faq_category;

SELECT
  *
FROM
  tl_formation
WHERE
  published = '1'

SELECT * FROM tl_formation WHERE published = '1';

SELECT
  tl_news_archive.*
FROM
  tl_news_archive
WHERE
  tl_news_archive.`protected` = ?

SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.`protected`='';

SELECT
  tl_newsletter_channel.*
FROM
  tl_newsletter_channel

SELECT tl_newsletter_channel.* FROM tl_newsletter_channel;

SELECT
  *
FROM
  tl_expertise
WHERE
  published = '1'

SELECT * FROM tl_expertise WHERE published = '1';