• 0

Wyniki wyszukiwania - strona 26

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Działka, 2 232 m², Mierzyn
299 000 zł

Działka, 2 232 m², Mierzyn

2232 m2133zł/m2
Mieszkanie do wnajęcia o9k 40 m2, studio.Otwarta kuchnia
1 600 zł

Mieszkanie do wnajęcia o9k 40 m2, studio.Otwarta kuchnia

40 m240zł/m2
Iconic Award-winning Meier New York Penthouse
29 950 000 $

Iconic Award-winning Meier New York Penthouse

450 m266555zł/m2
Mieszkanie 3-pokojowe, Krzyki, Wrocław
1 750 zł

Mieszkanie 3-pokojowe, Krzyki, Wrocław

56 m231zł/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
Mikołajki posiadłość sprzedam
995 000 zł

Mikołajki posiadłość sprzedam

200 m² m24975zł/m2
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

Mieszkanie ul Kolejowa "19 dzielnica" 54m² parking
3 500 zł

Mieszkanie ul Kolejowa "19 dzielnica" 54m² parking

54 m264zł/m2
Pokój dla 2 osób, świetna lokalizacja (ul. Okopowa
650 zł

Pokój dla 2 osób, świetna lokalizacja (ul. Okopowa

18 m236zł/m2
Pokoje 3 osobowe dla firm!!!
730 zł

Pokoje 3 osobowe dla firm!!!

15 m248zł/m2
Atrakcyjne 2 pok. z widokiem na zieleń - od zaraz
1 990 zł

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

45 m244zł/m2
Wolne miejsca w akdemiku "Słowicza", Na Ochocie!!!
730 zł

Wolne miejsca w akdemiku "Słowicza", Na Ochocie!!!

15 m248zł/m2
Bądź pierwszym najemcą nowa kawalerka Bez Prowizji
1 650 zł

Bądź pierwszym najemcą nowa kawalerka Bez Prowizji

29 m256zł/m2
Przytulne mieszkanie do wynajęcia na Woli – Jana K
2 100 zł

Przytulne mieszkanie do wynajęcia na Woli – Jana K

35 m260zł/m2
Akademik- wolne miejsca!!!
750 zł

Akademik- wolne miejsca!!!

15 m250zł/m2
Pokój do wynajęcia w samym centrum Warszawy/ ul. C
735 zł

Pokój do wynajęcia w samym centrum Warszawy/ ul. C

15 m249zł/m2
Kawalerka, Po Remoncie, 5 Min. Do Metra, Muranów
2 100 zł

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

30 m270zł/m2
Pokoj dla sympatycznej dziewczyny!!!
400 zł

Pokoj dla sympatycznej dziewczyny!!!

15 m226zł/m2
Wola, 36m2, 1-Pok, Umeblowane, Negocjacja
1 800 zł

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

36 m250zł/m2
  Database queries (Total queries: 148 - Total queries time: 0.16152763366699)  
0.00089502334594727 SELECT *
FROM (oc_t_preference)
0.0006558895111084 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.0001060962677002 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.00014305114746094 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00020694732666016 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCountry'
LIMIT 1
0.00019502639770508 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.0038869380950928 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-06-09 09:49:20')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 300, 12
0.006878137588501 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-06-09 09:49:20')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 1200000
0.00037908554077148 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '891'
0.00066590309143066 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '891'
AND s.fk_i_item_id = '891'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00034093856811523 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '892'
0.00054311752319336 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 = '892'
AND s.fk_i_item_id = '892'
AND cd.fk_i_category_id = '242'
GROUP BY fk_i_item_id
0.00029993057250977 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '890'
0.00068497657775879 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 = '890'
AND s.fk_i_item_id = '890'
AND cd.fk_i_category_id = '242'
GROUP BY fk_i_item_id
0.00040006637573242 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '889'
0.00048613548278809 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '889'
AND s.fk_i_item_id = '889'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00029492378234863 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '888'
0.00068497657775879 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 = '888'
AND s.fk_i_item_id = '888'
AND cd.fk_i_category_id = '242'
GROUP BY fk_i_item_id
0.00027704238891602 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '887'
0.00047206878662109 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '887'
AND s.fk_i_item_id = '887'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0002748966217041 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '886'
0.00051498413085938 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '886'
AND s.fk_i_item_id = '886'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00031185150146484 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '885'
0.002777099609375 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 = '885'
AND s.fk_i_item_id = '885'
AND cd.fk_i_category_id = '242'
GROUP BY fk_i_item_id
0.0002741813659668 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '884'
0.00054287910461426 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 = '884'
AND s.fk_i_item_id = '884'
AND cd.fk_i_category_id = '242'
GROUP BY fk_i_item_id
0.00028181076049805 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '883'
0.00050497055053711 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '883'
AND s.fk_i_item_id = '883'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00025701522827148 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '882'
0.00052618980407715 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 = '882'
AND s.fk_i_item_id = '882'
AND cd.fk_i_category_id = '242'
GROUP BY fk_i_item_id
0.00037097930908203 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '881'
0.00046014785766602 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '881'
AND s.fk_i_item_id = '881'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00014805793762207 SELECT *
FROM (oc_t_country)
WHERE pk_c_code = 'PL'
0.00028109550476074 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00089097023010254 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.00046396255493164 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.00054192543029785 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00023198127746582 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.00014996528625488 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.00013399124145508 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00012993812561035 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.00023984909057617 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.00027298927307129 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.00023317337036133 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.00023198127746582 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.052728176116943 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.00098991394042969 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (1127, '2025-06-09 09:49:20',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00041794776916504 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (344, '2025-06-09 09:49:20',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00038599967956543 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (308, '2025-06-09 09:49:20',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00034713745117188 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (345, '2025-06-09 09:49:20',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00031805038452148 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (304, '2025-06-09 09:49:20',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00035190582275391 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (303, '2025-06-09 09:49:20',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00035786628723145 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (276, '2025-06-09 09:49:20',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00028109550476074 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (348, '2025-06-09 09:49:20',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00028395652770996 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (347, '2025-06-09 09:49:20',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00010800361633301 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1127'
0.0039610862731934 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.0003209114074707 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '344'
0.0062768459320068 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 = '344'
AND s.fk_i_item_id = '344'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
6.6995620727539E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '308'
0.0063560009002686 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 = '308'
AND s.fk_i_item_id = '308'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00035595893859863 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '345'
0.0047299861907959 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 = '345'
AND s.fk_i_item_id = '345'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
7.0095062255859E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '304'
0.0035049915313721 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
8.2969665527344E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '303'
0.0035610198974609 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
7.0095062255859E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '276'
0.003291130065918 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
8.702278137207E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '348'
0.0038299560546875 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
8.702278137207E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '347'
0.0037679672241211 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.00025606155395508 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1127
AND dt_expiration_date >= '2025-06-09 09:49:20'
7.2002410888672E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1127
8.702278137207E-5 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
8.7976455688477E-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=1127
0.00024294853210449 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 344
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00026702880859375 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 344
0.00048398971557617 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=344
0.00018191337585449 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 308
AND dt_expiration_date >= '2025-06-09 09:49:20'
8.7976455688477E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 308
7.2002410888672E-5 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'USD'
8.392333984375E-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=308
0.00020098686218262 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 345
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00026893615722656 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 345
0.00046896934509277 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=345
0.00018095970153809 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 304
AND dt_expiration_date >= '2025-06-09 09:49:20'
7.9154968261719E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 304
9.2983245849609E-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=304
0.00022006034851074 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 303
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00010180473327637 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 303
8.2015991210938E-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=303
0.00022006034851074 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 276
AND dt_expiration_date >= '2025-06-09 09:49:20'
8.4877014160156E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 276
7.8916549682617E-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=276
0.0001838207244873 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 348
AND dt_expiration_date >= '2025-06-09 09:49:20'
7.5101852416992E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 348
8.2015991210938E-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=348
0.00018000602722168 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 347
AND dt_expiration_date >= '2025-06-09 09:49:20'
7.5101852416992E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 347
8.082389831543E-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=347
0.00026988983154297 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 891
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.0087440013885498 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 891
0.0008690357208252 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=891
0.00018095970153809 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 892
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00023007392883301 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 892
0.00063014030456543 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=892
0.00017690658569336 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 890
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00022506713867188 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 890
0.0007178783416748 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=890
0.00017499923706055 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 889
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00023508071899414 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 889
0.00078487396240234 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=889
0.00018095970153809 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 888
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00023889541625977 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 888
0.00061893463134766 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=888
0.00019288063049316 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 887
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00025486946105957 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 887
0.00060486793518066 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=887
0.00018787384033203 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 886
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00026702880859375 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 886
0.0043709278106689 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=886
0.00024986267089844 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 885
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00028586387634277 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 885
0.00067901611328125 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=885
0.00017809867858887 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 884
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00024795532226562 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 884
0.00065493583679199 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=884
0.00018405914306641 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 883
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00024604797363281 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 883
0.00073909759521484 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=883
0.00031399726867676 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 882
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00023388862609863 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 882
0.00063896179199219 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=882
0.00030684471130371 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 881
AND dt_expiration_date >= '2025-06-09 09:49:20'
0.00024890899658203 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 881
0.00063896179199219 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=881
0.00061583518981934 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.00024700164794922 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.00046515464782715 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00060606002807617 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.00033283233642578 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00053906440734863 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00051617622375488 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.00033712387084961 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00053310394287109 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00011992454528809 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC