SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003781s ]
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 '102KH20%' OR `brand` LIKE '102KH20%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039949s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14840334 LIMIT 5 [ RunTime:0.027121s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14840334 ORDER BY `minOrder` ASC [ RunTime:0.006381s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14840334 ORDER BY `unit` DESC [ RunTime:0.019326s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14840334 LIMIT 2 [ RunTime:0.007046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14840334 ORDER BY `minOrder` ASC [ RunTime:0.023288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14840333 LIMIT 5 [ RunTime:0.020341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14840333 ORDER BY `minOrder` ASC [ RunTime:0.017132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14840333 ORDER BY `unit` DESC [ RunTime:0.044616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14840333 LIMIT 2 [ RunTime:0.060807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14840333 ORDER BY `minOrder` ASC [ RunTime:0.008034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14840332 LIMIT 5 [ RunTime:0.019484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14840332 ORDER BY `minOrder` ASC [ RunTime:0.061751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14840332 ORDER BY `unit` DESC [ RunTime:0.045510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14840332 LIMIT 2 [ RunTime:0.077862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14840332 ORDER BY `minOrder` ASC [ RunTime:0.024189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14840086 LIMIT 5 [ RunTime:0.056457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14840086 ORDER BY `minOrder` ASC [ RunTime:0.065475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14840086 ORDER BY `unit` DESC [ RunTime:0.058635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14840086 LIMIT 2 [ RunTime:0.041827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14840086 ORDER BY `minOrder` ASC [ RunTime:0.029974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13939185 LIMIT 5 [ RunTime:0.053665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13939185 ORDER BY `minOrder` ASC [ RunTime:0.043863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13939185 ORDER BY `unit` DESC [ RunTime:0.021973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13939185 LIMIT 2 [ RunTime:0.007366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13939185 ORDER BY `minOrder` ASC [ RunTime:0.021834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13939184 LIMIT 5 [ RunTime:0.004823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13939184 ORDER BY `minOrder` ASC [ RunTime:0.042634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13939184 ORDER BY `unit` DESC [ RunTime:0.022987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13939184 LIMIT 2 [ RunTime:0.004223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13939184 ORDER BY `minOrder` ASC [ RunTime:0.040660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13939183 LIMIT 5 [ RunTime:0.036638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13939183 ORDER BY `minOrder` ASC [ RunTime:0.017600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13939183 ORDER BY `unit` DESC [ RunTime:0.008851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13939183 LIMIT 2 [ RunTime:0.026978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13939183 ORDER BY `minOrder` ASC [ RunTime:0.019330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13938976 LIMIT 5 [ RunTime:0.011563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13938976 ORDER BY `minOrder` ASC [ RunTime:0.017413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13938976 ORDER BY `unit` DESC [ RunTime:0.011334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13938976 LIMIT 2 [ RunTime:0.028148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13938976 ORDER BY `minOrder` ASC [ RunTime:0.022781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13938975 LIMIT 5 [ RunTime:0.028666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13938975 ORDER BY `minOrder` ASC [ RunTime:0.017747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13938975 ORDER BY `unit` DESC [ RunTime:0.010622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13938975 LIMIT 2 [ RunTime:0.001741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13938975 ORDER BY `minOrder` ASC [ RunTime:0.005722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13938974 LIMIT 5 [ RunTime:0.003025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13938974 ORDER BY `minOrder` ASC [ RunTime:0.002264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13938974 ORDER BY `unit` DESC [ RunTime:0.008884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13938974 LIMIT 2 [ RunTime:0.013973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13938974 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13938973 LIMIT 5 [ RunTime:0.008885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13938973 ORDER BY `minOrder` ASC [ RunTime:0.005736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13938973 ORDER BY `unit` DESC [ RunTime:0.014906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13938973 LIMIT 2 [ RunTime:0.011642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13938973 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13938972 LIMIT 5 [ RunTime:0.006273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13938972 ORDER BY `minOrder` ASC [ RunTime:0.011919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13938972 ORDER BY `unit` DESC [ RunTime:0.006439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13938972 LIMIT 2 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13938972 ORDER BY `minOrder` ASC [ RunTime:0.019015s ]
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 '102KH20%' OR `brand` LIKE '102KH20%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011235s ]
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 '102KH20%' OR `brand` LIKE '102KH20%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41848983 LIMIT 5 [ RunTime:0.004249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848983 ORDER BY `minOrder` ASC [ RunTime:0.001079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41848983 ORDER BY `unit` DESC [ RunTime:0.001923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41848983 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848983 ORDER BY `minOrder` ASC [ RunTime:0.002473s ]
select * from pdf where partno='102KH20J-F' and brandshort='YAGEO' limit 1 [ RunTime:0.012010s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20J-F' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.010178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41848982 LIMIT 5 [ RunTime:0.003660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848982 ORDER BY `minOrder` ASC [ RunTime:0.004032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41848982 ORDER BY `unit` DESC [ RunTime:0.011608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41848982 LIMIT 2 [ RunTime:0.011928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848982 ORDER BY `minOrder` ASC [ RunTime:0.011085s ]
select * from pdf where partno='102KH20J-FP7.5' and brandshort='YAGEO' limit 1 [ RunTime:0.007602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20J-FP7.5' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41848981 LIMIT 5 [ RunTime:0.005192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848981 ORDER BY `minOrder` ASC [ RunTime:0.013188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41848981 ORDER BY `unit` DESC [ RunTime:0.012579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41848981 LIMIT 2 [ RunTime:0.021211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848981 ORDER BY `minOrder` ASC [ RunTime:0.012770s ]
select * from pdf where partno='102KH20J-OP7.5' and brandshort='YAGEO' limit 1 [ RunTime:0.028262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20J-OP7.5' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.017161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41848980 LIMIT 5 [ RunTime:0.015054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848980 ORDER BY `minOrder` ASC [ RunTime:0.022352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41848980 ORDER BY `unit` DESC [ RunTime:0.027334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41848980 LIMIT 2 [ RunTime:0.029905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848980 ORDER BY `minOrder` ASC [ RunTime:0.004367s ]
select * from pdf where partno='102KH20J-O' and brandshort='YAGEO' limit 1 [ RunTime:0.025548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20J-O' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.027199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41848352 LIMIT 5 [ RunTime:0.007082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848352 ORDER BY `minOrder` ASC [ RunTime:0.014695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41848352 ORDER BY `unit` DESC [ RunTime:0.028520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41848352 LIMIT 2 [ RunTime:0.016322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848352 ORDER BY `minOrder` ASC [ RunTime:0.007848s ]
select * from pdf where partno='102KH20J' and brandshort='YAGEO' limit 1 [ RunTime:0.028037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20J' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.015518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41848351 LIMIT 5 [ RunTime:0.016344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848351 ORDER BY `minOrder` ASC [ RunTime:0.017018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41848351 ORDER BY `unit` DESC [ RunTime:0.011226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41848351 LIMIT 2 [ RunTime:0.002838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41848351 ORDER BY `minOrder` ASC [ RunTime:0.015572s ]
select * from pdf where partno='102KH20J-P7.5' and brandshort='YAGEO' limit 1 [ RunTime:0.008390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20J-P7.5' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.033250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847785 LIMIT 5 [ RunTime:0.018092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847785 ORDER BY `minOrder` ASC [ RunTime:0.012141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847785 ORDER BY `unit` DESC [ RunTime:0.055543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847785 LIMIT 2 [ RunTime:0.027029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847785 ORDER BY `minOrder` ASC [ RunTime:0.031231s ]
select * from pdf where partno='102KH20-F' and brandshort='YAGEO' limit 1 [ RunTime:0.006412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20-F' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.019503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847168 LIMIT 5 [ RunTime:0.040335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847168 ORDER BY `minOrder` ASC [ RunTime:0.050570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847168 ORDER BY `unit` DESC [ RunTime:0.047835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847168 LIMIT 2 [ RunTime:0.029094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847168 ORDER BY `minOrder` ASC [ RunTime:0.006566s ]
select * from pdf where partno='102KH20-O' and brandshort='YAGEO' limit 1 [ RunTime:0.028767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20-O' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.008415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847167 LIMIT 5 [ RunTime:0.033230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847167 ORDER BY `minOrder` ASC [ RunTime:0.010623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847167 ORDER BY `unit` DESC [ RunTime:0.017243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847167 LIMIT 2 [ RunTime:0.029661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847167 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
select * from pdf where partno='102KH20-OP7.5' and brandshort='YAGEO' limit 1 [ RunTime:0.017377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20-OP7.5' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.028174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41847166 LIMIT 5 [ RunTime:0.022536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847166 ORDER BY `minOrder` ASC [ RunTime:0.022378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41847166 ORDER BY `unit` DESC [ RunTime:0.027933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41847166 LIMIT 2 [ RunTime:0.031600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41847166 ORDER BY `minOrder` ASC [ RunTime:0.005378s ]
select * from pdf where partno='102KH20-FP7.5' and brandshort='YAGEO' limit 1 [ RunTime:0.025898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20-FP7.5' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.040994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41846007 LIMIT 5 [ RunTime:0.027651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846007 ORDER BY `minOrder` ASC [ RunTime:0.051664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41846007 ORDER BY `unit` DESC [ RunTime:0.009978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41846007 LIMIT 2 [ RunTime:0.020880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846007 ORDER BY `minOrder` ASC [ RunTime:0.010600s ]
select * from pdf where partno='102KH20' and brandshort='YAGEO' limit 1 [ RunTime:0.048132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.032877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41846006 LIMIT 5 [ RunTime:0.012953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846006 ORDER BY `minOrder` ASC [ RunTime:0.022431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41846006 ORDER BY `unit` DESC [ RunTime:0.000609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41846006 LIMIT 2 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41846006 ORDER BY `minOrder` ASC [ RunTime:0.002913s ]
select * from pdf where partno='102KH20-P7.5' and brandshort='YAGEO' limit 1 [ RunTime:0.026906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102KH20-P7.5' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.043606s ]
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 '102KH20%' OR `brand` LIKE '102KH20%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007188s ]
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 '102KH20%' OR `brand` LIKE '102KH20%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038111s ]
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 '102KH20%' OR `brand` LIKE '102KH20%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045818s ]
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 '102KH20%' OR `brand` LIKE '102KH20%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010994s ]
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 '102KH20%' OR `brand` LIKE '102KH20%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013066s ]
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 '102KH20%' OR `brand` LIKE '102KH20%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027728s ]
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 '102KH20%' OR `brand` LIKE '102KH20%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015356s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102KH20%' OR `brand` LIKE '102KH20%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021326s ]