SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002171s ]
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 '83000%' OR `brand` LIKE '83000%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013515s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19306538 LIMIT 5 [ RunTime:0.001512s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19306538 ORDER BY `minOrder` ASC [ RunTime:0.001647s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19306538 ORDER BY `unit` DESC [ RunTime:0.001411s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19306538 LIMIT 2 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19306538 ORDER BY `minOrder` ASC [ RunTime:0.000218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401628 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401628 ORDER BY `minOrder` ASC [ RunTime:0.007487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16401628 ORDER BY `unit` DESC [ RunTime:0.004522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16401628 LIMIT 2 [ RunTime:0.004353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401628 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='83000 001100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19307440 LIMIT 5 [ RunTime:0.007344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19307440 ORDER BY `minOrder` ASC [ RunTime:0.002667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19307440 ORDER BY `unit` DESC [ RunTime:0.002822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19307440 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19307440 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19306540 LIMIT 5 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19306540 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19306540 ORDER BY `unit` DESC [ RunTime:0.002851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19306540 LIMIT 2 [ RunTime:0.002780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19306540 ORDER BY `minOrder` ASC [ RunTime:0.000251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19304932 LIMIT 5 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19304932 ORDER BY `minOrder` ASC [ RunTime:0.002567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19304932 ORDER BY `unit` DESC [ RunTime:0.002910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19304932 LIMIT 2 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19304932 ORDER BY `minOrder` ASC [ RunTime:0.001039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12285296 LIMIT 5 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12285296 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12285296 ORDER BY `unit` DESC [ RunTime:0.002860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12285296 LIMIT 2 [ RunTime:0.002975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12285296 ORDER BY `minOrder` ASC [ RunTime:0.000224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19317434 LIMIT 5 [ RunTime:0.001079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19317434 ORDER BY `minOrder` ASC [ RunTime:0.002155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19317434 ORDER BY `unit` DESC [ RunTime:0.002930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19317434 LIMIT 2 [ RunTime:0.000374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19317434 ORDER BY `minOrder` ASC [ RunTime:0.000247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17172287 LIMIT 5 [ RunTime:0.000770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17172287 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17172287 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17172287 LIMIT 2 [ RunTime:0.002996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17172287 ORDER BY `minOrder` ASC [ RunTime:0.005658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12285784 LIMIT 5 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12285784 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12285784 ORDER BY `unit` DESC [ RunTime:0.002691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12285784 LIMIT 2 [ RunTime:0.003649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12285784 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12285787 LIMIT 5 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12285787 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12285787 ORDER BY `unit` DESC [ RunTime:0.002956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12285787 LIMIT 2 [ RunTime:0.000258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12285787 ORDER BY `minOrder` ASC [ RunTime:0.000205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14706637 LIMIT 5 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706637 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14706637 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14706637 LIMIT 2 [ RunTime:0.001784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706637 ORDER BY `minOrder` ASC [ RunTime:0.004727s ]
select * from pdf where partno='83000000005' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11263561 LIMIT 5 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11263561 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11263561 ORDER BY `unit` DESC [ RunTime:0.002114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11263561 LIMIT 2 [ RunTime:0.003703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11263561 ORDER BY `minOrder` ASC [ RunTime:0.000215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11263322 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11263322 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11263322 ORDER BY `unit` DESC [ RunTime:0.008389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11263322 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11263322 ORDER BY `minOrder` ASC [ RunTime:0.002741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12285788 LIMIT 5 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12285788 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12285788 ORDER BY `unit` DESC [ RunTime:0.003664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12285788 LIMIT 2 [ RunTime:0.007405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12285788 ORDER BY `minOrder` ASC [ RunTime:0.004559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12285789 LIMIT 5 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12285789 ORDER BY `minOrder` ASC [ RunTime:0.000758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12285789 ORDER BY `unit` DESC [ RunTime:0.007143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12285789 LIMIT 2 [ RunTime:0.000763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12285789 ORDER BY `minOrder` ASC [ RunTime:0.004387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17172470 LIMIT 5 [ RunTime:0.001812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17172470 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17172470 ORDER BY `unit` DESC [ RunTime:0.001217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17172470 LIMIT 2 [ RunTime:0.003620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17172470 ORDER BY `minOrder` ASC [ RunTime:0.010345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11263562 LIMIT 5 [ RunTime:0.000857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11263562 ORDER BY `minOrder` ASC [ RunTime:0.003375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11263562 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11263562 LIMIT 2 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11263562 ORDER BY `minOrder` ASC [ RunTime:0.002285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19345242 LIMIT 5 [ RunTime:0.001298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19345242 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19345242 ORDER BY `unit` DESC [ RunTime:0.000831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19345242 LIMIT 2 [ RunTime:0.002017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19345242 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17172545 LIMIT 5 [ RunTime:0.000890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17172545 ORDER BY `minOrder` ASC [ RunTime:0.003295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17172545 ORDER BY `unit` DESC [ RunTime:0.000512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17172545 LIMIT 2 [ RunTime:0.002922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17172545 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16402094 LIMIT 5 [ RunTime:0.000804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16402094 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16402094 ORDER BY `unit` DESC [ RunTime:0.003015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16402094 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16402094 ORDER BY `minOrder` ASC [ RunTime:0.003871s ]
select * from pdf where partno='83000 005100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000745s ]
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 '83000%' OR `brand` LIKE '83000%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51129127 LIMIT 5 [ RunTime:0.002174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129127 ORDER BY `minOrder` ASC [ RunTime:0.001043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51129127 ORDER BY `unit` DESC [ RunTime:0.002442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51129127 LIMIT 2 [ RunTime:0.004253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129127 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
select * from pdf where partno='830003000' and brandshort='wurth elektronik' limit 1 [ RunTime:0.000710s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003000' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.000621s ]
SELECT `id` FROM `stock` WHERE `id` <> 51129127 AND `partno` = '830003000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.000736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19304932 [ RunTime:0.000458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32214805 LIMIT 5 [ RunTime:0.004026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214805 ORDER BY `minOrder` ASC [ RunTime:0.001095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32214805 ORDER BY `unit` DESC [ RunTime:0.003235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32214805 LIMIT 2 [ RunTime:0.003459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214805 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='83000000005' and brandshort='littelfuse' limit 1 [ RunTime:0.000722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000000005' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.011641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32181990 LIMIT 5 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32181990 ORDER BY `minOrder` ASC [ RunTime:0.001463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32181990 ORDER BY `unit` DESC [ RunTime:0.000632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32181990 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32181990 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
select * from pdf where partno='83000000005' and brandshort='littelfuse' limit 1 [ RunTime:0.000330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000000005' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32200630 LIMIT 5 [ RunTime:0.001606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32200630 ORDER BY `minOrder` ASC [ RunTime:0.002744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32200630 ORDER BY `unit` DESC [ RunTime:0.000520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32200630 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32200630 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
select * from pdf where partno='830003279b' and brandshort='wurth elektronik' limit 1 [ RunTime:0.000554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003279b' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.001086s ]
SELECT `id` FROM `stock` WHERE `id` <> 32200630 AND `partno` = '830003279b' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.001471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11266511 [ RunTime:0.001966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138151 LIMIT 5 [ RunTime:0.001989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138151 ORDER BY `minOrder` ASC [ RunTime:0.001705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138151 ORDER BY `unit` DESC [ RunTime:0.006540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138151 LIMIT 2 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138151 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
select * from pdf where partno='83000 009100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.002215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 009100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.000521s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138151 AND `partno` = '83000 009100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138161 LIMIT 5 [ RunTime:0.003170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138161 ORDER BY `minOrder` ASC [ RunTime:0.001531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138161 ORDER BY `unit` DESC [ RunTime:0.006810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138161 LIMIT 2 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138161 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
select * from pdf where partno='83000 003100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.001195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 003100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.002556s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138161 AND `partno` = '83000 003100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138238 LIMIT 5 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138238 ORDER BY `minOrder` ASC [ RunTime:0.000558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138238 ORDER BY `unit` DESC [ RunTime:0.001011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138238 LIMIT 2 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138238 ORDER BY `minOrder` ASC [ RunTime:0.001103s ]
select * from pdf where partno='83000 006100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 006100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.002399s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138238 AND `partno` = '83000 006100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138630 LIMIT 5 [ RunTime:0.003229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138630 ORDER BY `minOrder` ASC [ RunTime:0.007314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138630 ORDER BY `unit` DESC [ RunTime:0.002533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138630 LIMIT 2 [ RunTime:0.007276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138630 ORDER BY `minOrder` ASC [ RunTime:0.001242s ]
select * from pdf where partno='83000 010100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.001616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 010100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.001835s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138630 AND `partno` = '83000 010100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.006839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138627 LIMIT 5 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138627 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138627 ORDER BY `unit` DESC [ RunTime:0.004700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138627 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138627 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
select * from pdf where partno='83000 004100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 004100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.010257s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138627 AND `partno` = '83000 004100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138626 LIMIT 5 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138626 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138626 ORDER BY `unit` DESC [ RunTime:0.000692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138626 LIMIT 2 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138626 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='83000 002100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.001004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 002100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.002193s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138626 AND `partno` = '83000 002100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.002175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138628 LIMIT 5 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138628 ORDER BY `minOrder` ASC [ RunTime:0.003545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138628 ORDER BY `unit` DESC [ RunTime:0.001730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138628 LIMIT 2 [ RunTime:0.000810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138628 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='83000 005100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.002828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 005100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.001088s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138628 AND `partno` = '83000 005100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.011185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138629 LIMIT 5 [ RunTime:0.005386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138629 ORDER BY `minOrder` ASC [ RunTime:0.002787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138629 ORDER BY `unit` DESC [ RunTime:0.000738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138629 LIMIT 2 [ RunTime:0.004852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138629 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='83000 007100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 007100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.002884s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138629 AND `partno` = '83000 007100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.003935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138210 LIMIT 5 [ RunTime:0.004834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138210 ORDER BY `minOrder` ASC [ RunTime:0.003637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138210 ORDER BY `unit` DESC [ RunTime:0.007771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138210 LIMIT 2 [ RunTime:0.002403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138210 ORDER BY `minOrder` ASC [ RunTime:0.006170s ]
select * from pdf where partno='83000 0041000' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 0041000' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.004143s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138210 AND `partno` = '83000 0041000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.011416s ]
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 '83000%' OR `brand` LIKE '83000%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42607282 LIMIT 5 [ RunTime:0.003821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42607282 ORDER BY `minOrder` ASC [ RunTime:0.002670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42607282 ORDER BY `unit` DESC [ RunTime:0.008943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42607282 LIMIT 2 [ RunTime:0.002582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42607282 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
select * from pdf where partno='830009706' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830009706' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006330s ]
SELECT `id` FROM `stock` WHERE `id` <> 42607282 AND `partno` = '830009706' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19306538 [ RunTime:0.014649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56229604 LIMIT 5 [ RunTime:0.003868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56229604 ORDER BY `minOrder` ASC [ RunTime:0.000810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56229604 ORDER BY `unit` DESC [ RunTime:0.001198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56229604 LIMIT 2 [ RunTime:0.003820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56229604 ORDER BY `minOrder` ASC [ RunTime:0.006739s ]
select * from pdf where partno='83000 003100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.012773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 003100' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000620s ]
SELECT `id` FROM `stock` WHERE `id` <> 56229604 AND `partno` = '83000 003100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405556 [ RunTime:0.005102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56228167 LIMIT 5 [ RunTime:0.001632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56228167 ORDER BY `minOrder` ASC [ RunTime:0.003713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56228167 ORDER BY `unit` DESC [ RunTime:0.000715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56228167 LIMIT 2 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56228167 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
select * from pdf where partno='83000 001100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 001100' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000481s ]
SELECT `id` FROM `stock` WHERE `id` <> 56228167 AND `partno` = '83000 001100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401628 [ RunTime:0.003737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42606452 LIMIT 5 [ RunTime:0.002824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42606452 ORDER BY `minOrder` ASC [ RunTime:0.001646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42606452 ORDER BY `unit` DESC [ RunTime:0.000692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42606452 LIMIT 2 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42606452 ORDER BY `minOrder` ASC [ RunTime:0.003811s ]
select * from pdf where partno='830009678' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830009678' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000928s ]
SELECT `id` FROM `stock` WHERE `id` <> 42606452 AND `partno` = '830009678' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19307440 [ RunTime:0.000703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42606815 LIMIT 5 [ RunTime:0.002915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42606815 ORDER BY `minOrder` ASC [ RunTime:0.001813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42606815 ORDER BY `unit` DESC [ RunTime:0.001096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42606815 LIMIT 2 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42606815 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='830009709' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830009709' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003136s ]
SELECT `id` FROM `stock` WHERE `id` <> 42606815 AND `partno` = '830009709' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19306540 [ RunTime:0.001439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42613707 LIMIT 5 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42613707 ORDER BY `minOrder` ASC [ RunTime:0.001156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42613707 ORDER BY `unit` DESC [ RunTime:0.002586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42613707 LIMIT 2 [ RunTime:0.007250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42613707 ORDER BY `minOrder` ASC [ RunTime:0.001108s ]
select * from pdf where partno='830003237' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003237' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001127s ]
SELECT `id` FROM `stock` WHERE `id` <> 42613707 AND `partno` = '830003237' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12285787 [ RunTime:0.009416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42606823 LIMIT 5 [ RunTime:0.001796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42606823 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42606823 ORDER BY `unit` DESC [ RunTime:0.014059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42606823 LIMIT 2 [ RunTime:0.002581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42606823 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='830002997B' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830002997B' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.008622s ]
SELECT `id` FROM `stock` WHERE `id` <> 42606823 AND `partno` = '830002997B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.002470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11263322 [ RunTime:0.001835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42607030 LIMIT 5 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42607030 ORDER BY `minOrder` ASC [ RunTime:0.001634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42607030 ORDER BY `unit` DESC [ RunTime:0.001406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42607030 LIMIT 2 [ RunTime:0.010465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42607030 ORDER BY `minOrder` ASC [ RunTime:0.003109s ]
select * from pdf where partno='830003000' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003000' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001240s ]
SELECT `id` FROM `stock` WHERE `id` <> 42607030 AND `partno` = '830003000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19304932 [ RunTime:0.011073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58199506 LIMIT 5 [ RunTime:0.001243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58199506 ORDER BY `minOrder` ASC [ RunTime:0.004370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58199506 ORDER BY `unit` DESC [ RunTime:0.001840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58199506 LIMIT 2 [ RunTime:0.000847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58199506 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='83000000005' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000000005' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42610917 LIMIT 5 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42610917 ORDER BY `minOrder` ASC [ RunTime:0.003751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42610917 ORDER BY `unit` DESC [ RunTime:0.001780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42610917 LIMIT 2 [ RunTime:0.002806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42610917 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='830003210' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003210' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000799s ]
SELECT `id` FROM `stock` WHERE `id` <> 42610917 AND `partno` = '830003210' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19317434 [ RunTime:0.000673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42607354 LIMIT 5 [ RunTime:0.004314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42607354 ORDER BY `minOrder` ASC [ RunTime:0.001805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42607354 ORDER BY `unit` DESC [ RunTime:0.001267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42607354 LIMIT 2 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42607354 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='830002996B' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830002996B' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.005434s ]
SELECT `id` FROM `stock` WHERE `id` <> 42607354 AND `partno` = '830002996B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19345242 [ RunTime:0.002927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42606964 LIMIT 5 [ RunTime:0.007383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42606964 ORDER BY `minOrder` ASC [ RunTime:0.007164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42606964 ORDER BY `unit` DESC [ RunTime:0.002666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42606964 LIMIT 2 [ RunTime:0.001817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42606964 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='830002995B' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830002995B' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.005934s ]
SELECT `id` FROM `stock` WHERE `id` <> 42606964 AND `partno` = '830002995B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.002882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17172287 [ RunTime:0.001144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42610421 LIMIT 5 [ RunTime:0.002183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42610421 ORDER BY `minOrder` ASC [ RunTime:0.001217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42610421 ORDER BY `unit` DESC [ RunTime:0.000636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42610421 LIMIT 2 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42610421 ORDER BY `minOrder` ASC [ RunTime:0.006266s ]
select * from pdf where partno='830003166' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003166' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003185s ]
SELECT `id` FROM `stock` WHERE `id` <> 42610421 AND `partno` = '830003166' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12285789 [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42608367 LIMIT 5 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42608367 ORDER BY `minOrder` ASC [ RunTime:0.008683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42608367 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42608367 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42608367 ORDER BY `minOrder` ASC [ RunTime:0.002319s ]
select * from pdf where partno='830003151' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003151' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001136s ]
SELECT `id` FROM `stock` WHERE `id` <> 42608367 AND `partno` = '830003151' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12285296 [ RunTime:0.002137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42613328 LIMIT 5 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42613328 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42613328 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42613328 LIMIT 2 [ RunTime:0.001945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42613328 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
select * from pdf where partno='830003058' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003058' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000524s ]
SELECT `id` FROM `stock` WHERE `id` <> 42613328 AND `partno` = '830003058' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11263561 [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42615620 LIMIT 5 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42615620 ORDER BY `minOrder` ASC [ RunTime:0.002393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42615620 ORDER BY `unit` DESC [ RunTime:0.001066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42615620 LIMIT 2 [ RunTime:0.000994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42615620 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='830003334' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003334' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000442s ]
SELECT `id` FROM `stock` WHERE `id` <> 42615620 AND `partno` = '830003334' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.002045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12285784 [ RunTime:0.000946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42616841 LIMIT 5 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42616841 ORDER BY `minOrder` ASC [ RunTime:0.000914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42616841 ORDER BY `unit` DESC [ RunTime:0.000506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42616841 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42616841 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
select * from pdf where partno='830003260' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003260' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001805s ]
SELECT `id` FROM `stock` WHERE `id` <> 42616841 AND `partno` = '830003260' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11263562 [ RunTime:0.000880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56228168 LIMIT 5 [ RunTime:0.000430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56228168 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56228168 ORDER BY `unit` DESC [ RunTime:0.002846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56228168 LIMIT 2 [ RunTime:0.002284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56228168 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
select * from pdf where partno='83000 006100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83000 006100' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000552s ]
SELECT `id` FROM `stock` WHERE `id` <> 56228168 AND `partno` = '83000 006100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13490097 [ RunTime:0.000762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42615274 LIMIT 5 [ RunTime:0.000359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42615274 ORDER BY `minOrder` ASC [ RunTime:0.002691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42615274 ORDER BY `unit` DESC [ RunTime:0.001603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42615274 LIMIT 2 [ RunTime:0.001277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42615274 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='830003519' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003519' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000706s ]
SELECT `id` FROM `stock` WHERE `id` <> 42615274 AND `partno` = '830003519' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12285788 [ RunTime:0.003093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42618037 LIMIT 5 [ RunTime:0.001520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42618037 ORDER BY `minOrder` ASC [ RunTime:0.001340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42618037 ORDER BY `unit` DESC [ RunTime:0.000897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42618037 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42618037 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='830003387' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '830003387' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002175s ]
SELECT `id` FROM `stock` WHERE `id` <> 42618037 AND `partno` = '830003387' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17172470 [ RunTime:0.002650s ]
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 '83000%' OR `brand` LIKE '83000%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001326s ]
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 '83000%' OR `brand` LIKE '83000%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000783s ]
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 '83000%' OR `brand` LIKE '83000%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002035s ]
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 '83000%' OR `brand` LIKE '83000%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000627s ]
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 '83000%' OR `brand` LIKE '83000%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000701s ]
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 '83000%' OR `brand` LIKE '83000%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001317s ]
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 '83000%' OR `brand` LIKE '83000%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000685s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '83000%' OR `brand` LIKE '83000%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006424s ]