Żoliborz, ul. Gwiaździsta

Promowanie Mieszkania Warszawa, mazowieckie, Polska
1 980 000 PLN brutto 1 609 756 PLN netto  
1 980 000 PLN brutto 1 609 756 PLN netto

Krzysztof

  • +(4

  • 0

Pochodzenie oferty

Region mazowieckie
Miasto Warszawa
Adres Ul. Gwiaździsta

Informacje o ogłoszeniu

Rynek Wtórny
Ilość m2 133
Rodzaj ogłoszenia Na sprzedaż

Informacje dodatkowe

parking Tak
winda Tak

Opis

Garaż/Miejsce parkingowe
garaż
Dodatkowe zalety
winda
Opis dodatkowy
|
Bardzo funkcjonalny, czteropokojowy apartament, który do tej pory nie był przez nikogo zamieszkiwany. Rozkład: hall, salon, kuchnia, 2/3 sypialnie (jeden pokój obecnie funkcjonuje jako gabinet), 2 łazienki, garderoba. Duża loggia (ogród zimowy). Bardzo ładne widoki. W cenie aż trzy miejsca postojowe i komórka lokatorska

  Database queries (Total queries: 189 - Total queries time: 0.10657072067261)  
0.00089192390441895 SELECT *
FROM (oc_t_preference)
0.0006859302520752 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00019478797912598 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0031259059906006 SELECT l.*, i.*, SUM(s.i_num_views) AS i_num_views
FROM (oc_t_item i)
LEFT JOIN oc_t_item_location l ON l.fk_i_item_id = i.pk_i_id
LEFT JOIN oc_t_item_stats s ON i.pk_i_id = s.fk_i_item_id
WHERE i.pk_i_id = '298'
GROUP BY s.fk_i_item_id
0.00025796890258789 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '298'
0.0015668869018555 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (298, '2024-04-26 13:15:52',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.0005648136138916 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '6'
0.00042510032653809 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '6'
0.00021505355834961 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.00046706199645996 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 298
0.00026297569274902 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00055313110351562 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.00045299530029297 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781807'
0.00053691864013672 SELECT *
FROM (oc_t_region)
WHERE s_name = 'mazowieckie'
LIMIT 1
0.00047087669372559 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE s_name = 'Warszawa'
LIMIT 1
0.00022196769714355 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.00011396408081055 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE s_name = 'Warszawa'
LIMIT 1
0.00044989585876465 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 6
0.00016283988952637 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '6'
0.00017499923706055 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 6
0.00017189979553223 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '6'
0.0002140998840332 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.00079488754272461 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 = 6
ORDER BY rand_ind asc
0.00020885467529297 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.00041699409484863 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.0012969970703125 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00051379203796387 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 236
AND s_plugin_name = 'custom_attributes'
0.00062680244445801 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.00032186508178711 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.0001378059387207 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.00027084350585938 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.00054383277893066 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '120'
LIMIT 1
0.00043201446533203 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '5'
LIMIT 1
0.0004880428314209 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '3'
LIMIT 1
0.00042486190795898 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '61'
LIMIT 1
0.00048208236694336 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '4'
LIMIT 1
0.00054502487182617 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '202'
LIMIT 1
0.00023412704467773 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '120'
LIMIT 1
0.00021791458129883 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '5'
LIMIT 1
0.00017118453979492 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '3'
LIMIT 1
0.00015592575073242 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '61'
LIMIT 1
0.00015592575073242 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '4'
LIMIT 1
0.00015497207641602 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '202'
LIMIT 1
0.00017690658569336 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.00044608116149902 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '32'
LIMIT 1
0.00038409233093262 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '31'
LIMIT 1
0.00034499168395996 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '28'
LIMIT 1
0.00041604042053223 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '33'
LIMIT 1
0.00040292739868164 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '186'
LIMIT 1
0.00041294097900391 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '34'
LIMIT 1
0.00045990943908691 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '29'
LIMIT 1
0.00040507316589355 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '30'
LIMIT 1
0.0003972053527832 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '125'
LIMIT 1
0.00040197372436523 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '223'
LIMIT 1
0.00042009353637695 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '219'
LIMIT 1
0.00038909912109375 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '188'
LIMIT 1
0.00044393539428711 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '83'
LIMIT 1
0.00038290023803711 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '129'
LIMIT 1
0.00042295455932617 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '84'
LIMIT 1
0.0004119873046875 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '192'
LIMIT 1
0.00042200088500977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '185'
LIMIT 1
0.00051689147949219 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '221'
LIMIT 1
0.00038599967956543 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '222'
LIMIT 1
0.00038290023803711 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '184'
LIMIT 1
0.00038504600524902 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '35'
LIMIT 1
0.00043487548828125 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '123'
LIMIT 1
0.00042486190795898 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '217'
LIMIT 1
0.00017309188842773 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.00042009353637695 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '85'
LIMIT 1
0.0004279613494873 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '121'
LIMIT 1
0.0003819465637207 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '122'
LIMIT 1
0.00043606758117676 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '147'
LIMIT 1
0.00043010711669922 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '57'
LIMIT 1
0.00043988227844238 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '58'
LIMIT 1
0.00042414665222168 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '59'
LIMIT 1
0.00040316581726074 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '60'
LIMIT 1
9.0837478637695E-5 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.00038909912109375 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '116'
LIMIT 1
0.00041389465332031 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '117'
LIMIT 1
0.00039100646972656 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '118'
LIMIT 1
0.00039410591125488 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '119'
LIMIT 1
0.00041913986206055 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '195'
LIMIT 1
0.00042200088500977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '196'
LIMIT 1
0.00041699409484863 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '197'
LIMIT 1
0.0004580020904541 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '200'
LIMIT 1
0.00017189979553223 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.00046205520629883 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '14'
LIMIT 1
0.00046896934509277 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '15'
LIMIT 1
0.00044703483581543 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '17'
LIMIT 1
0.00046896934509277 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '18'
LIMIT 1
0.00041890144348145 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '20'
LIMIT 1
0.00014090538024902 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '14'
LIMIT 1
0.00016093254089355 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '15'
LIMIT 1
0.00023317337036133 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '17'
LIMIT 1
0.00021100044250488 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '18'
LIMIT 1
0.00023794174194336 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '20'
LIMIT 1
0.00024700164794922 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.00045108795166016 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '77'
LIMIT 1
0.00041794776916504 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '159'
LIMIT 1
0.00040102005004883 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '87'
LIMIT 1
0.00041913986206055 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '86'
LIMIT 1
0.00045299530029297 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '90'
LIMIT 1
0.00044488906860352 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '161'
LIMIT 1
0.00046682357788086 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '89'
LIMIT 1
0.00043392181396484 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 298
AND fk_i_field_id = '160'
LIMIT 1
0.0011520385742188 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 >= '2024-04-26 13:15:52') AND oc_t_item.pk_i_id < 298
AND oc_t_item.fk_i_category_id IN (236)
AND ( oc_t_item_location.s_region LIKE 'mazowieckie' )
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.00066089630126953 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-04-26 13:15:52') AND oc_t_item.pk_i_id < 298
AND oc_t_item.fk_i_category_id IN (236)
AND ( oc_t_item_location.s_region LIKE 'mazowieckie' )
ORDER BY dt_pub_date DESC
LIMIT 900000
0.000579833984375 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '297'
0.0035610198974609 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.00030803680419922 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '296'
0.0029819011688232 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.0002739429473877 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '295'
0.0031740665435791 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.00030398368835449 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '294'
0.0031089782714844 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.00030779838562012 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '293'
0.003032922744751 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.00035190582275391 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '292'
0.0031740665435791 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.00034308433532715 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '277'
0.003115177154541 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.00037217140197754 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '275'
0.00058698654174805 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 = '275'
AND s.fk_i_item_id = '275'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00032210350036621 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '267'
0.00054001808166504 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 = '267'
AND s.fk_i_item_id = '267'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0014948844909668 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 >= '2024-04-26 13:15:52') AND oc_t_item.pk_i_id != 298
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.0017499923706055 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-04-26 13:15:52') AND oc_t_item.pk_i_id != 298
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00032496452331543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1170'
0.00078797340393066 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1170'
AND s.fk_i_item_id = '1170'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00036811828613281 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1169'
0.00056004524230957 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1169'
AND s.fk_i_item_id = '1169'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00031495094299316 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1168'
0.00055193901062012 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 = '1168'
AND s.fk_i_item_id = '1168'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00033307075500488 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1167'
0.00074601173400879 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 = '1167'
AND s.fk_i_item_id = '1167'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00040888786315918 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1166'
0.00060296058654785 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 = '1166'
AND s.fk_i_item_id = '1166'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00036001205444336 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1165'
0.00060510635375977 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 = '1165'
AND s.fk_i_item_id = '1165'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00033307075500488 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1164'
0.00059986114501953 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 = '1164'
AND s.fk_i_item_id = '1164'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00042200088500977 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1163'
0.00066494941711426 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 = '1163'
AND s.fk_i_item_id = '1163'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00034499168395996 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1162'
0.00060200691223145 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1162'
AND s.fk_i_item_id = '1162'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00038599967956543 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1170
AND dt_expiration_date >= '2024-04-26 13:15:52'
0.0004279613494873 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1170
0.00095415115356445 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1170
0.00034308433532715 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1169
AND dt_expiration_date >= '2024-04-26 13:15:52'
0.00039482116699219 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1169
0.00087404251098633 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1169
0.00026297569274902 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1168
AND dt_expiration_date >= '2024-04-26 13:15:52'
0.00033807754516602 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1168
0.00092101097106934 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=1168
0.00019598007202148 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1167
AND dt_expiration_date >= '2024-04-26 13:15:52'
0.00044488906860352 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1167
0.00082802772521973 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=1167
0.00042414665222168 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1166
AND dt_expiration_date >= '2024-04-26 13:15:52'
0.00040602684020996 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1166
0.0008389949798584 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=1166
0.00034689903259277 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1165
AND dt_expiration_date >= '2024-04-26 13:15:52'
0.00036883354187012 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1165
0.00081110000610352 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=1165
0.00038003921508789 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1164
AND dt_expiration_date >= '2024-04-26 13:15:52'
0.00040984153747559 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1164
0.00087904930114746 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=1164
0.00033092498779297 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1163
AND dt_expiration_date >= '2024-04-26 13:15:52'
0.00037813186645508 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1163
0.00095796585083008 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=1163
0.00033688545227051 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1162
AND dt_expiration_date >= '2024-04-26 13:15:52'
0.00039005279541016 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1162
0.0010340213775635 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=1162
0.00022101402282715 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00052905082702637 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.00017189979553223 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.00037002563476562 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0010261535644531 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00022196769714355 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00053095817565918 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.00023198127746582 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00037193298339844 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00062894821166992 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00015807151794434 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00050711631774902 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.00017094612121582 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00036787986755371 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00095486640930176 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00022983551025391 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC