SQL result
Host: Server1
Database: pioneerc_devmag
Generation Time: Jan 05, 2012 at 04:39 PM
Generated by: phpMyAdmin 2.11.11.3 / MySQL 5.0.77
SQL query: explain SELECT `e`.*, `at_prefix`.`value` AS `prefix`, `at_firstname`.`value` AS `firstname`,
`at_middlename`.`value` AS `middlename`, `at_lastname`.`value` AS `lastname`, `at_suffix`.`value` AS `suffix`,
CONCAT_WS(' ', IF(at_prefix.value IS NOT NULL AND at_prefix.value != '', LTRIM(RTRIM(at_prefix.value)), ''),
LTRIM(RTRIM(at_firstname.value)), IF(at_middlename.value IS NOT NULL AND at_middlename.value != '',
LTRIM(RTRIM(at_middlename.value)), ''), LTRIM(RTRIM(at_lastname.value)), IF(at_suffix.value IS NOT NULL AND
at_suffix.value != '', LTRIM(RTRIM(at_suffix.value)), '')) AS `name`, `at_default_billing`.`value` AS `default_billing`,
`at_billing_postcode`.`value` AS `billing_postcode`, `at_billing_city`.`value` AS `billing_city`,
`at_billing_telephone`.`value` AS `billing_telephone`, `at_billing_region`.`value` AS `billing_region`,
`at_billing_country_id`.`value` AS `billing_country_id` FROM `customer_entity` AS `e` LEFT JOIN
`customer_entity_varchar` AS `at_prefix` ON (`at_prefix`.`entity_id` = `e`.`entity_id`) AND (`at_prefix`.`attribute_id` = '4')
LEFT JOIN `customer_entity_varchar` AS `at_firstname` ON (`at_firstname`.`entity_id` = `e`.`entity_id`) AND
(`at_firstname`.`attribute_id` = '5') LEFT JOIN `customer_entity_varchar` AS `at_middlename` ON
(`at_middlename`.`entity_id` = `e`.`entity_id`) AND (`at_middlename`.`attribute_id` = '6') LEFT JOIN
`customer_entity_varchar` AS `at_lastname` ON (`at_lastname`.`entity_id` = `e`.`entity_id`) AND (`at_lastname`.`attribute_id`
= '7') LEFT JOIN `customer_entity_varchar` AS `at_suffix` ON (`at_suffix`.`entity_id` = `e`.`entity_id`) AND
(`at_suffix`.`attribute_id` = '8') LEFT JOIN `customer_entity_int` AS `at_default_billing` ON (`at_default_billing`.`entity_id`
= `e`.`entity_id`) AND (`at_default_billing`.`attribute_id` = '13') LEFT JOIN `customer_address_entity_varchar` AS
`at_billing_postcode` ON (`at_billing_postcode`.`entity_id` = `at_default_billing`.`value`) AND
(`at_billing_postcode`.`attribute_id` = '29') LEFT JOIN `customer_address_entity_varchar` AS `at_billing_city` ON
(`at_billing_city`.`entity_id` = `at_default_billing`.`value`) AND (`at_billing_city`.`attribute_id` = '25') LEFT JOIN
`customer_address_entity_varchar` AS `at_billing_telephone` ON (`at_billing_telephone`.`entity_id` =
`at_default_billing`.`value`) AND (`at_billing_telephone`.`attribute_id` = '30') LEFT JOIN `customer_address_entity_varchar`
AS `at_billing_region` ON (`at_billing_region`.`entity_id` = `at_default_billing`.`value`) AND
(`at_billing_region`.`attribute_id` = '27') LEFT JOIN `customer_address_entity_varchar` AS `at_billing_country_id` ON
(`at_billing_country_id`.`entity_id` = `at_default_billing`.`value`) AND (`at_billing_country_id`.`attribute_id` = '26')
WHERE (`e`.`entity_type_id` = '1') ORDER BY `e`.`entity_id` DESC LIMIT 20;
Rows: 12
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e ALL NULL NULL NULL NULL 28548
Using where; Using temporary;
Using filesort
1 SIMPLE at_prefix ALL NULL NULL NULL NULL 179819
1 SIMPLE at_firstname ALL NULL NULL NULL NULL 179819
1 SIMPLE at_middlename ALL NULL NULL NULL NULL 179819
1 SIMPLE at_lastname ALL NULL NULL NULL NULL 179819
1 SIMPLE at_suffix ALL NULL NULL NULL NULL 179819
1 SIMPLE at_default_billing ALL NULL NULL NULL NULL 49394
1 SIMPLE at_billing_postcode ALL NULL NULL NULL NULL 321613
1 SIMPLE at_billing_city ALL NULL NULL NULL NULL 321613
1 SIMPLE at_billing_telephone ALL NULL NULL NULL NULL 321613
1 SIMPLE at_billing_region ALL NULL NULL NULL NULL 321613
1 SIMPLE at_billing_country_id ALL NULL NULL NULL NULL 321613