{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "g",
      "access_type": "ref",
      "possible_keys": ["ClusterID", "OrganisationID_Status"],
      "key": "ClusterID",
      "key_length": "2",
      "used_key_parts": ["OrganisationID"],
      "ref": ["const"],
      "rows": 1705,
      "filtered": 100
    },
    "table": {
      "table_name": "rf",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "Wache"],
      "key": "PRIMARY",
      "key_length": "2",
      "used_key_parts": ["ID"],
      "ref": ["func"],
      "rows": 1,
      "filtered": 1.80842042,
      "attached_condition": "trigcond(rf.OrganisationID = 22 and rf.`ID` = if(g.Funkruf = 0,g.StammFunkrufID,g.Funkruf))"
    },
    "table": {
      "table_name": "f",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "Status"],
      "key": "PRIMARY",
      "key_length": "2",
      "used_key_parts": ["ID"],
      "ref": ["func"],
      "rows": 1,
      "filtered": 1.742086291,
      "attached_condition": "trigcond(f.OrganisationID = 22 and f.`ID` = coalesce(rf.Fahrzeug,rf.Stammfahrzeug,g.FesteinbauFID))"
    },
    "table": {
      "table_name": "w",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "Ressource", "Shop", "Strassensperrung"],
      "key": "PRIMARY",
      "key_length": "2",
      "used_key_parts": ["ID"],
      "ref": ["func"],
      "rows": 1,
      "filtered": 1.334379911,
      "attached_condition": "trigcond(w.OrganisationID = 22 and w.`ID` = coalesce(rf.Wache,f.Wache,g.werkstatt))"
    },
    "table": {
      "table_name": "cv",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "DROP_INDEX_ID"],
      "key": "DROP_INDEX_ID",
      "key_length": "3",
      "used_key_parts": ["ID"],
      "ref": ["qmsystems.g.ClusterID"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "l",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "DROP_INDEX_ID"],
      "key": "DROP_INDEX_ID",
      "key_length": "3",
      "used_key_parts": ["ID"],
      "ref": ["qmsystems.g.Lieferant"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "anmKt",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "DROP_INDEX_ID"],
      "key": "DROP_INDEX_ID",
      "key_length": "3",
      "used_key_parts": ["ID"],
      "ref": ["qmsystems.g.checkID"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "erstIn",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "DROP_INDEX_ID"],
      "key": "DROP_INDEX_ID",
      "key_length": "3",
      "used_key_parts": ["ID"],
      "ref": ["qmsystems.g.initialeFkt"],
      "rows": 1,
      "filtered": 100
    },
    "block-nl-join": {
      "table": {
        "table_name": "b",
        "access_type": "ALL",
        "possible_keys": ["PRIMARY", "Hersteller"],
        "rows": 5482,
        "filtered": 100
      },
      "buffer_type": "flat",
      "buffer_size": "2048Kb",
      "join_type": "BNL",
      "attached_condition": "b.`ID` = g.BezeichnungID"
    },
    "table": {
      "table_name": "t",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "OrganisationID", "DROP_INDEX_ID"],
      "key": "DROP_INDEX_ID",
      "key_length": "3",
      "used_key_parts": ["ID"],
      "ref": ["qmsystems.b.GeraeteTyp"],
      "rows": 1,
      "filtered": 1.590909123,
      "attached_condition": "t.OrganisationID = 22"
    },
    "table": {
      "table_name": "h",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "DROP_INDEX_ID"],
      "key": "DROP_INDEX_ID",
      "key_length": "3",
      "used_key_parts": ["ID"],
      "ref": ["qmsystems.b.Hersteller"],
      "rows": 1,
      "filtered": 100
    },
    "subqueries": [
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 14,
            "table": {
              "table_name": "rdMPGGeraetZubehoerValues",
              "access_type": "ref",
              "possible_keys": ["Bezeichnung"],
              "key": "Bezeichnung",
              "key_length": "2",
              "used_key_parts": ["OrganisationID"],
              "ref": ["const"],
              "rows": 6,
              "filtered": 100,
              "attached_condition": "find_in_set(rdMPGGeraetZubehoerValues.`ID`,g.Komponenten)"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 13,
            "table": {
              "table_name": "rdMPGWartung",
              "access_type": "ref",
              "possible_keys": ["Geraet", "PersonalID"],
              "key": "Geraet",
              "key_length": "4",
              "used_key_parts": ["Geraet"],
              "ref": ["qmsystems.g.ID"],
              "rows": 4,
              "filtered": 27.97187424,
              "attached_condition": "rdMPGWartung.PersonalID = 0 and rdMPGWartung.Art = 'erweiterte Kontrollmaßnahmen'"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 12,
            "table": {
              "table_name": "rdMPGWartung",
              "access_type": "ref",
              "possible_keys": ["Geraet", "PersonalID"],
              "key": "Geraet",
              "key_length": "4",
              "used_key_parts": ["Geraet"],
              "ref": ["qmsystems.g.ID"],
              "rows": 4,
              "filtered": 27.97187424,
              "attached_condition": "rdMPGWartung.PersonalID = 0 and rdMPGWartung.Art = 'Wartung'"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 11,
            "table": {
              "table_name": "rdMPGWartung",
              "access_type": "ref",
              "possible_keys": ["Geraet", "PersonalID"],
              "key": "Geraet",
              "key_length": "4",
              "used_key_parts": ["Geraet"],
              "ref": ["qmsystems.g.ID"],
              "rows": 4,
              "filtered": 27.97187424,
              "attached_condition": "rdMPGWartung.PersonalID = 0 and rdMPGWartung.Art = 'MTK'"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 10,
            "table": {
              "table_name": "rdMPGWartung",
              "access_type": "ref",
              "possible_keys": ["Geraet", "PersonalID"],
              "key": "Geraet",
              "key_length": "4",
              "used_key_parts": ["Geraet"],
              "ref": ["qmsystems.g.ID"],
              "rows": 4,
              "filtered": 27.97187424,
              "attached_condition": "rdMPGWartung.PersonalID = 0 and rdMPGWartung.Art = 'STK'"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 9,
            "table": {
              "table_name": "rdWache",
              "access_type": "eq_ref",
              "possible_keys": ["PRIMARY"],
              "key": "PRIMARY",
              "key_length": "2",
              "used_key_parts": ["ID"],
              "ref": ["qmsystems.g.wartungsWerkstatt"],
              "rows": 1,
              "filtered": 100,
              "index_condition": "rdWache.`ID` = g.wartungsWerkstatt"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 8,
            "table": {
              "table_name": "rdWache",
              "access_type": "eq_ref",
              "possible_keys": ["PRIMARY"],
              "key": "PRIMARY",
              "key_length": "2",
              "used_key_parts": ["ID"],
              "ref": ["qmsystems.g.werkstatt"],
              "rows": 1,
              "filtered": 100,
              "index_condition": "rdWache.`ID` = g.werkstatt"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 7,
            "table": {
              "table_name": "rf",
              "access_type": "eq_ref",
              "possible_keys": ["PRIMARY"],
              "key": "PRIMARY",
              "key_length": "2",
              "used_key_parts": ["ID"],
              "ref": ["qmsystems.g.Funkruf"],
              "rows": 1,
              "filtered": 100,
              "index_condition": "rf.`ID` = g.Funkruf"
            },
            "table": {
              "table_name": "f",
              "access_type": "eq_ref",
              "possible_keys": ["PRIMARY"],
              "key": "PRIMARY",
              "key_length": "2",
              "used_key_parts": ["ID"],
              "ref": ["func"],
              "rows": 1,
              "filtered": 100,
              "index_condition": "f.`ID` = coalesce(rf.Fahrzeug,rf.Stammfahrzeug)"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 6,
            "table": {
              "table_name": "rdWache",
              "access_type": "eq_ref",
              "possible_keys": ["PRIMARY"],
              "key": "PRIMARY",
              "key_length": "2",
              "used_key_parts": ["ID"],
              "ref": ["qmsystems.g.stammWerkstatt"],
              "rows": 1,
              "filtered": 100,
              "index_condition": "rdWache.`ID` = g.stammWerkstatt"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 5,
            "table": {
              "table_name": "f",
              "access_type": "eq_ref",
              "possible_keys": ["PRIMARY"],
              "key": "PRIMARY",
              "key_length": "2",
              "used_key_parts": ["ID"],
              "ref": ["qmsystems.g.FesteinbauFID"],
              "rows": 1,
              "filtered": 100,
              "index_condition": "f.`ID` = g.FesteinbauFID"
            },
            "table": {
              "table_name": "rf",
              "access_type": "eq_ref",
              "possible_keys": ["Fahrzeug"],
              "key": "Fahrzeug",
              "key_length": "4",
              "used_key_parts": ["Fahrzeug"],
              "ref": ["qmsystems.f.ID"],
              "rows": 1,
              "filtered": 100,
              "attached_condition": "trigcond(f.`ID` = rf.Fahrzeug)"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 4,
            "table": {
              "table_name": "f",
              "access_type": "eq_ref",
              "possible_keys": ["PRIMARY"],
              "key": "PRIMARY",
              "key_length": "2",
              "used_key_parts": ["ID"],
              "ref": ["qmsystems.g.StammFesteinbauFID"],
              "rows": 1,
              "filtered": 100,
              "index_condition": "f.`ID` = g.StammFesteinbauFID"
            },
            "table": {
              "table_name": "rf",
              "access_type": "eq_ref",
              "possible_keys": ["Stammfahrzeug"],
              "key": "Stammfahrzeug",
              "key_length": "4",
              "used_key_parts": ["Stammfahrzeug"],
              "ref": ["qmsystems.f.ID"],
              "rows": 1,
              "filtered": 100,
              "attached_condition": "trigcond(f.`ID` = rf.Stammfahrzeug)"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 3,
            "table": {
              "table_name": "rf",
              "access_type": "eq_ref",
              "possible_keys": ["PRIMARY"],
              "key": "PRIMARY",
              "key_length": "2",
              "used_key_parts": ["ID"],
              "ref": ["qmsystems.g.StammFunkrufID"],
              "rows": 1,
              "filtered": 100,
              "index_condition": "rf.`ID` = g.StammFunkrufID"
            },
            "table": {
              "table_name": "f",
              "access_type": "eq_ref",
              "possible_keys": ["PRIMARY"],
              "key": "PRIMARY",
              "key_length": "2",
              "used_key_parts": ["ID"],
              "ref": ["func"],
              "rows": 1,
              "filtered": 100,
              "index_condition": "f.`ID` = coalesce(rf.Fahrzeug,rf.Stammfahrzeug)"
            }
          }
        }
      },
      {
        "expression_cache": {
          "state": "uninitialized",
          "query_block": {
            "select_id": 2,
            "table": {
              "table_name": "tblWebUser",
              "access_type": "eq_ref",
              "possible_keys": ["PRIMARY"],
              "key": "PRIMARY",
              "key_length": "4",
              "used_key_parts": ["ID"],
              "ref": ["qmsystems.g.delID"],
              "rows": 1,
              "filtered": 100
            }
          }
        }
      }
    ]
  }
}