• 0

Wyniki wyszukiwania - strona 58

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Apartament Mieszkanie Warszawa Żoliborz, ul. Gen. Józefa Zajączka
1 990 000 zł

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

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

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

122 m216385zł/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
Mieszkanie 3-pokojowe, Krzyki, Wrocław
1 750 zł

Mieszkanie 3-pokojowe, Krzyki, Wrocław

56 m231zł/m2
Mieszkanie, 66,60 m², Gdynia
449 000 zł

Mieszkanie, 66,60 m², Gdynia

66.6 m26741zł/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
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
Iconic Award-winning Meier New York Penthouse
29 950 000 $

Iconic Award-winning Meier New York Penthouse

450 m266555zł/m2
Mieszkanie Warszawa Śródmieście, Rondo Radosława, ul. Zygmunta Słomińskiego
1 560 000 zł

Mieszkanie Warszawa Śródmieście, Rondo Radosława, ul. Zygmunta Słomińskiego

143 m210909zł/m2

929 ogłoszeń z kategorii: Polska

Kawalerka, Garaż, Tuż Przy Metrze Kabaty
1 600 zł

Kawalerka, Garaż, Tuż Przy Metrze Kabaty

40 m240zł/m2
Ekskluzywny Kompleks Biurowo-Magazynowy !!!
20 000 000 zł

Ekskluzywny Kompleks Biurowo-Magazynowy !!!

4000 m25000zł/m2
Górczewska 24, 30m, kawalerka
1 400 zł

Górczewska 24, 30m, kawalerka

30 m246zł/m2
WYJĄTKOWY pokój jedno lub dwuosobowy! WiFi w cenie
799 zł

WYJĄTKOWY pokój jedno lub dwuosobowy! WiFi w cenie

13 m261zł/m2
Apartamentowiec usługowo-mieszkalny w Świeradów Zd
20 000 000 zł

Apartamentowiec usługowo-mieszkalny w Świeradów Zd

3221,75 m26209zł/m2
Lokal użytkowy, 1 600 m², Wrocław
20 000 000 zł

Lokal użytkowy, 1 600 m², Wrocław

1600 m212500zł/m2
Pokój przy Metrze Młociny
900 zł

Pokój przy Metrze Młociny

12 m275zł/m2
Lokal użytkowy, 2 550 m², Warszawa
20 000 000 zł

Lokal użytkowy, 2 550 m², Warszawa

2550 m27843zł/m2
Hotel z 2007r. w centrum Gdyni
20 000 000 zł

Hotel z 2007r. w centrum Gdyni

2350 m28510zł/m2
WROCŁAW Hala magazynowo biurowa sprzedaż
12 900 000 zł

WROCŁAW Hala magazynowo biurowa sprzedaż

5086 m22536zł/m2
Lokal użytkowy, 8 332 m², Bydgoszcz
20 500 000 zł

Lokal użytkowy, 8 332 m², Bydgoszcz

8332 m22460zł/m2
Hala,garaz ,biura,mieszkanie,dzialalnosc uciazliwa
2 490 000 zł

Hala,garaz ,biura,mieszkanie,dzialalnosc uciazliwa

800 m23112zł/m2
  Database queries (Total queries: 148 - Total queries time: 0.15666818618774)  
