SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002411s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001904s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002227s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.62' ) [ RunTime:0.013696s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002269s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007634s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003515s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ6.5A' LIMIT 1 [ RunTime:0.017473s ]
UPDATE `stock_search` SET `count` = 15295 , `updatetime` = '2026-06-03 08:43:20' WHERE `partno` = 'SMBJ6.5A' [ RunTime:0.028861s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.006227s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.009665s ]
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.006735s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003518s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMBJ6.5A%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.016292s ]
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 'SMBJ6.5A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.020996s ]
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 ('30217665','30216132','30210073','30205505','30194225','30191068','30190167','30187048','30181493','30175448','16692650','16683392','16679842','16671692','16671596','16671524','16671254','16670021','16669753','16669264') ORDER BY FIELD(s.id, 30217665,30216132,30210073,30205505,30194225,30191068,30190167,30187048,30181493,30175448,16692650,16683392,16679842,16671692,16671596,16671524,16671254,16670021,16669753,16669264) [ RunTime:0.047861s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30217665 LIMIT 4 [ RunTime:0.037825s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30217665 ORDER BY `minOrder` ASC [ RunTime:0.035747s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.012430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30217665 ORDER BY `unit` DESC [ RunTime:0.010675s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30217665 LIMIT 2 [ RunTime:0.026111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30217665 ORDER BY `minOrder` ASC [ RunTime:0.025358s ]
select * from pdf where partno='SMBJ6.5A-QH' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.053625s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A-QH' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.044536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30216132 LIMIT 4 [ RunTime:0.074712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30216132 ORDER BY `minOrder` ASC [ RunTime:0.022645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30216132 ORDER BY `unit` DESC [ RunTime:0.039280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30216132 LIMIT 2 [ RunTime:0.062221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30216132 ORDER BY `minOrder` ASC [ RunTime:0.040148s ]
select * from pdf where partno='SMBJ6.5AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.043491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.045861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30210073 LIMIT 4 [ RunTime:0.044314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30210073 ORDER BY `minOrder` ASC [ RunTime:0.039720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30210073 ORDER BY `unit` DESC [ RunTime:0.013715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30210073 LIMIT 2 [ RunTime:0.019067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30210073 ORDER BY `minOrder` ASC [ RunTime:0.039950s ]
select * from pdf where partno='SMBJ6.5A-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.051723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.080705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30205505 LIMIT 4 [ RunTime:0.039471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30205505 ORDER BY `minOrder` ASC [ RunTime:0.063443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30205505 ORDER BY `unit` DESC [ RunTime:0.049966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30205505 LIMIT 2 [ RunTime:0.112617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30205505 ORDER BY `minOrder` ASC [ RunTime:0.030309s ]
select * from pdf where partno='SMBJ6.5A-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.032921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A-E3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30194225 LIMIT 4 [ RunTime:0.059874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30194225 ORDER BY `minOrder` ASC [ RunTime:0.094476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30194225 ORDER BY `unit` DESC [ RunTime:0.127617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30194225 LIMIT 2 [ RunTime:0.068834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30194225 ORDER BY `minOrder` ASC [ RunTime:0.026812s ]
select * from pdf where partno='SMBJ6.5A-AT/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.062141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A-AT/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.065675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30191068 LIMIT 4 [ RunTime:0.080151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30191068 ORDER BY `minOrder` ASC [ RunTime:0.036064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30191068 ORDER BY `unit` DESC [ RunTime:0.053721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30191068 LIMIT 2 [ RunTime:0.047089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30191068 ORDER BY `minOrder` ASC [ RunTime:0.020515s ]
select * from pdf where partno='SMBJ6.5A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.028180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.028412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30190167 LIMIT 4 [ RunTime:0.046605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30190167 ORDER BY `minOrder` ASC [ RunTime:0.025554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30190167 ORDER BY `unit` DESC [ RunTime:0.047105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30190167 LIMIT 2 [ RunTime:0.027229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30190167 ORDER BY `minOrder` ASC [ RunTime:0.015979s ]
select * from pdf where partno='SMBJ6.5A-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.072904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.089118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30187048 LIMIT 4 [ RunTime:0.112848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30187048 ORDER BY `minOrder` ASC [ RunTime:0.114431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30187048 ORDER BY `unit` DESC [ RunTime:0.070461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30187048 LIMIT 2 [ RunTime:0.031046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30187048 ORDER BY `minOrder` ASC [ RunTime:0.017233s ]
select * from pdf where partno='SMBJ6.5A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.041425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.058833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30181493 LIMIT 4 [ RunTime:0.028996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30181493 ORDER BY `minOrder` ASC [ RunTime:0.032479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30181493 ORDER BY `unit` DESC [ RunTime:0.030823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30181493 LIMIT 2 [ RunTime:0.022103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30181493 ORDER BY `minOrder` ASC [ RunTime:0.008795s ]
select * from pdf where partno='SMBJ6.5AJ' and brandshort='WeEn Semiconductors' limit 1 [ RunTime:0.034845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AJ' OR `brand` LIKE 'WeEn Semiconductors%' ) ) LIMIT 1 [ RunTime:0.036181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30175448 LIMIT 4 [ RunTime:0.040411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30175448 ORDER BY `minOrder` ASC [ RunTime:0.037573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30175448 ORDER BY `unit` DESC [ RunTime:0.030301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30175448 LIMIT 2 [ RunTime:0.015882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30175448 ORDER BY `minOrder` ASC [ RunTime:0.009535s ]
select * from pdf where partno='SMBJ6.5A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.018777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.022567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692650 LIMIT 4 [ RunTime:0.015151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692650 ORDER BY `minOrder` ASC [ RunTime:0.018542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692650 ORDER BY `unit` DESC [ RunTime:0.002942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692650 LIMIT 2 [ RunTime:0.012437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692650 ORDER BY `minOrder` ASC [ RunTime:0.012210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683392 LIMIT 4 [ RunTime:0.028310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683392 ORDER BY `minOrder` ASC [ RunTime:0.051022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683392 ORDER BY `unit` DESC [ RunTime:0.022357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683392 LIMIT 2 [ RunTime:0.013273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683392 ORDER BY `minOrder` ASC [ RunTime:0.025613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679842 LIMIT 4 [ RunTime:0.017947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679842 ORDER BY `minOrder` ASC [ RunTime:0.008639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679842 ORDER BY `unit` DESC [ RunTime:0.017044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679842 LIMIT 2 [ RunTime:0.017400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679842 ORDER BY `minOrder` ASC [ RunTime:0.013109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671692 LIMIT 4 [ RunTime:0.007777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671692 ORDER BY `minOrder` ASC [ RunTime:0.052962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671692 ORDER BY `unit` DESC [ RunTime:0.028383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671692 LIMIT 2 [ RunTime:0.011550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671692 ORDER BY `minOrder` ASC [ RunTime:0.003000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671596 LIMIT 4 [ RunTime:0.017131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671596 ORDER BY `minOrder` ASC [ RunTime:0.016228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671596 ORDER BY `unit` DESC [ RunTime:0.018580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671596 LIMIT 2 [ RunTime:0.039905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671596 ORDER BY `minOrder` ASC [ RunTime:0.014749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671524 LIMIT 4 [ RunTime:0.042117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671524 ORDER BY `minOrder` ASC [ RunTime:0.095907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671524 ORDER BY `unit` DESC [ RunTime:0.029226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671524 LIMIT 2 [ RunTime:0.043699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671524 ORDER BY `minOrder` ASC [ RunTime:0.020845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671254 LIMIT 4 [ RunTime:0.057171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671254 ORDER BY `minOrder` ASC [ RunTime:0.023836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671254 ORDER BY `unit` DESC [ RunTime:0.052980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671254 LIMIT 2 [ RunTime:0.045937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671254 ORDER BY `minOrder` ASC [ RunTime:0.011249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670021 LIMIT 4 [ RunTime:0.015516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670021 ORDER BY `minOrder` ASC [ RunTime:0.000874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670021 ORDER BY `unit` DESC [ RunTime:0.051700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670021 LIMIT 2 [ RunTime:0.050123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670021 ORDER BY `minOrder` ASC [ RunTime:0.050577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669753 LIMIT 4 [ RunTime:0.047245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669753 ORDER BY `minOrder` ASC [ RunTime:0.009700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669753 ORDER BY `unit` DESC [ RunTime:0.030566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669753 LIMIT 2 [ RunTime:0.022135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669753 ORDER BY `minOrder` ASC [ RunTime:0.012203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669264 LIMIT 4 [ RunTime:0.025977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669264 ORDER BY `minOrder` ASC [ RunTime:0.013291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669264 ORDER BY `unit` DESC [ RunTime:0.029946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669264 LIMIT 2 [ RunTime:0.028591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669264 ORDER BY `minOrder` ASC [ RunTime:0.009716s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMBJ6.5A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.007344s ]