SQL result

Хост: localhost
БД: milla_db
Час створення: Бер 31 2013 р., 18:06
Згенеровано: phpMyAdmin 3.3.7deb7 / MySQL 5.5.30-1~dotdeb.0-log
SQL-запит: EXPLAIN SELECT DISTINCT m0_.id AS id0 FROM milla_message m0_ INNER JOIN milla_currency m1_ ON m0_.currency_id = m1_.id INNER JOIN milla_category m2_ ON m0_.category_id = m2_.id INNER JOIN milla_region m3_ ON m0_.region_id = m3_.id INNER JOIN milla_city m4_ ON m0_.city_id = m4_.id WHERE m0_.status =1 ORDER BY m0_.published DESC LIMIT 20 OFFSET 0 ;
Рядки: 5

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m1_ index PRIMARY PRIMARY 4 NULL 3 Using index; Using temporary; Using filesort
1 SIMPLE m0_ ref IDX_8E8AD1B612469DE2,IDX_8E8AD1B638248176,IDX_8E8A... IDX_8E8AD1B638248176 5 milla_db.m1_.id 38398 Using where
1 SIMPLE m2_ eq_ref PRIMARY PRIMARY 4 milla_db.m0_.category_id 1 Using index; Distinct
1 SIMPLE m4_ eq_ref PRIMARY PRIMARY 4 milla_db.m0_.city_id 1 Using index; Distinct
1 SIMPLE m3_ eq_ref PRIMARY PRIMARY 4 milla_db.m0_.region_id 1 Using index; Distinct