0.91 ms (18.56%)
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
"S_VASo9 "
]
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 = 'S_VASo9' LIMIT 1 ;
Copy
0.82 ms (16.59%)
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 ޝ¤bˆsô‹Dk9ô~a\x03 "
b"\x01 ޝ£æüqÞºÎ&Ë|ø¸ "
b"\x01 ޝ¡Br\x06 È–Ûû¥,ÿ "
b"\x01 ޝ¢›Ðp\x0E ¦ôß·Py6s "
b"\x01 ޝ£—£p~ îå.Kžê´ "
b"\x01 ¯¤A'rÎ’,ùçû–\x15 "
b"\x01 ޝ¤\r ªqþº\t KÓ\x1E òsœ "
b"\x01 ޝ ó´p¿ùž›~¬\x02 è "
b"\x01 ޝ£Ñ:p3‚qíÜs\x1E ,˜ "
b"\x01 ¯£·¨qD‘èg*DÐá "
b"\x01 ޝ¢„\x04 pø‹K2ò^hê· "
b"\x01 ޝ£yØqæ¢Fj\x07 Ÿ›\x02 d "
b"\x01 ޝ¡k\x0F rï¿—›ÝN+\x15 J "
b"\x01 ¯¤'\x1C q@‘-ùlÕ\x03 j "
b"\x01 ›BL=ÁrD \‰!%ÃK› "
b"\x01 °â*Öq^°ƒŠÑ“\x18 c "
b"\x01 ްÑg5p-’É^\x1D àtî¢ "
b"\x01 ޵)Œ¨pªc"]®B¢_ "
b"\x01 ŽÃ{RÓq\f ¡Ó»\x7F BDLI "
b"\x01 ×4ñ\x1D p§\x03 å\x18 {ð\x1E ˜ "
b"\x01 Ž×OvAp\x0E ¥4É]«\x1D ÷\t "
b"\x01 Ž×P³Epc‡œ¡\x08 f\x13 9é "
]
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 (0x018EAFA4628873F48B446B39F47E6103 , 0x018EAFA3E6FC71DEBACE26CB7CADF8B8 , 0x018EAFA1AD427206A0C896DBFBA52CFF , 0x018EAFA29BD0700EA6F4DFB750793673 , 0x018EAFA397A3707EA0EEE52E4B9EEAB4 , 0x018EAFA4412772CE90922CF9E7FB9615 , 0x018EAFA40DAA71FEBA094BD31EF2739C , 0x018EAFA0F3B470BFADF99E9B7EAC02E8 , 0x018EAFA3D13A70338271EDDC731E2C98 , 0x018EAFA3B7A8714491E8672A44D0E19D , 0x018EAFA2840470F88B4B32F25E68EAB7 , 0x018EAFA379D871E6A2466A079F9B0264 , 0x018EAFA16B0F72EFBF979BDD4E2B154A , 0x018EAFA4271C7140912D8FF96CD5036A , 0x019B424C3DC17244A05C892125C34B9B , 0x018EB0E22AD6715EB0838AD193901863 , 0x018EB0D16735702D92C95E1DE074EEA2 , 0x018EB5298CA870ADAA63225DAE42A25F , 0x018EC37B52D3710CA1D3BB7F42444C49 , 0x018ED734F11D7081A703E5187BF01E98 , 0x018ED74F7641700EA534C95DAB1DF709 , 0x018ED750B3457063879CA108661339E9 );
Copy
0.65 ms (13.24%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa4-6288-73f4-8b44-6b39f47e6103' ), 38.93941116333 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa3-e6fc-71de-bace-26cb7cadf8b8' ), 36.499359130859 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa1-ad42-7206-a0c8-96dbfba52cff' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa2-9bd0-700e-a6f4-dfb750793673' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa3-97a3-707e-a0ee-e52e4b9eeab4' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa4-4127-72ce-9092-2cf9e7fb9615' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa4-0daa-71fe-ba09-4bd31ef2739c' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa0-f3b4-70bf-adf9-9e9b7eac02e8' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa3-d13a-7033-8271-eddc731e2c98' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa3-b7a8-7144-91e8-672a44d0e19d' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa2-8404-70f8-8b4b-32f25e68eab7' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa3-79d8-71e6-a246-6a079f9b0264' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa1-6b0f-72ef-bf97-9bdd4e2b154a' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa4-271c-7140-912d-8ff96cd5036a' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('019b424c-3dc1-7244-a05c-892125c34b9b' ), 10.539752960205 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eb0e2-2ad6-715e-b083-8ad193901863' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eb0d1-6735-702d-92c9-5e1de074eea2' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eb529-8ca8-70ad-aa63-225dae42a25f' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018ed734-f11d-7081-a703-e5187bf01e98' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018ed74f-7641-700e-a534-c95dab1df709' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018ed750-b345-7063-879c-a108661339e9' ), 7.95538854599 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa4-6288-73f4-8b44-6b39f47e6103'
),
38.93941116333
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa3-e6fc-71de-bace-26cb7cadf8b8'
),
36.499359130859
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa1-ad42-7206-a0c8-96dbfba52cff'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa2-9bd0-700e-a6f4-dfb750793673'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa3-97a3-707e-a0ee-e52e4b9eeab4'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa4-4127-72ce-9092-2cf9e7fb9615'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa4-0daa-71fe-ba09-4bd31ef2739c'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa0-f3b4-70bf-adf9-9e9b7eac02e8'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa3-d13a-7033-8271-eddc731e2c98'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa3-b7a8-7144-91e8-672a44d0e19d'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa2-8404-70f8-8b4b-32f25e68eab7'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa3-79d8-71e6-a246-6a079f9b0264'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa1-6b0f-72ef-bf97-9bdd4e2b154a'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eafa4-271c-7140-912d-8ff96cd5036a'
),
25.959608078003
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'019b424c-3dc1-7244-a05c-892125c34b9b'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eb0e2-2ad6-715e-b083-8ad193901863'
),
7.95538854599
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eb0d1-6735-702d-92c9-5e1de074eea2'
),
7.95538854599
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018eb529-8ca8-70ad-aa63-225dae42a25f'
),
7.95538854599
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018ec37b-52d3-710c-a1d3-bb7f42444c49'
),
7.95538854599
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018ed734-f11d-7081-a703-e5187bf01e98'
),
7.95538854599
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018ed74f-7641-700e-a534-c95dab1df709'
),
7.95538854599
),
(
UUID_TO_BIN (
'018eafa2-1d05-72ff-b68c-04f3c73b411b'
),
UUID_TO_BIN (
'018ed750-b345-7063-879c-a108661339e9'
),
7.95538854599
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa4-6288-73f4-8b44-6b39f47e6103' ), 38.93941116333 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa3-e6fc-71de-bace-26cb7cadf8b8' ), 36.499359130859 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa1-ad42-7206-a0c8-96dbfba52cff' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa2-9bd0-700e-a6f4-dfb750793673' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa3-97a3-707e-a0ee-e52e4b9eeab4' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa4-4127-72ce-9092-2cf9e7fb9615' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa4-0daa-71fe-ba09-4bd31ef2739c' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa0-f3b4-70bf-adf9-9e9b7eac02e8' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa3-d13a-7033-8271-eddc731e2c98' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa3-b7a8-7144-91e8-672a44d0e19d' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa2-8404-70f8-8b4b-32f25e68eab7' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa3-79d8-71e6-a246-6a079f9b0264' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa1-6b0f-72ef-bf97-9bdd4e2b154a' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eafa4-271c-7140-912d-8ff96cd5036a' ), 25.959608078003 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('019b424c-3dc1-7244-a05c-892125c34b9b' ), 10.539752960205 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eb0e2-2ad6-715e-b083-8ad193901863' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eb0d1-6735-702d-92c9-5e1de074eea2' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018eb529-8ca8-70ad-aa63-225dae42a25f' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018ec37b-52d3-710c-a1d3-bb7f42444c49' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018ed734-f11d-7081-a703-e5187bf01e98' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018ed74f-7641-700e-a534-c95dab1df709' ), 7.95538854599 ), (UUID_TO_BIN ('018eafa2-1d05-72ff-b68c-04f3c73b411b' ), UUID_TO_BIN ('018ed750-b345-7063-879c-a108661339e9' ), 7.95538854599 )
;
Copy