To top

Debug


PHP Version - toggle (1) 

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

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

MVC info - toggle (9) 

-----------------------
Array
(
    [0] => URI
    [1] => uri_string: s:10:"user/login";
    [2] => segments: a:2:{i:1;s:4:"user";i:2;s:5:"login";}
    [3] => routed segments: a:2:{i:1;s:4:"user";i:2;s:5:"login";}
    [4] => 
    [5] => Router
    [6] => class: s:4:"user";
    [7] => class location: s:56:"/www/storephp/code/controllers/user/controllers/User.php";
    [8] => method: s:5:"login";
)

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

SessionData - toggle (11) 

-----------------------
Array
(
    [X-B3-TraceId] => 37035c3f13cd33866caa596b8126a039
    [user_token] => OTAzODQ1YTk3NzM3ZTFjMjc1ZTVkMTFlZjUxNmZjZjRiYTMyMjk2NA==
    [api_access_token] => eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdG9yZV9pZCI6ImNyYWZ0bWFzdGVyMSIsImF1ZCI6WyJmaWxlcy1kYWVtb24iLCJjYXRhbG9nLWluZGV4IiwidmFsdWVzIiwicGF5bWVudHMiLCJvYXV0aDIiLCJzdG9ja3MiLCJjYXJ0Iiwibm90aWZpY2F0aW9uIiwic2hpcHBpbmciLCJ0YWd6IiwiY2F0YWxvZy1zZWFyY2giLCJjdXN0b21lcnMiLCJwcmljZXMiLCJzY2hlZHVsZS1kYWVtb24iLCJjaGVja291dCIsImNhbGN1bGF0b3IiLCJzZXR0aW5ncyIsImNvbmZpZy1kYWVtb24iLCJzeW5jIiwiZmlsZS1wcm9jZXNzb3ItZGFlbW9uIiwiZ3JpZCIsImZpbGVzIiwib3JkZXJzIiwic3RvcmVzLWRhZW1vbiIsInByb21vdGlvbiJdLCJzY29wZSI6WyJyZWFkIiwid3JpdGUiLCJndWVzdCIsInVzZXIiLCJhZG1pbiIsInZlcmlmaWVkIl0sImV4cCI6MTc3MDU5Nzc4MCwiYXV0aG9yaXRpZXMiOlsiMTkxIiwiMTkzIiwiMTk2IiwiMTk3IiwiMTExIiwiMTE0IiwiMTE1IiwiOTAiLCI5MyIsIjk2IiwiMTAiLCI1NCIsIjk5IiwiMTEiLCIxMiIsIjU3IiwiMTUiLCIxOCIsIjEyMCIsIjAiLCIxIiwiMiIsIjEyMyIsIjIwMCIsIjQiLCI3IiwiMjA1IiwiNjAiLCI2MyIsIjIxIiwiNjYiLCIyNCIsIjY5IiwiMjciLCIxMzIiLCIxMzMiLCIxMzUiLCIyMTIiLCIxMzciLCIyMTUiLCIxMzgiLCIxMzkiLCI3MiIsIjMwIiwiNzUiLCIzMyIsIjc4IiwiMzkiLCIxNDAiLCIxNDMiLCIxODgiLCIyMjEiLCIxMDIiLCIyMjUiLCIxMDUiLCIxMDgiLCI4MSIsIjg0IiwiODciXSwianRpIjoiMWpfWS1rOXpJOGM2MWxMcmFhTENVOFBObTJrIiwiY2xpZW50X2lkIjoic3ltcGhvbnkyIn0.MykXi7OHVX4oCW-dGCJGsOFFL5QWGea33UUUeYqNclE
    [api_verified_access_token] => eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdG9yZV9pZCI6ImNyYWZ0bWFzdGVyMSIsImF1ZCI6WyJmaWxlcy1kYWVtb24iLCJjYXRhbG9nLWluZGV4IiwidmFsdWVzIiwicGF5bWVudHMiLCJvYXV0aDIiLCJzdG9ja3MiLCJjYXJ0Iiwibm90aWZpY2F0aW9uIiwic2hpcHBpbmciLCJ0YWd6IiwiY2F0YWxvZy1zZWFyY2giLCJjdXN0b21lcnMiLCJwcmljZXMiLCJzY2hlZHVsZS1kYWVtb24iLCJjaGVja291dCIsImNhbGN1bGF0b3IiLCJzZXR0aW5ncyIsImNvbmZpZy1kYWVtb24iLCJzeW5jIiwiZmlsZS1wcm9jZXNzb3ItZGFlbW9uIiwiZ3JpZCIsImZpbGVzIiwib3JkZXJzIiwic3RvcmVzLWRhZW1vbiIsInByb21vdGlvbiJdLCJzY29wZSI6WyJ2ZXJpZmllZCJdLCJleHAiOjE3NzA1OTc3ODAsImF1dGhvcml0aWVzIjpbIjE5MSIsIjE5NiIsIjE5NyIsIjExMSIsIjExNCIsIjExNSIsIjkwIiwiOTMiLCI5NiIsIjEwIiwiNTQiLCI5OSIsIjExIiwiMTIiLCI1NyIsIjE1IiwiMTgiLCIxMjAiLCIwIiwiMSIsIjIiLCIxMjMiLCIyMDAiLCI0IiwiNyIsIjIwNSIsIjYwIiwiNjMiLCIyMSIsIjY2IiwiMjQiLCI2OSIsIjI3IiwiMTMyIiwiMTMzIiwiMTM1IiwiMjEyIiwiMTM3IiwiMjE1IiwiMTM4IiwiMTM5IiwiNzIiLCIzMCIsIjc1IiwiMzMiLCI3OCIsIjM5IiwiMTQwIiwiMTQzIiwiMTg4IiwiMjIxIiwiMTAyIiwiMjI1IiwiMTA1IiwiMTA4IiwiODEiLCI4NCIsIjg3Il0sImp0aSI6ImpGb1JnbzY5ZE01WE81Rlc5Y1BPcmczTmNnZyIsImNsaWVudF9pZCI6ImNvbW1lcmNlYnVpbGQtd2ViIn0.Pu4s89KlLm_d9dCtSllfugqoma1y535KjC8wbQ1oEqw
    [api_token_expiry] => 3589
    [api_token_start] => 1770594180
    [price_code] => WEB
    [currency_used] => USD
    [symbol] => US$
    [xmci_csrf_time_name] => 1770594181
    [xmci_csrf_token] => 1c3997c40f7ff20205357a552dee089bazBg9Fp13IozVQ==
)

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

