Barcelona Turisme
TikTok Pinterest Youtube Instagram facebook Twitter
Restricted area
Remember password

Enter your contact e-mail where we can send you your username and password

Transparència
Transparència

Turisme de Barcelona has its own Internal Transparency Regulations. See Pdf attachment
The contents of the regulations are based on Law 19/2014 of 29th December regarding transparency, public access to information and good governance and reflect Turisme de Barcelona’s commitment to being a transparent and accessible organisation that is open to the community.


The Transparency Portal is structured in several sections that facilitate browsing and accessing the public information of the Consortium of Turisme de Barcelona:

Contacta amb Turisme de Barcelona
Tel:
Fax:
Mail:
[+34] 933 689 700
[+34] 933 689 701
info@barcelonaturisme.com
DEBUG LEVEL
    TIME TYPE MESSAGE

  Fri Apr 19 08:23:19 2024 [DEBUG] Start Handler
Fri Apr 19 08:23:19 2024 [DEBUG] Start Section RECURSO (11770)  
Fri Apr 19 08:23:19 2024 [DEBUG] Start Global Section EBDML (11769)  

Fri Apr 19 08:23:19 2024 [DEBUG] End Section Global EBDML (11769)  

Fri Apr 19 08:23:19 2024 [DEBUG] End Section RECURSO (11770)  
Fri Apr 19 08:23:19 2024 [DEBUG] Start Section RECURSO (9044)  
Fri Apr 19 08:23:19 2024 [DEBUG] Start Global Section EBDML (9042)  

Fri Apr 19 08:23:19 2024 [DEBUG] End Section Global EBDML (9042)  

Fri Apr 19 08:23:19 2024 [DEBUG] End Section RECURSO (9044)  
Fri Apr 19 08:23:19 2024 [DEBUG] Start Section RECURSO (8673)  
Fri Apr 19 08:23:19 2024 [DEBUG] Start Global Section EBDML (8672)  

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 4
Size In/Out: 203 B / 1.07 KB
Time: 1 ms
SELECT ps.* FROM PRO_Secciones ps WHERE ps.idPadre=0 AND ps.visible='S' AND ps.idTipoVentana=4 ORDER BY ps.idPadre, ps.orden ASC

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 10
Size In/Out: 222 B / 2.46 KB
Time: 3 ms
SELECT ps.*,ps.nombreENG AS titulo FROM PRO_Secciones ps WHERE ps.idPadre=1 AND ps.visible='S' ORDER BY ps.idPadre, ps.orden ASC

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 6
Size In/Out: 222 B / 1.5 KB
Time: 1 ms
SELECT ps.*,ps.nombreENG AS titulo FROM PRO_Secciones ps WHERE ps.idPadre=2 AND ps.visible='S' ORDER BY ps.idPadre, ps.orden ASC

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 3
Size In/Out: 222 B / 900 B
Time: 1 ms
SELECT ps.*,ps.nombreENG AS titulo FROM PRO_Secciones ps WHERE ps.idPadre=3 AND ps.visible='S' ORDER BY ps.idPadre, ps.orden ASC

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 5
Size In/Out: 335 B / 192 B
Time: 1 ms
SELECT p.idPRO_Pagina as idPagina,p.Titulo_ENG AS titulo,p.idPagina_ebd, p.Titulo_ALT_ENG as tituloAlt,p.PRO_Secciones_idSeccion as idSeccion FROM PRO_Pagina p WHERE p.PRO_Secciones_idSeccion='42' AND p.noVisibleEnMenu='N' ORDER BY p.orden ASC

  Fri Apr 19 08:23:19 2024 [WARNING] SELECT p.idPRO_Pagina as idPagina,p.Titulo_ENG AS titulo,p.idPagina_ebd, p.Titulo_ALT_ENG as tituloAlt,p.PRO_Secciones_idSeccion as idSeccion FROM PRO_Pagina p WHERE p.PRO_Secciones_idSeccion='42' AND p.noVisibleEnMenu='N' ORDER BY p.orden ASC

  Fri Apr 19 08:23:19 2024 [WARNING] Transparència

  Fri Apr 19 08:23:19 2024 [WARNING] Institutional information

  Fri Apr 19 08:23:19 2024 [WARNING] Organisational structure

  Fri Apr 19 08:23:19 2024 [WARNING] Economic information

  Fri Apr 19 08:23:19 2024 [WARNING] Contractor Profile
