Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.css AS css_2,
  t0.url AS url_3,
  t0.visible AS visible_4,
  t0.redirecturl AS redirecturl_5,
  t0.priority AS priority_6,
  t0.adfactor AS adfactor_7,
  t0.name AS name_8
FROM
  menuitem t0
WHERE
  t0.visible = ?
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.css AS css_2, t0.url AS url_3, t0.visible AS visible_4, t0.redirecturl AS redirecturl_5, t0.priority AS priority_6, t0.adfactor AS adfactor_7, t0.name AS name_8 FROM menuitem t0 WHERE t0.visible = 1 ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.menuitem_id AS menuitem_id_2,
  t0.name AS name_3,
  t0.url AS url_4,
  t0.type AS type_5,
  t0.priority AS priority_6,
  t0.menuitem_id AS menuitem_id_7
FROM
  submenuitem t0
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.menuitem_id AS menuitem_id_2, t0.name AS name_3, t0.url AS url_4, t0.type AS type_5, t0.priority AS priority_6, t0.menuitem_id AS menuitem_id_7 FROM submenuitem t0 ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.submenuitem_id AS submenuitem_id_2,
  t0.name AS name_3,
  t0.css AS css_4,
  t0.url AS url_5,
  t0.hideskill AS hideskill_6,
  t0.type AS type_7,
  t0.priority AS priority_8,
  t0.submenuitem_id AS submenuitem_id_9,
  t10.id AS id_11,
  t10.url AS url_12,
  t10.name AS name_13,
  t10.metatitle AS metatitle_14,
  t10.metadesc AS metadesc_15,
  t10.metakeyw AS metakeyw_16,
  t10.age AS age_17,
  t10.ageto AS ageto_18,
  t10.lead AS lead_19,
  t10.views AS views_20,
  t10.adddate AS adddate_21,
  t10.content AS content_22,
  t10.likesno AS likesno_23,
  t10.path AS path_24,
  t10.category_id AS category_id_25,
  t10.skill_id AS skill_id_26,
  t10.author_id AS author_id_27,
  t10.gallery_id AS gallery_id_28
FROM
  submenucategory t0
  LEFT JOIN staticitem t10 ON t10.category_id = t0.id
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.submenuitem_id AS submenuitem_id_2, t0.name AS name_3, t0.css AS css_4, t0.url AS url_5, t0.hideskill AS hideskill_6, t0.type AS type_7, t0.priority AS priority_8, t0.submenuitem_id AS submenuitem_id_9, t10.id AS id_11, t10.url AS url_12, t10.name AS name_13, t10.metatitle AS metatitle_14, t10.metadesc AS metadesc_15, t10.metakeyw AS metakeyw_16, t10.age AS age_17, t10.ageto AS ageto_18, t10.lead AS lead_19, t10.views AS views_20, t10.adddate AS adddate_21, t10.content AS content_22, t10.likesno AS likesno_23, t10.path AS path_24, t10.category_id AS category_id_25, t10.skill_id AS skill_id_26, t10.author_id AS author_id_27, t10.gallery_id AS gallery_id_28 FROM submenucategory t0 LEFT JOIN staticitem t10 ON t10.category_id = t0.id ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.promo AS promo_3,
  t0.startpage AS startpage_4,
  t0.alttitle AS alttitle_5,
  t0.category_id AS category_id_6,
  t0.name AS name_7,
  t0.metatitle AS metatitle_8,
  t0.metadesc AS metadesc_9,
  t0.metakeyw AS metakeyw_10,
  t0.age AS age_11,
  t0.ageto AS ageto_12,
  t0.lead AS lead_13,
  t0.views AS views_14,
  t0.adddate AS adddate_15,
  t0.showfrom AS showfrom_16,
  t0.showto AS showto_17,
  t0.showrepeated AS showrepeated_18,
  t0.published AS published_19,
  t0.content AS content_20,
  t0.likesno AS likesno_21,
  t0.path AS path_22,
  t0.rss_published AS rss_published_23,
  t0.category_id AS category_id_24,
  t0.author_id AS author_id_25,
  t0.gallery_id AS gallery_id_26
FROM
  articleitem t0
WHERE
  t0.startpage = ?
  AND t0.published = ?
