{
"query_block": {
"select_id": 1,
"filesort": {
"sort_key": "anfragen.anID",
"temporary_table": {
"table": {
"table_name": "anfragen",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"anProNeuwagen",
"anVerkaufsstatus",
"anQuelle",
"anDatum"
],
"key": "anDatum",
"key_length": "5",
"used_key_parts": ["anDatum"],
"rows": 295192,
"filtered": 15.0108242,
"index_condition": "anfragen.anDatum > <cache>(current_timestamp() + interval -90 day)",
"attached_condition": "anfragen.anProNeuwagen is null and anfragen.anVerkaufsstatus <> '0' and !<in_optimizer>(anfragen.anInteressentID,anfragen.anInteressentID in (subquery#5)) and (anfragen.anQuelle is null or anfragen.anQuelle = '')"
},
"duplicates_removal": {
"table": {
"table_name": "statistik_ref",
"access_type": "ref",
"possible_keys": ["reAnfrageID"],
"key": "reAnfrageID",
"key_length": "5",
"used_key_parts": ["reAnfrageID"],
"ref": ["meinauto.anfragen.anID"],
"rows": 1,
"filtered": 100,
"index_condition": "anfragen.anID = statistik_ref.reAnfrageID",
"attached_condition": "statistik_ref.reRef like '%'"
}
},
"table": {
"table_name": "mo",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["idModelle"],
"ref": ["meinauto.anfragen.anProdukt2ID"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(trigcond(anfragen.anProdukt2ID is not null))"
},
"table": {
"table_name": "ma",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["idMarken"],
"ref": ["meinauto.anfragen.anProdukt1ID"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(trigcond(anfragen.anProdukt1ID is not null))"
},
"table": {
"table_name": "abschluesse",
"access_type": "ref",
"possible_keys": ["abAnfrageID"],
"key": "abAnfrageID",
"key_length": "4",
"used_key_parts": ["abAnfrageID"],
"ref": ["meinauto.anfragen.anID"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(anfragen.anID = abschluesse.abAnfrageID)"
},
"table": {
"table_name": "statistik_ref",
"access_type": "ref",
"possible_keys": ["reAnfrageID"],
"key": "reAnfrageID",
"key_length": "5",
"used_key_parts": ["reAnfrageID"],
"ref": ["meinauto.anfragen.anID"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(anfragen.anID = statistik_ref.reAnfrageID)"
},
"table": {
"table_name": "vermittlungsauftraege",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["vaID"],
"ref": ["meinauto.abschluesse.abVermittlungsauftragID"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(trigcond(abschluesse.abVermittlungsauftragID is not null))"
},
"table": {
"table_name": "ak",
"access_type": "ref",
"possible_keys": ["akAnfrageID", "akAnfrageID_akAktion"],
"key": "akAnfrageID",
"key_length": "5",
"used_key_parts": ["akAnfrageID"],
"ref": ["meinauto.anfragen.anID"],
"rows": 9,
"filtered": 100,
"attached_condition": "trigcond(ak.akAnfrageID = anfragen.anID)",
"using_index": true
},
"table": {
"table_name": "<derived2>",
"access_type": "ref",
"possible_keys": ["key0"],
"key": "key0",
"key_length": "5",
"used_key_parts": ["modellid"],
"ref": ["meinauto.anfragen.anProdukt2ID"],
"rows": 10,
"filtered": 100,
"attached_condition": "trigcond(trigcond(anfragen.anProdukt2ID is not null))",
"materialized": {
"query_block": {
"select_id": 2,
"filesort": {
"sort_key": "sonderaktionen_neu.ModellId",
"temporary_table": {
"table": {
"table_name": "sonderaktionen_neu",
"access_type": "ALL",
"possible_keys": ["ModellId"],
"rows": 2369,
"filtered": 100
}
}
}
}
}
},
"block-nl-join": {
"table": {
"table_name": "vario",
"access_type": "ALL",
"rows": 928105,
"filtered": 100
},
"buffer_type": "flat",
"buffer_size": "768Kb",
"join_type": "BNL",
"attached_condition": "trigcond(meinauto_local.vario.inquiry_id = anfragen.anID)"
},
"subqueries": [
{
"query_block": {
"select_id": 5,
"table": {
"table_name": "interessenten",
"access_type": "ref",
"possible_keys": ["PRIMARY", "inEmail", "inEmail_inClient"],
"key": "inEmail",
"key_length": "203",
"used_key_parts": ["inEmail"],
"ref": ["const"],
"rows": 1258,
"filtered": 100,
"attached_condition": "interessenten.inEmail = 'testkauf@meinauto.de'",
"using_index": true
}
}
}
]
}
}
}
}
