0.89 ms (19.71%)
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 Ž´[…“r£‰²¿\x1D È^ˆ® "
b"\x01 ޱ\t ý\e s³’!Åä\x11 Íßä "
b"\x01 Ãy\x07 p\x7F †á*A†^\x1F ‡ "
b"\x01 ŽÃ|u-q{•.\f 0fË~Á "
b"\x01 ŽÃxm\x12 põ‘,Ýé%¿Ø™ "
b"\x01 ŽÃ{”–qç¥ò\x12 *«Ì` "
b"\x01 ŽÃy~HpØ“¸»¨ˆ~\x07 Û "
b"\x01 ŽÃxÅœqƒšYä…Ò¿Dù "
b"\x01 Ã}\x0E Fs2ŽZ\x17\x14 º†^B "
b"\x01 ŽÃwøÚpb¾7˜?˜T2§ "
b"\x01 ŽÃ|\x1F\e pOµo\VÕçÙƒ "
b"\x01 ŽÃ{ÛZpC¨Ô‡òœ•[¿ "
b"\x01 ŽÃ}‚Ürë•J5'\ì²â "
b"\x01 ŽÃyK\x02 sŽŠ¯œ\x1D ¡vÞn "
b"\x01 ޝ¢\x1D\x05 rÿ¶Œ\x04 óÇ;A\e "
b"\x01 °â*Öq^°ƒŠÑ“\x18 c "
b"\x01 ްÑg5p-’É^\x1D àtî¢ "
b"\x01 ޵)Œ¨pªc"]®B¢_ "
b"\x01 ×4ñ\x1D p§\x03 å\x18 {ð\x1E ˜ "
b"\x01 Ž×OvAp\x0E ¥4É]«\x1D ÷\t "
b"\x01 Ž×P³Epc‡œ¡\x08 f\x13 9é "
]
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 (0x018EB45B859372A389B2BF1DC85E88AE , 0x018EB109FD1B73B39221C5E411CDDFE4 , 0x018EC379078F707F86E12A41865E1F87 , 0x018EC37C752D717B952E0C3066CB7EC1 , 0x018EC3786D1270F5912CDDE925BFD899 , 0x018EC37B949671E7A5F212202AABCC60 , 0x018EC3797E4870D893B8BBA8887E07DB , 0x018EC378C59C71839A59E485D2BF44F9 , 0x018EC37D0E4673328D5A1714BA865E42 , 0x018EC377F8DA7062BE37983F985432A7 , 0x018EC37C1F1B704FB56F5C56D5E7D983 , 0x018EC37BDB5A7043A8D487F29C955BBF , 0x018EC37D82DC72EB954A35275CECB2E2 , 0x018EC3794B02738E8AAF9C1DA176DE6E , 0x018EAFA21D0572FFB68C04F3C73B411B , 0x018EB0E22AD6715EB0838AD193901863 , 0x018EB0D16735702D92C95E1DE074EEA2 , 0x018EB5298CA870ADAA63225DAE42A25F , 0x018ED734F11D7081A703E5187BF01E98 , 0x018ED74F7641700EA534C95DAB1DF709 , 0x018ED750B3457063879CA108661339E9 );
Copy
0.68 ms (15.20%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eb45b-8593-72a3-89b2-bf1dc85e88ae' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eb109-fd1b-73b3-9221-c5e411cddfe4' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec379-078f-707f-86e1-2a41865e1f87' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37c-752d-717b-952e-0c3066cb7ec1' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37b-9496-71e7-a5f2-12202aabcc60' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec379-7e48-70d8-93b8-bba8887e07db' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec378-c59c-7183-9a59-e485d2bf44f9' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37d-0e46-7332-8d5a-1714ba865e42' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec377-f8da-7062-be37-983f985432a7' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37c-1f1b-704f-b56f-5c56d5e7d983' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37b-db5a-7043-a8d4-87f29c955bbf' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37d-82dc-72eb-954a-35275cecb2e2' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec379-4b02-738e-8aaf-9c1da176de6e' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eb0e2-2ad6-715e-b083-8ad193901863' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eb0d1-6735-702d-92c9-5e1de074eea2' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eb529-8ca8-70ad-aa63-225dae42a25f' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ed734-f11d-7081-a703-e5187bf01e98' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ed74f-7641-700e-a534-c95dab1df709' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ed750-b345-7063-879c-a108661339e9' ), 7.95538854599 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018eb45b-8593-72a3-89b2-bf1dc85e88ae'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018eb109-fd1b-73b3-9221-c5e411cddfe4'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec379-078f-707f-86e1-2a41865e1f87'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec37c-752d-717b-952e-0c3066cb7ec1'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec37b-9496-71e7-a5f2-12202aabcc60'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec379-7e48-70d8-93b8-bba8887e07db'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec378-c59c-7183-9a59-e485d2bf44f9'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec37d-0e46-7332-8d5a-1714ba865e42'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec377-f8da-7062-be37-983f985432a7'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec37c-1f1b-704f-b56f-5c56d5e7d983'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec37b-db5a-7043-a8d4-87f29c955bbf'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec37d-82dc-72eb-954a-35275cecb2e2'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ec379-4b02-738e-8aaf-9c1da176de6e'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
7.95538854599
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018eb0e2-2ad6-715e-b083-8ad193901863'
),
7.95538854599
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018eb0d1-6735-702d-92c9-5e1de074eea2'
),
7.95538854599
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018eb529-8ca8-70ad-aa63-225dae42a25f'
),
7.95538854599
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ed734-f11d-7081-a703-e5187bf01e98'
),
7.95538854599
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ed74f-7641-700e-a534-c95dab1df709'
),
7.95538854599
),
(
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
UUID_TO_BIN (
'018ed750-b345-7063-879c-a108661339e9'
),
7.95538854599
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eb45b-8593-72a3-89b2-bf1dc85e88ae' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eb109-fd1b-73b3-9221-c5e411cddfe4' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec379-078f-707f-86e1-2a41865e1f87' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37c-752d-717b-952e-0c3066cb7ec1' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37b-9496-71e7-a5f2-12202aabcc60' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec379-7e48-70d8-93b8-bba8887e07db' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec378-c59c-7183-9a59-e485d2bf44f9' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37d-0e46-7332-8d5a-1714ba865e42' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec377-f8da-7062-be37-983f985432a7' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37c-1f1b-704f-b56f-5c56d5e7d983' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37b-db5a-7043-a8d4-87f29c955bbf' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec37d-82dc-72eb-954a-35275cecb2e2' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ec379-4b02-738e-8aaf-9c1da176de6e' ), 25.959608078003 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eb0e2-2ad6-715e-b083-8ad193901863' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eb0d1-6735-702d-92c9-5e1de074eea2' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018eb529-8ca8-70ad-aa63-225dae42a25f' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ed734-f11d-7081-a703-e5187bf01e98' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ed74f-7641-700e-a534-c95dab1df709' ), 7.95538854599 ), (UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), UUID_TO_BIN ('018ed750-b345-7063-879c-a108661339e9' ), 7.95538854599 )
;
Copy
0.44 ms (9.76%)
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
"OWOTyou "
]
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 = 'OWOTyou' LIMIT 1 ;
Copy