Symfony Profiler

SELECT
  p.id AS id0,
  p.slug AS slug1,
  p.title AS title2,
  p.broadcast_at AS broadcast_at3,
  p.youtube AS youtube4,
  p.dailymotion AS dailymotion5,
  p.vimeo AS vimeo6,
  p.description AS description7,
  p.current_provider AS current_provider8,
  p.created_at AS created_at9,
  p.updated_at AS updated_at10,
  p.iframe AS iframe11,
  p.iframe2 AS iframe212,
  p.playlist_monday AS playlist_monday13,
  p.playlist_tuesday AS playlist_tuesday14,
  p.playlist_wednesday AS playlist_wednesday15,
  p.playlist_thursday AS playlist_thursday16,
  p.playlist_friday AS playlist_friday17,
  p.playlist_saturday AS playlist_saturday18,
  p.playlist_sunday AS playlist_sunday19,
  p.playlist_recent_successes AS playlist_recent_successes20,
  p.product_link AS product_link21,
  p.product_text AS product_text22,
  p.alt AS alt23,
  p.category_id AS category_id24,
  p.image_id AS image_id25,
  p.user_id AS user_id26,
  p.product_image_id AS product_image_id27,
  pc.id AS id28,
  pc.slug AS slug29,
  pc.name AS name30,
  pc.alt AS alt31,
  pc.position AS position32,
  pc.activated AS activated33,
  pc.description AS description34,
  pc.image_id AS image_id35,
  mm.name AS name36,
  mm.description AS description37,
  mm.enabled AS enabled38,
  mm.provider_name AS provider_name39,
  mm.provider_status AS provider_status40,
  mm.provider_reference AS provider_reference41,
  mm.provider_metadata AS provider_metadata42,
  mm.width AS width43,
  mm.height AS height44,
  mm.length AS length45,
  mm.content_type AS content_type46,
  mm.content_size AS content_size47,
  mm.copyright AS copyright48,
  mm.author_name AS author_name49,
  mm.context AS context50,
  mm.cdn_is_flushable AS cdn_is_flushable51,
  mm.cdn_flush_identifier AS cdn_flush_identifier52,
  mm.cdn_flush_at AS cdn_flush_at53,
  mm.cdn_status AS cdn_status54,
  mm.updated_at AS updated_at55,
  mm.created_at AS created_at56,
  mm.id AS id57
FROM
  program p
  JOIN program_category pc on p.category_id = pc.id
  JOIN media__media mm on p.image_id = mm.id
WHERE
  p.slug = ?
  AND p.broadcast_at <= CURRENT_TIMESTAMP()
  AND (
    p.youtube IS NOT NULL
    OR p.dailymotion IS NOT NULL
    OR p.iframe IS NOT NULL
    OR p.vimeo IS NOT NULL
    OR p.iframe2 IS NOT NULL
  )
