China NICKEL Y#349 Yr27(1938) UNC CV$20

  • China NICKEL Y#349 Yr27(1938) UNC CV$20
  • List Price:0.00
  • Price:19.00

China NICKEL Y#349 Yr28(1939) CV$27.50 UNC

  • China NICKEL Y#349 Yr28(1939) CV$27.50 UNC
  • List Price:0.00
  • Price:26.99

North China Half Value Surcharges Chan Jn 554

  • North China Half Value Surcharges Chan Jn 554
  • List Price:0.00
  • Price:260.00

Japanese Occ Opt "SUPEH "Chan JN151 $1 Unused VF

  • Japanese Occ Opt \
  • List Price:0.00
  • Price:299.00

China/Rep.1914(yrs.3)Yuan Shih Kai Half dollar UNC

  • China/Rep.1914(yrs.3)Yuan Shih Kai Half dollar UNC
  • List Price:0.00
  • Price:225.00

Hopei japanese Occ China Chan JN225

  • Hopei japanese Occ China Chan JN225
  • List Price:0.00
  • Price:1.99

China postage Due stamps 2 Dollar

  • China postage Due stamps 2 Dollar
  • List Price:0.00
  • Price:6.60

Hopei japanese Occ China Chan JN225

  • Hopei japanese Occ China Chan JN225
  • List Price:0.00
  • Price:1.99

Dragon & Phoenix Silver Coins, 10C 1926,AU - UNC

  • Dragon & Phoenix Silver Coins, 10C 1926,AU - UNC
  • List Price:180.00
  • Price:120.00

China old Coins, UNC******

  • China old Coins, UNC******
  • List Price:50.00
  • Price:26.90

China Taiwan 10 Yuan 1936 Bank Note

  • China Taiwan 10 Yuan 1936 Bank Note
  • List Price:5.00
  • Price:2.90

Central B. of China CGU 100 UNC

  • Central B. of China CGU 100  UNC
  • List Price:8.00
  • Price:5.90

Central B. of China CGU 10000 UNC

  • Central B. of China CGU 10000  UNC
  • List Price:8.00
  • Price:5.90

Central B. of China CGU 10000 UNC

  • Central B. of China CGU 10000  UNC
  • List Price:0.00
  • Price:5.90

RUSSIA, 1000 RUBLES 1917, NO RESERVE AU-UNC

  • RUSSIA, 1000 RUBLES 1917, NO RESERVE AU-UNC
  • List Price:6.00
  • Price:2.90

RUSSIA: 1909 5 Ru. Different Konshin,s

  • RUSSIA: 1909 5 Ru. Different Konshin,s
  • List Price:800.00
  • Price:5.90

RUSSIA: 1909 10 Ru. Different Konshin,s

  • RUSSIA: 1909 10 Ru. Different Konshin,s
  • List Price:8.00
  • Price:2.99

JAPAN,Kuan-ei, DOT on Right Reverse SCARCE !!

  • JAPAN,Kuan-ei, DOT on Right Reverse SCARCE !!
  • List Price:12.00
  • Price:5.50

Hong Kong Cent 1949 UNC

  • Hong Kong Cent 1949  UNC
  • List Price:8.00
  • Price:5.90

Hong Kong Cent 1933 UNC

  • Hong Kong Cent 1933 UNC
  • List Price:8.00
  • Price:5.90

Hong Kong Cent 1937 UNC

  • Hong Kong Cent 1937 UNC
  • List Price:8.00
  • Price:5.90

Hong Kong Cent 1938 UNC

  • Hong Kong Cent 1938  UNC
  • List Price:8.00
  • Price:5.90

Crisp uncirculated note China Ten Yuan 1941 UNC

  • Crisp uncirculated note China Ten Yuan 1941 UNC
  • List Price:33.00
  • Price:18.00

Central B. of China CGU 500 UNC

  • Central B. of China CGU 500 UNC
  • List Price:6.00
  • Price:2.90

Central B.of China CGU 2000 UNC

  • Central B.of China CGU 2000 UNC
  • List Price:6.00
  • Price:2.90

Central B.of China CGU 500 UNC

  • Central B.of China CGU 500 UNC
  • List Price:6.00
  • Price:2.90

Central B. of China CGU 2000 UNC

  • Central B. of China CGU 2000  UNC
  • List Price:6.00
  • Price:2.90

RUSSIA: 1910 100 Rubles UNC

  • RUSSIA: 1910  100 Rubles UNC
  • List Price:0.00
  • Price:19.99