ORDER BY
  t0.id DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.url AS url_2, t0.promo AS promo_3, t0.startpage AS startpage_4, t0.alttitle AS alttitle_5, t0.category_id AS category_id_6, t0.name AS name_7, t0.metatitle AS metatitle_8, t0.metadesc AS metadesc_9, t0.metakeyw AS metakeyw_10, t0.age AS age_11, t0.ageto AS ageto_12, t0.lead AS lead_13, t0.views AS views_14, t0.adddate AS adddate_15, t0.showfrom AS showfrom_16, t0.showto AS showto_17, t0.showrepeated AS showrepeated_18, t0.published AS published_19, t0.content AS content_20, t0.likesno AS likesno_21, t0.path AS path_22, t0.rss_published AS rss_published_23, t0.category_id AS category_id_24, t0.author_id AS author_id_25, t0.gallery_id AS gallery_id_26 FROM articleitem t0 WHERE t0.startpage = 1 AND t0.published = 1 ORDER BY t0.id DESC LIMIT 4;

SELECT
  e0_.id AS id_0,
  e0_.category_id AS category_id_1,
  e0_.alttitle AS alttitle_2,
  e0_.promo AS promo_3,
  e0_.showfrom AS showfrom_4,
  e0_.showto AS showto_5,
  e0_.published AS published_6,
  e0_.patronage AS patronage_7,
  e0_.url AS url_8,
  e0_.startpage AS startpage_9,
  e0_.name AS name_10,
  e0_.email AS email_11,
  e0_.town AS town_12,
  e0_.metatitle AS metatitle_13,
  e0_.metadesc AS metadesc_14,
  e0_.metakeyw AS metakeyw_15,
  e0_.description AS description_16,
  e0_.fulldescription AS fulldescription_17,
  e0_.program AS program_18,
  e0_.info AS info_19,
  e0_.datefrom AS datefrom_20,
  e0_.dateto AS dateto_21,
  e0_.hours AS hours_22,
  e0_.price AS price_23,
  e0_.fullprice AS fullprice_24,
  e0_.priceinfo AS priceinfo_25,
  e0_.deleted AS deleted_26,
  e0_.promoaddress AS promoaddress_27,
  e0_.promoname AS promoname_28,
  e0_.promostreet AS promostreet_29,
  e0_.promopostcode AS promopostcode_30,
  e0_.promotown AS promotown_31,
  e0_.views AS views_32,
  e0_.adddate AS adddate_33,
  e0_.likesno AS likesno_34,
  e0_.lead AS lead_35,
  e0_.content AS content_36,
  e0_.path AS path_37,
  e0_.category_id AS category_id_38,
  e0_.mpd_id AS mpd_id_39,
  e0_.subcategory_id AS subcategory_id_40,
  e0_.gallery_id AS gallery_id_41
FROM
  eventitem e0_
WHERE
  e0_.category_id IN (69, 84, 85)
  AND e0_.published = 1
ORDER BY
  e0_.adddate DESC
LIMIT
  4

SELECT e0_.id AS id_0, e0_.category_id AS category_id_1, e0_.alttitle AS alttitle_2, e0_.promo AS promo_3, e0_.showfrom AS showfrom_4, e0_.showto AS showto_5, e0_.published AS published_6, e0_.patronage AS patronage_7, e0_.url AS url_8, e0_.startpage AS startpage_9, e0_.name AS name_10, e0_.email AS email_11, e0_.town AS town_12, e0_.metatitle AS metatitle_13, e0_.metadesc AS metadesc_14, e0_.metakeyw AS metakeyw_15, e0_.description AS description_16, e0_.fulldescription AS fulldescription_17, e0_.program AS program_18, e0_.info AS info_19, e0_.datefrom AS datefrom_20, e0_.dateto AS dateto_21, e0_.hours AS hours_22, e0_.price AS price_23, e0_.fullprice AS fullprice_24, e0_.priceinfo AS priceinfo_25, e0_.deleted AS deleted_26, e0_.promoaddress AS promoaddress_27, e0_.promoname AS promoname_28, e0_.promostreet AS promostreet_29, e0_.promopostcode AS promopostcode_30, e0_.promotown AS promotown_31, e0_.views AS views_32, e0_.adddate AS adddate_33, e0_.likesno AS likesno_34, e0_.lead AS lead_35, e0_.content AS content_36, e0_.path AS path_37, e0_.category_id AS category_id_38, e0_.mpd_id AS mpd_id_39, e0_.subcategory_id AS subcategory_id_40, e0_.gallery_id AS gallery_id_41 FROM eventitem e0_ WHERE e0_.category_id IN (69, 84, 85) AND e0_.published = 1 ORDER BY e0_.adddate DESC LIMIT 4;

SELECT
  a0_.id AS id_0,
  a0_.url AS url_1,
  a0_.promo AS promo_2,
  a0_.startpage AS startpage_3,
  a0_.alttitle AS alttitle_4,
  a0_.category_id AS category_id_5,
  a0_.name AS name_6,
  a0_.metatitle AS metatitle_7,
  a0_.metadesc AS metadesc_8,
  a0_.metakeyw AS metakeyw_9,
  a0_.age AS age_10,
  a0_.ageto AS ageto_11,
  a0_.lead AS lead_12,
  a0_.views AS views_13,
  a0_.adddate AS adddate_14,
  a0_.showfrom AS showfrom_15,
  a0_.showto AS showto_16,
  a0_.showrepeated AS showrepeated_17,
  a0_.published AS published_18,
  a0_.content AS content_19,
  a0_.likesno AS likesno_20,
  a0_.path AS path_21,
  a0_.rss_published AS rss_published_22,
  a0_.category_id AS category_id_23,
  a0_.author_id AS author_id_24,
  a0_.gallery_id AS gallery_id_25
FROM
  articleitem a0_
WHERE
  a0_.id NOT IN (1825, 1824, 1823, 1822)
  AND a0_.published = 1
  AND a0_.promo = 1
ORDER BY
  a0_.showfrom DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.promo AS promo_2, a0_.startpage AS startpage_3, a0_.alttitle AS alttitle_4, a0_.category_id AS category_id_5, a0_.name AS name_6, a0_.metatitle AS metatitle_7, a0_.metadesc AS metadesc_8, a0_.metakeyw AS metakeyw_9, a0_.age AS age_10, a0_.ageto AS ageto_11, a0_.lead AS lead_12, a0_.views AS views_13, a0_.adddate AS adddate_14, a0_.showfrom AS showfrom_15, a0_.showto AS showto_16, a0_.showrepeated AS showrepeated_17, a0_.published AS published_18, a0_.content AS content_19, a0_.likesno AS likesno_20, a0_.path AS path_21, a0_.rss_published AS rss_published_22, a0_.category_id AS category_id_23, a0_.author_id AS author_id_24, a0_.gallery_id AS gallery_id_25 FROM articleitem a0_ WHERE a0_.id NOT IN (1825, 1824, 1823, 1822) AND a0_.published = 1 AND a0_.promo = 1 ORDER BY a0_.showfrom DESC LIMIT 3;

SELECT
  a0_.id AS id_0,
  a0_.url AS url_1,
  a0_.promo AS promo_2,
  a0_.startpage AS startpage_3,
  a0_.alttitle AS alttitle_4,
  a0_.category_id AS category_id_5,
  a0_.name AS name_6,
  a0_.metatitle AS metatitle_7,
  a0_.metadesc AS metadesc_8,
  a0_.metakeyw AS metakeyw_9,
  a0_.age AS age_10,
  a0_.ageto AS ageto_11,
  a0_.lead AS lead_12,
  a0_.views AS views_13,
  a0_.adddate AS adddate_14,
  a0_.showfrom AS showfrom_15,
  a0_.showto AS showto_16,
  a0_.showrepeated AS showrepeated_17,
  a0_.published AS published_18,
  a0_.content AS content_19,
  a0_.likesno AS likesno_20,
  a0_.path AS path_21,
  a0_.rss_published AS rss_published_22,
  a0_.category_id AS category_id_23,
  a0_.author_id AS author_id_24,
  a0_.gallery_id AS gallery_id_25
FROM
  articleitem a0_
WHERE
  a0_.id NOT IN (
    1825, 1824, 1823, 1822, 1738, 1722, 1569
  )
  AND a0_.published = 1
ORDER BY
  a0_.showfrom DESC
LIMIT
  8

SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.promo AS promo_2, a0_.startpage AS startpage_3, a0_.alttitle AS alttitle_4, a0_.category_id AS category_id_5, a0_.name AS name_6, a0_.metatitle AS metatitle_7, a0_.metadesc AS metadesc_8, a0_.metakeyw AS metakeyw_9, a0_.age AS age_10, a0_.ageto AS ageto_11, a0_.lead AS lead_12, a0_.views AS views_13, a0_.adddate AS adddate_14, a0_.showfrom AS showfrom_15, a0_.showto AS showto_16, a0_.showrepeated AS showrepeated_17, a0_.published AS published_18, a0_.content AS content_19, a0_.likesno AS likesno_20, a0_.path AS path_21, a0_.rss_published AS rss_published_22, a0_.category_id AS category_id_23, a0_.author_id AS author_id_24, a0_.gallery_id AS gallery_id_25 FROM articleitem a0_ WHERE a0_.id NOT IN (1825, 1824, 1823, 1822, 1738, 1722, 1569) AND a0_.published = 1 ORDER BY a0_.showfrom DESC LIMIT 8;

SELECT
  a0_.id AS id_0,
  a0_.url AS url_1,
  a0_.promo AS promo_2,
  a0_.startpage AS startpage_3,
  a0_.alttitle AS alttitle_4,
  a0_.category_id AS category_id_5,
  a0_.name AS name_6,
  a0_.metatitle AS metatitle_7,
  a0_.metadesc AS metadesc_8,
  a0_.metakeyw AS metakeyw_9,
  a0_.age AS age_10,
  a0_.ageto AS ageto_11,
  a0_.lead AS lead_12,
  a0_.views AS views_13,
  a0_.adddate AS adddate_14,
  a0_.showfrom AS showfrom_15,
  a0_.showto AS showto_16,
  a0_.showrepeated AS showrepeated_17,
  a0_.published AS published_18,
  a0_.content AS content_19,
  a0_.likesno AS likesno_20,
  a0_.path AS path_21,
  a0_.rss_published AS rss_published_22,
  a0_.category_id AS category_id_23,
  a0_.author_id AS author_id_24,
  a0_.gallery_id AS gallery_id_25
FROM
  articleitem a0_
WHERE
  a0_.id NOT IN (
    1825, 1824, 1823, 1822, 1738, 1722, 1569
  )
  AND a0_.published = 1
  AND a0_.promo = 1
  AND a0_.category_id IN (
    35, 36, 37, 38, 39, 40, 42, 30, 31, 86, 72,
    74, 25, 26, 27, 32
  )
ORDER BY
  a0_.id DESC
LIMIT
  2

SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.promo AS promo_2, a0_.startpage AS startpage_3, a0_.alttitle AS alttitle_4, a0_.category_id AS category_id_5, a0_.name AS name_6, a0_.metatitle AS metatitle_7, a0_.metadesc AS metadesc_8, a0_.metakeyw AS metakeyw_9, a0_.age AS age_10, a0_.ageto AS ageto_11, a0_.lead AS lead_12, a0_.views AS views_13, a0_.adddate AS adddate_14, a0_.showfrom AS showfrom_15, a0_.showto AS showto_16, a0_.showrepeated AS showrepeated_17, a0_.published AS published_18, a0_.content AS content_19, a0_.likesno AS likesno_20, a0_.path AS path_21, a0_.rss_published AS rss_published_22, a0_.category_id AS category_id_23, a0_.author_id AS author_id_24, a0_.gallery_id AS gallery_id_25 FROM articleitem a0_ WHERE a0_.id NOT IN (1825, 1824, 1823, 1822, 1738, 1722, 1569) AND a0_.published = 1 AND a0_.promo = 1 AND a0_.category_id IN (35, 36, 37, 38, 39, 40, 42, 30, 31, 86, 72, 74, 25, 26, 27, 32) ORDER BY a0_.id DESC LIMIT 2;

