0.95 ms (19.65%)
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 ŽÃmÜÐp°¾Î\x07 ó\x02 Þ³Z "
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 ް‘Ò°sp¸ØÇ"\x19 €™ì "
b"\x01 ޝÖ(ØqŸš5a©JŒ>ª "
b"\x01 ޝßÄÇqˆ‹@ƒÂü%]\x16 "
b"\x01 ް×éâpW¸ç\x15 ÕüZF¥ "
b"\x01 °Ó¬àp-8Öž\9xe "
b"\x01 °Ö\x00 sm…9\v µ\x1D Cn "
b"""
\x01 ·Ž\n
îs™±ÀÀ“\x1A 4$_
"""
]
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 (0x018EC36DDCD070B0BECE07F302DEB35A , 0x018EB10780B173DB96FB49B88ADFB011 , 0x018EB107194F72A3811579E0BA173EEF , 0x018EC36F06FC7021A28E4CB9E2462A92 , 0x018EC36D67657148B52DEFD4AB1E595D , 0x018EC36E380872F6959E69749B5E4B17 , 0x018EC36CE870717D9D63EAB41BF7E100 , 0x018EC36BDD0172F58CF773D0FD99A148 , 0x018EC36C559670449729401E792CD2C3 , 0x018EC36C962170DD9C82D02CC8B87BD2 , 0x018EC36C22E973779DF12332B9C4741F , 0x018EC36F86DE7368B8A861EB57228651 , 0x018EB091D2B07370B8D8C722198099EC , 0x018EAFD628D8719F9A3561A94A8C3EAA , 0x018EAFDFC4C771888B4083C2FC255D16 , 0x018EB0D7E9E27057B8E715D5FC5A46A5 , 0x018EB0D3ACE0702D8F38D69E5C397865 , 0x018EB0D6008F736D8185390BB51D436E , 0x018EB78D0AEE7399B1C0C0931A34245F );
Copy
0.75 ms (15.43%)
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
"vWQ2Cls "
]
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 = 'vWQ2Cls' LIMIT 1 ;
Copy
0.59 ms (12.22%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), 25.334943771362 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb107-80b1-73db-96fb-49b88adfb011' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb107-194f-72a3-8115-79e0ba173eef' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36f-06fc-7021-a28e-4cb9e2462a92' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36d-6765-7148-b52d-efd4ab1e595d' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36e-3808-72f6-959e-69749b5e4b17' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36c-e870-717d-9d63-eab41bf7e100' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36b-dd01-72f5-8cf7-73d0fd99a148' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36c-5596-7044-9729-401e792cd2c3' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36c-9621-70dd-9c82-d02cc8b87bd2' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36c-22e9-7377-9df1-2332b9c4741f' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36f-86de-7368-b8a8-61eb57228651' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb091-d2b0-7370-b8d8-c722198099ec' ), 11.714120864868 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eafd6-28d8-719f-9a35-61a94a8c3eaa' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eafdf-c4c7-7188-8b40-83c2fc255d16' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb0d7-e9e2-7057-b8e7-15d5fc5a46a5' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb0d3-ace0-702d-8f38-d69e5c397865' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb0d6-008f-736d-8185-390bb51d436e' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb78d-0aee-7399-b1c0-c0931a34245f' ), 8.2858877182007 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018ec36d-dcd0-70b0-bece-07f302deb35a'
),
25.334943771362
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018eb107-80b1-73db-96fb-49b88adfb011'
),
13.620822906494
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018eb107-194f-72a3-8115-79e0ba173eef'
),
13.620822906494
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018ec36f-06fc-7021-a28e-4cb9e2462a92'
),
13.620822906494
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018ec36d-6765-7148-b52d-efd4ab1e595d'
),
13.620822906494
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018ec36e-3808-72f6-959e-69749b5e4b17'
),
13.620822906494
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018ec36c-e870-717d-9d63-eab41bf7e100'
),
13.620822906494
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018ec36b-dd01-72f5-8cf7-73d0fd99a148'
),
13.620822906494
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018ec36c-5596-7044-9729-401e792cd2c3'
),
13.620822906494
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018ec36c-9621-70dd-9c82-d02cc8b87bd2'
),
13.620822906494
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018ec36c-22e9-7377-9df1-2332b9c4741f'
),
13.620822906494
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018ec36f-86de-7368-b8a8-61eb57228651'
),
13.620822906494
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018eb091-d2b0-7370-b8d8-c722198099ec'
),
11.714120864868
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018eafd6-28d8-719f-9a35-61a94a8c3eaa'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018eafdf-c4c7-7188-8b40-83c2fc255d16'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018eb0d7-e9e2-7057-b8e7-15d5fc5a46a5'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018eb0d3-ace0-702d-8f38-d69e5c397865'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018eb0d6-008f-736d-8185-390bb51d436e'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb107-638d-7202-9419-f9f476ae95e2'
),
UUID_TO_BIN (
'018eb78d-0aee-7399-b1c0-c0931a34245f'
),
8.2858877182007
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36d-dcd0-70b0-bece-07f302deb35a' ), 25.334943771362 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb107-80b1-73db-96fb-49b88adfb011' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb107-194f-72a3-8115-79e0ba173eef' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36f-06fc-7021-a28e-4cb9e2462a92' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36d-6765-7148-b52d-efd4ab1e595d' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36e-3808-72f6-959e-69749b5e4b17' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36c-e870-717d-9d63-eab41bf7e100' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36b-dd01-72f5-8cf7-73d0fd99a148' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36c-5596-7044-9729-401e792cd2c3' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36c-9621-70dd-9c82-d02cc8b87bd2' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36c-22e9-7377-9df1-2332b9c4741f' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018ec36f-86de-7368-b8a8-61eb57228651' ), 13.620822906494 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb091-d2b0-7370-b8d8-c722198099ec' ), 11.714120864868 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eafd6-28d8-719f-9a35-61a94a8c3eaa' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eafdf-c4c7-7188-8b40-83c2fc255d16' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb0d7-e9e2-7057-b8e7-15d5fc5a46a5' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb0d3-ace0-702d-8f38-d69e5c397865' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb0d6-008f-736d-8185-390bb51d436e' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb107-638d-7202-9419-f9f476ae95e2' ), UUID_TO_BIN ('018eb78d-0aee-7399-b1c0-c0931a34245f' ), 8.2858877182007 )
;
Copy