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 TP-LINK

Get great deals on a range of products from TP-Link

Page 1 of 2 (41 results)

TP-Link TL-SG2016P Omada Managed Switch 16 Port
Ordered on Request
TP-Link TL-SG2016P Omada Managed Switch 16 Port
Product Code: TPL0049
£205.72
£171.43 Ex Vat
TP-Link TL-SG3428 JetStream Omada L2+ Managed Switch 24 Port 4 SFP Slots
Ordered on Request
TP-Link TL-SG3428 JetStream Omada L2+ Managed Switch 24 Port 4 SFP Slots
Product Code: TPL0048
£167.62
£139.68 Ex Vat
TP-Link Omada OC300 Controller
Ordered on Request
TP-Link Omada OC300 Controller
Product Code: TPL0047
£167.62
£139.68 Ex Vat
TP-Link Omada ER605 Gigabit VPN Router
Ordered on Request
TP-Link Omada ER605 Gigabit VPN Router
Product Code: TPL0046
£53.34
£44.45 Ex Vat
TP-LINK TL-PA7017-KIT AV1000 Gigabit Powerline HomePlug Adapter Kit
In stock
TP-LINK TL-PA7017-KIT AV1000 Gigabit Powerline HomePlug Adapter Kit
Product Code: TPL0045
£39.41
£32.84 Ex Vat
TP-Link TL-PoE160S 2 x 10/100/1000Mbps Gigabit PoE Injector, 2 Gigabit Ports
10+ In stock
TP-Link TL-PoE160S 2 x 10/100/1000Mbps Gigabit PoE Injector, 2 Gigabit Ports
Product Code: TPL0044
£18.19
£15.16 Ex Vat
TP-Link TL-PoE150S 2 x 10/100/1000Mbps Gigabit PoE Injector
10+ In stock
TP-Link TL-PoE150S 2 x 10/100/1000Mbps Gigabit PoE Injector
Product Code: TPL0043
£15.17
£12.64 Ex Vat
TP-LINK TL-SG1016DE 16-Port 10/100/1000Mbps Smart Desktop/Rackmount Switch
In stock
TP-LINK TL-SG1016DE 16-Port 10/100/1000Mbps Smart Desktop/Rackmount Switch
Product Code: TPL0042
£83.81
£69.84 Ex Vat
TP-LINK TL-SG1024DE 24-Port 10/100/1000Mbps Smart Desktop/Rackmount Switch
In stock
TP-LINK TL-SG1024DE 24-Port 10/100/1000Mbps Smart Desktop/Rackmount Switch
Product Code: TPL0041
£106.66
£88.88 Ex Vat
TP-LINK TL-SF1024D 24-Port 10/100Mbps Unmanaged Desktop/Rackmount Switch
In stock
TP-LINK TL-SF1024D 24-Port 10/100Mbps Unmanaged Desktop/Rackmount Switch
Product Code: TPL0040
£45.72
£38.10 Ex Vat
TP-LINK TL-SF1016DS 16-Port 10/100Mbps Unmanaged Desktop/Rackmount Switch
In stock
TP-LINK TL-SF1016DS 16-Port 10/100Mbps Unmanaged Desktop/Rackmount Switch
Product Code: TPL0039
£31.99
£26.66 Ex Vat
TP-Link TL-SM5110-LR 10GBase-SR Single-mode SFP+ LC Transceiver
In stock
TP-Link TL-SM5110-LR 10GBase-SR Single-mode SFP+ LC Transceiver
Product Code: TPL0038
£46.50
£38.75 Ex Vat
TP-Link TL-SM5110-SR 10GBase-SR Multi-mode SFP+ LC Transceiver
In stock
TP-Link TL-SM5110-SR 10GBase-SR Multi-mode SFP+ LC Transceiver
Product Code: TPL0037
£28.50
£23.75 Ex Vat
TP-LINK TL-SX3008F JetStream 8-Port 10GE SFP+ L2+ Managed Switch
Ordered on Request
TP-LINK TL-SX3008F JetStream 8-Port 10GE SFP+ L2+ Managed Switch
Product Code: TPL0036
£227.36
£189.47 Ex Vat
TP-LINK TL-SG3452XP JetStream 48-Port PoE+ Gigabit 4-Port 10GE SFP+ L2+ Switch
CLEARANCE
Only 1 left
TP-LINK TL-SG3452XP JetStream 48-Port PoE+ Gigabit 4-Port 10GE SFP+ L2+ Switch
Product Code: TPL0035
£696.00
£580.00 Ex Vat
WAS £870.00
Save £174.00
TP-LINK TL-SG3452 JetStream 48-Port Gigabit L2 Managed Network Switch 4x SFP
In stock
TP-LINK TL-SG3452 JetStream 48-Port Gigabit L2 Managed Network Switch 4x SFP
Product Code: TPL0034
£337.51
£281.26 Ex Vat
TP-LINK EAP230-WALL Omada AC1200 Dual-Band Wireless In-Wall PoE Access Point
In stock
TP-LINK EAP230-WALL Omada AC1200 Dual-Band Wireless In-Wall PoE Access Point
Product Code: TPL0033
£75.04
£62.53 Ex Vat
TP-LINK TL-SG2428P JetStream 28-Port (24-Port PoE+) Gigabit Smart Switch 4x SFP
In stock
TP-LINK TL-SG2428P JetStream 28-Port (24-Port PoE+) Gigabit Smart Switch 4x SFP
Product Code: TPL0032
£300.12
£250.10 Ex Vat
TP-LINK EAP670 AX5400 Dual Band Wireless Ceiling Mount Wi-Fi 6 Mesh Access Point
In stock
TP-LINK EAP670 AX5400 Dual Band Wireless Ceiling Mount Wi-Fi 6 Mesh Access Point
Product Code: TPL0031
£143.23
£119.36 Ex Vat
TP-LINK EAP650-WALL AX3000 Dual Band Wireless In-Wall Wi-Fi 6 Mesh Access Point
In stock
TP-LINK EAP650-WALL AX3000 Dual Band Wireless In-Wall Wi-Fi 6 Mesh Access Point
Product Code: TPL0030
£98.52
£82.10 Ex Vat
TP-LINK EAP650-OUTDOOR AX3000 Dual Band Wireless Wi-Fi 6 Mesh Access Point
In stock
TP-LINK EAP650-OUTDOOR AX3000 Dual Band Wireless Wi-Fi 6 Mesh Access Point
Product Code: TPL0029
£190.99
£159.16 Ex Vat
TP-LINK EAP650 AX3000 Dual Band Wireless Ceiling Mount Wi-Fi 6 Mesh Access Point
In stock
TP-LINK EAP650 AX3000 Dual Band Wireless Ceiling Mount Wi-Fi 6 Mesh Access Point
Product Code: TPL0028
£109.14
£90.95 Ex Vat
TP-LINK EAP610-OUTDOOR AX1800 Dual Band Wireless Wi-Fi 6 Mesh Access Point
In stock
TP-LINK EAP610-OUTDOOR AX1800 Dual Band Wireless Wi-Fi 6 Mesh Access Point
Product Code: TPL0027
£139.15
£115.96 Ex Vat
TP-LINK EAP610 AX1800 Dual Band Wireless Ceiling Mount Wi-Fi 6 Mesh Access Point
In stock
TP-LINK EAP610 AX1800 Dual Band Wireless Ceiling Mount Wi-Fi 6 Mesh Access Point
Product Code: TPL0026
£122.77
£102.31 Ex Vat

