SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002319s ]
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.25S12-3.305%' OR `brand` LIKE 'R0.25S12-3.305%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006505s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637927 LIMIT 5 [ RunTime:0.031587s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637927 ORDER BY `minOrder` ASC [ RunTime:0.020630s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16637927 ORDER BY `unit` DESC [ RunTime:0.033757s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16637927 LIMIT 2 [ RunTime:0.017162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637927 ORDER BY `minOrder` ASC [ RunTime:0.010476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637590 LIMIT 5 [ RunTime:0.013447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637590 ORDER BY `minOrder` ASC [ RunTime:0.036235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16637590 ORDER BY `unit` DESC [ RunTime:0.028692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16637590 LIMIT 2 [ RunTime:0.033643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637590 ORDER BY `minOrder` ASC [ RunTime:0.064878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637337 LIMIT 5 [ RunTime:0.023985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637337 ORDER BY `minOrder` ASC [ RunTime:0.061624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16637337 ORDER BY `unit` DESC [ RunTime:0.019929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16637337 LIMIT 2 [ RunTime:0.061710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637337 ORDER BY `minOrder` ASC [ RunTime:0.027555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14773505 LIMIT 5 [ RunTime:0.065830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14773505 ORDER BY `minOrder` ASC [ RunTime:0.048813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14773505 ORDER BY `unit` DESC [ RunTime:0.079254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14773505 LIMIT 2 [ RunTime:0.083057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14773505 ORDER BY `minOrder` ASC [ RunTime:0.034467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14773134 LIMIT 5 [ RunTime:0.030622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14773134 ORDER BY `minOrder` ASC [ RunTime:0.093161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14773134 ORDER BY `unit` DESC [ RunTime:0.069619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14773134 LIMIT 2 [ RunTime:0.078600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14773134 ORDER BY `minOrder` ASC [ RunTime:0.033021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772898 LIMIT 5 [ RunTime:0.068266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772898 ORDER BY `minOrder` ASC [ RunTime:0.073551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14772898 ORDER BY `unit` DESC [ RunTime:0.029697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14772898 LIMIT 2 [ RunTime:0.049138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772898 ORDER BY `minOrder` ASC [ RunTime:0.010581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772519 LIMIT 5 [ RunTime:0.042010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772519 ORDER BY `minOrder` ASC [ RunTime:0.044675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14772519 ORDER BY `unit` DESC [ RunTime:0.007420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14772519 LIMIT 2 [ RunTime:0.026835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772519 ORDER BY `minOrder` ASC [ RunTime:0.038709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772518 LIMIT 5 [ RunTime:0.031005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772518 ORDER BY `minOrder` ASC [ RunTime:0.017600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14772518 ORDER BY `unit` DESC [ RunTime:0.052321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14772518 LIMIT 2 [ RunTime:0.042923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772518 ORDER BY `minOrder` ASC [ RunTime:0.040903s ]
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.25S12-3.305%' OR `brand` LIKE 'R0.25S12-3.305%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027227s ]
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.25S12-3.305%' OR `brand` LIKE 'R0.25S12-3.305%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64340230 LIMIT 5 [ RunTime:0.040639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64340230 ORDER BY `minOrder` ASC [ RunTime:0.074178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64340230 ORDER BY `unit` DESC [ RunTime:0.038003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64340230 LIMIT 2 [ RunTime:0.020936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64340230 ORDER BY `minOrder` ASC [ RunTime:0.017030s ]
select * from pdf where partno='R0.25S12-3.305/HP' and brandshort='Recom Power' limit 1 [ RunTime:0.023020s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S12-3.305/HP' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.042881s ]
SELECT `id` FROM `stock` WHERE `id` <> 64340230 AND `partno` = 'R0.25S12-3.305/HP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.015326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14773134 [ RunTime:0.030243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64340012 LIMIT 5 [ RunTime:0.023195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64340012 ORDER BY `minOrder` ASC [ RunTime:0.016319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64340012 ORDER BY `unit` DESC [ RunTime:0.017844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64340012 LIMIT 2 [ RunTime:0.015458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64340012 ORDER BY `minOrder` ASC [ RunTime:0.013340s ]
select * from pdf where partno='R0.25S12-3.305/HP-R' and brandshort='Recom Power' limit 1 [ RunTime:0.018431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S12-3.305/HP-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.038943s ]
SELECT `id` FROM `stock` WHERE `id` <> 64340012 AND `partno` = 'R0.25S12-3.305/HP-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.015273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14773505 [ RunTime:0.017294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64339098 LIMIT 5 [ RunTime:0.021604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64339098 ORDER BY `minOrder` ASC [ RunTime:0.013405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64339098 ORDER BY `unit` DESC [ RunTime:0.071295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64339098 LIMIT 2 [ RunTime:0.023301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64339098 ORDER BY `minOrder` ASC [ RunTime:0.020288s ]
select * from pdf where partno='R0.25S12-3.305/P' and brandshort='Recom Power' limit 1 [ RunTime:0.025920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S12-3.305/P' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.042341s ]
SELECT `id` FROM `stock` WHERE `id` <> 64339098 AND `partno` = 'R0.25S12-3.305/P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.051974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772519 [ RunTime:0.030577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64339097 LIMIT 5 [ RunTime:0.034414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64339097 ORDER BY `minOrder` ASC [ RunTime:0.014797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64339097 ORDER BY `unit` DESC [ RunTime:0.030383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64339097 LIMIT 2 [ RunTime:0.040206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64339097 ORDER BY `minOrder` ASC [ RunTime:0.012092s ]
select * from pdf where partno='R0.25S12-3.305/H' and brandshort='Recom Power' limit 1 [ RunTime:0.017421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S12-3.305/H' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.019453s ]
SELECT `id` FROM `stock` WHERE `id` <> 64339097 AND `partno` = 'R0.25S12-3.305/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.055093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772518 [ RunTime:0.056943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64338808 LIMIT 5 [ RunTime:0.045814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64338808 ORDER BY `minOrder` ASC [ RunTime:0.015591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64338808 ORDER BY `unit` DESC [ RunTime:0.063227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64338808 LIMIT 2 [ RunTime:0.027858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64338808 ORDER BY `minOrder` ASC [ RunTime:0.013401s ]
select * from pdf where partno='R0.25S12-3.305/H-R' and brandshort='Recom Power' limit 1 [ RunTime:0.019961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S12-3.305/H-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.022957s ]
SELECT `id` FROM `stock` WHERE `id` <> 64338808 AND `partno` = 'R0.25S12-3.305/H-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.020883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772898 [ RunTime:0.019682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64338767 LIMIT 5 [ RunTime:0.017154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64338767 ORDER BY `minOrder` ASC [ RunTime:0.021464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64338767 ORDER BY `unit` DESC [ RunTime:0.015016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64338767 LIMIT 2 [ RunTime:0.038693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64338767 ORDER BY `minOrder` ASC [ RunTime:0.014972s ]
select * from pdf where partno='R0.25S12-3.305/P-R' and brandshort='Recom Power' limit 1 [ RunTime:0.013291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S12-3.305/P-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.065864s ]
SELECT `id` FROM `stock` WHERE `id` <> 64338767 AND `partno` = 'R0.25S12-3.305/P-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.046378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637927 [ RunTime:0.019447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64337641 LIMIT 5 [ RunTime:0.012316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64337641 ORDER BY `minOrder` ASC [ RunTime:0.015759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64337641 ORDER BY `unit` DESC [ RunTime:0.025720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64337641 LIMIT 2 [ RunTime:0.043067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64337641 ORDER BY `minOrder` ASC [ RunTime:0.009810s ]
select * from pdf where partno='R0.25S12-3.305' and brandshort='Recom Power' limit 1 [ RunTime:0.041205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S12-3.305' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.044036s ]
SELECT `id` FROM `stock` WHERE `id` <> 64337641 AND `partno` = 'R0.25S12-3.305' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.038241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637337 [ RunTime:0.069245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64337416 LIMIT 5 [ RunTime:0.029493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64337416 ORDER BY `minOrder` ASC [ RunTime:0.066818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64337416 ORDER BY `unit` DESC [ RunTime:0.039386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64337416 LIMIT 2 [ RunTime:0.056678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64337416 ORDER BY `minOrder` ASC [ RunTime:0.019517s ]
select * from pdf where partno='R0.25S12-3.305-R' and brandshort='Recom Power' limit 1 [ RunTime:0.016687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25S12-3.305-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.014402s ]
SELECT `id` FROM `stock` WHERE `id` <> 64337416 AND `partno` = 'R0.25S12-3.305-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.017928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637590 [ RunTime:0.029446s ]
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.25S12-3.305%' OR `brand` LIKE 'R0.25S12-3.305%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032186s ]
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.25S12-3.305%' OR `brand` LIKE 'R0.25S12-3.305%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019594s ]
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.25S12-3.305%' OR `brand` LIKE 'R0.25S12-3.305%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023036s ]
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.25S12-3.305%' OR `brand` LIKE 'R0.25S12-3.305%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014353s ]
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.25S12-3.305%' OR `brand` LIKE 'R0.25S12-3.305%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039125s ]
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.25S12-3.305%' OR `brand` LIKE 'R0.25S12-3.305%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019549s ]
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.25S12-3.305%' OR `brand` LIKE 'R0.25S12-3.305%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015927s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.25S12-3.305%' OR `brand` LIKE 'R0.25S12-3.305%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.019168s ]