SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002359s ]
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 'ADS7841E%' OR `brand` LIKE 'ADS7841E%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022363s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16137098 LIMIT 5 [ RunTime:0.010993s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16137098 ORDER BY `minOrder` ASC [ RunTime:0.014089s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.026500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16137098 ORDER BY `unit` DESC [ RunTime:0.018093s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16137098 LIMIT 2 [ RunTime:0.012331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16137098 ORDER BY `minOrder` ASC [ RunTime:0.027208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17135017 LIMIT 5 [ RunTime:0.030480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17135017 ORDER BY `minOrder` ASC [ RunTime:0.009290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17135017 ORDER BY `unit` DESC [ RunTime:0.013128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17135017 LIMIT 2 [ RunTime:0.017377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17135017 ORDER BY `minOrder` ASC [ RunTime:0.009669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17134607 LIMIT 5 [ RunTime:0.018770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17134607 ORDER BY `minOrder` ASC [ RunTime:0.007711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17134607 ORDER BY `unit` DESC [ RunTime:0.010089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17134607 LIMIT 2 [ RunTime:0.018515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17134607 ORDER BY `minOrder` ASC [ RunTime:0.003651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15353837 LIMIT 5 [ RunTime:0.058431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15353837 ORDER BY `minOrder` ASC [ RunTime:0.044294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15353837 ORDER BY `unit` DESC [ RunTime:0.019580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15353837 LIMIT 2 [ RunTime:0.017121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15353837 ORDER BY `minOrder` ASC [ RunTime:0.005692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16137122 LIMIT 5 [ RunTime:0.017492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16137122 ORDER BY `minOrder` ASC [ RunTime:0.016317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16137122 ORDER BY `unit` DESC [ RunTime:0.010422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16137122 LIMIT 2 [ RunTime:0.029563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16137122 ORDER BY `minOrder` ASC [ RunTime:0.010250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16140084 LIMIT 5 [ RunTime:0.008199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16140084 ORDER BY `minOrder` ASC [ RunTime:0.013453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16140084 ORDER BY `unit` DESC [ RunTime:0.017676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16140084 LIMIT 2 [ RunTime:0.027165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16140084 ORDER BY `minOrder` ASC [ RunTime:0.007856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17136525 LIMIT 5 [ RunTime:0.009771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17136525 ORDER BY `minOrder` ASC [ RunTime:0.011862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17136525 ORDER BY `unit` DESC [ RunTime:0.030878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17136525 LIMIT 2 [ RunTime:0.020623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17136525 ORDER BY `minOrder` ASC [ RunTime:0.016303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16141325 LIMIT 5 [ RunTime:0.005275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16141325 ORDER BY `minOrder` ASC [ RunTime:0.008118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16141325 ORDER BY `unit` DESC [ RunTime:0.013388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16141325 LIMIT 2 [ RunTime:0.003267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16141325 ORDER BY `minOrder` ASC [ RunTime:0.006075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16141023 LIMIT 5 [ RunTime:0.046183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16141023 ORDER BY `minOrder` ASC [ RunTime:0.011248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16141023 ORDER BY `unit` DESC [ RunTime:0.005634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16141023 LIMIT 2 [ RunTime:0.002690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16141023 ORDER BY `minOrder` ASC [ RunTime:0.005089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16140930 LIMIT 5 [ RunTime:0.032413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16140930 ORDER BY `minOrder` ASC [ RunTime:0.037266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16140930 ORDER BY `unit` DESC [ RunTime:0.016917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16140930 LIMIT 2 [ RunTime:0.012306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16140930 ORDER BY `minOrder` ASC [ RunTime:0.007589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15355730 LIMIT 5 [ RunTime:0.039628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15355730 ORDER BY `minOrder` ASC [ RunTime:0.008104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15355730 ORDER BY `unit` DESC [ RunTime:0.000657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15355730 LIMIT 2 [ RunTime:0.004569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15355730 ORDER BY `minOrder` ASC [ RunTime:0.008914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15355710 LIMIT 5 [ RunTime:0.021221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15355710 ORDER BY `minOrder` ASC [ RunTime:0.000874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15355710 ORDER BY `unit` DESC [ RunTime:0.000627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15355710 LIMIT 2 [ RunTime:0.005379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15355710 ORDER BY `minOrder` ASC [ RunTime:0.002368s ]
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 'ADS7841E%' OR `brand` LIKE 'ADS7841E%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018335s ]
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 'ADS7841E%' OR `brand` LIKE 'ADS7841E%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63755443 LIMIT 5 [ RunTime:0.003332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63755443 ORDER BY `minOrder` ASC [ RunTime:0.005297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63755443 ORDER BY `unit` DESC [ RunTime:0.003296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63755443 LIMIT 2 [ RunTime:0.001530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63755443 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='ADS7841E/2K5' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001758s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841E/2K5' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.003698s ]
SELECT `id` FROM `stock` WHERE `id` <> 63755443 AND `partno` = 'ADS7841E/2K5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16137098 [ RunTime:0.013687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63758835 LIMIT 5 [ RunTime:0.006622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63758835 ORDER BY `minOrder` ASC [ RunTime:0.013077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63758835 ORDER BY `unit` DESC [ RunTime:0.010359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63758835 LIMIT 2 [ RunTime:0.006471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63758835 ORDER BY `minOrder` ASC [ RunTime:0.005301s ]
select * from pdf where partno='ADS7841ESQDBQRQ1' and brandshort='Texas Instruments' limit 1 [ RunTime:0.007006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841ESQDBQRQ1' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.005542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63755444 LIMIT 5 [ RunTime:0.006423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63755444 ORDER BY `minOrder` ASC [ RunTime:0.007104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63755444 ORDER BY `unit` DESC [ RunTime:0.004327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63755444 LIMIT 2 [ RunTime:0.013977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63755444 ORDER BY `minOrder` ASC [ RunTime:0.008562s ]
select * from pdf where partno='ADS7841EB/2K5' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841EB/2K5' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63755490 LIMIT 5 [ RunTime:0.000813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63755490 ORDER BY `minOrder` ASC [ RunTime:0.006374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63755490 ORDER BY `unit` DESC [ RunTime:0.000681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63755490 LIMIT 2 [ RunTime:0.011414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63755490 ORDER BY `minOrder` ASC [ RunTime:0.001777s ]
select * from pdf where partno='ADS7841EB' and brandshort='Texas Instruments' limit 1 [ RunTime:0.004125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841EB' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.005397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63759682 LIMIT 5 [ RunTime:0.001358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63759682 ORDER BY `minOrder` ASC [ RunTime:0.003086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63759682 ORDER BY `unit` DESC [ RunTime:0.003385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63759682 LIMIT 2 [ RunTime:0.002576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63759682 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='ADS7841E' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841E' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000847s ]
SELECT `id` FROM `stock` WHERE `id` <> 63759682 AND `partno` = 'ADS7841E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16137122 [ RunTime:0.002741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63760415 LIMIT 5 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63760415 ORDER BY `minOrder` ASC [ RunTime:0.002619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63760415 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63760415 LIMIT 2 [ RunTime:0.007261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63760415 ORDER BY `minOrder` ASC [ RunTime:0.001630s ]
select * from pdf where partno='ADS7841ES' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841ES' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.006693s ]
SELECT `id` FROM `stock` WHERE `id` <> 63760415 AND `partno` = 'ADS7841ES' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.006154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16140084 [ RunTime:0.000516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63761996 LIMIT 5 [ RunTime:0.004374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63761996 ORDER BY `minOrder` ASC [ RunTime:0.003181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63761996 ORDER BY `unit` DESC [ RunTime:0.002557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63761996 LIMIT 2 [ RunTime:0.001437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63761996 ORDER BY `minOrder` ASC [ RunTime:0.004819s ]
select * from pdf where partno='ADS7841EIDBQRQ1' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841EIDBQRQ1' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.002899s ]
SELECT `id` FROM `stock` WHERE `id` <> 63761996 AND `partno` = 'ADS7841EIDBQRQ1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.007718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16141325 [ RunTime:0.001274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63761376 LIMIT 5 [ RunTime:0.001689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63761376 ORDER BY `minOrder` ASC [ RunTime:0.014647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63761376 ORDER BY `unit` DESC [ RunTime:0.009575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63761376 LIMIT 2 [ RunTime:0.009142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63761376 ORDER BY `minOrder` ASC [ RunTime:0.015294s ]
select * from pdf where partno='ADS7841EG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.009143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841EG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.013008s ]
SELECT `id` FROM `stock` WHERE `id` <> 63761376 AND `partno` = 'ADS7841EG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.001965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17136525 [ RunTime:0.004308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63761221 LIMIT 5 [ RunTime:0.008002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63761221 ORDER BY `minOrder` ASC [ RunTime:0.015098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63761221 ORDER BY `unit` DESC [ RunTime:0.012051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63761221 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63761221 ORDER BY `minOrder` ASC [ RunTime:0.002136s ]
select * from pdf where partno='ADS7841ESG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.004035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841ESG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000627s ]
SELECT `id` FROM `stock` WHERE `id` <> 63761221 AND `partno` = 'ADS7841ESG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16141023 [ RunTime:0.002430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63761076 LIMIT 5 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63761076 ORDER BY `minOrder` ASC [ RunTime:0.008106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63761076 ORDER BY `unit` DESC [ RunTime:0.012063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63761076 LIMIT 2 [ RunTime:0.002409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63761076 ORDER BY `minOrder` ASC [ RunTime:0.002713s ]
select * from pdf where partno='ADS7841ES/2K5G4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841ES/2K5G4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.002629s ]
SELECT `id` FROM `stock` WHERE `id` <> 63761076 AND `partno` = 'ADS7841ES/2K5G4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.004647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15355730 [ RunTime:0.001055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63761075 LIMIT 5 [ RunTime:0.001838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63761075 ORDER BY `minOrder` ASC [ RunTime:0.007608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63761075 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63761075 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63761075 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
select * from pdf where partno='ADS7841ES/2K5' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841ES/2K5' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.006008s ]
SELECT `id` FROM `stock` WHERE `id` <> 63761075 AND `partno` = 'ADS7841ES/2K5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.031659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16140930 [ RunTime:0.004115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63760993 LIMIT 5 [ RunTime:0.004554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63760993 ORDER BY `minOrder` ASC [ RunTime:0.002246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63760993 ORDER BY `unit` DESC [ RunTime:0.002171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63760993 LIMIT 2 [ RunTime:0.000269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63760993 ORDER BY `minOrder` ASC [ RunTime:0.000171s ]
select * from pdf where partno='ADS7841E/2K5G4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADS7841E/2K5G4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.005010s ]
SELECT `id` FROM `stock` WHERE `id` <> 63760993 AND `partno` = 'ADS7841E/2K5G4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.007820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15355710 [ RunTime:0.011699s ]
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 'ADS7841E%' OR `brand` LIKE 'ADS7841E%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003671s ]
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 'ADS7841E%' OR `brand` LIKE 'ADS7841E%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009561s ]
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 'ADS7841E%' OR `brand` LIKE 'ADS7841E%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001832s ]
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 'ADS7841E%' OR `brand` LIKE 'ADS7841E%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001466s ]
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 'ADS7841E%' OR `brand` LIKE 'ADS7841E%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013261s ]
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 'ADS7841E%' OR `brand` LIKE 'ADS7841E%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002807s ]
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 'ADS7841E%' OR `brand` LIKE 'ADS7841E%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002689s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ADS7841E%' OR `brand` LIKE 'ADS7841E%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002298s ]