Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
0.78 ms
(16.93%)
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\x16º°ç:9:ž²"
  b"\x01޽˜Á¤s\x18¼³V\e9\x0EÜ\"
  b"\x01޽˜…Ór\fŽª—1€‘`9"
  b"\x01޽˜>Qq/›¢ó\x15Í&èê"
  b"""
    \x01޽™\x12\n
    s鮐Yᑊ\x12
    """
  b"\x01޽—øûrð‹ƒ„ÁhŒAÏ"
  b"\x01Žãxُq£“QˆF7Äún"
  b"\x01Žãzàlr \tž4e/.ë"
  b"\x01Žãz$LrÆ‚ãnöÈô;>"
  b"\x01ŽãyL“pä¢ÞC\x04J\x01"
  b"\x01ޝˆLqO­ï/â¿ú¶;"
  b"\x01ޝÝ{\x0FrZ¿”\x19LK\x05"
  b"\x01ޝßÄÇqˆ‹@ƒÂü%]\x16"
  b"\x01ޝ¹Ÿ\x11qzœ\x02šÁ\x1EÜ-Ã"
  b"""
    \x01ޝ¾ôír{­rh\n
    ©^K©
    """
  b"\x01ް¨Ô—q6™&æ°öäÆõ"
  b"\x01ްŸzpýµŠ<8^ l¢"
  b"\x01Žä#`«s\x1E˜‡ZߨaP"
  b"\x01Žä\x17=\x05s\f¯Š ?¬\x17ŠF"
]
0.77 ms
(16.71%)
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:
[
  "Хищник Predator Ловушка "
  "Хищник Predator Ловушка "
  b"\x01޽—ÀÛs\x0F0µ\x08w¸i—"
  10
  24
]
0.66 ms
(14.52%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id`, `related_id`, `relevance`)
            VALUES (UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ebd99-40ec-7016-bab0-e73a393a9eb2'), 14.38868522644),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ebd98-c1a4-7318-bcb3-561b390edc5c'), 14.38868522644),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ebd98-85d3-720c-8eaa-973180916039'), 14.38868522644),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ebd98-3e51-712f-9ba2-f315cd26e8ea'), 14.38868522644),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ebd99-120a-73e9-ae90-59e1918a1292'), 14.38868522644),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ebd97-f8fb-72f0-8b83-84c1688c41cf'), 14.38868522644),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ee378-d98f-71a3-9351-884637c4fa6e'), 14.38868522644),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ee37a-e06c-72a0-9d09-9e34652f2eeb'), 14.38868522644),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ee37a-244c-72c6-82e3-6ef6c8f43b3e'), 14.38868522644),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ee379-4c93-70e4-a2de-43044a0178db'), 14.38868522644),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018eaf88-814c-714f-adef-2fe2bffab63b'), 7.4181051254272),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018eafdd-7b0f-725a-bf94-194c4b0544ab'), 7.4181051254272),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018eafdf-c4c7-7188-8b40-83c2fc255d16'), 7.4181051254272),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018eafb9-9f11-717a-9c02-9ac11edc2dc3'), 7.4181051254272),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018eafbe-f4ed-727b-ad72-680aa95e4ba9'), 7.4181051254272),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018eb0a8-d497-7136-9926-e6b0f6e4c6f5'), 7.4181051254272),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018eb09d-9f7a-70fd-b58a-3c385e206ca2'), 7.4181051254272),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ee423-60ab-731e-9887-5adfc3986150'), 7.4181051254272),(UUID_TO_BIN('018ebd97-c0db-730f-9030-b50877b86997'), UUID_TO_BIN('018ee417-3d05-730c-af8a-203fac178a46'), 7.4181051254272)
Parameters:
[]
0.59 ms
(12.97%)
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
  "AWbE3Ea"
]
0.54 ms
(11.70%)
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޽—ÀÛs\x0F0µ\x08w¸i—"
  10
  24
  0
]
0.46 ms
(10.00%)
1
SELECT `path` FROM `movie_clip_media` WHERE `clip_id` = ?
Parameters:
[
  b"\x01޽—ÀÛs\x0F0µ\x08w¸i—"
]
0.29 ms
(6.29%)
1
SELECT film_id,
           original_title,
           title,
           poster_path,
           release_year
    FROM `film`
    WHERE `film_id` = ?
Parameters:
[
  b"\x01\x05\x0FÿØpÙ™WPm—\x1D²d"
]
0.28 ms
(6.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
0.22 ms
(4.85%)
1
SELECT `clip_id`, `search_field`
                FROM `movie_clip`
                WHERE `clip_id` = ?
Parameters:
[
  b"\x01޽—ÀÛs\x0F0µ\x08w¸i—"
]

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.