0.88 ms (18.98%)
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 Žãû§{s-¢@‹¢*ÓJ¢ "
b"\x01 Ž·ÙlFqŒ‘–´}"ü¸r "
b"\x01 Ž·ÚCòq¿‰Ë\x12 ¡0ªƒ7 "
b"\x01 ·ØËq«·Å:\e 'a[X "
b"\x01 Ž·ÖÒqq\t ˜ˆ¯m\x17\x18 BU "
b"\x01 Ž·Ø‘\x1D pÖºÛd\x1F §\x14 g’ "
b"\x01 Ž·ÙãÔs¬¼þ\x1C\x0E JÍIÌ "
b"\x01 Ž·Öe”sÞº^dÐi\x17 %ý "
b"\x01 Ž·Ø\x11 °s÷«×çžÓíÃÆ "
b"\x01 ŽãE_osí ¼ª\t ³×^) "
b"""
\x01 ãü©árX¬\n
áµ\x13 Ú
"""
b"\x01 Žãü\x02 ‡p•³\x02\x07 Þ\x07 õ”s "
b"\x01 ŽãD÷µqo™-þ`%ư] "
b"\x01 Þº2¸pÝ‚à¶8\e ÀE "
b"\x01 ޝ‚HasU–³õ¬ÊÃ¶Ê "
b"\x01 ·í¿Êr\x18 ·\x19 HÞ\f … "
b"\x01 ް2döpX®a\x07\x05 ¬ÿ-f "
b"\x01 °rgçr|’èÁåZéE "
b"\x01 ´Žì!pœŒ7\x05 #Ü\x19\v ÷ "
b"\x01 ŽÉÕ#üs\x03 „•SP\x0E êr% "
]
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 (0x018EE3FBA77B732DA2408BA22AD34AA2 , 0x018EB7D96C46718C9196B47D22FCB872 , 0x018EB7DA43F271BF89CB12A130AA8337 , 0x018EB7D8CB9071ABB7C53A1B27615B58 , 0x018EB7D6D27171099888AF6D17184255 , 0x018EB7D8911D70D6BADB641FA7146792 , 0x018EB7D9E3D473ACBCFE1C0E4ACD49CC , 0x018EB7D6659473DEBA5E64D0691725FD , 0x018EB7D811B073F7ABD7E79ED3EDC3C6 , 0x018EE3455F6F73EDA0BCAA09B3D75E29 , 0x018EE3FCA9E17258AC0AE1ADB51390DA , 0x018EE3FC02877095B30207DE07F59473 , 0x018EE344F7B5716F992DFE6025C6B05D , 0x018EDEBA32B870DD82E0B68F381BC045 , 0x018EAF824861735596B3F5ACCAC3B6CA , 0x018EB7EDBFCA7218B71948DE810C8581 , 0x018EB03264F67058AE610705ACFF2D66 , 0x018EB07267E7727C92E89DC1E55AE945 , 0x018EB48DEC21709C8C370523DC190BF7 , 0x018EC9D523FC7303849553500EEA7225 );
Copy
0.69 ms (14.79%)
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
"-Hueyjn "
]
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 = '-Hueyjn' LIMIT 1 ;
Copy
0.55 ms (11.90%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ee3fb-a77b-732d-a240-8ba22ad34aa2' ), 33.217319488525 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d9-6c46-718c-9196-b47d22fcb872' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7da-43f2-71bf-89cb-12a130aa8337' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d8-cb90-71ab-b7c5-3a1b27615b58' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d6-d271-7109-9888-af6d17184255' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d8-911d-70d6-badb-641fa7146792' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d9-e3d4-73ac-bcfe-1c0e4acd49cc' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d6-6594-73de-ba5e-64d0691725fd' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d8-11b0-73f7-abd7-e79ed3edc3c6' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ee345-5f6f-73ed-a0bc-aa09b3d75e29' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ee3fc-a9e1-7258-ac0a-e1adb51390da' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ee3fc-0287-7095-b302-07de07f59473' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ee344-f7b5-716f-992d-fe6025c6b05d' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018edeba-32b8-70dd-82e0-b68f381bc045' ), 11.714120864868 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eaf82-4861-7355-96b3-f5accac3b6ca' ), 10.539752960205 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7ed-bfca-7218-b719-48de810c8581' ), 10.539752960205 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb032-64f6-7058-ae61-0705acff2d66' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb072-67e7-727c-92e8-9dc1e55ae945' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb48d-ec21-709c-8c37-0523dc190bf7' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ec9d5-23fc-7303-8495-53500eea7225' ), 9.1485061645508 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018ee3fb-a77b-732d-a240-8ba22ad34aa2'
),
33.217319488525
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb7d9-6c46-718c-9196-b47d22fcb872'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb7da-43f2-71bf-89cb-12a130aa8337'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb7d8-cb90-71ab-b7c5-3a1b27615b58'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb7d6-d271-7109-9888-af6d17184255'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb7d8-911d-70d6-badb-641fa7146792'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb7d9-e3d4-73ac-bcfe-1c0e4acd49cc'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb7d6-6594-73de-ba5e-64d0691725fd'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb7d8-11b0-73f7-abd7-e79ed3edc3c6'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018ee345-5f6f-73ed-a0bc-aa09b3d75e29'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018ee3fc-a9e1-7258-ac0a-e1adb51390da'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018ee3fc-0287-7095-b302-07de07f59473'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018ee344-f7b5-716f-992d-fe6025c6b05d'
),
19.930393218994
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018edeba-32b8-70dd-82e0-b68f381bc045'
),
11.714120864868
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eaf82-4861-7355-96b3-f5accac3b6ca'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb7ed-bfca-7218-b719-48de810c8581'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb032-64f6-7058-ae61-0705acff2d66'
),
9.1485061645508
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb072-67e7-727c-92e8-9dc1e55ae945'
),
9.1485061645508
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018eb48d-ec21-709c-8c37-0523dc190bf7'
),
9.1485061645508
),
(
UUID_TO_BIN (
'018eb7d9-1f19-7107-81a6-c92e6a24e81d'
),
UUID_TO_BIN (
'018ec9d5-23fc-7303-8495-53500eea7225'
),
9.1485061645508
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ee3fb-a77b-732d-a240-8ba22ad34aa2' ), 33.217319488525 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d9-6c46-718c-9196-b47d22fcb872' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7da-43f2-71bf-89cb-12a130aa8337' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d8-cb90-71ab-b7c5-3a1b27615b58' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d6-d271-7109-9888-af6d17184255' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d8-911d-70d6-badb-641fa7146792' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d9-e3d4-73ac-bcfe-1c0e4acd49cc' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d6-6594-73de-ba5e-64d0691725fd' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7d8-11b0-73f7-abd7-e79ed3edc3c6' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ee345-5f6f-73ed-a0bc-aa09b3d75e29' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ee3fc-a9e1-7258-ac0a-e1adb51390da' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ee3fc-0287-7095-b302-07de07f59473' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ee344-f7b5-716f-992d-fe6025c6b05d' ), 19.930393218994 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018edeba-32b8-70dd-82e0-b68f381bc045' ), 11.714120864868 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eaf82-4861-7355-96b3-f5accac3b6ca' ), 10.539752960205 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb7ed-bfca-7218-b719-48de810c8581' ), 10.539752960205 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb032-64f6-7058-ae61-0705acff2d66' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb072-67e7-727c-92e8-9dc1e55ae945' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018eb48d-ec21-709c-8c37-0523dc190bf7' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb7d9-1f19-7107-81a6-c92e6a24e81d' ), UUID_TO_BIN ('018ec9d5-23fc-7303-8495-53500eea7225' ), 9.1485061645508 )
;
Copy