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

Response
200 OK
IP
172.31.8.199
Profiled on
Token
643ef7

Query Metrics

43 Database Queries
20 Different statements
68.01 ms Query time
2 Invalid entities
85 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.15 ms 
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"C",Pp¦Ö\x0E@|vì\vSÿÿ¥├!¥"
]
View formatted query    View runnable query    Explain query
2 0.54 ms 
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
]
View formatted query    View runnable query    Explain query
3 0.66 ms 
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: 
[
  5
]
View formatted query    View runnable query    Explain query
4 2.44 ms 
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: 
[
  718384
]
View formatted query    View runnable query    Explain query
5 0.66 ms 
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: 
[
  23288
]
View formatted query    View runnable query    Explain query
6 0.52 ms 
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: 
[
  70
]
View formatted query    View runnable query    Explain query
7 0.46 ms 
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
]
View formatted query    View runnable query    Explain query
8 0.61 ms 
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: 
[
  70
]
View formatted query    View runnable query    Explain query
9 0.41 ms 
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
]
View formatted query    View runnable query    Explain query
10 0.51 ms 
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
]
View formatted query    View runnable query    Explain query
11 0.40 ms 
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: 
[
  6
]
View formatted query    View runnable query    Explain query
12 0.39 ms 
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: 
[
  7
]
View formatted query    View runnable query    Explain query
13 0.53 ms 
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: 
[
  23292
]
View formatted query    View runnable query    Explain query
14 0.47 ms 
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: 
[
  23291
]
View formatted query    View runnable query    Explain query
15 7.64 ms 
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: 
[
  23289
]
View formatted query    View runnable query    Explain query
16 0.93 ms 
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.name = ? LIMIT 1
Parameters: 
[
  "España"
]
View formatted query    View runnable query    Explain query
17 11.03 ms 
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM persons p0_ INNER JOIN person_has_places p1_ ON p0_.id = p1_.person_id INNER JOIN places p2_ ON p1_.place_id = p2_.id WHERE p0_.is_inspirador = 1 AND p2_.id = 2
Parameters: 
[]
View formatted query    View runnable query    Explain query
18 1.39 ms 
SELECT p0_.id AS id_0, p0_.first_name AS first_name_1, p0_.last_name AS last_name_2, p0_.normalized_name AS normalized_name_3, p0_.email AS email_4, p0_.biography AS biography_5, p0_.weight AS weight_6, p0_.full_name AS full_name_7, p0_.is_inspirador AS is_inspirador_8, p0_.facebook_url AS facebook_url_9, p0_.linked_in_url AS linked_in_url_10, p0_.x_url AS x_url_11, p0_.occupation AS occupation_12, p0_.editor_created_id AS editor_created_id_13, p0_.editor_updated_id AS editor_updated_id_14, p0_.profile_image_id AS profile_image_id_15 FROM persons p0_ INNER JOIN person_has_places p1_ ON p0_.id = p1_.person_id INNER JOIN places p2_ ON p1_.place_id = p2_.id WHERE p0_.is_inspirador = 1 AND p2_.id = 2 GROUP BY p0_.id ORDER BY p0_.id DESC LIMIT 5
Parameters: 
[]
View formatted query    View runnable query    Explain query
19 0.72 ms 
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: 
[
  390217
]
View formatted query    View runnable query    Explain query
20 1.12 ms 
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: 
[
  977273
]
View formatted query    View runnable query    Explain query
21 20.28 ms 
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: 
[
  977316
]
View formatted query    View runnable query    Explain query
22 1.09 ms 
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: 
[
  977317
]
View formatted query    View runnable query    Explain query
23 1.25 ms 
SELECT t0.id AS id_1, t0.metas AS metas_2 FROM board_webs t0 WHERE t0.id = ?
Parameters: 
[
  977428
]
View formatted query    View runnable query    Explain query
24 0.55 ms 
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: 
[
  389575
]
View formatted query    View runnable query    Explain query
25 0.86 ms 
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: 
[
  974570
]
View formatted query    View runnable query    Explain query
26 0.63 ms 
SELECT t0.id AS id_1, t0.metas AS metas_2 FROM board_webs t0 WHERE t0.id = ?
Parameters: 
[
  974681
]
View formatted query    View runnable query    Explain query
27 0.64 ms 
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: 
[
  215996
]
View formatted query    View runnable query    Explain query
28 0.72 ms 
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: 
[
  389574
]
View formatted query    View runnable query    Explain query
29 0.75 ms 
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: 
[
  974564
]
View formatted query    View runnable query    Explain query
30 0.69 ms 
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: 
[
  974571
]
View formatted query    View runnable query    Explain query
31 0.55 ms 
SELECT t0.id AS id_1, t0.metas AS metas_2 FROM board_webs t0 WHERE t0.id = ?
Parameters: 
[
  974682
]
View formatted query    View runnable query    Explain query
32 0.74 ms 
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: 
[
  215997
]
View formatted query    View runnable query    Explain query
33 0.55 ms 
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: 
[
  389573
]
View formatted query    View runnable query    Explain query
34 0.69 ms 
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: 
[
  974527
]
View formatted query    View runnable query    Explain query
35 0.61 ms 
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: 
[
  974572
]
View formatted query    View runnable query    Explain query
36 0.43 ms 
SELECT t0.id AS id_1, t0.metas AS metas_2 FROM board_webs t0 WHERE t0.id = ?
Parameters: 
[
  974683
]
View formatted query    View runnable query    Explain query
37 0.51 ms 
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: 
[
  389383
]
View formatted query    View runnable query    Explain query
38 0.63 ms 
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: 
[
  974027
]
View formatted query    View runnable query    Explain query
39 0.47 ms 
SELECT t0.id AS id_1, t0.metas AS metas_2 FROM board_webs t0 WHERE t0.id = ?
Parameters: 
[
  974138
]
View formatted query    View runnable query    Explain query
40 0.50 ms 
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: 
[
  215844
]
View formatted query    View runnable query    Explain query
41 1.03 ms 
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"
  5
  2
]
View formatted query    View runnable query    Explain query
42 0.63 ms 
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: 
[
  718389
]
View formatted query    View runnable query    Explain query
43 0.59 ms 
SELECT s0_.slug AS slug_0 FROM slugs s0_ WHERE s0_.section_id = ? AND s0_.hash IN (?, ?, ?, ?, ?)
Parameters: 
[
  5
  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^"
]
View formatted query    View runnable query    Explain query

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 13
Camus\ModelBundle\Entity\Board\Slug 10
Camus\ModelBundle\Entity\Board\BoardVersion 10
Camus\ModelBundle\Entity\Board\BoardWeb 10
Camus\AdBundle\Entity\AdSizes 7
Camus\ModelBundle\Entity\Board\Module 6
Camus\AdBundle\Entity\Size 6
App\Entity\Person 5
Camus\AdBundle\Entity\Ad 4
Camus\AdBundle\Entity\AdSpace 4
App\Admin\Sonata\UserBundle\Entity\User 3
Camus\MediaBundle\Entity\Media 3
Camus\ModelBundle\Entity\Place 2
Camus\ModelBundle\Entity\Section 1
Camus\AdBundle\Entity\Enviroment 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.
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.
Camus\MediaBundle\Entity\MediaHasKeyword No errors.
Camus\MediaBundle\Entity\MediaHasTag No errors.
Camus\MediaBundle\Entity\MediaHasTrackingTag No errors.
Camus\MediaBundle\Entity\ContentHasMedia No errors.