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 RGL

Get great deals on a range of products from RGL

Page 3 of 7 (166 results)

RGL WP-EDR-2 Weatherproof IP67 Double-Pole Resettable Call Point
In stock
RGL WP-EDR-2 Weatherproof IP67 Double-Pole Resettable Call Point
Product Code: RGL0135
£74.00
£61.67 Ex Vat
RGL DR-ARM-1/W White Armature Plate with Chain for Door Hold Open Magnets
In stock
RGL DR-ARM-1/W White Armature Plate with Chain for Door Hold Open Magnets
Product Code: RGL0134
£31.58
£26.32 Ex Vat
RGL DR-01-BKT/W White Floor Mount Bracket for DR-01-W Door Hold Open Magnet
In stock
RGL DR-01-BKT/W White Floor Mount Bracket for DR-01-W Door Hold Open Magnet
Product Code: RGL0133
£9.60
£8.00 Ex Vat
RGL DR-01-W White Fire Door Hold Open Magnet 24 VDC
In stock
RGL DR-01-W White Fire Door Hold Open Magnet 24 VDC
Product Code: RGL0132
£30.12
£25.10 Ex Vat
RGL DR-ARM-1/BK Black Armature Plate with Chain for Door Hold Open Magnets
In stock
RGL DR-ARM-1/BK Black Armature Plate with Chain for Door Hold Open Magnets
Product Code: RGL0131
£31.58
£26.32 Ex Vat
RGL DR-01-BKT/BK Black Floor Mount Bracket for DR-01-BK Door Hold Open Magnet
In stock
RGL DR-01-BKT/BK Black Floor Mount Bracket for DR-01-BK Door Hold Open Magnet
Product Code: RGL0130
£9.60
£8.00 Ex Vat
RGL DR-01-BK Black Fire Door Hold Open Magnet 24 VDC
In stock
RGL DR-01-BK Black Fire Door Hold Open Magnet 24 VDC
Product Code: RGL0129
£30.12
£25.10 Ex Vat
RGL DL02 Long Coiled Metal Door Loop 600mm
In stock
RGL DL02 Long Coiled Metal Door Loop 600mm
Product Code: RGL0128
£11.40
£9.50 Ex Vat
RGL TRAN-01 Extra Spare Remote Keyfob Transmitter for use with REC-01 Receiver
In stock
RGL TRAN-01 Extra Spare Remote Keyfob Transmitter for use with REC-01 Receiver
Product Code: RGL0127
£11.99
£9.99 Ex Vat
RGL TRAN/REC-01 Universal Remote Keyfob Device Switch TX/RX 12 VDC
In stock
RGL TRAN/REC-01 Universal Remote Keyfob Device Switch TX/RX 12 VDC
Product Code: RGL0126
£34.75
£28.96 Ex Vat
RGL MSL-2600 Double Shearlock Electronic Lock 2600lbs Holding Force
In stock
RGL MSL-2600 Double Shearlock Electronic Lock 2600lbs Holding Force
Product Code: RGL0124
£127.36
£106.13 Ex Vat
RGL DBGLS150 Fail-Safe Drop Bolt for Glass Doors 12 VDC
Ordered on Request
RGL DBGLS150 Fail-Safe Drop Bolt for Glass Doors 12 VDC
Product Code: RGL0123
£94.93
£79.11 Ex Vat
RGL SB-200LS Fail-Safe Monitored Mortice Drop Bolt 12 VDC
In stock
RGL SB-200LS Fail-Safe Monitored Mortice Drop Bolt 12 VDC
Product Code: RGL0122
£69.46
£57.88 Ex Vat
RGL EL225 22.5mm Extension Lip for AS900 Door Strike
In stock
RGL EL225 22.5mm Extension Lip for AS900 Door Strike
Product Code: RGL0121
£5.29
£4.41 Ex Vat
RGL AS900M ANSI Style Fail Safe/Secure Monitored Door Strike 12/24 VAC/VDC
In stock
RGL AS900M ANSI Style Fail Safe/Secure Monitored Door Strike 12/24 VAC/VDC
Product Code: RGL0120
£63.95
£53.29 Ex Vat
RGL AS900 ANSI Style Fail Safe/Secure Electronic Door Strike 12/24 VAC/VDC
In stock
RGL AS900 ANSI Style Fail Safe/Secure Electronic Door Strike 12/24 VAC/VDC
Product Code: RGL0119
£58.46
£48.72 Ex Vat
RGL MM600-M-MORT 600 lbs Flush Mortice Mount Monitored Magnetic Lock 12/24 VDC
In stock
RGL MM600-M-MORT 600 lbs Flush Mortice Mount Monitored Magnetic Lock 12/24 VDC
Product Code: RGL0118
£38.94
£32.45 Ex Vat
RGL MM600-MORT 600 lbs Flush Mortice Mount Magnetic Lock 12/24 VDC
In stock
RGL MM600-MORT 600 lbs Flush Mortice Mount Magnetic Lock 12/24 VDC
Product Code: RGL0117
£35.89
£29.91 Ex Vat
RGL DS-002 Fail-Safe Electronic Door Release 12V AC/DC
In stock
RGL DS-002 Fail-Safe Electronic Door Release 12V AC/DC
Product Code: RGL0114
£21.97
£18.31 Ex Vat
RGL ARM600 Spare Armature Plate for ML600 Series Magnetic locks
In stock
RGL ARM600 Spare Armature Plate for ML600 Series Magnetic locks
Product Code: RGL0113
£11.99
£9.99 Ex Vat
RGL ADJ-600L Adjustable L-Bracket for ML600 Magnetic Locks
In stock
RGL ADJ-600L Adjustable L-Bracket for ML600 Magnetic Locks
Product Code: RGL0112
£58.93
£49.11 Ex Vat
RGL ML600-D 600lbs Double Mini Magnetic Lock
In stock
RGL ML600-D 600lbs Double Mini Magnetic Lock
Product Code: RGL0111
£64.84
£54.03 Ex Vat
RGL KP-FOB-BE Blue Proximity Fob for KPX1000 and KPX2000 Readers
10+ In stock
RGL KP-FOB-BE Blue Proximity Fob for KPX1000 and KPX2000 Readers
Product Code: RGL0110
£1.57
£1.31 Ex Vat
RGL RD26-C Surface Mount Proximity (Wiegand, Mifare, HID, EM) Reader for KPX2000
Ordered on Request
RGL RD26-C Surface Mount Proximity (Wiegand, Mifare, HID, EM) Reader for KPX2000
Product Code: RGL0109
£50.93
£42.44 Ex Vat

