SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.004626s ]
SELECT `qr` FROM `tp_wx_user` LIMIT 1 [ RunTime:0.000181s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001608s ]
SELECT * FROM `tp_goods` WHERE `goods_id` = 191 LIMIT 1 [ RunTime:0.001081s ]
UPDATE `tp_goods` SET `click_count` = 41 WHERE `goods_id` = 191 [ RunTime:0.038605s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000854s ]
SELECT * FROM `tp_goods_attr` INNER JOIN `tp_goods_attribute` `b` ON `tp_goods_attr`.`attr_id`=`b`.`attr_id` WHERE `goods_id` = 191 AND `attr_index` = 1 ORDER BY `b`.`order` DESC [ RunTime:0.000696s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000616s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000498s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.008546s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1776668400 and end_time > 1776668400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000792s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000355s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1776668400 and end_time > 1776668400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.001167s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006757s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1776668400 and end_time > 1776668400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000753s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000367s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1776668400 and end_time > 1776668400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000870s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004857s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1776668400 and end_time > 1776668400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000652s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000463s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1776668400 and end_time > 1776668400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000695s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006009s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1776668400 and end_time > 1776668400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000675s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000568s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1776668400 and end_time > 1776668400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.002181s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.026068s ]
SELECT * FROM `tp_ad` WHERE ( pid=105 and enabled = 1 and start_time < 1776668400 and end_time > 1776668400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.001806s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000211s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1776668400 and end_time > 1776668400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000258s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.002545s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 230 LIMIT 1 [ RunTime:0.002229s ]
SELECT * FROM `tp_goods_category` WHERE `id` IN (12,26) [ RunTime:0.000701s ]
SELECT * FROM `tp_goods_category` WHERE `id` IN (12,26) [ RunTime:0.000933s ]
SELECT * FROM `tp_goods_category` WHERE `id` IN (12,26) [ RunTime:0.000214s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.003680s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` = 191 [ RunTime:0.011154s ]
SHOW FULL COLUMNS FROM `tp_spec_goods_price` [ RunTime:0.005974s ]
SELECT * FROM `tp_spec_goods_price` WHERE `goods_id` = 191 AND `goods_id` = 191 ORDER BY `item_id` [ RunTime:0.000795s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.004265s ]
SELECT * FROM `tp_brand` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001238s ]
SELECT `key` FROM `tp_spec_goods_price` WHERE `goods_id` = 191 [ RunTime:0.001797s ]
SELECT `key` FROM `tp_spec_goods_price` WHERE `goods_id` = 191 [ RunTime:0.000588s ]
SHOW FULL COLUMNS FROM `tp_ad_goods` [ RunTime:0.000875s ]
SELECT * FROM `tp_ad_goods` `g` LEFT JOIN `tp_ad_goods_config` `c` ON `c`.`ad_goods_id`=`g`.`ad_goods_id` WHERE ( g.enabled =1 AND g.end_time > 1777055923 AND g.start_time <1777055923 and( c.goods_id = 191 OR c.goods_id is null) ) GROUP BY `c`.`goods_id` ORDER BY `c`.`goods_id` ASC,`g`.`orderby` DESC LIMIT 1 [ RunTime:0.001160s ]
SELECT * FROM `tp_ad_goods` `g` LEFT JOIN `tp_ad_goods_config` `c` ON `c`.`ad_goods_id`=`g`.`ad_goods_id` WHERE ( g.enabled =1 AND g.end_time > 1777055923 AND g.start_time <1777055923 and( c.goods_id = 191 OR c.goods_id is null) ) GROUP BY `c`.`goods_id` ORDER BY `c`.`goods_id` ASC,`g`.`orderby` DESC LIMIT 1 [ RunTime:0.001082s ]
SELECT * FROM `tp_ad_goods` `g` LEFT JOIN `tp_ad_goods_config` `c` ON `c`.`ad_goods_id`=`g`.`ad_goods_id` WHERE ( g.enabled =1 AND g.end_time > 1777055923 AND g.start_time <1777055923 and( c.goods_id = 191 OR c.goods_id is null) ) GROUP BY `c`.`goods_id` ORDER BY `c`.`goods_id` ASC,`g`.`orderby` DESC LIMIT 1 [ RunTime:0.001310s ]
SHOW FULL COLUMNS FROM `tp_comment` [ RunTime:0.030922s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `tp_askall_question` [ RunTime:0.000436s ]
SELECT COUNT(*) AS think_count FROM `tp_askall_question` WHERE `goods_id` = 191 AND `status` = 1 AND ( `audit` = 1 ) [ RunTime:0.000193s ]
SELECT * FROM `tp_goods_attr` INNER JOIN `tp_goods_attribute` `b` ON `tp_goods_attr`.`attr_id`=`b`.`attr_id` WHERE `goods_id` = 191 AND `attr_index` = 1 ORDER BY `b`.`order` DESC [ RunTime:0.000363s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000618s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000818s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000869s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000749s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.001360s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000306s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000811s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000713s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000683s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000259s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000648s ]
SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 4 or ceil((deliver_rank+goods_rank+service_rank)/3)= 5 then 1 else 0 end) as high_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)= 3 then 1 else 0 end) as center_sum,sum(case when ceil((deliver_rank+goods_rank+service_rank)/3)<=2 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 191 AND `username` <> 'admin' GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000671s ]
select * from `tp_system_article` where doc_code='refund' limit 1 [ RunTime:0.000584s ]
SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.001009s ]
select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.000690s ]
select goods_id,goods_name,shop_price from `tp_goods` where goods_id != 191 AND cat_id = 230 AND is_on_sale = 1 limit 12 [ RunTime:0.001040s ]
