1. 2609

  2. Array
(
    [0] => 2800
    [1] => 2841
)


  3. inside consumer HERE

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND ?:categories.category_id IN (2800) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 5

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND ?:categories.category_id IN (2841) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 5

  1. 0
Queries time: 0.00709
№ Query Time
1 
unmanaged_addons::cache_customer
 0.00010
2 
init_storage_settings::cache_customer
 0.00009
3 
all_available_company_ids::cache_customer
 0.00010
4 
settings::cache_customer__1__0
 0.00032
5 
addons::cache_customer__1__0
 0.00023
6 
schemas::cache_customerschema_routes_objects
 0.00008
7 
schemas::cache_customerschema_cp_settings_schema
 0.00007
8 
seo_active_languages::cache_customer__1
 0.00007
9 
schemas::cache_customerschema_seo_objects
 0.00008
10 
schemas::cache_customerschema_storefronts_relations
 0.00007
11 
seo_settings::cache_customerseo_settings_0_1
 0.00009
12 
schemas::cache_customerschema_vendors_dispatches
 0.00008
13 
init_language::cache_customer__1init_language_C
 0.00008
14 
init_currency::cache_customer__1__eninit_currencyff96855a38cd3caf2c3536af0fab8a8d
 0.00008
15 
lang_cache::C_GET_products_view_en_EUR
 0.00007
16 
theme_dirs::cache_customer__1
 0.00009
17 
template_logos::cache_customer__1init_logos_0_10_302470e13ed10fb461d230934fa07036
 0.00009
18 
schemas::cache_customerschema_security_http_content_policy
 0.00008
19 
schemas::cache_customerschema_security_secure_controllers
 0.00008
20 
schemas::cache_customerschema_last_view_frontend
 0.00007
21 
templateExistsViaSnapshot::cache_customer
 0.00008
22 
schemas::cache_customerschema_block_manager_dynamic_objects
 0.00008
23 
schemas::cache_customerschema_block_manager_frontend_editable_locations
 0.00010
24 
available_countries_hash::cache_customer
 0.00008
25 
mobile_app_settings::cache_customer__1
 0.00011
26 
init_cdn_settings::cache_customer
 0.00008
27 
storefront_protocol::cache_customerstorefront_protocol1
 0.00009
28 
schemas::cache_customerschema_products_overridable_fields
 0.00011
29 
storefront_settings_values::cache_customer__1storefront_settings_values____
 0.00045
30 
schemas::cache_customerschema_csc_meta_templates_settings
 0.00009
31 
schemas::cache_customerschema_csc_virtual_categories_settings
 0.00014
32 
schemas::cache_customerschema_permissions_admin
 0.00020
33 
schemas::cache_customerschema_seo_canonical_urls
 0.00009
34 
seo_schema_org_markup_items::cache_customer__1__en__EURseo_schema_org_markup_items_12407_1
 0.00007
35 
schemas::cache_customerschema_seo_feature_codes
 0.00006
36 
template_overrides::cache_customerf66251d24ea328a4c39098f410938a21
 0.00013
37 
thooks_C::cache_customer__1
 0.00013
38 
schemas::cache_customerschema_seo_indexation
 0.00008
39 
assets_cache_key::time
 0.00008
40 
preloaded_font_resources::1__en
 0.00009
41 
schemas::cache_customerschema_vendors_containers
 0.00010
42 
seo_cache_static::cache_customeren
 0.00010
43 
schemas::cache_customerschema_block_manager_blocks
 0.00010
44 
scheme_block::cache_customer__1scheme_block_smarty_block
 0.00009
45 
scheme_block::cache_customer__1scheme_block_currencies
 0.00010
46 
scheme_block::cache_customer__1scheme_block_template
 0.00010
47 
scheme_block::cache_customer__1scheme_block_html_block
 0.00010
48 
schemas::cache_customerschema_block_manager_block_cache_properties
 0.00008
49 
block_content_html_block::en__219__0_1____httpsdev1-ecom.kindlife.in09d978c40c0ce6024bf193a124846a5d
 0.00007
50 
scheme_block::cache_customer__1scheme_block_cart_content
 0.00009
51 
block_content_cart_content::en__219__0_1____httpsdev1-ecom.kindlife.in539a96e366158e11985ab6495588aabc
 0.00009
52 
block_content_html_block::en__219__0_1____httpsdev1-ecom.kindlife.incc319148d57a408e2da297357aaeecab
 0.00008
53 
scheme_block::cache_customer__1scheme_block_menu
 0.00010
54 
menu_items_dependencies::cache_customermenu_items_dependencies_2
 0.00009
55 
block_content_menu::en__219__0_1____httpsdev1-ecom.kindlife.in881267208de19555ffc9930c6ac16e58
 0.00007
56 
schemas::cache_customerschema_static_data_schema
 0.00008
57 
block_content_html_block::en__219__0_1____httpsdev1-ecom.kindlife.inb556e592d4c62f5eb1e3d2d02a58df5d
 0.00008
58 
scheme_block::cache_customer__1scheme_block_main
 0.00014
59 
block_content_main_products.view::en__219__0_1____httpsdev1-ecom.kindlife.in045e7360c4cfe5fbcf847e7497a0c464
 0.00009
60 
scheme_block::cache_customer__1scheme_block_kl_feature_pdp
 0.00010
61 
schemas::cache_customerschema_block_manager_templates
 0.00009
62 
schemas::cache_customerschema_block_manager_fillings
 0.00009
63 
scheme_block::cache_customer__1scheme_block_kl_cp_videos_watch_pdp
 0.00019
64 
scheme_block::cache_customer__1scheme_block_kiki_ai_qna_block
 0.00014
65 
scheme_block::cache_customer__1scheme_block_kl_load_block_by_ajax
 0.00010
66 
scheme_block::cache_customer__1scheme_block_products_new
 0.00010
67 
block_content_products_new::en__219__0_1____httpsdev1-ecom.kindlife.in529ff8233563db07f02ad61b8fc4e70c
 0.00008
68 
scheme_block::cache_customer__1scheme_block_user_recently_viewed_data_block
 0.00009