GET https://dev.muviki.cc/movie/8e2kmSB

Query Metrics

9 Database Queries
9 Different statements
50.39 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
28.38 ms
(56.33%)
1
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 ?
Parameters:
[
  "Мальчишник в Вегасе The Hangover Поиграем в блэкджек? "
  "Мальчишник в Вегасе The Hangover Поиграем в блэкджек? "
  b"\x01ŽÃ€\x00XrX½Ÿ‰EF¬\x12\x10"
  10
  24
]
18.84 ms
(37.38%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id`, `related_id`, `relevance`)
            VALUES (UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018ec381-4eaa-70de-a635-fa5bbe9a7441'), 19.930393218994),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018ec381-aad5-71ad-8d25-276e4eb52e05'), 19.930393218994),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018ec380-5d66-72a9-a401-d3462044f5b4'), 19.930393218994),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018ec37f-7154-7033-8d25-1c5f4a14e28f'), 19.930393218994),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018ec380-c6d0-7239-be85-bd58f8d61a99'), 19.930393218994),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018eb074-3616-72dd-976f-be9e017164bf'), 13.28692817688),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018eb073-d1bf-73b0-ab2b-e8926e3ac3aa'), 13.28692817688),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018eb073-f8ab-7192-baa7-ba432901cbe2'), 13.28692817688),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018eb073-c2cf-736b-a045-1fd4f48fbc21'), 13.28692817688),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018eb074-1786-7386-9d3d-40430dea9fba'), 13.28692817688),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018eb073-9e0e-7149-9ada-9786a2d356b4'), 13.28692817688),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018eb073-40aa-7320-beaf-335e16ad1072'), 13.28692817688),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018eb073-79ed-736d-8f1b-dfb4f29fe430'), 13.28692817688),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018eb487-b2c4-732a-8154-e23b75b20eed'), 6.6434640884399),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018eb488-1375-71e0-a2b2-a223db590751'), 6.6434640884399),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018ece3e-78e9-72d4-89d0-fbc1740c2756'), 6.6434640884399),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018ece3c-5b19-705d-9458-a56094574a6e'), 6.6434640884399),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018ece3d-4ed0-71ed-b2e9-0ccad25bcfbb'), 6.6434640884399),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018ece3d-f281-735f-b960-cb9e77faa0be'), 6.6434640884399),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018ece3c-d616-70e5-840b-9480cf4ba656'), 6.6434640884399),(UUID_TO_BIN('018ec380-0058-7258-bd9f-894546ac1210'), UUID_TO_BIN('018ece3c-7a6a-71c8-9df6-81022df90a81'), 6.6434640884399)
Parameters:
[]
0.92 ms
(1.82%)
1
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  b"\x01ŽÃNªpÞ¦5ú[¾štA"
  b"\x01ŽÃªÕq­Ž%'nNµ.\x05"
  b"\x01ŽÃ€]fr©¤\x01ÓF Dõ´"
  b"\x01ŽÃ\x7FqTp3Ž%\x1C_J\x14â"
  b"\x01ŽÃ€ÆÐr9¾…½XøÖ\x1A"
  b"\x01ްt6\x16rÝ—o¾ž\x01qd¿"
  b"\x01ްsÑ¿s°«+è’n:ê"
  b"\x01ްsø«q’º§ºC)\x01Ëâ"
  b"\x01ްsÂÏsk E\x1FÔô¼!"
  b"\x01ްt\x17†s†=@C\rꟺ"
  b"\x01ްsž\x0EqIšÚ—†¢ÓV´"
  b"\x01ްs@ªs ¾¯3^\x16­\x10r"
  b"\x01ްsyísm\eß´òŸä0"
  b"\x01Ž´‡²Äs*Tâ;u²\x0Eí"
  b"\x01Ž´ˆ\x13uqࢲ¢#ÛY\x07Q"
  b"\x01ŽÎ>xérÔ‰ÐûÁt\f'V"
  b"\x01ŽÎ<[\x19p]”X¥`”WJn"
  b"\x01ŽÎ=NÐqí²é\fÊÒ[Ï»"
  b"\x01ŽÎ=òs_¹`Ëžwú ¾"
  b"\x01ŽÎ<Ö\x16på„\v”€ÏK¦V"
  b"""
    \x01ŽÎ<zjqȝö\x02\n
    
    """
]
0.66 ms
(1.30%)
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=? 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
Parameters:
[
  1
  2
  "8e2kmSB"
]
0.43 ms
(0.85%)
1
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 ?
Parameters:
[
  b"\x01ŽÃ€\x00XrX½Ÿ‰EF¬\x12\x10"
  10
  24
  0
]
0.40 ms
(0.80%)
1
SELECT `path` FROM `movie_clip_media` WHERE `clip_id` = ?
Parameters:
[
  b"\x01ŽÃ€\x00XrX½Ÿ‰EF¬\x12\x10"
]
0.27 ms
(0.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
0.27 ms
(0.54%)
1
SELECT film_id,
           original_title,
           title,
           poster_path,
           release_year
    FROM `film`
    WHERE `film_id` = ?
Parameters:
[
  b"\x01\x05\rñ‹p{ˆÜ`èÍ-é\x18"
]
0.22 ms
(0.44%)
1
SELECT `clip_id`, `search_field`
                FROM `movie_clip`
                WHERE `clip_id` = ?
Parameters:
[
  b"\x01ŽÃ€\x00XrX½Ÿ‰EF¬\x12\x10"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

No loaded entities.