SELECT sg.id,sg.sid,s.name AS sname,sg.name,sg.price,sg.sprice,sg.thumb220,sg.display_tmpl FROM `qt_shop_goods` AS sg INNER JOIN qt_shop AS s ON s.id=sg.sid WHERE ( sg.name like '%大城驴肉%' and sg.is_del = 0 and is_added = 1 ) LIMIT 0,25
大城驴肉 - 商品搜索 - 志晟信息网 120.52.157.163
SHOW COLUMNS FROM `qt_weather` [ RunTime:0.000550s ]
SELECT * FROM `qt_weather` ORDER BY id desc LIMIT 1 [ RunTime:0.000320s ]
SHOW COLUMNS FROM `qt_adv_not_key` [ RunTime:0.000420s ]
SELECT * FROM `qt_adv_not_key` WHERE ( is_out=0 ) ORDER BY rand() LIMIT 1 [ RunTime:0.000331s ]
SHOW COLUMNS FROM `qt_shop_domain` [ RunTime:0.000370s ]
SELECT `sid`,`domain` FROM `qt_shop_domain` WHERE ( domain='zccnsc.com' AND status=1 ) LIMIT 1 [ RunTime:0.000292s ]
SHOW COLUMNS FROM `qt_channel` [ RunTime:0.000445s ]
SHOW COLUMNS FROM `qt_user_message` [ RunTime:0.000395s ]
SELECT COUNT(*) AS tp_count FROM `qt_user_message` as um inner join qt_message m on um.mid=m.id WHERE ( m.status=0 and um.status=0 and um.toid=0 ) LIMIT 1 [ RunTime:0.000274s ]
SHOW COLUMNS FROM `qt_site` [ RunTime:0.000379s ]
SELECT `id` FROM `qt_site` WHERE ( code="index" ) LIMIT 1 [ RunTime:0.000215s ]
SHOW COLUMNS FROM `qt_keywords` [ RunTime:0.000371s ]
SELECT DISTINCT `keywords` FROM `qt_keywords` ORDER BY count desc LIMIT 6 [ RunTime:0.000876s ]
SHOW COLUMNS FROM `qt_shop_goods` [ RunTime:0.000992s ]
SELECT sg.id,sg.sid,s.name AS sname,sg.name,sg.price,sg.sprice,sg.thumb220,sg.display_tmpl FROM `qt_shop_goods` AS sg INNER JOIN qt_shop AS s ON s.id=sg.sid WHERE ( sg.name like '%大城驴肉%' and sg.is_del = 0 and is_added = 1 ) LIMIT 0,25 [ RunTime:0.007087s ]
SELECT COUNT(*) AS tp_count FROM `qt_shop_goods` AS sg INNER JOIN qt_shop AS s ON s.id=sg.sid WHERE ( sg.name like '%大城驴肉%' and sg.is_del = 0 and is_added = 1 ) LIMIT 1 [ RunTime:0.006373s ]
SELECT COUNT(*) AS tp_count FROM `qt_keywords` WHERE ( `keywords` = '大城驴肉' ) AND ( `type` = 2 ) AND ( `ktype` = 0 ) LIMIT 1 [ RunTime:0.000425s ]
UPDATE `qt_keywords` SET `count`=count+1 WHERE ( `keywords` = '大城驴肉' ) AND ( `type` = 2 ) AND ( `ktype` = 0 ) [ RunTime:0.001407s ]
SELECT `id` FROM `qt_keywords` WHERE ( `keywords` = '大城驴肉' ) AND ( `type` = 2 ) AND ( `ktype` = 0 ) LIMIT 1 [ RunTime:0.000245s ]
SHOW COLUMNS FROM `qt_keywords_detail` [ RunTime:0.000397s ]
INSERT INTO `qt_keywords_detail` (`kid`,`uid`,`addtime`,`ip`) VALUES (100087,0,1745942396,'3.15.22.62') [ RunTime:0.000210s ]