Page 1 of 2 (41 results)

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

)

Array
(
    [ALL] => Array
        (
            [0] => 20:17:50; PREPARED; MEMCACHED; Url; __construct; SELECT * FROM ct_url_alias WHERE store_id = 1 OR store_id = 0
            [1] => 20:17:50; PREPARED; MEMCACHED; ControllerStartupStartup; index; SELECT * FROM ct_setting WHERE store_id = 0 OR store_id = 1 ORDER BY store_id ASC
            [2] => 20:17:50; PREPARED; MEMCACHED; Cart\Customer; __construct; SELECT * FROM ct_customer_group WHERE customer_group_id = 1
            [3] => 20:17:50; 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] => 20:17:50; STANDARD; MEMCACHED; ModelLocalisationCurrency; getCurrencies; SELECT * FROM ct_currency WHERE status = 1 ORDER BY title ASC
            [5] => 20:17:50; STANDARD; MEMCACHED; Cart\Currency; __construct; SELECT * FROM ct_currency
            [6] => 20:17:50; STANDARD; 0.000900; 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] => 20:17:50; STANDARD; 0.000290; Tracking; getNewTracker; SELECT tracking_id FROM ct_tracking WHERE tracker = 'cedd9d3e42cdbd58944e3aa3f33131f9499beb50387cce2a09fe8c5367bc78ef'
            [8] => 20:17:50; PREPARED; MEMCACHED; Url; getRedirect; SELECT * FROM ct_url_redirect WHERE source = 'tp-link' AND path = ''
            [9] => 20:17:50; STANDARD; 0.000269; ModelCatalogManufacturer; getManufacturer; SELECT * FROM ct_manufacturer m WHERE m.manufacturer_id = '73'
            [10] => 20:17:50; STANDARD; 0.010043; 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 = 73 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] => 20:17:50; STANDARD; 0.000668; 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 = 19253 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [12] => 20:17:50; STANDARD; 0.000300; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 19253
            [13] => 20:17:50; STANDARD; 0.000926; 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 = 19253 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [14] => 20:17:50; STANDARD; 0.000468; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 19252 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [15] => 20:17:50; STANDARD; 0.000262; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 19252
            [16] => 20:17:50; STANDARD; 0.000648; 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 = 19252 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [17] => 20:17:50; 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 = 19251 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [18] => 20:17:50; STANDARD; 0.000272; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 19251
            [19] => 20:17:50; 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 = 19251 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [20] => 20:17:50; STANDARD; 0.000384; 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 = 19250 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [21] => 20:17:50; STANDARD; 0.000232; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 19250
            [22] => 20:17:50; STANDARD; 0.000736; 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 = 19250 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [23] => 20:17:50; STANDARD; 0.000486; 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 = 18777 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [24] => 20:17:50; STANDARD; 0.000592; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18777
            [25] => 20:17:50; STANDARD; 0.001635; 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 = 18777 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [26] => 20:17:50; STANDARD; 0.000864; 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 = 18210 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [27] => 20:17:50; STANDARD; 0.000539; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18210
            [28] => 20:17:50; STANDARD; 0.001503; 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 = 18210 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [29] => 20:17:50; STANDARD; 0.000911; 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 = 18209 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [30] => 20:17:50; STANDARD; 0.000374; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18209
            [31] => 20:17:50; STANDARD; 0.000750; 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 = 18209 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [32] => 20:17:50; STANDARD; 0.000461; 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 = 18063 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [33] => 20:17:50; STANDARD; 0.000278; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18063
            [34] => 20:17:50; STANDARD; 0.000712; 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 = 18063 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [35] => 20:17:50; STANDARD; 0.000468; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 18062 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [36] => 20:17:50; STANDARD; 0.000271; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18062
            [37] => 20:17:50; STANDARD; 0.000742; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 18062 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [38] => 20:17:50; STANDARD; 0.000468; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 18061 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [39] => 20:17:50; STANDARD; 0.000273; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18061
            [40] => 20:17:50; STANDARD; 0.000731; 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 = 18061 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [41] => 20:17:50; STANDARD; 0.000464; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 18060 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [42] => 20:17:50; STANDARD; 0.000328; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 18060
            [43] => 20:17:50; STANDARD; 0.000733; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 18060 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [44] => 20:17:50; STANDARD; 0.000473; 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 = 17823 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [45] => 20:17:50; STANDARD; 0.000323; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17823
            [46] => 20:17:50; STANDARD; 0.000740; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 17823 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [47] => 20:17:50; STANDARD; 0.000456; 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 = 17822 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [48] => 20:17:50; STANDARD; 0.000291; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17822
            [49] => 20:17:50; STANDARD; 0.000742; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 17822 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [50] => 20:17:50; STANDARD; 0.000476; 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 = 17821 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [51] => 20:17:50; STANDARD; 0.000295; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17821
            [52] => 20:17:50; STANDARD; 0.000733; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 17821 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [53] => 20:17:50; STANDARD; 0.000477; 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 = 17820 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [54] => 20:17:50; STANDARD; 0.000279; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17820
            [55] => 20:17:50; STANDARD; 0.000762; 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 = 17820 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [56] => 20:17:50; STANDARD; 0.000471; 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 = 17819 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [57] => 20:17:50; STANDARD; 0.000277; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17819
            [58] => 20:17:50; STANDARD; 0.000830; 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 = 17819 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [59] => 20:17:50; STANDARD; 0.000521; 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 = 17619 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [60] => 20:17:50; STANDARD; 0.000328; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17619
            [61] => 20:17:50; STANDARD; 0.000738; 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 = 17619 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [62] => 20:17:50; STANDARD; 0.000457; 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 = 17618 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [63] => 20:17:50; STANDARD; 0.000291; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17618
            [64] => 20:17:51; STANDARD; 0.000726; 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 = 17618 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [65] => 20:17:51; STANDARD; 0.000452; 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 = 17617 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [66] => 20:17:51; STANDARD; 0.000273; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17617
            [67] => 20:17:51; STANDARD; 0.000734; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 17617 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [68] => 20:17:51; STANDARD; 0.000457; 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 = 17616 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [69] => 20:17:51; STANDARD; 0.000276; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17616
            [70] => 20:17:51; STANDARD; 0.000723; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = 0 OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = 1 OR FIND_IN_SET(prd.customer_group_id, '')) AND prd.quantity <= 1) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = 0 OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = 1 OR FIND_IN_SET(pd.customer_group_id, '')) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= 1 AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = 17616 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [71] => 20:17:51; STANDARD; 0.000484; ModelCatalogProduct; getProducts; SELECT pv.variant_id, pv.name, (pvp.cost + (pvp.cost * (pvp.markup / 100))) AS base_price, p.sku FROM ct_product_variant pv LEFT JOIN ct_product p ON p.product_id = pv.variant_id LEFT JOIN ct_product pvp ON pvp.product_id = pv.variant_id LEFT JOIN ct_product_available pav ON pav.product_id = pvp.product_id AND pav.store_id = 1 WHERE pv.product_id = 17615 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [72] => 20:17:51; STANDARD; 0.000253; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17615
            [73] => 20:17:51; STANDARD; 0.000826; 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 = 17615 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [74] => 20:17:51; STANDARD; 0.000523; 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 = 17614 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [75] => 20:17:51; STANDARD; 0.000287; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17614
            [76] => 20:17:51; STANDARD; 0.000823; 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 = 17614 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [77] => 20:17:51; STANDARD; 0.000462; 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 = 17613 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [78] => 20:17:51; STANDARD; 0.000329; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17613
            [79] => 20:17:51; STANDARD; 0.000776; 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 = 17613 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [80] => 20:17:51; 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 = 17612 AND pvp.status > 1 AND (pvp.eol = 0 OR pav.available > 0) ORDER BY pv.sort_order ASC
            [81] => 20:17:51; STANDARD; 0.007253; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = 17612
            [82] => 20:17:51; STANDARD; 0.000877; 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 = 17612 ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1
            [83] => 20:17:51; STANDARD; 0.000257; ModelAccountFavourites; getFavourites; SELECT * FROM ct_customer_favourites WHERE customer_id = 0
            [84] => 20:17:51; STANDARD; 0.000492; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = 19253 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [85] => 20:17:51; STANDARD; 0.000366; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 19253 ORDER BY sort_order ASC
            [86] => 20:17:51; STANDARD; 0.000458; 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 = 19252 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [87] => 20:17:51; STANDARD; 0.000240; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 19252 ORDER BY sort_order ASC
            [88] => 20:17:51; 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 = 19251 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [89] => 20:17:51; STANDARD; 0.000262; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 19251 ORDER BY sort_order ASC
            [90] => 20:17:51; 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 = 19250 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [91] => 20:17:51; STANDARD; 0.000233; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 19250 ORDER BY sort_order ASC
            [92] => 20:17:51; 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 = 18777 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [93] => 20:17:51; STANDARD; 0.000241; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18777 ORDER BY sort_order ASC
            [94] => 20:17:51; STANDARD; 0.000355; 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 = 18210 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [95] => 20:17:51; STANDARD; 0.000245; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18210 ORDER BY sort_order ASC
            [96] => 20:17:51; STANDARD; 0.000352; 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 = 18209 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [97] => 20:17:51; STANDARD; 0.000260; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18209 ORDER BY sort_order ASC
            [98] => 20:17:51; 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 = 18063 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [99] => 20:17:51; STANDARD; 0.000245; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18063 ORDER BY sort_order ASC
            [100] => 20:17:51; 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 = 18062 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [101] => 20:17:51; STANDARD; 0.000242; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18062 ORDER BY sort_order ASC
            [102] => 20:17:51; 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 = 18061 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [103] => 20:17:51; STANDARD; 0.000240; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18061 ORDER BY sort_order ASC
            [104] => 20:17:51; STANDARD; 0.000345; 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 = 18060 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [105] => 20:17:51; STANDARD; 0.000228; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 18060 ORDER BY sort_order ASC
            [106] => 20:17:51; 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 = 17823 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [107] => 20:17:51; STANDARD; 0.000231; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17823 ORDER BY sort_order ASC
            [108] => 20:17:51; STANDARD; 0.000360; 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 = 17822 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [109] => 20:17:51; STANDARD; 0.000242; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17822 ORDER BY sort_order ASC
            [110] => 20:17:51; 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 = 17821 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [111] => 20:17:51; STANDARD; 0.000274; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17821 ORDER BY sort_order ASC
            [112] => 20:17:51; STANDARD; 0.000388; 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 = 17820 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [113] => 20:17:51; STANDARD; 0.000274; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17820 ORDER BY sort_order ASC
            [114] => 20:17:51; STANDARD; 0.000366; 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 = 17819 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [115] => 20:17:51; STANDARD; 0.000261; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17819 ORDER BY sort_order ASC
            [116] => 20:17:51; STANDARD; 0.000378; 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 = 17619 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [117] => 20:17:51; STANDARD; 0.000248; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17619 ORDER BY sort_order ASC
            [118] => 20:17:51; STANDARD; 0.000370; 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 = 17618 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [119] => 20:17:51; STANDARD; 0.000249; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17618 ORDER BY sort_order ASC
            [120] => 20:17:51; 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 = 17617 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [121] => 20:17:51; STANDARD; 0.000242; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17617 ORDER BY sort_order ASC
            [122] => 20:17:51; 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 = 17616 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [123] => 20:17:51; STANDARD; 0.000249; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17616 ORDER BY sort_order ASC
            [124] => 20:17:51; 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 = 17615 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [125] => 20:17:51; STANDARD; 0.000241; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17615 ORDER BY sort_order ASC
            [126] => 20:17:51; 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 = 17614 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [127] => 20:17:51; STANDARD; 0.000301; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17614 ORDER BY sort_order ASC
            [128] => 20:17:51; STANDARD; 0.000482; 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 = 17613 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [129] => 20:17:51; STANDARD; 0.000317; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17613 ORDER BY sort_order ASC
            [130] => 20:17:51; STANDARD; 0.000369; 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 = 17612 AND p2c.primary_category = 1 AND p2c.store_id = 1
            [131] => 20:17:51; STANDARD; 0.000252; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = 17612 ORDER BY sort_order ASC
            [132] => 20:17:51; 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] => 20:17:51; STANDARD; 0.001711; 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(19253,19252,19251,19250,18777,18210,18209,18063,18062,18061,18060,17823,17822,17821,17820,17819,17619,17618,17617,17616,17615,17614,17613,17612,17611,17610,17609,17608,17607,17606,17605,17604,17603,17602,16504,16503,16501,14706,14640,14639,11502) AND c.store_id = 1 ORDER BY cd.name ASC
        )

    [DUPLICATES] => Array
        (
        )

    [SLOW] => Array
        (
        )

    [TOTAL_EXECUTION_TIME] => 0.075091600418091
)