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 = ''; $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.0060.00918.27
8.3.50.0170.00822.11
8.3.40.0040.01118.63
8.3.30.0070.00719.09
8.3.20.0040.00420.13
8.3.10.0040.00423.50
8.3.00.0060.00319.50
8.2.180.0110.00416.75
8.2.170.0070.00722.96
8.2.160.0070.01020.43
8.2.150.0050.00324.18
8.2.140.0040.00424.66
8.2.130.0040.00426.16
8.2.120.0000.00722.06
8.2.110.0000.00820.25
8.2.100.0040.00718.03
8.2.90.0050.00319.17
8.2.80.0000.00817.97
8.2.70.0030.00617.63
8.2.60.0000.00817.93
8.2.50.0040.00418.07
8.2.40.0000.00819.82
8.2.30.0020.00518.03
8.2.20.0040.00417.75
8.2.10.0000.00718.07
8.2.00.0040.00417.88
8.1.280.0090.01225.92
8.1.270.0050.00323.91
8.1.260.0020.00226.35
8.1.250.0040.00428.09
8.1.240.0070.00323.71
8.1.230.0060.00619.12
8.1.220.0000.00817.74
8.1.210.0030.00518.77
8.1.200.0060.00317.22
8.1.190.0050.00317.00
8.1.180.0030.00618.10
8.1.170.0070.00318.53
8.1.160.0030.00522.05
8.1.150.0070.00018.91
8.1.140.0000.00817.44
8.1.130.0030.00317.90
8.1.120.0000.00817.41
8.1.110.0000.00717.47
8.1.100.0000.00917.53
8.1.90.0000.00717.50
8.1.80.0040.00417.40
8.1.70.0000.00717.47
8.1.60.0030.00517.69
8.1.50.0030.00517.63
8.1.40.0020.00517.43
8.1.30.0030.00517.69
8.1.20.0080.00017.72
8.1.10.0000.00717.54
8.1.00.0040.00417.55
8.0.300.0040.00418.77
8.0.290.0040.00416.75
8.0.280.0030.00318.59
8.0.270.0070.00017.30
8.0.260.0030.00317.21
8.0.250.0050.00317.11
8.0.240.0030.00317.02
8.0.230.0030.00317.05
8.0.220.0040.00416.92
8.0.210.0000.00716.88
8.0.200.0050.00317.09
8.0.190.0000.00817.09
8.0.180.0000.00816.99
8.0.170.0030.00617.00
8.0.160.0040.00417.07
8.0.150.0040.00416.96
8.0.140.0040.00416.84
8.0.130.0000.00613.38
8.0.120.0000.00816.81
8.0.110.0070.00017.00
8.0.100.0070.00016.92
8.0.90.0050.00217.11
8.0.80.0140.00617.05
8.0.70.0040.00417.05
8.0.60.0040.00416.94
8.0.50.0000.00716.98
8.0.30.0110.00817.04
8.0.20.0090.00917.44
8.0.10.0070.00016.94
8.0.00.0070.01216.84
7.4.330.0020.00215.00
7.4.320.0000.00616.53
7.4.300.0030.00316.63
7.4.290.0030.00316.53
7.4.280.0000.00816.67
7.4.270.0000.00716.49
7.4.260.0030.00316.58
7.4.250.0050.00316.42
7.4.240.0040.00316.46
7.4.230.0030.00316.64
7.4.220.0090.01016.74
7.4.210.0070.01416.57
7.4.200.0030.00616.73
7.4.160.0120.00616.52
7.4.150.0160.00817.40
7.4.140.0130.00417.86
7.4.130.0130.00516.54
7.4.120.0060.01216.60
7.4.110.0030.01316.73
7.4.100.0070.01016.54
7.4.90.0130.00316.68
7.4.80.0070.01019.39
7.4.70.0130.00316.59
7.4.60.0130.00316.63
7.4.50.0040.00416.56
7.4.40.0100.01416.68
7.4.30.0070.01116.55
7.4.10.0030.01514.97
7.4.00.0090.00915.11
7.3.330.0030.00313.35
7.3.320.0000.00513.28
7.3.310.0030.00316.41
7.3.300.0000.00716.47
7.3.290.0130.00416.42
7.3.280.0100.00716.43
7.3.270.0030.01317.40
7.3.260.0090.00816.55
7.3.240.0080.00916.40
7.3.230.0150.00616.43
7.3.210.0080.00816.58
7.3.200.0060.01319.39
7.3.190.0110.00716.53
7.3.180.0070.00816.38
7.3.170.0100.00716.50
7.3.160.0090.00616.48
7.3.130.0100.00714.96
7.3.120.0040.01414.62
7.3.110.0060.01014.75
7.3.100.0070.00415.07
7.3.90.0100.00714.75
7.3.80.0100.00314.89
7.3.70.0030.01014.94
7.3.60.0000.00914.94
7.3.50.0060.00614.97
7.3.40.0070.01015.07
7.3.30.0000.01014.82
7.3.20.0070.00716.64
7.3.10.0060.00716.62
7.3.00.0020.00916.76
7.2.330.0040.02016.53
7.2.320.0100.01016.66
7.2.310.0060.01416.73
7.2.300.0210.00016.88
7.2.290.0170.00616.81
7.2.260.0060.00915.09
7.2.250.0110.00714.82
7.2.240.0110.00015.33
7.2.230.0030.01315.06
7.2.220.0090.00615.28
7.2.210.0060.00915.18
7.2.200.0120.00015.15
7.2.190.0040.00814.73
7.2.180.0040.01115.07
7.2.170.0070.00415.00
7.2.160.0110.00415.15
7.2.150.0130.00317.01
7.2.140.0030.01317.03
7.2.130.0020.00916.96
7.2.120.0080.00516.95
7.2.110.0020.01116.90
7.2.100.0040.00817.13
7.2.90.0060.01017.01
7.2.80.0050.00916.95
7.2.70.0020.01116.90
7.2.60.0050.00817.07
7.2.50.0050.00616.96
7.2.40.0070.00717.09
7.2.30.0060.00917.01
7.2.20.0070.00716.63
7.2.10.0060.01016.80
7.2.00.0100.00717.82
7.1.330.0100.00315.91
7.1.320.0030.00915.80
7.1.310.0000.01515.56
7.1.300.0000.01115.81
7.1.290.0030.00915.66
7.1.280.0070.00715.82
7.1.270.0060.00315.82
7.1.260.0030.01015.82
7.1.250.0030.00915.75
7.1.240.0090.00615.53
7.1.230.0030.00615.58
7.1.220.0070.00415.54
7.1.210.0000.01715.83
7.1.200.0070.00715.61
7.1.190.0000.01515.93
7.1.180.0000.00815.98
7.1.170.0060.00615.59
7.1.160.0040.01115.61
7.1.150.0060.00915.69
7.1.140.0040.01115.84
7.1.130.0030.01015.90
7.1.120.0070.00715.79
7.1.110.0030.01015.82
7.1.100.0050.00616.88
7.1.90.0100.00316.00
7.1.80.0060.00315.96
7.1.70.0050.00616.46
7.1.60.0080.01217.58
7.1.50.0100.01116.34
7.1.40.0000.01716.01
7.1.30.0100.00615.84
7.1.20.0040.00415.68
7.1.10.0060.01215.96
7.1.00.0070.04118.90
7.0.330.0040.00815.49
7.0.320.0070.00715.59
7.0.310.0030.00615.41
7.0.300.0060.00915.55
7.0.290.0000.01415.57
7.0.280.0090.00615.49
7.0.270.0070.00715.63
7.0.260.0090.00315.50
7.0.250.0070.00715.45
7.0.240.0000.00915.55
7.0.230.0060.00615.59
7.0.220.0030.00715.39
7.0.210.0000.01915.50
7.0.200.0020.01116.03
7.0.190.0070.00715.48
7.0.180.0060.00615.57
7.0.170.0030.01015.58
7.0.160.0030.01015.53
7.0.150.0030.00615.44
7.0.140.0070.03818.66
7.0.130.0060.00715.67
7.0.120.0030.01015.20
7.0.110.0040.00415.60
7.0.100.0000.01115.43
7.0.90.0060.00615.47
7.0.80.0030.01015.65
7.0.70.0030.01015.12
7.0.60.0090.04817.75
7.0.50.0100.02816.76
7.0.40.0050.04216.81
7.0.30.0120.04116.81
7.0.20.0170.02416.85
7.0.10.0020.02816.79
7.0.00.0030.02716.83
5.6.400.0060.00314.82
5.6.390.0080.00614.34
5.6.380.0070.00714.34
5.6.370.0100.00314.68
5.6.360.0090.00614.52
5.6.350.0060.00914.41
5.6.340.0000.01214.14
5.6.330.0070.00714.64
5.6.320.0070.01014.16
5.6.310.0060.00914.51
5.6.300.0090.00614.54
5.6.290.0060.01014.46
5.6.280.0020.04317.66
5.6.270.0100.00314.64
5.6.260.0030.00614.72
5.6.250.0040.01114.54
5.6.240.0070.01114.54
5.6.230.0070.01014.45
5.6.220.0090.00614.39
5.6.210.0100.02117.67
5.6.200.0140.03516.30
5.6.190.0080.03117.49
5.6.180.0130.02517.44
5.6.170.0200.04517.46
5.6.160.0050.04817.44
5.6.150.0090.04016.35
5.6.140.0110.04216.31
5.6.130.0000.03016.27
5.6.120.0100.02717.66
5.6.110.0150.03717.54
5.6.100.0140.02517.82
5.6.90.0030.02817.53
5.6.80.0080.04317.42
5.6.70.0030.01014.18
5.6.60.0040.01114.27
5.6.50.0040.01114.07
5.6.40.0030.00714.33
5.6.30.0000.01014.39
5.6.20.0030.00614.33
5.6.10.0030.01014.43
5.6.00.0040.00714.30
5.5.380.0040.00814.53
5.5.370.0090.00914.26
5.5.360.0130.00314.66
5.5.350.0060.04817.24
5.5.340.0070.02016.09
5.5.330.0100.04017.37
5.5.320.0250.03817.15
5.5.310.0200.02517.32
5.5.300.0080.04316.31
5.5.290.0050.04016.12
5.5.280.0070.03417.52
5.5.270.0030.03117.58
5.5.260.0050.02317.39
5.5.250.0020.04417.67
5.5.240.0130.02517.29
5.5.230.0000.01014.47
5.5.220.0060.00914.16
5.5.210.0040.01414.49
5.5.200.0040.00814.29
5.5.190.0030.00814.30
5.5.180.0110.00314.21
5.5.170.0040.00413.94
5.5.160.0030.01014.16
5.5.150.0000.01414.51
5.5.140.0070.00714.22
5.5.130.0060.00314.36
5.5.120.0040.01114.18
5.5.110.0060.00614.60
5.5.100.0060.00314.48
5.5.90.0140.00014.47
5.5.80.0100.00314.33
5.5.70.0000.01114.47
5.5.60.0060.00314.48
5.5.50.0060.00914.00
5.5.40.0040.00814.39
5.5.30.0080.00813.95
5.5.20.0090.00314.51
5.5.10.0040.01114.21
5.5.00.0040.00414.39
5.4.450.0150.03716.34
5.4.440.0220.02316.44
5.4.430.0180.03716.32
5.4.420.0350.00416.43
5.4.410.0350.00216.47
5.4.400.0320.00316.28
5.4.390.0330.00216.28
5.4.380.0380.00016.24
5.4.370.0320.00316.23
5.4.360.0350.00316.27
5.4.350.0330.00316.29
5.4.340.0020.02412.70
5.4.330.0000.00813.41
5.4.320.0070.02912.94
5.4.310.0070.02912.94
5.4.300.0020.02812.94
5.4.290.0050.02012.94
5.4.280.0040.02112.88
5.4.270.0060.01912.88
5.4.260.0040.02512.88
5.4.250.0040.02712.88
5.4.240.0040.02312.88
5.4.230.0070.01912.88
5.4.220.0070.02412.88
5.4.210.0020.02412.88
5.4.200.0060.02412.88
5.4.190.0020.02112.88
5.4.180.0060.02212.88
5.4.170.0040.02312.88
5.4.160.0060.02112.88
5.4.150.0070.02212.88
5.4.140.0040.02312.72
5.4.130.0070.02412.72
5.4.120.0040.02312.69
5.4.110.0040.02412.69
5.4.100.0040.02412.69
5.4.90.0040.02412.69
5.4.80.0050.02112.69
5.4.70.0080.01612.69
5.4.60.0050.02112.69
5.4.50.0080.02012.69
5.4.40.0020.02112.69
5.4.30.0060.01912.68
5.4.20.0060.02012.68
5.4.10.0050.02412.69
5.4.00.0080.02112.43
5.3.290.0070.04012.80
5.3.280.0090.05212.71
5.3.270.0110.04512.73
5.3.260.0090.03712.72
5.3.250.0060.04012.72
5.3.240.0080.05012.72
5.3.230.0070.03812.71
5.3.220.0070.03812.68
5.3.210.0080.04312.68
5.3.200.0080.03612.68
5.3.190.0090.03512.68
5.3.180.0100.03812.68
5.3.170.0080.03512.66
5.3.160.0060.04212.67
5.3.150.0090.03612.67
5.3.140.0080.03612.66
5.3.130.0060.04312.66
5.3.120.0070.04512.65
5.3.110.0060.04112.66
5.3.100.0090.03812.12
5.3.90.0090.03712.08
5.3.80.0050.03912.08
5.3.70.0080.03812.07
5.3.60.0100.03412.06
5.3.50.0050.03912.00
5.3.40.0090.03512.00
5.3.30.0060.03711.96
5.3.20.0080.04011.74
5.3.10.0050.03711.70
5.3.00.0060.03911.69
5.2.170.0060.0369.19
5.2.160.0060.0359.19
5.2.150.0060.0299.20
5.2.140.0070.0319.19
5.2.130.0050.0339.15
5.2.120.0060.0309.15
5.2.110.0060.0339.16
5.2.100.0050.0349.16
5.2.90.0090.0339.16
5.2.80.0070.0389.15
5.2.70.0050.0329.15
5.2.60.0040.0319.11
5.2.50.0030.0319.07
5.2.40.0050.0329.05
5.2.30.0070.0399.03
5.2.20.0090.0349.03
5.2.10.0070.0288.95
5.2.00.0010.0338.81
5.1.60.0060.0298.09
5.1.50.0040.0288.09
5.1.40.0040.0248.08
5.1.30.0050.0258.43
5.1.20.0050.0268.45
5.1.10.0080.0278.17
5.1.00.0040.0258.17
5.0.50.0050.0206.65
5.0.40.0060.0246.52
5.0.30.0030.0386.32
5.0.20.0040.0216.30
5.0.10.0020.0216.28
5.0.00.0040.0296.27
4.4.90.0020.0234.78
4.4.80.0030.0154.75
4.4.70.0030.0154.76
4.4.60.0040.0144.76
4.4.50.0010.0174.77
4.4.40.0020.0264.71
4.4.30.0020.0164.76
4.4.20.0030.0154.85
4.4.10.0010.0174.85
4.4.00.0040.0234.76
4.3.110.0060.0164.67
4.3.100.0040.0174.67
4.3.90.0060.0114.63
4.3.80.0050.0224.58
4.3.70.0030.0144.63
4.3.60.0030.0144.63
4.3.50.0030.0154.63
4.3.40.0010.0254.54
4.3.30.0030.0163.32
4.3.20.0000.0183.29
4.3.10.0010.0213.24
4.3.00.0100.0207.30

preferences:
43.92 ms | 401 KiB | 5 Q