Wyniki wyszukiwania - strona 47

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Mikołajki posiadłość sprzedam
995 000 zł

Mikołajki posiadłość sprzedam

200 m² m24975zł/m2
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
Energooszczędny Dom MDM Przy Lesie, ul. Osiedle Tygrysie Dachowa
289 000 zł

Energooszczędny Dom MDM Przy Lesie, ul. Osiedle Tygrysie Dachowa

99-230 m22919zł/m2
Dom, 573 m², Warszawa
18 000 zł

Dom, 573 m², Warszawa

573 m231zł/m2
Działka, 2 232 m², Mierzyn
299 000 zł

Działka, 2 232 m², Mierzyn

2232 m2133zł/m2
Dom, 600 m², Kraków
19 900 000 zł

Dom, 600 m², Kraków

600 m233166zł/m2
lokal biurowy na wynajem w Warszawa
7 000 zł

lokal biurowy na wynajem w Warszawa

Zalesiany sprzedam, rolna działka
3 650 000 zł

Zalesiany sprzedam, rolna działka

73000 m250zł/m2
WYNAJMĘ LOKAL USŁUGOWY BEZ POŚREDNIKÓW/CENTRUM OŁTASZYN
2 000 zł

WYNAJMĘ LOKAL USŁUGOWY BEZ POŚREDNIKÓW/CENTRUM OŁTASZYN

929 ogłoszeń z kategorii: Polska

Elbląg, Hetmańska 47, Miejsca w hali garażowej
25 000 zł

Elbląg, Hetmańska 47, Miejsca w hali garażowej

15 m21666zł/m2
Garaż w dobrym stanie, ul. Pułaskiego.
25 000 zł

Garaż w dobrym stanie, ul. Pułaskiego.

16,5 m21562zł/m2
Garaż, Kraków, Os. Mozarta
25 000 zł

Garaż, Kraków, Os. Mozarta

15 m21666zł/m2
Sprzedam miejsce postojowe ul. Inflancka 20.
25 000 zł

Sprzedam miejsce postojowe ul. Inflancka 20.

15,6 m21666zł/m2
Garaż
28 000 zł

Garaż

16 m21750zł/m2
Sprzedam garaż
28 000 zł

Sprzedam garaż

16,94 m21750zł/m2
Garaż - Sprzedam- Tychy oś. F
27 500 zł

Garaż - Sprzedam- Tychy oś. F

15,4 m21833zł/m2
NA sprzedaż obiekt magazyn. - prod. - handl. w Z-G
4 500 000 zł

NA sprzedaż obiekt magazyn. - prod. - handl. w Z-G

3395 m21325zł/m2
Hala/Magazyn, 1 565,69 m², Rzeszów
4 500 000 zł

Hala/Magazyn, 1 565,69 m², Rzeszów

1565,69 m22875zł/m2
Działka, 3 605 m², Piastów
6 246 275 zł

Działka, 3 605 m², Piastów

3605 m21732zł/m2
(3867) Magazyn, Starachowice, 3500 m2
4 500 000 zł

(3867) Magazyn, Starachowice, 3500 m2

3500 m21285zł/m2
Hala/Magazyn, 2 625 m², Bolechowo
4 500 000 zł

Hala/Magazyn, 2 625 m², Bolechowo

2625 m21714zł/m2
  Database queries (Total queries: 148 - Total queries time: 0.21467328071594)  
