Dzięki! Jest to bardzo pomocne!

testowe mieszkanie

Mieszkania Warszawa, mazowieckie, Polska
200 000 PLN brutto 162 602 PLN netto  
200 000 PLN brutto 162 602 PLN netto

Krzysztof

  • 0

Pochodzenie oferty

Region mazowieckie
Miasto Warszawa
Adres Ul. Mydlańska 23

Informacje o ogłoszeniu

Rynek Pierwotny
Ilość m2 100
Rodzaj ogłoszenia Na wynajem

Informacje dodatkowe

witryna Tak
winda Tak
umeblowanie Tak

Opis

test

  Database queries (Total queries: 175 - Total queries time: 0.076564788818359)  
0.00085806846618652 SELECT *
FROM (oc_t_preference)
0.0005500316619873 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00024318695068359 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0010559558868408 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 = '266'
GROUP BY s.fk_i_item_id
0.0002138614654541 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '266'
0.0010139942169189 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (266, '2024-05-19 08:15:49',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.00043988227844238 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '22'
0.00034999847412109 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
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.00038886070251465 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 266
0.00023794174194336 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00024104118347168 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.00023007392883301 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781807'
0.00023603439331055 SELECT *
FROM (oc_t_region)
WHERE s_name = 'mazowieckie'
LIMIT 1
0.00022602081298828 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.0010139942169189 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.00017213821411133 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.00046014785766602 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
0.00021910667419434 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00022411346435547 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
0.0002751350402832 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00022196769714355 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.00062918663024902 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.00022602081298828 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.00039982795715332 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.0012931823730469 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00041604042053223 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 236
AND s_plugin_name = 'custom_attributes'
0.00048494338989258 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.00025701522827148 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.0002448558807373 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.00062298774719238 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.00023603439331055 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.00048184394836426 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '120'
LIMIT 1
0.00038290023803711 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '5'
LIMIT 1
0.00042486190795898 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '3'
LIMIT 1
0.00040698051452637 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '61'
LIMIT 1
0.00041985511779785 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '4'
LIMIT 1
0.00042200088500977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '202'
LIMIT 1
0.00023007392883301 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '120'
LIMIT 1
0.00016283988952637 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '5'
LIMIT 1
0.00016999244689941 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '3'
LIMIT 1
0.0001380443572998 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '61'
LIMIT 1
0.00017690658569336 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '4'
LIMIT 1
0.0001680850982666 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '202'
LIMIT 1
0.00083017349243164 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.00045204162597656 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '32'
LIMIT 1
0.00037312507629395 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '31'
LIMIT 1
0.00039291381835938 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '28'
LIMIT 1
0.00037479400634766 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '33'
LIMIT 1
0.00037693977355957 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '186'
LIMIT 1
0.00049304962158203 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '34'
LIMIT 1
0.00043892860412598 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '29'
LIMIT 1
0.0003669261932373 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '30'
LIMIT 1
0.00038814544677734 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '125'
LIMIT 1
0.00038003921508789 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '223'
LIMIT 1
0.00037503242492676 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '219'
LIMIT 1
0.00038003921508789 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '188'
LIMIT 1
0.00038695335388184 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '83'
LIMIT 1
0.00039482116699219 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '129'
LIMIT 1
0.00038599967956543 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '84'
LIMIT 1
0.00038814544677734 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '192'
LIMIT 1
0.00038480758666992 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '185'
LIMIT 1
0.00038504600524902 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '221'
LIMIT 1
0.00040316581726074 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '222'
LIMIT 1
0.00040888786315918 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '184'
LIMIT 1
0.0004279613494873 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '35'
LIMIT 1
0.00033307075500488 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '123'
LIMIT 1
0.00039005279541016 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '217'
LIMIT 1
0.00065112113952637 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.00039315223693848 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '85'
LIMIT 1
0.00036907196044922 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '121'
LIMIT 1
0.00037884712219238 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '122'
LIMIT 1
0.0003809928894043 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '147'
LIMIT 1
0.00050997734069824 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '57'
LIMIT 1
0.00037193298339844 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '58'
LIMIT 1
0.00039100646972656 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '59'
LIMIT 1
0.00037217140197754 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '60'
LIMIT 1
0.00017094612121582 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.00039577484130859 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '116'
LIMIT 1
0.00037598609924316 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '117'
LIMIT 1
0.00059700012207031 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '118'
LIMIT 1
0.00037002563476562 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '119'
LIMIT 1
0.00037217140197754 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '195'
LIMIT 1
0.00038695335388184 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '196'
LIMIT 1
0.00038385391235352 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '197'
LIMIT 1
0.00038695335388184 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '200'
LIMIT 1
0.00019097328186035 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.00039386749267578 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '14'
LIMIT 1
0.00035691261291504 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '15'
LIMIT 1
0.00038290023803711 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '17'
LIMIT 1
0.00039100646972656 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '18'
LIMIT 1
0.00040292739868164 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '20'
LIMIT 1
0.00017309188842773 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '14'
LIMIT 1
0.00016903877258301 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '15'
LIMIT 1
0.00017189979553223 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '17'
LIMIT 1
0.00017023086547852 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '18'
LIMIT 1
0.00016307830810547 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '20'
LIMIT 1
0.00010514259338379 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.00039911270141602 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '77'
LIMIT 1
0.00037312507629395 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '159'
LIMIT 1
0.00039505958557129 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '87'
LIMIT 1
0.00037193298339844 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '86'
LIMIT 1
0.00037789344787598 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '90'
LIMIT 1
0.00038480758666992 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '161'
LIMIT 1
0.00037097930908203 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '89'
LIMIT 1
0.00052809715270996 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 266
AND fk_i_field_id = '160'
LIMIT 1
0.00068187713623047 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-05-19 08:15:50') AND oc_t_item.pk_i_id < 266
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.00053811073303223 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 08:15:50') AND oc_t_item.pk_i_id < 266
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.00035786628723145 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '259'
0.00055909156799316 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 = '259'
AND s.fk_i_item_id = '259'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00032401084899902 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '257'
0.00052618980407715 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 = '257'
AND s.fk_i_item_id = '257'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0011630058288574 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-05-19 08:15:50') AND oc_t_item.pk_i_id != 266
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.0016520023345947 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 08:15:50') AND oc_t_item.pk_i_id != 266
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00065708160400391 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1170'
0.00066018104553223 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.00032806396484375 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1169'
0.00056099891662598 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.00031018257141113 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1168'
0.00059914588928223 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.00037479400634766 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1167'
0.00053000450134277 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.00032997131347656 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1166'
0.00058293342590332 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.00032591819763184 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1165'
0.00056099891662598 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.0003201961517334 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1164'
0.00056290626525879 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.00034999847412109 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1163'
0.00056982040405273 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1163'
AND s.fk_i_item_id = '1163'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00032496452331543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1162'
0.00055408477783203 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.00030899047851562 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1170
AND dt_expiration_date >= '2024-05-19 08:15:50'
0.00035810470581055 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1170
0.0007941722869873 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.00033402442932129 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1169
AND dt_expiration_date >= '2024-05-19 08:15:50'
0.00039005279541016 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1169
0.00098013877868652 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.0003511905670166 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1168
AND dt_expiration_date >= '2024-05-19 08:15:50'
0.00041604042053223 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1168
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=1168
0.00031590461730957 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1167
AND dt_expiration_date >= '2024-05-19 08:15:50'
0.00038909912109375 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1167
0.00097084045410156 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.0003349781036377 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1166
AND dt_expiration_date >= '2024-05-19 08:15:50'
0.00037002563476562 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1166
0.0008847713470459 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.00031685829162598 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1165
AND dt_expiration_date >= '2024-05-19 08:15:50'
0.00036096572875977 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1165
0.00076198577880859 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.0003199577331543 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1164
AND dt_expiration_date >= '2024-05-19 08:15:50'
0.00037908554077148 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1164
0.00081896781921387 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.00033211708068848 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1163
AND dt_expiration_date >= '2024-05-19 08:15:50'
0.00037598609924316 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1163
0.00081682205200195 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.00034594535827637 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1162
AND dt_expiration_date >= '2024-05-19 08:15:50'
0.00037598609924316 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1162
0.00081515312194824 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.00020790100097656 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00059413909912109 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.00012612342834473 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.0011928081512451 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00021195411682129 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00049901008605957 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.00016903877258301 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00041699409484863 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0010550022125244 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00020408630371094 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
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 = 4
ORDER BY rand_ind asc
0.00024890899658203 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00034809112548828 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00091099739074707 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00020885467529297 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC
19/05/2024 - 08:15:50 [ OPERATION OK ] Connected to 'sugmoto_house': [DBHOST] = localhost | [DBUSER] = sugmoto_house
19/05/2024 - 08:15:50 [ OPERATION OK ] SELECT user_id, pic_ext FROM oc_t_profile_picture WHERE user_id = '22'
19/05/2024 - 08:15:50 [ OPERATION OK ] Connection with 'sugmoto_house' released properly