DB Timing - toggle (1) 

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

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

Queries - toggle (37) 

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

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

    [2] => 
Time: 0.0035:
 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.0019:
 SELECT *
FROM `site_email_settings`
ORDER BY `site_email_settings_code` ASC

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

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

    [6] => 
Time: 0.0020:
 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.0025:
 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.0023:
 SELECT *
FROM `redirections`
WHERE `redirections_from` = '%2Fuser%2Flogin'
AND `redirections_active` = 1
 LIMIT 1

    [10] => 
Time: 0.0025:
 SELECT *
FROM `api_settings`
RIGHT JOIN `api` ON `api_id` = `api_settings_api_id`
WHERE `api_code` = 'moodle'

    [11] => 
Time: 0.0026:
 SELECT * FROM layout_settings
                      WHERE layout_settings_page_id = (SELECT layout_pages_id FROM layout_pages WHERE layout_pages_code = ?) LIMIT 1

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

    [13] => 
Time: 0.0028:
 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

    [14] => 
Time: 0.0033:
 SELECT *
FROM `html`
WHERE `html_name` = 'xm-login'
AND `html_scope` = 'public'
ORDER BY `html_ordering` ASC

    [15] => 
Time: 0.0019:
 SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(16420)
ORDER BY `html_column_contents_order` ASC

    [16] => 