SELECT
  a0_.id AS id_0,
  a0_.url AS url_1,
  a0_.promo AS promo_2,
  a0_.startpage AS startpage_3,
  a0_.alttitle AS alttitle_4,
  a0_.category_id AS category_id_5,
  a0_.name AS name_6,
  a0_.metatitle AS metatitle_7,
  a0_.metadesc AS metadesc_8,
  a0_.metakeyw AS metakeyw_9,
  a0_.age AS age_10,
  a0_.ageto AS ageto_11,
  a0_.lead AS lead_12,
  a0_.views AS views_13,
  a0_.adddate AS adddate_14,
  a0_.showfrom AS showfrom_15,
  a0_.showto AS showto_16,
  a0_.showrepeated AS showrepeated_17,
  a0_.published AS published_18,
  a0_.content AS content_19,
  a0_.likesno AS likesno_20,
  a0_.path AS path_21,
  a0_.rss_published AS rss_published_22,
  a0_.category_id AS category_id_23,
  a0_.author_id AS author_id_24,
  a0_.gallery_id AS gallery_id_25
FROM
  articleitem a0_
WHERE
  a0_.id NOT IN (
    1825, 1824, 1823, 1822, 1738, 1722, 1569,
    1814, 1813
  )
  AND a0_.published = 1
  AND a0_.category_id IN (
    35, 36, 37, 38, 39, 40, 42, 30, 31, 86, 72,
    74, 25, 26, 27, 32
  )
ORDER BY
  a0_.id DESC
LIMIT
  12

SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.promo AS promo_2, a0_.startpage AS startpage_3, a0_.alttitle AS alttitle_4, a0_.category_id AS category_id_5, a0_.name AS name_6, a0_.metatitle AS metatitle_7, a0_.metadesc AS metadesc_8, a0_.metakeyw AS metakeyw_9, a0_.age AS age_10, a0_.ageto AS ageto_11, a0_.lead AS lead_12, a0_.views AS views_13, a0_.adddate AS adddate_14, a0_.showfrom AS showfrom_15, a0_.showto AS showto_16, a0_.showrepeated AS showrepeated_17, a0_.published AS published_18, a0_.content AS content_19, a0_.likesno AS likesno_20, a0_.path AS path_21, a0_.rss_published AS rss_published_22, a0_.category_id AS category_id_23, a0_.author_id AS author_id_24, a0_.gallery_id AS gallery_id_25 FROM articleitem a0_ WHERE a0_.id NOT IN (1825, 1824, 1823, 1822, 1738, 1722, 1569, 1814, 1813) AND a0_.published = 1 AND a0_.category_id IN (35, 36, 37, 38, 39, 40, 42, 30, 31, 86, 72, 74, 25, 26, 27, 32) ORDER BY a0_.id DESC LIMIT 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lead AS lead_3,
  t0.url AS url_4,
  t0.adddate AS adddate_5,
  t0.height AS height_6,
  t0.likesno AS likesno_7,
  t0.views AS views_8,
  t0.path AS path_9,
  t0.blog_id AS blog_id_10
FROM
  blogentry t0
ORDER BY
  t0.adddate DESC
LIMIT
  6

SELECT t0.id AS id_1, t0.name AS name_2, t0.lead AS lead_3, t0.url AS url_4, t0.adddate AS adddate_5, t0.height AS height_6, t0.likesno AS likesno_7, t0.views AS views_8, t0.path AS path_9, t0.blog_id AS blog_id_10 FROM blogentry t0 ORDER BY t0.adddate DESC LIMIT 6;

SELECT
  p0_.views AS views_0,
  p0_.id AS id_1,
  p0_.title AS title_2,
  p0_.subtitle AS subtitle_3,
  p0_.town AS town_4,
  p0_.url AS url_5,
  p0_.description AS description_6,
  p0_.privacy AS privacy_7,
  p0_.height AS height_8,
  p0_.likesno AS likesno_9,
  p0_.path AS path_10,
  p0_.user_id AS user_id_11
FROM
  photopage p0_
WHERE
  p0_.privacy = 1
  AND p0_.path IS NOT NULL
ORDER BY
  p0_.id DESC
LIMIT
  50

SELECT p0_.views AS views_0, p0_.id AS id_1, p0_.title AS title_2, p0_.subtitle AS subtitle_3, p0_.town AS town_4, p0_.url AS url_5, p0_.description AS description_6, p0_.privacy AS privacy_7, p0_.height AS height_8, p0_.likesno AS likesno_9, p0_.path AS path_10, p0_.user_id AS user_id_11 FROM photopage p0_ WHERE p0_.privacy = 1 AND p0_.path IS NOT NULL ORDER BY p0_.id DESC LIMIT 50;

