SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001234s ]
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.012707s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001073s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003972s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001592s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.012478s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001145s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009214s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001623s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.017978s ]
UPDATE `stock_search` SET `count` = 3721 , `updatetime` = '2026-06-08 15:00:28' WHERE `partno` = '210' [ RunTime:0.010607s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.009472s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001906s ]
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.007444s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001747s ]
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.008962s ]
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 2800,20 [ RunTime:0.086738s ]
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 ('37558876','37558851','37558844','37558833','37558832','37558777','37558776','37558702','37558656','37558655','37558654','37558624','37558623','37558622','37558621','37558583','37558582','37558581','37558580','37558579') ORDER BY FIELD(s.id, 37558876,37558851,37558844,37558833,37558832,37558777,37558776,37558702,37558656,37558655,37558654,37558624,37558623,37558622,37558621,37558583,37558582,37558581,37558580,37558579) [ RunTime:0.013375s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558876 LIMIT 4 [ RunTime:0.011239s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558876 ORDER BY `minOrder` ASC [ RunTime:0.023056s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558876 ORDER BY `unit` DESC [ RunTime:0.023324s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558876 LIMIT 2 [ RunTime:0.009506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558876 ORDER BY `minOrder` ASC [ RunTime:0.003290s ]
select * from pdf where partno='210002816' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.020329s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002816' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.021075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558851 LIMIT 4 [ RunTime:0.007781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558851 ORDER BY `minOrder` ASC [ RunTime:0.106654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558851 ORDER BY `unit` DESC [ RunTime:0.047996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558851 LIMIT 2 [ RunTime:0.042037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558851 ORDER BY `minOrder` ASC [ RunTime:0.028920s ]
select * from pdf where partno='210002947' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.071883s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002947' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.023111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558844 LIMIT 4 [ RunTime:0.022418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558844 ORDER BY `minOrder` ASC [ RunTime:0.083932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558844 ORDER BY `unit` DESC [ RunTime:0.052391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558844 LIMIT 2 [ RunTime:0.043322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558844 ORDER BY `minOrder` ASC [ RunTime:0.009663s ]
select * from pdf where partno='210002898' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.022851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002898' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.068512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558833 LIMIT 4 [ RunTime:0.014011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558833 ORDER BY `minOrder` ASC [ RunTime:0.031333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558833 ORDER BY `unit` DESC [ RunTime:0.110694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558833 LIMIT 2 [ RunTime:0.048410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558833 ORDER BY `minOrder` ASC [ RunTime:0.001953s ]
select * from pdf where partno='210002841' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.045054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002841' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.053448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558832 LIMIT 4 [ RunTime:0.038676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558832 ORDER BY `minOrder` ASC [ RunTime:0.109286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558832 ORDER BY `unit` DESC [ RunTime:0.092588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558832 LIMIT 2 [ RunTime:0.060656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558832 ORDER BY `minOrder` ASC [ RunTime:0.014544s ]
select * from pdf where partno='210002906' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.057527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002906' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.071817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558777 LIMIT 4 [ RunTime:0.034249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558777 ORDER BY `minOrder` ASC [ RunTime:0.032768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558777 ORDER BY `unit` DESC [ RunTime:0.053177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558777 LIMIT 2 [ RunTime:0.027095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558777 ORDER BY `minOrder` ASC [ RunTime:0.051702s ]
select * from pdf where partno='210002812' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.052402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002812' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.037852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558776 LIMIT 4 [ RunTime:0.027564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558776 ORDER BY `minOrder` ASC [ RunTime:0.039459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558776 ORDER BY `unit` DESC [ RunTime:0.046353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558776 LIMIT 2 [ RunTime:0.055074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558776 ORDER BY `minOrder` ASC [ RunTime:0.033075s ]
select * from pdf where partno='210002817' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.024710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002817' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.082175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558702 LIMIT 4 [ RunTime:0.077897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558702 ORDER BY `minOrder` ASC [ RunTime:0.050200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558702 ORDER BY `unit` DESC [ RunTime:0.058055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558702 LIMIT 2 [ RunTime:0.076677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558702 ORDER BY `minOrder` ASC [ RunTime:0.044455s ]
select * from pdf where partno='210002823' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.056674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002823' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.059224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558656 LIMIT 4 [ RunTime:0.116413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558656 ORDER BY `minOrder` ASC [ RunTime:0.091975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558656 ORDER BY `unit` DESC [ RunTime:0.062832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558656 LIMIT 2 [ RunTime:0.031293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558656 ORDER BY `minOrder` ASC [ RunTime:0.073587s ]
select * from pdf where partno='210002811' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.039317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002811' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.043364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558655 LIMIT 4 [ RunTime:0.116778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558655 ORDER BY `minOrder` ASC [ RunTime:0.137852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558655 ORDER BY `unit` DESC [ RunTime:0.111647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558655 LIMIT 2 [ RunTime:0.051059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558655 ORDER BY `minOrder` ASC [ RunTime:0.026208s ]
select * from pdf where partno='210002807' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.051197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002807' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.069683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558654 LIMIT 4 [ RunTime:0.235530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558654 ORDER BY `minOrder` ASC [ RunTime:0.047055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558654 ORDER BY `unit` DESC [ RunTime:0.100504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558654 LIMIT 2 [ RunTime:0.168345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558654 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
select * from pdf where partno='210002810' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.061037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002810' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.035910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558624 LIMIT 4 [ RunTime:0.083398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558624 ORDER BY `minOrder` ASC [ RunTime:0.259174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558624 ORDER BY `unit` DESC [ RunTime:0.037464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558624 LIMIT 2 [ RunTime:0.038604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558624 ORDER BY `minOrder` ASC [ RunTime:0.025531s ]
select * from pdf where partno='210003022' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.043333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003022' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.022208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558623 LIMIT 4 [ RunTime:0.026354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558623 ORDER BY `minOrder` ASC [ RunTime:0.021290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558623 ORDER BY `unit` DESC [ RunTime:0.024339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558623 LIMIT 2 [ RunTime:0.015318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558623 ORDER BY `minOrder` ASC [ RunTime:0.010738s ]
select * from pdf where partno='210002806' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.017609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002806' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.016338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558622 LIMIT 4 [ RunTime:0.008687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558622 ORDER BY `minOrder` ASC [ RunTime:0.023697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558622 ORDER BY `unit` DESC [ RunTime:0.037198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558622 LIMIT 2 [ RunTime:0.026100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558622 ORDER BY `minOrder` ASC [ RunTime:0.027583s ]
select * from pdf where partno='210002808' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.014709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002808' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.011888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558621 LIMIT 4 [ RunTime:0.037669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558621 ORDER BY `minOrder` ASC [ RunTime:0.021129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558621 ORDER BY `unit` DESC [ RunTime:0.025685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558621 LIMIT 2 [ RunTime:0.047192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558621 ORDER BY `minOrder` ASC [ RunTime:0.001893s ]
select * from pdf where partno='210002809' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.009942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002809' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.021236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558583 LIMIT 4 [ RunTime:0.010043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558583 ORDER BY `minOrder` ASC [ RunTime:0.004999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558583 ORDER BY `unit` DESC [ RunTime:0.013861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558583 LIMIT 2 [ RunTime:0.038213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558583 ORDER BY `minOrder` ASC [ RunTime:0.008881s ]
select * from pdf where partno='210002802' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.010801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002802' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.019149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558582 LIMIT 4 [ RunTime:0.021077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558582 ORDER BY `minOrder` ASC [ RunTime:0.023336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558582 ORDER BY `unit` DESC [ RunTime:0.017893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558582 LIMIT 2 [ RunTime:0.020754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558582 ORDER BY `minOrder` ASC [ RunTime:0.002565s ]
select * from pdf where partno='210002801' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.002957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002801' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.005858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558581 LIMIT 4 [ RunTime:0.008307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558581 ORDER BY `minOrder` ASC [ RunTime:0.014418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558581 ORDER BY `unit` DESC [ RunTime:0.012771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558581 LIMIT 2 [ RunTime:0.011526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558581 ORDER BY `minOrder` ASC [ RunTime:0.004713s ]
select * from pdf where partno='210002800' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.027506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002800' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.023402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558580 LIMIT 4 [ RunTime:0.005839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558580 ORDER BY `minOrder` ASC [ RunTime:0.010338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558580 ORDER BY `unit` DESC [ RunTime:0.011262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558580 LIMIT 2 [ RunTime:0.022028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558580 ORDER BY `minOrder` ASC [ RunTime:0.010317s ]
select * from pdf where partno='210002805' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.008092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002805' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.019667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558579 LIMIT 4 [ RunTime:0.029572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558579 ORDER BY `minOrder` ASC [ RunTime:0.045799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558579 ORDER BY `unit` DESC [ RunTime:0.013739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558579 LIMIT 2 [ RunTime:0.001511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558579 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='210002803' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.002494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002803' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.019504s ]
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.002986s ]