0.77 ms (17.33%)
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 µ1/hsžÛÀ)²\x03 »t "
b"\x01 ޵1¾fpp¹÷/ì(Ê4Ç "
b"\x01 ޵2CÖqߥ@?)èd\ï "
b"\x01 ޵0Ü4qŠºÌë\x02 —Ô&K "
b"\x01 ŽÞŠ Ÿpå‹f\e ß$\x05 Q\x17 "
b"\x01 ŽÞˆ„´p•¦¸J¡^ êc "
b"\x01 ŽÞ‰€Ùpî›Ä\x01 D¾»‹÷ "
b"\x01 ŽÞŠú\x0E q\x1D ¢xsåƒp:p "
b"\x01 ŽÞ†ß§sg‹w³Ðøµ“u "
b"\x01 ŽÞ‡¥‡r\x07 ¹-ÃÔ\x1E €âU "
b"\x01 Þ‹]s(Ž€°Ê~6U\x07 "
b"\x01 Ž·ix9r}žÞ¸\f úZê "
b"\x01 Ž·i/Úr\r ª|ok6\x18 mu "
b"\x01 Ž·i´7s{·LOvÒw—¿ "
b"\x01 Ž·iï¼q”ºáöÚ01\x11 " "
b"\x01 Ž·h¶\x06 s=¸†\x07 ²»sÔ` "
b"\x01 Ž·hòæpï™ô\x03 °/¹`Ê "
b"\x01 ½ãg)r_Žâ\x18 _Å’»9 "
b"\x01 ŽÃ,¤<qÙ‘*M\x0F wÇjÕ "
b"\x01 Þ»Í,r(´[\x1A 1m\x7F … "
]
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 (0x018EB5312F68739E8FDBC029B203BB74 , 0x018EB531BE667070B9F72FEC28CA34C7 , 0x018EB53243D671DFA5403F29E8645CEF , 0x018EB530DC34718ABACCEB0297D4264B , 0x018EDE8A209F70E58B661BDF24055117 , 0x018EDE8884B47095A6B84AA15EA0EA63 , 0x018EDE8980D970EE9BC40144BEBB8BF7 , 0x018EDE8AFA0E711DA27873E583703A70 , 0x018EDE86DFA773678B77B3D0F8B59375 , 0x018EDE87A5877207B92DC3D41E80E255 , 0x018EDE8B8F5D73288D80B0CA7E365507 , 0x018EB7697839727D9EDEB80CADFA5AEA , 0x018EB7692FDA720DAA7C6F6B36186D75 , 0x018EB769B437737BB74C4F76D27797BF , 0x018EB769EFBC7194BAE1F6DA30311122 , 0x018EB768B606733DB88607B2BB73D460 , 0x018EB768F2E670EF99F403B02FB960CA , 0x018EBDE36729725F8DE2185FC592BB39 , 0x018EC32CA43C71D9912A4D0F77C76AD5 , 0x018EDEBBCD2C7228B45B901A316D7F85 );
Copy
0.69 ms (15.66%)
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
"JFrC-ya "
]
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 = 'JFrC-ya' LIMIT 1 ;
Copy
0.58 ms (13.10%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb531-2f68-739e-8fdb-c029b203bb74' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb531-be66-7070-b9f7-2fec28ca34c7' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb532-43d6-71df-a540-3f29e8645cef' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb530-dc34-718a-bacc-eb0297d4264b' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede8a-209f-70e5-8b66-1bdf24055117' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede88-84b4-7095-a6b8-4aa15ea0ea63' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede89-80d9-70ee-9bc4-0144bebb8bf7' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede8a-fa0e-711d-a278-73e583703a70' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede86-dfa7-7367-8b77-b3d0f8b59375' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede87-a587-7207-b92d-c3d41e80e255' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede8b-8f5d-7328-8d80-b0ca7e365507' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb769-7839-727d-9ede-b80cadfa5aea' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb769-2fda-720d-aa7c-6f6b36186d75' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb769-b437-737b-b74c-4f76d27797bf' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb769-efbc-7194-bae1-f6da30311122' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb768-b606-733d-b886-07b2bb73d460' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb768-f2e6-70ef-99f4-03b02fb960ca' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ebde3-6729-725f-8de2-185fc592bb39' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ec32c-a43c-71d9-912a-4d0f77c76ad5' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018edebb-cd2c-7228-b45b-901a316d7f85' ), 5.7667245864868 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018eb531-2f68-739e-8fdb-c029b203bb74'
),
12.759779930115
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018eb531-be66-7070-b9f7-2fec28ca34c7'
),
12.759779930115
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018eb532-43d6-71df-a540-3f29e8645cef'
),
12.759779930115
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018eb530-dc34-718a-bacc-eb0297d4264b'
),
12.759779930115
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018ede8a-209f-70e5-8b66-1bdf24055117'
),
12.759779930115
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018ede88-84b4-7095-a6b8-4aa15ea0ea63'
),
12.759779930115
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018ede89-80d9-70ee-9bc4-0144bebb8bf7'
),
12.759779930115
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018ede8a-fa0e-711d-a278-73e583703a70'
),
12.759779930115
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018ede86-dfa7-7367-8b77-b3d0f8b59375'
),
12.759779930115
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018ede87-a587-7207-b92d-c3d41e80e255'
),
12.759779930115
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018ede8b-8f5d-7328-8d80-b0ca7e365507'
),
12.759779930115
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018eb769-7839-727d-9ede-b80cadfa5aea'
),
5.7667245864868
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018eb769-2fda-720d-aa7c-6f6b36186d75'
),
5.7667245864868
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018eb769-b437-737b-b74c-4f76d27797bf'
),
5.7667245864868
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018eb769-efbc-7194-bae1-f6da30311122'
),
5.7667245864868
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018eb768-b606-733d-b886-07b2bb73d460'
),
5.7667245864868
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018eb768-f2e6-70ef-99f4-03b02fb960ca'
),
5.7667245864868
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018ebde3-6729-725f-8de2-185fc592bb39'
),
5.7667245864868
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018ec32c-a43c-71d9-912a-4d0f77c76ad5'
),
5.7667245864868
),
(
UUID_TO_BIN (
'018ede86-849a-707e-bcc7-7261675f794a'
),
UUID_TO_BIN (
'018edebb-cd2c-7228-b45b-901a316d7f85'
),
5.7667245864868
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb531-2f68-739e-8fdb-c029b203bb74' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb531-be66-7070-b9f7-2fec28ca34c7' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb532-43d6-71df-a540-3f29e8645cef' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb530-dc34-718a-bacc-eb0297d4264b' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede8a-209f-70e5-8b66-1bdf24055117' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede88-84b4-7095-a6b8-4aa15ea0ea63' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede89-80d9-70ee-9bc4-0144bebb8bf7' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede8a-fa0e-711d-a278-73e583703a70' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede86-dfa7-7367-8b77-b3d0f8b59375' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede87-a587-7207-b92d-c3d41e80e255' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ede8b-8f5d-7328-8d80-b0ca7e365507' ), 12.759779930115 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb769-7839-727d-9ede-b80cadfa5aea' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb769-2fda-720d-aa7c-6f6b36186d75' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb769-b437-737b-b74c-4f76d27797bf' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb769-efbc-7194-bae1-f6da30311122' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb768-b606-733d-b886-07b2bb73d460' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018eb768-f2e6-70ef-99f4-03b02fb960ca' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ebde3-6729-725f-8de2-185fc592bb39' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018ec32c-a43c-71d9-912a-4d0f77c76ad5' ), 5.7667245864868 ), (UUID_TO_BIN ('018ede86-849a-707e-bcc7-7261675f794a' ), UUID_TO_BIN ('018edebb-cd2c-7228-b45b-901a316d7f85' ), 5.7667245864868 )
;
Copy