-----------------------
Array
(
[0] =>
Time: 0.0076:
SHOW TABLES FROM `s_dantestlb`
[1] =>
Time: 0.0076:
SHOW TABLES FROM `s_dantestlb`
[2] =>
Time: 0.0019:
SELECT `enabled`, `code`, `store_feature_values`.`value` AS `value`
FROM `store_features`
LEFT JOIN `store_feature_values` ON `store_features`.`id` = `store_feature_values`.`store_features_id` AND `store_feature_values`.`locale` = (SELECT xm_settings_value FROM xm_settings WHERE xm_settings_code = "store_default_language")
WHERE code IN(multilanguage_frontside, multilanguage_urls, multilanguage_tables)
[3] =>
Time: 0.0010:
SELECT `languages`.*
FROM `languages`
WHERE `languages_segment` = 'en'
LIMIT 1
[4] =>
Time: 0.0014:
SELECT *
FROM `site_email_settings`
ORDER BY `site_email_settings_code` ASC
[5] =>
Time: 0.0012:
SELECT *
FROM `xm_settings`
WHERE `xm_settings_code` = 'enable_using_cart_api'
LIMIT 1
[6] =>
Time: 0.0010:
SELECT COUNT(*) AS `numrows`
FROM `basket_items`
WHERE `user_token` = 'YWFkOWRlNjM1NDUwODY2ZDI4ZDk4MWViY2Y1MzAxMzU4NWNmYTAxMA=='
[7] =>
Time: 0.0016:
SELECT *
FROM `xm_settings`
WHERE xm_settings_code IN(enable_elastic_search_for_listings, enable_elastic_search_for_search, enable_elastic_search_for_menu, enable_elastic_search_for_product_details, use_pricing_library, is_password_policies_enable, enable_product_finder, enable_custom_filters, enable_csrf_at_product_search, api_endpoint, api_version)
[8] =>
Time: 0.0016:
SELECT *
FROM `countries`
WHERE `countries_preferred` != 0
AND `countries_active` = 1
ORDER BY `countries_preferred` ASC
[9] =>
Time: 0.0010:
SELECT *
FROM `clients`
LIMIT 1
[10] =>
Time: 0.0015:
SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEB000001'
[11] =>
Time: 0.0011:
SELECT *
FROM `currencies`
WHERE `currencies_denom` = 'GBP'
[12] =>
Time: 0.0007:
SELECT *
FROM `currencies`
WHERE `currencies_id` = 7
[13] =>
Time: 0.0014:
SELECT *
FROM `api_settings`
RIGHT JOIN `api` ON `api_id` = `api_settings_api_id`
WHERE `api_code` = 'moodle'
[14] =>
Time: 0.0015:
SELECT * FROM layout_settings
WHERE layout_settings_page_id = (SELECT layout_pages_id FROM layout_pages WHERE layout_pages_code = ?) LIMIT 1
[15] =>
Time: 0.0013:
SELECT *
FROM `currencies`
WHERE `currencies_symbol` = '£'
LIMIT 1
[16] =>
Time: 0.0017:
SELECT
layout_settings_page_id page_id,
layout_settings_column_id column_id,
layout_settings_position_id position_id,
layout_settings_module_id module_id,
layout_settings_module_support_id support_id,
layout_settings_container_id container_id,
COALESCE(layout_pages_code,'') pages_code,
COALESCE(layout_positions_code,'') positions_code,
COALESCE(layout_modules_code,'') modules_code,
COALESCE(layout_modules_support_code,'') support_code,
COALESCE(layout_containers_code,'') containers_code
FROM layout_settings
LEFT JOIN layout_pages ON layout_settings_page_id = layout_pages_id
LEFT JOIN layout_positions ON layout_settings_position_id = layout_positions_id
LEFT JOIN layout_modules ON layout_settings_module_id = layout_modules_id
LEFT JOIN layout_modules_support ON layout_settings_module_support_id = layout_modules_support_id
LEFT JOIN layout_containers ON layout_settings_container_id = layout_containers_id
WHERE layout_settings_page_id = (SELECT layout_pages_id FROM layout_pages WHERE layout_pages_code = ?)
ORDER BY layout_settings_position_id, layout_settings_container_id
[17] =>
Time: 0.0009:
SELECT * FROM layout_settings
WHERE layout_settings_page_id = (SELECT layout_pages_id FROM layout_pages WHERE layout_pages_code = ?) LIMIT 1
[18] =>
Time: 0.0008:
SELECT
layout_settings_page_id page_id,
layout_settings_column_id column_id,
layout_settings_position_id position_id,
layout_settings_module_id module_id,
layout_settings_module_support_id support_id,
layout_settings_container_id container_id,
COALESCE(layout_pages_code,'') pages_code,
COALESCE(layout_positions_code,'') positions_code,
COALESCE(layout_modules_code,'') modules_code,
COALESCE(layout_modules_support_code,'') support_code,
COALESCE(layout_containers_code,'') containers_code
FROM layout_settings
LEFT JOIN layout_pages ON layout_settings_page_id = layout_pages_id
LEFT JOIN layout_positions ON layout_settings_position_id = layout_positions_id
LEFT JOIN layout_modules ON layout_settings_module_id = layout_modules_id
LEFT JOIN layout_modules_support ON layout_settings_module_support_id = layout_modules_support_id
LEFT JOIN layout_containers ON layout_settings_container_id = layout_containers_id
WHERE layout_settings_page_id = (SELECT layout_pages_id FROM layout_pages WHERE layout_pages_code = ?)
ORDER BY layout_settings_position_id, layout_settings_container_id
[19] =>
Time: 0.0007:
SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEB000001'
[20] =>
Time: 0.0017:
SELECT *
FROM `payment_methods`
WHERE `payment_methods_code` = 'paypal_express'
LIMIT 1
[21] =>
Time: 0.0018:
SELECT *
FROM `gateway_settings`
WHERE `gateway_settings_gateway` = 'paypal_express'
AND `gateway_settings_terminal` = 1
[22] =>
Time: 0.0012:
SELECT *
FROM `payment_terms`
WHERE payment_terms_codeterm IN(CH30NET)
[23] =>
Time: 0.0009:
SELECT *
FROM `payment_methods`
WHERE `payment_methods_code` = 'paypalcheckout'
LIMIT 1
[24] =>
Time: 0.0012:
SELECT *
FROM `gateway_settings`
WHERE `gateway_settings_gateway` = 'paypalcheckout'
AND `gateway_settings_terminal` = 1
[25] =>
Time: 0.0005:
SELECT *
FROM `payment_terms`
WHERE payment_terms_codeterm IN(CH30NET)
[26] =>
Time: 0.0019:
SELECT *
FROM `promotions_used`
JOIN `promotions` ON `promotions`.`promotions_code` = `promotions_used`.`promotions_used_code`
WHERE `promotions_used_utoken` = 'YWFkOWRlNjM1NDUwODY2ZDI4ZDk4MWViY2Y1MzAxMzU4NWNmYTAxMA=='
AND `promotions_used_status` = 0
AND JSON_CONTAINS(promotions_scope, '"b2c"')
[27] =>
Time: 0.0011:
DELETE FROM `basket_items`
WHERE `user_token` = 'YWFkOWRlNjM1NDUwODY2ZDI4ZDk4MWViY2Y1MzAxMzU4NWNmYTAxMA=='
AND `promoflag` = 1
[28] =>
Time: 0.0011:
DELETE FROM `basket_items`
WHERE `user_token` = 'YWFkOWRlNjM1NDUwODY2ZDI4ZDk4MWViY2Y1MzAxMzU4NWNmYTAxMA=='
AND `promoflag` = 1
[29] =>
Time: 0.0020:
SELECT *
FROM `promotions_used`
JOIN `promotions` ON `promotions`.`promotions_code` = `promotions_used`.`promotions_used_code`
WHERE `promotions_used_utoken` = 'YWFkOWRlNjM1NDUwODY2ZDI4ZDk4MWViY2Y1MzAxMzU4NWNmYTAxMA=='
AND `promotions_used_status` = 0
AND JSON_CONTAINS(promotions_scope, '"b2c"')
AND `promotions_deleted` = 0
AND `promotions`.`promotions_type` != 5
[30] =>
Time: 0.0017:
SELECT basket_items.*, 0 AS `id`, '' AS `location`, `id` AS `row_id`, SUM(`quantity_requested`) AS `quantity_requested`, SUM(`bo_qty`) AS `bo_qty`, SUM(`item_qty`) AS `item_qty`, SUM(`price`) AS `price`, SUM(`tax`) AS `tax`, if(virtual_link_table!='', virtual_itemno, product_code) AS `real_itemno` FROM basket_items WHERE (user_token = ?) GROUP BY product_code, kit_no, item_convert, virtual_itemno, virtual_option_id, virtual_grouping_unique_code, promoflag, quote_ref, comment ORDER BY ordering ASC
[31] =>
Time: 0.0021:
SELECT product_code, correlationId, segment, kit_no, promoflag, line_num, comment, virtual_batch_tracking_code, virtual_qty_multiplyer, SUM(`quantity_requested`) AS `quantity_requested`, SUM(`item_qty`) AS `item_qty`, SUM(`bo_qty`) AS `bo_qty`, quantity_detail, shipping, discount, item_convert, convert_factor, virtual_itemno, virtual_link_id, virtual_link_table, virtual_option_id, virtual_configurator_tab, virtual_grouping_unique_code, virtual_qty_pre_multiplyer, user_token, user_id, updated, gift_registry_id, create_date, users_shipto_location_id, arcsp_shipto_location_code, MAX(`ordering`) AS `ordering`, lot_tracking, location, quote_ref, pricelist, unit_price, is_product_on_hold, hold_order_number, inclusive FROM `basket_items` WHERE (user_token = ?) GROUP BY product_code, kit_no, item_convert, promoflag, virtual_itemno, comment, virtual_option_id, quote_ref ORDER BY create_date ASC
[32] =>
Time: 0.0015:
SELECT *, MIN(`id`) AS `id`, SUM(`item_qty`) AS `item_qty`, SUM(`bo_qty`) AS `bo_qty`, SUM(ROUND((quantity_requested * unit_price) - (ROUND((quantity_requested * unit_price) * (discount/100), 4)),4)) AS `price`, SUM(`quantity_requested`) AS `quantity_requested`
FROM `basket_items`
WHERE `user_token` = 'YWFkOWRlNjM1NDUwODY2ZDI4ZDk4MWViY2Y1MzAxMzU4NWNmYTAxMA=='
AND `promoflag` = '0'
GROUP BY `product_code`, `kit_no`, `item_convert`, `virtual_itemno`
ORDER BY `ordering` ASC, `create_date` DESC, `id` ASC
[33] =>
Time: 0.0015:
SELECT *
FROM `html`
WHERE `html_name` = 'xm-cart'
AND `html_scope` = 'public'
LIMIT 1
[34] =>
Time: 0.0017:
SELECT *
FROM `basket_items`
WHERE `user_token` = 'YWFkOWRlNjM1NDUwODY2ZDI4ZDk4MWViY2Y1MzAxMzU4NWNmYTAxMA=='
GROUP BY `product_code`, `kit_no`, `item_convert`
[35] =>
Time: 0.0007:
SELECT *
FROM `promotions_used`
JOIN `promotions` ON `promotions`.`promotions_code` = `promotions_used`.`promotions_used_code`
WHERE `promotions_used_utoken` = 'YWFkOWRlNjM1NDUwODY2ZDI4ZDk4MWViY2Y1MzAxMzU4NWNmYTAxMA=='
AND `promotions_used_status` = 0
AND JSON_CONTAINS(promotions_scope, '"b2c"')
AND `promotions_deleted` = 0
AND `promotions`.`promotions_type` != 5
[36] =>
Time: 0.0016:
SELECT `product_code`, MIN(`id`) AS `id`, SUM(`price`) AS `price`, SUM(`tax`) AS `tax`, SUM(`item_qty`) AS `item_qty`, SUM(`quantity_requested`) AS `quantity_requested`, SUM(`bo_qty`) AS `bo_qty`, SUM(`discount`) AS `discount`, `unit_price`, `inclusive`, `item_convert`, `location`, `correlationId`
FROM `basket_items`
WHERE `user_token` = 'YWFkOWRlNjM1NDUwODY2ZDI4ZDk4MWViY2Y1MzAxMzU4NWNmYTAxMA=='
GROUP BY `product_code`, `kit_no`, `item_convert`, `promoflag`
[37] =>
Time: 0.0017:
SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'en'
LIMIT 1
[38] =>
Time: 0.0014:
SELECT *
FROM `module_content`
WHERE module_content_name IN(mobile_menu, mobile_menu_filters, mobile_menu_account)
[39] =>
Time: 0.0012:
SELECT *
FROM `api_settings`
JOIN `api` ON `api_id` = `api_settings_api_id`
WHERE `api_code` = 'moodle'
AND `api_enabled_b2c` = 1
AND `api_settings_code` = 'moodle_url'
[40] =>
Time: 0.0012:
SELECT *
FROM `module_custom_tag`
WHERE module_custom_tag_position IN(head, head, body, footer)
AND module_custom_tag_page_style IN(all, contents, cart, product, category, home, user, recept)
[41] =>
Time: 0.0016:
SELECT *
FROM `module_custom_css`
[42] =>
Time: 0.0015:
SELECT *
FROM `html`
WHERE html_header = 1
AND `html_scope` = 'public'
[43] =>
Time: 0.0013:
SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(720)
ORDER BY `html_column_contents_order` ASC
[44] =>
Time: 0.0018:
SELECT `html_contents`.*
FROM `html_contents`
LEFT JOIN `html_column_grid` ON `html_contents_grid` = `html_column_grid_id`
WHERE html_contents_column IN(380, 381, 382, 383, 384)
ORDER BY `html_contents_row`, `html_contents_tab`, COALESCE( html_column_grid_ordering)
[45] =>
Time: 0.0015:
SELECT `html_column_grid`.*
FROM `html_column_grid`
WHERE html_column_grid_html_id IN(720)
ORDER BY `html_column_grid_ordering`
[46] =>
Time: 0.0012:
SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'en'
LIMIT 1
[47] =>
Time: 0.0012:
SELECT *
FROM `module_content`
WHERE `module_content_name` = 'mobile_menu'
LIMIT 1
[48] =>
Time: 0.0023:
SELECT
t1.public_categories_id categories_id,
t1.public_categories_path categories_image,
t1.public_categories_parent parent_id,
t1.public_categories_url url,
t1.public_categories_show_is_featured show_is_featured,
t1.public_categories_nav_html_id nav_html_id,
IFNULL(t1.public_categories_external_url,'') external_url,t1.public_categories_externalurl_target externalurl_target,t1.public_categories_tree_display tree_display,t1.public_categories_menu_display menu_display,t1.public_categories_nav_item_css_class nav_item_css_class,t1.public_categories_nav_panel_css_class nav_panel_css_class,t1.public_categories_nav_panel_width nav_panel_width,t1.public_categories_badge_1 badge_1,t1.public_categories_badge_2 badge_2,t1.public_categories_is_brand is_brand,CASE WHEN ( IF(t3.public_categories_id IS NULL, 0, 1) + IF(t2.public_categories_id IS NULL, 0, 1) + IF(t1.public_categories_id IS NULL, 0, 1)) = 1 THEN t3.public_categories_menu_desc WHEN ( IF(t3.public_categories_id IS NULL, 0, 1) + IF(t2.public_categories_id IS NULL, 0, 1) + IF(t1.public_categories_id IS NULL, 0, 1)) = 2 THEN t2.public_categories_menu_desc WHEN ( IF(t3.public_categories_id IS NULL, 0, 1) + IF(t2.public_categories_id IS NULL, 0, 1) + IF(t1.public_categories_id IS NULL, 0, 1)) = 3 THEN t1.public_categories_menu_desc END menu_desc,CASE WHEN ( IF(t3.public_categories_id IS NULL, 0, 1) + IF(t2.public_categories_id IS NULL, 0, 1) + IF(t1.public_categories_id IS NULL, 0, 1)) = 1 THEN t3.public_categories_menu_thumb WHEN ( IF(t3.public_categories_id IS NULL, 0, 1) + IF(t2.public_categories_id IS NULL, 0, 1) + IF(t1.public_categories_id IS NULL, 0, 1)) = 2 THEN t2.public_categories_menu_thumb WHEN ( IF(t3.public_categories_id IS NULL, 0, 1) + IF(t2.public_categories_id IS NULL, 0, 1) + IF(t1.public_categories_id IS NULL, 0, 1)) = 3 THEN t1.public_categories_menu_thumb END menu_thumb,(IF(t3.public_categories_id IS NULL, 0, 1) + IF(t2.public_categories_id IS NULL, 0, 1) + IF(t1.public_categories_id IS NULL, 0, 1)) as level,
trim(leading '/' FROM CONCAT(IFNULL(t3.public_categories_url, ''),'/',IFNULL(t2.public_categories_url, ''),'/',IFNULL(t1.public_categories_url, ''))) as path
,`t1`.`public_categories_name` AS `cat_name`
,`t1`.`public_categories_desc` AS `categories_desc`
FROM public_categories t1 LEFT JOIN public_categories t2 ON t1.public_categories_parent = t2.public_categories_id LEFT JOIN public_categories t3 ON t2.public_categories_parent = t3.public_categories_id WHERE t1.public_categories_active = 1 ORDER BY IFNULL(t1.public_categories_ordering,0), IFNULL(t2.public_categories_ordering,0), IFNULL(t3.public_categories_ordering,0)
[49] =>
Time: 0.0020:
SELECT *
FROM `html`
WHERE `html_name` != 'home'
AND `html_name` != 'menu'
AND `html_name` != 'sidebar'
AND `html_name` != 'xm-splash'
AND `html_is_nav_menu_content` = 1
AND html_pid IN(53, 50)
AND html_scope IN(public, both)
ORDER BY `html_ordering` ASC
[50] =>
Time: 0.0017:
SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(758, 759)
ORDER BY `html_column_contents_order` ASC
[51] =>
Time: 0.0012:
SELECT `html_column_grid`.*
FROM `html_column_grid`
WHERE html_column_grid_html_id IN(758, 759)
ORDER BY `html_column_grid_ordering`
[52] =>
Time: 0.0014:
SELECT `html_contents`.*
FROM `html_contents`
LEFT JOIN `html_column_grid` ON `html_contents_grid` = `html_column_grid_id`
WHERE html_contents_html_id IN(758, 759)
ORDER BY `html_contents_row`, `html_contents_tab`, COALESCE( html_column_grid_ordering)
[53] =>
Time: 0.0014:
SELECT *
FROM `public_categories`
WHERE `public_categories_url` = 'en'
[54] =>
Time: 0.0011:
SELECT *
FROM `module_content`
WHERE `module_content_name` = 'mobile_menu_account'
LIMIT 1
[55] =>
Time: 0.0009:
SELECT basket_items.*, 0 AS `id`, '' AS `location`, `id` AS `row_id`, SUM(`quantity_requested`) AS `quantity_requested`, SUM(`bo_qty`) AS `bo_qty`, SUM(`item_qty`) AS `item_qty`, SUM(`price`) AS `price`, SUM(`tax`) AS `tax`, if(virtual_link_table!='', virtual_itemno, product_code) AS `real_itemno` FROM basket_items WHERE (user_token = ?) GROUP BY product_code, kit_no, item_convert, virtual_itemno, virtual_option_id, virtual_grouping_unique_code, promoflag, quote_ref, comment ORDER BY ordering ASC
[56] =>
Time: 0.0010:
SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'en'
LIMIT 1
[57] =>
Time: 0.0013:
SELECT *
FROM `categories_display_mode`
[58] =>
Time: 0.0014:
SELECT *
FROM `html_contents`
INNER JOIN `html` ON `html_contents_html_id` = `html_id`
WHERE `html_scope` = 'public'
AND `html_name` = 'header'
AND `html_contents_module` = 'global_filter'
[59] =>
Time: 0.0015:
SELECT *
FROM `html`
WHERE html_footer = 1
AND `html_scope` = 'public'
[60] =>
Time: 0.0006:
SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(717)
ORDER BY `html_column_contents_order` ASC
[61] =>
Time: 0.0012:
SELECT *
FROM `html_column_grid`
INNER JOIN `html_column_contents` ON `html_column_contents_id` = `html_column_grid_column`
WHERE html_column_grid_column IN(379)
AND `html_column_grid_html_id` = 717
ORDER BY `html_column_contents_order` ASC, `html_column_grid_ordering` ASC
[62] =>
Time: 0.0012:
SELECT `html_contents`.*
FROM `html_contents`
WHERE html_contents_grid IN(754, 755)
[63] =>
Time: 0.0008:
SELECT *
FROM `clients`
LIMIT 1
)
-----------------------
