SELECT UPPER(`type`) AS `type`, UPPER(`name`) AS `name`, `expire` FROM sys_cache_expires [ RunTime:0.003918s ]
select * from sys_pc_pages where flag='foot_help' [ RunTime:0.003636s ]
select id,title from article where cat_id=7 and is_open=1 limit 0,7 [ RunTime:0.003521s ]
select id,url_name from article where id='8' [ RunTime:0.003402s ]
select id,url_name from article where id='11' [ RunTime:0.003397s ]
select * from article_cat where id='7' [ RunTime:0.003441s ]
select id,title from article where cat_id=4 and is_open=1 limit 0,7 [ RunTime:0.003605s ]
select id,url_name from article where id='6' [ RunTime:0.003390s ]
select * from article_cat where id='4' [ RunTime:0.003547s ]
select id,title from article where cat_id=6 and is_open=1 limit 0,7 [ RunTime:0.003529s ]
select * from article_cat where id='6' [ RunTime:0.003795s ]
select * from shop_config [ RunTime:0.003710s ]
select * from friend_link order by sort_order desc limit 0,5 [ RunTime:0.003505s ]
select * from sys_pc_pages where flag='header_nav' [ RunTime:0.003624s ]
select * from cat where parent_id='1' order by sort_order asc [ RunTime:0.003611s ]
select * from cat where parent_id='5' order by sort_order asc [ RunTime:0.003582s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003603s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003604s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003536s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003503s ]
select * from cat where parent_id='4' order by sort_order asc [ RunTime:0.003450s ]
select * from shop_config [ RunTime:0.003567s ]
select * from pic_type [ RunTime:0.003419s ]
select * from shop_config [ RunTime:0.003558s ]
select * from shop_config [ RunTime:0.003763s ]
select * from fa_type [ RunTime:0.003333s ]
select a.is_on_sale,a.chima_type_id,promote_end_date,promote_start_date,goods_name,cat_id,brand_id,b.name as brand_name,goods_brief,goods_number,goods_desc,is_return,is_guonei,is_spec,video_path,video_pic,is_guowai,is_advance,is_return,is_change,is_reason_7 from goods a left join brand b on a.brand_id=b.id where a.id='35' [ RunTime:0.003670s ]
SELECT `chima_type_id`,parent_id FROM cat WHERE `id`='3' [ RunTime:0.003360s ]
SELECT `chima_type_id`,parent_id FROM cat WHERE `id`='2' [ RunTime:0.003377s ]
SELECT `chima_type_id`,parent_id FROM cat WHERE `id`='1' [ RunTime:0.003451s ]
select id from products where goods_id='35' and is_valid=1 and goods_attr !='' [ RunTime:0.003462s ]
SELECT id as pid,goods_id,product_name,product_sn,goods_name,goods_sn,product_number,price as product_price,market_price,img_id,goods_attr,attr_info,weight,promote_price,product_original_img,send_from,send_days FROM products WHERE id='76' [ RunTime:0.003560s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 35 and is_main=1 [ RunTime:0.003619s ]
select goods_attr from products where id='76' [ RunTime:0.003518s ]
select id as goods_attr_id,attr_name,attr_value from goods_attr where id='45' [ RunTime:0.003405s ]
select id as goods_attr_id,attr_name,attr_value from goods_attr where id='46' [ RunTime:0.003501s ]
select cat_id,goods_name,id,goods_weight from goods where id='35' [ RunTime:0.003455s ]
SELECT give_integral
FROM goods
WHERE id='35' [ RunTime:0.003552s ]
SELECT a.goods_name,a.id as goods_id, c.id,c.name,c.money,c.type FROM goods a LEFT JOIN coupon_goods_link b LEFT JOIN coupon c ON b.`coupon_id` = c.id ON a.id = b.`goods_id` WHERE a.id = '35'
AND c.STATUS = 1 AND c.send_start_time < 1719901805 AND c.send_end_time > 1719901805 AND c.tYPE = 2 [ RunTime:0.003456s ]
select goods_name,promote_start_date,promote_end_date from goods where id='35' [ RunTime:0.003467s ]
select * from shop_config where code='currency_format' [ RunTime:0.003387s ]
select * from fa_type [ RunTime:0.006322s ]
select * from shop_config where code='currency_format' [ RunTime:0.003500s ]
select * from fa_type [ RunTime:0.003443s ]
select * from shop_config where code='currency_format' [ RunTime:0.003503s ]
select * from fa_type [ RunTime:0.003436s ]
SELECT id as pid,goods_id,product_name,product_sn,goods_name,goods_sn,product_number,price as product_price,market_price,img_id,goods_attr,attr_info,weight,promote_price,product_original_img,send_from,send_days FROM products WHERE id='77' [ RunTime:0.003477s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 35 and is_main=1 [ RunTime:0.003500s ]
select goods_attr from products where id='77' [ RunTime:0.003347s ]
select id as goods_attr_id,attr_name,attr_value from goods_attr where id='45' [ RunTime:0.003661s ]
select id as goods_attr_id,attr_name,attr_value from goods_attr where id='47' [ RunTime:0.003396s ]
select cat_id,goods_name,id,goods_weight from goods where id='35' [ RunTime:0.003539s ]
SELECT give_integral
FROM goods
WHERE id='35' [ RunTime:0.003430s ]
SELECT a.goods_name,a.id as goods_id, c.id,c.name,c.money,c.type FROM goods a LEFT JOIN coupon_goods_link b LEFT JOIN coupon c ON b.`coupon_id` = c.id ON a.id = b.`goods_id` WHERE a.id = '35'
AND c.STATUS = 1 AND c.send_start_time < 1719901805 AND c.send_end_time > 1719901805 AND c.tYPE = 2 [ RunTime:0.003567s ]
select goods_name,promote_start_date,promote_end_date from goods where id='35' [ RunTime:0.003489s ]
select * from shop_config where code='currency_format' [ RunTime:0.003442s ]
select * from fa_type [ RunTime:0.003320s ]
select * from shop_config where code='currency_format' [ RunTime:0.003596s ]
select * from fa_type [ RunTime:0.003410s ]
select * from shop_config where code='currency_format' [ RunTime:0.003400s ]
select * from fa_type [ RunTime:0.003399s ]
SELECT id as pid,goods_id,product_name,product_sn,goods_name,goods_sn,product_number,price as product_price,market_price,img_id,goods_attr,attr_info,weight,promote_price,product_original_img,send_from,send_days FROM products WHERE id='78' [ RunTime:0.003434s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 35 and is_main=1 [ RunTime:0.003399s ]
select goods_attr from products where id='78' [ RunTime:0.003415s ]
select id as goods_attr_id,attr_name,attr_value from goods_attr where id='48' [ RunTime:0.003369s ]
select id as goods_attr_id,attr_name,attr_value from goods_attr where id='46' [ RunTime:0.003316s ]
select cat_id,goods_name,id,goods_weight from goods where id='35' [ RunTime:0.003374s ]
SELECT give_integral
FROM goods
WHERE id='35' [ RunTime:0.003363s ]
SELECT a.goods_name,a.id as goods_id, c.id,c.name,c.money,c.type FROM goods a LEFT JOIN coupon_goods_link b LEFT JOIN coupon c ON b.`coupon_id` = c.id ON a.id = b.`goods_id` WHERE a.id = '35'
AND c.STATUS = 1 AND c.send_start_time < 1719901805 AND c.send_end_time > 1719901805 AND c.tYPE = 2 [ RunTime:0.003549s ]
select goods_name,promote_start_date,promote_end_date from goods where id='35' [ RunTime:0.003319s ]
select * from shop_config where code='currency_format' [ RunTime:0.003401s ]
select * from fa_type [ RunTime:0.003441s ]
select * from shop_config where code='currency_format' [ RunTime:0.003412s ]
select * from fa_type [ RunTime:0.003397s ]
select * from shop_config where code='currency_format' [ RunTime:0.003378s ]
select * from fa_type [ RunTime:0.003358s ]
SELECT id as pid,goods_id,product_name,product_sn,goods_name,goods_sn,product_number,price as product_price,market_price,img_id,goods_attr,attr_info,weight,promote_price,product_original_img,send_from,send_days FROM products WHERE id='79' [ RunTime:0.003433s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 35 and is_main=1 [ RunTime:0.003423s ]
select goods_attr from products where id='79' [ RunTime:0.003346s ]
select id as goods_attr_id,attr_name,attr_value from goods_attr where id='48' [ RunTime:0.003367s ]
select id as goods_attr_id,attr_name,attr_value from goods_attr where id='47' [ RunTime:0.003358s ]
select cat_id,goods_name,id,goods_weight from goods where id='35' [ RunTime:0.003373s ]
SELECT give_integral
FROM goods
WHERE id='35' [ RunTime:0.003347s ]
SELECT a.goods_name,a.id as goods_id, c.id,c.name,c.money,c.type FROM goods a LEFT JOIN coupon_goods_link b LEFT JOIN coupon c ON b.`coupon_id` = c.id ON a.id = b.`goods_id` WHERE a.id = '35'
AND c.STATUS = 1 AND c.send_start_time < 1719901805 AND c.send_end_time > 1719901805 AND c.tYPE = 2 [ RunTime:0.003482s ]
select goods_name,promote_start_date,promote_end_date from goods where id='35' [ RunTime:0.003411s ]
select * from shop_config where code='currency_format' [ RunTime:0.003386s ]
select * from fa_type [ RunTime:0.003329s ]
select * from shop_config where code='currency_format' [ RunTime:0.003382s ]
select * from fa_type [ RunTime:0.003315s ]
select * from shop_config where code='currency_format' [ RunTime:0.003309s ]
select * from fa_type [ RunTime:0.003329s ]
select * from shop_config where code='guowai_days' [ RunTime:0.003407s ]
select * from fa_type [ RunTime:0.003358s ]
select * from shop_config [ RunTime:0.003602s ]
select * from shop_config [ RunTime:0.007449s ]
SELECT id, cat_name, parent_id FROM cat [ RunTime:0.003366s ]
select id,goods_id,big_url,middle_url,thumb_url,little_url,is_main from goods_images where goods_id = '35' order by is_main desc [ RunTime:0.003453s ]
SELECT goods_id, a.attr_name, a.attr_value,a.attr_type FROM goods_attr a left join attr b on a.attr_id=b.id WHERE b.is_spec=0 AND goods_id = '35' and is_valid=1 order by b.sort_order asc [ RunTime:0.003477s ]
SELECT link_id FROM goods_link where goods_id='35' [ RunTime:0.003331s ]
SELECT goods_id FROM goods_link where link_id='35' [ RunTime:0.003421s ]
SELECT
a.id,
b.big_url,
b.middle_url,
b.thumb_url,b.little_url,
a.goods_name
FROM
goods a
LEFT JOIN goods_images b
ON a.id = b.goods_id
AND b.`is_main` = 1
WHERE a.id IN (35)
AND b.is_main = 1 and a.is_on_sale=1 [ RunTime:0.003477s ]
select * from shop_config [ RunTime:0.003581s ]
select id,is_spec from goods where id='35' [ RunTime:0.003344s ]
SELECT goods_attr FROM products a WHERE a.goods_id = '35' AND a.is_sale = 1 AND a.product_number > 0 [ RunTime:0.003471s ]
SELECT a.id as goods_attr_id,goods_id, attr_id,a.attr_name, a.attr_value,IFNULL(big_url,'')as big_url,IFNULL(middle_url,'') AS middle_url,IFNULL(thumb_url,'') as thumb_url FROM goods_attr a left join attr b on a.attr_id=b.id WHERE b.is_spec=1 and a.is_valid=1 and a.attr_type = 1 AND goods_id = '35' ORDER BY a.sort_num_spec ASC, a.id asc [ RunTime:0.003538s ]
select * from shop_config [ RunTime:0.003580s ]
select * from shop_config [ RunTime:0.003504s ]
SELECT id,seo_title,seo_desc,seo_keywords,goods_name,brand_id FROM goods WHERE id='35' LIMIT 1 [ RunTime:0.003387s ]
select name from brand where id IN ('0') [ RunTime:0.003458s ]