SlevaJakBrno.cz - všechny hromadné slevy online

SlevaJakBrno.cz to jsou všechny hromadné slevy online. Všechny slevy jsou ověřené, ručně zpracované a rozdělené do kategorií a všech měst - Praha, Brno, Ostrava, Plzeň, Olomouc. Najdete zde akční slevy na pobyty, wellness pobyty, pobyty pro dva, eurovíkendy, slevy na zboží a další slevy.
Řazení:

Vybrané nabídky posíláme
e-mailem pro vaši pohodu
Je to zdarma a dvakrát týdně dostanete TOP nabídky
Dostávat slevy z měst:
Pro správné fungování používají tyto stránky cookies. Setrváním na stránce s tímto souhlasíte.
MilestoneDiffCumulative
starting _initView00
starting _initDb0.000780.00078
starting _require0.006980.00777
end _require0.000140.0079
starting _initRouter4.0E-50.00794
finishing _initRouter0.007090.01503
starting init0.003850.01888
finishing init0.022620.0415
starting postDispatch0.829650.87115
finishing postDispatch0.257621.12877
finish2.0E-51.12879
PHP+SQL: 1.128 sec   SQL: 0.883 sec   Peak: 14.711 MB   Queries: 40   Debug: 2/3   PHP: 5.3.3   © PHP STORM 1.3.260318-PG
#0 SELECT `this->`.* FROM agregator_city as `this->` WHERE 1=1 AND (url=:url) Array ( [url] => ) in 0.0001s
#1 SELECT `this->`.* FROM news_new as `this->` WHERE 1=1 AND (url=:url) Array ( [url] => ) in 0.0001s
#2 SELECT `this->`.* FROM web_page as `this->` WHERE 1=1 AND (`this->`.`uuid`=:uuid ) LIMIT 1 Array ( [uuid] => web_index ) in 0.0001s
#3 SELECT `this->`.* FROM web_pagetype as `this->` WHERE 1=1 AND (`this->`.`uuid`=:uuid ) LIMIT 1 Array ( [uuid] => web_index ) in 0.0001s
#4 SELECT `this->`.* FROM web_settings as `this->` WHERE 1=1 Array ( ) in 0.0001s
#5 SELECT `this->`.* FROM competition_competition as `this->` WHERE 1=1 AND (datetime_from < NOW() AND datetime_to > NOW() AND hidden= 0) Array ( ) in 0.0003s
#6 SELECT url,uuid FROM web_page as `this->` WHERE 1=1 Array ( ) in 0.0001s
#7 SELECT count(*) FROM agregator_deal as `this->` WHERE 1=1 AND (`from` < NOW() AND `to` > NOW()) Array ( ) in 0.0079s
#8 SELECT `this->`.* FROM agregator_city as `this->` WHERE 1=1 AND (url=:url) Array ( [url] => ) in 0.0001s
#9 SELECT count(*) FROM agregator_deal as `this->` LEFT JOIN `agregator_provider` AS `provider->` ON `this->`.`fk_provider`=`provider->`.`uuid` WHERE 1=1 AND (`from` < NOW() AND `to` > NOW() AND 'where'='where' AND `provider->`.uuid != 'slevajakbrno' AND 'all_offers_nocat'='all_offers_nocat' AND adult!=1) Array ( ) in 0.0214s
#10 SELECT count(*) FROM agregator_deal as `this->` LEFT JOIN `agregator_provider` AS `provider->` ON `this->`.`fk_provider`=`provider->`.`uuid` WHERE 1=1 AND (`from` < NOW() AND `to` > NOW() AND 'where'='where' AND `provider->`.uuid != 'slevajakbrno' AND `this->`.adult=0 ) Array ( ) in 0.0339s
#11 SELECT count(*) FROM agregator_deal as `this->` LEFT JOIN `agregator_provider` AS `provider->` ON `this->`.`fk_provider`=`provider->`.`uuid` WHERE 1=1 AND (`from` < NOW() AND `to` > NOW() AND 'where'='where' AND `provider->`.uuid != 'slevajakbrno' AND `this->`.adult=0 AND 'new_offers'='new_offers' AND `from`>=:today) Array ( [today] => 2016-05-03 0:00 ) in 0.0016s
#12 SELECT count(*) FROM agregator_deal as `this->` LEFT JOIN `agregator_provider` AS `provider->` ON `this->`.`fk_provider`=`provider->`.`uuid` WHERE 1=1 AND (`from` < NOW() AND `to` > NOW() AND 'where'='where' AND `provider->`.uuid != 'slevajakbrno' AND `this->`.adult=0 AND 'ending_offers'='ending_offers' AND `to`<:tomorrow) Array ( [tomorrow] => 2016-05-04 0:00 ) in 0.03s
#13 SELECT count(*) FROM agregator_deal as `this->` LEFT JOIN `agregator_provider` AS `provider->` ON `this->`.`fk_provider`=`provider->`.`uuid` WHERE 1=1 AND (`from` < NOW() AND `to` > NOW() AND 'where'='where' AND `provider->`.uuid != 'slevajakbrno' AND `this->`.adult=0 AND 'all_offers_notype'='all_offers_notype') Array ( ) in 0.0406s
#14 SELECT agregator_category.uuid, count(distinct agregator_deal.uuid) as pocet FROM agregator_deal LEFT JOIN _deal_category ON agregator_deal.uuid=_deal_category.fk_deal LEFT JOIN agregator_category ON agregator_category.uuid=_deal_category.fk_category LEFT JOIN _deal_city ON agregator_deal.uuid=_deal_city.fk_deal LEFT JOIN agregator_city ON agregator_city.uuid=_deal_city.fk_city LEFT JOIN agregator_provider ON agregator_deal.fk_provider=agregator_provider.uuid WHERE `from` < NOW() AND `to` > NOW() AND 'where'='where' AND 'where2'='where2' AND agregator_provider.uuid != 'slevajakbrno' AND (agregator_deal.adult=0 OR agregator_deal.adult=agregator_category.adult) GROUP BY agregator_category.uuid Array ( ) in 0.3277s
#15 SELECT agregator_city.uuid, count(distinct agregator_deal.uuid) as pocet FROM agregator_deal LEFT JOIN _deal_category ON agregator_deal.uuid=_deal_category.fk_deal LEFT JOIN agregator_category ON agregator_category.uuid=_deal_category.fk_category LEFT JOIN _deal_city ON agregator_deal.uuid=_deal_city.fk_deal LEFT JOIN agregator_city ON agregator_city.uuid=_deal_city.fk_city LEFT JOIN agregator_provider ON agregator_deal.fk_provider=agregator_provider.uuid WHERE `from` < NOW() AND `to` > NOW() AND 'where'='where' AND (agregator_deal.adult=0 OR agregator_deal.adult=agregator_category.adult) GROUP BY agregator_city.uuid Array ( ) in 0.3673s
#16 SELECT `this->`.* FROM category_city_text as `this->` WHERE 1=1 AND (fk_category = :category) AND (fk_city = :city) LIMIT 1 Array ( [category] => [city] => ) in 0.0001s
#17 SELECT `this->`.* FROM web_page as `this->` WHERE 1=1 AND (path='0' OR path='00' OR path='001' OR path='001Q') ORDER BY path ASC Array ( ) in 0.0001s
#18 SELECT `this->`.* FROM agregator_city as `this->` WHERE 1=1 ORDER BY `order` ASC, name ASC Array ( ) in 0.0001s
#19 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (hidden='0' AND fk_parent is null) ORDER BY `order` ASC,name ASC Array ( ) in 0.0001s
#20 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 23 ) in 0.0001s
#21 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 19 ) in 0.0002s
#22 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 22 ) in 0.0002s
#23 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 21 ) in 0.0002s
#24 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 24 ) in 0.0002s
#25 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 25 ) in 0.0002s
#26 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 20 ) in 0.0002s
#27 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 23 ) in 0.0002s
#28 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 19 ) in 0.0002s
#29 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 22 ) in 0.0002s
#30 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 21 ) in 0.0001s
#31 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 24 ) in 0.0001s
#32 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 25 ) in 0.0001s
#33 SELECT `this->`.* FROM agregator_category as `this->` WHERE 1=1 AND (fk_parent=:parent AND hidden=0) ORDER BY `order` ASC,name ASC Array ( [parent] => 20 ) in 0.0001s
#34 SELECT `this->`.* FROM web_menuitem as `this->` LEFT JOIN `web_menu` AS `menu->` ON `this->`.`guid_menu`=`menu->`.`uuid` WHERE 1=1 AND (`this->`.hidden=0 AND `menu->`.type='menu_bottom') ORDER BY `order` ASC Array ( ) in 0.0002s
#35 SELECT buffer.* FROM `web_page` as buffer WHERE `uuid` IN ('obchodni_podminky','contact') Array ( ) in 0.0001s
#36 SELECT `this->`.* FROM agregator_deal as `this->` LEFT JOIN `agregator_provider` AS `provider->` ON `this->`.`fk_provider`=`provider->`.`uuid` WHERE 1=1 AND (`from` < NOW() AND `to` > NOW() AND 'where'='where' AND `provider->`.uuid != 'slevajakbrno' AND `this->`.adult=0 ) ORDER BY position ASC LIMIT 24 Array ( ) in 0.0477s
#37 SELECT buffer.* FROM `agregator_provider` as buffer WHERE `uuid` IN ('slevy-z-hor','hyperslevy','slevy-z-hor','hyperslevy','nakup-v-akci','slevy-z-hor','slevoking','pepa','nakup-v-akci','slevy-z-hor','nakup-v-akci','slevy-z-hor','slevadne','slevoking','nakup-v-akci','nakup-v-akci','slevoking','slevy-z-hor','slevoteka','slevoking','slevoking','slevoking','hyperslevy','hyperslevy') Array ( ) in 0.0001s
#38 SELECT `this->`.*,`this->`.*,`this->`.*,`_parent->`.`uuid` as _parent_uuid FROM agregator_category as `this->` JOIN `_deal_category` ON `_deal_category`.`fk_category`=`this->`.`uuid` JOIN `agregator_deal` AS `_parent->` ON `_deal_category`.`fk_deal`=`_parent->`.`uuid` AND `_parent->`.`uuid` IN ('742123','726622','721758','742793','737890','739661','733289','741920','734475','721790','740235','721796','736485','738356','736493','708250','727011','722573','718049','742831','727032','676235','734626','737254') WHERE 1 AND (fk_parent is null) ORDER BY `order` ASC Array ( ) in 0.0003s
#39 SELECT `this->`.*,`_parent->`.`uuid` as _parent_uuid FROM agregator_city as `this->` JOIN `_deal_city` ON `_deal_city`.`fk_city`=`this->`.`uuid` JOIN `agregator_deal` AS `_parent->` ON `_deal_city`.`fk_deal`=`_parent->`.`uuid` AND `_parent->`.`uuid` IN ('742123','726622','721758','742793','737890','739661','733289','741920','734475','721790','740235','721796','736485','738356','736493','708250','727011','722573','718049','742831','727032','676235','734626','737254') WHERE 1=1 Array ( ) in 0.0001s