SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001504s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.007176s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001282s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000534s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001938s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000362s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001537s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005061s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001426s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.007103s ]
UPDATE `stock_search` SET `count` = 4099 , `updatetime` = '2026-06-08 16:34:24' WHERE `partno` = '210' [ RunTime:0.003230s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000284s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000228s ]
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.003125s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002679s ]
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.095577s ]
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 2840,20 [ RunTime:0.066014s ]
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 ('37558318','37558270','37558269','37558251','37558242','37558215','37558214','37558213','37558212','37558211','37558210','37558191','37558190','37558189','37558185','37558184','37558183','37558182','37558181','37558180') ORDER BY FIELD(s.id, 37558318,37558270,37558269,37558251,37558242,37558215,37558214,37558213,37558212,37558211,37558210,37558191,37558190,37558189,37558185,37558184,37558183,37558182,37558181,37558180) [ RunTime:0.018911s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558318 LIMIT 4 [ RunTime:0.003721s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558318 ORDER BY `minOrder` ASC [ RunTime:0.011324s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.020604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558318 ORDER BY `unit` DESC [ RunTime:0.012731s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558318 LIMIT 2 [ RunTime:0.009964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558318 ORDER BY `minOrder` ASC [ RunTime:0.009519s ]
select * from pdf where partno='210000319' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.061375s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000319' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.035653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558270 LIMIT 4 [ RunTime:0.010506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558270 ORDER BY `minOrder` ASC [ RunTime:0.041548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558270 ORDER BY `unit` DESC [ RunTime:0.005412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558270 LIMIT 2 [ RunTime:0.046290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558270 ORDER BY `minOrder` ASC [ RunTime:0.015154s ]
select * from pdf where partno='210001662' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.035170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001662' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.012896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558269 LIMIT 4 [ RunTime:0.029962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558269 ORDER BY `minOrder` ASC [ RunTime:0.053788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558269 ORDER BY `unit` DESC [ RunTime:0.021354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558269 LIMIT 2 [ RunTime:0.007618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558269 ORDER BY `minOrder` ASC [ RunTime:0.008594s ]
select * from pdf where partno='210001661' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.023297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001661' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.027831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558251 LIMIT 4 [ RunTime:0.031121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558251 ORDER BY `minOrder` ASC [ RunTime:0.017126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558251 ORDER BY `unit` DESC [ RunTime:0.048187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558251 LIMIT 2 [ RunTime:0.028635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558251 ORDER BY `minOrder` ASC [ RunTime:0.032592s ]
select * from pdf where partno='210001193' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.014118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001193' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.016721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558242 LIMIT 4 [ RunTime:0.013798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558242 ORDER BY `minOrder` ASC [ RunTime:0.034672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558242 ORDER BY `unit` DESC [ RunTime:0.015686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558242 LIMIT 2 [ RunTime:0.047540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558242 ORDER BY `minOrder` ASC [ RunTime:0.046957s ]
select * from pdf where partno='210001845' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.072729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001845' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.020524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558215 LIMIT 4 [ RunTime:0.021871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558215 ORDER BY `minOrder` ASC [ RunTime:0.046505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558215 ORDER BY `unit` DESC [ RunTime:0.032009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558215 LIMIT 2 [ RunTime:0.056913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558215 ORDER BY `minOrder` ASC [ RunTime:0.010712s ]
select * from pdf where partno='210002237' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.041316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002237' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.007220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558214 LIMIT 4 [ RunTime:0.012632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558214 ORDER BY `minOrder` ASC [ RunTime:0.067491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558214 ORDER BY `unit` DESC [ RunTime:0.051163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558214 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558214 ORDER BY `minOrder` ASC [ RunTime:0.032065s ]
select * from pdf where partno='210001026' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.034923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001026' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.037718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558213 LIMIT 4 [ RunTime:0.042769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558213 ORDER BY `minOrder` ASC [ RunTime:0.051313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558213 ORDER BY `unit` DESC [ RunTime:0.034934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558213 LIMIT 2 [ RunTime:0.026489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558213 ORDER BY `minOrder` ASC [ RunTime:0.021255s ]
select * from pdf where partno='210001702' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.030800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001702' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.033892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558212 LIMIT 4 [ RunTime:0.035715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558212 ORDER BY `minOrder` ASC [ RunTime:0.064976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558212 ORDER BY `unit` DESC [ RunTime:0.051249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558212 LIMIT 2 [ RunTime:0.018429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558212 ORDER BY `minOrder` ASC [ RunTime:0.051352s ]
select * from pdf where partno='210002238' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.030714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002238' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.099441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558211 LIMIT 4 [ RunTime:0.033796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558211 ORDER BY `minOrder` ASC [ RunTime:0.033787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558211 ORDER BY `unit` DESC [ RunTime:0.034043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558211 LIMIT 2 [ RunTime:0.016093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558211 ORDER BY `minOrder` ASC [ RunTime:0.021794s ]
select * from pdf where partno='210001025' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.051225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001025' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.021561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558210 LIMIT 4 [ RunTime:0.028679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558210 ORDER BY `minOrder` ASC [ RunTime:0.091846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558210 ORDER BY `unit` DESC [ RunTime:0.025153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558210 LIMIT 2 [ RunTime:0.011473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558210 ORDER BY `minOrder` ASC [ RunTime:0.032102s ]
select * from pdf where partno='210001027' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.030257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001027' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.045114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558191 LIMIT 4 [ RunTime:0.014108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558191 ORDER BY `minOrder` ASC [ RunTime:0.062318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558191 ORDER BY `unit` DESC [ RunTime:0.076395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558191 LIMIT 2 [ RunTime:0.012612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558191 ORDER BY `minOrder` ASC [ RunTime:0.025977s ]
select * from pdf where partno='210001601' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.002579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001601' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.000585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558190 LIMIT 4 [ RunTime:0.026250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558190 ORDER BY `minOrder` ASC [ RunTime:0.074570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558190 ORDER BY `unit` DESC [ RunTime:0.037196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558190 LIMIT 2 [ RunTime:0.001737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558190 ORDER BY `minOrder` ASC [ RunTime:0.000939s ]
select * from pdf where partno='210001602' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.027151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001602' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.039939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558189 LIMIT 4 [ RunTime:0.036420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558189 ORDER BY `minOrder` ASC [ RunTime:0.044072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558189 ORDER BY `unit` DESC [ RunTime:0.037185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558189 LIMIT 2 [ RunTime:0.008438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558189 ORDER BY `minOrder` ASC [ RunTime:0.015016s ]
select * from pdf where partno='210001535' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001535' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.030799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558185 LIMIT 4 [ RunTime:0.017423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558185 ORDER BY `minOrder` ASC [ RunTime:0.110136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558185 ORDER BY `unit` DESC [ RunTime:0.065698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558185 LIMIT 2 [ RunTime:0.013583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558185 ORDER BY `minOrder` ASC [ RunTime:0.014675s ]
select * from pdf where partno='210002830' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.019324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002830' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.055260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558184 LIMIT 4 [ RunTime:0.015721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558184 ORDER BY `minOrder` ASC [ RunTime:0.068509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558184 ORDER BY `unit` DESC [ RunTime:0.018662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558184 LIMIT 2 [ RunTime:0.021850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558184 ORDER BY `minOrder` ASC [ RunTime:0.056311s ]
select * from pdf where partno='210002831' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.023497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002831' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.020458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558183 LIMIT 4 [ RunTime:0.027303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558183 ORDER BY `minOrder` ASC [ RunTime:0.071013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558183 ORDER BY `unit` DESC [ RunTime:0.023310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558183 LIMIT 2 [ RunTime:0.031588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558183 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
select * from pdf where partno='210002829' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.017883s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002829' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.009020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558182 LIMIT 4 [ RunTime:0.033644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558182 ORDER BY `minOrder` ASC [ RunTime:0.049429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558182 ORDER BY `unit` DESC [ RunTime:0.011969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558182 LIMIT 2 [ RunTime:0.017481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558182 ORDER BY `minOrder` ASC [ RunTime:0.047392s ]
select * from pdf where partno='210002828' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.025324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002828' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.013455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558181 LIMIT 4 [ RunTime:0.026008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558181 ORDER BY `minOrder` ASC [ RunTime:0.025634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558181 ORDER BY `unit` DESC [ RunTime:0.007597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558181 LIMIT 2 [ RunTime:0.011002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558181 ORDER BY `minOrder` ASC [ RunTime:0.022233s ]
select * from pdf where partno='210002827' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.023192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002827' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.006014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558180 LIMIT 4 [ RunTime:0.024708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558180 ORDER BY `minOrder` ASC [ RunTime:0.036556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558180 ORDER BY `unit` DESC [ RunTime:0.017995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558180 LIMIT 2 [ RunTime:0.013428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558180 ORDER BY `minOrder` ASC [ RunTime:0.002849s ]
select * from pdf where partno='210002826' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.005041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002826' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.003192s ]
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.009277s ]