SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003396s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010282s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001709s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.219' ) [ RunTime:0.003089s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001670s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003517s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001250s ]
SELECT * FROM `stock_search` WHERE `partno` = 'G501' LIMIT 1 [ RunTime:0.003052s ]
UPDATE `stock_search` SET `count` = 13304 , `updatetime` = '2026-05-31 19:33:48' WHERE `partno` = 'G501' [ RunTime:0.010287s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.015663s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.003328s ]
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.013598s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001360s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'G501%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.004548s ]
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 'G501%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.016298s ]
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 ('24506363','24506362','24506361','24506360','24506359','24506389','24506364','13535021','24506390','14169021','25457476','25457444','24762089','24761174','24761173','24761160','24761147','24761146','21082944','21080655') ORDER BY FIELD(s.id, 24506363,24506362,24506361,24506360,24506359,24506389,24506364,13535021,24506390,14169021,25457476,25457444,24762089,24761174,24761173,24761160,24761147,24761146,21082944,21080655) [ RunTime:0.026562s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24506363 LIMIT 4 [ RunTime:0.003470s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506363 ORDER BY `minOrder` ASC [ RunTime:0.014235s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24506363 ORDER BY `unit` DESC [ RunTime:0.019126s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24506363 LIMIT 2 [ RunTime:0.006548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506363 ORDER BY `minOrder` ASC [ RunTime:0.007649s ]
select * from pdf where partno='G501-1020-01' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.006598s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1020-01' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.003507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24506362 LIMIT 4 [ RunTime:0.003374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506362 ORDER BY `minOrder` ASC [ RunTime:0.007862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24506362 ORDER BY `unit` DESC [ RunTime:0.016674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24506362 LIMIT 2 [ RunTime:0.009170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506362 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='G501-1020-12' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.004504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1020-12' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.029144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24506361 LIMIT 4 [ RunTime:0.015765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506361 ORDER BY `minOrder` ASC [ RunTime:0.029928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24506361 ORDER BY `unit` DESC [ RunTime:0.014033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24506361 LIMIT 2 [ RunTime:0.006692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506361 ORDER BY `minOrder` ASC [ RunTime:0.005028s ]
select * from pdf where partno='G501-1020-02' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.018515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1020-02' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.031022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24506360 LIMIT 4 [ RunTime:0.019782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506360 ORDER BY `minOrder` ASC [ RunTime:0.029501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24506360 ORDER BY `unit` DESC [ RunTime:0.035780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24506360 LIMIT 2 [ RunTime:0.029391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506360 ORDER BY `minOrder` ASC [ RunTime:0.013912s ]
select * from pdf where partno='G501-1020-00' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.021581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1020-00' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.006325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24506359 LIMIT 4 [ RunTime:0.027920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506359 ORDER BY `minOrder` ASC [ RunTime:0.006732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24506359 ORDER BY `unit` DESC [ RunTime:0.008758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24506359 LIMIT 2 [ RunTime:0.002907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506359 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
select * from pdf where partno='G501-1020-10' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.009592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1020-10' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.015467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24506389 LIMIT 4 [ RunTime:0.008836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506389 ORDER BY `minOrder` ASC [ RunTime:0.004159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24506389 ORDER BY `unit` DESC [ RunTime:0.002399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24506389 LIMIT 2 [ RunTime:0.005435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506389 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
select * from pdf where partno='G501-1025-10' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.004254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1025-10' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.005948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24506364 LIMIT 4 [ RunTime:0.015215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506364 ORDER BY `minOrder` ASC [ RunTime:0.011022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24506364 ORDER BY `unit` DESC [ RunTime:0.007913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24506364 LIMIT 2 [ RunTime:0.008580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506364 ORDER BY `minOrder` ASC [ RunTime:0.003776s ]
select * from pdf where partno='G501-1020-11' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.001870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1020-11' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.012348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13535021 LIMIT 4 [ RunTime:0.019596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13535021 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13535021 ORDER BY `unit` DESC [ RunTime:0.002874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13535021 LIMIT 2 [ RunTime:0.004301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13535021 ORDER BY `minOrder` ASC [ RunTime:0.001060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24506390 LIMIT 4 [ RunTime:0.009718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506390 ORDER BY `minOrder` ASC [ RunTime:0.007982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24506390 ORDER BY `unit` DESC [ RunTime:0.000925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24506390 LIMIT 2 [ RunTime:0.003430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24506390 ORDER BY `minOrder` ASC [ RunTime:0.006173s ]
select * from pdf where partno='G501-1025-12' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.006843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G501-1025-12' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.002337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14169021 LIMIT 4 [ RunTime:0.003265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14169021 ORDER BY `minOrder` ASC [ RunTime:0.005032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14169021 ORDER BY `unit` DESC [ RunTime:0.006420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14169021 LIMIT 2 [ RunTime:0.009287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14169021 ORDER BY `minOrder` ASC [ RunTime:0.001630s ]
select * from pdf where partno='G5015M05B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.005400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25457476 LIMIT 4 [ RunTime:0.002132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25457476 ORDER BY `minOrder` ASC [ RunTime:0.001595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25457476 ORDER BY `unit` DESC [ RunTime:0.002616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25457476 LIMIT 2 [ RunTime:0.004787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25457476 ORDER BY `minOrder` ASC [ RunTime:0.006759s ]
select * from pdf where partno='G50102206' and brandshort='Carlo Gavazzi Inc.' limit 1 [ RunTime:0.006218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G50102206' OR `brand` LIKE 'Carlo Gavazzi Inc.%' ) ) LIMIT 1 [ RunTime:0.005177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25457444 LIMIT 4 [ RunTime:0.020482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25457444 ORDER BY `minOrder` ASC [ RunTime:0.018722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25457444 ORDER BY `unit` DESC [ RunTime:0.008099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25457444 LIMIT 2 [ RunTime:0.002721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25457444 ORDER BY `minOrder` ASC [ RunTime:0.001077s ]
select * from pdf where partno='G50101106' and brandshort='Carlo Gavazzi Inc.' limit 1 [ RunTime:0.001454s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G50101106' OR `brand` LIKE 'Carlo Gavazzi Inc.%' ) ) LIMIT 1 [ RunTime:0.009691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24762089 LIMIT 4 [ RunTime:0.002415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24762089 ORDER BY `minOrder` ASC [ RunTime:0.016266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24762089 ORDER BY `unit` DESC [ RunTime:0.011575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24762089 LIMIT 2 [ RunTime:0.000983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24762089 ORDER BY `minOrder` ASC [ RunTime:0.002970s ]
select * from pdf where partno='G5012' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5012' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.014372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24761174 LIMIT 4 [ RunTime:0.010938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24761174 ORDER BY `minOrder` ASC [ RunTime:0.008968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24761174 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24761174 LIMIT 2 [ RunTime:0.014520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24761174 ORDER BY `minOrder` ASC [ RunTime:0.008423s ]
select * from pdf where partno='G5016' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.002031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5016' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.018326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24761173 LIMIT 4 [ RunTime:0.011210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24761173 ORDER BY `minOrder` ASC [ RunTime:0.005482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24761173 ORDER BY `unit` DESC [ RunTime:0.035279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24761173 LIMIT 2 [ RunTime:0.013489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24761173 ORDER BY `minOrder` ASC [ RunTime:0.003007s ]
select * from pdf where partno='G5015' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.020120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.005867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24761160 LIMIT 4 [ RunTime:0.001357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24761160 ORDER BY `minOrder` ASC [ RunTime:0.013349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24761160 ORDER BY `unit` DESC [ RunTime:0.015771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24761160 LIMIT 2 [ RunTime:0.016971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24761160 ORDER BY `minOrder` ASC [ RunTime:0.034312s ]
select * from pdf where partno='G5014' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.012900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5014' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.015042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24761147 LIMIT 4 [ RunTime:0.002096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24761147 ORDER BY `minOrder` ASC [ RunTime:0.000671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24761147 ORDER BY `unit` DESC [ RunTime:0.008271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24761147 LIMIT 2 [ RunTime:0.029576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24761147 ORDER BY `minOrder` ASC [ RunTime:0.015727s ]
select * from pdf where partno='G5011' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.003095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5011' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.002059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24761146 LIMIT 4 [ RunTime:0.003289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24761146 ORDER BY `minOrder` ASC [ RunTime:0.007950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24761146 ORDER BY `unit` DESC [ RunTime:0.032888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24761146 LIMIT 2 [ RunTime:0.042319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24761146 ORDER BY `minOrder` ASC [ RunTime:0.012865s ]
select * from pdf where partno='G5013' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5013' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.004482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21082944 LIMIT 4 [ RunTime:0.015046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21082944 ORDER BY `minOrder` ASC [ RunTime:0.013800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21082944 ORDER BY `unit` DESC [ RunTime:0.008800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21082944 LIMIT 2 [ RunTime:0.020358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21082944 ORDER BY `minOrder` ASC [ RunTime:0.018173s ]
select * from pdf where partno='G5015L12B1+6-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.000945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015L12B1+6-RSR' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.007435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21080655 LIMIT 4 [ RunTime:0.013595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21080655 ORDER BY `minOrder` ASC [ RunTime:0.032884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21080655 ORDER BY `unit` DESC [ RunTime:0.003941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21080655 LIMIT 2 [ RunTime:0.040124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21080655 ORDER BY `minOrder` ASC [ RunTime:0.004421s ]
select * from pdf where partno='G5015E12B-RSR-CC' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.005091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015E12B-RSR-CC' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.007611s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'G501%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.030353s ]