SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003611s ]
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 '7327%' OR `brand` LIKE '7327%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015411s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585757 LIMIT 5 [ RunTime:0.024141s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585757 ORDER BY `minOrder` ASC [ RunTime:0.009371s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19585757 ORDER BY `unit` DESC [ RunTime:0.005956s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19585757 LIMIT 2 [ RunTime:0.044643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585757 ORDER BY `minOrder` ASC [ RunTime:0.011709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867214 LIMIT 5 [ RunTime:0.033467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867214 ORDER BY `minOrder` ASC [ RunTime:0.013367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18867214 ORDER BY `unit` DESC [ RunTime:0.055958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18867214 LIMIT 2 [ RunTime:0.026016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867214 ORDER BY `minOrder` ASC [ RunTime:0.005662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19067422 LIMIT 5 [ RunTime:0.014739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19067422 ORDER BY `minOrder` ASC [ RunTime:0.013225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19067422 ORDER BY `unit` DESC [ RunTime:0.022442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19067422 LIMIT 2 [ RunTime:0.020635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19067422 ORDER BY `minOrder` ASC [ RunTime:0.008915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867569 LIMIT 5 [ RunTime:0.018738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867569 ORDER BY `minOrder` ASC [ RunTime:0.004526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18867569 ORDER BY `unit` DESC [ RunTime:0.018540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18867569 LIMIT 2 [ RunTime:0.012421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867569 ORDER BY `minOrder` ASC [ RunTime:0.004116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396153 LIMIT 5 [ RunTime:0.021795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396153 ORDER BY `minOrder` ASC [ RunTime:0.021091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396153 ORDER BY `unit` DESC [ RunTime:0.035104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396153 LIMIT 2 [ RunTime:0.019649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396153 ORDER BY `minOrder` ASC [ RunTime:0.003497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395196 LIMIT 5 [ RunTime:0.020336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395196 ORDER BY `minOrder` ASC [ RunTime:0.040355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395196 ORDER BY `unit` DESC [ RunTime:0.021264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395196 LIMIT 2 [ RunTime:0.009846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395196 ORDER BY `minOrder` ASC [ RunTime:0.040143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523897 LIMIT 5 [ RunTime:0.023183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523897 ORDER BY `minOrder` ASC [ RunTime:0.049067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523897 ORDER BY `unit` DESC [ RunTime:0.015494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523897 LIMIT 2 [ RunTime:0.037540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523897 ORDER BY `minOrder` ASC [ RunTime:0.008484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523835 LIMIT 5 [ RunTime:0.010930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523835 ORDER BY `minOrder` ASC [ RunTime:0.009187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523835 ORDER BY `unit` DESC [ RunTime:0.014051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523835 LIMIT 2 [ RunTime:0.015630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523835 ORDER BY `minOrder` ASC [ RunTime:0.001842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782529 LIMIT 5 [ RunTime:0.010850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782529 ORDER BY `minOrder` ASC [ RunTime:0.002169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12782529 ORDER BY `unit` DESC [ RunTime:0.009948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12782529 LIMIT 2 [ RunTime:0.024436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782529 ORDER BY `minOrder` ASC [ RunTime:0.023328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782453 LIMIT 5 [ RunTime:0.015760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782453 ORDER BY `minOrder` ASC [ RunTime:0.003349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12782453 ORDER BY `unit` DESC [ RunTime:0.015695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12782453 LIMIT 2 [ RunTime:0.012162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782453 ORDER BY `minOrder` ASC [ RunTime:0.013931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12170237 LIMIT 5 [ RunTime:0.015222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12170237 ORDER BY `minOrder` ASC [ RunTime:0.013133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12170237 ORDER BY `unit` DESC [ RunTime:0.008922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12170237 LIMIT 2 [ RunTime:0.004350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12170237 ORDER BY `minOrder` ASC [ RunTime:0.001484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611242 LIMIT 5 [ RunTime:0.010349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611242 ORDER BY `minOrder` ASC [ RunTime:0.012130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611242 ORDER BY `unit` DESC [ RunTime:0.028466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611242 LIMIT 2 [ RunTime:0.014902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611242 ORDER BY `minOrder` ASC [ RunTime:0.016348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11603533 LIMIT 5 [ RunTime:0.015841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603533 ORDER BY `minOrder` ASC [ RunTime:0.010283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11603533 ORDER BY `unit` DESC [ RunTime:0.037158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11603533 LIMIT 2 [ RunTime:0.017989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603533 ORDER BY `minOrder` ASC [ RunTime:0.025820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11603532 LIMIT 5 [ RunTime:0.015928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603532 ORDER BY `minOrder` ASC [ RunTime:0.025281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11603532 ORDER BY `unit` DESC [ RunTime:0.036080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11603532 LIMIT 2 [ RunTime:0.013634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603532 ORDER BY `minOrder` ASC [ RunTime:0.019844s ]
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 '7327%' OR `brand` LIKE '7327%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32232768 LIMIT 5 [ RunTime:0.031291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232768 ORDER BY `minOrder` ASC [ RunTime:0.034585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32232768 ORDER BY `unit` DESC [ RunTime:0.006303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32232768 LIMIT 2 [ RunTime:0.016138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232768 ORDER BY `minOrder` ASC [ RunTime:0.011312s ]
select * from pdf where partno='7327' and brandshort='vcc' limit 1 [ RunTime:0.024704s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327' OR `brand` LIKE 'vcc%' ) ) LIMIT 1 [ RunTime:0.010689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32232949 LIMIT 5 [ RunTime:0.027226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232949 ORDER BY `minOrder` ASC [ RunTime:0.052422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32232949 ORDER BY `unit` DESC [ RunTime:0.036033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32232949 LIMIT 2 [ RunTime:0.026033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232949 ORDER BY `minOrder` ASC [ RunTime:0.002001s ]
select * from pdf where partno='7327' and brandshort='jkl components' limit 1 [ RunTime:0.025790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327' OR `brand` LIKE 'jkl components%' ) ) LIMIT 1 [ RunTime:0.035108s ]
SELECT `id` FROM `stock` WHERE `id` <> 32232949 AND `partno` = '7327' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jkl components%' ) [ RunTime:0.014561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867569 [ RunTime:0.020522s ]
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 '7327%' OR `brand` LIKE '7327%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54116696 LIMIT 5 [ RunTime:0.006714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54116696 ORDER BY `minOrder` ASC [ RunTime:0.012731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54116696 ORDER BY `unit` DESC [ RunTime:0.010208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54116696 LIMIT 2 [ RunTime:0.024012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54116696 ORDER BY `minOrder` ASC [ RunTime:0.003183s ]
select * from pdf where partno='7327' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.017881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.013973s ]
SELECT `id` FROM `stock` WHERE `id` <> 54116696 AND `partno` = '7327' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.017710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585757 [ RunTime:0.031252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51263017 LIMIT 5 [ RunTime:0.007664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51263017 ORDER BY `minOrder` ASC [ RunTime:0.027669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51263017 ORDER BY `unit` DESC [ RunTime:0.014177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51263017 LIMIT 2 [ RunTime:0.052502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51263017 ORDER BY `minOrder` ASC [ RunTime:0.015495s ]
select * from pdf where partno='7327-1Z-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.022194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327-1Z-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.022463s ]
SELECT `id` FROM `stock` WHERE `id` <> 51263017 AND `partno` = '7327-1Z-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.012821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51265495 LIMIT 5 [ RunTime:0.025940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51265495 ORDER BY `minOrder` ASC [ RunTime:0.029532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51265495 ORDER BY `unit` DESC [ RunTime:0.031108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51265495 LIMIT 2 [ RunTime:0.008340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51265495 ORDER BY `minOrder` ASC [ RunTime:0.006397s ]
select * from pdf where partno='7327E-2Z-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.014757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327E-2Z-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.011941s ]
SELECT `id` FROM `stock` WHERE `id` <> 51265495 AND `partno` = '7327E-2Z-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.037036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51265343 LIMIT 5 [ RunTime:0.006157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51265343 ORDER BY `minOrder` ASC [ RunTime:0.031718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51265343 ORDER BY `unit` DESC [ RunTime:0.002064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51265343 LIMIT 2 [ RunTime:0.018097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51265343 ORDER BY `minOrder` ASC [ RunTime:0.006228s ]
select * from pdf where partno='7327E-2-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.007026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327E-2-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.012365s ]
SELECT `id` FROM `stock` WHERE `id` <> 51265343 AND `partno` = '7327E-2-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.005292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51264693 LIMIT 5 [ RunTime:0.009442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51264693 ORDER BY `minOrder` ASC [ RunTime:0.022345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51264693 ORDER BY `unit` DESC [ RunTime:0.009963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51264693 LIMIT 2 [ RunTime:0.006958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51264693 ORDER BY `minOrder` ASC [ RunTime:0.015410s ]
select * from pdf where partno='7327E-1-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.001597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327E-1-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.023788s ]
SELECT `id` FROM `stock` WHERE `id` <> 51264693 AND `partno` = '7327E-1-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.018399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52497722 LIMIT 5 [ RunTime:0.008699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52497722 ORDER BY `minOrder` ASC [ RunTime:0.005793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52497722 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52497722 LIMIT 2 [ RunTime:0.005704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52497722 ORDER BY `minOrder` ASC [ RunTime:0.005671s ]
select * from pdf where partno='73277-101402LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '73277-101402LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004998s ]
SELECT `id` FROM `stock` WHERE `id` <> 52497722 AND `partno` = '73277-101402LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.012643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51241055 LIMIT 5 [ RunTime:0.020127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241055 ORDER BY `minOrder` ASC [ RunTime:0.000918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51241055 ORDER BY `unit` DESC [ RunTime:0.006501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51241055 LIMIT 2 [ RunTime:0.001705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241055 ORDER BY `minOrder` ASC [ RunTime:0.001889s ]
select * from pdf where partno='7327' and brandshort='Visual Communications Company - VCC' limit 1 [ RunTime:0.009485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327' OR `brand` LIKE 'Visual Communications Company - VCC%' ) ) LIMIT 1 [ RunTime:0.004693s ]
SELECT `id` FROM `stock` WHERE `id` <> 51241055 AND `partno` = '7327' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%visual communications company - vcc%' ) [ RunTime:0.003805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867214 [ RunTime:0.005586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58006392 LIMIT 5 [ RunTime:0.007341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58006392 ORDER BY `minOrder` ASC [ RunTime:0.004678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58006392 ORDER BY `unit` DESC [ RunTime:0.000989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58006392 LIMIT 2 [ RunTime:0.002432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58006392 ORDER BY `minOrder` ASC [ RunTime:0.004324s ]
select * from pdf where partno='7327N' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.016049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327N' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.005215s ]
SELECT `id` FROM `stock` WHERE `id` <> 58006392 AND `partno` = '7327N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.002916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57699232 LIMIT 5 [ RunTime:0.009062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57699232 ORDER BY `minOrder` ASC [ RunTime:0.024468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57699232 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57699232 LIMIT 2 [ RunTime:0.009930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57699232 ORDER BY `minOrder` ASC [ RunTime:0.000761s ]
select * from pdf where partno='7327-1HV-PK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327-1HV-PK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.017460s ]
SELECT `id` FROM `stock` WHERE `id` <> 57699232 AND `partno` = '7327-1HV-PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.012572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396153 [ RunTime:0.006055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57697241 LIMIT 5 [ RunTime:0.002887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57697241 ORDER BY `minOrder` ASC [ RunTime:0.004691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57697241 ORDER BY `unit` DESC [ RunTime:0.001866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57697241 LIMIT 2 [ RunTime:0.012598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57697241 ORDER BY `minOrder` ASC [ RunTime:0.002639s ]
select * from pdf where partno='7327-4-PK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327-4-PK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010390s ]
SELECT `id` FROM `stock` WHERE `id` <> 57697241 AND `partno` = '7327-4-PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523897 [ RunTime:0.009440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57697133 LIMIT 5 [ RunTime:0.001320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57697133 ORDER BY `minOrder` ASC [ RunTime:0.001104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57697133 ORDER BY `unit` DESC [ RunTime:0.000484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57697133 LIMIT 2 [ RunTime:0.003759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57697133 ORDER BY `minOrder` ASC [ RunTime:0.003014s ]
select * from pdf where partno='7327-1-PK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327-1-PK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004684s ]
SELECT `id` FROM `stock` WHERE `id` <> 57697133 AND `partno` = '7327-1-PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523835 [ RunTime:0.015920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57697018 LIMIT 5 [ RunTime:0.020533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57697018 ORDER BY `minOrder` ASC [ RunTime:0.002757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57697018 ORDER BY `unit` DESC [ RunTime:0.004146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57697018 LIMIT 2 [ RunTime:0.030516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57697018 ORDER BY `minOrder` ASC [ RunTime:0.002645s ]
select * from pdf where partno='7327-3C-PK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327-3C-PK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.017229s ]
SELECT `id` FROM `stock` WHERE `id` <> 57697018 AND `partno` = '7327-3C-PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.013160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395196 [ RunTime:0.004090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57626717 LIMIT 5 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57626717 ORDER BY `minOrder` ASC [ RunTime:0.001802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57626717 ORDER BY `unit` DESC [ RunTime:0.007944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57626717 LIMIT 2 [ RunTime:0.018201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57626717 ORDER BY `minOrder` ASC [ RunTime:0.013245s ]
select * from pdf where partno='732750003' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.019383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '732750003' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.002672s ]
SELECT `id` FROM `stock` WHERE `id` <> 57626717 AND `partno` = '732750003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.006867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19067422 [ RunTime:0.016257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52508180 LIMIT 5 [ RunTime:0.043661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52508180 ORDER BY `minOrder` ASC [ RunTime:0.018747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52508180 ORDER BY `unit` DESC [ RunTime:0.017888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52508180 LIMIT 2 [ RunTime:0.030857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52508180 ORDER BY `minOrder` ASC [ RunTime:0.014818s ]
select * from pdf where partno='73277-101000' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.016742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '73277-101000' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.006640s ]
SELECT `id` FROM `stock` WHERE `id` <> 52508180 AND `partno` = '73277-101000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.004892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11603532 [ RunTime:0.000740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52506633 LIMIT 5 [ RunTime:0.004740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52506633 ORDER BY `minOrder` ASC [ RunTime:0.013878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52506633 ORDER BY `unit` DESC [ RunTime:0.014944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52506633 LIMIT 2 [ RunTime:0.007329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52506633 ORDER BY `minOrder` ASC [ RunTime:0.004809s ]
select * from pdf where partno='73277-101002' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.020490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '73277-101002' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.010979s ]
SELECT `id` FROM `stock` WHERE `id` <> 52506633 AND `partno` = '73277-101002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.008293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782529 [ RunTime:0.002097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52506520 LIMIT 5 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52506520 ORDER BY `minOrder` ASC [ RunTime:0.005572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52506520 ORDER BY `unit` DESC [ RunTime:0.009001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52506520 LIMIT 2 [ RunTime:0.020216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52506520 ORDER BY `minOrder` ASC [ RunTime:0.007390s ]
select * from pdf where partno='73277-101009' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.010785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '73277-101009' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.015392s ]
SELECT `id` FROM `stock` WHERE `id` <> 52506520 AND `partno` = '73277-101009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.017067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782453 [ RunTime:0.002786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52502340 LIMIT 5 [ RunTime:0.006414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52502340 ORDER BY `minOrder` ASC [ RunTime:0.002183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52502340 ORDER BY `unit` DESC [ RunTime:0.000675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52502340 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52502340 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='73277-101400LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '73277-101400LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002633s ]
SELECT `id` FROM `stock` WHERE `id` <> 52502340 AND `partno` = '73277-101400LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611242 [ RunTime:0.000626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51657499 LIMIT 5 [ RunTime:0.002291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51657499 ORDER BY `minOrder` ASC [ RunTime:0.003373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51657499 ORDER BY `unit` DESC [ RunTime:0.000615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51657499 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51657499 ORDER BY `minOrder` ASC [ RunTime:0.004705s ]
select * from pdf where partno='7327N' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.002744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327N' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.002786s ]
SELECT `id` FROM `stock` WHERE `id` <> 51657499 AND `partno` = '7327N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.001709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12170237 [ RunTime:0.000888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51241312 LIMIT 5 [ RunTime:0.001290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241312 ORDER BY `minOrder` ASC [ RunTime:0.001033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51241312 ORDER BY `unit` DESC [ RunTime:0.000846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51241312 LIMIT 2 [ RunTime:0.001149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241312 ORDER BY `minOrder` ASC [ RunTime:0.005453s ]
select * from pdf where partno='7327' and brandshort='JKL Components Corp.' limit 1 [ RunTime:0.003447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7327' OR `brand` LIKE 'JKL Components Corp.%' ) ) LIMIT 1 [ RunTime:0.010647s ]
SELECT `id` FROM `stock` WHERE `id` <> 51241312 AND `partno` = '7327' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jkl components corp.%' ) [ RunTime:0.001561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867569 [ RunTime:0.000432s ]
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 '7327%' OR `brand` LIKE '7327%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001285s ]
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 '7327%' OR `brand` LIKE '7327%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007955s ]
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 '7327%' OR `brand` LIKE '7327%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005949s ]
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 '7327%' OR `brand` LIKE '7327%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001155s ]
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 '7327%' OR `brand` LIKE '7327%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002289s ]
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 '7327%' OR `brand` LIKE '7327%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001530s ]
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 '7327%' OR `brand` LIKE '7327%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005006s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7327%' OR `brand` LIKE '7327%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013482s ]