SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003236s ]
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 'SN74ACT08D%' OR `brand` LIKE 'SN74ACT08D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006445s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16096003 LIMIT 5 [ RunTime:0.001597s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16096003 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16096003 ORDER BY `unit` DESC [ RunTime:0.000342s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16096003 LIMIT 2 [ RunTime:0.004008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16096003 ORDER BY `minOrder` ASC [ RunTime:0.003407s ]
select * from pdf where partno='SN74ACT08DRG3' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14236381 LIMIT 5 [ RunTime:0.000937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14236381 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14236381 ORDER BY `unit` DESC [ RunTime:0.002244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14236381 LIMIT 2 [ RunTime:0.003983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14236381 ORDER BY `minOrder` ASC [ RunTime:0.002222s ]
select * from pdf where partno='SN74ACT08DR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19189339 LIMIT 5 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19189339 ORDER BY `minOrder` ASC [ RunTime:0.002874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19189339 ORDER BY `unit` DESC [ RunTime:0.000366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19189339 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19189339 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
select * from pdf where partno='SN74ACT08DBR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21001 LIMIT 5 [ RunTime:0.010770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21001 ORDER BY `minOrder` ASC [ RunTime:0.004202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21001 ORDER BY `unit` DESC [ RunTime:0.006798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21001 LIMIT 2 [ RunTime:0.007155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21001 ORDER BY `minOrder` ASC [ RunTime:0.009426s ]
select * from pdf where partno='SN74ACT08DR' and brandshort='TI' limit 1 [ RunTime:0.000978s ]
select foldpath,foldpath2,filename from pdf_file where id=622260 limit 1 [ RunTime:0.005139s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DR' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.048768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19188000 LIMIT 5 [ RunTime:0.002823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19188000 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19188000 ORDER BY `unit` DESC [ RunTime:0.000683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19188000 LIMIT 2 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19188000 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='SN74ACT08DG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19187523 LIMIT 5 [ RunTime:0.010281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19187523 ORDER BY `minOrder` ASC [ RunTime:0.003008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19187523 ORDER BY `unit` DESC [ RunTime:0.015387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19187523 LIMIT 2 [ RunTime:0.007899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19187523 ORDER BY `minOrder` ASC [ RunTime:0.002923s ]
select * from pdf where partno='SN74ACT08DRG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19187522 LIMIT 5 [ RunTime:0.004944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19187522 ORDER BY `minOrder` ASC [ RunTime:0.011807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19187522 ORDER BY `unit` DESC [ RunTime:0.007908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19187522 LIMIT 2 [ RunTime:0.008332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19187522 ORDER BY `minOrder` ASC [ RunTime:0.013175s ]
select * from pdf where partno='SN74ACT08DRE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.009287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16097673 LIMIT 5 [ RunTime:0.001632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16097673 ORDER BY `minOrder` ASC [ RunTime:0.021155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16097673 ORDER BY `unit` DESC [ RunTime:0.003624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16097673 LIMIT 2 [ RunTime:0.007673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16097673 ORDER BY `minOrder` ASC [ RunTime:0.006262s ]
select * from pdf where partno='SN74ACT08D' and brandshort='Texas Instruments' limit 1 [ RunTime:0.010947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16096086 LIMIT 5 [ RunTime:0.012259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16096086 ORDER BY `minOrder` ASC [ RunTime:0.004422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16096086 ORDER BY `unit` DESC [ RunTime:0.018738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16096086 LIMIT 2 [ RunTime:0.003019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16096086 ORDER BY `minOrder` ASC [ RunTime:0.000226s ]
select * from pdf where partno='SN74ACT08DE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003800s ]
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 'SN74ACT08D%' OR `brand` LIKE 'SN74ACT08D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002119s ]
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 'SN74ACT08D%' OR `brand` LIKE 'SN74ACT08D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49976409 LIMIT 5 [ RunTime:0.005725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49976409 ORDER BY `minOrder` ASC [ RunTime:0.013166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49976409 ORDER BY `unit` DESC [ RunTime:0.001391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49976409 LIMIT 2 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49976409 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='SN74ACT08DRG3' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DRG3' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.011921s ]
SELECT `id` FROM `stock` WHERE `id` <> 49976409 AND `partno` = 'SN74ACT08DRG3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.030177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16096003 [ RunTime:0.000816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37172522 LIMIT 5 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37172522 ORDER BY `minOrder` ASC [ RunTime:0.009929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37172522 ORDER BY `unit` DESC [ RunTime:0.006550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37172522 LIMIT 2 [ RunTime:0.004880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37172522 ORDER BY `minOrder` ASC [ RunTime:0.006741s ]
select * from pdf where partno='SN74ACT08DRG3' and brandshort='Texas Instruments' limit 1 [ RunTime:0.006630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DRG3' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000838s ]
SELECT `id` FROM `stock` WHERE `id` <> 37172522 AND `partno` = 'SN74ACT08DRG3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.011556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16096003 [ RunTime:0.001899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37172342 LIMIT 5 [ RunTime:0.006692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37172342 ORDER BY `minOrder` ASC [ RunTime:0.013082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37172342 ORDER BY `unit` DESC [ RunTime:0.001025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37172342 LIMIT 2 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37172342 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='SN74ACT08DR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.008654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49976252 LIMIT 5 [ RunTime:0.007405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49976252 ORDER BY `minOrder` ASC [ RunTime:0.003009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49976252 ORDER BY `unit` DESC [ RunTime:0.000804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49976252 LIMIT 2 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49976252 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
select * from pdf where partno='SN74ACT08DR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.007764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49977956 LIMIT 5 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49977956 ORDER BY `minOrder` ASC [ RunTime:0.003063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49977956 ORDER BY `unit` DESC [ RunTime:0.000440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49977956 LIMIT 2 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49977956 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='SN74ACT08DBR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DBR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000382s ]
SELECT `id` FROM `stock` WHERE `id` <> 49977956 AND `partno` = 'SN74ACT08DBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.001178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19189339 [ RunTime:0.014887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37174071 LIMIT 5 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37174071 ORDER BY `minOrder` ASC [ RunTime:0.001295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37174071 ORDER BY `unit` DESC [ RunTime:0.011076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37174071 LIMIT 2 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37174071 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
select * from pdf where partno='SN74ACT08DBR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DBR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000264s ]
SELECT `id` FROM `stock` WHERE `id` <> 37174071 AND `partno` = 'SN74ACT08DBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.004285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19189339 [ RunTime:0.001322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49986313 LIMIT 5 [ RunTime:0.001187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49986313 ORDER BY `minOrder` ASC [ RunTime:0.005199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49986313 ORDER BY `unit` DESC [ RunTime:0.003463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49986313 LIMIT 2 [ RunTime:0.006242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49986313 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
select * from pdf where partno='SN74ACT08DG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000713s ]
SELECT `id` FROM `stock` WHERE `id` <> 49986313 AND `partno` = 'SN74ACT08DG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19188000 [ RunTime:0.004355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49985518 LIMIT 5 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49985518 ORDER BY `minOrder` ASC [ RunTime:0.001442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49985518 ORDER BY `unit` DESC [ RunTime:0.002409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49985518 LIMIT 2 [ RunTime:0.001848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49985518 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
select * from pdf where partno='SN74ACT08DRG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.002869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DRG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000954s ]
SELECT `id` FROM `stock` WHERE `id` <> 49985518 AND `partno` = 'SN74ACT08DRG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19187523 [ RunTime:0.002166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49985517 LIMIT 5 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49985517 ORDER BY `minOrder` ASC [ RunTime:0.000645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49985517 ORDER BY `unit` DESC [ RunTime:0.003324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49985517 LIMIT 2 [ RunTime:0.001649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49985517 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
select * from pdf where partno='SN74ACT08DRE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DRE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.001140s ]
SELECT `id` FROM `stock` WHERE `id` <> 49985517 AND `partno` = 'SN74ACT08DRE4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19187522 [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49980742 LIMIT 5 [ RunTime:0.010981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49980742 ORDER BY `minOrder` ASC [ RunTime:0.019608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49980742 ORDER BY `unit` DESC [ RunTime:0.006865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49980742 LIMIT 2 [ RunTime:0.017321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49980742 ORDER BY `minOrder` ASC [ RunTime:0.016104s ]
select * from pdf where partno='SN74ACT08D' and brandshort='Texas Instruments' limit 1 [ RunTime:0.004324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08D' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.011906s ]
SELECT `id` FROM `stock` WHERE `id` <> 49980742 AND `partno` = 'SN74ACT08D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.009686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16097673 [ RunTime:0.021794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37182479 LIMIT 5 [ RunTime:0.006336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37182479 ORDER BY `minOrder` ASC [ RunTime:0.021986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37182479 ORDER BY `unit` DESC [ RunTime:0.028212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37182479 LIMIT 2 [ RunTime:0.036441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37182479 ORDER BY `minOrder` ASC [ RunTime:0.053836s ]
select * from pdf where partno='SN74ACT08DG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.012522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.016685s ]
SELECT `id` FROM `stock` WHERE `id` <> 37182479 AND `partno` = 'SN74ACT08DG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.031461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19188000 [ RunTime:0.006449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37181667 LIMIT 5 [ RunTime:0.016285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37181667 ORDER BY `minOrder` ASC [ RunTime:0.017625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37181667 ORDER BY `unit` DESC [ RunTime:0.009465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37181667 LIMIT 2 [ RunTime:0.006046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37181667 ORDER BY `minOrder` ASC [ RunTime:0.027442s ]
select * from pdf where partno='SN74ACT08DRG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DRG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.005613s ]
SELECT `id` FROM `stock` WHERE `id` <> 37181667 AND `partno` = 'SN74ACT08DRG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19187523 [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37181666 LIMIT 5 [ RunTime:0.001902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37181666 ORDER BY `minOrder` ASC [ RunTime:0.003693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37181666 ORDER BY `unit` DESC [ RunTime:0.003359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37181666 LIMIT 2 [ RunTime:0.009964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37181666 ORDER BY `minOrder` ASC [ RunTime:0.002298s ]
select * from pdf where partno='SN74ACT08DRE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.002792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08DRE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.001953s ]
SELECT `id` FROM `stock` WHERE `id` <> 37181666 AND `partno` = 'SN74ACT08DRE4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.019670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19187522 [ RunTime:0.004337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37176953 LIMIT 5 [ RunTime:0.000982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37176953 ORDER BY `minOrder` ASC [ RunTime:0.001050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37176953 ORDER BY `unit` DESC [ RunTime:0.004257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37176953 LIMIT 2 [ RunTime:0.021496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37176953 ORDER BY `minOrder` ASC [ RunTime:0.001021s ]
select * from pdf where partno='SN74ACT08D' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74ACT08D' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.009522s ]
SELECT `id` FROM `stock` WHERE `id` <> 37176953 AND `partno` = 'SN74ACT08D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.008769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16097673 [ RunTime:0.002955s ]
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 'SN74ACT08D%' OR `brand` LIKE 'SN74ACT08D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023017s ]
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 'SN74ACT08D%' OR `brand` LIKE 'SN74ACT08D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013901s ]
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 'SN74ACT08D%' OR `brand` LIKE 'SN74ACT08D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002792s ]
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 'SN74ACT08D%' OR `brand` LIKE 'SN74ACT08D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001041s ]
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 'SN74ACT08D%' OR `brand` LIKE 'SN74ACT08D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001330s ]
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 'SN74ACT08D%' OR `brand` LIKE 'SN74ACT08D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001051s ]
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 'SN74ACT08D%' OR `brand` LIKE 'SN74ACT08D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001305s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SN74ACT08D%' OR `brand` LIKE 'SN74ACT08D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001245s ]