SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001539s ]
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.001590s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002533s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000523s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001473s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000284s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001165s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000298s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001831s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.003472s ]
UPDATE `stock_search` SET `count` = 2776 , `updatetime` = '2026-06-08 08:13:57' WHERE `partno` = '210' [ RunTime:0.004283s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000207s ]
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.002307s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001598s ]
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.000361s ]
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 3960,20 [ RunTime:0.063788s ]
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 ('35522367','35521939','35521388','35521286','35521100','35520858','35520603','35520108','35519086','35518859','35518712','35517214','35516998','35513106','35513105','35512025','35511629','35511628','35508887','35507413') ORDER BY FIELD(s.id, 35522367,35521939,35521388,35521286,35521100,35520858,35520603,35520108,35519086,35518859,35518712,35517214,35516998,35513106,35513105,35512025,35511629,35511628,35508887,35507413) [ RunTime:0.005743s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35522367 LIMIT 4 [ RunTime:0.001654s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35522367 ORDER BY `minOrder` ASC [ RunTime:0.017545s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35522367 ORDER BY `unit` DESC [ RunTime:0.021405s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35522367 LIMIT 2 [ RunTime:0.009773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35522367 ORDER BY `minOrder` ASC [ RunTime:0.009457s ]
select * from pdf where partno='2107734' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015898s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107734' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35521939 LIMIT 4 [ RunTime:0.012389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35521939 ORDER BY `minOrder` ASC [ RunTime:0.019955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35521939 ORDER BY `unit` DESC [ RunTime:0.018674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35521939 LIMIT 2 [ RunTime:0.020320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35521939 ORDER BY `minOrder` ASC [ RunTime:0.002383s ]
select * from pdf where partno='21024545302' and brandshort='HARTING' limit 1 [ RunTime:0.041187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024545302' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.007955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35521388 LIMIT 4 [ RunTime:0.022014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35521388 ORDER BY `minOrder` ASC [ RunTime:0.050399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35521388 ORDER BY `unit` DESC [ RunTime:0.049795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35521388 LIMIT 2 [ RunTime:0.099102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35521388 ORDER BY `minOrder` ASC [ RunTime:0.020666s ]
select * from pdf where partno='21024545305' and brandshort='HARTING' limit 1 [ RunTime:0.019741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024545305' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35521286 LIMIT 4 [ RunTime:0.024704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35521286 ORDER BY `minOrder` ASC [ RunTime:0.037260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35521286 ORDER BY `unit` DESC [ RunTime:0.028944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35521286 LIMIT 2 [ RunTime:0.053581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35521286 ORDER BY `minOrder` ASC [ RunTime:0.015344s ]
select * from pdf where partno='21025544305' and brandshort='HARTING' limit 1 [ RunTime:0.037649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21025544305' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.068611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35521100 LIMIT 4 [ RunTime:0.036213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35521100 ORDER BY `minOrder` ASC [ RunTime:0.050635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35521100 ORDER BY `unit` DESC [ RunTime:0.033873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35521100 LIMIT 2 [ RunTime:0.042743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35521100 ORDER BY `minOrder` ASC [ RunTime:0.006296s ]
select * from pdf where partno='21024545301' and brandshort='HARTING' limit 1 [ RunTime:0.128489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024545301' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.027791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35520858 LIMIT 4 [ RunTime:0.022666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35520858 ORDER BY `minOrder` ASC [ RunTime:0.064517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35520858 ORDER BY `unit` DESC [ RunTime:0.065823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35520858 LIMIT 2 [ RunTime:0.020358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35520858 ORDER BY `minOrder` ASC [ RunTime:0.010989s ]
select * from pdf where partno='21024547301' and brandshort='HARTING' limit 1 [ RunTime:0.018783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024547301' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.040637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35520603 LIMIT 4 [ RunTime:0.048668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35520603 ORDER BY `minOrder` ASC [ RunTime:0.120825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35520603 ORDER BY `unit` DESC [ RunTime:0.118749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35520603 LIMIT 2 [ RunTime:0.101361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35520603 ORDER BY `minOrder` ASC [ RunTime:0.036071s ]
select * from pdf where partno='2107590' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.064213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107590' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35520108 LIMIT 4 [ RunTime:0.097861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35520108 ORDER BY `minOrder` ASC [ RunTime:0.055585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35520108 ORDER BY `unit` DESC [ RunTime:0.053033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35520108 LIMIT 2 [ RunTime:0.057334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35520108 ORDER BY `minOrder` ASC [ RunTime:0.084155s ]
select * from pdf where partno='21024545304' and brandshort='HARTING' limit 1 [ RunTime:0.051163s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024545304' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.057640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35519086 LIMIT 4 [ RunTime:0.110406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35519086 ORDER BY `minOrder` ASC [ RunTime:0.137444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35519086 ORDER BY `unit` DESC [ RunTime:0.093877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35519086 LIMIT 2 [ RunTime:0.102170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35519086 ORDER BY `minOrder` ASC [ RunTime:0.063178s ]
select * from pdf where partno='21025547302' and brandshort='HARTING' limit 1 [ RunTime:0.165766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21025547302' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.119209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35518859 LIMIT 4 [ RunTime:0.060909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35518859 ORDER BY `minOrder` ASC [ RunTime:0.095591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35518859 ORDER BY `unit` DESC [ RunTime:0.079294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35518859 LIMIT 2 [ RunTime:0.050758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35518859 ORDER BY `minOrder` ASC [ RunTime:0.041987s ]
select * from pdf where partno='2107545' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.041208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107545' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.122186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35518712 LIMIT 4 [ RunTime:0.143238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35518712 ORDER BY `minOrder` ASC [ RunTime:0.055279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35518712 ORDER BY `unit` DESC [ RunTime:0.094979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35518712 LIMIT 2 [ RunTime:0.031148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35518712 ORDER BY `minOrder` ASC [ RunTime:0.068114s ]
select * from pdf where partno='21033176510' and brandshort='HARTING' limit 1 [ RunTime:0.147699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033176510' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.060939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35517214 LIMIT 4 [ RunTime:0.047113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35517214 ORDER BY `minOrder` ASC [ RunTime:0.073025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35517214 ORDER BY `unit` DESC [ RunTime:0.128495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35517214 LIMIT 2 [ RunTime:0.053198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35517214 ORDER BY `minOrder` ASC [ RunTime:0.042988s ]
select * from pdf where partno='21034155402' and brandshort='HARTING' limit 1 [ RunTime:0.036809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034155402' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.051429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35516998 LIMIT 4 [ RunTime:0.057088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35516998 ORDER BY `minOrder` ASC [ RunTime:0.424276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35516998 ORDER BY `unit` DESC [ RunTime:0.050912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35516998 LIMIT 2 [ RunTime:0.070692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35516998 ORDER BY `minOrder` ASC [ RunTime:0.090783s ]
select * from pdf where partno='21033111410' and brandshort='HARTING' limit 1 [ RunTime:0.093472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033111410' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.077395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35513106 LIMIT 4 [ RunTime:0.115076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35513106 ORDER BY `minOrder` ASC [ RunTime:0.093430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35513106 ORDER BY `unit` DESC [ RunTime:0.064754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35513106 LIMIT 2 [ RunTime:0.032790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35513106 ORDER BY `minOrder` ASC [ RunTime:0.026173s ]
select * from pdf where partno='21011303233' and brandshort='HARTING' limit 1 [ RunTime:0.092341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011303233' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.051657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35513105 LIMIT 4 [ RunTime:0.087818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35513105 ORDER BY `minOrder` ASC [ RunTime:0.010425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35513105 ORDER BY `unit` DESC [ RunTime:0.028791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35513105 LIMIT 2 [ RunTime:0.027856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35513105 ORDER BY `minOrder` ASC [ RunTime:0.015601s ]
select * from pdf where partno='21011301223' and brandshort='HARTING' limit 1 [ RunTime:0.023748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011301223' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.015050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35512025 LIMIT 4 [ RunTime:0.009768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35512025 ORDER BY `minOrder` ASC [ RunTime:0.007376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35512025 ORDER BY `unit` DESC [ RunTime:0.007631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35512025 LIMIT 2 [ RunTime:0.001931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35512025 ORDER BY `minOrder` ASC [ RunTime:0.003114s ]
select * from pdf where partno='21035154402' and brandshort='HARTING' limit 1 [ RunTime:0.008749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035154402' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35511629 LIMIT 4 [ RunTime:0.020729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35511629 ORDER BY `minOrder` ASC [ RunTime:0.007019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35511629 ORDER BY `unit` DESC [ RunTime:0.008085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35511629 LIMIT 2 [ RunTime:0.025027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35511629 ORDER BY `minOrder` ASC [ RunTime:0.034678s ]
select * from pdf where partno='21011411323' and brandshort='HARTING' limit 1 [ RunTime:0.025409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011411323' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.066661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35511628 LIMIT 4 [ RunTime:0.115014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35511628 ORDER BY `minOrder` ASC [ RunTime:0.017169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35511628 ORDER BY `unit` DESC [ RunTime:0.006539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35511628 LIMIT 2 [ RunTime:0.007048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35511628 ORDER BY `minOrder` ASC [ RunTime:0.003323s ]
select * from pdf where partno='21011401323' and brandshort='HARTING' limit 1 [ RunTime:0.014474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011401323' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35508887 LIMIT 4 [ RunTime:0.011693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35508887 ORDER BY `minOrder` ASC [ RunTime:0.004425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35508887 ORDER BY `unit` DESC [ RunTime:0.010918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35508887 LIMIT 2 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35508887 ORDER BY `minOrder` ASC [ RunTime:0.001256s ]
select * from pdf where partno='21025547301' and brandshort='HARTING' limit 1 [ RunTime:0.010835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21025547301' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.011593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35507413 LIMIT 4 [ RunTime:0.003774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35507413 ORDER BY `minOrder` ASC [ RunTime:0.012175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35507413 ORDER BY `unit` DESC [ RunTime:0.002392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35507413 LIMIT 2 [ RunTime:0.002956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35507413 ORDER BY `minOrder` ASC [ RunTime:0.006992s ]
select * from pdf where partno='21025544301' and brandshort='HARTING' limit 1 [ RunTime:0.014201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21025544301' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010199s ]
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.106883s ]