SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003406s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.60' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.004318s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002390s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004836s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001273s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.60' ) [ RunTime:0.000254s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001102s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000231s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001076s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.003047s ]
UPDATE `stock_search` SET `count` = 2473 , `updatetime` = '2026-06-08 05:08:27' WHERE `partno` = '210' [ RunTime:0.004360s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.006548s ]
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.000519s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001494s ]
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.000320s ]
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 3900,20 [ RunTime:0.096156s ]
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 ('35539767','35539296','35538935','35538927','35538260','35538259','35538106','35538056','35537305','35536241','35536043','35536001','35535338','35535166','35535053','35534987','35534809','35534808','35534294','35534069') ORDER BY FIELD(s.id, 35539767,35539296,35538935,35538927,35538260,35538259,35538106,35538056,35537305,35536241,35536043,35536001,35535338,35535166,35535053,35534987,35534809,35534808,35534294,35534069) [ RunTime:0.034875s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35539767 LIMIT 4 [ RunTime:0.013763s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35539767 ORDER BY `minOrder` ASC [ RunTime:0.015169s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35539767 ORDER BY `unit` DESC [ RunTime:0.002313s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35539767 LIMIT 2 [ RunTime:0.002836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35539767 ORDER BY `minOrder` ASC [ RunTime:0.002768s ]
select * from pdf where partno='2104884' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006963s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104884' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35539296 LIMIT 4 [ RunTime:0.012928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35539296 ORDER BY `minOrder` ASC [ RunTime:0.018299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35539296 ORDER BY `unit` DESC [ RunTime:0.025331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35539296 LIMIT 2 [ RunTime:0.038953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35539296 ORDER BY `minOrder` ASC [ RunTime:0.002622s ]
select * from pdf where partno='2107810' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107810' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35538935 LIMIT 4 [ RunTime:0.013161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538935 ORDER BY `minOrder` ASC [ RunTime:0.016036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35538935 ORDER BY `unit` DESC [ RunTime:0.012351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35538935 LIMIT 2 [ RunTime:0.009275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538935 ORDER BY `minOrder` ASC [ RunTime:0.010324s ]
select * from pdf where partno='2109894' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109894' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35538927 LIMIT 4 [ RunTime:0.013549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538927 ORDER BY `minOrder` ASC [ RunTime:0.007330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35538927 ORDER BY `unit` DESC [ RunTime:0.016842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35538927 LIMIT 2 [ RunTime:0.009231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538927 ORDER BY `minOrder` ASC [ RunTime:0.005464s ]
select * from pdf where partno='2109899' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109899' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.029217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35538260 LIMIT 4 [ RunTime:0.028161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538260 ORDER BY `minOrder` ASC [ RunTime:0.013109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35538260 ORDER BY `unit` DESC [ RunTime:0.015883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35538260 LIMIT 2 [ RunTime:0.040272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538260 ORDER BY `minOrder` ASC [ RunTime:0.026679s ]
select * from pdf where partno='2107786' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107786' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35538259 LIMIT 4 [ RunTime:0.028921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538259 ORDER BY `minOrder` ASC [ RunTime:0.042278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35538259 ORDER BY `unit` DESC [ RunTime:0.062389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35538259 LIMIT 2 [ RunTime:0.014360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538259 ORDER BY `minOrder` ASC [ RunTime:0.027788s ]
select * from pdf where partno='2107519' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107519' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35538106 LIMIT 4 [ RunTime:0.043503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538106 ORDER BY `minOrder` ASC [ RunTime:0.026708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35538106 ORDER BY `unit` DESC [ RunTime:0.033283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35538106 LIMIT 2 [ RunTime:0.025214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538106 ORDER BY `minOrder` ASC [ RunTime:0.017617s ]
select * from pdf where partno='21035853451' and brandshort='HARTING' limit 1 [ RunTime:0.018260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035853451' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.038480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35538056 LIMIT 4 [ RunTime:0.046908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538056 ORDER BY `minOrder` ASC [ RunTime:0.021172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35538056 ORDER BY `unit` DESC [ RunTime:0.000890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35538056 LIMIT 2 [ RunTime:0.042645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538056 ORDER BY `minOrder` ASC [ RunTime:0.009887s ]
select * from pdf where partno='2106283' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106283' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35537305 LIMIT 4 [ RunTime:0.027934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35537305 ORDER BY `minOrder` ASC [ RunTime:0.025771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35537305 ORDER BY `unit` DESC [ RunTime:0.026522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35537305 LIMIT 2 [ RunTime:0.045355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35537305 ORDER BY `minOrder` ASC [ RunTime:0.004681s ]
select * from pdf where partno='2107807' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.048415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107807' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35536241 LIMIT 4 [ RunTime:0.019474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536241 ORDER BY `minOrder` ASC [ RunTime:0.029940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35536241 ORDER BY `unit` DESC [ RunTime:0.023702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35536241 LIMIT 2 [ RunTime:0.006038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536241 ORDER BY `minOrder` ASC [ RunTime:0.005447s ]
select * from pdf where partno='2107806' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.036372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107806' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35536043 LIMIT 4 [ RunTime:0.046244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536043 ORDER BY `minOrder` ASC [ RunTime:0.054580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35536043 ORDER BY `unit` DESC [ RunTime:0.032072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35536043 LIMIT 2 [ RunTime:0.039139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536043 ORDER BY `minOrder` ASC [ RunTime:0.009008s ]
select * from pdf where partno='21035992535' and brandshort='HARTING' limit 1 [ RunTime:0.051803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035992535' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.050405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35536001 LIMIT 4 [ RunTime:0.017550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536001 ORDER BY `minOrder` ASC [ RunTime:0.023227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35536001 ORDER BY `unit` DESC [ RunTime:0.029548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35536001 LIMIT 2 [ RunTime:0.060228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536001 ORDER BY `minOrder` ASC [ RunTime:0.002457s ]
select * from pdf where partno='21035851451' and brandshort='HARTING' limit 1 [ RunTime:0.016039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035851451' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.034289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35535338 LIMIT 4 [ RunTime:0.022465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535338 ORDER BY `minOrder` ASC [ RunTime:0.017946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35535338 ORDER BY `unit` DESC [ RunTime:0.029324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35535338 LIMIT 2 [ RunTime:0.048193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535338 ORDER BY `minOrder` ASC [ RunTime:0.001974s ]
select * from pdf where partno='21035853401' and brandshort='HARTING' limit 1 [ RunTime:0.036823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035853401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.034835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35535166 LIMIT 4 [ RunTime:0.044212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535166 ORDER BY `minOrder` ASC [ RunTime:0.036539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35535166 ORDER BY `unit` DESC [ RunTime:0.025861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35535166 LIMIT 2 [ RunTime:0.022676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535166 ORDER BY `minOrder` ASC [ RunTime:0.048507s ]
select * from pdf where partno='21035991535' and brandshort='HARTING' limit 1 [ RunTime:0.023096s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035991535' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.029405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35535053 LIMIT 4 [ RunTime:0.020968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535053 ORDER BY `minOrder` ASC [ RunTime:0.036454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35535053 ORDER BY `unit` DESC [ RunTime:0.025790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35535053 LIMIT 2 [ RunTime:0.057435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535053 ORDER BY `minOrder` ASC [ RunTime:0.009954s ]
select * from pdf where partno='2101503' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.138116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101503' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.041877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35534987 LIMIT 4 [ RunTime:0.036526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534987 ORDER BY `minOrder` ASC [ RunTime:0.091118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35534987 ORDER BY `unit` DESC [ RunTime:0.027177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35534987 LIMIT 2 [ RunTime:0.069963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534987 ORDER BY `minOrder` ASC [ RunTime:0.037666s ]
select * from pdf where partno='21035962535' and brandshort='HARTING' limit 1 [ RunTime:0.030161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035962535' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.028616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35534809 LIMIT 4 [ RunTime:0.056393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534809 ORDER BY `minOrder` ASC [ RunTime:0.019904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35534809 ORDER BY `unit` DESC [ RunTime:0.019450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35534809 LIMIT 2 [ RunTime:0.060537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534809 ORDER BY `minOrder` ASC [ RunTime:0.007372s ]
select * from pdf where partno='21035961535' and brandshort='HARTING' limit 1 [ RunTime:0.027255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035961535' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.055436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35534808 LIMIT 4 [ RunTime:0.073387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534808 ORDER BY `minOrder` ASC [ RunTime:0.063634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35534808 ORDER BY `unit` DESC [ RunTime:0.011953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35534808 LIMIT 2 [ RunTime:0.015448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534808 ORDER BY `minOrder` ASC [ RunTime:0.010487s ]
select * from pdf where partno='21035961516' and brandshort='HARTING' limit 1 [ RunTime:0.020460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035961516' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.070508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35534294 LIMIT 4 [ RunTime:0.076394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534294 ORDER BY `minOrder` ASC [ RunTime:0.016254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35534294 ORDER BY `unit` DESC [ RunTime:0.043683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35534294 LIMIT 2 [ RunTime:0.038201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534294 ORDER BY `minOrder` ASC [ RunTime:0.005969s ]
select * from pdf where partno='2107781' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107781' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35534069 LIMIT 4 [ RunTime:0.012488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534069 ORDER BY `minOrder` ASC [ RunTime:0.017475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35534069 ORDER BY `unit` DESC [ RunTime:0.005541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35534069 LIMIT 2 [ RunTime:0.002145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534069 ORDER BY `minOrder` ASC [ RunTime:0.002309s ]
select * from pdf where partno='21033176810' and brandshort='HARTING' limit 1 [ RunTime:0.014212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033176810' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.008430s ]
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.000938s ]