SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002719s ]
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 'SA45%' OR `brand` LIKE 'SA45%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006463s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800502 LIMIT 5 [ RunTime:0.000960s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800502 ORDER BY `minOrder` ASC [ RunTime:0.008821s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800502 ORDER BY `unit` DESC [ RunTime:0.005815s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800502 LIMIT 2 [ RunTime:0.005136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800502 ORDER BY `minOrder` ASC [ RunTime:0.003772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818017 LIMIT 5 [ RunTime:0.000968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818017 ORDER BY `minOrder` ASC [ RunTime:0.001808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818017 ORDER BY `unit` DESC [ RunTime:0.001851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818017 LIMIT 2 [ RunTime:0.001345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818017 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813524 LIMIT 5 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813524 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14813524 ORDER BY `unit` DESC [ RunTime:0.003870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14813524 LIMIT 2 [ RunTime:0.002878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813524 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905577 LIMIT 5 [ RunTime:0.003064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905577 ORDER BY `minOrder` ASC [ RunTime:0.003309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905577 ORDER BY `unit` DESC [ RunTime:0.002963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905577 LIMIT 2 [ RunTime:0.001306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905577 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692864 LIMIT 5 [ RunTime:0.004539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692864 ORDER BY `minOrder` ASC [ RunTime:0.005220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692864 ORDER BY `unit` DESC [ RunTime:0.007320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692864 LIMIT 2 [ RunTime:0.002369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692864 ORDER BY `minOrder` ASC [ RunTime:0.006768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692858 LIMIT 5 [ RunTime:0.000905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692858 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692858 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692858 LIMIT 2 [ RunTime:0.002050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692858 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692782 LIMIT 5 [ RunTime:0.008648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692782 ORDER BY `minOrder` ASC [ RunTime:0.001785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692782 ORDER BY `unit` DESC [ RunTime:0.000493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692782 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692782 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688802 LIMIT 5 [ RunTime:0.003238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688802 ORDER BY `minOrder` ASC [ RunTime:0.006698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688802 ORDER BY `unit` DESC [ RunTime:0.001135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688802 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688802 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688801 LIMIT 5 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688801 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688801 ORDER BY `unit` DESC [ RunTime:0.000776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688801 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688801 ORDER BY `minOrder` ASC [ RunTime:0.001643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688800 LIMIT 5 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688800 ORDER BY `minOrder` ASC [ RunTime:0.000723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688800 ORDER BY `unit` DESC [ RunTime:0.001172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688800 LIMIT 2 [ RunTime:0.002167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688800 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688799 LIMIT 5 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688799 ORDER BY `minOrder` ASC [ RunTime:0.005457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688799 ORDER BY `unit` DESC [ RunTime:0.001479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688799 LIMIT 2 [ RunTime:0.001316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688799 ORDER BY `minOrder` ASC [ RunTime:0.001804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687528 LIMIT 5 [ RunTime:0.001073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687528 ORDER BY `minOrder` ASC [ RunTime:0.001984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687528 ORDER BY `unit` DESC [ RunTime:0.000442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687528 LIMIT 2 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687528 ORDER BY `minOrder` ASC [ RunTime:0.006146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673554 LIMIT 5 [ RunTime:0.003484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673554 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673554 ORDER BY `unit` DESC [ RunTime:0.000306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673554 LIMIT 2 [ RunTime:0.003644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673554 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670872 LIMIT 5 [ RunTime:0.002330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670872 ORDER BY `minOrder` ASC [ RunTime:0.000759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670872 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670872 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670872 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670373 LIMIT 5 [ RunTime:0.000696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670373 ORDER BY `minOrder` ASC [ RunTime:0.001420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670373 ORDER BY `unit` DESC [ RunTime:0.007648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670373 LIMIT 2 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670373 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669408 LIMIT 5 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669408 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669408 ORDER BY `unit` DESC [ RunTime:0.001643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669408 LIMIT 2 [ RunTime:0.014576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669408 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833555 LIMIT 5 [ RunTime:0.001692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833555 ORDER BY `minOrder` ASC [ RunTime:0.009627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833555 ORDER BY `unit` DESC [ RunTime:0.002118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833555 LIMIT 2 [ RunTime:0.001964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833555 ORDER BY `minOrder` ASC [ RunTime:0.006659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833550 LIMIT 5 [ RunTime:0.011139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833550 ORDER BY `minOrder` ASC [ RunTime:0.000605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833550 ORDER BY `unit` DESC [ RunTime:0.004283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833550 LIMIT 2 [ RunTime:0.001514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833550 ORDER BY `minOrder` ASC [ RunTime:0.009571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832035 LIMIT 5 [ RunTime:0.001243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832035 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832035 ORDER BY `unit` DESC [ RunTime:0.011034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832035 LIMIT 2 [ RunTime:0.001329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832035 ORDER BY `minOrder` ASC [ RunTime:0.001279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832034 LIMIT 5 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832034 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832034 ORDER BY `unit` DESC [ RunTime:0.000991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832034 LIMIT 2 [ RunTime:0.003031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832034 ORDER BY `minOrder` ASC [ RunTime:0.003711s ]
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 'SA45%' OR `brand` LIKE 'SA45%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005736s ]
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 'SA45%' OR `brand` LIKE 'SA45%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42146518 LIMIT 5 [ RunTime:0.014888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146518 ORDER BY `minOrder` ASC [ RunTime:0.007487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42146518 ORDER BY `unit` DESC [ RunTime:0.007477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42146518 LIMIT 2 [ RunTime:0.016614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146518 ORDER BY `minOrder` ASC [ RunTime:0.007617s ]
select * from pdf where partno='SA45A' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.011218s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45A' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.004516s ]
SELECT `id` FROM `stock` WHERE `id` <> 42146518 AND `partno` = 'SA45A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.002985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800502 [ RunTime:0.014871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42116494 LIMIT 5 [ RunTime:0.000987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42116494 ORDER BY `minOrder` ASC [ RunTime:0.020299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42116494 ORDER BY `unit` DESC [ RunTime:0.004033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42116494 LIMIT 2 [ RunTime:0.009587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42116494 ORDER BY `minOrder` ASC [ RunTime:0.002599s ]
select * from pdf where partno='SA45CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.025140s ]
SELECT `id` FROM `stock` WHERE `id` <> 42116494 AND `partno` = 'SA45CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.025340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813524 [ RunTime:0.019868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42116034 LIMIT 5 [ RunTime:0.012071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42116034 ORDER BY `minOrder` ASC [ RunTime:0.004503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42116034 ORDER BY `unit` DESC [ RunTime:0.006614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42116034 LIMIT 2 [ RunTime:0.008274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42116034 ORDER BY `minOrder` ASC [ RunTime:0.000726s ]
select * from pdf where partno='SA45A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000791s ]
SELECT `id` FROM `stock` WHERE `id` <> 42116034 AND `partno` = 'SA45A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818017 [ RunTime:0.000676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147644 LIMIT 5 [ RunTime:0.010148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147644 ORDER BY `minOrder` ASC [ RunTime:0.001922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147644 ORDER BY `unit` DESC [ RunTime:0.002819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147644 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147644 ORDER BY `minOrder` ASC [ RunTime:0.001803s ]
select * from pdf where partno='SA45ARL' and brandshort='onsemi' limit 1 [ RunTime:0.001351s ]
select foldpath,foldpath2,filename from pdf_file where id=346491 limit 1 [ RunTime:0.002842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45ARL' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.018358s ]
SELECT `id` FROM `stock` WHERE `id` <> 42147644 AND `partno` = 'SA45ARL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905577 [ RunTime:0.002784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42280719 LIMIT 5 [ RunTime:0.001778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42280719 ORDER BY `minOrder` ASC [ RunTime:0.001174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42280719 ORDER BY `unit` DESC [ RunTime:0.002421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42280719 LIMIT 2 [ RunTime:0.008874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42280719 ORDER BY `minOrder` ASC [ RunTime:0.002245s ]
select * from pdf where partno='SA45CAHE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45CAHE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000899s ]
SELECT `id` FROM `stock` WHERE `id` <> 42280719 AND `partno` = 'SA45CAHE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917013 [ RunTime:0.002184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42280700 LIMIT 5 [ RunTime:0.003653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42280700 ORDER BY `minOrder` ASC [ RunTime:0.007109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42280700 ORDER BY `unit` DESC [ RunTime:0.006610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42280700 LIMIT 2 [ RunTime:0.011285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42280700 ORDER BY `minOrder` ASC [ RunTime:0.006846s ]
select * from pdf where partno='SA45CAHE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45CAHE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006080s ]
SELECT `id` FROM `stock` WHERE `id` <> 42280700 AND `partno` = 'SA45CAHE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42278125 LIMIT 5 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42278125 ORDER BY `minOrder` ASC [ RunTime:0.002995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42278125 ORDER BY `unit` DESC [ RunTime:0.013185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42278125 LIMIT 2 [ RunTime:0.007835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42278125 ORDER BY `minOrder` ASC [ RunTime:0.002411s ]
select * from pdf where partno='SA45CA-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45CA-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011060s ]
SELECT `id` FROM `stock` WHERE `id` <> 42278125 AND `partno` = 'SA45CA-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828526 [ RunTime:0.002629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42276997 LIMIT 5 [ RunTime:0.007862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42276997 ORDER BY `minOrder` ASC [ RunTime:0.005112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42276997 ORDER BY `unit` DESC [ RunTime:0.019501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42276997 LIMIT 2 [ RunTime:0.013375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42276997 ORDER BY `minOrder` ASC [ RunTime:0.001111s ]
select * from pdf where partno='SA45AHE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45AHE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006741s ]
SELECT `id` FROM `stock` WHERE `id` <> 42276997 AND `partno` = 'SA45AHE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.013928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673554 [ RunTime:0.002884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42273895 LIMIT 5 [ RunTime:0.010121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273895 ORDER BY `minOrder` ASC [ RunTime:0.002002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42273895 ORDER BY `unit` DESC [ RunTime:0.006762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42273895 LIMIT 2 [ RunTime:0.001012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273895 ORDER BY `minOrder` ASC [ RunTime:0.008678s ]
select * from pdf where partno='SA45A-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45A-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.026657s ]
SELECT `id` FROM `stock` WHERE `id` <> 42273895 AND `partno` = 'SA45A-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.008963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42272258 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272258 ORDER BY `minOrder` ASC [ RunTime:0.003958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42272258 ORDER BY `unit` DESC [ RunTime:0.008927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42272258 LIMIT 2 [ RunTime:0.002792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272258 ORDER BY `minOrder` ASC [ RunTime:0.005007s ]
select * from pdf where partno='SA45AHE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.010636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45AHE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009579s ]
SELECT `id` FROM `stock` WHERE `id` <> 42272258 AND `partno` = 'SA45AHE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.016319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257308 LIMIT 5 [ RunTime:0.012953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257308 ORDER BY `minOrder` ASC [ RunTime:0.023715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257308 ORDER BY `unit` DESC [ RunTime:0.008110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257308 LIMIT 2 [ RunTime:0.004222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257308 ORDER BY `minOrder` ASC [ RunTime:0.007024s ]
select * from pdf where partno='SA45CA-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.015097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45CA-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007305s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257308 AND `partno` = 'SA45CA-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812896 [ RunTime:0.008493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42243977 LIMIT 5 [ RunTime:0.009538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42243977 ORDER BY `minOrder` ASC [ RunTime:0.004909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42243977 ORDER BY `unit` DESC [ RunTime:0.021096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42243977 LIMIT 2 [ RunTime:0.028206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42243977 ORDER BY `minOrder` ASC [ RunTime:0.002515s ]
select * from pdf where partno='SA45A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011567s ]
SELECT `id` FROM `stock` WHERE `id` <> 42243977 AND `partno` = 'SA45A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670872 [ RunTime:0.004970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222407 LIMIT 5 [ RunTime:0.005933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222407 ORDER BY `minOrder` ASC [ RunTime:0.002714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222407 ORDER BY `unit` DESC [ RunTime:0.007898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222407 LIMIT 2 [ RunTime:0.003148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222407 ORDER BY `minOrder` ASC [ RunTime:0.006414s ]
select * from pdf where partno='SA45CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.011739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.008375s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222407 AND `partno` = 'SA45CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.007147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809904 [ RunTime:0.001070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222406 LIMIT 5 [ RunTime:0.005160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222406 ORDER BY `minOrder` ASC [ RunTime:0.001170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222406 ORDER BY `unit` DESC [ RunTime:0.006266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222406 LIMIT 2 [ RunTime:0.020797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222406 ORDER BY `minOrder` ASC [ RunTime:0.017487s ]
select * from pdf where partno='SA45CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.003172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003348s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222406 AND `partno` = 'SA45CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.021327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809903 [ RunTime:0.009062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222316 LIMIT 5 [ RunTime:0.009059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222316 ORDER BY `minOrder` ASC [ RunTime:0.009703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222316 ORDER BY `unit` DESC [ RunTime:0.007798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222316 LIMIT 2 [ RunTime:0.007229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222316 ORDER BY `minOrder` ASC [ RunTime:0.004753s ]
select * from pdf where partno='SA45CH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.005976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45CH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003694s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222316 AND `partno` = 'SA45CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810456 [ RunTime:0.004432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222255 LIMIT 5 [ RunTime:0.013761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222255 ORDER BY `minOrder` ASC [ RunTime:0.006270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222255 ORDER BY `unit` DESC [ RunTime:0.008962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222255 LIMIT 2 [ RunTime:0.003026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222255 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='SA45C' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.004228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45C' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.005184s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222255 AND `partno` = 'SA45C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.004761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670373 [ RunTime:0.006373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42212242 LIMIT 5 [ RunTime:0.004006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212242 ORDER BY `minOrder` ASC [ RunTime:0.017857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42212242 ORDER BY `unit` DESC [ RunTime:0.005104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42212242 LIMIT 2 [ RunTime:0.001350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212242 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
select * from pdf where partno='SA45AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.004278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.004621s ]
SELECT `id` FROM `stock` WHERE `id` <> 42212242 AND `partno` = 'SA45AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912341 [ RunTime:0.001299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42212241 LIMIT 5 [ RunTime:0.007943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212241 ORDER BY `minOrder` ASC [ RunTime:0.002796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42212241 ORDER BY `unit` DESC [ RunTime:0.006988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42212241 LIMIT 2 [ RunTime:0.000810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212241 ORDER BY `minOrder` ASC [ RunTime:0.001246s ]
select * from pdf where partno='SA45A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000426s ]
SELECT `id` FROM `stock` WHERE `id` <> 42212241 AND `partno` = 'SA45A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912340 [ RunTime:0.000352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42211904 LIMIT 5 [ RunTime:0.005591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42211904 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42211904 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42211904 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42211904 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='SA45H' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.005718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45H' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000964s ]
SELECT `id` FROM `stock` WHERE `id` <> 42211904 AND `partno` = 'SA45H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809394 [ RunTime:0.003028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42211887 LIMIT 5 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42211887 ORDER BY `minOrder` ASC [ RunTime:0.000867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42211887 ORDER BY `unit` DESC [ RunTime:0.002230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42211887 LIMIT 2 [ RunTime:0.005522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42211887 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='SA45' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.003298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA45' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000917s ]
SELECT `id` FROM `stock` WHERE `id` <> 42211887 AND `partno` = 'SA45' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669408 [ RunTime:0.003276s ]
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 'SA45%' OR `brand` LIKE 'SA45%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005417s ]
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 'SA45%' OR `brand` LIKE 'SA45%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002243s ]
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 'SA45%' OR `brand` LIKE 'SA45%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001226s ]
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 'SA45%' OR `brand` LIKE 'SA45%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006242s ]
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 'SA45%' OR `brand` LIKE 'SA45%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002184s ]
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 'SA45%' OR `brand` LIKE 'SA45%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013146s ]
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 'SA45%' OR `brand` LIKE 'SA45%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002653s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SA45%' OR `brand` LIKE 'SA45%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.017488s ]