0.92 ms (20.60%)
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 ޝêO\x0E s¢”³Vûx\x08 Ñ> "
b"\x01 ޝë\r íp?•Æ\r Ró|ÞH "
b"\x01 ޝê}ŽrL€]zCt\v Ã$ "
b"\x01 ޝêËq–´¬.éÈæXš "
b"\x01 ޝêýŒp9²$®pc\x04\x10 Î "
b"\x01 ޝê•#s°ƒ¤\x1D ©(ð·Þ "
b"\x01 ¯ê:…pZŽ/ßë~\x08 M— "
b"\x01 Ž¯ê®¢qUŒ8¾gÈ2\t ø "
b"\x01 ¯êcqqÙŽàø8z‡B^ "
b"\x01 ްMŠís¯§>Ž\x0F ¦P=i "
b"\x01 ްekÆp°†mš…bå\x13 ö "
b"\x01 ްXÂlq$Šc¶€ \x10 "Ý "
b"""
\x01 ްeW\x07 syˆ\n
\f C†¨ö<
"""
b"\x01 °ðÈjs¦–×Ó•'\x07 ò "
b"\x01 ±\x00 ÅÎqH²È¶„fžà "
b"\x01 ޽ðb\x17 rH§YG2‰\x14\x18 º "
b"\x01 ŽÎ,þ´p ›Öþ\x11 õ¦ó "
b"\x01 ΖTŒqöTéºS\x1D ½\x08 "
b"\x01 ä\x13\x1C ˜q\x14 \x7F [¿Š`ÓW "
]
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 (0x018EAFEA4F0E73A294B356FB7808D13E , 0x018EAFEB0DED703F95C60D52F37CDE48 , 0x018EAFEA7D8E724C805D7A43740BC324 , 0x018EAFEACBAD7196B4AC2EE9C8E6589A , 0x018EAFEAFD8C7039B224AE70630410CE , 0x018EAFEA952373B083A41DA928F0B7DE , 0x018EAFEA3A85705A8D2FDFEB7E084D97 , 0x018EAFEAAEA271558C38BE67C83209F8 , 0x018EAFEA637171D98DE0F8387A87425E , 0x018EB04D8AED73AFA73E8E0FA6503D69 , 0x018EB0656BC670B0866D9A8562E513F6 , 0x018EB058C26C71248A63B680A01022DD , 0x018EB06557077379880A0C4386A8F63C , 0x018EB0F0C86A73A696D7D381952707F2 , 0x018EB100C5CE7148B2C8B68F84669EE0 , 0x018EBDF062177248A7594732891418BA , 0x018ECE2CFEB470A09BD6ADFE11F5A6F3 , 0x018ECE96548C71F69054E9BA531DBD08 , 0x018EE4131C987114817F5BBF8A60D357 );
Copy
0.54 ms (12.10%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-4f0e-73a2-94b3-56fb7808d13e' ), 24.580345153809 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafeb-0ded-703f-95c6-0d52f37cde48' ), 24.580345153809 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-7d8e-724c-805d-7a43740bc324' ), 24.580345153809 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-cbad-7196-b4ac-2ee9c8e6589a' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-fd8c-7039-b224-ae70630410ce' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-9523-73b0-83a4-1da928f0b7de' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-3a85-705a-8d2f-dfeb7e084d97' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-aea2-7155-8c38-be67c83209f8' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-6371-71d9-8de0-f8387a87425e' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb04d-8aed-73af-a73e-8e0fa6503d69' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb065-6bc6-70b0-866d-9a8562e513f6' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb058-c26c-7124-8a63-b680a01022dd' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb065-5707-7379-880a-0c4386a8f63c' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb0f0-c86a-73a6-96d7-d381952707f2' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb100-c5ce-7148-b2c8-b68f84669ee0' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018ebdf0-6217-7248-a759-4732891418ba' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018ece2c-feb4-70a0-9bd6-adfe11f5a6f3' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018ece96-548c-71f6-9054-e9ba531dbd08' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018ee413-1c98-7114-817f-5bbf8a60d357' ), 7.1943426132202 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eafea-4f0e-73a2-94b3-56fb7808d13e'
),
24.580345153809
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eafeb-0ded-703f-95c6-0d52f37cde48'
),
24.580345153809
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eafea-7d8e-724c-805d-7a43740bc324'
),
24.580345153809
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eafea-cbad-7196-b4ac-2ee9c8e6589a'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eafea-fd8c-7039-b224-ae70630410ce'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eafea-9523-73b0-83a4-1da928f0b7de'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eafea-3a85-705a-8d2f-dfeb7e084d97'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eafea-aea2-7155-8c38-be67c83209f8'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eafea-6371-71d9-8de0-f8387a87425e'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eb04d-8aed-73af-a73e-8e0fa6503d69'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eb065-6bc6-70b0-866d-9a8562e513f6'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eb058-c26c-7124-8a63-b680a01022dd'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eb065-5707-7379-880a-0c4386a8f63c'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eb0f0-c86a-73a6-96d7-d381952707f2'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018eb100-c5ce-7148-b2c8-b68f84669ee0'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018ebdf0-6217-7248-a759-4732891418ba'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018ece2c-feb4-70a0-9bd6-adfe11f5a6f3'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018ece96-548c-71f6-9054-e9ba531dbd08'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eafea-e6ad-721e-b2be-d439573d30ac'
),
UUID_TO_BIN (
'018ee413-1c98-7114-817f-5bbf8a60d357'
),
7.1943426132202
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-4f0e-73a2-94b3-56fb7808d13e' ), 24.580345153809 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafeb-0ded-703f-95c6-0d52f37cde48' ), 24.580345153809 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-7d8e-724c-805d-7a43740bc324' ), 24.580345153809 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-cbad-7196-b4ac-2ee9c8e6589a' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-fd8c-7039-b224-ae70630410ce' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-9523-73b0-83a4-1da928f0b7de' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-3a85-705a-8d2f-dfeb7e084d97' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-aea2-7155-8c38-be67c83209f8' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eafea-6371-71d9-8de0-f8387a87425e' ), 14.836210250854 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb04d-8aed-73af-a73e-8e0fa6503d69' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb065-6bc6-70b0-866d-9a8562e513f6' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb058-c26c-7124-8a63-b680a01022dd' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb065-5707-7379-880a-0c4386a8f63c' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb0f0-c86a-73a6-96d7-d381952707f2' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018eb100-c5ce-7148-b2c8-b68f84669ee0' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018ebdf0-6217-7248-a759-4732891418ba' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018ece2c-feb4-70a0-9bd6-adfe11f5a6f3' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018ece96-548c-71f6-9054-e9ba531dbd08' ), 7.1943426132202 ), (UUID_TO_BIN ('018eafea-e6ad-721e-b2be-d439573d30ac' ), UUID_TO_BIN ('018ee413-1c98-7114-817f-5bbf8a60d357' ), 7.1943426132202 )
;
Copy
0.52 ms (11.68%)
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
"ys4nPOZ "
]
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 = 'ys4nPOZ' LIMIT 1 ;
Copy