Symfony Profiler

SELECT 
  r0_.id AS id0, 
  r0_.path AS path1, 
  r0_.urlpath AS urlpath2, 
  r0_.title AS title3, 
  r0_.slug AS slug4, 
  r0_.content AS content5, 
  r0_.lft AS lft6, 
  r0_.rgt AS rgt7, 
  r0_.lvl AS lvl8, 
  r0_.parent_id AS parent_id9 
FROM 
  rc_pages r0_ 
  INNER JOIN rc_pages r1_ ON r0_.id = r1_.parent_id 
WHERE 
  r0_.slug = ?

SELECT r0_.id AS id0, r0_.path AS path1, r0_.urlpath AS urlpath2, r0_.title AS title3, r0_.slug AS slug4, r0_.content AS content5, r0_.lft AS lft6, r0_.rgt AS rgt7, r0_.lvl AS lvl8, r0_.parent_id AS parent_id9 FROM rc_pages r0_ INNER JOIN rc_pages r1_ ON r0_.id = r1_.parent_id WHERE r0_.slug = 'over-ons';

SELECT 
  t0.id AS id1, 
  t0.path AS path2, 
  t0.urlpath AS urlpath3, 
  t0.title AS title4, 
  t0.slug AS slug5, 
  t0.content AS content6, 
  t0.lft AS lft7, 
  t0.rgt AS rgt8, 
  t0.lvl AS lvl9, 
  t0.parent_id AS parent_id10 
FROM 
  rc_pages t0 
WHERE 
  t0.parent_id = ? 
ORDER BY 
  t0.lft ASC

SELECT t0.id AS id1, t0.path AS path2, t0.urlpath AS urlpath3, t0.title AS title4, t0.slug AS slug5, t0.content AS content6, t0.lft AS lft7, t0.rgt AS rgt8, t0.lvl AS lvl9, t0.parent_id AS parent_id10 FROM rc_pages t0 WHERE t0.parent_id = 4 ORDER BY t0.lft ASC;

SELECT 
  r0_.id AS id0, 
  r0_.state AS state1, 
  r0_.anonymous AS anonymous2, 
  r0_.reviewer_name AS reviewer_name3, 
  r0_.reviewer_email AS reviewer_email4, 
  r0_.reviewer_facebook_id AS reviewer_facebook_id5, 
  r0_.activation_token AS activation_token6, 
  r0_.comment AS comment7, 
  r0_.created_at AS created_at8, 
  r0_.updated_at AS updated_at9, 
  r0_.relation AS relation10, 
  r0_.reviewable_id AS reviewable_id11 
FROM 
  rc_review r0_ 
WHERE 
  r0_.state = 1 
ORDER BY 
  r0_.created_at DESC 
LIMIT 
  4

SELECT r0_.id AS id0, r0_.state AS state1, r0_.anonymous AS anonymous2, r0_.reviewer_name AS reviewer_name3, r0_.reviewer_email AS reviewer_email4, r0_.reviewer_facebook_id AS reviewer_facebook_id5, r0_.activation_token AS activation_token6, r0_.comment AS comment7, r0_.created_at AS created_at8, r0_.updated_at AS updated_at9, r0_.relation AS relation10, r0_.reviewable_id AS reviewable_id11 FROM rc_review r0_ WHERE r0_.state = 1 ORDER BY r0_.created_at DESC LIMIT 4;

SELECT 
  r0_.id AS id0, 
  r0_.text AS text1, 
  count(r1_.id) AS sclr2 
FROM 
  rc_subjects r0_ 
  INNER JOIN _subject_reviewable _2_ ON r0_.id = _2_.subject_id 
  INNER JOIN rc_reviewable r1_ ON r1_.id = _2_.reviewable_id 
GROUP BY 
  r0_.id 
ORDER BY 
  sclr2 DESC 
LIMIT 
  4

SELECT r0_.id AS id0, r0_.text AS text1, count(r1_.id) AS sclr2 FROM rc_subjects r0_ INNER JOIN _subject_reviewable _2_ ON r0_.id = _2_.subject_id INNER JOIN rc_reviewable r1_ ON r1_.id = _2_.reviewable_id GROUP BY r0_.id ORDER BY sclr2 DESC LIMIT 4;

SELECT 
  r0_.id AS id0, 
  r0_.firstName AS firstName1, 
  r0_.lastName AS lastName2, 
  r0_.gender AS gender3, 
  r0_.bookingEmail AS bookingEmail4, 
  r0_.mailPreference AS mailPreference5, 
  r0_.biography AS biography6, 
  r0_.website AS website7, 
  r0_.twitter AS twitter8, 
  r0_.languages AS languages9, 
  r0_.slug AS slug10, 
  r0_.avatar AS avatar11, 
  r0_.type AS type12, 
  r0_.active AS active13, 
  r0_.quote AS quote14, 
  r0_.linkedIn AS linkedIn15, 
  r0_.createdAt AS createdAt16, 
  r0_.updatedAt AS updatedAt17, 
  r0_.user_id AS user_id18 
