SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002323s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.20' , `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&page=2&srecordnum=99' [ RunTime:0.006602s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002177s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001420s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001403s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.20' ) [ RunTime:0.000263s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001408s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000461s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001390s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SS14' LIMIT 1 [ RunTime:0.008030s ]
UPDATE `stock_search` SET `count` = 21012 , `updatetime` = '2026-06-15 08:53:07' WHERE `partno` = 'SS14' [ RunTime:0.006231s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001336s ]
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 20,20 [ RunTime:0.006707s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44083669 LIMIT 4 [ RunTime:0.000342s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083669 ORDER BY `minOrder` ASC [ RunTime:0.001135s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44083669 ORDER BY `unit` DESC [ RunTime:0.001412s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44083669 LIMIT 2 [ RunTime:0.001618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083669 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='SS14H' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.004506s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14H' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.002321s ]
SELECT `id` FROM `stock` WHERE `id` <> 44083669 AND `partno` = 'SS14H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.002374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44081399 LIMIT 4 [ RunTime:0.001452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081399 ORDER BY `minOrder` ASC [ RunTime:0.000797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44081399 ORDER BY `unit` DESC [ RunTime:0.008786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44081399 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081399 ORDER BY `minOrder` ASC [ RunTime:0.000247s ]
select * from pdf where partno='SS14HE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14HE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002097s ]
SELECT `id` FROM `stock` WHERE `id` <> 44081399 AND `partno` = 'SS14HE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33431182 LIMIT 4 [ RunTime:0.000852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33431182 ORDER BY `minOrder` ASC [ RunTime:0.000807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33431182 ORDER BY `unit` DESC [ RunTime:0.005149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33431182 LIMIT 2 [ RunTime:0.008114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33431182 ORDER BY `minOrder` ASC [ RunTime:0.000251s ]
select * from pdf where partno='SS14M2G10' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.000537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14M2G10' OR `brand` LIKE 'Amphenol Sine Systems Corp%' ) ) LIMIT 1 [ RunTime:0.012682s ]
SELECT `id` FROM `stock` WHERE `id` <> 33431182 AND `partno` = 'SS14M2G10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sine systems corp%' ) [ RunTime:0.006991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12884780 [ RunTime:0.003194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44084271 LIMIT 4 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084271 ORDER BY `minOrder` ASC [ RunTime:0.007901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44084271 ORDER BY `unit` DESC [ RunTime:0.012893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44084271 LIMIT 2 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084271 ORDER BY `minOrder` ASC [ RunTime:0.000975s ]
select * from pdf where partno='SS14-M3/61T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14-M3/61T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001418s ]
SELECT `id` FROM `stock` WHERE `id` <> 44084271 AND `partno` = 'SS14-M3/61T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080602 LIMIT 4 [ RunTime:0.001034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080602 ORDER BY `minOrder` ASC [ RunTime:0.004929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080602 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080602 LIMIT 2 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080602 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
select * from pdf where partno='SS14FL-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.000490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14FL-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.002009s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080602 AND `partno` = 'SS14FL-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.001696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11685605 LIMIT 4 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11685605 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11685605 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11685605 LIMIT 2 [ RunTime:0.002464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11685605 ORDER BY `minOrder` ASC [ RunTime:0.002939s ]
select * from pdf where partno='SS14M2N' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.001007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33431083 LIMIT 4 [ RunTime:0.001374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33431083 ORDER BY `minOrder` ASC [ RunTime:0.000802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33431083 ORDER BY `unit` DESC [ RunTime:0.001914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33431083 LIMIT 2 [ RunTime:0.006092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33431083 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='SS14M2N' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.000414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14M2N' OR `brand` LIKE 'Amphenol Sine Systems Corp%' ) ) LIMIT 1 [ RunTime:0.000485s ]
SELECT `id` FROM `stock` WHERE `id` <> 33431083 AND `partno` = 'SS14M2N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sine systems corp%' ) [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11685605 [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44084159 LIMIT 4 [ RunTime:0.003553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084159 ORDER BY `minOrder` ASC [ RunTime:0.011095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44084159 ORDER BY `unit` DESC [ RunTime:0.016899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44084159 LIMIT 2 [ RunTime:0.017645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084159 ORDER BY `minOrder` ASC [ RunTime:0.005134s ]
select * from pdf where partno='SS14Q-LTP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14Q-LTP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.002831s ]
SELECT `id` FROM `stock` WHERE `id` <> 44084159 AND `partno` = 'SS14Q-LTP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.007787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33430655 LIMIT 4 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33430655 ORDER BY `minOrder` ASC [ RunTime:0.013225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33430655 ORDER BY `unit` DESC [ RunTime:0.002319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33430655 LIMIT 2 [ RunTime:0.004295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33430655 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='SS14M2F' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.000976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14M2F' OR `brand` LIKE 'Amphenol Sine Systems Corp%' ) ) LIMIT 1 [ RunTime:0.008600s ]
SELECT `id` FROM `stock` WHERE `id` <> 33430655 AND `partno` = 'SS14M2F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sine systems corp%' ) [ RunTime:0.002725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12885117 [ RunTime:0.003428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44083786 LIMIT 4 [ RunTime:0.008129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083786 ORDER BY `minOrder` ASC [ RunTime:0.008810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44083786 ORDER BY `unit` DESC [ RunTime:0.000766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44083786 LIMIT 2 [ RunTime:0.001805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083786 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
select * from pdf where partno='SS14M' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.011217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14M' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.004119s ]
SELECT `id` FROM `stock` WHERE `id` <> 44083786 AND `partno` = 'SS14M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.004126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44086782 LIMIT 4 [ RunTime:0.009183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086782 ORDER BY `minOrder` ASC [ RunTime:0.004975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44086782 ORDER BY `unit` DESC [ RunTime:0.010327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44086782 LIMIT 2 [ RunTime:0.022212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086782 ORDER BY `minOrder` ASC [ RunTime:0.027370s ]
select * from pdf where partno='SS14HE3-LTP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.016548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14HE3-LTP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000998s ]
SELECT `id` FROM `stock` WHERE `id` <> 44086782 AND `partno` = 'SS14HE3-LTP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44094994 LIMIT 4 [ RunTime:0.004058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094994 ORDER BY `minOrder` ASC [ RunTime:0.009810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44094994 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44094994 LIMIT 2 [ RunTime:0.007700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094994 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
select * from pdf where partno='SS14' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.002279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.000936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12885117 LIMIT 4 [ RunTime:0.000874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12885117 ORDER BY `minOrder` ASC [ RunTime:0.004406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12885117 ORDER BY `unit` DESC [ RunTime:0.013734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12885117 LIMIT 2 [ RunTime:0.022405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12885117 ORDER BY `minOrder` ASC [ RunTime:0.003461s ]
select * from pdf where partno='SS14M2F' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.000786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44088953 LIMIT 4 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088953 ORDER BY `minOrder` ASC [ RunTime:0.003871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44088953 ORDER BY `unit` DESC [ RunTime:0.007275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44088953 LIMIT 2 [ RunTime:0.005939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088953 ORDER BY `minOrder` ASC [ RunTime:0.002959s ]
select * from pdf where partno='SS14AL_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14AL_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.002286s ]
SELECT `id` FROM `stock` WHERE `id` <> 44088953 AND `partno` = 'SS14AL_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.015777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12884780 LIMIT 4 [ RunTime:0.008013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12884780 ORDER BY `minOrder` ASC [ RunTime:0.002561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12884780 ORDER BY `unit` DESC [ RunTime:0.002721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12884780 LIMIT 2 [ RunTime:0.027457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12884780 ORDER BY `minOrder` ASC [ RunTime:0.001613s ]
select * from pdf where partno='SS14M2G10' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.003699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44088907 LIMIT 4 [ RunTime:0.001391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088907 ORDER BY `minOrder` ASC [ RunTime:0.001241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44088907 ORDER BY `unit` DESC [ RunTime:0.000572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44088907 LIMIT 2 [ RunTime:0.001656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088907 ORDER BY `minOrder` ASC [ RunTime:0.002744s ]
select * from pdf where partno='SS14L_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.008191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14L_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.011830s ]
SELECT `id` FROM `stock` WHERE `id` <> 44088907 AND `partno` = 'SS14L_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.002513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44090416 LIMIT 4 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090416 ORDER BY `minOrder` ASC [ RunTime:0.001181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44090416 ORDER BY `unit` DESC [ RunTime:0.000956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44090416 LIMIT 2 [ RunTime:0.040238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090416 ORDER BY `minOrder` ASC [ RunTime:0.008155s ]
select * from pdf where partno='SS14F' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.018635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14F' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.026299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44090710 LIMIT 4 [ RunTime:0.005238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090710 ORDER BY `minOrder` ASC [ RunTime:0.012485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44090710 ORDER BY `unit` DESC [ RunTime:0.002993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44090710 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090710 ORDER BY `minOrder` ASC [ RunTime:0.006352s ]
select * from pdf where partno='SS14B' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.001192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14B' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.002647s ]
SELECT `id` FROM `stock` WHERE `id` <> 44090710 AND `partno` = 'SS14B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%shenzhen slkormicro semicon co., ltd.%' ) [ RunTime:0.002111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44088896 LIMIT 4 [ RunTime:0.014181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088896 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44088896 ORDER BY `unit` DESC [ RunTime:0.016916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44088896 LIMIT 2 [ RunTime:0.004533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44088896 ORDER BY `minOrder` ASC [ RunTime:0.001347s ]
select * from pdf where partno='SS14W_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14W_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.014296s ]
SELECT `id` FROM `stock` WHERE `id` <> 44088896 AND `partno` = 'SS14W_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.009610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20146853 LIMIT 4 [ RunTime:0.005621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146853 ORDER BY `minOrder` ASC [ RunTime:0.001053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20146853 ORDER BY `unit` DESC [ RunTime:0.007032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20146853 LIMIT 2 [ RunTime:0.000766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146853 ORDER BY `minOrder` ASC [ RunTime:0.003030s ]
select * from pdf where partno='SS14F' and brandshort='UMW' limit 1 [ RunTime:0.004420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS14F' OR `brand` LIKE 'UMW(友台半导体)%' ) ) LIMIT 1 [ RunTime:0.003577s ]
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 20,20 [ RunTime:0.003585s ]
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' ) ) tmp GROUP BY `brand` [ RunTime:0.001898s ]
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 [ RunTime:0.003228s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` IN (117,870) [ RunTime:0.000377s ]