SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002018s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000502s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003478s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.0' ) [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001961s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002356s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002002s ]
SELECT * FROM `stock_search` WHERE `partno` = '10078' LIMIT 1 [ RunTime:0.000733s ]
UPDATE `stock_search` SET `count` = 6427 , `updatetime` = '2026-03-14 11:08:03' WHERE `partno` = '10078' [ RunTime:0.001732s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000294s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000267s ]
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.000375s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002136s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '10078%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.004591s ]
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 '10078%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.004693s ]
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 ('16218346','16214546','16213205','16213204','16213047','16207119','16206578','16206577','16206576','16205171','16202942','16201951','15489423','15486211','15483883','15481398','15449194','15448763','14496596','14246291') ORDER BY FIELD(s.id, 16218346,16214546,16213205,16213204,16213047,16207119,16206578,16206577,16206576,16205171,16202942,16201951,15489423,15486211,15483883,15481398,15449194,15448763,14496596,14246291) [ RunTime:0.008326s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16218346 LIMIT 4 [ RunTime:0.003818s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16218346 ORDER BY `minOrder` ASC [ RunTime:0.003854s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16218346 ORDER BY `unit` DESC [ RunTime:0.009267s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16218346 LIMIT 2 [ RunTime:0.014888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16218346 ORDER BY `minOrder` ASC [ RunTime:0.007427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16214546 LIMIT 4 [ RunTime:0.012518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214546 ORDER BY `minOrder` ASC [ RunTime:0.017739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16214546 ORDER BY `unit` DESC [ RunTime:0.004627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16214546 LIMIT 2 [ RunTime:0.008829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214546 ORDER BY `minOrder` ASC [ RunTime:0.013046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213205 LIMIT 4 [ RunTime:0.012611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213205 ORDER BY `minOrder` ASC [ RunTime:0.006879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16213205 ORDER BY `unit` DESC [ RunTime:0.001831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16213205 LIMIT 2 [ RunTime:0.001787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213205 ORDER BY `minOrder` ASC [ RunTime:0.001983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213204 LIMIT 4 [ RunTime:0.002707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213204 ORDER BY `minOrder` ASC [ RunTime:0.003793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16213204 ORDER BY `unit` DESC [ RunTime:0.016917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16213204 LIMIT 2 [ RunTime:0.016800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213204 ORDER BY `minOrder` ASC [ RunTime:0.015998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213047 LIMIT 4 [ RunTime:0.001778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213047 ORDER BY `minOrder` ASC [ RunTime:0.001332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16213047 ORDER BY `unit` DESC [ RunTime:0.003795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16213047 LIMIT 2 [ RunTime:0.006929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213047 ORDER BY `minOrder` ASC [ RunTime:0.004234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16207119 LIMIT 4 [ RunTime:0.019762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207119 ORDER BY `minOrder` ASC [ RunTime:0.001227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16207119 ORDER BY `unit` DESC [ RunTime:0.007910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16207119 LIMIT 2 [ RunTime:0.022854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207119 ORDER BY `minOrder` ASC [ RunTime:0.002566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16206578 LIMIT 4 [ RunTime:0.008726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206578 ORDER BY `minOrder` ASC [ RunTime:0.004425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16206578 ORDER BY `unit` DESC [ RunTime:0.003637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16206578 LIMIT 2 [ RunTime:0.007757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206578 ORDER BY `minOrder` ASC [ RunTime:0.007129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16206577 LIMIT 4 [ RunTime:0.011218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206577 ORDER BY `minOrder` ASC [ RunTime:0.008884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16206577 ORDER BY `unit` DESC [ RunTime:0.009357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16206577 LIMIT 2 [ RunTime:0.014590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206577 ORDER BY `minOrder` ASC [ RunTime:0.001885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16206576 LIMIT 4 [ RunTime:0.000835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206576 ORDER BY `minOrder` ASC [ RunTime:0.008656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16206576 ORDER BY `unit` DESC [ RunTime:0.005634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16206576 LIMIT 2 [ RunTime:0.006284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206576 ORDER BY `minOrder` ASC [ RunTime:0.003315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16205171 LIMIT 4 [ RunTime:0.015199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205171 ORDER BY `minOrder` ASC [ RunTime:0.014205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16205171 ORDER BY `unit` DESC [ RunTime:0.006686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16205171 LIMIT 2 [ RunTime:0.012853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205171 ORDER BY `minOrder` ASC [ RunTime:0.001480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16202942 LIMIT 4 [ RunTime:0.005191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16202942 ORDER BY `minOrder` ASC [ RunTime:0.010492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16202942 ORDER BY `unit` DESC [ RunTime:0.004493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16202942 LIMIT 2 [ RunTime:0.013878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16202942 ORDER BY `minOrder` ASC [ RunTime:0.005907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16201951 LIMIT 4 [ RunTime:0.002791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16201951 ORDER BY `minOrder` ASC [ RunTime:0.004326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16201951 ORDER BY `unit` DESC [ RunTime:0.011851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16201951 LIMIT 2 [ RunTime:0.005788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16201951 ORDER BY `minOrder` ASC [ RunTime:0.011691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15489423 LIMIT 4 [ RunTime:0.013580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489423 ORDER BY `minOrder` ASC [ RunTime:0.003047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15489423 ORDER BY `unit` DESC [ RunTime:0.007100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15489423 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489423 ORDER BY `minOrder` ASC [ RunTime:0.002532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486211 LIMIT 4 [ RunTime:0.005342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486211 ORDER BY `minOrder` ASC [ RunTime:0.002127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15486211 ORDER BY `unit` DESC [ RunTime:0.001746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15486211 LIMIT 2 [ RunTime:0.001362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486211 ORDER BY `minOrder` ASC [ RunTime:0.003188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15483883 LIMIT 4 [ RunTime:0.009655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15483883 ORDER BY `minOrder` ASC [ RunTime:0.017107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15483883 ORDER BY `unit` DESC [ RunTime:0.011364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15483883 LIMIT 2 [ RunTime:0.025774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15483883 ORDER BY `minOrder` ASC [ RunTime:0.006284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15481398 LIMIT 4 [ RunTime:0.010355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15481398 ORDER BY `minOrder` ASC [ RunTime:0.011894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15481398 ORDER BY `unit` DESC [ RunTime:0.010851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15481398 LIMIT 2 [ RunTime:0.014398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15481398 ORDER BY `minOrder` ASC [ RunTime:0.004296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15449194 LIMIT 4 [ RunTime:0.007581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15449194 ORDER BY `minOrder` ASC [ RunTime:0.035231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15449194 ORDER BY `unit` DESC [ RunTime:0.020200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15449194 LIMIT 2 [ RunTime:0.024840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15449194 ORDER BY `minOrder` ASC [ RunTime:0.002837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448763 LIMIT 4 [ RunTime:0.005089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448763 ORDER BY `minOrder` ASC [ RunTime:0.002755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15448763 ORDER BY `unit` DESC [ RunTime:0.035826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15448763 LIMIT 2 [ RunTime:0.019152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448763 ORDER BY `minOrder` ASC [ RunTime:0.001286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14496596 LIMIT 4 [ RunTime:0.023404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14496596 ORDER BY `minOrder` ASC [ RunTime:0.010123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14496596 ORDER BY `unit` DESC [ RunTime:0.036701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14496596 LIMIT 2 [ RunTime:0.010699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14496596 ORDER BY `minOrder` ASC [ RunTime:0.013109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14246291 LIMIT 4 [ RunTime:0.016579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14246291 ORDER BY `minOrder` ASC [ RunTime:0.019543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14246291 ORDER BY `unit` DESC [ RunTime:0.047753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14246291 LIMIT 2 [ RunTime:0.031965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14246291 ORDER BY `minOrder` ASC [ RunTime:0.015961s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '10078%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.004866s ]