Extremely slow page displays /magento/order/

Hi
Other pages open normally
DigitalOcean Droplet: Ubuntu 16.04 with last updates, 2 CPU, 4G RAM
My opinion is that the matter in the SQL Query (from my mysql-slow.log)

MySQL

# Time: 2017-04-05T08:35:25.320306Z # User@Host: orocrmdb-user[orocrmdb-user] @ localhost [127.0.0.1] Id: 2327 # Query_time: 212.670702 Lock_time: 0.002225 Rows_sent: 25 Rows_examined: 606060 SET timestamp=1491381325; SELECT o0_.id AS id_0, o0_.currency AS currency_1, o0_.increment_id AS increment_id_2, o0_.created_at AS created_at_3, o0_.updated_at AS updated_at_4, o0_.total_paid_amount AS total_paid_amount_5, o0_.status AS status_6, o0_.first_name AS first_name_7, o0_.last_name AS last_name_8, o0_.subtotal_amount AS subtotal_amount_9, o0_.total_amount AS total_amount_10, o0_.customer_email AS customer_email_11, o1_.name AS name_12, o2_.website_name AS website_name_13, o0_.discount_amount AS discount_amount_14, o0_.discount_percent AS discount_percent_15, o0_.coupon_code AS coupon_code_16, (SELECT o3_.name FROM orocrm_magento_order_address o4_ LEFT JOIN oro_dictionary_country o3_ ON o4_.country_code = o3_.iso2_code LEFT JOIN orocrm_magento_order_addr_type o6_ ON o4_.id = o6_.order_address_id LEFT JOIN oro_address_type o5_ ON o5_.name = o6_.type_name WHERE o4_.owner_id = o0_.id AND (o5_.name = 'billing' OR o5_.name IS NULL)) AS sclr_17, (SELECT CONCAT(CASE WHEN o7_.region_text IS NOT NULL THEN o7_.region_text ELSE o8_.name END, '') AS sclr_19 FROM orocrm_magento_order_address o7_ LEFT JOIN oro_dictionary_region o8_ ON o7_.region_code = o8_.combined_code LEFT JOIN orocrm_magento_order_addr_type o10_ ON o7_.id = o10_.order_address_id LEFT JOIN oro_address_type o9_ ON o9_.name = o10_.type_name WHERE o7_.owner_id = o0_.id AND (o9_.name = 'billing' OR o9_.name IS NULL)) AS sclr_18 FROM orocrm_magento_order o0_ LEFT JOIN orocrm_magento_customer o11_ ON o0_.customer_id = o11_.id AND (o11_.organization_id = 1) LEFT JOIN orocrm_channel o1_ ON o0_.data_channel_id = o1_.id AND (o1_.organization_owner_id = 1) LEFT JOIN orocrm_magento_store o12_ ON o0_.store_id = o12_.id LEFT JOIN orocrm_magento_website o2_ ON o12_.website_id = o2_.id LEFT JOIN oro_workflow_item o13_ ON (CAST(o0_.id AS char) = CAST(o13_.entity_id AS char) AND o13_.entity_class = 'Oro\\Bundle\\MagentoBundle\\Entity\\Order') LEFT JOIN oro_workflow_step o14_ ON o13_.current_step_id = o14_.id WHERE o0_.organization_id = 1 ORDER BY o0_.created_at DESC LIMIT 25 OFFSET 0;

1 2 3 4 5

# Time: 2017-04-05T08:35:25.320306Z # User@Host: orocrmdb-user[orocrmdb-user] @ localhost [127.0.0.1]  Id:  2327 # Query_time: 212.670702  Lock_time: 0.002225 Rows_sent: 25  Rows_examined: 606060 SET timestamp=1491381325; SELECT o0_.id AS id_0, o0_.currency AS currency_1, o0_.increment_id AS increment_id_2, o0_.created_at AS created_at_3, o0_.updated_at AS updated_at_4, o0_.total_paid_amount AS total_paid_amount_5, o0_.status AS status_6, o0_.first_name AS first_name_7, o0_.last_name AS last_name_8, o0_.subtotal_amount AS subtotal_amount_9, o0_.total_amount AS total_amount_10, o0_.customer_email AS customer_email_11, o1_.name AS name_12, o2_.website_name AS website_name_13, o0_.discount_amount AS discount_amount_14, o0_.discount_percent AS discount_percent_15, o0_.coupon_code AS coupon_code_16, (SELECT o3_.name FROM orocrm_magento_order_address o4_ LEFT JOIN oro_dictionary_country o3_ ON o4_.country_code = o3_.iso2_code LEFT JOIN orocrm_magento_order_addr_type o6_ ON o4_.id = o6_.order_address_id LEFT JOIN oro_address_type o5_ ON o5_.name = o6_.type_name WHERE o4_.owner_id = o0_.id AND (o5_.name = 'billing' OR o5_.name IS NULL)) AS sclr_17, (SELECT CONCAT(CASE WHEN o7_.region_text IS NOT NULL THEN o7_.region_text ELSE o8_.name END, '') AS sclr_19 FROM orocrm_magento_order_address o7_ LEFT JOIN oro_dictionary_region o8_ ON o7_.region_code = o8_.combined_code LEFT JOIN orocrm_magento_order_addr_type o10_ ON o7_.id = o10_.order_address_id LEFT JOIN oro_address_type o9_ ON o9_.name = o10_.type_name WHERE o7_.owner_id = o0_.id AND (o9_.name = 'billing' OR o9_.name IS NULL)) AS sclr_18 FROM orocrm_magento_order o0_ LEFT JOIN orocrm_magento_customer o11_ ON o0_.customer_id = o11_.id AND (o11_.organization_id = 1) LEFT JOIN orocrm_channel o1_ ON o0_.data_channel_id = o1_.id AND (o1_.organization_owner_id = 1) LEFT JOIN orocrm_magento_store o12_ ON o0_.store_id = o12_.id LEFT JOIN orocrm_magento_website o2_ ON o12_.website_id = o2_.id LEFT JOIN oro_workflow_item o13_ ON (CAST(o0_.id AS char) = CAST(o13_.entity_id AS char) AND o13_.entity_class = 'Oro\\Bundle\\MagentoBundle\\Entity\\Order') LEFT JOIN oro_workflow_step o14_ ON o13_.current_step_id = o14_.id WHERE o0_.organization_id = 1 ORDER BY o0_.created_at DESC LIMIT 25 OFFSET 0;

Topic