• 0

mazowieckie - strona 10

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Penthouse, Żoliborz, ul. Przasnyska
1 700 000 zł

Penthouse, Żoliborz, ul. Przasnyska

118,19 m214406zł/m2
Mieszkanie Warszawa Śródmieście, ul. Orla
1 537 500 zł

Mieszkanie Warszawa Śródmieście, ul. Orla

125 m212300zł/m2
Mieszkanie Warszawa Śródmieście, Powiśle

Mieszkanie Warszawa Śródmieście, Powiśle

104 m2
Najlepszy Apartament W Stolicy
9 000 000 zł

Najlepszy Apartament W Stolicy

240 m237500zł/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
Śródmieście, 2 pokoje, Kamienica
542 000 zł

Śródmieście, 2 pokoje, Kamienica

49 m211061zł/m2
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
Luksusowe mieszkanie w samym centrum Pruszkowa
315 000 zł

Luksusowe mieszkanie w samym centrum Pruszkowa

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

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

122 m216385zł/m2

416 ogłoszeń z kategorii: Mazowieckie

Mieszkanie, Warszawa
9 600 zł

Mieszkanie, Warszawa

150 m264zł/m2
Wynajmę komfortowe mieszkanie na ul.Kasprzaka31B
2 750 zł

Wynajmę komfortowe mieszkanie na ul.Kasprzaka31B

50 m255zł/m2
Mieszkanie, 154 m², Warszawa
9 600 zł

Mieszkanie, 154 m², Warszawa

154 m262zł/m2
Mieszkanie 42 m2 od zaraz
2 400 zł

Mieszkanie 42 m2 od zaraz

42 m257zł/m2
Kawalerka, doskonała lokalizacja, bezpośrednio
1 599 zł

Kawalerka, doskonała lokalizacja, bezpośrednio

27 m259zł/m2
Luksusowy Penthouse Na Powislu, ul.Drewniana 9
23 000 zł

Luksusowy Penthouse Na Powislu, ul.Drewniana 9

200 m2115zł/m2
NOWA ↓ CENA Nowoczesne, 3 pok, klima, od zaraz
3 900 zł

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

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

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

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

Komfortowe mieszkanie w kameralnej inwestycji.

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

Mieszkanie, 118 m², Warszawa

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

Mieszkanie, 391 m², Warszawa

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

Mieszkanie, 100 m², Warszawa

100 m260zł/m2
  Database queries (Total queries: 150 - Total queries time: 0.20635604858398)  
