1.24 ms (19.11%)
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 â›q¤¼¾¬Ü\x08 ëÀ "
b"\x01 °\x01 ½\x0E qÂ·É Øžà\x16 "
b"\x01 °\x01 óøqM¹g¥/II' "
b"""
\x01 ް\x01 Ð\x7F p*—j\f ¶m\n
Gê
"""
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 ޝ«Ê\x16 p뻕 ³H¨h‹ "
b"\x01 ޝø\x16 Årƒ©ÆqË´.\„ "
b"\x01 ÎUà³r\x07 ».\x10 ô\v v "
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 (0x018EB001E29B71A4BCBEACDC08EBC0C2 , 0x018EB001BD0E71C2B78FC920D89EE016 , 0x018EB001F3F8714DB967A52F4949278F , 0x018EB001D07F702A976A0CB66D0A47EA , 0x018EAFED05C470BF8D67F39DA52CDE34 , 0x018EAFED57807353A51204303DE7EC3C , 0x018EAFECCB9F73F89B8432CCF364A16B , 0x018EAFECF1DE721F998FD3F5E3751C7B , 0x018EAFED2D0571538228D7627E40BA3C , 0x018EAFECDC6F73088E90E8D23450591E , 0x018EAFEC9AFB709CB5125F67B6554539 , 0x018EAFED3DE070319EC0EB54C2063633 , 0x018EAFED16E773CEB3CDFECB09933874 , 0x018EAFECB29A71A6B4A96AA66F985380 , 0x018EAFABCA1670EBBB95A0B348A8688B , 0x018EAFF816C57283A9C671CBB42E5C84 , 0x018ECE55E0B37207BB2E108FF40B8F76 , 0x018EB7D811B073F7ABD7E79ED3EDC3C6 , 0x018EAFFBA26172F9A39C63E79E2B16B4 , 0x018EB78A6032709AB6B3B2011AEAB885 );
Copy
1.13 ms (17.37%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eb001-e29b-71a4-bcbe-acdc08ebc0c2' ), 30.530094146729 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), 30.530094146729 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eb001-f3f8-714d-b967-a52f4949278f' ), 30.530094146729 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eb001-d07f-702a-976a-0cb66d0a47ea' ), 30.530094146729 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafed-05c4-70bf-8d67-f39da52cde34' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafed-5780-7353-a512-04303de7ec3c' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafec-cb9f-73f8-9b84-32ccf364a16b' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafec-f1de-721f-998f-d3f5e3751c7b' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafed-2d05-7153-8228-d7627e40ba3c' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafec-dc6f-7308-8e90-e8d23450591e' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafec-9afb-709c-b512-5f67b6554539' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafed-3de0-7031-9ec0-eb54c2063633' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafed-16e7-73ce-b3cd-fecb09933874' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafec-b29a-71a6-b4a9-6aa66f985380' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafab-ca16-70eb-bb95-a0b348a8688b' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eaff8-16c5-7283-a9c6-71cbb42e5c84' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018ece55-e0b3-7207-bb2e-108ff40b8f76' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eb7d8-11b0-73f7-abd7-e79ed3edc3c6' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eaffb-a261-72f9-a39c-63e79e2b16b4' ), 6.2159013748169 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), 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-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eb001-e29b-71a4-bcbe-acdc08ebc0c2'
),
30.530094146729
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eb001-bd0e-71c2-b78f-c920d89ee016'
),
30.530094146729
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eb001-f3f8-714d-b967-a52f4949278f'
),
30.530094146729
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eb001-d07f-702a-976a-0cb66d0a47ea'
),
30.530094146729
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eafed-05c4-70bf-8d67-f39da52cde34'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eafed-5780-7353-a512-04303de7ec3c'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eafec-cb9f-73f8-9b84-32ccf364a16b'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eafec-f1de-721f-998f-d3f5e3751c7b'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eafed-2d05-7153-8228-d7627e40ba3c'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eafec-dc6f-7308-8e90-e8d23450591e'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eafec-9afb-709c-b512-5f67b6554539'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eafed-3de0-7031-9ec0-eb54c2063633'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eafed-16e7-73ce-b3cd-fecb09933874'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eafec-b29a-71a6-b4a9-6aa66f985380'
),
12.70580291748
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eafab-ca16-70eb-bb95-a0b348a8688b'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eaff8-16c5-7283-a9c6-71cbb42e5c84'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018ece55-e0b3-7207-bb2e-108ff40b8f76'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eb7d8-11b0-73f7-abd7-e79ed3edc3c6'
),
8.6757850646973
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
UUID_TO_BIN (
'018eaffb-a261-72f9-a39c-63e79e2b16b4'
),
6.2159013748169
),
(
UUID_TO_BIN (
'018eb001-a8a3-7218-8d89-1b3c6794924d'
),
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-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eb001-e29b-71a4-bcbe-acdc08ebc0c2' ), 30.530094146729 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eb001-bd0e-71c2-b78f-c920d89ee016' ), 30.530094146729 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eb001-f3f8-714d-b967-a52f4949278f' ), 30.530094146729 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eb001-d07f-702a-976a-0cb66d0a47ea' ), 30.530094146729 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafed-05c4-70bf-8d67-f39da52cde34' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafed-5780-7353-a512-04303de7ec3c' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafec-cb9f-73f8-9b84-32ccf364a16b' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafec-f1de-721f-998f-d3f5e3751c7b' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafed-2d05-7153-8228-d7627e40ba3c' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafec-dc6f-7308-8e90-e8d23450591e' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafec-9afb-709c-b512-5f67b6554539' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafed-3de0-7031-9ec0-eb54c2063633' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafed-16e7-73ce-b3cd-fecb09933874' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafec-b29a-71a6-b4a9-6aa66f985380' ), 12.70580291748 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eafab-ca16-70eb-bb95-a0b348a8688b' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eaff8-16c5-7283-a9c6-71cbb42e5c84' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018ece55-e0b3-7207-bb2e-108ff40b8f76' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eb7d8-11b0-73f7-abd7-e79ed3edc3c6' ), 8.6757850646973 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eaffb-a261-72f9-a39c-63e79e2b16b4' ), 6.2159013748169 ), (UUID_TO_BIN ('018eb001-a8a3-7218-8d89-1b3c6794924d' ), UUID_TO_BIN ('018eb78a-6032-709a-b6b3-b2011aeab885' ), 6.2159013748169 )
;
Copy
0.83 ms (12.78%)
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
"B3hOIqz "
]
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 = 'B3hOIqz' LIMIT 1 ;
Copy