Warszawa - strona 3

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
Penthaus położony na Skarpie Warszawskiej
2 300 000 zł

Penthaus położony na Skarpie Warszawskiej

191 m212041zł/m2
Dwu Poziomowy Luksusowy Apartament, Śródmieście, ul. Aleje Jerozolimskie
2 250 000 zł

Dwu Poziomowy Luksusowy Apartament, Śródmieście, ul. Aleje Jerozolimskie

224 m210044zł/m2
Penthouse, Żoliborz, ul. Przasnyska
1 700 000 zł

Penthouse, Żoliborz, ul. Przasnyska

118,19 m214406zł/m2

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

104 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
Mieszkanie Warszawa Śródmieście, ul. Orla
1 537 500 zł

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

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

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

122 m216385zł/m2
lokal biurowy na wynajem w Warszawa
7 000 zł

lokal biurowy na wynajem w Warszawa

336 ogłoszeń z kategorii: Warszawa

Działka, 14 642 m², Warszawa
11 713 600 zł

Działka, 14 642 m², Warszawa

14642 m2800zł/m2
Działka budowlana na sprzedaż
11 710 450 zł

Działka budowlana na sprzedaż

13777 m2850zł/m2
Działka budowlana na sprzedaż
11 710 450 zł

Działka budowlana na sprzedaż

13777 m2850zł/m2
Lokal użytkowy, 820 m², Warszawa
10 000 000 zł

Lokal użytkowy, 820 m², Warszawa

820 m212195zł/m2
Lokal użytkowy, 1 831 m², Warszawa
10 000 000 zł

Lokal użytkowy, 1 831 m², Warszawa

1831 m25461zł/m2
Lokal użytkowy, 3 632 m², Warszawa
10 000 000 zł

Lokal użytkowy, 3 632 m², Warszawa

3632 m22753zł/m2
Mieszkanie, 319,40 m², Warszawa
9 052 092 zł

Mieszkanie, 319,40 m², Warszawa

319.4 m228340zł/m2
Najlepszy Apartament W Stolicy
9 000 000 zł

Najlepszy Apartament W Stolicy

240 m237500zł/m2
Mielno, morze, teren inwestycyjny
8 900 000 zł

Mielno, morze, teren inwestycyjny

2142m m24154zł/m2
Penthouse z basenem - w centrum.
2 000 000 €

Penthouse z basenem - w centrum.

319 m26269zł/m2
Penthouse Z Własnym Basenem W Willi Karolina
8 000 000 zł

Penthouse Z Własnym Basenem W Willi Karolina

400 m220000zł/m2
Działka deweloperska
7 670 400 zł

Działka deweloperska

12784 m2600zł/m2
  Database queries (Total queries: 150 - Total queries time: 0.11446666717529)  
