Hotel 860,04 m2, Baranówek

Lokale użytkowe Kielce, świętokrzyskie, Polska
10 000 000 PLN brutto 8 130 081 PLN netto  
10 000 000 PLN brutto 8 130 081 PLN netto
  • 0

Pochodzenie oferty

Region świętokrzyskie
Miasto Kielce

Informacje o ogłoszeniu

Rynek Wtórny
Ilość m2 860.04
Rodzaj ogłoszenia Na sprzedaż

Informacje o budynku

Stan budynku bardzo dobry
Typ budynku wolnostojący
Garaż/Miejsce parkingowe Parking
Dojazd asfalt

Media

internet Tak
kanalizacja Tak
prąd Tak
telefon Tak
woda Tak
gaz Tak

Opis

Do sprzedaży obiekt restauracyjno- hotelowy położony w cichej i zielonej okolicy na przedmieściach Kielc, na obrzeżach rezerwatu przyrody Biesak - Białogon. W pobliżu stok narciarski, park linowy, ścieżki zdrowia, szlaki rowerowe i konne. Do centrum miasta 2km.

Kompleks o pow. 860,04 m2 usytuowany jest na działce o pow. 7269 m2.

Na obiekt składają się dwa budynki.

W pierwszym budynku znajdują się trzy sale restauracyjne, kuchnia, osiem pokoi, apartament z osobnym wejściem, trzy toalety, magazyny oraz taras.

W skład drugiego budynku wchodzi piwnica oraz parter. W piwnicy znajduje się sala restauracyjna, bar, jacuzzi oraz toaleta. Na parterze budynku znajduje się recepcja, trzy sale, sześć pokoi, kuchnia, zmywak, toalety, magazyny oraz powierzchnia biurowa. Pomieszczenia są klimatyzowane.

Do obiektu przynależy kaplica, cztery altany, grillbar, park linowy, plac zabaw, garaż, magazyn kontenerowy oraz murowane toalety.

Teren wokół budynku oraz alejki wyłożone są kostką granitową.

Dane kontaktowe do agenta: Szymon Dąbrowski tel: 608-827-080

  Database queries (Total queries: 182 - Total queries time: 0.12871265411377)  
