0.88 ms (18.32%)
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 ŽÞ©ÚEpv¬Sâ´ùÁ§! "
b"\x01 µFíïrM‰Å)\x1A fô0 "
b"\x01 ޵Gd1r.¡\x1D ô°æó\x05 ¢ "
b"\x01 ޵Fcés侞Ãû·„1N "
b"\x01 ŽÞ«ÿ¨qt¼Ó¡ôÊ‹,l "
b"\x01 ŽÞ«…asê¡4\t t€Sæ¡ "
b"\x01 ŽÍà\x03 6qy‡†k+Áå8x "
b"\x01 ŽÎÁW”s\x05 •l\x1D ¨%<[Q "
b"\x01 ŽÎÀF}r¤—×Ôà™¤úÐ "
b"\x01 ŽÎÁ|¤s”¿[|mO\x13 †È "
b"\x01 ŽÖö'¼pý™»æ÷§„qj "
b"\x01 ޝïÅls\x0F ‚\x00 f\x02 5³–‚ "
b"\x01 ··4#qïÀÌLÌÇ„ù "
b"\x01 Ž´w\x08 Òs¦”:ª^’\x18 pZ "
b"\x01 ްò\x14 9q#„iù\x7F ÏK(Ý "
b"\x01 ´±Ï{qÙ¦%H?¾¶¹ "
b"\x01 ޵>×\x15 p\x05 ’jaµi4ŒI "
b"\x01 ŽÞšpàq œ{ë\x13 ½£E\x0E "
b"\x01 ›…YÏ«rx«\x06 g\x19 –ÂÛ\x01 "
]
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 (0x018EDEA9DA457076AC53E2B4F9C1A721 , 0x018EB546EDEF724D89C5291A6690F430 , 0x018EB5476431722EA11DF4B0E6F305A2 , 0x018EB54663E973E4BE9EC3FBB784314E , 0x018EDEABFFA87174BCD3A1F4CA8B2C6C , 0x018EDEAB856173EAA13409748053E6A1 , 0x018ECDE00336717987866B2BC1E53878 , 0x018ECEC157947305956C1DA8253C5B51 , 0x018ECEC0467D72A497D7D4E099A4FAD0 , 0x018ECEC17CA47394BF5B7C6D4F1386C8 , 0x018ED6F627BC70FD99BBE6F7A784716A , 0x018EAFEFC56C730F8200660235B39682 , 0x018EB7B7342371EF9DC0CC4CCCC784F9 , 0x018EB47708D273A6943AAA5E9218705A , 0x018EB0F2143971238469F97FCF4B28DD , 0x018EB4B1CF7B71D9A62548903FBEB6B9 , 0x018EB53ED7157005926A61B569348C49 , 0x018EDE9A70E071209C7BEB13BDA3450E , 0x019B8559CFAB7278AB06671996C2DB01 );
Copy
0.54 ms (11.34%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018edea9-da45-7076-ac53-e2b4f9c1a721' ), 38.513275146484 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb546-edef-724d-89c5-291a6690f430' ), 30.557888031006 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb547-6431-722e-a11d-f4b0e6f305a2' ), 30.557888031006 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb546-63e9-73e4-be9e-c3fbb784314e' ), 30.557888031006 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018edeab-ffa8-7174-bcd3-a1f4ca8b2c6c' ), 30.557888031006 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018edeab-8561-73ea-a134-09748053e6a1' ), 30.557888031006 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ecde0-0336-7179-8786-6b2bc1e53878' ), 13.986110687256 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ecec1-5794-7305-956c-1da8253c5b51' ), 13.986110687256 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ecec0-467d-72a4-97d7-d4e099a4fad0' ), 13.986110687256 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ecec1-7ca4-7394-bf5b-7c6d4f1386c8' ), 13.986110687256 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ed6f6-27bc-70fd-99bb-e6f7a784716a' ), 13.986110687256 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eafef-c56c-730f-8200-660235b39682' ), 10.539752960205 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb7b7-3423-71ef-9dc0-cc4cccc784f9' ), 10.539752960205 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb477-08d2-73a6-943a-aa5e9218705a' ), 7.95538854599 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb0f2-1439-7123-8469-f97fcf4b28dd' ), 7.95538854599 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb4b1-cf7b-71d9-a625-48903fbeb6b9' ), 7.95538854599 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb53e-d715-7005-926a-61b569348c49' ), 7.95538854599 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ede9a-70e0-7120-9c7b-eb13bda3450e' ), 7.95538854599 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('019b8559-cfab-7278-ab06-671996c2db01' ), 7.95538854599 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018edea9-da45-7076-ac53-e2b4f9c1a721'
),
38.513275146484
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018eb546-edef-724d-89c5-291a6690f430'
),
30.557888031006
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018eb547-6431-722e-a11d-f4b0e6f305a2'
),
30.557888031006
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018eb546-63e9-73e4-be9e-c3fbb784314e'
),
30.557888031006
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018edeab-ffa8-7174-bcd3-a1f4ca8b2c6c'
),
30.557888031006
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018edeab-8561-73ea-a134-09748053e6a1'
),
30.557888031006
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018ecde0-0336-7179-8786-6b2bc1e53878'
),
13.986110687256
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018ecec1-5794-7305-956c-1da8253c5b51'
),
13.986110687256
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018ecec0-467d-72a4-97d7-d4e099a4fad0'
),
13.986110687256
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018ecec1-7ca4-7394-bf5b-7c6d4f1386c8'
),
13.986110687256
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018ed6f6-27bc-70fd-99bb-e6f7a784716a'
),
13.986110687256
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018eafef-c56c-730f-8200-660235b39682'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018eb7b7-3423-71ef-9dc0-cc4cccc784f9'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018eb477-08d2-73a6-943a-aa5e9218705a'
),
7.95538854599
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018eb0f2-1439-7123-8469-f97fcf4b28dd'
),
7.95538854599
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018eb4b1-cf7b-71d9-a625-48903fbeb6b9'
),
7.95538854599
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018eb53e-d715-7005-926a-61b569348c49'
),
7.95538854599
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'018ede9a-70e0-7120-9c7b-eb13bda3450e'
),
7.95538854599
),
(
UUID_TO_BIN (
'018eb546-0e9c-706f-83e6-55109888fe95'
),
UUID_TO_BIN (
'019b8559-cfab-7278-ab06-671996c2db01'
),
7.95538854599
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018edea9-da45-7076-ac53-e2b4f9c1a721' ), 38.513275146484 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb546-edef-724d-89c5-291a6690f430' ), 30.557888031006 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb547-6431-722e-a11d-f4b0e6f305a2' ), 30.557888031006 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb546-63e9-73e4-be9e-c3fbb784314e' ), 30.557888031006 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018edeab-ffa8-7174-bcd3-a1f4ca8b2c6c' ), 30.557888031006 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018edeab-8561-73ea-a134-09748053e6a1' ), 30.557888031006 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ecde0-0336-7179-8786-6b2bc1e53878' ), 13.986110687256 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ecec1-5794-7305-956c-1da8253c5b51' ), 13.986110687256 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ecec0-467d-72a4-97d7-d4e099a4fad0' ), 13.986110687256 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ecec1-7ca4-7394-bf5b-7c6d4f1386c8' ), 13.986110687256 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ed6f6-27bc-70fd-99bb-e6f7a784716a' ), 13.986110687256 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eafef-c56c-730f-8200-660235b39682' ), 10.539752960205 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb7b7-3423-71ef-9dc0-cc4cccc784f9' ), 10.539752960205 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb477-08d2-73a6-943a-aa5e9218705a' ), 7.95538854599 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb0f2-1439-7123-8469-f97fcf4b28dd' ), 7.95538854599 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb4b1-cf7b-71d9-a625-48903fbeb6b9' ), 7.95538854599 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018eb53e-d715-7005-926a-61b569348c49' ), 7.95538854599 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('018ede9a-70e0-7120-9c7b-eb13bda3450e' ), 7.95538854599 ), (UUID_TO_BIN ('018eb546-0e9c-706f-83e6-55109888fe95' ), UUID_TO_BIN ('019b8559-cfab-7278-ab06-671996c2db01' ), 7.95538854599 )
;
Copy
0.48 ms (10.07%)
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
"pxtfj1D "
]
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 = 'pxtfj1D' LIMIT 1 ;
Copy