SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002066s ]
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.001931s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003340s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000578s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002325s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.008843s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002443s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005763s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001978s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000680s ]
UPDATE `stock_search` SET `count` = 2976 , `updatetime` = '2026-06-08 11:34:04' WHERE `partno` = '210' [ RunTime:0.012590s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000282s ]
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.008157s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002536s ]
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.349970s ]
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.108556s ]
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 ('35564460','35563936','35563883','35563452','35562975','35562957','35562742','35562689','35562369','35562040','35561986','35561752','35561643','35561642','35561499','35561498','35561066','35560472','35559699','35558832') ORDER BY FIELD(s.id, 35564460,35563936,35563883,35563452,35562975,35562957,35562742,35562689,35562369,35562040,35561986,35561752,35561643,35561642,35561499,35561498,35561066,35560472,35559699,35558832) [ RunTime:0.016012s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35564460 LIMIT 4 [ RunTime:0.006871s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35564460 ORDER BY `minOrder` ASC [ RunTime:0.017494s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35564460 ORDER BY `unit` DESC [ RunTime:0.017205s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35564460 LIMIT 2 [ RunTime:0.013713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35564460 ORDER BY `minOrder` ASC [ RunTime:0.020871s ]
select * from pdf where partno='21035851420' and brandshort='HARTING' limit 1 [ RunTime:0.035080s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035851420' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.067923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35563936 LIMIT 4 [ RunTime:0.034337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563936 ORDER BY `minOrder` ASC [ RunTime:0.022289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35563936 ORDER BY `unit` DESC [ RunTime:0.032833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35563936 LIMIT 2 [ RunTime:0.051501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563936 ORDER BY `minOrder` ASC [ RunTime:0.019048s ]
select * from pdf where partno='21034853415' and brandshort='HARTING' limit 1 [ RunTime:0.005861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034853415' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.023242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35563883 LIMIT 4 [ RunTime:0.020663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563883 ORDER BY `minOrder` ASC [ RunTime:0.020495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35563883 ORDER BY `unit` DESC [ RunTime:0.031470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35563883 LIMIT 2 [ RunTime:0.026414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563883 ORDER BY `minOrder` ASC [ RunTime:0.004550s ]
select * from pdf where partno='21034851415' and brandshort='HARTING' limit 1 [ RunTime:0.022397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034851415' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.041915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35563452 LIMIT 4 [ RunTime:0.017431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563452 ORDER BY `minOrder` ASC [ RunTime:0.009212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35563452 ORDER BY `unit` DESC [ RunTime:0.012898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35563452 LIMIT 2 [ RunTime:0.022014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563452 ORDER BY `minOrder` ASC [ RunTime:0.005300s ]
select * from pdf where partno='2109201' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.046845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109201' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562975 LIMIT 4 [ RunTime:0.019701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562975 ORDER BY `minOrder` ASC [ RunTime:0.006550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562975 ORDER BY `unit` DESC [ RunTime:0.006776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562975 LIMIT 2 [ RunTime:0.020001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562975 ORDER BY `minOrder` ASC [ RunTime:0.016870s ]
select * from pdf where partno='2106282' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106282' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562957 LIMIT 4 [ RunTime:0.014098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562957 ORDER BY `minOrder` ASC [ RunTime:0.004821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562957 ORDER BY `unit` DESC [ RunTime:0.007767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562957 LIMIT 2 [ RunTime:0.040406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562957 ORDER BY `minOrder` ASC [ RunTime:0.006343s ]
select * from pdf where partno='2109197' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109197' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562742 LIMIT 4 [ RunTime:0.009807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562742 ORDER BY `minOrder` ASC [ RunTime:0.004972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562742 ORDER BY `unit` DESC [ RunTime:0.007829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562742 LIMIT 2 [ RunTime:0.012226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562742 ORDER BY `minOrder` ASC [ RunTime:0.016087s ]
select * from pdf where partno='2106176' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106176' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562689 LIMIT 4 [ RunTime:0.009033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562689 ORDER BY `minOrder` ASC [ RunTime:0.015452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562689 ORDER BY `unit` DESC [ RunTime:0.009946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562689 LIMIT 2 [ RunTime:0.006827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562689 ORDER BY `minOrder` ASC [ RunTime:0.003885s ]
select * from pdf where partno='21035853420' and brandshort='HARTING' limit 1 [ RunTime:0.001739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035853420' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562369 LIMIT 4 [ RunTime:0.014581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562369 ORDER BY `minOrder` ASC [ RunTime:0.015632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562369 ORDER BY `unit` DESC [ RunTime:0.022060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562369 LIMIT 2 [ RunTime:0.011962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562369 ORDER BY `minOrder` ASC [ RunTime:0.008906s ]
select * from pdf where partno='2106574' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106574' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562040 LIMIT 4 [ RunTime:0.011391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562040 ORDER BY `minOrder` ASC [ RunTime:0.013682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562040 ORDER BY `unit` DESC [ RunTime:0.005167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562040 LIMIT 2 [ RunTime:0.009305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562040 ORDER BY `minOrder` ASC [ RunTime:0.003924s ]
select * from pdf where partno='21034853410' and brandshort='HARTING' limit 1 [ RunTime:0.003416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034853410' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561986 LIMIT 4 [ RunTime:0.006865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561986 ORDER BY `minOrder` ASC [ RunTime:0.006805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561986 ORDER BY `unit` DESC [ RunTime:0.001961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561986 LIMIT 2 [ RunTime:0.007308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561986 ORDER BY `minOrder` ASC [ RunTime:0.002377s ]
select * from pdf where partno='2106278' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106278' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561752 LIMIT 4 [ RunTime:0.003399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561752 ORDER BY `minOrder` ASC [ RunTime:0.006137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561752 ORDER BY `unit` DESC [ RunTime:0.001186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561752 LIMIT 2 [ RunTime:0.017775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561752 ORDER BY `minOrder` ASC [ RunTime:0.008726s ]
select * from pdf where partno='2106275' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106275' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561643 LIMIT 4 [ RunTime:0.011773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561643 ORDER BY `minOrder` ASC [ RunTime:0.002730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561643 ORDER BY `unit` DESC [ RunTime:0.002233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561643 LIMIT 2 [ RunTime:0.004581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561643 ORDER BY `minOrder` ASC [ RunTime:0.003288s ]
select * from pdf where partno='2106271' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106271' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561642 LIMIT 4 [ RunTime:0.009733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561642 ORDER BY `minOrder` ASC [ RunTime:0.005833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561642 ORDER BY `unit` DESC [ RunTime:0.002315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561642 LIMIT 2 [ RunTime:0.011470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561642 ORDER BY `minOrder` ASC [ RunTime:0.001709s ]
select * from pdf where partno='2106166' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106166' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561499 LIMIT 4 [ RunTime:0.003129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561499 ORDER BY `minOrder` ASC [ RunTime:0.002498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561499 ORDER BY `unit` DESC [ RunTime:0.007036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561499 LIMIT 2 [ RunTime:0.005457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561499 ORDER BY `minOrder` ASC [ RunTime:0.002643s ]
select * from pdf where partno='2106269' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106269' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561498 LIMIT 4 [ RunTime:0.006426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561498 ORDER BY `minOrder` ASC [ RunTime:0.000780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561498 ORDER BY `unit` DESC [ RunTime:0.000924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561498 LIMIT 2 [ RunTime:0.000805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561498 ORDER BY `minOrder` ASC [ RunTime:0.000720s ]
select * from pdf where partno='21034851410' and brandshort='HARTING' limit 1 [ RunTime:0.004540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034851410' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561066 LIMIT 4 [ RunTime:0.007476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561066 ORDER BY `minOrder` ASC [ RunTime:0.002573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561066 ORDER BY `unit` DESC [ RunTime:0.000733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561066 LIMIT 2 [ RunTime:0.000765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561066 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
select * from pdf where partno='21034831810' and brandshort='HARTING' limit 1 [ RunTime:0.004249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034831810' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35560472 LIMIT 4 [ RunTime:0.000898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35560472 ORDER BY `minOrder` ASC [ RunTime:0.001080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35560472 ORDER BY `unit` DESC [ RunTime:0.000777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35560472 LIMIT 2 [ RunTime:0.003563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35560472 ORDER BY `minOrder` ASC [ RunTime:0.001021s ]
select * from pdf where partno='2106286' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106286' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35559699 LIMIT 4 [ RunTime:0.001372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35559699 ORDER BY `minOrder` ASC [ RunTime:0.001342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35559699 ORDER BY `unit` DESC [ RunTime:0.003012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35559699 LIMIT 2 [ RunTime:0.000862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35559699 ORDER BY `minOrder` ASC [ RunTime:0.000804s ]
select * from pdf where partno='21034831405' and brandshort='HARTING' limit 1 [ RunTime:0.000976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034831405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35558832 LIMIT 4 [ RunTime:0.004216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35558832 ORDER BY `minOrder` ASC [ RunTime:0.001334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35558832 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35558832 LIMIT 2 [ RunTime:0.000717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35558832 ORDER BY `minOrder` ASC [ RunTime:0.000782s ]
select * from pdf where partno='21035853410' and brandshort='HARTING' limit 1 [ RunTime:0.001044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035853410' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001906s ]
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.079412s ]