0.93 ms (18.38%)
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 ´¢¶Ipÿ¤4ä\x1C\x06\x04 Ž• "
b"\x01 Ž´£TXpM”ûÕøz»¼L "
b"\x01 Ž´£\x0F\x00 qû ÈAî~pÌ[ "
b"\x01 Ž´¢içq¥½<˜¾B%s\x1D "
b"\x01 ×\x12 AþpªOu1ßöø\x00 "
b"\x01 ×\x10 ¼çr]¸\x06 PZ(\v Ð "
b"\x01 ×\x11 š~sΓǢ~nÁ" "
b"\x01 Ž×\x10 ä[så´iú \x10 Y,\v "
b"\x01 ¯hDq\x14 ŽÊÈA_ü°÷ "
b"\x01 ¯š+§sÔ–Ó„»\x1C ×\x05 "
b"\x01 ޝ—ycp\x18 ©“UytËÆp "
b"\x01 ޝ½K„q~¯öí<\x14 ªã\f "
b"\x01 ޝÍbNs\x18 ž£Ë@•ñÕú "
b"\x01 ް\ûërFƒIš\x7F ØÎe\x08 "
b"\x01 ް‡ÙÎq¡«ø•&ìdõ¢ "
b"\x01 ްåëSpЉ^–Û\x0F ‚çJ "
b"\x01 Ίáäp\x11 Ë‚\x15 öÅ®á "
b"\x01 ›‰ë\x17 Hq*u·µÐ "
]
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 (0x018EB4A2B64970FFA434E41C06048D95 , 0x018EB4A35458704D94FBD5F87ABBBC4C , 0x018EB4A30F0071FBA0C841EE7E70CC5B , 0x018EB4A269E771A5BD3C98BE4225731D , 0x018ED71241FE70AA904F7531DFF6F800 , 0x018ED710BCE7725DB806505A81280BD0 , 0x018ED7119A7E73CE93C7A27E6E9DC122 , 0x018ED710E45B73E5B469FAA010592C0B , 0x018EAF9D684471148DCAC8415FFCB0F7 , 0x018EAF9A2BA773D496D3848FBB1CD705 , 0x018EAF9779637018A993557974CBC670 , 0x018EAFBD4B84717EAFF6ED3C14AAE30C , 0x018EAFCD624E73189EA3CB4095F1D5FA , 0x018EB05CFBEB724683499A7FD8CE6508 , 0x018EB087D9CE71A1ABF89526EC64F5A2 , 0x018EB0E5EB53708A895E96DB0F82E74A , 0x018ECE8AE1E470119DCB8215F6C5AEE1 , 0x019B89EB174871EF8D9F982A75B7B5D0 );
Copy
0.67 ms (13.23%)
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
"itZWiIo "
]
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 = 'itZWiIo' LIMIT 1 ;
Copy
0.64 ms (12.67%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb4a2-b649-70ff-a434-e41c06048d95' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb4a3-5458-704d-94fb-d5f87abbbc4c' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb4a3-0f00-71fb-a0c8-41ee7e70cc5b' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb4a2-69e7-71a5-bd3c-98be4225731d' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018ed712-41fe-70aa-904f-7531dff6f800' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018ed710-bce7-725d-b806-505a81280bd0' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018ed711-9a7e-73ce-93c7-a27e6e9dc122' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018ed710-e45b-73e5-b469-faa010592c0b' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eaf9d-6844-7114-8dca-c8415ffcb0f7' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eaf9a-2ba7-73d4-96d3-848fbb1cd705' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eaf97-7963-7018-a993-557974cbc670' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eafbd-4b84-717e-aff6-ed3c14aae30c' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eafcd-624e-7318-9ea3-cb4095f1d5fa' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb05c-fbeb-7246-8349-9a7fd8ce6508' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb087-d9ce-71a1-abf8-9526ec64f5a2' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb0e5-eb53-708a-895e-96db0f82e74a' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018ece8a-e1e4-7011-9dcb-8215f6c5aee1' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('019b89eb-1748-71ef-8d9f-982a75b7b5d0' ), 7.1943426132202 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eb4a2-b649-70ff-a434-e41c06048d95'
),
30.677803039551
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eb4a3-5458-704d-94fb-d5f87abbbc4c'
),
30.677803039551
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eb4a3-0f00-71fb-a0c8-41ee7e70cc5b'
),
30.677803039551
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eb4a2-69e7-71a5-bd3c-98be4225731d'
),
30.677803039551
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018ed712-41fe-70aa-904f-7531dff6f800'
),
30.677803039551
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018ed710-bce7-725d-b806-505a81280bd0'
),
30.677803039551
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018ed711-9a7e-73ce-93c7-a27e6e9dc122'
),
30.677803039551
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018ed710-e45b-73e5-b469-faa010592c0b'
),
30.677803039551
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eaf9d-6844-7114-8dca-c8415ffcb0f7'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eaf9a-2ba7-73d4-96d3-848fbb1cd705'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eaf97-7963-7018-a993-557974cbc670'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eafbd-4b84-717e-aff6-ed3c14aae30c'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eafcd-624e-7318-9ea3-cb4095f1d5fa'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eb05c-fbeb-7246-8349-9a7fd8ce6508'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eb087-d9ce-71a1-abf8-9526ec64f5a2'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018eb0e5-eb53-708a-895e-96db0f82e74a'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'018ece8a-e1e4-7011-9dcb-8215f6c5aee1'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018eb4a2-2d25-713e-aaab-e2d7e54a8a8b'
),
UUID_TO_BIN (
'019b89eb-1748-71ef-8d9f-982a75b7b5d0'
),
7.1943426132202
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb4a2-b649-70ff-a434-e41c06048d95' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb4a3-5458-704d-94fb-d5f87abbbc4c' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb4a3-0f00-71fb-a0c8-41ee7e70cc5b' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb4a2-69e7-71a5-bd3c-98be4225731d' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018ed712-41fe-70aa-904f-7531dff6f800' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018ed710-bce7-725d-b806-505a81280bd0' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018ed711-9a7e-73ce-93c7-a27e6e9dc122' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018ed710-e45b-73e5-b469-faa010592c0b' ), 30.677803039551 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eaf9d-6844-7114-8dca-c8415ffcb0f7' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eaf9a-2ba7-73d4-96d3-848fbb1cd705' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eaf97-7963-7018-a993-557974cbc670' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eafbd-4b84-717e-aff6-ed3c14aae30c' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eafcd-624e-7318-9ea3-cb4095f1d5fa' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb05c-fbeb-7246-8349-9a7fd8ce6508' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb087-d9ce-71a1-abf8-9526ec64f5a2' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018eb0e5-eb53-708a-895e-96db0f82e74a' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('018ece8a-e1e4-7011-9dcb-8215f6c5aee1' ), 7.1943426132202 ), (UUID_TO_BIN ('018eb4a2-2d25-713e-aaab-e2d7e54a8a8b' ), UUID_TO_BIN ('019b89eb-1748-71ef-8d9f-982a75b7b5d0' ), 7.1943426132202 )
;
Copy