GBP  

• EUR Euro
• GBP Pound Sterling
• PLN złoty

   EX VAT INC VAT

Tax based on shipping to United Kingdom , Change?

Company Logo

Basket0 

Search SUBMIT

MENU NEW CLEARANCE

Five star rating Google Reviews

Spend £75.00 for free delivery*

Best advice & support

Trade accounts

PRODUCTS FROM RBF

Get great deals on a range of products from RBF

---

Compact List View Full List View Grid View

Filters

Sort: Default Name (A - Z) Name (Z - A) Price (Low - High) Price (High - Low) Model (A - Z) Model (Z - A) Newest

Show: All 17

Add To Favourites Add To Compare

Select version

Galvanised Steel DIN Rail Top Hat 35mm Wide x 1m Length (Slotted or Plain)

Product Code: Select version

From £4.46 Inc VAT

Select Version Plain Top Hat - 35mm x 7.5mm x 1m Plain Top Hat - 35mm x 15mm x 1m Slotted Top Hat - 35mm x 7.5 x 1m

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

Tough Lockable ABS Outdoor Enclosure IK10 IP65 with Clear Door and Backplate

Product Code: Select version

From £50.16 Inc VAT

Select Version 300 x 200 x 130 mm 350 x 250 x 150 mm 400 x 300 x 170 mm 400 x 300 x 220 mm 500 x 350 x 190 mm 500 x 400 x 180 mm 500 x 400 x 240 mm 600 x 400 x 200 mm 700 x 500 x 250 mm

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

Tough Lockable ABS Outdoor Enclosure IK10 IP65 with Solid Door and Backplate

Product Code: Select version

From £42.05 Inc VAT

Select Version 300 x 200 x 130 mm 350 x 250 x 150 mm 400 x 300 x 170 mm 400 x 300 x 220 mm 500 x 350 x 190 mm 500 x 400 x 180 mm 500 x 400 x 240 mm 600 x 400 x 200 mm 700 x 500 x 250 mm

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

100+ In stock

M25 25mm to M20 20mm Gland Reducer Black

Product Code: RBF0158

£0.84
£0.70 Ex Vat

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

Inline Coupler for Underground Twin Wall Ducting 40-110mm

Product Code: Select version

From £5.35 Inc VAT

Select Version 40mm NR040C 50mm NR050C 63mm NR063C 75mm NR075C 110mm NR110C

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

3 Way Underground Burial Inspection Pit for Ducting

Product Code: Select version

From £62.76 Inc VAT

Select Version PCC20 PCC30 PCC40

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

SDS Plus Masonry Drill Bits 5-25 mm

Product Code: Select version

From £1.28 Inc VAT

Select Version SDS Plus 5 x 110mm SDS Plus 6 x 160mm SDS Plus 7 x 160mm SDS Plus 8 x 160mm SDS Plus 10 x 260mm SDS Plus 10 x 450mm SDS Plus 12 x 450mm SDS Plus 12 x 600mm SDS Plus 12 x 1000mm SDS Plus 14 x 450mm SDS Plus 16 x 450mm SDS Plus 16 x 600mm SDS Plus 16 x 1000mm SDS Plus 20 x 600mm SDS Plus 20 x 1000mm SDS Plus 25 x 450mm SDS Plus 25 x 600mm SDS Plus 25 x 1000mm

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

Crimp-on Cable End Bootlace Ferrules (100 Pack)

Product Code: Select version

From £0.92 Inc VAT

Select Version 0.25mm Violet 0.5mm White 0.75mm Blue 1.0mm Red 1.5mm Black 2.5mm Grey 4.0mm Orange 6.0mm Green 10.0mm Brown 16.0mm Ivory 25.0mm Black 35.0mm Red

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

HSS Jobber Twist Drill Bits for Metal and Plastic

Product Code: Select version

From £0.13 Inc VAT

Select Version HSS Drill Bit 2mm HSS Drill Bit 2.5mm HSS Drill Bit 3mm HSS Drill Bit 3.5mm HSS Drill Bit 4mm HSS Drill Bit 4.5mm HSS Drill Bit 5mm HSS Drill Bit 5.5mm HSS Drill Bit 6mm HSS Drill Bit 7mm HSS Drill Bit 8mm HSS Drill Bit 9mm HSS Drill Bit 10mm

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

