0.94 ms (18.94%)
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 ްÛTÃp\x10 ‰~O@]¿`“ "
b"\x01 ްÛ\x01 ¦p\x1D ’é\x7F\x1F LDÇd "
b"\x01 ްÛíÅp ˜\RÊl6\x11 + "
b"\x01 ްÛ%&r“¢:\x1A ³\t\v t® "
b"\x01 Ž°Û¹\x10 q\x00 ´%SLy\I¤ "
b"\x01 °Ü\x10 šr·«ìw»™•M "
b"\x01 Ž¯Ô½\x0E sÂ\ºµ„A¾E "
b"""
\x01 ޝÕ\t Rp¾²<\n
CÚúGî
"""
b"\x01 ޝÔÕŸqý†\x11 Î\x08 Èäç7 "
b"\x01 ޝÔì$r¦¢œsØ,ÜHÛ "
b"\x01 ޝÕ\x1A ¶pß—°¹ḴGo "
b"\x01 ›F›éVst–ì\t ,z—ˆ\x05 "
b"\x01 ŽÉZ\x12 mr’¶úŒsFƒKi "
b"\x01 ŽÎd|µs@’±`q;9ÃÙ "
b"\x01 ŽÎcJ4r˜™\ä¼™\x1E wú "
b"\x01 °<ðústŽ’\x17 Ð[› \x05 "
b"\x01 ·´Ñq›ºì£œ€XuË "
b"""
\x01 Ž·µŠésVž˜C\n
mšÂ”
"""
b"\x01 Ž·µæWqd•Ùĉ_ŠZŠ "
b"\x01 ·´mrä„Ò• r\x11 à "
b"\x01 ·µ\x1C §qH·zDt†Ýë "
b"\x01 Ž·´\x07 NrȡӜEå×%p "
]
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 (0x018EB0DB54C37010897E4F405DBF6093 , 0x018EB0DB01A6701D92E97F1F4C44C764 , 0x018EB0DBEDC57020985C52CA6C36112B , 0x018EB0DB25267293A23A1AB3090B74AE , 0x018EB0DBB9107100B425534C795C49A4 , 0x018EB0DC109A72B7ABEC778FBB99954D , 0x018EAFD4BD0E73C2AD5CBAB58441BE45 , 0x018EAFD5095270BEB23C0A43DAFA47EE , 0x018EAFD4D59F71FD8611CE08C8E4E737 , 0x018EAFD4EC2472A6A29C73D82CDC48DB , 0x018EAFD51AB670DF97B0B94BCCB1476F , 0x019B469BE956737496EC092C7A978805 , 0x018EC95A126D7292B6FA8C7346834B69 , 0x018ECE647CB5734092B160713B39C3D9 , 0x018ECE634A347298995CE4BC991E77FA , 0x018EB03CF0FA73748D9217D05B9B2005 , 0x018EB7B4D19D719BBAECA39C805875CB , 0x018EB7B58AE973569E98430A6D9AC294 , 0x018EB7B5E657716495D9C4895F8A5A8A , 0x018EB7B46D9D72E484D295A072119FE0 , 0x018EB7B51CA77148B77A44748681DDEB , 0x018EB7B4074E72C8A1D39C45E5D72570 );
Copy
0.76 ms (15.35%)
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
"IXefLED "
]
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 = 'IXefLED' LIMIT 1 ;
Copy
0.73 ms (14.77%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0db-54c3-7010-897e-4f405dbf6093' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0db-01a6-701d-92e9-7f1f4c44c764' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0db-edc5-7020-985c-52ca6c36112b' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0db-2526-7293-a23a-1ab3090b74ae' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0db-b910-7100-b425-534c795c49a4' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0dc-109a-72b7-abec-778fbb99954d' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eafd4-bd0e-73c2-ad5c-bab58441be45' ), 13.803466796875 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eafd5-0952-70be-b23c-0a43dafa47ee' ), 13.803466796875 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eafd4-d59f-71fd-8611-ce08c8e4e737' ), 13.803466796875 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eafd4-ec24-72a6-a29c-73d82cdc48db' ), 13.803466796875 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eafd5-1ab6-70df-97b0-b94bccb1476f' ), 13.803466796875 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('019b469b-e956-7374-96ec-092c7a978805' ), 11.714120864868 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018ec95a-126d-7292-b6fa-8c7346834b69' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018ece64-7cb5-7340-92b1-60713b39c3d9' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018ece63-4a34-7298-995c-e4bc991e77fa' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb03c-f0fa-7374-8d92-17d05b9b2005' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b4-d19d-719b-baec-a39c805875cb' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b5-8ae9-7356-9e98-430a6d9ac294' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b5-e657-7164-95d9-c4895f8a5a8a' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b4-6d9d-72e4-84d2-95a072119fe0' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b5-1ca7-7148-b77a-44748681ddeb' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b4-074e-72c8-a1d3-9c45e5d72570' ), 6.8104114532471 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb0db-54c3-7010-897e-4f405dbf6093'
),
62.043319702148
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb0db-01a6-701d-92e9-7f1f4c44c764'
),
62.043319702148
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb0db-edc5-7020-985c-52ca6c36112b'
),
62.043319702148
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb0db-2526-7293-a23a-1ab3090b74ae'
),
62.043319702148
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb0db-b910-7100-b425-534c795c49a4'
),
62.043319702148
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb0dc-109a-72b7-abec-778fbb99954d'
),
62.043319702148
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eafd4-bd0e-73c2-ad5c-bab58441be45'
),
13.803466796875
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eafd5-0952-70be-b23c-0a43dafa47ee'
),
13.803466796875
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eafd4-d59f-71fd-8611-ce08c8e4e737'
),
13.803466796875
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eafd4-ec24-72a6-a29c-73d82cdc48db'
),
13.803466796875
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eafd5-1ab6-70df-97b0-b94bccb1476f'
),
13.803466796875
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'019b469b-e956-7374-96ec-092c7a978805'
),
11.714120864868
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018ec95a-126d-7292-b6fa-8c7346834b69'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018ece64-7cb5-7340-92b1-60713b39c3d9'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018ece63-4a34-7298-995c-e4bc991e77fa'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb03c-f0fa-7374-8d92-17d05b9b2005'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb7b4-d19d-719b-baec-a39c805875cb'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb7b5-8ae9-7356-9e98-430a6d9ac294'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb7b5-e657-7164-95d9-c4895f8a5a8a'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb7b4-6d9d-72e4-84d2-95a072119fe0'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb7b5-1ca7-7148-b77a-44748681ddeb'
),
6.8104114532471
),
(
UUID_TO_BIN (
'018eb0dc-564d-7317-902d-17c01ec8f347'
),
UUID_TO_BIN (
'018eb7b4-074e-72c8-a1d3-9c45e5d72570'
),
6.8104114532471
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0db-54c3-7010-897e-4f405dbf6093' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0db-01a6-701d-92e9-7f1f4c44c764' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0db-edc5-7020-985c-52ca6c36112b' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0db-2526-7293-a23a-1ab3090b74ae' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0db-b910-7100-b425-534c795c49a4' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb0dc-109a-72b7-abec-778fbb99954d' ), 62.043319702148 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eafd4-bd0e-73c2-ad5c-bab58441be45' ), 13.803466796875 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eafd5-0952-70be-b23c-0a43dafa47ee' ), 13.803466796875 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eafd4-d59f-71fd-8611-ce08c8e4e737' ), 13.803466796875 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eafd4-ec24-72a6-a29c-73d82cdc48db' ), 13.803466796875 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eafd5-1ab6-70df-97b0-b94bccb1476f' ), 13.803466796875 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('019b469b-e956-7374-96ec-092c7a978805' ), 11.714120864868 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018ec95a-126d-7292-b6fa-8c7346834b69' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018ece64-7cb5-7340-92b1-60713b39c3d9' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018ece63-4a34-7298-995c-e4bc991e77fa' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb03c-f0fa-7374-8d92-17d05b9b2005' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b4-d19d-719b-baec-a39c805875cb' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b5-8ae9-7356-9e98-430a6d9ac294' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b5-e657-7164-95d9-c4895f8a5a8a' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b4-6d9d-72e4-84d2-95a072119fe0' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b5-1ca7-7148-b77a-44748681ddeb' ), 6.8104114532471 ), (UUID_TO_BIN ('018eb0dc-564d-7317-902d-17c01ec8f347' ), UUID_TO_BIN ('018eb7b4-074e-72c8-a1d3-9c45e5d72570' ), 6.8104114532471 )
;
Copy