Quote Request:

Use this form to request a quote from us. Please provide brand, part #, description, quantity. You can also register here New Customer or Current Craftmaster Hardware Customer to use our online shopping cart and set up your own quotes. If you have any questions, use our Live Chat below.

First name:
* 		Company Name:
*
Last name:
* 		Address:
E-mail:
* 		City:
Your Job Title:
Zip Code:
*
Area Code:
Phone Number:
State:
*
Where did you hear about us? (Source):
Your Market/Industry:
Opt-Out of E-marketing communications:
Please use this area to list the items you would like us to quote. We suggest you to enter the list in the following format (list one Item Number per row):
Brand > Description > Item/Part Number > Quantity
To top

Debug


PHP Version - toggle (1) 

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

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

MVC info - toggle (9) 

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

-----------------------
Array
(
    [X-B3-TraceId] => d4d65f459319ed093b6377190d9051d6
    [user_token] => OWY2NTZmYjI3MTQ1ZDJkOWM4NDg0M2IzOGZkOGJkMWQ5ODI1YmI5ZQ==
    [price_code] => WEB
    [currency_used] => USD
    [symbol] => US$
    [xmci_csrf_time_name] => 1770608638
    [xmci_csrf_token] => f6228ef619a2eadd1758dd4f487e5bf2XX0Dy1E6mjoR8w==
)

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

DB Timing - toggle (1) 

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

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

Queries - toggle (42) 

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

    [1] => 
Time: 0.0067:
 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.0015:
 SELECT *
FROM `site_email_settings`
ORDER BY `site_email_settings_code` ASC

    [4] => 
Time: 0.0010:
 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` = 'OWY2NTZmYjI3MTQ1ZDJkOWM4NDg0M2IzOGZkOGJkMWQ5ODI1YmI5ZQ=='

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

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

    [9] => 
Time: 0.0014:
 SELECT *
FROM `redirections`
WHERE `redirections_from` = '%2Fquote-request'
AND `redirections_active` = 1
 LIMIT 1

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

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

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

    [15] => 
Time: 0.0015:
 SELECT *
FROM `redirections`
WHERE `redirections_from` = '%2Fquote-request'
AND `redirections_active` = 1

    [16] => 
Time: 0.0024:
 SELECT `html`.*
FROM `html`
WHERE html_id IN(6440)
ORDER BY `html_ordering` ASC

    [17] => 
Time: 0.0018:
 SELECT `html_column_contents`.*
FROM `html_column_contents`
WHERE html_column_contents_html_id IN(6440)
ORDER BY `html_column_contents_order` ASC

    [18] => 
Time: 0.0024:
 SELECT `html_contents`.*
FROM `html_contents`
LEFT JOIN `html_column_grid` ON `html_contents_grid` = `html_column_grid_id`
WHERE html_contents_column IN(2393, 2394)
ORDER BY `html_contents_row`, `html_contents_tab`, COALESCE( html_column_grid_ordering)

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

    [20] => 
Time: 0.0017:
 SELECT *
FROM `html_column_contents`
WHERE `html_column_contents_html_id` = 6440
ORDER BY `html_column_contents_order` ASC

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

    [22] => 
Time: 0.0032:
 SELECT *
FROM `users_groups_setting`
WHERE `users_groups_setting_landing_page` = 'quote-request'
 LIMIT 1

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

    [24] => 
Time: 0.0015:
 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.0016:
 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.0023:
 SELECT *
FROM `module_custom_css`

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

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

    [29] => 
Time: 0.0018:
 SELECT *
FROM `public_categories`
WHERE `public_categories_url` = 'quote-request'

    [30] => 
Time: 0.0021:
 SELECT *
FROM `categories_display_mode`

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

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

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

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

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

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

    [37] => 
Time: 0.0025:
 SELECT `html_id` AS `id`, `routes_url_name` AS `url_full`, `html_title` as `name`, `routes_url_name` AS `url_full`
FROM `html`
LEFT JOIN `routes` ON `html_id` = `routes_table_id`
WHERE html_scope IN(public, both)
AND routes_url_name IN(/quote-request)
AND `routes_table_name` = 'public_html'
AND `routes_public` = 1
ORDER BY `html_ordering` DESC

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

    [39] => 
Time: 0.0010:
 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.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)

)

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

Queries List - toggle (23) 

-----------------------
Array
(
    [html] => ___________________________________________________4 queries, time: 10.61ms
    [html_column_contents] => ___________________________________4 queries, time: 5.30ms
    [html_contents] => __________________________________________4 queries, time: 6.72ms
    [html_column_grid] => _______________________________________3 queries, time: 4.74ms
    [module_content] => _________________________________________3 queries, time: 4.52ms
    [s_craftmaster1] => _________________________________________2 queries, time: 13.28ms
    [xm_settings] => ____________________________________________2 queries, time: 2.53ms
    [basket_items] => ___________________________________________2 queries, time: 3.64ms
    [clients] => ________________________________________________2 queries, time: 2.72ms
    [redirections] => ___________________________________________2 queries, time: 2.89ms
    [layout_settings] => ________________________________________2 queries, time: 3.74ms
    [store_features] => _________________________________________1 queries, time: 2.02ms
    [site_email_settings] => ____________________________________1 queries, time: 1.47ms
    [countries] => ______________________________________________1 queries, time: 2.06ms
    [currencies] => _____________________________________________1 queries, time: 0.93ms
    [arcus_customers] => ________________________________________1 queries, time: 2.74ms
    [routes] => _________________________________________________1 queries, time: 2.50ms
    [users_groups_setting] => ___________________________________1 queries, time: 3.23ms
    [api_settings] => ___________________________________________1 queries, time: 1.48ms
    [module_custom_tag] => ______________________________________1 queries, time: 1.63ms
    [module_custom_css] => ______________________________________1 queries, time: 2.27ms
    [public_categories] => ______________________________________1 queries, time: 1.75ms
    [categories_display_mode] => ________________________________1 queries, time: 2.05ms
)

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

Platform API Calls - toggle (7) 

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

        )

    [1] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/xm-settings -> 200 [23.93ms]
            [2] => Array
                (
                    [X-B3-TraceId] => d4d65f459319ed093b6377190d9051d6
                    [X-B3-SpanId] => 5a0329873b1d366b
                )

        )

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

        )

    [3] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/module/all -> 200 [25.05ms]
            [2] => Array
                (
                    [X-B3-TraceId] => d4d65f459319ed093b6377190d9051d6
                    [X-B3-SpanId] => 9998b1b7e1cd3913
                )

        )

    [4] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/categories/content -> 200 [36.07ms]
            [2] => Array
                (
                    [X-B3-TraceId] => d4d65f459319ed093b6377190d9051d6
                    [X-B3-SpanId] => eb3606ed0f2abab4
                )

        )

    [5] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/labels -> 200 [22.61ms]
            [2] => Array
                (
                    [X-B3-TraceId] => d4d65f459319ed093b6377190d9051d6
                    [X-B3-SpanId] => 5bb775b276526b3b
                )

        )

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

)

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

Timing - toggle (1) 

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

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