ADMIN

BASKET

CATEGORY

MENU

CUSTOMER

db

MERCHANT

PRODUCT

STATE

CATEGORIES

PRODUCTS

TEMPLATES

_COOKIE

_FILES

_GET

_POST

_SERVER

_SESSION

SESSION SETTINGS

QUERY INFO

1. SET NAMES utf8mb4
   Execution Time: 0.00037288665771484 seconds.
   
   
2. SELECT pref,value FROM pref WHERE merchant_id = 4 /*clean_urls*/
   Execution Time: 0.0019879341125488 seconds. Selected: 320 row(s)
   
   
3. SELECT product_id FROM product FORCE INDEX (clean_url_to_id) WHERE merchant_id = 4 AND clean_url = '9g82-1-2-cup-measuring-scoop-9g60-shelf-ingredient-bin'
   Execution Time: 0.00046515464782715 seconds. Selected: 1 row(s)
   
   
4. SELECT * FROM `orders`
   WHERE merchant_id = 4
   AND session_id = '2dc5596bf2075cb836a90153dce4b38a'
   AND (order_status = 'Basket' OR order_status = 'Quote')
   Execution Time: 0.00091195106506348 seconds. Selected: 0 row(s)
   
   
5. SELECT c.*
   FROM category c FORCE INDEX (PRIMARY)
   WHERE c.merchant_id = 4
   AND c.category_id = 0
   Execution Time: 0.00065302848815918 seconds. Selected: 1 row(s)
   
   
6. SELECT *
   FROM product p WHERE merchant_id = 4 AND product_id = 2921
   Execution Time: 0.0004889965057373 seconds. Selected: 1 row(s)
   
   
7. SELECT * FROM product_option
   WHERE merchant_id = 4
   AND product_id = 2921
   UNION
   SELECT * FROM product_option
   WHERE merchant_id = 4
   AND package_id IN (
   SELECT p2p.package_id
   FROM package_2_product p2p INNER JOIN package p USING(merchant_id,package_id)
   WHERE p2p.merchant_id = 4
   AND p2p.product_id = 2921
   AND FIND_IN_SET('live',p.param)>0
   )
   ORDER BY rank,product_option_name
   Execution Time: 0.0007929801940918 seconds. Selected: 0 row(s)
   
   
8. SELECT * FROM product_image
   WHERE merchant_id = 4
   AND product_id = 2921
   AND is_default = '1'
   Execution Time: 0.00077009201049805 seconds. Selected: 1 row(s)
   
   
9. SELECT c.*
   FROM category c FORCE INDEX (PRIMARY)
   WHERE c.merchant_id = 4
   AND c.category_id = 452
   Execution Time: 0.00050187110900879 seconds. Selected: 1 row(s)
   
   
10. SELECT
    p.product_id
    FROM product p
    LEFT OUTER JOIN product_image i
    ON p.merchant_id = i.merchant_id
    AND p.product_id = i.product_id
    AND i.is_default = 1
    INNER JOIN product_related pr
    ON p.merchant_id = pr.merchant_id
    AND p.product_id = pr.product_related_id
    WHERE p.merchant_id = 4
    AND pr.product_id = '2921'
    AND FIND_IN_SET('live',p.param) > 0
    ORDER BY pr.rank,p.rank,p.product_name
    Execution Time: 0.00069284439086914 seconds. Selected: 0 row(s)
    
    
11. SELECT
    p.*, i.*
    
    FROM product p
    LEFT OUTER JOIN product_image i
    ON p.merchant_id = i.merchant_id
    AND p.product_id = i.product_id
    AND i.is_default = 1
    INNER JOIN product_related pr
    ON p.merchant_id = pr.merchant_id
    AND p.product_id = pr.product_related_id
    WHERE p.merchant_id = 4
    AND pr.product_id = '2921'
    AND FIND_IN_SET('live',p.param) > 0
    ORDER BY pr.rank,p.rank,p.product_name
    Execution Time: 0.00099992752075195 seconds. Selected: 0 row(s)
    
    
12. SELECT * FROM product_image
    WHERE merchant_id = 4
    AND product_id = 2921
    ORDER BY is_default DESC, rank ASC
    Execution Time: 0.00044798851013184 seconds. Selected: 1 row(s)
    
    

• Total Time: 0.0090856552124023 seconds.

showMe() Objects

showMeSession() Objects

ERROR MESSAGES

All Warning Messages

/domains/rubbermaidcommercialproducts.com/www/mc_template/rsp/header.php (1 errors displayed)

Warning: count(): Parameter must be an array or an object that implements Countable in /domains/rubbermaidcommercialproducts.com/www/mc_template/rsp/header.php on line 20

/domains/rubbermaidcommercialproducts.com/www/mc_template/rsp/catalog/product_detail.php (1 errors displayed)

Warning: count(): Parameter must be an array or an object that implements Countable in /domains/rubbermaidcommercialproducts.com/www/mc_template/rsp/catalog/product_detail.php on line 202

All Notice Messages

/usr/local/php/mc6/catalog/catalog.php (5 errors displayed)

Notice: Undefined index: action in /usr/local/php/mc6/catalog/catalog.php on line 730

Notice: Undefined index: action in /usr/local/php/mc6/catalog/catalog.php on line 734

Notice: Trying to get property 'catalog' of non-object in /usr/local/php/mc6/catalog/catalog.php on line 798

Notice: Undefined index: retail-only in /usr/local/php/mc6/catalog/catalog.php on line 799

Notice: Undefined index: wholesale-only in /usr/local/php/mc6/catalog/catalog.php on line 805

/usr/local/php/mc6/catalog/product.class.php (12 errors displayed)

Notice: Undefined variable: aux in /usr/local/php/mc6/catalog/product.class.php on line 197 (trace)

Notice: Undefined index: event in /usr/local/php/mc6/catalog/product.class.php on line 211 (trace)

Notice: Undefined variable: option in /usr/local/php/mc6/catalog/product.class.php on line 505 (trace)

Notice: Undefined index: special in /usr/local/php/mc6/catalog/product.class.php on line 92 (trace)

Notice: Undefined index: feature in /usr/local/php/mc6/catalog/product.class.php on line 92 (trace)

Notice: Undefined index: special in /usr/local/php/mc6/catalog/product.class.php on line 92 (trace)

Notice: Undefined index: feature in /usr/local/php/mc6/catalog/product.class.php on line 92 (trace)

Notice: Undefined variable: ret in /usr/local/php/mc6/catalog/product.class.php on line 2106 (trace)

Notice: Undefined index: special in /usr/local/php/mc6/catalog/product.class.php on line 92 (trace)

Notice: Undefined index: feature in /usr/local/php/mc6/catalog/product.class.php on line 92 (trace)

Notice: Undefined index: hide_add_to_basket in /usr/local/php/mc6/catalog/product.class.php on line 92 (trace)

Notice: Undefined index: hide_qty in /usr/local/php/mc6/catalog/product.class.php on line 92 (trace)

/usr/local/php/mc6/template/rsp/google_analytics.php (1 errors displayed)

Notice: Undefined variable: send_transaction in /usr/local/php/mc6/template/rsp/google_analytics.php on line 29