Fri Apr 19 08:23:19 2024 [DEBUG] Start Section EBDML (10572)  

Fri Apr 19 08:23:19 2024 [DEBUG] End Section EBDML (10572)  

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 1
Size In/Out: 139 B / 50 B
Time: 0 ms
SELECT s.nombreENG AS tituloSeccion,s.idPagina FROM PRO_Secciones s WHERE s.idSeccion=23

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 4
Size In/Out: 214 B / 1.09 KB
Time: 1 ms
SELECT ps.*,nombreENG AS titulo FROM PRO_Secciones ps WHERE ps.idPadre=0 AND ps.visible='S' ORDER BY ps.idPadre, ps.orden ASC

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 1
Size In/Out: 120 B / 174 B
Time: 0 ms
SELECT * FROM previsio WHERE prev_idioma=3 ORDER BY prev_dia ASC LIMIT 1

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 1
Size In/Out: 108 B / 130 B
Time: 1 ms
SELECT * FROM previsio_iconos WHERE pic_nombre = 'sol.gif'

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 1
Size In/Out: 243 B / 70 B
Time: 0 ms
SELECT p.idPagina,p.idPadre, p.nombreENG as nom, se.paginaeBD as paginaEsqSubhome FROM TBCN2_PAGINA p LEFT JOIN TBCN2_SUBESQUEMAPG se ON se.idSubesquema=p.idSubesquema WHERE p.idPagina=44

Fri Apr 19 08:23:19 2024 [DEBUG] End Section Global EBDML (8672)  

Fri Apr 19 08:23:19 2024 [DEBUG] End Section RECURSO (8673)  
Fri Apr 19 08:23:19 2024 [DEBUG] Start Page (11845)
Fri Apr 19 08:23:19 2024 [DEBUG] Start Section RECURSO (11848)  
Fri Apr 19 08:23:19 2024 [DEBUG] Start Global Section EBDML (8780)  

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 1
Size In/Out: 197 B / 40 B
Time: 0 ms
SELECT p.PRO_Secciones_idSeccion FROM PRO_Pagina p WHERE p.idPagina_ebd='11845' and p.noVisible<>'S' AND p.noVisibleEnMenu ='N' ORDER BY p.orden ASC

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 1
Size In/Out: 108 B / 40 B
Time: 1 ms
SELECT s.idPadre FROM PRO_Secciones s WHERE s.idSeccion='42'

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 1
Size In/Out: 216 B / 492 B
Time: 1 ms
SELECT s.nombreENG AS tituloSeccion,s.* FROM PRO_Secciones s WHERE s.idSeccion='42'

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 5
Size In/Out: 366 B / 170 B
Time: 1 ms
SELECT p.idPRO_Pagina, p.Titulo_ENG AS tituloPagina, idPagina_ebd, enlaceENG AS urlexterna FROM PRO_Pagina p WHERE p.noVisible<>'S' AND p.PRO_Secciones_idSeccion='42' AND p.noVisibleEnMenu ='N' ORDER BY p.orden ASC

explain this query
Fri Apr 19 08:23:19 2024 [DEBUG]
Rows: 5
Size In/Out: 245 B / 80 B
Time: 0 ms
SELECT COUNT(*) AS nRegistros FROM PRO_Pagina p WHERE p.noVisible<>'S' AND p.PRO_Secciones_idSeccion='42' GROUP BY _idRegistro

Fri Apr 19 08:23:19 2024 [DEBUG] End Section Global EBDML (8780)  

Fri Apr 19 08:23:19 2024 [DEBUG] End Section RECURSO (11848)  
Fri Apr 19 08:23:19 2024 [DEBUG] Start Section EBDML (11846)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Section RECURSO (11849)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Global Section EBDML (10011)  

  Fri Apr 19 08:23:20 2024 [WARNING] PAGINA: 71