Page 3 of 7 (166 results)

Compare 0
Google review badge 
PHPSESSID / cd5c2f38124180c54fd69b6b46615f86
0.171399
Array
(
    [cd5c2f38124180c54fd69b6b46615f86] => Array
        (
            [customer_group_id] => 1
            [pricing_groups] => 
            [currency] => GBP
            [currency_value] => 1.00000000
            [country_id] => 222
            [location_id] => 0
            [tracker] => 2daa0bdf218655c9733b0d03400da7ff0598ad9af77122e1419586dcf8320199
        )

)

Array
(
    [ALL] => Array
        (
            [0] => 21:21:45; PREPARED; MEMCACHED; Url; __construct; SELECT * FROM ct_url_alias WHERE store_id = 1 OR store_id = 0
            [1] => 21:21:45; PREPARED; MEMCACHED; ControllerStartupStartup; index; SELECT * FROM ct_setting WHERE store_id = 0 OR store_id = 1 ORDER BY store_id ASC
            [2] => 21:21:45; PREPARED; MEMCACHED; Cart\Customer; __construct; SELECT * FROM ct_customer_group WHERE customer_group_id = 1
            [3] => 21:21:45; 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:21:45; STANDARD; MEMCACHED; ModelLocalisationCurrency; getCurrencies; SELECT * FROM ct_currency WHERE status = 1 ORDER BY title ASC
            [5] => 21:21:45; STANDARD; MEMCACHED; Cart\Currency; __construct; SELECT * FROM ct_currency
            [6] => 21:21:45; STANDARD; 0.000774; 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:21:45; STANDARD; 0.000261; Tracking; getNewTracker; SELECT tracking_id FROM ct_tracking WHERE tracker = '2daa0bdf218655c9733b0d03400da7ff0598ad9af77122e1419586dcf8320199'
            [8] => 21:21:45; PREPARED; MEMCACHED; Url; getRedirect; SELECT * FROM ct_url_redirect WHERE source = 'rgl' AND path = ''
            [9] => 21:21:45; STANDARD; 0.000262; ModelCatalogManufacturer; getManufacturer; SELECT * FROM ct_manufacturer m WHERE m.manufacturer_id = '131'
            [10] => 21:21:45; STANDARD; 0.015554; 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 = 131 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:21:45; STANDARD; 0.000764; 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 = 18075 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [12] => 21:21:45; STANDARD; 0.000273; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18075
            [13] => 21:21:45; STANDARD; 0.000856; 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 = 18075 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [14] => 21:21:45; STANDARD; 0.000383; 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 = 17988 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [15] => 21:21:45; STANDARD; 0.000244; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17988
            [16] => 21:21:45; STANDARD; 0.000646; 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 = 17988 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [17] => 21:21:45; STANDARD; 0.000375; 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 = 17987 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [18] => 21:21:45; STANDARD; 0.000222; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17987
            [19] => 21:21:45; 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 = 17987 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [20] => 21:21:45; STANDARD; 0.000391; 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 = 17986 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [21] => 21:21:45; STANDARD; 0.000378; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17986
            [22] => 21:21:45; STANDARD; 0.000647; 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 = 17986 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [23] => 21:21:45; STANDARD; 0.000409; 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 = 17985 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [24] => 21:21:45; STANDARD; 0.000226; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17985
            [25] => 21:21:45; STANDARD; 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 = 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 = 17985 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [26] => 21:21:45; STANDARD; 0.000403; 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 = 17984 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [27] => 21:21:45; STANDARD; 0.000246; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17984
            [28] => 21:21:45; STANDARD; 0.000650; 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 = 17984 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [29] => 21:21:45; STANDARD; 0.000375; 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 = 17983 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [30] => 21:21:45; STANDARD; 0.000245; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17983
            [31] => 21:21:45; STANDARD; 0.000704; 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 = 17983 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [32] => 21:21:45; STANDARD; 0.000407; 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 = 17982 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [33] => 21:21:45; STANDARD; 0.000241; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17982
            [34] => 21:21:45; STANDARD; 0.000638; 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 = 17982 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [35] => 21:21:45; STANDARD; 0.000374; 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 = 17981 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [36] => 21:21:45; STANDARD; 0.000231; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17981
            [37] => 21:21:45; STANDARD; 0.000660; 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 = 17981 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [38] => 21:21:45; STANDARD; 0.000367; 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 = 17980 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [39] => 21:21:45; STANDARD; 0.000213; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17980
            [40] => 21:21:45; STANDARD; 0.000678; 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 = 17980 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [41] => 21:21:45; STANDARD; 0.000455; 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 = 17978 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [42] => 21:21:45; STANDARD; 0.000217; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17978
            [43] => 21:21:45; STANDARD; 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 = 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 = 17978 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [44] => 21:21:45; STANDARD; 0.000374; 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 = 17977 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [45] => 21:21:45; STANDARD; 0.000238; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17977
            [46] => 21:21:45; STANDARD; 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 = 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 = 17977 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [47] => 21:21:45; STANDARD; 0.000398; 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 = 17976 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [48] => 21:21:45; STANDARD; 0.000237; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17976
            [49] => 21:21:45; 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 = 17976 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [50] => 21:21:45; 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 = 17975 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [51] => 21:21:45; STANDARD; 0.000254; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17975
            [52] => 21:21:45; 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 = 17975 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [53] => 21:21:45; STANDARD; 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 = 1 WHERE pv.product_id = 17974 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [54] => 21:21:45; STANDARD; 0.000255; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17974
            [55] => 21:21:46; 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 = 17974 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [56] => 21:21:46; 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 = 17973 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [57] => 21:21:46; STANDARD; 0.000226; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17973
            [58] => 21:21:46; STANDARD; 0.000682; 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 = 17973 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [59] => 21:21:46; STANDARD; 0.000377; 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 = 17972 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [60] => 21:21:46; STANDARD; 0.000243; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17972
            [61] => 21:21:46; STANDARD; 0.000657; 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 = 17972 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [62] => 21:21:46; STANDARD; 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 = 1 WHERE pv.product_id = 17971 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [63] => 21:21:46; STANDARD; 0.000223; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17971
            [64] => 21:21:46; STANDARD; 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 = 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 = 17971 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [65] => 21:21:46; STANDARD; 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 = 1 WHERE pv.product_id = 17968 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [66] => 21:21:46; STANDARD; 0.000232; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17968
            [67] => 21:21:46; STANDARD; 0.000673; 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 = 17968 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [68] => 21:21:46; STANDARD; 0.000365; 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 = 17967 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [69] => 21:21:46; STANDARD; 0.000225; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17967
            [70] => 21:21:46; STANDARD; 0.000664; 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 = 17967 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [71] => 21:21:46; 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 = 17966 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [72] => 21:21:46; STANDARD; 0.000233; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17966
            [73] => 21:21:46; STANDARD; 0.000665; 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 = 17966 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [74] => 21:21:46; STANDARD; 0.000365; 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 = 17965 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [75] => 21:21:46; STANDARD; 0.000235; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17965
            [76] => 21:21:46; STANDARD; 0.000665; 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 = 17965 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [77] => 21:21:46; STANDARD; 0.000430; 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 = 17964 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [78] => 21:21:46; STANDARD; 0.000254; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17964
            [79] => 21:21:46; STANDARD; 0.000715; 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 = 17964 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [80] => 21:21:46; STANDARD; 0.000430; 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 = 17963 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [81] => 21:21:46; STANDARD; 0.000243; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17963
            [82] => 21:21:46; STANDARD; 0.000704; 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 = 17963 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [83] => 21:21:46; STANDARD; 0.000281; ModelAccountFavourites; getFavourites; SELECT * FROM ct_customer_favourites WHERE customer_id = 0
            [84] => 21:21:46; STANDARD; 0.000510; 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 = 18075 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [85] => 21:21:46; STANDARD; 0.000286; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18075 ORDER BY sort_order ASC
            [86] => 21:21:46; STANDARD; 0.000477; 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 = 17988 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [87] => 21:21:46; STANDARD; 0.000289; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17988 ORDER BY sort_order ASC
            [88] => 21:21:46; STANDARD; 0.000417; 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 = 17987 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [89] => 21:21:46; STANDARD; 0.000268; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17987 ORDER BY sort_order ASC
            [90] => 21:21:46; STANDARD; 0.000409; 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 = 17986 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [91] => 21:21:46; STANDARD; 0.000269; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17986 ORDER BY sort_order ASC
            [92] => 21:21:46; STANDARD; 0.000480; 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 = 17985 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [93] => 21:21:46; STANDARD; 0.000285; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17985 ORDER BY sort_order ASC
            [94] => 21:21:46; 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 = 17984 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [95] => 21:21:46; STANDARD; 0.000281; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17984 ORDER BY sort_order ASC
            [96] => 21:21:46; 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 = 17983 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [97] => 21:21:46; STANDARD; 0.000280; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17983 ORDER BY sort_order ASC
            [98] => 21:21:46; STANDARD; 0.000432; 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 = 17982 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [99] => 21:21:46; STANDARD; 0.000830; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17982 ORDER BY sort_order ASC
            [100] => 21:21:46; STANDARD; 0.000433; 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 = 17981 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [101] => 21:21:46; STANDARD; 0.000286; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17981 ORDER BY sort_order ASC
            [102] => 21:21:46; STANDARD; 0.000494; 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 = 17980 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [103] => 21:21:46; STANDARD; 0.000274; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17980 ORDER BY sort_order ASC
            [104] => 21:21:46; 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 = 17978 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [105] => 21:21:46; STANDARD; 0.000267; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17978 ORDER BY sort_order ASC
            [106] => 21:21:46; STANDARD; 0.000423; 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 = 17977 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [107] => 21:21:46; STANDARD; 0.000325; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17977 ORDER BY sort_order ASC
            [108] => 21:21:46; STANDARD; 0.000406; 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 = 17976 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [109] => 21:21:46; STANDARD; 0.000235; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17976 ORDER BY sort_order ASC
            [110] => 21:21:46; STANDARD; 0.000391; 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 = 17975 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [111] => 21:21:46; STANDARD; 0.000247; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17975 ORDER BY sort_order ASC
            [112] => 21:21:46; STANDARD; 0.000348; 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 = 17974 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [113] => 21:21:46; STANDARD; 0.000250; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17974 ORDER BY sort_order ASC
            [114] => 21:21:46; STANDARD; 0.000361; 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 = 17973 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [115] => 21:21:46; STANDARD; 0.000241; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17973 ORDER BY sort_order ASC
            [116] => 21:21:46; STANDARD; 0.000376; 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 = 17972 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [117] => 21:21:46; STANDARD; 0.000238; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17972 ORDER BY sort_order ASC
            [118] => 21:21:46; STANDARD; 0.000356; 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 = 17971 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [119] => 21:21:46; STANDARD; 0.000261; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17971 ORDER BY sort_order ASC
            [120] => 21:21:46; STANDARD; 0.000364; 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 = 17968 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [121] => 21:21:46; STANDARD; 0.000243; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17968 ORDER BY sort_order ASC
            [122] => 21:21:46; STANDARD; 0.000354; 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 = 17967 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [123] => 21:21:46; STANDARD; 0.000242; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17967 ORDER BY sort_order ASC
            [124] => 21:21:46; STANDARD; 0.000363; 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 = 17966 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [125] => 21:21:46; STANDARD; 0.000241; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17966 ORDER BY sort_order ASC
            [126] => 21:21:46; STANDARD; 0.000358; 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 = 17965 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [127] => 21:21:46; STANDARD; 0.000265; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17965 ORDER BY sort_order ASC
            [128] => 21:21:46; 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 = 17964 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [129] => 21:21:46; STANDARD; 0.000259; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17964 ORDER BY sort_order ASC
            [130] => 21:21:46; STANDARD; 0.000363; 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 = 17963 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [131] => 21:21:46; STANDARD; 0.000244; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17963 ORDER BY sort_order ASC
            [132] => 21:21:46; 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
            [133] => 21:21:46; STANDARD; 0.005337; 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(19293,19249,19245,19244,19243,19242,19241,19240,19239,19238,19237,19236,19235,19233,19232,19231,19230,19229,19228,19227,19226,19225,19221,19220,19219,19218,19217,19216,19101,18798,18797,18796,18795,18794,18793,18792,18791,18790,18789,18788,18787,18785,18593,18392,18234,18115,18114,18113,18075,17988,17987,17986,17985,17984,17983,17982,17981,17980,17978,17977,17976,17975,17974,17973,17972,17971,17968,17967,17966,17965,17964,17963,17962,17961,17960,17959,17958,17957,17956,17955,17954,17953,17952,17951,17950,17949,17948,17947,17946,17945,17944,17943,17942,17941,17940,17939,17938,17937,17936,17935,17934,17933,17932,17931,17930,17929,17928,17927,17484,17481,17322,17179,17178,17142,17141,17126,16312,16311,16310,16309,16308,16307,16306,16305,16304,16268,16267,16254,16223,16080,16079,16078,16075,16074,15855,15684,15683,15682,15357,14997,14842,14841,14840,14831,14723,14721,14720,14716,14188,14105,13917,13916,13914,13872,13703,13701,13501,13484,13483,12987,12730,12467,12373,12372,11899,11897) AND c.store_id = 1 ORDER BY cd.name ASC
        )

    [DUPLICATES] => Array
        (
        )

    [SLOW] => Array
        (
        )

    [TOTAL_EXECUTION_TIME] => 0.071080923080444
)