DEV MODE
Size: XS
Size: SM
Size: MD
Size: LG
Size: XL
   VAT
Tax based on shipping to United Kingdom gb flag , Change?
Connectec Company Logo
Basket0 
NEW CLEARANCE

Spend £75.00 for free delivery*

PRODUCTS FROM SFX CABLES

Get great deals on a range of products from SFX Cables

Page 3 of 5 (109 results)

Screened 4 Core Belden Equivalent (8723) LSF Grey 200m
In stock
Screened 4 Core Belden Equivalent (8723) LSF Grey 200m
Product Code: SFX0139
£77.86
£64.88 Ex Vat
Cat 5e FTP Solid Armoured SWA (per metre)
1000+ In stock
Cat 5e FTP Solid Armoured SWA (per metre)
Product Code: SFX0187
£1.85
£1.54 Ex Vat
Direct Burial Low Loss TV Satellite Coax Cable 100M
In stock
Direct Burial Low Loss TV Satellite Coax Cable 100M
Product Code: SFX0186
£68.40
£57.00 Ex Vat
Cat 6A U/FTP Solid Copper Steel Wire Armoured SWA (per metre)
1000+ In stock
Cat 6A U/FTP Solid Copper Steel Wire Armoured SWA (per metre)
Product Code: SFX0185
£2.35
£1.96 Ex Vat
Screened 10 Core Belden Equivalent (9540) PE External Black 100m
In stock
Screened 10 Core Belden Equivalent (9540) PE External Black 100m
Product Code: SFX0184
£89.56
£74.63 Ex Vat
Category 5e PE External Duct Grade Shotgun with 0.5mm Power 100m
In stock
Category 5e PE External Duct Grade Shotgun with 0.5mm Power 100m
Product Code: SFX0179
£84.76
£70.63 Ex Vat
Cat 5 UTP LSZH B2ca Purple Solid Network Cable 305m
CPR COMPLIANT
In stock
Cat 5 UTP LSZH B2ca Purple Solid Network Cable 305m
Product Code: SFX0177
£141.90
£118.25 Ex Vat
Cat 6 UTP LSZH B2ca Purple Solid Network Cable 305m
CPR COMPLIANT
Back order
Cat 6 UTP LSZH B2ca Purple Solid Network Cable 305m
Product Code: SFX0176
£174.30
£145.25 Ex Vat
Value 2 Core Speaker Cable White PVC 100m
Select version
Value 2 Core Speaker Cable White PVC 100m
Product Code: Select version
From £12.16 Inc VAT
Cat 6 UTP PE External Solid Network Cable
Select version
Cat 6 UTP PE External Solid Network Cable
Product Code: Select version
From £47.70 Inc VAT
Cat 6 FTP LSZH Shielded Data Cable Purple 305m
In stock
Cat 6 FTP LSZH Shielded Data Cable Purple 305m
Product Code: SFX0162
£199.50
£166.25 Ex Vat
External Long Distance TV Satellite Coax Cable CT165 / WF165
Ordered on Request
External Long Distance TV Satellite Coax Cable CT165 / WF165
Product Code: SFX0158
£1.06
£0.88 Ex Vat
Cat 5e UTP PE External Solid Network Cable
Select version
Cat 5e UTP PE External Solid Network Cable
Product Code: Select version
From £20.70 Inc VAT
Cat 6 UTP PVC Grey Solid Network Cable
Select version
Cat 6 UTP PVC Grey Solid Network Cable
Product Code: Select version
From £25.50 Inc VAT
Cat 6 Direct Burial HDPE Cable
Select version
Cat 6 Direct Burial HDPE Cable
Product Code: Select version
From £30.00 Inc VAT
Cat 5e UTP Solid Armoured SWA (per metre)
500+ In stock
Cat 5e UTP Solid Armoured SWA (per metre)
Product Code: SFX0148
£1.60
£1.33 Ex Vat
Category 6A F/FTP PE Duct Grade 100m
In stock
Category 6A F/FTP PE Duct Grade 100m
Product Code: SFX0141
£72.00
£60.00 Ex Vat
Category 6A FTP Shielded Screened LSZH Network Cable Blue 100m
In stock
Category 6A FTP Shielded Screened LSZH Network Cable Blue 100m
Product Code: SFX0140
£69.00
£57.50 Ex Vat
Screened 4 Core Belden Equivalent (8723) Duct Grade PE Black 100m
In stock
Screened 4 Core Belden Equivalent (8723) Duct Grade PE Black 100m
Product Code: SFX0136
£48.46
£40.38 Ex Vat
Screened 4 Core Belden Equivalent (8723) LSZH Grey
In stock
Screened 4 Core Belden Equivalent (8723) LSZH Grey
Product Code: SFX0135
£43.66
£36.38 Ex Vat
Cat 6 FTP Shielded Solid Armoured SWA (per metre)
1000+ In stock
Cat 6 FTP Shielded Solid Armoured SWA (per metre)
Product Code: SFX0132
£2.35
£1.96 Ex Vat
Value RG6 Low Loss Screened Coax Cable
Select version
Value RG6 Low Loss Screened Coax Cable
Product Code: Select version
From £14.10 Inc VAT
Value RG6 Twin Low Loss Screened Coax Cable
Select version
Value RG6 Twin Low Loss Screened Coax Cable
Product Code: Select version
From £27.76 Inc VAT
Low Loss Screened FPE Coax Cable for Satellite or TV
Select version
Low Loss Screened FPE Coax Cable for Satellite or TV
Product Code: Select version
From £15.76 Inc VAT

