Debug

---

PHP Version - toggle (1)

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

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

---

MVC info - toggle (9)

-----------------------
Array
(
    [0] => URI
    [1] => uri_string: s:42:"user/registerForm/form/45b4709be7a7fbc8e2b";
    [2] => segments: a:4:{i:1;s:4:"user";i:2;s:12:"registerForm";i:3;s:4:"form";i:4;s:19:"45b4709be7a7fbc8e2b";}
    [3] => routed segments: a:3:{i:1;s:12:"registerForm";i:2;s:4:"form";i:3;s:19:"45b4709be7a7fbc8e2b";}
    [4] => 
    [5] => Router
    [6] => class: s:12:"registerForm";
    [7] => class location: s:64:"/www/storephp/code/controllers/user/controllers/RegisterForm.php";
    [8] => method: s:4:"form";
)

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

---

SessionData - toggle (7)

-----------------------
Array
(
    [X-B3-TraceId] => 668f4a500a6e7106c0ff0675313f9a9d
    [user_token] => N2U2YjY0NGE3ZDY2ODczN2UxMTkxMThjMjU3N2MxYTJhYzJmMWFjZQ==
    [price_code] => WEB
    [currency_used] => USD
    [symbol] => US$
    [xmci_csrf_time_name] => 1770601799
    [xmci_csrf_token] => f12eceeec3575d522862b43e0054ef6bALXpRr8h4A2tyw==
)

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

---

DB Timing - toggle (1)

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

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

---

Queries - toggle (50)

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

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

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

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

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

    [6] => 
Time: 0.0024:
 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.0020:
 SELECT *
FROM `countries`
WHERE `countries_preferred` != 0
AND `countries_active` = 1
ORDER BY `countries_preferred` ASC

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

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

    [10] => 
Time: 0.0013:
 SELECT *
FROM `currencies`
WHERE `currencies_denom` = 'USD'

    [11] => 
Time: 0.0012:
 SELECT *
FROM `currencies`
WHERE `currencies_id` = 21

    [12] => 
Time: 0.0013:
 SELECT *
FROM `redirections`
WHERE `redirections_from` = '%2Fuser%2FregisterForm%2Fform%2F45b4709be7a7fbc8e2b'
AND `redirections_active` = 1
 LIMIT 1

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

    [14] => 
Time: 0.0017:
 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.0017:
 SELECT *
FROM `currencies`
WHERE `currencies_symbol` = 'US$'
 LIMIT 1

    [16] => 
Time: 0.0027:
 SELECT *
FROM `registration`
WHERE `identifier` = '45b4709be7a7fbc8e2b'
AND `is_disabled` =0
AND (`is_on_registration_page` = 1 OR `is_onepage_registration_option` = 1)
ORDER BY `ordering`
 LIMIT 1

    [17] => 
Time: 0.0031:
 SELECT *
FROM `registration_field`
WHERE registration_id IN(2)
ORDER BY `ordering`

    [18] => 
Time: 0.0019:
 SELECT *
FROM `registration_field_lang`
WHERE registration_field_lang.registration_field_id IN(54, 28, 29, 73, 62, 30, 32, 33, 63, 64, 65, 66, 67, 68, 69, 70, 71, 74)

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

    [20] => 
Time: 0.0008:
 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.0026:
 SELECT *
FROM `shipping_countries`
LEFT JOIN `countries` ON `countries_code` = `shipping_countries_code`
WHERE `shipping_countries_public` = 1
AND `countries_active` = 1
GROUP BY `shipping_countries_code`
ORDER BY `shipping_countries_name` ASC

    [22] => 
Time: 0.0021:
 SELECT *
FROM `shipping_countries`
LEFT JOIN `countries` ON `countries_code` = `shipping_countries_code`
WHERE `shipping_countries_public` = 0
AND `countries_active` = 1
GROUP BY `shipping_countries_code`
ORDER BY `shipping_countries_name` ASC

    [23] => 
Time: 0.0019:
 SELECT *
FROM `countries`
WHERE `countries_code` = 'USA'
OR `countries_name` = 'USA'
AND `countries_active` = 1
 LIMIT 1

    [24] => 
Time: 0.0032:
 SELECT `carriers`.* FROM `carriers` JOIN carriers_countries ON carriers_id = carriers_countries_carrier_id WHERE  (`carriers_site_scope` = ? OR `carriers_site_scope` = 'both') AND (`carriers_countries_country_code` = ?) ORDER BY carriers_sort_order ASC, carriers_location ASC

    [25] => 
Time: 0.0027:
 SELECT `zones`.*
FROM `zones`
WHERE zones_cid IN(6, 7, 2, 9, 59)
AND `zones_country_code` = 'US'

    [26] => 
Time: 0.0009:
 SELECT *
