SELECT account.id AS `id`, account.name AS `name`, account.deleted AS `deleted`, account.website AS `website`, emailAddresses.name AS `emailAddress`, phoneNumbers.name AS `phoneNumber`, account.type AS `type`, account.industry AS `industry`, account.sic_code AS `sicCode`, LEFT(account.billing_address_street, 5000) AS `billingAddressStreet`, account.billing_address_city AS `billingAddressCity`, account.billing_address_state AS `billingAddressState`, account.billing_address_country AS `billingAddressCountry`, account.billing_address_postal_code AS `billingAddressPostalCode`, LEFT(account.shipping_address_street, 5000) AS `shippingAddressStreet`, account.shipping_address_city AS `shippingAddressCity`, account.shipping_address_state AS `shippingAddressState`, account.shipping_address_country AS `shippingAddressCountry`, account.shipping_address_postal_code AS `shippingAddressPostalCode`, LEFT(account.description, 5000) AS `description`, account.created_at AS `createdAt`, account.modified_at AS `modifiedAt`, LEFT(account.dic, 5000) AS `dic`, account.issupplier AS `issupplier`, account.iscustomer AS `iscustomer`, account.activeclientwp AS `activeclientwp`, account.activeclientcrm AS `activeclientcrm`, account.change_ico AS `changeIco`, account.spolecnosti AS `spolecnosti`, account.partner AS `partner`, LEFT(account.firstname, 5000) AS `firstname`, LEFT(account.lastname, 5000) AS `lastname`, LEFT(account.idph, 5000) AS `idph`, account.category AS `category`, account.language AS `language`, account.enduser AS `enduser`, emailAddresses.opt_out AS `emailAddressIsOptedOut`, phoneNumbers.opt_out AS `phoneNumberIsOptedOut`, account.campaign_id AS `campaignId`, campaign.name AS `campaignName`, account.created_by_id AS `createdById`, TRIM(CONCAT(IFNULL(createdBy.first_name, ''), ' ', IFNULL(createdBy.last_name, ''))) AS `createdByName`, account.modified_by_id AS `modifiedById`, TRIM(CONCAT(IFNULL(modifiedBy.first_name, ''), ' ', IFNULL(modifiedBy.last_name, ''))) AS `modifiedByName`, account.assigned_user_id AS `assignedUserId`, TRIM(CONCAT(IFNULL(assignedUser.first_name, ''), ' ', IFNULL(assignedUser.last_name, ''))) AS `assignedUserName`, originalLead.id AS `originalLeadId`, TRIM(CONCAT(IFNULL(originalLead.first_name, ''), ' ', IFNULL(originalLead.last_name, ''))) AS `originalLeadName`, account.ploha_id AS `plohaId`, ploha.name AS `plohaName` FROM `account` LEFT JOIN `attachment` AS `ploha` ON account.ploha_id = ploha.id LEFT JOIN `lead` AS `originalLead` ON account.id = originalLead.created_account_id AND originalLead.deleted = 0 LEFT JOIN `campaign` AS `campaign` ON account.campaign_id = campaign.id LEFT JOIN `user` AS `assignedUser` ON account.assigned_user_id = assignedUser.id LEFT JOIN `user` AS `modifiedBy` ON account.modified_by_id = modifiedBy.id LEFT JOIN `user` AS `createdBy` ON account.created_by_id = createdBy.id LEFT JOIN `entity_email_address` AS `emailAddressesMiddle` ON account.id = emailAddressesMiddle.entity_id AND emailAddressesMiddle.deleted = 0 AND emailAddressesMiddle.primary = 1 AND emailAddressesMiddle.entity_type = 'Account' LEFT JOIN `email_address` AS `emailAddresses` ON emailAddresses.id = emailAddressesMiddle.email_address_id AND emailAddresses.deleted = 0 LEFT JOIN `entity_phone_number` AS `phoneNumbersMiddle` ON account.id = phoneNumbersMiddle.entity_id AND phoneNumbersMiddle.deleted = 0 AND phoneNumbersMiddle.primary = 1 AND phoneNumbersMiddle.entity_type = 'Account' LEFT JOIN `phone_number` AS `phoneNumbers` ON phoneNumbers.id = phoneNumbersMiddle.phone_number_id AND phoneNumbers.deleted = 0 WHERE account.deleted = 0 ORDER BY account.created_at DESC, account.id DESC LIMIT 0, 101;
MariaDB [project_alis_tech_com]> SHOW INDEX FROM account;
+---------+------------+----------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------+------------+----------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| account | 0 | PRIMARY | 1 | id | A | 2516 | NULL | NULL | | BTREE | | |
| account | 0 | UNIQ_CREATED_AT_ID | 1 | created_at | A | 629 | NULL | NULL | YES | BTREE | | |
| account | 0 | UNIQ_CREATED_AT_ID | 2 | id | A | 2516 | NULL | NULL | | BTREE | | |
| account | 1 | IDX_CAMPAIGN_ID | 1 | campaign_id | A | 2 | NULL | NULL | YES | BTREE | | |
| account | 1 | IDX_CREATED_BY_ID | 1 | created_by_id | A | 20 | NULL | NULL | YES | BTREE | | |
| account | 1 | IDX_MODIFIED_BY_ID | 1 | modified_by_id | A | 22 | NULL | NULL | YES | BTREE | | |
| account | 1 | IDX_ASSIGNED_USER_ID | 1 | assigned_user_id | A | 22 | NULL | NULL | YES | BTREE | | |
| account | 1 | IDX_CREATED_AT | 1 | created_at | A | 629 | NULL | NULL | YES | BTREE | | |
| account | 1 | IDX_CREATED_AT | 2 | deleted | A | 629 | NULL | NULL | YES | BTREE | | |
| account | 1 | IDX_NAME | 1 | name | A | 2516 | NULL | NULL | YES | BTREE | | |
| account | 1 | IDX_NAME | 2 | deleted | A | 2516 | NULL | NULL | YES | BTREE | | |
| account | 1 | IDX_ASSIGNED_USER | 1 | assigned_user_id | A | 22 | NULL | NULL | YES | BTREE | | |
| account | 1 | IDX_ASSIGNED_USER | 2 | deleted | A | 24 | NULL | NULL | YES | BTREE | | |
+---------+------------+----------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
13 rows in set (0.001 sec)
Leave a comment: