Symfony Profiler

<?php
namespace App\Controller;
use Pimcore\Controller\FrontendController;
use Symfony\Component\HttpFoundation\Request;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
use Symfony\Component\Routing\Annotation\Route;
use Pimcore\Model\DataObject;
use Pimcore\Model\DataObject\Products;
use Pimcore\Model\DataObject\Trendingrecipes;
use Pimcore\Model\DataObject\Recipe;
use Pimcore\Model\DataObject\Category;
use Pimcore\Model\DataObject\Brands;
use Pimcore\Model\DataObject\Slider;
use Pimcore\Model\DataObject\Resources;
use Pimcore\Model\DataObject\Userloyaltyprogram;
//use Pimcore\Model\DataObject\Trendingrecipes;
use Pimcore\Localization\LocaleServiceInterface;
use Pimcore\Model;
use Pimcore\Model\DataObject\ClassDefinition\Service;
// mansoor 2
class DefaultController extends FrontendController
{
/**
* @Template
* @param Request $request
* @return array
*/
public function defaultAction(Request $request)
{
return [];
}
public function redirecstAction()
{
return $this->redirect('/en',301);
}
public function ProductAction(Request $request)
{
$trendingrecipes = new Trendingrecipes\Listing();
$trendingrecipes->load();
foreach( $trendingrecipes as $trending_recipe){
}
foreach ($trendingrecipes as $trending_recipe){
}
$featured_products = new Products\Listing();
$featured_products->setCondition('featured IN (?)', '1');
$featured_products->setOrderKey("oo_id");
$featured_products->setOrder("desc");
$featured_products->setLimit('10');
$featured_products->load();
$ObjectIds = [];
foreach($featured_products as $featuredproducts){
$ObjectIds[] = $featuredproducts->getId();
}
$uid = $this->get('session')->get('loginUID');
$Liked = new Userloyaltyprogram\Listing();
$Liked->setCondition("op_name = ? and u_id = ? and obj_mod_name = ? and obj_data__id IN (?)",['Like',$uid,'Product',$ObjectIds]);
$Liked->load();
$LikedId = [];
foreach($Liked as $liked){
$LikedId[]=$liked->getObj_id();}
$featured_recipes = new Recipe\Listing();
$featured_recipes->setCondition('o_id = 47340 or o_id = 47333 or o_id = 47339 and featured IN (?)', '1');
$featured_recipes->setLimit('3');
$featured_recipes->load();
$brands = new Brands\Listing();
$brands->setOrderKey("order");
$brands->setOrder("asc");
$brands->setLimit('10');
$brands->load();
//home page article
$homearticle = new Resources\Listing();
$homearticle->setCondition('mostpopular IN (?)', '1');
$homearticle->setOrderKey("oo_id");
$homearticle->setOrder("desc");
$homearticle->setLimit('1');
$homearticle->load();
foreach($homearticle as $Homearticle){
break;
}
$categories = new Category\Listing();
$categories->load();
$home_slider = new Slider\Listing();
$home_slider->setCondition("o_id = 145");
$home_slider->load();
if(empty($home_slider->getdata()[0]->getsliders())){
$home_slider = array();
}else{
$home_slider = $home_slider->getdata()[0]->getsliders();
}
// dd($featured_products);
// Category Mid Banner
$loyalty_banner = new Slider\Listing();
$loyalty_banner->setCondition("o_id = 206");
$loyalty_banner->load();
foreach($loyalty_banner as $loyaltybanner){
break;
}
return $this->render('content/home.html.twig',
[
'trendingrecipes' => $trendingrecipes,
'featured_products' => $featured_products,
'featured_recipes' => $featured_recipes,
'brands' => $brands,
'categories' => $categories,
'home_slider' => $home_slider,
'trendingrecipes' => $trending_recipe,
'homearticle' => $Homearticle,
'LikedId' => $LikedId,
'loyaltybanner' => $loyaltybanner,
]);
}
// public function SignupAction(Request $request)
// {
// $countries = \Pimcore::getContainer()->get(LocaleServiceInterface::class)->getDisplayRegions();
// asort($countries);
// return $this->render('content/top-header.html.twig', ['countries'=>$countries]);
// }
public function likepopupAction(Request $request)
{
$success = true;
return $this->json(array('success'=>$success));
}
/**
* @Route("/{locale}/request-demo", name="request_demo")
*/
public function bookDemoRequestAction(Request $request)
{
return $this->render('content/request-demo.html.twig');
}
public function gcsCommunityAction(Request $request)
{
return $this->render('gcs-community/gcs-community.html.twig');
}
}

src/Controller/DefaultController.php line 38