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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.04 ms
(20.56%)
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:
[
  "Усатый нянь Moustached Nanny Прощание с Кешей "
  "Усатый нянь Moustached Nanny Прощание с Кешей "
  b"\x01Ž´¢-%q>ª«â×åJŠ‹"
  10
  24
]
0.93 ms
(18.38%)
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Ž´¢¶Ipÿ¤4ä\x1C\x06\x04Ž•"
  b"\x01Ž´£TXpM”ûÕøz»¼L"
  b"\x01Ž´£\x0F\x00qû ÈAî~pÌ["
  b"\x01Ž´¢içq¥½<˜¾B%s\x1D"
  b"\x01Ž×\x12AþpªOu1ßöø\x00"
  b"\x01Ž×\x10¼çr]¸\x06PZ(\vÐ"
  b"\x01Ž×\x11š~sΓǢ~nÁ""
  b"\x01Ž×\x10ä[så´iú \x10Y,\v"
  b"\x01ޝhDq\x14ŽÊÈA_ü°÷"
  b"\x01ޝš+§sÔ–Ó„»\x1C×\x05"
  b"\x01ޝ—ycp\x18©“UytËÆp"
  b"\x01ޝ½K„q~¯öí<\x14ªã\f"
  b"\x01ޝÍbNs\x18ž£Ë@•ñÕú"
  b"\x01ް\ûërFƒIš\x7FØÎe\x08"
  b"\x01ް‡ÙÎq¡«ø•&ìdõ¢"
  b"\x01ްåëSpЉ^–Û\x0F‚çJ"
  b"\x01ŽÎŠáäp\x11Ë‚\x15öÅ®á"
  b"\x01›‰ë\x17Hq˜*u·µÐ"
]
0.67 ms
(13.23%)
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
  "itZWiIo"
]
0.64 ms
(12.67%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id`, `related_id`, `relevance`)
            VALUES (UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eb4a2-b649-70ff-a434-e41c06048d95'), 30.677803039551),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eb4a3-5458-704d-94fb-d5f87abbbc4c'), 30.677803039551),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eb4a3-0f00-71fb-a0c8-41ee7e70cc5b'), 30.677803039551),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eb4a2-69e7-71a5-bd3c-98be4225731d'), 30.677803039551),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018ed712-41fe-70aa-904f-7531dff6f800'), 30.677803039551),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018ed710-bce7-725d-b806-505a81280bd0'), 30.677803039551),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018ed711-9a7e-73ce-93c7-a27e6e9dc122'), 30.677803039551),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018ed710-e45b-73e5-b469-faa010592c0b'), 30.677803039551),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eaf9d-6844-7114-8dca-c8415ffcb0f7'), 7.1943426132202),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eaf9a-2ba7-73d4-96d3-848fbb1cd705'), 7.1943426132202),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eaf97-7963-7018-a993-557974cbc670'), 7.1943426132202),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eafbd-4b84-717e-aff6-ed3c14aae30c'), 7.1943426132202),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eafcd-624e-7318-9ea3-cb4095f1d5fa'), 7.1943426132202),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eb05c-fbeb-7246-8349-9a7fd8ce6508'), 7.1943426132202),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eb087-d9ce-71a1-abf8-9526ec64f5a2'), 7.1943426132202),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018eb0e5-eb53-708a-895e-96db0f82e74a'), 7.1943426132202),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('018ece8a-e1e4-7011-9dcb-8215f6c5aee1'), 7.1943426132202),(UUID_TO_BIN('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'), UUID_TO_BIN('019b89eb-1748-71ef-8d9f-982a75b7b5d0'), 7.1943426132202)
Parameters:
[]
0.56 ms
(11.06%)
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Ž´¢-%q>ª«â×åJŠ‹"
  10
  24
  0
]
0.41 ms
(8.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
0.32 ms
(6.34%)
1
SELECT `path` FROM `movie_clip_media` WHERE `clip_id` = ?
Parameters:
[
  b"\x01Ž´¢-%q>ª«â×åJŠ‹"
]
0.27 ms
(5.28%)
1
SELECT `clip_id`, `search_field`
                FROM `movie_clip`
                WHERE `clip_id` = ?
Parameters:
[
  b"\x01Ž´¢-%q>ª«â×åJŠ‹"
]
0.22 ms
(4.34%)
1
SELECT film_id,
           original_title,
           title,
           poster_path,
           release_year
    FROM `film`
    WHERE `film_id` = ?
Parameters:
[
  b"\x01\x05\x0Eªs5¢éâ´‰\x18ÀÉ"
]

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.