DEV MODE
   VAT
Tax based on shipping to United Kingdom gb flag , Change?
Connectec Company Logo
Basket 
NEW CLEARANCE

Spend £75.00 for free delivery*

PRODUCTS FROM CONNECTEC VALUE

Get great deals on a range of products from Connectec value

Page 8 of 15 (348 results)

4K 8MP HD 2-Wire Pigtail Video Balun with Push Terminals
1000+ In stock
4K 8MP HD 2-Wire Pigtail Video Balun with Push Terminals
Product Code: CNV0777
£4.25
£3.54 Ex Vat
4K 8MP HD 2-Wire Rigid Fixed Video Balun with Push Terminals
100+ In stock
4K 8MP HD 2-Wire Rigid Fixed Video Balun with Push Terminals
Product Code: CNV0776
£4.56
£3.80 Ex Vat
4K 8MP HD RJ45 Power and Video Balun RJ45 to BNC+DC
1000+ In stock
4K 8MP HD RJ45 Power and Video Balun RJ45 to BNC+DC
Product Code: CNV0774
£6.76
£5.63 Ex Vat
BNC CCTV Video Ground Loop Isolator
50+ In stock
BNC CCTV Video Ground Loop Isolator
Product Code: CNV0773
£5.04
£4.20 Ex Vat
Passive USB Over Cat 5e/6 RJ45 Extender 45m
100+ In stock
Passive USB Over Cat 5e/6 RJ45 Extender 45m
Product Code: CNV0772
£6.30
£5.25 Ex Vat
Passive HDMI to VGA Converter
10+ In stock
Passive HDMI to VGA Converter
Product Code: CNV0771
£5.44
£4.53 Ex Vat
BNC Coupler Male (Pack of 10)
100+ In stock
BNC Coupler Male (Pack of 10)
Product Code: CNV0770
£4.21
£3.51 Ex Vat
BNC Coupler Female (Pack of 10)
100+ In stock
BNC Coupler Female (Pack of 10)
Product Code: CNV0769
£2.45
£2.04 Ex Vat
BNC Male Plug Connector with Screw Terminals
100+ In stock
BNC Male Plug Connector with Screw Terminals
Product Code: CNV0764
£0.54
£0.45 Ex Vat
Passive Low Voltage RJ45 POE Injector Set DC 2.1mm
100+ In stock
Passive Low Voltage RJ45 POE Injector Set DC 2.1mm
Product Code: CNV0751
£3.24
£2.70 Ex Vat
Precision Digital Caliper with LCD Display 150mm
In stock
Precision Digital Caliper with LCD Display 150mm
Product Code: CNV0748
£9.32
£7.77 Ex Vat
20W Mains Powered LED Worklight IP65 220-240V
In stock
20W Mains Powered LED Worklight IP65 220-240V
Product Code: CNV0747
£20.62
£17.18 Ex Vat
20cm Flat TV Aerial or Satellite Window Coax Cable
10+ In stock
20cm Flat TV Aerial or Satellite Window Coax Cable
Product Code: CNV0736
£1.01
£0.84 Ex Vat
2.1mm Barrel Plug to 4 Pin DIN Plug Convertor
10+ In stock
2.1mm Barrel Plug to 4 Pin DIN Plug Convertor
Product Code: CNV0732
£4.20
£3.50 Ex Vat
Premium Quality Cage Nut Insertion Tool M5 M6
In stock
Premium Quality Cage Nut Insertion Tool M5 M6
Product Code: CNV0720
£7.13
£5.94 Ex Vat
Panel Mount 75 Ohm BNC Coupler
In stock
Panel Mount 75 Ohm BNC Coupler
Product Code: CNV0715
£5.45
£4.54 Ex Vat
Panel Mount F Type Connector Coupler with Nut
50+ In stock
Panel Mount F Type Connector Coupler with Nut
Product Code: CNV0714
£0.83
£0.69 Ex Vat
48V DC 1.36A 65W 2.1 x 5.5mm Inline Power Supply
In stock
48V DC 1.36A 65W 2.1 x 5.5mm Inline Power Supply
Product Code: CNV0711
£31.48
£26.23 Ex Vat
Optical Fiber Toslink M-M Digital Audio Cable
Select version
Optical Fiber Toslink M-M Digital Audio Cable
Product Code: Select version
From £3.53 Inc VAT
Electrical Contact Cleaner Spray 400ML
10+ In stock
Electrical Contact Cleaner Spray 400ML
Product Code: CNV0697
£6.62
£5.52 Ex Vat
Cat 6A S/FTP Shielded Patch Cable
Select version
Cat 6A S/FTP Shielded Patch Cable
Product Code: Select version
From £1.44 Inc VAT
Cat 6 or 6A FTP Shielded RJ45 25 x 50mm Euro Module White
100+ In stock
Cat 6 or 6A FTP Shielded RJ45 25 x 50mm Euro Module White
Product Code: CNV0687
£3.18
£2.65 Ex Vat
Low Profile Flat TV Wall Bracket for Screens up to 55
CLEARANCE
Only 5 left
Low Profile Flat TV Wall Bracket for Screens up to 55" 40kg
Product Code: CNV0684
£8.40
£7.00 Ex Vat
WAS £20.81
Save £12.41
Stanley Style Craft Utility Knife Blades (10pc)
10+ In stock
Stanley Style Craft Utility Knife Blades (10pc)
Product Code: CNV0683
£1.01
£0.84 Ex Vat

