1.05 ms (23.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 ŽÞŒ\t ·rm³çÆ5ó)ZT "
b"\x01 ŽãÓA%pu™Hþ"Œ¦¬" "
b"\x01 ÞŽóOp°¸à¯\x0E n\x07\x1F e "
b"\x01 ŽÞŒ‚Up\x15 °ï\x17 —€Bâ "
b"\x01 ÞŽ¥4pÜ3on"':\x06 "
b"\x01 ãÒ'úrŒÖ\x15 _i=Ý\r "
b"\x01 ŽÞŒùJs¹¾Ë¤¨ê@ÒN "
b"\x01 ŽÞŽU„r\x7F ›\x1C 5‘—\x11 Õ "
b"\x01 °fŽÅrÜ–Ç¡ŒÝ%èj "
b"\x01 °ðkur\x06 f\x16 „?Rìß "
b"\x01 ޝ«Ê\x16 p뻕 ³H¨h‹ "
b"\x01 ޝ¶\x13 [pŸB&\x07 àF{‹ "
b"\x01 ޝæ!ðrŒ®€\x03 šæ¦\x02 ¶ "
b"\x01 ްªþWp\x03 ›V‚ÅŒmx÷ "
b"\x01 ްü]ês{²F¯’NÒ\5 "
b"\x01 ·¢úúpÓ‚Ñ6\x1C Ü "
b"\x01 µ6Wq»½‹ÑW\x13 jÆ? "
b"\x01 ŽÃÒUÁqI˜{^Ýílì; "
b"\x01 Žãî¸ûqÕ£–K\x03 UKûS "
]
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 (0x018EDE8C09B7726DB3E7C635F3295A54 , 0x018EE3D3412570759948FE228CA6AC22 , 0x018EDE8DF34F70B0B8E0AF0E6E071F65 , 0x018EDE8C82557015A0B0EF17978042E2 , 0x018EDE8DA53470DC90336F6E22273A06 , 0x018EE3D227FA728C9DD6155F693DDD0D , 0x018EDE8CF94A73B9BECBA4A8EA40D24E , 0x018EDE8E5584727F9B1C35AD919711D5 , 0x018EB0668DC572DC96C7A18CDD25E86A , 0x018EB0F06B7572069D6616843F52ECDF , 0x018EAFABCA1670EBBB95A0B348A8688B , 0x018EAFB6135B70C29F422607E0467B8B , 0x018EAFE621F0728CAE80039AE6A602B6 , 0x018EB0AAFE5770039B5682C58C6D78F7 , 0x018EB0FC5DEA737BB246AF924ED25C35 , 0x018EB7A2FAFA70D3819F82ADD1361CDC , 0x018EB536578F71BBBD8BD157136AC63F , 0x018EC3D255C17149987B5EDDED6CEC3B , 0x018EE3EEB8FB71D5A3964B03554BFB53 );
Copy
0.59 ms (13.25%)
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
"ylRQlBv "
]
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 = 'ylRQlBv' LIMIT 1 ;
Copy
0.55 ms (12.33%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8c-09b7-726d-b3e7-c635f3295a54' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ee3d3-4125-7075-9948-fe228ca6ac22' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8d-f34f-70b0-b8e0-af0e6e071f65' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8c-8255-7015-a0b0-ef17978042e2' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8d-a534-70dc-9033-6f6e22273a06' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ee3d2-27fa-728c-9dd6-155f693ddd0d' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8c-f94a-73b9-becb-a4a8ea40d24e' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8e-5584-727f-9b1c-35ad919711d5' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb066-8dc5-72dc-96c7-a18cdd25e86a' ), 10.539752960205 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb0f0-6b75-7206-9d66-16843f52ecdf' ), 10.539752960205 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eafab-ca16-70eb-bb95-a0b348a8688b' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eafb6-135b-70c2-9f42-2607e0467b8b' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eafe6-21f0-728c-ae80-039ae6a602b6' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb0aa-fe57-7003-9b56-82c58c6d78f7' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb0fc-5dea-737b-b246-af924ed25c35' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb7a2-fafa-70d3-819f-82add1361cdc' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb536-578f-71bb-bd8b-d157136ac63f' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ec3d2-55c1-7149-987b-5edded6cec3b' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ee3ee-b8fb-71d5-a396-4b03554bfb53' ), 7.4181051254272 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018ede8c-09b7-726d-b3e7-c635f3295a54'
),
15.338901519775
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018ee3d3-4125-7075-9948-fe228ca6ac22'
),
15.338901519775
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018ede8d-f34f-70b0-b8e0-af0e6e071f65'
),
15.338901519775
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018ede8c-8255-7015-a0b0-ef17978042e2'
),
15.338901519775
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018ede8d-a534-70dc-9033-6f6e22273a06'
),
15.338901519775
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018ee3d2-27fa-728c-9dd6-155f693ddd0d'
),
15.338901519775
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018ede8c-f94a-73b9-becb-a4a8ea40d24e'
),
15.338901519775
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018ede8e-5584-727f-9b1c-35ad919711d5'
),
15.338901519775
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018eb066-8dc5-72dc-96c7-a18cdd25e86a'
),
10.539752960205
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018eb0f0-6b75-7206-9d66-16843f52ecdf'
),
10.539752960205
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018eafab-ca16-70eb-bb95-a0b348a8688b'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018eafb6-135b-70c2-9f42-2607e0467b8b'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018eafe6-21f0-728c-ae80-039ae6a602b6'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018eb0aa-fe57-7003-9b56-82c58c6d78f7'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018eb0fc-5dea-737b-b246-af924ed25c35'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018eb7a2-fafa-70d3-819f-82add1361cdc'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018eb536-578f-71bb-bd8b-d157136ac63f'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018ec3d2-55c1-7149-987b-5edded6cec3b'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ee3d3-1483-710e-93c1-be671b5245ec'
),
UUID_TO_BIN (
'018ee3ee-b8fb-71d5-a396-4b03554bfb53'
),
7.4181051254272
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8c-09b7-726d-b3e7-c635f3295a54' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ee3d3-4125-7075-9948-fe228ca6ac22' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8d-f34f-70b0-b8e0-af0e6e071f65' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8c-8255-7015-a0b0-ef17978042e2' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8d-a534-70dc-9033-6f6e22273a06' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ee3d2-27fa-728c-9dd6-155f693ddd0d' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8c-f94a-73b9-becb-a4a8ea40d24e' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ede8e-5584-727f-9b1c-35ad919711d5' ), 15.338901519775 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb066-8dc5-72dc-96c7-a18cdd25e86a' ), 10.539752960205 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb0f0-6b75-7206-9d66-16843f52ecdf' ), 10.539752960205 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eafab-ca16-70eb-bb95-a0b348a8688b' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eafb6-135b-70c2-9f42-2607e0467b8b' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eafe6-21f0-728c-ae80-039ae6a602b6' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb0aa-fe57-7003-9b56-82c58c6d78f7' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb0fc-5dea-737b-b246-af924ed25c35' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb7a2-fafa-70d3-819f-82add1361cdc' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018eb536-578f-71bb-bd8b-d157136ac63f' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ec3d2-55c1-7149-987b-5edded6cec3b' ), 7.4181051254272 ), (UUID_TO_BIN ('018ee3d3-1483-710e-93c1-be671b5245ec' ), UUID_TO_BIN ('018ee3ee-b8fb-71d5-a396-4b03554bfb53' ), 7.4181051254272 )
;
Copy