Ogłoszenia

(0.3ms) CREATE TABLE IF NOT EXISTS `brazar`.`sessions` ( `session_id` VARCHAR(255), `data` TEXT, `ip` VARCHAR(45), `agen... (0.5ms) SELECT `session_id`,`data`,`ip`,`agent`,`stamp` FROM `sessions` WHERE session_id='2d6ea3b44caff4073023f068aee43f... (1.6ms) INSERT INTO log_activity (user_id, ip_address, url, hour_key, hits) VALUES (NULL, '216.73.216.120', '/o', '2026-... (2.0ms) SELECT COUNT(DISTINCT a.id) as total FROM ads a LEFT JOIN categories c ON a.category_id = c.id LEFT JOIN users u... (2.3ms) SELECT a.*, c.name as category_name, c.slug as category_slug, um_name.mval as user_name, um_verified.mval as is_...

(0.3ms) 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.5ms) SELECT `session_id`,`data`,`ip`,`agent`,`stamp` FROM `sessions` WHERE session_id='2d6ea3b44caff4073023f068aee43fd5' (1.6ms) INSERT INTO log_activity (user_id, ip_address, url, hour_key, hits) VALUES (NULL, '216.73.216.120', '/o', '2026-01-09 00', 1) ON DUPLICATE KEY UPDATE hits = hits + 1, date_added = NOW() (2.0ms) 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 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 ) ) (2.3ms) 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 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