SELECT
  m0_.id AS id_0,
  m0_.promo AS promo_1,
  m0_.name AS name_2,
  m0_.contactname AS contactname_3,
  m0_.promocode AS promocode_4,
  m0_.sellercode AS sellercode_5,
  m0_.longdescription AS longdescription_6,
  m0_.description AS description_7,
  m0_.street AS street_8,
  m0_.postcode AS postcode_9,
  m0_.email AS email_10,
  m0_.province AS province_11,
  m0_.plan AS plan_12,
  m0_.townname AS townname_13,
  m0_.vatid AS vatid_14,
  m0_.phone AS phone_15,
  m0_.mobile AS mobile_16,
  m0_.fax AS fax_17,
  m0_.website AS website_18,
  m0_.rules AS rules_19,
  m0_.marketing AS marketing_20,
  m0_.vat AS vat_21,
  m0_.vatname AS vatname_22,
  m0_.vatstreet AS vatstreet_23,
  m0_.vatpostcode AS vatpostcode_24,
  m0_.vattown AS vattown_25,
  m0_.visible AS visible_26,
  m0_.approved AS approved_27,
  m0_.examplary AS examplary_28,
  m0_.regacceptlego AS regacceptlego_29,
  m0_.recommended AS recommended_30,
  m0_.paid AS paid_31,
  m0_.deleted AS deleted_32,
  m0_.hasrealpromos AS hasrealpromos_33,
  m0_.hasowner AS hasowner_34,
  m0_.mark AS mark_35,
  m0_.pricefrom AS pricefrom_36,
  m0_.pricefor AS pricefor_37,
  m0_.age AS age_38,
  m0_.ageto AS ageto_39,
  m0_.lng AS lng_40,
  m0_.lat AS lat_41,
  m0_.likesno AS likesno_42,
  m0_.x AS x_43,
  m0_.y AS y_44,
  m0_.iiothers AS iiothers_45,
  m0_.path AS path_46,
  m0_.adddate AS adddate_47,
  m0_.editdate AS editdate_48,
  m0_.errordate AS errordate_49,
  m0_.visits AS visits_50,
  m0_.listshow AS listshow_51,
  m0_.town_id AS town_id_52,
  m0_.category_id AS category_id_53,
  m0_.user_id AS user_id_54,
  m0_.adduser_id AS adduser_id_55
FROM
  mpd m0_
WHERE
  m0_.deleted = 0
  AND m0_.visible = 1
  AND m0_.approved = 1
  AND m0_.path IS NOT NULL
ORDER BY
  m0_.adddate DESC
LIMIT
  9

SELECT m0_.id AS id_0, m0_.promo AS promo_1, m0_.name AS name_2, m0_.contactname AS contactname_3, m0_.promocode AS promocode_4, m0_.sellercode AS sellercode_5, m0_.longdescription AS longdescription_6, m0_.description AS description_7, m0_.street AS street_8, m0_.postcode AS postcode_9, m0_.email AS email_10, m0_.province AS province_11, m0_.plan AS plan_12, m0_.townname AS townname_13, m0_.vatid AS vatid_14, m0_.phone AS phone_15, m0_.mobile AS mobile_16, m0_.fax AS fax_17, m0_.website AS website_18, m0_.rules AS rules_19, m0_.marketing AS marketing_20, m0_.vat AS vat_21, m0_.vatname AS vatname_22, m0_.vatstreet AS vatstreet_23, m0_.vatpostcode AS vatpostcode_24, m0_.vattown AS vattown_25, m0_.visible AS visible_26, m0_.approved AS approved_27, m0_.examplary AS examplary_28, m0_.regacceptlego AS regacceptlego_29, m0_.recommended AS recommended_30, m0_.paid AS paid_31, m0_.deleted AS deleted_32, m0_.hasrealpromos AS hasrealpromos_33, m0_.hasowner AS hasowner_34, m0_.mark AS mark_35, m0_.pricefrom AS pricefrom_36, m0_.pricefor AS pricefor_37, m0_.age AS age_38, m0_.ageto AS ageto_39, m0_.lng AS lng_40, m0_.lat AS lat_41, m0_.likesno AS likesno_42, m0_.x AS x_43, m0_.y AS y_44, m0_.iiothers AS iiothers_45, m0_.path AS path_46, m0_.adddate AS adddate_47, m0_.editdate AS editdate_48, m0_.errordate AS errordate_49, m0_.visits AS visits_50, m0_.listshow AS listshow_51, m0_.town_id AS town_id_52, m0_.category_id AS category_id_53, m0_.user_id AS user_id_54, m0_.adduser_id AS adduser_id_55 FROM mpd m0_ WHERE m0_.deleted = 0 AND m0_.visible = 1 AND m0_.approved = 1 AND m0_.path IS NOT NULL ORDER BY m0_.adddate DESC LIMIT 9;

