0.70 ms (17.18%)
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 ŽãÓ»\x1E pè“ñðAè9L@ "
b"\x01 ޵<\x05 wq\x1D ˆ½$ô\x04 —¤Ð "
b"\x01 ŽÞ”4<p\x07 ¨hÆrÆÐC: "
b"\x01 ŽÞ“ØIs¾¾_Rì‘ÙDr "
b"\x01 ŽãÔo\x10 q+¿Ó\x1E\v 3=\x12 Œ "
b"\x01 ŽÞ“‘´r.“Š…Í\x01 [?° "
b"\x01 ްeÀWp\x15 ¤\e 1éü\x00 «\x11 "
b"\x01 ްú¼|r†„”ix°ý]Ý "
b"\x01 µ\r ¿ÏpÜ•_wfc\x16 ³ "
b"\x01 ޽ÙHCpÕ–>ƒt¾Æ\x14 ï "
b"\x01 ·Ø\x0F qAšF‘›ó\f êù "
b"""
\x01 Ž·‚‚¹pä¼/\x1C '“\n
éí
"""
b"\x01 Ž·‚.ÔsBŸ#Wj§&47 "
b"\x01 Ã~µp¹²F+õ‹\x0F ¼\x1A "
b"\x01 ŽÃ~NZqy£ô\x13 ÂΟ)| "
b"\x01 ŽÃ~ìWq9»ÙJ±3ªN÷ "
b"\x01 ÞÒ\r 9qß®f=W\x17 Ñ7 "
b"\x01 ÞÒÇ"qœz\x12 >}0° "
]
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 (0x018EE3D3BB1E70E893F1F041E8394C40 , 0x018EB53C0577711D88BD24F40497A4D0 , 0x018EDE94343C7007A868C672C6D0433A , 0x018EDE93D84973BEBE5F52EC91D94472 , 0x018EE3D46F10712BBFD31E0B333D128C , 0x018EDE9391B4722E938A85CD015B3FB0 , 0x018EB065C0577015A41B31E9FC00AB11 , 0x018EB0FABC7C728684946978B0FD5DDD , 0x018EB50DBFCF70DC90955F77666316B3 , 0x018EBDD9484370D5963E8374BEC614EF , 0x018EB781D80F71419A46919BF30CEAF9 , 0x018EB78282B970E4BC2F1C27930AE9ED , 0x018EB7822ED473429F23576AA7263437 , 0x018EC37EB59070B9B2462BF58B0FBC1A , 0x018EC37E4E5A7179A3F413C2CE9F297C , 0x018EC37EEC577139BBD94AB133AA4EF7 , 0x018EDED20D3971DFAE663D5717D1378F , 0x018EDED2C722719C9D8F7A123E7D30B0 );
Copy
0.60 ms (14.73%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ee3d3-bb1e-70e8-93f1-f041e8394c40' ), 66.489921569824 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb53c-0577-711d-88bd-24f40497a4d0' ), 31.347564697266 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ede94-343c-7007-a868-c672c6d0433a' ), 31.347564697266 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ede93-d849-73be-be5f-52ec91d94472' ), 31.347564697266 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ee3d4-6f10-712b-bfd3-1e0b333d128c' ), 31.347564697266 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ede93-91b4-722e-938a-85cd015b3fb0' ), 31.347564697266 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb065-c057-7015-a41b-31e9fc00ab11' ), 11.714120864868 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb0fa-bc7c-7286-8494-6978b0fd5ddd' ), 9.7441358566284 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb50d-bfcf-70dc-9095-5f77666316b3' ), 9.7441358566284 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ebdd9-4843-70d5-963e-8374bec614ef' ), 9.7441358566284 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb781-d80f-7141-9a46-919bf30ceaf9' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb782-82b9-70e4-bc2f-1c27930ae9ed' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb782-2ed4-7342-9f23-576aa7263437' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ec37e-b590-70b9-b246-2bf58b0fbc1a' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ec37e-4e5a-7179-a3f4-13c2ce9f297c' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ec37e-ec57-7139-bbd9-4ab133aa4ef7' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eded2-0d39-71df-ae66-3d5717d1378f' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eded2-c722-719c-9d8f-7a123e7d30b0' ), 6.4899020195007 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018ee3d3-bb1e-70e8-93f1-f041e8394c40'
),
66.489921569824
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018eb53c-0577-711d-88bd-24f40497a4d0'
),
31.347564697266
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018ede94-343c-7007-a868-c672c6d0433a'
),
31.347564697266
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018ede93-d849-73be-be5f-52ec91d94472'
),
31.347564697266
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018ee3d4-6f10-712b-bfd3-1e0b333d128c'
),
31.347564697266
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018ede93-91b4-722e-938a-85cd015b3fb0'
),
31.347564697266
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018eb065-c057-7015-a41b-31e9fc00ab11'
),
11.714120864868
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018eb0fa-bc7c-7286-8494-6978b0fd5ddd'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018eb50d-bfcf-70dc-9095-5f77666316b3'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018ebdd9-4843-70d5-963e-8374bec614ef'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018eb781-d80f-7141-9a46-919bf30ceaf9'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018eb782-82b9-70e4-bc2f-1c27930ae9ed'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018eb782-2ed4-7342-9f23-576aa7263437'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018ec37e-b590-70b9-b246-2bf58b0fbc1a'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018ec37e-4e5a-7179-a3f4-13c2ce9f297c'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018ec37e-ec57-7139-bbd9-4ab133aa4ef7'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018eded2-0d39-71df-ae66-3d5717d1378f'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ede93-43d4-7215-9d66-f9c9ad5be931'
),
UUID_TO_BIN (
'018eded2-c722-719c-9d8f-7a123e7d30b0'
),
6.4899020195007
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ee3d3-bb1e-70e8-93f1-f041e8394c40' ), 66.489921569824 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb53c-0577-711d-88bd-24f40497a4d0' ), 31.347564697266 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ede94-343c-7007-a868-c672c6d0433a' ), 31.347564697266 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ede93-d849-73be-be5f-52ec91d94472' ), 31.347564697266 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ee3d4-6f10-712b-bfd3-1e0b333d128c' ), 31.347564697266 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ede93-91b4-722e-938a-85cd015b3fb0' ), 31.347564697266 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb065-c057-7015-a41b-31e9fc00ab11' ), 11.714120864868 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb0fa-bc7c-7286-8494-6978b0fd5ddd' ), 9.7441358566284 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb50d-bfcf-70dc-9095-5f77666316b3' ), 9.7441358566284 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ebdd9-4843-70d5-963e-8374bec614ef' ), 9.7441358566284 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb781-d80f-7141-9a46-919bf30ceaf9' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb782-82b9-70e4-bc2f-1c27930ae9ed' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eb782-2ed4-7342-9f23-576aa7263437' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ec37e-b590-70b9-b246-2bf58b0fbc1a' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ec37e-4e5a-7179-a3f4-13c2ce9f297c' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018ec37e-ec57-7139-bbd9-4ab133aa4ef7' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eded2-0d39-71df-ae66-3d5717d1378f' ), 6.4899020195007 ), (UUID_TO_BIN ('018ede93-43d4-7215-9d66-f9c9ad5be931' ), UUID_TO_BIN ('018eded2-c722-719c-9d8f-7a123e7d30b0' ), 6.4899020195007 )
;
Copy
0.47 ms (11.42%)
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
"vRJEObi "
]
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 = 'vRJEObi' LIMIT 1 ;
Copy