• 0

Wyniki wyszukiwania - strona 22

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Tomaryny (Mazury Zach.) Leśniczówka + Stodoła + 0,5-3 Ha Działka
748 000 zł

Tomaryny (Mazury Zach.) Leśniczówka + Stodoła + 0,5-3 Ha Działka

130 m25753zł/m2
Dom, 600 m², Kraków
19 900 000 zł

Dom, 600 m², Kraków

600 m233166zł/m2
Warszawa Żoliborz, ul. Gen. Józefa Zajączka
1 999 000 zł

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

122 m216385zł/m2
Zalesiany sprzedam, rolna działka
3 650 000 zł

Zalesiany sprzedam, rolna działka

73000 m250zł/m2
Żoliborz, ul. Gwiaździsta
1 980 000 zł

Żoliborz, ul. Gwiaździsta

133 m214887zł/m2
Śródmieście, 2 pokoje, Kamienica
542 000 zł

Śródmieście, 2 pokoje, Kamienica

49 m211061zł/m2
Dom, 573 m², Warszawa
18 000 zł

Dom, 573 m², Warszawa

573 m231zł/m2
lokal biurowy na wynajem w Warszawa
7 000 zł

lokal biurowy na wynajem w Warszawa

Najlepszy Apartament W Stolicy
9 000 000 zł

Najlepszy Apartament W Stolicy

240 m237500zł/m2

929 ogłoszeń z kategorii: Polska

NOWA ↓ CENA Nowoczesne, 3 pok, klima, od zaraz
3 900 zł

NOWA ↓ CENA Nowoczesne, 3 pok, klima, od zaraz

70 m255zł/m2
Top Apartament /280m2/ śródmieście/zieleń
23 000 zł

Top Apartament /280m2/ śródmieście/zieleń

280 m282zł/m2
Komfortowe mieszkanie w kameralnej inwestycji.
6 000 zł

Komfortowe mieszkanie w kameralnej inwestycji.

89 m267zł/m2
Mieszkanie, 118 m², Warszawa
8 600 zł

Mieszkanie, 118 m², Warszawa

118 m272zł/m2
Mieszkanie, 391 m², Warszawa
23 460 zł

Mieszkanie, 391 m², Warszawa

391 m260zł/m2
Mieszkanie, 100 m², Warszawa
6 000 zł

Mieszkanie, 100 m², Warszawa

100 m260zł/m2
Mieszkanie, 71 m², Warszawa
4 500 zł

Mieszkanie, 71 m², Warszawa

71 m263zł/m2
Luxourius penthouse! 200sqm, spectacular views!
25 000 zł

Luxourius penthouse! 200sqm, spectacular views!

200 m2125zł/m2
Dwupokojowe mieszkanie w 19 dzielnicy
2 500 zł

Dwupokojowe mieszkanie w 19 dzielnicy

39 m264zł/m2
Nowe wyposażone mieszkanie na Jana Kazimierza
2 000 zł

Nowe wyposażone mieszkanie na Jana Kazimierza

43 m246zł/m2
Mieszkanie, 319 m², Warszawa
7 200 €

Mieszkanie, 319 m², Warszawa

319 m222zł/m2
Mam do wynajęcia dużą kawalerkę na Okopowej!
2 150 zł

Mam do wynajęcia dużą kawalerkę na Okopowej!

34 m263zł/m2
  Database queries (Total queries: 149 - Total queries time: 0.2722065448761)  
