Redirect 301 redirect from GET @content-index (c77f12)

GET http://stage-mx.librotea.com/americas/videotea

Query Metrics

205 Database Queries
34 Different statements
277.69 ms Query time
2 Invalid entities
334 Managed entities

Grouped Statements

Show all queries

Time Count Info
31.12 ms
(11.21%)
28
SELECT t0.id AS id_1, t0.reference_id AS reference_id_2, t0.file_type AS file_type_3, t0.provider_name AS provider_name_4, t0.published_date AS published_date_5, t0.creation_date AS creation_date_6, t0.deleted AS deleted_7, t0.title AS title_8, t0.summary AS summary_9, t0.length AS length_10, t0.size AS size_11, t0.width AS width_12, t0.height AS height_13, t0.enable AS enable_14, t0.provider_reference AS provider_reference_15, t0.id_you_tube AS id_you_tube_16, t0.file_hash AS file_hash_17, t0.section_id AS section_id_18, t0.place_id AS place_id_19, t0.board_media_id AS board_media_id_20, t0.media_id AS media_id_21, t0.thumbnail_id AS thumbnail_id_22, t0.thumbnail_clipping_id AS thumbnail_clipping_id_23 FROM medias t0 WHERE t0.id = ?
Parameters:
[
  225844
]
27.90 ms
(10.05%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.normalized_title AS normalized_title_4, t0.summary AS summary_5 FROM literary_works t0 WHERE t0.id = ?
Parameters:
[
  596811
]
27.76 ms
(10.00%)
2
SELECT t0.id AS id_1, t0.reference_id AS reference_id_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4, t0.name AS name_5, t0.active AS active_6, t0.weight AS weight_7, t0.editor_updated_id AS editor_updated_id_8 FROM places t0 WHERE t0.id = ?
Parameters:
[
  2
]
26.69 ms
(9.61%)
24
SELECT t0.id AS id_9, t0.creation_date AS creation_date_10, t0.modification_date AS modification_date_11, t0.name AS name_12, t0.template AS template_13, t0.type AS type_14, t0.active AS active_15, t0.reference_id AS reference_id_16, t0.system_board AS system_board_17, t0.title AS title_18, t0.published_version_id AS published_version_id_19, t0.editor_created_id AS editor_created_id_20, t0.editor_updated_id AS editor_updated_id_21, t0.board_web_id AS board_web_id_22, t0.disc, t1.content_id AS content_id_23, t2.section_id AS section_id_24, t3.tag_id AS tag_id_25, t4.place_id AS place_id_26, t5.media_id AS media_id_27, t6.person_id AS person_id_28, t7.legal_page_id AS legal_page_id_29, t8.person_id AS person_id_30 FROM boards t0 LEFT JOIN board_contents t1 ON t0.id = t1.id LEFT JOIN board_sections t2 ON t0.id = t2.id LEFT JOIN board_tags t3 ON t0.id = t3.id LEFT JOIN board_places t4 ON t0.id = t4.id LEFT JOIN board_medias t5 ON t0.id = t5.id LEFT JOIN board_inspirators t6 ON t0.id = t6.id LEFT JOIN board_legal_pages t7 ON t0.id = t7.id LEFT JOIN board_authors t8 ON t0.id = t8.id WHERE t0.id = ?
Parameters:
[
  726797
]
21.32 ms
(7.68%)
15
SELECT t1.id AS id_2, t1.creation_date AS creation_date_3, t1.modification_date AS modification_date_4, t1.name AS name_5, t1.template AS template_6, t1.type AS type_7, t1.active AS active_8, t1.reference_id AS reference_id_9, t1.system_board AS system_board_10, t1.title AS title_11, t1.published_version_id AS published_version_id_12, t1.editor_created_id AS editor_created_id_13, t1.editor_updated_id AS editor_updated_id_14, t1.board_web_id AS board_web_id_15, t0.content_id AS content_id_16, t1.disc FROM board_contents t0 INNER JOIN boards t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  1029180
]
19.95 ms
(7.18%)
16
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.hash AS hash_3, t0.content_id AS content_id_4, t0.tag_id AS tag_id_5, t0.section_id AS section_id_6, t0.place_id AS place_id_7, t0.redirect_slug_id AS redirect_slug_id_8, t0.board_id AS board_id_9, t0.editor_updated_id AS editor_updated_id_10, t0.media_id AS media_id_11, t0.legal_page_id AS legal_page_id_12, t0.opinion_id AS opinion_id_13, t0.person_id AS person_id_14 FROM slugs t0 WHERE t0.content_id = ?
Parameters:
[
  610996
]
17.05 ms
(6.14%)
15
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.normalized_name AS normalized_name_4, t0.email AS email_5, t0.biography AS biography_6, t0.weight AS weight_7, t0.full_name AS full_name_8, t0.is_inspirador AS is_inspirador_9, t0.facebook_url AS facebook_url_10, t0.linked_in_url AS linked_in_url_11, t0.x_url AS x_url_12, t0.occupation AS occupation_13, t0.editor_created_id AS editor_created_id_14, t0.editor_updated_id AS editor_updated_id_15, t0.profile_image_id AS profile_image_id_16 FROM persons t0 INNER JOIN contents_has_persons ON t0.id = contents_has_persons.persons WHERE contents_has_persons.base_contents = ?
Parameters:
[
  610996
]
16.03 ms
(5.77%)
13
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.hash AS hash_3, t0.content_id AS content_id_4, t0.tag_id AS tag_id_5, t0.section_id AS section_id_6, t0.place_id AS place_id_7, t0.redirect_slug_id AS redirect_slug_id_8, t0.board_id AS board_id_9, t0.editor_updated_id AS editor_updated_id_10, t0.media_id AS media_id_11, t0.legal_page_id AS legal_page_id_12, t0.opinion_id AS opinion_id_13, t0.person_id AS person_id_14 FROM slugs t0 WHERE t0.person_id = ?
Parameters:
[
  5
]
11.32 ms
(4.08%)
15
SELECT t0.id AS id_1, t0.metas AS metas_2 FROM board_webs t0 WHERE t0.id = ?
Parameters:
[
  1029309
]
10.09 ms
(3.63%)
15
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.short_title AS short_title_5, t0.summary AS summary_6, t0.body AS body_7, t0.short_piece AS short_piece_8, t0.signature AS signature_9, t0.signature_place AS signature_place_10, t0.type AS type_11, t0.kind AS kind_12, t0.language AS language_13, t0.editor_created_id AS editor_created_id_14, t15.id AS id_16, t15.reference_id AS reference_id_17, t15.creation_date AS creation_date_18, t15.scheduled_date AS scheduled_date_19, t15.published_date AS published_date_20, t15.event_start_date AS event_start_date_21, t15.event_end_date AS event_end_date_22, t15.show_on_list AS show_on_list_23, t15.deleted AS deleted_24, t15.published_version_id AS published_version_id_25, t15.section_id AS section_id_26, t15.place_id AS place_id_27, t15.board_content_id AS board_content_id_28, t15.editor_created_id AS editor_created_id_29, t15.content_type_id AS content_type_id_30, t15.book_id AS book_id_31, t15.bookshelf_person AS bookshelf_person_32, t15.board_legal_page_id AS board_legal_page_id_33, t0.content_id AS content_id_34, t0.thumbnail_id AS thumbnail_id_35 FROM versions t0 LEFT JOIN contents t15 ON t15.published_version_id = t0.id WHERE t0.id = ?
Parameters:
[
  612046
]
8.42 ms
(3.03%)
15
SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.media_id AS media_id_4, t0.content_id AS content_id_5, t0.media_clipping_id AS media_clipping_id_6 FROM content_has_medias t0 WHERE t0.content_id = ?
Parameters:
[
  610996
]
7.97 ms
(2.87%)
13
SELECT t0.id AS id_1, t0.name AS name_2, t0.creation_date AS creation_date_3, t0.x AS x_4, t0.y AS y_5, t0.width AS width_6, t0.height AS height_7, t0.quality AS quality_8, t0.file_extension AS file_extension_9, t0.conversion AS conversion_10, t0.media_id AS media_id_11 FROM clippings t0 WHERE t0.id = ?
Parameters:
[
  665
]
7.00 ms
(2.52%)
1
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.normalized_name AS normalized_name_4, t0.email AS email_5, t0.biography AS biography_6, t0.weight AS weight_7, t0.full_name AS full_name_8, t0.is_inspirador AS is_inspirador_9, t0.facebook_url AS facebook_url_10, t0.linked_in_url AS linked_in_url_11, t0.x_url AS x_url_12, t0.occupation AS occupation_13, t0.editor_created_id AS editor_created_id_14, t0.editor_updated_id AS editor_updated_id_15, t0.profile_image_id AS profile_image_id_16 FROM persons t0 INNER JOIN literary_work_contributors ON t0.id = literary_work_contributors.persons WHERE literary_work_contributors.literary_works = ?
Parameters:
[
  596811
]
5.48 ms
(1.97%)
1
SELECT t0.id AS id_1, t0.reference_id AS reference_id_2, t0.creation_date AS creation_date_3, t0.scheduled_date AS scheduled_date_4, t0.published_date AS published_date_5, t0.event_start_date AS event_start_date_6, t0.event_end_date AS event_end_date_7, t0.show_on_list AS show_on_list_8, t0.deleted AS deleted_9, t0.published_version_id AS published_version_id_10, t0.section_id AS section_id_11, t0.place_id AS place_id_12, t0.board_content_id AS board_content_id_13, t0.editor_created_id AS editor_created_id_14, t0.content_type_id AS content_type_id_15, t0.book_id AS book_id_16, t0.bookshelf_person AS bookshelf_person_17, t0.board_legal_page_id AS board_legal_page_id_18 FROM contents t0 WHERE t0.book_id = ?
Parameters:
[
  596699
]
4.69 ms
(1.69%)
1
SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.name AS name_2, a0_.name_code AS name_code_3, s1_.id AS id_4, s1_.reference_id AS reference_id_5, s1_.creation_date AS creation_date_6, s1_.modification_date AS modification_date_7, s1_.name AS name_8, s1_.title AS title_9, s1_.active AS active_10, p2_.id AS id_11, p2_.reference_id AS reference_id_12, p2_.creation_date AS creation_date_13, p2_.modification_date AS modification_date_14, p2_.name AS name_15, p2_.active AS active_16, p2_.weight AS weight_17, a3_.id AS id_18, a4_.id AS id_19, a4_.width AS width_20, a4_.height AS height_21, a4_.mobile_width AS mobile_width_22, a4_.mobile_height AS mobile_height_23, a4_.name AS name_24, a5_.id AS id_25, a5_.name AS name_26, a5_.template AS template_27, a0_.section_id AS section_id_28, a0_.place_id AS place_id_29, a0_.enviroment_id AS enviroment_id_30, a0_.space_id AS space_id_31, s1_.editor_created_id AS editor_created_id_32, s1_.editor_updated_id AS editor_updated_id_33, s1_.parent_id AS parent_id_34, p2_.editor_updated_id AS editor_updated_id_35, a3_.ad_id AS ad_id_36, a3_.size_id AS size_id_37 FROM ads a0_ LEFT JOIN sections s1_ ON a0_.section_id = s1_.id LEFT JOIN places p2_ ON a0_.place_id = p2_.id LEFT JOIN ad_has_sizes a3_ ON a0_.id = a3_.ad_id LEFT JOIN ad_sizes a4_ ON a3_.size_id = a4_.id LEFT JOIN ad_space a5_ ON a0_.space_id = a5_.id WHERE a0_.type = ? AND s1_.id = ? AND p2_.id = ? ORDER BY a0_.section_id ASC
Parameters:
[
  "Board"
  6
  2
]
4.68 ms
(1.69%)
5
SELECT t0.id AS id_1, t0.module_id AS module_id_2, t0.media_id AS media_id_3, t0.mobile_clipping_id AS mobile_clipping_id_4, t0.desktop_clipping_id AS desktop_clipping_id_5 FROM module_has_mediass t0 WHERE t0.module_id = ?
Parameters:
[
  23306
]
4.30 ms
(1.55%)
3
SELECT t0.id AS id_1, t0.width AS width_2, t0.height AS height_3, t0.mobile_width AS mobile_width_4, t0.mobile_height AS mobile_height_5, t0.name AS name_6 FROM ad_sizes t0 WHERE t0.id = ?
Parameters:
[
  2
]
4.13 ms
(1.49%)
5
SELECT t0.id AS id_1, t0.reference_id AS reference_id_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4, t0.name AS name_5, t0.title AS title_6, t0.active AS active_7, t0.editor_created_id AS editor_created_id_8, t0.editor_updated_id AS editor_updated_id_9, t0.parent_id AS parent_id_10 FROM sections t0 WHERE t0.id = ?
Parameters:
[
  6
]
3.71 ms
(1.34%)
1
SELECT t0.id AS id_1, t0.isbn AS isbn_2, t0.product_form AS product_form_3, t0.editorial_id AS editorial_id_4, t0.literary_work_id AS literary_work_id_5, t0.media_id AS media_id_6 FROM books t0 WHERE t0.id = ?
Parameters:
[
  596699
]
3.40 ms
(1.22%)
2
SELECT p0_.id AS id_0, p0_.reference_id AS reference_id_1, p0_.creation_date AS creation_date_2, p0_.modification_date AS modification_date_3, p0_.name AS name_4, p0_.active AS active_5, p0_.weight AS weight_6, p0_.editor_updated_id AS editor_updated_id_7 FROM places p0_, slugs s1_ LEFT JOIN places p2_ ON s1_.place_id = p2_.id LEFT JOIN contents c3_ ON s1_.content_id = c3_.id LEFT JOIN places p4_ ON c3_.place_id = p4_.id LEFT JOIN medias m5_ ON s1_.media_id = m5_.id LEFT JOIN places p6_ ON m5_.place_id = p6_.id WHERE s1_.hash = ? AND (p2_.id = p0_.id OR p4_.id = p0_.id OR p6_.id = p0_.id)
Parameters:
[
  b"ÐCP1ñåpÎ7‡„f\r\x01\x02TäKÛ_"
]
2.74 ms
(0.99%)
1
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.hash AS hash_2, b1_.id AS id_3, b1_.creation_date AS creation_date_4, b1_.modification_date AS modification_date_5, b1_.name AS name_6, b1_.template AS template_7, b1_.type AS type_8, b1_.active AS active_9, b1_.reference_id AS reference_id_10, b1_.system_board AS system_board_11, b1_.title AS title_12, b10_.id AS id_13, b10_.reference_id AS reference_id_14, b10_.creation_date AS creation_date_15, b10_.modification_date AS modification_date_16, b10_.schedule_date AS schedule_date_17, b10_.extra_data AS extra_data_18, b11_.id AS id_19, b11_.metas AS metas_20, c12_.id AS id_21, c12_.reference_id AS reference_id_22, c12_.creation_date AS creation_date_23, c12_.scheduled_date AS scheduled_date_24, c12_.published_date AS published_date_25, c12_.event_start_date AS event_start_date_26, c12_.event_end_date AS event_end_date_27, c12_.show_on_list AS show_on_list_28, c12_.deleted AS deleted_29, s0_.content_id AS content_id_30, s0_.tag_id AS tag_id_31, s0_.section_id AS section_id_32, s0_.place_id AS place_id_33, s0_.redirect_slug_id AS redirect_slug_id_34, s0_.board_id AS board_id_35, s0_.editor_updated_id AS editor_updated_id_36, s0_.media_id AS media_id_37, s0_.legal_page_id AS legal_page_id_38, s0_.opinion_id AS opinion_id_39, s0_.person_id AS person_id_40, b1_.disc AS disc_41, b1_.published_version_id AS published_version_id_42, b1_.editor_created_id AS editor_created_id_43, b1_.editor_updated_id AS editor_updated_id_44, b1_.board_web_id AS board_web_id_45, b2_.content_id AS content_id_46, b3_.section_id AS section_id_47, b4_.tag_id AS tag_id_48, b5_.place_id AS place_id_49, b6_.media_id AS media_id_50, b7_.person_id AS person_id_51, b8_.legal_page_id AS legal_page_id_52, b9_.person_id AS person_id_53, b10_.editor_created_id AS editor_created_id_54, b10_.editor_updated_id AS editor_updated_id_55, b10_.editor_published_id AS editor_published_id_56, b10_.board_id AS board_id_57, c12_.published_version_id AS published_version_id_58, c12_.section_id AS section_id_59, c12_.place_id AS place_id_60, c12_.board_content_id AS board_content_id_61, c12_.editor_created_id AS editor_created_id_62, c12_.content_type_id AS content_type_id_63, c12_.book_id AS book_id_64, c12_.bookshelf_person AS bookshelf_person_65, c12_.board_legal_page_id AS board_legal_page_id_66 FROM slugs s0_ LEFT JOIN boards b1_ ON s0_.board_id = b1_.id LEFT JOIN board_contents b2_ ON b1_.id = b2_.id LEFT JOIN board_sections b3_ ON b1_.id = b3_.id LEFT JOIN board_tags b4_ ON b1_.id = b4_.id LEFT JOIN board_places b5_ ON b1_.id = b5_.id LEFT JOIN board_medias b6_ ON b1_.id = b6_.id LEFT JOIN board_inspirators b7_ ON b1_.id = b7_.id LEFT JOIN board_legal_pages b8_ ON b1_.id = b8_.id LEFT JOIN board_authors b9_ ON b1_.id = b9_.id LEFT JOIN board_versions b10_ ON b1_.published_version_id = b10_.id LEFT JOIN board_webs b11_ ON b1_.board_web_id = b11_.id LEFT JOIN contents c12_ ON s0_.content_id = c12_.id WHERE s0_.hash = ?
Parameters:
[
  b"«Ê\x1Eì]ŒÛÿuœfÂèÐÂÔÝ–O^"
]
1.72 ms
(0.62%)
1
SELECT m0_.id AS id_0, m0_.reference_id AS reference_id_1, m0_.body AS body_2, m0_.link AS link_3, m0_.position AS position_4, m0_.template AS template_5, m0_.type AS type_6, m0_.extra_data AS extra_data_7, m0_.title AS title_8, m0_.abstract AS abstract_9, m0_.editorial AS editorial_10, m0_.heading AS heading_11, m0_.author AS author_12, m0_.column_name AS column_name_13, m0_.section_name AS section_name_14, m0_.place_name AS place_name_15, m0_.published_date AS published_date_16, m0_.layout AS layout_17, m0_.creation_date AS creation_date_18, m1_.automatic_list AS automatic_list_19, m1_.offset_list AS offset_list_20, m1_.limit_list AS limit_list_21, m1_.media_type AS media_type_22, m1_.start_date AS start_date_23, m1_.end_date AS end_date_24, m1_.search_criteria AS search_criteria_25, m1_.include_subcategories AS include_subcategories_26, m1_.pagination AS pagination_27, m1_.page_number AS page_number_28, m2_.id AS id_29, m2_.reference_id AS reference_id_30, m2_.body AS body_31, m2_.link AS link_32, m2_.position AS position_33, m2_.template AS template_34, m2_.type AS type_35, m2_.extra_data AS extra_data_36, m2_.title AS title_37, m2_.abstract AS abstract_38, m2_.editorial AS editorial_39, m2_.heading AS heading_40, m2_.author AS author_41, m2_.column_name AS column_name_42, m2_.section_name AS section_name_43, m2_.place_name AS place_name_44, m2_.published_date AS published_date_45, m2_.layout AS layout_46, m2_.creation_date AS creation_date_47, m3_.automatic_list AS automatic_list_48, m3_.offset_list AS offset_list_49, m3_.limit_list AS limit_list_50, m3_.media_type AS media_type_51, m3_.start_date AS start_date_52, m3_.end_date AS end_date_53, m3_.search_criteria AS search_criteria_54, m3_.include_subcategories AS include_subcategories_55, m3_.pagination AS pagination_56, m3_.page_number AS page_number_57, m4_.id AS id_58, m4_.reference_id AS reference_id_59, m4_.body AS body_60, m4_.link AS link_61, m4_.position AS position_62, m4_.template AS template_63, m4_.type AS type_64, m4_.extra_data AS extra_data_65, m4_.title AS title_66, m4_.abstract AS abstract_67, m4_.editorial AS editorial_68, m4_.heading AS heading_69, m4_.author AS author_70, m4_.column_name AS column_name_71, m4_.section_name AS section_name_72, m4_.place_name AS place_name_73, m4_.published_date AS published_date_74, m4_.layout AS layout_75, m4_.creation_date AS creation_date_76, m5_.automatic_list AS automatic_list_77, m5_.offset_list AS offset_list_78, m5_.limit_list AS limit_list_79, m5_.media_type AS media_type_80, m5_.start_date AS start_date_81, m5_.end_date AS end_date_82, m5_.search_criteria AS search_criteria_83, m5_.include_subcategories AS include_subcategories_84, m5_.pagination AS pagination_85, m5_.page_number AS page_number_86, m6_.id AS id_87, m6_.reference_id AS reference_id_88, m6_.body AS body_89, m6_.link AS link_90, m6_.position AS position_91, m6_.template AS template_92, m6_.type AS type_93, m6_.extra_data AS extra_data_94, m6_.title AS title_95, m6_.abstract AS abstract_96, m6_.editorial AS editorial_97, m6_.heading AS heading_98, m6_.author AS author_99, m6_.column_name AS column_name_100, m6_.section_name AS section_name_101, m6_.place_name AS place_name_102, m6_.published_date AS published_date_103, m6_.layout AS layout_104, m6_.creation_date AS creation_date_105, m7_.automatic_list AS automatic_list_106, m7_.offset_list AS offset_list_107, m7_.limit_list AS limit_list_108, m7_.media_type AS media_type_109, m7_.start_date AS start_date_110, m7_.end_date AS end_date_111, m7_.search_criteria AS search_criteria_112, m7_.include_subcategories AS include_subcategories_113, m7_.pagination AS pagination_114, m7_.page_number AS page_number_115, m0_.disc AS disc_116, m0_.news_event_id AS news_event_id_117, m0_.board_id AS board_id_118, m0_.content_location_id AS content_location_id_119, m0_.sponsor_id AS sponsor_id_120, m0_.video_id AS video_id_121, m0_.content_id AS content_id_122, m0_.editor_created_id AS editor_created_id_123, m0_.editor_updated_id AS editor_updated_id_124, m0_.ad_id AS ad_id_125, m0_.person_id AS person_id_126, m1_.section_filter_id AS section_filter_id_127, m1_.content_type_id AS content_type_id_128, m1_.place_filter_id AS place_filter_id_129, m1_.author_filter_id AS author_filter_id_130, m1_.tag_filter_id AS tag_filter_id_131, m1_.category_filter_id AS category_filter_id_132, m2_.disc AS disc_133, m2_.news_event_id AS news_event_id_134, m2_.board_id AS board_id_135, m2_.content_location_id AS content_location_id_136, m2_.sponsor_id AS sponsor_id_137, m2_.video_id AS video_id_138, m2_.content_id AS content_id_139, m2_.editor_created_id AS editor_created_id_140, m2_.editor_updated_id AS editor_updated_id_141, m2_.ad_id AS ad_id_142, m2_.person_id AS person_id_143, m3_.section_filter_id AS section_filter_id_144, m3_.content_type_id AS content_type_id_145, m3_.place_filter_id AS place_filter_id_146, m3_.author_filter_id AS author_filter_id_147, m3_.tag_filter_id AS tag_filter_id_148, m3_.category_filter_id AS category_filter_id_149, m4_.disc AS disc_150, m4_.news_event_id AS news_event_id_151, m4_.board_id AS board_id_152, m4_.content_location_id AS content_location_id_153, m4_.sponsor_id AS sponsor_id_154, m4_.video_id AS video_id_155, m4_.content_id AS content_id_156, m4_.editor_created_id AS editor_created_id_157, m4_.editor_updated_id AS editor_updated_id_158, m4_.ad_id AS ad_id_159, m4_.person_id AS person_id_160, m5_.section_filter_id AS section_filter_id_161, m5_.content_type_id AS content_type_id_162, m5_.place_filter_id AS place_filter_id_163, m5_.author_filter_id AS author_filter_id_164, m5_.tag_filter_id AS tag_filter_id_165, m5_.category_filter_id AS category_filter_id_166, m6_.disc AS disc_167, m6_.news_event_id AS news_event_id_168, m6_.board_id AS board_id_169, m6_.content_location_id AS content_location_id_170, m6_.sponsor_id AS sponsor_id_171, m6_.video_id AS video_id_172, m6_.content_id AS content_id_173, m6_.editor_created_id AS editor_created_id_174, m6_.editor_updated_id AS editor_updated_id_175, m6_.ad_id AS ad_id_176, m6_.person_id AS person_id_177, m7_.section_filter_id AS section_filter_id_178, m7_.content_type_id AS content_type_id_179, m7_.place_filter_id AS place_filter_id_180, m7_.author_filter_id AS author_filter_id_181, m7_.tag_filter_id AS tag_filter_id_182, m7_.category_filter_id AS category_filter_id_183 FROM modules m0_ LEFT JOIN module_lists m1_ ON m0_.id = m1_.id LEFT JOIN modules_has_modules m8_ ON m0_.id = m8_.module_id LEFT JOIN modules m2_ ON m2_.id = m8_.modules LEFT JOIN module_lists m3_ ON m2_.id = m3_.id LEFT JOIN modules_has_modules m9_ ON m2_.id = m9_.module_id LEFT JOIN modules m4_ ON m4_.id = m9_.modules LEFT JOIN module_lists m5_ ON m4_.id = m5_.id LEFT JOIN modules_has_modules m10_ ON m4_.id = m10_.module_id LEFT JOIN modules m6_ ON m6_.id = m10_.modules LEFT JOIN module_lists m7_ ON m6_.id = m7_.id WHERE m0_.board_id = ?
Parameters:
[
  879695
]
1.58 ms
(0.57%)
1
SELECT s0_.slug AS slug_0 FROM slugs s0_ WHERE s0_.section_id = ? AND s0_.hash IN (?, ?, ?, ?, ?)
Parameters:
[
  6
  b"ú$TyJøÏ\v¨$¡Ž#éy¿­ €\x00"
  b"C",Pp¦Ö\x0E@|vì\vSÿÿ¥├!¥"
  b"ZÖs{&P”ðÚ(Îöÿâ{­ZÛ\x18\x0E"
  b"¾”p\x07<\x07dU”\x01\x192/<ŒA%\x15Î"
  b"«Ê\x1Eì]ŒÛÿuœfÂèÐÂÔÝ–O^"
]
1.47 ms
(0.53%)
1
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.normalized_name AS normalized_name_4, t0.email AS email_5, t0.biography AS biography_6, t0.weight AS weight_7, t0.full_name AS full_name_8, t0.is_inspirador AS is_inspirador_9, t0.facebook_url AS facebook_url_10, t0.linked_in_url AS linked_in_url_11, t0.x_url AS x_url_12, t0.occupation AS occupation_13, t0.editor_created_id AS editor_created_id_14, t0.editor_updated_id AS editor_updated_id_15, t0.profile_image_id AS profile_image_id_16 FROM persons t0 WHERE t0.id = ?
Parameters:
[
  390217
]
1.26 ms
(0.45%)
1
SELECT k0_.id AS id_0, k0_.keyword AS keyword_1, k0_.keyword_normalized AS keyword_normalized_2, k0_.creation_date AS creation_date_3, k0_.editor_created_id AS editor_created_id_4, k0_.editor_updated_id AS editor_updated_id_5 FROM keywords k0_ INNER JOIN boards_has_keywords b2_ ON k0_.id = b2_.keywords INNER JOIN board_webs b1_ ON b1_.id = b2_.board_id WHERE b1_.id = ?
Parameters:
[
  879765
]
1.04 ms
(0.38%)
1
SELECT c0_.id AS id_0, c0_.reference_id AS reference_id_1, c0_.creation_date AS creation_date_2, c0_.scheduled_date AS scheduled_date_3, c0_.published_date AS published_date_4, c0_.event_start_date AS event_start_date_5, c0_.event_end_date AS event_end_date_6, c0_.show_on_list AS show_on_list_7, c0_.deleted AS deleted_8, c0_.published_version_id AS published_version_id_9, c0_.section_id AS section_id_10, c0_.place_id AS place_id_11, c0_.board_content_id AS board_content_id_12, c0_.editor_created_id AS editor_created_id_13, c0_.content_type_id AS content_type_id_14, c0_.book_id AS book_id_15, c0_.bookshelf_person AS bookshelf_person_16, c0_.board_legal_page_id AS board_legal_page_id_17 FROM contents c0_ INNER JOIN versions v1_ ON c0_.published_version_id = v1_.id INNER JOIN content_types c2_ ON c0_.content_type_id = c2_.id INNER JOIN places p3_ ON c0_.place_id = p3_.id WHERE c0_.published_date IS NOT NULL AND c0_.show_on_list = 1 AND c0_.deleted IS NULL AND c2_.id = 4 AND p3_.id = 2 GROUP BY c0_.id ORDER BY c0_.published_date DESC LIMIT 15
Parameters:
[]
0.91 ms
(0.33%)
1
SELECT t0.id AS id_1, t0.enviroment_name AS enviroment_name_2, t0.enviroment_code AS enviroment_code_3 FROM ad_enviroments t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.90 ms
(0.32%)
1
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contents c0_ INNER JOIN versions v1_ ON c0_.published_version_id = v1_.id INNER JOIN content_types c2_ ON c0_.content_type_id = c2_.id INNER JOIN places p3_ ON c0_.place_id = p3_.id WHERE c0_.published_date IS NOT NULL AND c0_.show_on_list = 1 AND c0_.deleted IS NULL AND c2_.id = 4 AND p3_.id = 2
Parameters:
[]
0.60 ms
(0.22%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.creation_date AS creation_date_4, t0.updated_date AS updated_date_5 FROM content_types t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.52 ms
(0.19%)
1
SELECT t0.id AS id_1, t0.ad_id AS ad_id_2, t0.size_id AS size_id_3 FROM ad_has_sizes t0 WHERE t0.ad_id = ?
Parameters:
[
  91
]
0.51 ms
(0.18%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.name_code AS name_code_4, t0.section_id AS section_id_5, t0.place_id AS place_id_6, t0.enviroment_id AS enviroment_id_7, t0.space_id AS space_id_8 FROM ads t0 WHERE t0.id = ?
Parameters:
[
  91
]
0.51 ms
(0.18%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3 FROM ad_space t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.50 ms
(0.18%)
1
SELECT t0.id AS id_1, t0.reference_id AS reference_id_2, t0.creation_date AS creation_date_3, t0.scheduled_date AS scheduled_date_4, t0.published_date AS published_date_5, t0.event_start_date AS event_start_date_6, t0.event_end_date AS event_end_date_7, t0.show_on_list AS show_on_list_8, t0.deleted AS deleted_9, t0.published_version_id AS published_version_id_10, t0.section_id AS section_id_11, t0.place_id AS place_id_12, t0.board_content_id AS board_content_id_13, t0.editor_created_id AS editor_created_id_14, t0.content_type_id AS content_type_id_15, t0.book_id AS book_id_16, t0.bookshelf_person AS bookshelf_person_17, t0.board_legal_page_id AS board_legal_page_id_18 FROM contents t0 WHERE t0.id = ?
Parameters:
[
  599573
]
0.42 ms
(0.15%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_normalized AS name_normalized_3 FROM editorials t0 WHERE t0.id = ?
Parameters:
[
  153
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
Camus\ModelBundle\Entity\Board\Board 64
Camus\ModelBundle\Entity\Board\Slug 41
Camus\ModelBundle\Entity\Board\BoardVersion 40
Camus\ModelBundle\Entity\Board\BoardWeb 40
Camus\MediaBundle\Entity\Media 28
App\Entity\Content 16
App\Entity\Version 16
Camus\MediaBundle\Entity\ContentHasMedia 14
App\Entity\Person 13
Camus\MediaBundle\Entity\Clipping 13
App\Admin\Sonata\UserBundle\Entity\User 7
Camus\ModelBundle\Entity\Board\Module 7
Camus\AdBundle\Entity\AdSizes 7
Camus\ModelBundle\Entity\Section 6
Camus\AdBundle\Entity\Size 6
Camus\AdBundle\Entity\Ad 4
Camus\AdBundle\Entity\AdSpace 3
Camus\ModelBundle\Entity\Place 2
Camus\ModelBundle\Entity\ContentType 2
Camus\AdBundle\Entity\Enviroment 1
Camus\MediaBundle\Entity\ModuleHasMedias 1
App\Entity\Book 1
App\Entity\Editorial 1
App\Entity\LiteraryWork 1

Entities Mapping

Class Mapping errors
Camus\AdBundle\Entity\AdSpace No errors.
Camus\ModelBundle\Entity\Board\Slug No errors.
Camus\ModelBundle\Entity\Board\Board No errors.
Camus\ModelBundle\Entity\Board\BoardVersion No errors.
Camus\ModelBundle\Entity\Board\BoardWeb No errors.
Camus\ModelBundle\Entity\BaseContent No errors.
App\Entity\Content No errors.
Camus\ModelBundle\Entity\Board\BoardContent No errors.
Camus\ModelBundle\Entity\Board\BoardSection No errors.
Camus\ModelBundle\Entity\Board\BoardTag No errors.
Camus\ModelBundle\Entity\Board\BoardPlace No errors.
Camus\ModelBundle\Entity\Board\BoardMedia No errors.
Camus\ModelBundle\Entity\Board\BoardInspirator No errors.
Camus\ModelBundle\Entity\Board\BoardLegalPage No errors.
Camus\ModelBundle\Entity\Board\BoardAuthor No errors.
Camus\ModelBundle\Entity\Tag No errors.
Camus\ModelBundle\Entity\Section No errors.
Camus\ModelBundle\Entity\Place No errors.
App\Admin\Sonata\UserBundle\Entity\User No errors.
Camus\MediaBundle\Entity\Media No errors.
Camus\ModelBundle\Entity\LegalPage No errors.
App\Entity\Opinion No errors.
Camus\ModelBundle\Entity\Person No errors.
App\Entity\Person No errors.
Camus\ModelBundle\Entity\BaseVersion No errors.
App\Entity\Version No errors.
Camus\ModelBundle\Entity\ContentType No errors.
App\Entity\Book No errors.
Camus\ModelBundle\Entity\Board\Module No errors.
Camus\ModelBundle\Entity\Keyword No errors.
Camus\ModelBundle\Entity\PersonHasPlaces No errors.
Camus\ModelBundle\Entity\Board\ModuleList No errors.
Camus\ModelBundle\Entity\NewsEvent No errors.
Camus\ModelBundle\Entity\Sponsor No errors.
Camus\AdBundle\Entity\Ad No errors.
App\Entity\Category No errors.
Camus\MediaBundle\Entity\ModuleHasMedias No errors.
Camus\ModelBundle\Entity\Board\ModuleHasAd No errors.
Camus\MediaBundle\Entity\Clipping No errors.
Camus\AdBundle\Entity\Enviroment No errors.
Camus\AdBundle\Entity\AdSizes No errors.
Camus\AdBundle\Entity\ModuleListHasAd
  • The association Camus\AdBundle\Entity\ModuleListHasAd#moduleList refers to the inverse side field Camus\ModelBundle\Entity\Board\ModuleList#adsList which does not exist.
Camus\AdBundle\Entity\Size No errors.
Camus\ModelBundle\Entity\ContentHasContent No errors.
Camus\ModelBundle\Entity\ContentHasTag No errors.
Camus\ModelBundle\Entity\ContentHasKeyword No errors.
Camus\ModelBundle\Entity\ContentHasTrackingTag No errors.
Camus\ModelBundle\Entity\ContentHasNewsEvent No errors.
Camus\MediaBundle\Entity\ContentHasMedia No errors.
Camus\MediaBundle\Entity\MediaHasKeyword No errors.
Camus\MediaBundle\Entity\MediaHasTag No errors.
Camus\MediaBundle\Entity\MediaHasTrackingTag No errors.
App\Entity\LiteraryWork
  • The field App\Entity\LiteraryWork#books is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Book#literaryWork does not contain the required 'inversedBy="books"' attribute.
App\Entity\BookContributor No errors.
App\Entity\Editorial No errors.