GET https://dev.muviki.cc/movie/Hmr5jJQ

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.09 ms
(19.80%)
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:
[
  "300 спартанцев 300 Спарта падёт, вся Греция падёт. "
  "300 спартанцев 300 Спарта падёт, вся Греция падёт. "
  b"\x01ްx\r\x13p1£\tåB\x7FòJw"
  10
  24
]
0.91 ms
(16.62%)
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ްxn\rp–õdûÍYS´"
  b"\x01ްv.‡pGšÛQú€±)\"
  b"\x01ްvÍ@p´¦£@\x16êxÃ4"
  b"\x01ްu \x08sl‘wx¡Ü+É3"
  b"\x01ްun²r±›ÇE£~7˪"
  b"""
    \x01ްuô=rÓ­\t»ÁrÒ\n
    \r
    """
  b"\x01ްtf¨qô¯§æÝu\yß"
  b"\x01ްwĽq¼ÚÙ6r¡Ó5"
  b"\x01ްwj¸rGŒÆþSeåz\x19"
  b"\x01ްv}ør\x13®§´™slN’"
  b"\x01ްwˆ#rª•¢\x04Ç1æ11"
  b"\x01ްw\x04\x10sѾï9Âý\x1F"
  b"\x01ްx‹p\x07‡‡]L“NÚ."
  b"\x01ްuØ…pó\x18 ¥Üy\x03ø"
  b"""
    \x01ްu¸\n
    s\r¤°\x16à\fÿ)ª
    """
  b"\x01ްuM#p\x07¦ î¨»´"
  b"\x01ޝ³Õtqõ‡Y¡‰Ë"\x03É"
  b"\x01ŽÍç|žrÜžÌuªéZ\"
  b"\x01ŽÞì\x07@r\x00 ¾0s\x11"H×"
]
0.82 ms
(14.88%)
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
  "Hmr5jJQ"
]
0.70 ms
(12.75%)
1
SELECT `path` FROM `movie_clip_media` WHERE `clip_id` = ?
Parameters:
[
  b"\x01ްx\r\x13p1£\tåB\x7FòJw"
]
0.68 ms
(12.37%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id`, `related_id`, `relevance`)
            VALUES (UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb078-6e0d-7096-8ff5-64fbcd5953b4'), 27.324550628662),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb076-2e87-7047-9adb-51fa80b1295c'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb076-cd40-70b4-a6a3-4016ea78c334'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb075-a008-736c-9177-78a1dc2bc933'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb075-6eb2-72b1-9bc7-45a37e37cbaa'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb075-f43d-72d3-ad09-bbc172d20a0d'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb074-66a8-71f4-afa7-e6dd755c79df'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb077-c4bd-7181-bcda-d93672a1d335'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb077-6ab8-7247-8cc6-fe5365e57a19'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb076-7df8-7213-aea7-b499736c4e92'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb077-8823-72aa-95a2-04c731e63131'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb077-0410-73d1-beef-39c2fd1f6af6'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb078-8b81-7007-8787-5d4c934eda2e'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb075-b80a-730d-a4b0-16e00cff29aa'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eb075-4d23-709d-9007-a6a0eea8bbb4'), 15.610429763794),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018eafb3-d574-71f5-8759-a189cb2203c9'), 10.539752960205),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018ecde7-7c9e-72dc-9ecc-75aae95a5c81'), 10.539752960205),(UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), UUID_TO_BIN('018edeec-0740-7200-a0be-3073112248d7'), 4.6972641944885)
Parameters:
[]
0.54 ms
(9.79%)
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ްx\r\x13p1£\tåB\x7FòJw"
  10
  24
  0
]
0.26 ms
(4.76%)
1
SELECT film_id,
           original_title,
           title,
           poster_path,
           release_year
    FROM `film`
    WHERE `film_id` = ?
Parameters:
[
  b"\x01\x05\r8·pÑ—Ë/ÙûÜ>Ê"
]
0.25 ms
(4.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
0.24 ms
(4.44%)
1
SELECT `clip_id`, `search_field`
                FROM `movie_clip`
                WHERE `clip_id` = ?
Parameters:
[
  b"\x01ްx\r\x13p1£\tåB\x7FòJw"
]

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.