3v4l.org

run code in 300+ PHP versions simultaneously
<?php $categories = array('Colour', 'Portrait'); $sql = "SELECT p.*\nFROM (\n SELECT '"; $sql .= implode("' AS keyword\n UNION ALL\n SELECT '", $categories); $sql .= "' AS keyWord\n) k\nJOIN photos p ON CONCAT(',', p.keyWords, ',') LIKE CONCAT('%,', k.keyWord, ',%')\n"; $sql .= "GROUP BY p.id\nHAVING COUNT(*) = " . count($categories); 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.4.140.0160.00517.49
8.4.130.0110.01017.61
8.4.120.0080.01220.54
8.4.110.0090.01018.91
8.4.100.0150.00617.84
8.4.90.0060.00417.73
8.4.80.0040.00417.44
8.4.70.0100.01017.56
8.4.60.0130.00817.75
8.4.50.0100.00417.79
8.4.40.0040.01118.65
8.4.30.0110.00820.48
8.4.20.0110.01118.00
8.4.10.0030.00619.61
8.3.270.0100.00916.52
8.3.260.0120.00716.49
8.3.250.0060.01218.71
8.3.240.0090.00216.64
8.3.230.0120.00816.66
8.3.220.0040.00517.17
8.3.210.0120.00516.63
8.3.200.0060.00916.51
8.3.190.0110.00816.80
8.3.180.0070.00218.16
8.3.170.0110.00716.63
8.3.160.0110.00317.10
8.3.150.0080.01117.18
8.3.140.0140.00417.17
8.3.130.0040.00418.36
8.3.120.0030.00518.94
8.3.110.0060.00320.94
8.3.100.0050.00524.06
8.3.90.0170.00326.77
8.3.80.0030.00616.50
8.3.70.0130.00316.58
8.3.60.0070.01418.20
8.3.50.0100.01023.66
8.3.40.0100.00722.02
8.3.30.0060.00918.71
8.3.20.0000.00824.18
8.3.10.0070.00024.66
8.3.00.0080.00026.16
8.2.290.0080.00620.32
8.2.280.0100.00318.06
8.2.270.0080.01216.74
8.2.260.0040.00418.03
8.2.250.0050.00316.58
8.2.240.0070.01117.01
8.2.230.0060.00322.58
8.2.220.0040.01137.54
8.2.210.0000.00826.77
8.2.200.0100.00716.38
8.2.190.0150.00016.75
8.2.180.0150.00425.92
8.2.170.0140.00018.95
8.2.160.0070.00722.96
8.2.150.0000.00825.66
8.2.140.0000.00824.66
8.2.130.0070.00026.16
8.2.120.0040.00421.07
8.2.110.0030.00721.01
8.2.100.0100.00617.91
8.2.90.0040.00417.75
8.2.80.0040.00418.82
8.2.70.0080.00017.75
8.2.60.0040.00418.03
8.2.50.0050.00518.07
8.2.40.0000.00819.88
8.2.30.0040.00418.10
8.2.20.0040.00417.99
8.2.10.0040.00419.18
8.2.00.0040.00419.26
8.1.330.0110.00818.29
8.1.320.0120.00716.04
8.1.310.0100.00718.18
8.1.300.0000.01017.79
8.1.290.0060.00318.88
8.1.280.0100.01025.92
8.1.270.0100.01021.96
8.1.260.0040.00426.35
8.1.250.0000.00728.09
8.1.240.0100.00317.52
8.1.230.0070.00422.63
8.1.220.0000.00817.74
8.1.210.0040.00418.77
8.1.200.0090.00017.23
8.1.190.0050.00317.00
8.1.180.0040.00418.10
8.1.170.0060.00318.57
8.1.160.0030.00518.93
8.1.150.0050.00318.90
8.1.140.0050.00320.58
8.1.130.0000.00820.16
8.1.120.0080.00017.40
8.1.110.0030.00617.49
8.1.100.0000.00717.43
8.1.90.0000.00717.37
8.1.80.0030.00717.44
8.1.70.0040.00417.46
8.1.60.0050.00317.59
8.1.50.0040.00417.57
8.1.40.0030.00517.49
8.1.30.0040.00417.66
8.1.20.0050.00217.63
8.1.10.0050.00317.54
8.1.00.0040.00417.43
8.0.300.0050.00218.77
8.0.290.0040.00416.75
8.0.280.0030.00318.42
8.0.270.0000.00718.00
8.0.260.0060.00018.43
8.0.250.0070.00316.95
8.0.240.0000.00616.94
8.0.230.0030.00316.97
8.0.220.0030.00316.90
8.0.210.0000.00716.81
8.0.200.0030.00316.90
8.0.190.0040.00416.95
8.0.180.0080.00016.83
8.0.170.0060.00316.91
8.0.160.0000.00716.87
8.0.150.0000.00716.83
8.0.140.0000.00816.84
8.0.130.0040.00413.28
8.0.120.0040.00416.80
8.0.110.0000.00916.71
8.0.100.0080.00016.94
8.0.90.0040.00416.69
8.0.80.0030.01116.86
8.0.70.0040.00417.00
8.0.60.0040.00416.75
8.0.50.0040.00416.81
8.0.30.0120.00916.99
8.0.20.0080.01216.98
8.0.10.0040.00316.95
8.0.00.0190.00517.01
7.4.330.0080.00015.55
7.4.320.0030.00316.48
7.4.300.0030.00316.51
7.4.290.0000.00716.45
7.4.280.0100.00016.52
7.4.270.0020.00516.39
7.4.260.0000.00513.31
7.4.250.0060.00316.41
7.4.240.0040.00416.51
7.4.230.0000.00716.49
7.4.220.0020.00516.63
7.4.210.0100.00616.58
7.4.200.0030.00316.63
7.4.130.0110.00716.45
7.4.120.0140.00416.36
7.4.110.0110.00816.31
7.4.100.0130.00716.55
7.4.90.0180.00016.46
7.4.80.0120.00616.43
7.4.70.0100.00716.52
7.4.60.0070.01116.49
7.4.50.0140.01116.43
7.4.40.0100.01116.44
7.4.30.0170.00816.46
7.4.20.0140.00616.47
7.4.10.0100.01416.13
7.4.00.0160.00516.41
7.3.330.0070.00016.25
7.3.320.0000.00513.13
7.3.310.0000.00716.21
7.3.300.0030.00316.25
7.3.290.0110.00716.25
7.3.260.0160.00716.20
7.3.240.0080.01116.51
7.3.230.0120.00916.21
7.3.220.0110.00716.23
7.3.210.0100.00716.26
7.3.200.0090.00916.53
7.3.190.0140.00516.30
7.3.180.0060.01216.11
7.3.170.0120.00816.23
7.3.160.0090.01516.49
7.3.150.0180.00616.29
7.3.140.0140.00816.21
7.3.130.0130.01016.07
7.3.120.0080.01116.35
7.3.110.0180.00016.35
7.3.100.0040.01416.26
7.3.90.0100.01416.41
7.3.80.0140.00416.68
7.3.70.0110.00616.43
7.3.60.0050.01316.38
7.3.50.0140.00416.33
7.3.40.0080.01516.38
7.3.30.0100.01316.23
7.3.20.0100.00716.39
7.3.10.0080.01116.34
7.3.00.0130.01016.21
7.2.340.0070.01416.45
7.2.330.0190.00016.25
7.2.320.0120.00616.34
7.2.310.0170.00316.37
7.2.300.0100.00916.64
7.2.290.0140.01116.71
7.2.280.0220.01116.65
7.2.270.0100.01416.30
7.2.260.0190.00316.42
7.2.250.0200.00016.51
7.2.240.0140.00716.18
7.2.230.0090.00916.25
7.2.220.0060.01316.31
7.2.210.0100.01016.53
7.2.200.0150.00616.41
7.2.190.0120.00616.46
7.2.180.0070.01516.42
7.2.170.0130.00916.57
7.2.160.0080.01116.57
7.2.150.0150.00316.60
7.2.140.0120.01216.50
7.2.130.0130.01016.43
7.2.120.0170.00416.16
7.2.110.0090.01316.43
7.2.100.0170.00416.31
7.2.90.0070.01716.36
7.2.80.0370.01016.27
7.2.70.0100.01316.04
7.2.60.0110.01116.26
7.2.50.0140.01015.95
7.2.40.0110.01116.28
7.2.30.0080.01416.39
7.2.20.0210.00016.52
7.2.10.0130.01116.21
7.2.00.0140.01016.44

preferences:
30.86 ms | 403 KiB | 5 Q