记录 1
结果:
success 耗时:0.15 毫秒
语句:SELECT name, value FROM settings WHERE id>1
记录 2
结果:
success 耗时:0.06 毫秒
语句:SELECT * FROM currencies WHERE id>1
记录 3
结果:
success 耗时:0.06 毫秒
语句:SELECT * FROM languages WHERE status=1
记录 4
结果:
success 耗时:0.06 毫秒
语句:SELECT c.id,c.parent_id,cd.name FROM categories as c LEFT JOIN category_descriptions as cd ON c.id=cd.category_id WHERE c.active=1 ORDER BY c.position asc
记录 5
结果:
success 耗时:0.06 毫秒
语句:SELECT c.id,c.parent_id,cd.name FROM categories as c LEFT JOIN category_descriptions as cd ON c.id=cd.category_id WHERE c.active=1 AND c.parent_id=0 ORDER BY c.position asc
记录 6
结果:
false 耗时:0.06 毫秒
语句:SELECT p.id,p.images,p.video,p.sales FROM products as p,product_categories as pd WHERE p.active=1 AND p.id=pd.product_id AND pd.category_id=? ORDER BY p.sales DESC, p.updated_at DESC LIMIT 6
记录 7
结果:
false 耗时:0.06 毫秒
语句:SELECT p.id,p.images,p.video,p.sales FROM products as p,product_categories as pd WHERE p.active=1 AND p.id=pd.product_id AND pd.category_id=? ORDER BY p.sales DESC, p.updated_at DESC LIMIT 6
记录 8
结果:
false 耗时:0.06 毫秒
语句:SELECT p.id,p.images,p.video,p.sales FROM products as p,product_categories as pd WHERE p.active=1 AND p.id=pd.product_id AND pd.category_id=? ORDER BY p.sales DESC, p.updated_at DESC LIMIT 6
记录 9
结果:
false 耗时:0.05 毫秒
语句:SELECT id FROM products WHERE active=1 ORDER BY sales DESC LIMIT 20
记录 10
结果:
false 耗时:0.05 毫秒
语句:SELECT id FROM products WHERE active=1 ORDER BY sales DESC LIMIT 20 OFFSET 20
记录 11
结果:
success 耗时:0.05 毫秒
语句:SELECT product_id,COUNT(product_id) AS ub_count FROM user_behavior GROUP BY product_id ORDER BY ub_count DESC LIMIT 30
记录 12
结果:
false 耗时:0.05 毫秒
语句:SELECT images FROM products WHERE id=?
记录 13
结果:
success 耗时:0.06 毫秒
语句:SELECT MIN(price) AS min_price,MAX(origin_price) AS max_price, MIN(id) AS min_sku_id FROM product_skus WHERE product_id=?
记录 14
结果:
false 耗时:0.05 毫秒
语句:SELECT name FROM product_descriptions WHERE product_id=?
记录 15
结果:
false 耗时:0.05 毫秒
语句:SELECT meta_keywords FROM product_descriptions WHERE product_id=?
记录 16
结果:
false 耗时:0.04 毫秒
语句:SELECT id FROM products WHERE active=1 ORDER BY updated_at DESC LIMIT 20
记录 17
结果:
false 耗时:0.04 毫秒
语句:SELECT id FROM products WHERE active=1 ORDER BY sales DESC LIMIT 20 OFFSET 20
记录 18
结果:
false 耗时:0.04 毫秒
语句:SELECT page_id,title,summary,meta_keywords FROM page_descriptions ORDER BY updated_at DESC LIMIT 3
记录 19
结果:
false 耗时:0.34 毫秒
语句:SELECT * FROM cart_products WHERE session_id=? ORDER BY updated_at DESC