1.13 ms (19.37%)
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 ޽§\x05 <s¹¯Ñ<`ã\x1C »¡ "
b"\x01 ޽§Ñçsï¸\x07 ü2ί.š "
b"\x01 ޽¨kèsm¯Om p\x7F ¼Ÿ "
b"\x01 ޽¨+]pð«ò\x04 â+v{e "
b"\x01 ޽§S¹rØg\x1F †y•ߥ "
b"\x01 ޽¨Èds_Ž´\x07\x00\x08 [áµ "
b"\x01 Žã‚`ãr©š\f 3±2$žÐ "
b"\x01 Žã‚\r \x02 s°¯úhÚßb.ƒ "
b"\x01 ޝù/¥qE£Ç•~Ä\x03\x18 3 "
b"\x01 ް8Ö\e q{„oêÍÞ‰QÆ "
b"\x01 ŽÉP\x0F rqü‹dg=\x1C ÀÅR "
b"\x01 ¯åÁq »¿Û¤½Uë¿ "
b"\x01 ¯M›p\t ‚wé™CŒ\x0F Î "
b"\x01 ޝ‡\x07\x11 pŸ–|Íó÷\x14 2Ê "
b"\x01 °’d]q\x13 š2\x12 .U6ù "
b"\x01 ް¯h™q-ŒñŸX\x16 „Ëá "
b"\x01 ް²v|qo¸n`¸äîŽ "
b"\x01 Ž´~åTrJ•H\x06 <N2Ô» "
b"\x01 ްÉ\x7F ÎrÇ»¨ÇH\f 1¾× "
b"\x01 ޽œ©àrfŸÌ¡AuØF‰ "
b"\x01 ÉÎèïq^±W{ë&§_ "
b"\x01 ŽÞƒ‘\x00 qLŽØ‡HãƒD¬ "
]
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 (0x018EBDA7053C73B9AFD13C60E31CBBA1 , 0x018EBDA7D1E773EFB807FC32CEAF2E9A , 0x018EBDA86BE8736DAF4F6DA0707FBC9F , 0x018EBDA82B5D70F0ABF204E22B767B65 , 0x018EBDA753B972D8AD671F867995DFA5 , 0x018EBDA8C864735F8EB40700085BE1B5 , 0x018EE38260E372A99A0C33B132249ED0 , 0x018EE3820D0273B0AFFA68DADF622E83 , 0x018EAFF92FA57145A3C7957EC4031833 , 0x018EB038D61B717B846FEACDDE8951C6 , 0x018EC9500F7271FC8B64673D1CC0C552 , 0x018EAF9DE5C171A0BBBFDBA4BD55EBBF , 0x018EAF9D4D9B70098277E999438C0FCE , 0x018EAF870711709F967CCDF3F71432CA , 0x018EB092645D71139A32122E558136F9 , 0x018EB0AF6899712D8CF19F581684CBE1 , 0x018EB0B2767C716FB86E60C2B8E4EE8E , 0x018EB47EE554724A9548063C4E32D4BB , 0x018EB0C97FCE72C7BBA8C7480C31BED7 , 0x018EBD9CA9E072669FCCA14175D84689 , 0x018EC9CEE8EF715EB1577BEB26A79D5F , 0x018EDE839100714C8ED88748E38344AC );
Copy
0.84 ms (14.43%)
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
"4T7Kivw "
]
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 = '4T7Kivw' LIMIT 1 ;
Copy
0.73 ms (12.48%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda7-053c-73b9-afd1-3c60e31cbba1' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda7-d1e7-73ef-b807-fc32ceaf2e9a' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda8-6be8-736d-af4f-6da0707fbc9f' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda8-2b5d-70f0-abf2-04e22b767b65' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda7-53b9-72d8-ad67-1f867995dfa5' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda8-c864-735f-8eb4-0700085be1b5' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ee382-60e3-72a9-9a0c-33b132249ed0' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ee382-0d02-73b0-affa-68dadf622e83' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eaff9-2fa5-7145-a3c7-957ec4031833' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb038-d61b-717b-846f-eacdde8951c6' ), 7.1943426132202 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ec950-0f72-71fc-8b64-673d1cc0c552' ), 7.1943426132202 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eaf9d-e5c1-71a0-bbbf-dba4bd55ebbf' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eaf9d-4d9b-7009-8277-e999438c0fce' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eaf87-0711-709f-967c-cdf3f71432ca' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb092-645d-7113-9a32-122e558136f9' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb0af-6899-712d-8cf1-9f581684cbe1' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb0b2-767c-716f-b86e-60c2b8e4ee8e' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb47e-e554-724a-9548-063c4e32d4bb' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb0c9-7fce-72c7-bba8-c7480c31bed7' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebd9c-a9e0-7266-9fcc-a14175d84689' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ec9ce-e8ef-715e-b157-7beb26a79d5f' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ede83-9100-714c-8ed8-8748e38344ac' ), 6.9930553436279 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ebda7-053c-73b9-afd1-3c60e31cbba1'
),
37.620800018311
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ebda7-d1e7-73ef-b807-fc32ceaf2e9a'
),
37.620800018311
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ebda8-6be8-736d-af4f-6da0707fbc9f'
),
37.620800018311
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ebda8-2b5d-70f0-abf2-04e22b767b65'
),
37.620800018311
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ebda7-53b9-72d8-ad67-1f867995dfa5'
),
37.620800018311
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ebda8-c864-735f-8eb4-0700085be1b5'
),
37.620800018311
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ee382-60e3-72a9-9a0c-33b132249ed0'
),
37.620800018311
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ee382-0d02-73b0-affa-68dadf622e83'
),
37.620800018311
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018eaff9-2fa5-7145-a3c7-957ec4031833'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018eb038-d61b-717b-846f-eacdde8951c6'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ec950-0f72-71fc-8b64-673d1cc0c552'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018eaf9d-e5c1-71a0-bbbf-dba4bd55ebbf'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018eaf9d-4d9b-7009-8277-e999438c0fce'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018eaf87-0711-709f-967c-cdf3f71432ca'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018eb092-645d-7113-9a32-122e558136f9'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018eb0af-6899-712d-8cf1-9f581684cbe1'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018eb0b2-767c-716f-b86e-60c2b8e4ee8e'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018eb47e-e554-724a-9548-063c4e32d4bb'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018eb0c9-7fce-72c7-bba8-c7480c31bed7'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ebd9c-a9e0-7266-9fcc-a14175d84689'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ec9ce-e8ef-715e-b157-7beb26a79d5f'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebda7-9111-712f-8cff-99c090c53d0f'
),
UUID_TO_BIN (
'018ede83-9100-714c-8ed8-8748e38344ac'
),
6.9930553436279
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda7-053c-73b9-afd1-3c60e31cbba1' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda7-d1e7-73ef-b807-fc32ceaf2e9a' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda8-6be8-736d-af4f-6da0707fbc9f' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda8-2b5d-70f0-abf2-04e22b767b65' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda7-53b9-72d8-ad67-1f867995dfa5' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebda8-c864-735f-8eb4-0700085be1b5' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ee382-60e3-72a9-9a0c-33b132249ed0' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ee382-0d02-73b0-affa-68dadf622e83' ), 37.620800018311 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eaff9-2fa5-7145-a3c7-957ec4031833' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb038-d61b-717b-846f-eacdde8951c6' ), 7.1943426132202 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ec950-0f72-71fc-8b64-673d1cc0c552' ), 7.1943426132202 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eaf9d-e5c1-71a0-bbbf-dba4bd55ebbf' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eaf9d-4d9b-7009-8277-e999438c0fce' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eaf87-0711-709f-967c-cdf3f71432ca' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb092-645d-7113-9a32-122e558136f9' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb0af-6899-712d-8cf1-9f581684cbe1' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb0b2-767c-716f-b86e-60c2b8e4ee8e' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb47e-e554-724a-9548-063c4e32d4bb' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018eb0c9-7fce-72c7-bba8-c7480c31bed7' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ebd9c-a9e0-7266-9fcc-a14175d84689' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ec9ce-e8ef-715e-b157-7beb26a79d5f' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebda7-9111-712f-8cff-99c090c53d0f' ), UUID_TO_BIN ('018ede83-9100-714c-8ed8-8748e38344ac' ), 6.9930553436279 )
;
Copy