SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002359s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.001870s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002309s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002605s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002300s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000551s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002121s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002868s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002174s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.004298s ]
UPDATE `stock_search` SET `count` = 1487 , `updatetime` = '2026-06-06 18:34:27' WHERE `partno` = '210' [ RunTime:0.004899s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.004471s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004035s ]
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.002827s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002707s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.000447s ]
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 '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 3260,20 [ RunTime:0.012375s ]
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 ('32417552','32410343','32405731','32401301','32398888','32398881','32393769','32393764','32393759','32389420','32384737','32381641','32381511','32375945','32374201','32373797','32372598','32371071','32370857','32369933') ORDER BY FIELD(s.id, 32417552,32410343,32405731,32401301,32398888,32398881,32393769,32393764,32393759,32389420,32384737,32381641,32381511,32375945,32374201,32373797,32372598,32371071,32370857,32369933) [ RunTime:0.005464s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32417552 LIMIT 4 [ RunTime:0.008670s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32417552 ORDER BY `minOrder` ASC [ RunTime:0.002253s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32417552 ORDER BY `unit` DESC [ RunTime:0.001854s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32417552 LIMIT 2 [ RunTime:0.000967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32417552 ORDER BY `minOrder` ASC [ RunTime:0.000894s ]
select * from pdf where partno='2101711' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009169s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101711' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32410343 LIMIT 4 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32410343 ORDER BY `minOrder` ASC [ RunTime:0.009161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32410343 ORDER BY `unit` DESC [ RunTime:0.000648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32410343 LIMIT 2 [ RunTime:0.003512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32410343 ORDER BY `minOrder` ASC [ RunTime:0.002606s ]
select * from pdf where partno='210001339' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.008497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001339' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.005855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32405731 LIMIT 4 [ RunTime:0.006819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32405731 ORDER BY `minOrder` ASC [ RunTime:0.006103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32405731 ORDER BY `unit` DESC [ RunTime:0.005111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32405731 LIMIT 2 [ RunTime:0.003427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32405731 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='2100161' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100161' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32401301 LIMIT 4 [ RunTime:0.004534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401301 ORDER BY `minOrder` ASC [ RunTime:0.010073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32401301 ORDER BY `unit` DESC [ RunTime:0.001720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32401301 LIMIT 2 [ RunTime:0.009082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401301 ORDER BY `minOrder` ASC [ RunTime:0.003034s ]
select * from pdf where partno='2102004' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102004' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32398888 LIMIT 4 [ RunTime:0.007607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32398888 ORDER BY `minOrder` ASC [ RunTime:0.004634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32398888 ORDER BY `unit` DESC [ RunTime:0.006637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32398888 LIMIT 2 [ RunTime:0.003490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32398888 ORDER BY `minOrder` ASC [ RunTime:0.017386s ]
select * from pdf where partno='2108944' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108944' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32398881 LIMIT 4 [ RunTime:0.006677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32398881 ORDER BY `minOrder` ASC [ RunTime:0.002241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32398881 ORDER BY `unit` DESC [ RunTime:0.002362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32398881 LIMIT 2 [ RunTime:0.012593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32398881 ORDER BY `minOrder` ASC [ RunTime:0.005546s ]
select * from pdf where partno='2107264' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107264' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32393769 LIMIT 4 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393769 ORDER BY `minOrder` ASC [ RunTime:0.007548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32393769 ORDER BY `unit` DESC [ RunTime:0.000540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32393769 LIMIT 2 [ RunTime:0.009940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393769 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='2109318' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000312s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109318' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32393764 LIMIT 4 [ RunTime:0.002558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393764 ORDER BY `minOrder` ASC [ RunTime:0.004070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32393764 ORDER BY `unit` DESC [ RunTime:0.001393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32393764 LIMIT 2 [ RunTime:0.002129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393764 ORDER BY `minOrder` ASC [ RunTime:0.007787s ]
select * from pdf where partno='2103190' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103190' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32393759 LIMIT 4 [ RunTime:0.006500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393759 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32393759 ORDER BY `unit` DESC [ RunTime:0.005016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32393759 LIMIT 2 [ RunTime:0.003509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393759 ORDER BY `minOrder` ASC [ RunTime:0.006919s ]
select * from pdf where partno='2108571' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108571' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32389420 LIMIT 4 [ RunTime:0.006180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32389420 ORDER BY `minOrder` ASC [ RunTime:0.001409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32389420 ORDER BY `unit` DESC [ RunTime:0.002676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32389420 LIMIT 2 [ RunTime:0.019318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32389420 ORDER BY `minOrder` ASC [ RunTime:0.004370s ]
select * from pdf where partno='2101876' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101876' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32384737 LIMIT 4 [ RunTime:0.006091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32384737 ORDER BY `minOrder` ASC [ RunTime:0.003291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32384737 ORDER BY `unit` DESC [ RunTime:0.013677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32384737 LIMIT 2 [ RunTime:0.002336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32384737 ORDER BY `minOrder` ASC [ RunTime:0.001934s ]
select * from pdf where partno='2101143-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.005383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101143-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.007016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32381641 LIMIT 4 [ RunTime:0.001252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32381641 ORDER BY `minOrder` ASC [ RunTime:0.009234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32381641 ORDER BY `unit` DESC [ RunTime:0.005308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32381641 LIMIT 2 [ RunTime:0.001905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32381641 ORDER BY `minOrder` ASC [ RunTime:0.001863s ]
select * from pdf where partno='21028' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.001779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21028' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.000935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32381511 LIMIT 4 [ RunTime:0.000511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32381511 ORDER BY `minOrder` ASC [ RunTime:0.002461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32381511 ORDER BY `unit` DESC [ RunTime:0.001318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32381511 LIMIT 2 [ RunTime:0.002001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32381511 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
select * from pdf where partno='2101830' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101830' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32375945 LIMIT 4 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32375945 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32375945 ORDER BY `unit` DESC [ RunTime:0.002348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32375945 LIMIT 2 [ RunTime:0.014882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32375945 ORDER BY `minOrder` ASC [ RunTime:0.005549s ]
select * from pdf where partno='21021' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.004604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.003399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32374201 LIMIT 4 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32374201 ORDER BY `minOrder` ASC [ RunTime:0.006471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32374201 ORDER BY `unit` DESC [ RunTime:0.007703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32374201 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32374201 ORDER BY `minOrder` ASC [ RunTime:0.002561s ]
select * from pdf where partno='21023' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.002145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21023' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.004294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32373797 LIMIT 4 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32373797 ORDER BY `minOrder` ASC [ RunTime:0.003230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32373797 ORDER BY `unit` DESC [ RunTime:0.007698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32373797 LIMIT 2 [ RunTime:0.008134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32373797 ORDER BY `minOrder` ASC [ RunTime:0.005392s ]
select * from pdf where partno='21072' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.005609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21072' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.010769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32372598 LIMIT 4 [ RunTime:0.003482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32372598 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32372598 ORDER BY `unit` DESC [ RunTime:0.011527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32372598 LIMIT 2 [ RunTime:0.002913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32372598 ORDER BY `minOrder` ASC [ RunTime:0.001632s ]
select * from pdf where partno='21039' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.000625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21039' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.000795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32371071 LIMIT 4 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32371071 ORDER BY `minOrder` ASC [ RunTime:0.002781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32371071 ORDER BY `unit` DESC [ RunTime:0.000529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32371071 LIMIT 2 [ RunTime:0.003774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32371071 ORDER BY `minOrder` ASC [ RunTime:0.001895s ]
select * from pdf where partno='21037' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.006777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21037' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32370857 LIMIT 4 [ RunTime:0.001772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32370857 ORDER BY `minOrder` ASC [ RunTime:0.002545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32370857 ORDER BY `unit` DESC [ RunTime:0.002445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32370857 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32370857 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='2104098' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104098' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32369933 LIMIT 4 [ RunTime:0.001130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32369933 ORDER BY `minOrder` ASC [ RunTime:0.005719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32369933 ORDER BY `unit` DESC [ RunTime:0.000866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32369933 LIMIT 2 [ RunTime:0.002079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32369933 ORDER BY `minOrder` ASC [ RunTime:0.001168s ]
select * from pdf where partno='21029' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.000432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21029' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.003100s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.004500s ]