SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002592s ]
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 'MEB1-128S%' OR `brand` LIKE 'MEB1-128S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040595s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11670531 LIMIT 5 [ RunTime:0.016411s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670531 ORDER BY `minOrder` ASC [ RunTime:0.046328s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11670531 ORDER BY `unit` DESC [ RunTime:0.017196s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11670531 LIMIT 2 [ RunTime:0.054530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670531 ORDER BY `minOrder` ASC [ RunTime:0.010941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11670528 LIMIT 5 [ RunTime:0.046026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670528 ORDER BY `minOrder` ASC [ RunTime:0.028469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11670528 ORDER BY `unit` DESC [ RunTime:0.028560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11670528 LIMIT 2 [ RunTime:0.040723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670528 ORDER BY `minOrder` ASC [ RunTime:0.075503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11670527 LIMIT 5 [ RunTime:0.039452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670527 ORDER BY `minOrder` ASC [ RunTime:0.073723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11670527 ORDER BY `unit` DESC [ RunTime:0.010609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11670527 LIMIT 2 [ RunTime:0.065906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670527 ORDER BY `minOrder` ASC [ RunTime:0.008209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11670526 LIMIT 5 [ RunTime:0.052640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670526 ORDER BY `minOrder` ASC [ RunTime:0.018890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11670526 ORDER BY `unit` DESC [ RunTime:0.031439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11670526 LIMIT 2 [ RunTime:0.026366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670526 ORDER BY `minOrder` ASC [ RunTime:0.000916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11670525 LIMIT 5 [ RunTime:0.022380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670525 ORDER BY `minOrder` ASC [ RunTime:0.005835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11670525 ORDER BY `unit` DESC [ RunTime:0.008667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11670525 LIMIT 2 [ RunTime:0.012028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670525 ORDER BY `minOrder` ASC [ RunTime:0.026158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11670524 LIMIT 5 [ RunTime:0.029005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670524 ORDER BY `minOrder` ASC [ RunTime:0.021003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11670524 ORDER BY `unit` DESC [ RunTime:0.014111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11670524 LIMIT 2 [ RunTime:0.010818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670524 ORDER BY `minOrder` ASC [ RunTime:0.008397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11670520 LIMIT 5 [ RunTime:0.038304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670520 ORDER BY `minOrder` ASC [ RunTime:0.003337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11670520 ORDER BY `unit` DESC [ RunTime:0.022559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11670520 LIMIT 2 [ RunTime:0.010021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11670520 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749922 LIMIT 5 [ RunTime:0.018267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749922 ORDER BY `minOrder` ASC [ RunTime:0.012928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749922 ORDER BY `unit` DESC [ RunTime:0.003138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749922 LIMIT 2 [ RunTime:0.001016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749922 ORDER BY `minOrder` ASC [ RunTime:0.002470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749921 LIMIT 5 [ RunTime:0.013388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749921 ORDER BY `minOrder` ASC [ RunTime:0.029750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749921 ORDER BY `unit` DESC [ RunTime:0.034959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749921 LIMIT 2 [ RunTime:0.014429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749921 ORDER BY `minOrder` ASC [ RunTime:0.004749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749917 LIMIT 5 [ RunTime:0.003768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749917 ORDER BY `minOrder` ASC [ RunTime:0.002346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749917 ORDER BY `unit` DESC [ RunTime:0.007751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749917 LIMIT 2 [ RunTime:0.012948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749917 ORDER BY `minOrder` ASC [ RunTime:0.027779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749910 LIMIT 5 [ RunTime:0.015315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749910 ORDER BY `minOrder` ASC [ RunTime:0.010935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749910 ORDER BY `unit` DESC [ RunTime:0.032746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749910 LIMIT 2 [ RunTime:0.007972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749910 ORDER BY `minOrder` ASC [ RunTime:0.003008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749906 LIMIT 5 [ RunTime:0.005291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749906 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749906 ORDER BY `unit` DESC [ RunTime:0.001300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749906 LIMIT 2 [ RunTime:0.001165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749906 ORDER BY `minOrder` ASC [ RunTime:0.001217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749905 LIMIT 5 [ RunTime:0.004791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749905 ORDER BY `minOrder` ASC [ RunTime:0.028403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749905 ORDER BY `unit` DESC [ RunTime:0.009709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749905 LIMIT 2 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749905 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749904 LIMIT 5 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749904 ORDER BY `minOrder` ASC [ RunTime:0.000987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749904 ORDER BY `unit` DESC [ RunTime:0.002952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749904 LIMIT 2 [ RunTime:0.007071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749904 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749900 LIMIT 5 [ RunTime:0.001087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749900 ORDER BY `minOrder` ASC [ RunTime:0.000684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749900 ORDER BY `unit` DESC [ RunTime:0.001449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749900 LIMIT 2 [ RunTime:0.005776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749900 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749899 LIMIT 5 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749899 ORDER BY `minOrder` ASC [ RunTime:0.000678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749899 ORDER BY `unit` DESC [ RunTime:0.009629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749899 LIMIT 2 [ RunTime:0.003565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749899 ORDER BY `minOrder` ASC [ RunTime:0.001410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749897 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749897 ORDER BY `minOrder` ASC [ RunTime:0.001940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749897 ORDER BY `unit` DESC [ RunTime:0.001766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749897 LIMIT 2 [ RunTime:0.004014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749897 ORDER BY `minOrder` ASC [ RunTime:0.006577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749889 LIMIT 5 [ RunTime:0.001224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749889 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749889 ORDER BY `unit` DESC [ RunTime:0.008984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749889 LIMIT 2 [ RunTime:0.013006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749889 ORDER BY `minOrder` ASC [ RunTime:0.005071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749885 LIMIT 5 [ RunTime:0.013733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749885 ORDER BY `minOrder` ASC [ RunTime:0.007021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749885 ORDER BY `unit` DESC [ RunTime:0.002826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749885 LIMIT 2 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749885 ORDER BY `minOrder` ASC [ RunTime:0.001114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749881 LIMIT 5 [ RunTime:0.006166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749881 ORDER BY `minOrder` ASC [ RunTime:0.000813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749881 ORDER BY `unit` DESC [ RunTime:0.000721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749881 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749881 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
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 'MEB1-128S%' OR `brand` LIKE 'MEB1-128S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002432s ]
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 'MEB1-128S%' OR `brand` LIKE 'MEB1-128S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55122248 LIMIT 5 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122248 ORDER BY `minOrder` ASC [ RunTime:0.000877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55122248 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55122248 LIMIT 2 [ RunTime:0.004500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122248 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='MEB1-128S' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.003653s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128S' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.004536s ]
SELECT `id` FROM `stock` WHERE `id` <> 55122248 AND `partno` = 'MEB1-128S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.011673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749870 [ RunTime:0.004957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52485587 LIMIT 5 [ RunTime:0.013809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52485587 ORDER BY `minOrder` ASC [ RunTime:0.012832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52485587 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52485587 LIMIT 2 [ RunTime:0.006347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52485587 ORDER BY `minOrder` ASC [ RunTime:0.002387s ]
select * from pdf where partno='MEB1-128SH18K' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.012540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SH18K' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.018016s ]
SELECT `id` FROM `stock` WHERE `id` <> 52485587 AND `partno` = 'MEB1-128SH18K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.022727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749906 [ RunTime:0.000698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52485586 LIMIT 5 [ RunTime:0.004562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52485586 ORDER BY `minOrder` ASC [ RunTime:0.002876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52485586 ORDER BY `unit` DESC [ RunTime:0.001080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52485586 LIMIT 2 [ RunTime:0.003741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52485586 ORDER BY `minOrder` ASC [ RunTime:0.003376s ]
select * from pdf where partno='MEB1-128SH15' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.003493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SH15' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.008918s ]
SELECT `id` FROM `stock` WHERE `id` <> 52485586 AND `partno` = 'MEB1-128SH15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.000767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749900 [ RunTime:0.002312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869902 LIMIT 5 [ RunTime:0.005597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869902 ORDER BY `minOrder` ASC [ RunTime:0.005549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869902 ORDER BY `unit` DESC [ RunTime:0.004818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869902 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869902 ORDER BY `minOrder` ASC [ RunTime:0.000671s ]
select * from pdf where partno='MEB1-128SS14K' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.004576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SS14K' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.024729s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869902 AND `partno` = 'MEB1-128SS14K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.070354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749922 [ RunTime:0.040567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869901 LIMIT 5 [ RunTime:0.036054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869901 ORDER BY `minOrder` ASC [ RunTime:0.011748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869901 ORDER BY `unit` DESC [ RunTime:0.028991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869901 LIMIT 2 [ RunTime:0.012209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869901 ORDER BY `minOrder` ASC [ RunTime:0.001404s ]
select * from pdf where partno='MEB1-128SS13' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.009935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SS13' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.007471s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869901 AND `partno` = 'MEB1-128SS13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.049316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749921 [ RunTime:0.036420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869900 LIMIT 5 [ RunTime:0.025262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869900 ORDER BY `minOrder` ASC [ RunTime:0.028691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869900 ORDER BY `unit` DESC [ RunTime:0.009900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869900 LIMIT 2 [ RunTime:0.007612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869900 ORDER BY `minOrder` ASC [ RunTime:0.001144s ]
select * from pdf where partno='MEB1-128SH36' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.018745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SH36' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.022285s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869900 AND `partno` = 'MEB1-128SH36' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.040141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749917 [ RunTime:0.023141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869893 LIMIT 5 [ RunTime:0.027605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869893 ORDER BY `minOrder` ASC [ RunTime:0.081506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869893 ORDER BY `unit` DESC [ RunTime:0.029169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869893 LIMIT 2 [ RunTime:0.026252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869893 ORDER BY `minOrder` ASC [ RunTime:0.003140s ]
select * from pdf where partno='MEB1-128SH3' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.020066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SH3' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.016119s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869893 AND `partno` = 'MEB1-128SH3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.051324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749910 [ RunTime:0.048542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869891 LIMIT 5 [ RunTime:0.059576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869891 ORDER BY `minOrder` ASC [ RunTime:0.073153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869891 ORDER BY `unit` DESC [ RunTime:0.014668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869891 LIMIT 2 [ RunTime:0.026642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869891 ORDER BY `minOrder` ASC [ RunTime:0.067571s ]
select * from pdf where partno='MEB1-128SH33' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.131075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SH33' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.078798s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869891 AND `partno` = 'MEB1-128SH33' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.078710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749905 [ RunTime:0.070012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869890 LIMIT 5 [ RunTime:0.048089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869890 ORDER BY `minOrder` ASC [ RunTime:0.007470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869890 ORDER BY `unit` DESC [ RunTime:0.152798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869890 LIMIT 2 [ RunTime:0.092412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869890 ORDER BY `minOrder` ASC [ RunTime:0.001622s ]
select * from pdf where partno='MEB1-128SBRP' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.066619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SBRP' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.051117s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869890 AND `partno` = 'MEB1-128SBRP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.074399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749904 [ RunTime:0.179722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869887 LIMIT 5 [ RunTime:0.027473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869887 ORDER BY `minOrder` ASC [ RunTime:0.104485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869887 ORDER BY `unit` DESC [ RunTime:0.012501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869887 LIMIT 2 [ RunTime:0.086627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869887 ORDER BY `minOrder` ASC [ RunTime:0.015060s ]
select * from pdf where partno='MEB1-128SH042' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.023633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SH042' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.033484s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869887 AND `partno` = 'MEB1-128SH042' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.049868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749899 [ RunTime:0.027142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869885 LIMIT 5 [ RunTime:0.029071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869885 ORDER BY `minOrder` ASC [ RunTime:0.023731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869885 ORDER BY `unit` DESC [ RunTime:0.030751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869885 LIMIT 2 [ RunTime:0.053140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869885 ORDER BY `minOrder` ASC [ RunTime:0.017768s ]
select * from pdf where partno='MEB1-128SBR' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.020348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SBR' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.036224s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869885 AND `partno` = 'MEB1-128SBR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.015789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749897 [ RunTime:0.008565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869881 LIMIT 5 [ RunTime:0.001829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869881 ORDER BY `minOrder` ASC [ RunTime:0.001919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869881 ORDER BY `unit` DESC [ RunTime:0.000458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869881 LIMIT 2 [ RunTime:0.002302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869881 ORDER BY `minOrder` ASC [ RunTime:0.014363s ]
select * from pdf where partno='MEB1-128SHY01' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.011359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SHY01' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.011608s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869881 AND `partno` = 'MEB1-128SHY01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.009933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11670531 [ RunTime:0.015197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869876 LIMIT 5 [ RunTime:0.020777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869876 ORDER BY `minOrder` ASC [ RunTime:0.012890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869876 ORDER BY `unit` DESC [ RunTime:0.035783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869876 LIMIT 2 [ RunTime:0.015097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869876 ORDER BY `minOrder` ASC [ RunTime:0.017719s ]
select * from pdf where partno='MEB1-128SH13' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.006504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SH13' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.018262s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869876 AND `partno` = 'MEB1-128SH13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.023770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749889 [ RunTime:0.005773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869873 LIMIT 5 [ RunTime:0.020611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869873 ORDER BY `minOrder` ASC [ RunTime:0.025447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869873 ORDER BY `unit` DESC [ RunTime:0.025312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869873 LIMIT 2 [ RunTime:0.042646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869873 ORDER BY `minOrder` ASC [ RunTime:0.012051s ]
select * from pdf where partno='MEB1-128SH8' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.006777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SH8' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.008048s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869873 AND `partno` = 'MEB1-128SH8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.023847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749885 [ RunTime:0.009363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869872 LIMIT 5 [ RunTime:0.022356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869872 ORDER BY `minOrder` ASC [ RunTime:0.025607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869872 ORDER BY `unit` DESC [ RunTime:0.024247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869872 LIMIT 2 [ RunTime:0.031347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869872 ORDER BY `minOrder` ASC [ RunTime:0.014771s ]
select * from pdf where partno='MEB1-128SP-1' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.023598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SP-1' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.017998s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869872 AND `partno` = 'MEB1-128SP-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.020804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11670528 [ RunTime:0.011164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869871 LIMIT 5 [ RunTime:0.006957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869871 ORDER BY `minOrder` ASC [ RunTime:0.012958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869871 ORDER BY `unit` DESC [ RunTime:0.041724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869871 LIMIT 2 [ RunTime:0.042951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869871 ORDER BY `minOrder` ASC [ RunTime:0.004193s ]
select * from pdf where partno='MEB1-128SH32' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.023908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SH32' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.010471s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869871 AND `partno` = 'MEB1-128SH32' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.023561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11670527 [ RunTime:0.039460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869870 LIMIT 5 [ RunTime:0.023742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869870 ORDER BY `minOrder` ASC [ RunTime:0.028928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869870 ORDER BY `unit` DESC [ RunTime:0.018643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869870 LIMIT 2 [ RunTime:0.079923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869870 ORDER BY `minOrder` ASC [ RunTime:0.026428s ]
select * from pdf where partno='MEB1-128SH003' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.021977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SH003' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.025154s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869870 AND `partno` = 'MEB1-128SH003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.024613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11670526 [ RunTime:0.028635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869868 LIMIT 5 [ RunTime:0.033798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869868 ORDER BY `minOrder` ASC [ RunTime:0.040042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869868 ORDER BY `unit` DESC [ RunTime:0.018497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869868 LIMIT 2 [ RunTime:0.014913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869868 ORDER BY `minOrder` ASC [ RunTime:0.023896s ]
select * from pdf where partno='MEB1-128SH001' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.012683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SH001' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.039215s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869868 AND `partno` = 'MEB1-128SH001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.050163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749881 [ RunTime:0.051873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869864 LIMIT 5 [ RunTime:0.035410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869864 ORDER BY `minOrder` ASC [ RunTime:0.048926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869864 ORDER BY `unit` DESC [ RunTime:0.006213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869864 LIMIT 2 [ RunTime:0.031972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869864 ORDER BY `minOrder` ASC [ RunTime:0.013582s ]
select * from pdf where partno='MEB1-128SBRP-1' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.012236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SBRP-1' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.036959s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869864 AND `partno` = 'MEB1-128SBRP-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.034289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749875 [ RunTime:0.034368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869862 LIMIT 5 [ RunTime:0.031381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869862 ORDER BY `minOrder` ASC [ RunTime:0.023123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869862 ORDER BY `unit` DESC [ RunTime:0.013753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869862 LIMIT 2 [ RunTime:0.041447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869862 ORDER BY `minOrder` ASC [ RunTime:0.008276s ]
select * from pdf where partno='MEB1-128SL94' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.073012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEB1-128SL94' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.091497s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869862 AND `partno` = 'MEB1-128SL94' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.054517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749873 [ RunTime:0.043453s ]
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 'MEB1-128S%' OR `brand` LIKE 'MEB1-128S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029911s ]
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 'MEB1-128S%' OR `brand` LIKE 'MEB1-128S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028362s ]
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 'MEB1-128S%' OR `brand` LIKE 'MEB1-128S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027266s ]
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 'MEB1-128S%' OR `brand` LIKE 'MEB1-128S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009678s ]
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 'MEB1-128S%' OR `brand` LIKE 'MEB1-128S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011612s ]
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 'MEB1-128S%' OR `brand` LIKE 'MEB1-128S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027569s ]
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 'MEB1-128S%' OR `brand` LIKE 'MEB1-128S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016242s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MEB1-128S%' OR `brand` LIKE 'MEB1-128S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010246s ]