php - 编写这两个 SQL 查询的更好方法？

Question

它获取 url 的名称，找到 ID 并使用它来查找与此 ID 关联的产品。

有没有更好的写法？我说的更好是指性能。我不知道是否可以合并这两个查询以获得更好的性能。

$cname = mysql_real_escape_string($_GET["c"]);

$row = mysql_fetch_assoc(mysql_query("SELECT id FROM companies WHERE name = '$cname' LIMIT 1"));
$cID = $row['id'];

$products = mysql_query("SELECT name FROM products WHERE company_id = '$cID' " );
while($product = mysql_fetch_assoc($products)) {
                echo $product['name'].'<br>';
            }

Answer 1

SELECT c.id, p.name
FROM companies c
INNER JOIN products p ON p.company_id = c.id
WHERE c.name = '$cname'