• 0

Wyniki wyszukiwania - strona 2

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Iconic Award-winning Meier New York Penthouse
29 950 000 $

Iconic Award-winning Meier New York Penthouse

450 m266555zł/m2
Dom, 600 m², Kraków
19 900 000 zł

Dom, 600 m², Kraków

600 m233166zł/m2
Działka, 2 232 m², Mierzyn
299 000 zł

Działka, 2 232 m², Mierzyn

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

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

40 m2
Dom, 573 m², Warszawa
18 000 zł

Dom, 573 m², Warszawa

573 m231zł/m2
Zalesiany sprzedam, rolna działka
3 650 000 zł

Zalesiany sprzedam, rolna działka

73000 m250zł/m2
Mieszkanie, 66,60 m², Gdynia
449 000 zł

Mieszkanie, 66,60 m², Gdynia

66.6 m26741zł/m2
Mieszkanie Warszawa Muranów, ul. Plac Bankowy Przy Metrze Ratusz Arsenał
400 000 zł

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

30 m213333zł/m2
Lokal na parterze koło Uniwersytetu i Słodowej
521 000 zł

Lokal na parterze koło Uniwersytetu i Słodowej

81 m26432zł/m2

929 ogłoszeń z kategorii: Polska

->Budynek produkcyjny 801m Zaczernie po remoncie
1 200 000 zł

->Budynek produkcyjny 801m Zaczernie po remoncie

801 m21498zł/m2
Miejsce parkingowe w garażu podziemnym ul Obrzeżna
29 900 zł

Miejsce parkingowe w garażu podziemnym ul Obrzeżna

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

Hala/Magazyn, 400 m², Luborzyca

400 m23775zł/m2
Garaż, Kędzierzyn-Koźle, Powstańców
20 000 zł

Garaż, Kędzierzyn-Koźle, Powstańców

TANIO!! Sprzedam obiekt przemysłowy
960 000 zł

TANIO!! Sprzedam obiekt przemysłowy

700 m21371zł/m2
Garaż Murowany Za 25.000 Na Kazimierza Wielkiego
25 000 zł

Garaż Murowany Za 25.000 Na Kazimierza Wielkiego

Sprzedam lub wynajmę budynek biurowo- magazynowy
4 250 000 zł

Sprzedam lub wynajmę budynek biurowo- magazynowy

1150 m23695zł/m2
Sprzedam zamykany boks parkingowy w hali Bliźniąt
25 000 zł

Sprzedam zamykany boks parkingowy w hali Bliźniąt

Hala 1200m2+Hala 550m2+ 3,5ha ;FERMA DROBIU
2 650 000 zł

Hala 1200m2+Hala 550m2+ 3,5ha ;FERMA DROBIU

30500 m286zł/m2
Miejsce postojowe, Bora Komorowskiego 21, Warszawa
20 000 zł

Miejsce postojowe, Bora Komorowskiego 21, Warszawa

Kawalerka / BEZ DODATKOWYCH OPŁAT! kaucja 900zł!!!
1 850 zł

Kawalerka / BEZ DODATKOWYCH OPŁAT! kaucja 900zł!!!

28 m266zł/m2
Mieszkanie, 36,50 m², Warszawa
1 700 zł

Mieszkanie, 36,50 m², Warszawa

33,60 m251zł/m2
  Database queries (Total queries: 149 - Total queries time: 0.14701962471008)  
