SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001356s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004666s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001558s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.37' ) [ RunTime:0.000322s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001729s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000324s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000226s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000427s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001286s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay IS NULL OR s.isDisplay = 1) ) AND ( `partno` LIKE '3003%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.004649s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay IS NULL OR s.isDisplay = 1) ) AND `s`.`id` IN ('9528195','9528170','9528065','9528064','9527823','8869914','8680711','7572780','7572230','7280958','7280623','7266553','7262022','7024264','6992543','6988350','6968528','6117515','5421379','5235851') ORDER BY FIELD(s.id, 9528195,9528170,9528065,9528064,9527823,8869914,8680711,7572780,7572230,7280958,7280623,7266553,7262022,7024264,6992543,6988350,6968528,6117515,5421379,5235851) [ RunTime:0.006845s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9528195 LIMIT 4 [ RunTime:0.002799s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9528195 ORDER BY `minOrder` ASC [ RunTime:0.001986s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9528195 ORDER BY `unit` DESC [ RunTime:0.001739s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9528195 LIMIT 2 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9528195 ORDER BY `minOrder` ASC [ RunTime:0.000198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9528170 LIMIT 4 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9528170 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9528170 ORDER BY `unit` DESC [ RunTime:0.001931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9528170 LIMIT 2 [ RunTime:0.005418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9528170 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9528065 LIMIT 4 [ RunTime:0.003220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9528065 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9528065 ORDER BY `unit` DESC [ RunTime:0.002009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9528065 LIMIT 2 [ RunTime:0.001120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9528065 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9528064 LIMIT 4 [ RunTime:0.001435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9528064 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9528064 ORDER BY `unit` DESC [ RunTime:0.001566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9528064 LIMIT 2 [ RunTime:0.002952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9528064 ORDER BY `minOrder` ASC [ RunTime:0.001383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9527823 LIMIT 4 [ RunTime:0.002179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9527823 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9527823 ORDER BY `unit` DESC [ RunTime:0.000288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9527823 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9527823 ORDER BY `minOrder` ASC [ RunTime:0.001099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8869914 LIMIT 4 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8869914 ORDER BY `minOrder` ASC [ RunTime:0.002740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8869914 ORDER BY `unit` DESC [ RunTime:0.001156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8869914 LIMIT 2 [ RunTime:0.001197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8869914 ORDER BY `minOrder` ASC [ RunTime:0.000193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8680711 LIMIT 4 [ RunTime:0.001341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8680711 ORDER BY `minOrder` ASC [ RunTime:0.001045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8680711 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8680711 LIMIT 2 [ RunTime:0.000288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8680711 ORDER BY `minOrder` ASC [ RunTime:0.000187s ]
select * from pdf where partno='3003' and brandshort='3M' limit 1 [ RunTime:0.002834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7572780 LIMIT 4 [ RunTime:0.005660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7572780 ORDER BY `minOrder` ASC [ RunTime:0.002726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7572780 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7572780 LIMIT 2 [ RunTime:0.002533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7572780 ORDER BY `minOrder` ASC [ RunTime:0.001157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7572230 LIMIT 4 [ RunTime:0.005121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7572230 ORDER BY `minOrder` ASC [ RunTime:0.008120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7572230 ORDER BY `unit` DESC [ RunTime:0.001765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7572230 LIMIT 2 [ RunTime:0.000834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7572230 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7280958 LIMIT 4 [ RunTime:0.001114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7280958 ORDER BY `minOrder` ASC [ RunTime:0.003069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7280958 ORDER BY `unit` DESC [ RunTime:0.000707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7280958 LIMIT 2 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7280958 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7280623 LIMIT 4 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7280623 ORDER BY `minOrder` ASC [ RunTime:0.001045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7280623 ORDER BY `unit` DESC [ RunTime:0.002139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7280623 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7280623 ORDER BY `minOrder` ASC [ RunTime:0.000193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7266553 LIMIT 4 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7266553 ORDER BY `minOrder` ASC [ RunTime:0.002608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7266553 ORDER BY `unit` DESC [ RunTime:0.001761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7266553 LIMIT 2 [ RunTime:0.003072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7266553 ORDER BY `minOrder` ASC [ RunTime:0.000166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7262022 LIMIT 4 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7262022 ORDER BY `minOrder` ASC [ RunTime:0.001204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7262022 ORDER BY `unit` DESC [ RunTime:0.005845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7262022 LIMIT 2 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7262022 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7024264 LIMIT 4 [ RunTime:0.001862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7024264 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7024264 ORDER BY `unit` DESC [ RunTime:0.002373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7024264 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7024264 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6992543 LIMIT 4 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6992543 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6992543 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6992543 LIMIT 2 [ RunTime:0.000225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6992543 ORDER BY `minOrder` ASC [ RunTime:0.003194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6988350 LIMIT 4 [ RunTime:0.001957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6988350 ORDER BY `minOrder` ASC [ RunTime:0.002421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6988350 ORDER BY `unit` DESC [ RunTime:0.000788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6988350 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6988350 ORDER BY `minOrder` ASC [ RunTime:0.000163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6968528 LIMIT 4 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6968528 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6968528 ORDER BY `unit` DESC [ RunTime:0.000232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6968528 LIMIT 2 [ RunTime:0.001978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6968528 ORDER BY `minOrder` ASC [ RunTime:0.001235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6117515 LIMIT 4 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6117515 ORDER BY `minOrder` ASC [ RunTime:0.001233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6117515 ORDER BY `unit` DESC [ RunTime:0.000734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6117515 LIMIT 2 [ RunTime:0.001934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6117515 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5421379 LIMIT 4 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5421379 ORDER BY `minOrder` ASC [ RunTime:0.002000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5421379 ORDER BY `unit` DESC [ RunTime:0.000246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5421379 LIMIT 2 [ RunTime:0.003522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5421379 ORDER BY `minOrder` ASC [ RunTime:0.000189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5235851 LIMIT 4 [ RunTime:0.002280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5235851 ORDER BY `minOrder` ASC [ RunTime:0.001054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5235851 ORDER BY `unit` DESC [ RunTime:0.002435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5235851 LIMIT 2 [ RunTime:0.000254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5235851 ORDER BY `minOrder` ASC [ RunTime:0.000162s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '3003%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.008376s ]