0.76 ms (1.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 ް°PÖqÞ©T¥½ÇÈ\x1E — "
b"\x01 ް¯£s‰»nòN}.1 "
b"\x01 ް¯h™q-ŒñŸX\x16 „Ëá "
b"\x01 °¯˜‡röI 6ÆfªÉ "
b"\x01 ÉÞeq‹–æû¶\x10 µD¸ "
b"\x01 ŽÎRÐir;_4KûC¹è "
b"\x01 ½¹.Wr¶ºbö,\e sj "
b"\x01 ¯¤A'rÎ’,ùçû–\x15 "
b"\x01 °,·Lr¯«\x05\x13 ¨€\x7F Ô "
b"\x01 ް=ìêr\x06 ±È÷4hÑaû "
b"\x01 ްXyÕp\x15 ¨Lg\x07 /@!· "
b"\x01 Ž·ÀP¿pÿ„š£á7Zž‡ "
b"\x01 ޽nh\x12 pñ±‹[Àá\x10\x1A ˜ "
b"\x01 ŽÉ\x17 •\x16 sޏIŒ4k—,I "
b"\x01 ŽÎ3\x05\x15 på¢6îõõÔ«X "
b"\x01 ŽÞêÿÄqB£¤>²Dð1‹ "
b"\x01 ŽÞ‰€Ùpî›Ä\x01 D¾»‹÷ "
b"\x01 ›6ß„2s\x1E ·äB!\e ·£ê "
]
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 (0x018EB0B050D671DEA954A5BDC7C81E97 , 0x018EB0AFADA37389BB6EF24E7D2E31AD , 0x018EB0AF6899712D8CF19F581684CBE1 , 0x018EB0AF988772F68F492036C666AAC9 , 0x018EC9DE9D65718B96E6FBB610B544B8 , 0x018ECE52D06972CDBE5F344BFB43B9E8 , 0x018EBDB92E5772B6BA62F62C8F1B736A , 0x018EAFA4412772CE90922CF9E7FB9615 , 0x018EB02CB74C72AFAB0513A8807F90D4 , 0x018EB03DECEA7206B1C8F73468D161FB , 0x018EB05879D57015A84C67072F4021B7 , 0x018EB7C050BF70FF849AA3E1375A9E87 , 0x018EBD6E681270F1B18B5BC0E1101A98 , 0x018EC9179516738EB8498C346B972C49 , 0x018ECE33051570E5A236EEF5F5D4AB58 , 0x018EDEEAFFC47142A3A43EB244F0318B , 0x018EDE8980D970EE9BC40144BEBB8BF7 , 0x019B36DF8432731EB7E442211BB7A3EA );
Copy
0.58 ms (1.27%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb0b0-50d6-71de-a954-a5bdc7c81e97' ), 17.824291229248 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb0af-ada3-7389-bb6e-f24e7d2e31ad' ), 17.824291229248 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb0af-6899-712d-8cf1-9f581684cbe1' ), 17.824291229248 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb0af-9887-72f6-8f49-2036c666aac9' ), 17.824291229248 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ec9de-9d65-718b-96e6-fbb610b544b8' ), 10.539752960205 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ece52-d069-72cd-be5f-344bfb43b9e8' ), 10.539752960205 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ebdb9-2e57-72b6-ba62-f62c8f1b736a' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eafa4-4127-72ce-9092-2cf9e7fb9615' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb02c-b74c-72af-ab05-13a8807f90d4' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb03d-ecea-7206-b1c8-f73468d161fb' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb058-79d5-7015-a84c-67072f4021b7' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb7c0-50bf-70ff-849a-a3e1375a9e87' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ebd6e-6812-70f1-b18b-5bc0e1101a98' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ec917-9516-738e-b849-8c346b972c49' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ece33-0515-70e5-a236-eef5f5d4ab58' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018edeea-ffc4-7142-a3a4-3eb244f0318b' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ede89-80d9-70ee-9bc4-0144bebb8bf7' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('019b36df-8432-731e-b7e4-42211bb7a3ea' ), 6.9930553436279 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018eb0b0-50d6-71de-a954-a5bdc7c81e97'
),
17.824291229248
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018eb0af-ada3-7389-bb6e-f24e7d2e31ad'
),
17.824291229248
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018eb0af-6899-712d-8cf1-9f581684cbe1'
),
17.824291229248
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018eb0af-9887-72f6-8f49-2036c666aac9'
),
17.824291229248
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018ec9de-9d65-718b-96e6-fbb610b544b8'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018ece52-d069-72cd-be5f-344bfb43b9e8'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018ebdb9-2e57-72b6-ba62-f62c8f1b736a'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018eafa4-4127-72ce-9092-2cf9e7fb9615'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018eb02c-b74c-72af-ab05-13a8807f90d4'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018eb03d-ecea-7206-b1c8-f73468d161fb'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018eb058-79d5-7015-a84c-67072f4021b7'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018eb7c0-50bf-70ff-849a-a3e1375a9e87'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018ebd6e-6812-70f1-b18b-5bc0e1101a98'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018ec917-9516-738e-b849-8c346b972c49'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018ece33-0515-70e5-a236-eef5f5d4ab58'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018edeea-ffc4-7142-a3a4-3eb244f0318b'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'018ede89-80d9-70ee-9bc4-0144bebb8bf7'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018eb0b0-6d10-713e-8b27-ce075a86609f'
),
UUID_TO_BIN (
'019b36df-8432-731e-b7e4-42211bb7a3ea'
),
6.9930553436279
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb0b0-50d6-71de-a954-a5bdc7c81e97' ), 17.824291229248 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb0af-ada3-7389-bb6e-f24e7d2e31ad' ), 17.824291229248 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb0af-6899-712d-8cf1-9f581684cbe1' ), 17.824291229248 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb0af-9887-72f6-8f49-2036c666aac9' ), 17.824291229248 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ec9de-9d65-718b-96e6-fbb610b544b8' ), 10.539752960205 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ece52-d069-72cd-be5f-344bfb43b9e8' ), 10.539752960205 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ebdb9-2e57-72b6-ba62-f62c8f1b736a' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eafa4-4127-72ce-9092-2cf9e7fb9615' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb02c-b74c-72af-ab05-13a8807f90d4' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb03d-ecea-7206-b1c8-f73468d161fb' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb058-79d5-7015-a84c-67072f4021b7' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018eb7c0-50bf-70ff-849a-a3e1375a9e87' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ebd6e-6812-70f1-b18b-5bc0e1101a98' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ec917-9516-738e-b849-8c346b972c49' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ece33-0515-70e5-a236-eef5f5d4ab58' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018edeea-ffc4-7142-a3a4-3eb244f0318b' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('018ede89-80d9-70ee-9bc4-0144bebb8bf7' ), 6.9930553436279 ), (UUID_TO_BIN ('018eb0b0-6d10-713e-8b27-ce075a86609f' ), UUID_TO_BIN ('019b36df-8432-731e-b7e4-42211bb7a3ea' ), 6.9930553436279 )
;
Copy
0.53 ms (1.16%)
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
"SqyjgK8 "
]
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 = 'SqyjgK8' LIMIT 1 ;
Copy