0.81 ms (18.09%)
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 Ä\x05 Îp#‰EÏ£©ÚÑ. "
b"\x01 Ä\x08 È8sô©¸tiÛ²g "
b"\x01 Ä\x05 M>s-”þoF=û„ "
b"\x01 ŽÄ\x07 5Jpx³ÎŒX¿\x7F\x07 Œ "
b"\x01 ްK%ðq–«x:~DŽ•¼ "
b"\x01 ¯ÄÄpë¾EQ‹ÐâûB "
b"\x01 ¯ÖÖpçÈÀ’–Ù\x1A "
b"\x01 ¯¬Kp”Ž\x1E\e Ro\x7F Ö "
b"\x01 ¯›Ås½žõùöðœ©\x13 "
b"\x01 °ðÈjs¦–×Ó•'\x07 ò "
b"""
\x01 ްðK\n
rÑ€¾K\x19\x19\x07 gg
"""
b"\x01 °ðó\x19 s«¯/Ž„0÷ò "
b"\x01 °ñ\x19 ¶q‰•\x0E ½:¬Ã0 "
b"\x01 ްðÚmp7µP\x02 u‚V¤ø "
b"\x01 °ð[@r¡ßר.\x00 ±? "
b"\x01 ްñXKpû¾:¯Y³Ðü_ "
b"\x01 °ðkur\x06 f\x16 „?Rìß "
b"\x01 ŽÃ'L\e q÷™Ì0.\x1E Y\t w "
b"\x01 ŽÃ'}Ép\x13 ¥£Áõ>BÕ "
]
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 (0x018EC405CE9D70238945CFA3A9DAD12E , 0x018EC408C83873F490A9B87469DBB267 , 0x018EC4054D3E732D9094FE6F463DFB84 , 0x018EC407354A7078B3CE8C58BF7F078C , 0x018EB04B25F07196AB783A7E448E95BC , 0x018EAF81C4C470EBBE45518BD0E2FB42 , 0x018EAF81D6D670AD81E7C8C09296D91A , 0x018EAF81AC4B70948D1E1B526F7F90D6 , 0x018EAF819BC573BD9EF5F9F6F09CA913 , 0x018EB0F0C86A73A696D7D381952707F2 , 0x018EB0F04B0A72D180BE4B1919076767 , 0x018EB0F0F31973ABAF2F8D818430F7F2 , 0x018EB0F119B67189950E9DBD3AACC330 , 0x018EB0F0DA6D7037B55002758256A4F8 , 0x018EB0F05B407290A1DFD7A82E00B13F , 0x018EB0F1584B70FBBE3AAF59B3D0FC5F , 0x018EB0F06B7572069D6616843F52ECDF , 0x018EC3274C1B71F799CC302E1E590977 , 0x018EC3277DC97013A0A5A3C1F53E42D5 );
Copy
0.67 ms (15.01%)
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
"4B79Opr "
]
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 = '4B79Opr' LIMIT 1 ;
Copy
0.65 ms (14.54%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec405-ce9d-7023-8945-cfa3a9dad12e' ), 24.274383544922 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec408-c838-73f4-90a9-b87469dbb267' ), 24.274383544922 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec405-4d3e-732d-9094-fe6f463dfb84' ), 24.274383544922 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec407-354a-7078-b3ce-8c58bf7f078c' ), 24.274383544922 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb04b-25f0-7196-ab78-3a7e448e95bc' ), 11.714120864868 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eaf81-c4c4-70eb-be45-518bd0e2fb42' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eaf81-d6d6-70ad-81e7-c8c09296d91a' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eaf81-ac4b-7094-8d1e-1b526f7f90d6' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eaf81-9bc5-73bd-9ef5-f9f6f09ca913' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-c86a-73a6-96d7-d381952707f2' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-4b0a-72d1-80be-4b1919076767' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-f319-73ab-af2f-8d818430f7f2' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f1-19b6-7189-950e-9dbd3aacc330' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-da6d-7037-b550-02758256a4f8' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-5b40-7290-a1df-d7a82e00b13f' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f1-584b-70fb-be3a-af59b3d0fc5f' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-6b75-7206-9d66-16843f52ecdf' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec327-4c1b-71f7-99cc-302e1e590977' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec327-7dc9-7013-a0a5-a3c1f53e42d5' ), 5.9773707389832 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018ec405-ce9d-7023-8945-cfa3a9dad12e'
),
24.274383544922
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018ec408-c838-73f4-90a9-b87469dbb267'
),
24.274383544922
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018ec405-4d3e-732d-9094-fe6f463dfb84'
),
24.274383544922
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018ec407-354a-7078-b3ce-8c58bf7f078c'
),
24.274383544922
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eb04b-25f0-7196-ab78-3a7e448e95bc'
),
11.714120864868
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eaf81-c4c4-70eb-be45-518bd0e2fb42'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eaf81-d6d6-70ad-81e7-c8c09296d91a'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eaf81-ac4b-7094-8d1e-1b526f7f90d6'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eaf81-9bc5-73bd-9ef5-f9f6f09ca913'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eb0f0-c86a-73a6-96d7-d381952707f2'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eb0f0-4b0a-72d1-80be-4b1919076767'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eb0f0-f319-73ab-af2f-8d818430f7f2'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eb0f1-19b6-7189-950e-9dbd3aacc330'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eb0f0-da6d-7037-b550-02758256a4f8'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eb0f0-5b40-7290-a1df-d7a82e00b13f'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eb0f1-584b-70fb-be3a-af59b3d0fc5f'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018eb0f0-6b75-7206-9d66-16843f52ecdf'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018ec327-4c1b-71f7-99cc-302e1e590977'
),
5.9773707389832
),
(
UUID_TO_BIN (
'018ec408-59a3-7161-be68-7cfc414989e3'
),
UUID_TO_BIN (
'018ec327-7dc9-7013-a0a5-a3c1f53e42d5'
),
5.9773707389832
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec405-ce9d-7023-8945-cfa3a9dad12e' ), 24.274383544922 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec408-c838-73f4-90a9-b87469dbb267' ), 24.274383544922 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec405-4d3e-732d-9094-fe6f463dfb84' ), 24.274383544922 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec407-354a-7078-b3ce-8c58bf7f078c' ), 24.274383544922 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb04b-25f0-7196-ab78-3a7e448e95bc' ), 11.714120864868 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eaf81-c4c4-70eb-be45-518bd0e2fb42' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eaf81-d6d6-70ad-81e7-c8c09296d91a' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eaf81-ac4b-7094-8d1e-1b526f7f90d6' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eaf81-9bc5-73bd-9ef5-f9f6f09ca913' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-c86a-73a6-96d7-d381952707f2' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-4b0a-72d1-80be-4b1919076767' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-f319-73ab-af2f-8d818430f7f2' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f1-19b6-7189-950e-9dbd3aacc330' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-da6d-7037-b550-02758256a4f8' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-5b40-7290-a1df-d7a82e00b13f' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f1-584b-70fb-be3a-af59b3d0fc5f' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018eb0f0-6b75-7206-9d66-16843f52ecdf' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec327-4c1b-71f7-99cc-302e1e590977' ), 5.9773707389832 ), (UUID_TO_BIN ('018ec408-59a3-7161-be68-7cfc414989e3' ), UUID_TO_BIN ('018ec327-7dc9-7013-a0a5-a3c1f53e42d5' ), 5.9773707389832 )
;
Copy