3v4l.org

run code in 300+ PHP versions simultaneously
<?php function getListTableForeignKeysSQL($table, $database = null) { $sql = "SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, ". "k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ ". "FROM information_schema.key_column_usage k /*!50116 ". "INNER JOIN information_schema.referential_constraints c ON ". " c.constraint_name = k.constraint_name AND ". " c.table_name = '$table' */ WHERE k.table_name = '$table'"; $databaseNameSql = null === $database ? "'$database'" : 'DATABASE()'; $sql .= " AND k.table_schema = $databaseNameSql /*!50116 AND c.constraint_schema = $databaseNameSql */"; $sql .= " AND k.`REFERENCED_COLUMN_NAME` is not NULL"; return $sql; } echo getListTableForeignKeysSQL('AreaLayoutsUsingPresets'). "\n"; echo getListTableForeignKeysSQL('AreaLayoutsUsingPresets', 'concrete5db'). "\n";

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.0150.00616.50
8.3.50.0170.00521.20
8.3.40.0140.00318.51
8.3.30.0100.00318.67
8.3.20.0000.00720.29
8.3.10.0040.00423.61
8.3.00.0040.00419.44
8.2.180.0180.00316.50
8.2.170.0120.00322.96
8.2.160.0030.01019.51
8.2.150.0000.00724.18
8.2.140.0080.00024.66
8.2.130.0080.00026.16
8.2.120.0000.00817.50
8.2.110.0030.00721.04
8.2.100.0080.00317.78
8.2.90.0000.00820.07
8.2.80.0090.00018.22
8.2.70.0050.00317.91
8.2.60.0000.00817.93
8.2.50.0040.00718.10
8.2.40.0050.00320.54
8.2.30.0050.00219.43
8.2.20.0040.00417.82
8.2.10.0000.00918.19
8.2.00.0050.00218.01
8.1.280.0140.00425.92
8.1.270.0060.01320.32
8.1.260.0080.00026.35
8.1.250.0040.00428.09
8.1.240.0070.00319.21
8.1.230.0040.00822.13
8.1.220.0080.00017.91
8.1.210.0030.00618.77
8.1.200.0000.00817.23
8.1.190.0000.00917.35
8.1.180.0000.00818.10
8.1.170.0060.00318.57
8.1.160.0030.00322.06
8.1.150.0050.00318.69
8.1.140.0050.00317.45
8.1.130.0000.00717.62
8.1.120.0070.00017.48
8.1.110.0040.00417.39
8.1.100.0050.00317.48
8.1.90.0040.00417.41
8.1.80.0030.00517.48
8.1.70.0000.00717.31
8.1.60.0030.00617.63
8.1.50.0040.00417.54
8.1.40.0000.00817.50
8.1.30.0030.00517.64
8.1.20.0080.00017.64
8.1.10.0040.00417.47
8.1.00.0040.00417.43
8.0.300.0040.00420.02
8.0.290.0060.00316.88
8.0.280.0030.00518.45
8.0.270.0000.00717.17
8.0.260.0000.00717.26
8.0.250.0030.00516.88
8.0.240.0030.00316.96
8.0.230.0000.00716.83
8.0.220.0040.00416.94
8.0.210.0030.00316.94
8.0.200.0000.00616.93
8.0.190.0070.00017.05
8.0.180.0050.00316.95
8.0.170.0030.00516.94
8.0.160.0030.00316.96
8.0.150.0050.00216.74
8.0.140.0000.00716.83
8.0.130.0030.00313.37
8.0.120.0050.00316.89
8.0.110.0040.00416.88
8.0.100.0000.00716.73
8.0.90.0000.00816.73
8.0.80.0080.00816.84
8.0.70.0000.00716.69
8.0.60.0030.00516.77
8.0.50.0070.00016.75
8.0.30.0070.01017.05
8.0.20.0120.00817.40
8.0.10.0000.00716.96
8.0.00.0100.00816.69
7.4.330.0000.00615.08
7.4.320.0030.00316.66
7.4.300.0000.00616.51
7.4.290.0030.00316.53
7.4.280.0040.00416.49
7.4.270.0070.00016.65
7.4.260.0000.00716.64
7.4.250.0000.00716.49
7.4.240.0020.00516.53
7.4.230.0040.00216.35
7.4.220.0140.01416.45
7.4.210.0110.00316.54
7.4.200.0030.00316.70
7.4.160.0030.01316.34
7.4.150.0060.01217.40
7.4.140.0100.01017.86
7.4.130.0160.00216.57
7.4.120.0140.00616.64
7.4.110.0100.00716.46
7.4.100.0100.01016.56
7.4.90.0110.00616.52
7.4.80.0050.01119.39
7.4.70.0110.00516.42
7.4.60.0100.00616.41
7.4.50.0000.00816.35
7.4.40.0110.00416.49
7.4.30.0090.01216.47
7.4.00.0030.01314.90
7.3.330.0060.00013.14
7.3.320.0000.00613.32
7.3.310.0030.00316.31
7.3.300.0040.00416.32
7.3.290.0100.00716.34
7.3.280.0070.01016.33
7.3.270.0070.01117.40
7.3.260.0120.00616.62
7.3.250.0100.00916.46
7.3.240.0130.00516.37
7.3.230.0130.00316.48
7.3.210.0040.01416.62
7.3.200.0140.00716.61
7.3.190.0000.01616.57
7.3.180.0030.01216.41
7.3.170.0090.01316.54
7.3.160.0060.01216.38
7.3.120.0070.01114.71
7.3.110.0090.00414.77
7.3.100.0030.01014.57
7.3.90.0100.00314.88
7.3.80.0030.00615.04
7.3.70.0070.01014.98
7.3.60.0000.01314.62
7.3.50.0070.00714.75
7.3.40.0060.00614.82
7.3.30.0060.00615.00
7.3.20.0030.00716.58
7.3.10.0030.00716.56
7.3.00.0070.00416.74
7.2.330.0060.01216.47
7.2.320.0040.01816.66
7.2.310.0060.01016.69
7.2.300.0120.00616.71
7.2.290.0130.00916.79
7.2.250.0100.00715.26
7.2.240.0000.02015.17
7.2.230.0070.01014.98
7.2.220.0040.01515.04
7.2.210.0090.00615.29
7.2.200.0040.01114.74
7.2.190.0040.01114.79
7.2.180.0060.00614.99
7.2.170.0030.01115.15
7.2.00.0060.01019.03
7.1.330.0070.00715.62
7.1.320.0000.01015.67
7.1.310.0040.01215.65
7.1.300.0000.01515.70
7.1.290.0040.01215.94
7.1.280.0030.01015.65
7.1.270.0090.00615.74
7.1.260.0040.01115.62
7.1.100.0040.01118.00
7.1.70.0000.00717.03
7.1.60.0100.00720.03
7.1.50.0070.01416.66
7.1.00.0030.07722.45
7.0.200.0070.00716.94
7.0.60.0070.07019.77
7.0.50.0070.08317.90
7.0.40.0070.08720.02
7.0.30.0400.05020.19
7.0.20.0370.05020.16
7.0.10.0170.08020.26
7.0.00.0100.03320.30
5.6.280.0030.03021.14
5.6.210.0130.05720.50
5.6.200.0000.04718.29
5.6.190.0070.04320.50
5.6.180.0270.04720.52
5.6.170.0130.06020.55
5.6.160.0070.09020.51
5.6.150.0130.07018.22
5.6.140.0030.08318.19
5.6.130.0030.09318.14
5.6.120.0100.08021.05
5.6.110.0070.08320.98
5.6.100.0070.08321.14
5.6.90.0100.07720.88
5.6.80.0070.05020.44
5.5.350.3570.04320.30
5.5.340.0070.08018.07
5.5.330.0030.07320.30
5.5.320.0170.05720.52
5.5.310.0430.07320.34
5.5.300.0030.08018.04
5.5.290.0070.08018.09
5.5.280.0030.09020.97
5.5.270.0100.06320.84
5.5.260.0070.08020.87
5.5.250.0000.04320.66
5.5.240.0070.08320.16
5.4.450.0800.04319.69
5.4.440.0530.06319.15
5.4.430.0500.05019.59
5.4.420.0430.05719.61
5.4.410.0400.05719.33
5.4.400.0430.05719.29
5.4.390.0430.05719.25
5.4.380.0530.04319.14
5.4.370.0430.06019.29
5.4.360.0430.06018.96
5.4.350.0430.06318.85
5.4.340.0630.04319.37
5.4.320.0630.05319.14
5.4.310.0570.06018.82
5.4.300.0600.05019.26
5.4.290.0670.05319.25
5.4.280.0430.06719.14
5.4.270.0470.05319.37
5.4.260.0470.05719.37
5.4.250.0500.05719.13
5.4.240.0470.05019.13
5.4.230.0570.05719.22
5.4.220.0470.05319.28
5.4.210.0500.06018.95
5.4.200.0670.04319.21
5.4.190.0500.06019.04
5.4.180.0570.05019.21
5.4.170.0570.05319.10
5.4.160.0570.05019.27
5.4.150.0470.07019.27
5.4.140.0570.04316.45
5.4.130.0570.03716.32
5.4.120.0470.04316.56
5.4.110.0500.04716.44
5.4.100.0400.05316.63
5.4.90.0470.05316.61
5.4.80.0530.04316.59
5.4.70.0330.06016.18
5.4.60.0130.05016.33
5.4.50.0270.05316.53
5.4.40.0300.05716.53
5.4.30.0030.03716.53
5.4.20.0230.04016.52
5.4.10.0200.03716.35

preferences:
47.58 ms | 401 KiB | 5 Q