0.77 ms (19.58%)
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 µ7Es=¿µø´`ã« "
b"\x01 ްçõÖrt»iÂÊwÜKˆ "
b"\x01 ްç/¿sS†Æiè\x1F\x08\x1D £ "
b"\x01 ްçIísLœPScªXÙO "
b"""
\x01 ްègzs»\x06 ›v\n
D€+
"""
b"\x01 ްè&÷r£¤Û¬0\r !” "
b"\x01 ްè\t –sÉ©)êĆ#£± "
b"\x01 Ž°ç²’p„½'šÈ¤•:\x01 "
b"\x01 ްèKŸpq \x7F MÓ°Ucß "
b"\x01 ްç‡âq±©Z\x1D î\x12\x12 qh "
b"\x01 ްa\x14 ±qÿœ„€i¾ýyò "
b"\x01 ½\x14 p•‚ø"\x17 ö¶£ "
b"\x01 ޝ«Ê\x16 p뻕 ³H¨h‹ "
b"\x01 ޝØÐƒrÀ“\x1D ÄÖ\x08 Ðn\x13 "
b"\x01 ް^lfqz¶1x\x17 a;Rÿ "
b"\x01 ްÇ;9qÛ¨X©>Ýó{X "
b"\x01 °)s¹‡|(ß\x11 cÄ "
b"\x01 Ž´‹–‘r\v ¡áw\x16\x1D 2ZH "
b"\x01 ްîqðq¸·\x04 îXyÊ\x1F ã "
b"\x01 °î¥ªrSˆˆ²0>iÔ "
b"\x01 ޽Êf qœ™p\x13 ßY/L€ "
b"\x01 ×Õ˜rʶ‘ª ]²ÑM "
]
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 (0x018EB5379045733DBFB5F8B460E3AB9F , 0x018EB0E7F5D67274BB69C2CA77DC4B88 , 0x018EB0E72FBF735386C669E81F081DA3 , 0x018EB0E749ED734C9C505363AA58D94F , 0x018EB0E8677A73ADBB069B760A44802B , 0x018EB0E826F772A3A4DBAC300D21AD94 , 0x018EB0E8099673C9A929EAC48623A3B1 , 0x018EB0E7B2927084BD279AC8A4953A01 , 0x018EB0E84B9F7071A07F4DD3B05563DF , 0x018EB0E787E271B1A95A1DEE12127168 , 0x018EB06114B171FF9C848069BEFD79F2 , 0x018EBD8E1481709582F82217C3B6B6A3 , 0x018EAFABCA1670EBBB95A0B348A8688B , 0x018EAFD8D08372C0931DC4D608D06E13 , 0x018EB05E6C66717AB6317817613B52FF , 0x018EB0C73B3971DBA858A93EDDF37B58 , 0x018EB09F9D2973B9877C289FDF1163C4 , 0x018EB48B9691720BA1E177161D325A48 , 0x018EB0EE71F071B8B704EE5879CA1FE3 , 0x018EB0EEA5AA72538888B281303E69D4 , 0x018EBDCA6620719C997013DF592F4C80 , 0x018ED790D59872CAB691AA205DB2D14D );
Copy
0.70 ms (17.63%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb537-9045-733d-bfb5-f8b460e3ab9f' ), 16.817956924438 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e7-f5d6-7274-bb69-c2ca77dc4b88' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e7-2fbf-7353-86c6-69e81f081da3' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e7-49ed-734c-9c50-5363aa58d94f' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e8-677a-73ad-bb06-9b760a44802b' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e8-26f7-72a3-a4db-ac300d21ad94' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e8-0996-73c9-a929-eac48623a3b1' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e8-4b9f-7071-a07f-4dd3b05563df' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e7-87e2-71b1-a95a-1dee12127168' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb061-14b1-71ff-9c84-8069befd79f2' ), 10.539752960205 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018ebd8e-1481-7095-82f8-2217c3b6b6a3' ), 10.539752960205 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eafab-ca16-70eb-bb95-a0b348a8688b' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eafd8-d083-72c0-931d-c4d608d06e13' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb05e-6c66-717a-b631-7817613b52ff' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0c7-3b39-71db-a858-a93eddf37b58' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb09f-9d29-73b9-877c-289fdf1163c4' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb48b-9691-720b-a1e1-77161d325a48' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0ee-71f0-71b8-b704-ee5879ca1fe3' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0ee-a5aa-7253-8888-b281303e69d4' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018ebdca-6620-719c-9970-13df592f4c80' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018ed790-d598-72ca-b691-aa205db2d14d' ), 7.6694507598877 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb537-9045-733d-bfb5-f8b460e3ab9f'
),
16.817956924438
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0e7-f5d6-7274-bb69-c2ca77dc4b88'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0e7-2fbf-7353-86c6-69e81f081da3'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0e7-49ed-734c-9c50-5363aa58d94f'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0e8-677a-73ad-bb06-9b760a44802b'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0e8-26f7-72a3-a4db-ac300d21ad94'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0e8-0996-73c9-a929-eac48623a3b1'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0e7-b292-7084-bd27-9ac8a4953a01'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0e8-4b9f-7071-a07f-4dd3b05563df'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0e7-87e2-71b1-a95a-1dee12127168'
),
14.836210250854
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb061-14b1-71ff-9c84-8069befd79f2'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018ebd8e-1481-7095-82f8-2217c3b6b6a3'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eafab-ca16-70eb-bb95-a0b348a8688b'
),
9.1485061645508
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eafd8-d083-72c0-931d-c4d608d06e13'
),
9.1485061645508
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb05e-6c66-717a-b631-7817613b52ff'
),
9.1485061645508
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0c7-3b39-71db-a858-a93eddf37b58'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb09f-9d29-73b9-877c-289fdf1163c4'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb48b-9691-720b-a1e1-77161d325a48'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0ee-71f0-71b8-b704-ee5879ca1fe3'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018eb0ee-a5aa-7253-8888-b281303e69d4'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018ebdca-6620-719c-9970-13df592f4c80'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018eb0e7-00e3-7031-bfb3-4bafa2bc0d31'
),
UUID_TO_BIN (
'018ed790-d598-72ca-b691-aa205db2d14d'
),
7.6694507598877
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb537-9045-733d-bfb5-f8b460e3ab9f' ), 16.817956924438 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e7-f5d6-7274-bb69-c2ca77dc4b88' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e7-2fbf-7353-86c6-69e81f081da3' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e7-49ed-734c-9c50-5363aa58d94f' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e8-677a-73ad-bb06-9b760a44802b' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e8-26f7-72a3-a4db-ac300d21ad94' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e8-0996-73c9-a929-eac48623a3b1' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e7-b292-7084-bd27-9ac8a4953a01' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e8-4b9f-7071-a07f-4dd3b05563df' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0e7-87e2-71b1-a95a-1dee12127168' ), 14.836210250854 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb061-14b1-71ff-9c84-8069befd79f2' ), 10.539752960205 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018ebd8e-1481-7095-82f8-2217c3b6b6a3' ), 10.539752960205 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eafab-ca16-70eb-bb95-a0b348a8688b' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eafd8-d083-72c0-931d-c4d608d06e13' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb05e-6c66-717a-b631-7817613b52ff' ), 9.1485061645508 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0c7-3b39-71db-a858-a93eddf37b58' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb09f-9d29-73b9-877c-289fdf1163c4' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb48b-9691-720b-a1e1-77161d325a48' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0ee-71f0-71b8-b704-ee5879ca1fe3' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018eb0ee-a5aa-7253-8888-b281303e69d4' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018ebdca-6620-719c-9970-13df592f4c80' ), 7.6694507598877 ), (UUID_TO_BIN ('018eb0e7-00e3-7031-bfb3-4bafa2bc0d31' ), UUID_TO_BIN ('018ed790-d598-72ca-b691-aa205db2d14d' ), 7.6694507598877 )
;
Copy
0.46 ms (11.58%)
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
"UVhaYCM "
]
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 = 'UVhaYCM' LIMIT 1 ;
Copy