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"; 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.68
8.3.50.0170.00521.96
8.3.40.0090.00618.79
8.3.30.0060.01219.01
8.3.20.0040.00420.29
8.3.10.0050.00323.61
8.3.00.0040.00419.51
8.2.180.0090.00616.75
8.2.170.0120.00322.96
8.2.160.0100.00320.52
8.2.150.0030.00624.18
8.2.140.0080.00024.66
8.2.130.0000.00726.16
8.2.120.0050.00322.22
8.2.110.0070.00320.49
8.2.100.0060.00617.95
8.2.90.0000.00818.34
8.2.80.0000.00817.97
8.2.70.0000.00817.63
8.2.60.0040.00417.93
8.2.50.0000.01118.07
8.2.40.0050.00318.16
8.2.30.0040.00418.12
8.2.20.0080.00017.84
8.2.10.0000.00718.15
8.2.00.0060.00317.89
8.1.280.0080.00625.92
8.1.270.0000.00823.76
8.1.260.0050.00326.35
8.1.250.0000.00728.09
8.1.240.0040.00422.19
8.1.230.0070.00420.86
8.1.220.0030.00517.75
8.1.210.0040.00418.87
8.1.200.0050.00517.23
8.1.190.0050.00317.23
8.1.180.0040.00418.10
8.1.170.0080.00018.54
8.1.160.0050.00222.05
8.1.150.0040.00418.97
8.1.140.0050.00217.40
8.1.130.0040.00417.93
8.1.120.0040.00417.42
8.1.110.0000.00817.55
8.1.100.0000.00717.51
8.1.90.0070.00017.49
8.1.80.0000.00717.39
8.1.70.0070.00017.29
8.1.60.0000.00817.54
8.1.50.0030.00517.56
8.1.40.0040.00417.43
8.1.30.0000.00817.72
8.1.20.0000.00817.69
8.1.10.0030.00517.59
8.1.00.0040.00417.40
8.0.300.0000.00720.09
8.0.290.0040.00416.72
8.0.280.0000.00718.41
8.0.270.0070.00017.29
8.0.260.0000.00617.16
8.0.250.0050.00316.93
8.0.240.0000.00717.04
8.0.230.0030.00316.91
8.0.220.0030.00316.91
8.0.210.0060.00316.86
8.0.200.0040.00416.90
8.0.190.0070.00017.00
8.0.180.0000.00717.02
8.0.170.0000.00816.91
8.0.160.0000.00716.95
8.0.150.0000.00716.95
8.0.140.0070.00016.94
8.0.130.0060.00013.38
8.0.120.0030.00517.01
8.0.110.0080.00016.94
8.0.100.0000.01017.04
8.0.90.0000.00816.80
8.0.80.0060.00916.98
8.0.70.0040.00416.98
8.0.60.0000.00717.05
8.0.50.0040.00417.00
8.0.30.0120.01017.31
8.0.20.0090.01017.40
8.0.10.0000.00817.02
8.0.00.0090.00816.88
7.4.330.0000.00615.00
7.4.320.0030.00316.54
7.4.300.0000.00716.39
7.4.290.0070.00316.50
7.4.280.0050.00316.67
7.4.270.0070.00016.66
7.4.260.0080.00016.59
7.4.250.0000.00716.42
7.4.240.0060.00216.48
7.4.230.0030.00316.38
7.4.220.0140.00716.63
7.4.210.0030.01716.57
7.4.200.0000.00716.61
7.4.160.0110.00716.49
7.4.150.0120.00717.40
7.4.140.0130.00817.86
7.4.130.0160.00616.50
7.4.120.0110.00916.63
7.4.110.0190.00016.64
7.4.100.0140.00316.53
7.4.90.0070.01116.55
7.4.80.0090.01819.39
7.4.70.0060.01016.42
7.4.60.0070.01116.70
7.4.50.0000.00616.60
7.4.40.0110.00716.52
7.4.30.0160.00016.53
7.4.00.0000.01214.77
7.3.330.0000.00513.14
7.3.320.0020.00213.18
7.3.310.0030.00316.47
7.3.300.0030.00316.38
7.3.290.0070.00716.41
7.3.280.0100.00816.45
7.3.270.0090.00917.40
7.3.260.0160.00616.42
7.3.240.0170.00016.38
7.3.230.0090.00916.46
7.3.210.0030.01716.41
7.3.200.0100.01319.39
7.3.190.0110.00716.34
7.3.180.0050.01116.43
7.3.170.0000.01416.60
7.3.160.0120.00416.59
7.2.330.0100.00916.61
7.2.320.0060.01216.87
7.2.310.0100.01316.65
7.2.300.0080.00816.65
7.2.290.0070.01016.59
7.2.60.0030.01316.69
7.2.00.0060.00319.17
7.1.200.0060.00315.95
7.1.100.0030.00818.26
7.1.70.0000.00717.12
7.1.60.0100.01419.32
7.1.50.0000.01116.86
7.1.00.0070.07322.45
7.0.200.0080.00016.60
7.0.140.0000.07322.08
7.0.60.0030.04319.94
7.0.50.0000.08717.94
7.0.40.0070.07020.08
7.0.30.0370.06020.34
7.0.20.0170.04020.20
7.0.10.0000.04720.09
7.0.00.0030.04020.00
5.6.280.0130.06021.13
5.6.210.0100.07720.61
5.6.200.0100.08018.23
5.6.190.0070.08720.39
5.6.180.0270.07720.43
5.6.170.0370.08020.62
5.6.160.0070.06320.37
5.6.150.0070.06718.07
5.6.140.0030.04318.22
5.6.130.0070.03718.15
5.6.120.0170.03720.89
5.6.110.0130.08321.12
5.6.100.0030.09021.03
5.6.90.0130.07720.97
5.6.80.0100.07020.41
5.5.350.0200.07720.39
5.5.340.0130.07317.91
5.5.330.0070.04320.07
5.5.320.0330.07020.24
5.5.310.0270.04720.17
5.5.300.0070.08718.02
5.5.290.0030.05717.91
5.5.280.0100.06020.70
5.5.270.0130.06320.64
5.5.260.0030.04320.88
5.5.250.0070.08720.67
5.5.240.0200.06720.27
5.4.450.0870.05319.61
5.4.440.0930.05719.46
5.4.430.0900.04319.60
5.4.420.0670.00019.32
5.4.410.0630.00019.42
5.4.400.0630.00019.20
5.4.390.0600.00019.01
5.4.380.0630.00019.01
5.4.370.0630.00019.04
5.4.360.0630.00019.07
5.4.350.0830.00018.96
5.4.340.0110.03611.99
5.4.320.0050.04312.47
5.4.310.0070.04012.46
5.4.300.0090.03112.46
5.4.290.0060.03712.46
5.4.280.0060.03412.36
5.4.270.0080.03712.36
5.4.260.0060.03712.36
5.4.250.0060.04212.36
5.4.240.0080.03912.36
5.4.230.0050.03912.35
5.4.220.0070.04412.36
5.4.210.0040.04212.35
5.4.200.0060.03912.36
5.4.190.0070.03512.35
5.4.180.0060.03812.35
5.4.170.0060.04112.36
5.4.160.0080.05112.36
5.4.150.0090.06212.36
5.4.140.0090.04012.04
5.4.130.0070.03512.03
5.4.120.0060.03511.98
5.4.110.0040.03811.98
5.4.100.0070.03511.98
5.4.90.0020.04711.98
5.4.80.0030.05011.98
5.4.70.0060.03911.97
5.4.60.0080.03911.98
5.4.50.0040.03711.98
5.4.40.0080.03911.97
5.4.30.0050.03711.96
5.4.20.0050.03711.96
5.4.10.0050.03511.96
5.4.00.0100.03211.46
5.3.290.0050.04612.80
5.3.280.0090.04012.71
5.3.270.0070.04212.73
5.3.260.0090.03712.72
5.3.250.0070.03612.72
5.3.240.0100.03312.72
5.3.230.0020.04612.71
5.3.220.0070.03912.68
5.3.210.0100.03712.68
5.3.200.0060.04712.68
5.3.190.0080.04112.68
5.3.180.0090.03312.67
5.3.170.0080.03612.67
5.3.160.0100.05612.67
5.3.150.0060.03712.67
5.3.140.0060.03712.66
5.3.130.0100.03712.66
5.3.120.0060.03912.66
5.3.110.0080.04412.66
5.3.100.0070.03612.12
5.3.90.0060.03712.08
5.3.80.0040.03812.07
5.3.70.0080.03412.08
5.3.60.0090.04112.06
5.3.50.0090.04212.00
5.3.40.0080.03912.00
5.3.30.0060.03611.96
5.3.20.0030.04211.73
5.3.10.0070.03411.70
5.3.00.0060.03911.69
5.2.170.0070.0299.19
5.2.160.0050.0309.19
5.2.150.0030.0339.20
5.2.140.0070.0349.19
5.2.130.0060.0349.15
5.2.120.0050.0359.16
5.2.110.0070.0279.16
5.2.100.0060.0309.16
5.2.90.0040.0309.15
5.2.80.0070.0399.15
5.2.70.0070.0289.15
5.2.60.0040.0329.11
5.2.50.0030.0349.07
5.2.40.0040.0319.05
5.2.30.0040.0309.02
5.2.20.0100.0289.03
5.2.10.0050.0308.95
5.2.00.0070.0278.81
5.1.60.0070.0278.10
5.1.50.0080.0318.09
5.1.40.0010.0278.08
5.1.30.0020.0288.43
5.1.20.0090.0298.45
5.1.10.0080.0218.17
5.1.00.0050.0278.18
5.0.50.0020.0226.65
5.0.40.0070.0226.52
5.0.30.0040.0366.33
5.0.20.0050.0226.30
5.0.10.0010.0226.28
5.0.00.0060.0276.27
4.4.90.0030.0154.78
4.4.80.0050.0124.76
4.4.70.0020.0164.75
4.4.60.0040.0134.76
4.4.50.0010.0174.77
4.4.40.0040.0244.71
4.4.30.0020.0164.75
4.4.20.0020.0164.84
4.4.10.0020.0164.85
4.4.00.0020.0264.76
4.3.110.0040.0174.67
4.3.100.0020.0154.66
4.3.90.0020.0224.63
4.3.80.0040.0284.59
4.3.70.0030.0134.63
4.3.60.0020.0154.63
4.3.50.0030.0154.62
4.3.40.0010.0264.53
4.3.30.0040.0183.32
4.3.20.0010.0233.29
4.3.10.0030.0153.23
4.3.00.0130.0237.14

preferences:
74.83 ms | 401 KiB | 5 Q