0.82 ms (17.18%)
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
"AjThqLc "
]
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 = 'AjThqLc' LIMIT 1 ;
Copy
0.77 ms (16.21%)
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 Ž´ƒ\x0F 9pü¥*R§U@«è "
b"\x01 ŽÍìî6s\x13 ¥É€ZpE=J "
b"\x01 Íød1s©„Ì‚ZމΠ"
b"\x01 ŽÍõi{qή-¢ºÚD,Ñ "
b"\x01 Íðþ.qO2ç]Mvç "
b"\x01 ŽÍñæTs\x0F µX½M\x17 Ñ\x7F K "
b"\x01 ŽÍú\x16 ºq£¼\x16 âq“y¨Ô "
b"\x01 ŽÍöpxpŒ¾ïØ·\x01\x0E ™ú "
b"\x01 ŽÍïº[qôŠ\x1D\t Ë Ñö} "
b"\x01 ÍíÙÓq]B›Ïùmò "
b"\x01 ŽÍó±‘p˧(‘q±çDu "
b"\x01 ŽÎ\x00 â`p&µß£ßÃV\r ° "
b"\x01 Íû¥„q€‹(À\x05 Hxb "
b"\x01 ŽÍúò’p—ˆUê±…}Ö# "
b"\x01 ŽÍücÎqêŠ\x11\x14 BÝr4\x01 "
b"\x01 ŽÉP^5s?µ\t ½…OÌÆÝ "
]
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 (0x018EB4830F3970FCA52A52A75540ABE8 , 0x018ECDECEE367313A5C9805A70453D4A , 0x018ECDF8643173A984CC825ADE8189CE , 0x018ECDF5697B71CEAE2DA2BADA442CD1 , 0x018ECDF0FE2E7181904F32E75D4D76E7 , 0x018ECDF1E654730FB558BD4D17D17F4B , 0x018ECDFA16BA71A3BC16E2719379A8D4 , 0x018ECDF67078708CBEEFD8B7010E99FA , 0x018ECDEFBA5B71F48A1D09CBA0D1F67D , 0x018ECDEDD9D3715D81429F9BCFF96DF2 , 0x018ECDF3B19170CBA7289171B1E74475 , 0x018ECE00E2607026B5DFA3DFC3560DB0 , 0x018ECDFBA58471808F8B28C005487862 , 0x018ECDFAF29270978855EAB1857DD623 , 0x018ECDFC63CE71EA8A111442DD723401 , 0x018EC9505E35733FB509BD854FCCC6DD );
Copy
0.66 ms (13.91%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018eb483-0f39-70fc-a52a-52a75540abe8' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdec-ee36-7313-a5c9-805a70453d4a' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf8-6431-73a9-84cc-825ade8189ce' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf5-697b-71ce-ae2d-a2bada442cd1' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf0-fe2e-7181-904f-32e75d4d76e7' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf1-e654-730f-b558-bd4d17d17f4b' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdfa-16ba-71a3-bc16-e2719379a8d4' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf6-7078-708c-beef-d8b7010e99fa' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdef-ba5b-71f4-8a1d-09cba0d1f67d' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecded-d9d3-715d-8142-9f9bcff96df2' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf3-b191-70cb-a728-9171b1e74475' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ece00-e260-7026-b5df-a3dfc3560db0' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdfb-a584-7180-8f8b-28c005487862' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdfa-f292-7097-8855-eab1857dd623' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdfc-63ce-71ea-8a11-1442dd723401' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ec950-5e35-733f-b509-bd854fccc6dd' ), 11.714120864868 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018eb483-0f39-70fc-a52a-52a75540abe8'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdec-ee36-7313-a5c9-805a70453d4a'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdf8-6431-73a9-84cc-825ade8189ce'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdf5-697b-71ce-ae2d-a2bada442cd1'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdf0-fe2e-7181-904f-32e75d4d76e7'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdf1-e654-730f-b558-bd4d17d17f4b'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdfa-16ba-71a3-bc16-e2719379a8d4'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdf6-7078-708c-beef-d8b7010e99fa'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdef-ba5b-71f4-8a1d-09cba0d1f67d'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecded-d9d3-715d-8142-9f9bcff96df2'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdf3-b191-70cb-a728-9171b1e74475'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ece00-e260-7026-b5df-a3dfc3560db0'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdfb-a584-7180-8f8b-28c005487862'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdfa-f292-7097-8855-eab1857dd623'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ecdfc-63ce-71ea-8a11-1442dd723401'
),
12.69575881958
),
(
UUID_TO_BIN (
'018ece03-34a1-710a-8ba7-767bd9b4a640'
),
UUID_TO_BIN (
'018ec950-5e35-733f-b509-bd854fccc6dd'
),
11.714120864868
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018eb483-0f39-70fc-a52a-52a75540abe8' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdec-ee36-7313-a5c9-805a70453d4a' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf8-6431-73a9-84cc-825ade8189ce' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf5-697b-71ce-ae2d-a2bada442cd1' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf0-fe2e-7181-904f-32e75d4d76e7' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf1-e654-730f-b558-bd4d17d17f4b' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdfa-16ba-71a3-bc16-e2719379a8d4' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf6-7078-708c-beef-d8b7010e99fa' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdef-ba5b-71f4-8a1d-09cba0d1f67d' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecded-d9d3-715d-8142-9f9bcff96df2' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdf3-b191-70cb-a728-9171b1e74475' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ece00-e260-7026-b5df-a3dfc3560db0' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdfb-a584-7180-8f8b-28c005487862' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdfa-f292-7097-8855-eab1857dd623' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ecdfc-63ce-71ea-8a11-1442dd723401' ), 12.69575881958 ), (UUID_TO_BIN ('018ece03-34a1-710a-8ba7-767bd9b4a640' ), UUID_TO_BIN ('018ec950-5e35-733f-b509-bd854fccc6dd' ), 11.714120864868 )
;
Copy