Dzięki! Jest to bardzo pomocne!

test koparka

Mieszkania Polska
10 000 PLN brutto 8 130 PLN netto  
10 000 PLN brutto 8 130 PLN netto

Krzysztof

  • 0

Pochodzenie oferty

Opis

test

  Database queries (Total queries: 123 - Total queries time: 0.048092603683472)  
0.0008540153503418 SELECT *
FROM (oc_t_preference)
0.00054001808166504 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00021481513977051 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00075912475585938 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 = '258'
GROUP BY s.fk_i_item_id
7.0095062255859E-5 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '258'
0.00081801414489746 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (258, '2024-05-18 19:48:15',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.00034189224243164 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '22'
0.00032997131347656 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00020503997802734 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.00043392181396484 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 258
0.00030183792114258 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00029897689819336 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00053906440734863 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
0.00028300285339355 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00018596649169922 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 22
0.0001678466796875 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '22'
0.00025606155395508 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.00092601776123047 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.00020289421081543 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.00043606758117676 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.001101016998291 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00025510787963867 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 236
AND s_plugin_name = 'custom_attributes'
0.00025081634521484 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.00033211708068848 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00024914741516113 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.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 = '26'
ORDER BY i_order ASC
0.00019001960754395 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '1'
ORDER BY i_order ASC
0.00049710273742676 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '120'
LIMIT 1
0.00039911270141602 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '5'
LIMIT 1
0.0003659725189209 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '3'
LIMIT 1
0.0003809928894043 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '61'
LIMIT 1
0.00037717819213867 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '4'
LIMIT 1
0.00039100646972656 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '202'
LIMIT 1
0.0002291202545166 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.00036191940307617 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '32'
LIMIT 1
0.00023102760314941 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '31'
LIMIT 1
0.00036883354187012 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '28'
LIMIT 1
0.00036501884460449 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '33'
LIMIT 1
0.00035786628723145 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '186'
LIMIT 1
0.00037503242492676 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '34'
LIMIT 1
0.00037097930908203 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '29'
LIMIT 1
0.00040483474731445 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '30'
LIMIT 1
0.00033283233642578 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '125'
LIMIT 1
0.00043320655822754 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '223'
LIMIT 1
0.00039911270141602 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '219'
LIMIT 1
0.00038909912109375 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '188'
LIMIT 1
0.00037693977355957 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '83'
LIMIT 1
0.00036406517028809 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '129'
LIMIT 1
0.00035715103149414 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '84'
LIMIT 1
0.00034904479980469 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '192'
LIMIT 1
0.0003349781036377 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '185'
LIMIT 1
0.00031805038452148 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '221'
LIMIT 1
0.00033187866210938 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '222'
LIMIT 1
0.00037288665771484 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '184'
LIMIT 1
0.00037407875061035 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '35'
LIMIT 1
0.0003669261932373 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '123'
LIMIT 1
0.00036096572875977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '217'
LIMIT 1
0.00021600723266602 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.00040698051452637 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '85'
LIMIT 1
0.00034308433532715 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '121'
LIMIT 1
0.00036311149597168 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '122'
LIMIT 1
0.00036501884460449 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '147'
LIMIT 1
0.00036406517028809 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '57'
LIMIT 1
0.00037407875061035 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '58'
LIMIT 1
0.00035500526428223 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '59'
LIMIT 1
0.00037097930908203 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '60'
LIMIT 1
0.00017118453979492 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.0003199577331543 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '116'
LIMIT 1
0.00036001205444336 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '117'
LIMIT 1
0.00037908554077148 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '118'
LIMIT 1
0.00040888786315918 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '119'
LIMIT 1
0.0004119873046875 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '195'
LIMIT 1
0.00040984153747559 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '196'
LIMIT 1
0.00040602684020996 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '197'
LIMIT 1
0.00046300888061523 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '200'
LIMIT 1
0.00022315979003906 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.00038814544677734 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '14'
LIMIT 1
0.00036907196044922 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '15'
LIMIT 1
0.00036096572875977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '17'
LIMIT 1
0.00041699409484863 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '18'
LIMIT 1
0.00037813186645508 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '20'
LIMIT 1
0.00016689300537109 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.00043511390686035 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '77'
LIMIT 1
0.00039982795715332 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '159'
LIMIT 1
0.00040793418884277 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '87'
LIMIT 1
0.00039911270141602 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '86'
LIMIT 1
0.00037097930908203 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '90'
LIMIT 1
0.0003361701965332 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '161'
LIMIT 1
0.00034308433532715 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '89'
LIMIT 1
0.0004119873046875 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 258
AND fk_i_field_id = '160'
LIMIT 1
0.00066399574279785 SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2024-05-18 19:48:15') AND oc_t_item.pk_i_id < 258
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.00051403045654297 SELECT oc_t_item.pk_i_id, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2024-05-18 19:48:15') AND oc_t_item.pk_i_id < 258
AND oc_t_item.fk_i_category_id IN (236)
ORDER BY dt_pub_date DESC
LIMIT 900000
0.0003809928894043 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '257'
0.00055408477783203 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 = '257'
AND s.fk_i_item_id = '257'
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 = '256'
0.00058889389038086 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 = '256'
AND s.fk_i_item_id = '256'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00034689903259277 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '255'
0.00054621696472168 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 = '255'
AND s.fk_i_item_id = '255'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00036501884460449 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 257
AND dt_expiration_date >= '2024-05-18 19:48:15'
0.00035905838012695 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 257
0.0004279613494873 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=257
0.00033092498779297 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 256
AND dt_expiration_date >= '2024-05-18 19:48:15'
0.00035595893859863 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 256
0.00041699409484863 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=256
0.0004417896270752 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 255
AND dt_expiration_date >= '2024-05-18 19:48:15'
0.00034308433532715 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 255
0.00042581558227539 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=255
0.0001530647277832 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00064802169799805 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.00036501884460449 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.00017309188842773 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00052690505981445 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.00015497207641602 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00038981437683105 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00095605850219727 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00020003318786621 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00055193901062012 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.00021195411682129 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00039005279541016 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00098395347595215 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00021600723266602 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC
18/05/2024 - 19:48:15 [ OPERATION OK ] Connected to 'sugmoto_house': [DBHOST] = localhost | [DBUSER] = sugmoto_house
18/05/2024 - 19:48:15 [ OPERATION OK ] SELECT user_id, pic_ext FROM oc_t_profile_picture WHERE user_id = '22'
18/05/2024 - 19:48:15 [ OPERATION OK ] Connection with 'sugmoto_house' released properly