A Single Single Encoder License for the Network Optix Nx Witness video surveillance software, which is designed to work with 99% of IP Network cameras (Read more)
Network Optics NX Witness is a cutting-edge video management
software (VMS) that empowers organizations with robust surveillance
capabilities. Designed with advanced network optics technology, NX
Witness offers a comprehensive and user-friendly solution for
managing and analyzing video feeds from multiple cameras across
diverse locations. This powerful software enables seamless
integration with various IP cameras and devices, allowing for a
unified view of the entire surveillance infrastructure. With its
intuitive interface and intelligent features, NX Witness enables
efficient live monitoring, video playback, and event investigation.
Its scalable architecture ensures flexibility, enabling businesses
of all sizes to tailor their surveillance systems to their specific
needs. Whether it's for security, operations management, or
situational awareness, Network Optics NX Witness stands as a
reliable and versatile software solution for modern video
surveillance needs.
Please note: This is for a Single Encoder License, used for
devices that require an Encoder
Install and Configure in Minutes
Designed to be instantly usable and with no need to worry about
unnecessary prerequisite software, Nx Witness helps you get your IP
surveillance system up and running in minutes.
Connect from Anywhere
The Nx Witness Cloud layer was created specifically for remote
connectivity and management of an unlimited number of Systems from
a single, easy-to-use web-based interface.
Discover 99% of IP Cameras Instantly
With Nx Witness VMS you can automatically discover 99% of IP
cameras on the market today as well as compatible IoT devices so
you can configure new systems quickly.
Search a Year in a Second
Smart Search in Nx Witness allows users to comb through archives
using any combination of motion, events, bookmarks, metadata, and
time.
Connect an unlimited number of systems to a single account for
managed services or large enterprise customers.
Advanced Storage Management
With Nx Witness users can manage local HDDs and NAS devices. See
real-time usage statistics and utilize available space
intelligently.
Engineered to be Secure
Nx Witness VMS undergoes security and QA regression testing
before each release to make sure it uses the latest cyber security
best practices.
Customizable & Extensible
Choose from dozens of integrations to video analytics, access
control, alarm systems, and thousands of thousands of cloud-based
platforms.
SPECIFICATIONS
DESKTOP SPECS
HARDWARE
REQUIREMENTS
MINIMUM SUPPORTED SPECS
HARD DRIVE: HDD/SSD/mSATA
RAM: 2GB
CPU: Quad Core Intel Celeron CPU or higher
GRAPHICS: Intel HD Graphics 3000 w/ OpenGL2.1 support
NETWORKING: 1Gbps NIC
PERFORMANCE SPECS
HARD DRIVE: Performance SSD
RAM: 16 GB RAM
CPU: Intel Core i5
GRAPHICS: NVIDIA GeForce GTX 1050 (OpenGL2.1 support is
required)
NETWORKING: 10 GB NIC
MAXIMUM # OF GRID ITEMS PER
LAYOUT
64 Items (e.g., 64 live streams)
SUPPORTED OPERATING
SYSTEMS
WINDOWS
Windows 7
Windows 8
Windows 8.1
Windows 10
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012 R2
Windows 2016 v1607
Windows 10 Enterprise
UBUNTU LINUX
Ubuntu Linux 16.04 LTS
Ubuntu Linux 18.04 LTS
MAC OS
OSX 10.12
OSX 10.13
OSX 10.14
UNIQUE
CAPABILITIES
DESKTOP MODES
CONNECTED CLIENT: Manage any connected Nx
Witness System
MEDIA PLAYER: View, edit, and export offline videos and
images
VIDEO WALL: Put Nx Desktop into Video Wall mode to control
remotely
UNIQUE FEATURES
MULTILINGUAL SUPPORT: Support for 20+ languages
SHOWREEL: Fully customizable viewing sequences of any GRID
media
CUSTOMIZABLE BRANDING: Customizable Desktop background
DRAG & DROP REASSIGNMENT: Move cameras/streams between
Servers
SEARCH
KEYWORD: Search System Resources using Keywords
FLEX TIMELINE: Search by date / time using calendar or mouse
movements
EVENTS: Quickly search System event log to find event-driven
video
SMART MOTION: Select specific pixels to search a year of archive in
seconds
BOOKMARKS: Create Bookmarks manually or automatically with Rules
Engine
I/O Devices: Status and Triggers
SERVERS: Server Health Monitoring
BUILT-IN BROWSER
BROWSER SUPPORT: Websites, URLs, IP Addresses
SERVER SPECS
COMPATIBLE
HARDWARE
RECOMMENDED BASED ON # OF
STREAMS
STREAMS
RAM
NIC
CPU
Up to 8
1 GB
1 GB
Dual Core
ARM
Up to 16
2 GB
1 GB
Dual Core
Atom
Up to 32
4 GB
1 GB
Dual Core
Celeron
Up to 64
8 GB
1 GB
Core i3
Up to 128
16 GB
1 GB
Core i3
RECOMMENDED MAXIMUMS
# OF STREAMS PER SERVER:
128
# OF SERVERS IN A SERVER HIVE: 100
# OF CLIENTS PER SYSTEM: UNLIMITED
# OF RESOURCES PER SYSTEM: 10,000
# OF USERS IN A SYSTEM: 1000
SUPPORTED OPERATING
SYSTEMS
WINDOWS
Windows 7
Windows 8
Windows 8.1
Windows 10
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012 R2
Windows 2016 v1607
Windows 10 Enterprise
UBUNTU LINUX
Ubuntu Linux 16.04 LTS
Ubuntu Linux 18.04 LTS
ARM DEVICES
Raspberry Pi
Jetson TX1, TX2, XAVIER AGX
* Contact us to learn more about our ARM support
UNIQUE
CAPABILITIES
SERVER HIVE
SYNCHRONIZATION: SERVERS
SYNCHRONIZE SYSTEM DATA IN REAL TIME
FAILOVER: AUTOMATIC CAMERA FAILOVER WHEN SERVER
FAILS
ARCHIVE INTEGRITY
INTEGRITY CHECK: NOTIFICATION WHEN FILES
MANUAL MODIFIED
BACKUP: REAL-TIME (CONCURRENT) OR SCHEDULED
NO PREREQUISITE SOFTWARE REQUIRED
DATABASE: SQLITE + PROPRIETARY ARCHIVE
INDEX
LIGHTWEIGHT: ~75MB INSTALL FILE
STORAGE
LAN / WAN: HDD, SSD, NAS (SAMBA)
STORAGE SDK: INTEGRATE NEW STORAGE MEDIUMS (E.G. FTP,
CLOUD)
SECURITY
USER RIGHTS: LDAP/ACTIVE DIRECTORY
SECURE PASSWORD RECOVERY
TECHNOLOGIES: HTTPS OPEN SSL SALTED MD5 HASH
TSL/SSL
ENCRYPTION: SECURE CONNECTIONS ENCRYPTED
VIDEO
Connect any Nx Witness System to Nx Cloud
for simple remote connectivity from anywhere using Network Optix’s
NAT Traversal and Cloud Data Proxy technology.
MANAGE USERS
Add an unlimited number of users to a single
Nx Cloud System. Share access to your Nx Witness System in seconds
using only email addresses. Create Custom Roles to quickly assign
access to multiple Nx Cloud connected Systems.
UNIQUE
CAPABILITIES
CONNECTIVITY
CLOUD DATA PROXY: Connect via Nx Cloud
to view System data and video
NAT TRAVERSAL (DEFAULT): Connect directly to System via Cloud
addressing
SECURE
COMMUNICATIONS
SECURITY
PASSWORD RECOVERY: Reset password via
email
ENCYRPTED CONNECTIONS: HTTPS, OPENSSL
ENCRYPTED VIDEO: Encrypt video between Client and Server
applications
PASSWORD STORAGE: Complex Multi-Level MD5 Hash
INTERFACE
CLOUD INTERFACE
SYSTEMS: View connected System tiles in Cloud Web
Admin
SETTINGS: View users, rename systems, disconnect
systems
VIEW: View live or recorded video from connected cameras /
streams
VIEW: View live or recorded video from connected cameras /
streams
HIGHEST SPEED (BEST AVAILABLE FRAME
RATE)
BEST QUALITY (BEST AVAILABLE RESOLUTION)
1080p
720p
480p
360p
KEY FEATURES
CONNECT FROM ANYWHERE
LAN / WAN: Connect to Systems using
public IP address or Dynamic DNS
VIA NX CLOUD: Login to Nx Cloud to view all shared
Systems
ADAPTIVE CONNECTIONS: Works well on Wi-Fi or Data (4G / LTE /
3G)
VIEW LIVE OR RECORDED VIDEO
LIVE VIDEO: Connect to Systems using
public IP address or Dynamic DNS
ARCHIVED VIDEO: Login to Nx Cloud to view all shared
Systems
CONTROL CAMERAS
SOFT TRIGGERS: Control soft triggers
on cameras
2 WAY AUDIO: Talk through I/O or IP cameras that support
Audio In / Out
FISHEYE CAMERAS: Universal dewarping for fisheye
cameras
PTZ: Control PTZ cameras with Joystick and/or tap to move
UX
SEARCH
FLEX TIMELINE: Search using the same timeline interaction
as Nx Desktop
LAYOUTS: Control soft triggers on cameras
LIVE THUMBNAILS: Scroll through live thumbnails to find a
camera / view
KEYWORD: Universal dewarping for fisheye cameras
CALENDAR: Control PTZ cameras with Joystick and/or tap to
move UX
SMART MOTION: Search using Smart Motion
* 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
Our technical support team are experienced installation engineers with years of field experience.
SERVICE
Customer service is our top priority. We always try to ensure we offer a first class service too all our customers.
DELIVERY
We offer FREE mainland UK delivery on orders over £75 and FREE next day delivery on orders over £150*.
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.
This site uses cookies for essential website functions. You can choose to enable cookies that help us improve our services and promote relevant content to you.
For more information please see our Privacy Policy.
Array
(
[ALL] => Array
(
[0] => 03:20:25; PREPARED; MEMCACHE; __construct; SELECT * FROM ct_url_alias WHERE store_id = ? OR store_id = 0; 1
[1] => 03:20:25; PREPARED; MEMCACHE; index; SELECT * FROM ct_setting WHERE store_id = 0 OR store_id = ? ORDER BY store_id ASC; 1
[2] => 03:20:25; PREPARED; MEMCACHE; __construct; SELECT * FROM ct_customer_group WHERE customer_group_id = ?; 1
[3] => 03:20:25; 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] => 03:20:25; STANDARD; MEMCACHE; ModelLocalisationCurrency; getCurrencies; SELECT * FROM ct_currency WHERE status = 1 ORDER BY title ASC
[5] => 03:20:25; STANDARD; MEMCACHE; Cart\Currency; __construct; SELECT * FROM ct_currency
[6] => 03:20:25; PREPARED; 0.000742; 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] => 03:20:25; PREPARED; 0.000415; Tracking; getNewTracker; SELECT tracking_id FROM ct_tracking WHERE tracker = ?; ac137b441826b4854a50a02e26c07049573a0b248a50d954ba8cfc987ea2845e
[8] => 03:20:25; PREPARED; MEMCACHE; getRedirect; SELECT * FROM ct_url_redirect WHERE source = ? AND path = ?; security|
[9] => 03:20:25; PREPARED; 0.000282; Url; getRedirect; SELECT * FROM ct_url_redirect WHERE source = ? AND path = ?; security-software|
[10] => 03:20:25; PREPARED; 0.000341; Url; getRedirect; SELECT * FROM ct_url_redirect WHERE source = ? AND path = ?; network-optix-nx-witness|
[11] => 03:20:25; PREPARED; 0.000258; Url; getRedirect; SELECT * FROM ct_url_redirect WHERE source = ? AND path = ?; network-optix-nx-witness-single-encoder-license|
[12] => 03:20:25; PREPARED; 0.003799; 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 = ?; 16801
[13] => 03:20:25; PREPARED; 0.000342; ModelCatalogProduct; getProductKit; SELECT * FROM ct_product_kit WHERE product_id = ?; 16801
[14] => 03:20:25; PREPARED; 0.001470; 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|16801
[15] => 03:20:25; PREPARED; 0.000622; 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 = ?; 16801|1
[16] => 03:20:25; PREPARED; 0.000682; 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|16801
[17] => 03:20:25; PREPARED; 0.000511; 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 = ?; 16801
[18] => 03:20:25; PREPARED; 0.000401; 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 = ?; 16801
[19] => 03:20:25; PREPARED; 0.000583; 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|16801
[20] => 03:20:25; PREPARED; 0.000372; ModelCatalogProduct; getProductOptions; SELECT * FROM ct_product_option WHERE product_id = ? ORDER BY sort_order ASC; 16801
[21] => 03:20:25; PREPARED; 0.000354; ModelCatalogProduct; getProductQtyDiscounts; SELECT p.price_rule_id FROM ct_product p WHERE p.product_id = ?; 16801
[22] => 03:20:25; PREPARED; 0.000649; ModelCatalogProduct; getProductQtyDiscounts; SELECT prd.*, '' AS date_start, '' AS date_end, '' AS quantity_end FROM ct_price_rule_discount prd WHERE prd.price_rule_id = ? AND (prd.customer_id = 0 OR prd.customer_id = ?) AND (prd.customer_group_id = 0 OR prd.customer_group_id = ?) AND prd.quantity > 1 ORDER BY prd.sort_order ASC; 130|0|1
[23] => 03:20:25; PREPARED; 0.000739; 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; 16801|0|1
[24] => 03:20:25; 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|9be2303457c0fe48de2366269d00553d
[25] => 03:20:25; PREPARED; 0.001689; 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
[26] => 03:20:25; PREPARED; 0.000621; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
[27] => 03:20:25; PREPARED; 0.000438; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
[28] => 03:20:25; PREPARED; 0.000718; 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
[29] => 03:20:25; PREPARED; 0.000350; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
[30] => 03:20:25; PREPARED; 0.000305; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
[31] => 03:20:25; PREPARED; 0.000464; 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
[32] => 03:20:25; PREPARED; 0.000357; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
[33] => 03:20:25; PREPARED; 0.000310; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
[34] => 03:20:25; PREPARED; 0.000425; 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
[35] => 03:20:25; PREPARED; 0.000308; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
[36] => 03:20:25; PREPARED; 0.000304; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
[37] => 03:20:25; PREPARED; 0.000394; 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
[38] => 03:20:25; PREPARED; 0.000313; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
[39] => 03:20:25; PREPARED; 0.000312; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
[40] => 03:20:25; PREPARED; 0.000404; 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
[41] => 03:20:25; PREPARED; 0.000327; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
[42] => 03:20:25; PREPARED; 0.000285; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
[43] => 03:20:25; PREPARED; 0.000385; 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
[44] => 03:20:25; STANDARD; MEMCACHE; ModelLocalisationCountry; getCountries; SELECT * FROM ct_country WHERE status = '1' ORDER BY name ASC
[45] => 03:20:25; STANDARD; MEMCACHE; ModelLocalisationZone; getZonesByCountryId; SELECT * FROM ct_zone WHERE country_id = '222' AND status = '1' ORDER BY name
[46] => 03:20:25; PREPARED; 0.001508; 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
[47] => 03:20:25; PREPARED; 0.000402; 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
[48] => 03:20:25; PREPARED; 0.000700; 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|9be2303457c0fe48de2366269d00553d
[49] => 03:20:25; PREPARED; 0.000410; 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(?);
[50] => 03:20:25; PREPARED; 0.000602; 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|9be2303457c0fe48de2366269d00553d
[51] => 03:20:25; PREPARED; 0.000617; 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|9be2303457c0fe48de2366269d00553d
[52] => 03:20:25; PREPARED; 0.000390; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
[53] => 03:20:25; PREPARED; 0.000402; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
[54] => 03:20:25; PREPARED; 0.000559; 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
[55] => 03:20:25; PREPARED; 0.000402; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
[56] => 03:20:25; PREPARED; 0.000286; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
[57] => 03:20:25; PREPARED; 0.000363; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 2
[58] => 03:20:25; PREPARED; 0.000519; 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
[59] => 03:20:25; PREPARED; 0.000687; 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|9be2303457c0fe48de2366269d00553d
[60] => 03:20:25; PREPARED; 0.000340; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
[61] => 03:20:25; PREPARED; 0.000399; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
[62] => 03:20:25; PREPARED; 0.000478; 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
[63] => 03:20:25; PREPARED; 0.000347; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
[64] => 03:20:25; PREPARED; 0.000327; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
[65] => 03:20:25; PREPARED; 0.000335; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 3
[66] => 03:20:25; PREPARED; 0.000496; 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
[67] => 03:20:25; PREPARED; 0.000647; 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|9be2303457c0fe48de2366269d00553d
[68] => 03:20:25; PREPARED; 0.000366; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
[69] => 03:20:25; PREPARED; 0.000339; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
[70] => 03:20:25; PREPARED; 0.000490; 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
[71] => 03:20:25; PREPARED; 0.000381; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
[72] => 03:20:25; PREPARED; 0.000302; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
[73] => 03:20:25; PREPARED; 0.000287; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 1
[74] => 03:20:25; PREPARED; 0.000387; 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
[75] => 03:20:25; PREPARED; 0.000654; 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|9be2303457c0fe48de2366269d00553d
[76] => 03:20:25; PREPARED; 0.000329; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
[77] => 03:20:25; PREPARED; 0.000315; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
[78] => 03:20:25; 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 = ?; 16|2025-05-07
[79] => 03:20:25; PREPARED; 0.000337; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
[80] => 03:20:25; PREPARED; 0.000340; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
[81] => 03:20:25; PREPARED; 0.000385; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 16
[82] => 03:20:25; PREPARED; 0.000416; 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
[83] => 03:20:25; PREPARED; 0.000642; 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|9be2303457c0fe48de2366269d00553d
[84] => 03:20:25; PREPARED; 0.000298; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
[85] => 03:20:25; PREPARED; 0.000343; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
[86] => 03:20:25; PREPARED; 0.000963; 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
[87] => 03:20:25; PREPARED; 0.000303; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
[88] => 03:20:25; PREPARED; 0.000360; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
[89] => 03:20:25; PREPARED; 0.000298; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 17
[90] => 03:20:25; PREPARED; 0.000380; 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
[91] => 03:20:25; PREPARED; 0.000563; 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|9be2303457c0fe48de2366269d00553d
[92] => 03:20:25; PREPARED; 0.000341; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
[93] => 03:20:25; PREPARED; 0.000360; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
[94] => 03:20:25; PREPARED; 0.000540; 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
[95] => 03:20:25; PREPARED; 0.000376; Cart\Shipping; getArrivalDates; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
[96] => 03:20:25; PREPARED; 0.000356; Cart\Shipping; getArrivalDate; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
[97] => 03:20:25; PREPARED; 0.000318; Cart\Shipping; getTotalShipments; SELECT * FROM ct_shipping_method WHERE shipping_method_id = ?; 18
[98] => 03:20:25; PREPARED; 0.000442; 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
[99] => 03:20:25; PREPARED; 0.000694; 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|9be2303457c0fe48de2366269d00553d
[100] => 03:20:25; 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
[101] => 03:20:25; PREPARED; 0.000560; 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; 16801
[102] => 03:20:25; PREPARED; 0.000479; ModelCatalogProduct; getProductImages; SELECT * FROM ct_product_image WHERE product_id = ? ORDER BY sort_order ASC; 16801
[103] => 03:20:25; PREPARED; 0.000495; ModelCatalogProduct; getProductVideos; SELECT name, youtube_id FROM ct_product_video WHERE product_id = ? ORDER BY sort_order ASC; 16801
[104] => 03:20:25; PREPARED; 0.000690; 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; Network Optix Nx Witness Single Encoder License vms,program,application,ivms,programme,app,cctv,security,camera,analytics,software|232
[105] => 03:20:25; PREPARED; 0.000440; ModelCatalogProduct; getProductFiles; SELECT * FROM ct_product_file WHERE product_id = ? AND online = 1 ORDER BY sort_order ASC; 16801
[106] => 03:20:25; PREPARED; 0.000317; ModelCatalogProduct; getProductLinks; SELECT text, link FROM ct_product_link WHERE product_id = ? ORDER BY sort_order ASC; 16801
[107] => 03:20:25; PREPARED; 0.000500; 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; 16801
[108] => 03:20:25; PREPARED; 0.001279; 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|16801
[109] => 03:20:25; PREPARED; 0.001319; 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; 16801|1|16801|1
[110] => 03:20:25; PREPARED; 0.000549; 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'; 16801
[111] => 03:20:25; PREPARED; 0.000477; 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; 16801
[112] => 03:20:25; PREPARED; 0.000389; ModelAccountFavourites; getFavourites; SELECT * FROM ct_customer_favourites WHERE customer_id = ?; 0
[113] => 03:20:25; PREPARED; 0.004862; ModelCatalogProduct; updateViewed; UPDATE ct_product SET viewed = (viewed + 1) WHERE product_id = ?; 16801
[114] => 03:20:25; PREPARED; 0.000877; Tracking; track; SELECT customer_id FROM ct_customer WHERE tracker = ?; ac137b441826b4854a50a02e26c07049573a0b248a50d954ba8cfc987ea2845e
[115] => 03:20:25; PREPARED; 0.007492; 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()); ac137b441826b4854a50a02e26c07049573a0b248a50d954ba8cfc987ea2845e|18.217.95.146|Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])|9be2303457c0fe48de2366269d00553d|0||/security/security-software/network-optix-nx-witness/network-optix-nx-witness-single-encoder-license|view_product|16801
[116] => 03:20:25; PREPARED; 0.000723; 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; 16801
[117] => 03:20:25; PREPARED; MEMCACHE; getHtmlBlock; SELECT * FROM ct_html_block WHERE code = ? AND store_id = ?; why_buy|1
[118] => 03:20:25; PREPARED; MEMCACHE; getHtmlBlock; SELECT * FROM ct_html_block WHERE code = ? AND store_id = ?; product_qa_text|1
[119] => 03:20:25; PREPARED; MEMCACHE; getHtmlBlock; SELECT * FROM ct_html_block WHERE code = ? AND store_id = ?; product_review_text|1
[120] => 03:20:25; PREPARED; MEMCACHE; getHtmlBlock; SELECT * FROM ct_html_block WHERE code = ? AND store_id = ?; product_links_disclaimer|1
)
[DUPLIACTES] => Array
(
)
[TOTAL_EXECUTION_TIME] => 0.06793832779
)
Network Optix
