daily pastebin goal
51%
SHARE
TWEET

Untitled

a guest May 16th, 2018 88 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
Top