explain this query
Fri Apr 19 08:23:20 2024 [DEBUG]
Rows: 1
Size In/Out: 233 B / 72 B
Time: 0 ms
SELECT p.idPRO_Pagina, p.Titulo_ENG AS tituloPagina, idPagina_ebd, bannerENG AS imagen, p.HTML1_ENG AS intro FROM PRO_Pagina p WHERE p.idPRO_Pagina='71' ORDER BY p.orden ASC

Fri Apr 19 08:23:20 2024 [DEBUG] End Section Global EBDML (10011)  

Fri Apr 19 08:23:20 2024 [DEBUG] End Section RECURSO (11849)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Section RECURSO (11850)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Global Section EBDML (9526)  

explain this query
Fri Apr 19 08:23:20 2024 [DEBUG]
Rows: 1
Size In/Out: 275 B / 80 B
Time: 0 ms
SELECT idBloqueDePagina, tituloENG AS tituloBloque, contenidoENG AS contenido, idTipoBloque, imagen FROM PRO_BloquesDePagina WHERE idPagina='71' AND (idPadre='0' OR idPadre IS NULL) AND visible='S' ORDER BY orden ASC
Fri Apr 19 08:23:20 2024 [DEBUG] Start Section EBDML (9522)  

explain this query
Fri Apr 19 08:23:20 2024 [DEBUG]
Rows: 0
Size In/Out: 284 B / 55 B
Time: 0 ms
SELECT idBloqueDePagina, tituloENG AS tituloBloque, contenidoENG AS contenido, idTipoBloque, idIndicadorSostenibilitat, imagen FROM PRO_BloquesDePagina WHERE idPagina='71' AND idPadre='245' AND visible='S' ORDER BY orden ASC

Fri Apr 19 08:23:20 2024 [DEBUG] End Section EBDML (9522)  

Fri Apr 19 08:23:20 2024 [DEBUG] End Section Global EBDML (9526)  

Fri Apr 19 08:23:20 2024 [DEBUG] End Section RECURSO (11850)  

Fri Apr 19 08:23:20 2024 [DEBUG] End Section EBDML (11846)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Section RECURSO (11847)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Global Section EBDML (8792)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Section EBDML (9054)  

explain this query
Fri Apr 19 08:23:20 2024 [DEBUG]
Rows: 1
Size In/Out: 183 B / 80 B
Time: 0 ms
SELECT contactaTXTENG AS txtcontacta,contactaTelefono,contactaFax,contactaEmail,contactaTwitter FROM PRO_Secciones WHERE idSeccion='42'

Fri Apr 19 08:23:20 2024 [DEBUG] End Section EBDML (9054)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Section EBDML (10165)  

explain this query
Fri Apr 19 08:23:20 2024 [DEBUG]
Rows: 0
Size In/Out: 145 B / 30 B
Time: 0 ms
SELECT _idRegistro FROM PRO_Secciones WHERE idSeccion='42' AND mostrarBloqueNoticies='S' LIMIT 1

Fri Apr 19 08:23:20 2024 [DEBUG] End Section EBDML (10165)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Section EBDML (10643)  

  Fri Apr 19 08:23:20 2024 [WARNING] seccio: 42

explain this query
Fri Apr 19 08:23:20 2024 [DEBUG]
Rows: 0
Size In/Out: 346 B / 45 B
Time: 1 ms
SELECT s._idRegistro, s.idPadre, qf.idSeccion as seccion, qfp.idSeccion as seccionP FROM PRO_Secciones s LEFT JOIN PRO_QueFem qf ON qf.idSeccion=s.idSeccion LEFT JOIN PRO_QueFem qfp ON qfp.idSeccion=s.idPadre WHERE s.idSeccion='42' AND s.mostrarBloqueQueFem='S' AND '8671'<>'11845' LIMIT 1

  Fri Apr 19 08:23:20 2024 [WARNING] SELECT s._idRegistro, s.idPadre, qf.idSeccion as seccion, qfp.idSeccion as seccionP FROM PRO_Secciones s LEFT JOIN PRO_QueFem qf ON qf.idSeccion=s.idSeccion LEFT JOIN PRO_QueFem qfp ON qfp.idSeccion=s.idPadre WHERE s.idSeccion='42' AND s.mostrarBloqueQueFem='S' AND '8671'<>'11845' LIMIT 1

