Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Wstempresa`.`id`, `Wstempresa`.`nombre`, `Wstempresa`.`rason_social`, `Wstempresa`.`tipo_emp`, `Wstempresa`.`direccion`, `Wstempresa`.`codigo_postal`, `Wstempresa`.`wst_localidades_id`, `Wstempresa`.`str_localidad`, `Wstempresa`.`str_provincia`, `Wstempresa`.`str_pais`, `Wstempresa`.`telefono1`, `Wstempresa`.`telefono2`, `Wstempresa`.`celular1`, `Wstempresa`.`celular2`, `Wstempresa`.`mail_institucional`, `Wstempresa`.`mail_contactenos`, `Wstempresa`.`mail_pedidos`, `Wstempresa`.`mail_opcional`, `Wstempresa`.`horarios`, `Wstempresa`.`openingHours`, `Wstempresa`.`web`, `Wstempresa`.`fb_admins`, `Wstempresa`.`title_1`, `Wstempresa`.`subtitle_1`, `Wstempresa`.`description_1`, `Wstempresa`.`meta_key_1`, `Wstempresa`.`title_2`, `Wstempresa`.`subtitle_2`, `Wstempresa`.`description_2`, `Wstempresa`.`meta_key_2`, `Wstempresa`.`title_3`, `Wstempresa`.`subtitle_3`, `Wstempresa`.`description_3`, `Wstempresa`.`meta_key_3`, `Wstempresa`.`usuario`, `Wstempresa`.`clave`, `Wstempresa`.`idiva`, `Wstempresa`.`cuitonif`, `Wstempresa`.`cod_dineromail`, `Wstempresa`.`soporte`, `Wstempresa`.`estado` FROM `iterra`.`wst_empresas` AS `Wstempresa` WHERE `id` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Wstable`.`id`, `Wstable`.`label`, `Wstable`.`name`, `Wstable`.`key`, `Wstable`.`files`, `Wstable`.`files_key`, `Wstable`.`files_directory`, `Wstable`.`filter`, `Wstable`.`area`, `Wstable`.`area_campo_id`, `Wstable`.`area_campo_usuario`, `Wstable`.`area_campo_clave`, `Wstable`.`area_campo_mail`, `Wstable`.`area_filtro`, `Wstable`.`area_tipo_encode`, `Wstable`.`area_encode`, `Wstable`.`pagina_de_inicio`, `Wstable`.`trigger_insert`, `Wstable`.`trigger_update`, `Wstable`.`trigger_modify`, `Wstable`.`ayuda` FROM `iterra`.`wsavem1_tables` AS `Wstable` WHERE `id` = 5 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Wsfield`.`id`, `Wsfield`.`table_id`, `Wsfield`.`mod_id`, `Wsfield`.`name`, `Wsfield`.`label`, `Wsfield`.`edit`, `Wsfield`.`value`, `Wsfield`.`count_character`, `Wsfield`.`tag_size`, `Wsfield`.`order`, `Wsfield`.`fields_requiere`, `Wsfield`.`field_of_search`, `Wsfield`.`alt`, `Wsfield`.`class`, `Wsfield`.`list_1`, `Wsfield`.`list_2`, `Wsfield`.`list_3`, `Wsfield`.`list_4`, `Wsfield`.`relationship_table`, `Wsfield`.`relationship_value`, `Wsfield`.`relationship_label`, `Wsfield`.`relationship_type`, `Wsfield`.`relationship_sql`, `Wsfield`.`relationship_filter`, `Wsfield`.`relationship_order`, `Wsfield`.`list_pdf_1`, `Wsfield`.`list_pdf_2`, `Wsfield`.`list_pdf_3`, `Wsfield`.`list_pdf_4`, `Wsfield`.`list_pdf_size_1`, `Wsfield`.`list_pdf_size_2`, `Wsfield`.`list_pdf_size_3`, `Wsfield`.`list_pdf_size_4`, `Wsfield`.`trigger_insert`, `Wsfield`.`trigger_update`, `Wsfield`.`trigger_delete`, `Wsfield`.`accion`, `Wsfield`.`help` FROM `iterra`.`wsavem1_fields` AS `Wsfield` WHERE `Wsfield`.`table_id` = (5) ORDER BY `order` ASC | 8 | 8 | 3 | maybe slow |
SELECT `Wsfile`.`id`, `Wsfile`.`table_id`, `Wsfile`.`label`, `Wsfile`.`size`, `Wsfile`.`type`, `Wsfile`.`type_to_sizes`, `Wsfile`.`cant_file`, `Wsfile`.`field_id`, `Wsfile`.`script`, `Wsfile`.`order` FROM `iterra`.`wsavem1_files` AS `Wsfile` WHERE `Wsfile`.`table_id` = (5) ORDER BY `order` ASC | 3 | 3 | 1 | maybe slow |
SELECT `Wsfiles_size`.`id`, `Wsfiles_size`.`file_id`, `Wsfiles_size`.`width`, `Wsfiles_size`.`height`, `Wsfiles_size`.`order`, (CONCAT(`Wsfiles_size`.`width`, "x", `Wsfiles_size`.`height`)) AS `Wsfiles_size__tamanio` FROM `iterra`.`wsavem1_files_sizes` AS `Wsfiles_size` WHERE `Wsfiles_size`.`file_id` IN (2, 3, 7) ORDER BY `Wsfiles_size`.`order` ASC | 4 | 4 | 1 | maybe slow |
SELECT `Wslink_child`.`id`, `Wslink_child`.`parent_table_id`, `Wslink_child`.`parent_id`, `Wslink_child`.`label`, `Wslink_child`.`type`, `Wslink_child`.`table_id`, `Wslink_child`.`accion`, `Wslink_child`.`table_key`, `Wslink_child`.`table_label_show`, `Wslink_child`.`table_orden_show`, `Wslink_child`.`table_orden_type`, `Wslink_child`.`tabla_numer_list`, `Wslink_child`.`filter_user`, `Wslink_child`.`filter`, `Wslink_child`.`href`, `Wslink_child`.`target`, `Wslink_child`.`order` FROM `iterra`.`wsavem1_links` AS `Wslink_child` WHERE `Wslink_child`.`type` = 'H' AND `Wslink_child`.`parent_table_id` = (5) | 0 | 0 | 1 | maybe slow |
SELECT `Fideicomiso`.`id`, `Fideicomiso`.`nombre`, `Fideicomiso`.`wst_empresa_id`, `Fideicomiso`.`calle`, `Fideicomiso`.`numero`, `Fideicomiso`.`localidad`, `Fideicomiso`.`desc_chica`, `Fideicomiso`.`desc_grande`, `Fideicomiso`.`fecha_ini`, `Fideicomiso`.`fecha_fin` FROM `iterra`.`inmo_fideicomisos` AS `Fideicomiso` WHERE 1 = 1 ORDER BY `fecha_fin` DESC | 0 | 0 | 2 | maybe slow |