UNION
  (
    SELECT
      p.id AS id0,
      p.slug AS slug1,
      p.title AS title2,
      p.broadcast_at AS broadcast_at3,
      p.youtube AS youtube4,
      p.dailymotion AS dailymotion5,
      p.vimeo AS vimeo6,
      p.description AS description7,
      p.current_provider AS current_provider8,
      p.created_at AS created_at9,
      p.updated_at AS updated_at10,
      p.iframe AS iframe11,
      p.iframe2 AS iframe212,
      p.playlist_monday AS playlist_monday13,
      p.playlist_tuesday AS playlist_tuesday14,
      p.playlist_wednesday AS playlist_wednesday15,
      p.playlist_thursday AS playlist_thursday16,
      p.playlist_friday AS playlist_friday17,
      p.playlist_saturday AS playlist_saturday18,
      p.playlist_sunday AS playlist_sunday19,
      p.playlist_recent_successes AS playlist_recent_successes20,
      p.product_link AS product_link21,
      p.product_text AS product_text22,
      p.alt AS alt23,
      p.category_id AS category_id24,
      p.image_id AS image_id25,
      p.user_id AS user_id26,
      p.product_image_id AS product_image_id27,
      pc.id AS id28,
      pc.slug AS slug29,
      pc.name AS name30,
      pc.alt AS alt31,
      pc.position AS position32,
      pc.activated AS activated33,
      pc.description AS description34,
      pc.image_id AS image_id35,
      mm.name AS name36,
      mm.description AS description37,
      mm.enabled AS enabled38,
      mm.provider_name AS provider_name39,
      mm.provider_status AS provider_status40,
      mm.provider_reference AS provider_reference41,
      mm.provider_metadata AS provider_metadata42,
      mm.width AS width43,
      mm.height AS height44,
      mm.length AS length45,
      mm.content_type AS content_type46,
      mm.content_size AS content_size47,
      mm.copyright AS copyright48,
      mm.author_name AS author_name49,
      mm.context AS context50,
      mm.cdn_is_flushable AS cdn_is_flushable51,
      mm.cdn_flush_identifier AS cdn_flush_identifier52,
      mm.cdn_flush_at AS cdn_flush_at53,
      mm.cdn_status AS cdn_status54,
      mm.updated_at AS updated_at55,
      mm.created_at AS created_at56,
      mm.id AS id57
    FROM
      program p
      JOIN program_category pc on p.category_id = pc.id
      JOIN media__media mm on p.image_id = mm.id
    WHERE
      category_id = (
        SELECT
          category_id
        FROM
          program
        WHERE
          slug = ?
      )
      AND p.slug <> ?
      AND p.broadcast_at <= CURRENT_TIMESTAMP()
      AND (
        p.youtube IS NOT NULL
        OR p.dailymotion IS NOT NULL
        OR p.iframe IS NOT NULL
        OR p.vimeo IS NOT NULL
        OR p.iframe2 IS NOT NULL
      )
    ORDER BY
      broadcast_at DESC
    LIMIT
      9
  )