0.0012998580932617 SELECT *
FROM (oc_t_preference)
0.0005791187286377 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00024580955505371 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.00026917457580566 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00061392784118652 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCountry'
LIMIT 1
0.00016212463378906 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.0066080093383789 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-02-06 16:58:49')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 684, 12
0.006666898727417 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-02-06 16:58:49')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 1200000
0.00039815902709961 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '510'
0.00060200691223145 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 = '510'
AND s.fk_i_item_id = '510'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00038599967956543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '509'
0.00052809715270996 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 = '509'
AND s.fk_i_item_id = '509'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00037813186645508 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '508'
0.00059103965759277 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 = '508'
AND s.fk_i_item_id = '508'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00037312507629395 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '507'
0.00051999092102051 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 = '507'
AND s.fk_i_item_id = '507'
AND cd.fk_i_category_id = '242'
GROUP BY fk_i_item_id
0.00037908554077148 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '506'
0.00075912475585938 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 = '506'
AND s.fk_i_item_id = '506'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00038409233093262 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '505'
0.00052905082702637 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 = '505'
AND s.fk_i_item_id = '505'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00056600570678711 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '504'
0.00056982040405273 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 = '504'
AND s.fk_i_item_id = '504'
AND cd.fk_i_category_id = '242'
GROUP BY fk_i_item_id
0.00035285949707031 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '503'
0.00075912475585938 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 = '503'
AND s.fk_i_item_id = '503'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00033807754516602 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '502'
0.00061488151550293 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 = '502'
AND s.fk_i_item_id = '502'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.0003809928894043 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '501'
0.00053811073303223 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 = '501'
AND s.fk_i_item_id = '501'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00030207633972168 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '500'
0.00052118301391602 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '500'
AND s.fk_i_item_id = '500'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.0003969669342041 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '499'
0.00052690505981445 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 = '499'
AND s.fk_i_item_id = '499'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.0001828670501709 SELECT *
FROM (oc_t_country)
WHERE pk_c_code = 'PL'
0.0002598762512207 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00086593627929688 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.00041007995605469 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.00061607360839844 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00026297569274902 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.00018906593322754 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.00065803527832031 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00061988830566406 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.00033712387084961 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.00011301040649414 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.00021910667419434 SELECT oc_t_country_stats.fk_c_country_code as country_code, oc_t_country_stats.i_num_items as items, oc_t_country.s_name as country_name, oc_t_country.s_slug as country_slug
FROM (oc_t_country_stats)
JOIN oc_t_country ON oc_t_country_stats.fk_c_country_code = oc_t_country.pk_c_code
WHERE i_num_items > 0
ORDER BY country_name ASC
0.00021195411682129 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.049539804458618 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.0010590553283691 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (296, '2025-02-06 16:58:49',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0005500316619873 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (295, '2025-02-06 16:58:49',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00058603286743164 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (304, '2025-02-06 16:58:49',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00042486190795898 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (345, '2025-02-06 16:58:49',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00040102005004883 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (357, '2025-02-06 16:58:49',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00026798248291016 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (988, '2025-02-06 16:58:49',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00038790702819824 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (292, '2025-02-06 16:58:49',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00041413307189941 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (308, '2025-02-06 16:58:49',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00047397613525391 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (293, '2025-02-06 16:58:49',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00031399726867676 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '296'
0.00370192527771 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 = '296'
AND s.fk_i_item_id = '296'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00024890899658203 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '295'
0.0036051273345947 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '295'
AND s.fk_i_item_id = '295'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00026178359985352 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '304'
0.0036931037902832 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.00026416778564453 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '345'
0.003727912902832 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
0.00018215179443359 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '357'
0.0034999847412109 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.00026607513427734 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '988'
0.0036361217498779 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.00019383430480957 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '292'
0.0037839412689209 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.00025391578674316 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '308'
0.0036580562591553 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.00028204917907715 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '293'
0.0035028457641602 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 = '293'
AND s.fk_i_item_id = '293'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0003809928894043 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 296
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00043797492980957 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 296
0.00026702880859375 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00060606002807617 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=296
0.00031709671020508 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 295
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.0016930103302002 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 295
0.00066399574279785 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=295
0.00035619735717773 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 304
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00015807151794434 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 304
0.00040793418884277 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.0003209114074707 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 345
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00041913986206055 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 345
0.00058197975158691 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.00030899047851562 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 357
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00012803077697754 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 357
0.00023794174194336 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.00038504600524902 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 988
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00016403198242188 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 988
0.00022006034851074 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.00039005279541016 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 292
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00049495697021484 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 292
0.00066590309143066 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.00031399726867676 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 308
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00044107437133789 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 308
0.00043702125549316 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'USD'
0.00051999092102051 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.00035381317138672 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 293
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00061202049255371 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 293
0.00049304962158203 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=293
0.00034689903259277 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 510
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00044679641723633 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 510
0.00065207481384277 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=510
0.00034213066101074 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 509
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00040912628173828 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 509
0.00059318542480469 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=509
0.00034904479980469 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 508
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00053882598876953 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 508
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=508
0.00041890144348145 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 507
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00043797492980957 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 507
0.00065803527832031 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=507
0.00037598609924316 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 506
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.0003659725189209 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 506
0.00073003768920898 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=506
0.00032901763916016 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 505
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00036191940307617 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 505
0.00059890747070312 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=505
0.00033402442932129 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 504
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00045204162597656 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 504
0.00059819221496582 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=504
0.00033402442932129 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 503
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00059294700622559 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 503
0.00056290626525879 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=503
0.00044083595275879 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 502
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00037097930908203 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 502
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=502
0.00023818016052246 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 501
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.0003819465637207 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 501
0.00064492225646973 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=501
0.00033903121948242 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 500
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00034594535827637 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 500
0.00071215629577637 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=500
0.00033211708068848 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 499
AND dt_expiration_date >= '2025-02-06 16:58:49'
0.00037503242492676 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 499
0.00057816505432129 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=499
0.00090503692626953 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.0004270076751709 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.00051593780517578 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00048112869262695 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.00028610229492188 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00062108039855957 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.0005488395690918 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.00043582916259766 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00019502639770508 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC