0.78 ms (16.93%)
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 ޽™@ìp\x16 º°ç:9:ž² "
b"\x01 ޽˜Á¤s\x18 ¼³V\e 9\x0E Ü\ "
b"\x01 ޽˜…Ór\f Žª—1€‘`9 "
b"\x01 ޽˜>Qq/›¢ó\x15 Í&èê "
b"""
\x01 ½™\x12 \n
sé®Yᑊ\x12 ’
"""
b"\x01 ޽—øûrð‹ƒ„ÁhŒAÏ "
b"\x01 ãxÙq£“QˆF7Äún "
b"\x01 ãzàlr \t ž4e/.ë "
b"\x01 Žãz$LrÆ‚ãnöÈô;> "
b"\x01 ŽãyL“pä¢ÞC\x04 J\x01 xÛ "
b"\x01 ¯ˆLqOï/â¿ú¶; "
b"\x01 ޝÝ{\x0F rZ¿”\x19 LK\x05 D« "
b"\x01 ޝßÄÇqˆ‹@ƒÂü%]\x16 "
b"\x01 ޝ¹Ÿ\x11 qzœ\x02 šÁ\x1E Ü-à "
b"""
\x01 ޝ¾ôír{rh\n
©^K©
"""
b"\x01 ް¨Ô—q6™&æ°öäÆõ "
b"\x01 °zpýµŠ<8^ l¢ "
b"\x01 Žä#`«s\x1E ˜‡ZߨaP "
b"\x01 Žä\x17 =\x05 s\f ¯Š ?¬\x17 ŠF "
]
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 (0x018EBD9940EC7016BAB0E73A393A9EB2 , 0x018EBD98C1A47318BCB3561B390EDC5C , 0x018EBD9885D3720C8EAA973180916039 , 0x018EBD983E51712F9BA2F315CD26E8EA , 0x018EBD99120A73E9AE9059E1918A1292 , 0x018EBD97F8FB72F08B8384C1688C41CF , 0x018EE378D98F71A39351884637C4FA6E , 0x018EE37AE06C72A09D099E34652F2EEB , 0x018EE37A244C72C682E36EF6C8F43B3E , 0x018EE3794C9370E4A2DE43044A0178DB , 0x018EAF88814C714FADEF2FE2BFFAB63B , 0x018EAFDD7B0F725ABF94194C4B0544AB , 0x018EAFDFC4C771888B4083C2FC255D16 , 0x018EAFB99F11717A9C029AC11EDC2DC3 , 0x018EAFBEF4ED727BAD72680AA95E4BA9 , 0x018EB0A8D49771369926E6B0F6E4C6F5 , 0x018EB09D9F7A70FDB58A3C385E206CA2 , 0x018EE42360AB731E98875ADFC3986150 , 0x018EE4173D05730CAF8A203FAC178A46 );
Copy
0.66 ms (14.52%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd99-40ec-7016-bab0-e73a393a9eb2' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd98-c1a4-7318-bcb3-561b390edc5c' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd98-85d3-720c-8eaa-973180916039' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd98-3e51-712f-9ba2-f315cd26e8ea' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd99-120a-73e9-ae90-59e1918a1292' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd97-f8fb-72f0-8b83-84c1688c41cf' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee378-d98f-71a3-9351-884637c4fa6e' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee37a-e06c-72a0-9d09-9e34652f2eeb' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee37a-244c-72c6-82e3-6ef6c8f43b3e' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee379-4c93-70e4-a2de-43044a0178db' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eaf88-814c-714f-adef-2fe2bffab63b' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eafdd-7b0f-725a-bf94-194c4b0544ab' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eafdf-c4c7-7188-8b40-83c2fc255d16' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eafb9-9f11-717a-9c02-9ac11edc2dc3' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eafbe-f4ed-727b-ad72-680aa95e4ba9' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eb0a8-d497-7136-9926-e6b0f6e4c6f5' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eb09d-9f7a-70fd-b58a-3c385e206ca2' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee423-60ab-731e-9887-5adfc3986150' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee417-3d05-730c-af8a-203fac178a46' ), 7.4181051254272 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ebd99-40ec-7016-bab0-e73a393a9eb2'
),
14.38868522644
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ebd98-c1a4-7318-bcb3-561b390edc5c'
),
14.38868522644
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ebd98-85d3-720c-8eaa-973180916039'
),
14.38868522644
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ebd98-3e51-712f-9ba2-f315cd26e8ea'
),
14.38868522644
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ebd99-120a-73e9-ae90-59e1918a1292'
),
14.38868522644
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ebd97-f8fb-72f0-8b83-84c1688c41cf'
),
14.38868522644
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ee378-d98f-71a3-9351-884637c4fa6e'
),
14.38868522644
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ee37a-e06c-72a0-9d09-9e34652f2eeb'
),
14.38868522644
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ee37a-244c-72c6-82e3-6ef6c8f43b3e'
),
14.38868522644
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ee379-4c93-70e4-a2de-43044a0178db'
),
14.38868522644
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018eaf88-814c-714f-adef-2fe2bffab63b'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018eafdd-7b0f-725a-bf94-194c4b0544ab'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018eafdf-c4c7-7188-8b40-83c2fc255d16'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018eafb9-9f11-717a-9c02-9ac11edc2dc3'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018eafbe-f4ed-727b-ad72-680aa95e4ba9'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018eb0a8-d497-7136-9926-e6b0f6e4c6f5'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018eb09d-9f7a-70fd-b58a-3c385e206ca2'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ee423-60ab-731e-9887-5adfc3986150'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ebd97-c0db-730f-9030-b50877b86997'
),
UUID_TO_BIN (
'018ee417-3d05-730c-af8a-203fac178a46'
),
7.4181051254272
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd99-40ec-7016-bab0-e73a393a9eb2' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd98-c1a4-7318-bcb3-561b390edc5c' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd98-85d3-720c-8eaa-973180916039' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd98-3e51-712f-9ba2-f315cd26e8ea' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd99-120a-73e9-ae90-59e1918a1292' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ebd97-f8fb-72f0-8b83-84c1688c41cf' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee378-d98f-71a3-9351-884637c4fa6e' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee37a-e06c-72a0-9d09-9e34652f2eeb' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee37a-244c-72c6-82e3-6ef6c8f43b3e' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee379-4c93-70e4-a2de-43044a0178db' ), 14.38868522644 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eaf88-814c-714f-adef-2fe2bffab63b' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eafdd-7b0f-725a-bf94-194c4b0544ab' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eafdf-c4c7-7188-8b40-83c2fc255d16' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eafb9-9f11-717a-9c02-9ac11edc2dc3' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eafbe-f4ed-727b-ad72-680aa95e4ba9' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eb0a8-d497-7136-9926-e6b0f6e4c6f5' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018eb09d-9f7a-70fd-b58a-3c385e206ca2' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee423-60ab-731e-9887-5adfc3986150' ), 7.4181051254272 ), (UUID_TO_BIN ('018ebd97-c0db-730f-9030-b50877b86997' ), UUID_TO_BIN ('018ee417-3d05-730c-af8a-203fac178a46' ), 7.4181051254272 )
;
Copy
0.59 ms (12.97%)
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
"AWbE3Ea "
]
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 = 'AWbE3Ea' LIMIT 1 ;
Copy