DEV MODE
Tax based on shipping to United Kingdom gb flag , Change?
Basket 
NEW CLEARANCE
Veracity OUTREACH MAX VOR-ORM-XT External IP & PoE Extender
fullscreen

Veracity OUTREACH MAX VOR-ORM-XT External IP & PoE Extender

Rated 0/5   0 reviews | 0 Questions
Veracity logo Veracity
  • Powered by PoE
  • 200m Range
  • 10/100 Compatibility

The Veracity VOR-ORM-XT is a PoE powered external Ethernet and PoE extender that can increase the length of a 10/100 connection and be daisy chained. (Read more)

Loading
£252.58
£210.48 Ex VAT
Back order
Free delivery availale
Orders will be processed Tuesday 6th May
Product CodeVER0022
ModelVOR-ORM-XT
More Information
RELATED PRODUCTS

PRODUCT DETAILS

The Veracity VOR-ORM-XT OUTREACH MAX is an Ethernet extender that can double the length of a 10/100 Ethernet connection to 200m, or be daisy chained for longer runs, making it ideal for large scale CCTV or networking installations. The OUTREACH Max is powered by PoE, and will forward PoE to other devices that are compatible with IEEE 802.3af, which is the universal POE standard for low power network devices such as fixed IP cameras. In addition, OUTREACH Max is compatible with POE Plus (IEEE802.3at) and higher power 4-pair POE (IEEE 802.3bt) up to 90W.


Simple to install

Fitting OUTREACH Max is simple because no set-up is required. Its only connections are two RJ45 network ports, both of which immediately self-configure for 100Base-TX operation. POE power is automatically transferred between connected equipment. No local power supply connection is needed, because OUTREACH Max is powered by POE.

OUTREACH Max can easily be located anywhere along the network cable, as long as no single length of cable is greater than 100 metres. For example, to extend the network connection between a POE switch and an IP camera to 170 metres, an OUTREACH Max could be installed 90 metres from the switch. A further 80 metres of cable would run from the OUTREACH Max to the camera.


Application

A single OUTREACH Max XT doubles the cable range to a POE IP Camera. Each cable segment can be up to 100 metres.

6759b9307b041_screenshot2024-12-11160756.png


If there is no POE available, upgrade the link with Veracity’s low cost POE injector OUTSOURCE.

675b105711134_screenshot2024-12-12163300.png


If POE and network extension beyond 200 metres (656 ft) is required, more than one OUTREACH Max may be installed in series. For example, a 300 metre (984ft) connection between a POE switch and a 10 watt IP camera can be achieved by fitting two OUTREACH Max units at 100 metre intervals along the cable. The maximum extension distance depends on how much power is required and which POE source is used. 


6759b9d12e91d_screenshot2024-12-11161149.png


Which type of OUTREACH do I need?

ETHERNET ONLY
POE FORWARDING
EXTERNAL UNITS
GIGABIT OPTION
If Ethernet extension only  
is required, use OUTREACH Lite models.
Lite models extend Ethernet only
and do not forward POE.
If POE forwarding is also required,
use OUTREACH Max models.
Max models support all standards  
of POE forwarding.
For outdoor Ethernet extension,
use OUTREACH XT models with
IP67/Nema 4X/6P standard enclosures
and connections.
If Gigabit Ethernet extension
is required, use OUTREACH G models
as these support
full Gigabit data rates.


Features:

  • IP66/67 Nema 4X/6P tough enclosure for external installation
  • Instantly doubles cable range to 200 metres
  • Extend additional 100 metres per unit with multiple units
  • Compatible with POE, POE Plus & custom POE to 90W
  • Easy-to-fit cable seals for cables with existing RJ45 plugs
  • Full unrestricted network bandwidth (Gigabit available)
  • Secure wall mounting with detachable bracket
YOU MIGHT ALSO NEED
Loading
 
 
 
 
 
Loading
 
 
 
 
 
Loading
 
 
 
 
 
Loading
 
 
 
 
 
Loading
 
 
 
 
 
Loading
 
 
 
 
 
Loading
 
 
 
 
 
SPECIFICATIONS
POWER
Power consumption
1.3 watts via POE
POE POWER COMPATIBILITY
PoE Power Compatibility 90 watts max (full 802.3bt Class 8, 71 watts camera power)
Maximum current 1.92 amps per pair at rated operating temperature
POE STANDARDS
PoE Standards IEEE 802.3af POE (15W) and IEEE 802.3at at POE Plus (2-event signature) (25-30W)
IEEE 802.3bt POE (to 90W+, non-LLDP)
Custom POE (incl. “always-on 48V” and “4-pair” POE)
ETHERNET INTERFACE
Ethernet Interface Two independently auto-configuring 10/100 ports
(10Base-T/100Base-TX, half/full duplex)
Patch or crossover cables supported
LEDS
Status indicators
Green LED - shows POE Power good
Yellow LED - shows Ethernet link/activity
PHYSICAL/ENVIRONMENTAL
Dimensions
L 183mm W 50mm H 30mm
Weight
104g [3.7oz], 126g [4.5oz] including plate
Mounting
2/4 Bolt 7mm mounting holes. On 50/60mm centres
Operating temperature
-40ºC to 70ºC [-40ºF to 158ºF]
Relative humidity
Up to 85%, non-condensing
Compliance
CE, FCC, UKCA, UL RoHS
Environmental
IP66/67, Nema 4X/6P
USEFUL FILES AND LINKS
Videos
No videos available
Files
  Veracity OUTREACH MAX VOR-ORM-XT Datasheet
  Veracity OUTREACH MAX VOR-ORM-XT Quick Start Guide
Links*
Veracity website

* External websites provide additional content that supports the content on connectec.uk however the external Web site is subject to change and is beyond the control of Connectec Ltd. Connectec cannot guarantee the accuracy of content on external websites and does not endorse the information or products on any external websites. You will be subject to the external websites own privacy policy when you follow these links.

