0.90 ms (9.63%)
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 ÞèÈq—†\x1A Å¥µÛº "
b"\x01 ŽÞç@¹rx§r:èþH4™ "
b"\x01 Ž·–Û\v q9´¼z}ymôN "
b"\x01 Ž·— ãqݯFˆ{¼¸œB "
b"\x01 Ž·—Õ‚s¶¯ÉÑ‚øÃM¹ "
b"\x01 Ž·˜'\x14 pÒ½\x07 ‘Ú£ÿìV "
b"\x01 Ž·–1\x04 qá¸NÁܸH\x04 þ "
b"\x01 ·•°r8„Ž©-p\x14 È "
b"\x01 Ž·—v,rÅ–\x1A Xðr\x1F YË "
b"\x01 ŽãíM^sÜ¢$ø‹ýN#¿ "
b"\x01 Þésq™™Ìý¹‰L7 "
b"\x01 ŽÞèI'sô¿·ã˱\x13 ¶í "
b"\x01 ŽÞéð)p>¬üĦ/Jtô "
b"\x01 ŽãY\x01 bse£/÷¤Ú®ì6 "
b"\x01 ް^\x7F =r³‡£ñ²yàä¤ "
b"\x01 ްÂFBsfšFÑ·\x13 Y;@ "
b"\x01 ޵A\x02 öq×®@Òö\x15\x16 Pº "
b"\x01 ŽÃp0!pމ͌›v~r¹ "
b"\x01 ŽÞÜJds°”/Âþ3?d0 "
]
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 (0x018EDEE8C8817197861AC5A5B5DBBAAD , 0x018EDEE740B97278A7723AE8FE483499 , 0x018EB796DB0B7139B4BC7A7D796DF44E , 0x018EB79720E371DDAF46887BBCB89C42 , 0x018EB797D58273B6AFC9D182F8C34DB9 , 0x018EB798271470D2BD0791DAA3FFEC56 , 0x018EB796310471E1B84EC1DCB84804FE , 0x018EB795B09F7238848DA92D701420C8 , 0x018EB797762C72C5961A58F0721F59CB , 0x018EE3ED4D5E73DCA224F88BFD4E23BF , 0x018EDEE98173719999CCFDB9894C3781 , 0x018EDEE8492773F4BFB7E3CBB113B6ED , 0x018EDEE9F029703EACFCC4A62F4A74F4 , 0x018EE35901627365A32FF7A4DAAEEC36 , 0x018EB05E7F3D72B387A3F1B279E0E4A4 , 0x018EB0C2464273669A46D1B713593B40 , 0x018EB54102F671D7AE40D2F6151650BA , 0x018EC370302170DE89CD8C9B767E72B9 , 0x018EDEDC4A6473B0942FC2FE333F6430 );
Copy
0.81 ms (8.65%)
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
"hQGZDEZ "
]
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 = 'hQGZDEZ' LIMIT 1 ;
Copy
0.60 ms (6.35%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018edee8-c881-7197-861a-c5a5b5dbbaad' ), 45.284934997559 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018edee7-40b9-7278-a772-3ae8fe483499' ), 33.570816040039 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb796-db0b-7139-b4bc-7a7d796df44e' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb797-20e3-71dd-af46-887bbcb89c42' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb797-d582-73b6-afc9-d182f8c34db9' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb798-2714-70d2-bd07-91daa3ffec56' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb796-3104-71e1-b84e-c1dcb84804fe' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb795-b09f-7238-848d-a92d701420c8' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb797-762c-72c5-961a-58f0721f59cb' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018ee3ed-4d5e-73dc-a224-f88bfd4e23bf' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018edee9-8173-7199-99cc-fdb9894c3781' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018edee8-4927-73f4-bfb7-e3cbb113b6ed' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018edee9-f029-703e-acfc-c4a62f4a74f4' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018ee359-0162-7365-a32f-f7a4daaeec36' ), 9.7441358566284 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb05e-7f3d-72b3-87a3-f1b279e0e4a4' ), 8.6757850646973 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb0c2-4642-7366-9a46-d1b713593b40' ), 8.6757850646973 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb541-02f6-71d7-ae40-d2f6151650ba' ), 8.6757850646973 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018ec370-3021-70de-89cd-8c9b767e72b9' ), 8.6757850646973 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018ededc-4a64-73b0-942f-c2fe333f6430' ), 8.6757850646973 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018edee8-c881-7197-861a-c5a5b5dbbaad'
),
45.284934997559
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018edee7-40b9-7278-a772-3ae8fe483499'
),
33.570816040039
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018eb796-db0b-7139-b4bc-7a7d796df44e'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018eb797-20e3-71dd-af46-887bbcb89c42'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018eb797-d582-73b6-afc9-d182f8c34db9'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018eb798-2714-70d2-bd07-91daa3ffec56'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018eb796-3104-71e1-b84e-c1dcb84804fe'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018eb795-b09f-7238-848d-a92d701420c8'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018eb797-762c-72c5-961a-58f0721f59cb'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018ee3ed-4d5e-73dc-a224-f88bfd4e23bf'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018edee9-8173-7199-99cc-fdb9894c3781'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018edee8-4927-73f4-bfb7-e3cbb113b6ed'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018edee9-f029-703e-acfc-c4a62f4a74f4'
),
13.28692817688
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018ee359-0162-7365-a32f-f7a4daaeec36'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018eb05e-7f3d-72b3-87a3-f1b279e0e4a4'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018eb0c2-4642-7366-9a46-d1b713593b40'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018eb541-02f6-71d7-ae40-d2f6151650ba'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018ec370-3021-70de-89cd-8c9b767e72b9'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018ee3eb-1d07-71ea-8894-044c6243867c'
),
UUID_TO_BIN (
'018ededc-4a64-73b0-942f-c2fe333f6430'
),
8.6757850646973
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018edee8-c881-7197-861a-c5a5b5dbbaad' ), 45.284934997559 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018edee7-40b9-7278-a772-3ae8fe483499' ), 33.570816040039 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb796-db0b-7139-b4bc-7a7d796df44e' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb797-20e3-71dd-af46-887bbcb89c42' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb797-d582-73b6-afc9-d182f8c34db9' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb798-2714-70d2-bd07-91daa3ffec56' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb796-3104-71e1-b84e-c1dcb84804fe' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb795-b09f-7238-848d-a92d701420c8' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb797-762c-72c5-961a-58f0721f59cb' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018ee3ed-4d5e-73dc-a224-f88bfd4e23bf' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018edee9-8173-7199-99cc-fdb9894c3781' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018edee8-4927-73f4-bfb7-e3cbb113b6ed' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018edee9-f029-703e-acfc-c4a62f4a74f4' ), 13.28692817688 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018ee359-0162-7365-a32f-f7a4daaeec36' ), 9.7441358566284 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb05e-7f3d-72b3-87a3-f1b279e0e4a4' ), 8.6757850646973 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb0c2-4642-7366-9a46-d1b713593b40' ), 8.6757850646973 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018eb541-02f6-71d7-ae40-d2f6151650ba' ), 8.6757850646973 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018ec370-3021-70de-89cd-8c9b767e72b9' ), 8.6757850646973 ), (UUID_TO_BIN ('018ee3eb-1d07-71ea-8894-044c6243867c' ), UUID_TO_BIN ('018ededc-4a64-73b0-942f-c2fe333f6430' ), 8.6757850646973 )
;
Copy