1.02 ms (19.24%)
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 °PA6sšžfƒ\x1A êIn "
b"\x01 ްP[pq\x13 Ž2â\x08 ‹p/æ "
b"""
\x01 ްOûËpzž±ù‡²Ï\n
«
"""
b"\x01 ްPºkpX”=ÒRŒ_Yˆ "
b"\x01 ްP«fp\x06 ¡WÁ|\x10 Y\x19 ’ "
b"\x01 ްP\f jrÉ£“Z|šÓá™ "
b"\x01 ްPΓsؼÀÿ½òˆ× "
b"\x01 ްP"#pl_Üq%“Ï\x12 "
b"\x01 ްP›³pr™³ghPò¥9 "
b"\x01 ް\t Z|qY°¡ì*úX_\x00 "
b"\x01 ·~‹Ør-“ûÝ«\x05 •L "
b"\x01 Ž´¯\x0F õqâ 6(ûˆÐ\x1A £ "
b"\x01 ŽÃ§IÚrÕœñ!\f ü?ýb "
b"\x01 ŽÃrµürë¢\x12 1ZÈÕ~\x1F "
b"\x01 ŽÉ\x16 M_rz‹y0\x13 ÚðÆ÷ "
b"\x01 Ãs˜¬ràî®Ã]\x15 v) "
b"\x01 ×\x0F\f Žs\x13 º‹\x1D 0‰\x7F ‚p "
b"\x01 ŽÎ`ýNs\x07 ‹ßDBl¾ì„ "
b"\x01 Ž×Ô?oqf¤Ì`rÁÆÜv "
b"\x01 ŽÞžLXpý™\x1D Ò\x1E ºp!ˆ "
]
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 (0x018EB0504136739A9E66831AEA49906E , 0x018EB0505B7071138E32E2088B702FE6 , 0x018EB04FFBCB707A9EB1F987B2CF0AAB , 0x018EB050BA6B7058943DD2528C5F5988 , 0x018EB050AB667006A157C17C10591992 , 0x018EB0500C6A72C9A3935A7C9AD3E199 , 0x018EB050CE9373D8BCC0FFBDF288D7A0 , 0x018EB0502223706CAD5FDC712593CF12 , 0x018EB0509BB3707299B3676850F2A539 , 0x018EB0095A7C7159B0A1EC2AFA585F00 , 0x018EB77E8BD8722D93FBDDAB0595814C , 0x018EB4AF0FF571E2A03628FB88D01AA3 , 0x018EC3A749DA72D59CF1210CFC3FFD62 , 0x018EC372B5FC72EBA212315AC8D57E1F , 0x018EC9164D5F727A8B793013DAF0C6F7 , 0x018EC37398AC72E09DEEAEC35D157629 , 0x018ED70F0C8D7313BA8B1D30897F8270 , 0x018ECE60FD4E73078BDF44426CBEEC84 , 0x018ED7D43F6F7166A4CC6072C1C6DC76 , 0x018EDE9E4C5870FD991DD21EBA702188 );
Copy
0.73 ms (13.72%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-4136-739a-9e66-831aea49906e' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-5b70-7113-8e32-e2088b702fe6' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb04f-fbcb-707a-9eb1-f987b2cf0aab' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-ba6b-7058-943d-d2528c5f5988' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-ab66-7006-a157-c17c10591992' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-0c6a-72c9-a393-5a7c9ad3e199' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-ce93-73d8-bcc0-ffbdf288d7a0' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-2223-706c-ad5f-dc712593cf12' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-9bb3-7072-99b3-676850f2a539' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb009-5a7c-7159-b0a1-ec2afa585f00' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb77e-8bd8-722d-93fb-ddab0595814c' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb4af-0ff5-71e2-a036-28fb88d01aa3' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ec3a7-49da-72d5-9cf1-210cfc3ffd62' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ec372-b5fc-72eb-a212-315ac8d57e1f' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ec916-4d5f-727a-8b79-3013daf0c6f7' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ec373-98ac-72e0-9dee-aec35d157629' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ed70f-0c8d-7313-ba8b-1d30897f8270' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ece60-fd4e-7307-8bdf-44426cbeec84' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ed7d4-3f6f-7166-a4cc-6072c1c6dc76' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ede9e-4c58-70fd-991d-d21eba702188' ), 7.1943426132202 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb050-4136-739a-9e66-831aea49906e'
),
29.448657989502
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb050-5b70-7113-8e32-e2088b702fe6'
),
29.448657989502
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb04f-fbcb-707a-9eb1-f987b2cf0aab'
),
29.448657989502
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb050-ba6b-7058-943d-d2528c5f5988'
),
29.448657989502
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb050-ab66-7006-a157-c17c10591992'
),
29.448657989502
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb050-0c6a-72c9-a393-5a7c9ad3e199'
),
29.448657989502
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb050-ce93-73d8-bcc0-ffbdf288d7a0'
),
29.448657989502
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb050-2223-706c-ad5f-dc712593cf12'
),
29.448657989502
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb050-9bb3-7072-99b3-676850f2a539'
),
29.448657989502
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb009-5a7c-7159-b0a1-ec2afa585f00'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb77e-8bd8-722d-93fb-ddab0595814c'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018eb4af-0ff5-71e2-a036-28fb88d01aa3'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018ec3a7-49da-72d5-9cf1-210cfc3ffd62'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018ec372-b5fc-72eb-a212-315ac8d57e1f'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018ec916-4d5f-727a-8b79-3013daf0c6f7'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018ec373-98ac-72e0-9dee-aec35d157629'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018ed70f-0c8d-7313-ba8b-1d30897f8270'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018ece60-fd4e-7307-8bdf-44426cbeec84'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018ed7d4-3f6f-7166-a4cc-6072c1c6dc76'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb050-6c98-73c0-8fd8-0fab0983e138'
),
UUID_TO_BIN (
'018ede9e-4c58-70fd-991d-d21eba702188'
),
7.1943426132202
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-4136-739a-9e66-831aea49906e' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-5b70-7113-8e32-e2088b702fe6' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb04f-fbcb-707a-9eb1-f987b2cf0aab' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-ba6b-7058-943d-d2528c5f5988' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-ab66-7006-a157-c17c10591992' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-0c6a-72c9-a393-5a7c9ad3e199' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-ce93-73d8-bcc0-ffbdf288d7a0' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-2223-706c-ad5f-dc712593cf12' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb050-9bb3-7072-99b3-676850f2a539' ), 29.448657989502 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb009-5a7c-7159-b0a1-ec2afa585f00' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb77e-8bd8-722d-93fb-ddab0595814c' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018eb4af-0ff5-71e2-a036-28fb88d01aa3' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ec3a7-49da-72d5-9cf1-210cfc3ffd62' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ec372-b5fc-72eb-a212-315ac8d57e1f' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ec916-4d5f-727a-8b79-3013daf0c6f7' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ec373-98ac-72e0-9dee-aec35d157629' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ed70f-0c8d-7313-ba8b-1d30897f8270' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ece60-fd4e-7307-8bdf-44426cbeec84' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ed7d4-3f6f-7166-a4cc-6072c1c6dc76' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb050-6c98-73c0-8fd8-0fab0983e138' ), UUID_TO_BIN ('018ede9e-4c58-70fd-991d-d21eba702188' ), 7.1943426132202 )
;
Copy
0.55 ms (10.28%)
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
"rJKr5EC "
]
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 = 'rJKr5EC' LIMIT 1 ;
Copy