0.99 ms (36.24%)
|
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ް\f:írÞ…ÇHë¢C<7"
b"""
\x01ް\n
±õsL™Uâ\x05?¢Ì¹
"""
b"""
\x01ް\n
ÅLs–¿PLºâ]\x16Ê
"""
b"""
\x01ް\n
×Os, )\x01\x13w\x1AÃá
"""
b"""
\x01ް\n
éÈqÓœ\ee.$Í¿0
"""
b"\x01ް\vü|s\x12§eƒÐe÷-#"
b"\x01°\f\x0Eúrhðc\x14†7ä"
b"\x01ް\f!ôpÚÁ\x1C›øA+"
b"\x01ŽÎAa\x16pǾ¸®Q)þµo"
b"\x01´ˆa0q¯–É£VÔÂÀ"
b"\x01¯Ávrõ¹÷ÌÁ¯\x03é"
b"\x01Ž×Êfßs\x1C´³ü»þ]$#"
b"\x01°«¶ìr6£\x16öŽÞ\x7F2"
b"\x01·®\téq%“<`7ŽŠË\x13"
b"\x01ΰ4Ûp\x08_¿å(¾Žœ"
b"\x01ޝ®Ã\x02pi‰b:×=Žfž"
b"\x01޽ \x03³s\t€Ô§ ?‹Ÿ+"
b"\x01Èì\x08\p|ko…«4\x1D´"
b"\x01Ž×YÏWs{œè½J\x1FK\x08‡"
b"\x01Žã‹Å\x1Ar°°\x05\x16\x00ì9k+"
b"\x01Ž×Xã!pSœ\x10\x18)K,V\x13"
b"\x01½ÊîÒpY.\x17¶Te¥þ"
b"\x01ޝÐþbr~±\x01èÛ\x1C¥`%"
b"\x01ޝ¤\rªqþº\tKÓ\x1Eòsœ"
]
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 (0x018EB00C3AED72DE85C748EBA2433C37, 0x018EB00AB1F5734C9955E2053FA2CCB9, 0x018EB00AC54C7396BF504CBAE25D16CA, 0x018EB00AD74F732CA0290113771AC3E1, 0x018EB00AE9C871D39C1B652E24CDBF30, 0x018EB00BFC7C7312A76583D065F72D23, 0x018EB00C0EFA726890F063AD148637E4, 0x018EB00C21F470DAADC1AD1C9BF8412B, 0x018ECE41611670C7BEB8AE5129FEB56F, 0x018EB488613071AF9690C9A356D4C2C0, 0x018EAF90C17672F5B98EF7CCC1AF03E9, 0x018ED7CA66DF731CB4B3FCBBFE5D2423, 0x018EB0ABB6EC7236A316F69F8DDE7F32, 0x018EB7AE09E97125933C60378D8ACB13, 0x018ECEB034DB70088F5FBFE528BE8D9C, 0x018EAFAEC302706989623AD73D8E669E, 0x018EBDA003B3730980D4A7203F8B9F2B, 0x018EC8EC085C707C8F6B6F85AB341DB4, 0x018ED759CF57737B9CE8BD4A1F4B0887, 0x018EE38BC51A72B0B0051600EC396B2B, 0x018ED758E32170539C1018294B2C5613, 0x018EBDCAEED270598F2E17B65465A5FE, 0x018EAFD0FE62727EB101E8DB1CA56025, 0x018EAFA40DAA71FEBA094BD31EF2739C);
|
0.45 ms (16.30%)
|
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
"dPoXw9b"
]
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 = 'dPoXw9b' LIMIT 1;
|