11 |
4.79 ms |
SELECT `customer`.`id` AS `customer.id`, `customer`.`customer_group_id` AS `customer.groupId`, `customer`.`default_payment_method_id` AS `customer.defaultPaymentMethodId`, `customer`.`sales_channel_id` AS `customer.salesChannelId`, `customer`.`language_id` AS `customer.languageId`, `customer`.`last_payment_method_id` AS `customer.lastPaymentMethodId`, `customer`.`default_billing_address_id` AS `customer.defaultBillingAddressId`, `customer`.`default_shipping_address_id` AS `customer.defaultShippingAddressId`, `customer`.`auto_increment` AS `customer.autoIncrement`, `customer`.`customer_number` AS `customer.customerNumber`, `customer`.`salutation_id` AS `customer.salutationId`, `customer`.`first_name` AS `customer.firstName`, `customer`.`last_name` AS `customer.lastName`, `customer`.`company` AS `customer.company`, `customer`.`password` AS `customer.password`, `customer`.`email` AS `customer.email`, `customer`.`title` AS `customer.title`, `customer`.`vat_ids` AS `customer.vatIds`, `customer`.`affiliate_code` AS `customer.affiliateCode`, `customer`.`campaign_code` AS `customer.campaignCode`, `customer`.`active` AS `customer.active`, `customer`.`double_opt_in_registration` AS `customer.doubleOptInRegistration`, `customer`.`double_opt_in_email_sent_date` AS `customer.doubleOptInEmailSentDate`, `customer`.`double_opt_in_confirm_date` AS `customer.doubleOptInConfirmDate`, `customer`.`hash` AS `customer.hash`, `customer`.`guest` AS `customer.guest`, `customer`.`first_login` AS `customer.firstLogin`, `customer`.`last_login` AS `customer.lastLogin`, `customer`.`newsletter_sales_channel_ids` AS `customer.newsletterSalesChannelIds`, `customer`.`birthday` AS `customer.birthday`, `customer`.`last_order_date` AS `customer.lastOrderDate`, `customer`.`order_count` AS `customer.orderCount`, `customer`.`order_total_amount` AS `customer.orderTotalAmount`, `customer`.`review_count` AS `customer.reviewCount`, `customer`.`custom_fields` AS `customer.customFields`, `customer`.`legacy_password` AS `customer.legacyPassword`, `customer`.`legacy_encoder` AS `customer.legacyEncoder`, `customer`.`remote_address` AS `customer.remoteAddress`, `customer`.`tag_ids` AS `customer.tagIds`, `customer`.`requested_customer_group_id` AS `customer.requestedGroupId`, `customer`.`bound_sales_channel_id` AS `customer.boundSalesChannelId`, `customer`.`account_type` AS `customer.accountType`, `customer`.`created_by_id` AS `customer.createdById`, `customer`.`updated_by_id` AS `customer.updatedById`, `customer`.`created_at` AS `customer.createdAt`, `customer`.`updated_at` AS `customer.updatedAt` FROM `customer`
SELECT
`customer`.`id` AS `customer.id`,
`customer`.`customer_group_id` AS `customer.groupId`,
`customer`.`default_payment_method_id` AS `customer.defaultPaymentMethodId`,
`customer`.`sales_channel_id` AS `customer.salesChannelId`,
`customer`.`language_id` AS `customer.languageId`,
`customer`.`last_payment_method_id` AS `customer.lastPaymentMethodId`,
`customer`.`default_billing_address_id` AS `customer.defaultBillingAddressId`,
`customer`.`default_shipping_address_id` AS `customer.defaultShippingAddressId`,
`customer`.`auto_increment` AS `customer.autoIncrement`,
`customer`.`customer_number` AS `customer.customerNumber`,
`customer`.`salutation_id` AS `customer.salutationId`,
`customer`.`first_name` AS `customer.firstName`,
`customer`.`last_name` AS `customer.lastName`,
`customer`.`company` AS `customer.company`,
`customer`.`password` AS `customer.password`,
`customer`.`email` AS `customer.email`,
`customer`.`title` AS `customer.title`,
`customer`.`vat_ids` AS `customer.vatIds`,
`customer`.`affiliate_code` AS `customer.affiliateCode`,
`customer`.`campaign_code` AS `customer.campaignCode`,
`customer`.`active` AS `customer.active`,
`customer`.`double_opt_in_registration` AS `customer.doubleOptInRegistration`,
`customer`.`double_opt_in_email_sent_date` AS `customer.doubleOptInEmailSentDate`,
`customer`.`double_opt_in_confirm_date` AS `customer.doubleOptInConfirmDate`,
`customer`.`hash` AS `customer.hash`,
`customer`.`guest` AS `customer.guest`,
`customer`.`first_login` AS `customer.firstLogin`,
`customer`.`last_login` AS `customer.lastLogin`,
`customer`.`newsletter_sales_channel_ids` AS `customer.newsletterSalesChannelIds`,
`customer`.`birthday` AS `customer.birthday`,
`customer`.`last_order_date` AS `customer.lastOrderDate`,
`customer`.`order_count` AS `customer.orderCount`,
`customer`.`order_total_amount` AS `customer.orderTotalAmount`,
`customer`.`review_count` AS `customer.reviewCount`,
`customer`.`custom_fields` AS `customer.customFields`,
`customer`.`legacy_password` AS `customer.legacyPassword`,
`customer`.`legacy_encoder` AS `customer.legacyEncoder`,
`customer`.`remote_address` AS `customer.remoteAddress`,
`customer`.`tag_ids` AS `customer.tagIds`,
`customer`.`requested_customer_group_id` AS `customer.requestedGroupId`,
`customer`.`bound_sales_channel_id` AS `customer.boundSalesChannelId`,
`customer`.`account_type` AS `customer.accountType`,
`customer`.`created_by_id` AS `customer.createdById`,
`customer`.`updated_by_id` AS `customer.updatedById`,
`customer`.`created_at` AS `customer.createdAt`,
`customer`.`updated_at` AS `customer.updatedAt`
FROM
`customer`
SELECT `customer`.`id` AS `customer.id`, `customer`.`customer_group_id` AS `customer.groupId`, `customer`.`default_payment_method_id` AS `customer.defaultPaymentMethodId`, `customer`.`sales_channel_id` AS `customer.salesChannelId`, `customer`.`language_id` AS `customer.languageId`, `customer`.`last_payment_method_id` AS `customer.lastPaymentMethodId`, `customer`.`default_billing_address_id` AS `customer.defaultBillingAddressId`, `customer`.`default_shipping_address_id` AS `customer.defaultShippingAddressId`, `customer`.`auto_increment` AS `customer.autoIncrement`, `customer`.`customer_number` AS `customer.customerNumber`, `customer`.`salutation_id` AS `customer.salutationId`, `customer`.`first_name` AS `customer.firstName`, `customer`.`last_name` AS `customer.lastName`, `customer`.`company` AS `customer.company`, `customer`.`password` AS `customer.password`, `customer`.`email` AS `customer.email`, `customer`.`title` AS `customer.title`, `customer`.`vat_ids` AS `customer.vatIds`, `customer`.`affiliate_code` AS `customer.affiliateCode`, `customer`.`campaign_code` AS `customer.campaignCode`, `customer`.`active` AS `customer.active`, `customer`.`double_opt_in_registration` AS `customer.doubleOptInRegistration`, `customer`.`double_opt_in_email_sent_date` AS `customer.doubleOptInEmailSentDate`, `customer`.`double_opt_in_confirm_date` AS `customer.doubleOptInConfirmDate`, `customer`.`hash` AS `customer.hash`, `customer`.`guest` AS `customer.guest`, `customer`.`first_login` AS `customer.firstLogin`, `customer`.`last_login` AS `customer.lastLogin`, `customer`.`newsletter_sales_channel_ids` AS `customer.newsletterSalesChannelIds`, `customer`.`birthday` AS `customer.birthday`, `customer`.`last_order_date` AS `customer.lastOrderDate`, `customer`.`order_count` AS `customer.orderCount`, `customer`.`order_total_amount` AS `customer.orderTotalAmount`, `customer`.`review_count` AS `customer.reviewCount`, `customer`.`custom_fields` AS `customer.customFields`, `customer`.`legacy_password` AS `customer.legacyPassword`, `customer`.`legacy_encoder` AS `customer.legacyEncoder`, `customer`.`remote_address` AS `customer.remoteAddress`, `customer`.`tag_ids` AS `customer.tagIds`, `customer`.`requested_customer_group_id` AS `customer.requestedGroupId`, `customer`.`bound_sales_channel_id` AS `customer.boundSalesChannelId`, `customer`.`account_type` AS `customer.accountType`, `customer`.`created_by_id` AS `customer.createdById`, `customer`.`updated_by_id` AS `customer.updatedById`, `customer`.`created_at` AS `customer.createdAt`, `customer`.`updated_at` AS `customer.updatedAt` FROM `customer`;
|