001- 反馈人：王凯
001+ 反馈人：王凯 数据库：zhcxkj_center_bi 查询时间：17.9256 执行次数: 331 扫描行数：38614.1 发送行数：1 指纹SQL: SELECT count ( ? ) FROM ( SELECT max ( report_date ) AS reportDate , source_id , child_asin FROM ? WHERE report_date >= '?' AND report_date <= '?' AND source_id = ? AND child_asin != '?' GROUP BY source_id , child_asin ) table_count ; 真实SQL：SELECT count(0) FROM (SELECT max(report_date) AS reportDate, source_id, child_asin FROM t_amz_sales_and_traffic_report_asin WHERE report_date >= '2024-02-13 00:00:00' AND report_date <= '2025-08-12 00:00:00' AND source_id = 16082 AND child_asin != '' GROUP BY source_id, child_asin) table_count; ##无人工修改## AISQL修改建议：SELECT COUNT(*) FROM t_amz_sales_and_traffic_report_asin WHERE report_date BETWEEN '2024-02-13 00:00:00' AND '2025-08-12 00:00:00' AND source_id = 16082 AND child_asin != '' GROUP BY source_id, child_asin HAVING MAX(report_date) = MAX(report_date); explain表：id
002- 数据库：zhcxkj_center_bi
002+ select_type
003- 查询时间：17.9256
003+ table
004- 执行次数: 331
004+ partitions
005- 扫描行数：38614.1
005+ type
006- 发送行数：1
006+ possible_keys
007- 指纹SQL: SELECT count ( ? ) FROM ( SELECT max ( report_date ) AS reportDate , source_id , child_asin FROM ? WHERE report_date >= '?' AND report_date <= '?' AND source_id = ? AND child_asin != '?' GROUP BY source_id , child_asin ) table_count ;
007+ key
008- 真实SQL：SELECT count(0) FROM (SELECT max(report_date) AS reportDate, source_id, child_asin FROM t_amz_sales_and_traffic_report_asin WHERE report_date >= '2024-02-13 00:00:00' AND report_date <= '2025-08-12 00:00:00' AND source_id = 16082 AND child_asin != '' GROUP BY source_id, child_asin) table_count;
008+ key_len
009- ##无人工修改##
009+ ref
010- AISQL修改建议：SELECT COUNT(*)
010+ rows
011- FROM t_amz_sales_and_traffic_report_asin
011+ filtered
012- WHERE report_date BETWEEN '2024-02-13 00:00:00' AND '2025-08-12 00:00:00'
012+ Extra
013- AND source_id = 16082
013+ 1
014- AND child_asin != ''
014+ PRIMARY
015- GROUP BY source_id, child_asin
015+ <derived2>
016- HAVING MAX(report_date) = MAX(report_date);
016+ None
017- explain表：
017+ ALL
018-
018+ None
019-
019+ None
020-
020+ None
021-
021+ None
022-
022+ 126577
023-
023+ 100
024-
024+ None
025-
025+ 2
026-
026+ DERIVED
027-
027+ t_amz_sales_and_traffic_report_asin
028-
028+ None
029- id
029+ range
030-
030+ uk_report_date_source_id_msku,uk_source_id_msku,idx_report_date_child_asin_source_id,idx_sourceid_updatetime
031-
031+ uk_source_id_msku
032- select_type
032+ 1027
033-
033+ None
034-
034+ 522223
035- table
035+ 50
036-
036+ Using index condition; Using where
037-
037+
038- partitions
038+ 额外建议： 索引建议： 取出表 【t_amz_sales_and_traffic_report_asin】 where条件字段 【report_date】 100000 条记录，重复的数据有：【93555】 条，没有必要为该字段创建索引。→ 【t_amz_sales_and_traffic_report_asin】表 【source_id,child_asin】字段，联合索引已经存在，无需添加任何索引。 【t_amz_sales_and_traffic_report_asin】表 【source_id,child_asin】字段，索引分析： +--------------------------------+--------------------------------+---------------+---------------+ | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY | +================================+================================+===============+===============+ | t_amz_sales_and_traffic_report | idx_report_date_child_asin_sou | child_asin | 84645720 | | _asin | rce_id | | | +--------------------------------+--------------------------------+---------------+---------------+ | t_amz_sales_and_traffic_report | idx_report_date_child_asin_sou | source_id | 262575776 | | _asin | rce_id | | | +--------------------------------+--------------------------------+---------------+---------------+ | t_amz_sales_and_traffic_report | idx_sourceid_updatetime | source_id | 447185 | | _asin | | | | +--------------------------------+--------------------------------+---------------+---------------+ | t_amz_sales_and_traffic_report | idx_update_time_source_id | source_id | 1188044 | | _asin | | | | +--------------------------------+--------------------------------+---------------+---------------+ | t_amz_sales_and_traffic_report | uk_report_date_source_id_msku | source_id | 3053827 | | _asin | | | | +--------------------------------+--------------------------------+---------------+---------------+ | t_amz_sales_and_traffic_report | uk_report_date_source_id_msku | child_asin | 262575776 | | _asin | | | | +--------------------------------+--------------------------------+---------------+---------------+ | t_amz_sales_and_traffic_report | uk_source_id_msku | source_id | 607146 | | _asin | | | | +--------------------------------+--------------------------------+---------------+---------------+ | t_amz_sales_and_traffic_report | uk_source_id_msku | child_asin | 66808268 | | _asin | | | | +--------------------------------+--------------------------------+---------------+---------------+
039-
040-
041- type
042-
043-
044- possible_keys
045-
046-
047- key
048-
049-
050- key_len
051-
052-
053- ref
054-
055-
056- rows
057-
058-
059- filtered
060-
061-
062- Extra
063-
064-
065-
066-
067-
068-
069- 1
070-
071-
072- PRIMARY
073-
074-
075- <derived2>
076-
077-
078- None
079-
080-
081- ALL
082-
083-
084- None
085-
086-
087- None
088-
089-
090- None
091-
092-
093- None
094-
095-
096- 126577
097-
098-
099- 100
100-
101-
102- None
103-
104-
105-
106-
107- 2
108-
109-
110- DERIVED
111-
112-
113- t_amz_sales_and_traffic_report_asin
114-
115-
116- None
117-
118-
119- range
120-
121-
122- uk_report_date_source_id_msku,uk_source_id_msku,idx_report_date_child_asin_source_id,idx_sourceid_updatetime
123-
124-
125- uk_source_id_msku
126-
127-
128- 1027
129-
130-
131- None
132-
133-
134- 522223
135-
136-
137- 50
138-
139-
140- Using index condition; Using where
141-
142-
143-
144-
145-
146- 额外建议：
147- 索引建议：
148- 取出表 【t_amz_sales_and_traffic_report_asin】 where条件字段 【report_date】 100000 条记录，重复的数据有：【93555】 条，没有必要为该字段创建索引。
149-
150- → 【t_amz_sales_and_traffic_report_asin】表 【source_id,child_asin】字段，联合索引已经存在，无需添加任何索引。
151-
152- 【t_amz_sales_and_traffic_report_asin】表 【source_id,child_asin】字段，索引分析：
153- +--------------------------------+--------------------------------+---------------+---------------+
154- | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |
155- +================================+================================+===============+===============+
156- | t_amz_sales_and_traffic_report | idx_report_date_child_asin_sou | child_asin | 84645720 |
157- | _asin | rce_id | | |
158- +--------------------------------+--------------------------------+---------------+---------------+
159- | t_amz_sales_and_traffic_report | idx_report_date_child_asin_sou | source_id | 262575776 |
160- | _asin | rce_id | | |
161- +--------------------------------+--------------------------------+---------------+---------------+
162- | t_amz_sales_and_traffic_report | idx_sourceid_updatetime | source_id | 447185 |
163- | _asin | | | |
164- +--------------------------------+--------------------------------+---------------+---------------+
165- | t_amz_sales_and_traffic_report | idx_update_time_source_id | source_id | 1188044 |
166- | _asin | | | |
167- +--------------------------------+--------------------------------+---------------+---------------+
168- | t_amz_sales_and_traffic_report | uk_report_date_source_id_msku | source_id | 3053827 |
169- | _asin | | | |
170- +--------------------------------+--------------------------------+---------------+---------------+
171- | t_amz_sales_and_traffic_report | uk_report_date_source_id_msku | child_asin | 262575776 |
172- | _asin | | | |
173- +--------------------------------+--------------------------------+---------------+---------------+
174- | t_amz_sales_and_traffic_report | uk_source_id_msku | source_id | 607146 |
175- | _asin | | | |
176- +--------------------------------+--------------------------------+---------------+---------------+
177- | t_amz_sales_and_traffic_report | uk_source_id_msku | child_asin | 66808268 |
178- | _asin | | | |
179- +--------------------------------+--------------------------------+---------------+---------------+
180-
181-

