SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002187s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=SR4&search=1' [ RunTime:0.004897s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003134s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002424s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002149s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.006706s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.004181s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002045s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001861s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SR4' LIMIT 1 [ RunTime:0.006749s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 15:06:00' WHERE `partno` = 'SR4' [ RunTime:0.025523s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002721s ]
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 'SR4%' OR `brand` LIKE 'SR4%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055197s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15317836 LIMIT 5 [ RunTime:0.012000s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15317836 ORDER BY `minOrder` ASC [ RunTime:0.008294s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15317836 ORDER BY `unit` DESC [ RunTime:0.001615s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15317836 LIMIT 2 [ RunTime:0.002919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15317836 ORDER BY `minOrder` ASC [ RunTime:0.009345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13254803 LIMIT 5 [ RunTime:0.007504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254803 ORDER BY `minOrder` ASC [ RunTime:0.015861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13254803 ORDER BY `unit` DESC [ RunTime:0.008173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13254803 LIMIT 2 [ RunTime:0.009804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254803 ORDER BY `minOrder` ASC [ RunTime:0.012306s ]
select * from pdf where partno='SR4L034-L' and brandshort='Antenova' limit 1 [ RunTime:0.022911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15317858 LIMIT 5 [ RunTime:0.021114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15317858 ORDER BY `minOrder` ASC [ RunTime:0.031078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15317858 ORDER BY `unit` DESC [ RunTime:0.028992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15317858 LIMIT 2 [ RunTime:0.036784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15317858 ORDER BY `minOrder` ASC [ RunTime:0.016529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13254783 LIMIT 5 [ RunTime:0.022282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254783 ORDER BY `minOrder` ASC [ RunTime:0.007842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13254783 ORDER BY `unit` DESC [ RunTime:0.027324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13254783 LIMIT 2 [ RunTime:0.013052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254783 ORDER BY `minOrder` ASC [ RunTime:0.017934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11984204 LIMIT 5 [ RunTime:0.014728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11984204 ORDER BY `minOrder` ASC [ RunTime:0.013962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11984204 ORDER BY `unit` DESC [ RunTime:0.016474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11984204 LIMIT 2 [ RunTime:0.024012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11984204 ORDER BY `minOrder` ASC [ RunTime:0.009121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15317852 LIMIT 5 [ RunTime:0.010823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15317852 ORDER BY `minOrder` ASC [ RunTime:0.011068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15317852 ORDER BY `unit` DESC [ RunTime:0.006503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15317852 LIMIT 2 [ RunTime:0.010619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15317852 ORDER BY `minOrder` ASC [ RunTime:0.010139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13260583 LIMIT 5 [ RunTime:0.017375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13260583 ORDER BY `minOrder` ASC [ RunTime:0.022719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13260583 ORDER BY `unit` DESC [ RunTime:0.007231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13260583 LIMIT 2 [ RunTime:0.037820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13260583 ORDER BY `minOrder` ASC [ RunTime:0.015116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11984179 LIMIT 5 [ RunTime:0.007899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11984179 ORDER BY `minOrder` ASC [ RunTime:0.003458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11984179 ORDER BY `unit` DESC [ RunTime:0.026500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11984179 LIMIT 2 [ RunTime:0.002355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11984179 ORDER BY `minOrder` ASC [ RunTime:0.006412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13254806 LIMIT 5 [ RunTime:0.015446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254806 ORDER BY `minOrder` ASC [ RunTime:0.031080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13254806 ORDER BY `unit` DESC [ RunTime:0.023102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13254806 LIMIT 2 [ RunTime:0.018156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254806 ORDER BY `minOrder` ASC [ RunTime:0.006791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13254792 LIMIT 5 [ RunTime:0.012590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254792 ORDER BY `minOrder` ASC [ RunTime:0.008832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13254792 ORDER BY `unit` DESC [ RunTime:0.014236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13254792 LIMIT 2 [ RunTime:0.011286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254792 ORDER BY `minOrder` ASC [ RunTime:0.015619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17141152 LIMIT 5 [ RunTime:0.019285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17141152 ORDER BY `minOrder` ASC [ RunTime:0.032700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17141152 ORDER BY `unit` DESC [ RunTime:0.015176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17141152 LIMIT 2 [ RunTime:0.015032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17141152 ORDER BY `minOrder` ASC [ RunTime:0.007219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11984194 LIMIT 5 [ RunTime:0.018109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11984194 ORDER BY `minOrder` ASC [ RunTime:0.011154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11984194 ORDER BY `unit` DESC [ RunTime:0.026235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11984194 LIMIT 2 [ RunTime:0.020031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11984194 ORDER BY `minOrder` ASC [ RunTime:0.005560s ]
select * from pdf where partno='SR4L034-R' and brandshort='Antenova' limit 1 [ RunTime:0.015900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13259332 LIMIT 5 [ RunTime:0.020076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259332 ORDER BY `minOrder` ASC [ RunTime:0.043969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13259332 ORDER BY `unit` DESC [ RunTime:0.044431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13259332 LIMIT 2 [ RunTime:0.027826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259332 ORDER BY `minOrder` ASC [ RunTime:0.010222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17097177 LIMIT 5 [ RunTime:0.024900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17097177 ORDER BY `minOrder` ASC [ RunTime:0.015405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17097177 ORDER BY `unit` DESC [ RunTime:0.044655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17097177 LIMIT 2 [ RunTime:0.006608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17097177 ORDER BY `minOrder` ASC [ RunTime:0.002866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987446 LIMIT 5 [ RunTime:0.008303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987446 ORDER BY `minOrder` ASC [ RunTime:0.005758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987446 ORDER BY `unit` DESC [ RunTime:0.023897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987446 LIMIT 2 [ RunTime:0.008216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987446 ORDER BY `minOrder` ASC [ RunTime:0.073463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985843 LIMIT 5 [ RunTime:0.065758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985843 ORDER BY `minOrder` ASC [ RunTime:0.031489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985843 ORDER BY `unit` DESC [ RunTime:0.007627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985843 LIMIT 2 [ RunTime:0.007493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985843 ORDER BY `minOrder` ASC [ RunTime:0.022809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17097179 LIMIT 5 [ RunTime:0.046944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17097179 ORDER BY `minOrder` ASC [ RunTime:0.032389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17097179 ORDER BY `unit` DESC [ RunTime:0.038134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17097179 LIMIT 2 [ RunTime:0.015930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17097179 ORDER BY `minOrder` ASC [ RunTime:0.023803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14227816 LIMIT 5 [ RunTime:0.035437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14227816 ORDER BY `minOrder` ASC [ RunTime:0.024748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14227816 ORDER BY `unit` DESC [ RunTime:0.020966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14227816 LIMIT 2 [ RunTime:0.008696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14227816 ORDER BY `minOrder` ASC [ RunTime:0.009919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14024270 LIMIT 5 [ RunTime:0.025972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14024270 ORDER BY `minOrder` ASC [ RunTime:0.020604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14024270 ORDER BY `unit` DESC [ RunTime:0.013414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14024270 LIMIT 2 [ RunTime:0.024276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14024270 ORDER BY `minOrder` ASC [ RunTime:0.002053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16073649 LIMIT 5 [ RunTime:0.005760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16073649 ORDER BY `minOrder` ASC [ RunTime:0.005532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16073649 ORDER BY `unit` DESC [ RunTime:0.001775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16073649 LIMIT 2 [ RunTime:0.021413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16073649 ORDER BY `minOrder` ASC [ RunTime:0.012188s ]
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 'SR4%' OR `brand` LIKE 'SR4%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114269 LIMIT 5 [ RunTime:0.006450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114269 ORDER BY `minOrder` ASC [ RunTime:0.019392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114269 ORDER BY `unit` DESC [ RunTime:0.008669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114269 LIMIT 2 [ RunTime:0.013104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114269 ORDER BY `minOrder` ASC [ RunTime:0.001139s ]
select * from pdf where partno='sr4g080' and brandshort='antenova' limit 1 [ RunTime:0.006511s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4g080' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.015893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32303971 LIMIT 5 [ RunTime:0.015382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32303971 ORDER BY `minOrder` ASC [ RunTime:0.012408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32303971 ORDER BY `unit` DESC [ RunTime:0.006968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32303971 LIMIT 2 [ RunTime:0.011653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32303971 ORDER BY `minOrder` ASC [ RunTime:0.004114s ]
select * from pdf where partno='sr4g080' and brandshort='antenova' limit 1 [ RunTime:0.002983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4g080' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.001511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32295940 LIMIT 5 [ RunTime:0.002995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32295940 ORDER BY `minOrder` ASC [ RunTime:0.020777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32295940 ORDER BY `unit` DESC [ RunTime:0.028499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32295940 LIMIT 2 [ RunTime:0.037907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32295940 ORDER BY `minOrder` ASC [ RunTime:0.010225s ]
select * from pdf where partno='sr4g080' and brandshort='antenova' limit 1 [ RunTime:0.000986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4g080' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.000579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114268 LIMIT 5 [ RunTime:0.013700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114268 ORDER BY `minOrder` ASC [ RunTime:0.021414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114268 ORDER BY `unit` DESC [ RunTime:0.008886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114268 LIMIT 2 [ RunTime:0.018827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114268 ORDER BY `minOrder` ASC [ RunTime:0.011501s ]
select * from pdf where partno='sr4g013' and brandshort='antenova' limit 1 [ RunTime:0.026073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4g013' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.011140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304214 LIMIT 5 [ RunTime:0.005681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304214 ORDER BY `minOrder` ASC [ RunTime:0.020401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304214 ORDER BY `unit` DESC [ RunTime:0.002971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304214 LIMIT 2 [ RunTime:0.008446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304214 ORDER BY `minOrder` ASC [ RunTime:0.011774s ]
select * from pdf where partno='sr4g013' and brandshort='antenova' limit 1 [ RunTime:0.006312s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4g013' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.018047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296089 LIMIT 5 [ RunTime:0.009132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296089 ORDER BY `minOrder` ASC [ RunTime:0.021635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296089 ORDER BY `unit` DESC [ RunTime:0.032734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296089 LIMIT 2 [ RunTime:0.010500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296089 ORDER BY `minOrder` ASC [ RunTime:0.011668s ]
select * from pdf where partno='sr4g013' and brandshort='antenova' limit 1 [ RunTime:0.004482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4g013' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.004880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304728 LIMIT 5 [ RunTime:0.016810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304728 ORDER BY `minOrder` ASC [ RunTime:0.043061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304728 ORDER BY `unit` DESC [ RunTime:0.018537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304728 LIMIT 2 [ RunTime:0.016172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304728 ORDER BY `minOrder` ASC [ RunTime:0.023192s ]
select * from pdf where partno='sr4w030-100' and brandshort='antenova' limit 1 [ RunTime:0.014388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4w030-100' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.012206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296495 LIMIT 5 [ RunTime:0.023505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296495 ORDER BY `minOrder` ASC [ RunTime:0.033288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296495 ORDER BY `unit` DESC [ RunTime:0.026968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296495 LIMIT 2 [ RunTime:0.009407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296495 ORDER BY `minOrder` ASC [ RunTime:0.007699s ]
select * from pdf where partno='sr4w030-100' and brandshort='antenova' limit 1 [ RunTime:0.007523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4w030-100' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.013162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114705 LIMIT 5 [ RunTime:0.010873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114705 ORDER BY `minOrder` ASC [ RunTime:0.015869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114705 ORDER BY `unit` DESC [ RunTime:0.015828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114705 LIMIT 2 [ RunTime:0.025327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114705 ORDER BY `minOrder` ASC [ RunTime:0.007396s ]
select * from pdf where partno='sr4w030-100' and brandshort='antenova' limit 1 [ RunTime:0.005738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4w030-100' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.002694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32289973 LIMIT 5 [ RunTime:0.004327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32289973 ORDER BY `minOrder` ASC [ RunTime:0.026154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32289973 ORDER BY `unit` DESC [ RunTime:0.004220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32289973 LIMIT 2 [ RunTime:0.009827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32289973 ORDER BY `minOrder` ASC [ RunTime:0.031801s ]
select * from pdf where partno='sr400-200m-4227' and brandshort='doodle labs' limit 1 [ RunTime:0.020582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr400-200m-4227' OR `brand` LIKE 'doodle labs%' ) ) LIMIT 1 [ RunTime:0.019669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304912 LIMIT 5 [ RunTime:0.009018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304912 ORDER BY `minOrder` ASC [ RunTime:0.006152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304912 ORDER BY `unit` DESC [ RunTime:0.014408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304912 LIMIT 2 [ RunTime:0.024033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304912 ORDER BY `minOrder` ASC [ RunTime:0.010328s ]
select * from pdf where partno='sr4l054' and brandshort='antenova' limit 1 [ RunTime:0.009965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4l054' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.017197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296692 LIMIT 5 [ RunTime:0.008497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296692 ORDER BY `minOrder` ASC [ RunTime:0.013047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296692 ORDER BY `unit` DESC [ RunTime:0.003734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296692 LIMIT 2 [ RunTime:0.016326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296692 ORDER BY `minOrder` ASC [ RunTime:0.005140s ]
select * from pdf where partno='sr4l054' and brandshort='antenova' limit 1 [ RunTime:0.009181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4l054' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.004127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114858 LIMIT 5 [ RunTime:0.024678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114858 ORDER BY `minOrder` ASC [ RunTime:0.025037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114858 ORDER BY `unit` DESC [ RunTime:0.022695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114858 LIMIT 2 [ RunTime:0.025991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114858 ORDER BY `minOrder` ASC [ RunTime:0.010829s ]
select * from pdf where partno='sr4l054' and brandshort='antenova' limit 1 [ RunTime:0.008002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4l054' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.008393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114193 LIMIT 5 [ RunTime:0.005685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114193 ORDER BY `minOrder` ASC [ RunTime:0.008626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114193 ORDER BY `unit` DESC [ RunTime:0.001001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114193 LIMIT 2 [ RunTime:0.007181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114193 ORDER BY `minOrder` ASC [ RunTime:0.008834s ]
select * from pdf where partno='sr4l075' and brandshort='antenova' limit 1 [ RunTime:0.004733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4l075' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.013684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304133 LIMIT 5 [ RunTime:0.016899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304133 ORDER BY `minOrder` ASC [ RunTime:0.020065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304133 ORDER BY `unit` DESC [ RunTime:0.008907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304133 LIMIT 2 [ RunTime:0.002174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304133 ORDER BY `minOrder` ASC [ RunTime:0.002519s ]
select * from pdf where partno='sr4l075' and brandshort='antenova' limit 1 [ RunTime:0.008026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4l075' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.002237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296012 LIMIT 5 [ RunTime:0.010446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296012 ORDER BY `minOrder` ASC [ RunTime:0.005328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296012 ORDER BY `unit` DESC [ RunTime:0.004249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296012 LIMIT 2 [ RunTime:0.003177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296012 ORDER BY `minOrder` ASC [ RunTime:0.008312s ]
select * from pdf where partno='sr4l075' and brandshort='antenova' limit 1 [ RunTime:0.003322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4l075' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51088235 LIMIT 5 [ RunTime:0.016413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088235 ORDER BY `minOrder` ASC [ RunTime:0.009841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51088235 ORDER BY `unit` DESC [ RunTime:0.017080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51088235 LIMIT 2 [ RunTime:0.020070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088235 ORDER BY `minOrder` ASC [ RunTime:0.029705s ]
select * from pdf where partno='sr4m4006' and brandshort='te connectivity' limit 1 [ RunTime:0.016920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4m4006' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.036101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51115347 LIMIT 5 [ RunTime:0.003260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51115347 ORDER BY `minOrder` ASC [ RunTime:0.021227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51115347 ORDER BY `unit` DESC [ RunTime:0.013127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51115347 LIMIT 2 [ RunTime:0.008485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51115347 ORDER BY `minOrder` ASC [ RunTime:0.002434s ]
select * from pdf where partno='sr4w030-150' and brandshort='antenova' limit 1 [ RunTime:0.011713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4w030-150' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.006035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296600 LIMIT 5 [ RunTime:0.004959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296600 ORDER BY `minOrder` ASC [ RunTime:0.003096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296600 ORDER BY `unit` DESC [ RunTime:0.006532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296600 LIMIT 2 [ RunTime:0.004560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296600 ORDER BY `minOrder` ASC [ RunTime:0.006225s ]
select * from pdf where partno='sr4w030-150' and brandshort='antenova' limit 1 [ RunTime:0.003066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4w030-150' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.002941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304688 LIMIT 5 [ RunTime:0.010718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304688 ORDER BY `minOrder` ASC [ RunTime:0.026083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304688 ORDER BY `unit` DESC [ RunTime:0.009945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304688 LIMIT 2 [ RunTime:0.009595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304688 ORDER BY `minOrder` ASC [ RunTime:0.002158s ]
select * from pdf where partno='sr4c005' and brandshort='antenova' limit 1 [ RunTime:0.014876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sr4c005' OR `brand` LIKE 'antenova%' ) ) LIMIT 1 [ RunTime:0.009457s ]
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 'SR4%' OR `brand` LIKE 'SR4%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57020858 LIMIT 5 [ RunTime:0.004969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57020858 ORDER BY `minOrder` ASC [ RunTime:0.003575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57020858 ORDER BY `unit` DESC [ RunTime:0.017410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57020858 LIMIT 2 [ RunTime:0.012950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57020858 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
select * from pdf where partno='SR4410LRL' and brandshort='onsemi' limit 1 [ RunTime:0.001894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4410LRL' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.044388s ]
SELECT `id` FROM `stock` WHERE `id` <> 57020858 AND `partno` = 'SR4410LRL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.004203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15317836 [ RunTime:0.002252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50017492 LIMIT 5 [ RunTime:0.001988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50017492 ORDER BY `minOrder` ASC [ RunTime:0.000939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50017492 ORDER BY `unit` DESC [ RunTime:0.005851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50017492 LIMIT 2 [ RunTime:0.004384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50017492 ORDER BY `minOrder` ASC [ RunTime:0.000778s ]
select * from pdf where partno='SR4461' and brandshort='onsemi' limit 1 [ RunTime:0.000738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4461' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.012174s ]
SELECT `id` FROM `stock` WHERE `id` <> 50017492 AND `partno` = 'SR4461' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.003241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15317858 [ RunTime:0.000516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37213608 LIMIT 5 [ RunTime:0.001931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37213608 ORDER BY `minOrder` ASC [ RunTime:0.011030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37213608 ORDER BY `unit` DESC [ RunTime:0.001977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37213608 LIMIT 2 [ RunTime:0.010050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37213608 ORDER BY `minOrder` ASC [ RunTime:0.001821s ]
select * from pdf where partno='SR4461' and brandshort='onsemi' limit 1 [ RunTime:0.001313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4461' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.001418s ]
SELECT `id` FROM `stock` WHERE `id` <> 37213608 AND `partno` = 'SR4461' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.002987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15317858 [ RunTime:0.004246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413243 LIMIT 5 [ RunTime:0.007792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413243 ORDER BY `minOrder` ASC [ RunTime:0.011683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413243 ORDER BY `unit` DESC [ RunTime:0.004258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413243 LIMIT 2 [ RunTime:0.007103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413243 ORDER BY `minOrder` ASC [ RunTime:0.008938s ]
select * from pdf where partno='SR4W035' and brandshort='Antenova' limit 1 [ RunTime:0.001160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4W035' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.003519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57021003 LIMIT 5 [ RunTime:0.005895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57021003 ORDER BY `minOrder` ASC [ RunTime:0.016219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57021003 ORDER BY `unit` DESC [ RunTime:0.005558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57021003 LIMIT 2 [ RunTime:0.002872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57021003 ORDER BY `minOrder` ASC [ RunTime:0.000970s ]
select * from pdf where partno='SR4445' and brandshort='onsemi' limit 1 [ RunTime:0.015233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4445' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.038447s ]
SELECT `id` FROM `stock` WHERE `id` <> 57021003 AND `partno` = 'SR4445' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.010368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15317852 [ RunTime:0.022759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413302 LIMIT 5 [ RunTime:0.006637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413302 ORDER BY `minOrder` ASC [ RunTime:0.015760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413302 ORDER BY `unit` DESC [ RunTime:0.011479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413302 LIMIT 2 [ RunTime:0.003454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413302 ORDER BY `minOrder` ASC [ RunTime:0.001669s ]
select * from pdf where partno='SR4L034-L' and brandshort='Antenova' limit 1 [ RunTime:0.000780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4L034-L' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.002745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413315 LIMIT 5 [ RunTime:0.003515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413315 ORDER BY `minOrder` ASC [ RunTime:0.004477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413315 ORDER BY `unit` DESC [ RunTime:0.001018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413315 LIMIT 2 [ RunTime:0.004173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413315 ORDER BY `minOrder` ASC [ RunTime:0.003344s ]
select * from pdf where partno='SR4L002' and brandshort='Antenova' limit 1 [ RunTime:0.009073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4L002' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.009060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413275 LIMIT 5 [ RunTime:0.002966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413275 ORDER BY `minOrder` ASC [ RunTime:0.001927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413275 ORDER BY `unit` DESC [ RunTime:0.000747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413275 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413275 ORDER BY `minOrder` ASC [ RunTime:0.005458s ]
select * from pdf where partno='SR4G008' and brandshort='Antenova' limit 1 [ RunTime:0.002745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4G008' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.007185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413266 LIMIT 5 [ RunTime:0.017063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413266 ORDER BY `minOrder` ASC [ RunTime:0.005533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413266 ORDER BY `unit` DESC [ RunTime:0.005159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413266 LIMIT 2 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413266 ORDER BY `minOrder` ASC [ RunTime:0.004312s ]
select * from pdf where partno='SR42W001' and brandshort='Antenova' limit 1 [ RunTime:0.002141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR42W001' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.012075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413273 LIMIT 5 [ RunTime:0.003073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413273 ORDER BY `minOrder` ASC [ RunTime:0.004183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413273 ORDER BY `unit` DESC [ RunTime:0.002138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413273 LIMIT 2 [ RunTime:0.012131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413273 ORDER BY `minOrder` ASC [ RunTime:0.002854s ]
select * from pdf where partno='SR42I010-R' and brandshort='Antenova' limit 1 [ RunTime:0.017518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR42I010-R' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.009814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413322 LIMIT 5 [ RunTime:0.003609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413322 ORDER BY `minOrder` ASC [ RunTime:0.000832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413322 ORDER BY `unit` DESC [ RunTime:0.006442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413322 LIMIT 2 [ RunTime:0.003307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413322 ORDER BY `minOrder` ASC [ RunTime:0.001375s ]
select * from pdf where partno='SR4L049-R' and brandshort='Antenova' limit 1 [ RunTime:0.003413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4L049-R' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.003773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39473790 LIMIT 5 [ RunTime:0.001953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39473790 ORDER BY `minOrder` ASC [ RunTime:0.003068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39473790 ORDER BY `unit` DESC [ RunTime:0.009080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39473790 LIMIT 2 [ RunTime:0.005111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39473790 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
select * from pdf where partno='SR401C105KAR' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.007854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR401C105KAR' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.010434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57020913 LIMIT 5 [ RunTime:0.004233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57020913 ORDER BY `minOrder` ASC [ RunTime:0.006422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57020913 ORDER BY `unit` DESC [ RunTime:0.005144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57020913 LIMIT 2 [ RunTime:0.004989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57020913 ORDER BY `minOrder` ASC [ RunTime:0.001229s ]
select * from pdf where partno='SR4490' and brandshort='onsemi' limit 1 [ RunTime:0.001336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4490' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.028027s ]
SELECT `id` FROM `stock` WHERE `id` <> 57020913 AND `partno` = 'SR4490' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.002621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17097177 [ RunTime:0.008590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413316 LIMIT 5 [ RunTime:0.011850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413316 ORDER BY `minOrder` ASC [ RunTime:0.010941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413316 ORDER BY `unit` DESC [ RunTime:0.003779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413316 LIMIT 2 [ RunTime:0.000925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413316 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
select * from pdf where partno='SR4L049-L' and brandshort='Antenova' limit 1 [ RunTime:0.002124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4L049-L' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.005106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57021049 LIMIT 5 [ RunTime:0.004777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57021049 ORDER BY `minOrder` ASC [ RunTime:0.008530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57021049 ORDER BY `unit` DESC [ RunTime:0.000684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57021049 LIMIT 2 [ RunTime:0.023875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57021049 ORDER BY `minOrder` ASC [ RunTime:0.005074s ]
select * from pdf where partno='SR4475S' and brandshort='onsemi' limit 1 [ RunTime:0.005847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4475S' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.016492s ]
SELECT `id` FROM `stock` WHERE `id` <> 57021049 AND `partno` = 'SR4475S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14227816 [ RunTime:0.003309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57020924 LIMIT 5 [ RunTime:0.011037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57020924 ORDER BY `minOrder` ASC [ RunTime:0.003051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57020924 ORDER BY `unit` DESC [ RunTime:0.011674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57020924 LIMIT 2 [ RunTime:0.002666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57020924 ORDER BY `minOrder` ASC [ RunTime:0.001246s ]
select * from pdf where partno='SR4431' and brandshort='onsemi' limit 1 [ RunTime:0.013501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4431' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.027543s ]
SELECT `id` FROM `stock` WHERE `id` <> 57020924 AND `partno` = 'SR4431' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17097179 [ RunTime:0.006876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413819 LIMIT 5 [ RunTime:0.003059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413819 ORDER BY `minOrder` ASC [ RunTime:0.004715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413819 ORDER BY `unit` DESC [ RunTime:0.002121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413819 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413819 ORDER BY `minOrder` ASC [ RunTime:0.002119s ]
select * from pdf where partno='SR4I052' and brandshort='Antenova' limit 1 [ RunTime:0.008494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4I052' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.005312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413323 LIMIT 5 [ RunTime:0.001020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413323 ORDER BY `minOrder` ASC [ RunTime:0.006403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413323 ORDER BY `unit` DESC [ RunTime:0.007816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413323 LIMIT 2 [ RunTime:0.006028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413323 ORDER BY `minOrder` ASC [ RunTime:0.002390s ]
select * from pdf where partno='SR4L034-R' and brandshort='Antenova' limit 1 [ RunTime:0.000643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4L034-R' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.012988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57020925 LIMIT 5 [ RunTime:0.013884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57020925 ORDER BY `minOrder` ASC [ RunTime:0.010397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57020925 ORDER BY `unit` DESC [ RunTime:0.007271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57020925 LIMIT 2 [ RunTime:0.014013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57020925 ORDER BY `minOrder` ASC [ RunTime:0.003050s ]
select * from pdf where partno='SR4263' and brandshort='onsemi' limit 1 [ RunTime:0.012491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4263' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.017380s ]
SELECT `id` FROM `stock` WHERE `id` <> 57020925 AND `partno` = 'SR4263' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.001021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16073649 [ RunTime:0.005526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413356 LIMIT 5 [ RunTime:0.002967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413356 ORDER BY `minOrder` ASC [ RunTime:0.005066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413356 ORDER BY `unit` DESC [ RunTime:0.009263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413356 LIMIT 2 [ RunTime:0.012773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413356 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='SR4G053' and brandshort='Antenova' limit 1 [ RunTime:0.001653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4G053' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.001469s ]
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 'SR4%' OR `brand` LIKE 'SR4%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001567s ]
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 'SR4%' OR `brand` LIKE 'SR4%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003974s ]
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 'SR4%' OR `brand` LIKE 'SR4%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002992s ]
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 'SR4%' OR `brand` LIKE 'SR4%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002703s ]
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 'SR4%' OR `brand` LIKE 'SR4%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001221s ]
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 'SR4%' OR `brand` LIKE 'SR4%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005433s ]
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 'SR4%' OR `brand` LIKE 'SR4%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004626s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SR4%' OR `brand` LIKE 'SR4%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007345s ]