3v4l.org

run code in 500+ PHP versions simultaneously
<?php $queries=" SELECT col1,col2,col3 FROM users WHERE id IN (1,2,3,4); SELECT * FROM references WHERE status = 1 ; SELECT a.col1 , a.col2 , b.col1 FROM table_a a | <--- Here is the caret, run this query INNER JOIN table_b b ON b.id_table_a = a.id WHERE a.id = 5 ; UPDATE table_a SET col1 = 'demo' WHERE id = 3; -- etc, etc, etc"; $rtrimmed=substr($queries,0,strpos($queries,'|')); // remove substr following pipe $ltrimmed=substr($rtrimmed,strrpos($rtrimmed,';')+1); // remove substr upto latest semicolon echo trim($ltrimmed); // remove whitespace on either side echo "\n---\n"; echo preg_match('~;\s*\K[^;|]*?(?= *\|)~',$queries,$out) ? $out[0] : '';

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.5.30.0110.00817.45
8.5.20.0040.00319.32
8.5.10.0090.00917.01
8.5.00.0130.00919.98
8.4.180.0140.00922.02
8.4.170.0110.01122.05
8.4.160.0100.01222.00
8.4.150.0060.00516.95
8.4.140.0140.00717.86
8.4.130.0060.01018.98
8.4.120.0120.00818.51
8.4.110.0120.00919.86
8.4.100.0140.00718.14
8.4.90.0110.01020.50
8.4.80.0080.00618.81
8.4.70.0050.00318.75
8.4.60.0070.00420.67
8.4.50.0100.01118.77
8.4.40.0090.00918.01
8.4.30.0090.00019.79
8.4.20.0070.01419.89
8.4.10.0030.00917.78
8.3.300.0150.00518.41
8.3.290.0090.01220.94
8.3.280.0100.01118.69
8.3.270.0100.00516.56
8.3.260.0110.00816.71
8.3.250.0110.00816.56
8.3.240.0090.00716.69
8.3.230.0110.00816.62
8.3.220.0130.00619.14
8.3.210.0120.00616.76
8.3.200.0050.00416.74
8.3.190.0090.01018.75
8.3.180.0130.00718.68
8.3.170.0090.00916.97
8.3.160.0000.00817.37
8.3.150.0100.01018.97
8.3.140.0090.00616.88
8.3.130.0050.00318.59
8.3.120.0070.00318.85
8.3.110.0050.00216.63
8.3.100.0040.01516.75
8.3.90.0030.00526.77
8.3.80.0030.00618.30
8.3.70.0100.00718.43
8.3.60.0120.00318.43
8.3.50.0080.00817.50
8.3.40.0130.00619.05
8.3.30.0140.00718.98
8.3.20.0070.00021.90
8.3.10.0040.00423.73
8.3.00.0030.00721.92
8.2.300.0110.01120.29
8.2.290.0080.00416.87
8.2.280.0130.00918.55
8.2.270.0150.00618.50
8.2.260.0070.01117.36
8.2.250.0080.00018.90
8.2.240.0060.00317.22
8.2.230.0070.00420.94
8.2.220.0050.00316.70
8.2.210.0000.00926.77
8.2.200.0030.00618.67
8.2.190.0070.00716.88
8.2.180.0120.00316.75
8.2.170.0100.01019.17
8.2.160.0140.00722.96
8.2.150.0050.00324.18
8.2.140.0040.00424.66
8.2.130.0070.00021.20
8.2.120.0070.01026.35
8.2.110.0090.00022.14
8.2.100.0110.00318.09
8.2.90.0000.00818.16
8.2.80.0040.00418.03
8.2.70.0080.00018.03
8.2.60.0030.00617.75
8.2.50.0080.00018.34
8.2.40.0000.00720.46
8.2.30.0040.00420.73
8.2.20.0060.00318.13
8.2.10.0060.00318.17
8.2.00.0000.00717.98
8.1.340.0110.01120.37
8.1.330.0130.00516.50
8.1.320.0120.00718.16
8.1.310.0090.00916.85
8.1.300.0130.00616.35
8.1.290.0030.00730.84
8.1.280.0100.01025.92
8.1.270.0000.00822.18
8.1.260.0080.00026.35
8.1.250.0040.00428.09
8.1.240.0030.00619.41
8.1.230.0070.00422.73
8.1.220.0030.00617.78
8.1.210.0080.00018.85
8.1.200.0080.00017.36
8.1.190.0000.01117.38
8.1.180.0000.00818.10
8.1.170.0030.00618.64
8.1.160.0040.00418.76
8.1.150.0050.00222.06
8.1.140.0030.00617.68
8.1.130.0000.00719.11
8.1.120.0000.00717.57
8.1.110.0020.00517.46
8.1.100.0040.00417.57
8.1.90.0040.00417.55
8.1.80.0040.00317.42
8.1.70.0070.00017.52
8.1.60.0030.00517.71
8.1.50.0100.00017.64
8.1.40.0050.00217.64
8.1.30.0060.00317.66
8.1.20.0040.00417.72
8.1.10.0040.00417.76
8.1.00.0000.00717.69
8.0.300.0070.00019.98
8.0.290.0060.00316.75
8.0.280.0040.00418.40
8.0.270.0000.00717.30
8.0.260.0030.00318.55
8.0.250.0000.00717.15
8.0.240.0000.00817.14
8.0.230.0040.00417.08
8.0.220.0030.00316.98
8.0.210.0040.00417.02
8.0.200.0000.00717.05
8.0.190.0050.00317.01
8.0.180.0040.00417.01
8.0.170.0000.00916.94
8.0.160.0040.00417.07
8.0.150.0000.00716.89
8.0.140.0030.00616.94
8.0.130.0040.00413.42
8.0.120.0060.00316.91
8.0.110.0000.00716.96
8.0.100.0070.00016.86
8.0.90.0080.00016.80
8.0.80.0080.00817.02
8.0.70.0040.00416.95
8.0.60.0030.00516.98
8.0.50.0000.00716.83
8.0.30.0080.01017.41
8.0.20.0150.01117.48
8.0.10.0070.00017.16
8.0.00.0060.01116.82
7.4.330.0000.00515.55
7.4.320.0070.00016.69
7.4.300.0030.00316.76
7.4.290.0070.00016.76
7.4.280.0000.00816.80
7.4.270.0030.00316.82
7.4.260.0080.00016.75
7.4.250.0030.00616.64
7.4.240.0030.00516.70
7.4.230.0030.00316.67
7.4.220.0050.00216.86
7.4.210.0090.01016.72
7.4.200.0040.00416.48
7.4.160.0060.01116.67
7.4.140.0120.01117.86
7.4.130.0140.00316.46
7.4.120.0110.00816.66
7.4.110.0080.00816.46
7.4.100.0070.01116.60
7.4.90.0140.00316.46
7.4.80.0190.00619.39
7.4.70.0070.01016.70
7.4.60.0090.00616.77
7.4.50.0030.01016.51
7.4.40.0100.00616.54
7.4.00.0030.01414.96
7.3.330.0060.00013.17
7.3.320.0030.00313.34
7.3.310.0030.00316.39
7.3.300.0000.00716.41
7.3.290.0000.00716.34
7.3.280.0090.00716.33
7.3.260.0080.01416.38
7.3.240.0090.00916.64
7.3.230.0110.00716.43
7.3.210.0060.01216.62
7.3.200.0090.00616.39
7.3.190.0090.00916.56
7.3.180.0110.00416.46
7.3.170.0060.01016.37
7.3.160.0030.01216.63
7.2.330.0070.01016.87
7.2.320.0160.00516.65
7.2.310.0080.00816.61
7.2.300.0100.00716.64
7.2.290.0130.00816.63
7.2.60.0040.00716.87
7.2.30.0090.01220.00
7.2.20.0080.01320.14
7.2.10.0100.00819.87
7.2.00.0070.01020.16
7.1.200.0100.00315.72
7.1.150.0050.01518.89
7.1.140.0060.01118.53
7.1.130.0080.00918.88
7.1.120.0110.00719.10
7.1.110.0070.00918.06
7.1.100.0100.01218.30
7.1.90.0100.01018.15
7.1.80.0110.01118.16
7.1.70.0070.01416.98
7.1.60.0270.01735.27
7.1.50.0300.01534.63
7.1.40.0300.01734.48
7.1.30.0230.01434.66
7.1.20.0300.01734.97
7.1.10.0070.01716.67
7.1.00.0090.01416.86

preferences:
45.27 ms | 1406 KiB | 5 Q