Optyka

(0.2ms) CREATE TABLE IF NOT EXISTS `brazar`.`sessions` ( `session_id` VARCHAR(255), `data` TEXT, `ip` VARCHAR(45), `agen... (0.4ms) SELECT `session_id`,`data`,`ip`,`agent`,`stamp` FROM `sessions` WHERE session_id='eb7673477dc630e36a296657868f3b... (1.3ms) INSERT INTO log_activity (user_id, ip_address, url, hour_key, hits) VALUES (NULL, '216.73.216.120', '/o/k/optyka... (0.3ms) SELECT id, parent_id, slug, name, icon, status, position, date_added FROM categories WHERE status < 99 (0.4ms) SELECT ca.category_id, a.id AS attribute_id, a.slug AS attribute_slug, a.name AS attribute_name, a.type AS attri... (0.2ms) SELECT ao.attribute_id, ao.id AS option_id, ao.slug AS option_slug, ao.value AS option_value, ao.position FROM a... (0.6ms) SELECT COUNT(DISTINCT a.id) as total FROM ads a LEFT JOIN categories c ON a.category_id = c.id LEFT JOIN users u... (0.8ms) SELECT a.*, c.name as category_name, c.slug as category_slug, um_name.mval as user_name, um_verified.mval as is_...

(0.2ms) CREATE TABLE IF NOT EXISTS `brazar`.`sessions` ( `session_id` VARCHAR(255), `data` TEXT, `ip` VARCHAR(45), `agent` VARCHAR(300), `stamp` INTEGER, PRIMARY KEY (`session_id`) ); (0.4ms) SELECT `session_id`,`data`,`ip`,`agent`,`stamp` FROM `sessions` WHERE session_id='eb7673477dc630e36a296657868f3bac' (1.3ms) INSERT INTO log_activity (user_id, ip_address, url, hour_key, hits) VALUES (NULL, '216.73.216.120', '/o/k/optyka', '2026-01-09 00', 1) ON DUPLICATE KEY UPDATE hits = hits + 1, date_added = NOW() (0.3ms) SELECT id, parent_id, slug, name, icon, status, position, date_added FROM categories WHERE status < 99 (0.4ms) SELECT ca.category_id, a.id AS attribute_id, a.slug AS attribute_slug, a.name AS attribute_name, a.type AS attribute_type, a.unit, a.position AS attribute_position, ca.is_required, ca.is_filterable, ca.position AS category_position FROM category_attributes ca JOIN attributes a ON ca.attribute_id = a.id ORDER BY ca.category_id, ca.position, a.position (0.2ms) SELECT ao.attribute_id, ao.id AS option_id, ao.slug AS option_slug, ao.value AS option_value, ao.position FROM attribute_options ao ORDER BY ao.attribute_id, ao.position (0.6ms) SELECT COUNT(DISTINCT a.id) as total FROM ads a LEFT JOIN categories c ON a.category_id = c.id LEFT JOIN users u ON a.user_id = u.id LEFT JOIN user_meta um_verified ON u.id = um_verified.user_id AND um_verified.mkey = 'is_verified_member' LEFT JOIN ad_meta am_postcode ON a.id = am_postcode.ad_id AND am_postcode.mkey = 'postcode' WHERE a.status = "active" AND (a.category_id = 3 OR c.parent_id = 3) AND NOT EXISTS ( SELECT 1 FROM global_blacklist gb WHERE gb.user_id = a.user_id AND NOT EXISTS ( SELECT 1 FROM global_whitelist_exceptions gwe WHERE gwe.blacklist_id = gb.id AND gwe.category_id = a.category_id ) ) (0.8ms) SELECT a.*, c.name as category_name, c.slug as category_slug, um_name.mval as user_name, um_verified.mval as is_verified_member, am_city.mval as city, am_postcode.mval as postcode, (SELECT filename FROM ad_images WHERE ad_id = a.id ORDER BY id LIMIT 1) as main_image FROM ads a LEFT JOIN categories c ON a.category_id = c.id LEFT JOIN users u ON a.user_id = u.id LEFT JOIN user_meta um_name ON u.id = um_name.user_id AND um_name.mkey = 'name' LEFT JOIN user_meta um_verified ON u.id = um_verified.user_id AND um_verified.mkey = 'is_verified_member' LEFT JOIN ad_meta am_city ON a.id = am_city.ad_id AND am_city.mkey = 'city' LEFT JOIN ad_meta am_postcode ON a.id = am_postcode.ad_id AND am_postcode.mkey = 'postcode' WHERE a.status = "active" AND (a.category_id = 3 OR c.parent_id = 3) AND NOT EXISTS ( SELECT 1 FROM global_blacklist gb WHERE gb.user_id = a.user_id AND NOT EXISTS ( SELECT 1 FROM global_whitelist_exceptions gwe WHERE gwe.blacklist_id = gb.id AND gwe.category_id = a.category_id ) ) ORDER BY a.date_added DESC LIMIT 20 OFFSET 0