SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002110s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.215' , `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=1N458&search=1' [ RunTime:0.009258s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002468s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009153s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002240s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.215' ) [ RunTime:0.001326s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002186s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002364s ]
SELECT * FROM `stock_search` WHERE `partno` = '1N458' LIMIT 1 [ RunTime:0.025910s ]
UPDATE `stock_search` SET `count` = 15 , `updatetime` = '2026-08-30 01:57:33' WHERE `partno` = '1N458' [ RunTime:0.007696s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.008707s ]
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 '1N458%' OR `brand` LIKE '1N458%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008104s ]
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 '1N458%' OR `brand` LIKE '1N458%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066381s ]
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 '1N458%' OR `brand` LIKE '1N458%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093215s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44093295 LIMIT 5 [ RunTime:0.037135s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44093295 ORDER BY `minOrder` ASC [ RunTime:0.075950s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44093295 ORDER BY `unit` DESC [ RunTime:0.041096s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44093295 LIMIT 2 [ RunTime:0.063637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44093295 ORDER BY `minOrder` ASC [ RunTime:0.031587s ]
select * from pdf where partno='1N458A' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.058298s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N458A' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.019125s ]
SELECT `id` FROM `stock` WHERE `id` <> 44093295 AND `partno` = '1N458A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.098531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44093251 LIMIT 5 [ RunTime:0.088272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44093251 ORDER BY `minOrder` ASC [ RunTime:0.116475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44093251 ORDER BY `unit` DESC [ RunTime:0.138093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44093251 LIMIT 2 [ RunTime:0.078227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44093251 ORDER BY `minOrder` ASC [ RunTime:0.041795s ]
select * from pdf where partno='1N458ATR' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.050661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N458ATR' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.126936s ]
SELECT `id` FROM `stock` WHERE `id` <> 44093251 AND `partno` = '1N458ATR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.031607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44083341 LIMIT 5 [ RunTime:0.047601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083341 ORDER BY `minOrder` ASC [ RunTime:0.046451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44083341 ORDER BY `unit` DESC [ RunTime:0.081489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44083341 LIMIT 2 [ RunTime:0.041666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083341 ORDER BY `minOrder` ASC [ RunTime:0.034054s ]
select * from pdf where partno='1N458ATR' and brandshort='onsemi' limit 1 [ RunTime:0.016044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N458ATR' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.058748s ]
SELECT `id` FROM `stock` WHERE `id` <> 44083341 AND `partno` = '1N458ATR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.068903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44089701 LIMIT 5 [ RunTime:0.030187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089701 ORDER BY `minOrder` ASC [ RunTime:0.013396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44089701 ORDER BY `unit` DESC [ RunTime:0.009103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44089701 LIMIT 2 [ RunTime:0.033162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44089701 ORDER BY `minOrder` ASC [ RunTime:0.021235s ]
select * from pdf where partno='1N4586GP-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4586GP-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.008683s ]
SELECT `id` FROM `stock` WHERE `id` <> 44089701 AND `partno` = '1N4586GP-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.019108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080363 LIMIT 5 [ RunTime:0.039319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080363 ORDER BY `minOrder` ASC [ RunTime:0.030610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080363 ORDER BY `unit` DESC [ RunTime:0.023716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080363 LIMIT 2 [ RunTime:0.024405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080363 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
select * from pdf where partno='1N458A' and brandshort='onsemi' limit 1 [ RunTime:0.001165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N458A' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.020959s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080363 AND `partno` = '1N458A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.016509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58646414 LIMIT 5 [ RunTime:0.017041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58646414 ORDER BY `minOrder` ASC [ RunTime:0.003874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58646414 ORDER BY `unit` DESC [ RunTime:0.014538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58646414 LIMIT 2 [ RunTime:0.006529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58646414 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
select * from pdf where partno='1N4580AUR-1/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.011767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4580AUR-1/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.008986s ]
SELECT `id` FROM `stock` WHERE `id` <> 58646414 AND `partno` = '1N4580AUR-1/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.009912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58646418 LIMIT 5 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58646418 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58646418 ORDER BY `unit` DESC [ RunTime:0.007213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58646418 LIMIT 2 [ RunTime:0.002424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58646418 ORDER BY `minOrder` ASC [ RunTime:0.012643s ]
select * from pdf where partno='1N4581AUR-1/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.004578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4581AUR-1/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.002681s ]
SELECT `id` FROM `stock` WHERE `id` <> 58646418 AND `partno` = '1N4581AUR-1/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.004722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58654793 LIMIT 5 [ RunTime:0.010222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58654793 ORDER BY `minOrder` ASC [ RunTime:0.044464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58654793 ORDER BY `unit` DESC [ RunTime:0.016573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58654793 LIMIT 2 [ RunTime:0.045321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58654793 ORDER BY `minOrder` ASC [ RunTime:0.012641s ]
select * from pdf where partno='1N4582AUR-1/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.022516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4582AUR-1/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.009346s ]
SELECT `id` FROM `stock` WHERE `id` <> 58654793 AND `partno` = '1N4582AUR-1/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.000832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58654788 LIMIT 5 [ RunTime:0.025270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58654788 ORDER BY `minOrder` ASC [ RunTime:0.004073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58654788 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58654788 LIMIT 2 [ RunTime:0.023172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58654788 ORDER BY `minOrder` ASC [ RunTime:0.007443s ]
select * from pdf where partno='1N4582A-1' and brandshort='Microchip Technology' limit 1 [ RunTime:0.012544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4582A-1' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.009520s ]
SELECT `id` FROM `stock` WHERE `id` <> 58654788 AND `partno` = '1N4582A-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.052732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58654791 LIMIT 5 [ RunTime:0.030021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58654791 ORDER BY `minOrder` ASC [ RunTime:0.009086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58654791 ORDER BY `unit` DESC [ RunTime:0.028867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58654791 LIMIT 2 [ RunTime:0.028806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58654791 ORDER BY `minOrder` ASC [ RunTime:0.064355s ]
select * from pdf where partno='1N4582A' and brandshort='Microchip Technology' limit 1 [ RunTime:0.036311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4582A' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.040119s ]
SELECT `id` FROM `stock` WHERE `id` <> 58654791 AND `partno` = '1N4582A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.011472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58693345 LIMIT 5 [ RunTime:0.037859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58693345 ORDER BY `minOrder` ASC [ RunTime:0.049262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58693345 ORDER BY `unit` DESC [ RunTime:0.027814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58693345 LIMIT 2 [ RunTime:0.068631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58693345 ORDER BY `minOrder` ASC [ RunTime:0.029666s ]
select * from pdf where partno='1N4584A-1' and brandshort='Microchip Technology' limit 1 [ RunTime:0.016226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4584A-1' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.036766s ]
SELECT `id` FROM `stock` WHERE `id` <> 58693345 AND `partno` = '1N4584A-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.066153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58693344 LIMIT 5 [ RunTime:0.031664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58693344 ORDER BY `minOrder` ASC [ RunTime:0.065943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58693344 ORDER BY `unit` DESC [ RunTime:0.078272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58693344 LIMIT 2 [ RunTime:0.025378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58693344 ORDER BY `minOrder` ASC [ RunTime:0.038171s ]
select * from pdf where partno='1N4584-1' and brandshort='Microchip Technology' limit 1 [ RunTime:0.032212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4584-1' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.024542s ]
SELECT `id` FROM `stock` WHERE `id` <> 58693344 AND `partno` = '1N4584-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.042984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58692191 LIMIT 5 [ RunTime:0.054827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58692191 ORDER BY `minOrder` ASC [ RunTime:0.059128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58692191 ORDER BY `unit` DESC [ RunTime:0.041338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58692191 LIMIT 2 [ RunTime:0.014870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58692191 ORDER BY `minOrder` ASC [ RunTime:0.013385s ]
select * from pdf where partno='1N4584A/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.074790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4584A/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.023643s ]
SELECT `id` FROM `stock` WHERE `id` <> 58692191 AND `partno` = '1N4584A/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.027816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58692190 LIMIT 5 [ RunTime:0.030487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58692190 ORDER BY `minOrder` ASC [ RunTime:0.036694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58692190 ORDER BY `unit` DESC [ RunTime:0.048613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58692190 LIMIT 2 [ RunTime:0.027878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58692190 ORDER BY `minOrder` ASC [ RunTime:0.043985s ]
select * from pdf where partno='1N4584/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.011773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4584/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.026797s ]
SELECT `id` FROM `stock` WHERE `id` <> 58692190 AND `partno` = '1N4584/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.020678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58692158 LIMIT 5 [ RunTime:0.022201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58692158 ORDER BY `minOrder` ASC [ RunTime:0.081648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58692158 ORDER BY `unit` DESC [ RunTime:0.023409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58692158 LIMIT 2 [ RunTime:0.024884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58692158 ORDER BY `minOrder` ASC [ RunTime:0.012561s ]
select * from pdf where partno='1N4584A' and brandshort='Microchip Technology' limit 1 [ RunTime:0.018770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4584A' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.014507s ]
SELECT `id` FROM `stock` WHERE `id` <> 58692158 AND `partno` = '1N4584A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.036439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58692157 LIMIT 5 [ RunTime:0.011659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58692157 ORDER BY `minOrder` ASC [ RunTime:0.027630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58692157 ORDER BY `unit` DESC [ RunTime:0.046465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58692157 LIMIT 2 [ RunTime:0.013832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58692157 ORDER BY `minOrder` ASC [ RunTime:0.003621s ]
select * from pdf where partno='1N4584' and brandshort='Microchip Technology' limit 1 [ RunTime:0.012532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4584' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.034837s ]
SELECT `id` FROM `stock` WHERE `id` <> 58692157 AND `partno` = '1N4584' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.020906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58687718 LIMIT 5 [ RunTime:0.019555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58687718 ORDER BY `minOrder` ASC [ RunTime:0.028859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58687718 ORDER BY `unit` DESC [ RunTime:0.014703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58687718 LIMIT 2 [ RunTime:0.032250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58687718 ORDER BY `minOrder` ASC [ RunTime:0.007333s ]
select * from pdf where partno='1N4583/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.017391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4583/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.020705s ]
SELECT `id` FROM `stock` WHERE `id` <> 58687718 AND `partno` = '1N4583/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.077024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58687717 LIMIT 5 [ RunTime:0.032442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58687717 ORDER BY `minOrder` ASC [ RunTime:0.025833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58687717 ORDER BY `unit` DESC [ RunTime:0.036052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58687717 LIMIT 2 [ RunTime:0.077965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58687717 ORDER BY `minOrder` ASC [ RunTime:0.007983s ]
select * from pdf where partno='1N4583A/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.059974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4583A/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.026958s ]
SELECT `id` FROM `stock` WHERE `id` <> 58687717 AND `partno` = '1N4583A/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.073742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58687715 LIMIT 5 [ RunTime:0.097559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58687715 ORDER BY `minOrder` ASC [ RunTime:0.022521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58687715 ORDER BY `unit` DESC [ RunTime:0.092276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58687715 LIMIT 2 [ RunTime:0.029066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58687715 ORDER BY `minOrder` ASC [ RunTime:0.037452s ]
select * from pdf where partno='1N4583A-1/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.061093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4583A-1/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.006769s ]
SELECT `id` FROM `stock` WHERE `id` <> 58687715 AND `partno` = '1N4583A-1/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.053133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58687633 LIMIT 5 [ RunTime:0.057471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58687633 ORDER BY `minOrder` ASC [ RunTime:0.076751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58687633 ORDER BY `unit` DESC [ RunTime:0.064659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58687633 LIMIT 2 [ RunTime:0.113867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58687633 ORDER BY `minOrder` ASC [ RunTime:0.031917s ]
select * from pdf where partno='1N4581-1' and brandshort='Microchip Technology' limit 1 [ RunTime:0.050750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4581-1' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.073981s ]
SELECT `id` FROM `stock` WHERE `id` <> 58687633 AND `partno` = '1N4581-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.075787s ]
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 '1N458%' OR `brand` LIKE '1N458%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.089836s ]
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 '1N458%' OR `brand` LIKE '1N458%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.147807s ]
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 '1N458%' OR `brand` LIKE '1N458%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.102549s ]
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 '1N458%' OR `brand` LIKE '1N458%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081566s ]
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 '1N458%' OR `brand` LIKE '1N458%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093860s ]
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 '1N458%' OR `brand` LIKE '1N458%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062151s ]
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 '1N458%' OR `brand` LIKE '1N458%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067125s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1N458%' OR `brand` LIKE '1N458%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.042156s ]