SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002396s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000547s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002280s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.93' ) [ RunTime:0.000347s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002075s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000296s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002600s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TL431' LIMIT 1 [ RunTime:0.000440s ]
UPDATE `stock_search` SET `count` = 2399 , `updatetime` = '2026-06-02 04:05:38' WHERE `partno` = 'TL431' [ RunTime:0.009776s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001250s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000538s ]
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.000748s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002638s ]
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.000574s ]
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 560,20 [ RunTime:0.016203s ]
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 ('25047740','25047738','25047733','25047730','25047729','25047725','25047724','25047723','25047722','25047721','25047720','25047719','25047718','25047716','25047715','25047713','25047712','25047711','25047710','25047655') ORDER BY FIELD(s.id, 25047740,25047738,25047733,25047730,25047729,25047725,25047724,25047723,25047722,25047721,25047720,25047719,25047718,25047716,25047715,25047713,25047712,25047711,25047710,25047655) [ RunTime:0.012590s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047740 LIMIT 4 [ RunTime:0.000758s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047740 ORDER BY `minOrder` ASC [ RunTime:0.003390s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047740 ORDER BY `unit` DESC [ RunTime:0.004589s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047740 LIMIT 2 [ RunTime:0.002350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047740 ORDER BY `minOrder` ASC [ RunTime:0.005919s ]
select * from pdf where partno='TL431AQDBVRE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.005828s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431AQDBVRE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.003678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047738 LIMIT 4 [ RunTime:0.002658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047738 ORDER BY `minOrder` ASC [ RunTime:0.004871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047738 ORDER BY `unit` DESC [ RunTime:0.012087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047738 LIMIT 2 [ RunTime:0.013806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047738 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='TL431CD' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.007937s ]
select foldpath,foldpath2,filename from pdf_file where id=448229 limit 1 [ RunTime:0.002416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CD' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.000819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047733 LIMIT 4 [ RunTime:0.002158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047733 ORDER BY `minOrder` ASC [ RunTime:0.026454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047733 ORDER BY `unit` DESC [ RunTime:0.005301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047733 LIMIT 2 [ RunTime:0.004222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047733 ORDER BY `minOrder` ASC [ RunTime:0.003709s ]
select * from pdf where partno='TL431ACLPX' and brandshort='onsemi' limit 1 [ RunTime:0.005787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431ACLPX' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.022078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047730 LIMIT 4 [ RunTime:0.008874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047730 ORDER BY `minOrder` ASC [ RunTime:0.006485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047730 ORDER BY `unit` DESC [ RunTime:0.007125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047730 LIMIT 2 [ RunTime:0.002473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047730 ORDER BY `minOrder` ASC [ RunTime:0.000264s ]
select * from pdf where partno='TL431CDBVRG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.005630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CDBVRG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047729 LIMIT 4 [ RunTime:0.000450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047729 ORDER BY `minOrder` ASC [ RunTime:0.001297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047729 ORDER BY `unit` DESC [ RunTime:0.007657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047729 LIMIT 2 [ RunTime:0.001526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047729 ORDER BY `minOrder` ASC [ RunTime:0.006268s ]
select * from pdf where partno='TL431CDBVRE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.006514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CDBVRE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.007711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047725 LIMIT 4 [ RunTime:0.008811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047725 ORDER BY `minOrder` ASC [ RunTime:0.005144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047725 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047725 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047725 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
select * from pdf where partno='TL431CLPX' and brandshort='onsemi' limit 1 [ RunTime:0.003877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CLPX' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.017027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047724 LIMIT 4 [ RunTime:0.019767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047724 ORDER BY `minOrder` ASC [ RunTime:0.027622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047724 ORDER BY `unit` DESC [ RunTime:0.020192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047724 LIMIT 2 [ RunTime:0.030999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047724 ORDER BY `minOrder` ASC [ RunTime:0.004926s ]
select * from pdf where partno='TL431KC-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.010293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431KC-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.018763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047723 LIMIT 4 [ RunTime:0.001810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047723 ORDER BY `minOrder` ASC [ RunTime:0.000861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047723 ORDER BY `unit` DESC [ RunTime:0.004907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047723 LIMIT 2 [ RunTime:0.026463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047723 ORDER BY `minOrder` ASC [ RunTime:0.004559s ]
select * from pdf where partno='TL431CDRE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.009821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CDRE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.005846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047722 LIMIT 4 [ RunTime:0.005825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047722 ORDER BY `minOrder` ASC [ RunTime:0.018863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047722 ORDER BY `unit` DESC [ RunTime:0.008118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047722 LIMIT 2 [ RunTime:0.012010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047722 ORDER BY `minOrder` ASC [ RunTime:0.010578s ]
select * from pdf where partno='TL431AIDBZR,215' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.013179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431AIDBZR,215' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.007289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047721 LIMIT 4 [ RunTime:0.012858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047721 ORDER BY `minOrder` ASC [ RunTime:0.005585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047721 ORDER BY `unit` DESC [ RunTime:0.005831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047721 LIMIT 2 [ RunTime:0.012518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047721 ORDER BY `minOrder` ASC [ RunTime:0.013588s ]
select * from pdf where partno='TL431AQDBZR,215' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.008525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431AQDBZR,215' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.012874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047720 LIMIT 4 [ RunTime:0.013038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047720 ORDER BY `minOrder` ASC [ RunTime:0.015577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047720 ORDER BY `unit` DESC [ RunTime:0.021910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047720 LIMIT 2 [ RunTime:0.013708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047720 ORDER BY `minOrder` ASC [ RunTime:0.013019s ]
select * from pdf where partno='TL431HA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.005900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431HA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.006631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047719 LIMIT 4 [ RunTime:0.015137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047719 ORDER BY `minOrder` ASC [ RunTime:0.034906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047719 ORDER BY `unit` DESC [ RunTime:0.017183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047719 LIMIT 2 [ RunTime:0.009455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047719 ORDER BY `minOrder` ASC [ RunTime:0.005282s ]
select * from pdf where partno='TL431KA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.011363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431KA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.003575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047718 LIMIT 4 [ RunTime:0.008672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047718 ORDER BY `minOrder` ASC [ RunTime:0.009694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047718 ORDER BY `unit` DESC [ RunTime:0.011906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047718 LIMIT 2 [ RunTime:0.005653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047718 ORDER BY `minOrder` ASC [ RunTime:0.013329s ]
select * from pdf where partno='TL431LB-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.002734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431LB-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.007201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047716 LIMIT 4 [ RunTime:0.017560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047716 ORDER BY `minOrder` ASC [ RunTime:0.001079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047716 ORDER BY `unit` DESC [ RunTime:0.008520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047716 LIMIT 2 [ RunTime:0.002698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047716 ORDER BY `minOrder` ASC [ RunTime:0.002912s ]
select * from pdf where partno='TL431ACZ' and brandshort='onsemi' limit 1 [ RunTime:0.009418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431ACZ' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.018799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047715 LIMIT 4 [ RunTime:0.003930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047715 ORDER BY `minOrder` ASC [ RunTime:0.006603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047715 ORDER BY `unit` DESC [ RunTime:0.008277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047715 LIMIT 2 [ RunTime:0.006020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047715 ORDER BY `minOrder` ASC [ RunTime:0.001567s ]
select * from pdf where partno='TL431ACLP' and brandshort='onsemi' limit 1 [ RunTime:0.005414s ]
select foldpath,foldpath2,filename from pdf_file where id=448227 limit 1 [ RunTime:0.006782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431ACLP' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.024344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047713 LIMIT 4 [ RunTime:0.004269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047713 ORDER BY `minOrder` ASC [ RunTime:0.004688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047713 ORDER BY `unit` DESC [ RunTime:0.007106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047713 LIMIT 2 [ RunTime:0.005533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047713 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='TL431CDBZR,215' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.001404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CDBZR,215' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.005287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047712 LIMIT 4 [ RunTime:0.003299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047712 ORDER BY `minOrder` ASC [ RunTime:0.005703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047712 ORDER BY `unit` DESC [ RunTime:0.010310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047712 LIMIT 2 [ RunTime:0.018436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047712 ORDER BY `minOrder` ASC [ RunTime:0.005682s ]
select * from pdf where partno='TL431IDBZR,215' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.014578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431IDBZR,215' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.012713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047711 LIMIT 4 [ RunTime:0.002678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047711 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047711 ORDER BY `unit` DESC [ RunTime:0.009661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047711 LIMIT 2 [ RunTime:0.007681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047711 ORDER BY `minOrder` ASC [ RunTime:0.005682s ]
select * from pdf where partno='TL431QDBZR,215' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.008198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431QDBZR,215' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.001210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047710 LIMIT 4 [ RunTime:0.004934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047710 ORDER BY `minOrder` ASC [ RunTime:0.007136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047710 ORDER BY `unit` DESC [ RunTime:0.008341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047710 LIMIT 2 [ RunTime:0.003826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047710 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='TL431FDT,215' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.000608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431FDT,215' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.007538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047655 LIMIT 4 [ RunTime:0.008895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047655 ORDER BY `minOrder` ASC [ RunTime:0.017102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047655 ORDER BY `unit` DESC [ RunTime:0.017853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047655 LIMIT 2 [ RunTime:0.008351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047655 ORDER BY `minOrder` ASC [ RunTime:0.003185s ]
select * from pdf where partno='TL431AW5-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.003704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431AW5-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.004337s ]
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.012770s ]