0.97 ms (32.83%)
|
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ޝ Û\rr¨³¼¢£K¡q\x1A"
b"\x01ޝ ʹp\x15¡Õ|¹-w\x18*"
b"\x01¯ ¡KpÐ\x05 ‚îeM˜"
b"\x01ޝ ‘\vp_¼ÿj?ôW™\x10"
b"\x01ޝ €_sÞšL>!÷\x18æž"
b"\x01ޝ~ïÚr5š’\x02†\x07ýFà"
b"\x01ޝ\x7F’\x13rG„hO\x07ö\rYt"
b"\x01¯\x7Fk\x19p\x04eEŽ\v\x03À "
b"\x01¯\x7FYAqõö–Ø\x0E„\x1E"
b"\x01ޝ\x7F(\x08pü§¢\r~±9\x17i"
b"\x01ޝ\x7F\x11\x15qˆ…–XP\x06wGQ"
b"\x01ޝ~Ú,s\x08šš¿‘`¤½ñ"
b"\x01ޝ\x7F~¡q\x15—Ö \fr·\x7Fª"
b"\x01ŽÃfV‹r•¸eÜ_\x03ÅgÌ"
b"\x01°ß\t´r¸ƒÈ´¨#§2"
b"\x01ް[²\frÚ€ÛÚY}IgR"
b"\x01ÎWÌp\x00™Æi`\x00\x05ãÐ"
b"\x01ŽÎW4\x07rö™¹nu'ôD:"
b"\x01¯\(qqœûÕ\x12Â[´"
b"\x01¯¬÷p÷—ƒ_\x1D\x18›Ž\x04"
b"\x01ޝ¬ÞPsؤ\x1F\òÝTÍ"
b"\x01ޝ¬\x05wq+¼åZ[Ž\x06¸7"
b"\x01ޝ«^áp‰µ‚„³\x14Ê6-"
b"\x01¯ª–wr¯q<À}×%i"
]
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 (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?
)
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 (0x018EAFA0DB0D72A8B3BCA2A34BA1711A, 0x018EAFA0CAB97015A1D57CB92D77182A, 0x018EAFA0A14B70D09D052082EE654D98, 0x018EAFA0910B705FBCFF6A3FF4579910, 0x018EAFA0805F73DE9A4C3E21F718E69E, 0x018EAF7EEFDA72359A92028607FD46E0, 0x018EAF7F9213724784684F07F60D5974, 0x018EAF7F6B1970049F65458D0B03C0A0, 0x018EAF7F594171F58FADF696D80E841E, 0x018EAF7F280870FCA7A20D7EB1391769, 0x018EAF7F111571888596585006774751, 0x018EAF7EDA2C73089A9ABF9160A4BDF1, 0x018EAF7F7EA1711597D6A00C72B77FAA, 0x018EC366568B7295B865DC5F03C567CC, 0x018EB0DF09B472B883C8B4A823A79D32, 0x018EB05BB20C72DA80DBDA597D496752, 0x018ECE57CC81700099C669600005E3D0, 0x018ECE57340772F699B96E7527F4443A, 0x018EAFAD5C2871719CFBD5129DC25BB4, 0x018EAFACF78170F797835F1D189B8D04, 0x018EAFACDE5073D8A41FAD5CF2DD54CD, 0x018EAFAC0577712BBCE55A5B8E06B837, 0x018EAFAB5EE17089B58284B314CA362D, 0x018EAFAA96777281AF713CC07DD72569);
|
0.60 ms (20.25%)
|
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
"eVugAeA"
]
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 = 'eVugAeA' LIMIT 1;
|