0.90 ms (17.76%)
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 ޝ«Ê\x16 p뻕 ³H¨h‹ "
b"\x01 ޝé+|r\x00 žž{|¦o\x11 ý "
b"\x01 ޝéø\r q®˜8fõè|\x14\x12 "
b"\x01 ޝépEq©µö\x11 õÿ¯t "
b"\x01 ¯ê%\x15 r‚ðÚ_‚7LÇ "
b"\x01 ޝé\x15 ðpdŒ\x01 ²x”m\õ "
b"\x01 ¯è»qozÛj[äÉ "
b"\x01 ޝéž,q9…äJ\x1C ì nP "
b"\x01 ޝéáÅplŽ‚û0h¤Ùý "
b"\x01 ޝéÇLr›·²Ü<<t¾\x05 "
b"\x01 ޝèœOpß¾Ëö¦o»• "
b"\x01 ¯èèÆrœ·K&zðã\x15 "
b"\x01 ޝé°\x10 rÜ›ê«>¢Ê5\e "
b"\x01 ¯èÍ1p姈\x12 ¼‡MŠ "
b"\x01 ޝéAøqqŒTHh\e x\x03 ð "
b"\x01 ޝéZþq˜´,C''õ:\t "
b"\x01 ޝê\f ±pƩ۱³£\x12 kE "
b"\x01 ޝèþŒpª•ð;ðÊ´•¸ "
b"\x01 ŽÃPABpÉŒµ¯nÕ}©! "
b"""
\x01 ޝ¬G\x7F pù°\n
Gä_¶SÒ
"""
b"\x01 ¯«ß1qÒŽ4Ñõ!Ë& "
b"""
\x01 ްðK\n
rÑ€¾K\x19\x19\x07 gg
"""
]
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 (0x018EAFABCA1670EBBB95A0B348A8688B , 0x018EAFE92B7C72009E9E7B7CA66F11FD , 0x018EAFE9F80D71AE983866F5E87C1412 , 0x018EAFE9704571C2A9B5F611F5FFAF74 , 0x018EAFEA2515728290F0DA5F82374CC7 , 0x018EAFE915F070648C01B278946D5CF5 , 0x018EAFE8BB9D716F817ADB6A9D5BE4C9 , 0x018EAFE99E2C713985E44A1CEC206E50 , 0x018EAFE9E1C5706C8E82FB3068A4D9FD , 0x018EAFE9C74C729BB7B2DC3C3C74BE05 , 0x018EAFE89C4F70DFBECBF6A66FBB95A0 , 0x018EAFE8E8C6729CB74B267AF0E3158F , 0x018EAFE9B01072DC9BEAAB3EA2CA351B , 0x018EAFE8CD3170E5A78812BC874D8A81 , 0x018EAFE941F871718C5448681B7803F0 , 0x018EAFE95AFE7198B42C432727F53A09 , 0x018EAFEA0CB170C6A9DBB1B3A3126B45 , 0x018EAFE8FE8C70AA95F03BF0CAB495B8 , 0x018EC350414270C98CB5AF6ED57DA921 , 0x018EAFAC477F70F9B00A47E45FB653D2 , 0x018EAFABDF3171D28D34D1F521CB2681 , 0x018EB0F04B0A72D180BE4B1919076767 );
Copy
0.79 ms (15.54%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafab-ca16-70eb-bb95-a0b348a8688b' ), 41.429439544678 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-2b7c-7200-9e9e-7b7ca66f11fd' ), 28.807983398438 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-f80d-71ae-9838-66f5e87c1412' ), 20.522096633911 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-7045-71c2-a9b5-f611f5ffaf74' ), 20.522096633911 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafea-2515-7282-90f0-da5f82374cc7' ), 20.522096633911 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-15f0-7064-8c01-b278946d5cf5' ), 20.522096633911 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe8-bb9d-716f-817a-db6a9d5be4c9' ), 20.13219833374 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-9e2c-7139-85e4-4a1cec206e50' ), 20.13219833374 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-e1c5-706c-8e82-fb3068a4d9fd' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-c74c-729b-b7b2-dc3c3c74be05' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe8-9c4f-70df-becb-f6a66fbb95a0' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe8-e8c6-729c-b74b-267af0e3158f' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-b010-72dc-9bea-ab3ea2ca351b' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe8-cd31-70e5-a788-12bc874d8a81' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-41f8-7171-8c54-48681b7803f0' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-5afe-7198-b42c-432727f53a09' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafea-0cb1-70c6-a9db-b1b3a3126b45' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe8-fe8c-70aa-95f0-3bf0cab495b8' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018ec350-4142-70c9-8cb5-af6ed57da921' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafac-477f-70f9-b00a-47e45fb653d2' ), 8.2858877182007 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafab-df31-71d2-8d34-d1f521cb2681' ), 8.2858877182007 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eb0f0-4b0a-72d1-80be-4b1919076767' ), 5.8689413070679 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafab-ca16-70eb-bb95-a0b348a8688b'
),
41.429439544678
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe9-2b7c-7200-9e9e-7b7ca66f11fd'
),
28.807983398438
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe9-f80d-71ae-9838-66f5e87c1412'
),
20.522096633911
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe9-7045-71c2-a9b5-f611f5ffaf74'
),
20.522096633911
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafea-2515-7282-90f0-da5f82374cc7'
),
20.522096633911
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe9-15f0-7064-8c01-b278946d5cf5'
),
20.522096633911
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe8-bb9d-716f-817a-db6a9d5be4c9'
),
20.13219833374
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe9-9e2c-7139-85e4-4a1cec206e50'
),
20.13219833374
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe9-e1c5-706c-8e82-fb3068a4d9fd'
),
11.846311569214
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe9-c74c-729b-b7b2-dc3c3c74be05'
),
11.846311569214
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe8-9c4f-70df-becb-f6a66fbb95a0'
),
11.846311569214
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe8-e8c6-729c-b74b-267af0e3158f'
),
11.846311569214
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe9-b010-72dc-9bea-ab3ea2ca351b'
),
11.846311569214
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe8-cd31-70e5-a788-12bc874d8a81'
),
11.846311569214
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe9-41f8-7171-8c54-48681b7803f0'
),
11.846311569214
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe9-5afe-7198-b42c-432727f53a09'
),
11.846311569214
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafea-0cb1-70c6-a9db-b1b3a3126b45'
),
11.846311569214
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafe8-fe8c-70aa-95f0-3bf0cab495b8'
),
11.846311569214
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018ec350-4142-70c9-8cb5-af6ed57da921'
),
11.846311569214
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafac-477f-70f9-b00a-47e45fb653d2'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eafab-df31-71d2-8d34-d1f521cb2681'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eafe9-86bb-72c1-9909-7a33e234b7f5'
),
UUID_TO_BIN (
'018eb0f0-4b0a-72d1-80be-4b1919076767'
),
5.8689413070679
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafab-ca16-70eb-bb95-a0b348a8688b' ), 41.429439544678 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-2b7c-7200-9e9e-7b7ca66f11fd' ), 28.807983398438 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-f80d-71ae-9838-66f5e87c1412' ), 20.522096633911 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-7045-71c2-a9b5-f611f5ffaf74' ), 20.522096633911 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafea-2515-7282-90f0-da5f82374cc7' ), 20.522096633911 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-15f0-7064-8c01-b278946d5cf5' ), 20.522096633911 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe8-bb9d-716f-817a-db6a9d5be4c9' ), 20.13219833374 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-9e2c-7139-85e4-4a1cec206e50' ), 20.13219833374 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-e1c5-706c-8e82-fb3068a4d9fd' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-c74c-729b-b7b2-dc3c3c74be05' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe8-9c4f-70df-becb-f6a66fbb95a0' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe8-e8c6-729c-b74b-267af0e3158f' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-b010-72dc-9bea-ab3ea2ca351b' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe8-cd31-70e5-a788-12bc874d8a81' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-41f8-7171-8c54-48681b7803f0' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe9-5afe-7198-b42c-432727f53a09' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafea-0cb1-70c6-a9db-b1b3a3126b45' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafe8-fe8c-70aa-95f0-3bf0cab495b8' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018ec350-4142-70c9-8cb5-af6ed57da921' ), 11.846311569214 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafac-477f-70f9-b00a-47e45fb653d2' ), 8.2858877182007 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eafab-df31-71d2-8d34-d1f521cb2681' ), 8.2858877182007 ), (UUID_TO_BIN ('018eafe9-86bb-72c1-9909-7a33e234b7f5' ), UUID_TO_BIN ('018eb0f0-4b0a-72d1-80be-4b1919076767' ), 5.8689413070679 )
;
Copy
0.67 ms (13.23%)
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
"R2BJgxY "
]
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 = 'R2BJgxY' LIMIT 1 ;
Copy