SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001196s ]
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 '5905%' OR `brand` LIKE '5905%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011270s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430194 LIMIT 5 [ RunTime:0.014444s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430194 ORDER BY `minOrder` ASC [ RunTime:0.005455s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430194 ORDER BY `unit` DESC [ RunTime:0.010514s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430194 LIMIT 2 [ RunTime:0.012958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430194 ORDER BY `minOrder` ASC [ RunTime:0.001352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19523897 LIMIT 5 [ RunTime:0.016016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19523897 ORDER BY `minOrder` ASC [ RunTime:0.014742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19523897 ORDER BY `unit` DESC [ RunTime:0.008321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19523897 LIMIT 2 [ RunTime:0.015812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19523897 ORDER BY `minOrder` ASC [ RunTime:0.002181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13497598 LIMIT 5 [ RunTime:0.007191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13497598 ORDER BY `minOrder` ASC [ RunTime:0.004309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13497598 ORDER BY `unit` DESC [ RunTime:0.016066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13497598 LIMIT 2 [ RunTime:0.013294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13497598 ORDER BY `minOrder` ASC [ RunTime:0.006425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11412860 LIMIT 5 [ RunTime:0.011276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412860 ORDER BY `minOrder` ASC [ RunTime:0.016257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11412860 ORDER BY `unit` DESC [ RunTime:0.018357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11412860 LIMIT 2 [ RunTime:0.015844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412860 ORDER BY `minOrder` ASC [ RunTime:0.010729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17266207 LIMIT 5 [ RunTime:0.012903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17266207 ORDER BY `minOrder` ASC [ RunTime:0.004513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17266207 ORDER BY `unit` DESC [ RunTime:0.012611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17266207 LIMIT 2 [ RunTime:0.014622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17266207 ORDER BY `minOrder` ASC [ RunTime:0.010843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387555 LIMIT 5 [ RunTime:0.012495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387555 ORDER BY `minOrder` ASC [ RunTime:0.004424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387555 ORDER BY `unit` DESC [ RunTime:0.014934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387555 LIMIT 2 [ RunTime:0.009967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387555 ORDER BY `minOrder` ASC [ RunTime:0.001818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20080144 LIMIT 5 [ RunTime:0.006023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080144 ORDER BY `minOrder` ASC [ RunTime:0.001235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20080144 ORDER BY `unit` DESC [ RunTime:0.012645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20080144 LIMIT 2 [ RunTime:0.006326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080144 ORDER BY `minOrder` ASC [ RunTime:0.006684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719088 LIMIT 5 [ RunTime:0.002736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719088 ORDER BY `minOrder` ASC [ RunTime:0.003299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719088 ORDER BY `unit` DESC [ RunTime:0.013871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719088 LIMIT 2 [ RunTime:0.002038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719088 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17916018 LIMIT 5 [ RunTime:0.001352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17916018 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17916018 ORDER BY `unit` DESC [ RunTime:0.011613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17916018 LIMIT 2 [ RunTime:0.004743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17916018 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17915973 LIMIT 5 [ RunTime:0.002058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17915973 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17915973 ORDER BY `unit` DESC [ RunTime:0.008899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17915973 LIMIT 2 [ RunTime:0.003124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17915973 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17502049 LIMIT 5 [ RunTime:0.001172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17502049 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17502049 ORDER BY `unit` DESC [ RunTime:0.008864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17502049 LIMIT 2 [ RunTime:0.001746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17502049 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15548797 LIMIT 5 [ RunTime:0.001201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15548797 ORDER BY `minOrder` ASC [ RunTime:0.000658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15548797 ORDER BY `unit` DESC [ RunTime:0.011572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15548797 LIMIT 2 [ RunTime:0.001743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15548797 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396069 LIMIT 5 [ RunTime:0.003648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396069 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396069 ORDER BY `unit` DESC [ RunTime:0.017229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396069 LIMIT 2 [ RunTime:0.001756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396069 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396065 LIMIT 5 [ RunTime:0.002947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396065 ORDER BY `minOrder` ASC [ RunTime:0.002864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396065 ORDER BY `unit` DESC [ RunTime:0.011329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396065 LIMIT 2 [ RunTime:0.001869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396065 ORDER BY `minOrder` ASC [ RunTime:0.001945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396064 LIMIT 5 [ RunTime:0.003429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396064 ORDER BY `minOrder` ASC [ RunTime:0.002951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396064 ORDER BY `unit` DESC [ RunTime:0.010399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396064 LIMIT 2 [ RunTime:0.001735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396064 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396063 LIMIT 5 [ RunTime:0.001207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396063 ORDER BY `minOrder` ASC [ RunTime:0.001368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396063 ORDER BY `unit` DESC [ RunTime:0.009383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396063 LIMIT 2 [ RunTime:0.001915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396063 ORDER BY `minOrder` ASC [ RunTime:0.001523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396061 LIMIT 5 [ RunTime:0.000929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396061 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396061 ORDER BY `unit` DESC [ RunTime:0.009091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396061 LIMIT 2 [ RunTime:0.001762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396061 ORDER BY `minOrder` ASC [ RunTime:0.003947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396059 LIMIT 5 [ RunTime:0.001787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396059 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396059 ORDER BY `unit` DESC [ RunTime:0.009323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396059 LIMIT 2 [ RunTime:0.001880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396059 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396058 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396058 ORDER BY `minOrder` ASC [ RunTime:0.000667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396058 ORDER BY `unit` DESC [ RunTime:0.009330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396058 LIMIT 2 [ RunTime:0.001980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396058 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396057 LIMIT 5 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396057 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396057 ORDER BY `unit` DESC [ RunTime:0.006819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396057 LIMIT 2 [ RunTime:0.001626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396057 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
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 '5905%' OR `brand` LIKE '5905%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32307141 LIMIT 5 [ RunTime:0.002080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32307141 ORDER BY `minOrder` ASC [ RunTime:0.001969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32307141 ORDER BY `unit` DESC [ RunTime:0.006744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32307141 LIMIT 2 [ RunTime:0.001852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32307141 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
select * from pdf where partno='5905' and brandshort='adafruit' limit 1 [ RunTime:0.001535s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5905' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.004023s ]
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 '5905%' OR `brand` LIKE '5905%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997187 LIMIT 5 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997187 ORDER BY `minOrder` ASC [ RunTime:0.002438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997187 ORDER BY `unit` DESC [ RunTime:0.004990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997187 LIMIT 2 [ RunTime:0.001177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997187 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='5905C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5905C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001785s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997187 AND `partno` = '5905C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.004478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14374574 [ RunTime:0.000791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997198 LIMIT 5 [ RunTime:0.008292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997198 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997198 ORDER BY `unit` DESC [ RunTime:0.006308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997198 LIMIT 2 [ RunTime:0.001293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997198 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
select * from pdf where partno='5905C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5905C SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.003235s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997198 AND `partno` = '5905C SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.006276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13497598 [ RunTime:0.001543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58356855 LIMIT 5 [ RunTime:0.003413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58356855 ORDER BY `minOrder` ASC [ RunTime:0.005945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58356855 ORDER BY `unit` DESC [ RunTime:0.000530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58356855 LIMIT 2 [ RunTime:0.002017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58356855 ORDER BY `minOrder` ASC [ RunTime:0.000969s ]
select * from pdf where partno='59050-3-T-00-0' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59050-3-T-00-0' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58356816 LIMIT 5 [ RunTime:0.007220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58356816 ORDER BY `minOrder` ASC [ RunTime:0.005575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58356816 ORDER BY `unit` DESC [ RunTime:0.000674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58356816 LIMIT 2 [ RunTime:0.004980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58356816 ORDER BY `minOrder` ASC [ RunTime:0.001309s ]
select * from pdf where partno='59050-3-S-00-0' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59050-3-S-00-0' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57241638 LIMIT 5 [ RunTime:0.006324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241638 ORDER BY `minOrder` ASC [ RunTime:0.002988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57241638 ORDER BY `unit` DESC [ RunTime:0.010829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57241638 LIMIT 2 [ RunTime:0.004886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241638 ORDER BY `minOrder` ASC [ RunTime:0.004202s ]
select * from pdf where partno='5905' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5905' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.001624s ]
SELECT `id` FROM `stock` WHERE `id` <> 57241638 AND `partno` = '5905' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.003540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17266207 [ RunTime:0.003082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512685 LIMIT 5 [ RunTime:0.004087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512685 ORDER BY `minOrder` ASC [ RunTime:0.005422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512685 ORDER BY `unit` DESC [ RunTime:0.000821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512685 LIMIT 2 [ RunTime:0.006357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512685 ORDER BY `minOrder` ASC [ RunTime:0.003550s ]
select * from pdf where partno='59056-15-23PA' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.006604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59056-15-23PA' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.004287s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512685 AND `partno` = '59056-15-23PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.007021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512683 LIMIT 5 [ RunTime:0.003511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512683 ORDER BY `minOrder` ASC [ RunTime:0.006874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512683 ORDER BY `unit` DESC [ RunTime:0.005494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512683 LIMIT 2 [ RunTime:0.005402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512683 ORDER BY `minOrder` ASC [ RunTime:0.006495s ]
select * from pdf where partno='59052-25-35PN [V003]' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.002167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59052-25-35PN [V003]' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.004831s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512683 AND `partno` = '59052-25-35PN [V003]' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.007983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512604 LIMIT 5 [ RunTime:0.004371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512604 ORDER BY `minOrder` ASC [ RunTime:0.002857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512604 ORDER BY `unit` DESC [ RunTime:0.001756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512604 LIMIT 2 [ RunTime:0.006121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512604 ORDER BY `minOrder` ASC [ RunTime:0.001763s ]
select * from pdf where partno='59052-25-61PN [V003]' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.002211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59052-25-61PN [V003]' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.000930s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512604 AND `partno` = '59052-25-61PN [V003]' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.007205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512482 LIMIT 5 [ RunTime:0.003298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512482 ORDER BY `minOrder` ASC [ RunTime:0.002708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512482 ORDER BY `unit` DESC [ RunTime:0.003559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512482 LIMIT 2 [ RunTime:0.003893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512482 ORDER BY `minOrder` ASC [ RunTime:0.002790s ]
select * from pdf where partno='59051-25-29SA' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59051-25-29SA' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.003175s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512482 AND `partno` = '59051-25-29SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.003683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512470 LIMIT 5 [ RunTime:0.002305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512470 ORDER BY `minOrder` ASC [ RunTime:0.003280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512470 ORDER BY `unit` DESC [ RunTime:0.001505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512470 LIMIT 2 [ RunTime:0.002911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512470 ORDER BY `minOrder` ASC [ RunTime:0.002427s ]
select * from pdf where partno='59051-25-29SN' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.001112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59051-25-29SN' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.000931s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512470 AND `partno` = '59051-25-29SN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.006142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512465 LIMIT 5 [ RunTime:0.005829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512465 ORDER BY `minOrder` ASC [ RunTime:0.002304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512465 ORDER BY `unit` DESC [ RunTime:0.002507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512465 LIMIT 2 [ RunTime:0.003226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512465 ORDER BY `minOrder` ASC [ RunTime:0.001963s ]
select * from pdf where partno='59051-23-21SN' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.001289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59051-23-21SN' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.000685s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512465 AND `partno` = '59051-23-21SN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.003066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512442 LIMIT 5 [ RunTime:0.005042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512442 ORDER BY `minOrder` ASC [ RunTime:0.001138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512442 ORDER BY `unit` DESC [ RunTime:0.002761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512442 LIMIT 2 [ RunTime:0.002962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512442 ORDER BY `minOrder` ASC [ RunTime:0.001388s ]
select * from pdf where partno='59051-19-11SA' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.001478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59051-19-11SA' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.000718s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512442 AND `partno` = '59051-19-11SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.005934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512331 LIMIT 5 [ RunTime:0.003052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512331 ORDER BY `minOrder` ASC [ RunTime:0.004005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512331 ORDER BY `unit` DESC [ RunTime:0.006827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512331 LIMIT 2 [ RunTime:0.002598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512331 ORDER BY `minOrder` ASC [ RunTime:0.005286s ]
select * from pdf where partno='59059-11-04PN [V003]' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.005619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59059-11-04PN [V003]' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.002644s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512331 AND `partno` = '59059-11-04PN [V003]' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.003785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512330 LIMIT 5 [ RunTime:0.006565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512330 ORDER BY `minOrder` ASC [ RunTime:0.003810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512330 ORDER BY `unit` DESC [ RunTime:0.000660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512330 LIMIT 2 [ RunTime:0.002012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512330 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='59059-11-04PN [V004]' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59059-11-04PN [V004]' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.000493s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512330 AND `partno` = '59059-11-04PN [V004]' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.003292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512314 LIMIT 5 [ RunTime:0.006640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512314 ORDER BY `minOrder` ASC [ RunTime:0.002396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512314 ORDER BY `unit` DESC [ RunTime:0.005194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512314 LIMIT 2 [ RunTime:0.007104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512314 ORDER BY `minOrder` ASC [ RunTime:0.005403s ]
select * from pdf where partno='59059-11-04PD [V003]' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.005053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59059-11-04PD [V003]' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.007503s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512314 AND `partno` = '59059-11-04PD [V003]' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.005924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512313 LIMIT 5 [ RunTime:0.005203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512313 ORDER BY `minOrder` ASC [ RunTime:0.007036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512313 ORDER BY `unit` DESC [ RunTime:0.006323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512313 LIMIT 2 [ RunTime:0.002190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512313 ORDER BY `minOrder` ASC [ RunTime:0.004085s ]
select * from pdf where partno='59059-11-04PB [V003]' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.005494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59059-11-04PB [V003]' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.008527s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512313 AND `partno` = '59059-11-04PB [V003]' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.003991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512312 LIMIT 5 [ RunTime:0.008979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512312 ORDER BY `minOrder` ASC [ RunTime:0.003064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512312 ORDER BY `unit` DESC [ RunTime:0.003944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512312 LIMIT 2 [ RunTime:0.009998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512312 ORDER BY `minOrder` ASC [ RunTime:0.004110s ]
select * from pdf where partno='59059-11-04PA [V004]' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.005181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59059-11-04PA [V004]' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.000663s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512312 AND `partno` = '59059-11-04PA [V004]' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.013961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512311 LIMIT 5 [ RunTime:0.008115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512311 ORDER BY `minOrder` ASC [ RunTime:0.002536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512311 ORDER BY `unit` DESC [ RunTime:0.011029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512311 LIMIT 2 [ RunTime:0.010031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512311 ORDER BY `minOrder` ASC [ RunTime:0.005169s ]
select * from pdf where partno='59059-11-04PA' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.006543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59059-11-04PA' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.002735s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512311 AND `partno` = '59059-11-04PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512310 LIMIT 5 [ RunTime:0.004968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512310 ORDER BY `minOrder` ASC [ RunTime:0.012094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512310 ORDER BY `unit` DESC [ RunTime:0.004986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512310 LIMIT 2 [ RunTime:0.002483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512310 ORDER BY `minOrder` ASC [ RunTime:0.002632s ]
select * from pdf where partno='59059-11-04PC [V003]' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.006517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59059-11-04PC [V003]' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.005069s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512310 AND `partno` = '59059-11-04PC [V003]' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.010537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59512309 LIMIT 5 [ RunTime:0.009824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512309 ORDER BY `minOrder` ASC [ RunTime:0.005196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59512309 ORDER BY `unit` DESC [ RunTime:0.006346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59512309 LIMIT 2 [ RunTime:0.004158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59512309 ORDER BY `minOrder` ASC [ RunTime:0.002307s ]
select * from pdf where partno='59059-11-04PC' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.001301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59059-11-04PC' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.002167s ]
SELECT `id` FROM `stock` WHERE `id` <> 59512309 AND `partno` = '59059-11-04PC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.002875s ]
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 '5905%' OR `brand` LIKE '5905%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004960s ]
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 '5905%' OR `brand` LIKE '5905%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002905s ]
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 '5905%' OR `brand` LIKE '5905%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002135s ]
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 '5905%' OR `brand` LIKE '5905%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000561s ]
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 '5905%' OR `brand` LIKE '5905%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000568s ]
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 '5905%' OR `brand` LIKE '5905%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000543s ]
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 '5905%' OR `brand` LIKE '5905%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000587s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5905%' OR `brand` LIKE '5905%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000836s ]