SELECT
  d0_.id AS id_0,
  d0_.alttitle AS alttitle_1,
  d0_.url AS url_2,
  d0_.showfrom AS showfrom_3,
  d0_.showto AS showto_4,
  d0_.showrepeated AS showrepeated_5,
  d0_.published AS published_6,
  d0_.startpage AS startpage_7,
  d0_.difficulty AS difficulty_8,
  d0_.age AS age_9,
  d0_.ageto AS ageto_10,
  d0_.name AS name_11,
  d0_.premium AS premium_12,
  d0_.logged AS logged_13,
  d0_.price AS price_14,
  d0_.views AS views_15,
  d0_.adddate AS adddate_16,
  d0_.likesno AS likesno_17,
  d0_.path AS path_18,
  d0_.pdfpath AS pdfpath_19,
  d0_.category_id AS category_id_20
FROM
  downloaditem d0_
WHERE
  d0_.published = 1
  AND d0_.logged = 0
ORDER BY
  d0_.adddate ASC
LIMIT
  50

SELECT d0_.id AS id_0, d0_.alttitle AS alttitle_1, d0_.url AS url_2, d0_.showfrom AS showfrom_3, d0_.showto AS showto_4, d0_.showrepeated AS showrepeated_5, d0_.published AS published_6, d0_.startpage AS startpage_7, d0_.difficulty AS difficulty_8, d0_.age AS age_9, d0_.ageto AS ageto_10, d0_.name AS name_11, d0_.premium AS premium_12, d0_.logged AS logged_13, d0_.price AS price_14, d0_.views AS views_15, d0_.adddate AS adddate_16, d0_.likesno AS likesno_17, d0_.path AS path_18, d0_.pdfpath AS pdfpath_19, d0_.category_id AS category_id_20 FROM downloaditem d0_ WHERE d0_.published = 1 AND d0_.logged = 0 ORDER BY d0_.adddate ASC LIMIT 50;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.email AS email_2,
  f0_.url AS url_3,
  f0_.town AS town_4,
  f0_.description AS description_5,
  f0_.priority AS priority_6,
  f0_.path AS path_7
FROM
  foundation f0_
ORDER BY
  f0_.priority DESC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.email AS email_2, f0_.url AS url_3, f0_.town AS town_4, f0_.description AS description_5, f0_.priority AS priority_6, f0_.path AS path_7 FROM foundation f0_ ORDER BY f0_.priority DESC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.email AS email_2,
  p0_.url AS url_3,
  p0_.town AS town_4,
  p0_.description AS description_5,
  p0_.priority AS priority_6,
  p0_.path AS path_7
FROM
  partner p0_
ORDER BY
  p0_.priority DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.email AS email_2, p0_.url AS url_3, p0_.town AS town_4, p0_.description AS description_5, p0_.priority AS priority_6, p0_.path AS path_7 FROM partner p0_ ORDER BY p0_.priority DESC;

SELECT
  MAX(a0_.id) AS sclr_0
FROM
  articleitem a0_
WHERE
  a0_.category_id IN (74, 25, 26, 27, 32)
  AND a0_.id NOT IN (
    1825, 1824, 1823, 1822, 1738, 1722, 1569,
    1814, 1813
  )
GROUP BY
  a0_.category_id
LIMIT
  4

SELECT MAX(a0_.id) AS sclr_0 FROM articleitem a0_ WHERE a0_.category_id IN (74, 25, 26, 27, 32) AND a0_.id NOT IN (1825, 1824, 1823, 1822, 1738, 1722, 1569, 1814, 1813) GROUP BY a0_.category_id LIMIT 4;