SQL result

Хост: localhost
БД: milla_db
Час створення: Бер 31 2013 р., 16:46
Згенеровано: phpMyAdmin 3.3.7deb7 / MySQL 5.5.30-1~dotdeb.0-log
SQL-запит: EXPLAIN SELECT DISTINCT id0 FROM (SELECT m0_.id AS id0, m0_.title AS title1, m0_.text AS text2, m0_.price AS price3, m0_.originalPrice AS originalPrice4, m0_.condition_type AS condition_type5, m0_.image_1 AS image_16, m0_.image_2 AS image_27, m0_.image_3 AS image_38, m0_.image_4 AS image_49, m0_.image_5 AS image_510, m0_.video AS video11, m0_.contact_email AS contact_email12, m0_.contact_name AS contact_name13, m0_.contact_phone AS contact_phone14, m0_.contact_type AS contact_type15, m0_.published AS published16, m0_.type AS type17, m0_.status AS status18, m0_.highlight AS highlight19, m0_.urgent AS urgent20, m0_.topads AS topads21, m0_.period AS period22, m0_.hits AS hits23, m0_.ip AS ip24, m0_.created_at AS created_at25, m0_.updated_at AS updated_at26 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) dctrn_result LIMIT 20 OFFSET 0 ;
Рядки: 6

id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY <derived2> ALL NULL NULL NULL NULL 200914 Using temporary
2 DERIVED m0_ ref IDX_8E8AD1B612469DE2,IDX_8E8AD1B638248176,IDX_8E8AD1B698260155,IDX_8E8AD1B68BAC62AF,status_id,status_published_idx status_published_idx 4   85950 Using where
2 DERIVED m3_ eq_ref PRIMARY PRIMARY 4 milla_db.m0_.region_id 1 Using index
2 DERIVED m2_ eq_ref PRIMARY PRIMARY 4 milla_db.m0_.category_id 1 Using index
2 DERIVED m4_ eq_ref PRIMARY PRIMARY 4 milla_db.m0_.city_id 1 Using index
2 DERIVED m1_ eq_ref PRIMARY PRIMARY 4 milla_db.m0_.currency_id 1 Using index