SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002846s ]
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` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=145&srecordnum=7433' [ RunTime:0.001721s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001573s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001824s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002009s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000371s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001915s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000808s ]
UPDATE `stock_search` SET `count` = 5084 , `updatetime` = '2026-06-08 22:48:31' WHERE `partno` = '210' [ RunTime:0.001618s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000244s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000467s ]
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.000641s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001498s ]
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.234253s ]
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 2880,20 [ RunTime:0.122723s ]
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 ('37558171','37558170','37558167','37558166','37558165','37558164','37558163','37558162','37556141','37550143','37549937','37549929','37549899','37549894','37549886','37500522','37462230','37453462','37443740','37433176') ORDER BY FIELD(s.id, 37558171,37558170,37558167,37558166,37558165,37558164,37558163,37558162,37556141,37550143,37549937,37549929,37549899,37549894,37549886,37500522,37462230,37453462,37443740,37433176) [ RunTime:0.044897s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558171 LIMIT 4 [ RunTime:0.020510s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558171 ORDER BY `minOrder` ASC [ RunTime:0.048372s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558171 ORDER BY `unit` DESC [ RunTime:0.032553s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558171 LIMIT 2 [ RunTime:0.025821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558171 ORDER BY `minOrder` ASC [ RunTime:0.029105s ]
select * from pdf where partno='210002835' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.016749s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002835' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.008562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558170 LIMIT 4 [ RunTime:0.019654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558170 ORDER BY `minOrder` ASC [ RunTime:0.011082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558170 ORDER BY `unit` DESC [ RunTime:0.076277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558170 LIMIT 2 [ RunTime:0.023187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558170 ORDER BY `minOrder` ASC [ RunTime:0.048433s ]
select * from pdf where partno='210002834' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.025251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002834' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.035761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558167 LIMIT 4 [ RunTime:0.063083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558167 ORDER BY `minOrder` ASC [ RunTime:0.005480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558167 ORDER BY `unit` DESC [ RunTime:0.072198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558167 LIMIT 2 [ RunTime:0.040325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558167 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
select * from pdf where partno='210002746' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.017363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002746' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.025331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558166 LIMIT 4 [ RunTime:0.054785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558166 ORDER BY `minOrder` ASC [ RunTime:0.023461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558166 ORDER BY `unit` DESC [ RunTime:0.031756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558166 LIMIT 2 [ RunTime:0.042473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558166 ORDER BY `minOrder` ASC [ RunTime:0.012750s ]
select * from pdf where partno='210002745' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.042421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002745' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.018101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558165 LIMIT 4 [ RunTime:0.044194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558165 ORDER BY `minOrder` ASC [ RunTime:0.032619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558165 ORDER BY `unit` DESC [ RunTime:0.006954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558165 LIMIT 2 [ RunTime:0.011715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558165 ORDER BY `minOrder` ASC [ RunTime:0.011148s ]
select * from pdf where partno='210002744' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.030197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002744' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.053199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558164 LIMIT 4 [ RunTime:0.030093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558164 ORDER BY `minOrder` ASC [ RunTime:0.039261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558164 ORDER BY `unit` DESC [ RunTime:0.085605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558164 LIMIT 2 [ RunTime:0.020316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558164 ORDER BY `minOrder` ASC [ RunTime:0.013980s ]
select * from pdf where partno='210002742' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.097896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002742' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.049283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558163 LIMIT 4 [ RunTime:0.049970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558163 ORDER BY `minOrder` ASC [ RunTime:0.038614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558163 ORDER BY `unit` DESC [ RunTime:0.013943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558163 LIMIT 2 [ RunTime:0.051867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558163 ORDER BY `minOrder` ASC [ RunTime:0.019647s ]
select * from pdf where partno='210002741' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.027045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002741' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.019232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558162 LIMIT 4 [ RunTime:0.057619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558162 ORDER BY `minOrder` ASC [ RunTime:0.042302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558162 ORDER BY `unit` DESC [ RunTime:0.040908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558162 LIMIT 2 [ RunTime:0.024777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558162 ORDER BY `minOrder` ASC [ RunTime:0.026947s ]
select * from pdf where partno='210002743' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.011647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002743' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.059984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37556141 LIMIT 4 [ RunTime:0.023123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37556141 ORDER BY `minOrder` ASC [ RunTime:0.040533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37556141 ORDER BY `unit` DESC [ RunTime:0.024544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37556141 LIMIT 2 [ RunTime:0.020720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37556141 ORDER BY `minOrder` ASC [ RunTime:0.018330s ]
select * from pdf where partno='2100BL15A0100001E' and brandshort='Johanson Technology Inc.' limit 1 [ RunTime:0.033006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100BL15A0100001E' OR `brand` LIKE 'Johanson Technology Inc.%' ) ) LIMIT 1 [ RunTime:0.039319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37550143 LIMIT 4 [ RunTime:0.027896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37550143 ORDER BY `minOrder` ASC [ RunTime:0.013498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37550143 ORDER BY `unit` DESC [ RunTime:0.021363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37550143 LIMIT 2 [ RunTime:0.064361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37550143 ORDER BY `minOrder` ASC [ RunTime:0.028355s ]
select * from pdf where partno='210000377' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.034697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000377' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.013455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37549937 LIMIT 4 [ RunTime:0.012675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549937 ORDER BY `minOrder` ASC [ RunTime:0.044436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37549937 ORDER BY `unit` DESC [ RunTime:0.038155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37549937 LIMIT 2 [ RunTime:0.025371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549937 ORDER BY `minOrder` ASC [ RunTime:0.014033s ]
select * from pdf where partno='210003065' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.005412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003065' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.038027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37549929 LIMIT 4 [ RunTime:0.021164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549929 ORDER BY `minOrder` ASC [ RunTime:0.024046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37549929 ORDER BY `unit` DESC [ RunTime:0.041402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37549929 LIMIT 2 [ RunTime:0.034182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549929 ORDER BY `minOrder` ASC [ RunTime:0.022761s ]
select * from pdf where partno='210003051' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.017077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003051' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.031157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37549899 LIMIT 4 [ RunTime:0.020895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549899 ORDER BY `minOrder` ASC [ RunTime:0.039769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37549899 ORDER BY `unit` DESC [ RunTime:0.049472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37549899 LIMIT 2 [ RunTime:0.034433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549899 ORDER BY `minOrder` ASC [ RunTime:0.021094s ]
select * from pdf where partno='210003071' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.003456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003071' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.020907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37549894 LIMIT 4 [ RunTime:0.015422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549894 ORDER BY `minOrder` ASC [ RunTime:0.013163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37549894 ORDER BY `unit` DESC [ RunTime:0.034873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37549894 LIMIT 2 [ RunTime:0.034383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549894 ORDER BY `minOrder` ASC [ RunTime:0.016176s ]
select * from pdf where partno='210003070' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.007528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003070' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.027406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37549886 LIMIT 4 [ RunTime:0.008471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549886 ORDER BY `minOrder` ASC [ RunTime:0.017277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37549886 ORDER BY `unit` DESC [ RunTime:0.038511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37549886 LIMIT 2 [ RunTime:0.013034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37549886 ORDER BY `minOrder` ASC [ RunTime:0.009500s ]
select * from pdf where partno='210003050' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.026866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003050' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.011797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37500522 LIMIT 4 [ RunTime:0.025806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37500522 ORDER BY `minOrder` ASC [ RunTime:0.044946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37500522 ORDER BY `unit` DESC [ RunTime:0.026213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37500522 LIMIT 2 [ RunTime:0.021230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37500522 ORDER BY `minOrder` ASC [ RunTime:0.016645s ]
select * from pdf where partno='2101371' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101371' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37462230 LIMIT 4 [ RunTime:0.005308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37462230 ORDER BY `minOrder` ASC [ RunTime:0.028013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37462230 ORDER BY `unit` DESC [ RunTime:0.028956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37462230 LIMIT 2 [ RunTime:0.022596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37462230 ORDER BY `minOrder` ASC [ RunTime:0.031365s ]
select * from pdf where partno='2100315311' and brandshort='Advanced Energy' limit 1 [ RunTime:0.021200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100315311' OR `brand` LIKE 'Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.008173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37453462 LIMIT 4 [ RunTime:0.020123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37453462 ORDER BY `minOrder` ASC [ RunTime:0.024610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37453462 ORDER BY `unit` DESC [ RunTime:0.015681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37453462 LIMIT 2 [ RunTime:0.002533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37453462 ORDER BY `minOrder` ASC [ RunTime:0.002370s ]
select * from pdf where partno='2102812' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102812' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37443740 LIMIT 4 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37443740 ORDER BY `minOrder` ASC [ RunTime:0.014186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37443740 ORDER BY `unit` DESC [ RunTime:0.006982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37443740 LIMIT 2 [ RunTime:0.012023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37443740 ORDER BY `minOrder` ASC [ RunTime:0.000774s ]
select * from pdf where partno='210-251' and brandshort='Digilent, Inc.' limit 1 [ RunTime:0.007800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-251' OR `brand` LIKE 'Digilent, Inc.%' ) ) LIMIT 1 [ RunTime:0.022662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37433176 LIMIT 4 [ RunTime:0.024079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37433176 ORDER BY `minOrder` ASC [ RunTime:0.043163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37433176 ORDER BY `unit` DESC [ RunTime:0.006861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37433176 LIMIT 2 [ RunTime:0.003369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37433176 ORDER BY `minOrder` ASC [ RunTime:0.007123s ]
select * from pdf where partno='210-179P-BOARD' and brandshort='Digilent, Inc.' limit 1 [ RunTime:0.005598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-179P-BOARD' OR `brand` LIKE 'Digilent, Inc.%' ) ) LIMIT 1 [ RunTime:0.018082s ]
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.004589s ]