18.84 ms (37.38%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ec381-4eaa-70de-a635-fa5bbe9a7441' ), 19.930393218994 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ec381-aad5-71ad-8d25-276e4eb52e05' ), 19.930393218994 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ec380-5d66-72a9-a401-d3462044f5b4' ), 19.930393218994 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ec37f-7154-7033-8d25-1c5f4a14e28f' ), 19.930393218994 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ec380-c6d0-7239-be85-bd58f8d61a99' ), 19.930393218994 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb074-3616-72dd-976f-be9e017164bf' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-d1bf-73b0-ab2b-e8926e3ac3aa' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-f8ab-7192-baa7-ba432901cbe2' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-c2cf-736b-a045-1fd4f48fbc21' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb074-1786-7386-9d3d-40430dea9fba' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-9e0e-7149-9ada-9786a2d356b4' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-40aa-7320-beaf-335e16ad1072' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-79ed-736d-8f1b-dfb4f29fe430' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb487-b2c4-732a-8154-e23b75b20eed' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb488-1375-71e0-a2b2-a223db590751' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3e-78e9-72d4-89d0-fbc1740c2756' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3c-5b19-705d-9458-a56094574a6e' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3d-4ed0-71ed-b2e9-0ccad25bcfbb' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3d-f281-735f-b960-cb9e77faa0be' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3c-d616-70e5-840b-9480cf4ba656' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3c-7a6a-71c8-9df6-81022df90a81' ), 6.6434640884399 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018ec381-4eaa-70de-a635-fa5bbe9a7441'
),
19.930393218994
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018ec381-aad5-71ad-8d25-276e4eb52e05'
),
19.930393218994
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018ec380-5d66-72a9-a401-d3462044f5b4'
),
19.930393218994
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018ec37f-7154-7033-8d25-1c5f4a14e28f'
),
19.930393218994
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018ec380-c6d0-7239-be85-bd58f8d61a99'
),
19.930393218994
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018eb074-3616-72dd-976f-be9e017164bf'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018eb073-d1bf-73b0-ab2b-e8926e3ac3aa'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018eb073-f8ab-7192-baa7-ba432901cbe2'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018eb073-c2cf-736b-a045-1fd4f48fbc21'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018eb074-1786-7386-9d3d-40430dea9fba'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018eb073-9e0e-7149-9ada-9786a2d356b4'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018eb073-40aa-7320-beaf-335e16ad1072'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018eb073-79ed-736d-8f1b-dfb4f29fe430'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018eb487-b2c4-732a-8154-e23b75b20eed'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018eb488-1375-71e0-a2b2-a223db590751'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018ece3e-78e9-72d4-89d0-fbc1740c2756'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018ece3c-5b19-705d-9458-a56094574a6e'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018ece3d-4ed0-71ed-b2e9-0ccad25bcfbb'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018ece3d-f281-735f-b960-cb9e77faa0be'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018ece3c-d616-70e5-840b-9480cf4ba656'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ec380-0058-7258-bd9f-894546ac1210'
),
UUID_TO_BIN (
'018ece3c-7a6a-71c8-9df6-81022df90a81'
),
6.6434640884399
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ec381-4eaa-70de-a635-fa5bbe9a7441' ), 19.930393218994 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ec381-aad5-71ad-8d25-276e4eb52e05' ), 19.930393218994 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ec380-5d66-72a9-a401-d3462044f5b4' ), 19.930393218994 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ec37f-7154-7033-8d25-1c5f4a14e28f' ), 19.930393218994 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ec380-c6d0-7239-be85-bd58f8d61a99' ), 19.930393218994 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb074-3616-72dd-976f-be9e017164bf' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-d1bf-73b0-ab2b-e8926e3ac3aa' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-f8ab-7192-baa7-ba432901cbe2' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-c2cf-736b-a045-1fd4f48fbc21' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb074-1786-7386-9d3d-40430dea9fba' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-9e0e-7149-9ada-9786a2d356b4' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-40aa-7320-beaf-335e16ad1072' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb073-79ed-736d-8f1b-dfb4f29fe430' ), 13.28692817688 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb487-b2c4-732a-8154-e23b75b20eed' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018eb488-1375-71e0-a2b2-a223db590751' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3e-78e9-72d4-89d0-fbc1740c2756' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3c-5b19-705d-9458-a56094574a6e' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3d-4ed0-71ed-b2e9-0ccad25bcfbb' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3d-f281-735f-b960-cb9e77faa0be' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3c-d616-70e5-840b-9480cf4ba656' ), 6.6434640884399 ), (UUID_TO_BIN ('018ec380-0058-7258-bd9f-894546ac1210' ), UUID_TO_BIN ('018ece3c-7a6a-71c8-9df6-81022df90a81' ), 6.6434640884399 )
;
Copy
0.92 ms (1.82%)
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 ÃNªpÞ¦5ú[¾štA "
b"\x01 êÕqŽ%'nNµ.\x05 "
b"\x01 ŽÃ€]fr©¤\x01 ÓF Dõ´ "
b"\x01 Ã\x7F qTp3Ž%\x1C _J\x14 â "
b"\x01 ŽÃ€ÆÐr9¾…½XøÖ\x1A ™ "
b"\x01 ްt6\x16 rÝ—o¾ž\x01 qd¿ "
b"\x01 ްsÑ¿s°«+è’n:ê "
b"\x01 ްsø«q’º§ºC)\x01 Ëâ "
b"\x01 °sÂÏsk E\x1F Ôô¼! "
b"\x01 °t\x17 †s†=@C\r êº "
b"\x01 ްsž\x0E qIšÚ—†¢ÓV´ "
b"\x01 ްs@ªs ¾¯3^\x16 \x10 r "
b"\x01 °syísm\e ß´òä0 "
b"\x01 ´‡²Äs*Tâ;u²\x0E í "
b"\x01 Ž´ˆ\x13 uqࢲ¢#ÛY\x07 Q "
b"\x01 ŽÎ>xérÔ‰ÐûÁt\f 'V "
b"\x01 ŽÎ<[\x19 p]”X¥`”WJn "
b"\x01 ŽÎ=NÐqí²é\f ÊÒ[Ï» "
b"\x01 Î=òs_¹`Ëžwú ¾ "
b"\x01 ŽÎ<Ö\x16 på„\v ”€ÏK¦V "
b"""
\x01 Î<zjqÈö\x02 -ù\n
"""
]
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 (0x018EC3814EAA70DEA635FA5BBE9A7441 , 0x018EC381AAD571AD8D25276E4EB52E05 , 0x018EC3805D6672A9A401D3462044F5B4 , 0x018EC37F715470338D251C5F4A14E28F , 0x018EC380C6D07239BE85BD58F8D61A99 , 0x018EB074361672DD976FBE9E017164BF , 0x018EB073D1BF73B0AB2BE8926E3AC3AA , 0x018EB073F8AB7192BAA7BA432901CBE2 , 0x018EB073C2CF736BA0451FD4F48FBC21 , 0x018EB074178673869D3D40430DEA9FBA , 0x018EB0739E0E71499ADA9786A2D356B4 , 0x018EB07340AA7320BEAF335E16AD1072 , 0x018EB07379ED736D8F1BDFB4F29FE430 , 0x018EB487B2C4732A8154E23B75B20EED , 0x018EB488137571E0A2B2A223DB590751 , 0x018ECE3E78E972D489D0FBC1740C2756 , 0x018ECE3C5B19705D9458A56094574A6E , 0x018ECE3D4ED071EDB2E90CCAD25BCFBB , 0x018ECE3DF281735FB960CB9E77FAA0BE , 0x018ECE3CD61670E5840B9480CF4BA656 , 0x018ECE3C7A6A71C89DF681022DF90A81 );
Copy
0.66 ms (1.30%)
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
"8e2kmSB "
]
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 = '8e2kmSB' LIMIT 1 ;
Copy