SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001167s ]
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 'ZWS240BP-24%' OR `brand` LIKE 'ZWS240BP-24%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037631s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12103162 LIMIT 5 [ RunTime:0.047074s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12103162 ORDER BY `minOrder` ASC [ RunTime:0.005084s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.029642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12103162 ORDER BY `unit` DESC [ RunTime:0.034397s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12103162 LIMIT 2 [ RunTime:0.044284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12103162 ORDER BY `minOrder` ASC [ RunTime:0.014243s ]
select * from pdf where partno='ZWS240BP-24' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.036950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12106568 LIMIT 5 [ RunTime:0.033645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12106568 ORDER BY `minOrder` ASC [ RunTime:0.064337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12106568 ORDER BY `unit` DESC [ RunTime:0.015849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12106568 LIMIT 2 [ RunTime:0.013412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12106568 ORDER BY `minOrder` ASC [ RunTime:0.007971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12082046 LIMIT 5 [ RunTime:0.014047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12082046 ORDER BY `minOrder` ASC [ RunTime:0.018282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12082046 ORDER BY `unit` DESC [ RunTime:0.011667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12082046 LIMIT 2 [ RunTime:0.104123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12082046 ORDER BY `minOrder` ASC [ RunTime:0.012102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12087004 LIMIT 5 [ RunTime:0.063306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087004 ORDER BY `minOrder` ASC [ RunTime:0.046202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12087004 ORDER BY `unit` DESC [ RunTime:0.054752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12087004 LIMIT 2 [ RunTime:0.013182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087004 ORDER BY `minOrder` ASC [ RunTime:0.028133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12087000 LIMIT 5 [ RunTime:0.017877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087000 ORDER BY `minOrder` ASC [ RunTime:0.012954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12087000 ORDER BY `unit` DESC [ RunTime:0.014322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12087000 LIMIT 2 [ RunTime:0.066987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087000 ORDER BY `minOrder` ASC [ RunTime:0.004944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12082048 LIMIT 5 [ RunTime:0.045309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12082048 ORDER BY `minOrder` ASC [ RunTime:0.018393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12082048 ORDER BY `unit` DESC [ RunTime:0.023867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12082048 LIMIT 2 [ RunTime:0.046125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12082048 ORDER BY `minOrder` ASC [ RunTime:0.010306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11131042 LIMIT 5 [ RunTime:0.017731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11131042 ORDER BY `minOrder` ASC [ RunTime:0.023581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11131042 ORDER BY `unit` DESC [ RunTime:0.025654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11131042 LIMIT 2 [ RunTime:0.022021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11131042 ORDER BY `minOrder` ASC [ RunTime:0.018331s ]
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 'ZWS240BP-24%' OR `brand` LIKE 'ZWS240BP-24%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024105s ]
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 'ZWS240BP-24%' OR `brand` LIKE 'ZWS240BP-24%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41584879 LIMIT 5 [ RunTime:0.032073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41584879 ORDER BY `minOrder` ASC [ RunTime:0.024041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41584879 ORDER BY `unit` DESC [ RunTime:0.047463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41584879 LIMIT 2 [ RunTime:0.027642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41584879 ORDER BY `minOrder` ASC [ RunTime:0.002460s ]
select * from pdf where partno='ZWS240BP-24' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.013422s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZWS240BP-24' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.022616s ]
SELECT `id` FROM `stock` WHERE `id` <> 41584879 AND `partno` = 'ZWS240BP-24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.026740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12103162 [ RunTime:0.037104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41597883 LIMIT 5 [ RunTime:0.017769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41597883 ORDER BY `minOrder` ASC [ RunTime:0.024927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41597883 ORDER BY `unit` DESC [ RunTime:0.040681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41597883 LIMIT 2 [ RunTime:0.043183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41597883 ORDER BY `minOrder` ASC [ RunTime:0.008736s ]
select * from pdf where partno='ZWS240BP-24/R' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.053879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZWS240BP-24/R' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.015077s ]
SELECT `id` FROM `stock` WHERE `id` <> 41597883 AND `partno` = 'ZWS240BP-24/R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.005633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41597887 LIMIT 5 [ RunTime:0.030484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41597887 ORDER BY `minOrder` ASC [ RunTime:0.030648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41597887 ORDER BY `unit` DESC [ RunTime:0.012300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41597887 LIMIT 2 [ RunTime:0.033635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41597887 ORDER BY `minOrder` ASC [ RunTime:0.048728s ]
select * from pdf where partno='ZWS240BP-24/TA' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.019974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZWS240BP-24/TA' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.011985s ]
SELECT `id` FROM `stock` WHERE `id` <> 41597887 AND `partno` = 'ZWS240BP-24/TA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.014278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12106568 [ RunTime:0.040227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41600744 LIMIT 5 [ RunTime:0.047641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41600744 ORDER BY `minOrder` ASC [ RunTime:0.051775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41600744 ORDER BY `unit` DESC [ RunTime:0.032052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41600744 LIMIT 2 [ RunTime:0.005279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41600744 ORDER BY `minOrder` ASC [ RunTime:0.021250s ]
select * from pdf where partno='ZWS240BP-24/A' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.032242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZWS240BP-24/A' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.014330s ]
SELECT `id` FROM `stock` WHERE `id` <> 41600744 AND `partno` = 'ZWS240BP-24/A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.052603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12082048 [ RunTime:0.027951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41614429 LIMIT 5 [ RunTime:0.070483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41614429 ORDER BY `minOrder` ASC [ RunTime:0.022417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41614429 ORDER BY `unit` DESC [ RunTime:0.069584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41614429 LIMIT 2 [ RunTime:0.007793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41614429 ORDER BY `minOrder` ASC [ RunTime:0.022529s ]
select * from pdf where partno='ZWS240BP-24/T' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.047799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZWS240BP-24/T' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.044914s ]
SELECT `id` FROM `stock` WHERE `id` <> 41614429 AND `partno` = 'ZWS240BP-24/T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.017296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12082046 [ RunTime:0.041708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41637556 LIMIT 5 [ RunTime:0.087805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41637556 ORDER BY `minOrder` ASC [ RunTime:0.077467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41637556 ORDER BY `unit` DESC [ RunTime:0.083808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41637556 LIMIT 2 [ RunTime:0.061501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41637556 ORDER BY `minOrder` ASC [ RunTime:0.001707s ]
select * from pdf where partno='ZWS240BP-24/CO2' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.056069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZWS240BP-24/CO2' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.041086s ]
SELECT `id` FROM `stock` WHERE `id` <> 41637556 AND `partno` = 'ZWS240BP-24/CO2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.053288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11131042 [ RunTime:0.054543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41637357 LIMIT 5 [ RunTime:0.028087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41637357 ORDER BY `minOrder` ASC [ RunTime:0.090525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41637357 ORDER BY `unit` DESC [ RunTime:0.089567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41637357 LIMIT 2 [ RunTime:0.036282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41637357 ORDER BY `minOrder` ASC [ RunTime:0.045271s ]
select * from pdf where partno='ZWS240BP-24/TL' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.024185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZWS240BP-24/TL' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.047635s ]
SELECT `id` FROM `stock` WHERE `id` <> 41637357 AND `partno` = 'ZWS240BP-24/TL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.070012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12087004 [ RunTime:0.048951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41637353 LIMIT 5 [ RunTime:0.011075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41637353 ORDER BY `minOrder` ASC [ RunTime:0.045625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41637353 ORDER BY `unit` DESC [ RunTime:0.031075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41637353 LIMIT 2 [ RunTime:0.011390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41637353 ORDER BY `minOrder` ASC [ RunTime:0.003278s ]
select * from pdf where partno='ZWS240BP-24/L' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.012123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZWS240BP-24/L' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.013429s ]
SELECT `id` FROM `stock` WHERE `id` <> 41637353 AND `partno` = 'ZWS240BP-24/L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.020577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12087000 [ RunTime:0.002087s ]
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 'ZWS240BP-24%' OR `brand` LIKE 'ZWS240BP-24%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011684s ]
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 'ZWS240BP-24%' OR `brand` LIKE 'ZWS240BP-24%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020287s ]
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 'ZWS240BP-24%' OR `brand` LIKE 'ZWS240BP-24%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006718s ]
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 'ZWS240BP-24%' OR `brand` LIKE 'ZWS240BP-24%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009657s ]
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 'ZWS240BP-24%' OR `brand` LIKE 'ZWS240BP-24%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014548s ]
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 'ZWS240BP-24%' OR `brand` LIKE 'ZWS240BP-24%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018808s ]
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 'ZWS240BP-24%' OR `brand` LIKE 'ZWS240BP-24%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002429s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ZWS240BP-24%' OR `brand` LIKE 'ZWS240BP-24%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007231s ]