For the same SQL statement, it takes only 0.03 seconds for navicat to be executed directly, but more than 5 seconds for php to execute multiple times. No significant changes have been made after apache and mysql are restarted. what may be the problem? $ SQL & quot; SELECTo. id, o. lng, o. lat, l. nameFROMlocationasoleftjoinlinuxaslono. idl. idWHERE ('lng '& gt; 123) AND ('lng' & lt; 124) AND ('lat' & gt; 23) AND ('phpsql
For the same SQL statement, it takes only 0.03 seconds for navicat to be executed directly, but more than 5 seconds for php to execute multiple times.
No significant changes have been made after apache and mysql are restarted. what may be the problem?
$ SQL = "SELECT o. id, o. lng, o. lat, l. name FROM location as o left join linux as l on o. id = l. id WHERE ((Lng> 123) AND (Lng<124) AND ((Lat> 23) AND (Lat<24 ))"