SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001637s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.025874s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002351s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.103' ) [ RunTime:0.006788s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002268s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009612s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002173s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6KE33CA' LIMIT 1 [ RunTime:0.004244s ]
UPDATE `stock_search` SET `count` = 14952 , `updatetime` = '2026-06-02 02:50:22' WHERE `partno` = 'P6KE33CA' [ RunTime:0.004596s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000290s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.002037s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002754s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'P6KE33CA%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.061738s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'P6KE33CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.014685s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('10288','30272928','30272923','30228558','30228498','30217463','30216871','30216687','30210315','30202565','30201768','30201515','30194505','30185727','30173037','16691123','16686874','16671836','16669854','16669204') ORDER BY FIELD(s.id, 10288,30272928,30272923,30228558,30228498,30217463,30216871,30216687,30210315,30202565,30201768,30201515,30194505,30185727,30173037,16691123,16686874,16671836,16669854,16669204) [ RunTime:0.031375s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10288 LIMIT 4 [ RunTime:0.006749s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10288 ORDER BY `minOrder` ASC [ RunTime:0.010763s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10288 ORDER BY `unit` DESC [ RunTime:0.021203s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10288 LIMIT 2 [ RunTime:0.004680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10288 ORDER BY `minOrder` ASC [ RunTime:0.001623s ]
select * from pdf where partno='P6KE33CA' and brandshort='TAIWAN SEMICONDUCTOR' limit 1 [ RunTime:0.005328s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA' OR `brand` LIKE 'TAIWAN SEMICONDUCTOR%' ) ) LIMIT 1 [ RunTime:0.001400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30272928 LIMIT 4 [ RunTime:0.006345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30272928 ORDER BY `minOrder` ASC [ RunTime:0.025993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30272928 ORDER BY `unit` DESC [ RunTime:0.026675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30272928 LIMIT 2 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30272928 ORDER BY `minOrder` ASC [ RunTime:0.006336s ]
select * from pdf where partno='P6KE33CAHE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.020811s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CAHE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30272923 LIMIT 4 [ RunTime:0.001949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30272923 ORDER BY `minOrder` ASC [ RunTime:0.000906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30272923 ORDER BY `unit` DESC [ RunTime:0.000429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30272923 LIMIT 2 [ RunTime:0.004936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30272923 ORDER BY `minOrder` ASC [ RunTime:0.004261s ]
select * from pdf where partno='P6KE33CAHE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.015099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CAHE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30228558 LIMIT 4 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30228558 ORDER BY `minOrder` ASC [ RunTime:0.006974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30228558 ORDER BY `unit` DESC [ RunTime:0.002878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30228558 LIMIT 2 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30228558 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='P6KE33CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.001549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.012638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30228498 LIMIT 4 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30228498 ORDER BY `minOrder` ASC [ RunTime:0.002192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30228498 ORDER BY `unit` DESC [ RunTime:0.011034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30228498 LIMIT 2 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30228498 ORDER BY `minOrder` ASC [ RunTime:0.001391s ]
select * from pdf where partno='P6KE33CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.002462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.000627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30217463 LIMIT 4 [ RunTime:0.005625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30217463 ORDER BY `minOrder` ASC [ RunTime:0.001439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30217463 ORDER BY `unit` DESC [ RunTime:0.003900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30217463 LIMIT 2 [ RunTime:0.001584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30217463 ORDER BY `minOrder` ASC [ RunTime:0.007874s ]
select * from pdf where partno='P6KE33CA A0G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA A0G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.005160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30216871 LIMIT 4 [ RunTime:0.002646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30216871 ORDER BY `minOrder` ASC [ RunTime:0.016120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30216871 ORDER BY `unit` DESC [ RunTime:0.005997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30216871 LIMIT 2 [ RunTime:0.010608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30216871 ORDER BY `minOrder` ASC [ RunTime:0.005621s ]
select * from pdf where partno='P6KE33CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.002670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30216687 LIMIT 4 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30216687 ORDER BY `minOrder` ASC [ RunTime:0.008319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30216687 ORDER BY `unit` DESC [ RunTime:0.012457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30216687 LIMIT 2 [ RunTime:0.007752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30216687 ORDER BY `minOrder` ASC [ RunTime:0.001839s ]
select * from pdf where partno='P6KE33CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.004988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.008239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30210315 LIMIT 4 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30210315 ORDER BY `minOrder` ASC [ RunTime:0.006057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30210315 ORDER BY `unit` DESC [ RunTime:0.005608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30210315 LIMIT 2 [ RunTime:0.009249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30210315 ORDER BY `minOrder` ASC [ RunTime:0.004735s ]
select * from pdf where partno='P6KE33CA-AQ' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.001194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA-AQ' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.006167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30202565 LIMIT 4 [ RunTime:0.007370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30202565 ORDER BY `minOrder` ASC [ RunTime:0.008849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30202565 ORDER BY `unit` DESC [ RunTime:0.004044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30202565 LIMIT 2 [ RunTime:0.013039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30202565 ORDER BY `minOrder` ASC [ RunTime:0.004642s ]
select * from pdf where partno='P6KE33CA-BP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.015369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA-BP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.003656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30201768 LIMIT 4 [ RunTime:0.005649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30201768 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30201768 ORDER BY `unit` DESC [ RunTime:0.000533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30201768 LIMIT 2 [ RunTime:0.007626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30201768 ORDER BY `minOrder` ASC [ RunTime:0.000900s ]
select * from pdf where partno='P6KE33CA-AP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.000759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA-AP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.004204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30201515 LIMIT 4 [ RunTime:0.008981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30201515 ORDER BY `minOrder` ASC [ RunTime:0.002099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30201515 ORDER BY `unit` DESC [ RunTime:0.011324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30201515 LIMIT 2 [ RunTime:0.007880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30201515 ORDER BY `minOrder` ASC [ RunTime:0.001129s ]
select * from pdf where partno='P6KE33CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.002413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30194505 LIMIT 4 [ RunTime:0.010617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30194505 ORDER BY `minOrder` ASC [ RunTime:0.009371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30194505 ORDER BY `unit` DESC [ RunTime:0.004268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30194505 LIMIT 2 [ RunTime:0.006288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30194505 ORDER BY `minOrder` ASC [ RunTime:0.006464s ]
select * from pdf where partno='P6KE33CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.013742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30185727 LIMIT 4 [ RunTime:0.008668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30185727 ORDER BY `minOrder` ASC [ RunTime:0.011304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30185727 ORDER BY `unit` DESC [ RunTime:0.000491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30185727 LIMIT 2 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30185727 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
select * from pdf where partno='P6KE33CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.007852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.015278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30173037 LIMIT 4 [ RunTime:0.004645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30173037 ORDER BY `minOrder` ASC [ RunTime:0.002653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30173037 ORDER BY `unit` DESC [ RunTime:0.000697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30173037 LIMIT 2 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30173037 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='P6KE33CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE33CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691123 LIMIT 4 [ RunTime:0.002852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691123 ORDER BY `minOrder` ASC [ RunTime:0.001743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691123 ORDER BY `unit` DESC [ RunTime:0.004799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691123 LIMIT 2 [ RunTime:0.004483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691123 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16686874 LIMIT 4 [ RunTime:0.001967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16686874 ORDER BY `minOrder` ASC [ RunTime:0.002210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16686874 ORDER BY `unit` DESC [ RunTime:0.000571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16686874 LIMIT 2 [ RunTime:0.003267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16686874 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671836 LIMIT 4 [ RunTime:0.001126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671836 ORDER BY `minOrder` ASC [ RunTime:0.001711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671836 ORDER BY `unit` DESC [ RunTime:0.000522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671836 LIMIT 2 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671836 ORDER BY `minOrder` ASC [ RunTime:0.001178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669854 LIMIT 4 [ RunTime:0.001696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669854 ORDER BY `minOrder` ASC [ RunTime:0.003259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669854 ORDER BY `unit` DESC [ RunTime:0.002748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669854 LIMIT 2 [ RunTime:0.000802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669854 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669204 LIMIT 4 [ RunTime:0.001771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669204 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669204 ORDER BY `unit` DESC [ RunTime:0.001628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669204 LIMIT 2 [ RunTime:0.002859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669204 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'P6KE33CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002006s ]