https://portales-vivienda.staff.digital/config.json/

Forwarded to
ErrorController (42bad1)
Method
GET
HTTP Status
404
IP
20.171.207.190
Profiled on
Token
88335d

Query Metrics

25 Database Queries
15 Different statements
38.91 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.84 ms 
SELECT t0.header_logo AS header_logo_1, t0.header_phone1_show AS header_phone1_show_2, t0.header_phone1_number AS header_phone1_number_3, t0.header_phone2_show AS header_phone2_show_4, t0.header_phone2_number AS header_phone2_number_5, t0.header_filter_btn_show AS header_filter_btn_show_6, t0.header_filter_btn_text AS header_filter_btn_text_7, t0.header_filter_city_text AS header_filter_city_text_8, t0.header_filter_type_text AS header_filter_type_text_9, t0.header_pay_btn_show AS header_pay_btn_show_10, t0.header_pay_btn_text AS header_pay_btn_text_11, t0.header_pay_btn_url AS header_pay_btn_url_12, t0.header_map_btn_show AS header_map_btn_show_13, t0.header_map_btn_text AS header_map_btn_text_14, t0.header_contact_btn_show AS header_contact_btn_show_15, t0.header_contact_btn_text AS header_contact_btn_text_16, t0.menu_logo AS menu_logo_17, t0.menu_links AS menu_links_18, t0.footer_logo AS footer_logo_19, t0.footer_ruc AS footer_ruc_20, t0.footer_company_name AS footer_company_name_21, t0.footer_links AS footer_links_22, t0.footer_contact_show AS footer_contact_show_23, t0.footer_contact_text AS footer_contact_text_24, t0.footer_contact_phone_show AS footer_contact_phone_show_25, t0.footer_contact_phone_number AS footer_contact_phone_number_26, t0.footer_contact_address_show AS footer_contact_address_show_27, t0.footer_contact_address_text AS footer_contact_address_text_28, t0.footer_claim_show AS footer_claim_show_29, t0.footer_claim_text AS footer_claim_text_30, t0.footer_claim_url AS footer_claim_url_31, t0.footer_claim_icon AS footer_claim_icon_32, t0.footer_legal_show AS footer_legal_show_33, t0.footer_legal_text AS footer_legal_text_34, t0.footer_legal_links AS footer_legal_links_35, t0.footer_info_show AS footer_info_show_36, t0.footer_info_text AS footer_info_text_37, t0.footer_info_links AS footer_info_links_38, t0.region_info_show AS region_info_show_39, t0.region_button_show AS region_button_show_40, t0.region_button_text AS region_button_text_41, t0.counter_show AS counter_show_42, t0.counter_show_all_pages AS counter_show_all_pages_43, t0.counter_footer AS counter_footer_44, t0.counter_text AS counter_text_45, t0.counter_show_text_in_responsive AS counter_show_text_in_responsive_46, t0.counter_date AS counter_date_47, t0.counter_show_days AS counter_show_days_48, t0.counter_banner_image_responsive AS counter_banner_image_responsive_49, t0.counter_backgroundcolor AS counter_backgroundcolor_50, t0.counter_color_text AS counter_color_text_51, t0.counter_banner_texto AS counter_banner_texto_52, t0.counter_banner_color AS counter_banner_color_53, t0.counter_banner_opacity AS counter_banner_opacity_54, t0.counter_banner_image AS counter_banner_image_55, t0.counter_link AS counter_link_56, t0.counter_link_blank AS counter_link_blank_57, t0.social_show AS social_show_58, t0.social_text AS social_text_59, t0.social_youtube_show AS social_youtube_show_60, t0.social_youtube_url AS social_youtube_url_61, t0.social_facebook_show AS social_facebook_show_62, t0.social_facebook_url AS social_facebook_url_63, t0.social_instagram_show AS social_instagram_show_64, t0.social_instagram_url AS social_instagram_url_65, t0.seo_show AS seo_show_66, t0.seo_domain AS seo_domain_67, t0.seo_show_items AS seo_show_items_68, t0.seo_favicon AS seo_favicon_69, t0.seo_title AS seo_title_70, t0.seo_description AS seo_description_71, t0.blog_show AS blog_show_72, t0.blog_url AS blog_url_73, t0.blog_qty AS blog_qty_74, t0.account_show AS account_show_75, t0.account_url AS account_url_76, t0.outlet_show AS outlet_show_77, t0.outlet_url AS outlet_url_78, t0.whatsapp_show AS whatsapp_show_79, t0.whatsapp_button AS whatsapp_button_80, t0.whatsapp_image AS whatsapp_image_81, t0.whatsapp_number AS whatsapp_number_82, t0.whatsapp_message AS whatsapp_message_83, t0.whatsapp_consultants_show AS whatsapp_consultants_show_84, t0.whatsapp_title AS whatsapp_title_85, t0.whatsapp_text AS whatsapp_text_86, t0.whatsapp_help AS whatsapp_help_87, t0.whatsapp_consultants_items AS whatsapp_consultants_items_88, t0.copyright_text AS copyright_text_89, t0.terms_show AS terms_show_90, t0.terms_text AS terms_text_91, t0.custom_scripts AS custom_scripts_92, t0.map_api_key AS map_api_key_93, t0.custom_script_header AS custom_script_header_94, t0.custom_script_body AS custom_script_body_95, t0.custom_script_footer AS custom_script_footer_96, t0.map_api_key1 AS map_api_key1_97, t0.custom_script_header1 AS custom_script_header1_98, t0.custom_script_body1 AS custom_script_body1_99, t0.custom_script_footer1 AS custom_script_footer1_100, t0.call_let AS call_let_101, t0.call_days AS call_days_102, t0.call_start_time AS call_start_time_103, t0.call_end_time AS call_end_time_104, t0.dni_blacklist AS dni_blacklist_105, t0.email_blacklist AS email_blacklist_106, t0.phone_blacklist AS phone_blacklist_107, t0.link_supplier_code_show AS link_supplier_code_show_108, t0.link_supplier_code_text AS link_supplier_code_text_109, t0.link_supplier_code_target AS link_supplier_code_target_110, t0.id AS id_111, t0.created AS created_112, t0.modified AS modified_113, t0.created_user AS created_user_114, t0.modified_user AS modified_user_115 FROM info t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
2 0.66 ms 
SELECT t0.title AS title_1, t0.text AS text_2, t0.image AS image_3, t0.colour_btn_text AS colour_btn_text_4, t0.colour_btn_url AS colour_btn_url_5, t0.id AS id_6, t0.created AS created_7, t0.modified AS modified_8, t0.created_user AS created_user_9, t0.modified_user AS modified_user_10 FROM info_error t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3 1.65 ms 
SELECT DISTINCT p0_.slug AS slug_0, p0_.title AS title_1, p0_.sequence AS sequence_2, p0_.image AS image_3, p0_.logo AS logo_4, p0_.color AS color_5, p0_.open_in_list AS open_in_list_6 FROM property_type p0_ INNER JOIN property p1_ ON p0_.id = p1_.property_type_id INNER JOIN location l2_ ON p1_.location_id = l2_.id WHERE p0_.active = ? AND p1_.active = ? AND l2_.active = ? AND p1_.is_only_landing = ? ORDER BY p0_.sequence ASC
Parameters: 
[
  1
  1
  1
  0
]
View formatted query    View runnable query    Explain query
4 1.53 ms 
SELECT DISTINCT l0_.slug AS slug_0, l0_.title AS title_1, l0_.sequence AS sequence_2 FROM location l0_ INNER JOIN property p1_ ON l0_.id = p1_.location_id INNER JOIN property_type p2_ ON p1_.property_type_id = p2_.id WHERE l0_.active = ? AND p1_.active = ? AND p2_.active = ? AND p1_.is_only_landing = ? ORDER BY l0_.sequence ASC
Parameters: 
[
  1
  1
  1
  0
]
View formatted query    View runnable query    Explain query
5 1.63 ms 
SELECT DISTINCT p0_.title AS title_0, p1_.title AS title_1, IFNULL(p1_.titlecontacto, l2_.title) AS sclr_2, l2_.title AS title_3, p1_.slug AS slug_4, IFNULL(p1_.program, '##') AS sclr_5 FROM property p1_ INNER JOIN property_type p0_ ON p1_.property_type_id = p0_.id INNER JOIN location l2_ ON p1_.location_id = l2_.id WHERE p0_.active = ? AND p1_.active = ? AND l2_.active = ? AND p1_.is_only_landing = ? ORDER BY p1_.sequence ASC
Parameters: 
[
  1
  1
  1
  0
]
View formatted query    View runnable query    Explain query
6 2.05 ms 
SELECT l0_.slug AS slug_0, COUNT(p1_.id) AS sclr_1, p1_.slug AS slug_2 FROM property p1_ INNER JOIN property_type p2_ ON p1_.property_type_id = p2_.id INNER JOIN location l0_ ON p1_.location_id = l0_.id INNER JOIN stage s3_ ON p1_.stage_id = s3_.id WHERE p1_.active = ? AND p2_.active = ? AND l0_.active = ? AND s3_.active = ? AND p1_.is_only_landing = ? GROUP BY l0_.slug ORDER BY p1_.sequence ASC, p1_.title ASC
Parameters: 
[
  1
  1
  1
  1
  0
]
View formatted query    View runnable query    Explain query
7 2.33 ms 
SELECT p0_.title AS title_0, p0_.titlecontacto AS titlecontacto_1, p0_.sap_zone AS sap_zone_2, p0_.sap_zone_inmobiliario AS sap_zone_inmobiliario_3, p0_.sap_code AS sap_code_4, p0_.sap_project AS sap_project_5, p0_.slug AS slug_6, p0_.template AS template_7, p0_.program AS program_8, p0_.image_list_only_image AS image_list_only_image_9, p0_.image_list_desktop AS image_list_desktop_10, p0_.image_list_mobile AS image_list_mobile_11, p0_.image_map AS image_map_12, p0_.logo_desktop AS logo_desktop_13, p0_.logo_mobile AS logo_mobile_14, p0_.image_list_url AS image_list_url_15, p0_.image_features_detail_show AS image_features_detail_show_16, p0_.image_features_detail_img_desktop AS image_features_detail_img_desktop_17, p0_.image_features_detail_img_mobile AS image_features_detail_img_mobile_18, p0_.fee_show AS fee_show_19, p0_.fee_image AS fee_image_20, p0_.fee_preffix AS fee_preffix_21, p0_.fee_price AS fee_price_22, p0_.fee_suffix AS fee_suffix_23, p0_.cash_show AS cash_show_24, p0_.cash_image AS cash_image_25, p0_.cash_preffix AS cash_preffix_26, p0_.cash_price AS cash_price_27, p0_.cash_suffix AS cash_suffix_28, p0_.list_btn_text AS list_btn_text_29, p0_.address_show AS address_show_30, p0_.address_preffix AS address_preffix_31, p0_.address_value AS address_value_32, p0_.month_show AS month_show_33, p0_.month_preffix AS month_preffix_34, p0_.month_value AS month_value_35, p0_.sequence AS sequence_36, p0_.active AS active_37, p0_.is_only_landing AS is_only_landing_38, p0_.popup_video_show AS popup_video_show_39, p0_.popup_video_hide_close_button AS popup_video_hide_close_button_40, p0_.popup_video_link AS popup_video_link_41, p0_.popup_video_duration AS popup_video_duration_42, p0_.popup_video_skip_duration AS popup_video_skip_duration_43, p0_.banners AS banners_44, p0_.banner_opacity_show AS banner_opacity_show_45, p0_.banner_embed_video_show AS banner_embed_video_show_46, p0_.banner_embed_video_type AS banner_embed_video_type_47, p0_.banner_embed_video_url AS banner_embed_video_url_48, p0_.banner_embed_video_cover AS banner_embed_video_cover_49, p0_.banner_embed_image_desktop AS banner_embed_image_desktop_50, p0_.banner_embed_image_mobile AS banner_embed_image_mobile_51, p0_.banner_embed_preffix AS banner_embed_preffix_52, p0_.banner_embed_title AS banner_embed_title_53, p0_.banner_embed_suffix AS banner_embed_suffix_54, p0_.banner_embed_logo1_show AS banner_embed_logo1_show_55, p0_.banner_embed_logo1_img AS banner_embed_logo1_img_56, p0_.banner_embed_logo2_show AS banner_embed_logo2_show_57, p0_.banner_embed_logo2_img AS banner_embed_logo2_img_58, p0_.banner_embed_btn_show AS banner_embed_btn_show_59, p0_.banner_embed_btn_text AS banner_embed_btn_text_60, p0_.banner_video_show AS banner_video_show_61, p0_.banner_video_url AS banner_video_url_62, p0_.banner_video_title AS banner_video_title_63, p0_.banner_video_preffix AS banner_video_preffix_64, p0_.banner_video_suffix AS banner_video_suffix_65, p0_.banner_video_text AS banner_video_text_66, p0_.banner_video_img AS banner_video_img_67, p0_.terms_show AS terms_show_68, p0_.terms_title AS terms_title_69, p0_.terms_text AS terms_text_70, p0_.form_show AS form_show_71, p0_.form_title AS form_title_72, p0_.form_email AS form_email_73, p0_.thank_image_show AS thank_image_show_74, p0_.thank_image AS thank_image_75, p0_.fucsia_bar_show AS fucsia_bar_show_76, p0_.common_section_show AS common_section_show_77, p0_.common_show AS common_show_78, p0_.common_title AS common_title_79, p0_.common_text AS common_text_80, p0_.gallery_show AS gallery_show_81, p0_.gallery_title AS gallery_title_82, p0_.gallery_items AS gallery_items_83, p0_.benefit_show AS benefit_show_84, p0_.benefit_show_in_map AS benefit_show_in_map_85, p0_.benefit_image AS benefit_image_86, p0_.benefit_item_image_show AS benefit_item_image_show_87, p0_.benefit_item_image AS benefit_item_image_88, p0_.benefit_title AS benefit_title_89, p0_.benefit_items AS benefit_items_90, p0_.block_video_show AS block_video_show_91, p0_.block_video_background AS block_video_background_92, p0_.block_video_image AS block_video_image_93, p0_.block_video_logo AS block_video_logo_94, p0_.block_video_title AS block_video_title_95, p0_.block_video_url AS block_video_url_96, p0_.map_show AS map_show_97, p0_.map_show_start AS map_show_start_98, p0_.map_title AS map_title_99, p0_.map_items AS map_items_100, p0_.testimonials_show AS testimonials_show_101, p0_.testimonials_title AS testimonials_title_102, p0_.testimonials_items AS testimonials_items_103, p0_.discount_show AS discount_show_104, p0_.discount_show_start AS discount_show_start_105, p0_.discount_title AS discount_title_106, p0_.discount_image_desktop AS discount_image_desktop_107, p0_.discount_image_mobile AS discount_image_mobile_108, p0_.discount_items AS discount_items_109, p0_.quote_show AS quote_show_110, p0_.quote_show_in_popup AS quote_show_in_popup_111, p0_.quote_image AS quote_image_112, p0_.quote_popup_image AS quote_popup_image_113, p0_.quote_title AS quote_title_114, p0_.quote_text AS quote_text_115, p0_.related_show AS related_show_116, p0_.related_title AS related_title_117, p0_.related_btn_text AS related_btn_text_118, p0_.popup_show AS popup_show_119, p0_.popup_image_desktop AS popup_image_desktop_120, p0_.popup_image_mobile AS popup_image_mobile_121, p0_.popup_url AS popup_url_122, p0_.popup_blank AS popup_blank_123, p0_.alert_show AS alert_show_124, p0_.alert_image_desktop AS alert_image_desktop_125, p0_.alert_image_mobile AS alert_image_mobile_126, p0_.alert_url AS alert_url_127, p0_.alert_blank AS alert_blank_128, p0_.share_whatsapp_show AS share_whatsapp_show_129, p0_.share_facebook_show AS share_facebook_show_130, p0_.share_email_show AS share_email_show_131, p0_.mailing_show AS mailing_show_132, p0_.mailing_logo AS mailing_logo_133, p0_.mailing_banner AS mailing_banner_134, p0_.mailing_greeting_title AS mailing_greeting_title_135, p0_.mailing_greeting_text AS mailing_greeting_text_136, p0_.mailing_contact_title AS mailing_contact_title_137, p0_.mailing_contact_btn_text AS mailing_contact_btn_text_138, p0_.mailing_contact_btn_image AS mailing_contact_btn_image_139, p0_.mailing_contact_btn_url AS mailing_contact_btn_url_140, p0_.mailing_disclaimer AS mailing_disclaimer_141, p0_.child_number AS child_number_142, p0_.let_send_crm AS let_send_crm_143, p0_.crm_send_to_salesforce AS crm_send_to_salesforce_144, p0_.crm_origin_lead AS crm_origin_lead_145, p0_.seo_script_show AS seo_script_show_146, p0_.seo_script_generate AS seo_script_generate_147, p0_.seo_script_text AS seo_script_text_148, p0_.whatsapp_show AS whatsapp_show_149, p0_.whatsapp_replace AS whatsapp_replace_150, p0_.whatsapp_button AS whatsapp_button_151, p0_.whatsapp_image AS whatsapp_image_152, p0_.whatsapp_number AS whatsapp_number_153, p0_.whatsapp_message AS whatsapp_message_154, p0_.whatsapp_consultants_show AS whatsapp_consultants_show_155, p0_.whatsapp_title AS whatsapp_title_156, p0_.whatsapp_text AS whatsapp_text_157, p0_.whatsapp_help AS whatsapp_help_158, p0_.whatsapp_consultants_items AS whatsapp_consultants_items_159, p0_.id AS id_160, p0_.created AS created_161, p0_.modified AS modified_162, p0_.created_user AS created_user_163, p0_.modified_user AS modified_user_164, p1_.title AS title_165, p1_.slug AS slug_166, p1_.image AS image_167, p1_.logo AS logo_168, p1_.color AS color_169, p1_.sequence AS sequence_170, p1_.active AS active_171, p1_.open_in_list AS open_in_list_172, p1_.id AS id_173, p1_.created AS created_174, p1_.modified AS modified_175, p1_.created_user AS created_user_176, p1_.modified_user AS modified_user_177, l2_.title AS title_178, l2_.slug AS slug_179, l2_.image AS image_180, l2_.latitude AS latitude_181, l2_.longitude AS longitude_182, l2_.sequence AS sequence_183, l2_.active AS active_184, l2_.showtypes AS showtypes_185, l2_.id AS id_186, l2_.created AS created_187, l2_.modified AS modified_188, l2_.created_user AS created_user_189, l2_.modified_user AS modified_user_190, s3_.title AS title_191, s3_.slug AS slug_192, s3_.colour AS colour_193, s3_.sequence AS sequence_194, s3_.active AS active_195, s3_.id AS id_196, s3_.created AS created_197, s3_.modified AS modified_198, s3_.created_user AS created_user_199, s3_.modified_user AS modified_user_200, p0_.api_sap_zone_id AS api_sap_zone_id_201, p0_.stage_id AS stage_id_202, p0_.property_type_id AS property_type_id_203, p0_.location_id AS location_id_204, p0_.mother_id AS mother_id_205 FROM property p0_ INNER JOIN property_type p1_ ON p0_.property_type_id = p1_.id INNER JOIN location l2_ ON p0_.location_id = l2_.id INNER JOIN stage s3_ ON p0_.stage_id = s3_.id WHERE p0_.active = ? AND p1_.active = ? AND l2_.active = ? AND s3_.active = ? AND p0_.slug = ? ORDER BY p0_.sequence ASC, p0_.title ASC
Parameters: 
[
  1
  1
  1
  1
  "config.json"
]
View formatted query    View runnable query    Explain query
8 1.02 ms 
SELECT t0.source AS source_1, t0.destination AS destination_2, t0.permanent AS permanent_3, t0.count AS count_4, t0.last_accessed AS last_accessed_5, t0.id AS id_6 FROM zero_redirect t0 WHERE t0.source = ? LIMIT 1
Parameters: 
[
  "/config.json/"
]
View formatted query    View runnable query    Explain query
9 1.84 ms 
SELECT DISTINCT p0_.slug AS slug_0, p0_.title AS title_1, p0_.sequence AS sequence_2, p0_.image AS image_3, p0_.logo AS logo_4, p0_.color AS color_5, p0_.open_in_list AS open_in_list_6 FROM property_type p0_ INNER JOIN property p1_ ON p0_.id = p1_.property_type_id INNER JOIN location l2_ ON p1_.location_id = l2_.id WHERE p0_.active = ? AND p1_.active = ? AND l2_.active = ? AND p1_.is_only_landing = ? ORDER BY p0_.sequence ASC
Parameters: 
[
  1
  1
  1
  0
]
View formatted query    View runnable query    Explain query
10 1.54 ms 
SELECT DISTINCT l0_.slug AS slug_0, l0_.title AS title_1, l0_.sequence AS sequence_2 FROM location l0_ INNER JOIN property p1_ ON l0_.id = p1_.location_id INNER JOIN property_type p2_ ON p1_.property_type_id = p2_.id WHERE l0_.active = ? AND p1_.active = ? AND p2_.active = ? AND p1_.is_only_landing = ? ORDER BY l0_.sequence ASC
Parameters: 
[
  1
  1
  1
  0
]
View formatted query    View runnable query    Explain query
11 1.51 ms 
SELECT DISTINCT p0_.title AS title_0, p1_.title AS title_1, IFNULL(p1_.titlecontacto, l2_.title) AS sclr_2, l2_.title AS title_3, p1_.slug AS slug_4, IFNULL(p1_.program, '##') AS sclr_5 FROM property p1_ INNER JOIN property_type p0_ ON p1_.property_type_id = p0_.id INNER JOIN location l2_ ON p1_.location_id = l2_.id WHERE p0_.active = ? AND p1_.active = ? AND l2_.active = ? AND p1_.is_only_landing = ? ORDER BY p1_.sequence ASC
Parameters: 
[
  1
  1
  1
  0
]
View formatted query    View runnable query    Explain query
12 1.51 ms 
SELECT l0_.slug AS slug_0, COUNT(p1_.id) AS sclr_1, p1_.slug AS slug_2 FROM property p1_ INNER JOIN property_type p2_ ON p1_.property_type_id = p2_.id INNER JOIN location l0_ ON p1_.location_id = l0_.id INNER JOIN stage s3_ ON p1_.stage_id = s3_.id WHERE p1_.active = ? AND p2_.active = ? AND l0_.active = ? AND s3_.active = ? AND p1_.is_only_landing = ? GROUP BY l0_.slug ORDER BY p1_.sequence ASC, p1_.title ASC
Parameters: 
[
  1
  1
  1
  1
  0
]
View formatted query    View runnable query    Explain query
13 0.62 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
14 2.87 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "staff_portales_vivienda_2"
]
View formatted query    View runnable query    Explain query
15 0.56 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
16 2.68 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "staff_portales_vivienda_2"
]
View formatted query    View runnable query    Explain query
17 0.41 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
18 2.26 ms 
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters: 
[
  "staff_portales_vivienda_2"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
19 0.44 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
20 2.68 ms 
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'staff_portales_vivienda_2' */ ORDER BY k.ORDINAL_POSITION
Parameters: 
[
  "staff_portales_vivienda_2"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
21 3.95 ms 
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE        AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters: 
[
  "staff_portales_vivienda_2"
  "staff_portales_vivienda_2"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
22 0.45 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
23 1.79 ms 
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters: 
[
  "staff_portales_vivienda_2"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
24 0.56 ms 
SELECT * FROM doctrine_migration_versions
Parameters: 
[]
View formatted query    View runnable query    Explain query
25 0.54 ms 
SELECT DATABASE()
Parameters: 
[]
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.

Entities Mapping

Class Mapping errors
App\Entity\LogIpApi No errors.
App\Entity\Region No errors.
App\Entity\Info No errors.
App\Entity\IpApi No errors.
App\Entity\ZeroTranslate No errors.
App\Entity\ZeroSeo No errors.
App\Entity\InfoError No errors.
App\Entity\Property
  • The mappings App\Entity\Property#chiclayolist and App\Entity\ChiclayoLotList#house are inconsistent with each other.
App\Entity\PropertyType No errors.
App\Entity\Location No errors.
App\Entity\Stage No errors.
App\Entity\InfoForm No errors.
App\Entity\InfoProperty No errors.
App\Entity\SapZone No errors.
Zenstruck\RedirectBundle\Model\Redirect No errors.
App\Entity\ZeroRedirect No errors.
App\Entity\State No errors.
App\Entity\City No errors.
App\Entity\PropertyMap No errors.
App\Entity\CommonArea No errors.
App\Entity\Flat No errors.
App\Entity\Related No errors.
App\Entity\PiuraHouseMap No errors.
App\Entity\PiuraHouseList No errors.
App\Entity\IcaLotMap No errors.
App\Entity\PiuraTechoMap No errors.
App\Entity\ChiclayoLotMap No errors.
App\Entity\ChiclayoLotList
  • The association App\Entity\ChiclayoLotList#house refers to the inverse side field App\Entity\Property#chiclayo_lists which does not exist.
App\Entity\LandingSchedule No errors.