SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001509s ]
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.010534s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001328s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.014399s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002760s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.017243s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001753s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000345s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001769s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.015985s ]
UPDATE `stock_search` SET `count` = 1526 , `updatetime` = '2026-06-06 18:34:45' WHERE `partno` = '210' [ RunTime:0.007957s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001505s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000276s ]
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.003886s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002900s ]
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.011452s ]
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 3240,20 [ RunTime:0.009696s ]
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 ('32507010','32506399','32498910','32497713','32496605','32491182','32491180','32485920','32484510','32476568','32475152','32468111','32468102','32466389','32465589','32461778','32455664','32455663','32440058','32417819') ORDER BY FIELD(s.id, 32507010,32506399,32498910,32497713,32496605,32491182,32491180,32485920,32484510,32476568,32475152,32468111,32468102,32466389,32465589,32461778,32455664,32455663,32440058,32417819) [ RunTime:0.002115s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32507010 LIMIT 4 [ RunTime:0.000530s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32507010 ORDER BY `minOrder` ASC [ RunTime:0.003102s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32507010 ORDER BY `unit` DESC [ RunTime:0.001786s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32507010 LIMIT 2 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32507010 ORDER BY `minOrder` ASC [ RunTime:0.003030s ]
select * from pdf where partno='2106026' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002408s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106026' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32506399 LIMIT 4 [ RunTime:0.003015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32506399 ORDER BY `minOrder` ASC [ RunTime:0.001710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32506399 ORDER BY `unit` DESC [ RunTime:0.006989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32506399 LIMIT 2 [ RunTime:0.001228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32506399 ORDER BY `minOrder` ASC [ RunTime:0.007761s ]
select * from pdf where partno='2105618' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105618' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32498910 LIMIT 4 [ RunTime:0.006363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32498910 ORDER BY `minOrder` ASC [ RunTime:0.015838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32498910 ORDER BY `unit` DESC [ RunTime:0.004949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32498910 LIMIT 2 [ RunTime:0.007606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32498910 ORDER BY `minOrder` ASC [ RunTime:0.003294s ]
select * from pdf where partno='2102660-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102660-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.002817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32497713 LIMIT 4 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32497713 ORDER BY `minOrder` ASC [ RunTime:0.004523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32497713 ORDER BY `unit` DESC [ RunTime:0.004646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32497713 LIMIT 2 [ RunTime:0.003427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32497713 ORDER BY `minOrder` ASC [ RunTime:0.006466s ]
select * from pdf where partno='2106025' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106025' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32496605 LIMIT 4 [ RunTime:0.011689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32496605 ORDER BY `minOrder` ASC [ RunTime:0.004872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32496605 ORDER BY `unit` DESC [ RunTime:0.005779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32496605 LIMIT 2 [ RunTime:0.010853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32496605 ORDER BY `minOrder` ASC [ RunTime:0.014588s ]
select * from pdf where partno='2103274' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103274' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32491182 LIMIT 4 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32491182 ORDER BY `minOrder` ASC [ RunTime:0.001816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32491182 ORDER BY `unit` DESC [ RunTime:0.003418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32491182 LIMIT 2 [ RunTime:0.007778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32491182 ORDER BY `minOrder` ASC [ RunTime:0.014120s ]
select * from pdf where partno='2109583' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109583' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32491180 LIMIT 4 [ RunTime:0.004338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32491180 ORDER BY `minOrder` ASC [ RunTime:0.012298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32491180 ORDER BY `unit` DESC [ RunTime:0.004506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32491180 LIMIT 2 [ RunTime:0.002116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32491180 ORDER BY `minOrder` ASC [ RunTime:0.012242s ]
select * from pdf where partno='2104198' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104198' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32485920 LIMIT 4 [ RunTime:0.001709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32485920 ORDER BY `minOrder` ASC [ RunTime:0.007462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32485920 ORDER BY `unit` DESC [ RunTime:0.001032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32485920 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32485920 ORDER BY `minOrder` ASC [ RunTime:0.005756s ]
select * from pdf where partno='2102' and brandshort='JKL Components Corp.' limit 1 [ RunTime:0.002901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102' OR `brand` LIKE 'JKL Components Corp.%' ) ) LIMIT 1 [ RunTime:0.011041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32484510 LIMIT 4 [ RunTime:0.004805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32484510 ORDER BY `minOrder` ASC [ RunTime:0.021738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32484510 ORDER BY `unit` DESC [ RunTime:0.003331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32484510 LIMIT 2 [ RunTime:0.003953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32484510 ORDER BY `minOrder` ASC [ RunTime:0.001348s ]
select * from pdf where partno='2107052-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107052-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32476568 LIMIT 4 [ RunTime:0.002363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32476568 ORDER BY `minOrder` ASC [ RunTime:0.011613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32476568 ORDER BY `unit` DESC [ RunTime:0.003482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32476568 LIMIT 2 [ RunTime:0.002821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32476568 ORDER BY `minOrder` ASC [ RunTime:0.008193s ]
select * from pdf where partno='2106024' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106024' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32475152 LIMIT 4 [ RunTime:0.002982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32475152 ORDER BY `minOrder` ASC [ RunTime:0.006498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32475152 ORDER BY `unit` DESC [ RunTime:0.009914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32475152 LIMIT 2 [ RunTime:0.009457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32475152 ORDER BY `minOrder` ASC [ RunTime:0.001342s ]
select * from pdf where partno='2100699' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100699' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32468111 LIMIT 4 [ RunTime:0.004246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32468111 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32468111 ORDER BY `unit` DESC [ RunTime:0.009516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32468111 LIMIT 2 [ RunTime:0.028293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32468111 ORDER BY `minOrder` ASC [ RunTime:0.027231s ]
select * from pdf where partno='2106946-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106946-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32468102 LIMIT 4 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32468102 ORDER BY `minOrder` ASC [ RunTime:0.007996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32468102 ORDER BY `unit` DESC [ RunTime:0.003723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32468102 LIMIT 2 [ RunTime:0.003463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32468102 ORDER BY `minOrder` ASC [ RunTime:0.010476s ]
select * from pdf where partno='2106150-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106150-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32466389 LIMIT 4 [ RunTime:0.003068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32466389 ORDER BY `minOrder` ASC [ RunTime:0.010573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32466389 ORDER BY `unit` DESC [ RunTime:0.015344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32466389 LIMIT 2 [ RunTime:0.006451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32466389 ORDER BY `minOrder` ASC [ RunTime:0.005783s ]
select * from pdf where partno='2106023' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106023' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32465589 LIMIT 4 [ RunTime:0.013962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32465589 ORDER BY `minOrder` ASC [ RunTime:0.004803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32465589 ORDER BY `unit` DESC [ RunTime:0.006473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32465589 LIMIT 2 [ RunTime:0.019262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32465589 ORDER BY `minOrder` ASC [ RunTime:0.010751s ]
select * from pdf where partno='2101305-7' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.003435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101305-7' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.013498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32461778 LIMIT 4 [ RunTime:0.003882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32461778 ORDER BY `minOrder` ASC [ RunTime:0.009184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32461778 ORDER BY `unit` DESC [ RunTime:0.017940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32461778 LIMIT 2 [ RunTime:0.007740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32461778 ORDER BY `minOrder` ASC [ RunTime:0.024467s ]
select * from pdf where partno='2104395' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104395' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32455664 LIMIT 4 [ RunTime:0.003933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32455664 ORDER BY `minOrder` ASC [ RunTime:0.010161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32455664 ORDER BY `unit` DESC [ RunTime:0.016179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32455664 LIMIT 2 [ RunTime:0.017813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32455664 ORDER BY `minOrder` ASC [ RunTime:0.008768s ]
select * from pdf where partno='2109954' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109954' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32455663 LIMIT 4 [ RunTime:0.005170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32455663 ORDER BY `minOrder` ASC [ RunTime:0.005868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32455663 ORDER BY `unit` DESC [ RunTime:0.051253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32455663 LIMIT 2 [ RunTime:0.020599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32455663 ORDER BY `minOrder` ASC [ RunTime:0.011108s ]
select * from pdf where partno='2102654' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.028092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102654' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32440058 LIMIT 4 [ RunTime:0.011528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32440058 ORDER BY `minOrder` ASC [ RunTime:0.017717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32440058 ORDER BY `unit` DESC [ RunTime:0.006546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32440058 LIMIT 2 [ RunTime:0.046458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32440058 ORDER BY `minOrder` ASC [ RunTime:0.014697s ]
select * from pdf where partno='2103102' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103102' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32417819 LIMIT 4 [ RunTime:0.013669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32417819 ORDER BY `minOrder` ASC [ RunTime:0.002634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32417819 ORDER BY `unit` DESC [ RunTime:0.011965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32417819 LIMIT 2 [ RunTime:0.011660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32417819 ORDER BY `minOrder` ASC [ RunTime:0.018847s ]
select * from pdf where partno='21063' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.044425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21063' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.010335s ]
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.031283s ]