Sandbox

SELECT 
  cscart_power_labels.label_id, 
  cscart_power_labels_products.type 
FROM 
  cscart_power_labels 
  LEFT JOIN cscart_power_labels_products ON cscart_power_labels_products.label_id = cscart_power_labels.label_id 
  AND cscart_power_labels_products.product_id = 101278 
WHERE 
  cscart_power_labels_products.type != ''

Query time 0.00030

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "Impossible WHERE noticed after reading const tables"
  }
}