explain this query
Fri Apr 19 08:23:20 2024 [DEBUG]
Rows: 1
Size In/Out: 115 B / 40 B
Time: 1 ms
SELECT idQueFem FROM PRO_QueFem WHERE visibleHome='S' LIMIT 1

Fri Apr 19 08:23:20 2024 [DEBUG] End Section EBDML (10643)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Section EBDML (9055)  

explain this query
Fri Apr 19 08:23:20 2024 [DEBUG]
Rows: 0
Size In/Out: 151 B / 30 B
Time: 0 ms
SELECT _idRegistro FROM PRO_Secciones WHERE idSeccion='42' AND mostrarBloqueDestacats='S' LIMIT 1

Fri Apr 19 08:23:20 2024 [DEBUG] End Section EBDML (9055)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Section EBDML (9837)  

explain this query
Fri Apr 19 08:23:20 2024 [DEBUG]
Rows: 1
Size In/Out: 127 B / 130 B
Time: 0 ms
SELECT * FROM PRO_Banners_X_Pagina_O_Seccion WHERE idPagina='71' ORDER BY Orden

explain this query
Fri Apr 19 08:23:20 2024 [DEBUG]
Rows: 0
Size In/Out: 948 B / 135 B
Time: 0 ms
SELECT TBCN2_BANNER._idRegistro, TBCN2_BANNER.idBanner, TBCN2_BANNER.contenidoENG AS CONTENT, TBCN2_BANNER.textoAltENG AS altBanner, TBCN2_BANNER.flash, TBCN2_BANNER.flashENG AS flashIdioma, TBCN2_BANNER.imagenCAT, TBCN2_BANNER.imagenENG AS imagenIdioma, TBCN2_BANNER.urlImagenExterna, TBCN2_BANNER.urlImagenExternaENG AS ImagenExtIdioma, TBCN2_BANNER.uriEnlace, TBCN2_BANNER.urlEnlaceENG AS urlEnlaceIdioma, TBCN2_BANNER.TipoBanner_idTipoBanner, TBCN2_BANNER.idProd, TBCN2_BANNER.idTipoContenido, TBCN2_BANNER.TipoEnlace_idTipoEnlace, TBCN2_BANNER.idPagina, idFicha, TBCN2_PAGINA.nombreENG AS nombrePagina, TBCN2_BANNER.imagenDeProducto, TBCN2_BANNER.txtEnlace, TBCN2_BANNER.txtEnlaceENG as txtEnlaceIdioma FROM TBCN2_BANNER LEFT JOIN TBCN2_PAGINA ON TBCN2_PAGINA.idPagina=TBCN2_BANNER.idPagina WHERE idBanner=239 AND fechaFinVisible>='2024-4-19' AND fechaInicioVisible<='2024-4-19' AND visibleENG='S'

Fri Apr 19 08:23:20 2024 [DEBUG] End Section EBDML (9837)  

Fri Apr 19 08:23:20 2024 [DEBUG] End Section Global EBDML (8792)  

Fri Apr 19 08:23:20 2024 [DEBUG] End Section RECURSO (11847)  

Fri Apr 19 08:23:20 2024 [DEBUG] End Page (11845)
Fri Apr 19 08:23:20 2024 [DEBUG] Start Section RECURSO (8676)  
Fri Apr 19 08:23:20 2024 [DEBUG] Start Global Section EBDML (8675)  

Fri Apr 19 08:23:20 2024 [DEBUG] End Section Global EBDML (8675)  

Fri Apr 19 08:23:20 2024 [DEBUG] End Section RECURSO (8676)  

  Fri Apr 19 08:23:20 2024 [DEBUG] End Handler

INSPECTION   WATCHES
 
 
 
 
  KEY VALUE