Time: 0.0028:
 SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'user'
 LIMIT 1

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

    [18] => 
Time: 0.0019:
 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'

    [19] => 
Time: 0.0027:
 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)

    [20] => 
Time: 0.0028:
 SELECT *
FROM `module_custom_css`

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

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

    [23] => 
Time: 0.0029:
 SELECT *
FROM `public_categories`
WHERE `public_categories_url` = 'user'

    [24] => 
Time: 0.0018:
 SELECT *
FROM `categories_display_mode`

    [25] => 
Time: 0.0024:
 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'

    [26] => 
Time: 0.0020:
 SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEBUS'

    [27] => 
Time: 0.0027:
 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

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

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

    [30] => 
Time: 0.0027:
 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)

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

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

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

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

    [35] => 
Time: 0.0016:
 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)

    [36] => 
Time: 0.0007:
 SELECT *
FROM `clients`
 LIMIT 1

)

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

Queries List - toggle (22) 

-----------------------
Array
(
    [html] => ___________________________________________________3 queries, time: 9.54ms
    [html_column_contents] => ___________________________________3 queries, time: 3.42ms
    [module_content] => _________________________________________3 queries, time: 4.26ms
    [html_contents] => __________________________________________3 queries, time: 6.71ms
    [s_craftmaster1] => _________________________________________2 queries, time: 15.10ms
    [xm_settings] => ____________________________________________2 queries, time: 3.52ms
    [basket_items] => ___________________________________________2 queries, time: 4.61ms
    [clients] => ________________________________________________2 queries, time: 2.84ms
    [api_settings] => ___________________________________________2 queries, time: 4.45ms
    [layout_settings] => ________________________________________2 queries, time: 5.42ms
    [html_column_grid] => _______________________________________2 queries, time: 3.04ms
    [store_features] => _________________________________________1 queries, time: 3.55ms
    [site_email_settings] => ____________________________________1 queries, time: 1.89ms
    [countries] => ______________________________________________1 queries, time: 2.48ms
    [redirections] => ___________________________________________1 queries, time: 2.34ms
    [currencies] => _____________________________________________1 queries, time: 1.66ms
    [users_groups_setting] => ___________________________________1 queries, time: 2.83ms
    [module_custom_tag] => ______________________________________1 queries, time: 2.73ms
    [module_custom_css] => ______________________________________1 queries, time: 2.78ms
    [public_categories] => ______________________________________1 queries, time: 2.90ms
    [categories_display_mode] => ________________________________1 queries, time: 1.82ms
    [arcus_customers] => ________________________________________1 queries, time: 2.04ms
)

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

Platform API Calls - toggle (7) 

-----------------------
Array
(
    [0] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/store-features -> 200 [46.68ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 37035c3f13cd33866caa596b8126a039
                    [X-B3-SpanId] => b90ac9a0061370b6
                )

        )

    [1] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/xm-settings -> 200 [35.47ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 37035c3f13cd33866caa596b8126a039
                    [X-B3-SpanId] => 7cbbc6a258ab6f6c
                )

        )

    [2] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/store-mode -> 200 [33.69ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 37035c3f13cd33866caa596b8126a039
                    [X-B3-SpanId] => 32c93b62d98ebfb9
                )

        )

    [3] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/module/all -> 200 [36.57ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 37035c3f13cd33866caa596b8126a039
                    [X-B3-SpanId] => a029ce820f908269
                )

        )

    [4] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/labels -> 200 [32.77ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 37035c3f13cd33866caa596b8126a039
                    [X-B3-SpanId] => 21bc1695d7509320
                )

        )

    [5] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/categories/content -> 200 [1714.65ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 37035c3f13cd33866caa596b8126a039
                    [X-B3-SpanId] => 07d57e0e5f6af5bd
                )

        )

    [6] => Array
        (
            [Total API Response Time:] => 1.89983 sec
        )

)

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

Timing - toggle (1) 

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

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