SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001477s ]
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 '977%' OR `brand` LIKE '977%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036040s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313799 LIMIT 5 [ RunTime:0.018183s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313799 ORDER BY `minOrder` ASC [ RunTime:0.019465s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313799 ORDER BY `unit` DESC [ RunTime:0.005751s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313799 LIMIT 2 [ RunTime:0.002075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313799 ORDER BY `minOrder` ASC [ RunTime:0.009351s ]
select * from pdf where partno='9774030243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.030545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313816 LIMIT 5 [ RunTime:0.042059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313816 ORDER BY `minOrder` ASC [ RunTime:0.042268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313816 ORDER BY `unit` DESC [ RunTime:0.031414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313816 LIMIT 2 [ RunTime:0.045617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313816 ORDER BY `minOrder` ASC [ RunTime:0.002447s ]
select * from pdf where partno='9774015243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.017274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313814 LIMIT 5 [ RunTime:0.025131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313814 ORDER BY `minOrder` ASC [ RunTime:0.054619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313814 ORDER BY `unit` DESC [ RunTime:0.013996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313814 LIMIT 2 [ RunTime:0.036220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313814 ORDER BY `minOrder` ASC [ RunTime:0.020912s ]
select * from pdf where partno='9774015151R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.011709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315192 LIMIT 5 [ RunTime:0.016760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315192 ORDER BY `minOrder` ASC [ RunTime:0.013378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315192 ORDER BY `unit` DESC [ RunTime:0.020105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315192 LIMIT 2 [ RunTime:0.011587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315192 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='9774050360R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313815 LIMIT 5 [ RunTime:0.010271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313815 ORDER BY `minOrder` ASC [ RunTime:0.009150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313815 ORDER BY `unit` DESC [ RunTime:0.006491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313815 LIMIT 2 [ RunTime:0.004904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313815 ORDER BY `minOrder` ASC [ RunTime:0.014922s ]
select * from pdf where partno='9774025243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313817 LIMIT 5 [ RunTime:0.006789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313817 ORDER BY `minOrder` ASC [ RunTime:0.016379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313817 ORDER BY `unit` DESC [ RunTime:0.011631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313817 LIMIT 2 [ RunTime:0.006052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313817 ORDER BY `minOrder` ASC [ RunTime:0.003531s ]
select * from pdf where partno='9774010243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313800 LIMIT 5 [ RunTime:0.002751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313800 ORDER BY `minOrder` ASC [ RunTime:0.003237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313800 ORDER BY `unit` DESC [ RunTime:0.002590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313800 LIMIT 2 [ RunTime:0.005978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313800 ORDER BY `minOrder` ASC [ RunTime:0.009057s ]
select * from pdf where partno='9774040151R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.010013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313801 LIMIT 5 [ RunTime:0.005569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313801 ORDER BY `minOrder` ASC [ RunTime:0.011506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313801 ORDER BY `unit` DESC [ RunTime:0.015877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313801 LIMIT 2 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313801 ORDER BY `minOrder` ASC [ RunTime:0.011153s ]
select * from pdf where partno='9774030151R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313802 LIMIT 5 [ RunTime:0.001111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313802 ORDER BY `minOrder` ASC [ RunTime:0.003473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313802 ORDER BY `unit` DESC [ RunTime:0.004507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313802 LIMIT 2 [ RunTime:0.002920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313802 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
select * from pdf where partno='9774060243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.011036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039802 LIMIT 5 [ RunTime:0.002426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039802 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039802 ORDER BY `unit` DESC [ RunTime:0.000404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039802 LIMIT 2 [ RunTime:0.009696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039802 ORDER BY `minOrder` ASC [ RunTime:0.001523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039806 LIMIT 5 [ RunTime:0.008853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039806 ORDER BY `minOrder` ASC [ RunTime:0.012773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039806 ORDER BY `unit` DESC [ RunTime:0.002624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039806 LIMIT 2 [ RunTime:0.005892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039806 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='9774050151R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313803 LIMIT 5 [ RunTime:0.004805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313803 ORDER BY `minOrder` ASC [ RunTime:0.004974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313803 ORDER BY `unit` DESC [ RunTime:0.002478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313803 LIMIT 2 [ RunTime:0.001632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313803 ORDER BY `minOrder` ASC [ RunTime:0.000658s ]
select * from pdf where partno='9774100151R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313818 LIMIT 5 [ RunTime:0.000779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313818 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313818 ORDER BY `unit` DESC [ RunTime:0.009840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313818 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313818 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
select * from pdf where partno='9774020243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039792 LIMIT 5 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039792 ORDER BY `minOrder` ASC [ RunTime:0.006681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039792 ORDER BY `unit` DESC [ RunTime:0.002474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039792 LIMIT 2 [ RunTime:0.013993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039792 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
select * from pdf where partno='9774050951R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313804 LIMIT 5 [ RunTime:0.011863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313804 ORDER BY `minOrder` ASC [ RunTime:0.004724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313804 ORDER BY `unit` DESC [ RunTime:0.002625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313804 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313804 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
select * from pdf where partno='9774050243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313805 LIMIT 5 [ RunTime:0.001790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313805 ORDER BY `minOrder` ASC [ RunTime:0.000992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313805 ORDER BY `unit` DESC [ RunTime:0.000362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313805 LIMIT 2 [ RunTime:0.000300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313805 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
select * from pdf where partno='9774080151R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315193 LIMIT 5 [ RunTime:0.001158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315193 ORDER BY `minOrder` ASC [ RunTime:0.002390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315193 ORDER BY `unit` DESC [ RunTime:0.005651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315193 LIMIT 2 [ RunTime:0.004761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315193 ORDER BY `minOrder` ASC [ RunTime:0.006544s ]
select * from pdf where partno='9774110360R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039788 LIMIT 5 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039788 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039788 ORDER BY `unit` DESC [ RunTime:0.000546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039788 LIMIT 2 [ RunTime:0.005969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039788 ORDER BY `minOrder` ASC [ RunTime:0.000722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039807 LIMIT 5 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039807 ORDER BY `minOrder` ASC [ RunTime:0.008518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039807 ORDER BY `unit` DESC [ RunTime:0.008025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039807 LIMIT 2 [ RunTime:0.002937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039807 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='9774060151R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313807 LIMIT 5 [ RunTime:0.001241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313807 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313807 ORDER BY `unit` DESC [ RunTime:0.011433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313807 LIMIT 2 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313807 ORDER BY `minOrder` ASC [ RunTime:0.002847s ]
select * from pdf where partno='9774030951R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002085s ]
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 '977%' OR `brand` LIKE '977%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32214893 LIMIT 5 [ RunTime:0.014885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214893 ORDER BY `minOrder` ASC [ RunTime:0.014163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32214893 ORDER BY `unit` DESC [ RunTime:0.009937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32214893 LIMIT 2 [ RunTime:0.016561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214893 ORDER BY `minOrder` ASC [ RunTime:0.002945s ]
select * from pdf where partno='9775041360r' and brandshort='wurth elektronik' limit 1 [ RunTime:0.004021s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9775041360r' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.007509s ]
SELECT `id` FROM `stock` WHERE `id` <> 32214893 AND `partno` = '9775041360r' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.002032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308873 [ RunTime:0.001566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32214988 LIMIT 5 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214988 ORDER BY `minOrder` ASC [ RunTime:0.000831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32214988 ORDER BY `unit` DESC [ RunTime:0.006679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32214988 LIMIT 2 [ RunTime:0.002122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214988 ORDER BY `minOrder` ASC [ RunTime:0.002132s ]
select * from pdf where partno='9775086360r' and brandshort='wurth elektronik' limit 1 [ RunTime:0.001549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9775086360r' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.000490s ]
SELECT `id` FROM `stock` WHERE `id` <> 32214988 AND `partno` = '9775086360r' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.000754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13309421 [ RunTime:0.002963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32214735 LIMIT 5 [ RunTime:0.002766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214735 ORDER BY `minOrder` ASC [ RunTime:0.013376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32214735 ORDER BY `unit` DESC [ RunTime:0.002047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32214735 LIMIT 2 [ RunTime:0.002596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214735 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
select * from pdf where partno='9771050360r' and brandshort='wurth elektronik' limit 1 [ RunTime:0.001093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9771050360r' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.006431s ]
SELECT `id` FROM `stock` WHERE `id` <> 32214735 AND `partno` = '9771050360r' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.015223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13309985 [ RunTime:0.004545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32214818 LIMIT 5 [ RunTime:0.003605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214818 ORDER BY `minOrder` ASC [ RunTime:0.002611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32214818 ORDER BY `unit` DESC [ RunTime:0.000968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32214818 LIMIT 2 [ RunTime:0.008157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214818 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='9775026960r' and brandshort='wurth elektronik' limit 1 [ RunTime:0.002078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9775026960r' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.000542s ]
SELECT `id` FROM `stock` WHERE `id` <> 32214818 AND `partno` = '9775026960r' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.001243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12035883 [ RunTime:0.004869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32214736 LIMIT 5 [ RunTime:0.005356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214736 ORDER BY `minOrder` ASC [ RunTime:0.001048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32214736 ORDER BY `unit` DESC [ RunTime:0.004878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32214736 LIMIT 2 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214736 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='9776030960r' and brandshort='wurth elektronik' limit 1 [ RunTime:0.000563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9776030960r' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.005056s ]
SELECT `id` FROM `stock` WHERE `id` <> 32214736 AND `partno` = '9776030960r' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.002927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63403931 [ RunTime:0.001446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098557 LIMIT 5 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098557 ORDER BY `minOrder` ASC [ RunTime:0.003723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098557 ORDER BY `unit` DESC [ RunTime:0.001869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098557 LIMIT 2 [ RunTime:0.009184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098557 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='9772-30 25mm x 10m' and brandshort='3m' limit 1 [ RunTime:0.003894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9772-30 25mm x 10m' OR `brand` LIKE '3m%' ) ) LIMIT 1 [ RunTime:0.025274s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098557 AND `partno` = '9772-30 25mm x 10m' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.010682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32187834 LIMIT 5 [ RunTime:0.009242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32187834 ORDER BY `minOrder` ASC [ RunTime:0.003248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32187834 ORDER BY `unit` DESC [ RunTime:0.000255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32187834 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32187834 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
select * from pdf where partno='977' and brandshort='adafruit' limit 1 [ RunTime:0.000492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '977' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.000290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098558 LIMIT 5 [ RunTime:0.000817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098558 ORDER BY `minOrder` ASC [ RunTime:0.011960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098558 ORDER BY `unit` DESC [ RunTime:0.014676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098558 LIMIT 2 [ RunTime:0.000915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098558 ORDER BY `minOrder` ASC [ RunTime:0.000232s ]
select * from pdf where partno='9772-50 100mm x 10m' and brandshort='3m' limit 1 [ RunTime:0.000961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9772-50 100mm x 10m' OR `brand` LIKE '3m%' ) ) LIMIT 1 [ RunTime:0.005547s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098558 AND `partno` = '9772-50 100mm x 10m' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098588 LIMIT 5 [ RunTime:0.002923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098588 ORDER BY `minOrder` ASC [ RunTime:0.005849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098588 ORDER BY `unit` DESC [ RunTime:0.004024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098588 LIMIT 2 [ RunTime:0.011653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098588 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='9772-30 100mm x 10m' and brandshort='3m' limit 1 [ RunTime:0.009745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9772-30 100mm x 10m' OR `brand` LIKE '3m%' ) ) LIMIT 1 [ RunTime:0.007064s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098588 AND `partno` = '9772-30 100mm x 10m' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.016661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137544 LIMIT 5 [ RunTime:0.004066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137544 ORDER BY `minOrder` ASC [ RunTime:0.007602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137544 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137544 LIMIT 2 [ RunTime:0.002531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137544 ORDER BY `minOrder` ASC [ RunTime:0.012932s ]
select * from pdf where partno='9773 060100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.021820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9773 060100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.003559s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137544 AND `partno` = '9773 060100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.012858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137543 LIMIT 5 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137543 ORDER BY `minOrder` ASC [ RunTime:0.000729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137543 ORDER BY `unit` DESC [ RunTime:0.006956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137543 LIMIT 2 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137543 ORDER BY `minOrder` ASC [ RunTime:0.003635s ]
select * from pdf where partno='9770 001500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9770 001500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.002563s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137543 AND `partno` = '9770 001500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.002200s ]
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 '977%' OR `brand` LIKE '977%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389940 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389940 ORDER BY `minOrder` ASC [ RunTime:0.011133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389940 ORDER BY `unit` DESC [ RunTime:0.003135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389940 LIMIT 2 [ RunTime:0.002510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389940 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='9774025243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774025243R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000612s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389940 AND `partno` = '9774025243R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313815 [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389941 LIMIT 5 [ RunTime:0.006552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389941 ORDER BY `minOrder` ASC [ RunTime:0.006586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389941 ORDER BY `unit` DESC [ RunTime:0.000904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389941 LIMIT 2 [ RunTime:0.001963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389941 ORDER BY `minOrder` ASC [ RunTime:0.003988s ]
select * from pdf where partno='9774015151R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000454s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774015151R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004088s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389941 AND `partno` = '9774015151R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.002837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7788 [ RunTime:0.002606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313814 [ RunTime:0.001387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389942 LIMIT 5 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389942 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389942 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389942 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389942 ORDER BY `minOrder` ASC [ RunTime:0.002327s ]
select * from pdf where partno='9774050960R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774050960R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000716s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389942 AND `partno` = '9774050960R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313819 [ RunTime:0.002593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389906 LIMIT 5 [ RunTime:0.001489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389906 ORDER BY `minOrder` ASC [ RunTime:0.000980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389906 ORDER BY `unit` DESC [ RunTime:0.000518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389906 LIMIT 2 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389906 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='9774030243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774030243R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000540s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389906 AND `partno` = '9774030243R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.002232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7789 [ RunTime:0.006198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313799 [ RunTime:0.007949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389907 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389907 ORDER BY `minOrder` ASC [ RunTime:0.012772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389907 ORDER BY `unit` DESC [ RunTime:0.000715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389907 LIMIT 2 [ RunTime:0.001545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389907 ORDER BY `minOrder` ASC [ RunTime:0.005824s ]
select * from pdf where partno='9774040243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774040243R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004938s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389907 AND `partno` = '9774040243R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.014468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7790 [ RunTime:0.005745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313809 [ RunTime:0.002729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389982 LIMIT 5 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389982 ORDER BY `minOrder` ASC [ RunTime:0.001036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389982 ORDER BY `unit` DESC [ RunTime:0.003272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389982 LIMIT 2 [ RunTime:0.004531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389982 ORDER BY `minOrder` ASC [ RunTime:0.016124s ]
select * from pdf where partno='9774080360R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.010111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774080360R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003830s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389982 AND `partno` = '9774080360R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.024879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315196 [ RunTime:0.016304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389957 LIMIT 5 [ RunTime:0.006703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389957 ORDER BY `minOrder` ASC [ RunTime:0.019450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389957 ORDER BY `unit` DESC [ RunTime:0.007891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389957 LIMIT 2 [ RunTime:0.026891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389957 ORDER BY `minOrder` ASC [ RunTime:0.006173s ]
select * from pdf where partno='9774025151R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774025151R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.008538s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389957 AND `partno` = '9774025151R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.010950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389908 LIMIT 5 [ RunTime:0.003439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389908 ORDER BY `minOrder` ASC [ RunTime:0.007616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389908 ORDER BY `unit` DESC [ RunTime:0.012784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389908 LIMIT 2 [ RunTime:0.011723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389908 ORDER BY `minOrder` ASC [ RunTime:0.012068s ]
select * from pdf where partno='9774060243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.005050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774060243R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.010545s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389908 AND `partno` = '9774060243R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.005859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313802 [ RunTime:0.000765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63363601 LIMIT 5 [ RunTime:0.001547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63363601 ORDER BY `minOrder` ASC [ RunTime:0.012252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63363601 ORDER BY `unit` DESC [ RunTime:0.002059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63363601 LIMIT 2 [ RunTime:0.003003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63363601 ORDER BY `minOrder` ASC [ RunTime:0.007250s ]
select * from pdf where partno='97790603111' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.009057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97790603111' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002409s ]
SELECT `id` FROM `stock` WHERE `id` <> 63363601 AND `partno` = '97790603111' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389983 LIMIT 5 [ RunTime:0.006458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389983 ORDER BY `minOrder` ASC [ RunTime:0.014351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389983 ORDER BY `unit` DESC [ RunTime:0.008776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389983 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389983 ORDER BY `minOrder` ASC [ RunTime:0.002855s ]
select * from pdf where partno='9774030360R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774030360R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001996s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389983 AND `partno` = '9774030360R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.010576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13317913 [ RunTime:0.004268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389894 LIMIT 5 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389894 ORDER BY `minOrder` ASC [ RunTime:0.009229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389894 ORDER BY `unit` DESC [ RunTime:0.013049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389894 LIMIT 2 [ RunTime:0.006580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389894 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='9774005243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774005243R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.014208s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389894 AND `partno` = '9774005243R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.011243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039788 [ RunTime:0.019600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389984 LIMIT 5 [ RunTime:0.005126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389984 ORDER BY `minOrder` ASC [ RunTime:0.006593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389984 ORDER BY `unit` DESC [ RunTime:0.002827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389984 LIMIT 2 [ RunTime:0.002708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389984 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
select * from pdf where partno='9774120360R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774120360R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002210s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389984 AND `partno` = '9774120360R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.010557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315197 [ RunTime:0.002827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63390008 LIMIT 5 [ RunTime:0.014384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390008 ORDER BY `minOrder` ASC [ RunTime:0.002273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63390008 ORDER BY `unit` DESC [ RunTime:0.004570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63390008 LIMIT 2 [ RunTime:0.008516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390008 ORDER BY `minOrder` ASC [ RunTime:0.014725s ]
select * from pdf where partno='9774120960R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774120960R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.007354s ]
SELECT `id` FROM `stock` WHERE `id` <> 63390008 AND `partno` = '9774120960R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315205 [ RunTime:0.004687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389909 LIMIT 5 [ RunTime:0.019237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389909 ORDER BY `minOrder` ASC [ RunTime:0.023508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389909 ORDER BY `unit` DESC [ RunTime:0.008322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389909 LIMIT 2 [ RunTime:0.002460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389909 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='9774080151R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774080151R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.009859s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389909 AND `partno` = '9774080151R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.005768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313805 [ RunTime:0.000717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389985 LIMIT 5 [ RunTime:0.009896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389985 ORDER BY `minOrder` ASC [ RunTime:0.016660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389985 ORDER BY `unit` DESC [ RunTime:0.004997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389985 LIMIT 2 [ RunTime:0.016470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389985 ORDER BY `minOrder` ASC [ RunTime:0.004446s ]
select * from pdf where partno='9774050360R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774050360R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000849s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389985 AND `partno` = '9774050360R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315192 [ RunTime:0.005743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389986 LIMIT 5 [ RunTime:0.009166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389986 ORDER BY `minOrder` ASC [ RunTime:0.014719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389986 ORDER BY `unit` DESC [ RunTime:0.008727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389986 LIMIT 2 [ RunTime:0.004940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389986 ORDER BY `minOrder` ASC [ RunTime:0.024481s ]
select * from pdf where partno='9774060360R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774060360R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.007859s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389986 AND `partno` = '9774060360R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.016902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315198 [ RunTime:0.013885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389943 LIMIT 5 [ RunTime:0.007658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389943 ORDER BY `minOrder` ASC [ RunTime:0.014416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389943 ORDER BY `unit` DESC [ RunTime:0.014311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389943 LIMIT 2 [ RunTime:0.011219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389943 ORDER BY `minOrder` ASC [ RunTime:0.011329s ]
select * from pdf where partno='9774015243R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774015243R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006949s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389943 AND `partno` = '9774015243R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.012118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313816 [ RunTime:0.011641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389999 LIMIT 5 [ RunTime:0.008081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389999 ORDER BY `minOrder` ASC [ RunTime:0.010409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389999 ORDER BY `unit` DESC [ RunTime:0.013911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389999 LIMIT 2 [ RunTime:0.008516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389999 ORDER BY `minOrder` ASC [ RunTime:0.009035s ]
select * from pdf where partno='9774060960R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.031483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774060960R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006964s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389999 AND `partno` = '9774060960R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.026347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12040766 [ RunTime:0.027665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389871 LIMIT 5 [ RunTime:0.006826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389871 ORDER BY `minOrder` ASC [ RunTime:0.027619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389871 ORDER BY `unit` DESC [ RunTime:0.006213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389871 LIMIT 2 [ RunTime:0.006104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389871 ORDER BY `minOrder` ASC [ RunTime:0.002145s ]
select * from pdf where partno='9774050943R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.013108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774050943R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.010825s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389871 AND `partno` = '9774050943R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308322 [ RunTime:0.022262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389987 LIMIT 5 [ RunTime:0.011735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389987 ORDER BY `minOrder` ASC [ RunTime:0.051408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389987 ORDER BY `unit` DESC [ RunTime:0.049431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389987 LIMIT 2 [ RunTime:0.045413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389987 ORDER BY `minOrder` ASC [ RunTime:0.022870s ]
select * from pdf where partno='9774040360R' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.021343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9774040360R' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.060229s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389987 AND `partno` = '9774040360R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.041119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315194 [ RunTime:0.035634s ]
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 '977%' OR `brand` LIKE '977%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043140s ]
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 '977%' OR `brand` LIKE '977%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024423s ]
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 '977%' OR `brand` LIKE '977%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017536s ]
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 '977%' OR `brand` LIKE '977%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015705s ]
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 '977%' OR `brand` LIKE '977%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048296s ]
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 '977%' OR `brand` LIKE '977%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034838s ]
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 '977%' OR `brand` LIKE '977%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049983s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '977%' OR `brand` LIKE '977%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.027884s ]