Don't See What You're Looking For? We Can Find It! Call or Live Chat with one of our Product Specialists!

 

Expect More!

Craftmaster Hardware is a full-service qualified wholesale distributor of security hardware, detention, commercial door locks, and locksmith supplies. When you work with us, you can count on high-quality products and competitive pricing. But we know to become your most valued partner, your “go-to” source, you need something more.

Our Customers Rely on us Every Day Because:

  • We are experts in the education, healthcare, facility security and detention markets
  • We take personal responsibility for delivering the solution you need
  • We are accountable for results and committed to unrivaled service
To top

Debug


PHP Version - toggle (1) 

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

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

MVC info - toggle (9) 

-----------------------
Array
(
    [0] => URI
    [1] => uri_string: s:0:"";
    [2] => segments: a:0:{}
    [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 (11) 

-----------------------
Array
(
    [X-B3-TraceId] => 91417ec019e3cca65c8f1c33f519bb18
    [user_token] => YWI2MThmMDdlM2YzZjdhNGRkY2Q4MWFkNTc5MGIxYmQyMzk4NDE2Mg==
    [api_access_token] => eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdG9yZV9pZCI6ImNyYWZ0bWFzdGVyMSIsImF1ZCI6WyJmaWxlcy1kYWVtb24iLCJjYXRhbG9nLWluZGV4IiwidmFsdWVzIiwicGF5bWVudHMiLCJvYXV0aDIiLCJzdG9ja3MiLCJjYXJ0Iiwibm90aWZpY2F0aW9uIiwic2hpcHBpbmciLCJ0YWd6IiwiY2F0YWxvZy1zZWFyY2giLCJjdXN0b21lcnMiLCJwcmljZXMiLCJzY2hlZHVsZS1kYWVtb24iLCJjaGVja291dCIsImNhbGN1bGF0b3IiLCJzZXR0aW5ncyIsImNvbmZpZy1kYWVtb24iLCJzeW5jIiwiZmlsZS1wcm9jZXNzb3ItZGFlbW9uIiwiZ3JpZCIsImZpbGVzIiwib3JkZXJzIiwic3RvcmVzLWRhZW1vbiIsInByb21vdGlvbiJdLCJzY29wZSI6WyJyZWFkIiwid3JpdGUiLCJndWVzdCIsInVzZXIiLCJhZG1pbiIsInZlcmlmaWVkIl0sImV4cCI6MTc3MDU4MzM0NywiYXV0aG9yaXRpZXMiOlsiMTkxIiwiMTkzIiwiMTk2IiwiMTk3IiwiMTExIiwiMTE0IiwiMTE1IiwiOTAiLCI5MyIsIjk2IiwiMTAiLCI1NCIsIjk5IiwiMTEiLCIxMiIsIjU3IiwiMTUiLCIxOCIsIjEyMCIsIjAiLCIxIiwiMiIsIjEyMyIsIjIwMCIsIjQiLCI3IiwiMjA1IiwiNjAiLCI2MyIsIjIxIiwiNjYiLCIyNCIsIjY5IiwiMjciLCIxMzIiLCIxMzMiLCIxMzUiLCIyMTIiLCIxMzciLCIyMTUiLCIxMzgiLCIxMzkiLCI3MiIsIjMwIiwiNzUiLCIzMyIsIjc4IiwiMzkiLCIxNDAiLCIxNDMiLCIxODgiLCIyMjEiLCIxMDIiLCIyMjUiLCIxMDUiLCIxMDgiLCI4MSIsIjg0IiwiODciXSwianRpIjoiSHg1QzY2SDVpN1pQYTJNYWk0NS1iM2F3Y1hzIiwiY2xpZW50X2lkIjoic3ltcGhvbnkyIn0.k7wXvvmhnNvDLA3iyeKYfIYK-bOsoAKt9H0RKgm7gXY
    [api_verified_access_token] => eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdG9yZV9pZCI6ImNyYWZ0bWFzdGVyMSIsImF1ZCI6WyJmaWxlcy1kYWVtb24iLCJjYXRhbG9nLWluZGV4IiwidmFsdWVzIiwicGF5bWVudHMiLCJvYXV0aDIiLCJzdG9ja3MiLCJjYXJ0Iiwibm90aWZpY2F0aW9uIiwic2hpcHBpbmciLCJ0YWd6IiwiY2F0YWxvZy1zZWFyY2giLCJjdXN0b21lcnMiLCJwcmljZXMiLCJzY2hlZHVsZS1kYWVtb24iLCJjaGVja291dCIsImNhbGN1bGF0b3IiLCJzZXR0aW5ncyIsImNvbmZpZy1kYWVtb24iLCJzeW5jIiwiZmlsZS1wcm9jZXNzb3ItZGFlbW9uIiwiZ3JpZCIsImZpbGVzIiwib3JkZXJzIiwic3RvcmVzLWRhZW1vbiIsInByb21vdGlvbiJdLCJzY29wZSI6WyJ2ZXJpZmllZCJdLCJleHAiOjE3NzA1ODMzNDcsImF1dGhvcml0aWVzIjpbIjE5MSIsIjE5NiIsIjE5NyIsIjExMSIsIjExNCIsIjExNSIsIjkwIiwiOTMiLCI5NiIsIjEwIiwiNTQiLCI5OSIsIjExIiwiMTIiLCI1NyIsIjE1IiwiMTgiLCIxMjAiLCIwIiwiMSIsIjIiLCIxMjMiLCIyMDAiLCI0IiwiNyIsIjIwNSIsIjYwIiwiNjMiLCIyMSIsIjY2IiwiMjQiLCI2OSIsIjI3IiwiMTMyIiwiMTMzIiwiMTM1IiwiMjEyIiwiMTM3IiwiMjE1IiwiMTM4IiwiMTM5IiwiNzIiLCIzMCIsIjc1IiwiMzMiLCI3OCIsIjM5IiwiMTQwIiwiMTQzIiwiMTg4IiwiMjIxIiwiMTAyIiwiMjI1IiwiMTA1IiwiMTA4IiwiODEiLCI4NCIsIjg3Il0sImp0aSI6ImxuNzFqZTdkeExBSm4yM2tTeHFhS2NYX1otcyIsImNsaWVudF9pZCI6ImNvbW1lcmNlYnVpbGQtd2ViIn0.cbbdqdlc5wWETCrKzDCQyrIG3lCnnZ1cT3Go79jB0-E
    [api_token_expiry] => 3589
    [api_token_start] => 1770579747
    [price_code] => WEB
    [currency_used] => USD
    [symbol] => US$
    [xmci_csrf_time_name] => 1770579748
    [xmci_csrf_token] => 8eecee80f8cbcd5e63cdbf31fc9d9e08c4b1hg/Ya54FXw==
)

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

DB Timing - toggle (1) 

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

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

Queries - toggle (49) 

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

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

    [2] => 
Time: 0.0020:
 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.0015:
 SELECT *
FROM `xm_settings`
WHERE `xm_settings_code` = 'enable_using_cart_api'
 LIMIT 1

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

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

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

    [9] => 
Time: 0.0026:
 SELECT *
FROM `redirections`
WHERE `redirections_from` = '%2F'
AND `redirections_active` = 1
 LIMIT 1

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

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

    [12] => 
Time: 0.0021:
 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.0019:
 SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEBUS'

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

    [15] => 
Time: 0.0016:
 SELECT *
FROM `redirections`
WHERE `redirections_from` = '%2F'

    [16] => 
Time: 0.0124:
 SELECT *
FROM `html`
WHERE `html_name` = 'home'
AND `html_scope` = 'public'
 LIMIT 1

    [17] => 
Time: 0.0114:
 SELECT `html_contents_id`
FROM `html_contents`
JOIN `html` ON `html_contents_html_id` = `html_id`
WHERE `html_scope` = 'public'
AND html_name IN(home, footer, header)
AND `html_contents_module` = 'form'

    [18] => 
Time: 0.0067:
 SELECT *
FROM `categories_display_mode`

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

    [20] => 
Time: 0.0077:
 SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(6421)
ORDER BY `html_column_contents_order` ASC

    [21] => 
Time: 0.0134:
 SELECT `html_contents`.*
FROM `html_contents`
LEFT JOIN `html_column_grid` ON `html_contents_grid` = `html_column_grid_id`
WHERE html_contents_column IN(2348, 2349, 8495, 2351, 2352, 2347)
ORDER BY `html_contents_row`, `html_contents_tab`, COALESCE( html_column_grid_ordering)

    [22] => 
Time: 0.0024:
 SELECT `html_column_grid`.*
FROM `html_column_grid`
WHERE html_column_grid_html_id IN(6421)
ORDER BY `html_column_grid_ordering`

    [23] => 
Time: 0.1395:
 SELECT public_categories.*, routes.* FROM public_categories LEFT JOIN routes ON public_categories.public_categories_id = `routes`.`routes_table_id` AND `routes`.`routes_table_name`='categories' LEFT JOIN (SELECT COUNT(IFNULL(`categories_products_id`, 1)) AS count, `categories_products_cid` AS id FROM categories_products GROUP BY categories_products_cid) AS t2 ON (public_categories.public_categories_id=t2.`id`) WHERE  (public_categories_is_brand = ?) AND (`public_categories_parent` != 0) AND (`public_categories_name` != '') ORDER BY t2.count DESC LIMIT ?

    [24] => 
Time: 0.0016:
 SELECT *
FROM `html_column_contents`
WHERE `html_column_contents_html_id` = 6421
ORDER BY `html_column_contents_order` ASC

    [25] => 
Time: 0.0016:
 SELECT `html_contents`.*
FROM `html_contents`
LEFT JOIN `html_column_grid` ON `html_contents_grid` = `html_column_grid_id`
WHERE html_contents_column IN(2346)
ORDER BY `html_contents_row` ASC, `html_contents_tab` ASC, COALESCE( html_column_grid_ordering)

    [26] => 
Time: 0.0006:
 SELECT *
FROM `clients`
 LIMIT 1

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

    [28] => 
Time: 0.0102:
 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'

    [29] => 
Time: 0.0077:
 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)

    [30] => 
Time: 0.0074:
 SELECT *
FROM `module_custom_css`

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

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

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

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

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

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

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

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

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

    [40] => 
Time: 0.0013:
 SELECT *
FROM `html_column_contents`
WHERE `html_column_contents_id` = 2346

    [41] => 
Time: 0.0004:
 SELECT *
FROM `html_column_contents`
WHERE `html_column_contents_id` = 2346

    [42] => 
Time: 0.0047:
 SELECT *
FROM `html_column`
WHERE `html_column_id` = 4

    [43] => 
Time: 0.0012:
 SELECT *
FROM `html_column_grid`
WHERE `html_column_grid_id` = 3051

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

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

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

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

    [48] => 
Time: 0.0006:
 SELECT COUNT(*) AS `numrows`
FROM `basket_items`
WHERE `user_token` = 'YWI2MThmMDdlM2YzZjdhNGRkY2Q4MWFkNTc5MGIxYmQyMzk4NDE2Mg=='

)

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

