SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001873s ]
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 'M3826%' OR `brand` LIKE 'M3826%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023595s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.010817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19206627 LIMIT 5 [ RunTime:0.051105s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19206627 ORDER BY `minOrder` ASC [ RunTime:0.021162s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19206627 ORDER BY `unit` DESC [ RunTime:0.060133s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19206627 LIMIT 2 [ RunTime:0.015622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19206627 ORDER BY `minOrder` ASC [ RunTime:0.018901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19207059 LIMIT 5 [ RunTime:0.030487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19207059 ORDER BY `minOrder` ASC [ RunTime:0.036299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19207059 ORDER BY `unit` DESC [ RunTime:0.009838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19207059 LIMIT 2 [ RunTime:0.009808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19207059 ORDER BY `minOrder` ASC [ RunTime:0.035558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17114228 LIMIT 5 [ RunTime:0.045536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17114228 ORDER BY `minOrder` ASC [ RunTime:0.065477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17114228 ORDER BY `unit` DESC [ RunTime:0.078083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17114228 LIMIT 2 [ RunTime:0.054321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17114228 ORDER BY `minOrder` ASC [ RunTime:0.060588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513988 LIMIT 5 [ RunTime:0.090828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513988 ORDER BY `minOrder` ASC [ RunTime:0.149445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13513988 ORDER BY `unit` DESC [ RunTime:0.049232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13513988 LIMIT 2 [ RunTime:0.047611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513988 ORDER BY `minOrder` ASC [ RunTime:0.043378s ]
select * from pdf where partno='M3826 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.098465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14374337 LIMIT 5 [ RunTime:0.077562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14374337 ORDER BY `minOrder` ASC [ RunTime:0.057884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14374337 ORDER BY `unit` DESC [ RunTime:0.139426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14374337 LIMIT 2 [ RunTime:0.140997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14374337 ORDER BY `minOrder` ASC [ RunTime:0.053759s ]
select * from pdf where partno='M3826 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.122098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13496800 LIMIT 5 [ RunTime:0.035899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13496800 ORDER BY `minOrder` ASC [ RunTime:0.168792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13496800 ORDER BY `unit` DESC [ RunTime:0.118973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13496800 LIMIT 2 [ RunTime:0.064429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13496800 ORDER BY `minOrder` ASC [ RunTime:0.125677s ]
select * from pdf where partno='M3826 BK001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.051382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13496609 LIMIT 5 [ RunTime:0.096755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13496609 ORDER BY `minOrder` ASC [ RunTime:0.059767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13496609 ORDER BY `unit` DESC [ RunTime:0.128606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13496609 LIMIT 2 [ RunTime:0.100300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13496609 ORDER BY `minOrder` ASC [ RunTime:0.050965s ]
select * from pdf where partno='M3826 BK002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.034039s ]
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 'M3826%' OR `brand` LIKE 'M3826%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.096342s ]
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 'M3826%' OR `brand` LIKE 'M3826%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.090794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63554069 LIMIT 5 [ RunTime:0.039531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63554069 ORDER BY `minOrder` ASC [ RunTime:0.085932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63554069 ORDER BY `unit` DESC [ RunTime:0.030220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63554069 LIMIT 2 [ RunTime:0.062843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63554069 ORDER BY `minOrder` ASC [ RunTime:0.011575s ]
select * from pdf where partno='M38267E8GP' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.040810s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M38267E8GP' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.074952s ]
SELECT `id` FROM `stock` WHERE `id` <> 63554069 AND `partno` = 'M38267E8GP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.063648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19206627 [ RunTime:0.125392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63555108 LIMIT 5 [ RunTime:0.051537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63555108 ORDER BY `minOrder` ASC [ RunTime:0.090495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63555108 ORDER BY `unit` DESC [ RunTime:0.080112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63555108 LIMIT 2 [ RunTime:0.012411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63555108 ORDER BY `minOrder` ASC [ RunTime:0.014834s ]
select * from pdf where partno='M3826AEFGP#U0' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.037687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M3826AEFGP#U0' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.077023s ]
SELECT `id` FROM `stock` WHERE `id` <> 63555108 AND `partno` = 'M3826AEFGP#U0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.038045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19207059 [ RunTime:0.070614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63555109 LIMIT 5 [ RunTime:0.033428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63555109 ORDER BY `minOrder` ASC [ RunTime:0.022966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63555109 ORDER BY `unit` DESC [ RunTime:0.067349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63555109 LIMIT 2 [ RunTime:0.056106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63555109 ORDER BY `minOrder` ASC [ RunTime:0.004174s ]
select * from pdf where partno='M3826AEFFP#U0' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.036369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M3826AEFFP#U0' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.031916s ]
SELECT `id` FROM `stock` WHERE `id` <> 63555109 AND `partno` = 'M3826AEFFP#U0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.079014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17114228 [ RunTime:0.021756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63006535 LIMIT 5 [ RunTime:0.050413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63006535 ORDER BY `minOrder` ASC [ RunTime:0.030794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63006535 ORDER BY `unit` DESC [ RunTime:0.036226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63006535 LIMIT 2 [ RunTime:0.021276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63006535 ORDER BY `minOrder` ASC [ RunTime:0.023891s ]
select * from pdf where partno='M3826 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.014625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M3826 BK005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.034042s ]
SELECT `id` FROM `stock` WHERE `id` <> 63006535 AND `partno` = 'M3826 BK005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.051307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513988 [ RunTime:0.039836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63141114 LIMIT 5 [ RunTime:0.074418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63141114 ORDER BY `minOrder` ASC [ RunTime:0.063436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63141114 ORDER BY `unit` DESC [ RunTime:0.070703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63141114 LIMIT 2 [ RunTime:0.133546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63141114 ORDER BY `minOrder` ASC [ RunTime:0.009656s ]
select * from pdf where partno='M3826' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.049558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M3826' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.049201s ]
SELECT `id` FROM `stock` WHERE `id` <> 63141114 AND `partno` = 'M3826' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.032866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63012516 LIMIT 5 [ RunTime:0.056489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63012516 ORDER BY `minOrder` ASC [ RunTime:0.049708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63012516 ORDER BY `unit` DESC [ RunTime:0.052718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63012516 LIMIT 2 [ RunTime:0.127235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63012516 ORDER BY `minOrder` ASC [ RunTime:0.033464s ]
select * from pdf where partno='M3826 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.028476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M3826 BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.033362s ]
SELECT `id` FROM `stock` WHERE `id` <> 63012516 AND `partno` = 'M3826 BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.058790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14374337 [ RunTime:0.150240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63003218 LIMIT 5 [ RunTime:0.081441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63003218 ORDER BY `minOrder` ASC [ RunTime:0.078420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63003218 ORDER BY `unit` DESC [ RunTime:0.055004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63003218 LIMIT 2 [ RunTime:0.084848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63003218 ORDER BY `minOrder` ASC [ RunTime:0.050786s ]
select * from pdf where partno='M3826 BK001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.045976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M3826 BK001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.052907s ]
SELECT `id` FROM `stock` WHERE `id` <> 63003218 AND `partno` = 'M3826 BK001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.151007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13496800 [ RunTime:0.135328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63002997 LIMIT 5 [ RunTime:0.117989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63002997 ORDER BY `minOrder` ASC [ RunTime:0.102019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63002997 ORDER BY `unit` DESC [ RunTime:0.089568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63002997 LIMIT 2 [ RunTime:0.051009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63002997 ORDER BY `minOrder` ASC [ RunTime:0.051010s ]
select * from pdf where partno='M3826 BK002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.031246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M3826 BK002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.078440s ]
SELECT `id` FROM `stock` WHERE `id` <> 63002997 AND `partno` = 'M3826 BK002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.050843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13496609 [ RunTime:0.175445s ]
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 'M3826%' OR `brand` LIKE 'M3826%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041163s ]
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 'M3826%' OR `brand` LIKE 'M3826%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.170276s ]
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 'M3826%' OR `brand` LIKE 'M3826%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.088543s ]
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 'M3826%' OR `brand` LIKE 'M3826%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087576s ]
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 'M3826%' OR `brand` LIKE 'M3826%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052615s ]
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 'M3826%' OR `brand` LIKE 'M3826%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.158529s ]
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 'M3826%' OR `brand` LIKE 'M3826%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055685s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'M3826%' OR `brand` LIKE 'M3826%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.052439s ]