Mieszkania Warszawa - strona 16

Database queries (Total queries: 166 - Total queries time: 0.15302062034607)

0.0008699893951416	SELECT * FROM (oc_t_preference)
0.00058102607727051	REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00023102760314941	SELECT * FROM ((SELECT a., b., c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order FROM (oc_t_category as a) INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id WHERE b.s_name != '' AND a.b_enabled = 1 ORDER BY locale_order DESC) dummytable) GROUP BY pk_i_id ORDER BY i_position ASC
0.0011060237884521	SELECT * FROM ((SELECT a., b., c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order FROM (oc_t_category as a) INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id WHERE b.s_slug = 'mieszkania' AND b.s_name != '' ORDER BY locale_order DESC) dummytable) GROUP BY pk_i_id ORDER BY i_position ASC
0.0004580020904541	SELECT f.pk_i_id FROM (oc_t_meta_fields f, oc_t_meta_categories c) WHERE ( c.fk_i_category_id = 236 ) AND f.pk_i_id = c.fk_i_field_id AND f.b_searchable = 1
0.00018787384033203	SELECT s_type FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = 'page' LIMIT 1
0.00018095970153809	SELECT s_type FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = 'sCity' LIMIT 1
0.00017094612121582	SELECT s_type FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = 'sShowAs' LIMIT 1
0.00017595291137695	SELECT s_type FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = 'sCategory' LIMIT 1
0.00017595291137695	SELECT s_type FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = 'iPage' LIMIT 1
0.00033307075500488	SELECT s_type FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = 'sOrder' LIMIT 1
0.00028514862060547	SELECT s_type FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = 'iOrderType' LIMIT 1
0.0032010078430176	SELECT oc_t_item.i_price * oc_t_currency.value AS 'Total_price', oc_t_item.*, oc_t_item.s_contact_name as s_user_name, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel FROM (oc_t_item) LEFT JOIN oc_t_currency ON oc_t_item.fk_c_currency_code=oc_t_currency.pk_c_code LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id WHERE 1=1 AND oc_t_item.i_price!=0 AND oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 \|\| oc_t_item.dt_expiration >= '2024-05-18 23:06:30') AND oc_t_item.fk_i_category_id IN (236) AND ( oc_t_item_location.fk_i_city_id = 367478 ) ORDER BY Total_price desc, i_price desc LIMIT 180, 12
0.0019757747650146	SELECT oc_t_item.pk_i_id, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel FROM (oc_t_item) LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 \|\| oc_t_item.dt_expiration >= '2024-05-18 23:06:30') AND oc_t_item.fk_i_category_id IN (236) AND ( oc_t_item_location.fk_i_city_id = 367478 ) ORDER BY i_price desc LIMIT 1200000
0.0059769153594971	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '965'
0.00059604644775391	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '965' AND s.fk_i_item_id = '965' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00035691261291504	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '552'
0.00057601928710938	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '552' AND s.fk_i_item_id = '552' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.0003349781036377	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '956'
0.00054597854614258	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '956' AND s.fk_i_item_id = '956' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00036811828613281	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '953'
0.00057411193847656	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '953' AND s.fk_i_item_id = '953' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00037598609924316	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '528'
0.00057411193847656	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '528' AND s.fk_i_item_id = '528' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00031805038452148	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '526'
0.00057792663574219	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '526' AND s.fk_i_item_id = '526' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00036501884460449	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '902'
0.00057411193847656	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '902' AND s.fk_i_item_id = '902' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00039887428283691	SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug FROM (oc_t_city) WHERE pk_i_id = '367478'
0.00026798248291016	SELECT * FROM (oc_t_locale) WHERE b_enabled = 1 ORDER BY s_name ASC
0.00026798248291016	SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug FROM (oc_t_city) WHERE pk_i_id = '367478'
0.00024795532226562	SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_group_5'
0.00072908401489258	SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind" FROM (oc_t_banner b, oc_t_banner_group g) WHERE g.b_banner_id = b.b_id AND g.b_id = 5 ORDER BY rand_ind asc
0.0002439022064209	SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_5'
0.00036907196044922	SELECT * FROM (oc_t_banner) WHERE b_id = '5'
0.0010509490966797	UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00090909004211426	SELECT * FROM ((SELECT a., b., c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order FROM (oc_t_category as a) INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id WHERE fk_i_parent_id = 236 AND a.b_enabled = '1' AND b.s_name != '' ORDER BY locale_order DESC) dummytable) GROUP BY pk_i_id ORDER BY i_position ASC
0.00023102760314941	SELECT oc_t_country_stats.fk_c_country_code as country_code, oc_t_country_stats.i_num_items as items, oc_t_country.s_name as country_name, oc_t_country.s_slug as country_slug FROM (oc_t_country_stats) JOIN oc_t_country ON oc_t_country_stats.fk_c_country_code = oc_t_country.pk_c_code WHERE i_num_items > 0 ORDER BY country_name ASC
0.00022196769714355	SELECT STRAIGHT_JOIN oc_t_region_stats.fk_i_region_id as region_id, oc_t_region_stats.i_num_items as items, oc_t_region.s_name as region_name, oc_t_region.s_slug as region_slug FROM (oc_t_region , oc_t_region_stats) WHERE oc_t_region_stats.fk_i_region_id = oc_t_region.pk_i_id AND i_num_items > 0 ORDER BY region_name ASC
0.00031185150146484	SELECT oc_t_city_stats.fk_i_city_id as city_id, oc_t_city_stats.i_num_items as items, oc_t_city.s_name as city_name, oc_t_city.s_slug as city_slug FROM (oc_t_city_stats) LEFT JOIN oc_t_city ON oc_t_city_stats.fk_i_city_id = oc_t_city.pk_i_id WHERE i_num_items > 0 ORDER BY city_name ASC
0.00024795532226562	SELECT * FROM ((SELECT a., b., c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order FROM (oc_t_category as a) INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id WHERE fk_i_parent_id = 236 AND a.b_enabled = '1' AND b.s_name != '' ORDER BY locale_order DESC) dummytable) GROUP BY pk_i_id ORDER BY i_position ASC
0.00034117698669434	SELECT oc_t_country_stats.fk_c_country_code as country_code, oc_t_country_stats.i_num_items as items, oc_t_country.s_name as country_name, oc_t_country.s_slug as country_slug FROM (oc_t_country_stats) JOIN oc_t_country ON oc_t_country_stats.fk_c_country_code = oc_t_country.pk_c_code WHERE i_num_items > 0 ORDER BY country_name ASC
0.00060200691223145	SELECT mf.* FROM (oc_t_meta_fields mf, oc_t_meta_categories mc) WHERE mc.fk_i_category_id = '236' AND mf.pk_i_id = mc.fk_i_field_id
0.00039982795715332	SELECT COUNT(*) AS numrows FROM (oc_t_plugin_category) WHERE fk_i_category_id = '236' AND s_plugin_name = 'custom_attributes'
0.00057101249694824	SELECT * FROM (oc_t_item_custom_attr_groups) JOIN oc_t_item_custom_attr_categories ON fk_i_group_id = pk_i_id WHERE fk_i_category_id = '236' ORDER BY oc_t_item_custom_attr_groups.order ASC
0.00026392936706543	SELECT fk_i_field_id FROM (oc_t_item_custom_attr_meta)
0.00022792816162109	SELECT * FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id NOT IN ('3', '4', '5', '61', '120', '202', '8', '9', '10', '11', '12', '13', '21', '99', '14', '15', '17', '18', '20', '28', '29', '30', '31', '32', '33', '34', '35', '83', '84', '123', '125', '129', '184', '185', '186', '188', '192', '217', '219', '221', '222', '223', '36', '37', '38', '39', '41', '42', '43', '44', '45', '46', '47', '50', '51', '52', '53', '91', '98', '124', '130', '216', '218', '57', '58', '59', '60', '85', '121', '122', '147', '62', '63', '64', '65', '66', '67', '126', '70', '71', '78', '79', '80', '81', '82', '93', '94', '95', '97', '77', '86', '87', '89', '90', '159', '160', '161', '105', '107', '115', '131', '165', '109', '110', '112', '113', '114', '162', '206', '233', '116', '117', '118', '119', '195', '196', '197', '200', '128', '133', '134', '136', '137', '138', '139', '140', '141', '142', '143', '144', '151', '152', '153', '154', '155', '156', '157', '158', '163', '164', '235', '236', '237', '238', '171', '173', '174', '175', '203', '205', '224', '178', '181', '176', '187', '193', '194', '198', '199', '234', '207', '208', '209', '210', '211', '212', '213', '214', '215', '225', '226', '227', '228', '229', '230', '231') ORDER BY i_order ASC
0.00071191787719727	SELECT * FROM (oc_t_item_custom_attr_fields) JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id WHERE fk_i_group_id = '26' ORDER BY i_order ASC
0.00023913383483887	SELECT * FROM (oc_t_item_custom_attr_fields) JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id WHERE fk_i_group_id = '1' ORDER BY i_order ASC
0.00021910667419434	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '120' LIMIT 1
0.00017809867858887	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '5' LIMIT 1
0.00017786026000977	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '4' LIMIT 1
0.00018191337585449	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '202' LIMIT 1
0.00082588195800781	SELECT * FROM (oc_t_item_custom_attr_fields) JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id WHERE fk_i_group_id = '4' ORDER BY i_order ASC
0.00031399726867676	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '32' LIMIT 1
0.00026702880859375	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '31' LIMIT 1
0.00028514862060547	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '28' LIMIT 1
0.00025606155395508	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '125' LIMIT 1
0.00025796890258789	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '223' LIMIT 1
0.0002439022064209	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '188' LIMIT 1
0.00024509429931641	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '83' LIMIT 1
0.00035881996154785	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '129' LIMIT 1
0.00027012825012207	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '84' LIMIT 1
0.00028705596923828	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '192' LIMIT 1
0.00028109550476074	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '221' LIMIT 1
0.00028896331787109	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '222' LIMIT 1
0.00028300285339355	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '35' LIMIT 1
0.00027799606323242	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '123' LIMIT 1
0.00029516220092773	SELECT s_options FROM (oc_t_item_custom_attr_fields) WHERE pk_i_id = '217' LIMIT 1
0.00017809867858887	SELECT * FROM (oc_t_item_custom_attr_fields) JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id WHERE fk_i_group_id = '6' ORDER BY i_order ASC
0.00013995170593262	SELECT * FROM (oc_t_item_custom_attr_fields) JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id WHERE fk_i_group_id = '14' ORDER BY i_order ASC
0.00013613700866699	SELECT * FROM (oc_t_item_custom_attr_fields) JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id WHERE fk_i_group_id = '3' ORDER BY i_order ASC
0.00019598007202148	SELECT * FROM (oc_t_item_custom_attr_fields) JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id WHERE fk_i_group_id = '10' ORDER BY s_label ASC
0.049503087997437	SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name FROM (oc_t_item, oc_t_item_stats) LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id WHERE oc_t_item_stats.fk_i_item_id = oc_t_item.pk_i_id AND oc_t_item.b_premium = 1 AND oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND ( oc_t_item_location.fk_i_city_id = 367478 ) AND oc_t_item.fk_i_category_id IN (236) GROUP BY oc_t_item.pk_i_id ORDER BY SUM(oc_t_item_stats.i_num_premium_views) ASC, RAND() LIMIT 0, 9
0.0013790130615234	INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (297, '2024-05-18 23:06:30',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0006258487701416	INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (305, '2024-05-18 23:06:30',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0005180835723877	INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (300, '2024-05-18 23:06:30',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00049614906311035	INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (292, '2024-05-18 23:06:30',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00039505958557129	INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (277, '2024-05-18 23:06:30',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00099611282348633	INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (295, '2024-05-18 23:06:30',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00058889389038086	INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (294, '2024-05-18 23:06:30',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00060296058654785	INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (298, '2024-05-18 23:06:30',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00048685073852539	INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (293, '2024-05-18 23:06:30',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0005040168762207	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '297'
0.0031058788299561	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '297' AND s.fk_i_item_id = '297' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00027108192443848	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '305'
0.0030109882354736	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '305' AND s.fk_i_item_id = '305' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00040102005004883	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '300'
0.0030438899993896	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '300' AND s.fk_i_item_id = '300' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00040411949157715	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '292'
0.0030691623687744	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '292' AND s.fk_i_item_id = '292' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00040698051452637	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '277'
0.003061056137085	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '277' AND s.fk_i_item_id = '277' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00038504600524902	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '295'
0.0030200481414795	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '295' AND s.fk_i_item_id = '295' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00038814544677734	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '294'
0.0029878616333008	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '294' AND s.fk_i_item_id = '294' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00034403800964355	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '298'
0.0029549598693848	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '298' AND s.fk_i_item_id = '298' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00034284591674805	SELECT * FROM (oc_t_item_description) WHERE oc_t_item_description.fk_i_item_id = '293'
0.0030660629272461	SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views` FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s) WHERE oc_t_item_location.fk_i_item_id = '293' AND s.fk_i_item_id = '293' AND cd.fk_i_category_id = '236' GROUP BY fk_i_item_id
0.00033783912658691	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 297 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.0004270076751709	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 297
0.0002439022064209	SELECT pk_c_code, s_name, s_description, b_enabled FROM (oc_t_currency) WHERE pk_c_code = 'PLN'
0.00055789947509766	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=297
0.00035595893859863	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 305 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00043606758117676	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 305
0.00056719779968262	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=305
0.00034809112548828	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 300 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00037312507629395	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 300
0.00052785873413086	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=300
0.0003359317779541	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 292 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00040102005004883	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 292
0.00052905082702637	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=292
0.00034713745117188	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 277 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00036811828613281	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 277
0.00051498413085938	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=277
0.00032210350036621	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 295 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00040698051452637	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 295
0.0004878044128418	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=295
0.00034093856811523	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 294 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00041294097900391	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 294
0.00048398971557617	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=294
0.00034499168395996	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 298 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00037813186645508	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 298
0.00051307678222656	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=298
0.00031805038452148	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 293 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00038599967956543	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 293
0.00058579444885254	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=293
0.00034403800964355	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 965 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00047183036804199	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 965
0.00089883804321289	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=965
0.00035405158996582	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 552 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00044107437133789	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 552
0.00059890747070312	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=552
0.00033998489379883	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 956 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00045394897460938	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 956
0.00081801414489746	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=956
0.00032305717468262	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 953 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00036811828613281	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 953
0.000762939453125	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=953
0.00034308433532715	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 528 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.00045895576477051	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 528
0.00066089630126953	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=528
0.00035309791564941	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 526 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.0004432201385498	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 526
0.0005800724029541	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=526
0.00033283233642578	SELECT * FROM (oc_t_payment_pro_highlight) WHERE fk_i_item_id = 902 AND dt_expiration_date >= '2024-05-18 23:06:30'
0.0003819465637207	SELECT * FROM (oc_t_item_resource) WHERE fk_i_item_id = 902
0.00080204010009766	SELECT * FROM (oc_t_item) JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3 WHERE oc_t_item.pk_i_id=902
0.00022077560424805	SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00057697296142578	SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind" FROM (oc_t_banner b, oc_t_banner_group g) WHERE g.b_banner_id = b.b_id AND g.b_id = 2 ORDER BY rand_ind asc
0.0002129077911377	SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_2'
0.0003809928894043	SELECT * FROM (oc_t_banner) WHERE b_id = '2'
0.0011110305786133	UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00021195411682129	SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00056099891662598	SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind" FROM (oc_t_banner b, oc_t_banner_group g) WHERE g.b_banner_id = b.b_id AND g.b_id = 3 ORDER BY rand_ind asc
0.00021195411682129	SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_3'
0.00037312507629395	SELECT * FROM (oc_t_banner) WHERE b_id = '3'
0.00091814994812012	UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00020813941955566	SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00059390068054199	SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind" FROM (oc_t_banner b, oc_t_banner_group g) WHERE g.b_banner_id = b.b_id AND g.b_id = 4 ORDER BY rand_ind asc
0.00021505355834961	SELECT fk_i_category_id FROM (oc_t_plugin_category) WHERE s_plugin_name = 'ads_manager_banner_4'
0.00036120414733887	SELECT * FROM (oc_t_banner) WHERE b_id = '4'
0.00076007843017578	UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00021505355834961	SELECT * FROM (oc_t_pages) WHERE b_indelible = 0 AND b_link = 1 ORDER BY i_order ASC

Mieszkania Warszawa - strona 16

Wyszukiwanie zaawansowane

Informacje o ogłoszeniu

Przeznaczenie lokalu

Rynek

Ilość m2

Rodzaj ogłoszenia

Ogłoszeniodawca

Informacje o budynku

Typ budynku

Stan mieszkania

Forma własności

Dostępność od:

Liczba pokoi

Liczba łazienek

Ilość poziomów

Wysokość pomieszczeń

Umeblowanie

Okna

Balkon

Materiał

Ogrzewanie

Komórka lokatorska

Przyjazne zwierzętom

Palący

Piwnica

Garaż/Miejsce parkingowe

Dojazd

Położenie

Media i kanalizacja

siła

internet

telefon

Udogodnienia

Kuchenka

Mikrofalówka

Lodówka

Pralka

Zmywarka

Piekarnik

Telewizor

Meble

Informacje dodatkowe

witryna

parking

winda

klimatyzacja

umeblowanie

Zabezpieczenia

monitoring

ochrona

okna/drzwi antywłamaniowe

teren zamknięty

194 ogłoszeń z kategorii: Mieszkania Warszawa

Ilość m²