0.74 ms (16.45%)
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 ŽÃQ)\x10 pW¬Ù<\x0E dä#ê "
b"\x01 Ž×\x1D .×q\x1A ·¹¯.G;\x02 © "
b"\x01 Ž× ^+q¨‘H-º—B½í "
b"\x01 Ž´¥Z+sà¸\x10 í<«t9 "
b"\x01 Ž×"rTp‡´N&Ð\x08 ~¡ "
b"\x01 Ž×\x1E Ä1s\x1F ª«%\x14 Ø¥¿ë "
b"\x01 Ž×\x1D Ð\x15 p\x05 ”GãN‘LoÍ "
b"\x01 Ž× \x02 °r'‘Þ&‘‡"§Ç "
b"\x01 Ž×\e ÿ$r¯»„6¸‚`ÀZ "
b"\x01 Ž´«\x0F oqÓ±úˆÿ$J¦o "
b"\x01 Žã°yôsд]ÂhÍuK\x1D "
b"\x01 Ž´ÒÍ×q7¢ŒÚ\x02 ÿ8w% "
b"\x01 ŽÍå\\x03 qo¦-\x13 cLØ6p "
b"\x01 ŽÉÈ\x18 ›p/¼K\x07 Ý×Î,µ "
b"\x01 ްÐxÀs—‡_í)´à\x10 "
b"\x01 °räTr{¼õý–.£¥ "
b"\x01 ްróÓss°¶ÞO²Ü\x06 Ë "
b"\x01 °s\x01 ?p‹‡}Ä,¶lÙ "
]
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 (0x018EC35129107057ACD93C0E64E423EA , 0x018ED71D2ED7711AB7B9AF2E473B02A9 , 0x018ED7205E2B71A891482DBA9742BDED , 0x018EB4A55A2B73E0B8AD10ED3CAB7439 , 0x018ED72272547087B44E26D008A07EA1 , 0x018ED71EC431731FAAAB2514D8A5BFEB , 0x018ED71DD01570059447E34E914C6FCD , 0x018ED72002B0722791DE26918722A7C7 , 0x018ED71BFF2472AFBB8436B88260C05A , 0x018EB4AB0F6F71D3B1FA88FF244AA66F , 0x018EE3B079F473D0B45DC268CD754B1D , 0x018EB4D2CDD77137A28CDA02FF387725 , 0x018ECDE55C03716FA62D13634CD83670 , 0x018EC9C8189B702FBC4B07DDD7CE2CB5 , 0x018EB0D078C07397875FED29B4E010A0 , 0x018EB072E454727BBCF5FD96902EA3A5 , 0x018EB072F3D37373B0B6DE4FB2DC06CB , 0x018EB073013F708B877DC42CB6816CD9 );
Copy
0.62 ms (13.93%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ec351-2910-7057-acd9-3c0e64e423ea' ), 37.989471435547 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed71d-2ed7-711a-b7b9-af2e473b02a9' ), 36.035305023193 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed720-5e2b-71a8-9148-2dba9742bded' ), 36.035305023193 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb4a5-5a2b-73e0-b8ad-10ed3cab7439' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed722-7254-7087-b44e-26d008a07ea1' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed71e-c431-731f-aaab-2514d8a5bfeb' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed71d-d015-7005-9447-e34e914c6fcd' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed720-02b0-7227-91de-26918722a7c7' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed71b-ff24-72af-bb84-36b88260c05a' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb4ab-0f6f-71d3-b1fa-88ff244aa66f' ), 10.539752960205 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ee3b0-79f4-73d0-b45d-c268cd754b1d' ), 10.539752960205 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb4d2-cdd7-7137-a28c-da02ff387725' ), 9.1485061645508 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ecde5-5c03-716f-a62d-13634cd83670' ), 9.1485061645508 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ec9c8-189b-702f-bc4b-07ddd7ce2cb5' ), 9.1485061645508 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb0d0-78c0-7397-875f-ed29b4e010a0' ), 7.1943426132202 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb072-e454-727b-bcf5-fd96902ea3a5' ), 6.8104114532471 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), 6.8104114532471 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb073-013f-708b-877d-c42cb6816cd9' ), 6.8104114532471 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018ec351-2910-7057-acd9-3c0e64e423ea'
),
37.989471435547
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018ed71d-2ed7-711a-b7b9-af2e473b02a9'
),
36.035305023193
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018ed720-5e2b-71a8-9148-2dba9742bded'
),
36.035305023193
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018eb4a5-5a2b-73e0-b8ad-10ed3cab7439'
),
28.840965270996
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018ed722-7254-7087-b44e-26d008a07ea1'
),
28.840965270996
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018ed71e-c431-731f-aaab-2514d8a5bfeb'
),
28.840965270996
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018ed71d-d015-7005-9447-e34e914c6fcd'
),
28.840965270996
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018ed720-02b0-7227-91de-26918722a7c7'
),
28.840965270996
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018ed71b-ff24-72af-bb84-36b88260c05a'
),
28.840965270996
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018eb4ab-0f6f-71d3-b1fa-88ff244aa66f'
),
10.539752960205
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018ee3b0-79f4-73d0-b45d-c268cd754b1d'
),
10.539752960205
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018eb4d2-cdd7-7137-a28c-da02ff387725'
),
9.1485061645508
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018ecde5-5c03-716f-a62d-13634cd83670'
),
9.1485061645508
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018ec9c8-189b-702f-bc4b-07ddd7ce2cb5'
),
9.1485061645508
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018eb0d0-78c0-7397-875f-ed29b4e010a0'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018eb072-e454-727b-bcf5-fd96902ea3a5'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018ed721-98a5-73ae-87b2-3bc3d10059a1'
),
UUID_TO_BIN (
'018eb073-013f-708b-877d-c42cb6816cd9'
),
6.8104114532471
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ec351-2910-7057-acd9-3c0e64e423ea' ), 37.989471435547 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed71d-2ed7-711a-b7b9-af2e473b02a9' ), 36.035305023193 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed720-5e2b-71a8-9148-2dba9742bded' ), 36.035305023193 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb4a5-5a2b-73e0-b8ad-10ed3cab7439' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed722-7254-7087-b44e-26d008a07ea1' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed71e-c431-731f-aaab-2514d8a5bfeb' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed71d-d015-7005-9447-e34e914c6fcd' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed720-02b0-7227-91de-26918722a7c7' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ed71b-ff24-72af-bb84-36b88260c05a' ), 28.840965270996 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb4ab-0f6f-71d3-b1fa-88ff244aa66f' ), 10.539752960205 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ee3b0-79f4-73d0-b45d-c268cd754b1d' ), 10.539752960205 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb4d2-cdd7-7137-a28c-da02ff387725' ), 9.1485061645508 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ecde5-5c03-716f-a62d-13634cd83670' ), 9.1485061645508 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018ec9c8-189b-702f-bc4b-07ddd7ce2cb5' ), 9.1485061645508 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb0d0-78c0-7397-875f-ed29b4e010a0' ), 7.1943426132202 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb072-e454-727b-bcf5-fd96902ea3a5' ), 6.8104114532471 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), 6.8104114532471 ), (UUID_TO_BIN ('018ed721-98a5-73ae-87b2-3bc3d10059a1' ), UUID_TO_BIN ('018eb073-013f-708b-877d-c42cb6816cd9' ), 6.8104114532471 )
;
Copy
0.48 ms (10.78%)
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
"H6o-SqQ "
]
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 = 'H6o-SqQ' LIMIT 1 ;
Copy