0.0010330677032471 SELECT *
FROM (oc_t_preference)
0.00058221817016602 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00025105476379395 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.00022292137145996 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.0002140998840332 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCountry'
LIMIT 1
0.0001978874206543 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sShowAs'
LIMIT 1
0.00024008750915527 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.0019528865814209 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-04-15 02:25:11')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 12, 12
0.0062751770019531 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-04-15 02:25:11')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 1200000
0.00021791458129883 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1180'
0.0007929801940918 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 = '1180'
AND s.fk_i_item_id = '1180'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00023317337036133 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1179'
0.0014500617980957 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 = '1179'
AND s.fk_i_item_id = '1179'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00026202201843262 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1178'
0.00067996978759766 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1178'
AND s.fk_i_item_id = '1178'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.0002131462097168 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1177'
0.0011019706726074 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 = '1177'
AND s.fk_i_item_id = '1177'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00018596649169922 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1176'
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 = '1176'
AND s.fk_i_item_id = '1176'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.0002601146697998 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1175'
0.00082087516784668 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 = '1175'
AND s.fk_i_item_id = '1175'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00026106834411621 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1174'
0.0012259483337402 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 = '1174'
AND s.fk_i_item_id = '1174'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00027203559875488 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1173'
0.00080990791320801 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 = '1173'
AND s.fk_i_item_id = '1173'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00026702880859375 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1172'
0.00067591667175293 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 = '1172'
AND s.fk_i_item_id = '1172'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00029706954956055 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1171'
0.0013360977172852 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 = '1171'
AND s.fk_i_item_id = '1171'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00047492980957031 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1170'
0.00082898139953613 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 = '1170'
AND s.fk_i_item_id = '1170'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00042295455932617 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1169'
0.00063800811767578 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 = '1169'
AND s.fk_i_item_id = '1169'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00018191337585449 SELECT *
FROM (oc_t_country)
WHERE pk_c_code = 'PL'
0.00029587745666504 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00084090232849121 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.00035691261291504 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.00062108039855957 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00024986267089844 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.0002281665802002 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.0001988410949707 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00018787384033203 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.00028491020202637 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.0002448558807373 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.00026702880859375 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
7.2002410888672E-5 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.051316976547241 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.00057601928710938 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (308, '2025-04-15 02:25:11',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00029397010803223 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (467, '2025-04-15 02:25:11',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00030303001403809 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (1127, '2025-04-15 02:25:11',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00029993057250977 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (988, '2025-04-15 02:25:11',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00029993057250977 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (340, '2025-04-15 02:25:11',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00029301643371582 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (348, '2025-04-15 02:25:11',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00024199485778809 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (357, '2025-04-15 02:25:11',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00029110908508301 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (292, '2025-04-15 02:25:11',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 (306, '2025-04-15 02:25:11',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
7.7962875366211E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '308'
0.0033531188964844 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
5.6028366088867E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '467'
0.0033390522003174 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
6.4849853515625E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1127'
0.0033400058746338 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.00034284591674805 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '988'
0.0033600330352783 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '988'
AND s.fk_i_item_id = '988'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00014591217041016 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '340'
0.0032978057861328 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.0001521110534668 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '348'
0.0034530162811279 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.00019192695617676 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '357'
0.0033371448516846 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 = '357'
AND s.fk_i_item_id = '357'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00023388862609863 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '292'
0.0035312175750732 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '292'
AND s.fk_i_item_id = '292'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00019097328186035 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '306'
0.0034110546112061 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 = '306'
AND s.fk_i_item_id = '306'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00037717819213867 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 308
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00045204162597656 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 308
0.00053191184997559 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'USD'
0.00058889389038086 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.00031495094299316 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 467
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00040507316589355 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 467
0.00022101402282715 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.010865926742554 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.00026416778564453 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1127
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00029897689819336 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1127
0.00077581405639648 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.00022387504577637 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 988
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00027203559875488 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 988
0.00093793869018555 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=988
0.00032401084899902 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 340
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00014615058898926 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 340
0.00021910667419434 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.00035500526428223 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 348
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00044107437133789 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 348
0.00058698654174805 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.00021195411682129 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 357
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00017690658569336 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 357
0.00017595291137695 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=357
0.00029706954956055 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 292
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00019502639770508 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 292
0.00015902519226074 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=292
0.00026798248291016 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 306
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00037693977355957 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 306
0.00057697296142578 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=306
0.00034308433532715 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1180
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00016212463378906 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1180
0.00018191337585449 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=1180
0.00034189224243164 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1179
AND dt_expiration_date >= '2025-04-15 02:25:11'
8.2969665527344E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1179
8.8214874267578E-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=1179
0.00022315979003906 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1178
AND dt_expiration_date >= '2025-04-15 02:25:11'
7.2002410888672E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1178
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=1178
0.00023412704467773 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1177
AND dt_expiration_date >= '2025-04-15 02:25:11'
7.2956085205078E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1177
0.0001070499420166 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=1177
0.00026178359985352 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1176
AND dt_expiration_date >= '2025-04-15 02:25:11'
7.4148178100586E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1176
9.1075897216797E-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=1176
0.00019097328186035 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1175
AND dt_expiration_date >= '2025-04-15 02:25:11'
7.2956085205078E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1175
8.5115432739258E-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=1175
0.0001978874206543 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1174
AND dt_expiration_date >= '2025-04-15 02:25:11'
7.2002410888672E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1174
7.7009201049805E-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=1174
0.00020599365234375 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1173
AND dt_expiration_date >= '2025-04-15 02:25:11'
7.1048736572266E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1173
7.7962875366211E-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=1173
0.00022387504577637 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1172
AND dt_expiration_date >= '2025-04-15 02:25:11'
7.2956085205078E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1172
8.1062316894531E-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=1172
0.00019693374633789 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1171
AND dt_expiration_date >= '2025-04-15 02:25:11'
7.0095062255859E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1171
7.6055526733398E-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=1171
0.00018715858459473 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1170
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00029301643371582 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1170
0.00084090232849121 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=1170
0.00018692016601562 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1169
AND dt_expiration_date >= '2025-04-15 02:25:11'
0.00030088424682617 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1169
0.0008399486541748 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=1169
0.00058507919311523 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.00024509429931641 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.00048494338989258 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00047993659973145 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.0002291202545166 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0003359317779541 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00040388107299805 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.00021791458129883 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00033187866210938 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
7.7009201049805E-5 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC