Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Add Comment
Please, Sign In to add comment