0.0009610652923584 SELECT *
FROM (oc_t_preference)
0.00059604644775391 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00016617774963379 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
6.7949295043945E-5 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
6.413459777832E-5 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCity'
LIMIT 1
6.103515625E-5 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sShowAs'
LIMIT 1
5.8889389038086E-5 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
5.9127807617188E-5 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sOrder'
LIMIT 1
6.103515625E-5 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iOrderType'
LIMIT 1
0.0057089328765869 SELECT oc_t_item.i_price * oc_t_currency.value AS 'Total_price', 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_currency ON oc_t_item.fk_c_currency_code=oc_t_currency.pk_c_code
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 1=1
AND oc_t_item.i_price!=0
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.b_premium = 1 || oc_t_item.dt_expiration >= '2024-05-18 09:50:45')
AND ( oc_t_item_location.fk_i_city_id = 367478 )
ORDER BY Total_price desc, i_price desc
LIMIT 24, 12
0.0032989978790283 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 >= '2024-05-18 09:50:45')
AND ( oc_t_item_location.fk_i_city_id = 367478 )
ORDER BY i_price desc
LIMIT 1200000
0.0003199577331543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '660'
0.00042486190795898 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 = '660'
AND s.fk_i_item_id = '660'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00029397010803223 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '662'
0.00045585632324219 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 = '662'
AND s.fk_i_item_id = '662'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00026917457580566 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1072'
0.00051593780517578 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 = '1072'
AND s.fk_i_item_id = '1072'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00018310546875 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '693'
0.0019290447235107 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 = '693'
AND s.fk_i_item_id = '693'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00020694732666016 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '677'
0.00052714347839355 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 = '677'
AND s.fk_i_item_id = '677'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00019693374633789 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '686'
0.00051498413085938 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '686'
AND s.fk_i_item_id = '686'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00034594535827637 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '321'
0.00047588348388672 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 = '321'
AND s.fk_i_item_id = '321'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00014805793762207 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '322'
0.0031170845031738 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.00042390823364258 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '274'
0.00054693222045898 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 = '274'
AND s.fk_i_item_id = '274'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00036191940307617 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '323'
0.00051593780517578 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 = '323'
AND s.fk_i_item_id = '323'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00032806396484375 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '324'
0.00048398971557617 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 = '324'
AND s.fk_i_item_id = '324'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00029087066650391 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '602'
0.00048398971557617 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 = '602'
AND s.fk_i_item_id = '602'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00017595291137695 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE pk_i_id = '367478'
0.00024008750915527 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00015115737915039 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE pk_i_id = '367478'
0.00085806846618652 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.00041103363037109 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.0011072158813477 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.0002748966217041 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.00031590461730957 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.00018811225891113 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.00025796890258789 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.00028300285339355 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.00020790100097656 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.021559000015259 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_city_id = 367478 )
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.0010650157928467 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (296, '2024-05-18 09:50:45',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00047707557678223 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (302, '2024-05-18 09:50:45',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0004429817199707 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (305, '2024-05-18 09:50:45',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00047206878662109 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (297, '2024-05-18 09:50:45',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00035810470581055 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (277, '2024-05-18 09:50:45',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00035285949707031 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (292, '2024-05-18 09:50:45',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00041580200195312 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (294, '2024-05-18 09:50:45',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00063109397888184 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (295, '2024-05-18 09:50:45',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00049400329589844 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (346, '2024-05-18 09:50:45',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00051498413085938 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '296'
0.0030591487884521 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.0002131462097168 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '302'
0.0029699802398682 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 = '302'
AND s.fk_i_item_id = '302'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00025677680969238 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '305'
0.0029380321502686 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 = '305'
AND s.fk_i_item_id = '305'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0002739429473877 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '297'
0.0029840469360352 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.00024986267089844 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '277'
0.0029540061950684 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.00026202201843262 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '292'
0.0030560493469238 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.00026392936706543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '294'
0.0030090808868408 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.00020098686218262 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '295'
0.0031170845031738 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.00018191337585449 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '346'
0.0030930042266846 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '346'
AND s.fk_i_item_id = '346'
AND cd.fk_i_category_id = '243'
GROUP BY fk_i_item_id
0.00037980079650879 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 296
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00049614906311035 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 296
0.00021719932556152 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
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=296
0.00038409233093262 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 302
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00039505958557129 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 302
0.00043702125549316 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=302
0.00034093856811523 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 305
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00039100646972656 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 305
0.00049710273742676 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=305
0.00038409233093262 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 297
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00020289421081543 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 297
0.00023508071899414 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.0003058910369873 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 277
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00019502639770508 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 277
0.00017094612121582 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.00033020973205566 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 292
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00019192695617676 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 292
0.00021219253540039 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.0003199577331543 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 294
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00024604797363281 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 294
0.00023698806762695 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.00028800964355469 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 295
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00041604042053223 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 295
0.00052690505981445 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.00032401084899902 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 346
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00024604797363281 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 346
0.00024104118347168 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=346
0.00032997131347656 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 660
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00034499168395996 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 660
0.00075912475585938 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=660
0.00031304359436035 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 662
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00036096572875977 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 662
0.00063395500183105 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=662
0.0003361701965332 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1072
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00039100646972656 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1072
0.00080609321594238 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=1072
0.00031590461730957 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 693
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.0003809928894043 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 693
0.00061988830566406 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=693
0.00024199485778809 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 677
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00033688545227051 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 677
0.00067305564880371 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=677
0.00033807754516602 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 686
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00033998489379883 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 686
0.00074195861816406 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=686
0.00028896331787109 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 321
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.0003359317779541 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 321
0.0004420280456543 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=321
0.00018596649169922 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 322
AND dt_expiration_date >= '2024-05-18 09:50:45'
7.2956085205078E-5 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 322
9.9897384643555E-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=322
0.00028109550476074 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 274
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00040221214294434 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 274
0.00053119659423828 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=274
0.00030899047851562 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 323
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00048995018005371 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 323
0.00023889541625977 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'EUR'
0.00048398971557617 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=323
0.00044012069702148 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 324
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00040602684020996 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 324
0.00051212310791016 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=324
0.00033712387084961 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 602
AND dt_expiration_date >= '2024-05-18 09:50:45'
0.00037288665771484 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 602
0.00064897537231445 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=602
0.0006258487701416 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.00037908554077148 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.00096487998962402 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00050210952758789 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.0002899169921875 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00078392028808594 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00052380561828613 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.0003509521484375 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00067996978759766 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00022792816162109 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC