SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001730s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000597s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.007796s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.170' ) [ RunTime:0.001927s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001432s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000323s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001434s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ33A' LIMIT 1 [ RunTime:0.005951s ]
UPDATE `stock_search` SET `count` = 6116 , `updatetime` = '2026-03-04 21:12:48' WHERE `partno` = 'SMBJ33A' [ RunTime:0.002900s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000245s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000199s ]
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.000371s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001638s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMBJ33A%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.010967s ]
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 'SMBJ33A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008741s ]
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 ('14801726','13905347','13915617','14803005','14804490','16690029','16675505','14803032','13909393','13910336','13905561','13905787','14829431','13915933','16672909','13906070','16662535','13905743','14799868','14800792') ORDER BY FIELD(s.id, 14801726,13905347,13915617,14803005,14804490,16690029,16675505,14803032,13909393,13910336,13905561,13905787,14829431,13915933,16672909,13906070,16662535,13905743,14799868,14800792) [ RunTime:0.008401s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801726 LIMIT 4 [ RunTime:0.000704s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801726 ORDER BY `minOrder` ASC [ RunTime:0.002033s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801726 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801726 LIMIT 2 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801726 ORDER BY `minOrder` ASC [ RunTime:0.000161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905347 LIMIT 4 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905347 ORDER BY `minOrder` ASC [ RunTime:0.002101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905347 ORDER BY `unit` DESC [ RunTime:0.001846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905347 LIMIT 2 [ RunTime:0.000263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905347 ORDER BY `minOrder` ASC [ RunTime:0.000156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915617 LIMIT 4 [ RunTime:0.000820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915617 ORDER BY `minOrder` ASC [ RunTime:0.000816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915617 ORDER BY `unit` DESC [ RunTime:0.003172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915617 LIMIT 2 [ RunTime:0.001055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915617 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
select * from pdf where partno='SMBJ33AQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803005 LIMIT 4 [ RunTime:0.003865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803005 ORDER BY `minOrder` ASC [ RunTime:0.008919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803005 ORDER BY `unit` DESC [ RunTime:0.001024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803005 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803005 ORDER BY `minOrder` ASC [ RunTime:0.001989s ]
select * from pdf where partno='SMBJ33A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804490 LIMIT 4 [ RunTime:0.002682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804490 ORDER BY `minOrder` ASC [ RunTime:0.002186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14804490 ORDER BY `unit` DESC [ RunTime:0.000552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14804490 LIMIT 2 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804490 ORDER BY `minOrder` ASC [ RunTime:0.000920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690029 LIMIT 4 [ RunTime:0.001258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690029 ORDER BY `minOrder` ASC [ RunTime:0.003671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690029 ORDER BY `unit` DESC [ RunTime:0.001463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690029 LIMIT 2 [ RunTime:0.003397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690029 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675505 LIMIT 4 [ RunTime:0.002595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675505 ORDER BY `minOrder` ASC [ RunTime:0.001829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675505 ORDER BY `unit` DESC [ RunTime:0.001578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675505 LIMIT 2 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675505 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803032 LIMIT 4 [ RunTime:0.001086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803032 ORDER BY `minOrder` ASC [ RunTime:0.005057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803032 ORDER BY `unit` DESC [ RunTime:0.003014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803032 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803032 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909393 LIMIT 4 [ RunTime:0.003750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909393 ORDER BY `minOrder` ASC [ RunTime:0.005493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13909393 ORDER BY `unit` DESC [ RunTime:0.001602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13909393 LIMIT 2 [ RunTime:0.001279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909393 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910336 LIMIT 4 [ RunTime:0.000918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910336 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910336 ORDER BY `unit` DESC [ RunTime:0.000566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910336 LIMIT 2 [ RunTime:0.002061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910336 ORDER BY `minOrder` ASC [ RunTime:0.002583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905561 LIMIT 4 [ RunTime:0.007133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905561 ORDER BY `minOrder` ASC [ RunTime:0.010341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905561 ORDER BY `unit` DESC [ RunTime:0.013200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905561 LIMIT 2 [ RunTime:0.008437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905561 ORDER BY `minOrder` ASC [ RunTime:0.002413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905787 LIMIT 4 [ RunTime:0.003228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905787 ORDER BY `minOrder` ASC [ RunTime:0.006520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905787 ORDER BY `unit` DESC [ RunTime:0.002000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905787 LIMIT 2 [ RunTime:0.001710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905787 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829431 LIMIT 4 [ RunTime:0.003486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829431 ORDER BY `minOrder` ASC [ RunTime:0.008220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829431 ORDER BY `unit` DESC [ RunTime:0.003115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829431 LIMIT 2 [ RunTime:0.000829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829431 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915933 LIMIT 4 [ RunTime:0.001101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915933 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915933 ORDER BY `unit` DESC [ RunTime:0.000494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915933 LIMIT 2 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915933 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672909 LIMIT 4 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672909 ORDER BY `minOrder` ASC [ RunTime:0.002093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672909 ORDER BY `unit` DESC [ RunTime:0.000548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672909 LIMIT 2 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672909 ORDER BY `minOrder` ASC [ RunTime:0.000976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906070 LIMIT 4 [ RunTime:0.001840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906070 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906070 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906070 LIMIT 2 [ RunTime:0.004160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906070 ORDER BY `minOrder` ASC [ RunTime:0.003116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662535 LIMIT 4 [ RunTime:0.001069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662535 ORDER BY `minOrder` ASC [ RunTime:0.001244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662535 ORDER BY `unit` DESC [ RunTime:0.001363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662535 LIMIT 2 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662535 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905743 LIMIT 4 [ RunTime:0.000820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905743 ORDER BY `minOrder` ASC [ RunTime:0.004299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905743 ORDER BY `unit` DESC [ RunTime:0.002561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905743 LIMIT 2 [ RunTime:0.002079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905743 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799868 LIMIT 4 [ RunTime:0.002385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799868 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799868 ORDER BY `unit` DESC [ RunTime:0.000485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799868 LIMIT 2 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799868 ORDER BY `minOrder` ASC [ RunTime:0.001786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800792 LIMIT 4 [ RunTime:0.000807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800792 ORDER BY `minOrder` ASC [ RunTime:0.005406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800792 ORDER BY `unit` DESC [ RunTime:0.000493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800792 LIMIT 2 [ RunTime:0.001042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800792 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMBJ33A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001687s ]