0.81 ms (18.36%)
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 ްWJïqú¼Ç4Âúù•† "
b"\x01 ްW\x1A wrœ¨ÓŠõ±²‹I "
b"\x01 ްVù¶q¤¾~Ñ)Yþ»Š "
b"\x01 ްV´äs¡„ùYÙß(îÀ "
b"\x01 ްV‡üpœžÁ±÷\x02 Ñíþ "
b"\x01 °W\v ‚sýšR¹\x06 ÇÁ. "
b"\x01 °VÙ5p{\x7F ׇžÞ¦\x03 "
b"\x01 ްW*Wpç‘\x03 ZZHÃt\x04 "
b"\x01 ްVœ6sn”¿‹Í\x19 “±µ "
b"\x01 ްVèÖrá¤\x05 Ú]\x1E ]Â\x10 "
b"\x01 ްW<[r©§áôVzÃ>| "
b"\x01 É\x0E @úr$ªeÂ$[ŽÎ7 "
b"""
\x01 ŽÉ\n
ËÞp€ *ÃÃàý‚4
"""
b"\x01 ŽÉ\x10 Û¹p7ŽË\x16 ‚Ÿà æ "
b"\x01 ޝÒ?gps¦µèÒÿ•¿S "
b"\x01 ¯ø8½rìªMÂóŠ'\x7F "
b"\x01 ޝõ¿?s\x00 ™i\v Ϥ@ÑG "
b"\x01 ޵(m;q3™lÍýËy•K "
b"\x01 ŽÞ|\x07 ÊsD£\x06 ñ\f ÎìWû "
b"\x01 ¯÷vs \x10 Ù\x03 ÔVl "
b"\x01 ޝö\t `q²´\x10 tŸ\x18 ,\x0F â "
b"\x01 ŽÞ|y\x18 p\‡\t õJ\x03 èØÎ "
]
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 = 1 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 = 2 WHERE mc . clip_id IN (0x018EB0574AEF71FABCC734C2FAF99586 , 0x018EB0571A77729CA8D38AF5B1B28B49 , 0x018EB056F9B671A4BE7ED12959FEBB8A , 0x018EB056B4E473A184F959D9DF28EEC0 , 0x018EB05687FC709C9EC1B1F702D1EDFE , 0x018EB0570B8273FD9A5281B906C7C12E , 0x018EB056D935707B9D7FD7879EDEA603 , 0x018EB0572A5770E791035A5A48C37404 , 0x018EB0569C36736E94BF8BCD1993B1B5 , 0x018EB056E8D672E1A405DA5D1E5DC210 , 0x018EB0573C5B72A9A7E1F4567AC33E7C , 0x018EC90E40FA7224AA65C2245B8DCE37 , 0x018EC90ACBDE7080A02AC3C3E0FD8234 , 0x018EC910DBB970378ECB16829FE020E6 , 0x018EAFD23F677073A6B5E8D2FF95BF53 , 0x018EAFF838BD72ECAA4DC2F38A279D7F , 0x018EAFF5BF3F730099690BCFA440D147 , 0x018EB5286D3B7133996CCDFDCB79954B , 0x018EDE7C07CA7344A306F10CCEEC57FB , 0x018EAFF776817320A01081D903D4566C , 0x018EAFF6096071B2B410749F182C0FE2 , 0x018EDE7C7918705C8709F54A03E8D8CE );
Copy
0.62 ms (14.03%)
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
"GYzgiqs "
]
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 = 1 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 = 2 WHERE mc . public_key = 'GYzgiqs' LIMIT 1 ;
Copy
0.53 ms (12.09%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb057-4aef-71fa-bcc7-34c2faf99586' ), 32.661491394043 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb057-1a77-729c-a8d3-8af5b1b28b49' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-f9b6-71a4-be7e-d12959febb8a' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-b4e4-73a1-84f9-59d9df28eec0' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-87fc-709c-9ec1-b1f702d1edfe' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb057-0b82-73fd-9a52-81b906c7c12e' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-d935-707b-9d7f-d7879edea603' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb057-2a57-70e7-9103-5a5a48c37404' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-9c36-736e-94bf-8bcd1993b1b5' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-e8d6-72e1-a405-da5d1e5dc210' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb057-3c5b-72a9-a7e1-f4567ac33e7c' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018ec90e-40fa-7224-aa65-c2245b8dce37' ), 18.675378799438 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018ec90a-cbde-7080-a02a-c3c3e0fd8234' ), 12.582640647888 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018ec910-dbb9-7037-8ecb-16829fe020e6' ), 12.582640647888 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eafd2-3f67-7073-a6b5-e8d2ff95bf53' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eaff8-38bd-72ec-aa4d-c2f38a279d7f' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eaff5-bf3f-7300-9969-0bcfa440d147' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb528-6d3b-7133-996c-cdfdcb79954b' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018ede7c-07ca-7344-a306-f10cceec57fb' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eaff7-7681-7320-a010-81d903d4566c' ), 6.0927386283875 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eaff6-0960-71b2-b410-749f182c0fe2' ), 6.0927386283875 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018ede7c-7918-705c-8709-f54a03e8d8ce' ), 6.0927386283875 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb057-4aef-71fa-bcc7-34c2faf99586'
),
32.661491394043
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb057-1a77-729c-a8d3-8af5b1b28b49'
),
26.568752288818
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb056-f9b6-71a4-be7e-d12959febb8a'
),
26.568752288818
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb056-b4e4-73a1-84f9-59d9df28eec0'
),
26.568752288818
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb056-87fc-709c-9ec1-b1f702d1edfe'
),
26.568752288818
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb057-0b82-73fd-9a52-81b906c7c12e'
),
26.568752288818
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb056-d935-707b-9d7f-d7879edea603'
),
26.568752288818
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb057-2a57-70e7-9103-5a5a48c37404'
),
26.568752288818
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb056-9c36-736e-94bf-8bcd1993b1b5'
),
26.568752288818
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb056-e8d6-72e1-a405-da5d1e5dc210'
),
26.568752288818
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb057-3c5b-72a9-a7e1-f4567ac33e7c'
),
26.568752288818
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018ec90e-40fa-7224-aa65-c2245b8dce37'
),
18.675378799438
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018ec90a-cbde-7080-a02a-c3c3e0fd8234'
),
12.582640647888
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018ec910-dbb9-7037-8ecb-16829fe020e6'
),
12.582640647888
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eafd2-3f67-7073-a6b5-e8d2ff95bf53'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eaff8-38bd-72ec-aa4d-c2f38a279d7f'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eaff5-bf3f-7300-9969-0bcfa440d147'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eb528-6d3b-7133-996c-cdfdcb79954b'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018ede7c-07ca-7344-a306-f10cceec57fb'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eaff7-7681-7320-a010-81d903d4566c'
),
6.0927386283875
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018eaff6-0960-71b2-b410-749f182c0fe2'
),
6.0927386283875
),
(
UUID_TO_BIN (
'018eb056-c937-7148-88c5-f0243ed7614f'
),
UUID_TO_BIN (
'018ede7c-7918-705c-8709-f54a03e8d8ce'
),
6.0927386283875
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb057-4aef-71fa-bcc7-34c2faf99586' ), 32.661491394043 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb057-1a77-729c-a8d3-8af5b1b28b49' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-f9b6-71a4-be7e-d12959febb8a' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-b4e4-73a1-84f9-59d9df28eec0' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-87fc-709c-9ec1-b1f702d1edfe' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb057-0b82-73fd-9a52-81b906c7c12e' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-d935-707b-9d7f-d7879edea603' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb057-2a57-70e7-9103-5a5a48c37404' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-9c36-736e-94bf-8bcd1993b1b5' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb056-e8d6-72e1-a405-da5d1e5dc210' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb057-3c5b-72a9-a7e1-f4567ac33e7c' ), 26.568752288818 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018ec90e-40fa-7224-aa65-c2245b8dce37' ), 18.675378799438 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018ec90a-cbde-7080-a02a-c3c3e0fd8234' ), 12.582640647888 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018ec910-dbb9-7037-8ecb-16829fe020e6' ), 12.582640647888 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eafd2-3f67-7073-a6b5-e8d2ff95bf53' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eaff8-38bd-72ec-aa4d-c2f38a279d7f' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eaff5-bf3f-7300-9969-0bcfa440d147' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eb528-6d3b-7133-996c-cdfdcb79954b' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018ede7c-07ca-7344-a306-f10cceec57fb' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eaff7-7681-7320-a010-81d903d4566c' ), 6.0927386283875 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018eaff6-0960-71b2-b410-749f182c0fe2' ), 6.0927386283875 ), (UUID_TO_BIN ('018eb056-c937-7148-88c5-f0243ed7614f' ), UUID_TO_BIN ('018ede7c-7918-705c-8709-f54a03e8d8ce' ), 6.0927386283875 )
;
Copy