1.00 ms (17.98%)
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 ŽÖõàrs\x1D Œ%n¥'…\x1F ® "
b"\x01 µ\x07 ƒ"qµ\t\x10 À0Zr8 "
b"\x01 µ\x06 ær쪊M¼2Ž“\x12 "
b"\x01 Ž×Øyks'¯VÒúóÕH| "
b"\x01 Ž×Ø\Àpw…±\x14 ¿ÎÆfB "
b"\x01 ŽÞ;\x0E rs7”ÐÏþ83ß\n "
b"\x01 רŽ~p*‰}Û·"\x11\x10\x00 "
b"\x01 Ž×ØÊ¹q\x0E >—¶IÏXm "
b"\x01 ްÐðGr\x0F ®tC\x1A 8œ‹ "
b"\x01 ŽÈìMäp0‹$øÉ ûj” "
b"\x01 ŽÈå‰Os^´\e ô9BlÞ¿ "
b"\x01 ް\x7F\x03 ¨p{‹Ñs•í®ëc "
b"\x01 ްîqðq¸·\x04 îXyÊ\x1F ã "
b"\x01 °Ï®Dp#Œ\x17\x01 ߎî”ó "
b"\x01 ޽ôÛýpÝŒW°D~×ú^ "
b"\x01 Ž·û\r þr“¶\x19 ‡¿³s3| "
b"\x01 ŽãcË\x19 r\x16 ”÷P$\x01 ú\x04 » "
b"\x01 °räTr{¼õý–.£¥ "
b"\x01 ްróÓss°¶ÞO²Ü\x06 Ë "
b"\x01 °s\x01 ?p‹‡}Ä,¶lÙ "
]
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 (0x018ED6F5E072731D8C256EA527851FAE , 0x018EB507832271B59D0910C0305A7238 , 0x018EB506E6AD72ECAA8A4DBC328D9312 , 0x018ED7D8796B7327AF56D2FAF3D5487C , 0x018ED7D85CC0707785B114BFCEC66642 , 0x018EDE3B0E72733794D0CFFE3833DF0A , 0x018ED7D88D7E702A897DDBB722111000 , 0x018ED7D8CAB9710EA03E97B649CF586D , 0x018EB0D0F047720FAE74431A20389C8B , 0x018EC8EC4DE470308B24F8C920FB6A94 , 0x018EC8E5894F735EB41BF439426CDEBF , 0x018EB07F03A8707B8BD17395EDAEEB63 , 0x018EB0EE71F071B8B704EE5879CA1FE3 , 0x018EB0CFAE4470238C1701DF8DEE94F3 , 0x018EBDF4DBFD70DD8C57B0447ED7FA5E , 0x018EB7FB0DFE7293B61987BFB373337C , 0x018EE363CB19721694F7502401FA04BB , 0x018EB072E454727BBCF5FD96902EA3A5 , 0x018EB072F3D37373B0B6DE4FB2DC06CB , 0x018EB073013F708B877DC42CB6816CD9 );
Copy
0.84 ms (14.99%)
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
"3jKLJK9 "
]
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 = '3jKLJK9' LIMIT 1 ;
Copy
0.75 ms (13.50%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ed6f5-e072-731d-8c25-6ea527851fae' ), 37.670860290527 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb507-8322-71b5-9d09-10c0305a7238' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb506-e6ad-72ec-aa8a-4dbc328d9312' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ed7d8-796b-7327-af56-d2faf3d5487c' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ed7d8-5cc0-7077-85b1-14bfcec66642' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ede3b-0e72-7337-94d0-cffe3833df0a' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ed7d8-8d7e-702a-897d-dbb722111000' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ed7d8-cab9-710e-a03e-97b649cf586d' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb0d0-f047-720f-ae74-431a20389c8b' ), 11.714120864868 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ec8ec-4de4-7030-8b24-f8c920fb6a94' ), 10.539752960205 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ec8e5-894f-735e-b41b-f439426cdebf' ), 10.539752960205 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb07f-03a8-707b-8bd1-7395edaeeb63' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb0ee-71f0-71b8-b704-ee5879ca1fe3' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb0cf-ae44-7023-8c17-01df8dee94f3' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ebdf4-dbfd-70dd-8c57-b0447ed7fa5e' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb7fb-0dfe-7293-b619-87bfb373337c' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ee363-cb19-7216-94f7-502401fa04bb' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb072-e454-727b-bcf5-fd96902ea3a5' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb073-013f-708b-877d-c42cb6816cd9' ), 6.9930553436279 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018ed6f5-e072-731d-8c25-6ea527851fae'
),
37.670860290527
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018eb507-8322-71b5-9d09-10c0305a7238'
),
30.001407623291
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018eb506-e6ad-72ec-aa8a-4dbc328d9312'
),
30.001407623291
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018ed7d8-796b-7327-af56-d2faf3d5487c'
),
30.001407623291
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018ed7d8-5cc0-7077-85b1-14bfcec66642'
),
30.001407623291
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018ede3b-0e72-7337-94d0-cffe3833df0a'
),
30.001407623291
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018ed7d8-8d7e-702a-897d-dbb722111000'
),
30.001407623291
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018ed7d8-cab9-710e-a03e-97b649cf586d'
),
30.001407623291
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018eb0d0-f047-720f-ae74-431a20389c8b'
),
11.714120864868
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018ec8ec-4de4-7030-8b24-f8c920fb6a94'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018ec8e5-894f-735e-b41b-f439426cdebf'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018eb07f-03a8-707b-8bd1-7395edaeeb63'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018eb0ee-71f0-71b8-b704-ee5879ca1fe3'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018eb0cf-ae44-7023-8c17-01df8dee94f3'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018ebdf4-dbfd-70dd-8c57-b0447ed7fa5e'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018eb7fb-0dfe-7293-b619-87bfb373337c'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018ee363-cb19-7216-94f7-502401fa04bb'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018eb072-e454-727b-bcf5-fd96902ea3a5'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018eb072-f3d3-7373-b0b6-de4fb2dc06cb'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb507-18b9-71e8-b318-7bfc3ebe4306'
),
UUID_TO_BIN (
'018eb073-013f-708b-877d-c42cb6816cd9'
),
6.9930553436279
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ed6f5-e072-731d-8c25-6ea527851fae' ), 37.670860290527 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb507-8322-71b5-9d09-10c0305a7238' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb506-e6ad-72ec-aa8a-4dbc328d9312' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ed7d8-796b-7327-af56-d2faf3d5487c' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ed7d8-5cc0-7077-85b1-14bfcec66642' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ede3b-0e72-7337-94d0-cffe3833df0a' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ed7d8-8d7e-702a-897d-dbb722111000' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ed7d8-cab9-710e-a03e-97b649cf586d' ), 30.001407623291 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb0d0-f047-720f-ae74-431a20389c8b' ), 11.714120864868 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ec8ec-4de4-7030-8b24-f8c920fb6a94' ), 10.539752960205 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ec8e5-894f-735e-b41b-f439426cdebf' ), 10.539752960205 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb07f-03a8-707b-8bd1-7395edaeeb63' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb0ee-71f0-71b8-b704-ee5879ca1fe3' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb0cf-ae44-7023-8c17-01df8dee94f3' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ebdf4-dbfd-70dd-8c57-b0447ed7fa5e' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb7fb-0dfe-7293-b619-87bfb373337c' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018ee363-cb19-7216-94f7-502401fa04bb' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb072-e454-727b-bcf5-fd96902ea3a5' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb072-f3d3-7373-b0b6-de4fb2dc06cb' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb507-18b9-71e8-b318-7bfc3ebe4306' ), UUID_TO_BIN ('018eb073-013f-708b-877d-c42cb6816cd9' ), 6.9930553436279 )
;
Copy