https://emmaconnect.fr/robots.txt

id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 PRIMARY cat index PRIMARY name 194 1 100 Using index; Using temporary; Using filesort
1 PRIMARY cat index PRIMARY name 194 1 100 Using index; Using join buffer (hash join)
1 PRIMARY sch eq_ref PRIMARY, catalog_id catalog_id 202 mysql.cat.id, const 1 100 Using index
1 PRIMARY sch eq_ref PRIMARY, catalog_id catalog_id 202 mysql.cat.id, const 1 100 Using index
1 PRIMARY tbl eq_ref schema_id schema_id 202 mysql.sch.id, const 1 100 Rematerialize (<derived3>)
1 PRIMARY fk ref schema_id, table_id schema_id 8 mysql.sch.id 551 100
1 PRIMARY tbl eq_ref PRIMARY PRIMARY 8 mysql.fk.table_id 1 10 Using where
1 PRIMARY <derived3> ref <auto_key0> <auto_key0> 195 func 2 100 Using where
1 PRIMARY col eq_ref PRIMARY PRIMARY 8 constraints.column_id 1 100 Using where
3 DEPENDENT DERIVED Impossible WHERE
4 DEPENDENT UNION fk ref PRIMARY, table_id table_id 8 mysql.tbl.id 2 100
4 DEPENDENT UNION fkcu ref PRIMARY, foreign_key_id PRIMARY 8 mysql.fk.id 1 100