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 = 'ZiYCqSM' LIMIT 1;

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

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

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` = 0x0196050CDF9972D891AC59FF1253FACA;

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` = 0x018EB02A45DE72E680A286869CF7B965 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` = 0x018EB02A45DE72E680A286869CF7B965
            ;

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 ('Дневник памяти The Notebook Ты со мной встретишься? ') AS `relevance`
                FROM `movie_clip` as `mc`
                WHERE MATCH (`search_field`) AGAINST ('Дневник памяти The Notebook Ты со мной встретишься? ')
                  AND `mc`.`clip_id` <> 0x018EB02A45DE72E680A286869CF7B965
                  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(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb02a-faff-7009-8bca-50b0d04c4871'
    ),
    23.659381866455
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb02a-a191-729f-949d-454d07e26f16'
    ),
    23.659381866455
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb02a-e461-72ed-81d8-7e0abc53da42'
    ),
    23.659381866455
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb02a-5bd7-70af-bf3a-ead7df75de66'
    ),
    23.659381866455
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb02a-c77c-734c-a1f6-23c1e4c479c0'
    ),
    23.659381866455
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb02a-b70a-73bc-a178-40c1cac0cd6d'
    ),
    23.659381866455
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018ee3b3-237a-7269-8299-ddabfea4349c'
    ),
    7.95538854599
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb029-719b-739f-851d-8199ac0f4cd7'
    ),
    7.4181051254272
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb049-ceb9-73ad-82ec-da438677e9e9'
    ),
    7.4181051254272
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb04a-687e-7037-8209-aac9d1f84ae6'
    ),
    7.4181051254272
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eafe2-4dbc-706c-9db8-7e89a7d452c0'
    ),
    6.8104114532471
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb02d-2d04-7032-a9bf-0bb55ab5d49a'
    ),
    6.8104114532471
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb0e2-3d83-71f4-a30d-34f40cd9ebe5'
    ),
    6.8104114532471
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb0e4-dc96-73a0-887f-a9e8edeb3e92'
    ),
    6.8104114532471
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018eb769-7839-727d-9ede-b80cadfa5aea'
    ),
    6.8104114532471
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018ebde3-002e-7241-88ac-60a6eff1d94a'
    ),
    6.8104114532471
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018ebd73-8770-7197-b271-43a6a11b050e'
    ),
    6.8104114532471
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018ebdde-dfc4-72ff-bda3-b625c9fcf01f'
    ),
    6.8104114532471
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018ec9d8-0eda-71f3-b8fa-f85fcec7ced2'
    ),
    6.8104114532471
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018ec3ac-b08e-72f2-90ab-22beffc63eda'
    ),
    6.8104114532471
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018ede8c-09b7-726d-b3e7-c635f3295a54'
    ),
    6.8104114532471
  ),
  (
    UUID_TO_BIN(
      '018eb02a-45de-72e6-80a2-86869cf7b965'
    ),
    UUID_TO_BIN(
      '018ee340-2bed-70a7-a4b2-0bf13b731f2e'
    ),
    6.8104114532471
  )

INSERT IGNORE INTO `movie_clip_has_related` (`clip_id`, `related_id`, `relevance`)
            VALUES (UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb02a-faff-7009-8bca-50b0d04c4871'), 23.659381866455),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb02a-a191-729f-949d-454d07e26f16'), 23.659381866455),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb02a-e461-72ed-81d8-7e0abc53da42'), 23.659381866455),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb02a-5bd7-70af-bf3a-ead7df75de66'), 23.659381866455),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb02a-c77c-734c-a1f6-23c1e4c479c0'), 23.659381866455),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb02a-b70a-73bc-a178-40c1cac0cd6d'), 23.659381866455),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018ee3b3-237a-7269-8299-ddabfea4349c'), 7.95538854599),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb029-719b-739f-851d-8199ac0f4cd7'), 7.4181051254272),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb049-ceb9-73ad-82ec-da438677e9e9'), 7.4181051254272),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb04a-687e-7037-8209-aac9d1f84ae6'), 7.4181051254272),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eafe2-4dbc-706c-9db8-7e89a7d452c0'), 6.8104114532471),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb02d-2d04-7032-a9bf-0bb55ab5d49a'), 6.8104114532471),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb0e2-3d83-71f4-a30d-34f40cd9ebe5'), 6.8104114532471),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb0e4-dc96-73a0-887f-a9e8edeb3e92'), 6.8104114532471),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018eb769-7839-727d-9ede-b80cadfa5aea'), 6.8104114532471),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018ebde3-002e-7241-88ac-60a6eff1d94a'), 6.8104114532471),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018ebd73-8770-7197-b271-43a6a11b050e'), 6.8104114532471),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018ebdde-dfc4-72ff-bda3-b625c9fcf01f'), 6.8104114532471),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018ec9d8-0eda-71f3-b8fa-f85fcec7ced2'), 6.8104114532471),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018ec3ac-b08e-72f2-90ab-22beffc63eda'), 6.8104114532471),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018ede8c-09b7-726d-b3e7-c635f3295a54'), 6.8104114532471),(UUID_TO_BIN('018eb02a-45de-72e6-80a2-86869cf7b965'), UUID_TO_BIN('018ee340-2bed-70a7-a4b2-0bf13b731f2e'), 6.8104114532471)
        ;

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 (0x018EB02AFAFF70098BCA50B0D04C4871, 0x018EB02AA191729F949D454D07E26F16, 0x018EB02AE46172ED81D87E0ABC53DA42, 0x018EB02A5BD770AFBF3AEAD7DF75DE66, 0x018EB02AC77C734CA1F623C1E4C479C0, 0x018EB02AB70A73BCA17840C1CAC0CD6D, 0x018EE3B3237A72698299DDABFEA4349C, 0x018EB029719B739F851D8199AC0F4CD7, 0x018EB049CEB973AD82ECDA438677E9E9, 0x018EB04A687E70378209AAC9D1F84AE6, 0x018EAFE24DBC706C9DB87E89A7D452C0, 0x018EB02D2D047032A9BF0BB55AB5D49A, 0x018EB0E23D8371F4A30D34F40CD9EBE5, 0x018EB0E4DC9673A0887FA9E8EDEB3E92, 0x018EB7697839727D9EDEB80CADFA5AEA, 0x018EBDE3002E724188AC60A6EFF1D94A, 0x018EBD7387707197B27143A6A11B050E, 0x018EBDDEDFC472FFBDA3B625C9FCF01F, 0x018EC9D80EDA71F3B8FAF85FCEC7CED2, 0x018EC3ACB08E72F290AB22BEFFC63EDA, 0x018EDE8C09B7726DB3E7C635F3295A54, 0x018EE3402BED70A7A4B20BF13B731F2E);