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 RUIJIE

Get great deals on a range of products from Ruijie

Page 1 of 3 (64 results)

Ruijie RG-AirMetro460F Reyee AirMetro 5 GHz Wireless Bridge for PTMP/PTP
Back order
Ruijie RG-AirMetro460F Reyee AirMetro 5 GHz Wireless Bridge for PTMP/PTP
Product Code: RUI0066
£61.69
£51.41 Ex Vat
Ruijie Starter Kit 2 (RG-EG105G-P V2, RG-RAP2260(G), RG-ES210GC-LP)
In stock
Ruijie Starter Kit 2 (RG-EG105G-P V2, RG-RAP2260(G), RG-ES210GC-LP)
Product Code: RUI0065
£388.26
£323.55 Ex Vat
Ruijie Starter Kit 1 (RG-EG105G-P V2, RG-RAP2200(E), RG-ES206GC-P)
In stock
Ruijie Starter Kit 1 (RG-EG105G-P V2, RG-RAP2200(E), RG-ES206GC-P)
Product Code: RUI0064
£294.01
£245.01 Ex Vat
Ruijie RG-EG105GW-X Wi-Fi 6 AX3000 High-performance All-in-One Wireless Router
Back order
Ruijie RG-EG105GW-X Wi-Fi 6 AX3000 High-performance All-in-One Wireless Router
Product Code: RUI0063
£186.85
£155.71 Ex Vat
Ruijie RG-POE-AF15 1-Port PoE Adapter (1000Base-T, 52V, 15.6W)
In stock
Ruijie RG-POE-AF15 1-Port PoE Adapter (1000Base-T, 52V, 15.6W)
Product Code: RUI0062
£14.40
£12.00 Ex Vat
Ruijie RG-POE-AT30 1-Port Gigabit PoE Adapter (1000Base-T, 52V, 31.2W)
10+ In stock
Ruijie RG-POE-AT30 1-Port Gigabit PoE Adapter (1000Base-T, 52V, 31.2W)
Product Code: RUI0061
£21.68
£18.07 Ex Vat
Ruijie RG-ANT13-360 Reyee AirMetro Wireless Bridges for PTMP
In stock
Ruijie RG-ANT13-360 Reyee AirMetro Wireless Bridges for PTMP
Product Code: RUI0060
£198.85
£165.71 Ex Vat
Ruijie RG-ANT20S-90 Reyee AirMetro Wireless Bridges for PTMP
In stock
Ruijie RG-ANT20S-90 Reyee AirMetro Wireless Bridges for PTMP
Product Code: RUI0059
£173.15
£144.29 Ex Vat
Ruijie RG-ANT16S-120 Reyee AirMetro Wireless Bridges for PTMP
In stock
Ruijie RG-ANT16S-120 Reyee AirMetro Wireless Bridges for PTMP
Product Code: RUI0058
£99.43
£82.86 Ex Vat
Ruijie RG-AirMetro550G-B Reyee AirMetro 5 GHz Wireless Bridge Station for PTMP
In stock
Ruijie RG-AirMetro550G-B Reyee AirMetro 5 GHz Wireless Bridge Station for PTMP
Product Code: RUI0057
£144.00
£120.00 Ex Vat
Ruijie RG-AirMetro460G Reyee AirMetro 5 GHz Wireless Bridge for PTMP/PTP
In stock
Ruijie RG-AirMetro460G Reyee AirMetro 5 GHz Wireless Bridge for PTMP/PTP
Product Code: RUI0056
£84.00
£70.00 Ex Vat
Ruijie RG-EST100-E 2.4GHz 300Mbps Dual-Stream 500m Wireless P2P Bridge
In stock
Ruijie RG-EST100-E 2.4GHz 300Mbps Dual-Stream 500m Wireless P2P Bridge
Product Code: RUI0055
£61.72
£51.43 Ex Vat
Ruijie RG-RAP73HD Reyee Wi-Fi 7 Tri-Band BE19000 Ceiling Access Point
In stock
Ruijie RG-RAP73HD Reyee Wi-Fi 7 Tri-Band BE19000 Ceiling Access Point
Product Code: RUI0054
£920.57
£767.14 Ex Vat
Ruijie RG-NIS3100-8GT4SFP-HP 8-port 240w 8 PoE+ 4 SFP Industrial Managed Switch
In stock
Ruijie RG-NIS3100-8GT4SFP-HP 8-port 240w 8 PoE+ 4 SFP Industrial Managed Switch
Product Code: RUI0053
£474.85
£395.71 Ex Vat
Ruijie RG-NIS3100-8GT2SFP-HP 8-port 240w 8 PoE+ 2 SFP Industrial Managed Switch
In stock
Ruijie RG-NIS3100-8GT2SFP-HP 8-port 240w 8 PoE+ 2 SFP Industrial Managed Switch
Product Code: RUI0052
£372.00
£310.00 Ex Vat
Ruijie RG-NIS3100-4GT2SFP-HP 4-port 120w 4 PoE+ 2 SFP Industrial Managed Switch
In stock
Ruijie RG-NIS3100-4GT2SFP-HP 4-port 120w 4 PoE+ 2 SFP Industrial Managed Switch
Product Code: RUI0051
£270.85
£225.71 Ex Vat
Ruijie RG-RAP52-OD Reyee Wi-Fi 5 AC1300 Dual-Band Outdoor Access Point
In stock
Ruijie RG-RAP52-OD Reyee Wi-Fi 5 AC1300 Dual-Band Outdoor Access Point
Product Code: RUI0050
£89.52
£74.60 Ex Vat
Ruijie RG-EW1200 802.11ac 1200Mbps Dual-band Wireless Router
In stock
Ruijie RG-EW1200 802.11ac 1200Mbps Dual-band Wireless Router
Product Code: RUI0049
£34.28
£28.57 Ex Vat
Ruijie RG-RAP1200(P) Reyee Wi-Fi 5 1267Mbps Wall-mounted Access Point
In stock
Ruijie RG-RAP1200(P) Reyee Wi-Fi 5 1267Mbps Wall-mounted Access Point
Product Code: RUI0048
£94.28
£78.57 Ex Vat
Ruijie RG-RAP1261 Reyee Wi-Fi 6 AX3000 Ultra-Thin Wall Plate Access Point
In stock
Ruijie RG-RAP1261 Reyee Wi-Fi 6 AX3000 Ultra-Thin Wall Plate Access Point
Product Code: RUI0047
£123.43
£102.86 Ex Vat
Ruijie RG-RAP1260 Reyee Wi-Fi 6 AX3000 Dual-Band Wall Plate Access Point
Back order
Ruijie RG-RAP1260 Reyee Wi-Fi 6 AX3000 Dual-Band Wall Plate Access Point
Product Code: RUI0046
£142.85
£119.04 Ex Vat
Ruijie MINI-GBIC-LX-SM1310 1000BASE-SX SFP Transceiver SM (1310nm 10km LC)
In stock
Ruijie MINI-GBIC-LX-SM1310 1000BASE-SX SFP Transceiver SM (1310nm 10km LC)
Product Code: RUI0045
£21.12
£17.60 Ex Vat
Ruijie MINI-GBIC-SX-MM850 1000BASE-SX SFP Transceiver MM (850nm 550m LC)
In stock
Ruijie MINI-GBIC-SX-MM850 1000BASE-SX SFP Transceiver MM (850nm 550m LC)
Product Code: RUI0044
£16.39
£13.66 Ex Vat
Ruijie RG-M18(2 PACK) 1800Mbps Wi-Fi 6 Dual-band Gigabit Mesh Router - Pack of 2
In stock
Ruijie RG-M18(2 PACK) 1800Mbps Wi-Fi 6 Dual-band Gigabit Mesh Router - Pack of 2
Product Code: RUI0043
£216.76
£180.63 Ex Vat

