test

Mieszkania Warszawa, mazowieckie, Polska
333 333 PLN brutto 271 002 PLN netto  
333 333 PLN brutto 271 002 PLN netto

Krzysztof

  • 0

Pochodzenie oferty

Region mazowieckie
Miasto Warszawa
Adres Testowa Ulica

Informacje o ogłoszeniu

Ilość m2 333
Rodzaj ogłoszenia Na sprzedaż

Opis

rwetewrtwe

  Database queries (Total queries: 184 - Total queries time: 0.09607720375061)  
0.00096392631530762 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.00022482872009277 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0011970996856689 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 = '1139'
GROUP BY s.fk_i_item_id
0.0002589225769043 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '1139'
0.0014729499816895 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (1139, '2024-05-02 23:50:21',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.00053501129150391 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '22'
0.00037193298339844 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00023198127746582 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.00039100646972656 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1139
0.00033187866210938 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00054788589477539 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.00020480155944824 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781807'
0.00024509429931641 SELECT *
FROM (oc_t_region)
WHERE s_name = 'mazowieckie'
LIMIT 1
0.00046992301940918 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.00028204917907715 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.00023317337036133 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.00033402442932129 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
6.103515625E-5 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
6.9856643676758E-5 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
5.1975250244141E-5 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00033116340637207 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.0011391639709473 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.00021004676818848 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.00041604042053223 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.0013561248779297 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00057387351989746 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 236
AND s_plugin_name = 'custom_attributes'
0.00059914588928223 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.00030612945556641 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00023388862609863 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.00021004676818848 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.00072312355041504 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '120'
LIMIT 1
0.00077700614929199 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '5'
LIMIT 1
0.00075912475585938 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '3'
LIMIT 1
0.00085902214050293 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '61'
LIMIT 1
0.00075793266296387 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '4'
LIMIT 1
0.00042486190795898 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '202'
LIMIT 1
0.00018095970153809 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '120'
LIMIT 1
0.00018095970153809 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '5'
LIMIT 1
0.00020718574523926 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '3'
LIMIT 1
0.00018000602722168 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '61'
LIMIT 1
0.00020599365234375 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '4'
LIMIT 1
0.00018000602722168 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '202'
LIMIT 1
0.0001988410949707 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.00054597854614258 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '32'
LIMIT 1
0.00049805641174316 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '31'
LIMIT 1
0.00049495697021484 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '28'
LIMIT 1
0.00049090385437012 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '33'
LIMIT 1
0.00041604042053223 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '186'
LIMIT 1
0.00044894218444824 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '34'
LIMIT 1
0.00045108795166016 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '29'
LIMIT 1
0.00051307678222656 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '30'
LIMIT 1
0.00047492980957031 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '125'
LIMIT 1
0.00042200088500977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '223'
LIMIT 1
0.00042200088500977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '219'
LIMIT 1
0.0004122257232666 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '188'
LIMIT 1
0.00047683715820312 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '83'
LIMIT 1
0.00046181678771973 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '129'
LIMIT 1
0.00048112869262695 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '84'
LIMIT 1
0.00041604042053223 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '192'
LIMIT 1
0.00038409233093262 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '185'
LIMIT 1
0.00040102005004883 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '221'
LIMIT 1
0.00038003921508789 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '222'
LIMIT 1
0.00037789344787598 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '184'
LIMIT 1
0.00045394897460938 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '35'
LIMIT 1
0.00043988227844238 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '123'
LIMIT 1
0.00038385391235352 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '217'
LIMIT 1
0.00019693374633789 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.00048995018005371 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '85'
LIMIT 1
0.00048613548278809 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '121'
LIMIT 1
0.00045609474182129 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
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 = 1139
AND fk_i_field_id = '147'
LIMIT 1
0.00056195259094238 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '57'
LIMIT 1
0.00051689147949219 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '58'
LIMIT 1
0.00049996376037598 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '59'
LIMIT 1
0.00049996376037598 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '60'
LIMIT 1
0.00019693374633789 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.00041484832763672 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '116'
LIMIT 1
0.00048613548278809 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '117'
LIMIT 1
0.00040411949157715 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '118'
LIMIT 1
0.00041794776916504 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '119'
LIMIT 1
0.00039792060852051 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '195'
LIMIT 1
0.00039505958557129 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '196'
LIMIT 1
0.00039196014404297 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '197'
LIMIT 1
0.00041508674621582 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
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.00085711479187012 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '14'
LIMIT 1
0.00072503089904785 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '15'
LIMIT 1
0.00072503089904785 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '17'
LIMIT 1
0.00071883201599121 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '18'
LIMIT 1
0.00072503089904785 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '20'
LIMIT 1
0.00018501281738281 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.00072789192199707 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '77'
LIMIT 1
0.00040411949157715 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '159'
LIMIT 1
0.00071096420288086 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '87'
LIMIT 1
0.00072097778320312 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '86'
LIMIT 1
0.00072503089904785 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '90'
LIMIT 1
0.00036096572875977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '161'
LIMIT 1
0.00069785118103027 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '89'
LIMIT 1
0.00039887428283691 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '160'
LIMIT 1
0.0082700252532959 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-02 23:50:21') AND oc_t_item.pk_i_id < 1139
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.0021870136260986 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-02 23:50:21') AND oc_t_item.pk_i_id < 1139
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.00038409233093262 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1065'
0.0006098747253418 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 = '1065'
AND s.fk_i_item_id = '1065'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00040292739868164 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1064'
0.00046586990356445 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 = '1064'
AND s.fk_i_item_id = '1064'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00025701522827148 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1063'
0.00054407119750977 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 = '1063'
AND s.fk_i_item_id = '1063'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0003809928894043 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1049'
0.00059390068054199 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 = '1049'
AND s.fk_i_item_id = '1049'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00036287307739258 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1047'
0.00050902366638184 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 = '1047'
AND s.fk_i_item_id = '1047'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00046610832214355 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1046'
0.00054001808166504 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1046'
AND s.fk_i_item_id = '1046'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00035715103149414 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1044'
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 = '1044'
AND s.fk_i_item_id = '1044'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0003349781036377 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1042'
0.00049686431884766 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 = '1042'
AND s.fk_i_item_id = '1042'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00050997734069824 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1040'
0.00051212310791016 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 = '1040'
AND s.fk_i_item_id = '1040'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.001230001449585 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-02 23:50:21') AND oc_t_item.pk_i_id != 1139
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.0015189647674561 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-02 23:50:21') AND oc_t_item.pk_i_id != 1139
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00048017501831055 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1170'
0.00069189071655273 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.00031399726867676 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1169'
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 = '1169'
AND s.fk_i_item_id = '1169'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00032877922058105 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1168'
0.00053811073303223 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.0003209114074707 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1167'
0.00059700012207031 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.0003349781036377 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1166'
0.00055193901062012 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1166'
AND s.fk_i_item_id = '1166'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0003199577331543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1165'
0.00053882598876953 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.00032997131347656 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1164'
0.00055623054504395 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.00028896331787109 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1163'
0.00057601928710938 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.00038909912109375 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1162'
0.00057387351989746 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.00037789344787598 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1170
AND dt_expiration_date >= '2024-05-02 23:50:21'
0.00040912628173828 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1170
0.00095486640930176 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.00031304359436035 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1169
AND dt_expiration_date >= '2024-05-02 23:50:21'
0.00040197372436523 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1169
0.00078296661376953 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.00031089782714844 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1168
AND dt_expiration_date >= '2024-05-02 23:50:21'
0.00036787986755371 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1168
0.00083088874816895 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.00037407875061035 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1167
AND dt_expiration_date >= '2024-05-02 23:50:21'
0.00043201446533203 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1167
0.0010440349578857 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.00038695335388184 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1166
AND dt_expiration_date >= '2024-05-02 23:50:21'
0.00036501884460449 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1166
0.00098609924316406 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.00023794174194336 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1165
AND dt_expiration_date >= '2024-05-02 23:50:21'
0.00027108192443848 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1165
0.00074410438537598 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.00021696090698242 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1164
AND dt_expiration_date >= '2024-05-02 23:50:21'
0.00046801567077637 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1164
0.000762939453125 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.00024294853210449 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1163
AND dt_expiration_date >= '2024-05-02 23:50:21'
0.0003049373626709 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1163
0.00074315071105957 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.00024080276489258 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1162
AND dt_expiration_date >= '2024-05-02 23:50:21'
0.00027704238891602 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1162
0.00086712837219238 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.00012111663818359 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00056910514831543 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.00013303756713867 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.00027894973754883 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.00078892707824707 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00010085105895996 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00051712989807129 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.00013399124145508 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00026392936706543 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00064992904663086 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.0001368522644043 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00049090385437012 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.00010800361633301 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00038480758666992 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00066113471984863 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00027799606323242 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC
02/05/2024 - 23:50:21 [ OPERATION OK ] Connected to 'sugmoto_house': [DBHOST] = localhost | [DBUSER] = sugmoto_house
02/05/2024 - 23:50:21 [ OPERATION OK ] SELECT user_id, pic_ext FROM oc_t_profile_picture WHERE user_id = '22'
02/05/2024 - 23:50:21 [ OPERATION OK ] Connection with 'sugmoto_house' released properly