Queries List - toggle (23) 

-----------------------
Array
(
    [html_contents] => __________________________________________7 queries, time: 35.88ms
    [html_column_contents] => ___________________________________6 queries, time: 12.32ms
    [html_column_grid] => _______________________________________4 queries, time: 8.12ms
    [basket_items] => ___________________________________________3 queries, time: 3.82ms
    [html] => ___________________________________________________3 queries, time: 18.92ms
    [module_content] => _________________________________________3 queries, time: 6.85ms
    [s_craftmaster1] => _________________________________________2 queries, time: 14.44ms
    [xm_settings] => ____________________________________________2 queries, time: 3.31ms
    [clients] => ________________________________________________2 queries, time: 1.55ms
    [redirections] => ___________________________________________2 queries, time: 4.15ms
    [layout_settings] => ________________________________________2 queries, time: 3.80ms
    [categories_display_mode] => ________________________________2 queries, time: 7.40ms
    [store_features] => _________________________________________1 queries, time: 1.96ms
    [site_email_settings] => ____________________________________1 queries, time: 1.25ms
    [countries] => ______________________________________________1 queries, time: 1.51ms
    [currencies] => _____________________________________________1 queries, time: 1.08ms
    [arcus_customers] => ________________________________________1 queries, time: 1.91ms
    [routes] => _________________________________________________1 queries, time: 11.52ms
    [public_categories] => ______________________________________1 queries, time: 139.51ms
    [api_settings] => ___________________________________________1 queries, time: 10.22ms
    [module_custom_tag] => ______________________________________1 queries, time: 7.66ms
    [module_custom_css] => ______________________________________1 queries, time: 7.36ms
    [html_column] => ____________________________________________1 queries, time: 4.74ms
)

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

Platform API Calls - toggle (7) 

-----------------------
Array
(
    [0] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/store-features -> 200 [34.57ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 91417ec019e3cca65c8f1c33f519bb18
                    [X-B3-SpanId] => 7a01bc5a9324eba7
                )

        )

    [1] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/xm-settings -> 200 [22.65ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 91417ec019e3cca65c8f1c33f519bb18
                    [X-B3-SpanId] => 5735bf058a2fb012
                )

        )

    [2] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/store-mode -> 200 [18.90ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 91417ec019e3cca65c8f1c33f519bb18
                    [X-B3-SpanId] => be0dabe329d852e7
                )

        )

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

        )

    [4] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/categories/content -> 200 [1126.41ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 91417ec019e3cca65c8f1c33f519bb18
                    [X-B3-SpanId] => 71703ff8e56ccfb9
                )

        )

    [5] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/labels -> 200 [58.23ms]
            [2] => Array
                (
                    [X-B3-TraceId] => 91417ec019e3cca65c8f1c33f519bb18
                    [X-B3-SpanId] => 3308466f37f5d54d
                )

        )

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

)

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

Timing - toggle (1) 

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

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