php 如何更快,php – 如何使此查询运行得更快

我想知道这个查询是否可以更快地运行,或者如果可能的话如何使它更快.

$result = mysql_query("select

(select count(1) FROM videos WHERE title LIKE '%Cars%')as Cars,

(select count(1) FROM videos WHERE title LIKE '%Bikes%') as 'Bikes',

(select count(1) FROM videos WHERE title LIKE '%Airplanes%') as 'Airplanes',

(select count(1) FROM videos WHERE title LIKE '%Trucks%') as 'Trucks',

(select count(1) FROM videos WHERE title LIKE '%Games%') as 'Games'");

$row = mysql_fetch_assoc($result);

foreach($row as $title => $total)

{

echo '

'. $title.'  '. $total .'

';

}

echo '

A';

我制作了这个脚本的副本并将其粘贴100次,这样做之后加载速度非常慢.

解决方法:

像这样

select sum(title LIKE '%Cars%') as cars,

sum(title LIKE '%Bikes%') as bikes

from videos

标签：php,performance,mysql,count,select

来源： https://codeday.me/bug/20190830/1768163.html