Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.category_id AS category_id_2,
  t0.alttitle AS alttitle_3,
  t0.promo AS promo_4,
  t0.showfrom AS showfrom_5,
  t0.showto AS showto_6,
  t0.published AS published_7,
  t0.patronage AS patronage_8,
  t0.url AS url_9,
  t0.startpage AS startpage_10,
  t0.name AS name_11,
  t0.email AS email_12,
  t0.town AS town_13,
  t0.metatitle AS metatitle_14,
  t0.metadesc AS metadesc_15,
  t0.metakeyw AS metakeyw_16,
  t0.description AS description_17,
  t0.fulldescription AS fulldescription_18,
  t0.program AS program_19,
  t0.info AS info_20,
  t0.datefrom AS datefrom_21,
  t0.dateto AS dateto_22,
  t0.hours AS hours_23,
  t0.price AS price_24,
  t0.fullprice AS fullprice_25,
  t0.priceinfo AS priceinfo_26,
  t0.deleted AS deleted_27,
  t0.promoaddress AS promoaddress_28,
  t0.promoname AS promoname_29,
  t0.promostreet AS promostreet_30,
  t0.promopostcode AS promopostcode_31,
  t0.promotown AS promotown_32,
  t0.views AS views_33,
  t0.adddate AS adddate_34,
  t0.likesno AS likesno_35,
  t0.lead AS lead_36,
  t0.content AS content_37,
  t0.path AS path_38,
  t0.category_id AS category_id_39,
  t0.mpd_id AS mpd_id_40,
  t0.subcategory_id AS subcategory_id_41,
  t0.gallery_id AS gallery_id_42
FROM
  eventitem t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.alttitle AS alttitle_3, t0.promo AS promo_4, t0.showfrom AS showfrom_5, t0.showto AS showto_6, t0.published AS published_7, t0.patronage AS patronage_8, t0.url AS url_9, t0.startpage AS startpage_10, t0.name AS name_11, t0.email AS email_12, t0.town AS town_13, t0.metatitle AS metatitle_14, t0.metadesc AS metadesc_15, t0.metakeyw AS metakeyw_16, t0.description AS description_17, t0.fulldescription AS fulldescription_18, t0.program AS program_19, t0.info AS info_20, t0.datefrom AS datefrom_21, t0.dateto AS dateto_22, t0.hours AS hours_23, t0.price AS price_24, t0.fullprice AS fullprice_25, t0.priceinfo AS priceinfo_26, t0.deleted AS deleted_27, t0.promoaddress AS promoaddress_28, t0.promoname AS promoname_29, t0.promostreet AS promostreet_30, t0.promopostcode AS promopostcode_31, t0.promotown AS promotown_32, t0.views AS views_33, t0.adddate AS adddate_34, t0.likesno AS likesno_35, t0.lead AS lead_36, t0.content AS content_37, t0.path AS path_38, t0.category_id AS category_id_39, t0.mpd_id AS mpd_id_40, t0.subcategory_id AS subcategory_id_41, t0.gallery_id AS gallery_id_42 FROM eventitem t0 WHERE t0.id = '295';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  eventitem
SET
  views = ?
WHERE
  id = ?

UPDATE eventitem SET views = 5529 WHERE id = 295;

"COMMIT"

"COMMIT";

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.name AS name_2,
  t0.url AS url_3,
  t0.clicks AS clicks_4,
  t0.views AS views_5,
  t0.status AS status_6,
  t0.type AS type_7,
  t0.path AS path_8,
  t0.campaign_id AS campaign_id_9
FROM
  ad t0
  INNER JOIN ad_current_menuitem ON t0.id = ad_current_menuitem.ad_id
WHERE
  ad_current_menuitem.menuitem_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.clicks AS clicks_4, t0.views AS views_5, t0.status AS status_6, t0.type AS type_7, t0.path AS path_8, t0.campaign_id AS campaign_id_9 FROM ad t0 INNER JOIN ad_current_menuitem ON t0.id = ad_current_menuitem.ad_id WHERE ad_current_menuitem.menuitem_id = 4;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.keywords AS keywords_5
FROM
  meta t0
WHERE
  t0.path = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5 FROM meta t0 WHERE t0.path = '/e/295/warsztaty-masazu-shantala';

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.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.published = ?
ORDER BY
  t0.adddate DESC
LIMIT
  3

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.published = 1 ORDER BY t0.adddate DESC LIMIT 3;

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.published = ?
ORDER BY
  t0.views DESC
LIMIT
  3

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.published = 1 ORDER BY t0.views DESC LIMIT 3;