daily pastebin goal
67%
SHARE
TWEET

Untitled

a guest May 16th, 2018 89 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SQL result
  2. Host: Server1
  3. Database: pioneerc_devmag
  4. Generation Time: Jan 05, 2012 at 04:39 PM
  5. Generated by: phpMyAdmin 2.11.11.3 / MySQL 5.0.77
  6. SQL query: explain SELECT `e`.*, `at_prefix`.`value` AS `prefix`, `at_firstname`.`value` AS `firstname`,
  7. `at_middlename`.`value` AS `middlename`, `at_lastname`.`value` AS `lastname`, `at_suffix`.`value` AS `suffix`,
  8. CONCAT_WS(' ', IF(at_prefix.value IS NOT NULL AND at_prefix.value != '', LTRIM(RTRIM(at_prefix.value)), ''),
  9. LTRIM(RTRIM(at_firstname.value)), IF(at_middlename.value IS NOT NULL AND at_middlename.value != '',
  10. LTRIM(RTRIM(at_middlename.value)), ''), LTRIM(RTRIM(at_lastname.value)), IF(at_suffix.value IS NOT NULL AND
  11. at_suffix.value != '', LTRIM(RTRIM(at_suffix.value)), '')) AS `name`, `at_default_billing`.`value` AS `default_billing`,
  12. `at_billing_postcode`.`value` AS `billing_postcode`, `at_billing_city`.`value` AS `billing_city`,
  13. `at_billing_telephone`.`value` AS `billing_telephone`, `at_billing_region`.`value` AS `billing_region`,
  14. `at_billing_country_id`.`value` AS `billing_country_id` FROM `customer_entity` AS `e` LEFT JOIN
  15. `customer_entity_varchar` AS `at_prefix` ON (`at_prefix`.`entity_id` = `e`.`entity_id`) AND (`at_prefix`.`attribute_id` = '4')
  16. LEFT JOIN `customer_entity_varchar` AS `at_firstname` ON (`at_firstname`.`entity_id` = `e`.`entity_id`) AND
  17. (`at_firstname`.`attribute_id` = '5') LEFT JOIN `customer_entity_varchar` AS `at_middlename` ON
  18. (`at_middlename`.`entity_id` = `e`.`entity_id`) AND (`at_middlename`.`attribute_id` = '6') LEFT JOIN
  19. `customer_entity_varchar` AS `at_lastname` ON (`at_lastname`.`entity_id` = `e`.`entity_id`) AND (`at_lastname`.`attribute_id`
  20. = '7') LEFT JOIN `customer_entity_varchar` AS `at_suffix` ON (`at_suffix`.`entity_id` = `e`.`entity_id`) AND
  21. (`at_suffix`.`attribute_id` = '8') LEFT JOIN `customer_entity_int` AS `at_default_billing` ON (`at_default_billing`.`entity_id`
  22. = `e`.`entity_id`) AND (`at_default_billing`.`attribute_id` = '13') LEFT JOIN `customer_address_entity_varchar` AS
  23. `at_billing_postcode` ON (`at_billing_postcode`.`entity_id` = `at_default_billing`.`value`) AND
  24. (`at_billing_postcode`.`attribute_id` = '29') LEFT JOIN `customer_address_entity_varchar` AS `at_billing_city` ON
  25. (`at_billing_city`.`entity_id` = `at_default_billing`.`value`) AND (`at_billing_city`.`attribute_id` = '25') LEFT JOIN
  26. `customer_address_entity_varchar` AS `at_billing_telephone` ON (`at_billing_telephone`.`entity_id` =
  27. `at_default_billing`.`value`) AND (`at_billing_telephone`.`attribute_id` = '30') LEFT JOIN `customer_address_entity_varchar`
  28. AS `at_billing_region` ON (`at_billing_region`.`entity_id` = `at_default_billing`.`value`) AND
  29. (`at_billing_region`.`attribute_id` = '27') LEFT JOIN `customer_address_entity_varchar` AS `at_billing_country_id` ON
  30. (`at_billing_country_id`.`entity_id` = `at_default_billing`.`value`) AND (`at_billing_country_id`.`attribute_id` = '26')
  31. WHERE (`e`.`entity_type_id` = '1') ORDER BY `e`.`entity_id` DESC LIMIT 20;
  32. Rows: 12
  33. id select_type table type possible_keys key key_len ref rows Extra
  34. 1 SIMPLE e ALL NULL NULL NULL NULL 28548
  35. Using where; Using temporary;
  36. Using filesort
  37. 1 SIMPLE at_prefix ALL NULL NULL NULL NULL 179819
  38. 1 SIMPLE at_firstname ALL NULL NULL NULL NULL 179819
  39. 1 SIMPLE at_middlename ALL NULL NULL NULL NULL 179819
  40. 1 SIMPLE at_lastname ALL NULL NULL NULL NULL 179819
  41. 1 SIMPLE at_suffix ALL NULL NULL NULL NULL 179819
  42. 1 SIMPLE at_default_billing ALL NULL NULL NULL NULL 49394
  43. 1 SIMPLE at_billing_postcode ALL NULL NULL NULL NULL 321613
  44. 1 SIMPLE at_billing_city ALL NULL NULL NULL NULL 321613
  45. 1 SIMPLE at_billing_telephone ALL NULL NULL NULL NULL 321613
  46. 1 SIMPLE at_billing_region ALL NULL NULL NULL NULL 321613
  47. 1 SIMPLE at_billing_country_id ALL NULL NULL NULL NULL 321613
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top