SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001621s ]
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=237&srecordnum=7544' [ RunTime:0.016445s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001552s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001851s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001443s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.004269s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002730s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006221s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002023s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.016883s ]
UPDATE `stock_search` SET `count` = 5081 , `updatetime` = '2026-06-08 22:47:59' WHERE `partno` = '210' [ RunTime:0.006924s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001015s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000913s ]
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.000965s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002287s ]
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.013350s ]
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 4720,20 [ RunTime:0.009556s ]
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 ('33843383','33843381','33843280','33838582','33838543','33838289','33838220','33822959','33822926','33822911','33822910','33822409','33782833','33628082','33619012','33618416','33618113','33529455','33529453','33529450') ORDER BY FIELD(s.id, 33843383,33843381,33843280,33838582,33838543,33838289,33838220,33822959,33822926,33822911,33822910,33822409,33782833,33628082,33619012,33618416,33618113,33529455,33529453,33529450) [ RunTime:0.003385s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33843383 LIMIT 4 [ RunTime:0.007304s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33843383 ORDER BY `minOrder` ASC [ RunTime:0.001663s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33843383 ORDER BY `unit` DESC [ RunTime:0.013262s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33843383 LIMIT 2 [ RunTime:0.003455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33843383 ORDER BY `minOrder` ASC [ RunTime:0.005296s ]
select * from pdf where partno='210003029' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.013668s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003029' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.010694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33843381 LIMIT 4 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33843381 ORDER BY `minOrder` ASC [ RunTime:0.001152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33843381 ORDER BY `unit` DESC [ RunTime:0.012543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33843381 LIMIT 2 [ RunTime:0.004143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33843381 ORDER BY `minOrder` ASC [ RunTime:0.039090s ]
select * from pdf where partno='210000729' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.011224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000729' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.006294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33843280 LIMIT 4 [ RunTime:0.009915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33843280 ORDER BY `minOrder` ASC [ RunTime:0.003198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33843280 ORDER BY `unit` DESC [ RunTime:0.005521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33843280 LIMIT 2 [ RunTime:0.009384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33843280 ORDER BY `minOrder` ASC [ RunTime:0.003931s ]
select * from pdf where partno='210000908' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.015782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000908' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.000678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33838582 LIMIT 4 [ RunTime:0.006174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33838582 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33838582 ORDER BY `unit` DESC [ RunTime:0.014212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33838582 LIMIT 2 [ RunTime:0.001506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33838582 ORDER BY `minOrder` ASC [ RunTime:0.002497s ]
select * from pdf where partno='2107428' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107428' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33838543 LIMIT 4 [ RunTime:0.006947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33838543 ORDER BY `minOrder` ASC [ RunTime:0.010198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33838543 ORDER BY `unit` DESC [ RunTime:0.004648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33838543 LIMIT 2 [ RunTime:0.012915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33838543 ORDER BY `minOrder` ASC [ RunTime:0.013955s ]
select * from pdf where partno='21033116801' and brandshort='HARTING' limit 1 [ RunTime:0.009520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033116801' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.023365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33838289 LIMIT 4 [ RunTime:0.016192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33838289 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33838289 ORDER BY `unit` DESC [ RunTime:0.012823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33838289 LIMIT 2 [ RunTime:0.016657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33838289 ORDER BY `minOrder` ASC [ RunTime:0.032626s ]
select * from pdf where partno='21033116502' and brandshort='HARTING' limit 1 [ RunTime:0.013529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033116502' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.034433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33838220 LIMIT 4 [ RunTime:0.029058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33838220 ORDER BY `minOrder` ASC [ RunTime:0.009798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33838220 ORDER BY `unit` DESC [ RunTime:0.018003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33838220 LIMIT 2 [ RunTime:0.036032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33838220 ORDER BY `minOrder` ASC [ RunTime:0.024075s ]
select * from pdf where partno='21033116501' and brandshort='HARTING' limit 1 [ RunTime:0.016129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033116501' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.028468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33822959 LIMIT 4 [ RunTime:0.037139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33822959 ORDER BY `minOrder` ASC [ RunTime:0.007411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33822959 ORDER BY `unit` DESC [ RunTime:0.042755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33822959 LIMIT 2 [ RunTime:0.065103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33822959 ORDER BY `minOrder` ASC [ RunTime:0.031532s ]
select * from pdf where partno='21033711420' and brandshort='HARTING' limit 1 [ RunTime:0.051496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033711420' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.030990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33822926 LIMIT 4 [ RunTime:0.017931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33822926 ORDER BY `minOrder` ASC [ RunTime:0.034575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33822926 ORDER BY `unit` DESC [ RunTime:0.021102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33822926 LIMIT 2 [ RunTime:0.056298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33822926 ORDER BY `minOrder` ASC [ RunTime:0.040374s ]
select * from pdf where partno='21033816405' and brandshort='HARTING' limit 1 [ RunTime:0.045384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033816405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.028201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33822911 LIMIT 4 [ RunTime:0.062458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33822911 ORDER BY `minOrder` ASC [ RunTime:0.031388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33822911 ORDER BY `unit` DESC [ RunTime:0.055945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33822911 LIMIT 2 [ RunTime:0.048365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33822911 ORDER BY `minOrder` ASC [ RunTime:0.029387s ]
select * from pdf where partno='21033812400' and brandshort='HARTING' limit 1 [ RunTime:0.051669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033812400' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.113743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33822910 LIMIT 4 [ RunTime:0.021430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33822910 ORDER BY `minOrder` ASC [ RunTime:0.025566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33822910 ORDER BY `unit` DESC [ RunTime:0.035500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33822910 LIMIT 2 [ RunTime:0.053515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33822910 ORDER BY `minOrder` ASC [ RunTime:0.086410s ]
select * from pdf where partno='21033814400' and brandshort='HARTING' limit 1 [ RunTime:0.034609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033814400' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.036267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33822409 LIMIT 4 [ RunTime:0.019863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33822409 ORDER BY `minOrder` ASC [ RunTime:0.090988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33822409 ORDER BY `unit` DESC [ RunTime:0.057412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33822409 LIMIT 2 [ RunTime:0.012990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33822409 ORDER BY `minOrder` ASC [ RunTime:0.020785s ]
select * from pdf where partno='21033814800' and brandshort='HARTING' limit 1 [ RunTime:0.016071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033814800' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.041987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33782833 LIMIT 4 [ RunTime:0.016255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33782833 ORDER BY `minOrder` ASC [ RunTime:0.019867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33782833 ORDER BY `unit` DESC [ RunTime:0.009057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33782833 LIMIT 2 [ RunTime:0.025628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33782833 ORDER BY `minOrder` ASC [ RunTime:0.013352s ]
select * from pdf where partno='210-A-126-SMD/04' and brandshort='WECO Electrical Connectors Inc.' limit 1 [ RunTime:0.022752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-A-126-SMD/04' OR `brand` LIKE 'WECO Electrical Connectors Inc.%' ) ) LIMIT 1 [ RunTime:0.002044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33628082 LIMIT 4 [ RunTime:0.006880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33628082 ORDER BY `minOrder` ASC [ RunTime:0.010829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33628082 ORDER BY `unit` DESC [ RunTime:0.006742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33628082 LIMIT 2 [ RunTime:0.006283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33628082 ORDER BY `minOrder` ASC [ RunTime:0.007158s ]
select * from pdf where partno='210260000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210260000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33619012 LIMIT 4 [ RunTime:0.006665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33619012 ORDER BY `minOrder` ASC [ RunTime:0.009853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33619012 ORDER BY `unit` DESC [ RunTime:0.011638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33619012 LIMIT 2 [ RunTime:0.013275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33619012 ORDER BY `minOrder` ASC [ RunTime:0.017937s ]
select * from pdf where partno='2104-1307' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.014747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-1307' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.015919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618416 LIMIT 4 [ RunTime:0.003631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618416 ORDER BY `minOrder` ASC [ RunTime:0.018421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618416 ORDER BY `unit` DESC [ RunTime:0.012361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618416 LIMIT 2 [ RunTime:0.009529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618416 ORDER BY `minOrder` ASC [ RunTime:0.012057s ]
select * from pdf where partno='2102-1304' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.007404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-1304' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618113 LIMIT 4 [ RunTime:0.013089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618113 ORDER BY `minOrder` ASC [ RunTime:0.003855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618113 ORDER BY `unit` DESC [ RunTime:0.008653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618113 LIMIT 2 [ RunTime:0.007159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618113 ORDER BY `minOrder` ASC [ RunTime:0.010629s ]
select * from pdf where partno='2102-5207' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.005231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-5207' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.010146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529455 LIMIT 4 [ RunTime:0.014449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529455 ORDER BY `minOrder` ASC [ RunTime:0.009826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529455 ORDER BY `unit` DESC [ RunTime:0.010359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529455 LIMIT 2 [ RunTime:0.009114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529455 ORDER BY `minOrder` ASC [ RunTime:0.015980s ]
select * from pdf where partno='2100G' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.004731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100G' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.002593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529453 LIMIT 4 [ RunTime:0.002953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529453 ORDER BY `minOrder` ASC [ RunTime:0.001304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529453 ORDER BY `unit` DESC [ RunTime:0.002748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529453 LIMIT 2 [ RunTime:0.005265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529453 ORDER BY `minOrder` ASC [ RunTime:0.003833s ]
select * from pdf where partno='2100025' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100025' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529450 LIMIT 4 [ RunTime:0.007205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529450 ORDER BY `minOrder` ASC [ RunTime:0.015597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529450 ORDER BY `unit` DESC [ RunTime:0.019197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529450 LIMIT 2 [ RunTime:0.024902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529450 ORDER BY `minOrder` ASC [ RunTime:0.011046s ]
select * from pdf where partno='2100024' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100024' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.018598s ]
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.004554s ]