SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001817s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005669s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002442s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.62' ) [ RunTime:0.000387s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002148s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000366s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003419s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ48A' LIMIT 1 [ RunTime:0.004080s ]
UPDATE `stock_search` SET `count` = 20004 , `updatetime` = '2026-06-03 11:25:32' WHERE `partno` = 'SMBJ48A' [ RunTime:0.005710s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000287s ]
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.000477s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002352s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMBJ48A%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.050117s ]
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 'SMBJ48A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001348s ]
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 ('30155083','14801752','13905350','13909703','14802604','16667336','14830246','30121276','30096031','30098427','30097476','16686962','16665024','30095598','16662271','16688887','14799701','30136414','30119547','30104107') ORDER BY FIELD(s.id, 30155083,14801752,13905350,13909703,14802604,16667336,14830246,30121276,30096031,30098427,30097476,16686962,16665024,30095598,16662271,16688887,14799701,30136414,30119547,30104107) [ RunTime:0.004011s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30155083 LIMIT 4 [ RunTime:0.005876s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30155083 ORDER BY `minOrder` ASC [ RunTime:0.017846s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30155083 ORDER BY `unit` DESC [ RunTime:0.007771s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30155083 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30155083 ORDER BY `minOrder` ASC [ RunTime:0.000220s ]
select * from pdf where partno='SMBJ48AL00S0MX' and brandshort='NextGen Components' limit 1 [ RunTime:0.006329s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ48AL00S0MX' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.012027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801752 LIMIT 4 [ RunTime:0.010925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801752 ORDER BY `minOrder` ASC [ RunTime:0.001214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801752 ORDER BY `unit` DESC [ RunTime:0.000749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801752 LIMIT 2 [ RunTime:0.001827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801752 ORDER BY `minOrder` ASC [ RunTime:0.003250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905350 LIMIT 4 [ RunTime:0.003205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905350 ORDER BY `minOrder` ASC [ RunTime:0.005523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905350 ORDER BY `unit` DESC [ RunTime:0.005398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905350 LIMIT 2 [ RunTime:0.002337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905350 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909703 LIMIT 4 [ RunTime:0.009194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909703 ORDER BY `minOrder` ASC [ RunTime:0.000908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13909703 ORDER BY `unit` DESC [ RunTime:0.000577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13909703 LIMIT 2 [ RunTime:0.007850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909703 ORDER BY `minOrder` ASC [ RunTime:0.003030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802604 LIMIT 4 [ RunTime:0.001304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802604 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802604 ORDER BY `unit` DESC [ RunTime:0.010472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802604 LIMIT 2 [ RunTime:0.000863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802604 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667336 LIMIT 4 [ RunTime:0.001138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667336 ORDER BY `minOrder` ASC [ RunTime:0.003417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667336 ORDER BY `unit` DESC [ RunTime:0.000820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667336 LIMIT 2 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667336 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830246 LIMIT 4 [ RunTime:0.004423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830246 ORDER BY `minOrder` ASC [ RunTime:0.003191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830246 ORDER BY `unit` DESC [ RunTime:0.005868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830246 LIMIT 2 [ RunTime:0.002690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830246 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30121276 LIMIT 4 [ RunTime:0.004908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30121276 ORDER BY `minOrder` ASC [ RunTime:0.008861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30121276 ORDER BY `unit` DESC [ RunTime:0.005084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30121276 LIMIT 2 [ RunTime:0.002078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30121276 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='SMBJ48AH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.003828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ48AH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.002615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30096031 LIMIT 4 [ RunTime:0.017645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30096031 ORDER BY `minOrder` ASC [ RunTime:0.007423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30096031 ORDER BY `unit` DESC [ RunTime:0.004357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30096031 LIMIT 2 [ RunTime:0.008719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30096031 ORDER BY `minOrder` ASC [ RunTime:0.000820s ]
select * from pdf where partno='SMBJ48A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.007501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ48A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.011032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30098427 LIMIT 4 [ RunTime:0.005461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30098427 ORDER BY `minOrder` ASC [ RunTime:0.012306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30098427 ORDER BY `unit` DESC [ RunTime:0.000762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30098427 LIMIT 2 [ RunTime:0.000949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30098427 ORDER BY `minOrder` ASC [ RunTime:0.001180s ]
select * from pdf where partno='SMBJ48A-TR' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.011692s ]
select foldpath,foldpath2,filename from pdf_file where id=422264 limit 1 [ RunTime:0.013886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ48A-TR' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.012906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30097476 LIMIT 4 [ RunTime:0.034759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30097476 ORDER BY `minOrder` ASC [ RunTime:0.004813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30097476 ORDER BY `unit` DESC [ RunTime:0.009789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30097476 LIMIT 2 [ RunTime:0.007583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30097476 ORDER BY `minOrder` ASC [ RunTime:0.008585s ]
select * from pdf where partno='SMBJ48A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.006853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ48A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.033759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16686962 LIMIT 4 [ RunTime:0.030140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16686962 ORDER BY `minOrder` ASC [ RunTime:0.040732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16686962 ORDER BY `unit` DESC [ RunTime:0.023219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16686962 LIMIT 2 [ RunTime:0.006923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16686962 ORDER BY `minOrder` ASC [ RunTime:0.019868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665024 LIMIT 4 [ RunTime:0.008910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665024 ORDER BY `minOrder` ASC [ RunTime:0.000780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665024 ORDER BY `unit` DESC [ RunTime:0.000541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665024 LIMIT 2 [ RunTime:0.006854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665024 ORDER BY `minOrder` ASC [ RunTime:0.001963s ]
select * from pdf where partno='SMBJ48A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.022553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30095598 LIMIT 4 [ RunTime:0.009561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30095598 ORDER BY `minOrder` ASC [ RunTime:0.012723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30095598 ORDER BY `unit` DESC [ RunTime:0.002452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30095598 LIMIT 2 [ RunTime:0.001745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30095598 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
select * from pdf where partno='SMBJ48A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ48A-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.019141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662271 LIMIT 4 [ RunTime:0.004463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662271 ORDER BY `minOrder` ASC [ RunTime:0.002352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662271 ORDER BY `unit` DESC [ RunTime:0.012611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662271 LIMIT 2 [ RunTime:0.006023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662271 ORDER BY `minOrder` ASC [ RunTime:0.013582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688887 LIMIT 4 [ RunTime:0.010117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688887 ORDER BY `minOrder` ASC [ RunTime:0.013026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688887 ORDER BY `unit` DESC [ RunTime:0.023599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688887 LIMIT 2 [ RunTime:0.002348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688887 ORDER BY `minOrder` ASC [ RunTime:0.003756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799701 LIMIT 4 [ RunTime:0.014374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799701 ORDER BY `minOrder` ASC [ RunTime:0.001283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799701 ORDER BY `unit` DESC [ RunTime:0.001101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799701 LIMIT 2 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799701 ORDER BY `minOrder` ASC [ RunTime:0.004471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30136414 LIMIT 4 [ RunTime:0.002791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30136414 ORDER BY `minOrder` ASC [ RunTime:0.008083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30136414 ORDER BY `unit` DESC [ RunTime:0.013919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30136414 LIMIT 2 [ RunTime:0.002149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30136414 ORDER BY `minOrder` ASC [ RunTime:0.012133s ]
select * from pdf where partno='SMBJ48A' and brandshort='Semtech Corporation' limit 1 [ RunTime:0.000921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ48A' OR `brand` LIKE 'Semtech Corporation%' ) ) LIMIT 1 [ RunTime:0.001778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30119547 LIMIT 4 [ RunTime:0.006257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30119547 ORDER BY `minOrder` ASC [ RunTime:0.002980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30119547 ORDER BY `unit` DESC [ RunTime:0.015630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30119547 LIMIT 2 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30119547 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='SMBJ48A' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.000638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ48A' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.004207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30104107 LIMIT 4 [ RunTime:0.030476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30104107 ORDER BY `minOrder` ASC [ RunTime:0.019103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30104107 ORDER BY `unit` DESC [ RunTime:0.005336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30104107 LIMIT 2 [ RunTime:0.009039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30104107 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='SMBJ48A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ48A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.018560s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMBJ48A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.015065s ]