SELECT p.id AS id0, p.slug AS slug1, p.title AS title2, p.broadcast_at AS broadcast_at3, p.youtube AS youtube4, p.dailymotion AS dailymotion5, p.vimeo AS vimeo6, p.description AS description7, p.current_provider AS current_provider8, p.created_at AS created_at9, p.updated_at AS updated_at10, p.iframe AS iframe11, p.iframe2 AS iframe212, p.playlist_monday AS playlist_monday13, p.playlist_tuesday AS playlist_tuesday14, p.playlist_wednesday AS playlist_wednesday15, p.playlist_thursday AS playlist_thursday16, p.playlist_friday AS playlist_friday17, p.playlist_saturday AS playlist_saturday18, p.playlist_sunday AS playlist_sunday19, p.playlist_recent_successes AS playlist_recent_successes20, p.product_link AS product_link21, p.product_text AS product_text22, p.alt AS alt23, p.category_id AS category_id24, p.image_id AS image_id25, p.user_id AS user_id26, p.product_image_id AS product_image_id27, pc.id AS id28, pc.slug AS slug29, pc.name AS name30, pc.alt AS alt31, pc.position AS position32, pc.activated AS activated33, pc.description AS description34, pc.image_id AS image_id35, mm.name AS name36, mm.description AS description37, mm.enabled AS enabled38, mm.provider_name AS provider_name39, mm.provider_status AS provider_status40, mm.provider_reference AS provider_reference41, mm.provider_metadata AS provider_metadata42, mm.width AS width43, mm.height AS height44, mm.length AS length45, mm.content_type AS content_type46, mm.content_size AS content_size47, mm.copyright AS copyright48, mm.author_name AS author_name49, mm.context AS context50, mm.cdn_is_flushable AS cdn_is_flushable51, mm.cdn_flush_identifier AS cdn_flush_identifier52, mm.cdn_flush_at AS cdn_flush_at53, mm.cdn_status AS cdn_status54, mm.updated_at AS updated_at55, mm.created_at AS created_at56, mm.id AS id57
            FROM program p
            JOIN program_category pc on p.category_id = pc.id
            JOIN media__media mm on p.image_id = mm.id
            WHERE
                p.slug = 'newsite'
                AND p.broadcast_at <= CURRENT_TIMESTAMP()
                AND (p.youtube IS NOT NULL OR p.dailymotion IS NOT NULL OR p.iframe IS NOT NULL OR p.vimeo IS NOT NULL OR p.iframe2 IS NOT NULL)
            UNION
            (SELECT p.id AS id0, p.slug AS slug1, p.title AS title2, p.broadcast_at AS broadcast_at3, p.youtube AS youtube4, p.dailymotion AS dailymotion5, p.vimeo AS vimeo6, p.description AS description7, p.current_provider AS current_provider8, p.created_at AS created_at9, p.updated_at AS updated_at10, p.iframe AS iframe11, p.iframe2 AS iframe212, p.playlist_monday AS playlist_monday13, p.playlist_tuesday AS playlist_tuesday14, p.playlist_wednesday AS playlist_wednesday15, p.playlist_thursday AS playlist_thursday16, p.playlist_friday AS playlist_friday17, p.playlist_saturday AS playlist_saturday18, p.playlist_sunday AS playlist_sunday19, p.playlist_recent_successes AS playlist_recent_successes20, p.product_link AS product_link21, p.product_text AS product_text22, p.alt AS alt23, p.category_id AS category_id24, p.image_id AS image_id25, p.user_id AS user_id26, p.product_image_id AS product_image_id27, pc.id AS id28, pc.slug AS slug29, pc.name AS name30, pc.alt AS alt31, pc.position AS position32, pc.activated AS activated33, pc.description AS description34, pc.image_id AS image_id35, mm.name AS name36, mm.description AS description37, mm.enabled AS enabled38, mm.provider_name AS provider_name39, mm.provider_status AS provider_status40, mm.provider_reference AS provider_reference41, mm.provider_metadata AS provider_metadata42, mm.width AS width43, mm.height AS height44, mm.length AS length45, mm.content_type AS content_type46, mm.content_size AS content_size47, mm.copyright AS copyright48, mm.author_name AS author_name49, mm.context AS context50, mm.cdn_is_flushable AS cdn_is_flushable51, mm.cdn_flush_identifier AS cdn_flush_identifier52, mm.cdn_flush_at AS cdn_flush_at53, mm.cdn_status AS cdn_status54, mm.updated_at AS updated_at55, mm.created_at AS created_at56, mm.id AS id57
            FROM program p
            JOIN program_category pc on p.category_id = pc.id
            JOIN media__media mm on p.image_id = mm.id
            WHERE
                category_id = (SELECT category_id
                                 FROM program
                                 WHERE slug = 'newsite')
                AND p.slug <> 'newsite'
                AND p.broadcast_at <= CURRENT_TIMESTAMP()
                AND (p.youtube IS NOT NULL OR p.dailymotion IS NOT NULL OR p.iframe IS NOT NULL OR p.vimeo IS NOT NULL OR p.iframe2 IS NOT NULL)
            ORDER BY broadcast_at DESC LIMIT 9);

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.value AS value_3
FROM
  parameter t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3 FROM parameter t0 WHERE t0.`key` = 'currentVideoProvider' LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'tvlwebpp'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'tvlwebpp'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

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_NAME = ?
  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 = 'tvlwebpp' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  DISTINCT 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.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'tvlwebpp' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            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 = 'tvlwebpp' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'tvlwebpp' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  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 = 'tvlwebpp'
        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'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       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 = 'tvlwebpp'
            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 = 'tvlwebpp' AND t.TABLE_SCHEMA = 'tvlwebpp' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  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 = ?
  AND TABLE_NAME = ?
ORDER BY
  SEQ_IN_INDEX

SELECT        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 = 'tvlwebpp' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  DATABASE()

SELECT DATABASE();