3v4l.org

run code in 300+ PHP versions simultaneously
<?php $filters = []; $start = 0; $csv = true; $whereClause = " WHERE c.cID IS NOT NULL AND p.status NOT IN ('hidden')"; $orderBy = " ORDER BY "; $params = array(); if(is_null($filters)&& isset($_SESSION['claimfilters']) && !is_null($_SESSION['claimfilters']) && !$csv) $filters = unserialize($_SESSION['claimfilters']); if(!is_null($filters)) { if(isset($filters['pID']) && $filters['pID'] != "" && !is_null($filters['pID'])) { $whereClause .= " AND c.pID = :pID"; $params['pID'] = $filters['pID']; } if(isset($filters['cnID']) && $filters['cnID'] && !is_null($filters['cnID'])) { //$whereClause .= " AND p.cnID = :cnID"; $country = new Country($filters['cnID']); if($country->code=='gb'){$country->code='en';} $whereClause .= " AND con.lang IN ('" . $country->code ."')"; } if(isset($filters['ptID']) && $filters['ptID'] && !is_null($filters['ptID'])) { $whereClause .= " AND p.ptID = :ptID"; $params['ptID'] = $filters['ptID']; } if(isset($filters['customerType']) && $filters['customerType'] != "") { $whereClause .= " AND con.customerType = :customerType"; $params['customerType'] = $filters['customerType']; } if(isset($filters['status']) && $filters['status'] != "") { $whereClause .= " AND c.status = :status"; $params['status'] = $filters['status']; } if(isset($filters['slug']) && $filters['slug'] != "") { $whereClause .= " AND p.slug = :slug"; $params['slug'] = $filters['slug']; } if(isset($filters['redemptionstatus']) && $filters['redemptionstatus'] != "") { $whereClause .= " AND c.cID IN (SELECT DISTINCT(r.cID) FROM claims_redemptions r WHERE r.status = :redemptionstatus)"; $params['redemptionstatus'] = $filters['redemptionstatus']; } if(isset($filters['startDate']) && $filters['startDate'] != "" && isset($filters['endDate']) && $filters['endDate'] != "") { $whereClause .= " AND DATE(c.date_created) BETWEEN :startDate AND :endDate"; $params['startDate'] = $filters['startDate']; $params['endDate'] = $filters['endDate']; } if(isset($filters['sort']) && $filters['sort'] != "") { $orderBy = " e." . $filters['sort']." ".$filters['direction'] . ","; } if(isset($filters['search']) && $filters['search'] != "") { $whereClause .= " AND ( c.cID = '".$filters['search']."' OR con.email LIKE '%".$filters['search']."%' OR con.surname LIKE '%".$filters['search']."%' OR con.postcode LIKE '%".$filters['search']."%' )"; } if(isset($filters['actioneddate']) && $filters['actioneddate'] != "") { if(isset($filters['status']) && $filters['status'] != "") { switch($filters['status']) { case 'processed' : $date = 'date_processed'; break; case 'validated' : $date = 'date_validated'; break; case 'rejected' : $date = 'date_rejected'; break; } $whereClause .= " AND DATE(" . $date . ") = :actioned"; } else { $whereClause .= " AND (DATE(date_processed) = :actioned OR DATE(date_validated) = :actioned OR DATE(date_rejected) = :actioned)"; } $params['actioned'] = $filters['actioneddate']; } } $orderBy .= "c.cID ASC"; if(!$csv) $_SESSION['claimfilters'] = serialize($filters); $sql = "SELECT "; if($count) { $sql .= "COUNT(*)"; } elseif($full) { $sql .= "SQL_CALC_FOUND_ROWS r.*, r.cashback AS r_cashback, c.*, pr.*, con.*, pur.*, DATEDIFF(date_received,invoiceDate) as daysTaken, p.promoName, p.cnID, p.ptID, c.cID AS cID"; } else { $sql .= "SQL_CALC_FOUND_ROWS c.*, con.*, pur.*, DATEDIFF(date_received,invoiceDate) as daysTaken, p.promoName, p.cnID, p.ptID, p.paymentPeriod, c.cID AS cID, (SELECT SUM(cashback) FROM claims_redemptions WHERE cID = c.cID AND `status` NOT IN ('invalid','incomplete')) AS `cashback_amount`"; } if($full) { $sql .= " FROM claims_redemptions r LEFT JOIN claims c ON c.cID = r.cID LEFT JOIN consumers con ON c.conID = con.conID LEFT JOIN claims_purchases pur ON c.cID = pur.cID LEFT JOIN promotions p ON c.pID = p.pID LEFT JOIN promotions_products pr ON r.prID = pr.prID "; } else { $sql .= " FROM claims c LEFT JOIN consumers con ON c.conID = con.conID LEFT JOIN claims_purchases pur ON c.cID = pur.cID LEFT JOIN promotions p ON c.pID = p.pID "; } $sql .= $whereClause . $orderBy; $sql .= (!$csv) ? " LIMIT " . $start . ", " . $GLOBALS['config']->general->num_per_page : ""; die($sql); if(!$count) return DatabaseHandler::GetAll($sql,$params); else return DatabaseHandler::GetOne($sql,$params);

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.0120.00617.00
8.3.50.0170.00522.00
8.3.40.0120.00918.79
8.3.30.0100.00319.13
8.3.20.0000.00720.43
8.3.10.0030.00523.50
8.3.00.0050.00319.81
8.2.180.0180.00417.00
8.2.170.0110.00422.96
8.2.160.0030.01220.32
8.2.150.0040.00424.18
8.2.140.0040.00424.66
8.2.130.0060.00326.16
8.2.120.0040.00419.61
8.2.110.0060.00319.33
8.2.100.0060.00617.80
8.2.90.0030.00619.26
8.2.80.0040.00417.97
8.2.70.0030.00617.75
8.2.60.0090.00517.80
8.2.50.0050.00318.07
8.2.40.0030.00620.00
8.2.30.0000.00818.14
8.2.20.0000.00717.82
8.2.10.0000.00818.10
8.2.00.0080.00018.27
8.1.280.0070.01425.92
8.1.270.0030.00620.37
8.1.260.0040.00426.35
8.1.250.0000.00828.09
8.1.240.0060.00322.27
8.1.230.0040.00719.20
8.1.220.0030.00517.89
8.1.210.0040.00418.77
8.1.200.0060.00317.48
8.1.190.0030.00517.59
8.1.180.0040.00418.10
8.1.170.0000.01018.59
8.1.160.0050.00222.11
8.1.150.0000.00718.95
8.1.140.0030.00517.46
8.1.130.0070.00017.93
8.1.120.0070.00017.55
8.1.110.0000.00917.53
8.1.100.0040.00417.47
8.1.90.0040.00417.60
8.1.80.0080.00017.55
8.1.70.0070.00017.59
8.1.60.0000.00817.73
8.1.50.0040.00417.57
8.1.40.0040.00417.59
8.1.30.0050.00517.65
8.1.20.0040.00417.73
8.1.10.0050.00317.67
8.1.00.0000.00817.55
8.0.300.0040.00418.77
8.0.290.0070.00016.88
8.0.280.0040.00418.51
8.0.270.0050.00217.23
8.0.260.0030.00616.89
8.0.250.0000.00717.06
8.0.240.0030.00617.13
8.0.230.0040.00417.12
8.0.220.0030.00516.96
8.0.210.0080.00317.04
8.0.200.0030.00317.13
8.0.190.0030.00717.08
8.0.180.0040.00417.05
8.0.170.0030.00517.09
8.0.160.0040.00417.08
8.0.150.0030.00417.02
8.0.140.0000.00817.00
8.0.130.0030.00313.51
8.0.120.0000.00816.93
8.0.110.0030.00516.97
8.0.100.0000.00717.07
8.0.90.0080.00016.93
8.0.80.0000.02217.13
8.0.70.0000.00716.96
8.0.60.0000.00817.10
8.0.50.0080.00017.07
8.0.30.0080.01117.31
8.0.20.0100.00817.40
8.0.10.0050.00217.18
8.0.00.0120.00716.93
7.4.330.0030.00315.15
7.4.320.0060.00016.64
7.4.300.0070.00016.60
7.4.290.0020.00516.46
7.4.280.0060.00316.60
7.4.270.0030.00316.65
7.4.260.0070.00016.64
7.4.250.0070.00016.53
7.4.240.0040.00316.74
7.4.230.0000.00716.40
7.4.220.0110.00716.56
7.4.210.0070.01416.57
7.4.200.0030.00316.59
7.4.160.0130.00416.54
7.4.150.0090.00917.40
7.4.140.0100.00917.86
7.4.130.0090.00916.59
7.4.120.0060.01116.65
7.4.110.0100.00716.68
7.4.100.0140.01216.72
7.4.90.0030.01716.57
7.4.80.0090.01219.39
7.4.70.0080.00916.44
7.4.60.0130.00316.52
7.4.50.0000.00416.55
7.4.40.0090.00916.51
7.4.30.0110.00816.75
7.4.10.0060.00914.91
7.4.00.0100.00814.88
7.3.330.0040.00313.14
7.3.320.0050.00013.18
7.3.310.0060.00016.32
7.3.300.0030.00316.46
7.3.290.0060.00816.42
7.3.280.0040.01416.41
7.3.270.0160.00317.40
7.3.260.0070.01116.70
7.3.250.0140.00516.61
7.3.240.0090.00916.50
7.3.230.0060.01216.55
7.3.210.0110.00716.54
7.3.200.0090.00616.51
7.3.190.0070.01016.40
7.3.180.0090.00916.43
7.3.170.0070.01116.53
7.3.160.0060.01216.64
7.3.130.0070.01114.96
7.3.120.0080.00915.05
7.3.110.0080.00814.78
7.3.100.0040.00815.06
7.3.90.0120.00615.00
7.3.80.0040.00714.83
7.3.70.0080.00514.88
7.3.60.0080.00314.95
7.3.50.0100.00514.94
7.3.40.0020.01514.89
7.3.30.0020.01114.88
7.3.20.0130.00716.65
7.3.10.0020.01216.54
7.3.00.0070.00916.70
7.2.330.0080.01216.75
7.2.320.0110.00716.78
7.2.310.0060.01016.56
7.2.300.0150.00616.66
7.2.290.0120.01216.57
7.2.260.0070.01115.16
7.2.250.0070.01014.98
7.2.240.0020.01115.15
7.2.230.0050.01115.15
7.2.220.0050.01215.09
7.2.210.0070.00815.17
7.2.200.0050.01015.15
7.2.190.0090.00315.00
7.2.180.0080.00815.18
7.2.170.0040.01115.12
7.2.160.0120.00315.23
7.2.150.0070.01316.95
7.2.140.0070.00616.94
7.2.130.0070.00916.71
7.2.120.0100.00716.75
7.2.110.0070.00716.69
7.2.100.0110.00316.76
7.2.90.0050.00716.79
7.2.80.0060.00816.94
7.2.70.0030.01016.89
7.2.60.0020.01217.01
7.2.50.0040.01216.84
7.2.40.0080.01016.94
7.2.30.0050.00816.88
7.2.20.0100.00516.87
7.2.10.0060.00916.83
7.2.00.0070.00717.67
7.1.330.0070.00715.72
7.1.320.0110.00615.87
7.1.310.0080.00915.89
7.1.300.0080.00615.85
7.1.290.0020.01115.90
7.1.280.0080.00815.69
7.1.270.0070.00615.64
7.1.260.0100.00315.72
7.1.250.0030.01015.78
7.1.240.0090.00615.62
7.1.230.0090.00315.86
7.1.220.0070.00715.73
7.1.210.0140.00315.95
7.1.200.0000.01215.57
7.1.190.0060.00615.84
7.1.180.0060.00615.77
7.1.170.0110.00415.84
7.1.160.0040.00815.73
7.1.150.0070.00315.78
7.1.140.0030.01215.85
7.1.130.0040.00715.75
7.1.120.0070.00715.69
7.1.110.0030.00616.01
7.1.100.0040.00916.99
7.1.90.0040.01115.65
7.1.80.0000.01115.86
7.1.70.0040.00716.52
7.1.60.0070.01217.88
7.1.50.0070.01016.37
7.1.40.0070.00415.67
7.1.30.0100.01015.88
7.1.20.0030.01215.88
7.1.10.0040.01115.63
7.1.00.0070.03919.05
7.0.330.0030.01315.59
7.0.320.0110.00015.27
7.0.310.0070.00415.39
7.0.300.0040.00715.20
7.0.290.0070.00715.38
7.0.280.0070.00315.48
7.0.270.0030.00915.35
7.0.260.0100.01015.37
7.0.250.0040.00415.52
7.0.240.0030.00915.40
7.0.230.0040.00415.54
7.0.220.0080.00015.66
7.0.210.0000.01315.46
7.0.200.0040.00716.15
7.0.190.0040.00415.37
7.0.180.0030.01015.33
7.0.170.0070.00715.53
7.0.160.0000.01315.49
7.0.150.0070.00315.55
7.0.140.0060.00315.55
7.0.130.0000.01215.61
7.0.120.0060.00315.45
7.0.110.0080.00815.59
7.0.100.0100.00715.37
7.0.90.0030.00615.33
7.0.80.0040.00815.41
7.0.70.0120.00315.45
7.0.60.0100.03317.76
7.0.50.0050.04116.77
7.0.40.0090.04316.71
7.0.30.0150.03316.92
7.0.20.0150.04016.62
7.0.10.0040.03416.90
7.0.00.0080.04616.84
5.6.400.0030.00914.45
5.6.390.0110.00714.68
5.6.380.0060.00314.36
5.6.370.0030.01014.55
5.6.360.0100.00714.46
5.6.350.0030.01014.46
5.6.340.0000.01414.31
5.6.330.0070.00714.72
5.6.320.0040.00814.53
5.6.310.0040.01114.68
5.6.300.0030.00714.50
5.6.290.0080.00014.59
5.6.280.0030.04117.63
5.6.270.0110.00314.74
5.6.260.0070.00714.46
5.6.250.0030.01314.61
5.6.240.0030.01414.41
5.6.230.0000.01514.48
5.6.220.0090.00614.48
5.6.210.0090.04317.45
5.6.200.0030.03316.22
5.6.190.0090.02417.39
5.6.180.0200.02817.27
5.6.170.0180.03817.50
5.6.160.0030.02817.46
5.6.150.0050.02416.17
5.6.140.0050.02816.28
5.6.130.0020.03416.32
5.6.120.0070.03917.79
5.6.110.0050.04417.83
5.6.100.0070.03417.75
5.6.90.0020.04517.73
5.6.80.0120.02317.57
5.6.70.0030.00914.60
5.6.60.0090.00614.50
5.6.50.0090.00614.44
5.6.40.0030.00914.14
5.6.30.0070.00714.43
5.6.20.0030.00814.65
5.6.10.0030.01314.18
5.6.00.0080.00014.35
5.5.380.0030.01014.20
5.5.370.0000.01314.49
5.5.360.0090.00614.36
5.5.350.0130.03817.51
5.5.340.0090.03016.16
5.5.330.0060.03817.38
5.5.320.0170.04617.56
5.5.310.0150.03317.37
5.5.300.0070.04216.11
5.5.290.0050.03116.31
5.5.280.0070.02817.73
5.5.270.0030.02517.46
5.5.260.0070.02217.56
5.5.250.0090.03817.59
5.5.240.0040.04217.20
5.5.230.0030.01414.57
5.5.220.0030.01414.39
5.5.210.0090.00614.40
5.5.200.0080.00314.60
5.5.190.0070.00714.53
5.5.180.0000.00914.05
5.5.170.0030.00914.24
5.5.160.0070.00714.20
5.5.150.0110.00714.42
5.5.140.0040.01214.30
5.5.130.0040.00714.45
5.5.120.0110.00414.41
5.5.110.0090.00614.20
5.5.100.0070.00714.21
5.5.90.0060.00814.39
5.5.80.0000.01714.07
5.5.70.0040.00814.57
5.5.60.0080.00414.45
5.5.50.0100.00614.45
5.5.40.0070.00714.39
5.5.30.0030.00914.64
5.5.20.0100.00314.41
5.5.10.0060.00914.04
5.5.00.0040.01414.35
5.4.450.0130.03515.23
5.4.440.0450.03315.18
5.4.430.0100.03015.29
5.4.420.0040.03515.39
5.4.410.0060.03015.29
5.4.400.0100.02715.23
5.4.390.0160.02015.07
5.4.380.0080.03214.97
5.4.370.0100.02514.96
5.4.360.0120.02715.04
5.4.350.0050.03215.08
5.4.340.0030.03215.18
5.4.330.0030.00611.12
5.4.320.0060.03115.03
5.4.310.0030.03515.08
5.4.300.0050.03615.09
5.4.290.0080.03714.99
5.4.280.0050.03215.00
5.4.270.0060.02815.11
5.4.260.0130.03215.09
5.4.250.0070.03815.08
5.4.240.0070.03214.94
5.4.230.0050.03315.05
5.4.220.0050.03215.22
5.4.210.0050.03314.84
5.4.200.0100.02513.90
5.4.190.0050.03314.86
5.4.180.0080.03015.19
5.4.170.0130.03515.03
5.4.160.0120.02814.98
5.4.150.0070.03015.07
5.4.140.0030.03313.53
5.4.130.0050.02913.72
5.4.120.0050.02613.80
5.4.110.0110.02313.59
5.4.100.0080.02713.49
5.4.90.0030.03113.79
5.4.80.0050.03013.78
5.4.70.0100.02513.76
5.4.60.0070.02913.73
5.4.50.0050.03013.68
5.4.40.0070.03013.82
5.4.30.0140.02013.84
5.4.20.0030.03213.72
5.4.10.0100.02213.86
5.4.00.0050.02813.29
5.3.290.0070.06014.68
5.3.280.0130.04714.38
5.3.270.0100.05314.45
5.3.260.0100.05314.64
5.3.250.0070.05314.52
5.3.240.0100.05014.48
5.3.230.0070.05314.46
5.3.220.0170.05014.40
5.3.210.0070.06014.44
5.3.200.0100.05314.49
5.3.190.0070.06014.41
5.3.180.0070.05314.58
5.3.170.0100.04714.50
5.3.160.0100.04714.52
5.3.150.0300.05014.57
5.3.140.0070.05314.56
5.3.130.0030.05714.33
5.3.120.0170.04714.41
5.3.110.0100.05014.34
5.3.100.0130.04713.88
5.3.90.0200.04013.94
5.3.80.0000.06013.95
5.3.70.0070.05013.92
5.3.60.0130.04313.84
5.3.50.0170.04013.79
5.3.40.0130.04313.73
5.3.30.0070.05013.91
5.3.20.0100.04713.67
5.3.10.0030.05313.50
5.3.00.0070.05013.47
5.2.170.0100.04011.27
5.2.160.0170.03011.15
5.2.150.0070.04011.00
5.2.140.0030.04711.09
5.2.130.0100.03711.05
5.2.120.0100.03310.89
5.2.110.0170.04311.01
5.2.100.0070.04011.10
5.2.90.0100.03311.02
5.2.80.0100.03711.04
5.2.70.0070.04011.04
5.2.60.0070.04011.05
5.2.50.0070.04010.86
5.2.40.0070.04010.99
5.2.30.0000.06310.82
5.2.20.0070.05311.00
5.2.10.0230.03710.86
5.2.00.0070.04310.66
5.1.60.0000.0379.89
5.1.50.0070.03310.09
5.1.40.0170.0339.91
5.1.30.0000.05710.19
5.1.20.0170.03010.30
5.1.10.0000.0379.97
5.1.00.0070.0339.98
5.0.50.0000.0308.65
5.0.40.0030.0278.30
5.0.30.0070.0408.14
5.0.20.0000.0308.24
5.0.10.0070.0278.19
5.0.00.0070.0408.06
4.4.90.0000.0235.87
4.4.80.0070.0175.73
4.4.70.0000.0235.76
4.4.60.0070.0175.84
4.4.50.0030.0235.82
4.4.40.0030.0335.74
4.4.30.0000.0235.75
4.4.20.0000.0275.80
4.4.10.0070.0175.81
4.4.00.0070.0305.94
4.3.110.0030.0205.73
4.3.100.0070.0175.70
4.3.90.0030.0235.65
4.3.80.0030.0335.65
4.3.70.0000.0275.65
4.3.60.0030.0205.66
4.3.50.0030.0205.66
4.3.40.0000.0375.64
4.3.30.0000.0274.89
4.3.20.0000.0234.89
4.3.10.0000.0234.89
4.3.00.0130.0237.29

preferences:
40.4 ms | 401 KiB | 5 Q