-----
(mysql): SET CHARACTER SET utf8
-----
-----
(mysql): SELECT * FROM sb_products WHERE id=246789
-----
-----
(mysql): SELECT t1.val, t2.name, t2.id FROM sb_rules t1, sb_parameters t2 WHERE t1.kid=t2.id AND t1.pid=246789
-----
-----
(mysql): SELECT * FROM sb_cateparagroup WHERE cateid=1338
-----
-----
(mysql): SELECT * FROM sb_categorys WHERE id=1338
-----
-----
(mysql): SELECT t1 . * , t2.pid, t2.cateid, t2.seque
FROM sb_parameters t1
LEFT JOIN (
SELECT *
FROM sb_category_seque
WHERE cateid =1338
) AS t2 ON t2.pid = t1.id
WHERE t1.id
IN ( 2741, 10490, 10492, 10495 ) ORDER BY t2.seque DESC
-----
-----
(mysql): SELECT t1 . * , t2.pid, t2.cateid, t2.seque
FROM sb_parameters t1
LEFT JOIN (
SELECT *
FROM sb_category_seque
WHERE cateid =1338
) AS t2 ON t2.pid = t1.id
WHERE t1.id
IN ( 2706, 3352, 3139, 10480, 10499, 2704 ) ORDER BY t2.seque DESC
-----
-----
(mysql): SELECT t1 . * , t2.pid, t2.cateid, t2.seque
FROM sb_parameters t1
LEFT JOIN (
SELECT *
FROM sb_category_seque
WHERE cateid =1338
) AS t2 ON t2.pid = t1.id
WHERE t1.id
IN ( 1890, 1156, 9789, 32, 981, 192, 9788 ) ORDER BY t2.seque DESC
-----
-----
(mysql): SELECT cname FROM sb_categorys WHERE id=1338 LIMIT 1
-----
-----
(mysql): SELECT * FROM sb_brands WHERE id=1892
-----
-----
(mysql): SELECT * FROM sb_categorys WHERE id=1338
-----
-----
(mysql): SELECT * FROM sb_categorys WHERE id=981
-----
-----
(mysql): SELECT * FROM sb_categorys WHERE id=946
-----
-----
(mysql): SELECT * FROM sb_categorys WHERE id=1338 ORDER BY sequence DESC
-----
-----
(mysql): SELECT * FROM sb_categorys WHERE id=981 ORDER BY sequence DESC
-----
-----
(mysql): SELECT * FROM sb_categorys WHERE id=946 ORDER BY sequence DESC
-----
-----
(mysql): SELECT * FROM sb_products WHERE class_id = 1338 and id not in (246789) and status = 1 order by pxid desc, id desc limit 5
-----
-----
(mysql): SELECT * FROM sb_customers ORDER BY id DESC LIMIT 5
-----
-----
(mysql): SELECT t1.*, t2.content as template FROM sb_adv t1 , sb_adt t2 WHERE t1.starttime <= now()
AND t1.endtime >= now() AND t1.status=1 AND t2.status=1 AND t1.aid=t2.id AND t2.lang='cn' AND t2.tagname='product1'
AND t1.pid=246789 AND t1.tid=1
-----
-----
(mysql): SELECT t1.*, t2.content as template FROM sb_adv t1 , sb_adt t2 WHERE t1.starttime <= now()
AND t1.endtime >= now() AND t1.status=1 AND t2.status=1 AND t1.aid=t2.id AND t2.lang='cn' AND t2.tagname='product2'
AND t1.pid=246789 AND t1.tid=1
-----
-----
(mysql): SELECT t1.*, t2.content as template FROM sb_adv t1 , sb_adt t2 WHERE t1.starttime <= now()
AND t1.endtime >= now() AND t1.status=1 AND t2.status=1 AND t1.aid=t2.id AND t2.lang='cn' AND t2.tagname='product3'
AND t1.pid=246789 AND t1.tid=1
-----
-----
(mysql): SELECT t1.*, t2.content as template FROM sb_adv t1 , sb_adt t2 WHERE t1.starttime <= now()
AND t1.endtime >= now() AND t1.status=1 AND t2.status=1 AND t1.aid=t2.id AND t2.lang='cn' AND t2.tagname='product4'
AND t1.pid=246789 AND t1.tid=1
-----
-----
(mysql): SELECT * FROM sb_productuser WHERE pid = '246789' AND utype = '1' AND status = 1 ORDER BY price DESC, id DESC LIMIT 5
-----
-----
(mysql): SELECT * FROM sb_productuser WHERE pid = '246789' AND utype = '1' AND status = 1 ORDER BY price DESC, id DESC LIMIT 5
-----
-----
(mysql): update sb_products set hits = hits+1 where id=246789
-----
-----
(mysql): SELECT * FROM sb_comments WHERE category = 'products' and source = 246789 and status = 1 order by createtime desc
-----
-----
(mysql): SELECT count(*) as num FROM sb_comments where category = 'products' and source = 246789 and status = 1
-----
-----
(mysql): SELECT point, count( id ) AS num
FROM sb_comments
WHERE ctype = '1'
AND category = 'product'
AND source = '246789'
GROUP BY point
-----
-----
(mysql): SELECT search_value FROM sb_search_keys ORDER BY (customer+admin) DESC, last_search DESC LIMIT 0, 4
-----
1146: Table '51select.sb_search_keys' doesn't exist