Symfony Profiler

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT
  mc.clip_id,
  mc.user_id,
  mc.film_id,
  mc.public_key,
  mc.thumb_path,
  mc.preview_path,
  mc.duration,
  mc.quality,
  mc.is_vertical,
  mc.likes,
  mc.dislikes,
  mc.views,
  mc.status,
  mc.published_at,
  u.username,
  IFNULL(r.title, f.title) as title,
  IFNULL(r.description, f.description) as description
FROM
  movie_clip mc
  LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id
  AND f.lang_id = ?
  LEFT JOIN user u ON mc.user_id = u.user_id
  LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id
  AND r.lang_id = ?
WHERE
  mc.public_key = ?
LIMIT
  1

SELECT mc.clip_id, mc.user_id, mc.film_id, mc.public_key, mc.thumb_path, mc.preview_path, mc.duration, mc.quality, mc.is_vertical, mc.likes, mc.dislikes, mc.views, mc.status, mc.published_at, u.username, IFNULL(r.title, f.title) as title, IFNULL(r.description, f.description) as description FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=1 LEFT JOIN user u ON mc.user_id = u.user_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=2 WHERE mc.public_key = '4rhw6-k' LIMIT 1;

SELECT
  `path`
FROM
  `movie_clip_media`
WHERE
  `clip_id` = ?

SELECT `path` FROM `movie_clip_media` WHERE `clip_id` = 0x018EB04C6CD0732D8ED84A80279477B8;

SELECT
  film_id,
  original_title,
  title,
  poster_path,
  release_year
FROM
  `film`
WHERE
  `film_id` = ?

SELECT film_id,
           original_title,
           title,
           poster_path,
           release_year
    FROM `film`
    WHERE `film_id` = 0x0196050CFB4C70C0BAEEBBBBDFCC8E52;

SELECT
  `mchr`.`related_id`
FROM
  `movie_clip_has_related` as `mchr`
  LEFT JOIN `movie_clip` as `mc` USING (`clip_id`)
WHERE
  `mchr`.`clip_id` = ?
  AND `mc`.`status` = ?
ORDER BY
  `mchr`.`relevance` DESC
LIMIT
  ?
OFFSET
  ?

SELECT `mchr`.`related_id`
                FROM `movie_clip_has_related` as `mchr`
                LEFT JOIN `movie_clip` as `mc` USING (`clip_id`)
                WHERE `mchr`.`clip_id` = 0x018EB04C6CD0732D8ED84A80279477B8 AND `mc`.`status` = 10
                ORDER BY `mchr`.`relevance` DESC
                LIMIT 24
                OFFSET 0
            ;

SELECT
  `clip_id`,
  `search_field`
FROM
  `movie_clip`
WHERE
  `clip_id` = ?

SELECT `clip_id`, `search_field`
                FROM `movie_clip`
                WHERE `clip_id` = 0x018EB04C6CD0732D8ED84A80279477B8
            ;

SELECT
  `mc`.`clip_id`,
  MATCH (`search_field`) AGAINST (?) AS `relevance`
FROM
  `movie_clip` as `mc`
WHERE
  MATCH (`search_field`) AGAINST (?)
  AND `mc`.`clip_id` <> ?
  AND `mc`.`status` = ?
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `mc`.`clip_id`, MATCH (`search_field`) AGAINST ('По соображениям совести Hacksaw Ridge Сержант Хауэлл  даёт прозвища! ') AS `relevance`
                FROM `movie_clip` as `mc`
                WHERE MATCH (`search_field`) AGAINST ('По соображениям совести Hacksaw Ridge Сержант Хауэлл  даёт прозвища! ')
                  AND `mc`.`clip_id` <> 0x018EB04C6CD0732D8ED84A80279477B8
                  AND `mc`.`status` = 10
                ORDER BY `relevance` DESC
                LIMIT 24
            ;

INSERT IGNORE INTO `movie_clip_has_related` (
  `clip_id`, `related_id`, `relevance`
)
VALUES
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb04b-6296-7111-a4c0-21cac35074f1'
    ),
    27.972221374512
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb04c-42c8-7166-87a5-fbbd1104e630'
    ),
    27.972221374512
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb04c-136e-72c9-b564-ed1edec8d282'
    ),
    27.972221374512
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb04b-9fbe-7263-a911-f2025622b0db'
    ),
    27.972221374512
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb04c-5bf7-71be-ad55-494ad73e75e1'
    ),
    27.972221374512
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb04b-c28b-71fc-b321-06081fecadd3'
    ),
    27.972221374512
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb04c-7c3c-7197-843d-2c11fc940da3'
    ),
    27.972221374512
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb04b-7f5e-7392-9773-1fc51e655856'
    ),
    27.972221374512
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb04b-3f6f-70b3-9dbb-0281ee9bae29'
    ),
    27.972221374512
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb04b-25f0-7196-ab78-3a7e448e95bc'
    ),
    27.972221374512
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb04b-fca3-7088-a1ff-e2d8b61cb891'
    ),
    27.972221374512
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb0bf-d25a-72b6-a929-a7e60c9b6b61'
    ),
    11.714120864868
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb091-d2b0-7370-b8d8-c722198099ec'
    ),
    11.714120864868
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eafd8-d083-72c0-931d-c4d608d06e13'
    ),
    7.1943426132202
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eafb9-88a6-721e-9d40-0a1e504615c2'
    ),
    7.1943426132202
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eafd9-94f4-7160-b7c4-cd5275604e8d'
    ),
    7.1943426132202
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb002-37d0-7161-91ff-8503d4c1ff8e'
    ),
    7.1943426132202
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eaff5-176e-718e-8112-9c1f6e688a71'
    ),
    7.1943426132202
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb070-b801-739e-9be8-2eeddbef33cd'
    ),
    7.1943426132202
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb06f-0658-73f8-9d68-379d52f99898'
    ),
    7.1943426132202
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018eb09e-c0bd-73cc-a9a0-c55b6d5b0958'
    ),
    7.1943426132202
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018ed74e-6c14-71b7-8710-edaa88aafafd'
    ),
    7.1943426132202
  ),
  (
    UUID_TO_BIN(
      '018eb04c-6cd0-732d-8ed8-4a80279477b8'
    ),
    UUID_TO_BIN(
      '018edee8-c881-7197-861a-c5a5b5dbbaad'
    ),
    7.1943426132202
  )

