SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001267s ]
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.25S8-3.305%' OR `brand` LIKE 'R0.25S8-3.305%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012212s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637057 LIMIT 5 [ RunTime:0.015768s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637057 ORDER BY `minOrder` ASC [ RunTime:0.025111s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16637057 ORDER BY `unit` DESC [ RunTime:0.017967s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16637057 LIMIT 2 [ RunTime:0.034156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637057 ORDER BY `minOrder` ASC [ RunTime:0.006828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636836 LIMIT 5 [ RunTime:0.023015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636836 ORDER BY `minOrder` ASC [ RunTime:0.047817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16636836 ORDER BY `unit` DESC [ RunTime:0.029518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16636836 LIMIT 2 [ RunTime:0.068707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16636836 ORDER BY `minOrder` ASC [ RunTime:0.015882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771906 LIMIT 5 [ RunTime:0.007083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771906 ORDER BY `minOrder` ASC [ RunTime:0.060600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14771906 ORDER BY `unit` DESC [ RunTime:0.029433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14771906 LIMIT 2 [ RunTime:0.035543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771906 ORDER BY `minOrder` ASC [ RunTime:0.039508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771653 LIMIT 5 [ RunTime:0.035772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771653 ORDER BY `minOrder` ASC [ RunTime:0.050054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14771653 ORDER BY `unit` DESC [ RunTime:0.028965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14771653 LIMIT 2 [ RunTime:0.104256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771653 ORDER BY `minOrder` ASC [ RunTime:0.010443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771450 LIMIT 5 [ RunTime:0.147317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771450 ORDER BY `minOrder` ASC [ RunTime:0.020531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14771450 ORDER BY `unit` DESC [ RunTime:0.047094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14771450 LIMIT 2 [ RunTime:0.067749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771450 ORDER BY `minOrder` ASC [ RunTime:0.042169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13879305 LIMIT 5 [ RunTime:0.031263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13879305 ORDER BY `minOrder` ASC [ RunTime:0.016844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13879305 ORDER BY `unit` DESC [ RunTime:0.035594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13879305 LIMIT 2 [ RunTime:0.020089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13879305 ORDER BY `minOrder` ASC [ RunTime:0.016829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13878998 LIMIT 5 [ RunTime:0.022920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13878998 ORDER BY `minOrder` ASC [ RunTime:0.045337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13878998 ORDER BY `unit` DESC [ RunTime:0.041868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13878998 LIMIT 2 [ RunTime:0.016742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13878998 ORDER BY `minOrder` ASC [ RunTime:0.009338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13878795 LIMIT 5 [ RunTime:0.036170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13878795 ORDER BY `minOrder` ASC [ RunTime:0.012099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13878795 ORDER BY `unit` DESC [ RunTime:0.000847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13878795 LIMIT 2 [ RunTime:0.025454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13878795 ORDER BY `minOrder` ASC [ RunTime:0.007989s ]
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.25S8-3.305%' OR `brand` LIKE 'R0.25S8-3.305%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017095s ]
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.25S8-3.305%' OR `brand` LIKE 'R0.25S8-3.305%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64337550 LIMIT 5 [ RunTime:0.014635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64337550 ORDER BY `minOrder` ASC [ RunTime:0.008570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64337550 ORDER BY `unit` DESC [ RunTime:0.015207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64337550 LIMIT 2 [ RunTime:0.015544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64337550 ORDER BY `minOrder` ASC [ RunTime:0.005593s ]
select * from pdf where partno='R0.25S8-3.305/P' and brandshort='Recom Power' limit 1 [ RunTime:0.009411s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S8-3.305/P' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.006134s ]
SELECT `id` FROM `stock` WHERE `id` <> 64337550 AND `partno` = 'R0.25S8-3.305/P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.006494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771906 [ RunTime:0.015548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64337357 LIMIT 5 [ RunTime:0.019480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64337357 ORDER BY `minOrder` ASC [ RunTime:0.011138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64337357 ORDER BY `unit` DESC [ RunTime:0.019634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64337357 LIMIT 2 [ RunTime:0.018987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64337357 ORDER BY `minOrder` ASC [ RunTime:0.013889s ]
select * from pdf where partno='R0.25S8-3.305/P-R' and brandshort='Recom Power' limit 1 [ RunTime:0.012648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S8-3.305/P-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.025293s ]
SELECT `id` FROM `stock` WHERE `id` <> 64337357 AND `partno` = 'R0.25S8-3.305/P-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.017114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13879305 [ RunTime:0.001621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64336848 LIMIT 5 [ RunTime:0.031760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64336848 ORDER BY `minOrder` ASC [ RunTime:0.004670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64336848 ORDER BY `unit` DESC [ RunTime:0.007470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64336848 LIMIT 2 [ RunTime:0.024461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64336848 ORDER BY `minOrder` ASC [ RunTime:0.013532s ]
select * from pdf where partno='R0.25S8-3.305/EP' and brandshort='Recom Power' limit 1 [ RunTime:0.020539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S8-3.305/EP' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.019732s ]
SELECT `id` FROM `stock` WHERE `id` <> 64336848 AND `partno` = 'R0.25S8-3.305/EP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.026787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771653 [ RunTime:0.017738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64336690 LIMIT 5 [ RunTime:0.027189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64336690 ORDER BY `minOrder` ASC [ RunTime:0.035110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64336690 ORDER BY `unit` DESC [ RunTime:0.012542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64336690 LIMIT 2 [ RunTime:0.011461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64336690 ORDER BY `minOrder` ASC [ RunTime:0.025279s ]
select * from pdf where partno='R0.25S8-3.305/EP-R' and brandshort='Recom Power' limit 1 [ RunTime:0.017731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S8-3.305/EP-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.014268s ]
SELECT `id` FROM `stock` WHERE `id` <> 64336690 AND `partno` = 'R0.25S8-3.305/EP-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.013966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13878998 [ RunTime:0.013881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64336271 LIMIT 5 [ RunTime:0.027892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64336271 ORDER BY `minOrder` ASC [ RunTime:0.019825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64336271 ORDER BY `unit` DESC [ RunTime:0.008720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64336271 LIMIT 2 [ RunTime:0.008564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64336271 ORDER BY `minOrder` ASC [ RunTime:0.002879s ]
select * from pdf where partno='R0.25S8-3.305' and brandshort='Recom Power' limit 1 [ RunTime:0.003549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S8-3.305' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.000485s ]
SELECT `id` FROM `stock` WHERE `id` <> 64336271 AND `partno` = 'R0.25S8-3.305' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771450 [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64336020 LIMIT 5 [ RunTime:0.003041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64336020 ORDER BY `minOrder` ASC [ RunTime:0.018058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64336020 ORDER BY `unit` DESC [ RunTime:0.023624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64336020 LIMIT 2 [ RunTime:0.044093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64336020 ORDER BY `minOrder` ASC [ RunTime:0.008317s ]
select * from pdf where partno='R0.25S8-3.305-R' and brandshort='Recom Power' limit 1 [ RunTime:0.018397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S8-3.305-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.008929s ]
SELECT `id` FROM `stock` WHERE `id` <> 64336020 AND `partno` = 'R0.25S8-3.305-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.014277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13878795 [ RunTime:0.003668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64335581 LIMIT 5 [ RunTime:0.016852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64335581 ORDER BY `minOrder` ASC [ RunTime:0.007381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64335581 ORDER BY `unit` DESC [ RunTime:0.007867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64335581 LIMIT 2 [ RunTime:0.007442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64335581 ORDER BY `minOrder` ASC [ RunTime:0.002592s ]
select * from pdf where partno='R0.25S8-3.305/E' and brandshort='Recom Power' limit 1 [ RunTime:0.004902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S8-3.305/E' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.001720s ]
SELECT `id` FROM `stock` WHERE `id` <> 64335581 AND `partno` = 'R0.25S8-3.305/E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.017363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16636836 [ RunTime:0.007277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64335339 LIMIT 5 [ RunTime:0.003857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64335339 ORDER BY `minOrder` ASC [ RunTime:0.016783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64335339 ORDER BY `unit` DESC [ RunTime:0.003641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64335339 LIMIT 2 [ RunTime:0.001914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64335339 ORDER BY `minOrder` ASC [ RunTime:0.002318s ]
select * from pdf where partno='R0.25S8-3.305/E-R' and brandshort='Recom Power' limit 1 [ RunTime:0.005992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S8-3.305/E-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.003132s ]
SELECT `id` FROM `stock` WHERE `id` <> 64335339 AND `partno` = 'R0.25S8-3.305/E-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.003872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637057 [ RunTime:0.005247s ]
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.25S8-3.305%' OR `brand` LIKE 'R0.25S8-3.305%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009128s ]
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.25S8-3.305%' OR `brand` LIKE 'R0.25S8-3.305%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011759s ]
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.25S8-3.305%' OR `brand` LIKE 'R0.25S8-3.305%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018311s ]
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.25S8-3.305%' OR `brand` LIKE 'R0.25S8-3.305%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015095s ]
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.25S8-3.305%' OR `brand` LIKE 'R0.25S8-3.305%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009260s ]
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.25S8-3.305%' OR `brand` LIKE 'R0.25S8-3.305%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008211s ]
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.25S8-3.305%' OR `brand` LIKE 'R0.25S8-3.305%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003483s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.25S8-3.305%' OR `brand` LIKE 'R0.25S8-3.305%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021079s ]