Dzięki! Jest to bardzo pomocne!

asd

Domy asd, Polska
 
PLN brutto 0 PLN netto
  • 0

Pochodzenie oferty

Miasto asd
Adres Asd

Opis

asdasdasdasd

  Database queries (Total queries: 176 - Total queries time: 0.069566249847412)  
0.00083613395690918 SELECT *
FROM (oc_t_preference)
0.00038409233093262 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
8.7976455688477E-5 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0007011890411377 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 = '260'
GROUP BY s.fk_i_item_id
6.8902969360352E-5 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '260'
0.00036215782165527 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (260, '2024-05-18 19:41:47',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.00030708312988281 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '1'
0.00022196769714355 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '1'
9.9897384643555E-5 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.00050592422485352 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 260
0.00024509429931641 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00049114227294922 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 1
0.00025796890258789 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '1'
0.000244140625 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 1
0.00020003318786621 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '1'
0.00022411346435547 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.00059008598327637 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.00015997886657715 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.00042390823364258 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.00084090232849121 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00046801567077637 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 237
AND s_plugin_name = 'custom_attributes'
0.00052714347839355 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.00026893615722656 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00026202201843262 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.00025296211242676 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.00039291381835938 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '39'
LIMIT 1
0.00032281875610352 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '44'
LIMIT 1
0.00035405158996582 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '45'
LIMIT 1
0.00024914741516113 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '42'
LIMIT 1
0.0002448558807373 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '36'
LIMIT 1
0.00035405158996582 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '53'
LIMIT 1
0.00024318695068359 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '98'
LIMIT 1
0.00024008750915527 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '37'
LIMIT 1
0.00023889541625977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '38'
LIMIT 1
0.0002448558807373 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '43'
LIMIT 1
0.00033688545227051 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '218'
LIMIT 1
0.00032305717468262 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '50'
LIMIT 1
0.00028586387634277 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '91'
LIMIT 1
0.00028395652770996 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '130'
LIMIT 1
0.00029182434082031 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '51'
LIMIT 1
0.0002589225769043 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '41'
LIMIT 1
0.00026178359985352 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '47'
LIMIT 1
0.0002739429473877 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '46'
LIMIT 1
0.00028109550476074 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '52'
LIMIT 1
0.00032401084899902 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '124'
LIMIT 1
0.00034284591674805 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '216'
LIMIT 1
0.00012302398681641 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.00031900405883789 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '120'
LIMIT 1
0.0002901554107666 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '5'
LIMIT 1
0.00023913383483887 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '3'
LIMIT 1
0.0003349781036377 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '61'
LIMIT 1
0.00032997131347656 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '4'
LIMIT 1
0.00030612945556641 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '202'
LIMIT 1
0.00018882751464844 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.00032496452331543 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '85'
LIMIT 1
0.00031900405883789 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '121'
LIMIT 1
0.00032591819763184 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '122'
LIMIT 1
0.00031280517578125 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '147'
LIMIT 1
0.00039196014404297 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '57'
LIMIT 1
0.00032401084899902 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '58'
LIMIT 1
0.00030612945556641 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '59'
LIMIT 1
0.00031399726867676 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '60'
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 = '18'
ORDER BY i_order ASC
0.00031518936157227 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '143'
LIMIT 1
0.00030303001403809 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '144'
LIMIT 1
0.0001990795135498 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.00032401084899902 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '116'
LIMIT 1
0.00041508674621582 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '117'
LIMIT 1
0.00034379959106445 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '118'
LIMIT 1
0.00030922889709473 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '119'
LIMIT 1
0.00034189224243164 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '195'
LIMIT 1
0.00030398368835449 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '196'
LIMIT 1
0.0003058910369873 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '197'
LIMIT 1
0.00030517578125 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '200'
LIMIT 1
0.00019288063049316 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.00028896331787109 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '14'
LIMIT 1
0.00057888031005859 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '15'
LIMIT 1
0.00031089782714844 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '17'
LIMIT 1
0.00031304359436035 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '18'
LIMIT 1
0.0003058910369873 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '20'
LIMIT 1
0.00019001960754395 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.00030779838562012 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '176'
LIMIT 1
0.00019502639770508 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.00032401084899902 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '77'
LIMIT 1
0.00032806396484375 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '159'
LIMIT 1
0.00057721138000488 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '87'
LIMIT 1
0.00038909912109375 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '86'
LIMIT 1
0.00034499168395996 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '90'
LIMIT 1
0.00034403800964355 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '161'
LIMIT 1
0.00035500526428223 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '89'
LIMIT 1
0.00034308433532715 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '160'
LIMIT 1
0.00020694732666016 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.00035810470581055 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '133'
LIMIT 1
0.00030994415283203 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '134'
LIMIT 1
0.00031685829162598 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '136'
LIMIT 1
0.00037312507629395 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '137'
LIMIT 1
0.00030684471130371 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '138'
LIMIT 1
0.00034284591674805 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '139'
LIMIT 1
0.00033783912658691 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '140'
LIMIT 1
0.00033688545227051 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '141'
LIMIT 1
0.00036096572875977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '142'
LIMIT 1
0.00018715858459473 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.0003960132598877 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '157'
LIMIT 1
0.00035905838012695 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '158'
LIMIT 1
0.00037217140197754 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '151'
LIMIT 1
0.00031208992004395 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '152'
LIMIT 1
0.00033807754516602 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '153'
LIMIT 1
0.00037407875061035 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '154'
LIMIT 1
0.00036406517028809 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '155'
LIMIT 1
0.00034999847412109 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 260
AND fk_i_field_id = '156'
LIMIT 1
0.00061202049255371 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-18 19:41:47') AND oc_t_item.pk_i_id < 260
AND oc_t_item.fk_i_category_id IN (237)
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.00050997734069824 SELECT oc_t_item.pk_i_id, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2024-05-18 19:41:47') AND oc_t_item.pk_i_id < 260
AND oc_t_item.fk_i_category_id IN (237)
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00093293190002441 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-18 19:41:47') AND oc_t_item.pk_i_id != 260
AND oc_t_item.fk_i_category_id IN (237)
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.0011289119720459 SELECT oc_t_item.pk_i_id, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2024-05-18 19:41:47') AND oc_t_item.pk_i_id != 260
AND oc_t_item.fk_i_category_id IN (237)
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00042104721069336 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1150'
0.00073599815368652 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 = '1150'
AND s.fk_i_item_id = '1150'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00035619735717773 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1149'
0.0012500286102295 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 = '1149'
AND s.fk_i_item_id = '1149'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.0003349781036377 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1148'
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 = '1148'
AND s.fk_i_item_id = '1148'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00035405158996582 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1147'
0.00070905685424805 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 = '1147'
AND s.fk_i_item_id = '1147'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00018715858459473 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1146'
0.0017311573028564 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 = '1146'
AND s.fk_i_item_id = '1146'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00033092498779297 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1140'
0.00062108039855957 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 = '1140'
AND s.fk_i_item_id = '1140'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00035405158996582 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1082'
0.00058102607727051 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 = '1082'
AND s.fk_i_item_id = '1082'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00049400329589844 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1081'
0.00057411193847656 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 = '1081'
AND s.fk_i_item_id = '1081'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00034594535827637 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1075'
0.0005948543548584 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 = '1075'
AND s.fk_i_item_id = '1075'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00033688545227051 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1150
AND dt_expiration_date >= '2024-05-18 19:41:47'
0.00039196014404297 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1150
0.00018501281738281 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00093603134155273 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=1150
0.00033807754516602 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1149
AND dt_expiration_date >= '2024-05-18 19:41:47'
0.0003821849822998 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1149
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=1149
0.00034308433532715 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1148
AND dt_expiration_date >= '2024-05-18 19:41:47'
0.00037908554077148 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1148
0.00081300735473633 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=1148
0.00034189224243164 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1147
AND dt_expiration_date >= '2024-05-18 19:41:47'
0.00038290023803711 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1147
0.00081610679626465 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=1147
0.00033879280090332 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1146
AND dt_expiration_date >= '2024-05-18 19:41:47'
0.00025081634521484 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1146
0.00095200538635254 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=1146
0.00031709671020508 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1140
AND dt_expiration_date >= '2024-05-18 19:41:47'
0.00033807754516602 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1140
0.00081992149353027 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=1140
0.00033903121948242 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1082
AND dt_expiration_date >= '2024-05-18 19:41:47'
0.00036883354187012 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1082
0.00085210800170898 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=1082
0.00033211708068848 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1081
AND dt_expiration_date >= '2024-05-18 19:41:47'
0.00036406517028809 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1081
0.00078105926513672 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=1081
0.0003349781036377 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1075
AND dt_expiration_date >= '2024-05-18 19:41:47'
0.00036716461181641 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1075
0.00080108642578125 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=1075
0.00022077560424805 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00058507919311523 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.00015687942504883 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.00049710273742676 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0010890960693359 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00020122528076172 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00051999092102051 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.00016403198242188 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00029993057250977 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00071406364440918 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00020217895507812 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00051689147949219 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.00014781951904297 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00020289421081543 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00042009353637695 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00026416778564453 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC
18/05/2024 - 19:41:47 [ OPERATION OK ] Connected to 'sugmoto_house': [DBHOST] = localhost | [DBUSER] = sugmoto_house
18/05/2024 - 19:41:47 [ OPERATION OK ] SELECT user_id, pic_ext FROM oc_t_profile_picture WHERE user_id = '1'
18/05/2024 - 19:41:47 [ OPERATION OK ] Connection with 'sugmoto_house' released properly