0.92 ms (20.27%)
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 ŽÎ”lÒpV©vl‘rï³\x1D "
b"\x01 ŽÎ‘–ÍqR’f*\r 6\x13 ˜¦ "
b"\x01 ŽÎ“\x1F ®r!·fê\x0F\x04 Ä×Ö "
b"\x01 ŽÎ’ËmsÞ¬å\x00 Uä¾b9 "
b"\x01 ŽÎ”\t Grc¸·=§\x02 \r ó° "
b"\x01 ޝ¶s÷sš¥g>#,´vñ "
b"\x01 Ž¯Ê©ap¾¤ÙG\x19 ÏqÍÒ "
b"\x01 ް5ˆþr°‹Ùû+£Œ€« "
b"\x01 ް\t õhp„‚á\x19 „ÏdŠ• "
b"\x01 °fþÐp\v Ëe[ä£^’ "
b"\x01 ްr\x12 ~qr®!`\x1E\x1E ìÏú "
b"\x01 Ž´ân\x16 p\x12 ³ê\t ª\x1A Œd\v "
b"\x01 ް”/*ré¤vŒ/\x16 >$| "
b"\x01 ް“Èvrì¶k¿t\x08 üD˜ "
b"\x01 °“×qB©³w!"<\x03 "
b"\x01 ŽÞ†ß§sg‹w³Ðøµ“u "
b"\x01 ãÈŽµp…qUà#ð²O "
b"\x01 ް€¥\x05 p\x19 –åˆ\x0E lŸ\x02 ˜ "
b"\x01 ŽÉI¦àrÖ½£C\x18 ,Lœ¤ "
b"\x01 ŽÞ’²pn¼\x00 "kR\x1C\x17 J "
]
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 (0x018ECE946CD27056A9766C9172EFB31D , 0x018ECE9196CD715292662A0D361398A6 , 0x018ECE931FAE7221B766EA0F04C4D7D6 , 0x018ECE92CB6D73DEACE50055E4BE6239 , 0x018ECE9409477263B8B73DA7020DF3B0 , 0x018EAFB673F7739AA5673E232CB476F1 , 0x018EAFCAA96170BEA4D94719CF71CDD2 , 0x018EB03588FE72B08BD9FB2BA38C80AB , 0x018EB009F568708482E11984CF648A95 , 0x018EB066FED0700B81CB655BE4A35E92 , 0x018EB072127E7172AE21601E1EECCFFA , 0x018EB4E26E167012B3EA09AA1A8C640B , 0x018EB0942F2A72E9A4768C2F163E247C , 0x018EB093C87672ECB66BBF7408FC4498 , 0x018EB093D79D7142A9B3772122903C03 , 0x018EDE86DFA773678B77B3D0F8B59375 , 0x018EE3C88DB570859D7155E023F0B24F , 0x018EB080A505701996E5880E6C9F0298 , 0x018EC949A6E072D6BDA343182C4C9CA4 , 0x018EDE92ADB2706EBC00226B521C174A );
Copy
0.60 ms (13.14%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ece94-6cd2-7056-a976-6c9172efb31d' ), 52.976417541504 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ece91-96cd-7152-9266-2a0d361398a6' ), 41.262294769287 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ece93-1fae-7221-b766-ea0f04c4d7d6' ), 33.306907653809 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ece92-cb6d-73de-ace5-0055e4be6239' ), 33.306907653809 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ece94-0947-7263-b8b7-3da7020df3b0' ), 33.306907653809 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eafb6-73f7-739a-a567-3e232cb476f1' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eafca-a961-70be-a4d9-4719cf71cdd2' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb035-88fe-72b0-8bd9-fb2ba38c80ab' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb009-f568-7084-82e1-1984cf648a95' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb066-fed0-700b-81cb-655be4a35e92' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb072-127e-7172-ae21-601e1eeccffa' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb4e2-6e16-7012-b3ea-09aa1a8c640b' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb094-2f2a-72e9-a476-8c2f163e247c' ), 7.95538854599 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb093-c876-72ec-b66b-bf7408fc4498' ), 7.95538854599 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb093-d79d-7142-a9b3-772122903c03' ), 7.95538854599 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ede86-dfa7-7367-8b77-b3d0f8b59375' ), 7.95538854599 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ee3c8-8db5-7085-9d71-55e023f0b24f' ), 7.95538854599 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb080-a505-7019-96e5-880e6c9f0298' ), 7.6694507598877 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ec949-a6e0-72d6-bda3-43182c4c9ca4' ), 7.6694507598877 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ede92-adb2-706e-bc00-226b521c174a' ), 7.6694507598877 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018ece94-6cd2-7056-a976-6c9172efb31d'
),
52.976417541504
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018ece91-96cd-7152-9266-2a0d361398a6'
),
41.262294769287
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018ece93-1fae-7221-b766-ea0f04c4d7d6'
),
33.306907653809
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018ece92-cb6d-73de-ace5-0055e4be6239'
),
33.306907653809
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018ece94-0947-7263-b8b7-3da7020df3b0'
),
33.306907653809
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018eafb6-73f7-739a-a567-3e232cb476f1'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018eafca-a961-70be-a4d9-4719cf71cdd2'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018eb035-88fe-72b0-8bd9-fb2ba38c80ab'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018eb009-f568-7084-82e1-1984cf648a95'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018eb066-fed0-700b-81cb-655be4a35e92'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018eb072-127e-7172-ae21-601e1eeccffa'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018eb4e2-6e16-7012-b3ea-09aa1a8c640b'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018eb094-2f2a-72e9-a476-8c2f163e247c'
),
7.95538854599
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018eb093-c876-72ec-b66b-bf7408fc4498'
),
7.95538854599
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018eb093-d79d-7142-a9b3-772122903c03'
),
7.95538854599
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018ede86-dfa7-7367-8b77-b3d0f8b59375'
),
7.95538854599
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018ee3c8-8db5-7085-9d71-55e023f0b24f'
),
7.95538854599
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018eb080-a505-7019-96e5-880e6c9f0298'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018ec949-a6e0-72d6-bda3-43182c4c9ca4'
),
7.6694507598877
),
(
UUID_TO_BIN (
'018ece93-5444-709c-b602-e0bff0d6f41b'
),
UUID_TO_BIN (
'018ede92-adb2-706e-bc00-226b521c174a'
),
7.6694507598877
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ece94-6cd2-7056-a976-6c9172efb31d' ), 52.976417541504 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ece91-96cd-7152-9266-2a0d361398a6' ), 41.262294769287 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ece93-1fae-7221-b766-ea0f04c4d7d6' ), 33.306907653809 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ece92-cb6d-73de-ace5-0055e4be6239' ), 33.306907653809 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ece94-0947-7263-b8b7-3da7020df3b0' ), 33.306907653809 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eafb6-73f7-739a-a567-3e232cb476f1' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eafca-a961-70be-a4d9-4719cf71cdd2' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb035-88fe-72b0-8bd9-fb2ba38c80ab' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb009-f568-7084-82e1-1984cf648a95' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb066-fed0-700b-81cb-655be4a35e92' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb072-127e-7172-ae21-601e1eeccffa' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb4e2-6e16-7012-b3ea-09aa1a8c640b' ), 8.2858877182007 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb094-2f2a-72e9-a476-8c2f163e247c' ), 7.95538854599 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb093-c876-72ec-b66b-bf7408fc4498' ), 7.95538854599 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb093-d79d-7142-a9b3-772122903c03' ), 7.95538854599 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ede86-dfa7-7367-8b77-b3d0f8b59375' ), 7.95538854599 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ee3c8-8db5-7085-9d71-55e023f0b24f' ), 7.95538854599 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018eb080-a505-7019-96e5-880e6c9f0298' ), 7.6694507598877 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ec949-a6e0-72d6-bda3-43182c4c9ca4' ), 7.6694507598877 ), (UUID_TO_BIN ('018ece93-5444-709c-b602-e0bff0d6f41b' ), UUID_TO_BIN ('018ede92-adb2-706e-bc00-226b521c174a' ), 7.6694507598877 )
;
Copy
0.54 ms (11.94%)
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
"3UdEkfB "
]
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 = '3UdEkfB' LIMIT 1 ;
Copy