• 0

małopolskie - strona 2

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Dom, 600 m², Kraków
19 900 000 zł

Dom, 600 m², Kraków

600 m233166zł/m2
Do wynajęcia 2 pokojowe na Woli z dużym balkonem 15 m2!!!!

Do wynajęcia 2 pokojowe na Woli z dużym balkonem 15 m2!!!!

40 m2

54 ogłoszeń z kategorii: Małopolskie

Stęszewko/ Tuczno/ Puszcza Zielonka/ Jezioro
155 000 zł

Stęszewko/ Tuczno/ Puszcza Zielonka/ Jezioro

140 m21107zł/m2
Mieszkanie z kominkiem
445 000 zł

Mieszkanie z kominkiem

92,56 m24836zł/m2
Dom 4km od Myślenic w Bysinie
450 000 zł

Dom 4km od Myślenic w Bysinie

200 m22250zł/m2
Wyjątkowe mieszkanie przy Bulwarach Wiślanych
465 000 zł

Wyjątkowe mieszkanie przy Bulwarach Wiślanych

71 m26549zł/m2
Garaż, Dąbrowa Tarnowska
480 000 zł

Garaż, Dąbrowa Tarnowska

425 m21129zł/m2
Atrakcyjna nieruchomość, Beskid Niski
550 000 zł

Atrakcyjna nieruchomość, Beskid Niski

40689 m213zł/m2
Piękny dom w Zawadzie Lanckorońskiej -właściciel
680 000 zł

Piękny dom w Zawadzie Lanckorońskiej -właściciel

240 m22833zł/m2
Działka komercyjna 64 ar. Krynica Zdrój
695 000 zł

Działka komercyjna 64 ar. Krynica Zdrój

6400 m2108zł/m2
Do sprzedania garaże w Raciborowicach!
800 000 zł

Do sprzedania garaże w Raciborowicach!

390 m22051zł/m2
Hala/Magazyn, 400 m², Luborzyca
1 510 000 zł

Hala/Magazyn, 400 m², Luborzyca

400 m23775zł/m2
Hala/Magazyn, 504 m², Skawina
1 580 000 zł

Hala/Magazyn, 504 m², Skawina

504 m23134zł/m2
Nieruchomość komercyjna w centrum Zasola
1 700 000 zł

Nieruchomość komercyjna w centrum Zasola

1055 m21611zł/m2
  Database queries (Total queries: 109 - Total queries time: 0.087730407714844)  
0.00097799301147461 SELECT *
FROM (oc_t_preference)
0.00052309036254883 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00023603439331055 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.00022196769714355 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00023102760314941 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sRegion'
LIMIT 1
0.00023317337036133 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sShowAs'
LIMIT 1
0.00015497207641602 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sOrder'
LIMIT 1
0.00018119812011719 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iOrderType'
LIMIT 1
0.00017499923706055 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.0015339851379395 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-06 02:28:14')
AND ( oc_t_item_location.fk_i_region_id = 781808 )
ORDER BY Total_price asc, i_price asc
LIMIT 12, 12
0.00082111358642578 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-06 02:28:14')
AND ( oc_t_item_location.fk_i_region_id = 781808 )
ORDER BY i_price asc
LIMIT 1200000
0.00040388107299805 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '377'
0.00093197822570801 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 = '377'
AND s.fk_i_item_id = '377'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00010895729064941 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '291'
0.00054001808166504 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 = '291'
AND s.fk_i_item_id = '291'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0003209114074707 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '331'
0.00052785873413086 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 = '331'
AND s.fk_i_item_id = '331'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00016593933105469 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '279'
0.00058412551879883 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 = '279'
AND s.fk_i_item_id = '279'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0003201961517334 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '458'
0.00052118301391602 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 = '458'
AND s.fk_i_item_id = '458'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00033092498779297 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1074'
0.0006098747253418 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 = '1074'
AND s.fk_i_item_id = '1074'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00036191940307617 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '378'
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 = '378'
AND s.fk_i_item_id = '378'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00034689903259277 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1068'
0.00057005882263184 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 = '1068'
AND s.fk_i_item_id = '1068'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.0096030235290527 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '406'
0.0003960132598877 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 = '406'
AND s.fk_i_item_id = '406'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00019598007202148 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1178'
0.00052189826965332 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 = '1178'
AND s.fk_i_item_id = '1178'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00038909912109375 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1097'
0.00052595138549805 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 = '1097'
AND s.fk_i_item_id = '1097'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00033903121948242 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '812'
0.00053095817565918 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 = '812'
AND s.fk_i_item_id = '812'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00019192695617676 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781808'
0.00023198127746582 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0002739429473877 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781808'
0.00077414512634277 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.00035309791564941 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.0010161399841309 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
9.7036361694336E-5 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 a.fk_i_parent_id IS NULL
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.00022983551025391 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.00024104118347168 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.0002291202545166 SELECT *
FROM (oc_t_region)
WHERE s_name = 'małopolskie'
LIMIT 1
0.00022506713867188 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 = 781808
ORDER BY city_name ASC
0.00024104118347168 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 a.fk_i_parent_id IS NULL
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.0002288818359375 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.00019097328186035 SELECT *
FROM (oc_t_region)
WHERE s_name = 'małopolskie'
LIMIT 1
0.003532886505127 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 = 781808 )
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.0010380744934082 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (467, '2024-05-06 02:28:15',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0005040168762207 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (988, '2024-05-06 02:28:15',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00022292137145996 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '467'
0.0033779144287109 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 = '467'
AND s.fk_i_item_id = '467'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00019216537475586 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '988'
0.003450870513916 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 = '988'
AND s.fk_i_item_id = '988'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00030303001403809 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 467
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00023794174194336 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 467
0.00022983551025391 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00022506713867188 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=467
0.0003209114074707 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 988
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00024294853210449 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 988
0.00023412704467773 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=988
0.00036883354187012 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 377
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00081992149353027 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 377
0.0006711483001709 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=377
0.00030112266540527 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 291
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00011014938354492 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 291
0.00022101402282715 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=291
0.00037884712219238 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 331
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00038003921508789 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 331
0.00077509880065918 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=331
0.00020289421081543 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 279
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00013589859008789 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 279
8.9168548583984E-5 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=279
0.00044584274291992 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 458
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00046896934509277 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 458
0.00077009201049805 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=458
0.00035309791564941 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1074
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00030708312988281 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1074
0.00072121620178223 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=1074
0.00035691261291504 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 378
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.0003960132598877 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 378
0.00057101249694824 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=378
0.00034189224243164 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1068
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00038886070251465 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1068
0.00088119506835938 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=1068
0.00039887428283691 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 406
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00036811828613281 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 406
0.0005488395690918 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=406
0.00034499168395996 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1178
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00039005279541016 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1178
0.0012061595916748 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=1178
0.00035381317138672 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1097
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00038719177246094 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1097
0.00089788436889648 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=1097
0.00031590461730957 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 812
AND dt_expiration_date >= '2024-05-06 02:28:15'
0.00038385391235352 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 812
0.021002054214478 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=812
0.00062990188598633 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.00050497055053711 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0014870166778564 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00054001808166504 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.00041103363037109 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0014071464538574 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00057792663574219 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.0003352165222168 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00096797943115234 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00016593933105469 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC