0.86 ms (18.39%)
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„špˆ™d‡\t ãÍyå "
b"\x01 ޽—øûrð‹ƒ„ÁhŒAÏ "
b"\x01 Ž´}\f Gr[«`øð=0›@ "
b"\x01 ŽÉº–«pj¶'®’9ëÄI "
b"\x01 ŽÉ·xArÑ‹\x12\x1F lå§\x14 à "
b"\x01 ɶ¦\x03 r@µµ½êg\t "
b"\x01 ŽÉ¹P‡sÄ…\x19 “Ý\v ˆ=q "
b"\x01 ŽÉ»Œ\x12 p\x16 €#°ã\x08 ½º "
b"\x01 ŽÉ¹Ö\x15 q®ŽT\x07 …'Ÿbé "
b"\x01 ¯÷þ—q?¾‹…¥î\x13\x16 "
b"\x01 ޝúÅ_pü¨&×|\x02 e‘Ü "
b"\x01 ްÝΔp@¥p•Ö ©„ô "
b"\x01 ¯Þ\x13\x03 r”‰04î÷\x17 \x10 "
b"\x01 ޝ¾B`s5Š"Ï0\x14 é^\x06 "
b"\x01 °™¥\x1C r\x16 °âº˜®8¾ "
b"\x01 ްÄɃp'x\x15\x08 7x¤Ñ "
b"\x01 Ž·Ü©\x12 sè¹ZOÖxå‚k "
b"\x01 ŽÃƒSˆs\x19 …ËâÓ\x06 úñx "
b"\x01 ް”/*ré¤vŒ/\x16 >$| "
b"\x01 ް“Èvrì¶k¿t\x08 üD˜ "
]
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 (0x018EB070849A708899648709E3CD79E5 , 0x018EBD97F8FB72F08B8384C1688C41CF , 0x018EB47D0C47725BAB60F8F03D309B40 , 0x018EC9BA96AB706AB627AE9239EBC449 , 0x018EC9B7784172D18B121F6CE5A714C3 , 0x018EC9B6A6037240B5B5BD8F81EA6709 , 0x018EC9B9508773C4851993DD0B883D71 , 0x018EC9BB8C12701680AD23B0E308BDBA , 0x018EC9B9D61571AE8E540785279F62E9 , 0x018EAFF7FE97713FBE8B85A59DEE1316 , 0x018EAFFAC55F70FCA826D77C026591DC , 0x018EB0DDCE947040A57095D620A984F4 , 0x018EAFDE13037294893034EEF7179D10 , 0x018EAFBE426073358A22CF3014E95E06 , 0x018EB099A51C7216B0E2BA8198AE38BE , 0x018EB0C4C9837027AD7815083778A4D1 , 0x018EB7DCA91273E8B95A4FD678E5826B , 0x018EC3835388731985CBE2D306FAF178 , 0x018EB0942F2A72E9A4768C2F163E247C , 0x018EB093C87672ECB66BBF7408FC4498 );
Copy
0.64 ms (13.68%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb070-849a-7088-9964-8709e3cd79e5' ), 16.345235824585 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ebd97-f8fb-72f0-8b83-84c1688c41cf' ), 16.345235824585 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb47d-0c47-725b-ab60-f8f03d309b40' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9ba-96ab-706a-b627-ae9239ebc449' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9b7-7841-72d1-8b12-1f6ce5a714c3' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9b6-a603-7240-b5b5-bd8f81ea6709' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9b9-5087-73c4-8519-93dd0b883d71' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9bb-8c12-7016-80ad-23b0e308bdba' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9b9-d615-71ae-8e54-0785279f62e9' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eaff7-fe97-713f-be8b-85a59dee1316' ), 8.6757850646973 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eaffa-c55f-70fc-a826-d77c026591dc' ), 8.6757850646973 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb0dd-ce94-7040-a570-95d620a984f4' ), 8.6757850646973 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eafde-1303-7294-8930-34eef7179d10' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eafbe-4260-7335-8a22-cf3014e95e06' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb099-a51c-7216-b0e2-ba8198ae38be' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb0c4-c983-7027-ad78-15083778a4d1' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb7dc-a912-73e8-b95a-4fd678e5826b' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec383-5388-7319-85cb-e2d306faf178' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb094-2f2a-72e9-a476-8c2f163e247c' ), 7.4181051254272 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb093-c876-72ec-b66b-bf7408fc4498' ), 7.4181051254272 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eb070-849a-7088-9964-8709e3cd79e5'
),
16.345235824585
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018ebd97-f8fb-72f0-8b83-84c1688c41cf'
),
16.345235824585
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eb47d-0c47-725b-ab60-f8f03d309b40'
),
15.37349319458
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018ec9ba-96ab-706a-b627-ae9239ebc449'
),
15.37349319458
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018ec9b7-7841-72d1-8b12-1f6ce5a714c3'
),
15.37349319458
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018ec9b6-a603-7240-b5b5-bd8f81ea6709'
),
15.37349319458
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018ec9b9-5087-73c4-8519-93dd0b883d71'
),
15.37349319458
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018ec9bb-8c12-7016-80ad-23b0e308bdba'
),
15.37349319458
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018ec9b9-d615-71ae-8e54-0785279f62e9'
),
15.37349319458
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eaff7-fe97-713f-be8b-85a59dee1316'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eaffa-c55f-70fc-a826-d77c026591dc'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eb0dd-ce94-7040-a570-95d620a984f4'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eafde-1303-7294-8930-34eef7179d10'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eafbe-4260-7335-8a22-cf3014e95e06'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eb099-a51c-7216-b0e2-ba8198ae38be'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eb0c4-c983-7027-ad78-15083778a4d1'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eb7dc-a912-73e8-b95a-4fd678e5826b'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018ec383-5388-7319-85cb-e2d306faf178'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eb094-2f2a-72e9-a476-8c2f163e247c'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018ec9b7-5092-7320-a149-28446b9b6313'
),
UUID_TO_BIN (
'018eb093-c876-72ec-b66b-bf7408fc4498'
),
7.4181051254272
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb070-849a-7088-9964-8709e3cd79e5' ), 16.345235824585 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ebd97-f8fb-72f0-8b83-84c1688c41cf' ), 16.345235824585 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb47d-0c47-725b-ab60-f8f03d309b40' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9ba-96ab-706a-b627-ae9239ebc449' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9b7-7841-72d1-8b12-1f6ce5a714c3' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9b6-a603-7240-b5b5-bd8f81ea6709' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9b9-5087-73c4-8519-93dd0b883d71' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9bb-8c12-7016-80ad-23b0e308bdba' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec9b9-d615-71ae-8e54-0785279f62e9' ), 15.37349319458 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eaff7-fe97-713f-be8b-85a59dee1316' ), 8.6757850646973 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eaffa-c55f-70fc-a826-d77c026591dc' ), 8.6757850646973 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb0dd-ce94-7040-a570-95d620a984f4' ), 8.6757850646973 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eafde-1303-7294-8930-34eef7179d10' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eafbe-4260-7335-8a22-cf3014e95e06' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb099-a51c-7216-b0e2-ba8198ae38be' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb0c4-c983-7027-ad78-15083778a4d1' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb7dc-a912-73e8-b95a-4fd678e5826b' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018ec383-5388-7319-85cb-e2d306faf178' ), 7.6694507598877 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb094-2f2a-72e9-a476-8c2f163e247c' ), 7.4181051254272 ), (UUID_TO_BIN ('018ec9b7-5092-7320-a149-28446b9b6313' ), UUID_TO_BIN ('018eb093-c876-72ec-b66b-bf7408fc4498' ), 7.4181051254272 )
;
Copy
0.57 ms (12.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
"ptPPm0R "
]
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 = 'ptPPm0R' LIMIT 1 ;
Copy