SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001263s ]
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 'BB17%' OR `brand` LIKE 'BB17%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003832s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577001 LIMIT 5 [ RunTime:0.000831s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577001 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18577001 ORDER BY `unit` DESC [ RunTime:0.012106s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18577001 LIMIT 2 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577001 ORDER BY `minOrder` ASC [ RunTime:0.006291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18576998 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18576998 ORDER BY `minOrder` ASC [ RunTime:0.002412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18576998 ORDER BY `unit` DESC [ RunTime:0.003565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18576998 LIMIT 2 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18576998 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16962832 LIMIT 5 [ RunTime:0.004884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16962832 ORDER BY `minOrder` ASC [ RunTime:0.001845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16962832 ORDER BY `unit` DESC [ RunTime:0.010448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16962832 LIMIT 2 [ RunTime:0.022141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16962832 ORDER BY `minOrder` ASC [ RunTime:0.001689s ]
select * from pdf where partno='BB174X' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.009715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577189 LIMIT 5 [ RunTime:0.038192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577189 ORDER BY `minOrder` ASC [ RunTime:0.021897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18577189 ORDER BY `unit` DESC [ RunTime:0.017469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18577189 LIMIT 2 [ RunTime:0.028421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577189 ORDER BY `minOrder` ASC [ RunTime:0.020779s ]
select * from pdf where partno='BB175X' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.017695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 22804 LIMIT 5 [ RunTime:0.031785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 22804 ORDER BY `minOrder` ASC [ RunTime:0.012549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 22804 ORDER BY `unit` DESC [ RunTime:0.035962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 22804 LIMIT 2 [ RunTime:0.024723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 22804 ORDER BY `minOrder` ASC [ RunTime:0.013333s ]
select * from pdf where partno='BB173X(4)' and brandshort='NXP' limit 1 [ RunTime:0.023268s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB173X(4)' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.039757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 22060 LIMIT 5 [ RunTime:0.033336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 22060 ORDER BY `minOrder` ASC [ RunTime:0.027050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 22060 ORDER BY `unit` DESC [ RunTime:0.012490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 22060 LIMIT 2 [ RunTime:0.016671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 22060 ORDER BY `minOrder` ASC [ RunTime:0.009636s ]
select * from pdf where partno='BB174' and brandshort='NXP' limit 1 [ RunTime:0.021908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB174' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.032825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368084 LIMIT 5 [ RunTime:0.011536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368084 ORDER BY `minOrder` ASC [ RunTime:0.013353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13368084 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13368084 LIMIT 2 [ RunTime:0.004092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368084 ORDER BY `minOrder` ASC [ RunTime:0.018088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368086 LIMIT 5 [ RunTime:0.002166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368086 ORDER BY `minOrder` ASC [ RunTime:0.002586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13368086 ORDER BY `unit` DESC [ RunTime:0.005279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13368086 LIMIT 2 [ RunTime:0.007851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368086 ORDER BY `minOrder` ASC [ RunTime:0.011956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12078459 LIMIT 5 [ RunTime:0.012771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12078459 ORDER BY `minOrder` ASC [ RunTime:0.003305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12078459 ORDER BY `unit` DESC [ RunTime:0.023271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12078459 LIMIT 2 [ RunTime:0.004265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12078459 ORDER BY `minOrder` ASC [ RunTime:0.002637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368085 LIMIT 5 [ RunTime:0.009174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368085 ORDER BY `minOrder` ASC [ RunTime:0.007076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13368085 ORDER BY `unit` DESC [ RunTime:0.027877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13368085 LIMIT 2 [ RunTime:0.014386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368085 ORDER BY `minOrder` ASC [ RunTime:0.007595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368087 LIMIT 5 [ RunTime:0.008836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368087 ORDER BY `minOrder` ASC [ RunTime:0.015196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13368087 ORDER BY `unit` DESC [ RunTime:0.009844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13368087 LIMIT 2 [ RunTime:0.018769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368087 ORDER BY `minOrder` ASC [ RunTime:0.003535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12078458 LIMIT 5 [ RunTime:0.002547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12078458 ORDER BY `minOrder` ASC [ RunTime:0.002235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12078458 ORDER BY `unit` DESC [ RunTime:0.014077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12078458 LIMIT 2 [ RunTime:0.010797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12078458 ORDER BY `minOrder` ASC [ RunTime:0.005162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368088 LIMIT 5 [ RunTime:0.012177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368088 ORDER BY `minOrder` ASC [ RunTime:0.016769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13368088 ORDER BY `unit` DESC [ RunTime:0.002685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13368088 LIMIT 2 [ RunTime:0.010977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13368088 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577440 LIMIT 5 [ RunTime:0.002369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577440 ORDER BY `minOrder` ASC [ RunTime:0.004615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18577440 ORDER BY `unit` DESC [ RunTime:0.014123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18577440 LIMIT 2 [ RunTime:0.024390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577440 ORDER BY `minOrder` ASC [ RunTime:0.010022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577439 LIMIT 5 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577439 ORDER BY `minOrder` ASC [ RunTime:0.002374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18577439 ORDER BY `unit` DESC [ RunTime:0.003244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18577439 LIMIT 2 [ RunTime:0.007342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577439 ORDER BY `minOrder` ASC [ RunTime:0.001875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577438 LIMIT 5 [ RunTime:0.007684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577438 ORDER BY `minOrder` ASC [ RunTime:0.012685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18577438 ORDER BY `unit` DESC [ RunTime:0.015757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18577438 LIMIT 2 [ RunTime:0.021254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577438 ORDER BY `minOrder` ASC [ RunTime:0.006764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577431 LIMIT 5 [ RunTime:0.005883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577431 ORDER BY `minOrder` ASC [ RunTime:0.012014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18577431 ORDER BY `unit` DESC [ RunTime:0.015622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18577431 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577431 ORDER BY `minOrder` ASC [ RunTime:0.000233s ]
select * from pdf where partno='BB179B,335' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.017516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577430 LIMIT 5 [ RunTime:0.005268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577430 ORDER BY `minOrder` ASC [ RunTime:0.001909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18577430 ORDER BY `unit` DESC [ RunTime:0.009948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18577430 LIMIT 2 [ RunTime:0.007164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577430 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
select * from pdf where partno='BB179B,135' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.004202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577429 LIMIT 5 [ RunTime:0.025525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577429 ORDER BY `minOrder` ASC [ RunTime:0.001185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18577429 ORDER BY `unit` DESC [ RunTime:0.000554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18577429 LIMIT 2 [ RunTime:0.006292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577429 ORDER BY `minOrder` ASC [ RunTime:0.011632s ]
select * from pdf where partno='BB179,315' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.018710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577414 LIMIT 5 [ RunTime:0.012929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577414 ORDER BY `minOrder` ASC [ RunTime:0.013860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18577414 ORDER BY `unit` DESC [ RunTime:0.011037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18577414 LIMIT 2 [ RunTime:0.020426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577414 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
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 'BB17%' OR `brand` LIKE 'BB17%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51097652 LIMIT 5 [ RunTime:0.008410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097652 ORDER BY `minOrder` ASC [ RunTime:0.001156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51097652 ORDER BY `unit` DESC [ RunTime:0.000820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51097652 LIMIT 2 [ RunTime:0.005796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097652 ORDER BY `minOrder` ASC [ RunTime:0.001151s ]
select * from pdf where partno='bb170-g' and brandshort='busboard prototype systems' limit 1 [ RunTime:0.005981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bb170-g' OR `brand` LIKE 'busboard prototype systems%' ) ) LIMIT 1 [ RunTime:0.013440s ]
SELECT `id` FROM `stock` WHERE `id` <> 51097652 AND `partno` = 'bb170-g' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.005106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51097682 LIMIT 5 [ RunTime:0.010197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097682 ORDER BY `minOrder` ASC [ RunTime:0.009812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51097682 ORDER BY `unit` DESC [ RunTime:0.003172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51097682 LIMIT 2 [ RunTime:0.010096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097682 ORDER BY `minOrder` ASC [ RunTime:0.014081s ]
select * from pdf where partno='bb170-blu' and brandshort='busboard prototype systems' limit 1 [ RunTime:0.006924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bb170-blu' OR `brand` LIKE 'busboard prototype systems%' ) ) LIMIT 1 [ RunTime:0.009382s ]
SELECT `id` FROM `stock` WHERE `id` <> 51097682 AND `partno` = 'bb170-blu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.009697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51097727 LIMIT 5 [ RunTime:0.021176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097727 ORDER BY `minOrder` ASC [ RunTime:0.011830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51097727 ORDER BY `unit` DESC [ RunTime:0.011887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51097727 LIMIT 2 [ RunTime:0.018361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097727 ORDER BY `minOrder` ASC [ RunTime:0.006438s ]
select * from pdf where partno='bb170-y' and brandshort='busboard prototype systems' limit 1 [ RunTime:0.012377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bb170-y' OR `brand` LIKE 'busboard prototype systems%' ) ) LIMIT 1 [ RunTime:0.003392s ]
SELECT `id` FROM `stock` WHERE `id` <> 51097727 AND `partno` = 'bb170-y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.018428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51097701 LIMIT 5 [ RunTime:0.008956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097701 ORDER BY `minOrder` ASC [ RunTime:0.018852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51097701 ORDER BY `unit` DESC [ RunTime:0.014685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51097701 LIMIT 2 [ RunTime:0.024025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097701 ORDER BY `minOrder` ASC [ RunTime:0.001293s ]
select * from pdf where partno='bb170-r' and brandshort='busboard prototype systems' limit 1 [ RunTime:0.002956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bb170-r' OR `brand` LIKE 'busboard prototype systems%' ) ) LIMIT 1 [ RunTime:0.000698s ]
SELECT `id` FROM `stock` WHERE `id` <> 51097701 AND `partno` = 'bb170-r' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.005686s ]
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 'BB17%' OR `brand` LIKE 'BB17%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63525995 LIMIT 5 [ RunTime:0.002031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63525995 ORDER BY `minOrder` ASC [ RunTime:0.012792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63525995 ORDER BY `unit` DESC [ RunTime:0.013220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63525995 LIMIT 2 [ RunTime:0.013012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63525995 ORDER BY `minOrder` ASC [ RunTime:0.028246s ]
select * from pdf where partno='BB170-BK' and brandshort='BusBoard Prototype Systems' limit 1 [ RunTime:0.014101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB170-BK' OR `brand` LIKE 'BusBoard Prototype Systems%' ) ) LIMIT 1 [ RunTime:0.013411s ]
SELECT `id` FROM `stock` WHERE `id` <> 63525995 AND `partno` = 'BB170-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.009191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12078459 [ RunTime:0.012533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63525996 LIMIT 5 [ RunTime:0.024627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63525996 ORDER BY `minOrder` ASC [ RunTime:0.038267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63525996 ORDER BY `unit` DESC [ RunTime:0.037306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63525996 LIMIT 2 [ RunTime:0.007273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63525996 ORDER BY `minOrder` ASC [ RunTime:0.013558s ]
select * from pdf where partno='BB170-WH' and brandshort='BusBoard Prototype Systems' limit 1 [ RunTime:0.005026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB170-WH' OR `brand` LIKE 'BusBoard Prototype Systems%' ) ) LIMIT 1 [ RunTime:0.011959s ]
SELECT `id` FROM `stock` WHERE `id` <> 63525996 AND `partno` = 'BB170-WH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.015980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368089 [ RunTime:0.035498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63525997 LIMIT 5 [ RunTime:0.017337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63525997 ORDER BY `minOrder` ASC [ RunTime:0.032816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63525997 ORDER BY `unit` DESC [ RunTime:0.043401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63525997 LIMIT 2 [ RunTime:0.045078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63525997 ORDER BY `minOrder` ASC [ RunTime:0.013012s ]
select * from pdf where partno='BB170-YW' and brandshort='BusBoard Prototype Systems' limit 1 [ RunTime:0.026001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB170-YW' OR `brand` LIKE 'BusBoard Prototype Systems%' ) ) LIMIT 1 [ RunTime:0.010265s ]
SELECT `id` FROM `stock` WHERE `id` <> 63525997 AND `partno` = 'BB170-YW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.018446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368087 [ RunTime:0.006055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58207433 LIMIT 5 [ RunTime:0.004822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207433 ORDER BY `minOrder` ASC [ RunTime:0.017110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58207433 ORDER BY `unit` DESC [ RunTime:0.026130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58207433 LIMIT 2 [ RunTime:0.008977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207433 ORDER BY `minOrder` ASC [ RunTime:0.008753s ]
select * from pdf where partno='BB17' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB17' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.031451s ]
SELECT `id` FROM `stock` WHERE `id` <> 58207433 AND `partno` = 'BB17' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.021316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63526055 LIMIT 5 [ RunTime:0.011483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526055 ORDER BY `minOrder` ASC [ RunTime:0.026596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63526055 ORDER BY `unit` DESC [ RunTime:0.017018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63526055 LIMIT 2 [ RunTime:0.049590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526055 ORDER BY `minOrder` ASC [ RunTime:0.024423s ]
select * from pdf where partno='BB170-GR' and brandshort='BusBoard Prototype Systems' limit 1 [ RunTime:0.038105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB170-GR' OR `brand` LIKE 'BusBoard Prototype Systems%' ) ) LIMIT 1 [ RunTime:0.017463s ]
SELECT `id` FROM `stock` WHERE `id` <> 63526055 AND `partno` = 'BB170-GR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.014268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368084 [ RunTime:0.031381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63526056 LIMIT 5 [ RunTime:0.031416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526056 ORDER BY `minOrder` ASC [ RunTime:0.006233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63526056 ORDER BY `unit` DESC [ RunTime:0.007186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63526056 LIMIT 2 [ RunTime:0.014026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526056 ORDER BY `minOrder` ASC [ RunTime:0.010013s ]
select * from pdf where partno='BB170-OR' and brandshort='BusBoard Prototype Systems' limit 1 [ RunTime:0.017639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB170-OR' OR `brand` LIKE 'BusBoard Prototype Systems%' ) ) LIMIT 1 [ RunTime:0.008025s ]
SELECT `id` FROM `stock` WHERE `id` <> 63526056 AND `partno` = 'BB170-OR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.006014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368086 [ RunTime:0.014660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63526057 LIMIT 5 [ RunTime:0.002859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526057 ORDER BY `minOrder` ASC [ RunTime:0.012181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63526057 ORDER BY `unit` DESC [ RunTime:0.014442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63526057 LIMIT 2 [ RunTime:0.032345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526057 ORDER BY `minOrder` ASC [ RunTime:0.010678s ]
select * from pdf where partno='BB170-RD' and brandshort='BusBoard Prototype Systems' limit 1 [ RunTime:0.013883s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB170-RD' OR `brand` LIKE 'BusBoard Prototype Systems%' ) ) LIMIT 1 [ RunTime:0.003331s ]
SELECT `id` FROM `stock` WHERE `id` <> 63526057 AND `partno` = 'BB170-RD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.008882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12078458 [ RunTime:0.001165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63526058 LIMIT 5 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526058 ORDER BY `minOrder` ASC [ RunTime:0.009742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63526058 ORDER BY `unit` DESC [ RunTime:0.006189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63526058 LIMIT 2 [ RunTime:0.003234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526058 ORDER BY `minOrder` ASC [ RunTime:0.004434s ]
select * from pdf where partno='BB170-T' and brandshort='BusBoard Prototype Systems' limit 1 [ RunTime:0.015552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB170-T' OR `brand` LIKE 'BusBoard Prototype Systems%' ) ) LIMIT 1 [ RunTime:0.001127s ]
SELECT `id` FROM `stock` WHERE `id` <> 63526058 AND `partno` = 'BB170-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.012862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368085 [ RunTime:0.014425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63526059 LIMIT 5 [ RunTime:0.005275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526059 ORDER BY `minOrder` ASC [ RunTime:0.000645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63526059 ORDER BY `unit` DESC [ RunTime:0.003459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63526059 LIMIT 2 [ RunTime:0.006277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526059 ORDER BY `minOrder` ASC [ RunTime:0.002056s ]
select * from pdf where partno='BB170-BL' and brandshort='BusBoard Prototype Systems' limit 1 [ RunTime:0.006646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB170-BL' OR `brand` LIKE 'BusBoard Prototype Systems%' ) ) LIMIT 1 [ RunTime:0.011008s ]
SELECT `id` FROM `stock` WHERE `id` <> 63526059 AND `partno` = 'BB170-BL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%busboard prototype systems%' ) [ RunTime:0.004840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13368088 [ RunTime:0.015267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58623556 LIMIT 5 [ RunTime:0.014641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623556 ORDER BY `minOrder` ASC [ RunTime:0.023535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58623556 ORDER BY `unit` DESC [ RunTime:0.008875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58623556 LIMIT 2 [ RunTime:0.007372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623556 ORDER BY `minOrder` ASC [ RunTime:0.028789s ]
select * from pdf where partno='BB173X' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.037703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB173X' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.016826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58623555 LIMIT 5 [ RunTime:0.020108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623555 ORDER BY `minOrder` ASC [ RunTime:0.014398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58623555 ORDER BY `unit` DESC [ RunTime:0.045845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58623555 LIMIT 2 [ RunTime:0.031641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623555 ORDER BY `minOrder` ASC [ RunTime:0.020524s ]
select * from pdf where partno='BB174X' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.010305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB174X' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.030805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58623512 LIMIT 5 [ RunTime:0.031357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623512 ORDER BY `minOrder` ASC [ RunTime:0.021402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58623512 ORDER BY `unit` DESC [ RunTime:0.013790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58623512 LIMIT 2 [ RunTime:0.028026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623512 ORDER BY `minOrder` ASC [ RunTime:0.013073s ]
select * from pdf where partno='BB178,115' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.016289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB178,115' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.010432s ]
SELECT `id` FROM `stock` WHERE `id` <> 58623512 AND `partno` = 'BB178,115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp usa inc.%' ) [ RunTime:0.008418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577281 [ RunTime:0.017082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58623509 LIMIT 5 [ RunTime:0.027488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623509 ORDER BY `minOrder` ASC [ RunTime:0.020575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58623509 ORDER BY `unit` DESC [ RunTime:0.013847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58623509 LIMIT 2 [ RunTime:0.035997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623509 ORDER BY `minOrder` ASC [ RunTime:0.015263s ]
select * from pdf where partno='BB179BLX,315' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.011141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB179BLX,315' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.021870s ]
SELECT `id` FROM `stock` WHERE `id` <> 58623509 AND `partno` = 'BB179BLX,315' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp usa inc.%' ) [ RunTime:0.025589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577303 [ RunTime:0.056941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58623501 LIMIT 5 [ RunTime:0.018559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623501 ORDER BY `minOrder` ASC [ RunTime:0.057945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58623501 ORDER BY `unit` DESC [ RunTime:0.015170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58623501 LIMIT 2 [ RunTime:0.042346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623501 ORDER BY `minOrder` ASC [ RunTime:0.030285s ]
select * from pdf where partno='BB179B,115' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.013759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB179B,115' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.019048s ]
SELECT `id` FROM `stock` WHERE `id` <> 58623501 AND `partno` = 'BB179B,115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp usa inc.%' ) [ RunTime:0.016694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577279 [ RunTime:0.013293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58623485 LIMIT 5 [ RunTime:0.028083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623485 ORDER BY `minOrder` ASC [ RunTime:0.016526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58623485 ORDER BY `unit` DESC [ RunTime:0.019154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58623485 LIMIT 2 [ RunTime:0.024744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58623485 ORDER BY `minOrder` ASC [ RunTime:0.018777s ]
select * from pdf where partno='BB179,115' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.035739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB179,115' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.003093s ]
SELECT `id` FROM `stock` WHERE `id` <> 58623485 AND `partno` = 'BB179,115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp usa inc.%' ) [ RunTime:0.031041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577269 [ RunTime:0.012298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51758529 LIMIT 5 [ RunTime:0.008309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51758529 ORDER BY `minOrder` ASC [ RunTime:0.012223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51758529 ORDER BY `unit` DESC [ RunTime:0.005856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51758529 LIMIT 2 [ RunTime:0.005437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51758529 ORDER BY `minOrder` ASC [ RunTime:0.003492s ]
select * from pdf where partno='BB174LXX' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.002474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB174LXX' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.011131s ]
SELECT `id` FROM `stock` WHERE `id` <> 51758529 AND `partno` = 'BB174LXX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp usa inc.%' ) [ RunTime:0.004724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51758528 LIMIT 5 [ RunTime:0.011100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51758528 ORDER BY `minOrder` ASC [ RunTime:0.017741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51758528 ORDER BY `unit` DESC [ RunTime:0.014213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51758528 LIMIT 2 [ RunTime:0.017010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51758528 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='BB173LXX' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.012185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB173LXX' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.002149s ]
SELECT `id` FROM `stock` WHERE `id` <> 51758528 AND `partno` = 'BB173LXX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp usa inc.%' ) [ RunTime:0.010106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577438 [ RunTime:0.002884s ]
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 'BB17%' OR `brand` LIKE 'BB17%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003348s ]
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 'BB17%' OR `brand` LIKE 'BB17%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011456s ]
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 'BB17%' OR `brand` LIKE 'BB17%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013821s ]
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 'BB17%' OR `brand` LIKE 'BB17%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002584s ]
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 'BB17%' OR `brand` LIKE 'BB17%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004300s ]
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 'BB17%' OR `brand` LIKE 'BB17%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005731s ]
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 'BB17%' OR `brand` LIKE 'BB17%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039603s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BB17%' OR `brand` LIKE 'BB17%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007241s ]