SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002347s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000593s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002430s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.93' ) [ RunTime:0.000365s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002451s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000426s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002544s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TL431' LIMIT 1 [ RunTime:0.000755s ]
UPDATE `stock_search` SET `count` = 2399 , `updatetime` = '2026-06-02 04:05:38' WHERE `partno` = 'TL431' [ RunTime:0.009641s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000945s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000427s ]
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.000716s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001636s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'TL431%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.000451s ]
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 'TL431%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 580,20 [ RunTime:0.006738s ]
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 ('25047608','25046292','25046260','25046243','25046237','25046227','25046221','25046210','25046206','25046192','25046176','25046172','25046169','25046168','25046141','25046104','25046080','25046079','25046072','25046061') ORDER BY FIELD(s.id, 25047608,25046292,25046260,25046243,25046237,25046227,25046221,25046210,25046206,25046192,25046176,25046172,25046169,25046168,25046141,25046104,25046080,25046079,25046072,25046061) [ RunTime:0.005599s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047608 LIMIT 4 [ RunTime:0.005274s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047608 ORDER BY `minOrder` ASC [ RunTime:0.005760s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047608 ORDER BY `unit` DESC [ RunTime:0.002191s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047608 LIMIT 2 [ RunTime:0.002751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047608 ORDER BY `minOrder` ASC [ RunTime:0.004569s ]
select * from pdf where partno='TL431BSA-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.006045s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BSA-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.004835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046292 LIMIT 4 [ RunTime:0.007986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046292 ORDER BY `minOrder` ASC [ RunTime:0.005627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046292 ORDER BY `unit` DESC [ RunTime:0.001981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046292 LIMIT 2 [ RunTime:0.001316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046292 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='TL431BVPG' and brandshort='onsemi' limit 1 [ RunTime:0.012063s ]
select foldpath,foldpath2,filename from pdf_file where id=1060031 limit 1 [ RunTime:0.018292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BVPG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.018594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046260 LIMIT 4 [ RunTime:0.013192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046260 ORDER BY `minOrder` ASC [ RunTime:0.014992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046260 ORDER BY `unit` DESC [ RunTime:0.000995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046260 LIMIT 2 [ RunTime:0.003530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046260 ORDER BY `minOrder` ASC [ RunTime:0.002832s ]
select * from pdf where partno='TL431BIPG' and brandshort='onsemi' limit 1 [ RunTime:0.004099s ]
select foldpath,foldpath2,filename from pdf_file where id=1060031 limit 1 [ RunTime:0.005597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BIPG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.026257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046243 LIMIT 4 [ RunTime:0.003890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046243 ORDER BY `minOrder` ASC [ RunTime:0.015756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046243 ORDER BY `unit` DESC [ RunTime:0.000750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046243 LIMIT 2 [ RunTime:0.002210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046243 ORDER BY `minOrder` ASC [ RunTime:0.003515s ]
select * from pdf where partno='TL431BCPG' and brandshort='onsemi' limit 1 [ RunTime:0.002235s ]
select foldpath,foldpath2,filename from pdf_file where id=579916 limit 1 [ RunTime:0.004410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BCPG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.012393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046237 LIMIT 4 [ RunTime:0.003644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046237 ORDER BY `minOrder` ASC [ RunTime:0.005315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046237 ORDER BY `unit` DESC [ RunTime:0.015128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046237 LIMIT 2 [ RunTime:0.004018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046237 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
select * from pdf where partno='TL431BILP' and brandshort='onsemi' limit 1 [ RunTime:0.005149s ]
select foldpath,foldpath2,filename from pdf_file where id=448227 limit 1 [ RunTime:0.004605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BILP' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.023506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046227 LIMIT 4 [ RunTime:0.023662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046227 ORDER BY `minOrder` ASC [ RunTime:0.020030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046227 ORDER BY `unit` DESC [ RunTime:0.020248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046227 LIMIT 2 [ RunTime:0.013203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046227 ORDER BY `minOrder` ASC [ RunTime:0.004345s ]
select * from pdf where partno='TL431ACPG' and brandshort='onsemi' limit 1 [ RunTime:0.013753s ]
select foldpath,foldpath2,filename from pdf_file where id=579916 limit 1 [ RunTime:0.008413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431ACPG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.019095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046221 LIMIT 4 [ RunTime:0.019816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046221 ORDER BY `minOrder` ASC [ RunTime:0.003091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046221 ORDER BY `unit` DESC [ RunTime:0.012692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046221 LIMIT 2 [ RunTime:0.006100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046221 ORDER BY `minOrder` ASC [ RunTime:0.001821s ]
select * from pdf where partno='TL431CPG' and brandshort='onsemi' limit 1 [ RunTime:0.014222s ]
select foldpath,foldpath2,filename from pdf_file where id=448227 limit 1 [ RunTime:0.012406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CPG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.028487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046210 LIMIT 4 [ RunTime:0.004363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046210 ORDER BY `minOrder` ASC [ RunTime:0.003647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046210 ORDER BY `unit` DESC [ RunTime:0.007828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046210 LIMIT 2 [ RunTime:0.012856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046210 ORDER BY `minOrder` ASC [ RunTime:0.003257s ]
select * from pdf where partno='TL431CLP' and brandshort='onsemi' limit 1 [ RunTime:0.006459s ]
select foldpath,foldpath2,filename from pdf_file where id=448227 limit 1 [ RunTime:0.010593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CLP' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.040975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046206 LIMIT 4 [ RunTime:0.007246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046206 ORDER BY `minOrder` ASC [ RunTime:0.012656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046206 ORDER BY `unit` DESC [ RunTime:0.020995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046206 LIMIT 2 [ RunTime:0.003835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046206 ORDER BY `minOrder` ASC [ RunTime:0.005966s ]
select * from pdf where partno='TL431ACD' and brandshort='onsemi' limit 1 [ RunTime:0.011700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431ACD' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.040338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046192 LIMIT 4 [ RunTime:0.006085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046192 ORDER BY `minOrder` ASC [ RunTime:0.026196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046192 ORDER BY `unit` DESC [ RunTime:0.024265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046192 LIMIT 2 [ RunTime:0.015078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046192 ORDER BY `minOrder` ASC [ RunTime:0.013744s ]
select * from pdf where partno='TL431CDBVTG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CDBVTG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.009254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046176 LIMIT 4 [ RunTime:0.017584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046176 ORDER BY `minOrder` ASC [ RunTime:0.009216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046176 ORDER BY `unit` DESC [ RunTime:0.013244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046176 LIMIT 2 [ RunTime:0.004523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046176 ORDER BY `minOrder` ASC [ RunTime:0.007563s ]
select * from pdf where partno='TL431BIDMR2G' and brandshort='onsemi' limit 1 [ RunTime:0.008427s ]
select foldpath,foldpath2,filename from pdf_file where id=448227 limit 1 [ RunTime:0.003822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BIDMR2G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.011427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046172 LIMIT 4 [ RunTime:0.005218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046172 ORDER BY `minOrder` ASC [ RunTime:0.008698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046172 ORDER BY `unit` DESC [ RunTime:0.004361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046172 LIMIT 2 [ RunTime:0.008807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046172 ORDER BY `minOrder` ASC [ RunTime:0.002216s ]
select * from pdf where partno='TL431BCLPME3' and brandshort='Texas Instruments' limit 1 [ RunTime:0.002001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BCLPME3' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.006364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046169 LIMIT 4 [ RunTime:0.010398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046169 ORDER BY `minOrder` ASC [ RunTime:0.003544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046169 ORDER BY `unit` DESC [ RunTime:0.004486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046169 LIMIT 2 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046169 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
select * from pdf where partno='TL431BCLPM' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BCLPM' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.010325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046168 LIMIT 4 [ RunTime:0.010553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046168 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046168 ORDER BY `unit` DESC [ RunTime:0.002569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046168 LIMIT 2 [ RunTime:0.000254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046168 ORDER BY `minOrder` ASC [ RunTime:0.000182s ]
select * from pdf where partno='TL431BCPW' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BCPW' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.002633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046141 LIMIT 4 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046141 ORDER BY `minOrder` ASC [ RunTime:0.006266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046141 ORDER BY `unit` DESC [ RunTime:0.001902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046141 LIMIT 2 [ RunTime:0.004631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046141 ORDER BY `minOrder` ASC [ RunTime:0.002778s ]
select * from pdf where partno='TL431BIP' and brandshort='onsemi' limit 1 [ RunTime:0.007404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BIP' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.014033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046104 LIMIT 4 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046104 ORDER BY `minOrder` ASC [ RunTime:0.014448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046104 ORDER BY `unit` DESC [ RunTime:0.010563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046104 LIMIT 2 [ RunTime:0.008538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046104 ORDER BY `minOrder` ASC [ RunTime:0.005539s ]
select * from pdf where partno='TL431BVLPG' and brandshort='onsemi' limit 1 [ RunTime:0.009612s ]
select foldpath,foldpath2,filename from pdf_file where id=1060031 limit 1 [ RunTime:0.010030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BVLPG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.021139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046080 LIMIT 4 [ RunTime:0.006472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046080 ORDER BY `minOrder` ASC [ RunTime:0.007338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046080 ORDER BY `unit` DESC [ RunTime:0.003041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046080 LIMIT 2 [ RunTime:0.004670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046080 ORDER BY `minOrder` ASC [ RunTime:0.002184s ]
select * from pdf where partno='TL431IDMR2G' and brandshort='onsemi' limit 1 [ RunTime:0.008869s ]
select foldpath,foldpath2,filename from pdf_file where id=448227 limit 1 [ RunTime:0.006890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431IDMR2G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.006529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046079 LIMIT 4 [ RunTime:0.003437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046079 ORDER BY `minOrder` ASC [ RunTime:0.004967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046079 ORDER BY `unit` DESC [ RunTime:0.005293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046079 LIMIT 2 [ RunTime:0.013134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046079 ORDER BY `minOrder` ASC [ RunTime:0.003285s ]
select * from pdf where partno='TL431ACLPRPG' and brandshort='onsemi' limit 1 [ RunTime:0.013264s ]
select foldpath,foldpath2,filename from pdf_file where id=448227 limit 1 [ RunTime:0.009275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431ACLPRPG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.016610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046072 LIMIT 4 [ RunTime:0.002459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046072 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046072 ORDER BY `unit` DESC [ RunTime:0.001182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046072 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046072 ORDER BY `minOrder` ASC [ RunTime:0.000199s ]
select * from pdf where partno='TL431BIDMR2' and brandshort='onsemi' limit 1 [ RunTime:0.001940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BIDMR2' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.011278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25046061 LIMIT 4 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046061 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25046061 ORDER BY `unit` DESC [ RunTime:0.000365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25046061 LIMIT 2 [ RunTime:0.001738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25046061 ORDER BY `minOrder` ASC [ RunTime:0.002671s ]
select * from pdf where partno='TL431BVLPRAG' and brandshort='onsemi' limit 1 [ RunTime:0.004107s ]
select foldpath,foldpath2,filename from pdf_file where id=1060031 limit 1 [ RunTime:0.000848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BVLPRAG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.014067s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'TL431%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000691s ]