0.88 ms (18.26%)
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 °0`ds1ìiQN†\x00 { "
b"\x01 °0¬òqj_<AW{$• "
b"\x01 °08Æsÿ¢äðé¼\x1E ¯ "
b"\x01 °0Ø©q¥f\x1F ã%îǤ "
b"\x01 ް0zíp¸¦òB\x1E ¨I ¬ "
b"\x01 ް0”sp7”þ[ÒÆûšt "
b"\x01 ް0Äâr¢¶ëvè´Âši "
b"\x01 ްhÍûrà«’¯ÔU‹Ê\x7F "
b"\x01 °hÞsgc\t ð\x17 '"“ "
b"\x01 ްhBsfŒÎ´Ì©Ÿ§ "
b"\x01 ްh`Òq3±\f ºß\r 9X” "
b"\x01 ްi\e usŸ¢~4\x07 oµ\x19 m "
b"\x01 ްhQŸsAˆØl%luáµ "
b"\x01 °i)-p(¸\x01 wçR?Žå "
b"\x01 °h»\x1F s¤Ž¥zcfvV2 "
b"\x01 ްhíÖp\x12 “~±nÔC-\x01 "
b"\x01 ްi\f ^pœ¬“ºè´i¶T "
b"\x01 °hqÞ¨¾"ªö©O\x15 "
b"\x01 ްhÿ{r\x19 ³v\r Å’aÌ\x1D "
b"\x01 °h4p狇¼y!üfœ "
b"\x01 ްhr5pÓ†\v KÞt\x11 î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 (0x018EB0306064733190EC69514E86007B , 0x018EB030ACF2716A905F3C41577B2495 , 0x018EB03038C673FFA2E4F0E9BC1EAF90 , 0x018EB030D8A97181A5661FE325EEC7A4 , 0x018EB0307AED70B8A6F2421EA84920AC , 0x018EB0309473703794FE5BD2C6FB9A74 , 0x018EB030C4E272A2B6EB76E8B4C29A69 , 0x018EB068CDFB72E0AB92AFD4558BCA7F , 0x018EB068DE8173679D6309F017272293 , 0x018EB068AD4273668CCEB4CCA9AD9FA7 , 0x018EB06860D27133B10CBADF0D395894 , 0x018EB0691B75739FA27E34076FB5196D , 0x018EB068519F734188D86C256C75E1B5 , 0x018EB069292D7028B80177E7523F8DE5 , 0x018EB068BB1F73A48DA57A6366765632 , 0x018EB068EDD67012937EB16ED4432D01 , 0x018EB0690C5E709CAC93BAE8B469B654 , 0x018EB068908171DEA8BE22AAF6A94F15 , 0x018EB068FF7B7219B3760DC59261CC1D , 0x018EB068813470E78B87BC7921FC669C , 0x018EB068723570D3860B4BDE7411EE75 );
Copy
0.67 ms (13.92%)
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
"q3qcsLc "
]
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 = 'q3qcsLc' LIMIT 1 ;
Copy
0.62 ms (12.89%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-6064-7331-90ec-69514e86007b' ), 17.010299682617 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-acf2-716a-905f-3c41577b2495' ), 17.010299682617 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-38c6-73ff-a2e4-f0e9bc1eaf90' ), 17.010299682617 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-d8a9-7181-a566-1fe325eec7a4' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-7aed-70b8-a6f2-421ea84920ac' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-9473-7037-94fe-5bd2c6fb9a74' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-c4e2-72a2-b6eb-76e8b4c29a69' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-cdfb-72e0-ab92-afd4558bca7f' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-de81-7367-9d63-09f017272293' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-ad42-7366-8cce-b4cca9ad9fa7' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-60d2-7133-b10c-badf0d395894' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb069-1b75-739f-a27e-34076fb5196d' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-519f-7341-88d8-6c256c75e1b5' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb069-292d-7028-b801-77e7523f8de5' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-bb1f-73a4-8da5-7a6366765632' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-edd6-7012-937e-b16ed4432d01' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb069-0c5e-709c-ac93-bae8b469b654' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-9081-71de-a8be-22aaf6a94f15' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-ff7b-7219-b376-0dc59261cc1d' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-8134-70e7-8b87-bc7921fc669c' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-7235-70d3-860b-4bde7411ee75' ), 11.34019947052 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb030-6064-7331-90ec-69514e86007b'
),
17.010299682617
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb030-acf2-716a-905f-3c41577b2495'
),
17.010299682617
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb030-38c6-73ff-a2e4-f0e9bc1eaf90'
),
17.010299682617
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb030-d8a9-7181-a566-1fe325eec7a4'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb030-7aed-70b8-a6f2-421ea84920ac'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb030-9473-7037-94fe-5bd2c6fb9a74'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb030-c4e2-72a2-b6eb-76e8b4c29a69'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb068-cdfb-72e0-ab92-afd4558bca7f'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb068-de81-7367-9d63-09f017272293'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb068-ad42-7366-8cce-b4cca9ad9fa7'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb068-60d2-7133-b10c-badf0d395894'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb069-1b75-739f-a27e-34076fb5196d'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb068-519f-7341-88d8-6c256c75e1b5'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb069-292d-7028-b801-77e7523f8de5'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb068-bb1f-73a4-8da5-7a6366765632'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb068-edd6-7012-937e-b16ed4432d01'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb069-0c5e-709c-ac93-bae8b469b654'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb068-9081-71de-a8be-22aaf6a94f15'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb068-ff7b-7219-b376-0dc59261cc1d'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb068-8134-70e7-8b87-bc7921fc669c'
),
11.34019947052
),
(
UUID_TO_BIN (
'018eb068-9f20-726d-b739-7526a5a35ca5'
),
UUID_TO_BIN (
'018eb068-7235-70d3-860b-4bde7411ee75'
),
11.34019947052
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-6064-7331-90ec-69514e86007b' ), 17.010299682617 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-acf2-716a-905f-3c41577b2495' ), 17.010299682617 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-38c6-73ff-a2e4-f0e9bc1eaf90' ), 17.010299682617 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-d8a9-7181-a566-1fe325eec7a4' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-7aed-70b8-a6f2-421ea84920ac' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-9473-7037-94fe-5bd2c6fb9a74' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb030-c4e2-72a2-b6eb-76e8b4c29a69' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-cdfb-72e0-ab92-afd4558bca7f' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-de81-7367-9d63-09f017272293' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-ad42-7366-8cce-b4cca9ad9fa7' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-60d2-7133-b10c-badf0d395894' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb069-1b75-739f-a27e-34076fb5196d' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-519f-7341-88d8-6c256c75e1b5' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb069-292d-7028-b801-77e7523f8de5' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-bb1f-73a4-8da5-7a6366765632' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-edd6-7012-937e-b16ed4432d01' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb069-0c5e-709c-ac93-bae8b469b654' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-9081-71de-a8be-22aaf6a94f15' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-ff7b-7219-b376-0dc59261cc1d' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-8134-70e7-8b87-bc7921fc669c' ), 11.34019947052 ), (UUID_TO_BIN ('018eb068-9f20-726d-b739-7526a5a35ca5' ), UUID_TO_BIN ('018eb068-7235-70d3-860b-4bde7411ee75' ), 11.34019947052 )
;
Copy