001- 反馈人：王凯<br />
001+ 反馈人：王凯<br /> 数据库：zhcxkj_center_bi<br /> 查询时间：17.9256<br /> 执行次数: 331<br /> 扫描行数：38614.1<br /> 发送行数：1<br /> 指纹SQL: SELECT count ( ? ) FROM ( SELECT max ( report_date ) AS reportDate , source_id , child_asin FROM ? WHERE report_date &gt;= '?' AND report_date &lt;= '?' AND source_id = ? AND child_asin != '?' GROUP BY source_id , child_asin ) table_count ;<br /> 真实SQL：SELECT count(0) FROM (SELECT max(report_date) AS reportDate, source_id, child_asin FROM t_amz_sales_and_traffic_report_asin WHERE report_date &gt;= '2024-02-13 00:00:00' AND report_date &lt;= '2025-08-12 00:00:00' AND source_id = 16082 AND child_asin != '' GROUP BY source_id, child_asin) table_count;<br /> ##无人工修改##<br /> AISQL修改建议：SELECT COUNT(*) <br /> FROM t_amz_sales_and_traffic_report_asin<br /> WHERE report_date BETWEEN '2024-02-13 00:00:00' AND '2025-08-12 00:00:00'<br /> AND source_id = 16082<br /> AND child_asin != ''<br /> GROUP BY source_id, child_asin<br /> HAVING MAX(report_date) = MAX(report_date);<br /> explain表：<br /><br /><br /><br /><br /><br /><br /><br /><table><tbody><tr><th>id</th>
002- 数据库：zhcxkj_center_bi<br />
002+ <th>select_type</th>
003- 查询时间：17.9256<br />
003+ <th>table</th>
004- 执行次数: 331<br />
004+ <th>partitions</th>
005- 扫描行数：38614.1<br />
005+ <th>type</th>
006- 发送行数：1<br />
006+ <th>possible_keys</th>
007- 指纹SQL: SELECT count ( ? ) FROM ( SELECT max ( report_date ) AS reportDate , source_id , child_asin FROM ? WHERE report_date &gt;= '?' AND report_date &lt;= '?' AND source_id = ? AND child_asin != '?' GROUP BY source_id , child_asin ) table_count ;<br />
007+ <th>key</th>
008- 真实SQL：SELECT count(0) FROM (SELECT max(report_date) AS reportDate, source_id, child_asin FROM t_amz_sales_and_traffic_report_asin WHERE report_date &gt;= '2024-02-13 00:00:00' AND report_date &lt;= '2025-08-12 00:00:00' AND source_id = 16082 AND child_asin != '' GROUP BY source_id, child_asin) table_count;<br />
008+ <th>key_len</th>
009- ##无人工修改##<br />
009+ <th>ref</th>
010- AISQL修改建议：SELECT COUNT(*) <br />
010+ <th>rows</th>
011- FROM t_amz_sales_and_traffic_report_asin<br />
011+ <th>filtered</th>
012- WHERE report_date BETWEEN '2024-02-13 00:00:00' AND '2025-08-12 00:00:00'<br />
012+ <th>Extra</th>
013- AND source_id = 16082<br />
013+ </tr></tbody><tbody><tr><td>1</td>
014- AND child_asin != ''<br />
014+ <td>PRIMARY</td>
015- GROUP BY source_id, child_asin<br />
015+ <td>&lt;derived2&gt;</td>
016- HAVING MAX(report_date) = MAX(report_date);<br />
016+ <td>None</td>
017- explain表：<br />
017+ <td>ALL</td>
018- <br />
018+ <td>None</td>
019- <br />
019+ <td>None</td>
020- <br />
020+ <td>None</td>
021- <br />
021+ <td>None</td>
022- <br />
022+ <td>126577</td>
023- <br />
023+ <td>100</td>
024- <br />
024+ <td>None</td>
025- <table>
025+ </tr><tr><td>2</td>
026- <tbody>
026+ <td>DERIVED</td>
027- <tr>
027+ <td>t_amz_sales_and_traffic_report_asin</td>
028- <th>
028+ <td>None</td>
029- id
029+ <td>range</td>
030- </th>
030+ <td>uk_report_date_source_id_msku,uk_source_id_msku,idx_report_date_child_asin_source_id,idx_sourceid_updatetime</td>
031- <th>
031+ <td>uk_source_id_msku</td>
032- select_type
032+ <td>1027</td>
033- </th>
033+ <td>None</td>
034- <th>
034+ <td>522223</td>
035- table
035+ <td>50</td>
036- </th>
036+ <td>Using index condition; Using where</td>
037- <th>
037+ </tr></tbody></table><br />
038- partitions
038+ 额外建议：<br /> 索引建议：<br /> 取出表 【t_amz_sales_and_traffic_report_asin】 where条件字段 【report_date】 100000 条记录，重复的数据有：【93555】 条，没有必要为该字段创建索引。<br /><br /><span style="color:#008000;font-weight:bold;">→ 【t_amz_sales_and_traffic_report_asin】表 【source_id,child_asin】字段，联合索引已经存在，无需添加任何索引。</span><br /><br /> 【t_amz_sales_and_traffic_report_asin】表 【source_id,child_asin】字段，索引分析：<br /> +--------------------------------+--------------------------------+---------------+---------------+<br /> | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |<br /> +================================+================================+===============+===============+<br /> | t_amz_sales_and_traffic_report | idx_report_date_child_asin_sou | child_asin | 84645720 |<br /> | _asin | rce_id | | |<br /> +--------------------------------+--------------------------------+---------------+---------------+<br /> | t_amz_sales_and_traffic_report | idx_report_date_child_asin_sou | source_id | 262575776 |<br /> | _asin | rce_id | | |<br /> +--------------------------------+--------------------------------+---------------+---------------+<br /> | t_amz_sales_and_traffic_report | idx_sourceid_updatetime | source_id | 447185 |<br /> | _asin | | | |<br /> +--------------------------------+--------------------------------+---------------+---------------+<br /> | t_amz_sales_and_traffic_report | idx_update_time_source_id | source_id | 1188044 |<br /> | _asin | | | |<br /> +--------------------------------+--------------------------------+---------------+---------------+<br /> | t_amz_sales_and_traffic_report | uk_report_date_source_id_msku | source_id | 3053827 |<br /> | _asin | | | |<br /> +--------------------------------+--------------------------------+---------------+---------------+<br /> | t_amz_sales_and_traffic_report | uk_report_date_source_id_msku | child_asin | 262575776 |<br /> | _asin | | | |<br /> +--------------------------------+--------------------------------+---------------+---------------+<br /> | t_amz_sales_and_traffic_report | uk_source_id_msku | source_id | 607146 |<br /> | _asin | | | |<br /> +--------------------------------+--------------------------------+---------------+---------------+<br /> | t_amz_sales_and_traffic_report | uk_source_id_msku | child_asin | 66808268 |<br /> | _asin | | | |<br /> +--------------------------------+--------------------------------+---------------+---------------+<br /><br /><br />
039- </th>
040- <th>
041- type
042- </th>
043- <th>
044- possible_keys
045- </th>
046- <th>
047- key
048- </th>
049- <th>
050- key_len
051- </th>
052- <th>
053- ref
054- </th>
055- <th>
056- rows
057- </th>
058- <th>
059- filtered
060- </th>
061- <th>
062- Extra
063- </th>
064- </tr>
065- </tbody>
066- <tbody>
067- <tr>
068- <td>
069- 1
070- </td>
071- <td>
072- PRIMARY
073- </td>
074- <td>
075- &lt;derived2&gt;
076- </td>
077- <td>
078- None
079- </td>
080- <td>
081- ALL
082- </td>
083- <td>
084- None
085- </td>
086- <td>
087- None
088- </td>
089- <td>
090- None
091- </td>
092- <td>
093- None
094- </td>
095- <td>
096- 126577
097- </td>
098- <td>
099- 100
100- </td>
101- <td>
102- None
103- </td>
104- </tr>
105- <tr>
106- <td>
107- 2
108- </td>
109- <td>
110- DERIVED
111- </td>
112- <td>
113- t_amz_sales_and_traffic_report_asin
114- </td>
115- <td>
116- None
117- </td>
118- <td>
119- range
120- </td>
121- <td>
122- uk_report_date_source_id_msku,uk_source_id_msku,idx_report_date_child_asin_source_id,idx_sourceid_updatetime
123- </td>
124- <td>
125- uk_source_id_msku
126- </td>
127- <td>
128- 1027
129- </td>
130- <td>
131- None
132- </td>
133- <td>
134- 522223
135- </td>
136- <td>
137- 50
138- </td>
139- <td>
140- Using index condition; Using where
141- </td>
142- </tr>
143- </tbody>
144- </table>
145- <br />
146- 额外建议：<br />
147- 索引建议：<br />
148- 取出表 【t_amz_sales_and_traffic_report_asin】 where条件字段 【report_date】 100000 条记录，重复的数据有：【93555】 条，没有必要为该字段创建索引。<br />
149- <br />
150- <span style="color:green;font-weight:bold;">→ 【t_amz_sales_and_traffic_report_asin】表 【source_id,child_asin】字段，联合索引已经存在，无需添加任何索引。</span><br />
151- <br />
152- 【t_amz_sales_and_traffic_report_asin】表 【source_id,child_asin】字段，索引分析：<br />
153- +--------------------------------+--------------------------------+---------------+---------------+<br />
154- | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |<br />
155- +================================+================================+===============+===============+<br />
156- | t_amz_sales_and_traffic_report | idx_report_date_child_asin_sou | child_asin | 84645720 |<br />
157- | _asin | rce_id | | |<br />
158- +--------------------------------+--------------------------------+---------------+---------------+<br />
159- | t_amz_sales_and_traffic_report | idx_report_date_child_asin_sou | source_id | 262575776 |<br />
160- | _asin | rce_id | | |<br />
161- +--------------------------------+--------------------------------+---------------+---------------+<br />
162- | t_amz_sales_and_traffic_report | idx_sourceid_updatetime | source_id | 447185 |<br />
163- | _asin | | | |<br />
164- +--------------------------------+--------------------------------+---------------+---------------+<br />
165- | t_amz_sales_and_traffic_report | idx_update_time_source_id | source_id | 1188044 |<br />
166- | _asin | | | |<br />
167- +--------------------------------+--------------------------------+---------------+---------------+<br />
168- | t_amz_sales_and_traffic_report | uk_report_date_source_id_msku | source_id | 3053827 |<br />
169- | _asin | | | |<br />
170- +--------------------------------+--------------------------------+---------------+---------------+<br />
171- | t_amz_sales_and_traffic_report | uk_report_date_source_id_msku | child_asin | 262575776 |<br />
172- | _asin | | | |<br />
173- +--------------------------------+--------------------------------+---------------+---------------+<br />
174- | t_amz_sales_and_traffic_report | uk_source_id_msku | source_id | 607146 |<br />
175- | _asin | | | |<br />
176- +--------------------------------+--------------------------------+---------------+---------------+<br />
177- | t_amz_sales_and_traffic_report | uk_source_id_msku | child_asin | 66808268 |<br />
178- | _asin | | | |<br />
179- +--------------------------------+--------------------------------+---------------+---------------+<br />
180- <br />
181- <br />