Page 8 of 15 (348 results)

Compare 0
Google review badge 
__Secure-PHPSESSID / c542113c1d4c1b7cac478790b8bc498d
0.213947
Array
(
    [c542113c1d4c1b7cac478790b8bc498d] => Array
        (
            [customer_group_id] => 1
            [pricing_groups] => 
            [currency] => GBP
            [currency_value] => 1.00000000
            [country_id] => 222
            [location_id] => 0
            [tracker] => 746563a877f9002b653f7f9d48a71c26a691828d79033cc4e33e8131b4495f47
        )

)

Array
(
    [ALL] => Array
        (
            [0] => 15:23:03; PREPARED; MEMCACHE; __construct; SELECT * FROM ct_url_alias WHERE store_id = ? OR store_id = 0; 1
            [1] => 15:23:03; PREPARED; MEMCACHE; index; SELECT * FROM ct_setting WHERE store_id = 0 OR store_id = ? ORDER BY store_id ASC; 1
            [2] => 15:23:03; PREPARED; MEMCACHE; __construct; SELECT * FROM ct_customer_group WHERE customer_group_id = ?; 1
            [3] => 15:23:03; PREPARED; MEMCACHE; 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 = ? AND ccc.customer_id != 0) OR ccc.customer_group_id = ?; 0|1
            [4] => 15:23:03; STANDARD; MEMCACHE; ModelLocalisationCurrency; getCurrencies; SELECT * FROM ct_currency WHERE status = 1 ORDER BY title ASC
            [5] => 15:23:03; STANDARD; MEMCACHE; Cart\Currency; __construct; SELECT * FROM ct_currency
            [6] => 15:23:03; PREPARED; 0.001140; 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 = ? AND z2gz.zone_id = ? AND tr2.tax_rate_register = ?; 222|11|0
            [7] => 15:23:03; PREPARED; 0.000408; Tracking; getNewTracker; SELECT tracking_id FROM ct_tracking WHERE tracker = ?; 746563a877f9002b653f7f9d48a71c26a691828d79033cc4e33e8131b4495f47
            [8] => 15:23:03; PREPARED; 0.000420; Url; getRedirect; SELECT * FROM ct_url_redirect WHERE source = ? AND path = ?; connectec-value|
            [9] => 15:23:03; STANDARD; 0.000288; ModelCatalogManufacturer; getManufacturer; SELECT * FROM ct_manufacturer m WHERE m.manufacturer_id = '30'
            [10] => 15:23:03; PREPARED; 0.056631; ModelCatalogProduct; getProducts; SELECT p.product_id, p.sku, p.parent_id, p.date_available, pav.available, 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 = ? 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 = ? LEFT JOIN ct_stock_status vs ON v.stock_status_id = vs.stock_status_id WHERE p.status > 1 AND (p.eol = 0 OR pav.available > 0) AND (v.product_id IS NOT NULL OR p.is_parent = 0) AND p2c.store_id = ? AND p.manufacturer_id = ? 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; 1|1|1|30
            [11] => 15:23:03; PREPARED; 0.003246; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14349
            [12] => 15:23:03; PREPARED; 0.000765; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14349
            [13] => 15:23:03; PREPARED; 0.001482; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14349
            [14] => 15:23:03; PREPARED; 0.000775; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14348
            [15] => 15:23:03; PREPARED; 0.000434; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14348
            [16] => 15:23:03; PREPARED; 0.001278; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14348
            [17] => 15:23:03; PREPARED; 0.000711; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14346
            [18] => 15:23:03; PREPARED; 0.000377; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14346
            [19] => 15:23:03; PREPARED; 0.001217; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14346
            [20] => 15:23:03; PREPARED; 0.000661; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14345
            [21] => 15:23:03; PREPARED; 0.000358; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14345
            [22] => 15:23:03; PREPARED; 0.001229; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14345
            [23] => 15:23:03; PREPARED; 0.000576; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14344
            [24] => 15:23:03; PREPARED; 0.000481; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14344
            [25] => 15:23:03; PREPARED; 0.001203; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14344
            [26] => 15:23:03; PREPARED; 0.000698; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14343
            [27] => 15:23:03; PREPARED; 0.000343; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14343
            [28] => 15:23:03; PREPARED; 0.001135; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14343
            [29] => 15:23:03; PREPARED; 0.000619; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14342
            [30] => 15:23:03; PREPARED; 0.000320; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14342
            [31] => 15:23:03; PREPARED; 0.001168; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14342
            [32] => 15:23:03; PREPARED; 0.000729; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14341
            [33] => 15:23:03; PREPARED; 0.000492; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14341
            [34] => 15:23:03; PREPARED; 0.001074; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14341
            [35] => 15:23:03; PREPARED; 0.001040; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14336
            [36] => 15:23:03; PREPARED; 0.000545; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14336
            [37] => 15:23:03; PREPARED; 0.001029; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14336
            [38] => 15:23:03; PREPARED; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14323
            [39] => 15:23:03; PREPARED; 0.000338; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14323
            [40] => 15:23:03; PREPARED; 0.000846; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14323
            [41] => 15:23:03; PREPARED; 0.000649; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14294
            [42] => 15:23:03; PREPARED; 0.001194; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14294
            [43] => 15:23:03; PREPARED; 0.000852; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14294
            [44] => 15:23:03; PREPARED; 0.001017; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14291
            [45] => 15:23:03; PREPARED; 0.000624; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14291
            [46] => 15:23:03; PREPARED; 0.001179; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14291
            [47] => 15:23:03; PREPARED; 0.000529; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14168
            [48] => 15:23:03; PREPARED; 0.000911; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14168
            [49] => 15:23:03; PREPARED; 0.001011; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14168
            [50] => 15:23:03; PREPARED; 0.000798; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14121
            [51] => 15:23:03; PREPARED; 0.000614; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14121
            [52] => 15:23:03; PREPARED; 0.001152; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14121
            [53] => 15:23:03; PREPARED; 0.000652; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|14062
            [54] => 15:23:03; PREPARED; 0.000785; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 14062
            [55] => 15:23:03; PREPARED; 0.000718; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|14062
            [56] => 15:23:03; PREPARED; 0.000469; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|13868
            [57] => 15:23:03; PREPARED; 0.000218; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 13868
            [58] => 15:23:03; PREPARED; 0.000659; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|13868
            [59] => 15:23:03; PREPARED; 0.000369; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|13866
            [60] => 15:23:03; PREPARED; 0.000238; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 13866
            [61] => 15:23:03; PREPARED; 0.000861; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|13866
            [62] => 15:23:03; PREPARED; 0.000382; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|13859
            [63] => 15:23:03; PREPARED; 0.000232; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 13859
            [64] => 15:23:03; PREPARED; 0.000662; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|13859
            [65] => 15:23:03; PREPARED; 0.000677; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|13851
            [66] => 15:23:03; PREPARED; 0.000300; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 13846
            [67] => 15:23:03; PREPARED; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|13846
            [68] => 15:23:03; PREPARED; 0.000378; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|13785
            [69] => 15:23:03; PREPARED; 0.000244; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 13785
            [70] => 15:23:03; PREPARED; 0.000696; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|13785
            [71] => 15:23:03; PREPARED; 0.000584; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|13783
            [72] => 15:23:03; PREPARED; 0.000220; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 13742
            [73] => 15:23:03; PREPARED; 0.000695; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|13742
            [74] => 15:23:03; PREPARED; 0.000464; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|13713
            [75] => 15:23:03; PREPARED; 0.000240; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 13713
            [76] => 15:23:03; PREPARED; 0.000641; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|13713
            [77] => 15:23:03; PREPARED; 0.000390; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|13627
            [78] => 15:23:03; PREPARED; 0.000225; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 13627
            [79] => 15:23:03; PREPARED; 0.000681; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|13627
            [80] => 15:23:03; PREPARED; 0.000381; 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 = ? WHERE pv.product_id = ? AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC; 1|13624
            [81] => 15:23:03; PREPARED; 0.000222; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 13624
            [82] => 15:23:03; PREPARED; 0.000672; 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 = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? 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 <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|13624
            [83] => 15:23:03; PREPARED; 0.000454; ModelAccountFavourites; getFavourites; SELECT * FROM ct_customer_favourites WHERE customer_id = ?; 0
            [84] => 15:23:03; PREPARED; 0.000545; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14349|1
            [85] => 15:23:03; PREPARED; 0.000349; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14349
            [86] => 15:23:03; PREPARED; 0.000451; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14348|1
            [87] => 15:23:03; PREPARED; 0.000283; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14348
            [88] => 15:23:03; PREPARED; 0.000444; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14346|1
            [89] => 15:23:03; PREPARED; 0.000296; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14346
            [90] => 15:23:03; PREPARED; 0.000438; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14345|1
            [91] => 15:23:03; PREPARED; 0.000402; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14345
            [92] => 15:23:03; PREPARED; 0.000670; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14344|1
            [93] => 15:23:03; PREPARED; 0.000296; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14344
            [94] => 15:23:03; PREPARED; 0.000461; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14343|1
            [95] => 15:23:03; PREPARED; 0.000313; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14343
            [96] => 15:23:03; PREPARED; 0.000467; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14342|1
            [97] => 15:23:03; PREPARED; 0.000300; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14342
            [98] => 15:23:03; PREPARED; 0.000483; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14341|1
            [99] => 15:23:03; PREPARED; 0.000390; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14341
            [100] => 15:23:03; PREPARED; 0.000492; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14336|1
            [101] => 15:23:03; PREPARED; 0.000360; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14336
            [102] => 15:23:03; PREPARED; 0.000593; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14323|1
            [103] => 15:23:03; PREPARED; 0.000431; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14323
            [104] => 15:23:03; PREPARED; 0.000582; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14294|1
            [105] => 15:23:03; PREPARED; 0.019493; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14294
            [106] => 15:23:03; PREPARED; 0.000972; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14291|1
            [107] => 15:23:03; PREPARED; 0.000452; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14291
            [108] => 15:23:03; PREPARED; 0.000703; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14168|1
            [109] => 15:23:03; PREPARED; 0.000421; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14168
            [110] => 15:23:03; PREPARED; 0.000670; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14121|1
            [111] => 15:23:03; PREPARED; 0.000420; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14121
            [112] => 15:23:03; PREPARED; 0.000604; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 14062|1
            [113] => 15:23:03; PREPARED; 0.000401; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14062
            [114] => 15:23:03; PREPARED; 0.000634; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 13868|1
            [115] => 15:23:03; PREPARED; 0.000406; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 13868
            [116] => 15:23:03; PREPARED; 0.000663; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 13866|1
            [117] => 15:23:03; PREPARED; 0.000394; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 13866
            [118] => 15:23:03; PREPARED; 0.000597; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 13859|1
            [119] => 15:23:03; PREPARED; 0.000425; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 13859
            [120] => 15:23:03; PREPARED; 0.000603; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 13851|1
            [121] => 15:23:03; PREPARED; 0.000433; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 13851
            [122] => 15:23:03; PREPARED; 0.000610; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 13785|1
            [123] => 15:23:03; PREPARED; 0.000408; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 13785
            [124] => 15:23:03; PREPARED; 0.000632; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 13783|1
            [125] => 15:23:03; PREPARED; 0.000412; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 13783
            [126] => 15:23:03; PREPARED; 0.000606; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 13713|1
            [127] => 15:23:03; PREPARED; 0.000430; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 13713
            [128] => 15:23:03; PREPARED; 0.000637; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 13627|1
            [129] => 15:23:03; PREPARED; 0.000448; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 13627
            [130] => 15:23:03; PREPARED; 0.000620; 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 = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 13624|1
            [131] => 15:23:03; PREPARED; 0.000403; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 13624
            [132] => 15:23:03; STANDARD; MEMCACHE; 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
            [133] => 15:23:03; STANDARD; 0.007571; 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(19054,18868,18827,18826,18822,18642,18638,18637,18631,18627,18615,18548,18353,18235,18231,18230,18206,18170,18102,18087,18086,18071,18070,18069,18024,17865,17842,17815,17792,17791,17790,17621,17524,17523,17522,17521,17463,17458,17373,17331,17310,16477,16469,16468,16428,16401,16387,16386,16385,16375,16342,16341,16339,16338,16259,16257,16256,16253,16252,16250,16246,16245,16243,16241,16229,16189,16187,16147,16138,16114,16090,16082,16081,16064,16063,16056,16055,16050,16049,16048,16047,16045,16042,16041,16040,16039,16038,16034,16033,16029,16028,16027,16025,16024,16013,16012,16011,16010,16009,16008,16001,16000,15999,15998,15994,15990,15989,15988,15986,15981,15979,15978,15975,15974,15896,15894,15854,15853,15852,15851,15850,15847,15845,15844,15841,15840,15839,15838,15837,15735,15728,15717,15693,15692,15691,15690,15602,15600,15560,15509,15465,15417,15405,15342,15338,15328,15195,15194,15066,14994,14983,14982,14981,14980,14979,14857,14700,14668,14662,14465,14389,14386,14358,14356,14355,14352,14351,14350,14349,14348,14346,14345,14344,14343,14342,14341,14336,14323,14294,14291,14168,14121,14062,13868,13866,13859,13851,13785,13783,13713,13627,13624,13623,13588,13492,13461,13444,13433,13077,13076,13075,13023,13022,13005,13004,13002,12911,12910,12899,12755,12754,12750,12744,12719,12717,12670,12669,12664,12616,12611,12592,12568,12538,12537,12536,12530,12447,12439,12430,12429,12421,12420,12410,12405,12398,12367,12366,12365,12363,12342,12340,12337,12336,12335,12334,12333,12332,12331,12329,12328,12327,12292,12251,12220,12219,12210,12178,12177,12168,12138,12137,12136,12111,12052,12045,12025,12022,12020,12019,11968,11956,11955,11949,11948,11945,11938,11937,11911,11909,11859,11854,11771,11770,11743,11741,11736,11735,11706,11686,11658,11608,11607,11606,11605,11602,11601,11591,11584,11583,11582,11579,11574,11558,11557,11554,11550,11543,11542,11541,11540,11531,11529,11518,11515,11513,11508,11495,11489,11477,11433,10924,10185,10913,10912,10911,10896,10895,10894,10893,10888,10887,10885,10873,10856,10855,10127,10529,10527,10321,10302,10299,10283,10257,10206,10190,10187,10178,10128) AND c.store_id = 1 ORDER BY cd.name ASC
        )

    [ALL_SLOW] => Array
        (
            [0] => 15:23:03; PREPARED; 0.056631; ModelCatalogProduct; getProducts; SELECT p.product_id, p.sku, p.parent_id, p.date_available, pav.available, 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 = ? 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 = ? LEFT JOIN ct_stock_status vs ON v.stock_status_id = vs.stock_status_id WHERE p.status > 1 AND (p.eol = 0 OR pav.available > 0) AND (v.product_id IS NOT NULL OR p.is_parent = 0) AND p2c.store_id = ? AND p.manufacturer_id = ? 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; 1|1|1|30
            [1] => 15:23:03; PREPARED; 0.019493; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 14294
        )

    [DUPLIACTES] => Array
(
)

    [TOTAL_EXECUTION_TIME] => 0.1603989601
)