SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001895s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=15KPA70&search=1' [ RunTime:0.004136s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001694s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000687s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004151s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000414s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001645s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000296s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002105s ]
SELECT * FROM `stock_search` WHERE `partno` = '15KPA70' LIMIT 1 [ RunTime:0.002160s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-19 12:23:56' WHERE `partno` = '15KPA70' [ RunTime:0.011621s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002007s ]
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 '15KPA70%' OR `brand` LIKE '15KPA70%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021011s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664167 LIMIT 5 [ RunTime:0.007301s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664167 ORDER BY `minOrder` ASC [ RunTime:0.000800s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664167 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664167 LIMIT 2 [ RunTime:0.010840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664167 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906400 LIMIT 5 [ RunTime:0.001497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906400 ORDER BY `minOrder` ASC [ RunTime:0.003858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906400 ORDER BY `unit` DESC [ RunTime:0.013582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906400 LIMIT 2 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906400 ORDER BY `minOrder` ASC [ RunTime:0.007403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830875 LIMIT 5 [ RunTime:0.012780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830875 ORDER BY `minOrder` ASC [ RunTime:0.013865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830875 ORDER BY `unit` DESC [ RunTime:0.021855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830875 LIMIT 2 [ RunTime:0.001150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830875 ORDER BY `minOrder` ASC [ RunTime:0.002524s ]
select * from pdf where partno='15KPA70CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800402 LIMIT 5 [ RunTime:0.005885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800402 ORDER BY `minOrder` ASC [ RunTime:0.006257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800402 ORDER BY `unit` DESC [ RunTime:0.014478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800402 LIMIT 2 [ RunTime:0.011179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800402 ORDER BY `minOrder` ASC [ RunTime:0.005391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931281 LIMIT 5 [ RunTime:0.001064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931281 ORDER BY `minOrder` ASC [ RunTime:0.000573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931281 ORDER BY `unit` DESC [ RunTime:0.000519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931281 LIMIT 2 [ RunTime:0.005798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931281 ORDER BY `minOrder` ASC [ RunTime:0.002320s ]
select * from pdf where partno='15KPA70A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684396 LIMIT 5 [ RunTime:0.002993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684396 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16684396 ORDER BY `unit` DESC [ RunTime:0.010499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16684396 LIMIT 2 [ RunTime:0.015899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684396 ORDER BY `minOrder` ASC [ RunTime:0.005473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683352 LIMIT 5 [ RunTime:0.000946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683352 ORDER BY `minOrder` ASC [ RunTime:0.007490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683352 ORDER BY `unit` DESC [ RunTime:0.000452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683352 LIMIT 2 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683352 ORDER BY `minOrder` ASC [ RunTime:0.005590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683351 LIMIT 5 [ RunTime:0.002464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683351 ORDER BY `minOrder` ASC [ RunTime:0.004103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683351 ORDER BY `unit` DESC [ RunTime:0.001357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683351 LIMIT 2 [ RunTime:0.000786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683351 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681954 LIMIT 5 [ RunTime:0.008860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681954 ORDER BY `minOrder` ASC [ RunTime:0.001007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16681954 ORDER BY `unit` DESC [ RunTime:0.003989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16681954 LIMIT 2 [ RunTime:0.009873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681954 ORDER BY `minOrder` ASC [ RunTime:0.014490s ]
select * from pdf where partno='15KPA70CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.006393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681458 LIMIT 5 [ RunTime:0.006213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681458 ORDER BY `minOrder` ASC [ RunTime:0.004202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16681458 ORDER BY `unit` DESC [ RunTime:0.000758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16681458 LIMIT 2 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681458 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680348 LIMIT 5 [ RunTime:0.006521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680348 ORDER BY `minOrder` ASC [ RunTime:0.004594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680348 ORDER BY `unit` DESC [ RunTime:0.003601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680348 LIMIT 2 [ RunTime:0.001849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680348 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680347 LIMIT 5 [ RunTime:0.001355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680347 ORDER BY `minOrder` ASC [ RunTime:0.000785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680347 ORDER BY `unit` DESC [ RunTime:0.000538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680347 LIMIT 2 [ RunTime:0.000856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680347 ORDER BY `minOrder` ASC [ RunTime:0.009530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14824362 LIMIT 5 [ RunTime:0.005135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14824362 ORDER BY `minOrder` ASC [ RunTime:0.006417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14824362 ORDER BY `unit` DESC [ RunTime:0.014247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14824362 LIMIT 2 [ RunTime:0.005749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14824362 ORDER BY `minOrder` ASC [ RunTime:0.003822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14822275 LIMIT 5 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14822275 ORDER BY `minOrder` ASC [ RunTime:0.002764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14822275 ORDER BY `unit` DESC [ RunTime:0.012342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14822275 LIMIT 2 [ RunTime:0.002902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14822275 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
select * from pdf where partno='15KPA70A-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821796 LIMIT 5 [ RunTime:0.011686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821796 ORDER BY `minOrder` ASC [ RunTime:0.001170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14821796 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14821796 LIMIT 2 [ RunTime:0.002018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821796 ORDER BY `minOrder` ASC [ RunTime:0.004620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931033 LIMIT 5 [ RunTime:0.002058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931033 ORDER BY `minOrder` ASC [ RunTime:0.007721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931033 ORDER BY `unit` DESC [ RunTime:0.002317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931033 LIMIT 2 [ RunTime:0.001008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931033 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931032 LIMIT 5 [ RunTime:0.001989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931032 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931032 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931032 LIMIT 2 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931032 ORDER BY `minOrder` ASC [ RunTime:0.002412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928610 LIMIT 5 [ RunTime:0.000944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928610 ORDER BY `minOrder` ASC [ RunTime:0.004520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928610 ORDER BY `unit` DESC [ RunTime:0.008851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928610 LIMIT 2 [ RunTime:0.010643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928610 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928609 LIMIT 5 [ RunTime:0.000559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928609 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928609 ORDER BY `unit` DESC [ RunTime:0.003832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928609 LIMIT 2 [ RunTime:0.010457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928609 ORDER BY `minOrder` ASC [ RunTime:0.006511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925609 LIMIT 5 [ RunTime:0.002839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925609 ORDER BY `minOrder` ASC [ RunTime:0.006302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13925609 ORDER BY `unit` DESC [ RunTime:0.005752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13925609 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925609 ORDER BY `minOrder` ASC [ RunTime:0.000237s ]
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 '15KPA70%' OR `brand` LIKE '15KPA70%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015727s ]
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 '15KPA70%' OR `brand` LIKE '15KPA70%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42166280 LIMIT 5 [ RunTime:0.002390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42166280 ORDER BY `minOrder` ASC [ RunTime:0.023655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42166280 ORDER BY `unit` DESC [ RunTime:0.003206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42166280 LIMIT 2 [ RunTime:0.006961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42166280 ORDER BY `minOrder` ASC [ RunTime:0.002260s ]
select * from pdf where partno='15KPA70A' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.009567s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70A' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.004387s ]
SELECT `id` FROM `stock` WHERE `id` <> 42166280 AND `partno` = '15KPA70A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.007630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664167 [ RunTime:0.000588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42158087 LIMIT 5 [ RunTime:0.011098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158087 ORDER BY `minOrder` ASC [ RunTime:0.006992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42158087 ORDER BY `unit` DESC [ RunTime:0.005445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42158087 LIMIT 2 [ RunTime:0.000559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158087 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
select * from pdf where partno='15KPA70CA' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.002825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.003163s ]
SELECT `id` FROM `stock` WHERE `id` <> 42158087 AND `partno` = '15KPA70CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.007558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906400 [ RunTime:0.000624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42109292 LIMIT 5 [ RunTime:0.019806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109292 ORDER BY `minOrder` ASC [ RunTime:0.001516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42109292 ORDER BY `unit` DESC [ RunTime:0.000767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42109292 LIMIT 2 [ RunTime:0.003176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109292 ORDER BY `minOrder` ASC [ RunTime:0.003086s ]
select * from pdf where partno='15KPA70CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.006459s ]
SELECT `id` FROM `stock` WHERE `id` <> 42109292 AND `partno` = '15KPA70CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.017043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830875 [ RunTime:0.001355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42109293 LIMIT 5 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109293 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42109293 ORDER BY `unit` DESC [ RunTime:0.011864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42109293 LIMIT 2 [ RunTime:0.005062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109293 ORDER BY `minOrder` ASC [ RunTime:0.001986s ]
select * from pdf where partno='15KPA70A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000818s ]
SELECT `id` FROM `stock` WHERE `id` <> 42109293 AND `partno` = '15KPA70A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.010121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931281 [ RunTime:0.004317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42145098 LIMIT 5 [ RunTime:0.012333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145098 ORDER BY `minOrder` ASC [ RunTime:0.023855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42145098 ORDER BY `unit` DESC [ RunTime:0.001579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42145098 LIMIT 2 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145098 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
select * from pdf where partno='15KPA70CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.001049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42418214 LIMIT 5 [ RunTime:0.003621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418214 ORDER BY `minOrder` ASC [ RunTime:0.009912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42418214 ORDER BY `unit` DESC [ RunTime:0.006792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42418214 LIMIT 2 [ RunTime:0.005346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418214 ORDER BY `minOrder` ASC [ RunTime:0.003273s ]
select * from pdf where partno='15KPA70CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.008300s ]
SELECT `id` FROM `stock` WHERE `id` <> 42418214 AND `partno` = '15KPA70CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684396 [ RunTime:0.011887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42418213 LIMIT 5 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418213 ORDER BY `minOrder` ASC [ RunTime:0.000654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42418213 ORDER BY `unit` DESC [ RunTime:0.000553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42418213 LIMIT 2 [ RunTime:0.004405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418213 ORDER BY `minOrder` ASC [ RunTime:0.002319s ]
select * from pdf where partno='15KPA70A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.002714s ]
SELECT `id` FROM `stock` WHERE `id` <> 42418213 AND `partno` = '15KPA70A-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.018791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925609 [ RunTime:0.008351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42417661 LIMIT 5 [ RunTime:0.001617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417661 ORDER BY `minOrder` ASC [ RunTime:0.000650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42417661 ORDER BY `unit` DESC [ RunTime:0.001378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42417661 LIMIT 2 [ RunTime:0.005777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417661 ORDER BY `minOrder` ASC [ RunTime:0.000906s ]
select * from pdf where partno='15KPA70CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003773s ]
SELECT `id` FROM `stock` WHERE `id` <> 42417661 AND `partno` = '15KPA70CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.005050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925435 [ RunTime:0.000947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42417660 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417660 ORDER BY `minOrder` ASC [ RunTime:0.005232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42417660 ORDER BY `unit` DESC [ RunTime:0.003411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42417660 LIMIT 2 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417660 ORDER BY `minOrder` ASC [ RunTime:0.002136s ]
select * from pdf where partno='15KPA70A-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001096s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70A-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001758s ]
SELECT `id` FROM `stock` WHERE `id` <> 42417660 AND `partno` = '15KPA70A-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14824362 [ RunTime:0.000497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42402401 LIMIT 5 [ RunTime:0.002780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402401 ORDER BY `minOrder` ASC [ RunTime:0.004333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42402401 ORDER BY `unit` DESC [ RunTime:0.002394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42402401 LIMIT 2 [ RunTime:0.001307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402401 ORDER BY `minOrder` ASC [ RunTime:0.002100s ]
select * from pdf where partno='15KPA70E3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.002424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70E3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.000809s ]
SELECT `id` FROM `stock` WHERE `id` <> 42402401 AND `partno` = '15KPA70E3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.000737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924706 [ RunTime:0.000876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42402400 LIMIT 5 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402400 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42402400 ORDER BY `unit` DESC [ RunTime:0.005523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42402400 LIMIT 2 [ RunTime:0.002032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402400 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
select * from pdf where partno='15KPA70CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.004749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.005016s ]
SELECT `id` FROM `stock` WHERE `id` <> 42402400 AND `partno` = '15KPA70CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.005293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924705 [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42402399 LIMIT 5 [ RunTime:0.001889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402399 ORDER BY `minOrder` ASC [ RunTime:0.005368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42402399 ORDER BY `unit` DESC [ RunTime:0.001925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42402399 LIMIT 2 [ RunTime:0.017294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402399 ORDER BY `minOrder` ASC [ RunTime:0.000709s ]
select * from pdf where partno='15KPA70CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.002909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.012243s ]
SELECT `id` FROM `stock` WHERE `id` <> 42402399 AND `partno` = '15KPA70CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.001087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683352 [ RunTime:0.002710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42402398 LIMIT 5 [ RunTime:0.004374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402398 ORDER BY `minOrder` ASC [ RunTime:0.000711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42402398 ORDER BY `unit` DESC [ RunTime:0.005276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42402398 LIMIT 2 [ RunTime:0.002149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402398 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='15KPA70AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.007194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.001041s ]
SELECT `id` FROM `stock` WHERE `id` <> 42402398 AND `partno` = '15KPA70AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.001218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683351 [ RunTime:0.000690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42333094 LIMIT 5 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42333094 ORDER BY `minOrder` ASC [ RunTime:0.003142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42333094 ORDER BY `unit` DESC [ RunTime:0.007070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42333094 LIMIT 2 [ RunTime:0.010431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42333094 ORDER BY `minOrder` ASC [ RunTime:0.008278s ]
select * from pdf where partno='15KPA70A-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70A-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001016s ]
SELECT `id` FROM `stock` WHERE `id` <> 42333094 AND `partno` = '15KPA70A-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14822275 [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42333090 LIMIT 5 [ RunTime:0.001160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42333090 ORDER BY `minOrder` ASC [ RunTime:0.002526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42333090 ORDER BY `unit` DESC [ RunTime:0.002507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42333090 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42333090 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='15KPA70CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.008664s ]
SELECT `id` FROM `stock` WHERE `id` <> 42333090 AND `partno` = '15KPA70CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681954 [ RunTime:0.003771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42327557 LIMIT 5 [ RunTime:0.003760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327557 ORDER BY `minOrder` ASC [ RunTime:0.004646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42327557 ORDER BY `unit` DESC [ RunTime:0.001796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42327557 LIMIT 2 [ RunTime:0.010856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327557 ORDER BY `minOrder` ASC [ RunTime:0.000669s ]
select * from pdf where partno='15KPA70A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.003596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42327546 LIMIT 5 [ RunTime:0.003264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327546 ORDER BY `minOrder` ASC [ RunTime:0.004883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42327546 ORDER BY `unit` DESC [ RunTime:0.001862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42327546 LIMIT 2 [ RunTime:0.005319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327546 ORDER BY `minOrder` ASC [ RunTime:0.001429s ]
select * from pdf where partno='15KPA70A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.002183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42327522 LIMIT 5 [ RunTime:0.002129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327522 ORDER BY `minOrder` ASC [ RunTime:0.002715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42327522 ORDER BY `unit` DESC [ RunTime:0.001537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42327522 LIMIT 2 [ RunTime:0.007822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327522 ORDER BY `minOrder` ASC [ RunTime:0.001413s ]
select * from pdf where partno='15KPA70CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.002291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42318463 LIMIT 5 [ RunTime:0.005579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42318463 ORDER BY `minOrder` ASC [ RunTime:0.000817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42318463 ORDER BY `unit` DESC [ RunTime:0.002785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42318463 LIMIT 2 [ RunTime:0.000887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42318463 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
select * from pdf where partno='15KPA70A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.001179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.000467s ]
SELECT `id` FROM `stock` WHERE `id` <> 42318463 AND `partno` = '15KPA70A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.001876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680347 [ RunTime:0.003087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42313314 LIMIT 5 [ RunTime:0.001578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42313314 ORDER BY `minOrder` ASC [ RunTime:0.001274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42313314 ORDER BY `unit` DESC [ RunTime:0.001101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42313314 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42313314 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='15KPA70CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.001064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.003207s ]
SELECT `id` FROM `stock` WHERE `id` <> 42313314 AND `partno` = '15KPA70CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.006557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680348 [ RunTime:0.000865s ]
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 '15KPA70%' OR `brand` LIKE '15KPA70%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004516s ]
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 '15KPA70%' OR `brand` LIKE '15KPA70%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001561s ]
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 '15KPA70%' OR `brand` LIKE '15KPA70%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002693s ]
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 '15KPA70%' OR `brand` LIKE '15KPA70%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002967s ]
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 '15KPA70%' OR `brand` LIKE '15KPA70%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001895s ]
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 '15KPA70%' OR `brand` LIKE '15KPA70%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006089s ]
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 '15KPA70%' OR `brand` LIKE '15KPA70%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023911s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15KPA70%' OR `brand` LIKE '15KPA70%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003339s ]