0.0014510154724121 SELECT *
FROM (oc_t_preference)
0.0010430812835693 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00032305717468262 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.00021481513977051 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.0001671314239502 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCountry'
LIMIT 1
0.00023794174194336 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sShowAs'
LIMIT 1
0.00013899803161621 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.0052430629730225 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-16 19:17:31')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 252, 12
0.0069189071655273 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-16 19:17:31')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 1200000
0.00059795379638672 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '940'
0.00090289115905762 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 = '940'
AND s.fk_i_item_id = '940'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00057601928710938 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '939'
0.00085282325744629 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 = '939'
AND s.fk_i_item_id = '939'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00052809715270996 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '938'
0.0008690357208252 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 = '938'
AND s.fk_i_item_id = '938'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00056791305541992 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '937'
0.00084090232849121 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 = '937'
AND s.fk_i_item_id = '937'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00047898292541504 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '936'
0.0010778903961182 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 = '936'
AND s.fk_i_item_id = '936'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00053310394287109 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '935'
0.00079512596130371 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 = '935'
AND s.fk_i_item_id = '935'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00052690505981445 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '934'
0.00073790550231934 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 = '934'
AND s.fk_i_item_id = '934'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00046300888061523 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '933'
0.00081801414489746 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 = '933'
AND s.fk_i_item_id = '933'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0004420280456543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '932'
0.00087618827819824 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 = '932'
AND s.fk_i_item_id = '932'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00048089027404785 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '931'
0.00093293190002441 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 = '931'
AND s.fk_i_item_id = '931'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00055909156799316 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '930'
0.0010640621185303 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 = '930'
AND s.fk_i_item_id = '930'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00061893463134766 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '929'
0.00098705291748047 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 = '929'
AND s.fk_i_item_id = '929'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00025796890258789 SELECT *
FROM (oc_t_country)
WHERE pk_c_code = 'PL'
0.00044798851013184 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0019450187683105 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.00076603889465332 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.0020151138305664 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00030994415283203 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.00033211708068848 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.00021195411682129 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00027203559875488 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
AND oc_t_region.fk_c_country_code = 'PL'
ORDER BY region_name ASC
0.0005028247833252 SELECT oc_t_city_stats.fk_i_city_id as city_id, oc_t_city_stats.i_num_items as items, oc_t_city.s_name as city_name, oc_t_city.s_slug as city_slug
FROM (oc_t_city_stats)
LEFT JOIN oc_t_city ON oc_t_city_stats.fk_i_city_id = oc_t_city.pk_i_id
WHERE i_num_items > 0
ORDER BY city_name ASC
0.00030803680419922 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.00035285949707031 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.00027799606323242 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.067831039428711 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_c_country_code = 'pl' )
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.0023031234741211 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (304, '2025-08-16 19:17:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0011458396911621 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (467, '2025-08-16 19:17:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0010590553283691 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (295, '2025-08-16 19:17:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0009610652923584 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (348, '2025-08-16 19:17:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0010299682617188 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (298, '2025-08-16 19:17:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0011129379272461 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (311, '2025-08-16 19:17:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.001115083694458 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (340, '2025-08-16 19:17:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00097990036010742 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (346, '2025-08-16 19:17:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00096821784973145 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (322, '2025-08-16 19:17:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0011031627655029 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '304'
0.0056579113006592 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 = '304'
AND s.fk_i_item_id = '304'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00065302848815918 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '467'
0.0057411193847656 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.00029397010803223 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '295'
0.0094978809356689 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '295'
AND s.fk_i_item_id = '295'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0010120868682861 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '348'
0.010080099105835 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 = '348'
AND s.fk_i_item_id = '348'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00084996223449707 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '298'
0.012706995010376 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.0011289119720459 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '311'
0.010421991348267 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.0007939338684082 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '340'
0.01034688949585 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 = '340'
AND s.fk_i_item_id = '340'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00085616111755371 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '346'
0.010993003845215 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 = '346'
AND s.fk_i_item_id = '346'
AND cd.fk_i_category_id = '243'
GROUP BY fk_i_item_id
0.00083398818969727 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '322'
0.0054810047149658 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.00071096420288086 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 304
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00085997581481934 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 304
0.00025200843811035 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.0010569095611572 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=304
0.00067400932312012 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 467
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00061607360839844 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 467
0.0010838508605957 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.00052809715270996 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 295
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00016403198242188 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 295
0.00016617774963379 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=295
0.00053596496582031 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 348
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.002453088760376 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 348
0.0012259483337402 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=348
0.00051307678222656 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 298
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00083208084106445 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 298
0.0012998580932617 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.00075507164001465 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 311
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00075316429138184 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 311
0.0010888576507568 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.00057816505432129 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 340
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00068497657775879 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 340
0.0010972023010254 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=340
0.00055599212646484 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 346
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00056600570678711 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 346
0.00074481964111328 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=346
0.0005650520324707 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 322
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00070810317993164 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 322
0.0010359287261963 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.00044012069702148 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 940
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00051021575927734 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 940
0.0009310245513916 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=940
0.00044989585876465 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 939
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00053000450134277 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 939
0.00090599060058594 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=939
0.00041484832763672 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 938
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00048398971557617 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 938
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=938
0.00042414665222168 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 937
AND dt_expiration_date >= '2025-08-16 19:17:31'
0.00044894218444824 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 937
0.001086950302124 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=937
0.00066995620727539 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 936
AND dt_expiration_date >= '2025-08-16 19:17:32'
0.00072288513183594 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 936
0.0014328956604004 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=936
0.00057601928710938 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 935
AND dt_expiration_date >= '2025-08-16 19:17:32'
0.00066494941711426 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 935
0.0013530254364014 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=935
0.00064802169799805 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 934
AND dt_expiration_date >= '2025-08-16 19:17:32'
0.00068497657775879 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 934
0.0013740062713623 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=934
0.00060391426086426 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 933
AND dt_expiration_date >= '2025-08-16 19:17:32'
0.00062012672424316 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 933
0.0014598369598389 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=933
0.00063085556030273 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 932
AND dt_expiration_date >= '2025-08-16 19:17:32'
0.00064897537231445 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 932
0.0013890266418457 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=932
0.00072002410888672 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 931
AND dt_expiration_date >= '2025-08-16 19:17:32'
0.00075387954711914 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 931
0.0014138221740723 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=931
0.00060391426086426 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 930
AND dt_expiration_date >= '2025-08-16 19:17:32'
0.00064897537231445 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 930
0.00061488151550293 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'EUR'
0.0014700889587402 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=930
0.00063920021057129 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 929
AND dt_expiration_date >= '2025-08-16 19:17:32'
0.00063991546630859 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 929
0.0015139579772949 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=929
0.0025238990783691 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.00077915191650391 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.001600980758667 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.0011279582977295 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.00068187713623047 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0016980171203613 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.0013401508331299 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.0005948543548584 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.0016739368438721 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00023412704467773 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC