raksmart活动促销

分享

写回答

发帖

导入数据库怎么网站只显示这些内容????

互联网出海创业 互联网出海创业 1615 人阅读 | 2 人回复

发表于 2008-7-25 19:11:29 | 显示全部楼层 |阅读模式

www.yahoowholesaler.com

page Execution duration:2.739846944809secs
Queries:42
SQL QUERY: SELECT * FROM sdb_mall_offer WHERE offerid=1
SQL Time: 0.00054693222045898
SQL QUERY: SELECT * FROM sdb_mall_template WHERE id='18'
SQL Time: 0.00024890899658203
SQL QUERY: SELECT * FROM sdb_mall_offer_interface WHERE 1=1 AND category = 'SHOP_I_KF' AND code = '53KF' ORDER BY id DESC
SQL Time: 0.0001368522644043
SQL QUERY: SELECT * FROM sdb_mall_offer_advs WHERE offerid = 1 AND type=4 AND ifopen=1 ORDER BY advslocat DESC
SQL Time: 0.00013208389282227
SQL QUERY: SELECT * FROM sdb_mall_config WHERE id=1
SQL Time: 0.00018310546875
SQL QUERY: select fs_text FROM sdb_mall_offer where offerid=1
SQL Time: 0.00021910667419434
time(config)0.053977966308594
SQL QUERY: SELECT * FROM sdb_mall_offer_advs WHERE offerid = 1 AND type=1 AND ifopen=1 ORDER BY advslocat DESC
SQL Time: 0.00019097328186035
SQL QUERY: SELECT * FROM sdb_mall_offer_advs WHERE offerid = 1 AND type=2 AND ifopen=1 ORDER BY advslocat DESC
SQL Time: 0.00029683113098145
SQL QUERY: SELECT * FROM sdb_mall_offer_advs WHERE offerid = 1 AND type=3 AND ifopen=1 ORDER BY advslocat DESC
SQL Time: 0.0001680850982666
PHP Script:header0.067447900772095
PHP Script:TPL_CLASS.php0.16330003738403
PHP Script:TPL_CLASS.php0.16377091407776
PHP Script:TPL_LOGIN.php0.16426205635071
PHP Script:TPL_CATEGORY.php0.16528987884521
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=0 AND offerid=1 ORDER BY catpath
SQL Time: 0.00045299530029297
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=13 AND offerid=1 ORDER BY catpath
SQL Time: 0.00043296813964844
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=25 AND offerid=1 ORDER BY catpath
SQL Time: 0.00034403800964355
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=2 AND offerid=1 ORDER BY catpath
SQL Time: 0.00030398368835449
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=21 AND offerid=1 ORDER BY catpath
SQL Time: 0.0014040470123291
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=22 AND offerid=1 ORDER BY catpath
SQL Time: 0.0050930976867676
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=23 AND offerid=1 ORDER BY catpath
SQL Time: 0.00090503692626953
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=24 AND offerid=1 ORDER BY catpath
SQL Time: 0.00031495094299316
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=9 AND offerid=1 ORDER BY catpath
SQL Time: 0.00028896331787109
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=7 AND offerid=1 ORDER BY catpath
SQL Time: 0.00047492980957031
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=11 AND offerid=1 ORDER BY catpath
SQL Time: 0.00041699409484863
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=12 AND offerid=1 ORDER BY catpath
SQL Time: 0.00029802322387695
PHP Script:TPL_ARTICLE_LIST.php0.19727301597595
SQL QUERY: SELECT * FROM sdb_mall_offer_ncat WHERE pid='1' AND offerid=1
SQL Time: 0.00019311904907227
SQL QUERY: SELECT sdb_mall_offer_ncon.*,sdb_mall_offer_ncat.cat,sdb_mall_offer_ncat.catid,sdb_mall_offer_ncat.pid FROM sdb_mall_offer_ncon LEFT JOIN sdb_mall_offer_ncat ON sdb_mall_offer_ncat.catid = sdb_mall_offer_ncon.catid WHERE sdb_mall_offer_ncon.ifpub=1 AND sdb_mall_offer_ncat.pid='1' AND sdb_mall_offer_ncon.offerid=1 ORDER BY sdb_mall_offer_ncon.orderlist DESC,sdb_mall_offer_ncon.uptime DESC
SQL Time: 0.00026202201843262
SQL QUERY: SELECT sdb_mall_offer_ncon.*,sdb_mall_offer_ncat.cat,sdb_mall_offer_ncat.catid,sdb_mall_offer_ncat.pid FROM sdb_mall_offer_ncon LEFT JOIN sdb_mall_offer_ncat ON sdb_mall_offer_ncat.catid = sdb_mall_offer_ncon.catid WHERE sdb_mall_offer_ncon.ifpub=1 AND sdb_mall_offer_ncat.pid='1' AND sdb_mall_offer_ncon.offerid=1 ORDER BY sdb_mall_offer_ncon.orderlist DESC,sdb_mall_offer_ncon.uptime DESC LIMIT 0,10
SQL Time: 0.0002739429473877
PHP Script:TPL_GOODSCLASS.php0.21330904960632
SQL QUERY: SELECT * from sdb_mall_currency where offerid = '1' AND number = ''
SQL Time: 0.00021600723266602
SQL QUERY: SELECT * from sdb_mall_currency where offerid = '1' AND basicmark = '1'
SQL Time: 0.00018405914306641
SQL QUERY: SELECT a.ifdiscreteness,a.gid,a.ifalarm,a.storage,a.intro,a.price,a.brand,a.bn,a.goods,a.danwei,a.point,a.priceintro,a.weight,a.smallimgremote,a.smallwsize,a.smallhsize,a.offerid,b.cat,a.attr1,a.attr2,a.attr3,a.attr4,a.attr5,a.attr6,a.attr7,a.attr8,a.attr9,a.attr10,a.attr11,a.attr12,a.attr13,a.attr14,a.attr15,a.attr16,a.attr17,a.attr18,a.attr19,a.attr20,a.attr21,a.attr22,a.attr23,a.attr24,a.attr25,a.attr26,a.attr27,a.attr28,a.attr29,a.attr30,a.attr31,a.attr32,a.attr33,a.attr34,a.attr35,a.attr36,a.attr37,a.attr38,a.attr39,a.attr40 FROM sdb_mall_goods as a LEFT JOIN sdb_mall_offer_pcat as b ON a.catid = b.catid and a.offerid = b.offerid WHERE shop_iffb=1 AND catiffb=1 AND hot2=1 AND a.offerid=1 AND catpath like '%,%' AND ifobject != 3 ORDER BY offer_ord DESC LIMIT 0,4
SQL Time: 0.00024294853210449
SQL QUERY: SELECT * FROM sdb_mall_offer_p WHERE ptype IN ('ALIPAY','ALIPAY_MASS','ALIPAY_DIRECT','99BILL','PAYPAL','PAYPAL_CN') AND offerid=1 ORDER BY ordernum DESC
SQL Time: 0.0001978874206543
PHP Script:TPL_LINKLIST.php0.27020692825317
SQL QUERY: SELECT * FROM sdb_mall_offer_link WHERE offerid=1 AND showfront = 1 ORDER BY ordernum desc
SQL Time: 0.00020503997802734
PHP Script:TPL_SELECTCURRENCY.php0.29332995414734
SQL QUERY: SELECT * FROM sdb_mall_currency where offerid = '1'
SQL Time: 0.00027203559875488
PHP Script:TPL_SEARCH.php0.32083201408386
SQL QUERY: SELECT catid,cat,catpath FROM sdb_mall_offer_pcat WHERE offerid=1 AND catiffb = 1 ORDER BY catpath
SQL Time: 0.00018692016601562
SQL QUERY: SELECT DISTINCT brand FROM sdb_mall_goods WHERE offerid=1 ORDER BY brand
SQL Time: 0.02803897857666
PHP Script:TPL_GOODSCLASS.php0.37007999420166
SQL QUERY: SELECT a.ifdiscreteness,a.gid,a.ifalarm,a.storage,a.intro,a.price,a.brand,a.bn,a.goods,a.danwei,a.point,a.priceintro,a.weight,a.smallimgremote,a.smallwsize,a.smallhsize,a.offerid,b.remote,a.smallwsize,a.smallhsize,a.offer

回答|共 2 个

大漠孤狼

发表于 2008-7-26 12:16:14 | 显示全部楼层

什么页面?吧SQL命令都显示出来了

sevenstar

发表于 2009-7-9 13:38:48 | 显示全部楼层

是同一个版本的sql吗?可能语句不兼容。
您需要登录后才可以回帖 登录 | 注册

本版积分规则