0.79 ms (17.48%)
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 ްçõÖrt»iÂÊwÜKˆ "
b"\x01 ްç/¿sS†Æiè\x1F\x08\x1D £ "
b"\x01 ްçIísLœPScªXÙO "
b"""
\x01 ްègzs»\x06 ›v\n
D€+
"""
b"\x01 ްè&÷r£¤Û¬0\r !” "
b"\x01 ްè\t –sÉ©)êĆ#£± "
b"\x01 ްèKŸpq \x7F MÓ°Ucß "
b"\x01 ްç\x00 ãp1¿³K¯¢¼\r 1 "
b"\x01 ްç‡âq±©Z\x1D î\x12\x12 qh "
b"\x01 ް2“\x03 rIºùœl~u\t z "
b"\x01 ްM\f õr\x02 ¨øî\x1F ªÓÿ6 "
b"\x01 ް֥^pž«uÁøzEÌ® "
b"\x01 Ž·ƒ4àrè”\x17 ¹«*Ïõœ "
b"\x01 Ž·‡\x15 ]q\v ˜\s¨HF^û "
b"\x01 Ž·¡óøsÁ¹Yå×tÊD‘ "
b"\x01 ޽¦'ÝsA¡‰z4Ã2F| "
b"\x01 Ž·úÉšq:¯o\x00\x0F\x03 Ó¦Ú "
b"\x01 ŽÉP^5s?µ\t ½…OÌÆÝ "
b"\x01 ŽÉP£<r\x12 ’˜\x0E\x18\x0F —ç+ "
b"\x01 ÉO³kp޽5˜S¯,íU "
b"\x01 ŽÉP\x0F rqü‹dg=\x1C ÀÅR "
b"\x01 ·‡øq$Ž ©öüö”! "
]
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 (0x018EB0E7F5D67274BB69C2CA77DC4B88 , 0x018EB0E72FBF735386C669E81F081DA3 , 0x018EB0E749ED734C9C505363AA58D94F , 0x018EB0E8677A73ADBB069B760A44802B , 0x018EB0E826F772A3A4DBAC300D21AD94 , 0x018EB0E8099673C9A929EAC48623A3B1 , 0x018EB0E84B9F7071A07F4DD3B05563DF , 0x018EB0E700E37031BFB34BAFA2BC0D31 , 0x018EB0E787E271B1A95A1DEE12127168 , 0x018EB03293037249BAF99C6C7E75097A , 0x018EB04D0CF57202A8F8EE1FAAD3FF36 , 0x018EB0D6A55E709EAB75C1F87A45CCAE , 0x018EB78334E072E89417B9AB2ACFF59C , 0x018EB787155D710B985C73A848465EFB , 0x018EB7A1F3F873C1B959E5D774CA4491 , 0x018EBDA627DD7341A1897A34C332467C , 0x018EB7FAC99A713AAF6F000F03D3A6DA , 0x018EC9505E35733FB509BD854FCCC6DD , 0x018EC950A33C721292980E180F97E72B , 0x018EC94FB36B708DBD359853AF2CED55 , 0x018EC9500F7271FC8B64673D1CC0C552 , 0x018ECE8787F871248D20A9F6FCF69421 );
Copy
0.60 ms (13.47%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e7-f5d6-7274-bb69-c2ca77dc4b88' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e7-2fbf-7353-86c6-69e81f081da3' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e7-49ed-734c-9c50-5363aa58d94f' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e8-677a-73ad-bb06-9b760a44802b' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e8-26f7-72a3-a4db-ac300d21ad94' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e8-0996-73c9-a929-eac48623a3b1' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e8-4b9f-7071-a07f-4dd3b05563df' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e7-87e2-71b1-a95a-1dee12127168' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb032-9303-7249-baf9-9c6c7e75097a' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb04d-0cf5-7202-a8f8-ee1faad3ff36' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0d6-a55e-709e-ab75-c1f87a45ccae' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb783-34e0-72e8-9417-b9ab2acff59c' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb787-155d-710b-985c-73a848465efb' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb7a1-f3f8-73c1-b959-e5d774ca4491' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ebda6-27dd-7341-a189-7a34c332467c' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb7fa-c99a-713a-af6f-000f03d3a6da' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ec950-5e35-733f-b509-bd854fccc6dd' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ec950-a33c-7212-9298-0e180f97e72b' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ec94f-b36b-708d-bd35-9853af2ced55' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ec950-0f72-71fc-8b64-673d1cc0c552' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ece87-87f8-7124-8d20-a9f6fcf69421' ), 6.6434640884399 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb0e7-f5d6-7274-bb69-c2ca77dc4b88'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb0e7-2fbf-7353-86c6-69e81f081da3'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb0e7-49ed-734c-9c50-5363aa58d94f'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb0e8-677a-73ad-bb06-9b760a44802b'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb0e8-26f7-72a3-a4db-ac300d21ad94'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb0e8-0996-73c9-a929-eac48623a3b1'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb0e8-4b9f-7071-a07f-4dd3b05563df'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb0e7-87e2-71b1-a95a-1dee12127168'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb032-9303-7249-baf9-9c6c7e75097a'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb04d-0cf5-7202-a8f8-ee1faad3ff36'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb0d6-a55e-709e-ab75-c1f87a45ccae'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb783-34e0-72e8-9417-b9ab2acff59c'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb787-155d-710b-985c-73a848465efb'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb7a1-f3f8-73c1-b959-e5d774ca4491'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018ebda6-27dd-7341-a189-7a34c332467c'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018eb7fa-c99a-713a-af6f-000f03d3a6da'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018ec950-5e35-733f-b509-bd854fccc6dd'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018ec950-a33c-7212-9298-0e180f97e72b'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018ec94f-b36b-708d-bd35-9853af2ced55'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018ec950-0f72-71fc-8b64-673d1cc0c552'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
UUID_TO_BIN (
'018ece87-87f8-7124-8d20-a9f6fcf69421'
),
6.6434640884399
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e7-f5d6-7274-bb69-c2ca77dc4b88' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e7-2fbf-7353-86c6-69e81f081da3' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e7-49ed-734c-9c50-5363aa58d94f' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e8-677a-73ad-bb06-9b760a44802b' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e8-26f7-72a3-a4db-ac300d21ad94' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e8-0996-73c9-a929-eac48623a3b1' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e8-4b9f-7071-a07f-4dd3b05563df' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0e7-87e2-71b1-a95a-1dee12127168' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb032-9303-7249-baf9-9c6c7e75097a' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb04d-0cf5-7202-a8f8-ee1faad3ff36' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb0d6-a55e-709e-ab75-c1f87a45ccae' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb783-34e0-72e8-9417-b9ab2acff59c' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb787-155d-710b-985c-73a848465efb' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb7a1-f3f8-73c1-b959-e5d774ca4491' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ebda6-27dd-7341-a189-7a34c332467c' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018eb7fa-c99a-713a-af6f-000f03d3a6da' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ec950-5e35-733f-b509-bd854fccc6dd' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ec950-a33c-7212-9298-0e180f97e72b' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ec94f-b36b-708d-bd35-9853af2ced55' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ec950-0f72-71fc-8b64-673d1cc0c552' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), UUID_TO_BIN ('018ece87-87f8-7124-8d20-a9f6fcf69421' ), 6.6434640884399 )
;
Copy
0.60 ms (13.31%)
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
"XXme5st "
]
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 = 'XXme5st' LIMIT 1 ;
Copy