Explain Query (mysql)
EXPLAIN SELECT
mf.nosub,
if(mf.nosub = 1,if('fr' = 'fr',mf.nosub_title,mflang.l_nosub_title),null) as nosub_title,
if('fr' = 'fr',mf.title,mflang.l_title) as title,
if('fr' = 'fr',mf.description,mflang.l_description) as tweet,
if(special = 1 ,if('fr' = 'fr',fft.special_feature_title, fftl.l_special_feature_title), '') as s_ti,
if(special = 1 ,if('fr' = 'fr',fft.special_feature_text, fftl.l_special_feature_text), '') as s_t,
if('fr' = 'fr', fft.featured_card_title, fftl.l_featured_card_title) as featured_cart_title,
IFNULL(fft.image_url,mf.image_url) as image_url,
fft.theme_color,
if('fr' = 'fr', fft.title, fftl.l_title) as featured_text_title,
weight,
mf.marketplace_family_id
FROM
marketplace_families mf
LEFT JOIN
marketplace_families_lang as mflang ON mflang.marketplace_family_id = mf.marketplace_family_id
LEFT JOIN
family_featured_texts as fft ON fft.marketplace_family_id = mf.marketplace_family_id AND '2025-04-12' BETWEEN fft.start_date AND fft.end_date
LEFT JOIN
family_featured_texts_lang as fftl ON fft.family_featured_id = fftl.family_featured_id AND 'fr' = fftl.lang_id
WHERE
status = 1
ORDER BY
mf.weight ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | mf | ref | status | status | 1 | const | 31 | 100.00 | Using filesort | |
| 1 | SIMPLE | mflang | ref | marketplace_family_id | marketplace_family_id | 4 | securelufacom.mf.marketplace_family_id | 1 | 100.00 | ||
| 1 | SIMPLE | fft | ref | fk_family_feature_text | fk_family_feature_text | 4 | securelufacom.mf.marketplace_family_id | 18 | 100.00 | Using where | |
| 1 | SIMPLE | fftl | ref | fk_family_feature_text_lang | fk_family_feature_text_lang | 4 | securelufacom.fft.family_featured_id | 1 | 100.00 | Using where |