SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002232s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002755s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002460s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.93' ) [ RunTime:0.002719s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001433s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.015129s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001537s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ30CA' LIMIT 1 [ RunTime:0.007097s ]
UPDATE `stock_search` SET `count` = 17529 , `updatetime` = '2026-06-02 19:56:21' WHERE `partno` = 'SMBJ30CA' [ RunTime:0.009485s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001006s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.006356s ]
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.008324s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001662s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMBJ30CA%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.003834s ]
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 'SMBJ30CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.021085s ]
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 ('30144002','16667718','30098397','16673264','30136944','16693212','16662534','30143961','14831441','30126149','30142407','13904618','14801292','30150076','16685406','16662924','14800565','14819','13928206','14801054') ORDER BY FIELD(s.id, 30144002,16667718,30098397,16673264,30136944,16693212,16662534,30143961,14831441,30126149,30142407,13904618,14801292,30150076,16685406,16662924,14800565,14819,13928206,14801054) [ RunTime:0.027429s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30144002 LIMIT 4 [ RunTime:0.019246s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30144002 ORDER BY `minOrder` ASC [ RunTime:0.011823s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30144002 ORDER BY `unit` DESC [ RunTime:0.011097s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30144002 LIMIT 2 [ RunTime:0.017604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30144002 ORDER BY `minOrder` ASC [ RunTime:0.022898s ]
select * from pdf where partno='SMBJ30CA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.014731s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.016871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667718 LIMIT 4 [ RunTime:0.021682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667718 ORDER BY `minOrder` ASC [ RunTime:0.019913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667718 ORDER BY `unit` DESC [ RunTime:0.069630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667718 LIMIT 2 [ RunTime:0.004446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667718 ORDER BY `minOrder` ASC [ RunTime:0.018223s ]
select * from pdf where partno='SMBJ30CAQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.002351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30098397 LIMIT 4 [ RunTime:0.029525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30098397 ORDER BY `minOrder` ASC [ RunTime:0.032860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30098397 ORDER BY `unit` DESC [ RunTime:0.021552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30098397 LIMIT 2 [ RunTime:0.034107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30098397 ORDER BY `minOrder` ASC [ RunTime:0.004734s ]
select * from pdf where partno='SMBJ30CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.013170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.027468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673264 LIMIT 4 [ RunTime:0.007858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673264 ORDER BY `minOrder` ASC [ RunTime:0.017114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673264 ORDER BY `unit` DESC [ RunTime:0.023746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673264 LIMIT 2 [ RunTime:0.022197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673264 ORDER BY `minOrder` ASC [ RunTime:0.007086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30136944 LIMIT 4 [ RunTime:0.008235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30136944 ORDER BY `minOrder` ASC [ RunTime:0.014799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30136944 ORDER BY `unit` DESC [ RunTime:0.025533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30136944 LIMIT 2 [ RunTime:0.020719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30136944 ORDER BY `minOrder` ASC [ RunTime:0.012639s ]
select * from pdf where partno='SMBJ30CAHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CAHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.027046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16693212 LIMIT 4 [ RunTime:0.012165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16693212 ORDER BY `minOrder` ASC [ RunTime:0.011897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16693212 ORDER BY `unit` DESC [ RunTime:0.051029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16693212 LIMIT 2 [ RunTime:0.035512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16693212 ORDER BY `minOrder` ASC [ RunTime:0.010685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662534 LIMIT 4 [ RunTime:0.012041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662534 ORDER BY `minOrder` ASC [ RunTime:0.010057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662534 ORDER BY `unit` DESC [ RunTime:0.021063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662534 LIMIT 2 [ RunTime:0.017594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662534 ORDER BY `minOrder` ASC [ RunTime:0.020489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30143961 LIMIT 4 [ RunTime:0.019257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30143961 ORDER BY `minOrder` ASC [ RunTime:0.011430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30143961 ORDER BY `unit` DESC [ RunTime:0.051800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30143961 LIMIT 2 [ RunTime:0.013521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30143961 ORDER BY `minOrder` ASC [ RunTime:0.016075s ]
select * from pdf where partno='SMBJ30CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.025236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.030028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831441 LIMIT 4 [ RunTime:0.020316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831441 ORDER BY `minOrder` ASC [ RunTime:0.009384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831441 ORDER BY `unit` DESC [ RunTime:0.014545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831441 LIMIT 2 [ RunTime:0.026483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831441 ORDER BY `minOrder` ASC [ RunTime:0.031888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30126149 LIMIT 4 [ RunTime:0.024680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30126149 ORDER BY `minOrder` ASC [ RunTime:0.006716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30126149 ORDER BY `unit` DESC [ RunTime:0.010693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30126149 LIMIT 2 [ RunTime:0.009714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30126149 ORDER BY `minOrder` ASC [ RunTime:0.013173s ]
select * from pdf where partno='SMBJ30CA-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA-M3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.016796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30142407 LIMIT 4 [ RunTime:0.026223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30142407 ORDER BY `minOrder` ASC [ RunTime:0.027734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30142407 ORDER BY `unit` DESC [ RunTime:0.013710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30142407 LIMIT 2 [ RunTime:0.025512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30142407 ORDER BY `minOrder` ASC [ RunTime:0.017528s ]
select * from pdf where partno='SMBJ30CA' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.031183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.041440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904618 LIMIT 4 [ RunTime:0.030169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904618 ORDER BY `minOrder` ASC [ RunTime:0.042521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904618 ORDER BY `unit` DESC [ RunTime:0.036820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904618 LIMIT 2 [ RunTime:0.036611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904618 ORDER BY `minOrder` ASC [ RunTime:0.012256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801292 LIMIT 4 [ RunTime:0.030476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801292 ORDER BY `minOrder` ASC [ RunTime:0.012676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801292 ORDER BY `unit` DESC [ RunTime:0.049464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801292 LIMIT 2 [ RunTime:0.010028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801292 ORDER BY `minOrder` ASC [ RunTime:0.004628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30150076 LIMIT 4 [ RunTime:0.016155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30150076 ORDER BY `minOrder` ASC [ RunTime:0.050063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30150076 ORDER BY `unit` DESC [ RunTime:0.019515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30150076 LIMIT 2 [ RunTime:0.015582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30150076 ORDER BY `minOrder` ASC [ RunTime:0.006875s ]
select * from pdf where partno='SMBJ30CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16685406 LIMIT 4 [ RunTime:0.039049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685406 ORDER BY `minOrder` ASC [ RunTime:0.031643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16685406 ORDER BY `unit` DESC [ RunTime:0.012266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16685406 LIMIT 2 [ RunTime:0.027606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685406 ORDER BY `minOrder` ASC [ RunTime:0.008739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662924 LIMIT 4 [ RunTime:0.002786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662924 ORDER BY `minOrder` ASC [ RunTime:0.049863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662924 ORDER BY `unit` DESC [ RunTime:0.018431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662924 LIMIT 2 [ RunTime:0.009595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662924 ORDER BY `minOrder` ASC [ RunTime:0.012350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800565 LIMIT 4 [ RunTime:0.021097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800565 ORDER BY `minOrder` ASC [ RunTime:0.036766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800565 ORDER BY `unit` DESC [ RunTime:0.026507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800565 LIMIT 2 [ RunTime:0.056682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800565 ORDER BY `minOrder` ASC [ RunTime:0.010375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819 LIMIT 4 [ RunTime:0.013444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819 ORDER BY `minOrder` ASC [ RunTime:0.006382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819 ORDER BY `unit` DESC [ RunTime:0.016403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819 LIMIT 2 [ RunTime:0.017091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819 ORDER BY `minOrder` ASC [ RunTime:0.020165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA-TR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.012214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928206 LIMIT 4 [ RunTime:0.009214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928206 ORDER BY `minOrder` ASC [ RunTime:0.042650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928206 ORDER BY `unit` DESC [ RunTime:0.023828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928206 LIMIT 2 [ RunTime:0.023661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928206 ORDER BY `minOrder` ASC [ RunTime:0.036178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801054 LIMIT 4 [ RunTime:0.017122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801054 ORDER BY `minOrder` ASC [ RunTime:0.011839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801054 ORDER BY `unit` DESC [ RunTime:0.013349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801054 LIMIT 2 [ RunTime:0.038976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801054 ORDER BY `minOrder` ASC [ RunTime:0.009960s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMBJ30CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.007144s ]