0.78 ms (19.08%)
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 ›J\x1C {Žpµ^AT\r &1 "
b"\x01 ›J\x1C t-rSÑÃ&ñpª_ "
b"\x01 ›J\x1C pjs–‹ûØ¿Ô=Ô "
b"\x01 ›J\x1C lûpý‹\x1C ÇF\x07 !\x1D\x18 "
b"\x01 ¯Ávrõ¹÷ÌÁ¯\x03 é "
b"\x01 ްw\x04\x10 sѾï9Âý\x1F jö "
b"\x01 Ž×8&Sp]’?ž|#¨]Î "
b"\x01 ޝö&Ïpê›Ö[gþîI] "
b"\x01 °r\x00 s}±«t਺?O "
b"\x01 ްqð/r\x04 £)MR\x00 ŠH\x00 "
b"\x01 ްr\x12 ~qr®!`\x1E\x1E ìÏú "
b"\x01 ްÉ\x7F ÎrÇ»¨ÇH\f 1¾× "
b"\x01 ޽mŒuq|¶§D^[–mà "
b"\x01 ·ñ\x00 $s\x16 ží”\x1E ™öí "
b"\x01 ޽œ©àrfŸÌ¡AuØF‰ "
b"\x01 ŽÃ|u-q{•.\f 0fË~Á "
b"\x01 Žãè\x1F bsñˆƒw7ÎB} "
b"\x01 Þr{Ùr[N¾9EƒQD "
b"\x01 Žã^û‹q½¼Íà)°>%» "
]
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 (0x019B4A1C7B8D70B59F9D5E41540D2631 , 0x019B4A1C742D7253ADD1C326F170AA5F , 0x019B4A1C706A73968BFBD8BFADD43DD4 , 0x019B4A1C6CFB70FD8B1CC74607211D18 , 0x018EAF90C17672F5B98EF7CCC1AF03E9 , 0x018EB077041073D1BEEF39C2FD1F6AF6 , 0x018ED7382653705D923F9E7C23A85DCE , 0x018EAFF626CF70EA9BD65B67FEEE495D , 0x018EB072009D737DB1AB74E0A8BA3F4F , 0x018EB071F02F7204A3294D52008A4800 , 0x018EB072127E7172AE21601E1EECCFFA , 0x018EB0C97FCE72C7BBA8C7480C31BED7 , 0x018EBD6D8C75717CB6A7445E5B966DC3 , 0x018EB7F1002473169EED941E99F681ED , 0x018EBD9CA9E072669FCCA14175D84689 , 0x018EC37C752D717B952E0C3066CB7EC1 , 0x018EE3E81F6273F188837737CE427DC2 , 0x018EDE727BD9725B814EBE3945835144 , 0x018EE35EFB8B71BDBCCDE029B03E25BB );
Copy
0.54 ms (13.24%)
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
"9M2BFIE "
]
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 = '9M2BFIE' LIMIT 1 ;
Copy
0.53 ms (13.02%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('019b4a1c-7b8d-70b5-9f9d-5e41540d2631' ), 33.661418914795 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('019b4a1c-742d-7253-add1-c326f170aa5f' ), 33.661418914795 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('019b4a1c-706a-7396-8bfb-d8bfadd43dd4' ), 24.512912750244 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('019b4a1c-6cfb-70fd-8b1c-c74607211d18' ), 24.512912750244 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eaf90-c176-72f5-b98e-f7ccc1af03e9' ), 18.297012329102 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb077-0410-73d1-beef-39c2fd1f6af6' ), 11.714120864868 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ed738-2653-705d-923f-9e7c23a85dce' ), 9.1485061645508 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eaff6-26cf-70ea-9bd6-5b67feee495d' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb072-009d-737d-b1ab-74e0a8ba3f4f' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb071-f02f-7204-a329-4d52008a4800' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb072-127e-7172-ae21-601e1eeccffa' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb0c9-7fce-72c7-bba8-c7480c31bed7' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ebd6d-8c75-717c-b6a7-445e5b966dc3' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb7f1-0024-7316-9eed-941e99f681ed' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ebd9c-a9e0-7266-9fcc-a14175d84689' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ec37c-752d-717b-952e-0c3066cb7ec1' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ee3e8-1f62-73f1-8883-7737ce427dc2' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ede72-7bd9-725b-814e-be3945835144' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ee35e-fb8b-71bd-bccd-e029b03e25bb' ), 6.2159013748169 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'019b4a1c-7b8d-70b5-9f9d-5e41540d2631'
),
33.661418914795
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'019b4a1c-742d-7253-add1-c326f170aa5f'
),
33.661418914795
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'019b4a1c-706a-7396-8bfb-d8bfadd43dd4'
),
24.512912750244
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'019b4a1c-6cfb-70fd-8b1c-c74607211d18'
),
24.512912750244
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018eaf90-c176-72f5-b98e-f7ccc1af03e9'
),
18.297012329102
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018eb077-0410-73d1-beef-39c2fd1f6af6'
),
11.714120864868
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018ed738-2653-705d-923f-9e7c23a85dce'
),
9.1485061645508
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018eaff6-26cf-70ea-9bd6-5b67feee495d'
),
6.2159013748169
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018eb072-009d-737d-b1ab-74e0a8ba3f4f'
),
6.2159013748169
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018eb071-f02f-7204-a329-4d52008a4800'
),
6.2159013748169
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018eb072-127e-7172-ae21-601e1eeccffa'
),
6.2159013748169
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018eb0c9-7fce-72c7-bba8-c7480c31bed7'
),
6.2159013748169
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018ebd6d-8c75-717c-b6a7-445e5b966dc3'
),
6.2159013748169
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018eb7f1-0024-7316-9eed-941e99f681ed'
),
6.2159013748169
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018ebd9c-a9e0-7266-9fcc-a14175d84689'
),
6.2159013748169
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018ec37c-752d-717b-952e-0c3066cb7ec1'
),
6.2159013748169
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018ee3e8-1f62-73f1-8883-7737ce427dc2'
),
6.2159013748169
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018ede72-7bd9-725b-814e-be3945835144'
),
6.2159013748169
),
(
UUID_TO_BIN (
'019b4a1c-7d2e-735c-91bb-ae23bfcd6164'
),
UUID_TO_BIN (
'018ee35e-fb8b-71bd-bccd-e029b03e25bb'
),
6.2159013748169
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('019b4a1c-7b8d-70b5-9f9d-5e41540d2631' ), 33.661418914795 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('019b4a1c-742d-7253-add1-c326f170aa5f' ), 33.661418914795 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('019b4a1c-706a-7396-8bfb-d8bfadd43dd4' ), 24.512912750244 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('019b4a1c-6cfb-70fd-8b1c-c74607211d18' ), 24.512912750244 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eaf90-c176-72f5-b98e-f7ccc1af03e9' ), 18.297012329102 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb077-0410-73d1-beef-39c2fd1f6af6' ), 11.714120864868 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ed738-2653-705d-923f-9e7c23a85dce' ), 9.1485061645508 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eaff6-26cf-70ea-9bd6-5b67feee495d' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb072-009d-737d-b1ab-74e0a8ba3f4f' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb071-f02f-7204-a329-4d52008a4800' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb072-127e-7172-ae21-601e1eeccffa' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb0c9-7fce-72c7-bba8-c7480c31bed7' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ebd6d-8c75-717c-b6a7-445e5b966dc3' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018eb7f1-0024-7316-9eed-941e99f681ed' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ebd9c-a9e0-7266-9fcc-a14175d84689' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ec37c-752d-717b-952e-0c3066cb7ec1' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ee3e8-1f62-73f1-8883-7737ce427dc2' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ede72-7bd9-725b-814e-be3945835144' ), 6.2159013748169 ), (UUID_TO_BIN ('019b4a1c-7d2e-735c-91bb-ae23bfcd6164' ), UUID_TO_BIN ('018ee35e-fb8b-71bd-bccd-e029b03e25bb' ), 6.2159013748169 )
;
Copy