3v4l.org

run code in 300+ PHP versions simultaneously
<?php /** * @author Brian Sandes * brian.sandes@gmail.com * Post class * Servus! Open-Source Development Framework */ class Product extends AppModel { public $Table = "{__PREF__}products"; public $Fields = Array( "id" => Array("extra" => "auto_increment"), "product_category_id" => Array("required" => true), "product_subcategory_id" => Array("required" => true), "line_id" => Array("required" => true), "name" => Array("type" => "text", "required" => true), "description" => Array("type" => "text"), "code" => Array("type" => "text"), "model" => Array("type" => "text"), "details" => Array("type" => "text", "class" => "simple-tinymce"), "blueprint" => Array("type" => "file"), "guide" => Array("type" => "file"), "dwg" => Array("type" => "file"), "video" => Array("type" => "text"), "bndes" => Array("type" => "checkbox"), "ambient" => Array(), "display_order" => Array("type" => "text"), "date" => Array("function" => "return date('Y-m-d H:i:s');", "display" => "return toDate('\$1', 'd/m/Y H:i:s');"), "last_update" => Array("display" => "return toDate('\$1', 'd/m/Y H:i:s');"), "status" => Array("type" => "radio") ); public static $Conf = Array( "mode" => "LAED", "grid" => Array("id", "name", "code", "category", "subcategory", "product_line", "last_update"), "icon" => "icon-shopping-cart" ); public function AltQuery($where = null, $plus = null) { $ProductCategory = new ProductCategory(); $ProductLine = new ProductLine(); $ProductImage = new ProductImage(); $Href = new Href(); return "SELECT {$this->Table}.*, c1.name as category, c2.name as subcategory, {$ProductLine->Table}.name as product_line, {$ProductImage->Table}.name as listing_image, {$Href->Table}.ref as ref FROM {$this->Table} LEFT OUTER JOIN {$ProductCategory->Table} c1 ON {$this->Table}.product_category_id = c1.id LEFT OUTER JOIN {$ProductCategory->Table} c2 ON {$this->Table}.product_subcategory_id = c2.id LEFT OUTER JOIN {$ProductLine->Table} ON {$this->Table}.line_id = {$ProductLine->Table}.id LEFT OUTER JOIN {$ProductImage->Table} ON {$ProductImage->Table}.product_id = {$this->Table}.id AND {$ProductImage->Table}.type = 'listing' LEFT OUTER JOIN {$Href->Table} ON {$Href->Table}.content_id = {$this->Table}.id and {$Href->Table}.type = 'product' $where GROUP BY {$this->Table}.id $plus"; } } ?>

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.0130.00318.20
8.3.50.0100.00821.08
8.3.40.0150.00318.92
8.3.30.0070.00720.20
8.3.20.0050.00318.77
8.3.10.0000.00820.92
8.3.00.0070.00023.82
8.2.180.0070.01116.75
8.2.170.0120.00322.96
8.2.160.0070.00720.40
8.2.150.0000.00824.18
8.2.140.0070.00024.66
8.2.130.0070.00026.16
8.2.120.0090.00019.70
8.2.110.0120.00620.53
8.2.100.0070.00418.03
8.2.90.0000.00719.23
8.2.80.0030.00519.34
8.2.70.0030.00617.75
8.2.60.0050.00317.93
8.2.50.0030.00618.07
8.2.40.0000.00819.89
8.2.30.0000.00719.52
8.2.20.0000.00717.76
8.2.10.0040.00417.79
8.2.00.0050.00317.70
8.1.280.0140.00725.92
8.1.270.0040.00423.99
8.1.260.0040.00426.35
8.1.250.0030.00528.09
8.1.240.0090.00022.47
8.1.230.0080.00420.89
8.1.220.0000.00818.77
8.1.210.0050.00318.85
8.1.200.0000.00917.22
8.1.190.0040.00417.40
8.1.180.0030.00618.10
8.1.170.0000.00818.64
8.1.160.0040.00418.87
8.1.150.0040.00418.68
8.1.140.0030.00617.46
8.1.130.0030.00317.77
8.1.120.0030.00517.42
8.1.110.0060.00317.39
8.1.100.0000.00817.36
8.1.90.0030.00517.33
8.1.80.0050.00317.32
8.1.70.0040.00417.43
8.1.60.0050.00517.55
8.1.50.0040.00417.46
8.1.40.0030.00517.35
8.1.30.0000.00917.66
8.1.20.0060.00317.56
8.1.10.0000.00817.55
8.1.00.0050.00217.41
8.0.300.0040.00420.21
8.0.290.0000.00717.18
8.0.280.0040.00318.50
8.0.270.0040.00416.84
8.0.260.0030.00316.98
8.0.250.0050.00317.07
8.0.240.0040.00417.05
8.0.230.0030.00317.05
8.0.220.0000.00617.00
8.0.210.0030.00316.87
8.0.200.0040.00417.01
8.0.190.0060.00317.00
8.0.180.0070.00016.95
8.0.170.0000.00716.91
8.0.160.0070.00016.98
8.0.150.0050.00217.04
8.0.140.0000.00716.87
8.0.130.0000.00513.36
8.0.120.0040.00416.93
8.0.110.0040.00417.02
8.0.100.0020.00516.98
8.0.90.0000.00816.89
8.0.80.0080.00616.98
8.0.70.0040.00416.81
8.0.60.0000.00816.82
8.0.50.0070.00016.83
8.0.30.0120.00817.09
8.0.20.0260.00517.40
8.0.10.0050.00216.95
8.0.00.0110.00916.88
7.4.330.0030.00316.74
7.4.320.0000.00716.51
7.4.300.0060.00016.46
7.4.290.0030.00316.51
7.4.280.0000.00816.40
7.4.270.0000.00716.49
7.4.260.0000.00613.26
7.4.250.0040.00416.45
7.4.240.0030.00316.61
7.4.230.0030.00316.37
7.4.220.0060.01516.43
7.4.210.0070.00916.54
7.4.200.0030.00416.55
7.4.190.0070.00016.74
7.4.160.0130.00316.56
7.4.150.0030.01417.40
7.4.140.0090.00817.86
7.4.130.0110.01016.52
7.4.120.0140.00516.54
7.4.110.0130.00516.61
7.4.100.0070.01016.40
7.4.90.0150.00916.33
7.4.80.0060.01219.39
7.4.70.0060.01416.77
7.4.60.0060.01016.44
7.4.50.0030.00516.42
7.4.40.0060.00922.77
7.4.30.0070.01116.70
7.4.00.0060.00915.05
7.3.330.0030.00313.31
7.3.320.0000.00613.15
7.3.310.0040.00416.15
7.3.300.0070.00016.33
7.3.290.0030.01016.38
7.3.280.0050.01416.35
7.3.270.0120.00617.40
7.3.260.0160.00818.24
7.3.250.0080.00916.52
7.3.240.0220.00016.46
7.3.230.0070.01016.39
7.3.210.0070.01716.44
7.3.200.0140.00319.39
7.3.190.0040.01416.43
7.3.180.0060.00916.48
7.3.170.0120.00916.51
7.3.160.0040.01516.32
7.3.120.0040.00414.88
7.2.330.0120.00616.49
7.2.320.0120.00616.29
7.2.310.0070.01116.46
7.2.300.0100.00616.70
7.2.290.0100.00716.69
7.2.00.0060.00919.03
7.1.100.0070.00717.81
7.1.70.0030.00516.95
7.1.60.0040.01219.17
7.1.50.0100.01616.79
7.1.00.0070.06022.45
7.0.200.0040.00416.53
7.0.140.0130.06322.01
7.0.100.0070.07721.74
7.0.90.0200.07021.73
7.0.80.0000.07021.66
7.0.70.0030.08021.70
7.0.60.0030.08321.69
7.0.50.0100.08022.20
7.0.40.0170.07020.15
7.0.30.0100.05720.06
7.0.20.0100.07720.11
7.0.10.0100.07320.10
7.0.00.0130.07020.14
5.6.280.0000.09721.16
5.6.250.0070.08720.73
5.6.240.0200.07320.67
5.6.230.0030.09020.57
5.6.220.0070.07720.59
5.6.210.0030.08720.69
5.6.200.0130.07021.02
5.6.190.0070.08321.06
5.6.180.0070.08021.21
5.6.170.0070.08321.06
5.6.160.0170.07721.17
5.6.150.0100.07721.21
5.6.140.0070.08021.17
5.6.130.0100.07720.99
5.6.120.0070.08321.04
5.6.110.0070.04720.97
5.6.100.0030.08721.04
5.6.90.0130.07321.13
5.6.80.0070.06720.42
5.6.70.0100.07320.46
5.6.60.0100.07720.43
5.6.50.0000.07320.36
5.6.40.0070.07320.41
5.6.30.0070.07320.50
5.6.20.0030.07720.41
5.6.10.0130.07320.40
5.6.00.0070.06720.42
5.5.380.0100.07720.48
5.5.370.0000.08020.45
5.5.360.0100.07320.57
5.5.350.0070.07720.40
5.5.340.0170.07720.87
5.5.330.0100.07720.87
5.5.320.0130.07320.83
5.5.310.0070.08320.82
5.5.300.0130.04320.95
5.5.290.0030.07720.95
5.5.280.0130.08020.89
5.5.270.0030.08020.91
5.5.260.0100.05720.93
5.5.250.0130.07320.66
5.5.240.0000.08020.18
5.5.230.0100.08020.33
5.5.220.0100.06720.30
5.5.210.0070.08020.28
5.5.200.0170.06720.27
5.5.190.0030.08720.28
5.5.180.0030.08320.09
5.5.160.0030.08320.31
5.5.150.0000.07720.15
5.5.140.0070.07720.21
5.5.130.0030.05320.01
5.5.120.0100.06020.26
5.5.110.0130.07320.28
5.5.100.0070.07320.19
5.5.90.0030.08320.10
5.5.80.0030.08020.19
5.5.70.0070.08720.16
5.5.60.0070.07320.13
5.5.50.0070.07019.93
5.5.40.0070.08020.18
5.5.30.0000.08020.08
5.5.20.0100.08320.05
5.5.10.0030.07720.15
5.5.00.0170.06720.16
5.4.450.0070.08319.47
5.4.440.0000.09019.55
5.4.430.0030.08719.37
5.4.420.0070.07319.22
5.4.410.0030.07319.34
5.4.400.0170.06719.13
5.4.390.0070.06018.90
5.4.380.0070.07719.14
5.4.370.0070.07719.24
5.4.360.0130.07019.04
5.4.350.0130.07018.90
5.4.340.0030.08019.13
5.4.320.0000.06018.87
5.4.310.0130.06719.05
5.4.300.0030.06318.88
5.4.290.0030.07319.16
5.4.280.0100.08019.04
5.4.270.0070.07719.14
5.4.260.0100.07319.21
5.4.250.0030.05319.09
5.4.240.0030.07318.81
5.4.230.0070.07719.15
5.4.220.0070.08018.89
5.4.210.0100.05719.02
5.4.200.0000.05719.09
5.4.190.0070.07719.04
5.4.180.0000.07719.20
5.4.170.0130.06718.87
5.4.160.0070.05319.01
5.4.150.0100.05018.86
5.4.140.0100.07016.37
5.4.130.0070.07016.41
5.4.120.0070.06716.30
5.4.110.0030.07716.45
5.4.100.0030.07316.46
5.4.90.0030.07716.37
5.4.80.0100.07016.40
5.4.70.0070.07016.34
5.4.60.0030.07316.35
5.4.50.0130.06316.40
5.4.40.0100.06316.42
5.4.30.0030.07316.49
5.4.20.0100.06716.49
5.4.10.0100.05716.29
5.4.00.0100.04715.82
5.3.290.0030.08014.63
5.3.280.0070.07714.64
5.3.270.0100.07314.55
5.3.260.0100.07314.56
5.3.250.0030.07714.61
5.3.240.0030.08314.70
5.3.230.0070.07714.64
5.3.220.0070.07714.52
5.3.210.0030.07314.66
5.3.200.0070.07714.66
5.3.190.0170.07014.52
5.3.180.0030.08014.66
5.3.170.0100.04014.56
5.3.160.0170.07014.58
5.3.150.0000.08314.57
5.3.140.0070.06714.72
5.3.130.0000.07714.63
5.3.120.0070.08014.53
5.3.110.0070.07314.68
5.3.100.0030.05014.05
5.3.90.0030.05014.08
5.3.80.0030.07014.05
5.3.70.0000.04714.08
5.3.60.0030.04713.96
5.3.50.0100.07313.98
5.3.40.0070.07014.07
5.3.30.0000.08013.94
5.3.20.0070.07713.78
5.3.10.0100.04713.77
5.3.00.0070.07013.80
5.2.170.0030.05311.24
5.2.160.0030.04011.20
5.2.150.0070.06011.29
5.2.140.0070.06011.00
5.2.130.0100.05711.15
5.2.120.0070.06311.19
5.2.110.0030.06011.05
5.2.100.0030.06011.04
5.2.90.0000.05711.25
5.2.80.0000.06711.14
5.2.70.0000.04311.18
5.2.60.0000.06711.14
5.2.50.0000.05310.97
5.2.40.0070.05710.89
5.2.30.0030.06310.91
5.2.20.0000.06310.87
5.2.10.0000.06310.92
5.2.00.0070.05710.80
5.1.60.0000.06010.11
5.1.50.0000.05710.16
5.1.40.0030.05310.01
5.1.30.0100.05310.41
5.1.20.0030.05710.40
5.1.10.0030.0579.96
5.1.00.0100.05010.25
5.0.50.0070.0409.79
5.0.40.0030.0239.79
5.0.30.0030.0639.79
5.0.20.0030.0379.79
5.0.10.0000.0239.79
5.0.00.0000.0539.79
4.4.90.0000.0379.79
4.4.80.0030.0309.79
4.4.70.0030.0339.79
4.4.60.0000.0379.79
4.4.50.0000.0339.79
4.4.40.0000.0539.79
4.4.30.0100.0279.79
4.4.20.0000.0379.79
4.4.10.0000.0339.79
4.4.00.0000.0539.79
4.3.110.0000.0379.79
4.3.100.0030.0209.79
4.3.90.0000.0279.79
4.3.80.0000.0279.79
4.3.70.0000.0239.79
4.3.60.0000.0209.79
4.3.50.0030.0179.79
4.3.40.0030.0239.79
4.3.30.0030.0239.79
4.3.20.0000.0239.79
4.3.10.0000.0179.79
4.3.00.0000.0339.79

preferences:
45.38 ms | 401 KiB | 5 Q