SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001753s ]
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 'AM2%' OR `brand` LIKE 'AM2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066909s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12231605 LIMIT 5 [ RunTime:0.001161s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12231605 ORDER BY `minOrder` ASC [ RunTime:0.000769s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12231605 ORDER BY `unit` DESC [ RunTime:0.000594s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12231605 LIMIT 2 [ RunTime:0.004247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12231605 ORDER BY `minOrder` ASC [ RunTime:0.006429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12232284 LIMIT 5 [ RunTime:0.009428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12232284 ORDER BY `minOrder` ASC [ RunTime:0.004146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12232284 ORDER BY `unit` DESC [ RunTime:0.000550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12232284 LIMIT 2 [ RunTime:0.009912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12232284 ORDER BY `minOrder` ASC [ RunTime:0.010011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19199406 LIMIT 5 [ RunTime:0.020904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19199406 ORDER BY `minOrder` ASC [ RunTime:0.003016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19199406 ORDER BY `unit` DESC [ RunTime:0.003034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19199406 LIMIT 2 [ RunTime:0.007531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19199406 ORDER BY `minOrder` ASC [ RunTime:0.003921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17068486 LIMIT 5 [ RunTime:0.002325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17068486 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17068486 ORDER BY `unit` DESC [ RunTime:0.003265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17068486 LIMIT 2 [ RunTime:0.007539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17068486 ORDER BY `minOrder` ASC [ RunTime:0.005942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15331455 LIMIT 5 [ RunTime:0.002048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15331455 ORDER BY `minOrder` ASC [ RunTime:0.002394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15331455 ORDER BY `unit` DESC [ RunTime:0.000705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15331455 LIMIT 2 [ RunTime:0.003730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15331455 ORDER BY `minOrder` ASC [ RunTime:0.001974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12233293 LIMIT 5 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12233293 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12233293 ORDER BY `unit` DESC [ RunTime:0.000645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12233293 LIMIT 2 [ RunTime:0.007491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12233293 ORDER BY `minOrder` ASC [ RunTime:0.006026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19061846 LIMIT 5 [ RunTime:0.001788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19061846 ORDER BY `minOrder` ASC [ RunTime:0.000927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19061846 ORDER BY `unit` DESC [ RunTime:0.000650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19061846 LIMIT 2 [ RunTime:0.001989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19061846 ORDER BY `minOrder` ASC [ RunTime:0.001310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17104613 LIMIT 5 [ RunTime:0.000977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17104613 ORDER BY `minOrder` ASC [ RunTime:0.000661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17104613 ORDER BY `unit` DESC [ RunTime:0.000615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17104613 LIMIT 2 [ RunTime:0.001359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17104613 ORDER BY `minOrder` ASC [ RunTime:0.001208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14239212 LIMIT 5 [ RunTime:0.001124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14239212 ORDER BY `minOrder` ASC [ RunTime:0.001342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14239212 ORDER BY `unit` DESC [ RunTime:0.000652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14239212 LIMIT 2 [ RunTime:0.002430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14239212 ORDER BY `minOrder` ASC [ RunTime:0.002236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17068645 LIMIT 5 [ RunTime:0.001027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17068645 ORDER BY `minOrder` ASC [ RunTime:0.001745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17068645 ORDER BY `unit` DESC [ RunTime:0.004490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17068645 LIMIT 2 [ RunTime:0.003639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17068645 ORDER BY `minOrder` ASC [ RunTime:0.002082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16093847 LIMIT 5 [ RunTime:0.004716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16093847 ORDER BY `minOrder` ASC [ RunTime:0.003003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16093847 ORDER BY `unit` DESC [ RunTime:0.006758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16093847 LIMIT 2 [ RunTime:0.004063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16093847 ORDER BY `minOrder` ASC [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11229807 LIMIT 5 [ RunTime:0.001007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11229807 ORDER BY `minOrder` ASC [ RunTime:0.000677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11229807 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11229807 LIMIT 2 [ RunTime:0.005918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11229807 ORDER BY `minOrder` ASC [ RunTime:0.004536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11231317 LIMIT 5 [ RunTime:0.003441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11231317 ORDER BY `minOrder` ASC [ RunTime:0.000679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11231317 ORDER BY `unit` DESC [ RunTime:0.000659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11231317 LIMIT 2 [ RunTime:0.002067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11231317 ORDER BY `minOrder` ASC [ RunTime:0.001172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11229674 LIMIT 5 [ RunTime:0.000950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11229674 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11229674 ORDER BY `unit` DESC [ RunTime:0.000646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11229674 LIMIT 2 [ RunTime:0.001448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11229674 ORDER BY `minOrder` ASC [ RunTime:0.001183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17102898 LIMIT 5 [ RunTime:0.001004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17102898 ORDER BY `minOrder` ASC [ RunTime:0.001629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17102898 ORDER BY `unit` DESC [ RunTime:0.001094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17102898 LIMIT 2 [ RunTime:0.004623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17102898 ORDER BY `minOrder` ASC [ RunTime:0.001814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11230343 LIMIT 5 [ RunTime:0.001252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11230343 ORDER BY `minOrder` ASC [ RunTime:0.003588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11230343 ORDER BY `unit` DESC [ RunTime:0.003714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11230343 LIMIT 2 [ RunTime:0.002757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11230343 ORDER BY `minOrder` ASC [ RunTime:0.006194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19184856 LIMIT 5 [ RunTime:0.010665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19184856 ORDER BY `minOrder` ASC [ RunTime:0.009725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19184856 ORDER BY `unit` DESC [ RunTime:0.002436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19184856 LIMIT 2 [ RunTime:0.009695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19184856 ORDER BY `minOrder` ASC [ RunTime:0.006586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17102641 LIMIT 5 [ RunTime:0.019142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17102641 ORDER BY `minOrder` ASC [ RunTime:0.006409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17102641 ORDER BY `unit` DESC [ RunTime:0.008213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17102641 LIMIT 2 [ RunTime:0.008769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17102641 ORDER BY `minOrder` ASC [ RunTime:0.007277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17270798 LIMIT 5 [ RunTime:0.012654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17270798 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17270798 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17270798 LIMIT 2 [ RunTime:0.003976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17270798 ORDER BY `minOrder` ASC [ RunTime:0.004183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18959574 LIMIT 5 [ RunTime:0.003898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18959574 ORDER BY `minOrder` ASC [ RunTime:0.001993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18959574 ORDER BY `unit` DESC [ RunTime:0.001805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18959574 LIMIT 2 [ RunTime:0.002882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18959574 ORDER BY `minOrder` ASC [ RunTime:0.003545s ]
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 'AM2%' OR `brand` LIKE 'AM2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32231028 LIMIT 5 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32231028 ORDER BY `minOrder` ASC [ RunTime:0.005681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32231028 ORDER BY `unit` DESC [ RunTime:0.000542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32231028 LIMIT 2 [ RunTime:0.001665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32231028 ORDER BY `minOrder` ASC [ RunTime:0.002187s ]
select * from pdf where partno='am2520p3bt03' and brandshort='kingbright' limit 1 [ RunTime:0.002082s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am2520p3bt03' OR `brand` LIKE 'kingbright%' ) ) LIMIT 1 [ RunTime:0.001447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32227636 LIMIT 5 [ RunTime:0.003800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227636 ORDER BY `minOrder` ASC [ RunTime:0.001600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32227636 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32227636 LIMIT 2 [ RunTime:0.001066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227636 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
select * from pdf where partno='am2520zgc09' and brandshort='kingbright' limit 1 [ RunTime:0.004638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am2520zgc09' OR `brand` LIKE 'kingbright%' ) ) LIMIT 1 [ RunTime:0.003535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32226307 LIMIT 5 [ RunTime:0.004506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32226307 ORDER BY `minOrder` ASC [ RunTime:0.006775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32226307 ORDER BY `unit` DESC [ RunTime:0.002605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32226307 LIMIT 2 [ RunTime:0.002210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32226307 ORDER BY `minOrder` ASC [ RunTime:0.001493s ]
select * from pdf where partno='am2520zgc09' and brandshort='kingbright' limit 1 [ RunTime:0.000437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am2520zgc09' OR `brand` LIKE 'kingbright%' ) ) LIMIT 1 [ RunTime:0.000300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32225114 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32225114 ORDER BY `minOrder` ASC [ RunTime:0.002925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32225114 ORDER BY `unit` DESC [ RunTime:0.002850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32225114 LIMIT 2 [ RunTime:0.006360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32225114 ORDER BY `minOrder` ASC [ RunTime:0.003197s ]
select * from pdf where partno='am2520zgc09' and brandshort='kingbright' limit 1 [ RunTime:0.001176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am2520zgc09' OR `brand` LIKE 'kingbright%' ) ) LIMIT 1 [ RunTime:0.005893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32158200 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32158200 ORDER BY `minOrder` ASC [ RunTime:0.006349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32158200 ORDER BY `unit` DESC [ RunTime:0.000770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32158200 LIMIT 2 [ RunTime:0.003600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32158200 ORDER BY `minOrder` ASC [ RunTime:0.001244s ]
select * from pdf where partno='am2520zgc09' and brandshort='kingbright' limit 1 [ RunTime:0.000403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am2520zgc09' OR `brand` LIKE 'kingbright%' ) ) LIMIT 1 [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32234284 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32234284 ORDER BY `minOrder` ASC [ RunTime:0.003151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32234284 ORDER BY `unit` DESC [ RunTime:0.003835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32234284 LIMIT 2 [ RunTime:0.006074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32234284 ORDER BY `minOrder` ASC [ RunTime:0.001474s ]
select * from pdf where partno='am2520f3c03-p22' and brandshort='kingbright' limit 1 [ RunTime:0.003143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am2520f3c03-p22' OR `brand` LIKE 'kingbright%' ) ) LIMIT 1 [ RunTime:0.005170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51059096 LIMIT 5 [ RunTime:0.010841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059096 ORDER BY `minOrder` ASC [ RunTime:0.007389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51059096 ORDER BY `unit` DESC [ RunTime:0.005411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51059096 LIMIT 2 [ RunTime:0.001754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059096 ORDER BY `minOrder` ASC [ RunTime:0.000850s ]
select * from pdf where partno='am26lv32eirgyrg4' and brandshort='texas instruments' limit 1 [ RunTime:0.002332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am26lv32eirgyrg4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.007096s ]
SELECT `id` FROM `stock` WHERE `id` <> 51059096 AND `partno` = 'am26lv32eirgyrg4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.001253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19163341 [ RunTime:0.001038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51058941 LIMIT 5 [ RunTime:0.000958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51058941 ORDER BY `minOrder` ASC [ RunTime:0.001234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51058941 ORDER BY `unit` DESC [ RunTime:0.000724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51058941 LIMIT 2 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51058941 ORDER BY `minOrder` ASC [ RunTime:0.000779s ]
select * from pdf where partno='am26lv32einsr' and brandshort='texas instruments' limit 1 [ RunTime:0.001271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am26lv32einsr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.002097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51059997 LIMIT 5 [ RunTime:0.001506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059997 ORDER BY `minOrder` ASC [ RunTime:0.001186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51059997 ORDER BY `unit` DESC [ RunTime:0.000665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51059997 LIMIT 2 [ RunTime:0.001630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059997 ORDER BY `minOrder` ASC [ RunTime:0.004401s ]
select * from pdf where partno='am26lv31eirgyrg4' and brandshort='texas instruments' limit 1 [ RunTime:0.001114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am26lv31eirgyrg4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.001812s ]
SELECT `id` FROM `stock` WHERE `id` <> 51059997 AND `partno` = 'am26lv31eirgyrg4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.001170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17101630 [ RunTime:0.001034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32242275 LIMIT 5 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32242275 ORDER BY `minOrder` ASC [ RunTime:0.001304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32242275 ORDER BY `unit` DESC [ RunTime:0.001718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32242275 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32242275 ORDER BY `minOrder` ASC [ RunTime:0.000776s ]
select * from pdf where partno='am2520pd1bt03' and brandshort='kingbright' limit 1 [ RunTime:0.001171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am2520pd1bt03' OR `brand` LIKE 'kingbright%' ) ) LIMIT 1 [ RunTime:0.002467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32230334 LIMIT 5 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32230334 ORDER BY `minOrder` ASC [ RunTime:0.001247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32230334 ORDER BY `unit` DESC [ RunTime:0.001147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32230334 LIMIT 2 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32230334 ORDER BY `minOrder` ASC [ RunTime:0.000771s ]
select * from pdf where partno='am2520pd1bt03' and brandshort='kingbright' limit 1 [ RunTime:0.001567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am2520pd1bt03' OR `brand` LIKE 'kingbright%' ) ) LIMIT 1 [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51059048 LIMIT 5 [ RunTime:0.004564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059048 ORDER BY `minOrder` ASC [ RunTime:0.004801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51059048 ORDER BY `unit` DESC [ RunTime:0.001405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51059048 LIMIT 2 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059048 ORDER BY `minOrder` ASC [ RunTime:0.013385s ]
select * from pdf where partno='am26ls32acpwre4' and brandshort='texas instruments' limit 1 [ RunTime:0.007646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am26ls32acpwre4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.001487s ]
SELECT `id` FROM `stock` WHERE `id` <> 51059048 AND `partno` = 'am26ls32acpwre4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.007217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51059095 LIMIT 5 [ RunTime:0.006501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059095 ORDER BY `minOrder` ASC [ RunTime:0.005702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51059095 ORDER BY `unit` DESC [ RunTime:0.003491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51059095 LIMIT 2 [ RunTime:0.005756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059095 ORDER BY `minOrder` ASC [ RunTime:0.049992s ]
select * from pdf where partno='am26ls32acnsrg4' and brandshort='texas instruments' limit 1 [ RunTime:0.033512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am26ls32acnsrg4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.011472s ]
SELECT `id` FROM `stock` WHERE `id` <> 51059095 AND `partno` = 'am26ls32acnsrg4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.016327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16087580 [ RunTime:0.041285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51058992 LIMIT 5 [ RunTime:0.013363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51058992 ORDER BY `minOrder` ASC [ RunTime:0.046481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51058992 ORDER BY `unit` DESC [ RunTime:0.011099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51058992 LIMIT 2 [ RunTime:0.052692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51058992 ORDER BY `minOrder` ASC [ RunTime:0.050803s ]
select * from pdf where partno='am26ls32aidrg4' and brandshort='texas instruments' limit 1 [ RunTime:0.043282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am26ls32aidrg4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.072368s ]
SELECT `id` FROM `stock` WHERE `id` <> 51058992 AND `partno` = 'am26ls32aidrg4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.098691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19170513 [ RunTime:0.028856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32233505 LIMIT 5 [ RunTime:0.000815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32233505 ORDER BY `minOrder` ASC [ RunTime:0.004303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32233505 ORDER BY `unit` DESC [ RunTime:0.000726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32233505 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32233505 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
select * from pdf where partno='am2520sf4c09' and brandshort='kingbright' limit 1 [ RunTime:0.001092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am2520sf4c09' OR `brand` LIKE 'kingbright%' ) ) LIMIT 1 [ RunTime:0.005720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51058940 LIMIT 5 [ RunTime:0.000784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51058940 ORDER BY `minOrder` ASC [ RunTime:0.000786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51058940 ORDER BY `unit` DESC [ RunTime:0.001044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51058940 LIMIT 2 [ RunTime:0.000772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51058940 ORDER BY `minOrder` ASC [ RunTime:0.000755s ]
select * from pdf where partno='am26c32insr' and brandshort='texas instruments' limit 1 [ RunTime:0.003488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am26c32insr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.012510s ]
SELECT `id` FROM `stock` WHERE `id` <> 51058940 AND `partno` = 'am26c32insr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.003602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17102500 [ RunTime:0.001263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32152207 LIMIT 5 [ RunTime:0.000770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32152207 ORDER BY `minOrder` ASC [ RunTime:0.001377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32152207 ORDER BY `unit` DESC [ RunTime:0.000522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32152207 LIMIT 2 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32152207 ORDER BY `minOrder` ASC [ RunTime:0.000716s ]
select * from pdf where partno='am26ls31cdbr' and brandshort='texas instruments' limit 1 [ RunTime:0.003609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am26ls31cdbr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.005597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51058991 LIMIT 5 [ RunTime:0.003503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51058991 ORDER BY `minOrder` ASC [ RunTime:0.001056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51058991 ORDER BY `unit` DESC [ RunTime:0.000261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51058991 LIMIT 2 [ RunTime:0.002150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51058991 ORDER BY `minOrder` ASC [ RunTime:0.000713s ]
select * from pdf where partno='am26c31qdrg4' and brandshort='texas instruments' limit 1 [ RunTime:0.000529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am26c31qdrg4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.000986s ]
SELECT `id` FROM `stock` WHERE `id` <> 51058991 AND `partno` = 'am26c31qdrg4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.002576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15322514 [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51059806 LIMIT 5 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059806 ORDER BY `minOrder` ASC [ RunTime:0.002220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51059806 ORDER BY `unit` DESC [ RunTime:0.000577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51059806 LIMIT 2 [ RunTime:0.000853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51059806 ORDER BY `minOrder` ASC [ RunTime:0.001505s ]
select * from pdf where partno='am26ls32acdre4' and brandshort='texas instruments' limit 1 [ RunTime:0.003013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am26ls32acdre4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.001347s ]
SELECT `id` FROM `stock` WHERE `id` <> 51059806 AND `partno` = 'am26ls32acdre4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.001104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51066575 LIMIT 5 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51066575 ORDER BY `minOrder` ASC [ RunTime:0.002205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51066575 ORDER BY `unit` DESC [ RunTime:0.001499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51066575 LIMIT 2 [ RunTime:0.002544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51066575 ORDER BY `minOrder` ASC [ RunTime:0.001138s ]
select * from pdf where partno='am2520eh/sgd' and brandshort='kingbright' limit 1 [ RunTime:0.004009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'am2520eh/sgd' OR `brand` LIKE 'kingbright%' ) ) LIMIT 1 [ RunTime:0.001485s ]
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 'AM2%' OR `brand` LIKE 'AM2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41337656 LIMIT 5 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41337656 ORDER BY `minOrder` ASC [ RunTime:0.001691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41337656 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41337656 LIMIT 2 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41337656 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
select * from pdf where partno='AM2520SURCK03' and brandshort='Kingbright' limit 1 [ RunTime:0.000862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM2520SURCK03' OR `brand` LIKE 'Kingbright%' ) ) LIMIT 1 [ RunTime:0.001486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41337910 LIMIT 5 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41337910 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41337910 ORDER BY `unit` DESC [ RunTime:0.000328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41337910 LIMIT 2 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41337910 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='AM2520ZGC09' and brandshort='Kingbright' limit 1 [ RunTime:0.004782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM2520ZGC09' OR `brand` LIKE 'Kingbright%' ) ) LIMIT 1 [ RunTime:0.004088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44062911 LIMIT 5 [ RunTime:0.001055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44062911 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44062911 ORDER BY `unit` DESC [ RunTime:0.000366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44062911 LIMIT 2 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44062911 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='AM23A0N' and brandshort='Analog Power Inc.' limit 1 [ RunTime:0.001252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM23A0N' OR `brand` LIKE 'Analog Power Inc.%' ) ) LIMIT 1 [ RunTime:0.001929s ]
SELECT `id` FROM `stock` WHERE `id` <> 44062911 AND `partno` = 'AM23A0N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog power inc.%' ) [ RunTime:0.000864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57013270 LIMIT 5 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57013270 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57013270 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57013270 LIMIT 2 [ RunTime:0.001897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57013270 ORDER BY `minOrder` ASC [ RunTime:0.000951s ]
select * from pdf where partno='AM29C818ASC' and brandshort='Advanced Micro Devices' limit 1 [ RunTime:0.007139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM29C818ASC' OR `brand` LIKE 'Advanced Micro Devices%' ) ) LIMIT 1 [ RunTime:0.004073s ]
SELECT `id` FROM `stock` WHERE `id` <> 57013270 AND `partno` = 'AM29C818ASC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%advanced micro devices%' ) [ RunTime:0.002923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19199406 [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41337779 LIMIT 5 [ RunTime:0.001397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41337779 ORDER BY `minOrder` ASC [ RunTime:0.001314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41337779 ORDER BY `unit` DESC [ RunTime:0.000334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41337779 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41337779 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='AM2520SECK09' and brandshort='Kingbright' limit 1 [ RunTime:0.000881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM2520SECK09' OR `brand` LIKE 'Kingbright%' ) ) LIMIT 1 [ RunTime:0.001615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57161420 LIMIT 5 [ RunTime:0.000952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57161420 ORDER BY `minOrder` ASC [ RunTime:0.000813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57161420 ORDER BY `unit` DESC [ RunTime:0.000675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57161420 LIMIT 2 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57161420 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='AM29LV116DT-90EI' and brandshort='Advanced Micro Devices' limit 1 [ RunTime:0.001711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM29LV116DT-90EI' OR `brand` LIKE 'Advanced Micro Devices%' ) ) LIMIT 1 [ RunTime:0.001804s ]
SELECT `id` FROM `stock` WHERE `id` <> 57161420 AND `partno` = 'AM29LV116DT-90EI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%advanced micro devices%' ) [ RunTime:0.001144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17068486 [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41337780 LIMIT 5 [ RunTime:0.001605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41337780 ORDER BY `minOrder` ASC [ RunTime:0.001010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41337780 ORDER BY `unit` DESC [ RunTime:0.000365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41337780 LIMIT 2 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41337780 ORDER BY `minOrder` ASC [ RunTime:0.003956s ]
select * from pdf where partno='AM2520EC09' and brandshort='Kingbright' limit 1 [ RunTime:0.000936s ]
select foldpath,foldpath2,filename from pdf_file where id=593326 limit 1 [ RunTime:0.001438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM2520EC09' OR `brand` LIKE 'Kingbright%' ) ) LIMIT 1 [ RunTime:0.001222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44056612 LIMIT 5 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44056612 ORDER BY `minOrder` ASC [ RunTime:0.002248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44056612 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44056612 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44056612 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='AM2324N' and brandshort='Analog Power Inc.' limit 1 [ RunTime:0.000688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM2324N' OR `brand` LIKE 'Analog Power Inc.%' ) ) LIMIT 1 [ RunTime:0.001891s ]
SELECT `id` FROM `stock` WHERE `id` <> 44056612 AND `partno` = 'AM2324N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog power inc.%' ) [ RunTime:0.003882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57013251 LIMIT 5 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57013251 ORDER BY `minOrder` ASC [ RunTime:0.001059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57013251 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57013251 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57013251 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
select * from pdf where partno='AM29C823ASC' and brandshort='Advanced Micro Devices' limit 1 [ RunTime:0.000798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM29C823ASC' OR `brand` LIKE 'Advanced Micro Devices%' ) ) LIMIT 1 [ RunTime:0.001835s ]
SELECT `id` FROM `stock` WHERE `id` <> 57013251 AND `partno` = 'AM29C823ASC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%advanced micro devices%' ) [ RunTime:0.001126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15331455 [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41340477 LIMIT 5 [ RunTime:0.001750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340477 ORDER BY `minOrder` ASC [ RunTime:0.001424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41340477 ORDER BY `unit` DESC [ RunTime:0.000568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41340477 LIMIT 2 [ RunTime:0.001012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340477 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='AM2520ZGCK09' and brandshort='Kingbright' limit 1 [ RunTime:0.001449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM2520ZGCK09' OR `brand` LIKE 'Kingbright%' ) ) LIMIT 1 [ RunTime:0.001559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56999092 LIMIT 5 [ RunTime:0.001303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56999092 ORDER BY `minOrder` ASC [ RunTime:0.001407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56999092 ORDER BY `unit` DESC [ RunTime:0.001176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56999092 LIMIT 2 [ RunTime:0.000856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56999092 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
select * from pdf where partno='AM26LV32EIPWR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM26LV32EIPWR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.002395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57059388 LIMIT 5 [ RunTime:0.001395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57059388 ORDER BY `minOrder` ASC [ RunTime:0.000829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57059388 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57059388 LIMIT 2 [ RunTime:0.002888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57059388 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
select * from pdf where partno='AM29C668JC' and brandshort='Advanced Micro Devices' limit 1 [ RunTime:0.005085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM29C668JC' OR `brand` LIKE 'Advanced Micro Devices%' ) ) LIMIT 1 [ RunTime:0.002402s ]
SELECT `id` FROM `stock` WHERE `id` <> 57059388 AND `partno` = 'AM29C668JC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%advanced micro devices%' ) [ RunTime:0.001587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19061846 [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41340480 LIMIT 5 [ RunTime:0.004323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340480 ORDER BY `minOrder` ASC [ RunTime:0.001300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41340480 ORDER BY `unit` DESC [ RunTime:0.000389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41340480 LIMIT 2 [ RunTime:0.001081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340480 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
select * from pdf where partno='AM2520SYCK09' and brandshort='Kingbright' limit 1 [ RunTime:0.001292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM2520SYCK09' OR `brand` LIKE 'Kingbright%' ) ) LIMIT 1 [ RunTime:0.001681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56998937 LIMIT 5 [ RunTime:0.001339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56998937 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56998937 ORDER BY `unit` DESC [ RunTime:0.000349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56998937 LIMIT 2 [ RunTime:0.000786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56998937 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='AM26C31IDR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.002998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM26C31IDR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.003059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58111317 LIMIT 5 [ RunTime:0.001332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58111317 ORDER BY `minOrder` ASC [ RunTime:0.003230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58111317 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58111317 LIMIT 2 [ RunTime:0.000770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58111317 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='AM2520F3C03-P22' and brandshort='Kingbright' limit 1 [ RunTime:0.000928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM2520F3C03-P22' OR `brand` LIKE 'Kingbright%' ) ) LIMIT 1 [ RunTime:0.001467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57154853 LIMIT 5 [ RunTime:0.001074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57154853 ORDER BY `minOrder` ASC [ RunTime:0.000874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57154853 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57154853 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57154853 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='AM25LS2521PC' and brandshort='Advanced Micro Devices' limit 1 [ RunTime:0.001574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM25LS2521PC' OR `brand` LIKE 'Advanced Micro Devices%' ) ) LIMIT 1 [ RunTime:0.002373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41337744 LIMIT 5 [ RunTime:0.001318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41337744 ORDER BY `minOrder` ASC [ RunTime:0.000666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41337744 ORDER BY `unit` DESC [ RunTime:0.000388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41337744 LIMIT 2 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41337744 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
select * from pdf where partno='AM23SURTK-C2' and brandshort='Kingbright' limit 1 [ RunTime:0.001265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM23SURTK-C2' OR `brand` LIKE 'Kingbright%' ) ) LIMIT 1 [ RunTime:0.001970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44056844 LIMIT 5 [ RunTime:0.008809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44056844 ORDER BY `minOrder` ASC [ RunTime:0.003493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44056844 ORDER BY `unit` DESC [ RunTime:0.000685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44056844 LIMIT 2 [ RunTime:0.001087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44056844 ORDER BY `minOrder` ASC [ RunTime:0.001130s ]
select * from pdf where partno='AM2337P' and brandshort='Analog Power Inc.' limit 1 [ RunTime:0.001703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM2337P' OR `brand` LIKE 'Analog Power Inc.%' ) ) LIMIT 1 [ RunTime:0.004741s ]
SELECT `id` FROM `stock` WHERE `id` <> 44056844 AND `partno` = 'AM2337P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog power inc.%' ) [ RunTime:0.003314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41340685 LIMIT 5 [ RunTime:0.001515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340685 ORDER BY `minOrder` ASC [ RunTime:0.001699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41340685 ORDER BY `unit` DESC [ RunTime:0.000754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41340685 LIMIT 2 [ RunTime:0.006976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340685 ORDER BY `minOrder` ASC [ RunTime:0.001252s ]
select * from pdf where partno='AM27MGC09' and brandshort='Kingbright' limit 1 [ RunTime:0.007207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM27MGC09' OR `brand` LIKE 'Kingbright%' ) ) LIMIT 1 [ RunTime:0.002033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41340719 LIMIT 5 [ RunTime:0.001746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340719 ORDER BY `minOrder` ASC [ RunTime:0.001375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41340719 ORDER BY `unit` DESC [ RunTime:0.002645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41340719 LIMIT 2 [ RunTime:0.001184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41340719 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
select * from pdf where partno='AM2520QBC/D09' and brandshort='Kingbright' limit 1 [ RunTime:0.002176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AM2520QBC/D09' OR `brand` LIKE 'Kingbright%' ) ) LIMIT 1 [ RunTime:0.003065s ]
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 'AM2%' OR `brand` LIKE 'AM2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004863s ]
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 'AM2%' OR `brand` LIKE 'AM2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001982s ]
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 'AM2%' OR `brand` LIKE 'AM2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001451s ]
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 'AM2%' OR `brand` LIKE 'AM2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001414s ]
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 'AM2%' OR `brand` LIKE 'AM2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003549s ]
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 'AM2%' OR `brand` LIKE 'AM2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003324s ]
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 'AM2%' OR `brand` LIKE 'AM2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001786s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'AM2%' OR `brand` LIKE 'AM2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014609s ]