0.90 ms (18.27%)
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 ±\x07 cŽr\x02 ”\x19 ùôv®•â "
b"\x01 ޱ\x07 €±sÛ–ûI¸Šß°\x11 "
b"\x01 ±\x07\x19 Or£\x15 yàº\x17 >ï "
b"\x01 ŽÃo\x06 üp!¢ŽL¹âF*’ "
b"\x01 ŽÃmgeqHµ-ïÔ«\x1E Y] "
b"\x01 ŽÃn8\x08 rö•žit›^K\x17 "
b"\x01 Ãlèpq}cê´\e ÷á\x00 "
b"\x01 ŽÃkÝ\x01 rõŒ÷sÐý™¡H "
b"\x01 ŽÃlU–pD—)@\x1E y,ÒÃ "
b"\x01 ŽÃl–!pÝœ‚Ð,ȸ{Ò "
b"\x01 Ãl"éswñ#2¹Ät\x1F "
b"\x01 ŽÃo†Þsh¸¨aëW"†Q "
b"\x01 ¯“9ryŽKE‡|\x12 ™ "
b"\x01 ްòGrsr™àUºûW\x16 ² "
b"\x01 ¯Ó¼ÐrC}™\x04 ø–vD "
b"\x01 ްEºÝp\x05 ŒÓKçÆb1ß "
b"\x01 ްçõÖrt»iÂÊwÜKˆ "
b"\x01 Ž·§\x12\x19 sª‡½ˆô\r F‘Ø "
b"\x01 ޵Gd1r.¡\x1D ô°æó\x05 ¢ "
b"\x01 Ž·ìÎ_r%¡¹\x05 ÀÆèÝa "
]
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 (0x018EB107638D72029419F9F476AE95E2 , 0x018EB10780B173DB96FB49B88ADFB011 , 0x018EB107194F72A3811579E0BA173EEF , 0x018EC36F06FC7021A28E4CB9E2462A92 , 0x018EC36D67657148B52DEFD4AB1E595D , 0x018EC36E380872F6959E69749B5E4B17 , 0x018EC36CE870717D9D63EAB41BF7E100 , 0x018EC36BDD0172F58CF773D0FD99A148 , 0x018EC36C559670449729401E792CD2C3 , 0x018EC36C962170DD9C82D02CC8B87BD2 , 0x018EC36C22E973779DF12332B9C4741F , 0x018EC36F86DE7368B8A861EB57228651 , 0x018EAF93398E72798D4B45877C12AD99 , 0x018EB0F24772737299E055BAFB5716B2 , 0x018EAFD3BCD072439D7D9904F8967644 , 0x018EB045BADD70058CD34BE7C66231DF , 0x018EB0E7F5D67274BB69C2CA77DC4B88 , 0x018EB7A7121973AA87BD88F40D4691D8 , 0x018EB5476431722EA11DF4B0E6F305A2 , 0x018EB7ECCE5F7225A1B905C0C6E8DD61 );
Copy
0.68 ms (13.74%)
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
"YYEB7x- "
]
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 = 'YYEB7x-' LIMIT 1 ;
Copy
0.65 ms (13.11%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), 25.334943771362 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb107-80b1-73db-96fb-49b88adfb011' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb107-194f-72a3-8115-79e0ba173eef' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36f-06fc-7021-a28e-4cb9e2462a92' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36d-6765-7148-b52d-efd4ab1e595d' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36e-3808-72f6-959e-69749b5e4b17' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36c-e870-717d-9d63-eab41bf7e100' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36b-dd01-72f5-8cf7-73d0fd99a148' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36c-5596-7044-9729-401e792cd2c3' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36c-9621-70dd-9c82-d02cc8b87bd2' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36c-22e9-7377-9df1-2332b9c4741f' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36f-86de-7368-b8a8-61eb57228651' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eaf93-398e-7279-8d4b-45877c12ad99' ), 10.539752960205 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb0f2-4772-7372-99e0-55bafb5716b2' ), 10.539752960205 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eafd3-bcd0-7243-9d7d-9904f8967644' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb045-badd-7005-8cd3-4be7c66231df' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb0e7-f5d6-7274-bb69-c2ca77dc4b88' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb7a7-1219-73aa-87bd-88f40d4691d8' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb547-6431-722e-a11d-f4b0e6f305a2' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb7ec-ce5f-7225-a1b9-05c0c6e8dd61' ), 8.2858877182007 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
25.334943771362
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018eb107-80b1-73db-96fb-49b88adfb011'
),
13.620822906494
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018eb107-194f-72a3-8115-79e0ba173eef'
),
13.620822906494
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018ec36f-06fc-7021-a28e-4cb9e2462a92'
),
13.620822906494
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018ec36d-6765-7148-b52d-efd4ab1e595d'
),
13.620822906494
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018ec36e-3808-72f6-959e-69749b5e4b17'
),
13.620822906494
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018ec36c-e870-717d-9d63-eab41bf7e100'
),
13.620822906494
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018ec36b-dd01-72f5-8cf7-73d0fd99a148'
),
13.620822906494
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018ec36c-5596-7044-9729-401e792cd2c3'
),
13.620822906494
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018ec36c-9621-70dd-9c82-d02cc8b87bd2'
),
13.620822906494
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018ec36c-22e9-7377-9df1-2332b9c4741f'
),
13.620822906494
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018ec36f-86de-7368-b8a8-61eb57228651'
),
13.620822906494
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018eaf93-398e-7279-8d4b-45877c12ad99'
),
10.539752960205
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018eb0f2-4772-7372-99e0-55bafb5716b2'
),
10.539752960205
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018eafd3-bcd0-7243-9d7d-9904f8967644'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018eb045-badd-7005-8cd3-4be7c66231df'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018eb0e7-f5d6-7274-bb69-c2ca77dc4b88'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018eb7a7-1219-73aa-87bd-88f40d4691d8'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018eb547-6431-722e-a11d-f4b0e6f305a2'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
UUID_TO_BIN (
'018eb7ec-ce5f-7225-a1b9-05c0c6e8dd61'
),
8.2858877182007
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), 25.334943771362 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb107-80b1-73db-96fb-49b88adfb011' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb107-194f-72a3-8115-79e0ba173eef' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36f-06fc-7021-a28e-4cb9e2462a92' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36d-6765-7148-b52d-efd4ab1e595d' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36e-3808-72f6-959e-69749b5e4b17' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36c-e870-717d-9d63-eab41bf7e100' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36b-dd01-72f5-8cf7-73d0fd99a148' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36c-5596-7044-9729-401e792cd2c3' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36c-9621-70dd-9c82-d02cc8b87bd2' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36c-22e9-7377-9df1-2332b9c4741f' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018ec36f-86de-7368-b8a8-61eb57228651' ), 13.620822906494 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eaf93-398e-7279-8d4b-45877c12ad99' ), 10.539752960205 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb0f2-4772-7372-99e0-55bafb5716b2' ), 10.539752960205 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eafd3-bcd0-7243-9d7d-9904f8967644' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb045-badd-7005-8cd3-4be7c66231df' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb0e7-f5d6-7274-bb69-c2ca77dc4b88' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb7a7-1219-73aa-87bd-88f40d4691d8' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb547-6431-722e-a11d-f4b0e6f305a2' ), 8.2858877182007 ), (UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), UUID_TO_BIN ('018eb7ec-ce5f-7225-a1b9-05c0c6e8dd61' ), 8.2858877182007 )
;
Copy