Small-Cap Value Discovery Guide: Hidden Gems in the Russell 2000 Index
Published on 2026-07-10 US Investment Picks
An in-depth analysis of US small-cap investment opportunities represented by the Russell 2000 Index, screening small-mid cap targets with excess return potential through valuation discount repair, M&A catalysts, and rate-cut beneficiaries.
SHOW FULL COLUMNS FROM `g3ys_config` [ RunTime:0.002444s ]
SELECT `value` FROM `g3ys_config` WHERE `name` = 'timezone' AND `subsite_id` = '51' LIMIT 1 [ RunTime:0.000753s ]
SHOW FULL COLUMNS FROM `g3ys_route` [ RunTime:0.002504s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000795s ]
SHOW FULL COLUMNS FROM `g3ys_theme` [ RunTime:0.002720s ]
SELECT `paginator` FROM `g3ys_theme` WHERE `module` = 'home' AND `name` = 'seadivicom' AND `subsite_id` = '51' LIMIT 1 [ RunTime:0.000778s ]
SHOW FULL COLUMNS FROM `g3ys_lang` [ RunTime:0.003346s ]
SELECT * FROM `g3ys_lang` WHERE `subsite_id` = 51 AND ( ( LOWER(name) = 'en-us' ) OR `subtag` = 'en-us' ) AND `status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001288s ]
SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.004181s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '51' LIMIT 1 [ RunTime:0.001025s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.004042s ]
SELECT `id`,`document_type` FROM `g3ys_document` WHERE `subsite_id` = 51 AND `name` = 'small-cap-value-discovery' AND `status` IN ('1','2') LIMIT 1 [ RunTime:0.001500s ]
SELECT * FROM `g3ys_document` WHERE ( `name` = '5467' OR `id` = '5467' ) AND `subsite_id` = 51 LIMIT 1 [ RunTime:0.003308s ]
SHOW TABLES LIKE 'g3ys_document_article' [ RunTime:0.002597s ]
SHOW FULL COLUMNS FROM `g3ys_document_article` [ RunTime:0.001798s ]
SELECT * FROM `g3ys_document_article` WHERE `document_id` = '5467' LIMIT 1 [ RunTime:0.000789s ]
SHOW FULL COLUMNS FROM `g3ys_total` [ RunTime:0.002078s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '5467' LIMIT 1 [ RunTime:0.000627s ]
SHOW TABLES LIKE 'g3ys_document_article_lang' [ RunTime:0.002277s ]
SHOW FULL COLUMNS FROM `g3ys_document_article_lang` [ RunTime:0.001958s ]
SELECT * FROM `g3ys_document_article_lang` WHERE `subsite_id` = '51' AND `lang` = 'en-us' AND `document_id` = '5467' [ RunTime:0.017739s ]
SHOW FULL COLUMNS FROM `g3ys_document_article_lang` [ RunTime:0.004114s ]
SHOW TABLES LIKE 'g3ys_category_lang' [ RunTime:0.004571s ]
SHOW FULL COLUMNS FROM `g3ys_category_lang` [ RunTime:0.003962s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '51' AND `category_id` = '2150' AND `lang` = 'en-us' LIMIT 1 [ RunTime:0.001140s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '5467' LIMIT 1 [ RunTime:0.001226s ]
UPDATE `g3ys_total` SET `view_total` = `view_total` + 1 WHERE `target_id` = '5467' [ RunTime:0.002792s ]
SHOW FULL COLUMNS FROM `g3ys_record` [ RunTime:0.007476s ]
SELECT `id` FROM `g3ys_record` WHERE `subsite_id` = '51' AND `type` = 'article' AND `url` = 'https://www.seadivi.com/small-cap-value-discovery' AND `create_time` >= 1791503418 AND ( `visitor_id` = '37e92d30953c2b3b491333e3b86a3a6d' OR `session_id` = 'd02fad1d0f0de3e424c45f6cd045c002' ) LIMIT 1 [ RunTime:0.002183s ]
SHOW FULL COLUMNS FROM `g3ys_comment` [ RunTime:0.006572s ]
SELECT COUNT(*) AS think_count FROM `g3ys_comment` WHERE `target_id` = '5467' AND `pid` = '0' [ RunTime:0.001458s ]
SELECT * FROM `g3ys_document` WHERE `category_id` = 2150 AND `subsite_id` = 51 AND `pid` = '0' AND `status` = '1' AND ( ( sort > 0) or ( sort = 0 and id < 5467) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.002752s ]
SELECT * FROM `g3ys_document` WHERE `category_id` = 2150 AND `subsite_id` = 51 AND `pid` = '5466' AND `status` = '1' ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.002050s ]
SELECT * FROM `g3ys_document_article_lang` WHERE `subsite_id` = '51' AND `lang` = 'en-us' AND `document_id` = '5466' [ RunTime:0.024039s ]
SELECT * FROM `g3ys_document` WHERE `category_id` = 2150 AND `subsite_id` = 51 AND `pid` = '5467' AND `status` = '1' AND `document_type` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.002434s ]
SELECT * FROM `g3ys_document` WHERE `category_id` = 2150 AND `subsite_id` = 51 AND `pid` = '0' AND `status` = '1' AND `document_type` = 0 AND ( ( sort>0 and sort <= 0 and id!=5467) or ( sort = 0 and id > 5467) ) ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.001830s ]
SELECT * FROM `g3ys_document_article_lang` WHERE `subsite_id` = '51' AND `lang` = 'en-us' AND `document_id` = '5468' [ RunTime:0.022849s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001682s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '51' AND `category_id` = '2151' AND `lang` = 'en-us' LIMIT 1 [ RunTime:0.001428s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '51' AND `category_id` = '2149' AND `lang` = 'en-us' LIMIT 1 [ RunTime:0.000843s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '51' AND `category_id` = '2148' AND `lang` = 'en-us' LIMIT 1 [ RunTime:0.000796s ]
SHOW FULL COLUMNS FROM `g3ys_ad_location` [ RunTime:0.003914s ]
SELECT * FROM `g3ys_ad_location` WHERE `name` = 'ad-detail-full' AND `subsite_id` = '51' AND `status` = 1 LIMIT 1 [ RunTime:0.001276s ]
SHOW FULL COLUMNS FROM `g3ys_ad` [ RunTime:0.007243s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '51' AND `ad_location_id` = '123' AND `status` = 1 AND `device` IN ('all','pc') AND ( `start_time` = 0 OR `start_time` <= 1791503478 ) AND ( `end_time` = 0 OR `end_time` >= 1791503478 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.003696s ]
SHOW FULL COLUMNS FROM `g3ys_ad_lang` [ RunTime:0.007485s ]
SELECT * FROM `g3ys_ad_lang` WHERE `ad_id` = 123 AND `subsite_id` = '51' AND `lang` = 'en-us' [ RunTime:0.001661s ]
SHOW FULL COLUMNS FROM `g3ys_ad_lang` [ RunTime:0.003547s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004286s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001007s ]
SELECT * FROM `g3ys_ad_location` WHERE `name` = 'ad-right' AND `subsite_id` = '51' AND `status` = 1 LIMIT 1 [ RunTime:0.001020s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '51' AND `ad_location_id` = '125' AND `status` = 1 AND `device` IN ('all','pc') AND ( `start_time` = 0 OR `start_time` <= 1791503478 ) AND ( `end_time` = 0 OR `end_time` >= 1791503478 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.001219s ]
SELECT * FROM `g3ys_ad_lang` WHERE `ad_id` = 125 AND `subsite_id` = '51' AND `lang` = 'en-us' [ RunTime:0.000967s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001508s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001022s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001085s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000985s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000861s ]
SHOW FULL COLUMNS FROM `g3ys_tags` [ RunTime:0.003936s ]
SELECT * FROM `g3ys_tags` WHERE `subsite_id` = 51 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 15 [ RunTime:0.001958s ]
SHOW FULL COLUMNS FROM `g3ys_tags_lang` [ RunTime:0.003326s ]
SELECT * FROM `g3ys_tags_lang` WHERE `tags_id` IN (694,692,689,687,684,682,681,679,678,676,675,673,671,669,668) AND `subsite_id` = 51 AND `lang` = 'en-us' [ RunTime:0.002773s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001228s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001230s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000891s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001137s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001021s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000945s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000882s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000944s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000916s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001748s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '51' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001615s ]