SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001380s ]
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=200&srecordnum=7529' [ RunTime:0.026466s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001089s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005128s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001535s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.030891s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002107s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003754s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001692s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.006082s ]
UPDATE `stock_search` SET `count` = 4482 , `updatetime` = '2026-06-08 18:30:17' WHERE `partno` = '210' [ RunTime:0.003368s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.013820s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.003555s ]
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.000335s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002054s ]
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:1.054643s ]
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 3980,20 [ RunTime:0.157472s ]
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 ('35568688','35568089','35567753','35567720','35567513','35567138','35566904','35566762','35566694','35565843','35565659','35565602','35565351','35565083','35564917','35564782','35564720','35564460','35563936','35563883') ORDER BY FIELD(s.id, 35568688,35568089,35567753,35567720,35567513,35567138,35566904,35566762,35566694,35565843,35565659,35565602,35565351,35565083,35564917,35564782,35564720,35564460,35563936,35563883) [ RunTime:0.027421s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35568688 LIMIT 4 [ RunTime:0.029130s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35568688 ORDER BY `minOrder` ASC [ RunTime:0.028556s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35568688 ORDER BY `unit` DESC [ RunTime:0.041891s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35568688 LIMIT 2 [ RunTime:0.005513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35568688 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='2106262' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.050264s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106262' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35568089 LIMIT 4 [ RunTime:0.078972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35568089 ORDER BY `minOrder` ASC [ RunTime:0.122510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35568089 ORDER BY `unit` DESC [ RunTime:0.253033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35568089 LIMIT 2 [ RunTime:0.078260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35568089 ORDER BY `minOrder` ASC [ RunTime:0.024597s ]
select * from pdf where partno='2107898' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.058449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107898' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.155518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35567753 LIMIT 4 [ RunTime:0.084658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35567753 ORDER BY `minOrder` ASC [ RunTime:0.070984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35567753 ORDER BY `unit` DESC [ RunTime:0.080088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35567753 LIMIT 2 [ RunTime:0.048181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35567753 ORDER BY `minOrder` ASC [ RunTime:0.033900s ]
select * from pdf where partno='2109107' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.036644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109107' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.057792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35567720 LIMIT 4 [ RunTime:0.033869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35567720 ORDER BY `minOrder` ASC [ RunTime:0.028514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35567720 ORDER BY `unit` DESC [ RunTime:0.096589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35567720 LIMIT 2 [ RunTime:0.016121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35567720 ORDER BY `minOrder` ASC [ RunTime:0.013870s ]
select * from pdf where partno='2106261' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106261' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35567513 LIMIT 4 [ RunTime:0.018679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35567513 ORDER BY `minOrder` ASC [ RunTime:0.103466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35567513 ORDER BY `unit` DESC [ RunTime:0.004540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35567513 LIMIT 2 [ RunTime:0.019405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35567513 ORDER BY `minOrder` ASC [ RunTime:0.072999s ]
select * from pdf where partno='21058' and brandshort='Belden Inc.' limit 1 [ RunTime:0.028713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21058' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.029828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35567138 LIMIT 4 [ RunTime:0.046939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35567138 ORDER BY `minOrder` ASC [ RunTime:0.047844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35567138 ORDER BY `unit` DESC [ RunTime:0.055755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35567138 LIMIT 2 [ RunTime:0.026909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35567138 ORDER BY `minOrder` ASC [ RunTime:0.017454s ]
select * from pdf where partno='21034851425' and brandshort='HARTING' limit 1 [ RunTime:0.022162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034851425' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.038083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35566904 LIMIT 4 [ RunTime:0.089192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35566904 ORDER BY `minOrder` ASC [ RunTime:0.059244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35566904 ORDER BY `unit` DESC [ RunTime:0.084992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35566904 LIMIT 2 [ RunTime:0.082099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35566904 ORDER BY `minOrder` ASC [ RunTime:0.025135s ]
select * from pdf where partno='2109202' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.058204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109202' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35566762 LIMIT 4 [ RunTime:0.064117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35566762 ORDER BY `minOrder` ASC [ RunTime:0.114796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35566762 ORDER BY `unit` DESC [ RunTime:0.109519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35566762 LIMIT 2 [ RunTime:0.159988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35566762 ORDER BY `minOrder` ASC [ RunTime:0.058051s ]
select * from pdf where partno='2106273' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.075045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106273' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.054982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35566694 LIMIT 4 [ RunTime:0.153753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35566694 ORDER BY `minOrder` ASC [ RunTime:0.073339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35566694 ORDER BY `unit` DESC [ RunTime:0.041399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35566694 LIMIT 2 [ RunTime:0.051050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35566694 ORDER BY `minOrder` ASC [ RunTime:0.116979s ]
select * from pdf where partno='2109198' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.051133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109198' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.029701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35565843 LIMIT 4 [ RunTime:0.078756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35565843 ORDER BY `minOrder` ASC [ RunTime:0.071067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35565843 ORDER BY `unit` DESC [ RunTime:0.143907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35565843 LIMIT 2 [ RunTime:0.078954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35565843 ORDER BY `minOrder` ASC [ RunTime:0.049305s ]
select * from pdf where partno='21035851425' and brandshort='HARTING' limit 1 [ RunTime:0.026486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035851425' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.027811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35565659 LIMIT 4 [ RunTime:0.024327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35565659 ORDER BY `minOrder` ASC [ RunTime:0.060875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35565659 ORDER BY `unit` DESC [ RunTime:0.122596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35565659 LIMIT 2 [ RunTime:0.014481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35565659 ORDER BY `minOrder` ASC [ RunTime:0.065219s ]
select * from pdf where partno='21034851420' and brandshort='HARTING' limit 1 [ RunTime:0.034836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034851420' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.060910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35565602 LIMIT 4 [ RunTime:0.197520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35565602 ORDER BY `minOrder` ASC [ RunTime:0.066020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35565602 ORDER BY `unit` DESC [ RunTime:0.083491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35565602 LIMIT 2 [ RunTime:0.083411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35565602 ORDER BY `minOrder` ASC [ RunTime:0.013073s ]
select * from pdf where partno='2107899' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.067785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107899' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.092455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35565351 LIMIT 4 [ RunTime:0.010201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35565351 ORDER BY `minOrder` ASC [ RunTime:0.077800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35565351 ORDER BY `unit` DESC [ RunTime:0.082163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35565351 LIMIT 2 [ RunTime:0.028689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35565351 ORDER BY `minOrder` ASC [ RunTime:0.013725s ]
select * from pdf where partno='2107874' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.023266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107874' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.038810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35565083 LIMIT 4 [ RunTime:0.034708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35565083 ORDER BY `minOrder` ASC [ RunTime:0.040280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35565083 ORDER BY `unit` DESC [ RunTime:0.029599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35565083 LIMIT 2 [ RunTime:0.020542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35565083 ORDER BY `minOrder` ASC [ RunTime:0.004737s ]
select * from pdf where partno='2106170' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106170' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35564917 LIMIT 4 [ RunTime:0.014878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35564917 ORDER BY `minOrder` ASC [ RunTime:0.033387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35564917 ORDER BY `unit` DESC [ RunTime:0.007829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35564917 LIMIT 2 [ RunTime:0.032277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35564917 ORDER BY `minOrder` ASC [ RunTime:0.008668s ]
select * from pdf where partno='2106167' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106167' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35564782 LIMIT 4 [ RunTime:0.020263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35564782 ORDER BY `minOrder` ASC [ RunTime:0.014651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35564782 ORDER BY `unit` DESC [ RunTime:0.013988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35564782 LIMIT 2 [ RunTime:0.012742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35564782 ORDER BY `minOrder` ASC [ RunTime:0.012865s ]
select * from pdf where partno='2106276' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106276' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35564720 LIMIT 4 [ RunTime:0.003807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35564720 ORDER BY `minOrder` ASC [ RunTime:0.003594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35564720 ORDER BY `unit` DESC [ RunTime:0.007068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35564720 LIMIT 2 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35564720 ORDER BY `minOrder` ASC [ RunTime:0.002071s ]
select * from pdf where partno='2106272' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106272' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35564460 LIMIT 4 [ RunTime:0.002862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35564460 ORDER BY `minOrder` ASC [ RunTime:0.001294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35564460 ORDER BY `unit` DESC [ RunTime:0.011778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35564460 LIMIT 2 [ RunTime:0.013799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35564460 ORDER BY `minOrder` ASC [ RunTime:0.000621s ]
select * from pdf where partno='21035851420' and brandshort='HARTING' limit 1 [ RunTime:0.008640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035851420' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35563936 LIMIT 4 [ RunTime:0.015333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563936 ORDER BY `minOrder` ASC [ RunTime:0.013571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35563936 ORDER BY `unit` DESC [ RunTime:0.009829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35563936 LIMIT 2 [ RunTime:0.016567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563936 ORDER BY `minOrder` ASC [ RunTime:0.011568s ]
select * from pdf where partno='21034853415' and brandshort='HARTING' limit 1 [ RunTime:0.007444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034853415' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.012622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35563883 LIMIT 4 [ RunTime:0.017602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563883 ORDER BY `minOrder` ASC [ RunTime:0.015500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35563883 ORDER BY `unit` DESC [ RunTime:0.020585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35563883 LIMIT 2 [ RunTime:0.031159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563883 ORDER BY `minOrder` ASC [ RunTime:0.014038s ]
select * from pdf where partno='21034851415' and brandshort='HARTING' limit 1 [ RunTime:0.000826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034851415' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.009257s ]
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.015429s ]