http://185.237.252.235:8080/en/vendors

id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 PRIMARY <derived2> ALL 2 100 Using temporary
2 DERIVED b0_ ALL PRIMARY, UNIQ_9FA05F8A6FC27B12, UNIQ_9FA05F8A32C8A3DE 2 50 Using where; Using temporary; Using filesort
2 DERIVED s2_ ref IDX_677B9B74F603EE73 IDX_677B9B74F603EE73 5 open_marketplace.b0_.id 6 10 Using where
2 DERIVED b3_ eq_ref PRIMARY PRIMARY 4 open_marketplace.b0_.vendor_address_id 1 100 Using index
2 DERIVED b4_ eq_ref PRIMARY PRIMARY 4 open_marketplace.b0_.organization_id 1 100 Using index
2 DERIVED s5_ ref PRIMARY, IDX_7E82D5E632C8A3DE IDX_7E82D5E632C8A3DE 5 open_marketplace.b0_.organization_id 1 100 Using index
2 DERIVED s1_ eq_ref UNIQ_7C2B74809395C3F3 UNIQ_7C2B74809395C3F3 4 open_marketplace.s5_.id 1 50 Using where