test

Domy Polska
 
PLN brutto 0 PLN netto

Krzysztof

  • 0

Pochodzenie oferty

Informacje o ogłoszeniu

Ilość m2 23432
Rodzaj ogłoszenia Na wynajem

Opis

test

  Database queries (Total queries: 149 - Total queries time: 0.12973976135254)  
0.0011470317840576 SELECT *
FROM (oc_t_preference)
0.00063800811767578 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00022697448730469 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0011601448059082 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 = '270'
GROUP BY s.fk_i_item_id
0.00046396255493164 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '270'
0.00091195106506348 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (270, '2025-05-06 21:24:04',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.00059914588928223 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '22'
0.013695001602173 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00024795532226562 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.00045609474182129 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 270
0.0030319690704346 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00053191184997559 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
0.0002439022064209 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00017690658569336 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
0.0001530647277832 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00049114227294922 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.00070619583129883 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.00027918815612793 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.00029897689819336 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.00051283836364746 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00044798851013184 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 237
AND s_plugin_name = 'custom_attributes'
0.00049185752868652 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 = 237
ORDER BY oc_t_item_custom_attr_groups.order ASC
0.0002439022064209 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00021004676818848 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.00015783309936523 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.016772985458374 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '120'
LIMIT 1
0.010483980178833 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '5'
LIMIT 1
0.00043821334838867 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '3'
LIMIT 1
0.00078701972961426 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '61'
LIMIT 1
0.00029897689819336 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '4'
LIMIT 1
0.00029802322387695 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '202'
LIMIT 1
6.5088272094727E-5 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '120'
LIMIT 1
6.1988830566406E-5 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '5'
LIMIT 1
6.2942504882812E-5 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '3'
LIMIT 1
6.3896179199219E-5 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '61'
LIMIT 1
6.1988830566406E-5 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '4'
LIMIT 1
6.1988830566406E-5 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '202'
LIMIT 1
8.2015991210938E-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 = '5'
ORDER BY i_order ASC
0.00062012672424316 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '39'
LIMIT 1
0.004331111907959 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '44'
LIMIT 1
0.00029206275939941 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '45'
LIMIT 1
0.00032901763916016 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '42'
LIMIT 1
0.0018899440765381 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '36'
LIMIT 1
0.00092387199401855 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '53'
LIMIT 1
0.00062394142150879 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '98'
LIMIT 1
0.00028705596923828 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '37'
LIMIT 1
0.00029182434082031 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '38'
LIMIT 1
0.00028204917907715 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '43'
LIMIT 1
0.00029182434082031 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '218'
LIMIT 1
0.00028610229492188 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '50'
LIMIT 1
0.0005800724029541 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '91'
LIMIT 1
0.0018930435180664 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '130'
LIMIT 1
0.00028800964355469 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '51'
LIMIT 1
0.00029182434082031 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '41'
LIMIT 1
0.00029397010803223 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '47'
LIMIT 1
0.00028395652770996 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '46'
LIMIT 1
0.00029802322387695 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '52'
LIMIT 1
0.00064301490783691 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '124'
LIMIT 1
0.0002901554107666 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '216'
LIMIT 1
8.1062316894531E-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 = '6'
ORDER BY i_order ASC
0.0089612007141113 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '85'
LIMIT 1
0.00036311149597168 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '121'
LIMIT 1
0.00029087066650391 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '122'
LIMIT 1
0.00038599967956543 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '147'
LIMIT 1
0.00063800811767578 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '57'
LIMIT 1
0.00055718421936035 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '58'
LIMIT 1
0.00035595893859863 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '59'
LIMIT 1
0.00034403800964355 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '60'
LIMIT 1
0.00015902519226074 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.00049281120300293 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '116'
LIMIT 1
0.00036501884460449 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '117'
LIMIT 1
0.0003659725189209 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '118'
LIMIT 1
0.00035405158996582 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '119'
LIMIT 1
0.00029397010803223 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '195'
LIMIT 1
0.00031185150146484 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '196'
LIMIT 1
0.00031399726867676 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '197'
LIMIT 1
0.00029897689819336 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '200'
LIMIT 1
0.00013589859008789 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 = '18'
ORDER BY i_order ASC
0.00030398368835449 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '143'
LIMIT 1
0.00028610229492188 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '144'
LIMIT 1
8.6069107055664E-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 = '3'
ORDER BY i_order ASC
0.0049710273742676 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '14'
LIMIT 1
0.00078797340393066 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '15'
LIMIT 1
0.00072693824768066 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '17'
LIMIT 1
0.00072789192199707 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '18'
LIMIT 1
0.0071799755096436 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '20'
LIMIT 1
0.00016903877258301 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 = '24'
ORDER BY i_order ASC
0.00040888786315918 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '176'
LIMIT 1
0.00013899803161621 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.0010018348693848 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '77'
LIMIT 1
0.00050902366638184 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '159'
LIMIT 1
0.00088691711425781 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '87'
LIMIT 1
0.00031900405883789 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '86'
LIMIT 1
0.0048120021820068 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '90'
LIMIT 1
0.00037813186645508 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '161'
LIMIT 1
0.00033092498779297 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '89'
LIMIT 1
0.00035691261291504 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '160'
LIMIT 1
0.00011801719665527 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 = '16'
ORDER BY i_order ASC
0.00032591819763184 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '133'
LIMIT 1
0.00028204917907715 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '134'
LIMIT 1
0.00034809112548828 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '136'
LIMIT 1
0.00029397010803223 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '137'
LIMIT 1
0.00029301643371582 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '138'
LIMIT 1
0.00028514862060547 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '139'
LIMIT 1
0.0003509521484375 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '140'
LIMIT 1
0.00028800964355469 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '141'
LIMIT 1
0.00028610229492188 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '142'
LIMIT 1
0.00014400482177734 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 = '20'
ORDER BY i_order ASC
0.00032591819763184 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '157'
LIMIT 1
0.00028204917907715 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '158'
LIMIT 1
0.00027608871459961 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '151'
LIMIT 1
0.00032782554626465 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '152'
LIMIT 1
0.00031089782714844 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '153'
LIMIT 1
0.00040316581726074 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '154'
LIMIT 1
0.00034403800964355 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '155'
LIMIT 1
0.00027704238891602 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 270
AND fk_i_field_id = '156'
LIMIT 1
0.00074887275695801 SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2025-05-06 21:24:04') AND oc_t_item.pk_i_id < 270
AND oc_t_item.fk_i_category_id IN (237)
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.00047087669372559 SELECT oc_t_item.pk_i_id, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2025-05-06 21:24:04') AND oc_t_item.pk_i_id < 270
AND oc_t_item.fk_i_category_id IN (237)
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00026988983154297 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '263'
0.00063586235046387 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 = '263'
AND s.fk_i_item_id = '263'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00021195411682129 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '262'
0.00049400329589844 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 = '262'
AND s.fk_i_item_id = '262'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00020194053649902 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '260'
0.0005180835723877 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 = '260'
AND s.fk_i_item_id = '260'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00030517578125 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 263
AND dt_expiration_date >= '2025-05-06 21:24:04'
0.00025796890258789 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 263
0.00038290023803711 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=263
0.0002598762512207 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 262
AND dt_expiration_date >= '2025-05-06 21:24:04'
0.00024604797363281 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 262
0.00033402442932129 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=262
0.00026202201843262 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 260
AND dt_expiration_date >= '2025-05-06 21:24:04'
0.00024104118347168 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 260
0.00057101249694824 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=260
0.00013089179992676 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00053501129150391 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
7.7009201049805E-5 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.00029206275939941 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.00081396102905273 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00018787384033203 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00063395500183105 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.00021505355834961 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00026702880859375 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00063014030456543 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00025510787963867 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00054788589477539 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.00020503997802734 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00037312507629395 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.0005340576171875 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00024294853210449 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC
06/05/2025 - 21:24:04 [ OPERATION OK ] Connected to 'sugmoto_house': [DBHOST] = localhost | [DBUSER] = sugmoto_house
06/05/2025 - 21:24:04 [ OPERATION OK ] SELECT user_id, pic_ext FROM oc_t_profile_picture WHERE user_id = '22'
06/05/2025 - 21:24:04 [ OPERATION OK ] Connection with 'sugmoto_house' released properly