FROM 
  rc_profile r0_ 
WHERE 
  r0_.active = 1 
ORDER BY 
  r0_.createdAt DESC 
LIMIT 
  3

SELECT r0_.id AS id0, r0_.firstName AS firstName1, r0_.lastName AS lastName2, r0_.gender AS gender3, r0_.bookingEmail AS bookingEmail4, r0_.mailPreference AS mailPreference5, r0_.biography AS biography6, r0_.website AS website7, r0_.twitter AS twitter8, r0_.languages AS languages9, r0_.slug AS slug10, r0_.avatar AS avatar11, r0_.type AS type12, r0_.active AS active13, r0_.quote AS quote14, r0_.linkedIn AS linkedIn15, r0_.createdAt AS createdAt16, r0_.updatedAt AS updatedAt17, r0_.user_id AS user_id18 FROM rc_profile r0_ WHERE r0_.active = 1 ORDER BY r0_.createdAt DESC LIMIT 3;

SELECT 
  t0.id AS id1, 
  t0.slug AS slug2, 
  t0.active AS active3, 
  t0.name AS name4, 
  t0.description AS description5, 
  t0.duration AS duration6, 
  t0.budgetPrice AS budgetPrice7, 
  t0.priceType AS priceType8, 
  t0.budgetType AS budgetType9, 
  t0.maxParticipants AS maxParticipants10, 
  t0.language AS language11, 
  t0.level AS level12, 
  t0.region AS region13, 
  t0.subscribeMethod AS subscribeMethod14, 
  t0.kind AS kind15, 
  t0.youtube_url AS youtube_url16, 
  t0.short_code AS short_code17, 
  t0.reviewable_type AS reviewable_type18, 
  t0.created_at AS created_at19, 
  t0.updated_at AS updated_at20, 
  t0.countBookings AS countBookings21, 
  t0.roles AS roles22, 
  t0.event_id AS event_id23 
FROM 
  rc_reviewable t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.slug AS slug2, t0.active AS active3, t0.name AS name4, t0.description AS description5, t0.duration AS duration6, t0.budgetPrice AS budgetPrice7, t0.priceType AS priceType8, t0.budgetType AS budgetType9, t0.maxParticipants AS maxParticipants10, t0.language AS language11, t0.level AS level12, t0.region AS region13, t0.subscribeMethod AS subscribeMethod14, t0.kind AS kind15, t0.youtube_url AS youtube_url16, t0.short_code AS short_code17, t0.reviewable_type AS reviewable_type18, t0.created_at AS created_at19, t0.updated_at AS updated_at20, t0.countBookings AS countBookings21, t0.roles AS roles22, t0.event_id AS event_id23 FROM rc_reviewable t0 WHERE t0.id = '30';

SELECT 
  t0.id AS id1, 
  t0.grade AS grade2, 
  t0.grading_option_id AS grading_option_id3, 
  t0.review_id AS review_id4 
FROM 
  rc_review_grades t0 
WHERE 
  t0.review_id = ?

SELECT t0.id AS id1, t0.grade AS grade2, t0.grading_option_id AS grading_option_id3, t0.review_id AS review_id4 FROM rc_review_grades t0 WHERE t0.review_id = 12;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.position AS position3, 
  t0.label AS label4 
FROM 
  rc_grading_option t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.position AS position3, t0.label AS label4 FROM rc_grading_option t0 WHERE t0.id = '11';

SELECT 
  t0.id AS id1, 
  t0.slug AS slug2, 
  t0.active AS active3, 
  t0.name AS name4, 
  t0.description AS description5, 
  t0.duration AS duration6, 
  t0.budgetPrice AS budgetPrice7, 
  t0.priceType AS priceType8, 
  t0.budgetType AS budgetType9, 
  t0.maxParticipants AS maxParticipants10, 
  t0.language AS language11, 
  t0.level AS level12, 
  t0.region AS region13, 
  t0.subscribeMethod AS subscribeMethod14, 
  t0.kind AS kind15, 
  t0.youtube_url AS youtube_url16, 
  t0.short_code AS short_code17, 
  t0.reviewable_type AS reviewable_type18, 
  t0.created_at AS created_at19, 
  t0.updated_at AS updated_at20, 
  t0.countBookings AS countBookings21, 
  t0.roles AS roles22, 
  t0.event_id AS event_id23 
FROM 
  rc_reviewable t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.slug AS slug2, t0.active AS active3, t0.name AS name4, t0.description AS description5, t0.duration AS duration6, t0.budgetPrice AS budgetPrice7, t0.priceType AS priceType8, t0.budgetType AS budgetType9, t0.maxParticipants AS maxParticipants10, t0.language AS language11, t0.level AS level12, t0.region AS region13, t0.subscribeMethod AS subscribeMethod14, t0.kind AS kind15, t0.youtube_url AS youtube_url16, t0.short_code AS short_code17, t0.reviewable_type AS reviewable_type18, t0.created_at AS created_at19, t0.updated_at AS updated_at20, t0.countBookings AS countBookings21, t0.roles AS roles22, t0.event_id AS event_id23 FROM rc_reviewable t0 WHERE t0.id = '4';

