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'); echo $sql;

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)
8.3.60.0090.00918.43
8.3.50.0150.00721.03
8.3.40.0110.00418.68
8.3.30.0030.01018.79
8.3.20.0040.00420.21
8.3.10.0050.00323.66
8.3.00.0080.00019.25
8.2.180.0110.00716.63
8.2.170.0140.00418.68
8.2.160.0130.00022.96
8.2.150.0040.00424.18
8.2.140.0070.00324.66
8.2.130.0070.00026.16
8.2.120.0050.00222.10
8.2.110.0090.00019.18
8.2.100.0040.00717.78
8.2.90.0040.00419.09
8.2.80.0000.00817.97
8.2.70.0060.00317.50
8.2.60.0070.00017.92
8.2.50.0050.00318.10
8.2.40.0000.00817.92
8.2.30.0040.00418.16
8.2.20.0000.00717.59
8.2.10.0050.00318.05
8.2.00.0050.00317.57
8.1.280.0110.00425.92
8.1.270.0040.00423.79
8.1.260.0040.00426.35
8.1.250.0070.00028.09
8.1.240.0040.00419.44
8.1.230.0110.00017.82
8.1.220.0090.00017.74
8.1.210.0040.00418.77
8.1.200.0060.00317.35
8.1.190.0090.00017.22
8.1.180.0060.00318.10
8.1.170.0030.00618.47
8.1.160.0000.00721.89
8.1.150.0040.00418.73
8.1.140.0040.00417.33
8.1.130.0040.00417.89
8.1.120.0000.00717.43
8.1.110.0080.00017.38
8.1.100.0050.00217.37
8.1.90.0000.00817.28
8.1.80.0000.00817.39
8.1.70.0030.00317.40
8.1.60.0000.00817.50
8.1.50.0000.00817.50
8.1.40.0060.00317.48
8.1.30.0050.00317.60
8.1.20.0000.00717.60
8.1.10.0000.00717.39
8.1.00.0000.00717.45
8.0.300.0070.00318.77
8.0.290.0040.00416.58
8.0.280.0000.00718.43
8.0.270.0000.00717.14
8.0.260.0080.00017.25
8.0.250.0050.00216.92
8.0.240.0040.00416.97
8.0.230.0030.00516.95
8.0.220.0050.00216.80
8.0.210.0030.00316.85
8.0.200.0020.00516.88
8.0.190.0040.00416.84
8.0.180.0070.00016.72
8.0.170.0030.00516.84
8.0.160.0030.00516.92
8.0.150.0100.00016.62
8.0.140.0000.00916.70
8.0.130.0050.00013.23
8.0.120.0050.00316.80
8.0.110.0030.00316.68
8.0.100.0030.00516.83
8.0.90.0040.00316.76
8.0.80.0030.01316.86
8.0.70.0000.00716.77
8.0.60.0070.00016.65
8.0.50.0050.00316.84
8.0.30.0100.01016.96
8.0.20.0110.00917.40
8.0.10.0000.00817.00
8.0.00.0080.01016.72
7.4.330.0000.00515.02
7.4.320.0030.00316.55
7.4.300.0030.00316.45
7.4.290.0000.00716.35
7.4.280.0060.00316.35
7.4.270.0000.00616.41
7.4.260.0050.00316.48
7.4.250.0000.00816.49
7.4.240.0040.00416.48
7.4.230.0070.00016.26
7.4.220.0030.01316.62
7.4.210.0100.00316.53
7.4.200.0030.00316.18
7.4.160.0100.01016.55
7.4.150.0070.01117.40
7.4.140.0110.00817.86
7.4.130.0110.00816.45
7.4.120.0100.01016.48
7.4.110.0040.01216.63
7.4.100.0120.00416.44
7.4.90.0120.00416.49
7.4.80.0030.01419.39
7.4.70.0090.01216.38
7.4.60.0120.00316.48
7.4.50.0030.00616.18
7.4.40.0030.01316.30
7.4.30.0050.01116.47
7.4.00.0030.01015.07
7.3.330.0000.00513.13
7.3.320.0080.00012.95
7.3.310.0000.00716.04
7.3.300.0030.00316.19
7.3.290.0100.00616.20
7.3.280.0130.00716.14
7.3.270.0140.00717.40
7.3.260.0160.00916.23
7.3.250.0130.00316.30
7.3.240.0070.01116.26
7.3.230.0130.00416.48
7.3.210.0120.00316.25
7.3.200.0100.00619.39
7.3.190.0120.00616.49
7.3.180.0040.01116.23
7.3.170.0120.00916.29
7.3.160.0130.00316.32
7.3.10.0030.01016.54
7.3.00.0070.00716.41
7.2.330.0060.01016.54
7.2.320.0100.00716.65
7.2.310.0130.00316.42
7.2.300.0030.01616.31
7.2.290.0100.01016.60
7.2.130.0030.01016.97
7.2.120.0110.00416.75
7.2.110.0070.00716.78
7.2.100.0000.01416.67
7.2.90.0030.01216.67
7.2.80.0030.01016.91
7.2.70.0120.00316.65
7.2.60.0050.00816.65
7.2.50.0040.00416.93
7.2.40.0110.00016.64
7.2.30.0000.00916.71
7.2.20.0090.00616.92
7.2.10.0060.00916.47
7.2.00.0050.00918.13
7.1.250.0040.01115.70
7.1.200.0080.00015.41
7.1.100.0000.01118.37
7.1.70.0050.00216.87
7.1.60.0070.01819.19
7.1.50.0170.02034.76
7.1.00.0070.07022.36
7.0.200.0030.00616.75
7.0.140.0070.07022.04
7.0.60.0200.04720.03
7.0.50.0130.07317.77
7.0.40.0030.05020.21
7.0.30.0270.08020.02
7.0.20.0370.07020.17
7.0.10.0070.04020.04
7.0.00.0070.07320.00
5.6.280.0070.07020.90
5.6.210.0170.08020.55
5.6.200.0070.03718.21
5.6.190.0070.04020.42
5.6.180.0070.05720.61
5.6.170.0430.07320.50
5.6.160.0030.08720.34
5.6.150.0070.08718.23
5.6.140.0000.08318.11
5.6.130.0100.07318.21
5.6.120.0030.05020.98
5.6.110.0000.08721.02
5.6.100.0000.04321.02
5.6.90.0030.08720.96
5.6.80.0030.04020.41
5.6.70.4330.04320.49
5.5.350.0230.08020.34
5.5.340.0070.05317.91
5.5.330.0070.06020.42
5.5.320.0330.07320.29
5.5.310.0300.05020.29
5.5.300.0030.08718.02
5.5.290.0130.07718.02
5.5.280.0100.06720.86
5.5.270.0070.06320.88
5.5.260.0100.07320.71
5.5.250.0100.05320.66
5.5.240.0330.06320.23
5.4.450.0500.06319.28
5.4.440.0300.06019.61
5.4.430.0570.05719.44
5.4.420.0800.04019.60
5.4.410.0070.06019.17
5.4.400.0700.05319.29
5.4.390.0570.07319.16
5.4.380.0600.05319.13
5.4.370.0170.04318.78
5.4.360.0700.04719.31
5.4.350.0700.05319.00
5.4.340.0070.03411.96
5.4.320.0060.05112.45
5.4.310.0060.03812.45
5.4.300.0130.04312.45
5.4.290.0060.03812.45
5.4.280.0050.03712.34
5.4.270.0050.03812.34
5.4.260.0070.03712.35
5.4.250.0060.03612.35
5.4.240.0060.03512.34
5.4.230.0080.03512.34
5.4.220.0060.03912.34
5.4.210.0050.03712.34
5.4.200.0070.04912.34
5.4.190.0090.03912.33
5.4.180.0070.03812.33
5.4.170.0040.03912.35
5.4.160.0070.03612.34
5.4.150.0090.04612.34
5.4.140.0110.04812.02
5.4.130.0040.04012.01
5.4.120.0070.03511.97
5.4.110.0040.03711.96
5.4.100.0050.03611.96
5.4.90.0040.03911.96
5.4.80.0060.03611.97
5.4.70.0040.03811.96
5.4.60.0070.05011.96
5.4.50.0070.04811.96
5.4.40.0060.03711.95
5.4.30.0060.03711.95
5.4.20.0090.04011.95
5.4.10.0050.03711.95
5.4.00.0060.04111.44
5.3.290.0060.05612.80
5.3.280.0090.03912.71
5.3.270.0070.04212.72
5.3.260.0080.03812.71
5.3.250.0040.04012.72
5.3.240.0050.04212.72
5.3.230.0100.04512.71
5.3.220.0110.05312.68
5.3.210.0070.04412.68
5.3.200.0090.04812.68
5.3.190.0090.05112.68
5.3.180.0060.03912.67
5.3.170.0080.03612.66
5.3.160.0060.03712.67
5.3.150.0040.03912.68
5.3.140.0030.03912.66
5.3.130.0080.03712.66
5.3.120.0050.04012.66
5.3.110.0060.03912.66
5.3.100.0060.04312.12
5.3.90.0060.03612.08
5.3.80.0060.04712.08
5.3.70.0050.03812.07
5.3.60.0020.04112.06
5.3.50.0090.03812.00
5.3.40.0060.03712.00
5.3.30.0040.03911.94
5.3.20.0070.03411.71
5.3.10.0050.03911.69
5.3.00.0060.04211.68
5.2.170.0050.0319.18
5.2.160.0060.0299.18
5.2.150.0070.0309.18
5.2.140.0050.0319.17
5.2.130.0030.0329.14
5.2.120.0040.0329.13
5.2.110.0070.0289.14
5.2.100.0060.0429.14
5.2.90.0090.0269.13
5.2.80.0040.0319.13
5.2.70.0040.0399.13
5.2.60.0030.0319.09
5.2.50.0050.0339.05
5.2.40.0070.0339.03
5.2.30.0050.0349.00
5.2.20.0060.0339.01
5.2.10.0020.0368.91
5.2.00.0080.0408.77
5.1.60.0030.0258.06
5.1.50.0050.0258.05
5.1.40.0050.0258.04
5.1.30.0100.0308.39
5.1.20.0090.0238.41
5.1.10.0050.0268.13
5.1.00.0070.0248.13
5.0.50.0020.0236.61
5.0.40.0020.0216.47
5.0.30.0030.0326.28
5.0.20.0040.0196.26
5.0.10.0050.0256.23
5.0.00.0020.0346.23
4.4.90.0010.0184.78
4.4.80.0050.0144.76
4.4.70.0040.0154.76
4.4.60.0070.0164.76
4.4.50.0080.0354.77
4.4.40.0110.0504.71
4.4.30.0070.0214.75
4.4.20.0030.0214.85
4.4.10.0060.0184.85
4.4.00.0020.0264.76
4.3.110.0030.0154.66
4.3.100.0030.0164.67
4.3.90.0050.0134.64
4.3.80.0040.0244.59
4.3.70.0030.0154.63
4.3.60.0030.0154.63
4.3.50.0020.0174.63
4.3.40.0030.0244.54
4.3.30.0000.0183.28
4.3.20.0010.0193.25
4.3.10.0040.0173.22
4.3.00.0100.0236.68

preferences:
50.45 ms | 401 KiB | 5 Q