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); $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";

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.70.0150.00016.88
8.3.60.0140.00018.55
8.3.50.0220.00521.15
8.3.40.0140.00718.64
8.3.30.0100.00319.22
8.3.20.0040.00420.39
8.3.10.0020.00523.48
8.3.00.0030.00719.25
8.2.180.0090.00618.29
8.2.170.0130.00722.96
8.2.160.0110.00420.25
8.2.150.0040.00424.18
8.2.140.0040.00424.66
8.2.130.0080.00026.16
8.2.120.0070.00022.11
8.2.110.0090.00021.01
8.2.100.0040.00817.91
8.2.90.0050.00319.17
8.2.80.0000.00817.97
8.2.70.0070.00317.63
8.2.60.0000.00818.05
8.2.50.0050.00518.10
8.2.40.0040.00419.88
8.2.30.0070.00018.09
8.2.20.0000.00717.88
8.2.10.0040.00418.15
8.2.00.0030.00617.74
8.1.280.0100.01025.92
8.1.270.0080.00023.92
8.1.260.0080.00026.35
8.1.250.0040.00428.09
8.1.240.0060.00322.20
8.1.230.0090.00317.85
8.1.220.0080.00017.74
8.1.210.0050.00318.77
8.1.200.0050.00517.10
8.1.190.0040.00417.10
8.1.180.0030.00518.10
8.1.170.0050.00518.59
8.1.160.0040.00422.11
8.1.150.0040.00418.97
8.1.140.0040.00417.54
8.1.130.0000.00717.84
8.1.120.0040.00317.43
8.1.110.0000.00717.49
8.1.100.0050.00317.54
8.1.90.0040.00417.50
8.1.80.0040.00417.39
8.1.70.0040.00417.33
8.1.60.0000.00917.64
8.1.50.0030.00517.45
8.1.40.0040.00417.43
8.1.30.0000.00817.62
8.1.20.0040.00417.52
8.1.10.0000.00717.61
8.1.00.0040.00417.58
8.0.300.0000.00818.77
8.0.290.0040.00416.75
8.0.280.0030.00318.52
8.0.270.0000.00717.27
8.0.260.0030.00317.36
8.0.250.0000.00817.00
8.0.240.0070.00017.06
8.0.230.0000.00817.06
8.0.220.0070.00016.93
8.0.210.0030.00316.97
8.0.200.0080.00017.02
8.0.190.0080.00017.05
8.0.180.0040.00416.94
8.0.170.0050.00316.96
8.0.160.0030.00316.98
8.0.150.0000.00816.95
8.0.140.0040.00416.93
8.0.130.0000.00613.34
8.0.120.0040.00416.91
8.0.110.0030.00516.88
8.0.100.0000.00716.95
8.0.90.0000.00716.97
8.0.80.0180.00317.02
8.0.70.0040.00417.04
8.0.60.0040.00416.88
8.0.50.0070.00017.00
8.0.30.0100.00917.10
8.0.20.0090.01117.40
8.0.10.0000.00817.18
8.0.00.0100.01016.71
7.4.330.0000.00515.00
7.4.320.0000.00616.64
7.4.300.0060.00016.64
7.4.290.0000.00716.54
7.4.280.0060.00316.42
7.4.270.0030.00316.43
7.4.260.0030.00316.64
7.4.250.0030.00516.41
7.4.240.0050.00216.63
7.4.230.0070.00016.54
7.4.220.0060.01216.57
7.4.210.0100.00316.46
7.4.200.0040.00416.38
7.4.160.0160.00016.51
7.4.150.0080.00917.40
7.4.140.0110.00717.86
7.4.130.0090.00816.57
7.4.120.0100.00816.59
7.4.110.0000.01716.57
7.4.100.0090.00916.51
7.4.90.0100.00716.64
7.4.80.0090.00919.39
7.4.70.0120.00616.51
7.4.60.0030.01316.42
7.4.50.0050.00316.52
7.4.40.0150.00916.60
7.4.30.0030.01316.58
7.4.00.0040.01215.27
7.3.330.0050.00013.27
7.3.320.0050.00013.19
7.3.310.0030.00316.25
7.3.300.0070.00016.41
7.3.290.0000.01816.40
7.3.280.0060.00916.38
7.3.270.0030.01417.40
7.3.260.0100.00716.45
7.3.250.0130.00316.47
7.3.240.0130.00316.70
7.3.230.0050.01116.45
7.3.210.0070.01416.58
7.3.200.0060.01519.39
7.3.190.0120.00916.62
7.3.180.0090.01316.46
7.3.170.0060.01016.65
7.3.160.0090.00616.49
7.2.330.0130.00316.68
7.2.320.0100.01316.90
7.2.310.0070.01416.70
7.2.300.0030.01416.88
7.2.290.0090.00916.63
7.1.100.0000.01118.30
7.1.70.0040.00417.25
7.1.60.0030.01219.32
7.1.50.0040.01816.54
7.1.00.0070.07322.30
7.0.200.0000.01016.77
7.0.140.0070.07022.11
7.0.60.0070.04720.01
7.0.50.0100.06717.84
7.0.40.0170.06719.99
7.0.30.0300.08020.02
7.0.20.0400.05720.01
7.0.10.0030.04320.08
7.0.00.0070.03720.18
5.6.280.0100.07020.93
5.6.210.0200.05320.63
5.6.200.0070.06018.17
5.6.190.0070.04320.41
5.6.180.0300.07720.63
5.6.170.0330.05320.42
5.6.160.0030.06020.48
5.6.150.0130.06718.16
5.6.140.0070.06718.11
5.6.130.0030.04318.20
5.6.120.0000.08721.02
5.6.110.0070.08020.90
5.6.100.0100.08021.14
5.6.90.0030.04321.09
5.6.80.0030.04320.40
5.5.350.0100.08320.45
5.5.340.0030.04018.02
5.5.330.0000.05020.29
5.5.320.0400.07020.28
5.5.310.0200.06020.28
5.5.300.0130.03317.97
5.5.290.0100.07717.99
5.5.280.0100.08020.88
5.5.270.0100.04320.93
5.5.260.0030.04720.96
5.5.250.0170.06720.59
5.5.240.0070.04020.16
5.4.450.0330.04019.63
5.4.440.0200.05719.46
5.4.430.0170.05319.53
5.4.420.0670.00019.63
5.4.410.0630.00019.35
5.4.400.0600.00019.00
5.4.390.0670.00018.92
5.4.380.0670.00019.08
5.4.370.0600.00019.11
5.4.360.0700.00019.07
5.4.350.0630.00019.16
5.4.340.0070.04011.98
5.4.320.0040.04112.46
5.4.310.0070.03812.46
5.4.300.0060.04212.47
5.4.290.0020.04112.46
5.4.280.0050.04112.36
5.4.270.0050.03812.36
5.4.260.0070.03612.36
5.4.250.0070.03612.36
5.4.240.0070.03712.36
5.4.230.0050.04012.36
5.4.220.0070.03612.36
5.4.210.0070.03512.36
5.4.200.0090.03612.35
5.4.190.0100.04412.35
5.4.180.0060.04112.35
5.4.170.0050.04012.36
5.4.160.0070.03512.36
5.4.150.0050.03812.36
5.4.140.0060.04212.04
5.4.130.0080.03912.03
5.4.120.0060.03411.98
5.4.110.0090.03811.98
5.4.100.0050.03611.98
5.4.90.0050.04011.98
5.4.80.0050.04011.98
5.4.70.0060.03811.98
5.4.60.0080.03811.97
5.4.50.0060.03911.98
5.4.40.0060.04311.96
5.4.30.0040.04011.96
5.4.20.0090.03311.96
5.4.10.0060.03611.96
5.4.00.0040.03911.46
5.3.290.0060.04112.80
5.3.280.0050.04012.71
5.3.270.0050.04112.72
5.3.260.0070.03912.72
5.3.250.0060.03812.72
5.3.240.0060.05212.71
5.3.230.0050.04012.71
5.3.220.0050.03712.68
5.3.210.0070.03712.68
5.3.200.0090.04312.68
5.3.190.0060.04012.68
5.3.180.0030.03912.67
5.3.170.0070.03912.67
5.3.160.0070.03612.67
5.3.150.0110.04112.67
5.3.140.0050.03812.66
5.3.130.0080.04012.66
5.3.120.0030.04712.66
5.3.110.0060.03912.66
5.3.100.0050.04812.11
5.3.90.0050.03712.08
5.3.80.0080.03712.07
5.3.70.0090.03312.08
5.3.60.0050.03812.06
5.3.50.0080.03412.00
5.3.40.0050.04012.00
5.3.30.0070.03411.96
5.3.20.0090.04111.73
5.3.10.0090.03711.70
5.3.00.0050.04111.69
5.2.170.0090.0289.19
5.2.160.0030.0349.19
5.2.150.0060.0309.19
5.2.140.0080.0289.19
5.2.130.0070.0289.15
5.2.120.0070.0289.15
5.2.110.0070.0289.16
5.2.100.0020.0339.15
5.2.90.0080.0269.15
5.2.80.0050.0329.15
5.2.70.0050.0309.15
5.2.60.0080.0279.10
5.2.50.0070.0309.07
5.2.40.0050.0349.05
5.2.30.0050.0309.02
5.2.20.0050.0309.03
5.2.10.0010.0328.95
5.2.00.0030.0338.81
5.1.60.0030.0308.10
5.1.50.0050.0278.10
5.1.40.0040.0258.08
5.1.30.0080.0238.43
5.1.20.0070.0248.45
5.1.10.0080.0268.18
5.1.00.0080.0268.18
5.0.50.0050.0216.65
5.0.40.0040.0196.52
5.0.30.0060.0326.32
5.0.20.0040.0216.30
5.0.10.0050.0186.28
5.0.00.0030.0316.27
4.4.90.0030.0194.78
4.4.80.0030.0174.75
4.4.70.0020.0214.75
4.4.60.0030.0164.76
4.4.50.0010.0174.77
4.4.40.0020.0274.71
4.4.30.0030.0194.76
4.4.20.0020.0174.85
4.4.10.0030.0164.85
4.4.00.0010.0264.76
4.3.110.0030.0154.67
4.3.100.0020.0164.66
4.3.90.0030.0144.64
4.3.80.0040.0234.59
4.3.70.0040.0214.63
4.3.60.0030.0184.63
4.3.50.0060.0204.63
4.3.40.0040.0284.54
4.3.30.0020.0163.32
4.3.20.0000.0183.29
4.3.10.0020.0183.24
4.3.00.0030.0207.30

preferences:
67.13 ms | 401 KiB | 5 Q