SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002910s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000723s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002195s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.62' ) [ RunTime:0.012221s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001197s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006828s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001185s ]
SELECT * FROM `stock_search` WHERE `partno` = 'UC3845B' LIMIT 1 [ RunTime:0.000348s ]
UPDATE `stock_search` SET `count` = 2410 , `updatetime` = '2026-06-03 08:02:24' WHERE `partno` = 'UC3845B' [ RunTime:0.004135s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000183s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000163s ]
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.000406s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001721s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'UC3845B%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.009812s ]
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 'UC3845B%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006523s ]
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 ('20145660','19143519','17097070','25207758','19145106','25206007','16073636','25207915','25209585','19147460','15318566','25206661','25206704','25206024','16074039','25206031','25206004','25206039','16074134','19145118') ORDER BY FIELD(s.id, 20145660,19143519,17097070,25207758,19145106,25206007,16073636,25207915,25209585,19147460,15318566,25206661,25206704,25206024,16074039,25206031,25206004,25206039,16074134,19145118) [ RunTime:0.019274s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20145660 LIMIT 4 [ RunTime:0.001844s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20145660 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20145660 ORDER BY `unit` DESC [ RunTime:0.003062s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20145660 LIMIT 2 [ RunTime:0.003094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20145660 ORDER BY `minOrder` ASC [ RunTime:0.006141s ]
select * from pdf where partno='UC3845B' and brandshort='UMW' limit 1 [ RunTime:0.002248s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UC3845B' OR `brand` LIKE 'UMW(友台半导体)%' ) ) LIMIT 1 [ RunTime:0.005471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19143519 LIMIT 4 [ RunTime:0.002945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19143519 ORDER BY `minOrder` ASC [ RunTime:0.001980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19143519 ORDER BY `unit` DESC [ RunTime:0.000436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19143519 LIMIT 2 [ RunTime:0.002577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19143519 ORDER BY `minOrder` ASC [ RunTime:0.004353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17097070 LIMIT 4 [ RunTime:0.002655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17097070 ORDER BY `minOrder` ASC [ RunTime:0.001704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17097070 ORDER BY `unit` DESC [ RunTime:0.000493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17097070 LIMIT 2 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17097070 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25207758 LIMIT 4 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25207758 ORDER BY `minOrder` ASC [ RunTime:0.002813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25207758 ORDER BY `unit` DESC [ RunTime:0.001997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25207758 LIMIT 2 [ RunTime:0.021999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25207758 ORDER BY `minOrder` ASC [ RunTime:0.009995s ]
select * from pdf where partno='UC3845BVDR2G' and brandshort='onsemi' limit 1 [ RunTime:0.001511s ]
select foldpath,foldpath2,filename from pdf_file where id=1152415 limit 1 [ RunTime:0.000934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UC3845BVDR2G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.015594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19145106 LIMIT 4 [ RunTime:0.000965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19145106 ORDER BY `minOrder` ASC [ RunTime:0.002817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19145106 ORDER BY `unit` DESC [ RunTime:0.000559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19145106 LIMIT 2 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19145106 ORDER BY `minOrder` ASC [ RunTime:0.002242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25206007 LIMIT 4 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206007 ORDER BY `minOrder` ASC [ RunTime:0.005938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25206007 ORDER BY `unit` DESC [ RunTime:0.005288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25206007 LIMIT 2 [ RunTime:0.001778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206007 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='UC3845BVD1R2G' and brandshort='onsemi' limit 1 [ RunTime:0.001686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UC3845BVD1R2G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.018145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16073636 LIMIT 4 [ RunTime:0.012782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16073636 ORDER BY `minOrder` ASC [ RunTime:0.007506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16073636 ORDER BY `unit` DESC [ RunTime:0.000563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16073636 LIMIT 2 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16073636 ORDER BY `minOrder` ASC [ RunTime:0.002503s ]
select * from pdf where partno='UC3845B' and brandshort='UMW' limit 1 [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25207915 LIMIT 4 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25207915 ORDER BY `minOrder` ASC [ RunTime:0.016923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25207915 ORDER BY `unit` DESC [ RunTime:0.005519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25207915 LIMIT 2 [ RunTime:0.016645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25207915 ORDER BY `minOrder` ASC [ RunTime:0.002117s ]
select * from pdf where partno='UC3845B' and brandshort='UMW' limit 1 [ RunTime:0.000370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UC3845B' OR `brand` LIKE 'UMW%' ) ) LIMIT 1 [ RunTime:0.003210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25209585 LIMIT 4 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25209585 ORDER BY `minOrder` ASC [ RunTime:0.004789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25209585 ORDER BY `unit` DESC [ RunTime:0.023689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25209585 LIMIT 2 [ RunTime:0.015679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25209585 ORDER BY `minOrder` ASC [ RunTime:0.005301s ]
select * from pdf where partno='UC3845BD1G' and brandshort='onsemi' limit 1 [ RunTime:0.006710s ]
select foldpath,foldpath2,filename from pdf_file where id=1152415 limit 1 [ RunTime:0.003983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UC3845BD1G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.023345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19147460 LIMIT 4 [ RunTime:0.008322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19147460 ORDER BY `minOrder` ASC [ RunTime:0.008513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19147460 ORDER BY `unit` DESC [ RunTime:0.000988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19147460 LIMIT 2 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19147460 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15318566 LIMIT 4 [ RunTime:0.001286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15318566 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15318566 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15318566 LIMIT 2 [ RunTime:0.003264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15318566 ORDER BY `minOrder` ASC [ RunTime:0.003885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25206661 LIMIT 4 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206661 ORDER BY `minOrder` ASC [ RunTime:0.003528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25206661 ORDER BY `unit` DESC [ RunTime:0.006711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25206661 LIMIT 2 [ RunTime:0.002909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206661 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
select * from pdf where partno='UC3845BDR2G' and brandshort='onsemi' limit 1 [ RunTime:0.001222s ]
select foldpath,foldpath2,filename from pdf_file where id=1106279 limit 1 [ RunTime:0.000964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UC3845BDR2G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.014952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25206704 LIMIT 4 [ RunTime:0.000803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206704 ORDER BY `minOrder` ASC [ RunTime:0.001162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25206704 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25206704 LIMIT 2 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206704 ORDER BY `minOrder` ASC [ RunTime:0.001872s ]
select * from pdf where partno='UC3845BD1' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.001154s ]
select foldpath,foldpath2,filename from pdf_file where id=448492 limit 1 [ RunTime:0.003410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UC3845BD1' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.000799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25206024 LIMIT 4 [ RunTime:0.002911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206024 ORDER BY `minOrder` ASC [ RunTime:0.005267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25206024 ORDER BY `unit` DESC [ RunTime:0.002557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25206024 LIMIT 2 [ RunTime:0.001207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206024 ORDER BY `minOrder` ASC [ RunTime:0.006399s ]
select * from pdf where partno='UC3845BD1013TR' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.003254s ]
select foldpath,foldpath2,filename from pdf_file where id=1045160 limit 1 [ RunTime:0.000777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UC3845BD1013TR' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.005746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16074039 LIMIT 4 [ RunTime:0.006673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16074039 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16074039 ORDER BY `unit` DESC [ RunTime:0.002906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16074039 LIMIT 2 [ RunTime:0.006284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16074039 ORDER BY `minOrder` ASC [ RunTime:0.003847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25206031 LIMIT 4 [ RunTime:0.007022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206031 ORDER BY `minOrder` ASC [ RunTime:0.008530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25206031 ORDER BY `unit` DESC [ RunTime:0.001512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25206031 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206031 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='UC3845BN' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.001277s ]
select foldpath,foldpath2,filename from pdf_file where id=448492 limit 1 [ RunTime:0.001950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UC3845BN' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.007552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25206004 LIMIT 4 [ RunTime:0.013725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206004 ORDER BY `minOrder` ASC [ RunTime:0.040882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25206004 ORDER BY `unit` DESC [ RunTime:0.010230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25206004 LIMIT 2 [ RunTime:0.003234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206004 ORDER BY `minOrder` ASC [ RunTime:0.004440s ]
select * from pdf where partno='UC3845BD1R2G' and brandshort='onsemi' limit 1 [ RunTime:0.005829s ]
select foldpath,foldpath2,filename from pdf_file where id=448493 limit 1 [ RunTime:0.002535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UC3845BD1R2G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.034179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25206039 LIMIT 4 [ RunTime:0.004331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206039 ORDER BY `minOrder` ASC [ RunTime:0.002715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25206039 ORDER BY `unit` DESC [ RunTime:0.001956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25206039 LIMIT 2 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25206039 ORDER BY `minOrder` ASC [ RunTime:0.001774s ]
select * from pdf where partno='UC3845BNG' and brandshort='onsemi' limit 1 [ RunTime:0.000790s ]
select foldpath,foldpath2,filename from pdf_file where id=448493 limit 1 [ RunTime:0.001075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UC3845BNG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.011484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16074134 LIMIT 4 [ RunTime:0.005871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16074134 ORDER BY `minOrder` ASC [ RunTime:0.012049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16074134 ORDER BY `unit` DESC [ RunTime:0.003848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16074134 LIMIT 2 [ RunTime:0.006695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16074134 ORDER BY `minOrder` ASC [ RunTime:0.006077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19145118 LIMIT 4 [ RunTime:0.009264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19145118 ORDER BY `minOrder` ASC [ RunTime:0.007725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19145118 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19145118 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19145118 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'UC3845B%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.005282s ]