1.13 ms (1.86%)
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 ŽÃ{”–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 ŽÃ{RÓq\f ¡Ó»\x7F BDLI "
b"\x01 ŽÃ|\x1F\e pOµo\VÕçÙƒ "
b"\x01 ŽÃ{ÛZpC¨Ô‡òœ•[¿ "
b"\x01 ŽÃ}‚Ürë•J5'\ì²â "
b"\x01 ŽÃyK\x02 sŽŠ¯œ\x1D ¡vÞn "
b"\x01 ްN>Špä°Í¦`Øå¥\x19 "
b"\x01 ްMïgs‹–GÆ>”Y\x17 ˜ "
b"\x01 ްMý]sj´Ï\x11 @%‡\x12 Ç "
b"\x01 ްN\x1E ~p\x14 …Ñÿ–TÌi‰ "
b"\x01 ްN\f\x19 qb¢PïyIdð "
b"\x01 °N.p>ª:z¯\x12\x1A šü "
]
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 , 0x018EC37B949671E7A5F212202AABCC60 , 0x018EC3797E4870D893B8BBA8887E07DB , 0x018EC378C59C71839A59E485D2BF44F9 , 0x018EC37D0E4673328D5A1714BA865E42 , 0x018EC377F8DA7062BE37983F985432A7 , 0x018EC37B52D3710CA1D3BB7F42444C49 , 0x018EC37C1F1B704FB56F5C56D5E7D983 , 0x018EC37BDB5A7043A8D487F29C955BBF , 0x018EC37D82DC72EB954A35275CECB2E2 , 0x018EC3794B02738E8AAF9C1DA176DE6E , 0x018EB04E3E8A70E4B0CDA660D8E5A519 , 0x018EB04DEF67738B9647C63E94591798 , 0x018EB04DFD5D736AB4CF1140258712C7 , 0x018EB04E1E7E701485D1FF9654CC6989 , 0x018EB04E0C197162A250ADEF794964F0 , 0x018EB04E2E90703EAA3A7AAF121A9AFC );
Copy
0.64 ms (1.06%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb45b-8593-72a3-89b2-bf1dc85e88ae' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb109-fd1b-73b3-9221-c5e411cddfe4' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec379-078f-707f-86e1-2a41865e1f87' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37c-752d-717b-952e-0c3066cb7ec1' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37b-9496-71e7-a5f2-12202aabcc60' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec379-7e48-70d8-93b8-bba8887e07db' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec378-c59c-7183-9a59-e485d2bf44f9' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37d-0e46-7332-8d5a-1714ba865e42' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec377-f8da-7062-be37-983f985432a7' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37c-1f1b-704f-b56f-5c56d5e7d983' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37b-db5a-7043-a8d4-87f29c955bbf' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37d-82dc-72eb-954a-35275cecb2e2' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec379-4b02-738e-8aaf-9c1da176de6e' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04e-3e8a-70e4-b0cd-a660d8e5a519' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04d-ef67-738b-9647-c63e94591798' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04d-fd5d-736a-b4cf-1140258712c7' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04e-1e7e-7014-85d1-ff9654cc6989' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04e-0c19-7162-a250-adef794964f0' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04e-2e90-703e-aa3a-7aaf121a9afc' ), 8.2858877182007 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018eb45b-8593-72a3-89b2-bf1dc85e88ae'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018eb109-fd1b-73b3-9221-c5e411cddfe4'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec379-078f-707f-86e1-2a41865e1f87'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec37c-752d-717b-952e-0c3066cb7ec1'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec37b-9496-71e7-a5f2-12202aabcc60'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec379-7e48-70d8-93b8-bba8887e07db'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec378-c59c-7183-9a59-e485d2bf44f9'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec37d-0e46-7332-8d5a-1714ba865e42'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec377-f8da-7062-be37-983f985432a7'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec37c-1f1b-704f-b56f-5c56d5e7d983'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec37b-db5a-7043-a8d4-87f29c955bbf'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec37d-82dc-72eb-954a-35275cecb2e2'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018ec379-4b02-738e-8aaf-9c1da176de6e'
),
25.959608078003
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018eb04e-3e8a-70e4-b0cd-a660d8e5a519'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018eb04d-ef67-738b-9647-c63e94591798'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018eb04d-fd5d-736a-b4cf-1140258712c7'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018eb04e-1e7e-7014-85d1-ff9654cc6989'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018eb04e-0c19-7162-a250-adef794964f0'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ec378-6d12-70f5-912c-dde925bfd899'
),
UUID_TO_BIN (
'018eb04e-2e90-703e-aa3a-7aaf121a9afc'
),
8.2858877182007
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb45b-8593-72a3-89b2-bf1dc85e88ae' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb109-fd1b-73b3-9221-c5e411cddfe4' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec379-078f-707f-86e1-2a41865e1f87' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37c-752d-717b-952e-0c3066cb7ec1' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37b-9496-71e7-a5f2-12202aabcc60' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec379-7e48-70d8-93b8-bba8887e07db' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec378-c59c-7183-9a59-e485d2bf44f9' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37d-0e46-7332-8d5a-1714ba865e42' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec377-f8da-7062-be37-983f985432a7' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37c-1f1b-704f-b56f-5c56d5e7d983' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37b-db5a-7043-a8d4-87f29c955bbf' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec37d-82dc-72eb-954a-35275cecb2e2' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018ec379-4b02-738e-8aaf-9c1da176de6e' ), 25.959608078003 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04e-3e8a-70e4-b0cd-a660d8e5a519' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04d-ef67-738b-9647-c63e94591798' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04d-fd5d-736a-b4cf-1140258712c7' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04e-1e7e-7014-85d1-ff9654cc6989' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04e-0c19-7162-a250-adef794964f0' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec378-6d12-70f5-912c-dde925bfd899' ), UUID_TO_BIN ('018eb04e-2e90-703e-aa3a-7aaf121a9afc' ), 8.2858877182007 )
;
Copy
0.57 ms (0.94%)
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
"33c9mGI "
]
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 = '33c9mGI' LIMIT 1 ;
Copy