SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001204s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.115' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=SMG30&search=1' [ RunTime:0.003232s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001160s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003986s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001703s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.115' ) [ RunTime:0.003008s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002690s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009752s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003061s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMG30' LIMIT 1 [ RunTime:0.013847s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-14 20:44:54' WHERE `partno` = 'SMG30' [ RunTime:0.007120s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001486s ]
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 'SMG30%' OR `brand` LIKE 'SMG30%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039282s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280173 LIMIT 5 [ RunTime:0.009678s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.017617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280173 ORDER BY `minOrder` ASC [ RunTime:0.005062s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280173 ORDER BY `unit` DESC [ RunTime:0.021725s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.015241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280173 LIMIT 2 [ RunTime:0.006316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280173 ORDER BY `minOrder` ASC [ RunTime:0.019460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280172 LIMIT 5 [ RunTime:0.028581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280172 ORDER BY `minOrder` ASC [ RunTime:0.061674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280172 ORDER BY `unit` DESC [ RunTime:0.071920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280172 LIMIT 2 [ RunTime:0.010769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280172 ORDER BY `minOrder` ASC [ RunTime:0.020237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280171 LIMIT 5 [ RunTime:0.041405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280171 ORDER BY `minOrder` ASC [ RunTime:0.028284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280171 ORDER BY `unit` DESC [ RunTime:0.049441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280171 LIMIT 2 [ RunTime:0.025421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280171 ORDER BY `minOrder` ASC [ RunTime:0.027166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280170 LIMIT 5 [ RunTime:0.049321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280170 ORDER BY `minOrder` ASC [ RunTime:0.051036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280170 ORDER BY `unit` DESC [ RunTime:0.011814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280170 LIMIT 2 [ RunTime:0.019660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280170 ORDER BY `minOrder` ASC [ RunTime:0.008481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280169 LIMIT 5 [ RunTime:0.052574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280169 ORDER BY `minOrder` ASC [ RunTime:0.039382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280169 ORDER BY `unit` DESC [ RunTime:0.042206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280169 LIMIT 2 [ RunTime:0.025053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280169 ORDER BY `minOrder` ASC [ RunTime:0.002528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280168 LIMIT 5 [ RunTime:0.051595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280168 ORDER BY `minOrder` ASC [ RunTime:0.026624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280168 ORDER BY `unit` DESC [ RunTime:0.030403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280168 LIMIT 2 [ RunTime:0.038368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280168 ORDER BY `minOrder` ASC [ RunTime:0.018170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280167 LIMIT 5 [ RunTime:0.004819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280167 ORDER BY `minOrder` ASC [ RunTime:0.041572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280167 ORDER BY `unit` DESC [ RunTime:0.025665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280167 LIMIT 2 [ RunTime:0.019376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280167 ORDER BY `minOrder` ASC [ RunTime:0.018229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280166 LIMIT 5 [ RunTime:0.027041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280166 ORDER BY `minOrder` ASC [ RunTime:0.012436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280166 ORDER BY `unit` DESC [ RunTime:0.025221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280166 LIMIT 2 [ RunTime:0.025845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280166 ORDER BY `minOrder` ASC [ RunTime:0.009035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280165 LIMIT 5 [ RunTime:0.029389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280165 ORDER BY `minOrder` ASC [ RunTime:0.019348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280165 ORDER BY `unit` DESC [ RunTime:0.018865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280165 LIMIT 2 [ RunTime:0.029475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280165 ORDER BY `minOrder` ASC [ RunTime:0.016609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280164 LIMIT 5 [ RunTime:0.016150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280164 ORDER BY `minOrder` ASC [ RunTime:0.016597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280164 ORDER BY `unit` DESC [ RunTime:0.024283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280164 LIMIT 2 [ RunTime:0.014626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280164 ORDER BY `minOrder` ASC [ RunTime:0.009607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280163 LIMIT 5 [ RunTime:0.016802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280163 ORDER BY `minOrder` ASC [ RunTime:0.001837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280163 ORDER BY `unit` DESC [ RunTime:0.000868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280163 LIMIT 2 [ RunTime:0.002899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280163 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280162 LIMIT 5 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280162 ORDER BY `minOrder` ASC [ RunTime:0.007321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280162 ORDER BY `unit` DESC [ RunTime:0.012570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280162 LIMIT 2 [ RunTime:0.004623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280162 ORDER BY `minOrder` ASC [ RunTime:0.000681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280161 LIMIT 5 [ RunTime:0.002757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280161 ORDER BY `minOrder` ASC [ RunTime:0.001922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280161 ORDER BY `unit` DESC [ RunTime:0.003739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280161 LIMIT 2 [ RunTime:0.014987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280161 ORDER BY `minOrder` ASC [ RunTime:0.001366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280160 LIMIT 5 [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280160 ORDER BY `minOrder` ASC [ RunTime:0.000761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14280160 ORDER BY `unit` DESC [ RunTime:0.000673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14280160 LIMIT 2 [ RunTime:0.007701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14280160 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392689 LIMIT 5 [ RunTime:0.001106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392689 ORDER BY `minOrder` ASC [ RunTime:0.000567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13392689 ORDER BY `unit` DESC [ RunTime:0.006087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13392689 LIMIT 2 [ RunTime:0.002847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392689 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392688 LIMIT 5 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392688 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13392688 ORDER BY `unit` DESC [ RunTime:0.004802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13392688 LIMIT 2 [ RunTime:0.004104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392688 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392687 LIMIT 5 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392687 ORDER BY `minOrder` ASC [ RunTime:0.003257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13392687 ORDER BY `unit` DESC [ RunTime:0.000357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13392687 LIMIT 2 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392687 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392686 LIMIT 5 [ RunTime:0.000540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392686 ORDER BY `minOrder` ASC [ RunTime:0.000854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13392686 ORDER BY `unit` DESC [ RunTime:0.000545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13392686 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392686 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392685 LIMIT 5 [ RunTime:0.003066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392685 ORDER BY `minOrder` ASC [ RunTime:0.001222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13392685 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13392685 LIMIT 2 [ RunTime:0.000563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392685 ORDER BY `minOrder` ASC [ RunTime:0.002140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392684 LIMIT 5 [ RunTime:0.000784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392684 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13392684 ORDER BY `unit` DESC [ RunTime:0.004166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13392684 LIMIT 2 [ RunTime:0.006170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392684 ORDER BY `minOrder` ASC [ RunTime:0.001801s ]
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 'SMG30%' OR `brand` LIKE 'SMG30%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001402s ]
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 'SMG30%' OR `brand` LIKE 'SMG30%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64176484 LIMIT 5 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64176484 ORDER BY `minOrder` ASC [ RunTime:0.008267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64176484 ORDER BY `unit` DESC [ RunTime:0.005102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64176484 LIMIT 2 [ RunTime:0.006485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64176484 ORDER BY `minOrder` ASC [ RunTime:0.007927s ]
select * from pdf where partno='SMG30' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.003167s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG30' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.003440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564272 LIMIT 5 [ RunTime:0.012490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564272 ORDER BY `minOrder` ASC [ RunTime:0.007968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564272 ORDER BY `unit` DESC [ RunTime:0.009138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564272 LIMIT 2 [ RunTime:0.002917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564272 ORDER BY `minOrder` ASC [ RunTime:0.004451s ]
select * from pdf where partno='SMG3013-101K' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.005572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-101K' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.000635s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564272 AND `partno` = 'SMG3013-101K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.000927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392689 [ RunTime:0.005640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564271 LIMIT 5 [ RunTime:0.009583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564271 ORDER BY `minOrder` ASC [ RunTime:0.032971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564271 ORDER BY `unit` DESC [ RunTime:0.012041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564271 LIMIT 2 [ RunTime:0.009092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564271 ORDER BY `minOrder` ASC [ RunTime:0.006917s ]
select * from pdf where partno='SMG3013-390K' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.009126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-390K' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.003772s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564271 AND `partno` = 'SMG3013-390K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.020589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392688 [ RunTime:0.032558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564270 LIMIT 5 [ RunTime:0.009194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564270 ORDER BY `minOrder` ASC [ RunTime:0.013847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564270 ORDER BY `unit` DESC [ RunTime:0.028400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564270 LIMIT 2 [ RunTime:0.016133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564270 ORDER BY `minOrder` ASC [ RunTime:0.009151s ]
select * from pdf where partno='SMG3013-330K' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.028162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-330K' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.013826s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564270 AND `partno` = 'SMG3013-330K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.027559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280173 [ RunTime:0.029021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564269 LIMIT 5 [ RunTime:0.020919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564269 ORDER BY `minOrder` ASC [ RunTime:0.008477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564269 ORDER BY `unit` DESC [ RunTime:0.035030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564269 LIMIT 2 [ RunTime:0.022863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564269 ORDER BY `minOrder` ASC [ RunTime:0.020715s ]
select * from pdf where partno='SMG3013-101KLF' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.014619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-101KLF' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.010823s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564269 AND `partno` = 'SMG3013-101KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.058165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280172 [ RunTime:0.027242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564268 LIMIT 5 [ RunTime:0.042147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564268 ORDER BY `minOrder` ASC [ RunTime:0.055987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564268 ORDER BY `unit` DESC [ RunTime:0.016153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564268 LIMIT 2 [ RunTime:0.018296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564268 ORDER BY `minOrder` ASC [ RunTime:0.006997s ]
select * from pdf where partno='SMG3013-270K' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.061876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-270K' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.039935s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564268 AND `partno` = 'SMG3013-270K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.080122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280171 [ RunTime:0.032286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564267 LIMIT 5 [ RunTime:0.047990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564267 ORDER BY `minOrder` ASC [ RunTime:0.055143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564267 ORDER BY `unit` DESC [ RunTime:0.062807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564267 LIMIT 2 [ RunTime:0.108847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564267 ORDER BY `minOrder` ASC [ RunTime:0.017604s ]
select * from pdf where partno='SMG3013-330KLF' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.069084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-330KLF' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.070745s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564267 AND `partno` = 'SMG3013-330KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.046952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280170 [ RunTime:0.024688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564266 LIMIT 5 [ RunTime:0.074962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564266 ORDER BY `minOrder` ASC [ RunTime:0.083180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564266 ORDER BY `unit` DESC [ RunTime:0.028767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564266 LIMIT 2 [ RunTime:0.022408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564266 ORDER BY `minOrder` ASC [ RunTime:0.017920s ]
select * from pdf where partno='SMG3013-820KLF' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.103578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-820KLF' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.035911s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564266 AND `partno` = 'SMG3013-820KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.051484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280169 [ RunTime:0.046692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564265 LIMIT 5 [ RunTime:0.015655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564265 ORDER BY `minOrder` ASC [ RunTime:0.015423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564265 ORDER BY `unit` DESC [ RunTime:0.028361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564265 LIMIT 2 [ RunTime:0.041533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564265 ORDER BY `minOrder` ASC [ RunTime:0.018591s ]
select * from pdf where partno='SMG3013-470KLF' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.034329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-470KLF' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.079424s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564265 AND `partno` = 'SMG3013-470KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.030236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280168 [ RunTime:0.020223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564264 LIMIT 5 [ RunTime:0.012030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564264 ORDER BY `minOrder` ASC [ RunTime:0.039953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564264 ORDER BY `unit` DESC [ RunTime:0.033286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564264 LIMIT 2 [ RunTime:0.019016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564264 ORDER BY `minOrder` ASC [ RunTime:0.011227s ]
select * from pdf where partno='SMG3013-120K' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.042930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-120K' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.007123s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564264 AND `partno` = 'SMG3013-120K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.070071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392687 [ RunTime:0.058400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564263 LIMIT 5 [ RunTime:0.058095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564263 ORDER BY `minOrder` ASC [ RunTime:0.021283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564263 ORDER BY `unit` DESC [ RunTime:0.075137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564263 LIMIT 2 [ RunTime:0.068656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564263 ORDER BY `minOrder` ASC [ RunTime:0.040116s ]
select * from pdf where partno='SMG3013-150KLF' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.041901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-150KLF' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.055929s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564263 AND `partno` = 'SMG3013-150KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.011354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392686 [ RunTime:0.002770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564262 LIMIT 5 [ RunTime:0.028212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564262 ORDER BY `minOrder` ASC [ RunTime:0.022589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564262 ORDER BY `unit` DESC [ RunTime:0.025828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564262 LIMIT 2 [ RunTime:0.013914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564262 ORDER BY `minOrder` ASC [ RunTime:0.006524s ]
select * from pdf where partno='SMG3013-560KLF' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.019969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-560KLF' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.028190s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564262 AND `partno` = 'SMG3013-560KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.021884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280167 [ RunTime:0.043428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564261 LIMIT 5 [ RunTime:0.037963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564261 ORDER BY `minOrder` ASC [ RunTime:0.022242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564261 ORDER BY `unit` DESC [ RunTime:0.093956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564261 LIMIT 2 [ RunTime:0.019184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564261 ORDER BY `minOrder` ASC [ RunTime:0.009727s ]
select * from pdf where partno='SMG3013-560K' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.024755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-560K' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.065657s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564261 AND `partno` = 'SMG3013-560K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.060962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392685 [ RunTime:0.001183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564260 LIMIT 5 [ RunTime:0.004191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564260 ORDER BY `minOrder` ASC [ RunTime:0.033858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564260 ORDER BY `unit` DESC [ RunTime:0.015468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564260 LIMIT 2 [ RunTime:0.029125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564260 ORDER BY `minOrder` ASC [ RunTime:0.073895s ]
select * from pdf where partno='SMG3013-270KLF' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.047554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-270KLF' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.034959s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564260 AND `partno` = 'SMG3013-270KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.033232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392684 [ RunTime:0.037632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564259 LIMIT 5 [ RunTime:0.030185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564259 ORDER BY `minOrder` ASC [ RunTime:0.017114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564259 ORDER BY `unit` DESC [ RunTime:0.020755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564259 LIMIT 2 [ RunTime:0.013317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564259 ORDER BY `minOrder` ASC [ RunTime:0.010434s ]
select * from pdf where partno='SMG3013-220K' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.006332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-220K' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.029655s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564259 AND `partno` = 'SMG3013-220K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.045677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392683 [ RunTime:0.027081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564258 LIMIT 5 [ RunTime:0.033035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564258 ORDER BY `minOrder` ASC [ RunTime:0.048273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564258 ORDER BY `unit` DESC [ RunTime:0.027807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564258 LIMIT 2 [ RunTime:0.024281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564258 ORDER BY `minOrder` ASC [ RunTime:0.011575s ]
select * from pdf where partno='SMG3013-180KLF' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.032343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-180KLF' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.007451s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564258 AND `partno` = 'SMG3013-180KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.038524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280166 [ RunTime:0.036521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564257 LIMIT 5 [ RunTime:0.052921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564257 ORDER BY `minOrder` ASC [ RunTime:0.025863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564257 ORDER BY `unit` DESC [ RunTime:0.050730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564257 LIMIT 2 [ RunTime:0.086365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564257 ORDER BY `minOrder` ASC [ RunTime:0.026994s ]
select * from pdf where partno='SMG3013-390KLF' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.012830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-390KLF' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.056192s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564257 AND `partno` = 'SMG3013-390KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.032727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392682 [ RunTime:0.023978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564256 LIMIT 5 [ RunTime:0.011902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564256 ORDER BY `minOrder` ASC [ RunTime:0.008706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564256 ORDER BY `unit` DESC [ RunTime:0.017399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564256 LIMIT 2 [ RunTime:0.042217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564256 ORDER BY `minOrder` ASC [ RunTime:0.006099s ]
select * from pdf where partno='SMG3013-150K' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.029857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-150K' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.016896s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564256 AND `partno` = 'SMG3013-150K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.029017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392681 [ RunTime:0.046264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564255 LIMIT 5 [ RunTime:0.013385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564255 ORDER BY `minOrder` ASC [ RunTime:0.016225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564255 ORDER BY `unit` DESC [ RunTime:0.020398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564255 LIMIT 2 [ RunTime:0.009444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564255 ORDER BY `minOrder` ASC [ RunTime:0.010081s ]
select * from pdf where partno='SMG3013-120KLF' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.004562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-120KLF' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.010582s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564255 AND `partno` = 'SMG3013-120KLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.025828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280165 [ RunTime:0.025310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40564254 LIMIT 5 [ RunTime:0.024828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564254 ORDER BY `minOrder` ASC [ RunTime:0.008063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40564254 ORDER BY `unit` DESC [ RunTime:0.016801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40564254 LIMIT 2 [ RunTime:0.007212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40564254 ORDER BY `minOrder` ASC [ RunTime:0.009163s ]
select * from pdf where partno='SMG3013-100K' and brandshort='Gowanda Electronics' limit 1 [ RunTime:0.013765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMG3013-100K' OR `brand` LIKE 'Gowanda Electronics%' ) ) LIMIT 1 [ RunTime:0.013390s ]
SELECT `id` FROM `stock` WHERE `id` <> 40564254 AND `partno` = 'SMG3013-100K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gowanda electronics%' ) [ RunTime:0.033792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14280164 [ RunTime:0.038092s ]
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 'SMG30%' OR `brand` LIKE 'SMG30%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016584s ]
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 'SMG30%' OR `brand` LIKE 'SMG30%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027096s ]
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 'SMG30%' OR `brand` LIKE 'SMG30%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024905s ]
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 'SMG30%' OR `brand` LIKE 'SMG30%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042085s ]
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 'SMG30%' OR `brand` LIKE 'SMG30%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035890s ]
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 'SMG30%' OR `brand` LIKE 'SMG30%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039766s ]
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 'SMG30%' OR `brand` LIKE 'SMG30%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019283s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMG30%' OR `brand` LIKE 'SMG30%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.038068s ]