0.76 ms (17.54%)
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 ޵$\x02\x17 pë¼U¾Eà³£w "
b"\x01 ޵#˜*qÊ¡2\x07 'V0Ö¾ "
b"\x01 ޵#RcpÜŒTU\f ¡\x17 Çh "
b"\x01 ŽÞslãqª“%Áç…\x7F ò1 "
b"\x01 ŽÞt~–qì®\x0E\x02 &—‘ªð "
b"\x01 ޵$E¤rÜ“TÙ\x19\x0F 9^Õ "
b"\x01 µ$SrÖ¥XKQdôˆ "
b"\x01 ŽÞtÄ)sä˜ÓƒÁÎ´ìª "
b"\x01 ŽÞsÓ„p …1÷‰œk!+ "
b"\x01 ¯Ë±æp›’8j/\x11 ÁŠ "
b"\x01 ¯ÆÎ~rp¤Á8b¥ók "
b"\x01 ޝÇXuq§¯±qû¦óƒP "
b"\x01 °F`\x1F qÚ‰4>yïÎ "
b"\x01 ް_ê~ro–GìM>\x15 ÌJ "
b"\x01 ް`oçq\x17 ˆ•Óù—\x1A , "
b"\x01 °¿\x15 Ps!¸\x7F •–J¨C "
b"\x01 Ž°Û¹\x10 q\x00 ´%SLy\I¤ "
b"\x01 ޵\x1D àXr\x06 »—hv‰\x11\x1D / "
b"\x01 Žãv\x00 Pr¿¢\x7F *\x05 MaSp "
]
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 (0x018EB524021770EBBC55BE45E0B3A377 , 0x018EB523982A71CAA13207275630D6BE , 0x018EB523526370DC8C54550CA117C768 , 0x018EDE736CE371AA9325C1E7857FF231 , 0x018EDE747E9671ECAE0E02269791AAF0 , 0x018EB52445A472DC9354D9190F395ED5 , 0x018EB5248F5372D6A5584B518164F488 , 0x018EDE74C42973E498D383C1CEB4ECAA , 0x018EDE73D38470A08531F7899C6B212B , 0x018EAFCBB1E6709B9092386A2F11C18A , 0x018EAFC6CE7E7270A49DC13862A5F36B , 0x018EAFC7587571A7AFB171FBA6F38350 , 0x018EB046601F71DA9F8934813E79EFCE , 0x018EB05FEA7E726F9647EC4D3E15CC4A , 0x018EB0606FE771178895D3F9971A202C , 0x018EB0BF15507321B87F9590964AA843 , 0x018EB0DBB9107100B425534C795C49A4 , 0x018EB51DE0587206BB97687689111D2F , 0x018EE376005072BFA27F2A054D615370 );
Copy
0.63 ms (14.49%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb524-0217-70eb-bc55-be45e0b3a377' ), 32.794067382812 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb523-982a-71ca-a132-07275630d6be' ), 32.794067382812 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), 31.99845123291 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018ede73-6ce3-71aa-9325-c1e7857ff231' ), 31.99845123291 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018ede74-7e96-71ec-ae0e-02269791aaf0' ), 31.99845123291 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb524-45a4-72dc-9354-d9190f395ed5' ), 22.254314422607 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb524-8f53-72d6-a558-4b518164f488' ), 22.254314422607 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018ede74-c429-73e4-98d3-83c1ceb4ecaa' ), 22.254314422607 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018ede73-d384-70a0-8531-f7899c6b212b' ), 22.254314422607 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eafcb-b1e6-709b-9092-386a2f11c18a' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eafc6-ce7e-7270-a49d-c13862a5f36b' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eafc7-5875-71a7-afb1-71fba6f38350' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb046-601f-71da-9f89-34813e79efce' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb05f-ea7e-726f-9647-ec4d3e15cc4a' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb060-6fe7-7117-8895-d3f9971a202c' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb0bf-1550-7321-b87f-9590964aa843' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb0db-b910-7100-b425-534c795c49a4' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb51d-e058-7206-bb97-687689111d2f' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018ee376-0050-72bf-a27f-2a054d615370' ), 7.1943426132202 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eb524-0217-70eb-bc55-be45e0b3a377'
),
32.794067382812
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eb523-982a-71ca-a132-07275630d6be'
),
32.794067382812
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eb523-5263-70dc-8c54-550ca117c768'
),
31.99845123291
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018ede73-6ce3-71aa-9325-c1e7857ff231'
),
31.99845123291
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018ede74-7e96-71ec-ae0e-02269791aaf0'
),
31.99845123291
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eb524-45a4-72dc-9354-d9190f395ed5'
),
22.254314422607
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eb524-8f53-72d6-a558-4b518164f488'
),
22.254314422607
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018ede74-c429-73e4-98d3-83c1ceb4ecaa'
),
22.254314422607
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018ede73-d384-70a0-8531-f7899c6b212b'
),
22.254314422607
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eafcb-b1e6-709b-9092-386a2f11c18a'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eafc6-ce7e-7270-a49d-c13862a5f36b'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eafc7-5875-71a7-afb1-71fba6f38350'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eb046-601f-71da-9f89-34813e79efce'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eb05f-ea7e-726f-9647-ec4d3e15cc4a'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eb060-6fe7-7117-8895-d3f9971a202c'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eb0bf-1550-7321-b87f-9590964aa843'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eb0db-b910-7100-b425-534c795c49a4'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018eb51d-e058-7206-bb97-687689111d2f'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018ede73-2243-70a5-a838-fcc59727d306'
),
UUID_TO_BIN (
'018ee376-0050-72bf-a27f-2a054d615370'
),
7.1943426132202
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb524-0217-70eb-bc55-be45e0b3a377' ), 32.794067382812 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb523-982a-71ca-a132-07275630d6be' ), 32.794067382812 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb523-5263-70dc-8c54-550ca117c768' ), 31.99845123291 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018ede73-6ce3-71aa-9325-c1e7857ff231' ), 31.99845123291 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018ede74-7e96-71ec-ae0e-02269791aaf0' ), 31.99845123291 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb524-45a4-72dc-9354-d9190f395ed5' ), 22.254314422607 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb524-8f53-72d6-a558-4b518164f488' ), 22.254314422607 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018ede74-c429-73e4-98d3-83c1ceb4ecaa' ), 22.254314422607 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018ede73-d384-70a0-8531-f7899c6b212b' ), 22.254314422607 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eafcb-b1e6-709b-9092-386a2f11c18a' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eafc6-ce7e-7270-a49d-c13862a5f36b' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eafc7-5875-71a7-afb1-71fba6f38350' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb046-601f-71da-9f89-34813e79efce' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb05f-ea7e-726f-9647-ec4d3e15cc4a' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb060-6fe7-7117-8895-d3f9971a202c' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb0bf-1550-7321-b87f-9590964aa843' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb0db-b910-7100-b425-534c795c49a4' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018eb51d-e058-7206-bb97-687689111d2f' ), 7.1943426132202 ), (UUID_TO_BIN ('018ede73-2243-70a5-a838-fcc59727d306' ), UUID_TO_BIN ('018ee376-0050-72bf-a27f-2a054d615370' ), 7.1943426132202 )
;
Copy
0.60 ms (13.89%)
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
"VlSdypa "
]
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 = 'VlSdypa' LIMIT 1 ;
Copy