Dzięki! Jest to bardzo pomocne!

test

Mieszkania Polska
 
PLN brutto 0 PLN netto

Krzysztof

  • 0

Pochodzenie oferty

Opis

test

  Database queries (Total queries: 155 - Total queries time: 0.05536675453186)  
0.0010850429534912 SELECT *
FROM (oc_t_preference)
0.00056695938110352 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00015687942504883 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0008690357208252 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 = '255'
GROUP BY s.fk_i_item_id
0.0002589225769043 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '255'
0.0012369155883789 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (255, '2024-05-18 15:47:24',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.00022602081298828 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '22'
0.00022697448730469 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00020909309387207 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.00055313110351562 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 255
0.00030899047851562 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00028300285339355 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
0.00021696090698242 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00023412704467773 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
0.00019979476928711 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00022506713867188 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.00080990791320801 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.00015497207641602 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.0004119873046875 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.0011208057403564 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00015377998352051 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 236
AND s_plugin_name = 'custom_attributes'
0.00016093254089355 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.00025796890258789 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00016403198242188 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.00022792816162109 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.00016188621520996 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.00041985511779785 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '120'
LIMIT 1
0.00035810470581055 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '5'
LIMIT 1
0.00033998489379883 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '3'
LIMIT 1
0.00032401084899902 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '61'
LIMIT 1
0.00032496452331543 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '4'
LIMIT 1
0.00037407875061035 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '202'
LIMIT 1
0.00020790100097656 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.00039196014404297 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '32'
LIMIT 1
0.00038909912109375 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '31'
LIMIT 1
0.00038003921508789 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '28'
LIMIT 1
0.00039196014404297 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '33'
LIMIT 1
0.00027799606323242 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '186'
LIMIT 1
0.00039005279541016 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '34'
LIMIT 1
0.00037407875061035 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '29'
LIMIT 1
0.00034809112548828 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '30'
LIMIT 1
0.00032496452331543 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '125'
LIMIT 1
0.00032496452331543 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '223'
LIMIT 1
0.00036215782165527 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '219'
LIMIT 1
0.00035285949707031 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '188'
LIMIT 1
0.00024604797363281 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '83'
LIMIT 1
0.0002439022064209 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '129'
LIMIT 1
0.00023794174194336 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '84'
LIMIT 1
0.00024294853210449 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '192'
LIMIT 1
0.00021886825561523 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '185'
LIMIT 1
0.00039410591125488 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '221'
LIMIT 1
0.00043106079101562 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '222'
LIMIT 1
0.00046110153198242 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '184'
LIMIT 1
0.00044798851013184 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '35'
LIMIT 1
0.00039100646972656 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '123'
LIMIT 1
0.00041389465332031 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '217'
LIMIT 1
0.00020313262939453 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.00034403800964355 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '85'
LIMIT 1
0.00033998489379883 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '121'
LIMIT 1
0.0003359317779541 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '122'
LIMIT 1
0.00026988983154297 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '147'
LIMIT 1
0.00036907196044922 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '57'
LIMIT 1
0.00034093856811523 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '58'
LIMIT 1
0.0003201961517334 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '59'
LIMIT 1
0.00037479400634766 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '60'
LIMIT 1
0.00017619132995605 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.00037097930908203 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '116'
LIMIT 1
0.00033688545227051 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '117'
LIMIT 1
0.00033712387084961 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '118'
LIMIT 1
0.00036787986755371 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '119'
LIMIT 1
0.00033307075500488 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '195'
LIMIT 1
0.00036501884460449 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '196'
LIMIT 1
0.00037002563476562 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '197'
LIMIT 1
0.00029110908508301 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '200'
LIMIT 1
0.00020098686218262 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.0003809928894043 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '14'
LIMIT 1
0.00034713745117188 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '15'
LIMIT 1
0.00034618377685547 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '17'
LIMIT 1
0.00033402442932129 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '18'
LIMIT 1
0.00034284591674805 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '20'
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 = '10'
ORDER BY s_label ASC
0.00041484832763672 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '77'
LIMIT 1
0.00033211708068848 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '159'
LIMIT 1
0.00032520294189453 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '87'
LIMIT 1
0.00033807754516602 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '86'
LIMIT 1
0.00033688545227051 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '90'
LIMIT 1
0.00033807754516602 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '161'
LIMIT 1
0.0003349781036377 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '89'
LIMIT 1
0.00035190582275391 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 255
AND fk_i_field_id = '160'
LIMIT 1
0.00051116943359375 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 15:47:24') AND oc_t_item.pk_i_id < 255
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.00042510032653809 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 15:47:24') AND oc_t_item.pk_i_id < 255
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 900000
0.0010840892791748 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 15:47:24') AND oc_t_item.pk_i_id != 255
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.0015759468078613 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 15:47:24') AND oc_t_item.pk_i_id != 255
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00016903877258301 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1170'
0.00067996978759766 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.0001678466796875 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1169'
0.00053906440734863 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.00017094612121582 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1168'
0.00063204765319824 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.00015091896057129 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1167'
0.00060105323791504 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.00015401840209961 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1166'
0.0005490779876709 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.00015807151794434 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1165'
0.00054788589477539 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
8.7976455688477E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1164'
0.00071001052856445 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.00019478797912598 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1163'
0.00054693222045898 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.00015497207641602 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1162'
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 = '1162'
AND s.fk_i_item_id = '1162'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00028109550476074 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1170
AND dt_expiration_date >= '2024-05-18 15:47:24'
0.00016593933105469 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1170
0.00016093254089355 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00024700164794922 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.00034189224243164 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1169
AND dt_expiration_date >= '2024-05-18 15:47:24'
0.00016212463378906 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1169
0.00017809867858887 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.0003349781036377 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1168
AND dt_expiration_date >= '2024-05-18 15:47:24'
0.00018906593322754 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1168
0.00015997886657715 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.00032782554626465 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1167
AND dt_expiration_date >= '2024-05-18 15:47:24'
0.00023913383483887 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1167
0.00016403198242188 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.00033307075500488 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1166
AND dt_expiration_date >= '2024-05-18 15:47:24'
0.00016999244689941 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1166
0.00024890899658203 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.00036215782165527 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1165
AND dt_expiration_date >= '2024-05-18 15:47:24'
0.00023317337036133 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1165
0.00023794174194336 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.00033807754516602 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1164
AND dt_expiration_date >= '2024-05-18 15:47:24'
0.00016999244689941 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1164
0.00022602081298828 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.00039005279541016 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1163
AND dt_expiration_date >= '2024-05-18 15:47:24'
0.00019693374633789 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1163
0.00012397766113281 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.00034689903259277 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1162
AND dt_expiration_date >= '2024-05-18 15:47:24'
0.0002288818359375 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1162
0.00023508071899414 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.00021886825561523 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00060296058654785 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.0002281665802002 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.00041294097900391 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0010449886322021 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00018692016601562 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.0005180835723877 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.00019502639770508 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00030994415283203 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00044107437133789 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00022196769714355 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00059199333190918 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.00023293495178223 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00041508674621582 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00074100494384766 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00023198127746582 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC
18/05/2024 - 15:47:24 [ OPERATION OK ] Connected to 'sugmoto_house': [DBHOST] = localhost | [DBUSER] = sugmoto_house
18/05/2024 - 15:47:24 [ OPERATION OK ] SELECT user_id, pic_ext FROM oc_t_profile_picture WHERE user_id = '22'
18/05/2024 - 15:47:24 [ OPERATION OK ] Connection with 'sugmoto_house' released properly