Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
8.75 ms
(66.20%)
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
  "OlpZ6n7"
]
1.47 ms
(11.11%)
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:
[
  "Спирит: Душа прерий Spirit: Stallion of the Cimarron Прыжок веры! "
  "Спирит: Душа прерий Spirit: Stallion of the Cimarron Прыжок веры! "
  b"\x01ŽÃv‰µq\x16¹£üb¡Ö\x15~"
  10
  24
]
0.88 ms
(6.64%)
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ŽÃw—¯p3“Ë\x19ïØ:\x14Ê"
  b"\x01ŽÃuGZq Ž¼Ð°ŸÜc\x01"
  b"\x01ŽÃw+Ar’¢`LèNs;‰"
  b"\x01޽Ö\x00ópû˜Qc(\x1EÔš’"
  b"""
    \x01ޝ„p”ru‹xo\n
    J™áp
    """
  b"\x01ް£‹ÁrpžF¶F>3¿m"
  b"\x01ް£\*r\x0F±²õqM[|\x13"
  b"\x01ޝ„`¿pã¯ç\x13\x10Ä#ˆd"
  b"\x01ޝ„”Nq ±Ik\x070Æ`\x1C"
  b"\x01ޝ„ÕpF¾âýMÊ\x1E\x10)"
  b"\x01Ž´…\fÑs–‘ä\x1Fƒ>ú·Õ"
  b"\x01ŽÎUà³r\x07».\x10ô\vv"
  b"\x01ޝ®Ã\x02pi‰b:×=Žfž"
  b"\x01ްORWr?¸üÔ±Uý1å"
  b"\x01ް}=‘r^…:9>\x03ï™\x14"
  b"\x01Ž·s²ûrQ¾¹º\x02!Æýt"
  b"\x01Ž´¥½\x1Ap¬Bþˈë¯\f"
  b"\x01Ž×ƒ\x03ÂsA¸Ð;\e\x0E\x7F’‘"
  b"\x01ŽÎ}M¯rU‡ùg0ÿ>"
  b"\x01Ž×*/ñq€ˆ\x07ú•2÷ÖÐ"
  b"\x01ŽÎˆ \x1Cqˆ\x18Ó8)9òU"
  b"\x01ŽÎÐ©rߟèöZ‘¿!5"
]
0.68 ms
(5.16%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id`, `related_id`, `relevance`)
            VALUES (UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018ec377-97af-7033-93cb-19efd83a14ca'), 65.882919311523),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018ec375-475a-7120-8ebc-d0b09fdc6301'), 56.138786315918),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018ec377-2b41-7292-a260-4ce84e733b89'), 56.138786315918),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018ebdd6-00f3-70fb-9851-63281ed49a92'), 16.737190246582),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eaf84-7094-7275-8b78-6f0a4a99e170'), 14.836210250854),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eb0a3-8bc1-7270-9e46-b6463e33bf6d'), 9.7441358566284),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eb0a3-5c2a-720f-b1b2-f5714d5b7c13'), 9.7441358566284),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eaf84-60bf-70e3-afe7-1310c4238864'), 7.4181051254272),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eaf84-944e-71a0-b149-6b0730c6601c'), 7.4181051254272),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eaf84-81d5-7046-bee2-fd4dca1e1029'), 7.4181051254272),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eb485-0cd1-7396-91e4-1f833efab7d5'), 7.4181051254272),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018ece55-e0b3-7207-bb2e-108ff40b8f76'), 7.4181051254272),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eafae-c302-7069-8962-3ad73d8e669e'), 6.9930553436279),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eb04f-5257-723f-b8fc-d4b155fd31e5'), 6.9930553436279),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eb07d-3d91-725e-853a-393e03ef9914'), 6.9930553436279),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eb773-b2fb-7251-beb9-ba0221c6fd74'), 6.9930553436279),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018eb4a5-bd1a-70ac-9042-fecb88ebaf0c'), 6.9930553436279),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018ed783-03c2-7341-b8d0-3b1b0e7f9291'), 6.9930553436279),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018ece7d-4daf-7255-87f9-678f30ff903e'), 6.9930553436279),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018ed72a-2ff1-7180-8807-fa9532f7d6d0'), 6.9930553436279),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018ece88-a01c-7188-9d18-d3382939f255'), 6.9930553436279),(UUID_TO_BIN('018ec376-89b5-7116-b9a3-fc62a1d6157e'), UUID_TO_BIN('018ece81-d0a9-72df-9fe8-f65a91bf2135'), 6.9930553436279)
Parameters:
[]
0.47 ms
(3.55%)
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ŽÃv‰µq\x16¹£üb¡Ö\x15~"
  10
  24
  0
]
0.34 ms
(2.55%)
1
SELECT `path` FROM `movie_clip_media` WHERE `clip_id` = ?
Parameters:
[
  b"\x01ŽÃv‰µq\x16¹£üb¡Ö\x15~"
]
0.23 ms
(1.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
0.22 ms
(1.67%)
1
SELECT film_id,
           original_title,
           title,
           poster_path,
           release_year
    FROM `film`
    WHERE `film_id` = ?
Parameters:
[
  b"\x01\x05\réòp…«¥\x11\e3Éï`"
]
0.19 ms
(1.41%)
1
SELECT `clip_id`, `search_field`
                FROM `movie_clip`
                WHERE `clip_id` = ?
Parameters:
[
  b"\x01ŽÃv‰µq\x16¹£üb¡Ö\x15~"
]

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.