Debug

---

PHP Version - toggle (1)

-----------------------
Array
(
    [0] => 8.1.34
)

-----------------------

---

MVC info - toggle (9)

-----------------------
Array
(
    [0] => URI
    [1] => uri_string: s:42:"solutions/facilities-management/assa-abloy";
    [2] => segments: a:3:{i:1;s:9:"solutions";i:2;s:21:"facilities-management";i:3;s:10:"assa-abloy";}
    [3] => routed segments: a:2:{i:1;s:8:"category";i:2;s:5:"index";}
    [4] => 
    [5] => Router
    [6] => class: s:8:"category";
    [7] => class location: s:64:"/www/storephp/code/controllers/category/controllers/Category.php";
    [8] => method: s:5:"index";
)

-----------------------

---

SessionData - toggle (8)

-----------------------
Array
(
    [X-B3-TraceId] => 6f8f5cc1639420112a859be88d424f36
    [user_token] => MjdmNmMzMWVjOGRjMzUxNDU1YjMyMTlkZGY0YTk0ZTdiZmIzM2RhZg==
    [price_code] => WEB
    [currency_used] => USD
    [symbol] => US$
    [ignore-filter-ignore] => 0
    [hasSelectedFilter] => 
    [displayModeCode] => grid
)

-----------------------

---

DB Timing - toggle (1)

-----------------------
Array
(
    [0] => Total Query Time:             0.0911
)

-----------------------

---

Queries - toggle (42)

-----------------------
Array
(
    [0] => 
Time: 0.0113:
 SHOW TABLES FROM `s_craftmaster1`

    [1] => 
Time: 0.0114:
 SHOW TABLES FROM `s_craftmaster1`

    [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 *
FROM `site_email_settings`
ORDER BY `site_email_settings_code` ASC

    [4] => 
Time: 0.0014:
 SELECT *
FROM `xm_settings`
WHERE `xm_settings_code` = 'enable_using_cart_api'
 LIMIT 1

    [5] => 
Time: 0.0025:
 SELECT COUNT(*) AS `numrows`
FROM `basket_items`
WHERE `user_token` = 'MjdmNmMzMWVjOGRjMzUxNDU1YjMyMTlkZGY0YTk0ZTdiZmIzM2RhZg=='

    [6] => 
Time: 0.0018:
 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)

    [7] => 
Time: 0.0016:
 SELECT *
FROM `countries`
WHERE `countries_preferred` != 0
AND `countries_active` = 1
ORDER BY `countries_preferred` ASC

    [8] => 
Time: 0.0022:
 SELECT *
FROM `clients`
 LIMIT 1

    [9] => 
Time: 0.0013:
 SELECT *
FROM `redirections`
WHERE `redirections_from` = '%2Fsolutions%2Ffacilities-management%2Fassa-abloy%2F'
AND `redirections_active` = 1
 LIMIT 1

    [10] => 
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

    [11] => 
Time: 0.0010:
 SELECT *
FROM `currencies`
WHERE `currencies_symbol` = 'US$'
 LIMIT 1

    [12] => 
Time: 0.0040:
 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

    [13] => 
Time: 0.0018:
 SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEBUS'

    [14] => 
Time: 0.0027:
 SELECT * FROM `routes`  WHERE `routes_url_name` = ? AND `routes_table_name` IN (?,?,?)

    [15] => 
Time: 0.0011:
 SELECT *
FROM `redirections`
WHERE `redirections_from` = '%2Fsolutions%2Ffacilities-management%2Fassa-abloy%2F'
AND `redirections_active` = 1

    [16] => 
Time: 0.0014:
 SELECT *
FROM `categories_display_mode`

    [17] => 
Time: 0.0014:
 SELECT `public_categories_is_brand` AS `isBrand`
FROM `public_categories`
WHERE `public_categories_id` = 279

    [18] => 
Time: 0.0010:
 SELECT `public_categories_parent` AS `parentCategoryId`
FROM `public_categories`
WHERE `public_categories_id` = 279

    [19] => 
Time: 0.0009:
 SELECT *
FROM `clients`
 LIMIT 1

    [20] => 
Time: 0.0013:
 SELECT *
FROM `html`
WHERE `html_name` = 'xm-category'
AND `html_scope` = 'public'
 LIMIT 1

    [21] => 
Time: 0.0015:
 SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(16378)
ORDER BY `html_column_contents_order` ASC

    [22] => 
Time: 0.0017:
 SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'solutions'
 LIMIT 1

    [23] => 
Time: 0.0015:
 SELECT *
FROM `module_content`
WHERE module_content_name IN(mobile_menu, mobile_menu_filters, mobile_menu_account)

    [24] => 
Time: 0.0022:
 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'

    [25] => 
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)

    [26] => 
Time: 0.0020:
 SELECT *
FROM `module_custom_css`

    [27] => 
Time: 0.0015:
 SELECT *
FROM `module_content`
WHERE module_content_name IN(mobile_menu)

    [28] => 
Time: 0.0014:
 SELECT *
FROM `module_content`
WHERE `module_content_name` = 'mobile_menu'
 LIMIT 1

    [29] => 
Time: 0.0022:
 SELECT *
FROM `public_categories`
WHERE `public_categories_url` = 'solutions'

    [30] => 
