SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001434s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009514s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002420s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.010693s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001823s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006127s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001931s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ15CA' LIMIT 1 [ RunTime:0.011707s ]
UPDATE `stock_search` SET `count` = 10398 , `updatetime` = '2026-04-25 18:29:16' WHERE `partno` = 'SMBJ15CA' [ RunTime:0.003281s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.009485s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.020087s ]
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.020316s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003555s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMBJ15CA%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.020947s ]
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 'SMBJ15CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.011800s ]
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 ('13929203','14829066','3553','16689239','14827521','14800795','14807405','13907925','14817','16664758','16691441','16691159','16691158','16691017','16689089','16683168','16672666','16672665','16671043','16670511') ORDER BY FIELD(s.id, 13929203,14829066,3553,16689239,14827521,14800795,14807405,13907925,14817,16664758,16691441,16691159,16691158,16691017,16689089,16683168,16672666,16672665,16671043,16670511) [ RunTime:0.032564s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13929203 LIMIT 4 [ RunTime:0.008666s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929203 ORDER BY `minOrder` ASC [ RunTime:0.006879s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13929203 ORDER BY `unit` DESC [ RunTime:0.003591s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13929203 LIMIT 2 [ RunTime:0.011965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929203 ORDER BY `minOrder` ASC [ RunTime:0.003997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829066 LIMIT 4 [ RunTime:0.011713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829066 ORDER BY `minOrder` ASC [ RunTime:0.021332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829066 ORDER BY `unit` DESC [ RunTime:0.000585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829066 LIMIT 2 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829066 ORDER BY `minOrder` ASC [ RunTime:0.007337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3553 LIMIT 4 [ RunTime:0.029105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3553 ORDER BY `minOrder` ASC [ RunTime:0.013694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3553 ORDER BY `unit` DESC [ RunTime:0.008955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3553 LIMIT 2 [ RunTime:0.002455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3553 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ15CA-E3/52' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.025833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689239 LIMIT 4 [ RunTime:0.029028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689239 ORDER BY `minOrder` ASC [ RunTime:0.008306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689239 ORDER BY `unit` DESC [ RunTime:0.019645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689239 LIMIT 2 [ RunTime:0.006201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689239 ORDER BY `minOrder` ASC [ RunTime:0.002889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827521 LIMIT 4 [ RunTime:0.012622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827521 ORDER BY `minOrder` ASC [ RunTime:0.019276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827521 ORDER BY `unit` DESC [ RunTime:0.038812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827521 LIMIT 2 [ RunTime:0.035808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827521 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800795 LIMIT 4 [ RunTime:0.007680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800795 ORDER BY `minOrder` ASC [ RunTime:0.002701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800795 ORDER BY `unit` DESC [ RunTime:0.003402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800795 LIMIT 2 [ RunTime:0.025971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800795 ORDER BY `minOrder` ASC [ RunTime:0.007303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807405 LIMIT 4 [ RunTime:0.026070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807405 ORDER BY `minOrder` ASC [ RunTime:0.018453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807405 ORDER BY `unit` DESC [ RunTime:0.006218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807405 LIMIT 2 [ RunTime:0.012415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807405 ORDER BY `minOrder` ASC [ RunTime:0.009954s ]
select * from pdf where partno='SMBJ15CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.032795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907925 LIMIT 4 [ RunTime:0.010412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907925 ORDER BY `minOrder` ASC [ RunTime:0.010460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907925 ORDER BY `unit` DESC [ RunTime:0.003832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907925 LIMIT 2 [ RunTime:0.002591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907925 ORDER BY `minOrder` ASC [ RunTime:0.021962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817 LIMIT 4 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14817 ORDER BY `unit` DESC [ RunTime:0.001833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14817 LIMIT 2 [ RunTime:0.003833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817 ORDER BY `minOrder` ASC [ RunTime:0.003053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ15CA-TR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.005647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664758 LIMIT 4 [ RunTime:0.001101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664758 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664758 ORDER BY `unit` DESC [ RunTime:0.002036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664758 LIMIT 2 [ RunTime:0.011144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664758 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691441 LIMIT 4 [ RunTime:0.002929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691441 ORDER BY `minOrder` ASC [ RunTime:0.002726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691441 ORDER BY `unit` DESC [ RunTime:0.005157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691441 LIMIT 2 [ RunTime:0.006126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691441 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691159 LIMIT 4 [ RunTime:0.001066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691159 ORDER BY `minOrder` ASC [ RunTime:0.011585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691159 ORDER BY `unit` DESC [ RunTime:0.010290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691159 LIMIT 2 [ RunTime:0.003089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691159 ORDER BY `minOrder` ASC [ RunTime:0.002951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691158 LIMIT 4 [ RunTime:0.003499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691158 ORDER BY `minOrder` ASC [ RunTime:0.005171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691158 ORDER BY `unit` DESC [ RunTime:0.007234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691158 LIMIT 2 [ RunTime:0.006101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691158 ORDER BY `minOrder` ASC [ RunTime:0.006469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691017 LIMIT 4 [ RunTime:0.001104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691017 ORDER BY `minOrder` ASC [ RunTime:0.001925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691017 ORDER BY `unit` DESC [ RunTime:0.002045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691017 LIMIT 2 [ RunTime:0.000984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691017 ORDER BY `minOrder` ASC [ RunTime:0.002531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689089 LIMIT 4 [ RunTime:0.001069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689089 ORDER BY `minOrder` ASC [ RunTime:0.000662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689089 ORDER BY `unit` DESC [ RunTime:0.000747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689089 LIMIT 2 [ RunTime:0.001792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689089 ORDER BY `minOrder` ASC [ RunTime:0.001320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683168 LIMIT 4 [ RunTime:0.001092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683168 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683168 ORDER BY `unit` DESC [ RunTime:0.005657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683168 LIMIT 2 [ RunTime:0.001274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683168 ORDER BY `minOrder` ASC [ RunTime:0.000721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672666 LIMIT 4 [ RunTime:0.002243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672666 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672666 ORDER BY `unit` DESC [ RunTime:0.008000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672666 LIMIT 2 [ RunTime:0.012159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672666 ORDER BY `minOrder` ASC [ RunTime:0.003124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672665 LIMIT 4 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672665 ORDER BY `minOrder` ASC [ RunTime:0.002717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672665 ORDER BY `unit` DESC [ RunTime:0.002112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672665 LIMIT 2 [ RunTime:0.004871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672665 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671043 LIMIT 4 [ RunTime:0.001149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671043 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671043 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671043 LIMIT 2 [ RunTime:0.001041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671043 ORDER BY `minOrder` ASC [ RunTime:0.003821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670511 LIMIT 4 [ RunTime:0.001333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670511 ORDER BY `minOrder` ASC [ RunTime:0.000805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670511 ORDER BY `unit` DESC [ RunTime:0.002046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670511 LIMIT 2 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670511 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMBJ15CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002275s ]