SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002371s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=SS14' [ RunTime:0.006188s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002569s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000574s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002292s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000357s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001913s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000285s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001792s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SS14' LIMIT 1 [ RunTime:0.004046s ]
UPDATE `stock_search` SET `count` = 20829 , `updatetime` = '2026-06-13 09:50:26' WHERE `partno` = 'SS14' [ RunTime:0.001797s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002319s ]
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 'SS14%' OR `brand` LIKE 'SS14%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012342s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44090288 LIMIT 4 [ RunTime:0.001167s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090288 ORDER BY `minOrder` ASC [ RunTime:0.001073s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44090288 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44090288 LIMIT 2 [ RunTime:0.000265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090288 ORDER BY `minOrder` ASC [ RunTime:0.000180s ]
select * from pdf where partno='SS14F' and brandshort='MDD' limit 1 [ RunTime:0.001898s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14F' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.004524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079351 LIMIT 4 [ RunTime:0.005524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079351 ORDER BY `minOrder` ASC [ RunTime:0.002331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44079351 ORDER BY `unit` DESC [ RunTime:0.001440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44079351 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079351 ORDER BY `minOrder` ASC [ RunTime:0.000175s ]
select * from pdf where partno='SS14' and brandshort='onsemi' limit 1 [ RunTime:0.002543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.012189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079461 LIMIT 4 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079461 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44079461 ORDER BY `unit` DESC [ RunTime:0.000311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44079461 LIMIT 2 [ RunTime:0.002928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079461 ORDER BY `minOrder` ASC [ RunTime:0.001153s ]
select * from pdf where partno='SS14HE' and brandshort='onsemi' limit 1 [ RunTime:0.002123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14HE' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.006537s ]
SELECT `id` FROM `stock` WHERE `id` <> 44079461 AND `partno` = 'SS14HE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.002486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44093351 LIMIT 4 [ RunTime:0.008612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44093351 ORDER BY `minOrder` ASC [ RunTime:0.001722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44093351 ORDER BY `unit` DESC [ RunTime:0.002646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44093351 LIMIT 2 [ RunTime:0.013469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44093351 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
select * from pdf where partno='SS14' and brandshort='MDD' limit 1 [ RunTime:0.004393s ]
select foldpath,foldpath2,filename from pdf_file where id=1114032 limit 1 [ RunTime:0.007480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.001912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44090319 LIMIT 4 [ RunTime:0.002823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090319 ORDER BY `minOrder` ASC [ RunTime:0.001962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44090319 ORDER BY `unit` DESC [ RunTime:0.002526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44090319 LIMIT 2 [ RunTime:0.008507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090319 ORDER BY `minOrder` ASC [ RunTime:0.001224s ]
select * from pdf where partno='SS14' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.008957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.002257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44083563 LIMIT 4 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083563 ORDER BY `minOrder` ASC [ RunTime:0.001720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44083563 ORDER BY `unit` DESC [ RunTime:0.000686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44083563 LIMIT 2 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083563 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='SS14LS' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14LS' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000899s ]
SELECT `id` FROM `stock` WHERE `id` <> 44083563 AND `partno` = 'SS14LS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.002893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080620 LIMIT 4 [ RunTime:0.008078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080620 ORDER BY `minOrder` ASC [ RunTime:0.000804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080620 ORDER BY `unit` DESC [ RunTime:0.001579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080620 LIMIT 2 [ RunTime:0.002505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080620 ORDER BY `minOrder` ASC [ RunTime:0.001857s ]
select * from pdf where partno='SS14LWH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14LWH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.005914s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080620 AND `partno` = 'SS14LWH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44081048 LIMIT 4 [ RunTime:0.002356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081048 ORDER BY `minOrder` ASC [ RunTime:0.008751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44081048 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44081048 LIMIT 2 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081048 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='SS14-E3/5AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14-E3/5AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011252s ]
SELECT `id` FROM `stock` WHERE `id` <> 44081048 AND `partno` = 'SS14-E3/5AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079366 LIMIT 4 [ RunTime:0.012810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079366 ORDER BY `minOrder` ASC [ RunTime:0.008249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44079366 ORDER BY `unit` DESC [ RunTime:0.006051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44079366 LIMIT 2 [ RunTime:0.010240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079366 ORDER BY `minOrder` ASC [ RunTime:0.002565s ]
select * from pdf where partno='SS14-E3/61T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14-E3/61T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44081417 LIMIT 4 [ RunTime:0.012321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081417 ORDER BY `minOrder` ASC [ RunTime:0.014444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44081417 ORDER BY `unit` DESC [ RunTime:0.008054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44081417 LIMIT 2 [ RunTime:0.003078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081417 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='SS14M RSG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14M RSG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.009273s ]
SELECT `id` FROM `stock` WHERE `id` <> 44081417 AND `partno` = 'SS14M RSG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.005566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080994 LIMIT 4 [ RunTime:0.002897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080994 ORDER BY `minOrder` ASC [ RunTime:0.005212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080994 ORDER BY `unit` DESC [ RunTime:0.001265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080994 LIMIT 2 [ RunTime:0.002612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080994 ORDER BY `minOrder` ASC [ RunTime:0.005557s ]
select * from pdf where partno='SS14L' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14L' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080591 LIMIT 4 [ RunTime:0.000544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080591 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080591 ORDER BY `unit` DESC [ RunTime:0.000953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080591 LIMIT 2 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080591 ORDER BY `minOrder` ASC [ RunTime:0.003600s ]
select * from pdf where partno='SS14LW' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14LW' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000705s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080591 AND `partno` = 'SS14LW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080329 LIMIT 4 [ RunTime:0.003323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080329 ORDER BY `minOrder` ASC [ RunTime:0.014250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080329 ORDER BY `unit` DESC [ RunTime:0.002288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080329 LIMIT 2 [ RunTime:0.003104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080329 ORDER BY `minOrder` ASC [ RunTime:0.012761s ]
select * from pdf where partno='SS14-LTP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.008622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14-LTP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.001053s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080329 AND `partno` = 'SS14-LTP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.010822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080897 LIMIT 4 [ RunTime:0.029166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080897 ORDER BY `minOrder` ASC [ RunTime:0.010373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080897 ORDER BY `unit` DESC [ RunTime:0.000725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080897 LIMIT 2 [ RunTime:0.001765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080897 ORDER BY `minOrder` ASC [ RunTime:0.003386s ]
select * from pdf where partno='SS14MH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.017349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14MH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.001146s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080897 AND `partno` = 'SS14MH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.008991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2233 LIMIT 4 [ RunTime:0.035015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2233 ORDER BY `minOrder` ASC [ RunTime:0.013340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2233 ORDER BY `unit` DESC [ RunTime:0.001662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2233 LIMIT 2 [ RunTime:0.010167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2233 ORDER BY `minOrder` ASC [ RunTime:0.008635s ]
select * from pdf where partno='SS14' and brandshort='ONSEMI' limit 1 [ RunTime:0.003581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.032898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14487 LIMIT 4 [ RunTime:0.019568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14487 ORDER BY `minOrder` ASC [ RunTime:0.011277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14487 ORDER BY `unit` DESC [ RunTime:0.014670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14487 LIMIT 2 [ RunTime:0.016392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14487 ORDER BY `minOrder` ASC [ RunTime:0.007585s ]
select * from pdf where partno='SS14-E3/61T' and brandshort='VISHAY' limit 1 [ RunTime:0.001413s ]
select foldpath,foldpath2,filename from pdf_file where id=786027 limit 1 [ RunTime:0.003542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14-E3/61T' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.012104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44084153 LIMIT 4 [ RunTime:0.015361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084153 ORDER BY `minOrder` ASC [ RunTime:0.016218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44084153 ORDER BY `unit` DESC [ RunTime:0.001039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44084153 LIMIT 2 [ RunTime:0.004004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084153 ORDER BY `minOrder` ASC [ RunTime:0.000900s ]
select * from pdf where partno='SS14HE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14HE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001367s ]
SELECT `id` FROM `stock` WHERE `id` <> 44084153 AND `partno` = 'SS14HE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44086385 LIMIT 4 [ RunTime:0.014839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086385 ORDER BY `minOrder` ASC [ RunTime:0.015825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44086385 ORDER BY `unit` DESC [ RunTime:0.002806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44086385 LIMIT 2 [ RunTime:0.010276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086385 ORDER BY `minOrder` ASC [ RunTime:0.004722s ]
select * from pdf where partno='SS14LSH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.004407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14LSH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.010400s ]
SELECT `id` FROM `stock` WHERE `id` <> 44086385 AND `partno` = 'SS14LSH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.006426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44081542 LIMIT 4 [ RunTime:0.010585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081542 ORDER BY `minOrder` ASC [ RunTime:0.003952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44081542 ORDER BY `unit` DESC [ RunTime:0.001041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44081542 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081542 ORDER BY `minOrder` ASC [ RunTime:0.009286s ]
select * from pdf where partno='SS14-M3/5AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14-M3/5AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000868s ]
SELECT `id` FROM `stock` WHERE `id` <> 44081542 AND `partno` = 'SS14-M3/5AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.026998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080277 LIMIT 4 [ RunTime:0.003140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080277 ORDER BY `minOrder` ASC [ RunTime:0.002195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080277 ORDER BY `unit` DESC [ RunTime:0.009312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080277 LIMIT 2 [ RunTime:0.006663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080277 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='SS14_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.015228s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080277 AND `partno` = 'SS14_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.015885s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SS14%' OR `brand` LIKE 'SS14%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008411s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SS14%' OR `brand` LIKE 'SS14%' ) AND `s`.`status` <> '2' ) LIMIT 99 ) tmp GROUP BY `brand` [ RunTime:0.004716s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SS14%' OR `brand` LIKE 'SS14%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 LIMIT 99 [ RunTime:0.006619s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` IN (117,870) [ RunTime:0.000435s ]