1.03 ms (17.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 Ž°ï’§p+›ƒ\x00 ,à¼`– "
b"\x01 ްð-os\x02 €½T«ÂÈlr "
b"\x01 ްï)¢pŠ«‚éÑDÜÚ "
b"\x01 ްïÎñs`“1Qœò>e£ "
b"\x01 Ž·j̼p—¬Ïd¹\t °‚\x06 "
b"\x01 ·k\x05 ùr4\x1C [’ªx\x15 { "
b"\x01 Ž·k<+sàŸ4~3Êer¢ "
b"\x01 Ž·j&‡rö¾Ž\x08\x7F z{\x03 ² "
b"\x01 Ã%•ór\x1C ˆ\x02 |Žr_\x10 i "
b"\x01 ŽÃ#îÈsG…~¨Bo`À› "
b"\x01 ŽÃ#t‡rö\x07\x14 Ÿb.Vg "
b"\x01 ŽÃ$Í%sd˜“Ã\x05 žÎ"— "
b"\x01 ¯Ž¢hqi¿\x13 è|ºÀ²\x1F "
b"\x01 ޽d\x06\x14 s{µìmhÍË\x17\x06 "
b"\x01 ·Ý¢Þs\f ²[ù—IÄ "
b"\x01 ŽãI-Kq’Áè±Ð\e\x12 Ò "
b"""
\x01 ŽãJ°8qn¼\n
\x1F žÐ—ìY
"""
b"\x01 ŽãG\e ¥r\x10 £6h©\x01 Õi¼ "
b"\x01 ŽãþJ}rP£´ÉR7±‡¸ "
b"\x01 ŽãK{õp™‘DQC/\x1D áÌ "
b"\x01 ŽãH\x12 Ap¤¬O‰®ï:_\x12 "
]
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 (0x018EB0EF92A7702B9B83002CE0BC6096 , 0x018EB0F02D6F730280BD54ABC2C86C72 , 0x018EB0EF29A2708AAB82E9D144DCDAA0 , 0x018EB0EFCEF173609331519CF23E65A3 , 0x018EB76ACCBC7097ACCF64B909B08206 , 0x018EB76B05F97234901C5B92AA78157B , 0x018EB76B3C2B73E09F347E33CA6572A2 , 0x018EB76A268772F6BE8E087F7A7B03B2 , 0x018EC32595F3721C88027C8D725F1069 , 0x018EC323EEC87347857EA8426F60C09B , 0x018EC323748772F6AD07149F622E5667 , 0x018EC324CD2573649893C3059ECE2297 , 0x018EAF8DA2687169BF13E87CBAC0B21F , 0x018EBD640614737BB5EC6D68CDCB1706 , 0x018EB7DDA2DE730CB25BF9C2909749C4 , 0x018EE3492D4B7192ADC1E8B1D01B12D2 , 0x018EE34AB038716EBC0A1F9ED097EC59 , 0x018EE3471BA57210A33668A901D569BC , 0x018EE3FE4A7D7250A3B4C95237B187B8 , 0x018EE34B7BF57099914451432F1DE1CC , 0x018EE348124170A4AC4F89AEEF3A5F12 );
Copy
0.70 ms (11.83%)
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
"TGu_TYk "
]
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 = 'TGu_TYk' LIMIT 1 ;
Copy
0.67 ms (11.47%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb0ef-92a7-702b-9b83-002ce0bc6096' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb0f0-2d6f-7302-80bd-54abc2c86c72' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb0ef-29a2-708a-ab82-e9d144dcdaa0' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb0ef-cef1-7360-9331-519cf23e65a3' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb76a-ccbc-7097-accf-64b909b08206' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb76b-05f9-7234-901c-5b92aa78157b' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb76b-3c2b-73e0-9f34-7e33ca6572a2' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb76a-2687-72f6-be8e-087f7a7b03b2' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ec325-95f3-721c-8802-7c8d725f1069' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ec323-eec8-7347-857e-a8426f60c09b' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ec323-7487-72f6-ad07-149f622e5667' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ec324-cd25-7364-9893-c3059ece2297' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eaf8d-a268-7169-bf13-e87cbac0b21f' ), 10.539752960205 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ebd64-0614-737b-b5ec-6d68cdcb1706' ), 10.539752960205 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb7dd-a2de-730c-b25b-f9c2909749c4' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee349-2d4b-7192-adc1-e8b1d01b12d2' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee34a-b038-716e-bc0a-1f9ed097ec59' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee347-1ba5-7210-a336-68a901d569bc' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee3fe-4a7d-7250-a3b4-c95237b187b8' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee34b-7bf5-7099-9144-51432f1de1cc' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee348-1241-70a4-ac4f-89aeef3a5f12' ), 5.8689413070679 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018eb0ef-92a7-702b-9b83-002ce0bc6096'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018eb0f0-2d6f-7302-80bd-54abc2c86c72'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018eb0ef-29a2-708a-ab82-e9d144dcdaa0'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018eb0ef-cef1-7360-9331-519cf23e65a3'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018eb76a-ccbc-7097-accf-64b909b08206'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018eb76b-05f9-7234-901c-5b92aa78157b'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018eb76b-3c2b-73e0-9f34-7e33ca6572a2'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018eb76a-2687-72f6-be8e-087f7a7b03b2'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018ec325-95f3-721c-8802-7c8d725f1069'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018ec323-eec8-7347-857e-a8426f60c09b'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018ec323-7487-72f6-ad07-149f622e5667'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018ec324-cd25-7364-9893-c3059ece2297'
),
26.300176620483
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018eaf8d-a268-7169-bf13-e87cbac0b21f'
),
10.539752960205
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018ebd64-0614-737b-b5ec-6d68cdcb1706'
),
10.539752960205
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018eb7dd-a2de-730c-b25b-f9c2909749c4'
),
5.8689413070679
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018ee349-2d4b-7192-adc1-e8b1d01b12d2'
),
5.8689413070679
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018ee34a-b038-716e-bc0a-1f9ed097ec59'
),
5.8689413070679
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018ee347-1ba5-7210-a336-68a901d569bc'
),
5.8689413070679
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018ee3fe-4a7d-7250-a3b4-c95237b187b8'
),
5.8689413070679
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018ee34b-7bf5-7099-9144-51432f1de1cc'
),
5.8689413070679
),
(
UUID_TO_BIN (
'018ec327-2a31-703d-adfe-e32a0447f375'
),
UUID_TO_BIN (
'018ee348-1241-70a4-ac4f-89aeef3a5f12'
),
5.8689413070679
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb0ef-92a7-702b-9b83-002ce0bc6096' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb0f0-2d6f-7302-80bd-54abc2c86c72' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb0ef-29a2-708a-ab82-e9d144dcdaa0' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb0ef-cef1-7360-9331-519cf23e65a3' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb76a-ccbc-7097-accf-64b909b08206' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb76b-05f9-7234-901c-5b92aa78157b' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb76b-3c2b-73e0-9f34-7e33ca6572a2' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb76a-2687-72f6-be8e-087f7a7b03b2' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ec325-95f3-721c-8802-7c8d725f1069' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ec323-eec8-7347-857e-a8426f60c09b' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ec323-7487-72f6-ad07-149f622e5667' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ec324-cd25-7364-9893-c3059ece2297' ), 26.300176620483 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eaf8d-a268-7169-bf13-e87cbac0b21f' ), 10.539752960205 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ebd64-0614-737b-b5ec-6d68cdcb1706' ), 10.539752960205 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018eb7dd-a2de-730c-b25b-f9c2909749c4' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee349-2d4b-7192-adc1-e8b1d01b12d2' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee34a-b038-716e-bc0a-1f9ed097ec59' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee347-1ba5-7210-a336-68a901d569bc' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee3fe-4a7d-7250-a3b4-c95237b187b8' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee34b-7bf5-7099-9144-51432f1de1cc' ), 5.8689413070679 ), (UUID_TO_BIN ('018ec327-2a31-703d-adfe-e32a0447f375' ), UUID_TO_BIN ('018ee348-1241-70a4-ac4f-89aeef3a5f12' ), 5.8689413070679 )
;
Copy