Page 1 of 3 (64 results)

Compare 0
Google review badge 
PHPSESSID / 1c6b69e1cee3b5c983d9f5309e321119
0.104381
Array
(
    [1c6b69e1cee3b5c983d9f5309e321119] => Array
        (
            [customer_group_id] => 1
            [pricing_groups] => 
            [currency] => GBP
            [currency_value] => 1.00000000
            [country_id] => 222
            [location_id] => 0
            [tracker] => b8199f3dc31b36ff00a6f6a10c89b766ee1a5545a41ef8e686a76397ff01690f
        )

)

Array
(
    [ALL] => Array
        (
            [0] => 19:37:41; PREPARED; MEMCACHED; Url; __construct; SELECT * FROM ct_url_alias WHERE store_id = 1 OR store_id = 0
            [1] => 19:37:41; PREPARED; MEMCACHED; ControllerStartupStartup; index; SELECT * FROM ct_setting WHERE store_id = 0 OR store_id = 1 ORDER BY store_id ASC
            [2] => 19:37:41; PREPARED; MEMCACHED; Cart\Customer; __construct; SELECT * FROM ct_customer_group WHERE customer_group_id = 1
            [3] => 19:37:41; PREPARED; MEMCACHED; ModelCatalogCustomerCatalog; getCustomerCatalog; SELECT cc.* FROM ct_customer_catalog_customer ccc LEFT JOIN ct_customer_catalog cc ON cc.customer_catalog_id = ccc.customer_catalog_id WHERE (ccc.customer_id = 0 AND ccc.customer_id != 0) OR ccc.customer_group_id = 1
            [4] => 19:37:41; STANDARD; MEMCACHED; ModelLocalisationCurrency; getCurrencies; SELECT * FROM ct_currency WHERE status = 1 ORDER BY title ASC
            [5] => 19:37:41; STANDARD; MEMCACHED; Cart\Currency; __construct; SELECT * FROM ct_currency
            [6] => 19:37:41; STANDARD; 0.000835; Cart\Tax; setAddress; SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr2.tax_rate_register FROM ct_tax_rule tr1 LEFT JOIN ct_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) LEFT JOIN ct_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN ct_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE z2gz.country_id = 222 AND z2gz.zone_id = 11 AND tr2.tax_rate_register = 0
            [7] => 19:37:41; STANDARD; 0.000268; Tracking; getNewTracker; SELECT tracking_id FROM ct_tracking WHERE tracker = 'b8199f3dc31b36ff00a6f6a10c89b766ee1a5545a41ef8e686a76397ff01690f'
            [8] => 19:37:41; PREPARED; MEMCACHED; Url; getRedirect; SELECT * FROM ct_url_redirect WHERE source = 'ruijie' AND path = ''
            [9] => 19:37:41; STANDARD; 0.000256; ModelCatalogManufacturer; getManufacturer; SELECT * FROM ct_manufacturer m WHERE m.manufacturer_id = '245'
            [10] => 19:37:41; STANDARD; 0.012174; 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 = 245 AND p.parent_id = 0 GROUP BY p.product_id, v.parent_id ORDER BY p.sort_order = 0, p.sort_order ASC, p.date_added DESC
            [11] => 19:37:41; STANDARD; 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 = 1 WHERE pv.product_id = 19403 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [12] => 19:37:41; STANDARD; 0.000241; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 19403
            [13] => 19:37:41; STANDARD; 0.000793; 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 = 19403 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [14] => 19:37:41; STANDARD; 0.000416; 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 = 18774 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [15] => 19:37:41; STANDARD; 0.000231; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18774
            [16] => 19:37:41; STANDARD; 0.000684; 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 = 18774 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [17] => 19:37:41; STANDARD; 0.000392; 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 = 18773 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [18] => 19:37:41; STANDARD; 0.000229; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18773
            [19] => 19:37:41; STANDARD; 0.000649; 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 = 18773 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [20] => 19:37:41; STANDARD; 0.000373; 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 = 18761 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [21] => 19:37:41; STANDARD; 0.000231; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18761
            [22] => 19:37:41; STANDARD; 0.000676; 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 = 18761 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [23] => 19:37:41; STANDARD; 0.000385; 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 = 18760 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [24] => 19:37:41; STANDARD; 0.000209; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18760
            [25] => 19:37:41; STANDARD; 0.000632; 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 = 18760 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [26] => 19:37:41; STANDARD; 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 = 1 WHERE pv.product_id = 18759 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [27] => 19:37:41; STANDARD; 0.000227; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18759
            [28] => 19:37:41; 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 = 18759 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [29] => 19:37:41; STANDARD; 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 = 1 WHERE pv.product_id = 18757 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [30] => 19:37:41; STANDARD; 0.000246; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18757
            [31] => 19:37:41; STANDARD; 0.000653; 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 = 18757 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [32] => 19:37:41; STANDARD; 0.000414; 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 = 18756 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [33] => 19:37:41; STANDARD; 0.000262; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18756
            [34] => 19:37:41; 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 = 18756 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [35] => 19:37:41; STANDARD; 0.000419; 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 = 18755 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [36] => 19:37:41; STANDARD; 0.000247; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18755
            [37] => 19:37:41; STANDARD; 0.000637; 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 = 18755 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [38] => 19:37:41; STANDARD; 0.000402; 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 = 18754 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [39] => 19:37:41; STANDARD; 0.000230; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18754
            [40] => 19:37:41; 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 = 18754 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [41] => 19:37:41; STANDARD; 0.000392; 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 = 18753 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [42] => 19:37:41; STANDARD; 0.000229; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18753
            [43] => 19:37:41; STANDARD; 0.000705; 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 = 18753 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [44] => 19:37:41; STANDARD; 0.000402; 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 = 18383 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [45] => 19:37:41; STANDARD; 0.000231; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18383
            [46] => 19:37:41; 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 = 18383 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [47] => 19:37:41; STANDARD; 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 = 1 WHERE pv.product_id = 18381 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [48] => 19:37:41; STANDARD; 0.000233; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18381
            [49] => 19:37:41; 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 = 18381 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [50] => 19:37:41; STANDARD; 0.000370; 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 = 18380 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [51] => 19:37:41; STANDARD; 0.000212; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18380
            [52] => 19:37:41; STANDARD; 0.000632; 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 = 18380 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [53] => 19:37:41; 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 = 18379 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [54] => 19:37:41; STANDARD; 0.000230; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18379
            [55] => 19:37:41; 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 = 18379 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [56] => 19:37:41; STANDARD; 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 = 1 WHERE pv.product_id = 18378 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [57] => 19:37:41; STANDARD; 0.000220; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18378
            [58] => 19:37:41; 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 = 18378 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [59] => 19:37:41; 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 = 18327 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [60] => 19:37:41; STANDARD; 0.000256; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18327
            [61] => 19:37:41; 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 = 18327 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [62] => 19:37:41; STANDARD; 0.000370; 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 = 18316 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [63] => 19:37:41; STANDARD; 0.000222; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18316
            [64] => 19:37:41; 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 = 18316 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [65] => 19:37:41; STANDARD; 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 = 1 WHERE pv.product_id = 18315 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [66] => 19:37:41; STANDARD; 0.000249; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18315
            [67] => 19:37:41; STANDARD; 0.000637; 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 = 18315 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [68] => 19:37:41; STANDARD; 0.000357; 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 = 18314 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [69] => 19:37:41; STANDARD; 0.000220; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18314
            [70] => 19:37:41; 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 = 18314 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [71] => 19:37:41; STANDARD; 0.000370; 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 = 18313 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [72] => 19:37:41; STANDARD; 0.000232; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18313
            [73] => 19:37:41; STANDARD; 0.000677; 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 = 18313 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [74] => 19:37:41; 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 = 18312 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [75] => 19:37:41; STANDARD; 0.000218; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18312
            [76] => 19:37:41; STANDARD; 0.000635; 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 = 18312 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [77] => 19:37:41; 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 = 18311 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [78] => 19:37:41; STANDARD; 0.000222; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18311
            [79] => 19:37:41; STANDARD; 0.000643; 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 = 18311 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [80] => 19:37:41; STANDARD; 0.000366; 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 = 18310 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [81] => 19:37:41; STANDARD; 0.000253; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18310
            [82] => 19:37:41; STANDARD; 0.000624; 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 = 18310 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [83] => 19:37:41; STANDARD; 0.000264; ModelAccountFavourites; getFavourites; SELECT * FROM ct_customer_favourites WHERE customer_id = 0
            [84] => 19:37:41; STANDARD; 0.000429; 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 = 19403 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [85] => 19:37:41; STANDARD; 0.000262; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 19403 ORDER BY sort_order ASC
            [86] => 19:37:41; STANDARD; 0.000359; 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 = 18774 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [87] => 19:37:41; STANDARD; 0.000240; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18774 ORDER BY sort_order ASC
            [88] => 19:37:41; 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 = 18773 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [89] => 19:37:41; STANDARD; 0.000239; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18773 ORDER BY sort_order ASC
            [90] => 19:37:41; STANDARD; 0.000350; 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 = 18761 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [91] => 19:37:41; STANDARD; 0.000237; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18761 ORDER BY sort_order ASC
            [92] => 19:37:41; STANDARD; 0.000344; 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 = 18760 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [93] => 19:37:41; STANDARD; 0.000249; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18760 ORDER BY sort_order ASC
            [94] => 19:37:41; STANDARD; 0.000342; 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 = 18759 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [95] => 19:37:41; STANDARD; 0.000236; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18759 ORDER BY sort_order ASC
            [96] => 19:37:41; STANDARD; 0.000362; 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 = 18757 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [97] => 19:37:41; STANDARD; 0.000227; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18757 ORDER BY sort_order ASC
            [98] => 19:37:41; STANDARD; 0.000344; 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 = 18756 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [99] => 19:37:41; STANDARD; 0.000341; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18756 ORDER BY sort_order ASC
            [100] => 19:37:41; STANDARD; 0.000362; 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 = 18755 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [101] => 19:37:41; STANDARD; 0.000291; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18755 ORDER BY sort_order ASC
            [102] => 19:37:41; STANDARD; 0.000350; 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 = 18754 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [103] => 19:37:41; STANDARD; 0.000241; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18754 ORDER BY sort_order ASC
            [104] => 19:37:41; STANDARD; 0.000373; 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 = 18753 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [105] => 19:37:41; STANDARD; 0.000239; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18753 ORDER BY sort_order ASC
            [106] => 19:37:41; STANDARD; 0.000386; 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 = 18383 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [107] => 19:37:41; STANDARD; 0.000326; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18383 ORDER BY sort_order ASC
            [108] => 19:37:41; STANDARD; 0.000349; 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 = 18381 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [109] => 19:37:41; STANDARD; 0.000256; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18381 ORDER BY sort_order ASC
            [110] => 19:37:41; STANDARD; 0.000349; 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 = 18380 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [111] => 19:37:41; STANDARD; 0.000241; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18380 ORDER BY sort_order ASC
            [112] => 19:37:41; STANDARD; 0.000377; 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 = 18379 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [113] => 19:37:41; STANDARD; 0.000241; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18379 ORDER BY sort_order ASC
            [114] => 19:37:41; STANDARD; 0.000347; 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 = 18378 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [115] => 19:37:41; STANDARD; 0.000240; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18378 ORDER BY sort_order ASC
            [116] => 19:37:41; STANDARD; 0.000351; 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 = 18327 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [117] => 19:37:41; STANDARD; 0.000247; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18327 ORDER BY sort_order ASC
            [118] => 19:37:41; STANDARD; 0.000346; 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 = 18316 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [119] => 19:37:41; STANDARD; 0.000241; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18316 ORDER BY sort_order ASC
            [120] => 19:37:41; STANDARD; 0.000367; 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 = 18315 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [121] => 19:37:41; STANDARD; 0.000238; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18315 ORDER BY sort_order ASC
            [122] => 19:37:41; STANDARD; 0.000343; 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 = 18314 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [123] => 19:37:41; STANDARD; 0.000261; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18314 ORDER BY sort_order ASC
            [124] => 19:37:41; STANDARD; 0.000341; 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 = 18313 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [125] => 19:37:41; STANDARD; 0.000238; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18313 ORDER BY sort_order ASC
            [126] => 19:37:41; 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 = 18312 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [127] => 19:37:41; STANDARD; 0.000250; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18312 ORDER BY sort_order ASC
            [128] => 19:37:41; STANDARD; 0.000377; 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 = 18311 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [129] => 19:37:41; STANDARD; 0.000237; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18311 ORDER BY sort_order ASC
            [130] => 19:37:41; STANDARD; 0.000393; 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 = 18310 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [131] => 19:37:41; STANDARD; 0.000231; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18310 ORDER BY sort_order ASC
            [132] => 19:37:41; 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] => 19:37:41; STANDARD; 0.003101; 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(19403,18774,18773,18761,18760,18759,18757,18756,18755,18754,18753,18383,18381,18380,18379,18378,18327,18316,18315,18314,18313,18312,18311,18310,18309,18308,18265,18264,18263,18262,18261,17918,17789,17788,17787,17786,17785,17784,17783,17782,17781,17780,17779,17778,17776,17775,17774,17773,17772,17771,17770,17769,17768,17767,17766,17765,17764,17763,17762,17761,17760,17758,17757,17756) AND c.store_id = 1 ORDER BY cd.name ASC
        )

    [DUPLICATES] => Array
        (
        )

    [SLOW] => Array
        (
        )

    [TOTAL_EXECUTION_TIME] => 0.062505960464478
)