Knock on Girder Clips for Chain or Cable Ties 10pc

Product Code: Select version

From £5.47 Inc VAT

Select Version 1.5 - 4 mm 4 - 10 mm 10 - 15 mm 15 - 20 mm

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

Tough Cable Cleats for 10 to 25mm Cable or Conduit (100 Pack)

Product Code: Select version

From £4.14 Inc VAT

Select Version 10.1 - 12.7 mm 12.6 - 15.2 mm 15.1 - 17.8 mm 17.7 - 20.3 mm 20.2 - 22.8 mm 22.7 - 25.4 mm

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

PVC Flexible Corrugated Conduit Contractor Packs 20 or 25mm

Product Code: Select version

From £9.12 Inc VAT

Select Version 20mm x 10m Black 20mm x 10m White 25mm x 10m Black 25mm x 10m White

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

Rubber open and closed/blind grommets

Product Code: Select version

From £1.73 Inc VAT

Select Version 16 mm Open (100pc) 16 mm Closed (100pc) 20 mm Open (100pc) 20 mm Closed (100pc) 25 mm Open (50pc) 25 mm Closed (50pc) 32 mm Open (25pc) 32 mm Closed (25pc)

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

Underground Twin Wall Corrugated Data or Electrical Ducting

Product Code: Select version

From £3.56 Inc VAT

Select Version 40mm x 1m (Per meter) - Black 40mm x 50m - Black 50mm x 1m (Per meter) - Black 50mm x 50m - Black 63mm x 50m - Black 75mm x 50m - Black 110mm x 50m - Black

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

Light Duty LSHF Flexible Corrugated Plastic Conduit (Black)

Product Code: Select version

From £37.28 Inc VAT

Select Version 10/7mm Black 50m 12/9mm Black 50m 16/11 mm Black 100m 20/14 mm Black 100m 25/18 mm Black 50m 32/24 mm Black 50m

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

Fire Resistant P-Clips for Supporting Cable (50 Pack)

Product Code: Select version

From £9.42 Inc VAT

Select Version 8mm Red 9mm Red

Quantity Minus Quantity Quantity Plus   Add to Basket

Add To Favourites Add To Compare

Select version

Fire Resistant Saddles for Supporting Cable (50 Pack)

Product Code: Select version

From £9.42 Inc VAT

Select Version 8mm Red 9mm Red

Quantity Minus Quantity Quantity Plus   Add to Basket

PHPSESSID / 43922c39b79fe7bcaf4c291213afd598

0.104535

Array
(
    [43922c39b79fe7bcaf4c291213afd598] => Array
        (
            [customer_group_id] => 1
            [pricing_groups] => 
            [currency] => GBP
            [currency_value] => 1.00000000
            [country_id] => 222
            [location_id] => 0
            [tracker] => 5608db2f75bdd66cc79bbbdb68a4b10d13e0d4e7fc41c8a114c4e3f2696e7a91
        )

)