INSERT IGNORE INTO `movie_clip_has_related` (`clip_id`, `related_id`, `relevance`)
            VALUES (UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb04b-6296-7111-a4c0-21cac35074f1'), 27.972221374512),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb04c-42c8-7166-87a5-fbbd1104e630'), 27.972221374512),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb04c-136e-72c9-b564-ed1edec8d282'), 27.972221374512),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb04b-9fbe-7263-a911-f2025622b0db'), 27.972221374512),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb04c-5bf7-71be-ad55-494ad73e75e1'), 27.972221374512),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb04b-c28b-71fc-b321-06081fecadd3'), 27.972221374512),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb04c-7c3c-7197-843d-2c11fc940da3'), 27.972221374512),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb04b-7f5e-7392-9773-1fc51e655856'), 27.972221374512),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb04b-3f6f-70b3-9dbb-0281ee9bae29'), 27.972221374512),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb04b-25f0-7196-ab78-3a7e448e95bc'), 27.972221374512),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb04b-fca3-7088-a1ff-e2d8b61cb891'), 27.972221374512),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb0bf-d25a-72b6-a929-a7e60c9b6b61'), 11.714120864868),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb091-d2b0-7370-b8d8-c722198099ec'), 11.714120864868),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eafd8-d083-72c0-931d-c4d608d06e13'), 7.1943426132202),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eafb9-88a6-721e-9d40-0a1e504615c2'), 7.1943426132202),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eafd9-94f4-7160-b7c4-cd5275604e8d'), 7.1943426132202),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb002-37d0-7161-91ff-8503d4c1ff8e'), 7.1943426132202),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eaff5-176e-718e-8112-9c1f6e688a71'), 7.1943426132202),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb070-b801-739e-9be8-2eeddbef33cd'), 7.1943426132202),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb06f-0658-73f8-9d68-379d52f99898'), 7.1943426132202),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018eb09e-c0bd-73cc-a9a0-c55b6d5b0958'), 7.1943426132202),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018ed74e-6c14-71b7-8710-edaa88aafafd'), 7.1943426132202),(UUID_TO_BIN('018eb04c-6cd0-732d-8ed8-4a80279477b8'), UUID_TO_BIN('018edee8-c881-7197-861a-c5a5b5dbbaad'), 7.1943426132202)
        ;

SELECT
  mc.clip_id,
  mc.film_id,
  mc.public_key,
  mc.thumb_path,
  mc.preview_path,
  mc.duration,
  mc.quality,
  mc.is_vertical,
  mc.likes,
  mc.dislikes,
  mc.views,
  mc.status,
  mc.published_at,
  f1.title as film_title,
  f1.original_title as film_original_title,
  f1.poster_path as film_poster_path,
  f1.release_year as film_release_year,
  IFNULL(r.title, f.title) as title
FROM
  movie_clip mc
  LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id
  AND f.lang_id = ?
  LEFT JOIN film f1 ON mc.film_id = f1.film_id
  LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id
  AND r.lang_id = ?
WHERE
  mc.clip_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

SELECT mc.clip_id, mc.film_id, mc.public_key, mc.thumb_path, mc.preview_path, mc.duration, mc.quality, mc.is_vertical, mc.likes, mc.dislikes, mc.views, mc.status, mc.published_at, f1.title as film_title, f1.original_title as film_original_title, f1.poster_path as film_poster_path, f1.release_year as film_release_year, IFNULL(r.title, f.title) as title FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=1 LEFT JOIN film f1 ON mc.film_id = f1.film_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=2 WHERE mc.clip_id IN (0x018EB04B62967111A4C021CAC35074F1, 0x018EB04C42C8716687A5FBBD1104E630, 0x018EB04C136E72C9B564ED1EDEC8D282, 0x018EB04B9FBE7263A911F2025622B0DB, 0x018EB04C5BF771BEAD55494AD73E75E1, 0x018EB04BC28B71FCB32106081FECADD3, 0x018EB04C7C3C7197843D2C11FC940DA3, 0x018EB04B7F5E739297731FC51E655856, 0x018EB04B3F6F70B39DBB0281EE9BAE29, 0x018EB04B25F07196AB783A7E448E95BC, 0x018EB04BFCA37088A1FFE2D8B61CB891, 0x018EB0BFD25A72B6A929A7E60C9B6B61, 0x018EB091D2B07370B8D8C722198099EC, 0x018EAFD8D08372C0931DC4D608D06E13, 0x018EAFB988A6721E9D400A1E504615C2, 0x018EAFD994F47160B7C4CD5275604E8D, 0x018EB00237D0716191FF8503D4C1FF8E, 0x018EAFF5176E718E81129C1F6E688A71, 0x018EB070B801739E9BE82EEDDBEF33CD, 0x018EB06F065873F89D68379D52F99898, 0x018EB09EC0BD73CCA9A0C55B6D5B0958, 0x018ED74E6C1471B78710EDAA88AAFAFD, 0x018EDEE8C8817197861AC5A5B5DBBAAD);