3v4l.org

run code in 300+ PHP versions simultaneously
<?php $sql = sprintf("SELECT ul.user_id, u.nickname, u.avatar ,u.intro, u.gender, u.points, ul.lng, ul.lat, ul.car_no FROM user_location ul INNER JOIN user u ON ul.user_id=u.id GROUP BY ul.user_id WHERE geohash LIKE '%s%%'", 'x);

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

VersionSystem time (s)User time (s)Memory (MiB)
5.4.340.0060.04312.01
5.4.320.0100.04012.50
5.4.310.0080.04512.49
5.4.300.0060.04112.50
5.4.290.0080.04312.50
5.4.280.0070.04412.39
5.4.270.0090.04212.39
5.4.260.0130.05812.39
5.4.250.0080.03912.39
5.4.240.0080.03712.39
5.4.230.0040.04212.38
5.4.220.0100.04812.38
5.4.210.0090.04612.38
5.4.200.0080.04812.38
5.4.190.0040.04112.38
5.4.180.0060.03612.38
5.4.170.0060.03712.39
5.4.160.0050.03812.38
5.4.150.0030.04012.38
5.4.140.0060.03712.07
5.4.130.0080.03412.05
5.4.120.0070.03912.01
5.4.110.0050.03712.01
5.4.100.0040.03812.01
5.4.90.0070.03712.01
5.4.80.0070.03612.01
5.4.70.0080.03312.00
5.4.60.0050.04212.00
5.4.50.0070.03512.00
5.4.40.0040.03612.00
5.4.30.0110.03711.99
5.4.20.0060.03511.99
5.4.10.0120.04911.99
5.4.00.0040.04311.49
5.3.290.0110.03512.80
5.3.280.0050.04012.71
5.3.270.0060.04212.72
5.3.260.0070.04212.72
5.3.250.0100.03412.72
5.3.240.0060.03712.72
5.3.230.0050.04012.70
5.3.220.0050.03812.68
5.3.210.0040.04112.68
5.3.200.0090.07012.68
5.3.190.0100.05012.68
5.3.180.0090.05012.68
5.3.170.0090.04912.67
5.3.160.0100.04712.68
5.3.150.0100.04912.68
5.3.140.0080.04012.66
5.3.130.0050.04012.65
5.3.120.0080.03812.66
5.3.110.0050.03912.66
5.3.100.0060.03612.12
5.3.90.0060.03612.09
5.3.80.0050.03712.08
5.3.70.0060.03712.07
5.3.60.0040.03812.06
5.3.50.0080.03412.00
5.3.40.0060.03812.00
5.3.30.0050.03811.95
5.3.20.0100.03211.72
5.3.10.0050.03811.70
5.3.00.0070.03711.69
5.2.170.0100.0349.18
5.2.160.0050.0379.18
5.2.150.0080.0289.18
5.2.140.0050.0359.18
5.2.130.0060.0289.14
5.2.120.0090.0259.13
5.2.110.0030.0319.14
5.2.100.0070.0359.13
5.2.90.0030.0329.13
5.2.80.0030.0339.13
5.2.70.0030.0339.13
5.2.60.0080.0289.09
5.2.50.0020.0359.06
5.2.40.0050.0299.04
5.2.30.0050.0309.01
5.2.20.0050.0299.00
5.2.10.0060.0278.92
5.2.00.0010.0338.78
5.1.60.0040.0248.07
5.1.50.0020.0278.06
5.1.40.0050.0278.05
5.1.30.0060.0258.40
5.1.20.0050.0278.42
5.1.10.0030.0298.14
5.1.00.0040.0288.14
5.0.50.0030.0256.63
5.0.40.0020.0216.48
5.0.30.0050.0316.29
5.0.20.0030.0206.26
5.0.10.0020.0226.24
5.0.00.0070.0356.23
4.4.90.0030.0164.78
4.4.80.0030.0154.75
4.4.70.0030.0154.76
4.4.60.0010.0184.76
4.4.50.0030.0164.77
4.4.40.0030.0264.71
4.4.30.0040.0164.76
4.4.20.0020.0174.84
4.4.10.0020.0174.85
4.4.00.0040.0254.76
4.3.110.0020.0194.67
4.3.100.0050.0124.66
4.3.90.0040.0134.64
4.3.80.0010.0264.58
4.3.70.0030.0154.63
4.3.60.0040.0144.63
4.3.50.0020.0174.63
4.3.40.0030.0244.54
4.3.30.0040.0143.29
4.3.20.0020.0203.26
4.3.10.0010.0173.22
4.3.00.0170.0236.79

preferences:
140.01 ms | 1394 KiB | 7 Q