-----------------------
Array
(
[0] =>
Time: 0.0123:
SHOW TABLES FROM `s_dantestlb`
[1] =>
Time: 0.0123:
SHOW TABLES FROM `s_dantestlb`
[2] =>
Time: 0.0021:
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.0012:
SELECT `languages`.*
FROM `languages`
WHERE `languages_segment` = 'en'
LIMIT 1
[4] =>
Time: 0.0012:
SELECT *
FROM `site_email_settings`
ORDER BY `site_email_settings_code` ASC
[5] =>
Time: 0.0013:
SELECT *
FROM `xm_settings`
WHERE `xm_settings_code` = 'enable_using_cart_api'
LIMIT 1
[6] =>
Time: 0.0012:
SELECT COUNT(*) AS `numrows`
FROM `basket_items`
WHERE `user_token` = 'ZTdiMTQ4ZGZkZTg1YTc4MmY1ZDIxNzg3NzM1NzU3YmJlZDc3YWQ3Mw=='
[7] =>
Time: 0.0017:
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.0013:
SELECT *
FROM `clients`
LIMIT 1
[10] =>
Time: 0.0021:
SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEB000001'
[11] =>
Time: 0.0012:
SELECT *
FROM `currencies`
WHERE `currencies_denom` = 'GBP'
[12] =>
Time: 0.0013:
SELECT *
FROM `currencies`
WHERE `currencies_id` = 7
[13] =>
Time: 0.0020:
SELECT * FROM layout_settings
WHERE layout_settings_page_id = (SELECT layout_pages_id FROM layout_pages WHERE layout_pages_code = ?) LIMIT 1
[14] =>
Time: 0.0014:
SELECT *
FROM `currencies`
WHERE `currencies_symbol` = '£'
LIMIT 1
[15] =>
Time: 0.0019:
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
[16] =>
Time: 0.0010:
SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEB000001'
[17] =>
Time: 0.0016:
SELECT * FROM `routes` WHERE `routes_url_name` = ? AND `routes_table_name` IN (?,?,?)
[18] =>
Time: 0.0013:
SELECT *
FROM `categories_display_mode`
[19] =>
Time: 0.0014:
SELECT `public_categories_is_brand` AS `isBrand`
FROM `public_categories`
WHERE `public_categories_id` = 47
[20] =>
Time: 0.0012:
SELECT `public_categories_parent` AS `parentCategoryId`
FROM `public_categories`
WHERE `public_categories_id` = 47
[21] =>
Time: 0.0010:
SELECT *
FROM `clients`
LIMIT 1
[22] =>
Time: 0.0021:
SELECT *
FROM `html`
WHERE `html_name` = 'xm-category'
AND `html_scope` = 'public'
LIMIT 1
[23] =>
Time: 0.0018:
SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(732)
ORDER BY `html_column_contents_order` ASC
[24] =>
Time: 0.0021:
SELECT `html_contents`.*
FROM `html_contents`
LEFT JOIN `html_column_grid` ON `html_contents_grid` = `html_column_grid_id`
WHERE html_contents_column IN(403, 404)
ORDER BY `html_contents_row`, `html_contents_tab`, COALESCE( html_column_grid_ordering)
[25] =>
Time: 0.0016:
SELECT `html_column_grid`.*
FROM `html_column_grid`
WHERE html_column_grid_html_id IN(732)
ORDER BY `html_column_grid_ordering`
[26] =>
Time: 0.0018:
SELECT *
FROM `module_content`
WHERE `module_content_name` = 'mobile_menu_filters'
LIMIT 1
[27] =>
Time: 0.0018:
SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'en'
LIMIT 1
[28] =>
Time: 0.0017:
SELECT *
FROM `module_content`
WHERE module_content_name IN(mobile_menu, mobile_menu_filters, mobile_menu_account)
[29] =>
Time: 0.0018:
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'
[30] =>
Time: 0.0020:
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)
[31] =>
Time: 0.0016:
SELECT *
FROM `module_custom_css`
[32] =>
Time: 0.0017:
SELECT *
FROM `html`
WHERE html_header = 1
AND `html_scope` = 'public'
[33] =>
Time: 0.0007:
SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(720)
ORDER BY `html_column_contents_order` ASC
[34] =>
Time: 0.0020:
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)
[35] =>
Time: 0.0007:
SELECT `html_column_grid`.*
FROM `html_column_grid`
WHERE html_column_grid_html_id IN(720)
ORDER BY `html_column_grid_ordering`
[36] =>
Time: 0.0011:
SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'en'
LIMIT 1
[37] =>
Time: 0.0012:
SELECT *
FROM `module_content`
WHERE `module_content_name` = 'mobile_menu'
LIMIT 1
[38] =>
Time: 0.0029:
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)
[39] =>
Time: 0.0024:
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
[40] =>
Time: 0.0013:
SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(758, 759)
ORDER BY `html_column_contents_order` ASC
[41] =>
Time: 0.0011:
SELECT `html_column_grid`.*
FROM `html_column_grid`
WHERE html_column_grid_html_id IN(758, 759)
ORDER BY `html_column_grid_ordering`
[42] =>
Time: 0.0013:
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)
[43] =>
Time: 0.0013:
SELECT *
FROM `public_categories`
WHERE `public_categories_url` = 'en'
[44] =>
Time: 0.0012:
SELECT *
FROM `module_content`
WHERE `module_content_name` = 'mobile_menu_account'
LIMIT 1
[45] =>
Time: 0.0022:
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
[46] =>
Time: 0.0013:
SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'en'
LIMIT 1
[47] =>
Time: 0.0008:
SELECT *
FROM `categories_display_mode`
[48] =>
Time: 0.0015:
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'
[49] =>
Time: 0.0017:
SELECT *
FROM `html`
WHERE html_footer = 1
AND `html_scope` = 'public'
[50] =>
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
[51] =>
Time: 0.0020:
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
[52] =>
Time: 0.0015:
SELECT `html_contents`.*
FROM `html_contents`
WHERE html_contents_grid IN(754, 755)
)
-----------------------