QUESTIONS AND ANSWERS

Get expert answers to questions specific to this product below or for more help visit our Q&A forum


Be the first to ask a question and help others interested in this product

REVIEWS

Read customer reviews or submit your review of this product


Thanks for taking the time to review this product.
Your feedback helps us improve our products and services as well as helping other users make informed buying decisions.

There are no reviews for this product.


Why buy from Connectec?

Support

SUPPORT

Our technical support team are experienced installation engineers with years of field experience.

service_icon.png

SERVICE

Customer service is our top priority. We always try to ensure we offer a first class service too all our customers.

free_delivery_icon.png

DELIVERY

We offer FREE mainland UK delivery on orders over £75 and FREE next day delivery on orders over £150*.

partner_icon.png

PARTNERS

We are approved resellers for direct access to manufacturer warranty and support.

* Qualifying products only, subject to terms. For more information view our delivery information.

Compare 0
Google review badge
__Secure-PHPSESSID / a31d439315facc9941e8e16e04501003
0.132198
Array
(
    [a31d439315facc9941e8e16e04501003] => Array
        (
            [customer_group_id] => 1
            [pricing_groups] => 
            [currency] => GBP
            [currency_value] => 1.00000000
            [country_id] => 222
            [location_id] => 0
            [tracker] => c96a9f17809839411d818f566cb625e718e04f186fab3f5e0c96e4bbe26c36fc
            [shipping_methods] => Array
                (
                    [size] => 1
                    [name] => Small Items
                    [methods] => Array
                        (
                            [0] => Array
                                (
                                    [type] => shipping
                                    [shipping_method_id] => 2
                                    [location_id] => 0
                                    [name] => UK Economy
                                    [notes] => 
                                    [description] => Economy shipping to UK addresses
                                    [arrival_date] => 2025-05-09
                                    [arrival_dates] => Array
                                        (
                                            [0] => 2025-05-09
                                            [1] => 2025-05-12
                                            [2] => 2025-05-13
                                            [3] => 2025-05-14
                                            [4] => 2025-05-15
                                            [5] => 2025-05-16
                                            [6] => 2025-05-19
                                            [7] => 2025-05-20
                                            [8] => 2025-05-21
                                            [9] => 2025-05-22
                                            [10] => 2025-05-23
                                        )

                                    [arrival_text] => Friday 9th May (4 days)
                                    [amount] => 62.5
                                    [amount_diff] => 62.5
                                    [amount_diff_text] => £75.00
                                    [price] => 3.32
                                    [price_text] => £3.98
                                )

                            [1] => Array
                                (
                                    [type] => shipping
                                    [shipping_method_id] => 3
                                    [location_id] => 0
                                    [name] => UK Priority (Mainland UK)
                                    [notes] => 
                                    [description] => Priority delivery to UK mainland
                                    [arrival_date] => 2025-05-08
                                    [arrival_dates] => Array
                                        (
                                            [0] => 2025-05-08
                                            [1] => 2025-05-09
                                            [2] => 2025-05-12
                                            [3] => 2025-05-13
                                            [4] => 2025-05-14
                                            [5] => 2025-05-15
                                            [6] => 2025-05-16
                                            [7] => 2025-05-19
                                            [8] => 2025-05-20
                                            [9] => 2025-05-21
                                            [10] => 2025-05-22
                                        )

                                    [arrival_text] => Thursday 8th May (3 days)
                                    [amount] => 83.333
                                    [amount_diff] => 83.333
                                    [amount_diff_text] => £100.00
                                    [price] => 4.16
                                    [price_text] => £4.99
                                )

                            [2] => Array
                                (
                                    [type] => shipping
                                    [shipping_method_id] => 1
                                    [location_id] => 0
                                    [name] => UK Next Working Day
                                    [notes] => 
                                    [description] => Next working day delivery to mainland UK addresses
                                    [arrival_date] => 2025-05-07
                                    [arrival_dates] => Array
                                        (
                                            [0] => 2025-05-07
                                            [1] => 2025-05-08
                                            [2] => 2025-05-09
                                            [3] => 2025-05-12
                                            [4] => 2025-05-13
                                            [5] => 2025-05-14
                                            [6] => 2025-05-15
                                            [7] => 2025-05-16
                                            [8] => 2025-05-19
                                            [9] => 2025-05-20
                                            [10] => 2025-05-21
                                        )

                                    [arrival_text] => Wednesday 7th May (2 days)
                                    [amount] => 124.99
                                    [amount_diff] => 124.99
                                    [amount_diff_text] => £149.99
                                    [price] => 7.49
                                    [price_text] => £8.99
                                )

                            [3] => Array
                                (
                                    [type] => shipping
                                    [shipping_method_id] => 16
                                    [location_id] => 0
                                    [name] => UK Next Working Day < 1:00 PM
                                    [notes] => 
                                    [description] => Delivery to UK mainland addresses before 1:00 PM
                                    [arrival_date] => 2025-05-07
                                    [arrival_dates] => Array
                                        (
                                            [0] => 2025-05-07
                                            [1] => 2025-05-08
                                            [2] => 2025-05-09
                                            [3] => 2025-05-12
                                            [4] => 2025-05-13
                                            [5] => 2025-05-14
                                            [6] => 2025-05-15
                                            [7] => 2025-05-16
                                            [8] => 2025-05-19
                                            [9] => 2025-05-20
                                            [10] => 2025-05-21
                                        )

                                    [arrival_text] => Wednesday 7th May (2 days)
                                    [amount] => 0
                                    [amount_diff] => 0
                                    [amount_diff_text] => £0.00
                                    [price] => 12.5
                                    [price_text] => £15.00
                                )

                            [4] => Array
                                (
                                    [type] => shipping
                                    [shipping_method_id] => 17
                                    [location_id] => 0
                                    [name] => UK Next working day < 11:00 AM
                                    [notes] => 
                                    [description] => Delivery to mainland UK addresses before 11:00 AM
                                    [arrival_date] => 2025-05-07
                                    [arrival_dates] => Array
                                        (
                                            [0] => 2025-05-07
                                            [1] => 2025-05-08
                                            [2] => 2025-05-09
                                            [3] => 2025-05-12
                                            [4] => 2025-05-13
                                            [5] => 2025-05-14
                                            [6] => 2025-05-15
                                            [7] => 2025-05-16
                                            [8] => 2025-05-19
                                            [9] => 2025-05-20
                                            [10] => 2025-05-21
                                        )

                                    [arrival_text] => Wednesday 7th May (2 days)
                                    [amount] => 0
                                    [amount_diff] => 0
                                    [amount_diff_text] => £0.00
                                    [price] => 20.83
                                    [price_text] => £25.00
                                )

                            [5] => Array
                                (
                                    [type] => shipping
                                    [shipping_method_id] => 18
                                    [location_id] => 0
                                    [name] => UK Saturday
                                    [notes] => 
                                    [description] => Delivery on Saturdays
                                    [arrival_date] => 2025-05-10
                                    [arrival_dates] => Array
                                        (
                                            [0] => 2025-05-10
                                            [1] => 2025-05-17
                                            [2] => 2025-05-24
                                        )

                                    [arrival_text] => Saturday 10th May (5 days)
                                    [amount] => 0
                                    [amount_diff] => 0
                                    [amount_diff_text] => £0.00
                                    [price] => 16.67
                                    [price_text] => £20.00
                                )

                        )

                )

            [recent] => Array
                (
                    [19588] => 2025-05-05 04:25:14
                )

        )

)
Array
(
    [ALL] => Array
        (
            [0] => 04:25:14; PREPARED; MEMCACHE; __construct; SELECT * FROM ct_url_alias WHERE store_id = ? OR store_id = 0; 1
            [1] => 04:25:14; PREPARED; MEMCACHE; index; SELECT * FROM ct_setting WHERE store_id = 0 OR store_id = ? ORDER BY store_id ASC; 1
            [2] => 04:25:14; PREPARED; MEMCACHE; __construct; SELECT * FROM ct_customer_group WHERE customer_group_id = ?; 1
            [3] => 04:25:14; PREPARED; MEMCACHE; getCustomerCatalog; SELECT cc.* FROM ct_customer_catalog_customer ccc LEFT JOIN ct_customer_catalog cc ON cc.customer_catalog_id = ccc.customer_catalog_id WHERE (ccc.customer_id = ? AND ccc.customer_id != 0) OR ccc.customer_group_id = ?; 0|1
            [4] => 04:25:14; STANDARD; MEMCACHE; ModelLocalisationCurrency; getCurrencies; SELECT * FROM ct_currency WHERE status = 1 ORDER BY title ASC
            [5] => 04:25:14; STANDARD; MEMCACHE; Cart\Currency; __construct; SELECT * FROM ct_currency
            [6] => 04:25:14; PREPARED; 0.000920; Cart\Tax; setAddress; SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr2.tax_rate_register FROM ct_tax_rule tr1 LEFT JOIN ct_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) LEFT JOIN ct_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN ct_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE z2gz.country_id = ? AND z2gz.zone_id = ? AND tr2.tax_rate_register = ?; 222|11|0
            [7] => 04:25:14; PREPARED; 0.000398; Tracking; getNewTracker; SELECT tracking_id FROM ct_tracking WHERE tracker = ?; c96a9f17809839411d818f566cb625e718e04f186fab3f5e0c96e4bbe26c36fc
            [8] => 04:25:14; PREPARED; MEMCACHE; getRedirect; SELECT * FROM ct_url_redirect WHERE source = ? AND path = ?; electrical|
            [9] => 04:25:14; PREPARED; MEMCACHE; getRedirect; SELECT * FROM ct_url_redirect WHERE source = ? AND path = ?; power-supplies-psu|
            [10] => 04:25:14; PREPARED; 0.000316; Url; getRedirect; SELECT * FROM ct_url_redirect WHERE source = ? AND path = ?; poe-power-supplies|
            [11] => 04:25:14; PREPARED; 0.000279; Url; getRedirect; SELECT * FROM ct_url_redirect WHERE source = ? AND path = ?; veracity-outreach-max-vor-orm-xt-external-ip-and-poe-extender|
            [12] => 04:25:14; PREPARED; 0.001786; ModelCatalogProduct; getProduct; SELECT DISTINCT p.*, pav.available, pd.feature, pd.description, pd.specification, pd.tag, pd.meta_title, pd.meta_description, pd.product_note, IF(p.eol OR p.increment < 1, 1, p.increment) AS increment, IF(p.eol OR p.minimum < 1, 1, p.minimum) AS minimum, IF(p.eol, IF(p.maximum > 0, LEAST(pav.available, p.maximum), pav.available), IF(p.maximum > 0, p.maximum, 9999)) AS maximum, m.name AS manufacturer, m.image AS manufacturer_thumb, m.site AS manufacturer_site, m.support AS manufacturer_support, ss.name AS stock_status, ss.in_stock, ss.zero_checkout, COALESCE(AVG(r.rating), 0) AS rating, COUNT(DISTINCT r.review_id) AS reviews, p.sort_order , (SELECT GROUP_CONCAT(CONCAT(pv.variant_id, '|', pv.name)) FROM ct_product_variant pv WHERE pv.product_id = p.product_id GROUP BY pv.product_id ORDER BY pv.sort_order) AS variants FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id AND pav.store_id = 1 LEFT JOIN ct_review r ON (r.product_id = p.product_id AND r.status = '1') LEFT JOIN ct_stock_status ss ON (p.stock_status_id = ss.stock_status_id) LEFT JOIN ct_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN ct_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = ?; 19588
            [13] => 04:25:14; PREPARED; 0.000350; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 19588
            [14] => 04:25:14; PREPARED; 0.001091; ModelCatalogProduct; getProductPrice; SELECT p.cost, p.tax_class_id, COALESCE(pr.markup, p.markup) AS markup, COALESCE(pr.login, p.login) AS login, COALESCE(pr.trade, p.trade) AS trade, p.rrp, p.points, COALESCE(pd.price, prd.price, 0) AS discount_price, COALESCE(pd.percent, prd.percent, 0) AS discount_percent, COALESCE(pd.markup, prd.markup, 0) AS discount_markup, COALESCE(pd.date_end, '') AS discount_end, COALESCE(pd.reason, prd.reason, '') AS discount_reason, COALESCE(pd.customer_group_id, prd.customer_group_id, 0) AS customer_group_id FROM ct_product p LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id LEFT JOIN ct_price_rule pr ON pr.price_rule_id = p.price_rule_id LEFT JOIN ct_price_rule_discount prd ON prd.price_rule_id = pr.price_rule_id AND ((prd.customer_id = ? OR prd.customer_id = 0) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ? OR FIND_IN_SET(prd.customer_group_id, ?)) AND prd.quantity <= ?) LEFT JOIN ct_product_discount pd ON pd.product_id = p.product_id AND ((pd.customer_id = ? OR pd.customer_id = 0) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ? OR FIND_IN_SET(pd.customer_group_id, ?)) AND ((pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW())) AND pd.quantity <= ? AND (pd.quantity_end = '' OR pav.available > pd.quantity_end)) WHERE p.product_id = ? ORDER BY prd.quantity DESC, pd.quantity DESC, prd.sort_order ASC, pd.sort_order ASC LIMIT 1; 0|1||1|0|1||1|19588
            [15] => 04:25:14; PREPARED; 0.000619; ModelCatalogProduct; getProductPath; SELECT DISTINCT *, (SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id) AS path FROM ct_product_to_category p2c WHERE p2c.product_id = ? AND p2c.primary_category = 1 AND p2c.store_id = ?; 19588|1
            [16] => 04:25:14; PREPARED; 0.000618; ModelCatalogProduct; getProductVariant; SELECT pv.variant_id, pv.name AS variant_name, p.sku, p.model, p.mpn, p.ean, p.tax_class_id, pav.available, ss.name AS stock_status, ss.in_stock FROM ct_product_variant pv LEFT JOIN ct_product p ON pv.variant_id = p.product_id LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id AND pav.store_id = ? LEFT JOIN ct_stock_status ss ON p.stock_status_id = ss.stock_status_id WHERE pv.product_id = ? AND p.status > 1 AND (p.eol = 0 OR pav.available > 0) AND p.date_available <= CURDATE() ORDER BY pv.sort_order ASC; 1|19588
            [17] => 04:25:14; PREPARED; 0.000445; ModelCatalogProduct; getProductCountries; SELECT DISTINCT ztgz.country_id, c.iso_code_2, c.name FROM ct_product_geo_zone pgz LEFT JOIN ct_zone_to_geo_zone ztgz ON ztgz.geo_zone_id = pgz.geo_zone_id LEFT JOIN ct_country c ON c.country_id = ztgz.country_id WHERE pgz.product_id = ?; 19588
            [18] => 04:25:14; PREPARED; 0.000356; ModelCatalogProduct; getProductCertifications; SELECT pc.*, c.name FROM ct_product_certification pc LEFT JOIN ct_certification c ON c.certification_id = pc.certification_id WHERE pc.product_id = ?; 19588
            [19] => 04:25:14; PREPARED; 0.000621; ModelCatalogProduct; getAllProductUsed; SELECT pu.*, p.name AS name FROM ct_product_used pu LEFT JOIN ct_product p ON p.product_id = pu.product_id LEFT JOIN ct_product_to_category p2c ON p2c.product_id = pu.product_id AND p2c.primary_category = 1 AND p2c.store_id = ? WHERE pu.product_id = ? AND pu.quantity > 0 AND pu.price > 0 AND p2c.category_id IS NOT NULL; 1|19588
            [20] => 04:25:14; PREPARED; 0.000330; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 19588
            [21] => 04:25:14; PREPARED; 0.000308; ModelCatalogProduct; getProductQtyDiscounts; SELECT p.price_rule_id FROM ct_product p WHERE p.product_id = ?; 19588
            [22] => 04:25:14; PREPARED; 0.000723; ModelCatalogProduct; getProductQtyDiscounts; SELECT pd.* FROM ct_product_discount pd LEFT JOIN ct_product p ON p.product_id = pd.product_id LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id AND pav.store_id = 1 WHERE pd.product_id = ? AND (pd.customer_id = 0 OR pd.customer_id = ?) AND (pd.customer_group_id = 0 OR pd.customer_group_id = ?) AND pd.quantity > 1 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_end = '' OR pav.available > pd.quantity_end) ORDER BY pd.sort_order ASC; 19588|0|1
            [23] => 04:25:14; PREPARED; 0.000621; Cart\Cart; getProducts; SELECT c.*, pit.name AS product_inventory_type, pit.name AS type, pit.add_to_stock, pi.quantity AS product_inventory_quantity FROM ct_cart c LEFT JOIN ct_product_inventory pi ON pi.product_inventory_type_id = c.product_inventory_type_id AND pi.product_id = c.product_id LEFT JOIN ct_product_inventory_type pit ON pit.product_inventory_type_id = c.product_inventory_type_id WHERE c.api_id = ? AND c.customer_id = ? AND c.directory_id = ? AND c.session_id = ? ORDER BY c.sort_order ASC; 0|0|0|a31d439315facc9941e8e16e04501003
            [24] => 04:25:14; PREPARED; 0.001788; ModelCheckoutShippingMethod; getMethodsByAddress; SELECT sm.* FROM ct_shipping_method_geo_zone smgz LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = smgz.shipping_method_id LEFT JOIN ct_zone_to_geo_zone z2gz ON z2gz.geo_zone_id = smgz.geo_zone_id LEFT JOIN ct_zone z on z.zone_id = z2gz.zone_id WHERE FIND_IN_SET(?, stores) AND z2gz.country_id = ? AND (z2gz.zone_id = ? OR z2gz.zone_id = '0') AND sm.status = 1 AND sm.type = 'shipping' ORDER BY sm.sort_order ASC; 1|222|11
            [25] => 04:25:14; PREPARED; 0.000382; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
            [26] => 04:25:14; PREPARED; 0.000427; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
            [27] => 04:25:14; PREPARED; 0.000649; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 2|2025-05-09
            [28] => 04:25:14; PREPARED; 0.000381; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
            [29] => 04:25:14; PREPARED; 0.000323; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
            [30] => 04:25:14; PREPARED; 0.000461; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 3|2025-05-08
            [31] => 04:25:14; PREPARED; 0.000381; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
            [32] => 04:25:14; PREPARED; 0.000311; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
            [33] => 04:25:14; PREPARED; 0.000473; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 1|2025-05-07
            [34] => 04:25:14; PREPARED; 0.000315; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
            [35] => 04:25:14; PREPARED; 0.000315; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
            [36] => 04:25:14; PREPARED; 0.000488; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 16|2025-05-07
            [37] => 04:25:14; PREPARED; 0.000340; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
            [38] => 04:25:14; PREPARED; 0.000483; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
            [39] => 04:25:14; PREPARED; 0.000439; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 17|2025-05-07
            [40] => 04:25:14; PREPARED; 0.000297; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
            [41] => 04:25:14; PREPARED; 0.000308; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
            [42] => 04:25:14; PREPARED; 0.000426; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 18|2025-05-07
            [43] => 04:25:14; STANDARD; MEMCACHE; ModelLocalisationCountry; getCountries; SELECT * FROM ct_country WHERE status = '1' ORDER BY name ASC
            [44] => 04:25:14; STANDARD; MEMCACHE; ModelLocalisationZone; getZonesByCountryId; SELECT * FROM ct_zone WHERE country_id = '222' AND status = '1' ORDER BY name
            [45] => 04:25:14; PREPARED; 0.001765; ModelCheckoutShippingMethod; getMethodsByAddress; SELECT sm.* FROM ct_shipping_method_geo_zone smgz LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = smgz.shipping_method_id LEFT JOIN ct_zone_to_geo_zone z2gz ON z2gz.geo_zone_id = smgz.geo_zone_id LEFT JOIN ct_zone z on z.zone_id = z2gz.zone_id WHERE FIND_IN_SET(?, stores) AND z2gz.country_id = ? AND (z2gz.zone_id = ? OR z2gz.zone_id = '0') AND sm.status = 1 AND sm.type = 'shipping' ORDER BY sm.sort_order ASC; 1|222|11
            [46] => 04:25:14; PREPARED; 0.000350; ModelCheckoutOrder; getAddToNextOrders; SELECT DISTINCT o.order_id FROM ct_order_shipping_method osm LEFT JOIN ct_order o ON o.order_id = osm.order_id WHERE osm.type = 'add_to_order' AND o.add_to_order = 0 AND o.customer_id = ? AND o.customer_id != 0 AND o.shipping_postcode = ? AND o.order_status_id IN (?, ?); 0||4|5
            [47] => 04:25:14; PREPARED; 0.000671; Cart\Cart; getProducts; SELECT c.*, pit.name AS product_inventory_type, pit.name AS type, pit.add_to_stock, pi.quantity AS product_inventory_quantity FROM ct_cart c LEFT JOIN ct_product_inventory pi ON pi.product_inventory_type_id = c.product_inventory_type_id AND pi.product_id = c.product_id LEFT JOIN ct_product_inventory_type pit ON pit.product_inventory_type_id = c.product_inventory_type_id WHERE c.api_id = ? AND c.customer_id = ? AND c.directory_id = ? AND c.session_id = ? ORDER BY c.sort_order ASC; 0|0|0|a31d439315facc9941e8e16e04501003
            [48] => 04:25:14; PREPARED; 0.000487; Cart\Cart; getCountries; SELECT DISTINCT ztgz.country_id FROM ct_product_geo_zone pgz LEFT JOIN ct_zone_to_geo_zone ztgz ON ztgz.geo_zone_id = pgz.geo_zone_id WHERE pgz.product_id IN(?); 
            [49] => 04:25:14; PREPARED; 0.000658; Cart\Cart; getProducts; SELECT c.*, pit.name AS product_inventory_type, pit.name AS type, pit.add_to_stock, pi.quantity AS product_inventory_quantity FROM ct_cart c LEFT JOIN ct_product_inventory pi ON pi.product_inventory_type_id = c.product_inventory_type_id AND pi.product_id = c.product_id LEFT JOIN ct_product_inventory_type pit ON pit.product_inventory_type_id = c.product_inventory_type_id WHERE c.api_id = ? AND c.customer_id = ? AND c.directory_id = ? AND c.session_id = ? ORDER BY c.sort_order ASC; 0|0|0|a31d439315facc9941e8e16e04501003
            [50] => 04:25:14; PREPARED; 0.000653; Cart\Cart; getProducts; SELECT c.*, pit.name AS product_inventory_type, pit.name AS type, pit.add_to_stock, pi.quantity AS product_inventory_quantity FROM ct_cart c LEFT JOIN ct_product_inventory pi ON pi.product_inventory_type_id = c.product_inventory_type_id AND pi.product_id = c.product_id LEFT JOIN ct_product_inventory_type pit ON pit.product_inventory_type_id = c.product_inventory_type_id WHERE c.api_id = ? AND c.customer_id = ? AND c.directory_id = ? AND c.session_id = ? ORDER BY c.sort_order ASC; 0|0|0|a31d439315facc9941e8e16e04501003
            [51] => 04:25:14; PREPARED; 0.000388; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
            [52] => 04:25:14; PREPARED; 0.000371; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
            [53] => 04:25:14; PREPARED; 0.000575; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 2|2025-05-09
            [54] => 04:25:14; PREPARED; 0.000443; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
            [55] => 04:25:14; PREPARED; 0.000491; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
            [56] => 04:25:14; PREPARED; 0.000430; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
            [57] => 04:25:14; PREPARED; 0.000781; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 2|2025-05-09
            [58] => 04:25:14; PREPARED; 0.000801; Cart\Cart; getProducts; SELECT c.*, pit.name AS product_inventory_type, pit.name AS type, pit.add_to_stock, pi.quantity AS product_inventory_quantity FROM ct_cart c LEFT JOIN ct_product_inventory pi ON pi.product_inventory_type_id = c.product_inventory_type_id AND pi.product_id = c.product_id LEFT JOIN ct_product_inventory_type pit ON pit.product_inventory_type_id = c.product_inventory_type_id WHERE c.api_id = ? AND c.customer_id = ? AND c.directory_id = ? AND c.session_id = ? ORDER BY c.sort_order ASC; 0|0|0|a31d439315facc9941e8e16e04501003
            [59] => 04:25:14; PREPARED; 0.000656; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
            [60] => 04:25:14; PREPARED; 0.000406; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
            [61] => 04:25:14; PREPARED; 0.000585; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 3|2025-05-08
            [62] => 04:25:14; PREPARED; 0.000380; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
            [63] => 04:25:14; PREPARED; 0.000368; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
            [64] => 04:25:14; PREPARED; 0.000442; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
            [65] => 04:25:14; PREPARED; 0.000518; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 3|2025-05-08
            [66] => 04:25:14; PREPARED; 0.000758; Cart\Cart; getProducts; SELECT c.*, pit.name AS product_inventory_type, pit.name AS type, pit.add_to_stock, pi.quantity AS product_inventory_quantity FROM ct_cart c LEFT JOIN ct_product_inventory pi ON pi.product_inventory_type_id = c.product_inventory_type_id AND pi.product_id = c.product_id LEFT JOIN ct_product_inventory_type pit ON pit.product_inventory_type_id = c.product_inventory_type_id WHERE c.api_id = ? AND c.customer_id = ? AND c.directory_id = ? AND c.session_id = ? ORDER BY c.sort_order ASC; 0|0|0|a31d439315facc9941e8e16e04501003
            [67] => 04:25:14; PREPARED; 0.000387; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
            [68] => 04:25:14; PREPARED; 0.000432; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
            [69] => 04:25:14; PREPARED; 0.000596; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 1|2025-05-07
            [70] => 04:25:14; PREPARED; 0.000397; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
            [71] => 04:25:14; PREPARED; 0.000365; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
            [72] => 04:25:14; PREPARED; 0.000359; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
            [73] => 04:25:14; PREPARED; 0.000530; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 1|2025-05-07
            [74] => 04:25:14; PREPARED; 0.000753; Cart\Cart; getProducts; SELECT c.*, pit.name AS product_inventory_type, pit.name AS type, pit.add_to_stock, pi.quantity AS product_inventory_quantity FROM ct_cart c LEFT JOIN ct_product_inventory pi ON pi.product_inventory_type_id = c.product_inventory_type_id AND pi.product_id = c.product_id LEFT JOIN ct_product_inventory_type pit ON pit.product_inventory_type_id = c.product_inventory_type_id WHERE c.api_id = ? AND c.customer_id = ? AND c.directory_id = ? AND c.session_id = ? ORDER BY c.sort_order ASC; 0|0|0|a31d439315facc9941e8e16e04501003
            [75] => 04:25:14; PREPARED; 0.000362; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
            [76] => 04:25:14; PREPARED; 0.000344; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
            [77] => 04:25:14; PREPARED; 0.000475; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 16|2025-05-07
            [78] => 04:25:14; PREPARED; 0.000364; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
            [79] => 04:25:14; PREPARED; 0.000371; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
            [80] => 04:25:14; PREPARED; 0.000338; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
            [81] => 04:25:14; PREPARED; 0.000508; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 16|2025-05-07
            [82] => 04:25:14; PREPARED; 0.000798; Cart\Cart; getProducts; SELECT c.*, pit.name AS product_inventory_type, pit.name AS type, pit.add_to_stock, pi.quantity AS product_inventory_quantity FROM ct_cart c LEFT JOIN ct_product_inventory pi ON pi.product_inventory_type_id = c.product_inventory_type_id AND pi.product_id = c.product_id LEFT JOIN ct_product_inventory_type pit ON pit.product_inventory_type_id = c.product_inventory_type_id WHERE c.api_id = ? AND c.customer_id = ? AND c.directory_id = ? AND c.session_id = ? ORDER BY c.sort_order ASC; 0|0|0|a31d439315facc9941e8e16e04501003
            [83] => 04:25:14; PREPARED; 0.000374; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
            [84] => 04:25:14; PREPARED; 0.000434; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
            [85] => 04:25:14; PREPARED; 0.000533; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 17|2025-05-07
            [86] => 04:25:14; PREPARED; 0.000457; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
            [87] => 04:25:14; PREPARED; 0.000340; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
            [88] => 04:25:14; PREPARED; 0.000386; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
            [89] => 04:25:14; PREPARED; 0.000445; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 17|2025-05-07
            [90] => 04:25:14; PREPARED; 0.000575; Cart\Cart; getProducts; SELECT c.*, pit.name AS product_inventory_type, pit.name AS type, pit.add_to_stock, pi.quantity AS product_inventory_quantity FROM ct_cart c LEFT JOIN ct_product_inventory pi ON pi.product_inventory_type_id = c.product_inventory_type_id AND pi.product_id = c.product_id LEFT JOIN ct_product_inventory_type pit ON pit.product_inventory_type_id = c.product_inventory_type_id WHERE c.api_id = ? AND c.customer_id = ? AND c.directory_id = ? AND c.session_id = ? ORDER BY c.sort_order ASC; 0|0|0|a31d439315facc9941e8e16e04501003
            [91] => 04:25:14; PREPARED; 0.000305; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
            [92] => 04:25:14; PREPARED; 0.000270; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
            [93] => 04:25:14; PREPARED; 0.000564; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 18|2025-05-07
            [94] => 04:25:14; PREPARED; 0.000284; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
            [95] => 04:25:14; PREPARED; 0.000506; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
            [96] => 04:25:14; PREPARED; 0.000268; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
            [97] => 04:25:14; PREPARED; 0.000363; Cart\Shipping; getTotalShipments; SELECT COUNT(DISTINCT order_id) AS total FROM ct_order_shipping_method osm LEFT JOIN ct_shipping_method sm ON sm.shipping_method_id = osm.shipping_method_id WHERE osm.shipping_method_id = ? AND osm.arrival_date = ?; 18|2025-05-07
            [98] => 04:25:14; PREPARED; 0.000521; Cart\Cart; getProducts; SELECT c.*, pit.name AS product_inventory_type, pit.name AS type, pit.add_to_stock, pi.quantity AS product_inventory_quantity FROM ct_cart c LEFT JOIN ct_product_inventory pi ON pi.product_inventory_type_id = c.product_inventory_type_id AND pi.product_id = c.product_id LEFT JOIN ct_product_inventory_type pit ON pit.product_inventory_type_id = c.product_inventory_type_id WHERE c.api_id = ? AND c.customer_id = ? AND c.directory_id = ? AND c.session_id = ? ORDER BY c.sort_order ASC; 0|0|0|a31d439315facc9941e8e16e04501003
            [99] => 04:25:14; STANDARD; MEMCACHE; ModelCatalogInformation; getInformation; SELECT DISTINCT * FROM ct_information i LEFT JOIN ct_information_description id ON (i.information_id = id.information_id) WHERE i.information_id = 12 AND i.status = 1
            [100] => 04:25:14; PREPARED; 0.000461; ModelCatalogProduct; getProductOnOrder; SELECT ip.inventory_id, s.name AS supplier, (ip.ordered - ip.received) AS ordered, ip.date_due, i.product_inventory_type_id FROM ct_inventory_product ip LEFT JOIN ct_inventory i ON i.inventory_id = ip.inventory_id LEFT JOIN ct_supplier s ON s.supplier_id = i.supplier_id WHERE ip.ordered > ip.received AND ip.product_id = ? AND i.direct = '' ORDER BY ip.date_due ASC; 19588
            [101] => 04:25:14; PREPARED; 0.000381; html; processLinks; SELECT status, parent_id FROM ct_product WHERE product_id = ?; 19578
            [102] => 04:25:14; PREPARED; 0.000485; html; processLinks; SELECT COALESCE((SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id), '') AS path FROM ct_product_to_category p2c WHERE p2c.product_id = ? AND primary_category = 1; 19578
            [103] => 04:25:14; PREPARED; 0.000347; html; processLinks; SELECT status, parent_id FROM ct_product WHERE product_id = ?; 19585
            [104] => 04:25:14; PREPARED; 0.000500; html; processLinks; SELECT COALESCE((SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id), '') AS path FROM ct_product_to_category p2c WHERE p2c.product_id = ? AND primary_category = 1; 19585
            [105] => 04:25:14; PREPARED; 0.000296; html; processLinks; SELECT status, parent_id FROM ct_product WHERE product_id = ?; 19587
            [106] => 04:25:14; PREPARED; 0.000365; html; processLinks; SELECT COALESCE((SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id), '') AS path FROM ct_product_to_category p2c WHERE p2c.product_id = ? AND primary_category = 1; 19587
            [107] => 04:25:14; PREPARED; 0.000285; html; processLinks; SELECT status, parent_id FROM ct_product WHERE product_id = ?; 19586
            [108] => 04:25:14; PREPARED; 0.000449; html; processLinks; SELECT COALESCE((SELECT GROUP_CONCAT(cp.path_id ORDER BY level SEPARATOR '_') FROM ct_category_path cp WHERE cp.category_id = p2c.category_id GROUP BY cp.category_id), '') AS path FROM ct_product_to_category p2c WHERE p2c.product_id = ? AND primary_category = 1; 19586
            [109] => 04:25:14; PREPARED; 0.000890; ModelCatalogProduct; getProductImages; SELECT * FROM ct_product_image WHERE product_id = ? ORDER BY sort_order ASC; 19588
            [110] => 04:25:14; PREPARED; 0.001140; ModelCatalogProduct; getProductAlternatives; SELECT pa.alternative_id FROM ct_product_alternative pa LEFT JOIN ct_product p ON p.product_id = pa.alternative_id LEFT JOIN ct_product_available pav ON pav.product_id = p.product_id AND pav.store_id = ? WHERE pa.product_id = ? AND (p.eol != 1 OR pav.available > 0) AND p.status > 1 ORDER BY p.cost ASC; 1|19588
            [111] => 04:25:14; PREPARED; 0.000822; ModelCatalogProduct; getProductVideos; SELECT name, youtube_id FROM ct_product_video WHERE product_id = ? ORDER BY sort_order ASC; 19588
            [112] => 04:25:14; PREPARED; 0.000663; ModelCatalogVideo; getVideos; SELECT DISTINCT v.* FROM ct_video v LEFT JOIN ct_video_keyword vk ON v.video_id = vk.video_id WHERE 1 AND (LOCATE(vk.keyword, ?) > 0 OR vk.keyword IS NULL) AND (manufacturer_id = ? OR manufacturer_id = 0) ORDER BY v.name ASC; Veracity OUTREACH MAX VOR-ORM-XT External IP & PoE Extender poe powered,cat 5 etxender,cat 6 extender,ethernet expander,distance,200m,ip66,ip67|218
            [113] => 04:25:14; PREPARED; 0.000649; ModelCatalogProduct; getProductFiles; SELECT * FROM ct_product_file WHERE product_id = ? AND online = 1 ORDER BY sort_order ASC; 19588
            [114] => 04:25:14; PREPARED; 0.000362; ModelCatalogProduct; getProductLinks; SELECT text, link FROM ct_product_link WHERE product_id = ? ORDER BY sort_order ASC; 19588
            [115] => 04:25:14; PREPARED; 0.000767; ModelCatalogQuestion; getQuestions; SELECT q.question_id, q.reply_to, q.customer_id, q.author, q.text, q.date_added, c.firstname FROM ct_question q LEFT JOIN ct_customer c ON (c.customer_id = q.customer_id) WHERE q.product_id = ? AND q.status = '1' ORDER BY q.date_added DESC; 19588
            [116] => 04:25:14; PREPARED; 0.001869; ModelCatalogProduct; getProductAddon; SELECT p.*, pa.addon_id, (SELECT GROUP_CONCAT(pv.variant_id SEPARATOR ',') FROM ct_product_variant pv WHERE pv.product_id = p.product_id GROUP BY pv.product_id ORDER BY pv.sort_order) AS variants FROM ct_product_addon pa LEFT JOIN ct_product p ON pa.addon_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_to_category p2c ON p2c.product_id = p.product_id AND p2c.primary_category = 1 AND p2c.store_id = ? WHERE pa.product_id = ? AND p.status > 1 AND p.date_available <= CURDATE() AND (p.eol = 0 OR pav.available > 0) AND p2c.category_id IS NOT NULL ORDER BY pa.sort_order ASC; 1|19588
            [117] => 04:25:14; PREPARED; 0.001516; ModelCatalogProduct; getRelatedProducts; SELECT p2c.product_id FROM ct_product_to_category p2c LEFT JOIN ct_product p ON p.product_id = p2c.product_id WHERE p2c.category_id = (SELECT category_id FROM ct_product_to_category WHERE product_id = ? AND primary_category = 1 AND store_id = ?) AND p2c.product_id != ? AND p2c.store_id = ? AND p2c.primary_category = 1 AND p.eol = 0 AND p.status = 2 LIMIT 10; 19588|1|19588|1
            [118] => 04:25:14; PREPARED; 0.000479; ModelCatalogReview; getProductRating; SELECT COALESCE(AVG(r.rating), 0) AS rating, COUNT(DISTINCT r.review_id) AS reviews FROM ct_review r WHERE r.product_id = ? AND r.status = '1'; 19588
            [119] => 04:25:14; PREPARED; 0.000581; ModelCatalogReview; getReviewsByProductId; SELECT * FROM ct_review WHERE product_id = ? AND status = 1 ORDER BY helpful = 0, (((helpful +1) / (unhelpful +1)) * 100) DESC, helpful DESC, date_added DESC LIMIT 3; 19588
            [120] => 04:25:14; PREPARED; 0.000337; ModelAccountFavourites; getFavourites; SELECT * FROM ct_customer_favourites WHERE customer_id = ?; 0
            [121] => 04:25:14; PREPARED; 0.005657; ModelCatalogProduct; updateViewed; UPDATE ct_product SET viewed = (viewed + 1) WHERE product_id = ?; 19588
            [122] => 04:25:14; PREPARED; 0.000526; Tracking; track; SELECT customer_id FROM ct_customer WHERE tracker = ?; c96a9f17809839411d818f566cb625e718e04f186fab3f5e0c96e4bbe26c36fc
            [123] => 04:25:14; PREPARED; 0.005907; Tracking; track; INSERT INTO ct_tracking SET tracker = ?, ip_address = ?, agent = ?, session_id = ?, customer_id = ?, referer = ?, url = ?, event_label = ?, event_value = ?, date_added = DATE(NOW()), time_added = TIME(NOW()); c96a9f17809839411d818f566cb625e718e04f186fab3f5e0c96e4bbe26c36fc|18.117.166.111|Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])|a31d439315facc9941e8e16e04501003|0||/electrical/power-supplies-psu/poe-power-supplies/veracity-outreach-max-vor-orm-xt-external-ip-and-poe-extender|view_product|19588
            [124] => 04:25:14; PREPARED; 0.000577; ModelCatalogReview; getReviewsByProductId; SELECT * FROM ct_review WHERE product_id = ? AND status = 1 ORDER BY helpful = 0, (((helpful +1) / (unhelpful +1)) * 100) DESC, helpful DESC, date_added DESC LIMIT 1; 19588
            [125] => 04:25:14; PREPARED; MEMCACHE; getHtmlBlock; SELECT * FROM ct_html_block WHERE code = ? AND store_id = ?; why_buy|1
            [126] => 04:25:14; PREPARED; MEMCACHE; getHtmlBlock; SELECT * FROM ct_html_block WHERE code = ? AND store_id = ?; product_qa_text|1
            [127] => 04:25:14; PREPARED; MEMCACHE; getHtmlBlock; SELECT * FROM ct_html_block WHERE code = ? AND store_id = ?; product_review_text|1
            [128] => 04:25:14; PREPARED; MEMCACHE; getHtmlBlock; SELECT * FROM ct_html_block WHERE code = ? AND store_id = ?; product_links_disclaimer|1
        )

    [DUPLIACTES] => Array
(
    [87] => 04:25:14; PREPARED; 0.000340; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
)

    [TOTAL_EXECUTION_TIME] => 0.07205915451
)