SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.000909s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.149' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/category_615/1.html' [ RunTime:0.001687s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001141s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003058s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001448s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.149' ) [ RunTime:0.000427s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001219s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000388s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 615 [ RunTime:0.000333s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 615 LIMIT 1 [ RunTime:0.000261s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001286s ]
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` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '615' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001889s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5354 LIMIT 5 [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5354 ORDER BY `minOrder` ASC [ RunTime:0.001135s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5354 ORDER BY `unit` DESC [ RunTime:0.000534s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5354 LIMIT 2 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5354 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431AIDBZR,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.006020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2251 LIMIT 5 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2251 ORDER BY `minOrder` ASC [ RunTime:0.000726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2251 ORDER BY `unit` DESC [ RunTime:0.000553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2251 LIMIT 2 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2251 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='LD1117S33CTR' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.002320s ]
select foldpath,foldpath2,filename from pdf_file where id=533327 limit 1 [ RunTime:0.000546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LD1117S33CTR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10287 LIMIT 5 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10287 ORDER BY `minOrder` ASC [ RunTime:0.002708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10287 ORDER BY `unit` DESC [ RunTime:0.000628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10287 LIMIT 2 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10287 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NCP718ASN330T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.009902s ]
SELECT `id` FROM `stock` WHERE `id` <> 10287 AND `partno` = 'NCP718ASN330T1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.002311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14221561 [ RunTime:0.000977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5852 LIMIT 5 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5852 ORDER BY `minOrder` ASC [ RunTime:0.000707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5852 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5852 LIMIT 2 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5852 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L78M05CDT-TR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3548 LIMIT 5 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3548 ORDER BY `minOrder` ASC [ RunTime:0.002594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3548 ORDER BY `unit` DESC [ RunTime:0.000944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3548 LIMIT 2 [ RunTime:0.001261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3548 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A4403GEUTR-T' OR `brand` LIKE 'ALLEGRO MICROSYSTEMS%' ) ) LIMIT 1 [ RunTime:0.000879s ]
SELECT `id` FROM `stock` WHERE `id` <> 3548 AND `partno` = 'A4403GEUTR-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allegro microsystems%' ) [ RunTime:0.001373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16065858 [ RunTime:0.000703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7891 LIMIT 5 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7891 ORDER BY `minOrder` ASC [ RunTime:0.000848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7891 ORDER BY `unit` DESC [ RunTime:0.001495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7891 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7891 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIC5504-3.3YM5-TR' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.018561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2841 LIMIT 5 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2841 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2841 ORDER BY `unit` DESC [ RunTime:0.000313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2841 LIMIT 2 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2841 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC2117-3.3VDBTR' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.012195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14710 LIMIT 5 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14710 ORDER BY `minOrder` ASC [ RunTime:0.001171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14710 ORDER BY `unit` DESC [ RunTime:0.000526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14710 LIMIT 2 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14710 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='L7824CV' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.003233s ]
select foldpath,foldpath2,filename from pdf_file where id=375849 limit 1 [ RunTime:0.000608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L7824CV' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000530s ]
SELECT `id` FROM `stock` WHERE `id` <> 14710 AND `partno` = 'L7824CV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.000790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16048458 [ RunTime:0.000608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7677 LIMIT 5 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7677 ORDER BY `minOrder` ASC [ RunTime:0.000835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7677 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7677 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7677 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='TLE42744DV50ATMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.001109s ]
select foldpath,foldpath2,filename from pdf_file where id=1472930 limit 1 [ RunTime:0.000413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLE42744DV50ATMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.009727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5357 LIMIT 5 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5357 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5357 ORDER BY `unit` DESC [ RunTime:0.000362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5357 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5357 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BQDBZR,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.003370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4987 LIMIT 5 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4987 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4987 ORDER BY `unit` DESC [ RunTime:0.000479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4987 LIMIT 2 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4987 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NCV4274ADT50RKG' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.007039s ]
SELECT `id` FROM `stock` WHERE `id` <> 4987 AND `partno` = 'NCV4274ADT50RKG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16049458 [ RunTime:0.000542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5356 LIMIT 5 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5356 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5356 ORDER BY `unit` DESC [ RunTime:0.000324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5356 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5356 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BIDBZR,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.003356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1728 LIMIT 5 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1728 ORDER BY `minOrder` ASC [ RunTime:0.000629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1728 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1728 LIMIT 2 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1728 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L78M05ABDT-TR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7679 LIMIT 5 [ RunTime:0.000255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7679 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7679 ORDER BY `unit` DESC [ RunTime:0.000263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7679 LIMIT 2 [ RunTime:0.000251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7679 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
select * from pdf where partno='TLE4284DV50ATMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.001586s ]
select foldpath,foldpath2,filename from pdf_file where id=1472939 limit 1 [ RunTime:0.000237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLE4284DV50ATMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.005631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5851 LIMIT 5 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5851 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5851 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5851 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5851 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L78L05ABUTR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2753 LIMIT 5 [ RunTime:0.000295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2753 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2753 ORDER BY `unit` DESC [ RunTime:0.000270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2753 LIMIT 2 [ RunTime:0.000261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2753 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP1824T-ADJE/OT' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.010350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2247 LIMIT 5 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2247 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2247 ORDER BY `unit` DESC [ RunTime:0.000315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2247 LIMIT 2 [ RunTime:0.000263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2247 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='L78L05ABUTR' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.000988s ]
select foldpath,foldpath2,filename from pdf_file where id=126063 limit 1 [ RunTime:0.000393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L78L05ABUTR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12692 LIMIT 5 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12692 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12692 ORDER BY `unit` DESC [ RunTime:0.000481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12692 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12692 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLE4269GMXUMA2' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.005560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11210 LIMIT 5 [ RunTime:0.000270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11210 ORDER BY `minOrder` ASC [ RunTime:0.000707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11210 ORDER BY `unit` DESC [ RunTime:0.000467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11210 LIMIT 2 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11210 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLE4254GSXUMA4' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.005507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 278 LIMIT 5 [ RunTime:0.000250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 278 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 278 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 278 LIMIT 2 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 278 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L5970D' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000490s ]
SELECT `id` FROM `stock` WHERE `id` <> 278 AND `partno` = 'L5970D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.000958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16066358 [ RunTime:0.000425s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '615' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001427s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '615' ) LIMIT 203 ) tmp GROUP BY `brand` [ RunTime:0.001520s ]