3v4l.org

run code in 300+ PHP versions simultaneously
<?php namespace Lunnar\Bundle\CustomRepositories; use Doctrine\ORM\EntityRepository; class ProfileRepository extends EntityRepository{ public function RandomProfilesWithLimit($Limit){ $numbers = $this->getEntityManager() ->createQuery( 'SELECT p.id FROM LunnarBundle:Profile p' )->getResult(); shuffle($numbers); $numbers = array_slice($numbers, 0, $Limit); $query = 'SELECT p FROM LunnarBundle:Profile p WHERE p.id in ('; foreach($numbers as $number){ foreach($number as $key){ $query = $query.$key.','; } } $query = substr($query, 0, -1); $query = $query.')'; return $this->getEntityManager() ->createQuery( $query )->getResult(); } public function getProfilesBySearch($searchString, $isMapSearch = false){ $searchString = strtolower($searchString); $em = $this->getEntityManager(); $cit = $em->getRepository('LunnarBundle:City')->findAll(); $cat = $em->getRepository('LunnarBundle:Profilecategory')->findAll(); $cities = array(); $categories = array(); foreach($cit as $city){ array_push($cities, strtolower($city->getName())); } foreach($cat as $category){ array_push($categories, strtolower($category->getName())); } $parameters = array( 'var' => '%'.$searchString.'%', ); $searchQuery = "SELECT p FROM LunnarBundle:Profile p LEFT JOIN p.divisions d LEFT JOIN p.brand b LEFT JOIN p.profilecategory pc LEFT JOIN d.city c WHERE ( p.name LIKE :var OR (d.name LIKE :var AND d.maindivision = true )OR b.name LIKE :var OR pc.name LIKE :var OR c.name LIKE :var ) ORDER BY p.name ASC"; $query = $this->getEntityManager() ->createQuery( $searchQuery )->setParameters($parameters); return $query->getResult(); } public function getProfilesExperimental($searchString, $isMapSearch = false){ $searchString = strtolower($searchString); $em = $this->getEntityManager(); $cit = $em->getRepository('LunnarBundle:City')->findAll(); $cat = $em->getRepository('LunnarBundle:Profilecategory')->findAll(); $bra = $em->getRepository('LunnarBundle:Brand')->findAll(); $cities = array(); $profilecategories = array(); $brands = array(); foreach($cit as $city){ array_push($cities, strtolower($city->getName())); } foreach($cat as $category){ array_push($profilecategories, strtolower($category->getName())); } foreach($bra as $brand){ array_push($brands, strtolower($brand->getName())); } $parameters = array(); //'var' => '%'.$searchString.'%', $searchQuerySelectJoin = "SELECT p FROM LunnarBundle:Profile p LEFT JOIN p.divisions d "; $searchQueryWhere = ""; ////////////////////////// $searchStringArray = explode(" ", $searchString); // Remove í, á and við $removeWords = array('í','á','við'); //Find city, category, brand and save for later, and remove them from $searchStringArray $searchStringArray = array_diff($searchStringArray, $removeWords); $city = array_intersect($searchStringArray, $cities); $searchStringArray = array_diff($searchStringArray, $city); $category = array_intersect($searchStringArray, $profilecategories); $searchStringArray = array_diff($searchStringArray, $category); $brand = array_intersect($searchStringArray, $brands); $searchStringArray = array_diff($searchStringArray, $brand); //// PRINTS print_r($searchStringArray); echo '<br/>'; //print_r($city); //print_r($profilecategory); //print_r($brand); $first = true; $searchTerms = " "; if (sizeof($searchStringArray)>0){ $searchTerms = current($searchStringArray); $parameters['var'] = "%".$searchTerms."%"; $searchQueryWhere = "WHERE ( p.name LIKE :var ".$searchQueryWhere; $first = false; } elseif (sizeof($searchStringArray)==0){ $searchQueryWhere = " WHERE ( ".$searchQueryWhere; } if ($category){ $parameters['category'] = $category; $searchQuerySelectJoin .= " LEFT JOIN p.profilecategory pc "; if (!$first){ $searchQueryWhere .= " AND pc.name = :category "; }else { $first = false; $searchQueryWhere .= " pc.name = :category "; } } if ($brand){ $parameters['brand'] = $brand; $searchQuerySelectJoin .= " LEFT JOIN p.brand b "; if (!$first){ $searchQueryWhere .= " AND b.name = :brand "; }else { $first = false; $searchQueryWhere .= " b.name = :brand "; } } if ($city){ $parameters['city'] = $city; $searchQuerySelectJoin .= " LEFT JOIN d.city c "; if (!$first){ $searchQueryWhere .= " AND c.name = :city "; }else { $first = false; $searchQueryWhere .= " c.name = :city "; } } ////////////////////////// if($isMapSearch == true){ $searchQuery .= "AND d.latitude IS NOT NULL "; } $searchQuery = $searchQuerySelectJoin.$searchQueryWhere." ) ORDER BY p.name ASC"; echo $searchQuery; $query = $this->getEntityManager() ->createQuery( $searchQuery )->setParameters($parameters); return $query->getResult(); } }

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.0.110.0040.00417.07
8.0.100.0040.00416.86
8.0.90.0040.00417.10
8.0.80.0090.00616.99
8.0.70.0090.00016.85
8.0.60.0000.00717.08
8.0.50.0000.00817.09
8.0.30.0100.01017.21
8.0.20.0140.00617.40
8.0.10.0030.00317.17
8.0.00.0110.00716.87
7.4.240.0040.00416.62
7.4.230.0070.00016.44
7.4.220.0060.01216.63
7.4.210.0040.01116.73
7.4.200.0030.00316.74
7.4.160.0110.00516.76
7.4.150.0100.00917.40
7.4.140.0090.00917.86
7.4.130.0090.00916.66
7.4.120.0110.00616.68
7.4.110.0120.00616.60
7.4.100.0070.01616.75
7.4.90.0060.01216.57
7.4.80.0160.00619.39
7.4.70.0010.01916.65
7.4.60.0100.00716.56
7.4.50.0000.00816.34
7.4.40.0130.01016.53
7.4.30.0040.01216.46
7.4.10.0070.01115.09
7.4.00.0090.00815.14
7.3.300.0030.00316.41
7.3.290.0060.01316.39
7.3.280.0080.00816.40
7.3.270.0090.00917.40
7.3.260.0000.01916.52
7.3.250.0100.00716.54
7.3.240.0120.00616.45
7.3.230.0050.01316.39
7.3.210.0070.01116.41
7.3.200.0030.01319.39
7.3.190.0140.00816.51
7.3.180.0030.01416.38
7.3.170.0030.01316.63
7.3.160.0080.00816.70
7.3.130.0040.01515.18
7.3.120.0060.00914.90
7.3.110.0160.00415.02
7.3.100.0000.01415.05
7.3.90.0060.00914.74
7.3.80.0030.01315.17
7.3.70.0080.00014.93
7.3.60.0040.01114.98
7.3.50.0070.00714.88
7.3.40.0070.00714.75
7.3.30.0060.00914.88
7.3.20.0120.00316.38
7.3.10.0060.00616.54
7.3.00.0060.00616.58
7.2.330.0090.00916.54
7.2.320.0100.00716.42
7.2.310.0080.00916.34
7.2.300.0140.00316.60
7.2.290.0130.00316.63
7.2.260.0060.01214.91
7.2.250.0090.00914.96
7.2.240.0030.01014.92
7.2.230.0030.01214.68
7.2.220.0060.00614.72
7.2.210.0040.01214.92
7.2.200.0040.01215.15
7.2.190.0030.01214.95
7.2.180.0030.00614.67
7.2.170.0070.01015.08
7.2.160.0000.01714.74
7.2.150.0040.01116.70
7.2.140.0030.01316.79
7.2.130.0070.01116.71
7.2.120.0100.00716.91
7.2.110.0120.00316.92
7.2.100.0060.00916.68
7.2.90.0070.01016.74
7.2.80.0060.00916.84
7.2.70.0070.00716.52
7.2.60.0070.01116.69
7.2.50.0040.01116.84
7.2.40.0030.01316.94
7.2.30.0060.00916.84
7.2.20.0030.01016.56
7.2.10.0070.00416.74
7.2.00.0100.00616.59
7.1.330.0030.01015.67
7.1.320.0000.01015.35
7.1.310.0030.01215.38
7.1.300.0000.01315.60
7.1.290.0070.00315.48
7.1.280.0000.00915.55
7.1.270.0030.01015.61
7.1.260.0030.00915.82
7.1.250.0120.00315.59
7.1.240.0040.00415.54
7.1.230.0060.00315.66
7.1.220.0090.00315.51
7.1.210.0040.01115.59
7.1.200.0030.00915.46
7.1.190.0070.00415.54
7.1.180.0060.00615.39
7.1.170.0040.00415.50
7.1.160.0030.00915.61
7.1.150.0000.00915.80
7.1.140.0100.00315.68
7.1.130.0040.01115.59
7.1.120.0030.01015.44
7.1.110.0030.00715.83
7.1.100.0030.01015.58
7.1.90.0090.00415.61
7.1.80.0030.01015.66
7.1.70.0340.00615.47
7.1.60.0110.00917.46
7.1.50.0040.01316.28
7.1.40.0070.00715.64
7.1.30.0060.00615.42
7.1.20.0100.00715.56
7.1.10.0070.01015.35
7.1.00.0020.04518.93
7.0.330.0040.01115.19
7.0.320.0060.00915.22
7.0.310.0040.00815.30
7.0.300.0030.00715.52
7.0.290.0060.00615.19
7.0.280.0000.00915.23
7.0.270.0040.00415.29
7.0.260.0000.01415.23
7.0.250.0000.01315.02
7.0.240.0030.00715.31
7.0.230.0060.00315.47
7.0.220.0030.00615.34
7.0.210.0000.01115.45
7.0.200.0030.00815.91
7.0.190.0040.01115.34
7.0.180.0000.01215.30
7.0.170.0030.01015.36
7.0.160.0060.01215.33
7.0.150.0090.00315.31
7.0.140.0020.04318.66
7.0.130.0040.01115.23
7.0.120.0080.00815.39
7.0.110.0000.01315.38
7.0.100.0000.01315.19
7.0.90.0040.01115.46
7.0.80.0000.01415.20
7.0.70.0120.00315.20
7.0.60.0090.03017.63
7.0.50.0050.02416.65
7.0.40.0070.03116.89
7.0.30.0200.02316.70
7.0.20.0120.02616.63
7.0.10.0100.03416.71
7.0.00.0090.03716.65
5.6.400.0000.01414.09
5.6.390.0030.01514.20
5.6.380.0030.01014.11
5.6.370.0130.00013.91
5.6.360.0070.00714.38
5.6.350.0030.01014.23
5.6.340.0030.00914.25
5.6.330.0000.01414.10
5.6.320.0040.00814.05
5.6.310.0000.01214.24
5.6.300.0000.01014.34
5.6.290.0090.00314.13
5.6.280.0000.04117.47
5.6.270.0070.00414.40
5.6.260.0030.01414.25
5.6.250.0000.01314.17
5.6.240.0100.00314.48
5.6.230.0100.00714.07
5.6.220.0070.00714.07
5.6.210.0080.04117.51
5.6.200.0070.04316.38
5.6.190.0040.04517.37
5.6.180.1730.02917.35
5.6.170.0210.03617.49
5.6.160.0110.02017.50
5.6.150.0050.04916.14
5.6.140.0040.04716.19
5.6.130.0050.02116.16
5.6.120.0140.02717.55
5.6.110.0100.02017.59
5.6.100.0070.02517.60
5.6.90.0030.04617.62
5.6.80.0100.02817.31
5.6.70.2220.02717.22
5.6.60.0140.00714.19
5.6.50.0070.01114.22
5.6.40.0000.01414.26
5.6.30.0070.00714.25
5.6.20.0000.01114.20
5.6.10.0100.00414.03
5.6.00.0030.01014.01
5.5.380.0000.01614.19
5.5.370.0030.01013.84
5.5.360.0040.00713.85
5.5.350.0200.03817.22
5.5.340.0030.02816.03
5.5.330.0050.03117.41
5.5.320.0250.03817.26
5.5.310.0230.03817.13
5.5.300.0070.02316.02
5.5.290.0120.04216.03
5.5.280.0090.02517.63
5.5.270.0100.04117.63
5.5.260.0020.04817.27
5.5.250.0090.03517.46
5.5.240.0170.03716.98
5.5.230.0070.01113.94
5.5.220.0110.01113.78
5.5.210.0070.00713.94
5.5.200.0120.00314.17
5.5.190.0070.01013.84
5.5.180.0040.00814.16
5.5.170.0030.00714.04
5.5.160.0080.00813.70
5.5.150.0070.00713.90
5.5.140.0030.00714.06
5.5.130.0000.01414.12
5.5.120.0030.01213.61
5.5.110.0070.00714.15
5.5.100.0030.00614.10
5.5.90.0040.00414.00
5.5.80.0060.01014.14
5.5.70.0070.01013.95
5.5.60.0060.00914.21
5.5.50.0060.01014.11
5.5.40.0090.00313.84
5.5.30.0070.00714.04
5.5.20.0030.00713.86
5.5.10.0040.01214.03
5.5.00.0070.01013.81
5.4.450.0150.02515.10
5.4.440.0130.03515.00
5.4.430.0210.02615.23
5.4.420.0190.02415.06
5.4.410.0210.02115.04
5.4.400.0100.02514.95
5.4.390.0140.02314.89
5.4.380.0150.03514.75
5.4.370.0470.03114.74
5.4.360.0460.03414.78
5.4.350.0400.03214.73
5.4.340.0470.02414.80
5.4.330.0030.00610.61
5.4.320.0050.02511.64
5.4.310.0050.02211.67
5.4.300.0080.02711.47
5.4.290.0040.03211.53
5.4.280.0060.02211.51
5.4.270.0020.02311.43
5.4.260.0040.02411.62
5.4.250.0030.02511.56
5.4.240.0070.01911.56
5.4.230.0080.02611.59
5.4.220.0050.02411.52
5.4.210.0050.01911.59
5.4.200.0020.02611.51
5.4.190.0040.02111.64
5.4.180.0040.02611.64
5.4.170.0050.02711.65
5.4.160.0060.02311.71
5.4.150.0060.02311.71
5.4.140.0080.02211.49
5.4.130.0080.02011.31
5.4.120.0070.02811.43
5.4.110.0080.02511.46
5.4.100.0070.02711.48
5.4.90.0080.02211.33
5.4.80.0040.02111.42
5.4.70.0040.02411.43
5.4.60.0040.02111.42
5.4.50.0060.02111.55
5.4.40.0040.02211.46
5.4.30.0020.02211.39
5.4.20.0050.02111.33
5.4.10.0070.02411.27
5.4.00.0050.02311.19
5.3.290.0090.04012.80
5.3.280.0090.03712.73
5.3.270.0080.03912.74
5.3.260.0090.03812.73
5.3.250.0100.03612.74
5.3.240.0100.03412.74
5.3.230.0080.03912.73
5.3.220.0030.04212.70
5.3.210.0060.03912.70
5.3.200.0080.03612.70
5.3.190.0040.04112.70
5.3.180.0070.03712.70
5.3.170.0080.03912.70
5.3.160.0060.03712.69
5.3.150.0030.05112.69
5.3.140.0060.04212.68
5.3.130.0110.04612.68
5.3.120.0100.03812.68
5.3.110.0080.04612.68
5.3.100.0050.04212.18
5.3.90.0080.03512.15
5.3.80.0080.03612.15
5.3.70.0030.04012.14
5.3.60.0060.03812.13
5.3.50.0060.03912.07
5.3.40.0070.04512.07
5.3.30.0090.05112.04
5.3.20.0100.03611.81
5.3.10.0050.03611.78
5.3.00.0030.04011.76
5.2.170.0090.0309.18
5.2.160.0070.0309.19
5.2.150.0080.0289.18
5.2.140.0080.0289.18
5.2.130.0050.0289.14
5.2.120.0030.0319.15
5.2.110.0080.0269.15
5.2.100.0080.0299.15
5.2.90.0090.0279.14
5.2.80.0030.0329.14
5.2.70.0060.0299.14
5.2.60.0060.0349.10
5.2.50.0000.0349.07
5.2.40.0050.0289.04
5.2.30.0060.0289.02
5.2.20.0070.0289.00
5.2.10.0080.0268.93
5.2.00.0060.0398.79
5.1.60.0080.0288.07
5.1.50.0060.0328.07
5.1.40.0090.0318.05
5.1.30.0050.0368.40
5.1.20.0040.0318.42
5.1.10.0090.0348.14
5.1.00.0100.0378.15
5.0.50.0050.0296.63
5.0.40.0050.0276.48
5.0.30.0050.0316.30
5.0.20.0050.0186.27
5.0.10.0030.0216.25
5.0.00.0030.0326.24
4.4.90.0030.0164.78
4.4.80.0050.0184.75
4.4.70.0050.0184.75
4.4.60.0000.0184.76
4.4.50.0030.0164.77
4.4.40.0060.0324.71
4.4.30.0030.0204.76
4.4.20.0030.0174.84
4.4.10.0030.0224.85
4.4.00.0050.0274.76
4.3.110.0040.0214.67
4.3.100.0050.0134.66
4.3.90.0050.0134.63
4.3.80.0030.0324.59
4.3.70.0010.0164.63
4.3.60.0000.0174.62
4.3.50.0030.0194.63
4.3.40.0020.0254.54
4.3.30.0040.0143.29
4.3.20.0030.0163.26
4.3.10.0030.0183.23
4.3.00.0000.02015.94

preferences:
28.43 ms | 401 KiB | 5 Q