Mieszkania mazowieckie - strona 10

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Mieszkanie Warszawa Muranów, ul. Plac Bankowy Przy Metrze Ratusz Arsenał
400 000 zł

Mieszkanie Warszawa Muranów, ul. Plac Bankowy Przy Metrze Ratusz Arsenał

30 m213333zł/m2
Penthouse, Żoliborz, ul. Przasnyska
1 700 000 zł

Penthouse, Żoliborz, ul. Przasnyska

118,19 m214406zł/m2
Apartament Mieszkanie Warszawa Żoliborz, ul. Gen. Józefa Zajączka
1 990 000 zł

Apartament Mieszkanie Warszawa Żoliborz, ul. Gen. Józefa Zajączka

122 m216311zł/m2
Dwu Poziomowy Luksusowy Apartament, Śródmieście, ul. Aleje Jerozolimskie
2 250 000 zł

Dwu Poziomowy Luksusowy Apartament, Śródmieście, ul. Aleje Jerozolimskie

224 m210044zł/m2
Żoliborz, ul. Gwiaździsta
1 980 000 zł

Żoliborz, ul. Gwiaździsta

133 m214887zł/m2
Praga-Południe, Saska Kępa, ul. Nowaka-Jeziorańskiego
2 099 000 zł

Praga-Południe, Saska Kępa, ul. Nowaka-Jeziorańskiego

140,15 m214992zł/m2
Śródmieście, 2 pokoje, Kamienica
542 000 zł

Śródmieście, 2 pokoje, Kamienica

49 m211061zł/m2
Mieszkanie Warszawa Śródmieście, Rondo Radosława, ul. Zygmunta Słomińskiego
1 560 000 zł

Mieszkanie Warszawa Śródmieście, Rondo Radosława, ul. Zygmunta Słomińskiego

143 m210909zł/m2
Najlepszy Apartament W Stolicy
9 000 000 zł

Najlepszy Apartament W Stolicy

240 m237500zł/m2

190 ogłoszeń z kategorii: Mieszkania Mazowieckie

Luksusowe mieszkanie na Woli
3 500 zł

Luksusowe mieszkanie na Woli

Mieszkania  Warszawa, mazowieckie, Polska
Piękne 2 pokojowe mieszkanie, garaż komórka
2 150 zł

Piękne 2 pokojowe mieszkanie, garaż komórka

Mieszkania  Warszawa, mazowieckie, Polska
3 bedrooms, "19 Dzielnica" Compound!
9 000 zł

3 bedrooms, "19 Dzielnica" Compound!

Mieszkania  Warszawa, mazowieckie, Polska
Mieszkanie, 47 m², Warszawa
2 900 zł

Mieszkanie, 47 m², Warszawa

Mieszkania  Warszawa, mazowieckie, Polska
Mieszkanie ul Kolejowa "19 dzielnica" 54m² parking
3 500 zł

Mieszkanie ul Kolejowa "19 dzielnica" 54m² parking

Mieszkania  Warszawa, mazowieckie, Polska
Atrakcyjne 2 pok. z widokiem na zieleń - od zaraz
1 990 zł

Atrakcyjne 2 pok. z widokiem na zieleń - od zaraz

Mieszkania  Warszawa, mazowieckie, Polska
Bądź pierwszym najemcą nowa kawalerka Bez Prowizji
1 650 zł

Bądź pierwszym najemcą nowa kawalerka Bez Prowizji

Mieszkania  Warszawa, mazowieckie, Polska
Przytulne mieszkanie do wynajęcia na Woli – Jana K
2 100 zł

Przytulne mieszkanie do wynajęcia na Woli – Jana K

Mieszkania  Warszawa, mazowieckie, Polska
Kawalerka, Po Remoncie, 5 Min. Do Metra, Muranów
2 100 zł

Kawalerka, Po Remoncie, 5 Min. Do Metra, Muranów

Mieszkania  Warszawa, mazowieckie, Polska
Wola, 36m2, 1-Pok, Umeblowane, Negocjacja
1 800 zł

Wola, 36m2, 1-Pok, Umeblowane, Negocjacja

Mieszkania  Warszawa, mazowieckie, Polska
Wynajem Apartamentu Cosmopolitan
8 500 zł

Wynajem Apartamentu Cosmopolitan

Mieszkania  Warszawa 01-138, mazowieckie, Polska
Wola, Atrakcyjne, 2-Pok, Meble, Garaż, Balkon
2 300 zł

Wola, Atrakcyjne, 2-Pok, Meble, Garaż, Balkon

Mieszkania  Warszawa, mazowieckie, Polska
  Database queries (Total queries: 203 - Total queries time: 0.28407740592957)  
