-----------------------
Array
(
[0] =>
Time: 0.0065:
SHOW TABLES FROM `s_dantestlb`
[1] =>
Time: 0.0065:
SHOW TABLES FROM `s_dantestlb`
[2] =>
Time: 0.0023:
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_locale` = 'en_US'
LIMIT 1
[4] =>
Time: 0.0010:
SELECT `languages`.*
FROM `languages`
WHERE `languages_segment` = 'en'
LIMIT 1
[5] =>
Time: 0.0010:
SELECT *
FROM `site_email_settings`
ORDER BY `site_email_settings_code` ASC
[6] =>
Time: 0.0012:
SELECT *
FROM `xm_settings`
WHERE `xm_settings_code` = 'enable_using_cart_api'
LIMIT 1
[7] =>
Time: 0.0012:
SELECT COUNT(*) AS `numrows`
FROM `basket_items`
WHERE `user_token` = 'ZmVlZTBhZDQwYzRhNmY4ZWQ2N2ZmOGU2OWYxYzE2ODMwZjgyNTc3ZQ=='
[8] =>
Time: 0.0014:
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)
[9] =>
Time: 0.0016:
SELECT *
FROM `countries`
WHERE `countries_preferred` != 0
AND `countries_active` = 1
ORDER BY `countries_preferred` ASC
[10] =>
Time: 0.0013:
SELECT *
FROM `clients`
LIMIT 1
[11] =>
Time: 0.0015:
SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEB000001'
[12] =>
Time: 0.0011:
SELECT *
FROM `currencies`
WHERE `currencies_denom` = 'GBP'
[13] =>
Time: 0.0010:
SELECT *
FROM `currencies`
WHERE `currencies_id` = 7
[14] =>
Time: 0.0015:
SELECT *
FROM `api_settings`
RIGHT JOIN `api` ON `api_id` = `api_settings_api_id`
WHERE `api_code` = 'moodle'
[15] =>
Time: 0.0016:
SELECT * FROM layout_settings
WHERE layout_settings_page_id = (SELECT layout_pages_id FROM layout_pages WHERE layout_pages_code = ?) LIMIT 1
[16] =>
Time: 0.0011:
SELECT *
FROM `currencies`
WHERE `currencies_symbol` = '£'
LIMIT 1
[17] =>
Time: 0.0013:
SELECT *
FROM `registration`
WHERE `identifier` = '3639409af621be3cc6b'
AND `is_disabled` =0
AND (`is_on_registration_page` = 1 OR `is_onepage_registration_option` = 1)
ORDER BY `ordering`
LIMIT 1
[18] =>
Time: 0.0014:
SELECT *
FROM `registration_field`
WHERE registration_id IN(2)
ORDER BY `ordering`
[19] =>
Time: 0.0014:
SELECT *
FROM `registration_field_lang`
WHERE registration_field_lang.registration_field_id IN(54, 28, 29, 30, 31, 57, 55, 32, 33, 53, 56)
[20] =>
Time: 0.0018:
SELECT *
FROM `registration_b2b_template_arcus_customer`
WHERE registration_b2b_template_arcus_customer.registration_id IN(2)
ORDER BY `registration_b2b_template_arcus_customer`.`id` DESC
[21] =>
Time: 0.0004:
SELECT *
FROM `registration_b2b_template_arcus_customer`
WHERE registration_b2b_template_arcus_customer.registration_id IN(2)
ORDER BY `registration_b2b_template_arcus_customer`.`id` DESC
[22] =>
Time: 0.0012:
SELECT *
FROM `countries`
WHERE `countries_preferred` != 0
AND `countries_active` = 1
ORDER BY `countries_preferred` ASC
[23] =>
Time: 0.0021:
SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'en'
LIMIT 1
[24] =>
Time: 0.0013:
SELECT *
FROM `module_content`
WHERE module_content_name IN(mobile_menu, mobile_menu_filters, mobile_menu_account)
[25] =>
Time: 0.0014:
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'
[26] =>
Time: 0.0015:
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)
[27] =>
Time: 0.0015:
SELECT *
FROM `module_custom_css`
[28] =>
Time: 0.0017:
SELECT *
FROM `html`
WHERE html_header = 1
AND `html_scope` = 'public'
[29] =>
Time: 0.0011:
SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(720)
ORDER BY `html_column_contents_order` ASC
[30] =>
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_column IN(380, 381, 382, 383, 384)
ORDER BY `html_contents_row`, `html_contents_tab`, COALESCE( html_column_grid_ordering)
[31] =>
Time: 0.0009:
SELECT `html_column_grid`.*
FROM `html_column_grid`
WHERE html_column_grid_html_id IN(720)
ORDER BY `html_column_grid_ordering`
[32] =>
Time: 0.0010:
SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'en'
LIMIT 1
[33] =>
Time: 0.0011:
SELECT *
FROM `module_content`
WHERE `module_content_name` = 'mobile_menu'
LIMIT 1
[34] =>
Time: 0.0030:
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)
[35] =>
Time: 0.0017:
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
[36] =>
Time: 0.0011:
SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(758, 759)
ORDER BY `html_column_contents_order` ASC
[37] =>
Time: 0.0010:
SELECT `html_column_grid`.*
FROM `html_column_grid`
WHERE html_column_grid_html_id IN(758, 759)
ORDER BY `html_column_grid_ordering`
[38] =>
Time: 0.0011:
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)
[39] =>
Time: 0.0012:
SELECT *
FROM `public_categories`
WHERE `public_categories_url` = 'en'
[40] =>
Time: 0.0011:
SELECT *
FROM `module_content`
WHERE `module_content_name` = 'mobile_menu_account'
LIMIT 1
[41] =>
Time: 0.0008:
SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEB000001'
[42] =>
Time: 0.0016:
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
[43] =>
Time: 0.0009:
SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'en'
LIMIT 1
[44] =>
Time: 0.0013:
SELECT *
FROM `categories_display_mode`
[45] =>
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'
[46] =>
Time: 0.0017:
SELECT *
FROM `html`
WHERE html_footer = 1
AND `html_scope` = 'public'
[47] =>
Time: 0.0007:
SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(717)
ORDER BY `html_column_contents_order` ASC
[48] =>
Time: 0.0013:
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
[49] =>
Time: 0.0010:
SELECT `html_contents`.*
FROM `html_contents`
WHERE html_contents_grid IN(754, 755)
[50] =>
Time: 0.0006:
SELECT *
FROM `clients`
LIMIT 1
)
-----------------------
