SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001151s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.15' , `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=P6SMB160&search=1' [ RunTime:0.001585s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000945s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000463s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001568s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.15' ) [ RunTime:0.002760s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001570s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003097s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001208s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6SMB160' LIMIT 1 [ RunTime:0.001721s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-13 23:10:35' WHERE `partno` = 'P6SMB160' [ RunTime:0.001842s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001476s ]
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 'P6SMB160%' OR `brand` LIKE 'P6SMB160%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020799s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906584 LIMIT 5 [ RunTime:0.018024s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906584 ORDER BY `minOrder` ASC [ RunTime:0.010356s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906584 ORDER BY `unit` DESC [ RunTime:0.010041s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906584 LIMIT 2 [ RunTime:0.025007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906584 ORDER BY `minOrder` ASC [ RunTime:0.017282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906509 LIMIT 5 [ RunTime:0.012653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906509 ORDER BY `minOrder` ASC [ RunTime:0.055463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906509 ORDER BY `unit` DESC [ RunTime:0.002071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906509 LIMIT 2 [ RunTime:0.024364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906509 ORDER BY `minOrder` ASC [ RunTime:0.010615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675147 LIMIT 5 [ RunTime:0.021545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675147 ORDER BY `minOrder` ASC [ RunTime:0.030841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675147 ORDER BY `unit` DESC [ RunTime:0.054162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675147 LIMIT 2 [ RunTime:0.062740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675147 ORDER BY `minOrder` ASC [ RunTime:0.020594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692166 LIMIT 5 [ RunTime:0.016999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692166 ORDER BY `minOrder` ASC [ RunTime:0.035350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692166 ORDER BY `unit` DESC [ RunTime:0.053478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692166 LIMIT 2 [ RunTime:0.041096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692166 ORDER BY `minOrder` ASC [ RunTime:0.042317s ]
select * from pdf where partno='P6SMB160A-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.040841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14826344 LIMIT 5 [ RunTime:0.026919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14826344 ORDER BY `minOrder` ASC [ RunTime:0.009014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14826344 ORDER BY `unit` DESC [ RunTime:0.017104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14826344 LIMIT 2 [ RunTime:0.035425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14826344 ORDER BY `minOrder` ASC [ RunTime:0.001236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827506 LIMIT 5 [ RunTime:0.049210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827506 ORDER BY `minOrder` ASC [ RunTime:0.066175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827506 ORDER BY `unit` DESC [ RunTime:0.042056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827506 LIMIT 2 [ RunTime:0.016949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827506 ORDER BY `minOrder` ASC [ RunTime:0.010263s ]
select * from pdf where partno='P6SMB160CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.025013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14826715 LIMIT 5 [ RunTime:0.023018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14826715 ORDER BY `minOrder` ASC [ RunTime:0.022153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14826715 ORDER BY `unit` DESC [ RunTime:0.018603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14826715 LIMIT 2 [ RunTime:0.020379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14826715 ORDER BY `minOrder` ASC [ RunTime:0.021218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662816 LIMIT 5 [ RunTime:0.015342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662816 ORDER BY `minOrder` ASC [ RunTime:0.116453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662816 ORDER BY `unit` DESC [ RunTime:0.027605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662816 LIMIT 2 [ RunTime:0.043591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662816 ORDER BY `minOrder` ASC [ RunTime:0.042385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829814 LIMIT 5 [ RunTime:0.035547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829814 ORDER BY `minOrder` ASC [ RunTime:0.063264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829814 ORDER BY `unit` DESC [ RunTime:0.016459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829814 LIMIT 2 [ RunTime:0.022109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829814 ORDER BY `minOrder` ASC [ RunTime:0.026245s ]
select * from pdf where partno='P6SMB160A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.046017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908115 LIMIT 5 [ RunTime:0.013886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908115 ORDER BY `minOrder` ASC [ RunTime:0.012908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908115 ORDER BY `unit` DESC [ RunTime:0.029286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908115 LIMIT 2 [ RunTime:0.032805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908115 ORDER BY `minOrder` ASC [ RunTime:0.011442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692134 LIMIT 5 [ RunTime:0.002928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692134 ORDER BY `minOrder` ASC [ RunTime:0.004458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692134 ORDER BY `unit` DESC [ RunTime:0.004454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692134 LIMIT 2 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692134 ORDER BY `minOrder` ASC [ RunTime:0.004713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691375 LIMIT 5 [ RunTime:0.004748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691375 ORDER BY `minOrder` ASC [ RunTime:0.008072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691375 ORDER BY `unit` DESC [ RunTime:0.005206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691375 LIMIT 2 [ RunTime:0.001018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691375 ORDER BY `minOrder` ASC [ RunTime:0.005122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691374 LIMIT 5 [ RunTime:0.001731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691374 ORDER BY `minOrder` ASC [ RunTime:0.014125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691374 ORDER BY `unit` DESC [ RunTime:0.006661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691374 LIMIT 2 [ RunTime:0.023645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691374 ORDER BY `minOrder` ASC [ RunTime:0.026507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691373 LIMIT 5 [ RunTime:0.015282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691373 ORDER BY `minOrder` ASC [ RunTime:0.028018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691373 ORDER BY `unit` DESC [ RunTime:0.005703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691373 LIMIT 2 [ RunTime:0.008979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691373 ORDER BY `minOrder` ASC [ RunTime:0.018344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672456 LIMIT 5 [ RunTime:0.049866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672456 ORDER BY `minOrder` ASC [ RunTime:0.010319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672456 ORDER BY `unit` DESC [ RunTime:0.018720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672456 LIMIT 2 [ RunTime:0.038999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672456 ORDER BY `minOrder` ASC [ RunTime:0.017975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672361 LIMIT 5 [ RunTime:0.024685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672361 ORDER BY `minOrder` ASC [ RunTime:0.038499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672361 ORDER BY `unit` DESC [ RunTime:0.016058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672361 LIMIT 2 [ RunTime:0.003973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672361 ORDER BY `minOrder` ASC [ RunTime:0.016287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671226 LIMIT 5 [ RunTime:0.018397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671226 ORDER BY `minOrder` ASC [ RunTime:0.033177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671226 ORDER BY `unit` DESC [ RunTime:0.014136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671226 LIMIT 2 [ RunTime:0.011100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671226 ORDER BY `minOrder` ASC [ RunTime:0.016724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671218 LIMIT 5 [ RunTime:0.004411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671218 ORDER BY `minOrder` ASC [ RunTime:0.014584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671218 ORDER BY `unit` DESC [ RunTime:0.013010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671218 LIMIT 2 [ RunTime:0.073261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671218 ORDER BY `minOrder` ASC [ RunTime:0.011324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671144 LIMIT 5 [ RunTime:0.008899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671144 ORDER BY `minOrder` ASC [ RunTime:0.047131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671144 ORDER BY `unit` DESC [ RunTime:0.022930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671144 LIMIT 2 [ RunTime:0.002688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671144 ORDER BY `minOrder` ASC [ RunTime:0.000567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670864 LIMIT 5 [ RunTime:0.007802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670864 ORDER BY `minOrder` ASC [ RunTime:0.009381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670864 ORDER BY `unit` DESC [ RunTime:0.029198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670864 LIMIT 2 [ RunTime:0.007756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670864 ORDER BY `minOrder` ASC [ RunTime:0.010047s ]
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 'P6SMB160%' OR `brand` LIKE 'P6SMB160%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140704 LIMIT 5 [ RunTime:0.014068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140704 ORDER BY `minOrder` ASC [ RunTime:0.004610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140704 ORDER BY `unit` DESC [ RunTime:0.014059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140704 LIMIT 2 [ RunTime:0.006039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140704 ORDER BY `minOrder` ASC [ RunTime:0.002897s ]
select * from pdf where partno='p6smb160a-q' and brandshort='bourns' limit 1 [ RunTime:0.004013s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'p6smb160a-q' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.011034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51025690 LIMIT 5 [ RunTime:0.000720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025690 ORDER BY `minOrder` ASC [ RunTime:0.007463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51025690 ORDER BY `unit` DESC [ RunTime:0.024559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51025690 LIMIT 2 [ RunTime:0.026392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025690 ORDER BY `minOrder` ASC [ RunTime:0.002483s ]
select * from pdf where partno='p6smb160a-q' and brandshort='bourns' limit 1 [ RunTime:0.002753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'p6smb160a-q' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.002385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141335 LIMIT 5 [ RunTime:0.005630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141335 ORDER BY `minOrder` ASC [ RunTime:0.010034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141335 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141335 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141335 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
select * from pdf where partno='p6smb160a' and brandshort='bourns' limit 1 [ RunTime:0.006083s ]
select foldpath,foldpath2,filename from pdf_file where id=1697651 limit 1 [ RunTime:0.028541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'p6smb160a' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.024673s ]
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 'P6SMB160%' OR `brand` LIKE 'P6SMB160%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160749 LIMIT 5 [ RunTime:0.035600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160749 ORDER BY `minOrder` ASC [ RunTime:0.036307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160749 ORDER BY `unit` DESC [ RunTime:0.013713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160749 LIMIT 2 [ RunTime:0.013730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160749 ORDER BY `minOrder` ASC [ RunTime:0.002776s ]
select * from pdf where partno='P6SMB160CA' and brandshort='NextGen Components' limit 1 [ RunTime:0.019215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160CA' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.003601s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160749 AND `partno` = 'P6SMB160CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.008803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906584 [ RunTime:0.007543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159948 LIMIT 5 [ RunTime:0.003133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159948 ORDER BY `minOrder` ASC [ RunTime:0.008631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159948 ORDER BY `unit` DESC [ RunTime:0.046711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159948 LIMIT 2 [ RunTime:0.029839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159948 ORDER BY `minOrder` ASC [ RunTime:0.010941s ]
select * from pdf where partno='P6SMB160A' and brandshort='NextGen Components' limit 1 [ RunTime:0.015006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160A' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.022173s ]
SELECT `id` FROM `stock` WHERE `id` <> 42159948 AND `partno` = 'P6SMB160A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.019601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906509 [ RunTime:0.001501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162163 LIMIT 5 [ RunTime:0.004664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162163 ORDER BY `minOrder` ASC [ RunTime:0.006423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162163 ORDER BY `unit` DESC [ RunTime:0.000915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162163 LIMIT 2 [ RunTime:0.010417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162163 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
select * from pdf where partno='P6SMB160AL160A' and brandshort='LGE Diodes' limit 1 [ RunTime:0.001011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160AL160A' OR `brand` LIKE 'LGE Diodes%' ) ) LIMIT 1 [ RunTime:0.010117s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162163 AND `partno` = 'P6SMB160AL160A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lge diodes%' ) [ RunTime:0.018502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162123 LIMIT 5 [ RunTime:0.011052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162123 ORDER BY `minOrder` ASC [ RunTime:0.004471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162123 ORDER BY `unit` DESC [ RunTime:0.002580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162123 LIMIT 2 [ RunTime:0.007514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162123 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='P6SMB160CL160C' and brandshort='LGE Diodes' limit 1 [ RunTime:0.005345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160CL160C' OR `brand` LIKE 'LGE Diodes%' ) ) LIMIT 1 [ RunTime:0.012866s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162123 AND `partno` = 'P6SMB160CL160C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lge diodes%' ) [ RunTime:0.013671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112588 LIMIT 5 [ RunTime:0.011687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112588 ORDER BY `minOrder` ASC [ RunTime:0.009820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112588 ORDER BY `unit` DESC [ RunTime:0.001434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112588 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112588 ORDER BY `minOrder` ASC [ RunTime:0.002702s ]
select * from pdf where partno='P6SMB160A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.009766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.027918s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112588 AND `partno` = 'P6SMB160A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.014095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675147 [ RunTime:0.004357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42129943 LIMIT 5 [ RunTime:0.004330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42129943 ORDER BY `minOrder` ASC [ RunTime:0.005259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42129943 ORDER BY `unit` DESC [ RunTime:0.005860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42129943 LIMIT 2 [ RunTime:0.003410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42129943 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
select * from pdf where partno='P6SMB160A-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160A-M3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004546s ]
SELECT `id` FROM `stock` WHERE `id` <> 42129943 AND `partno` = 'P6SMB160A-M3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.005888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692166 [ RunTime:0.002826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42151519 LIMIT 5 [ RunTime:0.021876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151519 ORDER BY `minOrder` ASC [ RunTime:0.010521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42151519 ORDER BY `unit` DESC [ RunTime:0.003942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42151519 LIMIT 2 [ RunTime:0.003118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151519 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
select * from pdf where partno='P6SMB160A' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.001304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160A' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.002549s ]
SELECT `id` FROM `stock` WHERE `id` <> 42151519 AND `partno` = 'P6SMB160A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.003181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14826344 [ RunTime:0.017503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42124943 LIMIT 5 [ RunTime:0.001587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124943 ORDER BY `minOrder` ASC [ RunTime:0.004572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42124943 ORDER BY `unit` DESC [ RunTime:0.001301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42124943 LIMIT 2 [ RunTime:0.006144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124943 ORDER BY `minOrder` ASC [ RunTime:0.001918s ]
select * from pdf where partno='P6SMB160CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.015725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.019780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128175 LIMIT 5 [ RunTime:0.027468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128175 ORDER BY `minOrder` ASC [ RunTime:0.023962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128175 ORDER BY `unit` DESC [ RunTime:0.006336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128175 LIMIT 2 [ RunTime:0.005447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128175 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='P6SMB160CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160CA-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.005616s ]
SELECT `id` FROM `stock` WHERE `id` <> 42128175 AND `partno` = 'P6SMB160CA-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827506 [ RunTime:0.005069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101084 LIMIT 5 [ RunTime:0.015874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101084 ORDER BY `minOrder` ASC [ RunTime:0.015482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101084 ORDER BY `unit` DESC [ RunTime:0.018420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101084 LIMIT 2 [ RunTime:0.007377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101084 ORDER BY `minOrder` ASC [ RunTime:0.003077s ]
select * from pdf where partno='P6SMB160A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.017968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160A-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009814s ]
SELECT `id` FROM `stock` WHERE `id` <> 42101084 AND `partno` = 'P6SMB160A-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802790 [ RunTime:0.019803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42127697 LIMIT 5 [ RunTime:0.015250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127697 ORDER BY `minOrder` ASC [ RunTime:0.027446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42127697 ORDER BY `unit` DESC [ RunTime:0.004553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42127697 LIMIT 2 [ RunTime:0.012122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127697 ORDER BY `minOrder` ASC [ RunTime:0.014381s ]
select * from pdf where partno='P6SMB160A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.006118s ]
SELECT `id` FROM `stock` WHERE `id` <> 42127697 AND `partno` = 'P6SMB160A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.006825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829814 [ RunTime:0.017666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42173432 LIMIT 5 [ RunTime:0.005824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173432 ORDER BY `minOrder` ASC [ RunTime:0.006304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42173432 ORDER BY `unit` DESC [ RunTime:0.007323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42173432 LIMIT 2 [ RunTime:0.011855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173432 ORDER BY `minOrder` ASC [ RunTime:0.010006s ]
select * from pdf where partno='P6SMB160AS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160AS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.010469s ]
SELECT `id` FROM `stock` WHERE `id` <> 42173432 AND `partno` = 'P6SMB160AS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.008178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908115 [ RunTime:0.025162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42260483 LIMIT 5 [ RunTime:0.002059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42260483 ORDER BY `minOrder` ASC [ RunTime:0.011331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42260483 ORDER BY `unit` DESC [ RunTime:0.001065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42260483 LIMIT 2 [ RunTime:0.005143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42260483 ORDER BY `minOrder` ASC [ RunTime:0.004933s ]
select * from pdf where partno='P6SMB160A BK PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.008794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160A BK PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.007480s ]
SELECT `id` FROM `stock` WHERE `id` <> 42260483 AND `partno` = 'P6SMB160A BK PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.013698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814902 [ RunTime:0.014203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42256660 LIMIT 5 [ RunTime:0.012477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256660 ORDER BY `minOrder` ASC [ RunTime:0.013496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42256660 ORDER BY `unit` DESC [ RunTime:0.006468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42256660 LIMIT 2 [ RunTime:0.016484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256660 ORDER BY `minOrder` ASC [ RunTime:0.010307s ]
select * from pdf where partno='P6SMB160CAHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001856s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160CAHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003266s ]
SELECT `id` FROM `stock` WHERE `id` <> 42256660 AND `partno` = 'P6SMB160CAHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915727 [ RunTime:0.009203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42256654 LIMIT 5 [ RunTime:0.011756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256654 ORDER BY `minOrder` ASC [ RunTime:0.002684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42256654 ORDER BY `unit` DESC [ RunTime:0.003165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42256654 LIMIT 2 [ RunTime:0.006311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256654 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='P6SMB160CAHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160CAHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003621s ]
SELECT `id` FROM `stock` WHERE `id` <> 42256654 AND `partno` = 'P6SMB160CAHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.005588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812948 [ RunTime:0.006250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42246859 LIMIT 5 [ RunTime:0.002999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246859 ORDER BY `minOrder` ASC [ RunTime:0.010083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42246859 ORDER BY `unit` DESC [ RunTime:0.005407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42246859 LIMIT 2 [ RunTime:0.014450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246859 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
select * from pdf where partno='P6SMB160CAHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160CAHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004122s ]
SELECT `id` FROM `stock` WHERE `id` <> 42246859 AND `partno` = 'P6SMB160CAHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812953 [ RunTime:0.014541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42246629 LIMIT 5 [ RunTime:0.006148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246629 ORDER BY `minOrder` ASC [ RunTime:0.003335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42246629 ORDER BY `unit` DESC [ RunTime:0.007461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42246629 LIMIT 2 [ RunTime:0.011269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246629 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
select * from pdf where partno='P6SMB160CAHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160CAHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007873s ]
SELECT `id` FROM `stock` WHERE `id` <> 42246629 AND `partno` = 'P6SMB160CAHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915721 [ RunTime:0.007742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242506 LIMIT 5 [ RunTime:0.009645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242506 ORDER BY `minOrder` ASC [ RunTime:0.003726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242506 ORDER BY `unit` DESC [ RunTime:0.003722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242506 LIMIT 2 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242506 ORDER BY `minOrder` ASC [ RunTime:0.006076s ]
select * from pdf where partno='P6SMB160CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007725s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242506 AND `partno` = 'P6SMB160CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813385 [ RunTime:0.007173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242475 LIMIT 5 [ RunTime:0.006682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242475 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242475 ORDER BY `unit` DESC [ RunTime:0.004624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242475 LIMIT 2 [ RunTime:0.008962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242475 ORDER BY `minOrder` ASC [ RunTime:0.005503s ]
select * from pdf where partno='P6SMB160CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.006091s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242475 AND `partno` = 'P6SMB160CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.002844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811771 [ RunTime:0.004971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42240992 LIMIT 5 [ RunTime:0.006039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240992 ORDER BY `minOrder` ASC [ RunTime:0.011852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42240992 ORDER BY `unit` DESC [ RunTime:0.000769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42240992 LIMIT 2 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240992 ORDER BY `minOrder` ASC [ RunTime:0.007271s ]
select * from pdf where partno='P6SMB160AHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB160AHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002769s ]
SELECT `id` FROM `stock` WHERE `id` <> 42240992 AND `partno` = 'P6SMB160AHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671226 [ RunTime:0.003790s ]
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 'P6SMB160%' OR `brand` LIKE 'P6SMB160%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003172s ]
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 'P6SMB160%' OR `brand` LIKE 'P6SMB160%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002295s ]
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 'P6SMB160%' OR `brand` LIKE 'P6SMB160%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001128s ]
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 'P6SMB160%' OR `brand` LIKE 'P6SMB160%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003668s ]
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 'P6SMB160%' OR `brand` LIKE 'P6SMB160%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004750s ]
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 'P6SMB160%' OR `brand` LIKE 'P6SMB160%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002374s ]
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 'P6SMB160%' OR `brand` LIKE 'P6SMB160%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001188s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P6SMB160%' OR `brand` LIKE 'P6SMB160%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001920s ]