0.0022988319396973 SELECT *
FROM (oc_t_preference)
0.00082588195800781 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00026392936706543 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0013887882232666 SELECT l.*, i.*, SUM(s.i_num_views) AS i_num_views
FROM (oc_t_item i)
LEFT JOIN oc_t_item_location l ON l.fk_i_item_id = i.pk_i_id
LEFT JOIN oc_t_item_stats s ON i.pk_i_id = s.fk_i_item_id
WHERE i.pk_i_id = '692'
GROUP BY s.fk_i_item_id
0.00066995620727539 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '692'
0.0016930103302002 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (692, '2025-08-05 20:02:05',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.00020194053649902 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '33'
0.00014901161193848 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.0002131462097168 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.00021886825561523 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 692
0.00034308433532715 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00033402442932129 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 = '380086'
0.00024604797363281 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781814'
0.00026702880859375 SELECT *
FROM (oc_t_region)
WHERE s_name = 'świętokrzyskie'
LIMIT 1
0.00027704238891602 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE s_name = 'Kielce'
LIMIT 1
0.00032711029052734 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 = 'lokale-uzytkowe'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.0002129077911377 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE s_name = 'Kielce'
LIMIT 1
0.00031781196594238 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 33
0.0001678466796875 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.00029611587524414 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 33
0.00017809867858887 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.00026988983154297 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.0023620128631592 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 = 6
ORDER BY rand_ind asc
0.00022220611572266 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.00079703330993652 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.0017249584197998 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00021696090698242 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 239
AND s_plugin_name = 'custom_attributes'
0.00025010108947754 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 = 239
ORDER BY oc_t_item_custom_attr_groups.order ASC
0.00031805038452148 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00030994415283203 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.00025105476379395 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 = '28'
ORDER BY i_order ASC
0.00089001655578613 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '207'
LIMIT 1
0.00022602081298828 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.001039981842041 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '120'
LIMIT 1
0.0013668537139893 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '5'
LIMIT 1
0.0010390281677246 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '3'
LIMIT 1
0.0013389587402344 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '61'
LIMIT 1
0.0010650157928467 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '4'
LIMIT 1
0.00094485282897949 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '202'
LIMIT 1
0.0001981258392334 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '120'
LIMIT 1
0.00017905235290527 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '5'
LIMIT 1
0.00018000602722168 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '3'
LIMIT 1
0.00021481513977051 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '61'
LIMIT 1
0.00021505355834961 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '4'
LIMIT 1
0.0001988410949707 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '202'
LIMIT 1
0.00017714500427246 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 = '7'
ORDER BY i_order ASC
0.0011539459228516 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '64'
LIMIT 1
0.00089406967163086 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '65'
LIMIT 1
0.0010290145874023 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '66'
LIMIT 1
0.00088810920715332 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '62'
LIMIT 1
0.00099587440490723 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '63'
LIMIT 1
0.00097298622131348 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '67'
LIMIT 1
0.00094079971313477 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '126'
LIMIT 1
0.00024509429931641 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '64'
LIMIT 1
0.00022602081298828 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '65'
LIMIT 1
0.00022602081298828 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '66'
LIMIT 1
0.00021815299987793 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '62'
LIMIT 1
0.00022006034851074 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '63'
LIMIT 1
0.00016903877258301 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '67'
LIMIT 1
0.0002589225769043 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '126'
LIMIT 1
0.00024294853210449 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.0010321140289307 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '116'
LIMIT 1
0.001025915145874 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '117'
LIMIT 1
0.0010931491851807 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '118'
LIMIT 1
0.0010490417480469 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '119'
LIMIT 1
0.0010221004486084 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '195'
LIMIT 1
0.0010178089141846 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '196'
LIMIT 1
0.0010249614715576 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '197'
LIMIT 1
0.0010380744934082 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '200'
LIMIT 1
0.00029110908508301 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.0016849040985107 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '14'
LIMIT 1
0.0015218257904053 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '15'
LIMIT 1
0.0015659332275391 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '17'
LIMIT 1
0.0015039443969727 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '18'
LIMIT 1
0.0014958381652832 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '20'
LIMIT 1
0.00027894973754883 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 = '9'
ORDER BY i_order ASC
0.0013151168823242 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '78'
LIMIT 1
0.0012848377227783 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '79'
LIMIT 1
0.0012469291687012 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '80'
LIMIT 1
0.0012619495391846 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '81'
LIMIT 1
0.001291036605835 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '82'
LIMIT 1
0.0012650489807129 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '93'
LIMIT 1
0.0012052059173584 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '94'
LIMIT 1
0.0013101100921631 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '95'
LIMIT 1
0.0013229846954346 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '97'
LIMIT 1
0.00022697448730469 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '78'
LIMIT 1
0.00021696090698242 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '79'
LIMIT 1
0.00021004676818848 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '80'
LIMIT 1
0.0002131462097168 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '81'
LIMIT 1
0.00020217895507812 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '82'
LIMIT 1
0.00022006034851074 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '93'
LIMIT 1
0.00019288063049316 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '94'
LIMIT 1
0.00018692016601562 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '95'
LIMIT 1
0.00018501281738281 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '97'
LIMIT 1
0.00023818016052246 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.0013968944549561 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '77'
LIMIT 1
0.00094199180603027 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '159'
LIMIT 1
0.0010099411010742 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '87'
LIMIT 1
0.0010159015655518 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '86'
LIMIT 1
0.00098919868469238 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '90'
LIMIT 1
0.00081992149353027 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '161'
LIMIT 1
0.0010859966278076 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '89'
LIMIT 1
0.00075721740722656 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '160'
LIMIT 1
0.00020003318786621 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 = '16'
ORDER BY i_order ASC
0.00091791152954102 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '133'
LIMIT 1
0.00075078010559082 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '134'
LIMIT 1
0.00073599815368652 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '136'
LIMIT 1
0.0006709098815918 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '137'
LIMIT 1
0.00090193748474121 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '138'
LIMIT 1
0.00075411796569824 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '139'
LIMIT 1
0.00082802772521973 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '140'
LIMIT 1
0.0009000301361084 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '141'
LIMIT 1
0.0011789798736572 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 692
AND fk_i_field_id = '142'
LIMIT 1
0.0021300315856934 SELECT 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_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 >= '2025-08-05 20:02:06') AND oc_t_item.pk_i_id < 692
AND oc_t_item.fk_i_category_id IN (239)
AND ( oc_t_item_location.s_region LIKE 'świętokrzyskie' )
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.0015361309051514 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 >= '2025-08-05 20:02:06') AND oc_t_item.pk_i_id < 692
AND oc_t_item.fk_i_category_id IN (239)
AND ( oc_t_item_location.s_region LIKE 'świętokrzyskie' )
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00027298927307129 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '525'
0.0011370182037354 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 = '525'
AND s.fk_i_item_id = '525'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00022006034851074 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '353'
0.0011429786682129 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 = '353'
AND s.fk_i_item_id = '353'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.001539945602417 SELECT 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_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 >= '2025-08-05 20:02:06') AND oc_t_item.pk_i_id != 692
AND oc_t_item.fk_i_category_id IN (239)
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.0020570755004883 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 >= '2025-08-05 20:02:06') AND oc_t_item.pk_i_id != 692
AND oc_t_item.fk_i_category_id IN (239)
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00030422210693359 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '385'
0.0017759799957275 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 = '385'
AND s.fk_i_item_id = '385'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00022292137145996 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1160'
0.0012750625610352 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 = '1160'
AND s.fk_i_item_id = '1160'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00019192695617676 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1159'
0.0010619163513184 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 = '1159'
AND s.fk_i_item_id = '1159'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00016617774963379 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1158'
0.0013589859008789 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 = '1158'
AND s.fk_i_item_id = '1158'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00023698806762695 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1157'
0.0012080669403076 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 = '1157'
AND s.fk_i_item_id = '1157'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00019001960754395 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1156'
0.0011491775512695 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 = '1156'
AND s.fk_i_item_id = '1156'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00031495094299316 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1138'
0.0014760494232178 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 = '1138'
AND s.fk_i_item_id = '1138'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00021100044250488 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1137'
0.0011899471282959 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 = '1137'
AND s.fk_i_item_id = '1137'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00018215179443359 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1136'
0.0011389255523682 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 = '1136'
AND s.fk_i_item_id = '1136'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00066685676574707 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 385
AND dt_expiration_date >= '2025-08-05 20:02:06'
0.00025701522827148 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 385
0.00027298927307129 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=385
0.00064802169799805 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1160
AND dt_expiration_date >= '2025-08-05 20:02:06'
0.00030303001403809 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1160
0.00028896331787109 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=1160
0.00067305564880371 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1159
AND dt_expiration_date >= '2025-08-05 20:02:06'
0.00020480155944824 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1159
0.00037503242492676 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=1159
0.00094699859619141 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1158
AND dt_expiration_date >= '2025-08-05 20:02:06'
0.00024104118347168 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1158
0.00025606155395508 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=1158
0.00070595741271973 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1157
AND dt_expiration_date >= '2025-08-05 20:02:06'
0.00026297569274902 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1157
0.00026917457580566 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=1157
0.00067806243896484 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1156
AND dt_expiration_date >= '2025-08-05 20:02:06'
0.00024914741516113 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1156
0.00025701522827148 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=1156
0.00072693824768066 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1138
AND dt_expiration_date >= '2025-08-05 20:02:06'
0.00024795532226562 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1138
0.00025701522827148 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=1138
0.00067496299743652 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1137
AND dt_expiration_date >= '2025-08-05 20:02:06'
0.00023388862609863 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1137
0.00026702880859375 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=1137
0.0013561248779297 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1136
AND dt_expiration_date >= '2025-08-05 20:02:06'
0.00027894973754883 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1136
0.00029206275939941 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=1136
0.00022101402282715 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.0014989376068115 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.00022602081298828 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.0008089542388916 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0015909671783447 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00018906593322754 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.0010590553283691 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.00027799606323242 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00066399574279785 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0012059211730957 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00018906593322754 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.0010740756988525 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.00027990341186523 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00064611434936523 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.0012581348419189 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00027704238891602 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC