SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001758s ]
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.003762s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002260s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000545s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002378s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.60' ) [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002176s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000990s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002116s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.005096s ]
UPDATE `stock_search` SET `count` = 2491 , `updatetime` = '2026-06-08 05:08:58' WHERE `partno` = '210' [ RunTime:0.001361s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000267s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000231s ]
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.000469s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003360s ]
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.000453s ]
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 3880,20 [ RunTime:0.111991s ]
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 ('35548045','35547466','35547428','35547360','35547217','35547173','35546106','35545019','35544879','35544414','35543633','35542502','35541843','35541262','35541180','35540504','35540502','35540210','35540198','35540197') ORDER BY FIELD(s.id, 35548045,35547466,35547428,35547360,35547217,35547173,35546106,35545019,35544879,35544414,35543633,35542502,35541843,35541262,35541180,35540504,35540502,35540210,35540198,35540197) [ RunTime:0.020230s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35548045 LIMIT 4 [ RunTime:0.014018s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35548045 ORDER BY `minOrder` ASC [ RunTime:0.016098s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35548045 ORDER BY `unit` DESC [ RunTime:0.008018s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35548045 LIMIT 2 [ RunTime:0.010964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35548045 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='2104369' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018222s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104369' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35547466 LIMIT 4 [ RunTime:0.015218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35547466 ORDER BY `minOrder` ASC [ RunTime:0.005203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35547466 ORDER BY `unit` DESC [ RunTime:0.006941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35547466 LIMIT 2 [ RunTime:0.013999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35547466 ORDER BY `minOrder` ASC [ RunTime:0.002313s ]
select * from pdf where partno='2108211' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108211' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35547428 LIMIT 4 [ RunTime:0.010585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35547428 ORDER BY `minOrder` ASC [ RunTime:0.011433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35547428 ORDER BY `unit` DESC [ RunTime:0.023381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35547428 LIMIT 2 [ RunTime:0.013552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35547428 ORDER BY `minOrder` ASC [ RunTime:0.006451s ]
select * from pdf where partno='21035851405' and brandshort='HARTING' limit 1 [ RunTime:0.029432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035851405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.024699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35547360 LIMIT 4 [ RunTime:0.012223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35547360 ORDER BY `minOrder` ASC [ RunTime:0.019563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35547360 ORDER BY `unit` DESC [ RunTime:0.006757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35547360 LIMIT 2 [ RunTime:0.016585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35547360 ORDER BY `minOrder` ASC [ RunTime:0.005897s ]
select * from pdf where partno='21034851451' and brandshort='HARTING' limit 1 [ RunTime:0.007771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034851451' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.034021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35547217 LIMIT 4 [ RunTime:0.018340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35547217 ORDER BY `minOrder` ASC [ RunTime:0.038226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35547217 ORDER BY `unit` DESC [ RunTime:0.075767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35547217 LIMIT 2 [ RunTime:0.082849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35547217 ORDER BY `minOrder` ASC [ RunTime:0.030352s ]
select * from pdf where partno='21034851401' and brandshort='HARTING' limit 1 [ RunTime:0.028911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034851401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.067322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35547173 LIMIT 4 [ RunTime:0.044846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35547173 ORDER BY `minOrder` ASC [ RunTime:0.058289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35547173 ORDER BY `unit` DESC [ RunTime:0.021609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35547173 LIMIT 2 [ RunTime:0.031386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35547173 ORDER BY `minOrder` ASC [ RunTime:0.023974s ]
select * from pdf where partno='2106174' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106174' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35546106 LIMIT 4 [ RunTime:0.052532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35546106 ORDER BY `minOrder` ASC [ RunTime:0.025979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35546106 ORDER BY `unit` DESC [ RunTime:0.007442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35546106 LIMIT 2 [ RunTime:0.022289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35546106 ORDER BY `minOrder` ASC [ RunTime:0.033105s ]
select * from pdf where partno='2106171' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.031402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106171' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35545019 LIMIT 4 [ RunTime:0.009762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35545019 ORDER BY `minOrder` ASC [ RunTime:0.024675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35545019 ORDER BY `unit` DESC [ RunTime:0.016832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35545019 LIMIT 2 [ RunTime:0.047483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35545019 ORDER BY `minOrder` ASC [ RunTime:0.030492s ]
select * from pdf where partno='2107733' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107733' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35544879 LIMIT 4 [ RunTime:0.004945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35544879 ORDER BY `minOrder` ASC [ RunTime:0.023879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35544879 ORDER BY `unit` DESC [ RunTime:0.035038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35544879 LIMIT 2 [ RunTime:0.040353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35544879 ORDER BY `minOrder` ASC [ RunTime:0.019921s ]
select * from pdf where partno='2108472' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.034303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108472' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.037252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35544414 LIMIT 4 [ RunTime:0.005734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35544414 ORDER BY `minOrder` ASC [ RunTime:0.018443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35544414 ORDER BY `unit` DESC [ RunTime:0.018594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35544414 LIMIT 2 [ RunTime:0.009228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35544414 ORDER BY `minOrder` ASC [ RunTime:0.014805s ]
select * from pdf where partno='2106268' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106268' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35543633 LIMIT 4 [ RunTime:0.007315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35543633 ORDER BY `minOrder` ASC [ RunTime:0.039727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35543633 ORDER BY `unit` DESC [ RunTime:0.028094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35543633 LIMIT 2 [ RunTime:0.013196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35543633 ORDER BY `minOrder` ASC [ RunTime:0.006996s ]
select * from pdf where partno='21035853403' and brandshort='HARTING' limit 1 [ RunTime:0.026217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035853403' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.047878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35542502 LIMIT 4 [ RunTime:0.026861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35542502 ORDER BY `minOrder` ASC [ RunTime:0.062585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35542502 ORDER BY `unit` DESC [ RunTime:0.031906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35542502 LIMIT 2 [ RunTime:0.012460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35542502 ORDER BY `minOrder` ASC [ RunTime:0.011615s ]
select * from pdf where partno='2105499' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.036874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105499' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.053227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35541843 LIMIT 4 [ RunTime:0.011818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35541843 ORDER BY `minOrder` ASC [ RunTime:0.009479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35541843 ORDER BY `unit` DESC [ RunTime:0.027885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35541843 LIMIT 2 [ RunTime:0.018114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35541843 ORDER BY `minOrder` ASC [ RunTime:0.014718s ]
select * from pdf where partno='2101504' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101504' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.045667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35541262 LIMIT 4 [ RunTime:0.028405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35541262 ORDER BY `minOrder` ASC [ RunTime:0.013193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35541262 ORDER BY `unit` DESC [ RunTime:0.015128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35541262 LIMIT 2 [ RunTime:0.016420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35541262 ORDER BY `minOrder` ASC [ RunTime:0.002400s ]
select * from pdf where partno='21035851403' and brandshort='HARTING' limit 1 [ RunTime:0.021674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035851403' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.006567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35541180 LIMIT 4 [ RunTime:0.024810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35541180 ORDER BY `minOrder` ASC [ RunTime:0.011654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35541180 ORDER BY `unit` DESC [ RunTime:0.006055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35541180 LIMIT 2 [ RunTime:0.019089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35541180 ORDER BY `minOrder` ASC [ RunTime:0.027927s ]
select * from pdf where partno='2107731' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107731' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35540504 LIMIT 4 [ RunTime:0.030462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35540504 ORDER BY `minOrder` ASC [ RunTime:0.010019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35540504 ORDER BY `unit` DESC [ RunTime:0.024845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35540504 LIMIT 2 [ RunTime:0.037260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35540504 ORDER BY `minOrder` ASC [ RunTime:0.029377s ]
select * from pdf where partno='2104887' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.036703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104887' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.056767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35540502 LIMIT 4 [ RunTime:0.042127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35540502 ORDER BY `minOrder` ASC [ RunTime:0.019924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35540502 ORDER BY `unit` DESC [ RunTime:0.077748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35540502 LIMIT 2 [ RunTime:0.012003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35540502 ORDER BY `minOrder` ASC [ RunTime:0.015057s ]
select * from pdf where partno='2107716' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107716' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.050068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35540210 LIMIT 4 [ RunTime:0.017680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35540210 ORDER BY `minOrder` ASC [ RunTime:0.065468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35540210 ORDER BY `unit` DESC [ RunTime:0.057374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35540210 LIMIT 2 [ RunTime:0.063949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35540210 ORDER BY `minOrder` ASC [ RunTime:0.011414s ]
select * from pdf where partno='2107728' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107728' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.074147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35540198 LIMIT 4 [ RunTime:0.027784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35540198 ORDER BY `minOrder` ASC [ RunTime:0.038424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35540198 ORDER BY `unit` DESC [ RunTime:0.051011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35540198 LIMIT 2 [ RunTime:0.020655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35540198 ORDER BY `minOrder` ASC [ RunTime:0.017698s ]
select * from pdf where partno='21023531800' and brandshort='HARTING' limit 1 [ RunTime:0.018180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21023531800' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35540197 LIMIT 4 [ RunTime:0.032495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35540197 ORDER BY `minOrder` ASC [ RunTime:0.012897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35540197 ORDER BY `unit` DESC [ RunTime:0.027777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35540197 LIMIT 2 [ RunTime:0.004974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35540197 ORDER BY `minOrder` ASC [ RunTime:0.002181s ]
select * from pdf where partno='21023532800' and brandshort='HARTING' limit 1 [ RunTime:0.002751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21023532800' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005248s ]
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.003221s ]