0.0015580654144287 |
SELECT *
FROM (oc_t_preference) |
0.00085186958312988 |
REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING') |
0.00079703330993652 |
SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '32' |
0.00054287910461426 |
SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '32' |
0.0010509490966797 |
SELECT count(pk_i_id) as total
FROM (oc_t_item)
WHERE fk_i_user_id = 32
AND b_enabled = 1
AND b_active = 1
AND dt_expiration > '2025-07-27 09:30:12' |
0.0013828277587891 |
SELECT *
FROM (oc_t_item)
WHERE fk_i_user_id = 32
AND b_enabled = 1
AND b_active = 1
AND dt_expiration > '2025-07-27 09:30:12'
ORDER BY dt_pub_date DESC
LIMIT 60, 10 |
0.00019001960754395 |
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '444' |
0.00019097328186035 |
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 = '444'
AND s.fk_i_item_id = '444'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id |
0.00058817863464355 |
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '442' |
0.0010290145874023 |
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 = '442'
AND s.fk_i_item_id = '442'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id |
0.00053596496582031 |
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '441' |
0.00094699859619141 |
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 = '441'
AND s.fk_i_item_id = '441'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id |
0.00051307678222656 |
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '439' |
0.00098896026611328 |
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 = '439'
AND s.fk_i_item_id = '439'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id |
0.00050687789916992 |
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '436' |
0.0012202262878418 |
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 = '436'
AND s.fk_i_item_id = '436'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id |
0.00053715705871582 |
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '435' |
0.0010061264038086 |
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 = '435'
AND s.fk_i_item_id = '435'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id |
0.00047492980957031 |
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '434' |
0.00089502334594727 |
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 = '434'
AND s.fk_i_item_id = '434'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id |
0.00052905082702637 |
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '432' |
0.00088691711425781 |
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 = '432'
AND s.fk_i_item_id = '432'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id |
0.00048995018005371 |
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '431' |
0.000823974609375 |
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 = '431'
AND s.fk_i_item_id = '431'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id |
0.0005340576171875 |
SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '429' |
0.00095200538635254 |
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 = '429'
AND s.fk_i_item_id = '429'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id |
0.00062108039855957 |
SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 32 |
0.00022006034851074 |
SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '32' |
0.00032210350036621 |
SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC |
0.00030279159545898 |
SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 32 |
0.00022602081298828 |
SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '32' |
0.00030207633972168 |
SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 32 |
0.00022196769714355 |
SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '32' |
0.00025105476379395 |
SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 32 |
0.00017094612121582 |
SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '32' |
0.00069117546081543 |
SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 444
AND dt_expiration_date >= '2025-07-27 09:30:12' |
0.00022006034851074 |
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 444 |
0.00021219253540039 |
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.0002138614654541 |
SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN' |
0 |
Error number: 1054 Error description: Unknown column 'i_mileage' in 'field list'
SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=444 |
0.0012431144714355 |
SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 444
AND i.pk_i_id = 444 |
0.00062894821166992 |
SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 442
AND dt_expiration_date >= '2025-07-27 09:30:12' |
0.0008540153503418 |
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 442 |
0 |
Error number: 1054 Error description: Unknown column 'i_mileage' in 'field list'
SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=442 |
0.00089597702026367 |
SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 442
AND i.pk_i_id = 442 |
0.00049996376037598 |
SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 441
AND dt_expiration_date >= '2025-07-27 09:30:12' |
0.00061917304992676 |
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 441 |
0 |
Error number: 1054 Error description: Unknown column 'i_mileage' in 'field list'
SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=441 |
0.00086498260498047 |
SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 441
AND i.pk_i_id = 441 |
0.00054097175598145 |
SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 439
AND dt_expiration_date >= '2025-07-27 09:30:12' |
0.00061607360839844 |
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 439 |
0 |
Error number: 1054 Error description: Unknown column 'i_mileage' in 'field list'
SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=439 |
0.00077009201049805 |
SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 439
AND i.pk_i_id = 439 |
0.00058102607727051 |
SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 436
AND dt_expiration_date >= '2025-07-27 09:30:12' |
0.00070691108703613 |
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 436 |
0 |
Error number: 1054 Error description: Unknown column 'i_mileage' in 'field list'
SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=436 |
0.00081896781921387 |
SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 436
AND i.pk_i_id = 436 |
0.00070810317993164 |
SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 435
AND dt_expiration_date >= '2025-07-27 09:30:12' |
0.0012369155883789 |
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 435 |
0 |
Error number: 1054 Error description: Unknown column 'i_mileage' in 'field list'
SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=435 |
0.0008091926574707 |
SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 435
AND i.pk_i_id = 435 |
0.0006110668182373 |
SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 434
AND dt_expiration_date >= '2025-07-27 09:30:12' |
0.00074410438537598 |
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 434 |
0 |
Error number: 1054 Error description: Unknown column 'i_mileage' in 'field list'
SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=434 |
0.00084996223449707 |
SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 434
AND i.pk_i_id = 434 |
0.00064301490783691 |
SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 432
AND dt_expiration_date >= '2025-07-27 09:30:13' |
0.00071501731872559 |
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 432 |
0 |
Error number: 1054 Error description: Unknown column 'i_mileage' in 'field list'
SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=432 |
0.00096678733825684 |
SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 432
AND i.pk_i_id = 432 |
0.00055098533630371 |
SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 431
AND dt_expiration_date >= '2025-07-27 09:30:13' |
0.00077295303344727 |
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 431 |
0 |
Error number: 1054 Error description: Unknown column 'i_mileage' in 'field list'
SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=431 |
0.00095391273498535 |
SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 431
AND i.pk_i_id = 431 |
0.00071501731872559 |
SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 429
AND dt_expiration_date >= '2025-07-27 09:30:13' |
0.00080704689025879 |
SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 429 |
0 |
Error number: 1054 Error description: Unknown column 'i_mileage' in 'field list'
SELECT i_mileage,i_year FROM oc_t_item_custom_attr_values WHERE fk_i_item_id=429 |
0.00088596343994141 |
SELECT im.s_value as s_value, mf.pk_i_id as pk_i_id, mf.s_name as s_name, mf.e_type as e_type, im.s_multi as s_multi, mf.s_slug as s_slug
FROM (oc_t_item i, oc_t_item_meta im, oc_t_meta_categories mc, oc_t_meta_fields mf)
WHERE mf.pk_i_id = im.fk_i_field_id
AND mf.pk_i_id = mc.fk_i_field_id
AND mc.fk_i_category_id = i.fk_i_category_id
AND im.fk_i_item_id = 429
AND i.pk_i_id = 429 |
0.00031185150146484 |
SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 32 |
0.00023913383483887 |
SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '32' |
0.0011940002441406 |
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.0006709098815918 |
SELECT *
FROM (oc_t_banner)
WHERE b_id = '2' |
0.0013430118560791 |
UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2 |
0.001068115234375 |
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.00062394142150879 |
SELECT *
FROM (oc_t_banner)
WHERE b_id = '3' |
0.0010709762573242 |
UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3 |
0.00098609924316406 |
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.00083088874816895 |
SELECT *
FROM (oc_t_banner)
WHERE b_id = '4' |
0.0010340213775635 |
UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4 |
0.00023508071899414 |
SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC |