SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002402s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000637s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001485s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.25' ) [ RunTime:0.000959s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001553s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000660s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000279s ]
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.000495s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002561s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'T491D226K035AT%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.008336s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'T491D226K035AT%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001888s ]
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 = 1) ) AND `s`.`id` IN ('4884670','7612706','2057','7596862','7594889','7594888','6713921','6713264','6712110','5571235','5571234','5571199','5571198','5571197','5570763','5570762','4894526','4887627','4886859','4885165') ORDER BY FIELD(s.id, 4884670,7612706,2057,7596862,7594889,7594888,6713921,6713264,6712110,5571235,5571234,5571199,5571198,5571197,5570763,5570762,4894526,4887627,4886859,4885165) [ RunTime:0.012330s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4884670 LIMIT 4 [ RunTime:0.004613s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4884670 ORDER BY `minOrder` ASC [ RunTime:0.004157s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4884670 ORDER BY `unit` DESC [ RunTime:0.002174s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4884670 LIMIT 2 [ RunTime:0.003421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4884670 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7612706 LIMIT 4 [ RunTime:0.000798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7612706 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7612706 ORDER BY `unit` DESC [ RunTime:0.002248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7612706 LIMIT 2 [ RunTime:0.008124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7612706 ORDER BY `minOrder` ASC [ RunTime:0.002328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2057 LIMIT 4 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2057 ORDER BY `minOrder` ASC [ RunTime:0.004946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2057 ORDER BY `unit` DESC [ RunTime:0.005586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2057 LIMIT 2 [ RunTime:0.004396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2057 ORDER BY `minOrder` ASC [ RunTime:0.006534s ]
select * from pdf where partno='T491D226K035AT' and brandshort='KEMET' limit 1 [ RunTime:0.007008s ]
select foldpath,foldpath2,filename from pdf_file where id=1470040 limit 1 [ RunTime:0.004997s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D226K035AT' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.012270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7596862 LIMIT 4 [ RunTime:0.001016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7596862 ORDER BY `minOrder` ASC [ RunTime:0.001547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7596862 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7596862 LIMIT 2 [ RunTime:0.000530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7596862 ORDER BY `minOrder` ASC [ RunTime:0.001333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7594889 LIMIT 4 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7594889 ORDER BY `minOrder` ASC [ RunTime:0.003567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7594889 ORDER BY `unit` DESC [ RunTime:0.003839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7594889 LIMIT 2 [ RunTime:0.001300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7594889 ORDER BY `minOrder` ASC [ RunTime:0.003038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7594888 LIMIT 4 [ RunTime:0.001396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7594888 ORDER BY `minOrder` ASC [ RunTime:0.000779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7594888 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7594888 LIMIT 2 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7594888 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6713921 LIMIT 4 [ RunTime:0.001438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6713921 ORDER BY `minOrder` ASC [ RunTime:0.001343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6713921 ORDER BY `unit` DESC [ RunTime:0.001090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6713921 LIMIT 2 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6713921 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6713264 LIMIT 4 [ RunTime:0.000801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6713264 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6713264 ORDER BY `unit` DESC [ RunTime:0.002136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6713264 LIMIT 2 [ RunTime:0.001915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6713264 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6712110 LIMIT 4 [ RunTime:0.000794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6712110 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6712110 ORDER BY `unit` DESC [ RunTime:0.000465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6712110 LIMIT 2 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6712110 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5571235 LIMIT 4 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5571235 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5571235 ORDER BY `unit` DESC [ RunTime:0.000466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5571235 LIMIT 2 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5571235 ORDER BY `minOrder` ASC [ RunTime:0.000843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5571234 LIMIT 4 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5571234 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5571234 ORDER BY `unit` DESC [ RunTime:0.001280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5571234 LIMIT 2 [ RunTime:0.001766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5571234 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5571199 LIMIT 4 [ RunTime:0.000778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5571199 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5571199 ORDER BY `unit` DESC [ RunTime:0.002656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5571199 LIMIT 2 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5571199 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5571198 LIMIT 4 [ RunTime:0.000511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5571198 ORDER BY `minOrder` ASC [ RunTime:0.001225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5571198 ORDER BY `unit` DESC [ RunTime:0.005591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5571198 LIMIT 2 [ RunTime:0.002026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5571198 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5571197 LIMIT 4 [ RunTime:0.007412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5571197 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5571197 ORDER BY `unit` DESC [ RunTime:0.000474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5571197 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5571197 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5570763 LIMIT 4 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5570763 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5570763 ORDER BY `unit` DESC [ RunTime:0.002365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5570763 LIMIT 2 [ RunTime:0.001406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5570763 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5570762 LIMIT 4 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5570762 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5570762 ORDER BY `unit` DESC [ RunTime:0.000864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5570762 LIMIT 2 [ RunTime:0.002617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5570762 ORDER BY `minOrder` ASC [ RunTime:0.001495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4894526 LIMIT 4 [ RunTime:0.004012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4894526 ORDER BY `minOrder` ASC [ RunTime:0.002163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4894526 ORDER BY `unit` DESC [ RunTime:0.005249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4894526 LIMIT 2 [ RunTime:0.004113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4894526 ORDER BY `minOrder` ASC [ RunTime:0.002104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4887627 LIMIT 4 [ RunTime:0.004892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4887627 ORDER BY `minOrder` ASC [ RunTime:0.004215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4887627 ORDER BY `unit` DESC [ RunTime:0.001087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4887627 LIMIT 2 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4887627 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4886859 LIMIT 4 [ RunTime:0.004148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4886859 ORDER BY `minOrder` ASC [ RunTime:0.005851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4886859 ORDER BY `unit` DESC [ RunTime:0.000718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4886859 LIMIT 2 [ RunTime:0.002218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4886859 ORDER BY `minOrder` ASC [ RunTime:0.001769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4885165 LIMIT 4 [ RunTime:0.001552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4885165 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4885165 ORDER BY `unit` DESC [ RunTime:0.000507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4885165 LIMIT 2 [ RunTime:0.001906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4885165 ORDER BY `minOrder` ASC [ RunTime:0.002313s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'T491D226K035AT%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002089s ]