GET https://dev.muviki.cc/movie/hyRM-r0

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.65 ms
(28.43%)
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ްuØ…pó\x18 ¥Üy\x03ø"
  10
  24
]
0.94 ms
(16.20%)
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ް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ްxn\rp–õdûÍYS´"
  b"\x01ްw\x04\x10sѾï9Âý\x1F"
  b"\x01ްx‹p\x07‡‡]L“NÚ."
  b"\x01ްx\r\x13p1£\tåB\x7FòJw"
  b"""
    \x01ްu¸\n
    s\r¤°\x16à\fÿ)ª
    """
  b"\x01ްuM#p\x07¦ î¨»´"
  b"\x01ޝ˜\tjp^«÷¯£æNTs"
  b"\x01ްÐ1\x01r/­®2Q&6¼s"
  b"\x01ŽÃ.{¸qu‰Fôô°,k²"
  b"\x01ŽÉTKíp\x11¼zª|1\x18"
  b"\x01ŽÞì\x07@r\x00 ¾0s\x11"H×"
]
0.74 ms
(12.75%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id`, `related_id`, `relevance`)
            VALUES (UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb076-2e87-7047-9adb-51fa80b1295c'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb076-cd40-70b4-a6a3-4016ea78c334'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb075-a008-736c-9177-78a1dc2bc933'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb075-6eb2-72b1-9bc7-45a37e37cbaa'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb075-f43d-72d3-ad09-bbc172d20a0d'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb074-66a8-71f4-afa7-e6dd755c79df'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb077-c4bd-7181-bcda-d93672a1d335'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb077-6ab8-7247-8cc6-fe5365e57a19'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb076-7df8-7213-aea7-b499736c4e92'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb077-8823-72aa-95a2-04c731e63131'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb078-6e0d-7096-8ff5-64fbcd5953b4'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb077-0410-73d1-beef-39c2fd1f6af6'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb078-8b81-7007-8787-5d4c934eda2e'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb078-0d13-7031-a309-e5427ff24a77'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb075-b80a-730d-a4b0-16e00cff29aa'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb075-4d23-709d-9007-a6a0eea8bbb4'), 15.610429763794),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eaf98-096a-705e-abf7-afa3e64e5473'), 11.714120864868),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018eb0d0-3101-722f-adae-32512636bc73'), 9.7441358566284),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018ec32e-7bb8-7175-8946-f4f4b02c6bb2'), 9.7441358566284),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018ec954-4bed-7011-bc7a-aa7c31182fc3'), 9.7441358566284),(UUID_TO_BIN('018eb075-d885-70f3-9018-a0a5dc7903f8'), UUID_TO_BIN('018edeec-0740-7200-a0be-3073112248d7'), 4.6972641944885)
Parameters:
[]
0.62 ms
(10.78%)
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
  "hyRM-r0"
]
0.54 ms
(9.33%)
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ްuØ…pó\x18 ¥Üy\x03ø"
  10
  24
  0
]
0.42 ms
(7.26%)
1
SELECT `path` FROM `movie_clip_media` WHERE `clip_id` = ?
Parameters:
[
  b"\x01ްuØ…pó\x18 ¥Üy\x03ø"
]
0.36 ms
(6.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
0.27 ms
(4.59%)
1
SELECT film_id,
           original_title,
           title,
           poster_path,
           release_year
    FROM `film`
    WHERE `film_id` = ?
Parameters:
[
  b"\x01\x05\r8·pÑ—Ë/ÙûÜ>Ê"
]
0.26 ms
(4.49%)
1
SELECT `clip_id`, `search_field`
                FROM `movie_clip`
                WHERE `clip_id` = ?
Parameters:
[
  b"\x01ްuØ…pó\x18 ¥Üy\x03ø"
]

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.