0.99 ms (19.05%)
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 Ž·Ÿ\\x08 q7‹axVÊë1Ÿ "
b"\x01 Ž·žÎ\r rd²bÁ=Y\x0E –l "
b"\x01 · ®\x1F q\x00 <’Ù\x13 r‘¶ "
b"\x01 Ž· O¯q8«¤\v ÄöŒ$= "
b"\x01 Ž·¡\x1D Opö§€\x16 ß-wH( "
b"\x01 ŽÞð˜Òrð›"n·èS\x12 ¾ "
b"\x01 ŽÍìî6s\x13 ¥É€ZpE=J "
b"\x01 ãFX™p´Žæ0\x00 t\x1A\x11\x0F "
b"\x01 ްUž³qÀß÷6–\x1E "
b"\x01 ްÁàÓsÒ²Í\x08 \r ´Hä¸ "
b"\x01 ްÈm˜q@¼N)oòôÝØ "
b"\x01 Ž·d>ëp2™%FóÞì”Q "
b"\x01 Ž·¢1ðrW‡˜6ê›}Ùí "
b"\x01 Ž·Ò\x03 gs\x10 ¼wHéxh§Ô "
b"\x01 Ž·’3rr%ƒrŠŸÕMü\x08 "
b"""
\x01 ŽÎ¬\n
Êqå°`Їs<A\f
"""
b"\x01 ŽÞòë…p’²x¤s˜.ÍE "
b"\x01 Žãi¾\x0E rëœs~ßLõ/> "
b"\x01 ޝ¦‰)s™ž\x07 Ab\x19\e F\x18 "
b"\x01 ´ÈWùq5§«pƒŽƒJ "
b"\x01 Ž´±"\x13 p\x16 ¯–M‰¾6\x15 Ì "
b"\x01 Ž×Ï¡Fr\x01 œõ\x01 í\x1E uu "
]
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 (0x018EB79F5C0871378B617856CAEB319F , 0x018EB79ECE0D7264B262C13D590E966C , 0x018EB7A0AE1F7100813C92D9137291B6 , 0x018EB7A04FAF7138ABA40BC4F68C243D , 0x018EB7A11D4F70F6A78016DF2D774828 , 0x018EDEF098D272F09B226EB7E85312BE , 0x018ECDECEE367313A5C9805A70453D4A , 0x018EE346589970B48DE63000741A110F , 0x018EB0559EB371C0ADADDFF736AD961E , 0x018EB0C1E0D373D2B2CD080DB448E4B8 , 0x018EB0C86D987140BC4E296FF2F4DDD8 , 0x018EB7643EEB7032992546F3DEEC9451 , 0x018EB7A231F07257879836EA9B7DD9ED , 0x018EB7D203677310BC7748E97868A7D4 , 0x018EB7923372722583728A9FD54DFC08 , 0x018ECEAC0ACA71E5B0608A87733C410C , 0x018EDEF2EB857092B278A473982ECD45 , 0x018EE369BE0E72EB9C737EDF4CF52F3E , 0x018EAFA6892973999E074162191B4618 , 0x018EB4C857F97135A7AB8E70838D834A , 0x018EB4B122137016AF964D89BE3615CC , 0x018ED7CFA14672019CADF501ED1E7575 );
Copy
0.77 ms (14.75%)
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
"KRI320j "
]
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 = 'KRI320j' LIMIT 1 ;
Copy
0.67 ms (12.92%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb79f-5c08-7137-8b61-7856caeb319f' ), 41.975322723389 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb79e-ce0d-7264-b262-c13d590e966c' ), 41.975322723389 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb7a0-ae1f-7100-813c-92d9137291b6' ), 31.435569763184 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb7a0-4faf-7138-aba4-0bc4f68c243d' ), 31.435569763184 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb7a1-1d4f-70f6-a780-16df2d774828' ), 31.435569763184 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018edef0-98d2-72f0-9b22-6eb7e85312be' ), 31.435569763184 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018ecdec-ee36-7313-a5c9-805a70453d4a' ), 10.539752960205 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018ee346-5899-70b4-8de6-3000741a110f' ), 10.539752960205 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb055-9eb3-71c0-adad-dff736ad961e' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb0c1-e0d3-73d2-b2cd-080db448e4b8' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb0c8-6d98-7140-bc4e-296ff2f4ddd8' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb764-3eeb-7032-9925-46f3deec9451' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb7a2-31f0-7257-8798-36ea9b7dd9ed' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb7d2-0367-7310-bc77-48e97868a7d4' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb792-3372-7225-8372-8a9fd54dfc08' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eceac-0aca-71e5-b060-8a87733c410c' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018edef2-eb85-7092-b278-a473982ecd45' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018ee369-be0e-72eb-9c73-7edf4cf52f3e' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eafa6-8929-7399-9e07-4162191b4618' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb4c8-57f9-7135-a7ab-8e70838d834a' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb4b1-2213-7016-af96-4d89be3615cc' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018ed7cf-a146-7201-9cad-f501ed1e7575' ), 7.1943426132202 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb79f-5c08-7137-8b61-7856caeb319f'
),
41.975322723389
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb79e-ce0d-7264-b262-c13d590e966c'
),
41.975322723389
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb7a0-ae1f-7100-813c-92d9137291b6'
),
31.435569763184
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb7a0-4faf-7138-aba4-0bc4f68c243d'
),
31.435569763184
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb7a1-1d4f-70f6-a780-16df2d774828'
),
31.435569763184
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018edef0-98d2-72f0-9b22-6eb7e85312be'
),
31.435569763184
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018ecdec-ee36-7313-a5c9-805a70453d4a'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018ee346-5899-70b4-8de6-3000741a110f'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb055-9eb3-71c0-adad-dff736ad961e'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb0c1-e0d3-73d2-b2cd-080db448e4b8'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb0c8-6d98-7140-bc4e-296ff2f4ddd8'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb764-3eeb-7032-9925-46f3deec9451'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb7a2-31f0-7257-8798-36ea9b7dd9ed'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb7d2-0367-7310-bc77-48e97868a7d4'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb792-3372-7225-8372-8a9fd54dfc08'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eceac-0aca-71e5-b060-8a87733c410c'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018edef2-eb85-7092-b278-a473982ecd45'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018ee369-be0e-72eb-9c73-7edf4cf52f3e'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eafa6-8929-7399-9e07-4162191b4618'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb4c8-57f9-7135-a7ab-8e70838d834a'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018eb4b1-2213-7016-af96-4d89be3615cc'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb79f-ce01-70e8-b410-42ffcfb6a36b'
),
UUID_TO_BIN (
'018ed7cf-a146-7201-9cad-f501ed1e7575'
),
7.1943426132202
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb79f-5c08-7137-8b61-7856caeb319f' ), 41.975322723389 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb79e-ce0d-7264-b262-c13d590e966c' ), 41.975322723389 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb7a0-ae1f-7100-813c-92d9137291b6' ), 31.435569763184 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb7a0-4faf-7138-aba4-0bc4f68c243d' ), 31.435569763184 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb7a1-1d4f-70f6-a780-16df2d774828' ), 31.435569763184 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018edef0-98d2-72f0-9b22-6eb7e85312be' ), 31.435569763184 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018ecdec-ee36-7313-a5c9-805a70453d4a' ), 10.539752960205 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018ee346-5899-70b4-8de6-3000741a110f' ), 10.539752960205 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb055-9eb3-71c0-adad-dff736ad961e' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb0c1-e0d3-73d2-b2cd-080db448e4b8' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb0c8-6d98-7140-bc4e-296ff2f4ddd8' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb764-3eeb-7032-9925-46f3deec9451' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb7a2-31f0-7257-8798-36ea9b7dd9ed' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb7d2-0367-7310-bc77-48e97868a7d4' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb792-3372-7225-8372-8a9fd54dfc08' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eceac-0aca-71e5-b060-8a87733c410c' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018edef2-eb85-7092-b278-a473982ecd45' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018ee369-be0e-72eb-9c73-7edf4cf52f3e' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eafa6-8929-7399-9e07-4162191b4618' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb4c8-57f9-7135-a7ab-8e70838d834a' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018eb4b1-2213-7016-af96-4d89be3615cc' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb79f-ce01-70e8-b410-42ffcfb6a36b' ), UUID_TO_BIN ('018ed7cf-a146-7201-9cad-f501ed1e7575' ), 7.1943426132202 )
;
Copy