Germany. 10000 Mark. 19 Jan 1922 UNC

  • Germany. 10000 Mark. 19 Jan 1922 UNC
  • List Price:9.00
  • Price:6.90

Germany. 100000 Mark.1st Feb 1923 UNC

  • Germany. 100000 Mark.1st Feb 1923 UNC
  • List Price:0.00
  • Price:5.99

RUSSIA: 1912 500 Rubles UNC

  • RUSSIA: 1912 500 Rubles  UNC
  • List Price:0.00
  • Price:18.99

Hopei japanese Occ China Chan JN225

  • Hopei japanese Occ China Chan JN225
  • List Price:0.00
  • Price:1.99

RUSSIA; 1909 10 Ru, Different Konshin's

  • RUSSIA; 1909 10 Ru, Different Konshin\'s
  • List Price:0.00
  • Price:5.99

China Pupper(1943) 10 Yuan UNC PJ76 CV40

  • China Pupper(1943) 10 Yuan UNC PJ76 CV40
  • List Price:0.00
  • Price:39.00
page Execution duration:2.0561640262604secs
Queries:98
SQL QUERY: SELECT * FROM sdb_mall_offer WHERE offerid=1
SQL Time: 0.0027470588684082
SQL QUERY: SELECT * FROM sdb_mall_template WHERE id='10'
SQL Time: 0.00058388710021973
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.00050520896911621
SQL QUERY: SELECT * FROM sdb_mall_offer_advs WHERE offerid = 1 AND type=4 AND ifopen=1 ORDER BY advslocat DESC
SQL Time: 0.0005040168762207
SQL QUERY: SELECT * FROM sdb_mall_config WHERE id=1
SQL Time: 0.0011739730834961
SQL QUERY: select fs_text FROM sdb_mall_offer where offerid=1
SQL Time: 0.00046801567077637
time(config)0.1347770690918
SQL QUERY: SELECT * FROM sdb_mall_offer_advs WHERE offerid = 1 AND type=1 AND ifopen=1 ORDER BY advslocat DESC
SQL Time: 0.00080013275146484
SQL QUERY: SELECT * FROM sdb_mall_offer_advs WHERE offerid = 1 AND type=2 AND ifopen=1 ORDER BY advslocat DESC
SQL Time: 0.00075888633728027
SQL QUERY: SELECT * FROM sdb_mall_offer_advs WHERE offerid = 1 AND type=3 AND ifopen=1 ORDER BY advslocat DESC
SQL Time: 0.00067901611328125
PHP Script:header0.16692614555359
PHP Script:TPL_CLASS.php0.38019323348999
PHP Script:TPL_ARTICLE_LIST.php0.3804771900177
SQL QUERY: SELECT * FROM sdb_mall_offer_ncat WHERE pid='1' AND offerid=1
SQL Time: 0.060718059539795
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.052786111831665
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.12849092483521
PHP Script:TPL_LOGIN.php0.75326919555664
PHP Script:TPL_CATEGORY.php0.78067207336426
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=0 AND offerid=1 ORDER BY catpath
SQL Time: 0.033098936080933
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=21 AND offerid=1 ORDER BY catpath
SQL Time: 0.0017011165618896
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=31 AND offerid=1 ORDER BY catpath
SQL Time: 0.0019509792327881
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=32 AND offerid=1 ORDER BY catpath
SQL Time: 0.0020661354064941
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=57 AND offerid=1 ORDER BY catpath
SQL Time: 0.0017728805541992
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=58 AND offerid=1 ORDER BY catpath
SQL Time: 0.0014939308166504
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=59 AND offerid=1 ORDER BY catpath
SQL Time: 0.0045969486236572
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=63 AND offerid=1 ORDER BY catpath
SQL Time: 0.0021529197692871
PHP Script:TPL_GOODSCLASS.php0.86588716506958
SQL QUERY: SELECT * from sdb_mall_currency where offerid = '1' AND number = ''
SQL Time: 0.00053119659423828
SQL QUERY: SELECT * from sdb_mall_currency where offerid = '1' AND basicmark = '1'
SQL Time: 0.00060415267944336
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,30
SQL Time: 0.086449146270752
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.0099890232086182
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '1' AND state = 9 ORDER BY id DESC
SQL Time: 0.010093927383423
PHP Script:TPL_LINKLIST.php1.0843012332916
SQL QUERY: SELECT * FROM sdb_mall_offer_link WHERE offerid=1 AND showfront = 1 ORDER BY ordernum desc
SQL Time: 0.068042039871216
PHP Script:TPL_SELECTCURRENCY.php1.1808490753174
SQL QUERY: SELECT * FROM sdb_mall_currency where offerid = '1'
SQL Time: 0.00072002410888672
PHP Script:TPL_CLASS.php1.223592042923
PHP Script:TPL_CLASS.php1.2238481044769
PHP Script:TPL_GOODSCLASS.php1.2240722179413
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 new2=1 AND a.offerid=1 AND catpath like '%,%' AND ifobject != 3 ORDER BY offer_ord DESC LIMIT 0,30
SQL Time: 0.039399147033691
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '254' AND state = 9 ORDER BY id DESC
SQL Time: 0.00083208084106445
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '255' AND state = 9 ORDER BY id DESC
SQL Time: 0.00072908401489258
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '253' AND state = 9 ORDER BY id DESC
SQL Time: 0.00079989433288574
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '252' AND state = 9 ORDER BY id DESC
SQL Time: 0.00071191787719727
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '251' AND state = 9 ORDER BY id DESC
SQL Time: 0.00070905685424805
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '250' AND state = 9 ORDER BY id DESC
SQL Time: 0.00070786476135254
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '249' AND state = 9 ORDER BY id DESC
SQL Time: 0.0022530555725098
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '248' AND state = 9 ORDER BY id DESC
SQL Time: 0.00070405006408691
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '247' AND state = 9 ORDER BY id DESC
SQL Time: 0.0012381076812744
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '246' AND state = 9 ORDER BY id DESC
SQL Time: 0.00071096420288086
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '245' AND state = 9 ORDER BY id DESC
SQL Time: 0.00068998336791992
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '244' AND state = 9 ORDER BY id DESC
SQL Time: 0.00063800811767578
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '243' AND state = 9 ORDER BY id DESC
SQL Time: 0.0007939338684082
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '242' AND state = 9 ORDER BY id DESC
SQL Time: 0.00089907646179199
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '241' AND state = 9 ORDER BY id DESC
SQL Time: 0.00069403648376465
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '240' AND state = 9 ORDER BY id DESC
SQL Time: 0.00069379806518555
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '239' AND state = 9 ORDER BY id DESC
SQL Time: 0.00082087516784668
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '238' AND state = 9 ORDER BY id DESC
SQL Time: 0.0010709762573242
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '237' AND state = 9 ORDER BY id DESC
SQL Time: 0.00082707405090332
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '236' AND state = 9 ORDER BY id DESC
SQL Time: 0.00076007843017578
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '235' AND state = 9 ORDER BY id DESC
SQL Time: 0.00071406364440918
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '234' AND state = 9 ORDER BY id DESC
SQL Time: 0.00076508522033691
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '233' AND state = 9 ORDER BY id DESC
SQL Time: 0.00068998336791992
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '232' AND state = 9 ORDER BY id DESC
SQL Time: 0.0078949928283691
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '231' AND state = 9 ORDER BY id DESC
SQL Time: 0.00075602531433105
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '230' AND state = 9 ORDER BY id DESC
SQL Time: 0.00073099136352539
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '229' AND state = 9 ORDER BY id DESC
SQL Time: 0.00061511993408203
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '228' AND state = 9 ORDER BY id DESC
SQL Time: 0.00084209442138672
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '227' AND state = 9 ORDER BY id DESC
SQL Time: 0.0010359287261963
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '226' AND state = 9 ORDER BY id DESC
SQL Time: 0.00073099136352539
PHP Script:TPL_SEARCH.php1.5709540843964
SQL QUERY: SELECT catid,cat,catpath FROM sdb_mall_offer_pcat WHERE offerid=1 AND catiffb = 1 ORDER BY catpath
SQL Time: 0.0019237995147705
SQL QUERY: SELECT DISTINCT brand FROM sdb_mall_goods WHERE offerid=1 ORDER BY brand
SQL Time: 0.0050981044769287
PHP Script:TPL_GOODSCLASS.php1.6345250606537
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 recommand2=1 AND a.offerid=1 AND catpath like '%,%' AND ifobject != 3 ORDER BY offer_ord DESC LIMIT 0,30
SQL Time: 0.0623779296875
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '228' AND state = 9 ORDER BY id DESC
SQL Time: 0.00054502487182617
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '68' AND state = 9 ORDER BY id DESC
SQL Time: 0.00081610679626465
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '67' AND state = 9 ORDER BY id DESC
SQL Time: 0.00079703330993652
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '66' AND state = 9 ORDER BY id DESC
SQL Time: 0.001561164855957
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '65' AND state = 9 ORDER BY id DESC
SQL Time: 0.0023910999298096
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '64' AND state = 9 ORDER BY id DESC
SQL Time: 0.00072193145751953
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '63' AND state = 9 ORDER BY id DESC
SQL Time: 0.0007932186126709
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '62' AND state = 9 ORDER BY id DESC
SQL Time: 0.00060701370239258
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '61' AND state = 9 ORDER BY id DESC
SQL Time: 0.00066304206848145
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '60' AND state = 9 ORDER BY id DESC
SQL Time: 0.00080704689025879
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '52' AND state = 9 ORDER BY id DESC
SQL Time: 0.0006711483001709
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '51' AND state = 9 ORDER BY id DESC
SQL Time: 0.00070309638977051
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '50' AND state = 9 ORDER BY id DESC
SQL Time: 0.0006711483001709
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '49' AND state = 9 ORDER BY id DESC
SQL Time: 0.00073599815368652
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '48' AND state = 9 ORDER BY id DESC
SQL Time: 0.00072789192199707
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '47' AND state = 9 ORDER BY id DESC
SQL Time: 0.00070905685424805
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '46' AND state = 9 ORDER BY id DESC
SQL Time: 0.00070691108703613
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '45' AND state = 9 ORDER BY id DESC
SQL Time: 0.00079202651977539
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '44' AND state = 9 ORDER BY id DESC
SQL Time: 0.00075793266296387
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '43' AND state = 9 ORDER BY id DESC
SQL Time: 0.0006101131439209
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '42' AND state = 9 ORDER BY id DESC
SQL Time: 0.0017678737640381
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '41' AND state = 9 ORDER BY id DESC
SQL Time: 0.00073790550231934
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '38' AND state = 9 ORDER BY id DESC
SQL Time: 0.0021059513092041
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '37' AND state = 9 ORDER BY id DESC
SQL Time: 0.00061392784118652
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '36' AND state = 9 ORDER BY id DESC
SQL Time: 0.00072193145751953
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '35' AND state = 9 ORDER BY id DESC
SQL Time: 0.0026979446411133
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '33' AND state = 9 ORDER BY id DESC
SQL Time: 0.00063896179199219
PHP Script:TPL_CLASS.php1.8816721439362
PHP Script:TPL_GOODSCLASS.php1.8819491863251
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 tejia2=1 and a.offerid=1 AND catpath like '%,%' AND ifobject != 3 ORDER BY offer_ord DESC LIMIT 0,30
SQL Time: 0.0045969486236572
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '228' AND state = 9 ORDER BY id DESC
SQL Time: 0.00055289268493652
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '169' AND state = 9 ORDER BY id DESC
SQL Time: 0.00072288513183594
SQL QUERY: SELECT * FROM sdb_mall_goodsnotify WHERE offerid = '1' AND gid = '168' AND state = 9 ORDER BY id DESC
SQL Time: 0.00068998336791992
PHP Script:TPL_BOTTOM.php1.9161341190338
SQL QUERY: SELECT * FROM sdb_mall_offer_p WHERE ptype='ALIPAY' AND offerid=1 ORDER BY ordernum DESC
SQL Time: 0.00089693069458008
SQL QUERY: SELECT * FROM sdb_mall_offer_integrateim WHERE offerid = 1 AND showpage like '%copyright%' ORDER BY id DESC
SQL Time: 0.0007169246673584
SQL QUERY: SELECT value from sdb_mall_offer_setup where keyword='generalize_front_show' and offerid=1
SQL Time: 0.0015268325805664
SQL QUERY: SELECT value from sdb_mall_offer_setup where keyword='generalize_id' and offerid=1
SQL Time: 0.00048208236694336
SQL QUERY: SELECT value from sdb_mall_offer_setup where keyword='generalize_ifshow' and offerid=1
SQL Time: 0.00045895576477051
SQL QUERY: SELECT * FROM sdb_mall_offer_definetag where offerid = '1'
SQL Time: 0.00099301338195801
PHP Script:--END2.0253610610962
total sql time:0.65224051475525
Loaded Classes:
indexShop
TemplateFile
shopInterface
indexShopAdv
indexmallConfig
frontShow
wildSetup
flyTemp
Pager
shopArticle
shopArticleType
shopCategory
ShopCurrency
Product
shopPayment
GoodsNotify
shoplink
IntegrateIm
shopSetup
DefineTag
ClassesLoaded Time:0.2476122379303