SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002749s ]
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 '40C24-P250%' OR `brand` LIKE '40C24-P250%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029253s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652103 LIMIT 5 [ RunTime:0.040138s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652103 ORDER BY `minOrder` ASC [ RunTime:0.052332s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652103 ORDER BY `unit` DESC [ RunTime:0.024497s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652103 LIMIT 2 [ RunTime:0.069326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652103 ORDER BY `minOrder` ASC [ RunTime:0.028649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652102 LIMIT 5 [ RunTime:0.012456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652102 ORDER BY `minOrder` ASC [ RunTime:0.025183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652102 ORDER BY `unit` DESC [ RunTime:0.013816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652102 LIMIT 2 [ RunTime:0.029829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652102 ORDER BY `minOrder` ASC [ RunTime:0.025031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652094 LIMIT 5 [ RunTime:0.107191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652094 ORDER BY `minOrder` ASC [ RunTime:0.098938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652094 ORDER BY `unit` DESC [ RunTime:0.142337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652094 LIMIT 2 [ RunTime:0.051928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652094 ORDER BY `minOrder` ASC [ RunTime:0.019361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652093 LIMIT 5 [ RunTime:0.042558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652093 ORDER BY `minOrder` ASC [ RunTime:0.073930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652093 ORDER BY `unit` DESC [ RunTime:0.064707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652093 LIMIT 2 [ RunTime:0.076258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652093 ORDER BY `minOrder` ASC [ RunTime:0.015254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652089 LIMIT 5 [ RunTime:0.031000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652089 ORDER BY `minOrder` ASC [ RunTime:0.029397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652089 ORDER BY `unit` DESC [ RunTime:0.018137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652089 LIMIT 2 [ RunTime:0.077017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652089 ORDER BY `minOrder` ASC [ RunTime:0.014140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652082 LIMIT 5 [ RunTime:0.052466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652082 ORDER BY `minOrder` ASC [ RunTime:0.026315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652082 ORDER BY `unit` DESC [ RunTime:0.039329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652082 LIMIT 2 [ RunTime:0.054626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652082 ORDER BY `minOrder` ASC [ RunTime:0.034754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652080 LIMIT 5 [ RunTime:0.018828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652080 ORDER BY `minOrder` ASC [ RunTime:0.042461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652080 ORDER BY `unit` DESC [ RunTime:0.067609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652080 LIMIT 2 [ RunTime:0.043598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652080 ORDER BY `minOrder` ASC [ RunTime:0.011419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652079 LIMIT 5 [ RunTime:0.028367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652079 ORDER BY `minOrder` ASC [ RunTime:0.026854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652079 ORDER BY `unit` DESC [ RunTime:0.043651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652079 LIMIT 2 [ RunTime:0.016671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652079 ORDER BY `minOrder` ASC [ RunTime:0.019326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652074 LIMIT 5 [ RunTime:0.054010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652074 ORDER BY `minOrder` ASC [ RunTime:0.011626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652074 ORDER BY `unit` DESC [ RunTime:0.014102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652074 LIMIT 2 [ RunTime:0.041857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652074 ORDER BY `minOrder` ASC [ RunTime:0.026348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652073 LIMIT 5 [ RunTime:0.092358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652073 ORDER BY `minOrder` ASC [ RunTime:0.053947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652073 ORDER BY `unit` DESC [ RunTime:0.068201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652073 LIMIT 2 [ RunTime:0.031574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652073 ORDER BY `minOrder` ASC [ RunTime:0.051756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652069 LIMIT 5 [ RunTime:0.033085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652069 ORDER BY `minOrder` ASC [ RunTime:0.080560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652069 ORDER BY `unit` DESC [ RunTime:0.029538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652069 LIMIT 2 [ RunTime:0.043230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652069 ORDER BY `minOrder` ASC [ RunTime:0.064689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652068 LIMIT 5 [ RunTime:0.016068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652068 ORDER BY `minOrder` ASC [ RunTime:0.025162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652068 ORDER BY `unit` DESC [ RunTime:0.033378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652068 LIMIT 2 [ RunTime:0.027711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652068 ORDER BY `minOrder` ASC [ RunTime:0.001254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652066 LIMIT 5 [ RunTime:0.004967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652066 ORDER BY `minOrder` ASC [ RunTime:0.023316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652066 ORDER BY `unit` DESC [ RunTime:0.084900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652066 LIMIT 2 [ RunTime:0.015877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652066 ORDER BY `minOrder` ASC [ RunTime:0.004223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652055 LIMIT 5 [ RunTime:0.100289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652055 ORDER BY `minOrder` ASC [ RunTime:0.023665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652055 ORDER BY `unit` DESC [ RunTime:0.039403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652055 LIMIT 2 [ RunTime:0.087991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652055 ORDER BY `minOrder` ASC [ RunTime:0.012844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790287 LIMIT 5 [ RunTime:0.038473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790287 ORDER BY `minOrder` ASC [ RunTime:0.038895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790287 ORDER BY `unit` DESC [ RunTime:0.014757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790287 LIMIT 2 [ RunTime:0.052135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790287 ORDER BY `minOrder` ASC [ RunTime:0.009211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790286 LIMIT 5 [ RunTime:0.059147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790286 ORDER BY `minOrder` ASC [ RunTime:0.052211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790286 ORDER BY `unit` DESC [ RunTime:0.078709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790286 LIMIT 2 [ RunTime:0.055046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790286 ORDER BY `minOrder` ASC [ RunTime:0.033267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790283 LIMIT 5 [ RunTime:0.055976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790283 ORDER BY `minOrder` ASC [ RunTime:0.083231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790283 ORDER BY `unit` DESC [ RunTime:0.030190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790283 LIMIT 2 [ RunTime:0.010759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790283 ORDER BY `minOrder` ASC [ RunTime:0.007966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790279 LIMIT 5 [ RunTime:0.036775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790279 ORDER BY `minOrder` ASC [ RunTime:0.055174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790279 ORDER BY `unit` DESC [ RunTime:0.038896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790279 LIMIT 2 [ RunTime:0.048896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790279 ORDER BY `minOrder` ASC [ RunTime:0.032666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790277 LIMIT 5 [ RunTime:0.038871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790277 ORDER BY `minOrder` ASC [ RunTime:0.021191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790277 ORDER BY `unit` DESC [ RunTime:0.054196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790277 LIMIT 2 [ RunTime:0.020135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790277 ORDER BY `minOrder` ASC [ RunTime:0.012607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790265 LIMIT 5 [ RunTime:0.012684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790265 ORDER BY `minOrder` ASC [ RunTime:0.059557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790265 ORDER BY `unit` DESC [ RunTime:0.012746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790265 LIMIT 2 [ RunTime:0.015900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790265 ORDER BY `minOrder` ASC [ RunTime:0.004386s ]
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 '40C24-P250%' OR `brand` LIKE '40C24-P250%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025433s ]
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 '40C24-P250%' OR `brand` LIKE '40C24-P250%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57564180 LIMIT 5 [ RunTime:0.027864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564180 ORDER BY `minOrder` ASC [ RunTime:0.021740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57564180 ORDER BY `unit` DESC [ RunTime:0.023353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57564180 LIMIT 2 [ RunTime:0.026145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564180 ORDER BY `minOrder` ASC [ RunTime:0.005076s ]
select * from pdf where partno='40C24-P250-H' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.017843s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40C24-P250-H' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.025575s ]
SELECT `id` FROM `stock` WHERE `id` <> 57564180 AND `partno` = '40C24-P250-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.009537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57564177 LIMIT 5 [ RunTime:0.010417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564177 ORDER BY `minOrder` ASC [ RunTime:0.033625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57564177 ORDER BY `unit` DESC [ RunTime:0.019131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57564177 LIMIT 2 [ RunTime:0.063873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564177 ORDER BY `minOrder` ASC [ RunTime:0.011226s ]
select * from pdf where partno='40C24-P250-I10-WS-DAR' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.009820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40C24-P250-I10-WS-DAR' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.012403s ]
SELECT `id` FROM `stock` WHERE `id` <> 57564177 AND `partno` = '40C24-P250-I10-WS-DAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.027621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57564169 LIMIT 5 [ RunTime:0.003587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564169 ORDER BY `minOrder` ASC [ RunTime:0.025217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57564169 ORDER BY `unit` DESC [ RunTime:0.033166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57564169 LIMIT 2 [ RunTime:0.066566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564169 ORDER BY `minOrder` ASC [ RunTime:0.026152s ]
select * from pdf where partno='40C24-P250-I10' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.006047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40C24-P250-I10' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.046641s ]
SELECT `id` FROM `stock` WHERE `id` <> 57564169 AND `partno` = '40C24-P250-I10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.040390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57564168 LIMIT 5 [ RunTime:0.029953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564168 ORDER BY `minOrder` ASC [ RunTime:0.132277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57564168 ORDER BY `unit` DESC [ RunTime:0.055434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57564168 LIMIT 2 [ RunTime:0.022888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564168 ORDER BY `minOrder` ASC [ RunTime:0.031705s ]
select * from pdf where partno='40C24-P250-I5' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.026809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40C24-P250-I5' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.048598s ]
SELECT `id` FROM `stock` WHERE `id` <> 57564168 AND `partno` = '40C24-P250-I5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.052767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57564162 LIMIT 5 [ RunTime:0.061831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564162 ORDER BY `minOrder` ASC [ RunTime:0.083643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57564162 ORDER BY `unit` DESC [ RunTime:0.216433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57564162 LIMIT 2 [ RunTime:0.080048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564162 ORDER BY `minOrder` ASC [ RunTime:0.072309s ]
select * from pdf where partno='40C24-P250' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.098039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40C24-P250' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.069845s ]
SELECT `id` FROM `stock` WHERE `id` <> 57564162 AND `partno` = '40C24-P250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.105230s ]
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 '40C24-P250%' OR `brand` LIKE '40C24-P250%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070507s ]
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 '40C24-P250%' OR `brand` LIKE '40C24-P250%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031007s ]
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 '40C24-P250%' OR `brand` LIKE '40C24-P250%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032048s ]
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 '40C24-P250%' OR `brand` LIKE '40C24-P250%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060695s ]
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 '40C24-P250%' OR `brand` LIKE '40C24-P250%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043921s ]
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 '40C24-P250%' OR `brand` LIKE '40C24-P250%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062122s ]
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 '40C24-P250%' OR `brand` LIKE '40C24-P250%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069352s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40C24-P250%' OR `brand` LIKE '40C24-P250%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.057331s ]