SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001972s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.194' , `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=SA28A&search=1' [ RunTime:0.001669s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001158s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000461s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001895s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.194' ) [ RunTime:0.004736s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001270s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000213s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001596s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SA28A' LIMIT 1 [ RunTime:0.009653s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-02 22:46:56' WHERE `partno` = 'SA28A' [ RunTime:0.007742s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001317s ]
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 'SA28A%' OR `brand` LIKE 'SA28A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013107s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662238 LIMIT 5 [ RunTime:0.014078s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662238 ORDER BY `minOrder` ASC [ RunTime:0.006515s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662238 ORDER BY `unit` DESC [ RunTime:0.019071s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.022688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662238 LIMIT 2 [ RunTime:0.043899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662238 ORDER BY `minOrder` ASC [ RunTime:0.015060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907212 LIMIT 5 [ RunTime:0.026443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907212 ORDER BY `minOrder` ASC [ RunTime:0.031696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907212 ORDER BY `unit` DESC [ RunTime:0.034122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907212 LIMIT 2 [ RunTime:0.047573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907212 ORDER BY `minOrder` ASC [ RunTime:0.027868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801055 LIMIT 5 [ RunTime:0.020749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801055 ORDER BY `minOrder` ASC [ RunTime:0.017479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801055 ORDER BY `unit` DESC [ RunTime:0.042630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801055 LIMIT 2 [ RunTime:0.022918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801055 ORDER BY `minOrder` ASC [ RunTime:0.022867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661446 LIMIT 5 [ RunTime:0.014303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661446 ORDER BY `minOrder` ASC [ RunTime:0.032187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661446 ORDER BY `unit` DESC [ RunTime:0.040711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661446 LIMIT 2 [ RunTime:0.031909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661446 ORDER BY `minOrder` ASC [ RunTime:0.027519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692797 LIMIT 5 [ RunTime:0.025750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692797 ORDER BY `minOrder` ASC [ RunTime:0.029982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692797 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692797 LIMIT 2 [ RunTime:0.009283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692797 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673548 LIMIT 5 [ RunTime:0.019176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673548 ORDER BY `minOrder` ASC [ RunTime:0.008094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673548 ORDER BY `unit` DESC [ RunTime:0.010736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673548 LIMIT 2 [ RunTime:0.006207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673548 ORDER BY `minOrder` ASC [ RunTime:0.007730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662232 LIMIT 5 [ RunTime:0.047434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662232 ORDER BY `minOrder` ASC [ RunTime:0.008176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662232 ORDER BY `unit` DESC [ RunTime:0.021629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662232 LIMIT 2 [ RunTime:0.001539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662232 ORDER BY `minOrder` ASC [ RunTime:0.006857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833523 LIMIT 5 [ RunTime:0.031686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833523 ORDER BY `minOrder` ASC [ RunTime:0.009146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833523 ORDER BY `unit` DESC [ RunTime:0.024544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833523 LIMIT 2 [ RunTime:0.003392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833523 ORDER BY `minOrder` ASC [ RunTime:0.005730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833508 LIMIT 5 [ RunTime:0.005686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833508 ORDER BY `minOrder` ASC [ RunTime:0.005318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833508 ORDER BY `unit` DESC [ RunTime:0.008237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833508 LIMIT 2 [ RunTime:0.012528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833508 ORDER BY `minOrder` ASC [ RunTime:0.001610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832027 LIMIT 5 [ RunTime:0.002377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832027 ORDER BY `minOrder` ASC [ RunTime:0.003538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832027 ORDER BY `unit` DESC [ RunTime:0.004569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832027 LIMIT 2 [ RunTime:0.000740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832027 ORDER BY `minOrder` ASC [ RunTime:0.003065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812197 LIMIT 5 [ RunTime:0.002545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812197 ORDER BY `minOrder` ASC [ RunTime:0.003069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812197 ORDER BY `unit` DESC [ RunTime:0.007636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812197 LIMIT 2 [ RunTime:0.011127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812197 ORDER BY `minOrder` ASC [ RunTime:0.011947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808846 LIMIT 5 [ RunTime:0.007780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808846 ORDER BY `minOrder` ASC [ RunTime:0.007149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808846 ORDER BY `unit` DESC [ RunTime:0.006002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808846 LIMIT 2 [ RunTime:0.002583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808846 ORDER BY `minOrder` ASC [ RunTime:0.008633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808845 LIMIT 5 [ RunTime:0.000928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808845 ORDER BY `minOrder` ASC [ RunTime:0.003441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808845 ORDER BY `unit` DESC [ RunTime:0.001496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808845 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808845 ORDER BY `minOrder` ASC [ RunTime:0.007630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806022 LIMIT 5 [ RunTime:0.010305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806022 ORDER BY `minOrder` ASC [ RunTime:0.005412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806022 ORDER BY `unit` DESC [ RunTime:0.014393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806022 LIMIT 2 [ RunTime:0.002628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806022 ORDER BY `minOrder` ASC [ RunTime:0.003090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800599 LIMIT 5 [ RunTime:0.001188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800599 ORDER BY `minOrder` ASC [ RunTime:0.004870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800599 ORDER BY `unit` DESC [ RunTime:0.000652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800599 LIMIT 2 [ RunTime:0.000783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800599 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928575 LIMIT 5 [ RunTime:0.001009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928575 ORDER BY `minOrder` ASC [ RunTime:0.002047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928575 ORDER BY `unit` DESC [ RunTime:0.001327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928575 LIMIT 2 [ RunTime:0.004253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928575 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928363 LIMIT 5 [ RunTime:0.000941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928363 ORDER BY `minOrder` ASC [ RunTime:0.007931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928363 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928363 LIMIT 2 [ RunTime:0.003700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928363 ORDER BY `minOrder` ASC [ RunTime:0.001319s ]
select * from pdf where partno='SA28A' and brandshort='onsemi' limit 1 [ RunTime:0.007255s ]
select foldpath,foldpath2,filename from pdf_file where id=398670 limit 1 [ RunTime:0.001167s ]
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 'SA28A%' OR `brand` LIKE 'SA28A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141622 LIMIT 5 [ RunTime:0.002218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141622 ORDER BY `minOrder` ASC [ RunTime:0.001507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141622 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141622 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141622 ORDER BY `minOrder` ASC [ RunTime:0.001918s ]
select * from pdf where partno='sa28a' and brandshort='littelfuse' limit 1 [ RunTime:0.001656s ]
select foldpath,foldpath2,filename from pdf_file where id=398671 limit 1 [ RunTime:0.000862s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sa28a' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.009844s ]
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 'SA28A%' OR `brand` LIKE 'SA28A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147646 LIMIT 5 [ RunTime:0.003131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147646 ORDER BY `minOrder` ASC [ RunTime:0.001759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147646 ORDER BY `unit` DESC [ RunTime:0.001069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147646 LIMIT 2 [ RunTime:0.002947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147646 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='SA28A' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.018759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28A' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001820s ]
SELECT `id` FROM `stock` WHERE `id` <> 42147646 AND `partno` = 'SA28A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.000743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662238 [ RunTime:0.000510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105133 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105133 ORDER BY `minOrder` ASC [ RunTime:0.011875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105133 ORDER BY `unit` DESC [ RunTime:0.001944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105133 LIMIT 2 [ RunTime:0.002013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105133 ORDER BY `minOrder` ASC [ RunTime:0.000852s ]
select * from pdf where partno='SA28A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000829s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105133 AND `partno` = 'SA28A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801055 [ RunTime:0.006103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42103360 LIMIT 5 [ RunTime:0.003229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103360 ORDER BY `minOrder` ASC [ RunTime:0.003203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42103360 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42103360 LIMIT 2 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103360 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='SA28A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004483s ]
SELECT `id` FROM `stock` WHERE `id` <> 42103360 AND `partno` = 'SA28A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.004134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907212 [ RunTime:0.005835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42122980 LIMIT 5 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122980 ORDER BY `minOrder` ASC [ RunTime:0.002372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42122980 ORDER BY `unit` DESC [ RunTime:0.000548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42122980 LIMIT 2 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122980 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
select * from pdf where partno='SA28A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.000817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42276991 LIMIT 5 [ RunTime:0.001873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42276991 ORDER BY `minOrder` ASC [ RunTime:0.007334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42276991 ORDER BY `unit` DESC [ RunTime:0.001472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42276991 LIMIT 2 [ RunTime:0.001234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42276991 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
select * from pdf where partno='SA28AHE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28AHE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000973s ]
SELECT `id` FROM `stock` WHERE `id` <> 42276991 AND `partno` = 'SA28AHE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673548 [ RunTime:0.010296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42272256 LIMIT 5 [ RunTime:0.009912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272256 ORDER BY `minOrder` ASC [ RunTime:0.024865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42272256 ORDER BY `unit` DESC [ RunTime:0.006344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42272256 LIMIT 2 [ RunTime:0.005476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272256 ORDER BY `minOrder` ASC [ RunTime:0.002835s ]
select * from pdf where partno='SA28AHE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28AHE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000821s ]
SELECT `id` FROM `stock` WHERE `id` <> 42272256 AND `partno` = 'SA28AHE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.005861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42267656 LIMIT 5 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267656 ORDER BY `minOrder` ASC [ RunTime:0.000881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42267656 ORDER BY `unit` DESC [ RunTime:0.016945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42267656 LIMIT 2 [ RunTime:0.013513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267656 ORDER BY `minOrder` ASC [ RunTime:0.008368s ]
select * from pdf where partno='SA28A-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28A-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001123s ]
SELECT `id` FROM `stock` WHERE `id` <> 42267656 AND `partno` = 'SA28A-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242342 LIMIT 5 [ RunTime:0.015803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242342 ORDER BY `minOrder` ASC [ RunTime:0.006926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242342 ORDER BY `unit` DESC [ RunTime:0.001869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242342 LIMIT 2 [ RunTime:0.001086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242342 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='SA28A-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28A-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000706s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242342 AND `partno` = 'SA28A-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812197 [ RunTime:0.020278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42212230 LIMIT 5 [ RunTime:0.006225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212230 ORDER BY `minOrder` ASC [ RunTime:0.004846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42212230 ORDER BY `unit` DESC [ RunTime:0.000348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42212230 LIMIT 2 [ RunTime:0.015035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212230 ORDER BY `minOrder` ASC [ RunTime:0.016837s ]
select * from pdf where partno='SA28AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.006420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.008204s ]
SELECT `id` FROM `stock` WHERE `id` <> 42212230 AND `partno` = 'SA28AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.010083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808846 [ RunTime:0.015619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42212229 LIMIT 5 [ RunTime:0.008806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212229 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42212229 ORDER BY `unit` DESC [ RunTime:0.001720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42212229 LIMIT 2 [ RunTime:0.013291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212229 ORDER BY `minOrder` ASC [ RunTime:0.007930s ]
select * from pdf where partno='SA28A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.007180s ]
SELECT `id` FROM `stock` WHERE `id` <> 42212229 AND `partno` = 'SA28A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.015987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808845 [ RunTime:0.019230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42190281 LIMIT 5 [ RunTime:0.013218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190281 ORDER BY `minOrder` ASC [ RunTime:0.008493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42190281 ORDER BY `unit` DESC [ RunTime:0.020241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42190281 LIMIT 2 [ RunTime:0.009833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190281 ORDER BY `minOrder` ASC [ RunTime:0.004612s ]
select * from pdf where partno='SA28A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.009124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.013559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147637 LIMIT 5 [ RunTime:0.015631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147637 ORDER BY `minOrder` ASC [ RunTime:0.008306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147637 ORDER BY `unit` DESC [ RunTime:0.014114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147637 LIMIT 2 [ RunTime:0.011156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147637 ORDER BY `minOrder` ASC [ RunTime:0.011876s ]
select * from pdf where partno='SA28AG' and brandshort='onsemi' limit 1 [ RunTime:0.005461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28AG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.029784s ]
SELECT `id` FROM `stock` WHERE `id` <> 42147637 AND `partno` = 'SA28AG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.028230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800599 [ RunTime:0.008304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147634 LIMIT 5 [ RunTime:0.008896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147634 ORDER BY `minOrder` ASC [ RunTime:0.010455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147634 ORDER BY `unit` DESC [ RunTime:0.020114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147634 LIMIT 2 [ RunTime:0.030880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147634 ORDER BY `minOrder` ASC [ RunTime:0.015073s ]
select * from pdf where partno='SA28ARL' and brandshort='onsemi' limit 1 [ RunTime:0.004466s ]
select foldpath,foldpath2,filename from pdf_file where id=398670 limit 1 [ RunTime:0.002159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA28ARL' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.022995s ]
SELECT `id` FROM `stock` WHERE `id` <> 42147634 AND `partno` = 'SA28ARL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.030954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662232 [ RunTime:0.040096s ]
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 'SA28A%' OR `brand` LIKE 'SA28A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057847s ]
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 'SA28A%' OR `brand` LIKE 'SA28A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028921s ]
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 'SA28A%' OR `brand` LIKE 'SA28A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025853s ]
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 'SA28A%' OR `brand` LIKE 'SA28A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037560s ]
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 'SA28A%' OR `brand` LIKE 'SA28A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029404s ]
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 'SA28A%' OR `brand` LIKE 'SA28A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021175s ]
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 'SA28A%' OR `brand` LIKE 'SA28A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026118s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SA28A%' OR `brand` LIKE 'SA28A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.026042s ]