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.088643789291382)  
0.0013258457183838 SELECT *
FROM (oc_t_preference)
0.00063610076904297 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.0002748966217041 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0010881423950195 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.00019717216491699 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '1139'
0.0007939338684082 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (1139, '2024-05-02 17:08:41',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.0006258487701416 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '22'
0.00037288665771484 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00022006034851074 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.00041007995605469 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1139
0.00024318695068359 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00051093101501465 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.00033092498779297 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781807'
0.00039100646972656 SELECT *
FROM (oc_t_region)
WHERE s_name = 'mazowieckie'
LIMIT 1
0.00039291381835938 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.00024890899658203 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.00017285346984863 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.00048589706420898 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
0.00025677680969238 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00023698806762695 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
0.00018000602722168 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00022602081298828 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.00063180923461914 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.0001828670501709 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.00038695335388184 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.00095391273498535 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00042009353637695 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 236
AND s_plugin_name = 'custom_attributes'
0.00044798851013184 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.00028800964355469 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00027704238891602 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.00023579597473145 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.00018095970153809 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.00070285797119141 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.00070405006408691 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.00081205368041992 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.00069999694824219 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.00072383880615234 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.00041604042053223 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.00017595291137695 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.00016999244689941 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 1139
AND fk_i_field_id = '5'
LIMIT 1
9.6797943115234E-5 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.00016093254089355 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.00019192695617676 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.0001521110534668 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.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 = '4'
ORDER BY i_order ASC
0.00048494338989258 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.00043916702270508 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.00046515464782715 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.00048184394836426 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.00038886070251465 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.00047898292541504 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.00047016143798828 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.00044488906860352 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.00044798851013184 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.00040292739868164 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.00038909912109375 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.00041389465332031 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.00045394897460938 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.00048494338989258 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.00046300888061523 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.00040793418884277 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.00040817260742188 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.00036001205444336 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.00046706199645996 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.0004880428314209 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.00044012069702148 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.00039911270141602 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.00013589859008789 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '6'
ORDER BY i_order ASC
0.00050616264343262 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.00045299530029297 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.00048995018005371 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.00038981437683105 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.00056910514831543 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.00050592422485352 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.00051188468933105 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.00052809715270996 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.00021505355834961 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.00041508674621582 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.00040292739868164 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.00038003921508789 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.00044989585876465 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.0003809928894043 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.00044679641723633 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.00047206878662109 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.00041604042053223 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.00018095970153809 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.00074601173400879 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.00072598457336426 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.00072121620178223 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.00072097778320312 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.00068211555480957 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.00013399124145508 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.00071096420288086 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.00039386749267578 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.00073814392089844 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.00071310997009277 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.00069403648376465 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.00041508674621582 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.0003969669342041 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.0013179779052734 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 17:08:41') 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.0021500587463379 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 17:08:41') 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.00039505958557129 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1065'
0.00056195259094238 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.00035309791564941 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1064'
0.00048089027404785 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.00026082992553711 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1063'
0.00048017501831055 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.00040984153747559 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1049'
0.00054287910461426 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.00034308433532715 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1047'
0.00051593780517578 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.00033116340637207 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1046'
0.00051689147949219 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.0003209114074707 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1044'
0.00048303604125977 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.00034499168395996 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1042'
0.00049996376037598 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.00037908554077148 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1040'
0.00050878524780273 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.0012028217315674 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 17:08:41') 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.001539945602417 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 17:08:41') 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.00035810470581055 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1170'
0.00067591667175293 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.0003209114074707 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1169'
0.00071883201599121 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.00033998489379883 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1168'
0.00060319900512695 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.0003659725189209 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1167'
0.00057506561279297 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.00034499168395996 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1166'
0.00065803527832031 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.00033092498779297 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1165'
0.00054097175598145 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.00033092498779297 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1164'
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 = '1164'
AND s.fk_i_item_id = '1164'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00033211708068848 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1163'
0.00054812431335449 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.00033307075500488 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1162'
0.00057291984558105 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.00031399726867676 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1170
AND dt_expiration_date >= '2024-05-02 17:08:41'
0.00049114227294922 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1170
0.00081205368041992 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.00022196769714355 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1169
AND dt_expiration_date >= '2024-05-02 17:08:41'
0.00037598609924316 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1169
0.00078701972961426 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.00035405158996582 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1168
AND dt_expiration_date >= '2024-05-02 17:08:41'
0.00034809112548828 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1168
0.0010671615600586 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.00034499168395996 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1167
AND dt_expiration_date >= '2024-05-02 17:08:41'
0.00042200088500977 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1167
0.001133918762207 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.0003199577331543 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1166
AND dt_expiration_date >= '2024-05-02 17:08:41'
0.00036311149597168 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1166
0.00087094306945801 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.00029516220092773 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1165
AND dt_expiration_date >= '2024-05-02 17:08:41'
0.00032401084899902 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1165
0.00081801414489746 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.00029492378234863 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1164
AND dt_expiration_date >= '2024-05-02 17:08:41'
0.00036311149597168 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1164
0.00082993507385254 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.00029993057250977 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1163
AND dt_expiration_date >= '2024-05-02 17:08:41'
0.00042986869812012 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1163
0.00082707405090332 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.00029802322387695 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1162
AND dt_expiration_date >= '2024-05-02 17:08:41'
0.00036287307739258 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1162
0.00081110000610352 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.00014996528625488 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00068783760070801 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.00021505355834961 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.00040602684020996 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.00097298622131348 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00017619132995605 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00053191184997559 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.00025582313537598 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00035786628723145 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00084090232849121 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00014996528625488 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.00016188621520996 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00035285949707031 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00080609321594238 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00018000602722168 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC
02/05/2024 - 17:08:41 [ OPERATION OK ] Connected to 'sugmoto_house': [DBHOST] = localhost | [DBUSER] = sugmoto_house
02/05/2024 - 17:08:41 [ OPERATION OK ] SELECT user_id, pic_ext FROM oc_t_profile_picture WHERE user_id = '22'
02/05/2024 - 17:08:41 [ OPERATION OK ] Connection with 'sugmoto_house' released properly