0.87 ms (16.57%)
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 °s\x01 ?p‹‡}Ä,¶lÙ "
b"\x01 °räTr{¼õý–.£¥ "
b"\x01 ްkäÞrá£\x13 °r;Á.¿ "
b"\x01 ޝ~ïÚr5š’\x02 †\x07 ýFà "
b"\x01 ޵\x07\x18 ¹qè³\x18 {ü>¾C\x06 "
b"\x01 µ\x07 ƒ"qµ\t\x10 À0Zr8 "
b"\x01 µ\x06 ær쪊M¼2Ž“\x12 "
b"\x01 ŽÖõàrs\x1D Œ%n¥'…\x1F ® "
b"\x01 Ž×Øyks'¯VÒúóÕH| "
b"\x01 Ž×Ø\Àpw…±\x14 ¿ÎÆfB "
b"\x01 ŽÞ;\x0E rs7”ÐÏþ83ß\n "
b"\x01 רŽ~p*‰}Û·"\x11\x10\x00 "
b"\x01 Ž×ØÊ¹q\x0E >—¶IÏXm "
b"\x01 Ž´¥Z+sà¸\x10 í<«t9 "
b"\x01 ŽÃQ)\x10 pW¬Ù<\x0E dä#ê "
b"\x01 Ž×\x1D .×q\x1A ·¹¯.G;\x02 © "
b"\x01 Ž×"rTp‡´N&Ð\x08 ~¡ "
b"\x01 Ž× ^+q¨‘H-º—B½í "
b"\x01 Ž×\x1E Ä1s\x1F ª«%\x14 Ø¥¿ë "
b"\x01 Ž×\x1D Ð\x15 p\x05 ”GãN‘LoÍ "
b"\x01 Ž× \x02 °r'‘Þ&‘‡"§Ç "
b"\x01 Ž×!˜¥s®‡²;ÃÑ\x00 Y¡ "
b"\x01 Ž×\e ÿ$r¯»„6¸‚`ÀZ "
]
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 (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ?
)
Copy
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 (0x018EB073013F708B877DC42CB6816CD9 , 0x018EB072E454727BBCF5FD96902EA3A5 , 0x018EB06BE4DE72E1A313B0723BC12EBF , 0x018EAF7EEFDA72359A92028607FD46E0 , 0x018EB50718B971E8B3187BFC3EBE4306 , 0x018EB507832271B59D0910C0305A7238 , 0x018EB506E6AD72ECAA8A4DBC328D9312 , 0x018ED6F5E072731D8C256EA527851FAE , 0x018ED7D8796B7327AF56D2FAF3D5487C , 0x018ED7D85CC0707785B114BFCEC66642 , 0x018EDE3B0E72733794D0CFFE3833DF0A , 0x018ED7D88D7E702A897DDBB722111000 , 0x018ED7D8CAB9710EA03E97B649CF586D , 0x018EB4A55A2B73E0B8AD10ED3CAB7439 , 0x018EC35129107057ACD93C0E64E423EA , 0x018ED71D2ED7711AB7B9AF2E473B02A9 , 0x018ED72272547087B44E26D008A07EA1 , 0x018ED7205E2B71A891482DBA9742BDED , 0x018ED71EC431731FAAAB2514D8A5BFEB , 0x018ED71DD01570059447E34E914C6FCD , 0x018ED72002B0722791DE26918722A7C7 , 0x018ED72198A573AE87B23BC3D10059A1 , 0x018ED71BFF2472AFBB8436B88260C05A );
Copy
0.84 ms (15.95%)
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
"2tPDoRK "
]
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 = '2tPDoRK' LIMIT 1 ;
Copy
0.77 ms (14.74%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb073-013f-708b-877d-c42cb6816cd9' ), 66.880989074707 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb072-e454-727b-bcf5-fd96902ea3a5' ), 55.16686630249 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb06b-e4de-72e1-a313-b0723bc12ebf' ), 11.714120864868 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eaf7e-efda-7235-9a92-028607fd46e0' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb507-8322-71b5-9d09-10c0305a7238' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb506-e6ad-72ec-aa8a-4dbc328d9312' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed6f5-e072-731d-8c25-6ea527851fae' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed7d8-796b-7327-af56-d2faf3d5487c' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed7d8-5cc0-7077-85b1-14bfcec66642' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ede3b-0e72-7337-94d0-cffe3833df0a' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed7d8-8d7e-702a-897d-dbb722111000' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed7d8-cab9-710e-a03e-97b649cf586d' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb4a5-5a2b-73e0-b8ad-10ed3cab7439' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ec351-2910-7057-acd9-3c0e64e423ea' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed71d-2ed7-711a-b7b9-af2e473b02a9' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed722-7254-7087-b44e-26d008a07ea1' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed720-5e2b-71a8-9148-2dba9742bded' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed71e-c431-731f-aaab-2514d8a5bfeb' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed71d-d015-7005-9447-e34e914c6fcd' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed720-02b0-7227-91de-26918722a7c7' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed71b-ff24-72af-bb84-36b88260c05a' ), 6.8104114532471 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018eb073-013f-708b-877d-c42cb6816cd9'
),
66.880989074707
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018eb072-e454-727b-bcf5-fd96902ea3a5'
),
55.16686630249
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018eb06b-e4de-72e1-a313-b0723bc12ebf'
),
11.714120864868
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018eaf7e-efda-7235-9a92-028607fd46e0'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018eb507-8322-71b5-9d09-10c0305a7238'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018eb506-e6ad-72ec-aa8a-4dbc328d9312'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed6f5-e072-731d-8c25-6ea527851fae'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed7d8-796b-7327-af56-d2faf3d5487c'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed7d8-5cc0-7077-85b1-14bfcec66642'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ede3b-0e72-7337-94d0-cffe3833df0a'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed7d8-8d7e-702a-897d-dbb722111000'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed7d8-cab9-710e-a03e-97b649cf586d'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018eb4a5-5a2b-73e0-b8ad-10ed3cab7439'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ec351-2910-7057-acd9-3c0e64e423ea'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed71d-2ed7-711a-b7b9-af2e473b02a9'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed722-7254-7087-b44e-26d008a07ea1'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed720-5e2b-71a8-9148-2dba9742bded'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed71e-c431-731f-aaab-2514d8a5bfeb'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed71d-d015-7005-9447-e34e914c6fcd'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed720-02b0-7227-91de-26918722a7c7'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
UUID_TO_BIN (
'018ed71b-ff24-72af-bb84-36b88260c05a'
),
6.8104114532471
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb073-013f-708b-877d-c42cb6816cd9' ), 66.880989074707 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb072-e454-727b-bcf5-fd96902ea3a5' ), 55.16686630249 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb06b-e4de-72e1-a313-b0723bc12ebf' ), 11.714120864868 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eaf7e-efda-7235-9a92-028607fd46e0' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb507-8322-71b5-9d09-10c0305a7238' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb506-e6ad-72ec-aa8a-4dbc328d9312' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed6f5-e072-731d-8c25-6ea527851fae' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed7d8-796b-7327-af56-d2faf3d5487c' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed7d8-5cc0-7077-85b1-14bfcec66642' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ede3b-0e72-7337-94d0-cffe3833df0a' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed7d8-8d7e-702a-897d-dbb722111000' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed7d8-cab9-710e-a03e-97b649cf586d' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018eb4a5-5a2b-73e0-b8ad-10ed3cab7439' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ec351-2910-7057-acd9-3c0e64e423ea' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed71d-2ed7-711a-b7b9-af2e473b02a9' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed722-7254-7087-b44e-26d008a07ea1' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed720-5e2b-71a8-9148-2dba9742bded' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed71e-c431-731f-aaab-2514d8a5bfeb' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed71d-d015-7005-9447-e34e914c6fcd' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed720-02b0-7227-91de-26918722a7c7' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), UUID_TO_BIN ('018ed71b-ff24-72af-bb84-36b88260c05a' ), 6.8104114532471 )
;
Copy