0.001622200012207 SELECT *
FROM (oc_t_preference)
0.00084710121154785 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.00025010108947754 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00013995170593262 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCountry'
LIMIT 1
0.00019001960754395 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.00014495849609375 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sShowAs'
LIMIT 1
0.0079340934753418 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-08 15:55:24')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 552, 12
0.008152961730957 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-08 15:55:24')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 1200000
0.00062918663024902 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '641'
0.0027410984039307 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 = '641'
AND s.fk_i_item_id = '641'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00057601928710938 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '640'
0.00098013877868652 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 = '640'
AND s.fk_i_item_id = '640'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00058794021606445 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '639'
0.0010671615600586 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 = '639'
AND s.fk_i_item_id = '639'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00054383277893066 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '638'
0.0019659996032715 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 = '638'
AND s.fk_i_item_id = '638'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00064301490783691 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '637'
0.00096702575683594 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 = '637'
AND s.fk_i_item_id = '637'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00056695938110352 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '636'
0.0011711120605469 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 = '636'
AND s.fk_i_item_id = '636'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00057101249694824 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '635'
0.00098299980163574 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 = '635'
AND s.fk_i_item_id = '635'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00019097328186035 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '634'
0.00016999244689941 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 = '634'
AND s.fk_i_item_id = '634'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00014710426330566 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '633'
0.00016188621520996 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 = '633'
AND s.fk_i_item_id = '633'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00046205520629883 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '632'
0.00094103813171387 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 = '632'
AND s.fk_i_item_id = '632'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00016307830810547 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '631'
0.0010590553283691 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 = '631'
AND s.fk_i_item_id = '631'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.0001680850982666 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '630'
0.00025081634521484 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 = '630'
AND s.fk_i_item_id = '630'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00017189979553223 SELECT *
FROM (oc_t_country)
WHERE pk_c_code = 'PL'
0.00028777122497559 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0022778511047363 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.00083303451538086 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.0014698505401611 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.0025808811187744 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.00035715103149414 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.00026798248291016 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00026202201843262 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.00045204162597656 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.00035691261291504 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.0004417896270752 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.00029397010803223 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.066411018371582 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.0022249221801758 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (276, '2025-08-08 15:55:25',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0033218860626221 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (304, '2025-08-08 15:55:25',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0010039806365967 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (303, '2025-08-08 15:55:25',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00091099739074707 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (340, '2025-08-08 15:55:25',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00084686279296875 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (1127, '2025-08-08 15:55:25',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00087881088256836 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (467, '2025-08-08 15:55:25',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0010750293731689 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (346, '2025-08-08 15:55:25',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00097799301147461 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (348, '2025-08-08 15:55:25',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00094795227050781 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (347, '2025-08-08 15:55:25',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0003058910369873 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '276'
0.0038039684295654 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 = '276'
AND s.fk_i_item_id = '276'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00016689300537109 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '304'
0.0038390159606934 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.00019598007202148 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '303'
0.0039958953857422 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 = '303'
AND s.fk_i_item_id = '303'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00018095970153809 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '340'
0.0038981437683105 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.00017809867858887 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1127'
0.0039129257202148 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 = '1127'
AND s.fk_i_item_id = '1127'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00015997886657715 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '467'
0.0039458274841309 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.00017786026000977 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '346'
0.0039079189300537 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.00016903877258301 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '348'
0.0038950443267822 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.00017905235290527 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '347'
0.0038948059082031 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 = '347'
AND s.fk_i_item_id = '347'
AND cd.fk_i_category_id = '243'
GROUP BY fk_i_item_id
0.0004730224609375 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 276
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00075888633728027 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 276
0.00024080276489258 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.0015280246734619 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=276
0.00054001808166504 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 304
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00018787384033203 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 304
0.00030398368835449 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.00053691864013672 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 303
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00071382522583008 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 303
0.001284122467041 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=303
0.00057411193847656 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 340
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00073909759521484 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 340
0.0011780261993408 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.00058507919311523 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1127
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00075411796569824 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1127
0.0022640228271484 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=1127
0.00049400329589844 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 467
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00051403045654297 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 467
0.0010209083557129 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.00037097930908203 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 346
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00046801567077637 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 346
0.00072598457336426 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.00045394897460938 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 348
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00064206123352051 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 348
0.000885009765625 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 = 347
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00062990188598633 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 347
0.00074601173400879 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=347
0.00049781799316406 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 641
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00054502487182617 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 641
0.001121997833252 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=641
0.00048589706420898 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 640
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00056815147399902 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 640
0.0010409355163574 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=640
0.00055909156799316 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 639
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00056314468383789 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 639
0.00105881690979 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=639
0.00043797492980957 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 638
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.0004730224609375 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 638
0.0012240409851074 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=638
0.0004889965057373 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 637
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00051689147949219 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 637
0.0009911060333252 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=637
0.00058603286743164 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 636
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00058698654174805 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 636
0.0011742115020752 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=636
0.00046396255493164 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 635
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00056195259094238 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 635
0.0011069774627686 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=635
0.00049710273742676 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 634
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00019598007202148 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 634
0.0011670589447021 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=634
0.00044608116149902 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 633
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00019001960754395 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 633
0.001244068145752 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=633
0.00040602684020996 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 632
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00057601928710938 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 632
0.0010759830474854 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=632
0.00044083595275879 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 631
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00015401840209961 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 631
0.000823974609375 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=631
0.00039887428283691 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 630
AND dt_expiration_date >= '2025-08-08 15:55:25'
0.00020599365234375 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 630
0.00081396102905273 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=630
0.00094699859619141 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.00057005882263184 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0014400482177734 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00088906288146973 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.00056600570678711 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0011081695556641 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00081801414489746 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.00048613548278809 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.0011060237884521 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00024294853210449 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC