SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001881s ]
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 '3590%' OR `brand` LIKE '3590%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012875s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11518935 LIMIT 5 [ RunTime:0.000785s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518935 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11518935 ORDER BY `unit` DESC [ RunTime:0.000298s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11518935 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518935 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443322 LIMIT 5 [ RunTime:0.002305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443322 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15443322 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15443322 LIMIT 2 [ RunTime:0.000258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443322 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349350 LIMIT 5 [ RunTime:0.001421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349350 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349350 ORDER BY `unit` DESC [ RunTime:0.000320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349350 LIMIT 2 [ RunTime:0.000319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349350 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17767981 LIMIT 5 [ RunTime:0.004197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17767981 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17767981 ORDER BY `unit` DESC [ RunTime:0.000364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17767981 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17767981 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17767984 LIMIT 5 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17767984 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17767984 ORDER BY `unit` DESC [ RunTime:0.000287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17767984 LIMIT 2 [ RunTime:0.000268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17767984 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17767985 LIMIT 5 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17767985 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17767985 ORDER BY `unit` DESC [ RunTime:0.000299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17767985 LIMIT 2 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17767985 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1011 LIMIT 5 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1011 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1011 ORDER BY `unit` DESC [ RunTime:0.000369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1011 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1011 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-4-103L.' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.004173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17767999 LIMIT 5 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17767999 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17767999 ORDER BY `unit` DESC [ RunTime:0.000304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17767999 LIMIT 2 [ RunTime:0.000291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17767999 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15680617 LIMIT 5 [ RunTime:0.003415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15680617 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15680617 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15680617 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15680617 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16782188 LIMIT 5 [ RunTime:0.001592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16782188 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16782188 ORDER BY `unit` DESC [ RunTime:0.000564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16782188 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16782188 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17810856 LIMIT 5 [ RunTime:0.003248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17810856 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17810856 ORDER BY `unit` DESC [ RunTime:0.000562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17810856 LIMIT 2 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17810856 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17843930 LIMIT 5 [ RunTime:0.000885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17843930 ORDER BY `minOrder` ASC [ RunTime:0.000584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17843930 ORDER BY `unit` DESC [ RunTime:0.000559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17843930 LIMIT 2 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17843930 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15702528 LIMIT 5 [ RunTime:0.001442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15702528 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15702528 ORDER BY `unit` DESC [ RunTime:0.000561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15702528 LIMIT 2 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15702528 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14059259 LIMIT 5 [ RunTime:0.001778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14059259 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14059259 ORDER BY `unit` DESC [ RunTime:0.000597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14059259 LIMIT 2 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14059259 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15702532 LIMIT 5 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15702532 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15702532 ORDER BY `unit` DESC [ RunTime:0.000567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15702532 LIMIT 2 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15702532 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14988471 LIMIT 5 [ RunTime:0.001165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14988471 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14988471 ORDER BY `unit` DESC [ RunTime:0.000470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14988471 LIMIT 2 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14988471 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17770864 LIMIT 5 [ RunTime:0.000787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17770864 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17770864 ORDER BY `unit` DESC [ RunTime:0.000477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17770864 LIMIT 2 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17770864 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17769492 LIMIT 5 [ RunTime:0.000754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17769492 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17769492 ORDER BY `unit` DESC [ RunTime:0.000469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17769492 LIMIT 2 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17769492 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17769491 LIMIT 5 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17769491 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17769491 ORDER BY `unit` DESC [ RunTime:0.000470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17769491 LIMIT 2 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17769491 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16781447 LIMIT 5 [ RunTime:0.000807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16781447 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16781447 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16781447 LIMIT 2 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16781447 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
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 '3590%' OR `brand` LIKE '3590%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268148 LIMIT 5 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268148 ORDER BY `minOrder` ASC [ RunTime:0.000832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268148 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268148 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268148 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='35903-0022' and brandshort='molex' limit 1 [ RunTime:0.000677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '35903-0022' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.007151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267413 LIMIT 5 [ RunTime:0.000897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267413 ORDER BY `minOrder` ASC [ RunTime:0.001112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267413 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267413 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267413 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
select * from pdf where partno='35903-0106' and brandshort='molex' limit 1 [ RunTime:0.000968s ]
select foldpath,foldpath2,filename from pdf_file where id=688349 limit 1 [ RunTime:0.000644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '35903-0106' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51115916 LIMIT 5 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51115916 ORDER BY `minOrder` ASC [ RunTime:0.001122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51115916 ORDER BY `unit` DESC [ RunTime:0.000543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51115916 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51115916 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
select * from pdf where partno='3590s-4-102l' and brandshort='bourns' limit 1 [ RunTime:0.002166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590s-4-102l' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.004297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51116811 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116811 ORDER BY `minOrder` ASC [ RunTime:0.004930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51116811 ORDER BY `unit` DESC [ RunTime:0.000569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51116811 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116811 ORDER BY `minOrder` ASC [ RunTime:0.000680s ]
select * from pdf where partno='3590s-4-201l' and brandshort='bourns' limit 1 [ RunTime:0.002884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590s-4-201l' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.004290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51116431 LIMIT 5 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116431 ORDER BY `minOrder` ASC [ RunTime:0.001099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51116431 ORDER BY `unit` DESC [ RunTime:0.000548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51116431 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116431 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
select * from pdf where partno='3590s-8-103l' and brandshort='bourns' limit 1 [ RunTime:0.002546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590s-8-103l' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.003762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51116234 LIMIT 5 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116234 ORDER BY `minOrder` ASC [ RunTime:0.001027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51116234 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51116234 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116234 ORDER BY `minOrder` ASC [ RunTime:0.000612s ]
select * from pdf where partno='3590s-291-102l' and brandshort='bourns' limit 1 [ RunTime:0.001739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590s-291-102l' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.004068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51116520 LIMIT 5 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116520 ORDER BY `minOrder` ASC [ RunTime:0.001142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51116520 ORDER BY `unit` DESC [ RunTime:0.000659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51116520 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116520 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
select * from pdf where partno='3590s-291-103l' and brandshort='bourns' limit 1 [ RunTime:0.000941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590s-291-103l' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.003929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51116666 LIMIT 5 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116666 ORDER BY `minOrder` ASC [ RunTime:0.000993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51116666 ORDER BY `unit` DESC [ RunTime:0.000540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51116666 LIMIT 2 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116666 ORDER BY `minOrder` ASC [ RunTime:0.000622s ]
select * from pdf where partno='3590s-4-501l' and brandshort='bourns' limit 1 [ RunTime:0.000833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590s-4-501l' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.004053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51116430 LIMIT 5 [ RunTime:0.000528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116430 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51116430 ORDER BY `unit` DESC [ RunTime:0.000505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51116430 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116430 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
select * from pdf where partno='3590s-2-101l' and brandshort='bourns' limit 1 [ RunTime:0.000687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590s-2-101l' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.003785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51116521 LIMIT 5 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116521 ORDER BY `minOrder` ASC [ RunTime:0.000678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51116521 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51116521 LIMIT 2 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116521 ORDER BY `minOrder` ASC [ RunTime:0.000665s ]
select * from pdf where partno='3590s-3-502l' and brandshort='bourns' limit 1 [ RunTime:0.000765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590s-3-502l' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.003820s ]
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 '3590%' OR `brand` LIKE '3590%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66563551 LIMIT 5 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66563551 ORDER BY `minOrder` ASC [ RunTime:0.003712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66563551 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66563551 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66563551 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
select * from pdf where partno='35903-0022' and brandshort='Molex' limit 1 [ RunTime:0.000553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '35903-0022' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.004903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69916588 LIMIT 5 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69916588 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69916588 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69916588 LIMIT 2 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69916588 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='3590' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.003070s ]
SELECT `id` FROM `stock` WHERE `id` <> 69916588 AND `partno` = '3590' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.000632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13536182 [ RunTime:0.002990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67125701 LIMIT 5 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67125701 ORDER BY `minOrder` ASC [ RunTime:0.004008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67125701 ORDER BY `unit` DESC [ RunTime:0.000357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67125701 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67125701 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='3590' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000986s ]
SELECT `id` FROM `stock` WHERE `id` <> 67125701 AND `partno` = '3590' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443322 [ RunTime:0.000582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594299 LIMIT 5 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594299 ORDER BY `minOrder` ASC [ RunTime:0.004254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594299 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594299 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594299 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
select * from pdf where partno='3590S-2-103L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.002640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-2-103L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594311 LIMIT 5 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594311 ORDER BY `minOrder` ASC [ RunTime:0.001007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594311 ORDER BY `unit` DESC [ RunTime:0.000664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594311 LIMIT 2 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594311 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
select * from pdf where partno='3590S-2-104L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-2-104L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594300 LIMIT 5 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594300 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594300 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594300 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594300 ORDER BY `minOrder` ASC [ RunTime:0.000709s ]
select * from pdf where partno='3590S-2-502L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-2-502L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594301 LIMIT 5 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594301 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594301 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594301 LIMIT 2 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594301 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
select * from pdf where partno='3590S-2-102L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-2-102L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594302 LIMIT 5 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594302 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594302 ORDER BY `unit` DESC [ RunTime:0.000708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594302 LIMIT 2 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594302 ORDER BY `minOrder` ASC [ RunTime:0.000817s ]
select * from pdf where partno='3590S-2-202L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-2-202L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71319410 LIMIT 5 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71319410 ORDER BY `minOrder` ASC [ RunTime:0.001362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71319410 ORDER BY `unit` DESC [ RunTime:0.000824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71319410 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71319410 ORDER BY `minOrder` ASC [ RunTime:0.000721s ]
select * from pdf where partno='3590CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001391s ]
SELECT `id` FROM `stock` WHERE `id` <> 71319410 AND `partno` = '3590CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349350 [ RunTime:0.000798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594896 LIMIT 5 [ RunTime:0.000757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594896 ORDER BY `minOrder` ASC [ RunTime:0.005639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594896 ORDER BY `unit` DESC [ RunTime:0.000750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594896 LIMIT 2 [ RunTime:0.000914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594896 ORDER BY `minOrder` ASC [ RunTime:0.000772s ]
select * from pdf where partno='3590S-2-203L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-2-203L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594303 LIMIT 5 [ RunTime:0.000709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594303 ORDER BY `minOrder` ASC [ RunTime:0.000871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594303 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594303 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594303 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
select * from pdf where partno='3590S-1-103L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-1-103L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594912 LIMIT 5 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594912 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594912 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594912 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594912 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='3590S-1-104L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-1-104L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594909 LIMIT 5 [ RunTime:0.000430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594909 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594909 ORDER BY `unit` DESC [ RunTime:0.000751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594909 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594909 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
select * from pdf where partno='3590P-2-502L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590P-2-502L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000906s ]
SELECT `id` FROM `stock` WHERE `id` <> 40594909 AND `partno` = '3590P-2-502L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17769491 [ RunTime:0.000679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594915 LIMIT 5 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594915 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594915 ORDER BY `unit` DESC [ RunTime:0.000657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594915 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594915 ORDER BY `minOrder` ASC [ RunTime:0.000667s ]
select * from pdf where partno='3590P-2-104L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.002170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590P-2-104L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000799s ]
SELECT `id` FROM `stock` WHERE `id` <> 40594915 AND `partno` = '3590P-2-104L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16781449 [ RunTime:0.000589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594897 LIMIT 5 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594897 ORDER BY `minOrder` ASC [ RunTime:0.000759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594897 ORDER BY `unit` DESC [ RunTime:0.000658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594897 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594897 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
select * from pdf where partno='3590S-2-201L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-2-201L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000848s ]
SELECT `id` FROM `stock` WHERE `id` <> 40594897 AND `partno` = '3590S-2-201L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14988474 [ RunTime:0.002407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594898 LIMIT 5 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594898 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594898 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594898 LIMIT 2 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594898 ORDER BY `minOrder` ASC [ RunTime:0.000728s ]
select * from pdf where partno='3590S-1-203L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-1-203L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000817s ]
SELECT `id` FROM `stock` WHERE `id` <> 40594898 AND `partno` = '3590S-1-203L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14988471 [ RunTime:0.000700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594914 LIMIT 5 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594914 ORDER BY `minOrder` ASC [ RunTime:0.000780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594914 ORDER BY `unit` DESC [ RunTime:0.000771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594914 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594914 ORDER BY `minOrder` ASC [ RunTime:0.000847s ]
select * from pdf where partno='3590S-4-103L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.002794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-4-103L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000947s ]
SELECT `id` FROM `stock` WHERE `id` <> 40594914 AND `partno` = '3590S-4-103L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15680697 [ RunTime:0.001191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594899 LIMIT 5 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594899 ORDER BY `minOrder` ASC [ RunTime:0.000929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594899 ORDER BY `unit` DESC [ RunTime:0.000814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594899 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594899 ORDER BY `minOrder` ASC [ RunTime:0.000757s ]
select * from pdf where partno='3590S-1-501L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.002365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-1-501L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000842s ]
SELECT `id` FROM `stock` WHERE `id` <> 40594899 AND `partno` = '3590S-1-501L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14050149 [ RunTime:0.004026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594903 LIMIT 5 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594903 ORDER BY `minOrder` ASC [ RunTime:0.000765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594903 ORDER BY `unit` DESC [ RunTime:0.000628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594903 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594903 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
select * from pdf where partno='3590S-6-102L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.005202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-6-102L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000856s ]
SELECT `id` FROM `stock` WHERE `id` <> 40594903 AND `partno` = '3590S-6-102L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15680882 [ RunTime:0.005498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594900 LIMIT 5 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594900 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594900 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594900 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594900 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
select * from pdf where partno='3590S-1-102L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3590S-1-102L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002011s ]
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 '3590%' OR `brand` LIKE '3590%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001271s ]
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 '3590%' OR `brand` LIKE '3590%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001012s ]
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 '3590%' OR `brand` LIKE '3590%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001066s ]
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 '3590%' OR `brand` LIKE '3590%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001139s ]
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 '3590%' OR `brand` LIKE '3590%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000968s ]
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 '3590%' OR `brand` LIKE '3590%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000968s ]
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 '3590%' OR `brand` LIKE '3590%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001191s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3590%' OR `brand` LIKE '3590%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001840s ]