SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001388s ]
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 'R0.25S-1515%' OR `brand` LIKE 'R0.25S-1515%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014370s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636893 LIMIT 5 [ RunTime:0.018363s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636893 ORDER BY `minOrder` ASC [ RunTime:0.009651s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16636893 ORDER BY `unit` DESC [ RunTime:0.019216s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.021488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16636893 LIMIT 2 [ RunTime:0.013048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636893 ORDER BY `minOrder` ASC [ RunTime:0.015717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772336 LIMIT 5 [ RunTime:0.039751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772336 ORDER BY `minOrder` ASC [ RunTime:0.027825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14772336 ORDER BY `unit` DESC [ RunTime:0.032829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14772336 LIMIT 2 [ RunTime:0.046801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772336 ORDER BY `minOrder` ASC [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771897 LIMIT 5 [ RunTime:0.025178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771897 ORDER BY `minOrder` ASC [ RunTime:0.061773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14771897 ORDER BY `unit` DESC [ RunTime:0.017211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14771897 LIMIT 2 [ RunTime:0.020659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771897 ORDER BY `minOrder` ASC [ RunTime:0.050770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771437 LIMIT 5 [ RunTime:0.073712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771437 ORDER BY `minOrder` ASC [ RunTime:0.045475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14771437 ORDER BY `unit` DESC [ RunTime:0.013825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14771437 LIMIT 2 [ RunTime:0.042755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771437 ORDER BY `minOrder` ASC [ RunTime:0.021312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771074 LIMIT 5 [ RunTime:0.013748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771074 ORDER BY `minOrder` ASC [ RunTime:0.050966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14771074 ORDER BY `unit` DESC [ RunTime:0.042953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14771074 LIMIT 2 [ RunTime:0.034172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771074 ORDER BY `minOrder` ASC [ RunTime:0.055790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13878780 LIMIT 5 [ RunTime:0.024891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13878780 ORDER BY `minOrder` ASC [ RunTime:0.015044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13878780 ORDER BY `unit` DESC [ RunTime:0.021789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13878780 LIMIT 2 [ RunTime:0.029542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13878780 ORDER BY `minOrder` ASC [ RunTime:0.013425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13878779 LIMIT 5 [ RunTime:0.007068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13878779 ORDER BY `minOrder` ASC [ RunTime:0.007704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13878779 ORDER BY `unit` DESC [ RunTime:0.013380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13878779 LIMIT 2 [ RunTime:0.011336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13878779 ORDER BY `minOrder` ASC [ RunTime:0.002481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13878432 LIMIT 5 [ RunTime:0.001278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13878432 ORDER BY `minOrder` ASC [ RunTime:0.003418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13878432 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13878432 LIMIT 2 [ RunTime:0.001849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13878432 ORDER BY `minOrder` ASC [ RunTime:0.015634s ]
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 'R0.25S-1515%' OR `brand` LIKE 'R0.25S-1515%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011448s ]
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 'R0.25S-1515%' OR `brand` LIKE 'R0.25S-1515%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57527240 LIMIT 5 [ RunTime:0.003098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57527240 ORDER BY `minOrder` ASC [ RunTime:0.000919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57527240 ORDER BY `unit` DESC [ RunTime:0.005974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57527240 LIMIT 2 [ RunTime:0.030849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57527240 ORDER BY `minOrder` ASC [ RunTime:0.003734s ]
select * from pdf where partno='R0.25S-1515/HP' and brandshort='Recom Power' limit 1 [ RunTime:0.004428s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S-1515/HP' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.002504s ]
SELECT `id` FROM `stock` WHERE `id` <> 57527240 AND `partno` = 'R0.25S-1515/HP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.001081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771897 [ RunTime:0.000744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57526512 LIMIT 5 [ RunTime:0.000830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57526512 ORDER BY `minOrder` ASC [ RunTime:0.004050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57526512 ORDER BY `unit` DESC [ RunTime:0.000741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57526512 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57526512 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='R0.25S-1515/HP-R' and brandshort='Recom Power' limit 1 [ RunTime:0.000987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S-1515/HP-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.003011s ]
SELECT `id` FROM `stock` WHERE `id` <> 57526512 AND `partno` = 'R0.25S-1515/HP-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.001968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772336 [ RunTime:0.000687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57524901 LIMIT 5 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57524901 ORDER BY `minOrder` ASC [ RunTime:0.003149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57524901 ORDER BY `unit` DESC [ RunTime:0.004795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57524901 LIMIT 2 [ RunTime:0.006928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57524901 ORDER BY `minOrder` ASC [ RunTime:0.002865s ]
select * from pdf where partno='R0.25S-1515/P' and brandshort='Recom Power' limit 1 [ RunTime:0.001410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S-1515/P' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.002370s ]
SELECT `id` FROM `stock` WHERE `id` <> 57524901 AND `partno` = 'R0.25S-1515/P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.003511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771437 [ RunTime:0.000694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57524900 LIMIT 5 [ RunTime:0.001457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57524900 ORDER BY `minOrder` ASC [ RunTime:0.002999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57524900 ORDER BY `unit` DESC [ RunTime:0.003876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57524900 LIMIT 2 [ RunTime:0.005652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57524900 ORDER BY `minOrder` ASC [ RunTime:0.001903s ]
select * from pdf where partno='R0.25S-1515/H' and brandshort='Recom Power' limit 1 [ RunTime:0.003020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S-1515/H' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.000895s ]
SELECT `id` FROM `stock` WHERE `id` <> 57524900 AND `partno` = 'R0.25S-1515/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.009237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13878432 [ RunTime:0.008837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57524720 LIMIT 5 [ RunTime:0.003574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57524720 ORDER BY `minOrder` ASC [ RunTime:0.004090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57524720 ORDER BY `unit` DESC [ RunTime:0.008206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57524720 LIMIT 2 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57524720 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
select * from pdf where partno='R0.25S-1515/P-R' and brandshort='Recom Power' limit 1 [ RunTime:0.009144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S-1515/P-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.022811s ]
SELECT `id` FROM `stock` WHERE `id` <> 57524720 AND `partno` = 'R0.25S-1515/P-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.030918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13878780 [ RunTime:0.003065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57524713 LIMIT 5 [ RunTime:0.003885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57524713 ORDER BY `minOrder` ASC [ RunTime:0.004251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57524713 ORDER BY `unit` DESC [ RunTime:0.005827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57524713 LIMIT 2 [ RunTime:0.007609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57524713 ORDER BY `minOrder` ASC [ RunTime:0.020524s ]
select * from pdf where partno='R0.25S-1515/H-R' and brandshort='Recom Power' limit 1 [ RunTime:0.001149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S-1515/H-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.004467s ]
SELECT `id` FROM `stock` WHERE `id` <> 57524713 AND `partno` = 'R0.25S-1515/H-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.010724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13878779 [ RunTime:0.022359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57523847 LIMIT 5 [ RunTime:0.014697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57523847 ORDER BY `minOrder` ASC [ RunTime:0.017715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57523847 ORDER BY `unit` DESC [ RunTime:0.026304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57523847 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57523847 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='R0.25S-1515' and brandshort='Recom Power' limit 1 [ RunTime:0.002259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S-1515' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.006365s ]
SELECT `id` FROM `stock` WHERE `id` <> 57523847 AND `partno` = 'R0.25S-1515' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.001996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771074 [ RunTime:0.000844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57523626 LIMIT 5 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57523626 ORDER BY `minOrder` ASC [ RunTime:0.003975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57523626 ORDER BY `unit` DESC [ RunTime:0.007589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57523626 LIMIT 2 [ RunTime:0.003295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57523626 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='R0.25S-1515-R' and brandshort='Recom Power' limit 1 [ RunTime:0.004400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S-1515-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.000876s ]
SELECT `id` FROM `stock` WHERE `id` <> 57523626 AND `partno` = 'R0.25S-1515-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.009078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636893 [ RunTime:0.004886s ]
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 'R0.25S-1515%' OR `brand` LIKE 'R0.25S-1515%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001161s ]
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 'R0.25S-1515%' OR `brand` LIKE 'R0.25S-1515%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014994s ]
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 'R0.25S-1515%' OR `brand` LIKE 'R0.25S-1515%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001003s ]
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 'R0.25S-1515%' OR `brand` LIKE 'R0.25S-1515%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004313s ]
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 'R0.25S-1515%' OR `brand` LIKE 'R0.25S-1515%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008133s ]
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 'R0.25S-1515%' OR `brand` LIKE 'R0.25S-1515%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018613s ]
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 'R0.25S-1515%' OR `brand` LIKE 'R0.25S-1515%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008818s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.25S-1515%' OR `brand` LIKE 'R0.25S-1515%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004135s ]