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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
0.89 ms
(19.00%)
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:
[
  "Крид 2 Creed II ПОДГОТОВКА К БОЮ "
  "Крид 2 Creed II ПОДГОТОВКА К БОЮ "
  b"\x01ŽÉ·P’s ¡I(Dk›c\x13"
  10
  24
]
0.86 ms
(18.39%)
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ްp„špˆ™d‡\tãÍyå"
  b"\x01޽—øûrð‹ƒ„ÁhŒAÏ"
  b"\x01Ž´}\fGr[«`øð=0›@"
  b"\x01ŽÉº–«pj¶'®’9ëÄI"
  b"\x01ŽÉ·xArÑ‹\x12\x1Flå§\x14Ã"
  b"\x01ŽÉ¶¦\x03r@µµ½êg\t"
  b"\x01ŽÉ¹P‡sÄ…\x19“Ý\vˆ=q"
  b"\x01ŽÉ»Œ\x12p\x16€­#°ã\x08½º"
  b"\x01ŽÉ¹Ö\x15q®ŽT\x07…'Ÿbé"
  b"\x01ޝ÷þ—q?¾‹…¥î\x13\x16"
  b"\x01ޝúÅ_pü¨&×|\x02e‘Ü"
  b"\x01ްÝΔp@¥p•Ö ©„ô"
  b"\x01ޝÞ\x13\x03r”‰04î÷\x17\x10"
  b"\x01ޝ¾B`s5Š"Ï0\x14é^\x06"
  b"\x01ް™¥\x1Cr\x16°âº˜®8¾"
  b"\x01ްÄɃp'­x\x15\x087x¤Ñ"
  b"\x01Ž·Ü©\x12sè¹ZOÖxå‚k"
  b"\x01ŽÃƒSˆs\x19…ËâÓ\x06úñx"
  b"\x01ް”/*ré¤vŒ/\x16>$|"
  b"\x01ް“Èvrì¶k¿t\x08üD˜"
]
0.64 ms
(13.68%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id`, `related_id`, `relevance`)
            VALUES (UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eb070-849a-7088-9964-8709e3cd79e5'), 16.345235824585),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018ebd97-f8fb-72f0-8b83-84c1688c41cf'), 16.345235824585),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eb47d-0c47-725b-ab60-f8f03d309b40'), 15.37349319458),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018ec9ba-96ab-706a-b627-ae9239ebc449'), 15.37349319458),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018ec9b7-7841-72d1-8b12-1f6ce5a714c3'), 15.37349319458),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018ec9b6-a603-7240-b5b5-bd8f81ea6709'), 15.37349319458),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018ec9b9-5087-73c4-8519-93dd0b883d71'), 15.37349319458),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018ec9bb-8c12-7016-80ad-23b0e308bdba'), 15.37349319458),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018ec9b9-d615-71ae-8e54-0785279f62e9'), 15.37349319458),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eaff7-fe97-713f-be8b-85a59dee1316'), 8.6757850646973),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eaffa-c55f-70fc-a826-d77c026591dc'), 8.6757850646973),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eb0dd-ce94-7040-a570-95d620a984f4'), 8.6757850646973),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eafde-1303-7294-8930-34eef7179d10'), 7.6694507598877),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eafbe-4260-7335-8a22-cf3014e95e06'), 7.6694507598877),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eb099-a51c-7216-b0e2-ba8198ae38be'), 7.6694507598877),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eb0c4-c983-7027-ad78-15083778a4d1'), 7.6694507598877),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eb7dc-a912-73e8-b95a-4fd678e5826b'), 7.6694507598877),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018ec383-5388-7319-85cb-e2d306faf178'), 7.6694507598877),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eb094-2f2a-72e9-a476-8c2f163e247c'), 7.4181051254272),(UUID_TO_BIN('018ec9b7-5092-7320-a149-28446b9b6313'), UUID_TO_BIN('018eb093-c876-72ec-b66b-bf7408fc4498'), 7.4181051254272)
Parameters:
[]
0.59 ms
(12.69%)
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ŽÉ·P’s ¡I(Dk›c\x13"
  10
  24
  0
]
0.57 ms
(12.18%)
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
  "ptPPm0R"
]
0.30 ms
(6.33%)
1
SELECT `clip_id`, `search_field`
                FROM `movie_clip`
                WHERE `clip_id` = ?
Parameters:
[
  b"\x01ŽÉ·P’s ¡I(Dk›c\x13"
]
0.29 ms
(6.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
0.27 ms
(5.80%)
1
SELECT `path` FROM `movie_clip_media` WHERE `clip_id` = ?
Parameters:
[
  b"\x01ŽÉ·P’s ¡I(Dk›c\x13"
]
0.27 ms
(5.76%)
1
SELECT film_id,
           original_title,
           title,
           poster_path,
           release_year
    FROM `film`
    WHERE `film_id` = ?
Parameters:
[
  b"\x01\x05\x0E4²r¾‡5ÖWap\x17\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.