1.06 ms (21.64%)
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 ŽÞslãqª“%Áç…\x7F ò1 "
b"\x01 ŽÞt~–qì®\x0E\x02 &—‘ªð "
b"\x01 ŽÞs"Cp¥¨8üÅ—'Ó\x06 "
b"\x01 ޵$\x02\x17 pë¼U¾Eà³£w "
b"\x01 ޵$E¤rÜ“TÙ\x19\x0F 9^Õ "
b"\x01 ޵#˜*qÊ¡2\x07 'V0Ö¾ "
b"\x01 µ$SrÖ¥XKQdôˆ "
b"\x01 ŽÞtÄ)sä˜ÓƒÁÎ´ìª "
b"\x01 ŽÞsÓ„p …1÷‰œk!+ "
b"\x01 ް\x02 [lqµ™{2žS5«“ "
b"\x01 ޝ³\x01\x1E p\x18 ¨áh\x03 Ö$ÉN "
b"\x01 ޝª÷ qR€\x15 T\x7F }Çï5 "
b"\x01 ¯«3æp\x17 ÌŒâ\x04 vës "
b"\x01 ޝÛQNs‘•a\x7F û¹Ì…\x01 "
b"\x01 ޝâ\x16 apù£¦î[kÓª5 "
b"\x01 ް\x1C ÝÌrQ‚x_¯i¨\x0E\x7F "
b"""
\x01 ް?\x1D \n
rn±jÛȹBf\x15
"""
b"\x01 ް\x08 º%qU¨2?Å \x1C ý¨ "
b"\x01 Ž´ ¸%rCœ>Z\x10 ]¿… "
b"\x01 Ž·ÃI÷q׫8\e LùÄØi "
b"\x01 ޽Q¥ìp¹¹\x03 Y\x19 kÑ\x06\x06 "
b"\x01 ŽÞ¼úëp-˜ã:DÎÌ\x1C ¾ "
]
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 (0x018EDE736CE371AA9325C1E7857FF231 , 0x018EDE747E9671ECAE0E02269791AAF0 , 0x018EDE73224370A5A838FCC59727D306 , 0x018EB524021770EBBC55BE45E0B3A377 , 0x018EB52445A472DC9354D9190F395ED5 , 0x018EB523982A71CAA13207275630D6BE , 0x018EB5248F5372D6A5584B518164F488 , 0x018EDE74C42973E498D383C1CEB4ECAA , 0x018EDE73D38470A08531F7899C6B212B , 0x018EB0025B6C71B5997B329E5335AB93 , 0x018EAFB3011E7018A8E16803D624C94E , 0x018EAFAAF7A071528015547F7DC7EF35 , 0x018EAFAB33E6701790CC8CE20476EB73 , 0x018EAFDB514E739195617FFBB9CC8501 , 0x018EAFE2166170F9A3A6EE5B6BD3AA35 , 0x018EB01CDDCC725182785FAF69A80E7F , 0x018EB03F1D0A726EB16ADBC8B9426615 , 0x018EB008BA257155A8323FC5A01CFDA8 , 0x018EB4A0B82572439CAD3E5A105DBF85 , 0x018EB7C349F771D7AB381B4CF9C4D869 , 0x018EBD51A5EC70B9B90359196BD10606 , 0x018EDEBCFAEB702D98E33A44CECC1CBE );
Copy
0.72 ms (14.74%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ede73-6ce3-71aa-9325-c1e7857ff231' ), 31.99845123291 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ede74-7e96-71ec-ae0e-02269791aaf0' ), 31.99845123291 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), 31.99845123291 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb524-0217-70eb-bc55-be45e0b3a377' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb524-45a4-72dc-9354-d9190f395ed5' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb523-982a-71ca-a132-07275630d6be' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb524-8f53-72d6-a558-4b518164f488' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ede74-c429-73e4-98d3-83c1ceb4ecaa' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ede73-d384-70a0-8531-f7899c6b212b' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb002-5b6c-71b5-997b-329e5335ab93' ), 13.28692817688 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eafb3-011e-7018-a8e1-6803d624c94e' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eafaa-f7a0-7152-8015-547f7dc7ef35' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eafab-33e6-7017-90cc-8ce20476eb73' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eafdb-514e-7391-9561-7ffbb9cc8501' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eafe2-1661-70f9-a3a6-ee5b6bd3aa35' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb01c-ddcc-7251-8278-5faf69a80e7f' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb03f-1d0a-726e-b16a-dbc8b9426615' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb008-ba25-7155-a832-3fc5a01cfda8' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb4a0-b825-7243-9cad-3e5a105dbf85' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb7c3-49f7-71d7-ab38-1b4cf9c4d869' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ebd51-a5ec-70b9-b903-59196bd10606' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018edebc-faeb-702d-98e3-3a44cecc1cbe' ), 6.6434640884399 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018ede73-6ce3-71aa-9325-c1e7857ff231'
),
31.99845123291
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018ede74-7e96-71ec-ae0e-02269791aaf0'
),
31.99845123291
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
31.99845123291
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eb524-0217-70eb-bc55-be45e0b3a377'
),
22.254314422607
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eb524-45a4-72dc-9354-d9190f395ed5'
),
22.254314422607
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eb523-982a-71ca-a132-07275630d6be'
),
22.254314422607
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eb524-8f53-72d6-a558-4b518164f488'
),
22.254314422607
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018ede74-c429-73e4-98d3-83c1ceb4ecaa'
),
22.254314422607
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018ede73-d384-70a0-8531-f7899c6b212b'
),
22.254314422607
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eb002-5b6c-71b5-997b-329e5335ab93'
),
13.28692817688
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eafb3-011e-7018-a8e1-6803d624c94e'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eafaa-f7a0-7152-8015-547f7dc7ef35'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eafab-33e6-7017-90cc-8ce20476eb73'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eafdb-514e-7391-9561-7ffbb9cc8501'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eafe2-1661-70f9-a3a6-ee5b6bd3aa35'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eb01c-ddcc-7251-8278-5faf69a80e7f'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eb03f-1d0a-726e-b16a-dbc8b9426615'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eb008-ba25-7155-a832-3fc5a01cfda8'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eb4a0-b825-7243-9cad-3e5a105dbf85'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018eb7c3-49f7-71d7-ab38-1b4cf9c4d869'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018ebd51-a5ec-70b9-b903-59196bd10606'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
UUID_TO_BIN (
'018edebc-faeb-702d-98e3-3a44cecc1cbe'
),
6.6434640884399
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ede73-6ce3-71aa-9325-c1e7857ff231' ), 31.99845123291 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ede74-7e96-71ec-ae0e-02269791aaf0' ), 31.99845123291 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), 31.99845123291 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb524-0217-70eb-bc55-be45e0b3a377' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb524-45a4-72dc-9354-d9190f395ed5' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb523-982a-71ca-a132-07275630d6be' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb524-8f53-72d6-a558-4b518164f488' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ede74-c429-73e4-98d3-83c1ceb4ecaa' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ede73-d384-70a0-8531-f7899c6b212b' ), 22.254314422607 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb002-5b6c-71b5-997b-329e5335ab93' ), 13.28692817688 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eafb3-011e-7018-a8e1-6803d624c94e' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eafaa-f7a0-7152-8015-547f7dc7ef35' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eafab-33e6-7017-90cc-8ce20476eb73' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eafdb-514e-7391-9561-7ffbb9cc8501' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eafe2-1661-70f9-a3a6-ee5b6bd3aa35' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb01c-ddcc-7251-8278-5faf69a80e7f' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb03f-1d0a-726e-b16a-dbc8b9426615' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb008-ba25-7155-a832-3fc5a01cfda8' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb4a0-b825-7243-9cad-3e5a105dbf85' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018eb7c3-49f7-71d7-ab38-1b4cf9c4d869' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018ebd51-a5ec-70b9-b903-59196bd10606' ), 6.6434640884399 ), (UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), UUID_TO_BIN ('018edebc-faeb-702d-98e3-3a44cecc1cbe' ), 6.6434640884399 )
;
Copy
0.59 ms (12.13%)
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
"FUpJU9U "
]
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 = 'FUpJU9U' LIMIT 1 ;
Copy