1.06 ms (19.50%)
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
"j7_VbwL "
]
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 = 'j7_VbwL' LIMIT 1 ;
Copy
0.95 ms (17.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 ޝ³Õtqõ‡Y¡‰Ë"\x03 É "
b"\x01 ޝ³è=s\f …,ypã\j‡ "
b"\x01 ¯´\x08 ~q K†š$åž "
b"\x01 ޝ³¢Âq\x1D ¦×Tªš½Á« "
b"\x01 ޝ³÷lsJ¢š\t §\x1A ªÚ{ "
b"\x01 ޝ³³\x0E qÒ¾\x03 W±a™§0 "
b"\x01 ޝ´\e ¾rû‡Š’ÈCXêÙ "
b"\x01 ޝ´U\x16 rn£^ŸÁâ:z' "
b"\x01 ޝ´,\x1F q+¤ãÀ°+6ªq "
b"\x01 ޝ´;@rg§'\x0F c1\v ñv "
b"\x01 ޝ®Ã\x02 pi‰b:×=Žfž "
b"\x01 ްë‚ýr\x10 œ•IZ£Ãªe "
b"\x01 ½¡SsºüÀ&\x03 ÛàV "
b"\x01 ŽÉ\x17 ]\x16 p»²'ˆB\f -ÁŽ "
b"\x01 ŽÉ\x18 ³rr\x7F ¾¨H{B0¿õ "
b"\x01 É\x19\x17\x11 qX‡\x04\x17 ž\t\x13 t "
b"\x01 ŽÉ\x16 ûÙs6‹þá\e ±BÜý "
b"\x01 ŽÉ\x17 •\x16 sޏIŒ4k—,I "
]
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 (0x018EAFB3D57471F58759A189CB2203C9 , 0x018EAFB3E83D730C852C7970E35C6A87 , 0x018EAFB4087E71A08E8F4B869A24E59E , 0x018EAFB3A2C2711DA6D754AA9ABDC1AB , 0x018EAFB3F76C734AA29A09A71AAADA7B , 0x018EAFB3B30E71D2BE0357B16199A730 , 0x018EAFB41BBE72FB878A92C84358EAD9 , 0x018EAFB45516726EA35E9FC1E23A7A27 , 0x018EAFB42C1F712BA4E3C0B02B36AA71 , 0x018EAFB43B407267A7270F63310BF176 , 0x018EAFAEC302706989623AD73D8E669E , 0x018EB0EB82FD72109C95495AA3C3AA65 , 0x018EBD9FA15373BA81FCC02603DBE056 , 0x018EC9175D1670BBB22788420C2DC18E , 0x018EC918B372727FBEA8487B4230BFF5 , 0x018EC919171171588704179E0913749D , 0x018EC916FBD973368BFEE11BB142DCFD , 0x018EC9179516738EB8498C346B972C49 );
Copy
0.56 ms (10.18%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb3-d574-71f5-8759-a189cb2203c9' ), 41.217834472656 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb3-e83d-730c-852c-7970e35c6a87' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb4-087e-71a0-8e8f-4b869a24e59e' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb3-a2c2-711d-a6d7-54aa9abdc1ab' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb3-f76c-734a-a29a-09a71aaada7b' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb3-b30e-71d2-be03-57b16199a730' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb4-1bbe-72fb-878a-92c84358ead9' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb4-5516-726e-a35e-9fc1e23a7a27' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb4-2c1f-712b-a4e3-c0b02b36aa71' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb4-3b40-7267-a727-0f63310bf176' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafae-c302-7069-8962-3ad73d8e669e' ), 6.6434640884399 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eb0eb-82fd-7210-9c95-495aa3c3aa65' ), 6.6434640884399 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ebd9f-a153-73ba-81fc-c02603dbe056' ), 6.6434640884399 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ec917-5d16-70bb-b227-88420c2dc18e' ), 6.34787940979 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ec918-b372-727f-bea8-487b4230bff5' ), 6.34787940979 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ec919-1711-7158-8704-179e0913749d' ), 6.34787940979 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ec916-fbd9-7336-8bfe-e11bb142dcfd' ), 6.34787940979 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ec917-9516-738e-b849-8c346b972c49' ), 6.34787940979 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eafb3-d574-71f5-8759-a189cb2203c9'
),
41.217834472656
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eafb3-e83d-730c-852c-7970e35c6a87'
),
27.380027770996
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eafb4-087e-71a0-8e8f-4b869a24e59e'
),
27.380027770996
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eafb3-a2c2-711d-a6d7-54aa9abdc1ab'
),
27.380027770996
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eafb3-f76c-734a-a29a-09a71aaada7b'
),
27.380027770996
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eafb3-b30e-71d2-be03-57b16199a730'
),
27.380027770996
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eafb4-1bbe-72fb-878a-92c84358ead9'
),
27.380027770996
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eafb4-5516-726e-a35e-9fc1e23a7a27'
),
27.380027770996
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eafb4-2c1f-712b-a4e3-c0b02b36aa71'
),
27.380027770996
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eafb4-3b40-7267-a727-0f63310bf176'
),
27.380027770996
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eafae-c302-7069-8962-3ad73d8e669e'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018eb0eb-82fd-7210-9c95-495aa3c3aa65'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018ebd9f-a153-73ba-81fc-c02603dbe056'
),
6.6434640884399
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018ec917-5d16-70bb-b227-88420c2dc18e'
),
6.34787940979
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018ec918-b372-727f-bea8-487b4230bff5'
),
6.34787940979
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018ec919-1711-7158-8704-179e0913749d'
),
6.34787940979
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018ec916-fbd9-7336-8bfe-e11bb142dcfd'
),
6.34787940979
),
(
UUID_TO_BIN (
'018eafb3-c5ef-726b-bffb-6141be9e8a6b'
),
UUID_TO_BIN (
'018ec917-9516-738e-b849-8c346b972c49'
),
6.34787940979
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb3-d574-71f5-8759-a189cb2203c9' ), 41.217834472656 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb3-e83d-730c-852c-7970e35c6a87' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb4-087e-71a0-8e8f-4b869a24e59e' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb3-a2c2-711d-a6d7-54aa9abdc1ab' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb3-f76c-734a-a29a-09a71aaada7b' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb3-b30e-71d2-be03-57b16199a730' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb4-1bbe-72fb-878a-92c84358ead9' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb4-5516-726e-a35e-9fc1e23a7a27' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb4-2c1f-712b-a4e3-c0b02b36aa71' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafb4-3b40-7267-a727-0f63310bf176' ), 27.380027770996 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eafae-c302-7069-8962-3ad73d8e669e' ), 6.6434640884399 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018eb0eb-82fd-7210-9c95-495aa3c3aa65' ), 6.6434640884399 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ebd9f-a153-73ba-81fc-c02603dbe056' ), 6.6434640884399 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ec917-5d16-70bb-b227-88420c2dc18e' ), 6.34787940979 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ec918-b372-727f-bea8-487b4230bff5' ), 6.34787940979 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ec919-1711-7158-8704-179e0913749d' ), 6.34787940979 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ec916-fbd9-7336-8bfe-e11bb142dcfd' ), 6.34787940979 ), (UUID_TO_BIN ('018eafb3-c5ef-726b-bffb-6141be9e8a6b' ), UUID_TO_BIN ('018ec917-9516-738e-b849-8c346b972c49' ), 6.34787940979 )
;
Copy