1.06 ms (17.80%)
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
"O-0bApy "
]
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 = 'O-0bApy' LIMIT 1 ;
Copy
1.02 ms (17.16%)
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 ޽è'usu¶%ó‘Ž÷Åz "
b"\x01 ޽è´ssc˜\x07 í\t Å]d\v "
b"\x01 ޽é³|p|‚¸~_\x13\x04 Òž "
b"\x01 ½ç«4rº~£·ƒ¡\x19 ö "
b"\x01 ޝ¯G›p\e ˜„è›Ñt:Ø "
b"\x01 ޝëͧs“Œ„Ä?\t Zæ: "
b"\x01 ް\x05 N:pº oÚwë}—Ù "
b"\x01 ް£IðqÓ…Âáû"É\x0F R "
b"\x01 ŽÃÕ\t ir’¿L!qÖ&·L "
b"\x01 ¯©Ž\x08 q1¨·ä#\f Óâz "
b"\x01 ޝ© =p¯Šaåd9\x14 0Û "
b"\x01 ޝ¯5õpf‘ÇUÑ«\e XŠ "
b"\x01 ޝÜÌæs/±Ÿ¦‚ð¨\x03 b "
b"\x01 ޝÚà£sì¶\x13 Ç«´ÓR/ "
b"\x01 ¯ÔgPr:¥k\x01 H\f þ. "
b"\x01 °(½©q–\x08 ›Â‹R¦á "
b"\x01 ްA•kp¼¨—y<Ape "
b"""
\x01 ް\n
±õsL™Uâ\x05 ?¢Ì¹
"""
b"\x01 °Þäàsö›É?\x01 ˆ„| "
b"\x01 ޵\t /–q\x00 ·\¤™0\x13 ¦è "
b"\x01 Ž·¢1ðrW‡˜6ê›}Ùí "
b"\x01 ŽÃL—Vrk„½p¢åYŒÁ "
]
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 (0x018EBDE827757375B625F3918EF7C57A , 0x018EBDE8B47373639807ED09C55D640B , 0x018EBDE9B37C707C82B87E5F1304D29E , 0x018EBDE7AB347290BA7EA3B783A119F6 , 0x018EAFAF479B701B9884E89BD1743AD8 , 0x018EAFEBCDA773938C84C43F095AE63A , 0x018EB0054E3A70BAA06FDA77EB7D97D9 , 0x018EB0A349F071D385C2E1FB22C90F52 , 0x018EC3D509697292BF4C2171D626B74C , 0x018EAFA98D087131A8B7E4230CD3E27A , 0x018EAFA9203D70AF8A61E564391430DB , 0x018EAFAF35F5706691C755D1AB1B588A , 0x018EAFDCCCE6732FB19FA682F0A80362 , 0x018EAFDAE0A373ECB613C7ABB4D3522F , 0x018EAFD46750723AA56B0148900CFE2E , 0x018EB028BDA9719681089BC28B52A6E1 , 0x018EB041956B70BCA897793C417065A0 , 0x018EB00AB1F5734C9955E2053FA2CCB9 , 0x018EB0DEE4E073F69B81C93F0188847C , 0x018EB5092F967100B75CA4993013A6E8 , 0x018EB7A231F07257879836EA9B7DD9ED , 0x018EC34C9756726B84BD70A2E5598CC1 );
Copy
0.72 ms (12.08%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ebde8-2775-7375-b625-f3918ef7c57a' ), 27.106365203857 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ebde8-b473-7363-9807-ed09c55d640b' ), 27.106365203857 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ebde9-b37c-707c-82b8-7e5f1304d29e' ), 16.566612243652 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ebde7-ab34-7290-ba7e-a3b783a119f6' ), 16.566612243652 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafaf-479b-701b-9884-e89bd1743ad8' ), 8.6757850646973 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafeb-cda7-7393-8c84-c43f095ae63a' ), 8.6757850646973 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb005-4e3a-70ba-a06f-da77eb7d97d9' ), 8.6757850646973 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb0a3-49f0-71d3-85c2-e1fb22c90f52' ), 8.6757850646973 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ec3d5-0969-7292-bf4c-2171d626b74c' ), 8.6757850646973 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafa9-8d08-7131-a8b7-e4230cd3e27a' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafa9-203d-70af-8a61-e564391430db' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafaf-35f5-7066-91c7-55d1ab1b588a' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafdc-cce6-732f-b19f-a682f0a80362' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafda-e0a3-73ec-b613-c7abb4d3522f' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafd4-6750-723a-a56b-0148900cfe2e' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb028-bda9-7196-8108-9bc28b52a6e1' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb041-956b-70bc-a897-793c417065a0' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb00a-b1f5-734c-9955-e2053fa2ccb9' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb0de-e4e0-73f6-9b81-c93f0188847c' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb509-2f96-7100-b75c-a4993013a6e8' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb7a2-31f0-7257-8798-36ea9b7dd9ed' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ec34c-9756-726b-84bd-70a2e5598cc1' ), 6.6434640884399 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018ebde8-2775-7375-b625-f3918ef7c57a'
),
27.106365203857
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018ebde8-b473-7363-9807-ed09c55d640b'
),
27.106365203857
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018ebde9-b37c-707c-82b8-7e5f1304d29e'
),
16.566612243652
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018ebde7-ab34-7290-ba7e-a3b783a119f6'
),
16.566612243652
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eafaf-479b-701b-9884-e89bd1743ad8'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eafeb-cda7-7393-8c84-c43f095ae63a'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eb005-4e3a-70ba-a06f-da77eb7d97d9'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eb0a3-49f0-71d3-85c2-e1fb22c90f52'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018ec3d5-0969-7292-bf4c-2171d626b74c'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eafa9-8d08-7131-a8b7-e4230cd3e27a'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eafa9-203d-70af-8a61-e564391430db'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eafaf-35f5-7066-91c7-55d1ab1b588a'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eafdc-cce6-732f-b19f-a682f0a80362'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eafda-e0a3-73ec-b613-c7abb4d3522f'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eafd4-6750-723a-a56b-0148900cfe2e'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eb028-bda9-7196-8108-9bc28b52a6e1'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eb041-956b-70bc-a897-793c417065a0'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eb00a-b1f5-734c-9955-e2053fa2ccb9'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eb0de-e4e0-73f6-9b81-c93f0188847c'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eb509-2f96-7100-b75c-a4993013a6e8'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018eb7a2-31f0-7257-8798-36ea9b7dd9ed'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018ebde9-2f52-722a-9a01-ef7155530749'
),
UUID_TO_BIN (
'018ec34c-9756-726b-84bd-70a2e5598cc1'
),
6.6434640884399
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ebde8-2775-7375-b625-f3918ef7c57a' ), 27.106365203857 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ebde8-b473-7363-9807-ed09c55d640b' ), 27.106365203857 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ebde9-b37c-707c-82b8-7e5f1304d29e' ), 16.566612243652 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ebde7-ab34-7290-ba7e-a3b783a119f6' ), 16.566612243652 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafaf-479b-701b-9884-e89bd1743ad8' ), 8.6757850646973 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafeb-cda7-7393-8c84-c43f095ae63a' ), 8.6757850646973 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb005-4e3a-70ba-a06f-da77eb7d97d9' ), 8.6757850646973 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb0a3-49f0-71d3-85c2-e1fb22c90f52' ), 8.6757850646973 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ec3d5-0969-7292-bf4c-2171d626b74c' ), 8.6757850646973 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafa9-8d08-7131-a8b7-e4230cd3e27a' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafa9-203d-70af-8a61-e564391430db' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafaf-35f5-7066-91c7-55d1ab1b588a' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafdc-cce6-732f-b19f-a682f0a80362' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafda-e0a3-73ec-b613-c7abb4d3522f' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eafd4-6750-723a-a56b-0148900cfe2e' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb028-bda9-7196-8108-9bc28b52a6e1' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb041-956b-70bc-a897-793c417065a0' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb00a-b1f5-734c-9955-e2053fa2ccb9' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb0de-e4e0-73f6-9b81-c93f0188847c' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb509-2f96-7100-b75c-a4993013a6e8' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018eb7a2-31f0-7257-8798-36ea9b7dd9ed' ), 6.6434640884399 ), (UUID_TO_BIN ('018ebde9-2f52-722a-9a01-ef7155530749' ), UUID_TO_BIN ('018ec34c-9756-726b-84bd-70a2e5598cc1' ), 6.6434640884399 )
;
Copy