0.93 ms (18.81%)
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 Ž´¤¶\x03 s®‘\£-‘ÞyÒ "
b"\x01 ½l\x1C ^pciÛ6Kë¶z "
b"\x01 ޽l‡^rû•œR)ÜOñx "
b"\x01 ޽mŒuq|¶§D^[–mà "
b"\x01 ½k€\r s\x08 –òž³Ú¶b "
b"\x01 ޽mýŸrtŒ¿íæ"èTí "
b"\x01 ½kÖ\x0F q\x10 "…\x13\x06 RºÃ "
b"\x01 ޽lãÖp«˜2O´l¸~O "
b"\x01 ãkÇ«pS'ùF%ì!N "
b"\x01 Žãl_˜pH»¦3¢‘\x16 "h "
b"\x01 ްXyÕp\x15 ¨Lg\x07 /@!· "
b"\x01 ŽÉÇQ•q)°ÅÈ\x06 Ÿ©x’ "
b"\x01 ŽÞôiýq<µÊùÌí:Åk "
b"\x01 ޽ºãFpD•”©Ãƒqc« "
b"""
\x01 Ž×\x18 `ÃrFˆ¸oZ\n
ÓµÌ
"""
b"\x01 Ž×\x19\x1E äq{¯ágþXh$3 "
b"\x01 Ž×\e 7½s\e —ÅY\x00 yQÒÒ "
b"\x01 Ž×\x1A 6Ãqô¦Ã°§ƒH^P "
]
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 (0x018EB4A4B60373AE915CA32D91DE79D2 , 0x018EBD6C1C5E70639069DB364BEBB67A , 0x018EBD6C875E72FB959C5229DC4FF178 , 0x018EBD6D8C75717CB6A7445E5B966DC3 , 0x018EBD6B800D7308968FF29EB3DAB662 , 0x018EBD6DFD9F72748CBFEDE622E854ED , 0x018EBD6BD60F71108F2285130652BAC3 , 0x018EBD6CE3D670AB98324FB46CB87E4F , 0x018EE36BC7AB70538127F94625EC214E , 0x018EE36C5F987048BBA633A291162268 , 0x018EB05879D57015A84C67072F4021B7 , 0x018EC9C751957129B0C5C8069FA97892 , 0x018EDEF469FD713CB5CAF9CCED3AC56B , 0x018EBDBAE34670449594A9C3837163AB , 0x018ED71860C3724688B86F5A0AD3B5CC , 0x018ED7191EE4717BAFE167FE58682433 , 0x018ED71B37BD731B97C559007951D2D2 , 0x018ED71A36C371F4A6C3B0A783485E50 );
Copy
0.65 ms (13.16%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018eb4a4-b603-73ae-915c-a32d91de79d2' ), 16.571775436401 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6c-1c5e-7063-9069-db364bebb67a' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6c-875e-72fb-959c-5229dc4ff178' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6d-8c75-717c-b6a7-445e5b966dc3' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6b-800d-7308-968f-f29eb3dab662' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6d-fd9f-7274-8cbf-ede622e854ed' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6b-d60f-7110-8f22-85130652bac3' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6c-e3d6-70ab-9832-4fb46cb87e4f' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ee36b-c7ab-7053-8127-f94625ec214e' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ee36c-5f98-7048-bba6-33a291162268' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018eb058-79d5-7015-a84c-67072f4021b7' ), 9.7441358566284 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ec9c7-5195-7129-b0c5-c8069fa97892' ), 9.7441358566284 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018edef4-69fd-713c-b5ca-f9cced3ac56b' ), 9.7441358566284 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebdba-e346-7044-9594-a9c3837163ab' ), 8.2858877182007 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ed718-60c3-7246-88b8-6f5a0ad3b5cc' ), 8.2858877182007 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ed719-1ee4-717b-afe1-67fe58682433' ), 8.2858877182007 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ed71b-37bd-731b-97c5-59007951d2d2' ), 8.2858877182007 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ed71a-36c3-71f4-a6c3-b0a783485e50' ), 8.2858877182007 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018eb4a4-b603-73ae-915c-a32d91de79d2'
),
16.571775436401
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ebd6c-1c5e-7063-9069-db364bebb67a'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ebd6c-875e-72fb-959c-5229dc4ff178'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ebd6d-8c75-717c-b6a7-445e5b966dc3'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ebd6b-800d-7308-968f-f29eb3dab662'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ebd6d-fd9f-7274-8cbf-ede622e854ed'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ebd6b-d60f-7110-8f22-85130652bac3'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ebd6c-e3d6-70ab-9832-4fb46cb87e4f'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ee36b-c7ab-7053-8127-f94625ec214e'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ee36c-5f98-7048-bba6-33a291162268'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018eb058-79d5-7015-a84c-67072f4021b7'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ec9c7-5195-7129-b0c5-c8069fa97892'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018edef4-69fd-713c-b5ca-f9cced3ac56b'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ebdba-e346-7044-9594-a9c3837163ab'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ed718-60c3-7246-88b8-6f5a0ad3b5cc'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ed719-1ee4-717b-afe1-67fe58682433'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ed71b-37bd-731b-97c5-59007951d2d2'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ebd6d-39d1-7260-a8af-69c8553d25e3'
),
UUID_TO_BIN (
'018ed71a-36c3-71f4-a6c3-b0a783485e50'
),
8.2858877182007
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018eb4a4-b603-73ae-915c-a32d91de79d2' ), 16.571775436401 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6c-1c5e-7063-9069-db364bebb67a' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6c-875e-72fb-959c-5229dc4ff178' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6d-8c75-717c-b6a7-445e5b966dc3' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6b-800d-7308-968f-f29eb3dab662' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6d-fd9f-7274-8cbf-ede622e854ed' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6b-d60f-7110-8f22-85130652bac3' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebd6c-e3d6-70ab-9832-4fb46cb87e4f' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ee36b-c7ab-7053-8127-f94625ec214e' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ee36c-5f98-7048-bba6-33a291162268' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018eb058-79d5-7015-a84c-67072f4021b7' ), 9.7441358566284 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ec9c7-5195-7129-b0c5-c8069fa97892' ), 9.7441358566284 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018edef4-69fd-713c-b5ca-f9cced3ac56b' ), 9.7441358566284 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ebdba-e346-7044-9594-a9c3837163ab' ), 8.2858877182007 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ed718-60c3-7246-88b8-6f5a0ad3b5cc' ), 8.2858877182007 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ed719-1ee4-717b-afe1-67fe58682433' ), 8.2858877182007 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ed71b-37bd-731b-97c5-59007951d2d2' ), 8.2858877182007 ), (UUID_TO_BIN ('018ebd6d-39d1-7260-a8af-69c8553d25e3' ), UUID_TO_BIN ('018ed71a-36c3-71f4-a6c3-b0a783485e50' ), 8.2858877182007 )
;
Copy
0.59 ms (11.86%)
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
"mvvtgZw "
]
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 = 'mvvtgZw' LIMIT 1 ;
Copy