SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003729s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=NS10&search=1' [ RunTime:0.003460s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001717s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000593s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001924s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.000327s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002035s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000290s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001819s ]
SELECT * FROM `stock_search` WHERE `partno` = 'NS10' LIMIT 1 [ RunTime:0.004235s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 14:16:14' WHERE `partno` = 'NS10' [ RunTime:0.008979s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002591s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NS10%' OR `brand` LIKE 'NS10%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030070s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13426624 LIMIT 5 [ RunTime:0.004762s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13426624 ORDER BY `minOrder` ASC [ RunTime:0.005224s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13426624 ORDER BY `unit` DESC [ RunTime:0.004284s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13426624 LIMIT 2 [ RunTime:0.016143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13426624 ORDER BY `minOrder` ASC [ RunTime:0.005210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13391181 LIMIT 5 [ RunTime:0.016890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13391181 ORDER BY `minOrder` ASC [ RunTime:0.002400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13391181 ORDER BY `unit` DESC [ RunTime:0.013810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13391181 LIMIT 2 [ RunTime:0.019344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13391181 ORDER BY `minOrder` ASC [ RunTime:0.012930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14317341 LIMIT 5 [ RunTime:0.014525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317341 ORDER BY `minOrder` ASC [ RunTime:0.021213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14317341 ORDER BY `unit` DESC [ RunTime:0.008824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14317341 LIMIT 2 [ RunTime:0.011283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317341 ORDER BY `minOrder` ASC [ RunTime:0.012023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279092 LIMIT 5 [ RunTime:0.001636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279092 ORDER BY `minOrder` ASC [ RunTime:0.007637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279092 ORDER BY `unit` DESC [ RunTime:0.006140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279092 LIMIT 2 [ RunTime:0.009921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279092 ORDER BY `minOrder` ASC [ RunTime:0.004238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13412113 LIMIT 5 [ RunTime:0.010702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13412113 ORDER BY `minOrder` ASC [ RunTime:0.004905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13412113 ORDER BY `unit` DESC [ RunTime:0.009391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13412113 LIMIT 2 [ RunTime:0.011282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13412113 ORDER BY `minOrder` ASC [ RunTime:0.012643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279094 LIMIT 5 [ RunTime:0.009071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279094 ORDER BY `minOrder` ASC [ RunTime:0.010072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279094 ORDER BY `unit` DESC [ RunTime:0.001883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279094 LIMIT 2 [ RunTime:0.012815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279094 ORDER BY `minOrder` ASC [ RunTime:0.005293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16384459 LIMIT 5 [ RunTime:0.021873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16384459 ORDER BY `minOrder` ASC [ RunTime:0.022250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16384459 ORDER BY `unit` DESC [ RunTime:0.001320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16384459 LIMIT 2 [ RunTime:0.021738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16384459 ORDER BY `minOrder` ASC [ RunTime:0.007001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14278540 LIMIT 5 [ RunTime:0.016213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14278540 ORDER BY `minOrder` ASC [ RunTime:0.004382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14278540 ORDER BY `unit` DESC [ RunTime:0.018558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14278540 LIMIT 2 [ RunTime:0.011260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14278540 ORDER BY `minOrder` ASC [ RunTime:0.001691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13391189 LIMIT 5 [ RunTime:0.007306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13391189 ORDER BY `minOrder` ASC [ RunTime:0.012372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13391189 ORDER BY `unit` DESC [ RunTime:0.011135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13391189 LIMIT 2 [ RunTime:0.008212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13391189 ORDER BY `minOrder` ASC [ RunTime:0.018507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13391190 LIMIT 5 [ RunTime:0.006076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13391190 ORDER BY `minOrder` ASC [ RunTime:0.021018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13391190 ORDER BY `unit` DESC [ RunTime:0.018167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13391190 LIMIT 2 [ RunTime:0.035806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13391190 ORDER BY `minOrder` ASC [ RunTime:0.002576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14320296 LIMIT 5 [ RunTime:0.024027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14320296 ORDER BY `minOrder` ASC [ RunTime:0.010639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14320296 ORDER BY `unit` DESC [ RunTime:0.025268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14320296 LIMIT 2 [ RunTime:0.029528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14320296 ORDER BY `minOrder` ASC [ RunTime:0.044943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14278541 LIMIT 5 [ RunTime:0.009225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14278541 ORDER BY `minOrder` ASC [ RunTime:0.024437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14278541 ORDER BY `unit` DESC [ RunTime:0.039870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14278541 LIMIT 2 [ RunTime:0.004231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14278541 ORDER BY `minOrder` ASC [ RunTime:0.018515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13391195 LIMIT 5 [ RunTime:0.014616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13391195 ORDER BY `minOrder` ASC [ RunTime:0.019116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13391195 ORDER BY `unit` DESC [ RunTime:0.010129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13391195 LIMIT 2 [ RunTime:0.003378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13391195 ORDER BY `minOrder` ASC [ RunTime:0.001016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14279098 LIMIT 5 [ RunTime:0.012763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279098 ORDER BY `minOrder` ASC [ RunTime:0.013316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14279098 ORDER BY `unit` DESC [ RunTime:0.014808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14279098 LIMIT 2 [ RunTime:0.008907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14279098 ORDER BY `minOrder` ASC [ RunTime:0.000679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13422378 LIMIT 5 [ RunTime:0.010438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13422378 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13422378 ORDER BY `unit` DESC [ RunTime:0.009882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13422378 LIMIT 2 [ RunTime:0.014972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13422378 ORDER BY `minOrder` ASC [ RunTime:0.002058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13411716 LIMIT 5 [ RunTime:0.011983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13411716 ORDER BY `minOrder` ASC [ RunTime:0.005277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13411716 ORDER BY `unit` DESC [ RunTime:0.003641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13411716 LIMIT 2 [ RunTime:0.002197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13411716 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14319574 LIMIT 5 [ RunTime:0.005229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14319574 ORDER BY `minOrder` ASC [ RunTime:0.003426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14319574 ORDER BY `unit` DESC [ RunTime:0.001980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14319574 LIMIT 2 [ RunTime:0.003554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14319574 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13411685 LIMIT 5 [ RunTime:0.002305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13411685 ORDER BY `minOrder` ASC [ RunTime:0.002258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13411685 ORDER BY `unit` DESC [ RunTime:0.007158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13411685 LIMIT 2 [ RunTime:0.003815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13411685 ORDER BY `minOrder` ASC [ RunTime:0.003233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14320316 LIMIT 5 [ RunTime:0.015337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14320316 ORDER BY `minOrder` ASC [ RunTime:0.004046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14320316 ORDER BY `unit` DESC [ RunTime:0.005868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14320316 LIMIT 2 [ RunTime:0.008941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14320316 ORDER BY `minOrder` ASC [ RunTime:0.005212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13412691 LIMIT 5 [ RunTime:0.002551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13412691 ORDER BY `minOrder` ASC [ RunTime:0.002143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13412691 ORDER BY `unit` DESC [ RunTime:0.002953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13412691 LIMIT 2 [ RunTime:0.006558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13412691 ORDER BY `minOrder` ASC [ RunTime:0.008949s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NS10%' OR `brand` LIKE 'NS10%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51120104 LIMIT 5 [ RunTime:0.010044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51120104 ORDER BY `minOrder` ASC [ RunTime:0.017251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51120104 ORDER BY `unit` DESC [ RunTime:0.008143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51120104 LIMIT 2 [ RunTime:0.010043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51120104 ORDER BY `minOrder` ASC [ RunTime:0.028766s ]
select * from pdf where partno='ns10165t220mnvv' and brandshort='taiyo yuden' limit 1 [ RunTime:0.010323s ]
select foldpath,foldpath2,filename from pdf_file where id=1986538 limit 1 [ RunTime:0.006759s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ns10165t220mnvv' OR `brand` LIKE 'taiyo yuden%' ) ) LIMIT 1 [ RunTime:0.014990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51119704 LIMIT 5 [ RunTime:0.002953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51119704 ORDER BY `minOrder` ASC [ RunTime:0.008730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51119704 ORDER BY `unit` DESC [ RunTime:0.001291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51119704 LIMIT 2 [ RunTime:0.006456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51119704 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
select * from pdf where partno='ns10145t150mnv8' and brandshort='taiyo yuden' limit 1 [ RunTime:0.009169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ns10145t150mnv8' OR `brand` LIKE 'taiyo yuden%' ) ) LIMIT 1 [ RunTime:0.009886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51119611 LIMIT 5 [ RunTime:0.007370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51119611 ORDER BY `minOrder` ASC [ RunTime:0.014982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51119611 ORDER BY `unit` DESC [ RunTime:0.008582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51119611 LIMIT 2 [ RunTime:0.006458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51119611 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='ns10145t150mnvv' and brandshort='taiyo yuden' limit 1 [ RunTime:0.001279s ]
select foldpath,foldpath2,filename from pdf_file where id=1986538 limit 1 [ RunTime:0.001096s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ns10145t150mnvv' OR `brand` LIKE 'taiyo yuden%' ) ) LIMIT 1 [ RunTime:0.007267s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NS10%' OR `brand` LIKE 'NS10%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40466435 LIMIT 5 [ RunTime:0.004043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466435 ORDER BY `minOrder` ASC [ RunTime:0.002183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40466435 ORDER BY `unit` DESC [ RunTime:0.002182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40466435 LIMIT 2 [ RunTime:0.004336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466435 ORDER BY `minOrder` ASC [ RunTime:0.005028s ]
select * from pdf where partno='NS10145T680MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.008021s ]
select foldpath,foldpath2,filename from pdf_file where id=2072218 limit 1 [ RunTime:0.009686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T680MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.006529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40466537 LIMIT 5 [ RunTime:0.020433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466537 ORDER BY `minOrder` ASC [ RunTime:0.003863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40466537 ORDER BY `unit` DESC [ RunTime:0.003597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40466537 LIMIT 2 [ RunTime:0.020158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466537 ORDER BY `minOrder` ASC [ RunTime:0.003715s ]
select * from pdf where partno='NS10155T220MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.005723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10155T220MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.004112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40473551 LIMIT 5 [ RunTime:0.006550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40473551 ORDER BY `minOrder` ASC [ RunTime:0.009449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40473551 ORDER BY `unit` DESC [ RunTime:0.001271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40473551 LIMIT 2 [ RunTime:0.003299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40473551 ORDER BY `minOrder` ASC [ RunTime:0.003431s ]
select * from pdf where partno='NS10145T471MNVV' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.008278s ]
select foldpath,foldpath2,filename from pdf_file where id=1989029 limit 1 [ RunTime:0.003665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T471MNVV' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.007966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456087 LIMIT 5 [ RunTime:0.010824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456087 ORDER BY `minOrder` ASC [ RunTime:0.011434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456087 ORDER BY `unit` DESC [ RunTime:0.009061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456087 LIMIT 2 [ RunTime:0.008827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456087 ORDER BY `minOrder` ASC [ RunTime:0.004572s ]
select * from pdf where partno='NS10165T220MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.009013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10165T220MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.007484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456088 LIMIT 5 [ RunTime:0.004766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456088 ORDER BY `minOrder` ASC [ RunTime:0.009257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456088 ORDER BY `unit` DESC [ RunTime:0.001475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456088 LIMIT 2 [ RunTime:0.001708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456088 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='NS10165T150MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.016944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10165T150MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.001901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40466447 LIMIT 5 [ RunTime:0.012693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466447 ORDER BY `minOrder` ASC [ RunTime:0.024500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40466447 ORDER BY `unit` DESC [ RunTime:0.005011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40466447 LIMIT 2 [ RunTime:0.002554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466447 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='NS10145T6R8NNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.011332s ]
select foldpath,foldpath2,filename from pdf_file where id=2087821 limit 1 [ RunTime:0.009898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T6R8NNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.004867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40466450 LIMIT 5 [ RunTime:0.003838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466450 ORDER BY `minOrder` ASC [ RunTime:0.012929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40466450 ORDER BY `unit` DESC [ RunTime:0.016959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40466450 LIMIT 2 [ RunTime:0.002288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466450 ORDER BY `minOrder` ASC [ RunTime:0.003362s ]
select * from pdf where partno='NS10145T152MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.005061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T152MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.020997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40459868 LIMIT 5 [ RunTime:0.019831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459868 ORDER BY `minOrder` ASC [ RunTime:0.007427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40459868 ORDER BY `unit` DESC [ RunTime:0.003740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40459868 LIMIT 2 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459868 ORDER BY `minOrder` ASC [ RunTime:0.000873s ]
select * from pdf where partno='NS10155T4R7NNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.012615s ]
select foldpath,foldpath2,filename from pdf_file where id=2087481 limit 1 [ RunTime:0.002402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10155T4R7NNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.006823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40459815 LIMIT 5 [ RunTime:0.002846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459815 ORDER BY `minOrder` ASC [ RunTime:0.012280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40459815 ORDER BY `unit` DESC [ RunTime:0.002232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40459815 LIMIT 2 [ RunTime:0.002476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459815 ORDER BY `minOrder` ASC [ RunTime:0.003567s ]
select * from pdf where partno='NS10145T681MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.014161s ]
select foldpath,foldpath2,filename from pdf_file where id=2072217 limit 1 [ RunTime:0.004023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T681MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.008375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40459816 LIMIT 5 [ RunTime:0.006064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459816 ORDER BY `minOrder` ASC [ RunTime:0.009998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40459816 ORDER BY `unit` DESC [ RunTime:0.012514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40459816 LIMIT 2 [ RunTime:0.004529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459816 ORDER BY `minOrder` ASC [ RunTime:0.002912s ]
select * from pdf where partno='NS10145T471MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.005935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T471MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.004458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40459818 LIMIT 5 [ RunTime:0.003616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459818 ORDER BY `minOrder` ASC [ RunTime:0.001237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40459818 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40459818 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459818 ORDER BY `minOrder` ASC [ RunTime:0.002081s ]
select * from pdf where partno='NS10145T221MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.009735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T221MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.006429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40472878 LIMIT 5 [ RunTime:0.008254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40472878 ORDER BY `minOrder` ASC [ RunTime:0.007292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40472878 ORDER BY `unit` DESC [ RunTime:0.005786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40472878 LIMIT 2 [ RunTime:0.015790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40472878 ORDER BY `minOrder` ASC [ RunTime:0.004269s ]
select * from pdf where partno='NS10145T3R3NNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.010987s ]
select foldpath,foldpath2,filename from pdf_file where id=2166721 limit 1 [ RunTime:0.012750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T3R3NNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.025847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40459869 LIMIT 5 [ RunTime:0.006859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459869 ORDER BY `minOrder` ASC [ RunTime:0.000992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40459869 ORDER BY `unit` DESC [ RunTime:0.008486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40459869 LIMIT 2 [ RunTime:0.008656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459869 ORDER BY `minOrder` ASC [ RunTime:0.014617s ]
select * from pdf where partno='NS10155T150MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.011307s ]
select foldpath,foldpath2,filename from pdf_file where id=2072215 limit 1 [ RunTime:0.020945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10155T150MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.013837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40472931 LIMIT 5 [ RunTime:0.005993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40472931 ORDER BY `minOrder` ASC [ RunTime:0.020042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40472931 ORDER BY `unit` DESC [ RunTime:0.020151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40472931 LIMIT 2 [ RunTime:0.040273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40472931 ORDER BY `minOrder` ASC [ RunTime:0.010922s ]
select * from pdf where partno='NS10155T1R5NNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.033125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10155T1R5NNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.033254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40466463 LIMIT 5 [ RunTime:0.016809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466463 ORDER BY `minOrder` ASC [ RunTime:0.017734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40466463 ORDER BY `unit` DESC [ RunTime:0.019077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40466463 LIMIT 2 [ RunTime:0.027386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466463 ORDER BY `minOrder` ASC [ RunTime:0.004421s ]
select * from pdf where partno='NS10145T470MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.032994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T470MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.011577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40466602 LIMIT 5 [ RunTime:0.016609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466602 ORDER BY `minOrder` ASC [ RunTime:0.013693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40466602 ORDER BY `unit` DESC [ RunTime:0.030199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40466602 LIMIT 2 [ RunTime:0.006831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466602 ORDER BY `minOrder` ASC [ RunTime:0.000932s ]
select * from pdf where partno='NS10165T6R8NNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.001924s ]
select foldpath,foldpath2,filename from pdf_file where id=1761382 limit 1 [ RunTime:0.002771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10165T6R8NNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.007899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40472879 LIMIT 5 [ RunTime:0.012258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40472879 ORDER BY `minOrder` ASC [ RunTime:0.010115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40472879 ORDER BY `unit` DESC [ RunTime:0.005230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40472879 LIMIT 2 [ RunTime:0.014962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40472879 ORDER BY `minOrder` ASC [ RunTime:0.007957s ]
select * from pdf where partno='NS10145T1R0NNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.001994s ]
select foldpath,foldpath2,filename from pdf_file where id=2095805 limit 1 [ RunTime:0.003503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T1R0NNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.002753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40459825 LIMIT 5 [ RunTime:0.008880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459825 ORDER BY `minOrder` ASC [ RunTime:0.009547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40459825 ORDER BY `unit` DESC [ RunTime:0.005120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40459825 LIMIT 2 [ RunTime:0.008736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40459825 ORDER BY `minOrder` ASC [ RunTime:0.001398s ]
select * from pdf where partno='NS10145T101MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.004987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T101MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.005416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40473558 LIMIT 5 [ RunTime:0.005599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40473558 ORDER BY `minOrder` ASC [ RunTime:0.011821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40473558 ORDER BY `unit` DESC [ RunTime:0.002814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40473558 LIMIT 2 [ RunTime:0.036365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40473558 ORDER BY `minOrder` ASC [ RunTime:0.031470s ]
select * from pdf where partno='NS10145T152MNVV' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.009685s ]
select foldpath,foldpath2,filename from pdf_file where id=1989029 limit 1 [ RunTime:0.009012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T152MNVV' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.043861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40466467 LIMIT 5 [ RunTime:0.015130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466467 ORDER BY `minOrder` ASC [ RunTime:0.032022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40466467 ORDER BY `unit` DESC [ RunTime:0.023698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40466467 LIMIT 2 [ RunTime:0.051203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40466467 ORDER BY `minOrder` ASC [ RunTime:0.030136s ]
select * from pdf where partno='NS10145T100MNA' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.023612s ]
select foldpath,foldpath2,filename from pdf_file where id=2087817 limit 1 [ RunTime:0.012475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NS10145T100MNA' OR `brand` LIKE 'Taiyo Yuden%' ) ) LIMIT 1 [ RunTime:0.022038s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NS10%' OR `brand` LIKE 'NS10%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009984s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NS10%' OR `brand` LIKE 'NS10%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009267s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NS10%' OR `brand` LIKE 'NS10%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021832s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NS10%' OR `brand` LIKE 'NS10%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011201s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NS10%' OR `brand` LIKE 'NS10%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005766s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NS10%' OR `brand` LIKE 'NS10%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012407s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NS10%' OR `brand` LIKE 'NS10%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027286s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NS10%' OR `brand` LIKE 'NS10%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.036672s ]