SELECT 
  t0.id AS id1, 
  t0.grade AS grade2, 
  t0.grading_option_id AS grading_option_id3, 
  t0.review_id AS review_id4 
FROM 
  rc_review_grades t0 
WHERE 
  t0.review_id = ?

SELECT t0.id AS id1, t0.grade AS grade2, t0.grading_option_id AS grading_option_id3, t0.review_id AS review_id4 FROM rc_review_grades t0 WHERE t0.review_id = 11;

SELECT 
  t0.id AS id1, 
  t0.slug AS slug2, 
  t0.active AS active3, 
  t0.name AS name4, 
  t0.description AS description5, 
  t0.duration AS duration6, 
  t0.budgetPrice AS budgetPrice7, 
  t0.priceType AS priceType8, 
  t0.budgetType AS budgetType9, 
  t0.maxParticipants AS maxParticipants10, 
  t0.language AS language11, 
  t0.level AS level12, 
  t0.region AS region13, 
  t0.subscribeMethod AS subscribeMethod14, 
  t0.kind AS kind15, 
  t0.youtube_url AS youtube_url16, 
  t0.short_code AS short_code17, 
  t0.reviewable_type AS reviewable_type18, 
  t0.created_at AS created_at19, 
  t0.updated_at AS updated_at20, 
  t0.countBookings AS countBookings21, 
  t0.roles AS roles22, 
  t0.event_id AS event_id23 
FROM 
  rc_reviewable t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.slug AS slug2, t0.active AS active3, t0.name AS name4, t0.description AS description5, t0.duration AS duration6, t0.budgetPrice AS budgetPrice7, t0.priceType AS priceType8, t0.budgetType AS budgetType9, t0.maxParticipants AS maxParticipants10, t0.language AS language11, t0.level AS level12, t0.region AS region13, t0.subscribeMethod AS subscribeMethod14, t0.kind AS kind15, t0.youtube_url AS youtube_url16, t0.short_code AS short_code17, t0.reviewable_type AS reviewable_type18, t0.created_at AS created_at19, t0.updated_at AS updated_at20, t0.countBookings AS countBookings21, t0.roles AS roles22, t0.event_id AS event_id23 FROM rc_reviewable t0 WHERE t0.id = '6';

SELECT 
  t0.id AS id1, 
  t0.grade AS grade2, 
  t0.grading_option_id AS grading_option_id3, 
  t0.review_id AS review_id4 
FROM 
  rc_review_grades t0 
WHERE 
  t0.review_id = ?

SELECT t0.id AS id1, t0.grade AS grade2, t0.grading_option_id AS grading_option_id3, t0.review_id AS review_id4 FROM rc_review_grades t0 WHERE t0.review_id = 10;

SELECT 
  t0.id AS id1, 
  t0.slug AS slug2, 
  t0.active AS active3, 
  t0.name AS name4, 
  t0.description AS description5, 
  t0.duration AS duration6, 
  t0.budgetPrice AS budgetPrice7, 
  t0.priceType AS priceType8, 
  t0.budgetType AS budgetType9, 
  t0.maxParticipants AS maxParticipants10, 
  t0.language AS language11, 
  t0.level AS level12, 
  t0.region AS region13, 
  t0.subscribeMethod AS subscribeMethod14, 
  t0.kind AS kind15, 
  t0.youtube_url AS youtube_url16, 
  t0.short_code AS short_code17, 
  t0.reviewable_type AS reviewable_type18, 
  t0.created_at AS created_at19, 
  t0.updated_at AS updated_at20, 
  t0.countBookings AS countBookings21, 
  t0.roles AS roles22, 
  t0.event_id AS event_id23 
FROM 
  rc_reviewable t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.slug AS slug2, t0.active AS active3, t0.name AS name4, t0.description AS description5, t0.duration AS duration6, t0.budgetPrice AS budgetPrice7, t0.priceType AS priceType8, t0.budgetType AS budgetType9, t0.maxParticipants AS maxParticipants10, t0.language AS language11, t0.level AS level12, t0.region AS region13, t0.subscribeMethod AS subscribeMethod14, t0.kind AS kind15, t0.youtube_url AS youtube_url16, t0.short_code AS short_code17, t0.reviewable_type AS reviewable_type18, t0.created_at AS created_at19, t0.updated_at AS updated_at20, t0.countBookings AS countBookings21, t0.roles AS roles22, t0.event_id AS event_id23 FROM rc_reviewable t0 WHERE t0.id = '5';

SELECT 
  t0.id AS id1, 
  t0.grade AS grade2, 
  t0.grading_option_id AS grading_option_id3, 
  t0.review_id AS review_id4 
FROM 
  rc_review_grades t0 
WHERE 
  t0.review_id = ?

SELECT t0.id AS id1, t0.grade AS grade2, t0.grading_option_id AS grading_option_id3, t0.review_id AS review_id4 FROM rc_review_grades t0 WHERE t0.review_id = 9;