FROM `countries`
WHERE `countries_code` = 'USA'
OR `countries_name` = 'USA'
AND `countries_active` = 1
 LIMIT 1

    [27] => 
Time: 0.0010:
 SELECT `carriers`.* FROM `carriers` JOIN carriers_countries ON carriers_id = carriers_countries_carrier_id WHERE  (`carriers_site_scope` = ? OR `carriers_site_scope` = 'both') AND (`carriers_countries_country_code` = ?) ORDER BY carriers_sort_order ASC, carriers_location ASC

    [28] => 
Time: 0.0013:
 SELECT `zones`.*
FROM `zones`
WHERE zones_cid IN(6, 7, 2, 9, 59)
AND `zones_country_code` = 'US'

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

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

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

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

    [33] => 
Time: 0.0018:
 SELECT *
FROM `module_custom_css`

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

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

    [36] => 
Time: 0.0021:
 SELECT *
FROM `public_categories`
WHERE `public_categories_url` = 'user'

    [37] => 
Time: 0.0016:
 SELECT *
FROM `categories_display_mode`

    [38] => 
Time: 0.0020:
 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'

    [39] => 
Time: 0.0011:
 SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEBUS'

    [40] => 
Time: 0.0023:
 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

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

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

    [43] => 
Time: 0.0015:
 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)

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

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

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

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

    [48] => 
Time: 0.0017:
 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)

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

)

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

---

Queries List - toggle (29)

-----------------------
Array
(
    [countries] => ______________________________________________3 queries, time: 4.87ms
    [currencies] => _____________________________________________3 queries, time: 4.18ms
    [module_content] => _________________________________________3 queries, time: 4.42ms
    [html_contents] => __________________________________________3 queries, time: 5.25ms
    [s_craftmaster1] => _________________________________________2 queries, time: 15.94ms
    [xm_settings] => ____________________________________________2 queries, time: 4.38ms
    [basket_items] => ___________________________________________2 queries, time: 5.84ms
    [clients] => ________________________________________________2 queries, time: 2.40ms
    [arcus_customers] => ________________________________________2 queries, time: 3.09ms
    [api_settings] => ___________________________________________2 queries, time: 3.56ms
    [registration_b2b_template_arcus_customer] => _______________2 queries, time: 3.23ms
    [shipping_countries] => _____________________________________2 queries, time: 4.73ms
    [carriers] => _______________________________________________2 queries, time: 4.19ms
    [zones] => __________________________________________________2 queries, time: 4.04ms
    [html] => ___________________________________________________2 queries, time: 5.50ms
    [html_column_contents] => ___________________________________2 queries, time: 3.75ms
    [html_column_grid] => _______________________________________2 queries, time: 2.99ms
    [store_features] => _________________________________________1 queries, time: 2.33ms
    [site_email_settings] => ____________________________________1 queries, time: 1.62ms
    [redirections] => ___________________________________________1 queries, time: 1.27ms
    [layout_settings] => ________________________________________1 queries, time: 1.71ms
    [registration] => ___________________________________________1 queries, time: 2.75ms
    [registration_field] => _____________________________________1 queries, time: 3.12ms
    [registration_field_lang] => ________________________________1 queries, time: 1.94ms
    [users_groups_setting] => ___________________________________1 queries, time: 1.80ms
    [module_custom_tag] => ______________________________________1 queries, time: 1.22ms
    [module_custom_css] => ______________________________________1 queries, time: 1.79ms
    [public_categories] => ______________________________________1 queries, time: 2.07ms
    [categories_display_mode] => ________________________________1 queries, time: 1.58ms
)

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

---

Platform API Calls - toggle (7)

-----------------------
Array
(
    [0] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/store-features -> 200 [38.33ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 668f4a500a6e7106c0ff0675313f9a9d
                    [X-B3-SpanId] => ce42b21bed4547c0
                )

        )

    [1] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/xm-settings -> 200 [26.29ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 668f4a500a6e7106c0ff0675313f9a9d
                    [X-B3-SpanId] => d76a47f3e2ca2840
                )

        )

    [2] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/store-mode -> 200 [24.45ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 668f4a500a6e7106c0ff0675313f9a9d
                    [X-B3-SpanId] => c662aadf37a5e022
                )

        )

    [3] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/module/all -> 200 [29.67ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 668f4a500a6e7106c0ff0675313f9a9d
                    [X-B3-SpanId] => 4f781184754d5636
                )

        )

    [4] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/labels -> 200 [32.31ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 668f4a500a6e7106c0ff0675313f9a9d
                    [X-B3-SpanId] => 2355ae674a3bbc78
                )

        )

    [5] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/categories/content -> 200 [30.69ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 668f4a500a6e7106c0ff0675313f9a9d
                    [X-B3-SpanId] => 9295a157688fc5ec
                )

        )

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

)

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

---

Timing - toggle (1)

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

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