SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003178s ]
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 '10A24-N15-I10%' OR `brand` LIKE '10A24-N15-I10%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055812s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848963 LIMIT 5 [ RunTime:0.051141s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848963 ORDER BY `minOrder` ASC [ RunTime:0.062415s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848963 ORDER BY `unit` DESC [ RunTime:0.069335s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.024203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848963 LIMIT 2 [ RunTime:0.119395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848963 ORDER BY `minOrder` ASC [ RunTime:0.017476s ]
select * from pdf where partno='10A24-N15-I10-F-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.031500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848804 LIMIT 5 [ RunTime:0.093797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848804 ORDER BY `minOrder` ASC [ RunTime:0.023238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848804 ORDER BY `unit` DESC [ RunTime:0.070284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848804 LIMIT 2 [ RunTime:0.059339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848804 ORDER BY `minOrder` ASC [ RunTime:0.044426s ]
select * from pdf where partno='10A24-N15-I10-25PPM-F-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.016250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848771 LIMIT 5 [ RunTime:0.029201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848771 ORDER BY `minOrder` ASC [ RunTime:0.054506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848771 ORDER BY `unit` DESC [ RunTime:0.052527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848771 LIMIT 2 [ RunTime:0.083418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848771 ORDER BY `minOrder` ASC [ RunTime:0.030999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848551 LIMIT 5 [ RunTime:0.030879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848551 ORDER BY `minOrder` ASC [ RunTime:0.137979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848551 ORDER BY `unit` DESC [ RunTime:0.160833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848551 LIMIT 2 [ RunTime:0.064931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848551 ORDER BY `minOrder` ASC [ RunTime:0.054181s ]
select * from pdf where partno='10A24-N15-I10-F-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.041794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848238 LIMIT 5 [ RunTime:0.040237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848238 ORDER BY `minOrder` ASC [ RunTime:0.047998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848238 ORDER BY `unit` DESC [ RunTime:0.098102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848238 LIMIT 2 [ RunTime:0.050989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848238 ORDER BY `minOrder` ASC [ RunTime:0.057270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848143 LIMIT 5 [ RunTime:0.072450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848143 ORDER BY `minOrder` ASC [ RunTime:0.049384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848143 ORDER BY `unit` DESC [ RunTime:0.035074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848143 LIMIT 2 [ RunTime:0.061020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848143 ORDER BY `minOrder` ASC [ RunTime:0.034223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17847507 LIMIT 5 [ RunTime:0.028993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17847507 ORDER BY `minOrder` ASC [ RunTime:0.043010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17847507 ORDER BY `unit` DESC [ RunTime:0.075040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17847507 LIMIT 2 [ RunTime:0.053924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17847507 ORDER BY `minOrder` ASC [ RunTime:0.018314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800342 LIMIT 5 [ RunTime:0.019170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800342 ORDER BY `minOrder` ASC [ RunTime:0.027536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16800342 ORDER BY `unit` DESC [ RunTime:0.043246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16800342 LIMIT 2 [ RunTime:0.022855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800342 ORDER BY `minOrder` ASC [ RunTime:0.018356s ]
select * from pdf where partno='10A24-N15-I10-25PPM-F-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.031298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800254 LIMIT 5 [ RunTime:0.013852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800254 ORDER BY `minOrder` ASC [ RunTime:0.034432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16800254 ORDER BY `unit` DESC [ RunTime:0.015584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16800254 LIMIT 2 [ RunTime:0.004284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800254 ORDER BY `minOrder` ASC [ RunTime:0.015768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800228 LIMIT 5 [ RunTime:0.032550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800228 ORDER BY `minOrder` ASC [ RunTime:0.036197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16800228 ORDER BY `unit` DESC [ RunTime:0.014457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16800228 LIMIT 2 [ RunTime:0.052394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800228 ORDER BY `minOrder` ASC [ RunTime:0.010744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650541 LIMIT 5 [ RunTime:0.044440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650541 ORDER BY `minOrder` ASC [ RunTime:0.037121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650541 ORDER BY `unit` DESC [ RunTime:0.032948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650541 LIMIT 2 [ RunTime:0.057338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650541 ORDER BY `minOrder` ASC [ RunTime:0.046629s ]
select * from pdf where partno='10A24-N15-I10-25PPM-F-M' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.040450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650205 LIMIT 5 [ RunTime:0.052135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650205 ORDER BY `minOrder` ASC [ RunTime:0.024133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650205 ORDER BY `unit` DESC [ RunTime:0.019651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650205 LIMIT 2 [ RunTime:0.016532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650205 ORDER BY `minOrder` ASC [ RunTime:0.008551s ]
select * from pdf where partno='10A24-N15-I10-F-M-HLP' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.062082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650102 LIMIT 5 [ RunTime:0.034242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650102 ORDER BY `minOrder` ASC [ RunTime:0.053990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650102 ORDER BY `unit` DESC [ RunTime:0.031441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650102 LIMIT 2 [ RunTime:0.014277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650102 ORDER BY `minOrder` ASC [ RunTime:0.018647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649963 LIMIT 5 [ RunTime:0.050348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649963 ORDER BY `minOrder` ASC [ RunTime:0.053408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649963 ORDER BY `unit` DESC [ RunTime:0.030900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649963 LIMIT 2 [ RunTime:0.036058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649963 ORDER BY `minOrder` ASC [ RunTime:0.005325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649542 LIMIT 5 [ RunTime:0.024227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649542 ORDER BY `minOrder` ASC [ RunTime:0.042189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649542 ORDER BY `unit` DESC [ RunTime:0.027509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649542 LIMIT 2 [ RunTime:0.028800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649542 ORDER BY `minOrder` ASC [ RunTime:0.018299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15720507 LIMIT 5 [ RunTime:0.023408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15720507 ORDER BY `minOrder` ASC [ RunTime:0.036116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15720507 ORDER BY `unit` DESC [ RunTime:0.015154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15720507 LIMIT 2 [ RunTime:0.048419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15720507 ORDER BY `minOrder` ASC [ RunTime:0.040114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15009942 LIMIT 5 [ RunTime:0.011093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15009942 ORDER BY `minOrder` ASC [ RunTime:0.000830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15009942 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15009942 LIMIT 2 [ RunTime:0.018133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15009942 ORDER BY `minOrder` ASC [ RunTime:0.009347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788669 LIMIT 5 [ RunTime:0.013419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788669 ORDER BY `minOrder` ASC [ RunTime:0.028293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788669 ORDER BY `unit` DESC [ RunTime:0.020112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788669 LIMIT 2 [ RunTime:0.046452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788669 ORDER BY `minOrder` ASC [ RunTime:0.003781s ]
select * from pdf where partno='10A24-N15-I10-25PPM-F-M-HLP' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.010134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788587 LIMIT 5 [ RunTime:0.011615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788587 ORDER BY `minOrder` ASC [ RunTime:0.002985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788587 ORDER BY `unit` DESC [ RunTime:0.014828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788587 LIMIT 2 [ RunTime:0.021279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788587 ORDER BY `minOrder` ASC [ RunTime:0.006936s ]
select * from pdf where partno='10A24-N15-I10-F-M-H' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.020374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788529 LIMIT 5 [ RunTime:0.050530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788529 ORDER BY `minOrder` ASC [ RunTime:0.037280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788529 ORDER BY `unit` DESC [ RunTime:0.008020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788529 LIMIT 2 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788529 ORDER BY `minOrder` ASC [ RunTime:0.030379s ]
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 '10A24-N15-I10%' OR `brand` LIKE '10A24-N15-I10%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035713s ]
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 '10A24-N15-I10%' OR `brand` LIKE '10A24-N15-I10%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64370688 LIMIT 5 [ RunTime:0.038248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370688 ORDER BY `minOrder` ASC [ RunTime:0.017662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64370688 ORDER BY `unit` DESC [ RunTime:0.015022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64370688 LIMIT 2 [ RunTime:0.058785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370688 ORDER BY `minOrder` ASC [ RunTime:0.023195s ]
select * from pdf where partno='10A24-N15-I10' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.047139s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10A24-N15-I10' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.016446s ]
SELECT `id` FROM `stock` WHERE `id` <> 64370688 AND `partno` = '10A24-N15-I10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.018035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13892234 [ RunTime:0.042149s ]
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 '10A24-N15-I10%' OR `brand` LIKE '10A24-N15-I10%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012656s ]
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 '10A24-N15-I10%' OR `brand` LIKE '10A24-N15-I10%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046058s ]
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 '10A24-N15-I10%' OR `brand` LIKE '10A24-N15-I10%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038417s ]
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 '10A24-N15-I10%' OR `brand` LIKE '10A24-N15-I10%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008886s ]
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 '10A24-N15-I10%' OR `brand` LIKE '10A24-N15-I10%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075562s ]
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 '10A24-N15-I10%' OR `brand` LIKE '10A24-N15-I10%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.084939s ]
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 '10A24-N15-I10%' OR `brand` LIKE '10A24-N15-I10%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030672s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10A24-N15-I10%' OR `brand` LIKE '10A24-N15-I10%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.053856s ]