Time: 0.0017:
 SELECT *
FROM `public_categories`
WHERE `public_categories_url` = 'solutions'
AND `public_categories_parent` = 231

    [31] => 
Time: 0.0007:
 SELECT *
FROM `categories_display_mode`

    [32] => 
Time: 0.0017:
 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'

    [33] => 
Time: 0.0021:
 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

    [34] => 
Time: 0.0016:
 SELECT *
FROM `html`
WHERE html_header = 1
AND `html_scope` = 'public'

    [35] => 
Time: 0.0006:
 SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(6428)
ORDER BY `html_column_contents_order` ASC

    [36] => 
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(2358, 2359)
ORDER BY `html_contents_row`, `html_contents_tab`, COALESCE( html_column_grid_ordering)

    [37] => 
Time: 0.0016:
 SELECT `html_column_grid`.*
FROM `html_column_grid`
WHERE html_column_grid_html_id IN(6428)
ORDER BY `html_column_grid_ordering`

    [38] => 
Time: 0.0036:
 SELECT *
FROM `html`
WHERE html_footer = 1
AND `html_scope` = 'public'

    [39] => 
Time: 0.0011:
 SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(6425)
ORDER BY `html_column_contents_order` ASC

    [40] => 
Time: 0.0023:
 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(2353, 8447, 2354, 2356, 2355, 2357)
AND `html_column_grid_html_id` = 6425
ORDER BY `html_column_contents_order` ASC, `html_column_grid_ordering` ASC

    [41] => 
Time: 0.0013:
 SELECT `html_contents`.*
FROM `html_contents`
WHERE html_contents_grid IN(3059, 14466, 3060, 3061, 3062, 14553, 3063, 3067, 3064, 3065, 3066, 3068, 14455, 3069)

)

-----------------------

---

Queries List - toggle (23)

-----------------------
Array
(
    [public_categories] => ______________________________________4 queries, time: 6.34ms
    [html] => ___________________________________________________3 queries, time: 6.49ms
    [html_column_contents] => ___________________________________3 queries, time: 3.25ms
    [module_content] => _________________________________________3 queries, time: 4.38ms
    [html_contents] => __________________________________________3 queries, time: 4.84ms
    [s_craftmaster1] => _________________________________________2 queries, time: 22.73ms
    [xm_settings] => ____________________________________________2 queries, time: 3.29ms
    [basket_items] => ___________________________________________2 queries, time: 4.56ms
    [clients] => ________________________________________________2 queries, time: 3.12ms
    [redirections] => ___________________________________________2 queries, time: 2.41ms
    [layout_settings] => ________________________________________2 queries, time: 5.65ms
    [categories_display_mode] => ________________________________2 queries, time: 2.15ms
    [html_column_grid] => _______________________________________2 queries, time: 3.92ms
    [store_features] => _________________________________________1 queries, time: 2.09ms
    [site_email_settings] => ____________________________________1 queries, time: 1.16ms
    [countries] => ______________________________________________1 queries, time: 1.65ms
    [currencies] => _____________________________________________1 queries, time: 0.98ms
    [arcus_customers] => ________________________________________1 queries, time: 1.79ms
    [routes] => _________________________________________________1 queries, time: 2.73ms
    [users_groups_setting] => ___________________________________1 queries, time: 1.72ms
    [api_settings] => ___________________________________________1 queries, time: 2.25ms
    [module_custom_tag] => ______________________________________1 queries, time: 1.53ms
    [module_custom_css] => ______________________________________1 queries, time: 2.04ms
)

-----------------------

---

Platform API Calls - toggle (8)

-----------------------
Array
(
    [0] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/store-features -> 200 [29.35ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 6f8f5cc1639420112a859be88d424f36
                    [X-B3-SpanId] => 97cad9d94b6b5452
                )

        )

    [1] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/xm-settings -> 200 [21.25ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 6f8f5cc1639420112a859be88d424f36
                    [X-B3-SpanId] => 54f971cbdf211871
                )

        )

    [2] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/store-mode -> 200 [17.48ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 6f8f5cc1639420112a859be88d424f36
                    [X-B3-SpanId] => 501304f9b6ce331c
                )

        )

    [3] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/module/all -> 200 [22.98ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 6f8f5cc1639420112a859be88d424f36
                    [X-B3-SpanId] => feb44d73ce5ec4f8
                )

        )

    [4] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->post()
            [1] => POST /api/v/1/products/search?size=24&page=0 -> 200 [116.47ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 6f8f5cc1639420112a859be88d424f36
                    [X-B3-SpanId] => 8ae22a4556e972bf
                )

        )

    [5] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/categories/content -> 200 [15.81ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 6f8f5cc1639420112a859be88d424f36
                    [X-B3-SpanId] => 716d16be6fac5f1e
                )

        )

    [6] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/labels -> 200 [21.69ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 6f8f5cc1639420112a859be88d424f36
                    [X-B3-SpanId] => 6fbc9977d66fccfe
                )

        )

    [7] => Array
        (
            [Total API Response Time:] => 0.24503 sec
        )

)

-----------------------

---

Timing - toggle (1)

-----------------------
Array
(
    [0] => Page Load Time:               0.4679 seconds.
)

-----------------------