0.0014739036560059 SELECT *
FROM (oc_t_preference)
0.00070691108703613 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00028491020202637 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.0003049373626709 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.0002439022064209 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.00028491020202637 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00015807151794434 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.00014209747314453 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sRegion'
LIMIT 1
0.0001380443572998 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCategory'
LIMIT 1
0.00013899803161621 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sShowAs'
LIMIT 1
0.0036830902099609 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-07-27 05:12:00')
AND oc_t_item.fk_i_category_id IN (236)
AND ( oc_t_item_location.fk_i_region_id = 781807 )
ORDER BY dt_pub_date desc
LIMIT 108, 12
0.003864049911499 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-07-27 05:12:00')
AND oc_t_item.fk_i_category_id IN (236)
AND ( oc_t_item_location.fk_i_region_id = 781807 )
ORDER BY dt_pub_date desc
LIMIT 1200000
0.00071001052856445 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '899'
0.0014791488647461 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 = '899'
AND s.fk_i_item_id = '899'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00072789192199707 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '896'
0.0010650157928467 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 = '896'
AND s.fk_i_item_id = '896'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0001530647277832 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '895'
0.00087904930114746 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 = '895'
AND s.fk_i_item_id = '895'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00017595291137695 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '893'
0.0010008811950684 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 = '893'
AND s.fk_i_item_id = '893'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00024318695068359 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '891'
0.0010499954223633 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 = '891'
AND s.fk_i_item_id = '891'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00020909309387207 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '889'
0.0011489391326904 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 = '889'
AND s.fk_i_item_id = '889'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00021219253540039 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '887'
0.0010030269622803 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 = '887'
AND s.fk_i_item_id = '887'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00019502639770508 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '886'
0.0010709762573242 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 = '886'
AND s.fk_i_item_id = '886'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00021600723266602 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '883'
0.00099420547485352 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 = '883'
AND s.fk_i_item_id = '883'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00017905235290527 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '881'
0.0010049343109131 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 = '881'
AND s.fk_i_item_id = '881'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00019383430480957 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '880'
0.00094795227050781 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 = '880'
AND s.fk_i_item_id = '880'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00017905235290527 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '879'
0.001007080078125 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 = '879'
AND s.fk_i_item_id = '879'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00017595291137695 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781807'
0.00034809112548828 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00028204917907715 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781807'
0.00031208992004395 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_5'
0.0016748905181885 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.00021100044250488 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_5'
0.00065803527832031 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.0014040470123291 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00030303001403809 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.00028395652770996 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.00029301643371582 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.00023603439331055 SELECT *
FROM (oc_t_region)
WHERE s_name = 'mazowieckie'
LIMIT 1
0.00032997131347656 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
AND oc_t_city.fk_i_region_id = 781807
ORDER BY city_name ASC
0.00025677680969238 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.00029301643371582 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.00028705596923828 SELECT *
FROM (oc_t_region)
WHERE s_name = 'mazowieckie'
LIMIT 1
0.00030303001403809 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.00026106834411621 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = '236'
AND s_plugin_name = 'custom_attributes'
0.00028395652770996 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.00039386749267578 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00030612945556641 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.00023698806762695 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.00029206275939941 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.00028204917907715 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '120'
LIMIT 1
0.00025606155395508 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '5'
LIMIT 1
0.00024509429931641 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '4'
LIMIT 1
0.00024104118347168 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '202'
LIMIT 1
0.0002899169921875 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.00029897689819336 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '32'
LIMIT 1
0.0002741813659668 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '31'
LIMIT 1
0.00024294853210449 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '28'
LIMIT 1
0.00024008750915527 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '125'
LIMIT 1
0.00016999244689941 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '223'
LIMIT 1
0.00023794174194336 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '188'
LIMIT 1
0.00023984909057617 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '83'
LIMIT 1
0.00023794174194336 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '129'
LIMIT 1
0.00028204917907715 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '84'
LIMIT 1
0.00016379356384277 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '192'
LIMIT 1
0.00026416778564453 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '221'
LIMIT 1
0.00024104118347168 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '222'
LIMIT 1
0.00015997886657715 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '35'
LIMIT 1
0.00016307830810547 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '123'
LIMIT 1
0.00023293495178223 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '217'
LIMIT 1
0.00028705596923828 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.00028300285339355 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.00030088424682617 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.00029802322387695 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.059278964996338 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_region_id = 781807 )
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.0017051696777344 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (292, '2025-07-27 05:12:01',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0013589859008789 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (297, '2025-07-27 05:12:01',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.001439094543457 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (296, '2025-07-27 05:12:01',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0014519691467285 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (305, '2025-07-27 05:12:01',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0015079975128174 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (298, '2025-07-27 05:12:01',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0014798641204834 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (300, '2025-07-27 05:12:01',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0013320446014404 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (311, '2025-07-27 05:12:01',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0014388561248779 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (293, '2025-07-27 05:12:01',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0014088153839111 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (322, '2025-07-27 05:12:01',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00030612945556641 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '292'
0.010365962982178 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.00024795532226562 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '297'
0.010152816772461 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.00024509429931641 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '296'
0.018141984939575 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 = '296'
AND s.fk_i_item_id = '296'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00031089782714844 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '305'
0.010235071182251 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.0002751350402832 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '298'
0.010088205337524 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.00027084350585938 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '300'
0.010002136230469 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.00025200843811035 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '311'
0.010082960128784 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 = '311'
AND s.fk_i_item_id = '311'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0002739429473877 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '293'
0.010370016098022 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.01590895652771 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '322'
0.0065770149230957 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 = '322'
AND s.fk_i_item_id = '322'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0074222087860107 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 292
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00015997886657715 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 292
0.00020599365234375 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.0001838207244873 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.00071406364440918 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 297
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00016283988952637 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 297
0.00027799606323242 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.00057888031005859 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 296
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00020384788513184 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 296
0.00018119812011719 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=296
0.00059294700622559 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 305
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.0001838207244873 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 305
0.00019097328186035 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.00061893463134766 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 298
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00015997886657715 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 298
0.0018041133880615 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.00062799453735352 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 300
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00015592575073242 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 300
0.00023484230041504 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.00067400932312012 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 311
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.0002598762512207 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 311
0.00018501281738281 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=311
0.00062203407287598 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 293
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00016093254089355 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 293
0.0059299468994141 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.00082612037658691 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 322
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00088191032409668 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 322
0.00027799606323242 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=322
0.00050210952758789 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 899
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00061297416687012 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 899
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=899
0.00075507164001465 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 899
AND i.pk_i_id = 899
0.00049805641174316 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 896
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00016498565673828 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 896
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=896
0.00065708160400391 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 896
AND i.pk_i_id = 896
0.00040411949157715 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 895
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00016021728515625 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 895
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=895
0.0007169246673584 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 895
AND i.pk_i_id = 895
0.00044417381286621 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 893
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00054407119750977 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 893
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=893
0.00070500373840332 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 893
AND i.pk_i_id = 893
0.00042510032653809 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 891
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.0005958080291748 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 891
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=891
0.00089502334594727 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 891
AND i.pk_i_id = 891
0.00098490715026855 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 889
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00064992904663086 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 889
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=889
0.00090384483337402 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 889
AND i.pk_i_id = 889
0.0004880428314209 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 887
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00058507919311523 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 887
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=887
0.0006558895111084 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 887
AND i.pk_i_id = 887
0.00043082237243652 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 886
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00058817863464355 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 886
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=886
0.00076794624328613 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 886
AND i.pk_i_id = 886
0.00046491622924805 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 883
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00054216384887695 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 883
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=883
0.00068497657775879 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 883
AND i.pk_i_id = 883
0.00046205520629883 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 881
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00053095817565918 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 881
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=881
0.00075578689575195 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 881
AND i.pk_i_id = 881
0.00047016143798828 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 880
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00060510635375977 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 880
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=880
0.00072216987609863 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 880
AND i.pk_i_id = 880
0.00043392181396484 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 879
AND dt_expiration_date >= '2025-07-27 05:12:01'
0.00020098686218262 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 879
0 Error number: 1054
Error description: Unknown column 'i_mileage' in 'field list'

SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=879
0.00073385238647461 SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 879
AND i.pk_i_id = 879
0.00024604797363281 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.0010900497436523 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.00020909309387207 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.00050711631774902 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0012140274047852 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00015687942504883 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00088000297546387 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.0001528263092041 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00056004524230957 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0012030601501465 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00020098686218262 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00093412399291992 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.00019311904907227 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00057697296142578 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.0012068748474121 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00018906593322754 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC
27/07/2025 - 05:12:01 [ OPERATION OK ] Connected to 'sugmoto_house': [DBHOST] = localhost | [DBUSER] = sugmoto_house
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=899
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=896
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=895
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=893
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=891
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=889
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=887
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=886
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=883
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=881
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=880
27/07/2025 - 05:12:01 [ OPERATION OK ] SELECT * FROM `oc_t_item_location` WHERE `fk_i_item_id`=879
27/07/2025 - 05:12:01 [ OPERATION OK ] Connection with 'sugmoto_house' released properly