0.83 ms (1.34%)
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 rQ”\x15 ¡í²\x05 n "
b"\x01 Žãc™¬sº¿3Ä\x01 [J~^ "
b"\x01 ްÂFBsfšFÑ·\x13 Y;@ "
b"\x01 ŽÃûô»qƒ¥XzZQ0õ™ "
b"\x01 ŽÃÉ=žq™®Ê#\x01\x12 RÙ¶ "
b"\x01 ŽÎoðor꟫[¿–ö‰\x11 "
b"\x01 ޝ‹\x14 Qr2’ êý\x02 ß:8 "
b"\x01 Ž´Šómr¸°¢&\x7F )\e v "
b"\x01 ްõmÕs\r Ÿ\x1E ÂIÌÚ›\x16 "
b"\x01 Ã,håp°¥\x07 ‰V.¯Q "
b"\x01 ŽÉ®\x07 ›sÆ“z|\x02 w—\x02 “ "
b"\x01 ŽÍè^\x0F sÁ¦}w6wDíä "
b"\x01 ŽÍéù}q7¹\x13\t ”d@Ó° "
b"\x01 ŽÍ늎rm¡®’(ªù º "
b"\x01 Íë\x14\x19 sМ\x19 Wñ<* "
b"\x01 ŽÍé8Ûs¦¤¯ TÝ\x07 û< "
b"\x01 ŽÍê‘Mq\x01 ˆÓ“ï½â¥î "
b"\x01 Žäj\v 9s™¿›\x06 žÜT¾è "
]
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 (0x018EB7F8F11672519415A1EDB205AD6E , 0x018EE36399AC73BABF33C4015B4A7E5E , 0x018EB0C2464273669A46D1B713593B40 , 0x018EC3FBF4BB7183A5587A5A5130F599 , 0x018EC3C93D9E7199AECA23011252D9B6 , 0x018ECE6FF06F72EA9FAB5BBF96F68911 , 0x018EAF8B145172329220EAFD02DF3A38 , 0x018EB48AF36D72B8B0A2267FA0291B76 , 0x018EB0F56DD5730D9F1EC249CCDA9B16 , 0x018EC32C68E570B0A59D0789562EAF51 , 0x018EC9AE079B73C6937A7C0277970293 , 0x018ECDE85E0F73C1A67D77367744EDE4 , 0x018ECDE9F97D7137B91309946440D3B0 , 0x018ECDEB8A8E726DA1AE9228AAF9A0BA , 0x018ECDEB141973D09C1957F1903C812A , 0x018ECDE938DB73A6A4AF2054DD07FB3C , 0x018ECDEA914D710188D393EFBDE2A5EE , 0x018EE46A0B397399BF9B069EDC54BEE8 );
Copy
0.68 ms (1.10%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018eb7f8-f116-7251-9415-a1edb205ad6e' ), 35.622787475586 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ee363-99ac-73ba-bf33-c4015b4a7e5e' ), 35.622787475586 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018eb0c2-4642-7366-9a46-d1b713593b40' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ec3fb-f4bb-7183-a558-7a5a5130f599' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ec3c9-3d9e-7199-aeca-23011252d9b6' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ece6f-f06f-72ea-9fab-5bbf96f68911' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018eaf8b-1451-7232-9220-eafd02df3a38' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018eb48a-f36d-72b8-b0a2-267fa0291b76' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018eb0f5-6dd5-730d-9f1e-c249ccda9b16' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ec32c-68e5-70b0-a59d-0789562eaf51' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ec9ae-079b-73c6-937a-7c0277970293' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecde8-5e0f-73c1-a67d-77367744ede4' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecde9-f97d-7137-b913-09946440d3b0' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecdeb-8a8e-726d-a1ae-9228aaf9a0ba' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecdeb-1419-73d0-9c19-57f1903c812a' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecde9-38db-73a6-a4af-2054dd07fb3c' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecdea-914d-7101-88d3-93efbde2a5ee' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ee46a-0b39-7399-bf9b-069edc54bee8' ), 7.6694507598877 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018eb7f8-f116-7251-9415-a1edb205ad6e'
),
35.622787475586
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ee363-99ac-73ba-bf33-c4015b4a7e5e'
),
35.622787475586
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018eb0c2-4642-7366-9a46-d1b713593b40'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ec3fb-f4bb-7183-a558-7a5a5130f599'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ec3c9-3d9e-7199-aeca-23011252d9b6'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ece6f-f06f-72ea-9fab-5bbf96f68911'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018eaf8b-1451-7232-9220-eafd02df3a38'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018eb48a-f36d-72b8-b0a2-267fa0291b76'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018eb0f5-6dd5-730d-9f1e-c249ccda9b16'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ec32c-68e5-70b0-a59d-0789562eaf51'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ec9ae-079b-73c6-937a-7c0277970293'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ecde8-5e0f-73c1-a67d-77367744ede4'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ecde9-f97d-7137-b913-09946440d3b0'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ecdeb-8a8e-726d-a1ae-9228aaf9a0ba'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ecdeb-1419-73d0-9c19-57f1903c812a'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ecde9-38db-73a6-a4af-2054dd07fb3c'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ecdea-914d-7101-88d3-93efbde2a5ee'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb7f9-433a-724f-aace-df95d06fd3c2'
),
UUID_TO_BIN (
'018ee46a-0b39-7399-bf9b-069edc54bee8'
),
7.6694507598877
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018eb7f8-f116-7251-9415-a1edb205ad6e' ), 35.622787475586 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ee363-99ac-73ba-bf33-c4015b4a7e5e' ), 35.622787475586 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018eb0c2-4642-7366-9a46-d1b713593b40' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ec3fb-f4bb-7183-a558-7a5a5130f599' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ec3c9-3d9e-7199-aeca-23011252d9b6' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ece6f-f06f-72ea-9fab-5bbf96f68911' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018eaf8b-1451-7232-9220-eafd02df3a38' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018eb48a-f36d-72b8-b0a2-267fa0291b76' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018eb0f5-6dd5-730d-9f1e-c249ccda9b16' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ec32c-68e5-70b0-a59d-0789562eaf51' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ec9ae-079b-73c6-937a-7c0277970293' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecde8-5e0f-73c1-a67d-77367744ede4' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecde9-f97d-7137-b913-09946440d3b0' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecdeb-8a8e-726d-a1ae-9228aaf9a0ba' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecdeb-1419-73d0-9c19-57f1903c812a' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecde9-38db-73a6-a4af-2054dd07fb3c' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ecdea-914d-7101-88d3-93efbde2a5ee' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb7f9-433a-724f-aace-df95d06fd3c2' ), UUID_TO_BIN ('018ee46a-0b39-7399-bf9b-069edc54bee8' ), 7.6694507598877 )
;
Copy
0.66 ms (1.06%)
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
"RCJBpHD "
]
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 = 'RCJBpHD' LIMIT 1 ;
Copy