3v4l.org

run code in 300+ PHP versions simultaneously
<?php $fields = array( 'np.title `partner`', 'fm.fmid', 'n.nid', 'ws.sid', 'n.language', ); $extra = array('adgroup', 'campaign', 'content', 'source', 'term', 'mobile', 'tablet'); foreach ($extra as $field) { $fields[] = "{$field}.`value` `{$field}`"; } $extra = array_combine($extra, $extra); $suffix = '_sand'; $sql = 'INSERT INTO {report_generic_report} SELECT ' . implode(', ', $fields) . ", ws.submitted, ps.doi FROM {form_map_history{$suffix}} fmh JOIN {form_map} fm ON fmh.fmid = fm.fmid JOIN {node} np ON fm.vid = np.vid JOIN {webform_submissions{$suffix}} ws ON fmh.sid = ws.sid JOIN {partner_submission{$suffix}} ps ON ws.sid = ps.sid AND fm.vid = ps.vid JOIN {node} n ON ws.nid = n.nid"; foreach ($extra as $field) { $sql .= " LEFT JOIN {webform_submission_extra{$suffix}} `{$field}` ON ws.sid = `{$field}`.sid AND `{$field}`.`name` = '{$field}'"; } $sql .= " WHERE ws.submitted BETWEEN %d AND %d"; if ($form_state['values']['language']) { $sql .= " AND n.`language` = '".$form_state['values']['language']."'"; } $sql .= " ORDER BY `partner`, sid"; print $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.0110.00418.27
8.3.50.0130.00622.18
8.3.40.0090.00618.71
8.3.30.0090.00619.09
8.3.20.0080.00020.29
8.3.10.0000.00823.61
8.3.00.0040.00419.38
8.2.180.0060.00917.00
8.2.170.0140.00722.96
8.2.160.0070.00720.52
8.2.150.0060.00324.18
8.2.140.0050.00324.66
8.2.130.0000.00726.16
8.2.120.0080.00022.09
8.2.110.0060.00320.53
8.2.100.0000.01118.04
8.2.90.0000.00818.28
8.2.80.0000.00817.97
8.2.70.0000.00817.50
8.2.60.0060.00318.05
8.2.50.0100.00018.07
8.2.40.0040.00418.34
8.2.30.0000.00718.03
8.2.20.0000.00717.77
8.2.10.0040.00418.16
8.2.00.0050.00317.96
8.1.280.0100.00325.92
8.1.270.0030.00623.80
8.1.260.0030.00526.35
8.1.250.0000.00728.09
8.1.240.0060.00322.02
8.1.230.0070.00420.79
8.1.220.0080.00017.74
8.1.210.0040.00418.82
8.1.200.0040.00417.23
8.1.190.0080.00017.23
8.1.180.0000.00818.10
8.1.170.0000.00818.51
8.1.160.0000.00722.11
8.1.150.0040.00418.82
8.1.140.0070.00017.44
8.1.130.0030.00617.92
8.1.120.0030.00517.52
8.1.110.0050.00217.46
8.1.100.0000.00717.51
8.1.90.0040.00417.52
8.1.80.0000.00717.51
8.1.70.0030.00317.38
8.1.60.0000.00917.57
8.1.50.0050.00317.52
8.1.40.0000.00817.54
8.1.30.0050.00317.71
8.1.20.0030.00617.71
8.1.10.0040.00417.64
8.1.00.0040.00417.59
8.0.300.0050.00320.16
8.0.290.0000.00716.63
8.0.280.0040.00418.48
8.0.270.0020.00517.21
8.0.260.0000.00817.34
8.0.250.0030.00316.99
8.0.240.0030.00317.06
8.0.230.0030.00317.03
8.0.220.0060.00017.04
8.0.210.0040.00416.89
8.0.200.0030.00316.93
8.0.190.0000.00717.10
8.0.180.0000.00716.91
8.0.170.0000.00716.98
8.0.160.0040.00416.95
8.0.150.0070.00016.97
8.0.140.0060.00316.82
8.0.130.0050.00013.43
8.0.120.0060.00316.86
8.0.110.0040.00417.00
8.0.100.0030.00416.86
8.0.90.0030.00616.84
8.0.80.0130.00716.95
8.0.70.0000.00716.96
8.0.60.0000.00816.86
8.0.50.0040.00417.05
8.0.30.0110.00917.07
8.0.20.0110.00817.40
8.0.10.0080.00016.93
8.0.00.0090.00916.91
7.4.330.0050.00015.00
7.4.320.0030.00316.58
7.4.300.0030.00316.62
7.4.290.0030.00616.57
7.4.280.0020.00516.60
7.4.270.0030.00316.66
7.4.260.0030.00316.45
7.4.250.0000.00716.36
7.4.240.0050.00316.64
7.4.230.0040.00416.44
7.4.220.0070.01416.59
7.4.210.0140.00616.64
7.4.200.0070.00016.51
7.4.160.0170.00616.48
7.4.150.0090.01317.40
7.4.140.0100.01117.86
7.4.130.0070.01016.55
7.4.120.0090.01116.47
7.4.110.0090.01216.49
7.4.100.0040.01316.55
7.4.90.0060.01216.64
7.4.80.0090.01419.39
7.4.70.0060.01016.55
7.4.60.0090.00616.51
7.4.50.0060.00016.53
7.4.40.0130.00416.45
7.4.30.0130.00316.48
7.4.10.0060.01215.20
7.4.00.0080.00814.95
7.3.330.0000.00513.36
7.3.320.0050.00013.41
7.3.310.0030.00316.33
7.3.300.0000.00716.47
7.3.290.0090.00616.46
7.3.280.0080.00616.40
7.3.270.0240.00017.40
7.3.260.0070.01716.54
7.3.250.0100.01016.47
7.3.240.0090.00916.37
7.3.230.0140.00416.50
7.3.210.0070.01016.45
7.3.200.0090.00619.39
7.3.190.0060.01016.60
7.3.180.0100.00716.59
7.3.170.0030.01316.51
7.3.160.0120.00416.61
7.3.130.0060.01314.88
7.3.120.0100.00815.00
7.3.110.0090.01014.72
7.3.100.0030.01414.73
7.3.90.0050.01115.01
7.3.80.0050.00815.05
7.3.70.0000.01215.06
7.3.60.0050.00714.76
7.3.50.0030.00814.96
7.3.40.0060.00614.94
7.3.30.0060.00714.89
7.3.20.0050.00916.75
7.3.10.0060.00816.72
7.3.00.0080.00516.51
7.2.330.0060.01216.78
7.2.320.0120.01216.66
7.2.310.0060.01716.58
7.2.300.0080.00816.73
7.2.290.0110.00716.74
7.2.260.0130.00315.27
7.2.250.0070.01215.33
7.2.240.0090.00815.27
7.2.230.0100.00715.01
7.2.220.0090.00814.93
7.2.210.0020.01115.03
7.2.200.0050.01014.99
7.2.190.0050.00815.10
7.2.180.0020.00915.12
7.2.170.0110.00315.20
7.2.160.0020.01015.15
7.2.150.0080.00616.88
7.2.140.0110.00417.13
7.2.130.0000.01416.88
7.2.120.0110.00517.00
7.2.110.0090.00616.92
7.2.100.0050.01116.94
7.2.90.0050.01116.99
7.2.80.0070.00816.80
7.2.70.0090.00716.85
7.2.60.0070.00817.00
7.2.50.0090.00216.82
7.2.40.0040.00916.98
7.2.30.0070.01216.89
7.2.20.0050.01216.85
7.2.10.0060.01016.96
7.2.00.0020.01016.93
7.1.330.0080.00615.90
7.1.320.0070.01015.86
7.1.310.0050.00915.88
7.1.300.0030.01115.79
7.1.290.0040.01015.95
7.1.280.0060.00515.79
7.1.270.0060.00515.81
7.1.260.0060.00815.96
7.1.250.0040.00615.59
7.1.240.0090.00415.70
7.1.230.0090.00715.73
7.1.220.0040.01215.83
7.1.210.0060.00615.76
7.1.200.0080.00715.95
7.1.190.0070.01015.84
7.1.180.0060.00615.79
7.1.170.0070.00515.90
7.1.160.0030.01015.75
7.1.150.0070.01015.82
7.1.140.0040.00715.82
7.1.130.0020.01015.96
7.1.120.0050.00715.76
7.1.110.0060.00815.84
7.1.100.0030.01115.83
7.1.90.0020.00915.93
7.1.80.0020.00915.97
7.1.70.0050.00616.12
7.1.60.0040.01116.99
7.1.50.0040.00716.15
7.1.40.0040.01015.86
7.1.30.0070.00515.79
7.1.20.0070.01015.96
7.1.10.0100.00515.69
7.1.00.0030.03118.09
7.0.330.0040.01015.34
7.0.320.0020.01115.38
7.0.310.0090.00715.38
7.0.300.0040.00415.61
7.0.290.0030.00615.37
7.0.280.0080.00515.48
7.0.270.0020.01315.25
7.0.260.0050.00615.45
7.0.250.0050.00915.46
7.0.240.0000.01215.54
7.0.230.0040.00915.35
7.0.220.0050.00915.44
7.0.210.0050.00515.48
7.0.200.0050.00615.74
7.0.190.0070.00615.33
7.0.180.0030.00715.58
7.0.170.0050.00815.55
7.0.160.0050.00815.29
7.0.150.0090.00715.53
7.0.140.0070.02817.67
7.0.130.0080.00515.30
7.0.120.0030.00815.49
7.0.110.0050.00615.52
7.0.100.0090.00215.23
7.0.90.0060.00515.58
7.0.80.0050.00715.21
7.0.70.0010.00915.32
7.0.60.0030.03116.84
7.0.50.0100.02316.26
7.0.40.0080.01815.66
7.0.30.0190.02515.77
7.0.20.0140.02015.65
7.0.10.0060.01715.70
7.0.00.0050.02315.78
5.6.400.0060.00514.38
5.6.390.0090.00314.58
5.6.380.0080.00214.51
5.6.370.0100.00314.68
5.6.360.0080.00314.52
5.6.350.0100.00414.30
5.6.340.0080.00714.46
5.6.330.0090.00314.58
5.6.320.0020.01014.23
5.6.310.0050.00914.40
5.6.300.0060.00814.48
5.6.290.0040.00614.76
5.6.280.0020.03116.55
5.6.270.0040.00814.51
5.6.260.0090.00614.42
5.6.250.0050.00814.36
5.6.240.0090.00514.44
5.6.230.0060.00314.34
5.6.220.0030.00914.56
5.6.210.0050.02916.59
5.6.200.0080.02615.65
5.6.190.0080.01816.52
5.6.180.0120.03116.45
5.6.170.0170.02916.54
5.6.160.0070.02516.36
5.6.150.0060.02315.75
5.6.140.0040.02915.59
5.6.130.0050.02215.82
5.6.120.0120.02916.62
5.6.110.0100.02116.50
5.6.100.0090.03016.52
5.6.90.0080.02716.62
5.6.80.0060.01616.42
5.6.70.0060.00714.46
5.6.60.0030.00814.41
5.6.50.0050.00914.53
5.6.40.0090.00814.33
5.6.30.0030.00714.35
5.6.20.0020.01114.35
5.6.10.0040.00914.39
5.6.00.0040.00814.21
5.5.380.0070.00714.62
5.5.370.0060.00814.59
5.5.360.0110.00214.45
5.5.350.0150.02516.54
5.5.340.0030.02015.58
5.5.330.0050.03216.52
5.5.320.0160.02916.30
5.5.310.0130.02216.45
5.5.300.0050.03415.64
5.5.290.0080.02915.50
5.5.280.0060.02016.56
5.5.270.0040.03416.57
5.5.260.0080.02416.45
5.5.250.0050.02516.36
5.5.240.0120.03016.32
5.5.230.0050.00514.45
5.5.220.0030.00714.38
5.5.210.0080.00514.41
5.5.200.0050.00814.21
5.5.190.0030.01014.31
5.5.180.0050.00614.40
5.5.170.0030.00614.24
5.5.160.0040.00814.50
5.5.150.0020.01114.32
5.5.140.0070.00814.17
5.5.130.0040.00914.40
5.5.120.0080.00714.35
5.5.110.0080.00614.31
5.5.100.0040.00714.26
5.5.90.0090.00314.28
5.5.80.0010.01014.30
5.5.70.0070.00814.48
5.5.60.0080.00614.39
5.5.50.0080.00814.47
5.5.40.0040.00414.40
5.5.30.0060.00614.46
5.5.20.0090.00314.24
5.5.10.0100.00514.37
5.5.00.0040.00514.25
5.4.450.0070.02214.31
5.4.440.0290.02014.39
5.4.430.0270.02414.27
5.4.420.0240.00414.29
5.4.410.0240.00614.24
5.4.400.0240.00414.22
5.4.390.0260.00514.22
5.4.380.0320.00314.21
5.4.370.0240.00514.13
5.4.360.0210.00414.12
5.4.350.0250.00014.16
5.4.340.0050.01411.79
5.4.330.0030.00811.62
5.4.320.0030.01711.95
5.4.310.0040.01911.96
5.4.300.0060.01612.01
5.4.290.0060.01811.93
5.4.280.0030.01811.90
5.4.270.0060.01511.91
5.4.260.0070.01411.96
5.4.250.0030.01711.92
5.4.240.0040.01711.92
5.4.230.0030.01711.82
5.4.220.0040.01611.91
5.4.210.0040.01611.88
5.4.200.0030.01811.92
5.4.190.0080.01411.93
5.4.180.0070.01511.88
5.4.170.0060.01711.90
5.4.160.0020.01711.79
5.4.150.0040.01411.97
5.4.140.0070.01711.86
5.4.130.0030.01611.91
5.4.120.0060.01311.72
5.4.110.0030.01411.75
5.4.100.0050.01711.83
5.4.90.0040.01711.87
5.4.80.0040.01611.83
5.4.70.0060.01511.75
5.4.60.0050.01711.74
5.4.50.0030.01611.82
5.4.40.0080.01311.83
5.4.30.0030.01811.83
5.4.20.0030.01611.85
5.4.10.0040.01611.72
5.4.00.0040.01711.66
5.3.290.0040.04712.80
5.3.280.0040.03812.71
5.3.270.0070.04212.73
5.3.260.0050.04012.72
5.3.250.0060.03712.72
5.3.240.0070.03612.72
5.3.230.0060.04412.71
5.3.220.0070.04012.68
5.3.210.0060.03912.68
5.3.200.0040.03812.68
5.3.190.0060.03712.68
5.3.180.0030.03812.68
5.3.170.0060.03512.67
5.3.160.0080.03312.67
5.3.150.0110.03112.67
5.3.140.0060.03612.66
5.3.130.0100.03312.65
5.3.120.0090.03512.66
5.3.110.0050.03812.66
5.3.100.0040.03812.12
5.3.90.0040.03812.08
5.3.80.0090.03312.08
5.3.70.0070.04612.07
5.3.60.0070.03612.06
5.3.50.0060.03612.00
5.3.40.0060.03512.00
5.3.30.0040.03511.96
5.3.20.0070.04211.73
5.3.10.0090.03711.70
5.3.00.0080.03911.69
5.2.170.0040.0329.20
5.2.160.0090.0279.19
5.2.150.0020.0339.19
5.2.140.0080.0279.19
5.2.130.0040.0379.15
5.2.120.0070.0269.15
5.2.110.0060.0289.16
5.2.100.0040.0299.16
5.2.90.0070.0289.16
5.2.80.0070.0349.15
5.2.70.0030.0319.14
5.2.60.0080.0349.11
5.2.50.0050.0329.07
5.2.40.0060.0269.05
5.2.30.0020.0339.02
5.2.20.0050.0279.03
5.2.10.0050.0288.95
5.2.00.0060.0338.81
5.1.60.0020.0258.10
5.1.50.0020.0278.09
5.1.40.0050.0238.08
5.1.30.0020.0288.43
5.1.20.0040.0268.45
5.1.10.0040.0258.17
5.1.00.0020.0278.18
5.0.50.0050.0186.66
5.0.40.0040.0246.52
5.0.30.0050.0296.32
5.0.20.0030.0196.30
5.0.10.0060.0166.28
5.0.00.0020.0316.27
4.4.90.0020.0164.78
4.4.80.0030.0144.76
4.4.70.0030.0154.75
4.4.60.0020.0214.76
4.4.50.0030.0144.77
4.4.40.0010.0264.70
4.4.30.0020.0154.76
4.4.20.0010.0174.85
4.4.10.0020.0174.85
4.4.00.0030.0244.76
4.3.110.0030.0154.67
4.3.100.0030.0144.66
4.3.90.0050.0124.63
4.3.80.0030.0244.58
4.3.70.0020.0154.63
4.3.60.0050.0114.63
4.3.50.0050.0124.62
4.3.40.0020.0244.54
4.3.30.0000.0183.32
4.3.20.0020.0163.29
4.3.10.0010.0163.24
4.3.00.0270.0207.14

preferences:
46.54 ms | 401 KiB | 5 Q