Array
(
    [ALL] => Array
        (
            [0] => 19:28:18; PREPARED; MEMCACHED; Url; __construct; SELECT * FROM ct_url_alias WHERE store_id = 1 OR store_id = 0
            [1] => 19:28:18; PREPARED; MEMCACHED; ControllerStartupStartup; index; SELECT * FROM ct_setting WHERE store_id = 0 OR store_id = 1 ORDER BY store_id ASC
            [2] => 19:28:18; PREPARED; MEMCACHED; Cart\Customer; __construct; SELECT * FROM ct_customer_group WHERE customer_group_id = 1
            [3] => 19:28:18; PREPARED; MEMCACHED; ModelCatalogCustomerCatalog; getCustomerCatalog; SELECT cc.* FROM ct_customer_catalog_customer ccc LEFT JOIN ct_customer_catalog cc ON cc.customer_catalog_id = ccc.customer_catalog_id WHERE (ccc.customer_id = 0 AND ccc.customer_id != 0) OR ccc.customer_group_id = 1
            [4] => 19:28:18; STANDARD; MEMCACHED; ModelLocalisationCurrency; getCurrencies; SELECT * FROM ct_currency WHERE status = 1 ORDER BY title ASC
            [5] => 19:28:18; STANDARD; MEMCACHED; Cart\Currency; __construct; SELECT * FROM ct_currency
            [6] => 19:28:18; STANDARD; 0.000816; Cart\Tax; setAddress; SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr2.tax_rate_register FROM ct_tax_rule tr1 LEFT JOIN ct_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) LEFT JOIN ct_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN ct_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE z2gz.country_id = 222 AND z2gz.zone_id = 11 AND tr2.tax_rate_register = 0
            [7] => 19:28:18; STANDARD; 0.000357; Tracking; getNewTracker; SELECT tracking_id FROM ct_tracking WHERE tracker = '5608db2f75bdd66cc79bbbdb68a4b10d13e0d4e7fc41c8a114c4e3f2696e7a91'
            [8] => 19:28:18; PREPARED; MEMCACHED; Url; getRedirect; SELECT * FROM ct_url_redirect WHERE source = 'rbf' AND path = ''
            [9] => 19:28:18; STANDARD; 0.000272; ModelCatalogManufacturer; getManufacturer; SELECT * FROM ct_manufacturer m WHERE m.manufacturer_id = '95'
            [10] => 19:28:18; STANDARD; 0.010126; ModelCatalogProduct; getProducts; SELECT p.product_id, p.sku, p.parent_id, p.date_available, pav.available, p.status, p.stock_status_text, p.mpn, p.model, p.shipping, p.collection, p.points, p.ean, p.upc, p.jan, p.isbn, pd.product_note, p.name, pd.meta_description, p.sash_text, p.sash_class, IF(p.image = '' AND p.parent_id, par.image, p.image) AS image, IF(p.image = '' AND p.parent_id, par.image_overlay_text, p.image_overlay_text) AS image_overlay_text, IF(p.image = '' AND p.parent_id, par.image_overlay_colour, p.image_overlay_colour) AS image_overlay_colour, IF(p.parent_id != 0, pard.feature, pd.feature) AS feature, p.tax_class_id, p.date_added, p.eol, IF(p.eol OR p.increment < 1, 1, p.increment) AS increment, IF(p.eol OR p.minimum < 1, 1, p.minimum) AS minimum, IF(p.eol, IF(p.maximum > 0, LEAST(pav.available, p.maximum), pav.available), IF(p.maximum > 0, p.maximum, 9999)) AS maximum, p.manufacturer_id, m.name AS manufacturer, m.image AS manufacturer_thumb, ss.name AS stock_status, ss.in_stock, ss.zero_checkout, vs.name AS variant_stock_status, vs.in_stock AS variant_in_stock, vs.zero_checkout AS variant_zero_checkout, COALESCE(AVG(r.rating), 0) AS rating, COUNT(DISTINCT r.review_id) AS reviews, SUM(IF(pav2.available > 0, 1, 0)) AS variants_in_stock FROM ct_product_to_category p2c LEFT JOIN ct_product p ON p2c.product_id = p.product_id LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id AND pav.store_id = 1 LEFT JOIN ct_product par ON p.parent_id = par.product_id LEFT JOIN ct_product_description pard ON par.product_id = pard.product_id LEFT JOIN ct_stock_status ss ON p.stock_status_id = ss.stock_status_id LEFT JOIN ct_review r ON r.product_id = p.product_id AND r.status = 1 LEFT JOIN ct_manufacturer m ON p.manufacturer_id = m.manufacturer_id LEFT JOIN ct_product_description pd ON p.product_id = pd.product_id LEFT JOIN ct_product v ON v.parent_id = p.product_id AND v.status > 1 AND (v.eol = 0 OR v.available > 0) LEFT JOIN ct_product_available pav2 ON pav2.product_id = v.product_id AND pav2.store_id = 1 LEFT JOIN ct_stock_status vs ON v.stock_status_id = vs.stock_status_id WHERE 1 AND (p.eol = 0 OR pav.available > 0) AND p2c.store_id = 1 AND p.status > 1 AND (v.product_id IS NOT NULL OR p.is_parent = 0) AND p.manufacturer_id = 95 AND p.parent_id = 0 GROUP BY p.product_id, v.parent_id ORDER BY p.sort_order = 0, p.sort_order ASC, p.date_added DESC
            [11] => 19:28:18; STANDARD; 0.000657; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 18174 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [12] => 19:28:18; STANDARD; 0.000304; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18171
            [13] => 19:28:18; STANDARD; 0.000844; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 18171 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [14] => 19:28:18; STANDARD; 0.000618; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 17300 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [15] => 19:28:18; STANDARD; 0.000304; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17284
            [16] => 19:28:18; STANDARD; 0.000721; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 17284 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [17] => 19:28:18; STANDARD; 0.000610; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 17299 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [18] => 19:28:18; STANDARD; 0.000278; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17283
            [19] => 19:28:18; STANDARD; 0.000721; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 17283 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [20] => 19:28:18; STANDARD; 0.000468; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 16459 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [21] => 19:28:18; STANDARD; 0.000274; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 16459
            [22] => 19:28:18; STANDARD; 0.000740; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 16459 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [23] => 19:28:18; STANDARD; 0.000580; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 16073 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [24] => 19:28:18; STANDARD; 0.000277; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 16068
            [25] => 19:28:18; STANDARD; 0.000754; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 16068 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [26] => 19:28:18; STANDARD; 0.000531; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 15315 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [27] => 19:28:18; STANDARD; 0.000290; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 15312
            [28] => 19:28:18; STANDARD; 0.000728; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 15312 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [29] => 19:28:18; STANDARD; 0.000766; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 14167 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [30] => 19:28:18; STANDARD; 0.000293; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12875
            [31] => 19:28:18; STANDARD; 0.000722; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 12875 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [32] => 19:28:18; STANDARD; 0.000646; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 12566 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [33] => 19:28:18; STANDARD; 0.000291; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12539
            [34] => 19:28:18; STANDARD; 0.000751; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 12539 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [35] => 19:28:18; STANDARD; 0.000655; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 12564 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [36] => 19:28:18; STANDARD; 0.000276; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12551
            [37] => 19:28:18; STANDARD; 0.000733; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 12551 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [38] => 19:28:18; STANDARD; 0.000573; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 12062 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [39] => 19:28:18; STANDARD; 0.000285; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12033
            [40] => 19:28:18; STANDARD; 0.000748; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 12033 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [41] => 19:28:18; STANDARD; 0.000582; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 11847 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [42] => 19:28:18; STANDARD; 0.000275; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 11848
            [43] => 19:28:18; STANDARD; 0.000734; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 11848 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [44] => 19:28:18; STANDARD; 0.000543; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 11840 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [45] => 19:28:18; STANDARD; 0.000303; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 11841
            [46] => 19:28:18; STANDARD; 0.000723; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 11841 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [47] => 19:28:18; STANDARD; 0.000612; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 11810 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [48] => 19:28:18; STANDARD; 0.000293; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 11420
            [49] => 19:28:18; STANDARD; 0.000720; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 11420 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [50] => 19:28:18; STANDARD; 0.000593; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 11772 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [51] => 19:28:18; STANDARD; 0.000287; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18055
            [52] => 19:28:18; STANDARD; 0.000733; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 18055 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [53] => 19:28:18; STANDARD; 0.000594; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 11501 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [54] => 19:28:18; STANDARD; 0.000279; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 13220
            [55] => 19:28:18; STANDARD; 0.000743; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 13220 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [56] => 19:28:18; STANDARD; 0.000532; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 11216 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [57] => 19:28:18; STANDARD; 0.000294; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 11217
            [58] => 19:28:18; STANDARD; 0.000742; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 11217 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [59] => 19:28:18; STANDARD; 0.000505; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 11219 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [60] => 19:28:18; STANDARD; 0.000291; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 11221
            [61] => 19:28:18; STANDARD; 0.000709; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 11221 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [62] => 19:28:18; STANDARD; 0.000315; ModelAccountFavourites; getFavourites; SELECT * FROM ct_customer_favourites WHERE customer_id = 0
            [63] => 19:28:18; STANDARD; 0.000520; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 18174 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [64] => 19:28:18; STANDARD; 0.000305; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18174 ORDER BY sort_order ASC
            [65] => 19:28:18; STANDARD; 0.000476; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 17300 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [66] => 19:28:18; STANDARD; 0.000295; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17300 ORDER BY sort_order ASC
            [67] => 19:28:18; STANDARD; 0.000449; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 17299 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [68] => 19:28:18; STANDARD; 0.000303; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17299 ORDER BY sort_order ASC
            [69] => 19:28:18; STANDARD; 0.000457; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 16459 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [70] => 19:28:18; STANDARD; 0.000304; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 16459 ORDER BY sort_order ASC
            [71] => 19:28:18; STANDARD; 0.000447; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 16073 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [72] => 19:28:18; STANDARD; 0.000304; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 16073 ORDER BY sort_order ASC
            [73] => 19:28:18; STANDARD; 0.000447; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 15315 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [74] => 19:28:18; STANDARD; 0.000339; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 15315 ORDER BY sort_order ASC
            [75] => 19:28:18; STANDARD; 0.000446; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 14167 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [76] => 19:28:18; STANDARD; 0.000309; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 14167 ORDER BY sort_order ASC
            [77] => 19:28:18; STANDARD; 0.000445; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 12566 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [78] => 19:28:18; STANDARD; 0.000309; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12566 ORDER BY sort_order ASC
            [79] => 19:28:18; STANDARD; 0.000442; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 12564 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [80] => 19:28:18; STANDARD; 0.000310; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12564 ORDER BY sort_order ASC
            [81] => 19:28:18; STANDARD; 0.000465; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 12062 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [82] => 19:28:18; STANDARD; 0.000313; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12062 ORDER BY sort_order ASC
            [83] => 19:28:18; STANDARD; 0.000439; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 11847 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [84] => 19:28:18; STANDARD; 0.000295; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 11847 ORDER BY sort_order ASC
            [85] => 19:28:18; STANDARD; 0.000468; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 11840 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [86] => 19:28:18; STANDARD; 0.000296; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 11840 ORDER BY sort_order ASC
            [87] => 19:28:18; STANDARD; 0.000449; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 11810 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [88] => 19:28:18; STANDARD; 0.000305; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 11810 ORDER BY sort_order ASC
            [89] => 19:28:18; STANDARD; 0.000453; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 11772 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [90] => 19:28:18; STANDARD; 0.000294; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 11772 ORDER BY sort_order ASC
            [91] => 19:28:18; STANDARD; 0.000447; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 11501 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [92] => 19:28:18; STANDARD; 0.000298; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 11501 ORDER BY sort_order ASC
            [93] => 19:28:18; STANDARD; 0.000484; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 11216 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [94] => 19:28:18; STANDARD; 0.000305; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 11216 ORDER BY sort_order ASC
            [95] => 19:28:18; STANDARD; 0.000468; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 11219 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [96] => 19:28:18; STANDARD; 0.000315; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 11219 ORDER BY sort_order ASC
            [97] => 19:28:18; STANDARD; MEMCACHED; ModelCatalogInformation; getInformation; SELECT DISTINCT * FROM ct_information i LEFT JOIN ct_information_description id ON (i.information_id = id.information_id) WHERE i.information_id = 12 AND i.status = 1
            [98] => 19:28:18; STANDARD; 0.000996; ModelCatalogCategory; getProductParentCategories; SELECT c.parent_id AS category_id, cd.name FROM ct_product_to_category p2c LEFT JOIN ct_category c ON c.category_id = p2c.category_id LEFT JOIN ct_category_description cd ON c.parent_id = cd.category_id WHERE p2c.product_id IN(18174,17300,17299,16459,16073,15315,14167,12566,12564,12062,11847,11840,11810,11772,11501,11216,11219) AND c.store_id = 1 ORDER BY cd.name ASC
        )

    [DUPLICATES] => Array
        (
        )

    [SLOW] => Array
        (
        )

    [TOTAL_EXECUTION_TIME] => 0.053406953811646
)