Page 3 of 5 (109 results)

Compare 0
Google review badge 
PHPSESSID / fc9aec373fabb0d81d23ae08d5d1138c
0.096774
Array
(
    [fc9aec373fabb0d81d23ae08d5d1138c] => Array
        (
            [customer_group_id] => 1
            [pricing_groups] => 
            [currency] => GBP
            [currency_value] => 1.00000000
            [country_id] => 222
            [location_id] => 0
            [tracker] => 42b94f89683b7d4c488a49c18bbd9a0280e4ddf48ff3617361f92daa1a976c1c
        )

)

Array
(
    [ALL] => Array
        (
            [0] => 21:22:12; PREPARED; MEMCACHED; Url; __construct; SELECT * FROM ct_url_alias WHERE store_id = 1 OR store_id = 0
            [1] => 21:22:12; PREPARED; MEMCACHED; ControllerStartupStartup; index; SELECT * FROM ct_setting WHERE store_id = 0 OR store_id = 1 ORDER BY store_id ASC
            [2] => 21:22:12; PREPARED; MEMCACHED; Cart\Customer; __construct; SELECT * FROM ct_customer_group WHERE customer_group_id = 1
            [3] => 21:22:12; 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] => 21:22:12; STANDARD; MEMCACHED; ModelLocalisationCurrency; getCurrencies; SELECT * FROM ct_currency WHERE status = 1 ORDER BY title ASC
            [5] => 21:22:12; STANDARD; MEMCACHED; Cart\Currency; __construct; SELECT * FROM ct_currency
            [6] => 21:22:12; 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] => 21:22:12; STANDARD; 0.000281; Tracking; getNewTracker; SELECT tracking_id FROM ct_tracking WHERE tracker = '42b94f89683b7d4c488a49c18bbd9a0280e4ddf48ff3617361f92daa1a976c1c'
            [8] => 21:22:12; PREPARED; MEMCACHED; Url; getRedirect; SELECT * FROM ct_url_redirect WHERE source = 'sfx-cables' AND path = ''
            [9] => 21:22:12; STANDARD; MEMCACHED; ModelCatalogManufacturer; getManufacturer; SELECT * FROM ct_manufacturer m WHERE m.manufacturer_id = '78'
            [10] => 21:22:12; PREPARED; MEMCACHED; 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 = 78 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] => 21:22:12; STANDARD; 0.000623; 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 = 14984 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [12] => 21:22:12; STANDARD; 0.000250; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12189
            [13] => 21:22:12; STANDARD; 0.000827; 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 = 12189 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [14] => 21:22:12; STANDARD; 0.000389; 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 = 14860 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [15] => 21:22:12; STANDARD; 0.000267; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 14860
            [16] => 21:22:12; STANDARD; 0.000658; 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 = 14860 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [17] => 21:22:12; STANDARD; 0.000418; 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 = 14845 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [18] => 21:22:12; STANDARD; 0.000226; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 14845
            [19] => 21:22:12; STANDARD; 0.000654; 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 = 14845 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [20] => 21:22:12; STANDARD; 0.000372; 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 = 14782 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [21] => 21:22:12; STANDARD; 0.000240; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 14782
            [22] => 21:22:12; STANDARD; 0.000656; 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 = 14782 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [23] => 21:22:12; STANDARD; 0.000404; 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 = 14507 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [24] => 21:22:12; STANDARD; 0.000225; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 14507
            [25] => 21:22:12; STANDARD; 0.000669; 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 = 14507 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [26] => 21:22:12; STANDARD; 0.000394; 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 = 14302 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [27] => 21:22:12; STANDARD; 0.000268; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 14302
            [28] => 21:22:12; STANDARD; 0.000674; 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 = 14302 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [29] => 21:22:12; STANDARD; 0.000413; 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 = 14186 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [30] => 21:22:12; STANDARD; 0.000234; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 14186
            [31] => 21:22:12; STANDARD; 0.000693; 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 = 14186 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [32] => 21:22:12; STANDARD; 0.000393; 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 = 14185 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [33] => 21:22:12; STANDARD; 0.000244; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 14185
            [34] => 21:22:12; STANDARD; 0.000697; 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 = 14185 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [35] => 21:22:12; STANDARD; 0.000510; 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 = 14082 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [36] => 21:22:12; STANDARD; 0.000240; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 13223
            [37] => 21:22:12; STANDARD; 0.000683; 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 = 13223 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [38] => 21:22:12; STANDARD; 0.000484; 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 = 13259 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [39] => 21:22:12; STANDARD; 0.000248; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 10838
            [40] => 21:22:12; 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 = 10838 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [41] => 21:22:12; STANDARD; 0.000423; 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 = 13177 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [42] => 21:22:12; STANDARD; 0.000239; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 13177
            [43] => 21:22:12; STANDARD; 0.000725; 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 = 13177 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [44] => 21:22:12; STANDARD; 0.000413; 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 = 12939 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [45] => 21:22:12; STANDARD; 0.000252; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12939
            [46] => 21:22:12; STANDARD; 0.000729; 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 = 12939 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [47] => 21:22:12; STANDARD; 0.000535; 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 = 12867 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [48] => 21:22:12; STANDARD; 0.000242; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 15020
            [49] => 21:22:12; 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 = 15020 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [50] => 21:22:12; STANDARD; 0.000507; 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 = 12865 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [51] => 21:22:12; STANDARD; 0.000255; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12862
            [52] => 21:22:12; 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 = 12862 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [53] => 21:22:12; STANDARD; 0.000540; 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 = 12766 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [54] => 21:22:12; STANDARD; 0.000281; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12768
            [55] => 21:22:12; STANDARD; 0.000739; 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 = 12768 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [56] => 21:22:12; STANDARD; 0.000458; 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 = 12764 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [57] => 21:22:12; STANDARD; 0.000238; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12764
            [58] => 21:22:12; 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 = 12764 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [59] => 21:22:12; STANDARD; 0.000395; 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 = 12407 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [60] => 21:22:12; STANDARD; 0.000255; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12407
            [61] => 21:22:12; STANDARD; 0.000652; 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 = 12407 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [62] => 21:22:12; STANDARD; 0.000451; 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 = 12406 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [63] => 21:22:12; STANDARD; 0.000249; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12406
            [64] => 21:22:12; STANDARD; 0.000716; 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 = 12406 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [65] => 21:22:12; STANDARD; 0.000404; 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 = 12114 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [66] => 21:22:12; STANDARD; 0.000272; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12114
            [67] => 21:22:12; STANDARD; 0.000688; 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 = 12114 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [68] => 21:22:12; STANDARD; 0.000420; 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 = 12113 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [69] => 21:22:12; STANDARD; 0.000269; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12113
            [70] => 21:22:12; STANDARD; 0.000693; 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 = 12113 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [71] => 21:22:12; STANDARD; 0.000488; 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 = 11754 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [72] => 21:22:12; STANDARD; 0.000257; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 11754
            [73] => 21:22:12; 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 = 11754 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [74] => 21:22:12; STANDARD; 0.000536; 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 = 11610 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [75] => 21:22:12; STANDARD; 0.000298; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 11611
            [76] => 21:22:12; STANDARD; 0.000710; 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 = 11611 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [77] => 21:22:12; STANDARD; 0.000560; 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 = 11617 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [78] => 21:22:12; STANDARD; 0.000255; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 11620
            [79] => 21:22:12; STANDARD; 0.000688; 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 = 11620 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [80] => 21:22:12; STANDARD; 0.000502; 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 = 11622 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [81] => 21:22:12; STANDARD; 0.000247; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 11623
            [82] => 21:22:12; STANDARD; 0.000688; 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 = 11623 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [83] => 21:22:12; STANDARD; 0.000314; ModelAccountFavourites; getFavourites; SELECT * FROM ct_customer_favourites WHERE customer_id = 0
            [84] => 21:22:12; STANDARD; 0.000522; 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 = 14984 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [85] => 21:22:12; STANDARD; 0.000994; ModelCatalogProduct; getProduct; SELECT DISTINCT p.*, pav.available, pd.feature, pd.description, pd.specification, pd.tag, pd.meta_title, pd.meta_description, pd.product_note, 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, m.name AS manufacturer, m.image AS manufacturer_thumb, m.site AS manufacturer_site, m.support AS manufacturer_support, ss.name AS stock_status, ss.in_stock, ss.zero_checkout, COALESCE(AVG(r.rating), 0) AS rating, COUNT(DISTINCT r.review_id) AS reviews, p.sort_order , (SELECT GROUP_CONCAT(CONCAT(pv.variant_id, '|', pv.name)) FROM ct_product_variant pv WHERE pv.product_id = p.product_id GROUP BY pv.product_id ORDER BY pv.sort_order) AS variants FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id AND pav.store_id = 1 LEFT JOIN ct_review r ON (r.product_id = p.product_id AND r.status = '1') LEFT JOIN ct_stock_status ss ON (p.stock_status_id = ss.stock_status_id) LEFT JOIN ct_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN ct_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = 12189
            [86] => 21:22:12; STANDARD; 0.000273; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 12189
            [87] => 21:22:12; STANDARD; 0.000724; 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 = 12189 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [88] => 21:22:12; STANDARD; 0.000284; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12189 ORDER BY sort_order ASC
            [89] => 21:22:12; STANDARD; 0.000490; 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 = 14860 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [90] => 21:22:12; STANDARD; 0.000323; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 14860 ORDER BY sort_order ASC
            [91] => 21:22:12; STANDARD; 0.000659; 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 = 14845 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [92] => 21:22:12; STANDARD; 0.000289; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 14845 ORDER BY sort_order ASC
            [93] => 21:22:12; STANDARD; 0.000413; 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 = 14782 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [94] => 21:22:12; STANDARD; 0.000270; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 14782 ORDER BY sort_order ASC
            [95] => 21:22:12; STANDARD; 0.000422; 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 = 14507 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [96] => 21:22:12; STANDARD; 0.000268; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 14507 ORDER BY sort_order ASC
            [97] => 21:22:12; STANDARD; 0.000387; 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 = 14302 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [98] => 21:22:12; STANDARD; 0.001085; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 14302 ORDER BY sort_order ASC
            [99] => 21:22:12; STANDARD; 0.000473; 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 = 14186 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [100] => 21:22:12; STANDARD; 0.000374; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 14186 ORDER BY sort_order ASC
            [101] => 21:22:12; STANDARD; 0.000454; 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 = 14185 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [102] => 21:22:12; STANDARD; 0.000280; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 14185 ORDER BY sort_order ASC
            [103] => 21:22:12; STANDARD; 0.000380; 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 = 14082 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [104] => 21:22:12; STANDARD; 0.000264; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 14082 ORDER BY sort_order ASC
            [105] => 21:22:12; STANDARD; 0.000380; 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 = 13259 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [106] => 21:22:12; STANDARD; 0.000263; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 13259 ORDER BY sort_order ASC
            [107] => 21:22:12; STANDARD; 0.000402; 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 = 13177 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [108] => 21:22:12; STANDARD; 0.000270; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 13177 ORDER BY sort_order ASC
            [109] => 21:22:12; STANDARD; 0.000440; 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 = 12939 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [110] => 21:22:12; STANDARD; 0.000254; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12939 ORDER BY sort_order ASC
            [111] => 21:22:12; STANDARD; 0.000392; 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 = 12867 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [112] => 21:22:12; STANDARD; 0.000268; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12867 ORDER BY sort_order ASC
            [113] => 21:22:12; STANDARD; 0.000380; 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 = 12865 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [114] => 21:22:12; STANDARD; 0.000266; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12865 ORDER BY sort_order ASC
            [115] => 21:22:12; STANDARD; 0.000408; 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 = 12766 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [116] => 21:22:12; STANDARD; 0.000265; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12766 ORDER BY sort_order ASC
            [117] => 21:22:12; STANDARD; 0.000397; 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 = 12764 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [118] => 21:22:12; STANDARD; 0.000255; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12764 ORDER BY sort_order ASC
            [119] => 21:22:12; STANDARD; 0.000418; 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 = 12407 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [120] => 21:22:12; STANDARD; 0.000275; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12407 ORDER BY sort_order ASC
            [121] => 21:22:12; STANDARD; 0.000411; 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 = 12406 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [122] => 21:22:12; STANDARD; 0.000289; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12406 ORDER BY sort_order ASC
            [123] => 21:22:12; STANDARD; 0.000400; 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 = 12114 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [124] => 21:22:12; STANDARD; 0.000270; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12114 ORDER BY sort_order ASC
            [125] => 21:22:12; STANDARD; 0.000397; 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 = 12113 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [126] => 21:22:12; STANDARD; 0.000262; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 12113 ORDER BY sort_order ASC
            [127] => 21:22:12; STANDARD; 0.000421; 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 = 11754 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [128] => 21:22:12; STANDARD; 0.000265; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 11754 ORDER BY sort_order ASC
            [129] => 21:22:12; STANDARD; 0.000395; 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 = 11610 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [130] => 21:22:12; STANDARD; 0.000264; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 11610 ORDER BY sort_order ASC
            [131] => 21:22:12; STANDARD; 0.000400; 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 = 11617 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [132] => 21:22:12; STANDARD; 0.000299; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 11617 ORDER BY sort_order ASC
            [133] => 21:22:12; STANDARD; 0.000407; 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 = 11622 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [134] => 21:22:12; STANDARD; 0.000267; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 11622 ORDER BY sort_order ASC
            [135] => 21:22:12; 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
            [136] => 21:22:12; STANDARD; MEMCACHED; 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(19696,19083,18216,17989,17812,17714,17711,17708,17705,17669,17666,17656,17388,17377,17376,17321,16995,16875,16850,16500,16452,16450,16449,16225,16203,16202,16186,16184,16182,16181,16179,16178,16176,16175,16173,16171,16170,16169,15973,15971,15963,15258,15256,15255,15254,15248,15229,15096,14984,14860,14845,14782,14507,14302,14186,14185,14082,13259,13177,12939,12867,12865,12766,12764,12407,12406,12114,12113,11754,11610,11617,11622,11627,11632,9181,11290,11227,11228,11236,11258,11262,11203,11162,11167,11184,11187,11116,11123,11126,11138,11139,11140,11155,11062,11070,11071,11076,11089,11099,11107,10976,10990,11000,11010,11023,11035,11051,10680,10212) AND c.store_id = 1 ORDER BY cd.name ASC
        )

    [DUPLICATES] => Array
        (
        )

    [SLOW] => Array
        (
        )

    [TOTAL_EXECUTION_TIME] => 0.055068492889404
)