SELECT UPPER(`type`) AS `type`, UPPER(`name`) AS `name`, `expire` FROM sys_cache_expires [ RunTime:0.003668s ]
select * from sys_pc_pages where flag='foot_help' [ RunTime:0.003486s ]
select id,title from article where cat_id=7 and is_open=1 limit 0,7 [ RunTime:0.003413s ]
select id,url_name from article where id='8' [ RunTime:0.003317s ]
select id,url_name from article where id='11' [ RunTime:0.003335s ]
select * from article_cat where id='7' [ RunTime:0.003373s ]
select id,title from article where cat_id=4 and is_open=1 limit 0,7 [ RunTime:0.003283s ]
select id,url_name from article where id='6' [ RunTime:0.003305s ]
select * from article_cat where id='4' [ RunTime:0.003350s ]
select id,title from article where cat_id=6 and is_open=1 limit 0,7 [ RunTime:0.003312s ]
select * from article_cat where id='6' [ RunTime:0.003314s ]
select * from shop_config [ RunTime:0.003543s ]
select * from friend_link order by sort_order desc limit 0,5 [ RunTime:0.003359s ]
select * from sys_pc_pages where flag='header_nav' [ RunTime:0.003406s ]
select * from cat where parent_id='1' order by sort_order asc [ RunTime:0.003405s ]
select * from cat where parent_id='5' order by sort_order asc [ RunTime:0.003395s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003395s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003381s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003359s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003289s ]
select * from cat where parent_id='4' order by sort_order asc [ RunTime:0.003356s ]
select * from shop_config [ RunTime:0.003482s ]
select * from pic_type [ RunTime:0.003359s ]
select * from shop_config [ RunTime:0.003460s ]
select * from shop_config [ RunTime:0.003442s ]
select * from fa_type [ RunTime:0.003271s ]
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='31' [ RunTime:0.003471s ]
SELECT `chima_type_id`,parent_id FROM cat WHERE `id`='4' [ RunTime:0.003236s ]
SELECT `chima_type_id`,parent_id FROM cat WHERE `id`='3' [ RunTime:0.003264s ]
SELECT `chima_type_id`,parent_id FROM cat WHERE `id`='2' [ RunTime:0.003278s ]
select id from products where goods_id='31' and is_valid=1 and goods_attr !='' [ RunTime:0.003335s ]
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='66' [ RunTime:0.003342s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 31 and is_main=1 [ RunTime:0.003447s ]
select * from shop_config [ RunTime:0.003562s ]
select goods_attr from products where id='66' [ RunTime:0.003330s ]
select id as goods_attr_id,attr_name,attr_value from goods_attr where id='27' [ RunTime:0.003292s ]
select cat_id,goods_name,id,goods_weight from goods where id='31' [ RunTime:0.003321s ]
SELECT give_integral
FROM goods
WHERE id='31' [ RunTime:0.003316s ]
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 = '31'
AND c.STATUS = 1 AND c.send_start_time < 1746239538 AND c.send_end_time > 1746239538 AND c.tYPE = 2 [ RunTime:0.003367s ]
select goods_name,promote_start_date,promote_end_date from goods where id='31' [ RunTime:0.003270s ]
select * from shop_config where code='currency_format' [ RunTime:0.003303s ]
select * from fa_type [ RunTime:0.003339s ]
select * from shop_config where code='currency_format' [ RunTime:0.003336s ]
select * from fa_type [ RunTime:0.003250s ]
select * from shop_config where code='currency_format' [ RunTime:0.003301s ]
select * from fa_type [ RunTime:0.003345s ]
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='67' [ RunTime:0.003318s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 31 and is_main=1 [ RunTime:0.003312s ]
select * from shop_config [ RunTime:0.003451s ]
select goods_attr from products where id='67' [ RunTime:0.003307s ]
select id as goods_attr_id,attr_name,attr_value from goods_attr where id='28' [ RunTime:0.003326s ]
select cat_id,goods_name,id,goods_weight from goods where id='31' [ RunTime:0.003343s ]
SELECT give_integral
FROM goods
WHERE id='31' [ RunTime:0.003339s ]
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 = '31'
AND c.STATUS = 1 AND c.send_start_time < 1746239539 AND c.send_end_time > 1746239539 AND c.tYPE = 2 [ RunTime:0.003400s ]
select goods_name,promote_start_date,promote_end_date from goods where id='31' [ RunTime:0.003329s ]
select * from shop_config where code='currency_format' [ RunTime:0.003313s ]
select * from fa_type [ RunTime:0.003263s ]
select * from shop_config where code='currency_format' [ RunTime:0.003226s ]
select * from fa_type [ RunTime:0.003212s ]
select * from shop_config where code='currency_format' [ RunTime:0.003271s ]
select * from fa_type [ RunTime:0.003358s ]
select * from shop_config where code='guowai_days' [ RunTime:0.003358s ]
select * from fa_type [ RunTime:0.003302s ]
select * from shop_config [ RunTime:0.003510s ]
select * from shop_config [ RunTime:0.003514s ]
SELECT id, cat_name, parent_id FROM cat [ RunTime:0.003335s ]
select id,goods_id,big_url,middle_url,thumb_url,little_url,is_main from goods_images where goods_id = '31' order by is_main desc [ RunTime:0.003418s ]
select * from shop_config [ RunTime:0.003554s ]
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 = '31' and is_valid=1 order by b.sort_order asc [ RunTime:0.003545s ]
SELECT link_id FROM goods_link where goods_id='31' [ RunTime:0.003400s ]
SELECT goods_id FROM goods_link where link_id='31' [ RunTime:0.003311s ]
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 (31)
AND b.is_main = 1 and a.is_on_sale=1 [ RunTime:0.003347s ]
select * from shop_config [ RunTime:0.003520s ]
select id,is_spec from goods where id='31' [ RunTime:0.003270s ]
SELECT goods_attr FROM products a WHERE a.goods_id = '31' AND a.is_sale = 1 AND a.product_number > 0 [ RunTime:0.003351s ]
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 = '31' ORDER BY a.sort_num_spec ASC, a.id asc [ RunTime:0.003480s ]
select * from shop_config [ RunTime:0.003474s ]
select * from shop_config [ RunTime:0.003466s ]
SELECT id,seo_title,seo_desc,seo_keywords,goods_name,brand_id FROM goods WHERE id='31' LIMIT 1 [ RunTime:0.003353s ]
select name from brand where id IN ('28') [ RunTime:0.003268s ]