0.0015280246734619 SELECT *
FROM (oc_t_preference)
0.00078415870666504 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00024819374084473 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781807'
0.00024795532226562 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781807'
0.00023984909057617 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.00025796890258789 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00014686584472656 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.00013089179992676 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sRegion'
LIMIT 1
0.004641056060791 SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2025-08-02 10:17:17')
AND ( oc_t_item_location.fk_i_region_id = 781807 )
ORDER BY dt_pub_date desc
LIMIT 108, 12
0.0038771629333496 SELECT oc_t_item.pk_i_id, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2025-08-02 10:17:17')
AND ( oc_t_item_location.fk_i_region_id = 781807 )
ORDER BY dt_pub_date desc
LIMIT 1200000
0.0016140937805176 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '946'
0.00099396705627441 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 = '946'
AND s.fk_i_item_id = '946'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00069808959960938 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '945'
0.0013949871063232 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 = '945'
AND s.fk_i_item_id = '945'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00070500373840332 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '944'
0.001331090927124 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 = '944'
AND s.fk_i_item_id = '944'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0006558895111084 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '943'
0.0012979507446289 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 = '943'
AND s.fk_i_item_id = '943'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00066709518432617 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '942'
0.0012979507446289 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 = '942'
AND s.fk_i_item_id = '942'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00075006484985352 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '941'
0.001629114151001 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 = '941'
AND s.fk_i_item_id = '941'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0007319450378418 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '940'
0.00089693069458008 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '940'
AND s.fk_i_item_id = '940'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00071907043457031 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '939'
0.0014541149139404 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '939'
AND s.fk_i_item_id = '939'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00076389312744141 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '938'
0.0014159679412842 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '938'
AND s.fk_i_item_id = '938'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00067901611328125 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '937'
0.0013449192047119 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '937'
AND s.fk_i_item_id = '937'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0007789134979248 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '936'
0.0013260841369629 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '936'
AND s.fk_i_item_id = '936'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00067710876464844 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '935'
0.0014951229095459 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '935'
AND s.fk_i_item_id = '935'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00022196769714355 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781807'
0.00026798248291016 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00026607513427734 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781807'
0.00111985206604 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.00051403045654297 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.0012180805206299 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00032711029052734 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.00022602081298828 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.00025296211242676 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
ORDER BY region_name ASC
0.00025701522827148 SELECT *
FROM (oc_t_region)
WHERE s_name = 'mazowieckie'
LIMIT 1
0.00026988983154297 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
AND oc_t_city.fk_i_region_id = 781807
ORDER BY city_name ASC
0.00028395652770996 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.00031709671020508 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.00025296211242676 SELECT *
FROM (oc_t_region)
WHERE s_name = 'mazowieckie'
LIMIT 1
0.031928062438965 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_i_region_id = 781807 )
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.0018539428710938 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (297, '2025-08-02 10:17:17',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00090384483337402 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (294, '2025-08-02 10:17:17',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00086784362792969 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (277, '2025-08-02 10:17:17',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00084805488586426 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (322, '2025-08-02 10:17:17',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00080299377441406 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (293, '2025-08-02 10:17:17',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00075507164001465 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (311, '2025-08-02 10:17:17',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00072979927062988 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (296, '2025-08-02 10:17:17',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00064587593078613 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (329, '2025-08-02 10:17:17',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00066804885864258 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (295, '2025-08-02 10:17:17',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00019383430480957 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '297'
0.0055699348449707 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 = '297'
AND s.fk_i_item_id = '297'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00018787384033203 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '294'
0.0082879066467285 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 = '294'
AND s.fk_i_item_id = '294'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00021600723266602 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '277'
0.0085721015930176 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 = '277'
AND s.fk_i_item_id = '277'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00017094612121582 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '322'
0.008281946182251 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '322'
AND s.fk_i_item_id = '322'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00015902519226074 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '293'
0.0084681510925293 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.00014710426330566 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '311'
0.0079798698425293 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '311'
AND s.fk_i_item_id = '311'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00023007392883301 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '296'
0.0084719657897949 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.00020480155944824 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '329'
0.0081658363342285 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 = '329'
AND s.fk_i_item_id = '329'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00014090538024902 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '295'
0.0085620880126953 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.0005340576171875 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 297
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00024795532226562 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 297
0.00018811225891113 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00020599365234375 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=297
0.00055503845214844 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 294
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00061893463134766 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 294
0.0010888576507568 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=294
0.00042295455932617 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 277
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00050878524780273 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 277
0.00085997581481934 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=277
0.00048613548278809 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 322
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00015997886657715 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 322
0.00024700164794922 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=322
0.00042986869812012 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 293
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00019383430480957 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 293
0.00026798248291016 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.00056290626525879 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 311
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00024294853210449 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 311
0.0002598762512207 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=311
0.0005648136138916 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 296
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00017809867858887 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 296
0.00019311904907227 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.00048398971557617 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 329
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00024509429931641 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 329
0.00024604797363281 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=329
0.00088691711425781 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 295
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00022292137145996 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 295
0.0002741813659668 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.00057005882263184 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 946
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00062108039855957 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 946
0.0013260841369629 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=946
0.00046992301940918 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 945
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00050806999206543 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 945
0.0013420581817627 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=945
0.00054311752319336 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 944
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.0006108283996582 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 944
0.0022780895233154 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=944
0.0011160373687744 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 943
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00053310394287109 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 943
0.0010850429534912 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=943
0.00050806999206543 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 942
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00057411193847656 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 942
0.0011990070343018 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=942
0.00048589706420898 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 941
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00045299530029297 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 941
0.0010290145874023 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=941
0.00041007995605469 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 940
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00049090385437012 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 940
0.0010240077972412 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=940
0.00040006637573242 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 939
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00055289268493652 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 939
0.0011448860168457 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=939
0.00041913986206055 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 938
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.0004880428314209 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 938
0.0010271072387695 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=938
0.00053596496582031 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 937
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00067496299743652 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 937
0.001554012298584 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=937
0.00065016746520996 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 936
AND dt_expiration_date >= '2025-08-02 10:17:17'
0.00053501129150391 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 936
0.001140832901001 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=936
0.00043487548828125 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 935
AND dt_expiration_date >= '2025-08-02 10:17:18'
0.00079607963562012 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 935
0.0011298656463623 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=935
0.00094413757324219 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.00050806999206543 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0016829967498779 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.0010950565338135 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.00059914588928223 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0012390613555908 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.0010571479797363 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.00064802169799805 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.0010950565338135 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00022006034851074 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC