Mieszkania Warszawa - strona 2

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Mieszkanie Warszawa Śródmieście, ul. Orla
1 537 500 zł

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

125 m212300zł/m2
Śródmieście, 2 pokoje, Kamienica
542 000 zł

Śródmieście, 2 pokoje, Kamienica

49 m211061zł/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
Żoliborz, ul. Gwiaździsta
1 980 000 zł

Żoliborz, ul. Gwiaździsta

133 m214887zł/m2
Praga-Południe, Saska Kępa, ul. Nowaka-Jeziorańskiego
2 099 000 zł

Praga-Południe, Saska Kępa, ul. Nowaka-Jeziorańskiego

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

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

122 m216385zł/m2
Penthaus położony na Skarpie Warszawskiej
2 300 000 zł

Penthaus położony na Skarpie Warszawskiej

191 m212041zł/m2

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

104 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

194 ogłoszeń z kategorii: Mieszkania Warszawa

Mieszkanie, 120 m², Warszawa
2 748 000 zł

Mieszkanie, 120 m², Warszawa

120 m222900zł/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
Qbik
2 230 000 zł

Qbik

169 m213195zł/m2
Praga-Południe, Saska Kępa, ul. Nowaka-Jeziorańskiego
2 099 000 zł

Praga-Południe, Saska Kępa, ul. Nowaka-Jeziorańskiego

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

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

122 m216385zł/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
Żoliborz, ul. Gwiaździsta
1 980 000 zł

Żoliborz, ul. Gwiaździsta

133 m214887zł/m2
Penthouse, Żoliborz, ul. Przasnyska
1 700 000 zł

Penthouse, Żoliborz, ul. Przasnyska

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

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

125 m212300zł/m2
Piękne Mieszkanie, Biuro, Metro, SGH
690 000 zł

Piękne Mieszkanie, Biuro, Metro, SGH

58.32 m211831zł/m2
  Database queries (Total queries: 184 - Total queries time: 0.17068862915039)  
0.00077319145202637 SELECT *
FROM (oc_t_preference)
0.00054812431335449 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00023603439331055 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.00023102760314941 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_slug = 'mieszkania'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.00081205368041992 SELECT f.pk_i_id
FROM (oc_t_meta_fields f, oc_t_meta_categories c)
WHERE ( c.fk_i_category_id = 236 )
AND f.pk_i_id = c.fk_i_field_id
AND f.b_searchable = 1
0.00022697448730469 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00026106834411621 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCity'
LIMIT 1
0.00021505355834961 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sShowAs'
LIMIT 1
0.00030803680419922 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sOrder'
LIMIT 1
0.0002448558807373 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iOrderType'
LIMIT 1
0.00025415420532227 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCategory'
LIMIT 1
0.00015687942504883 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.00341796875 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-19 16:56:51')
AND oc_t_item.fk_i_category_id IN (236)
AND ( oc_t_item_location.fk_i_city_id = 367478 )
ORDER BY Total_price desc, i_price desc
LIMIT 12, 12
0.0023210048675537 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-19 16:56:51')
AND oc_t_item.fk_i_category_id IN (236)
AND ( oc_t_item_location.fk_i_city_id = 367478 )
ORDER BY i_price desc
LIMIT 1200000
0.00037312507629395 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1145'
0.00069212913513184 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 = '1145'
AND s.fk_i_item_id = '1145'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00020909309387207 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '302'
0.0030319690704346 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.00025486946105957 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '305'
0.0030770301818848 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.00037288665771484 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '301'
0.0007319450378418 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 = '301'
AND s.fk_i_item_id = '301'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0001981258392334 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '300'
0.0030882358551025 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 = '300'
AND s.fk_i_item_id = '300'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00021886825561523 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '295'
0.0030319690704346 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.00020980834960938 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '296'
0.0030639171600342 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.00039196014404297 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '298'
0.0030760765075684 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 = '298'
AND s.fk_i_item_id = '298'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00020313262939453 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '297'
0.0031161308288574 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.00018596649169922 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '293'
0.0030038356781006 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.00019216537475586 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '294'
0.002979040145874 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.00039005279541016 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1063'
0.00059008598327637 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 = '1063'
AND s.fk_i_item_id = '1063'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00019216537475586 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.00025796890258789 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00028491020202637 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.0002601146697998 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_5'
0.00080704689025879 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.0002601146697998 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_5'
0.00045490264892578 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.00095915794372559 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00093698501586914 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 fk_i_parent_id = 236
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.00026202201843262 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.00023317337036133 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.00028109550476074 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.00023412704467773 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 fk_i_parent_id = 236
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.00023293495178223 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.00045514106750488 SELECT mf.*
FROM (oc_t_meta_fields mf, oc_t_meta_categories mc)
WHERE mc.fk_i_category_id = '236'
AND mf.pk_i_id = mc.fk_i_field_id
0.00033402442932129 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = '236'
AND s_plugin_name = 'custom_attributes'
0.00061702728271484 SELECT *
FROM (oc_t_item_custom_attr_groups)
JOIN oc_t_item_custom_attr_categories ON fk_i_group_id = pk_i_id
WHERE fk_i_category_id = '236'
ORDER BY oc_t_item_custom_attr_groups.order ASC
0.00029993057250977 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00025081634521484 SELECT *
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id NOT IN ('3', '4', '5', '61', '120', '202', '8', '9', '10', '11', '12', '13', '21', '99', '14', '15', '17', '18', '20', '28', '29', '30', '31', '32', '33', '34', '35', '83', '84', '123', '125', '129', '184', '185', '186', '188', '192', '217', '219', '221', '222', '223', '36', '37', '38', '39', '41', '42', '43', '44', '45', '46', '47', '50', '51', '52', '53', '91', '98', '124', '130', '216', '218', '57', '58', '59', '60', '85', '121', '122', '147', '62', '63', '64', '65', '66', '67', '126', '70', '71', '78', '79', '80', '81', '82', '93', '94', '95', '97', '77', '86', '87', '89', '90', '159', '160', '161', '105', '107', '115', '131', '165', '109', '110', '112', '113', '114', '162', '206', '233', '116', '117', '118', '119', '195', '196', '197', '200', '128', '133', '134', '136', '137', '138', '139', '140', '141', '142', '143', '144', '151', '152', '153', '154', '155', '156', '157', '158', '163', '164', '235', '236', '237', '238', '171', '173', '174', '175', '203', '205', '224', '178', '181', '176', '187', '193', '194', '198', '199', '234', '207', '208', '209', '210', '211', '212', '213', '214', '215', '225', '226', '227', '228', '229', '230', '231')
ORDER BY i_order ASC
0.0001678466796875 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '26'
ORDER BY i_order ASC
0.00017380714416504 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '1'
ORDER BY i_order ASC
0.00017285346984863 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '120'
LIMIT 1
0.00022697448730469 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '5'
LIMIT 1
0.00018095970153809 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '4'
LIMIT 1
0.00017905235290527 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '202'
LIMIT 1
0.00016689300537109 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '4'
ORDER BY i_order ASC
0.00038409233093262 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '32'
LIMIT 1
0.00028705596923828 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '31'
LIMIT 1
0.00033211708068848 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '28'
LIMIT 1
0.00033903121948242 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '125'
LIMIT 1
0.00029420852661133 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '223'
LIMIT 1
0.00029397010803223 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '188'
LIMIT 1
0.00026988983154297 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '83'
LIMIT 1
0.00029206275939941 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '129'
LIMIT 1
0.00027298927307129 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '84'
LIMIT 1
0.00025701522827148 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '192'
LIMIT 1
0.00029611587524414 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '221'
LIMIT 1
0.00029993057250977 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '222'
LIMIT 1
0.00027704238891602 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '35'
LIMIT 1
0.00027918815612793 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '123'
LIMIT 1
0.00032806396484375 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '217'
LIMIT 1
0.00018095970153809 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '6'
ORDER BY i_order ASC
0.00018787384033203 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '14'
ORDER BY i_order ASC
0.00018000602722168 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '3'
ORDER BY i_order ASC
0.00017786026000977 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '10'
ORDER BY s_label ASC
0.048127889633179 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 )
AND oc_t_item.fk_i_category_id IN (236)
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.00080084800720215 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (294, '2024-05-19 16:56:51',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 (311, '2024-05-19 16:56:51',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00033187866210938 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (293, '2024-05-19 16:56:51',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00029397010803223 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (298, '2024-05-19 16:56:51',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00027894973754883 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (300, '2024-05-19 16:56:51',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00028896331787109 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (295, '2024-05-19 16:56:51',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00029897689819336 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (302, '2024-05-19 16:56:51',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00026297569274902 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (277, '2024-05-19 16:56:51',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00027608871459961 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (296, '2024-05-19 16:56:51',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
9.918212890625E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '294'
0.0029981136322021 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.00034904479980469 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '311'
0.003026008605957 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.00016093254089355 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '293'
0.0030779838562012 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.00019216537475586 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '298'
0.0031139850616455 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 = '298'
AND s.fk_i_item_id = '298'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00021195411682129 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '300'
0.0030632019042969 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 = '300'
AND s.fk_i_item_id = '300'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00018882751464844 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '295'
0.0030879974365234 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.00020194053649902 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '302'
0.0031239986419678 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.00020289421081543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '277'
0.003046989440918 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.00020503997802734 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '296'
0.0029838085174561 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.00037288665771484 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 294
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00044703483581543 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 294
0.00019192695617676 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
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=294
0.0004730224609375 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 311
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00045680999755859 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 311
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=311
0.00034093856811523 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 293
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00039005279541016 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 293
0.00046610832214355 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.00033712387084961 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 298
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00017285346984863 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 298
0.00047707557678223 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=298
0.0003359317779541 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 300
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00038814544677734 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 300
0.00046014785766602 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=300
0.00034308433532715 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 295
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.0003659725189209 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 295
0.00045585632324219 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.00032305717468262 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 302
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00041294097900391 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 302
0.00050878524780273 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.00032901763916016 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 277
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00037097930908203 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 277
0.00056791305541992 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.00032210350036621 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 296
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00037217140197754 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 296
0.00050711631774902 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.00035405158996582 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1145
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00035500526428223 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1145
0.0066120624542236 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=1145
0.00023221969604492 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 302
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00023198127746582 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.00033092498779297 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 305
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00036811828613281 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 305
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=305
0.00034117698669434 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 301
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00034999847412109 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 301
0.00050902366638184 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=301
0.00016188621520996 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 300
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00023198127746582 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=300
0.00024700164794922 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 295
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00023007392883301 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.00024104118347168 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 296
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00023293495178223 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.00022602081298828 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 298
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00016593933105469 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=298
0.00032806396484375 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 297
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00040411949157715 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 297
0.0005030632019043 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.0002281665802002 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 293
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00021600723266602 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.00023603439331055 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 294
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00023984909057617 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.00033998489379883 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1063
AND dt_expiration_date >= '2024-05-19 16:56:51'
0.00038790702819824 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1063
0.00088882446289062 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=1063
0.00022315979003906 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00060892105102539 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.00023102760314941 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.00046110153198242 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.00081300735473633 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00018692016601562 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00059103965759277 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.00017285346984863 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00039100646972656 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00044989585876465 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00022101402282715 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00057220458984375 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.00016498565673828 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.0003960132598877 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00043106079101562 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00021600723266602 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC