0.82 ms (16.46%)
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 °\x01 óøqM¹g¥/II' "
b"""
\x01 ް\x01 Ð\x7F p*—j\f ¶m\n
Gê
"""
b"\x01 ް\x01 â›q¤¼¾¬Ü\x08 ëÀ "
b"\x01 °\x01 ¨£r\x18 މ\e <g”’M "
b"\x01 ¯í\x05 Äp¿Žgó¥,Þ4 "
b"\x01 ޝíW€sS¥\x12\x04 0=çì< "
b"\x01 ޝìËŸsø›„2Ìód¡k "
b"\x01 ¯ìñÞr\x1F ™Óõãu\x1C { "
b"\x01 ޝí-\x05 qS‚(×b~@º< "
b"\x01 ¯ìÜos\x08 èÒ4PY\x1E "
b"\x01 ޝìšûpœµ\x12 _g¶UE9 "
b"\x01 ޝí=àp1žÀëTÂ\x06 63 "
b"\x01 ޝí\x16 çsγÍþË\t “8t "
b"\x01 Ž¯ì²šq¦´©j¦o˜S€ "
b"\x01 ް\x02 7Ðqa‘ÿ…\x03 ÔÁÿŽ "
b"\x01 ½ËT¨pe³EÔï°\x19 • "
b"\x01 Ž·Ø\x11 °s÷«×çžÓíÃÆ "
b"\x01 ޝû¢arù£œcçž+\x16 ´ "
b"\x01 Ž·Š`2pš¶³²\x01\x1A 긅 "
]
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 (0x018EB001F3F8714DB967A52F4949278F , 0x018EB001D07F702A976A0CB66D0A47EA , 0x018EB001E29B71A4BCBEACDC08EBC0C2 , 0x018EB001A8A372188D891B3C6794924D , 0x018EAFED05C470BF8D67F39DA52CDE34 , 0x018EAFED57807353A51204303DE7EC3C , 0x018EAFECCB9F73F89B8432CCF364A16B , 0x018EAFECF1DE721F998FD3F5E3751C7B , 0x018EAFED2D0571538228D7627E40BA3C , 0x018EAFECDC6F73088E90E8D23450591E , 0x018EAFEC9AFB709CB5125F67B6554539 , 0x018EAFED3DE070319EC0EB54C2063633 , 0x018EAFED16E773CEB3CDFECB09933874 , 0x018EAFECB29A71A6B4A96AA66F985380 , 0x018EB00237D0716191FF8503D4C1FF8E , 0x018EBDCB54A87065B345D4EFB0199D95 , 0x018EB7D811B073F7ABD7E79ED3EDC3C6 , 0x018EAFFBA26172F9A39C63E79E2B16B4 , 0x018EB78A6032709AB6B3B2011AEAB885 );
Copy
0.72 ms (14.47%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb001-f3f8-714d-b967-a52f4949278f' ), 50.218353271484 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb001-d07f-702a-976a-0cb66d0a47ea' ), 50.218353271484 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb001-e29b-71a4-bcbe-acdc08ebc0c2' ), 39.678600311279 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), 30.530094146729 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafed-05c4-70bf-8d67-f39da52cde34' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafed-5780-7353-a512-04303de7ec3c' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafec-cb9f-73f8-9b84-32ccf364a16b' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafec-f1de-721f-998f-d3f5e3751c7b' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafed-2d05-7153-8228-d7627e40ba3c' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafec-dc6f-7308-8e90-e8d23450591e' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafec-9afb-709c-b512-5f67b6554539' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafed-3de0-7031-9ec0-eb54c2063633' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafed-16e7-73ce-b3cd-fecb09933874' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafec-b29a-71a6-b4a9-6aa66f985380' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb002-37d0-7161-91ff-8503d4c1ff8e' ), 11.714120864868 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018ebdcb-54a8-7065-b345-d4efb0199d95' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb7d8-11b0-73f7-abd7-e79ed3edc3c6' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eaffb-a261-72f9-a39c-63e79e2b16b4' ), 6.2159013748169 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb78a-6032-709a-b6b3-b2011aeab885' ), 6.2159013748169 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eb001-f3f8-714d-b967-a52f4949278f'
),
50.218353271484
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eb001-d07f-702a-976a-0cb66d0a47ea'
),
50.218353271484
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eb001-e29b-71a4-bcbe-acdc08ebc0c2'
),
39.678600311279
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
30.530094146729
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eafed-05c4-70bf-8d67-f39da52cde34'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eafed-5780-7353-a512-04303de7ec3c'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eafec-cb9f-73f8-9b84-32ccf364a16b'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eafec-f1de-721f-998f-d3f5e3751c7b'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eafed-2d05-7153-8228-d7627e40ba3c'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eafec-dc6f-7308-8e90-e8d23450591e'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eafec-9afb-709c-b512-5f67b6554539'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eafed-3de0-7031-9ec0-eb54c2063633'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eafed-16e7-73ce-b3cd-fecb09933874'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eafec-b29a-71a6-b4a9-6aa66f985380'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eb002-37d0-7161-91ff-8503d4c1ff8e'
),
11.714120864868
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018ebdcb-54a8-7065-b345-d4efb0199d95'
),
9.1485061645508
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eb7d8-11b0-73f7-abd7-e79ed3edc3c6'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eaffb-a261-72f9-a39c-63e79e2b16b4'
),
6.2159013748169
),
(
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
UUID_TO_BIN (
'018eb78a-6032-709a-b6b3-b2011aeab885'
),
6.2159013748169
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb001-f3f8-714d-b967-a52f4949278f' ), 50.218353271484 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb001-d07f-702a-976a-0cb66d0a47ea' ), 50.218353271484 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb001-e29b-71a4-bcbe-acdc08ebc0c2' ), 39.678600311279 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), 30.530094146729 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafed-05c4-70bf-8d67-f39da52cde34' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafed-5780-7353-a512-04303de7ec3c' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafec-cb9f-73f8-9b84-32ccf364a16b' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafec-f1de-721f-998f-d3f5e3751c7b' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafed-2d05-7153-8228-d7627e40ba3c' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafec-dc6f-7308-8e90-e8d23450591e' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafec-9afb-709c-b512-5f67b6554539' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafed-3de0-7031-9ec0-eb54c2063633' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafed-16e7-73ce-b3cd-fecb09933874' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eafec-b29a-71a6-b4a9-6aa66f985380' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb002-37d0-7161-91ff-8503d4c1ff8e' ), 11.714120864868 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018ebdcb-54a8-7065-b345-d4efb0199d95' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb7d8-11b0-73f7-abd7-e79ed3edc3c6' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eaffb-a261-72f9-a39c-63e79e2b16b4' ), 6.2159013748169 ), (UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), UUID_TO_BIN ('018eb78a-6032-709a-b6b3-b2011aeab885' ), 6.2159013748169 )
;
Copy
0.55 ms (11.08%)
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
"X4r9POd "
]
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 = 'X4r9POd' LIMIT 1 ;
Copy