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

Commerce/Barcelona Shopping Line The city’s retail hub par excellence is the Barcelona Shopping Line which showcases top-quality brands and amazing, modern shops featuring the latest trends, at affordable prices. And museums, architecture, art and culture. They will help you experience the lifestyle of the local people.

About us

About us

The Shopping and Shopping Line Programme is responsible for promoting and establishing Barcelona as a world-class shopping city.

Barcelona Shopping line

Barcelona Shopping line

Barcelona is a city of shops and retail hubs, with an urban design that invites you to shop and admire the window displays. The Barcelona Shopping Line is the retail hub that attracts tourists, where you’ll find surprising, modern shops selling world-famous brands featuring the latest trends and at affordable prices.

Advantages for members

Advantages for members

Being a member of the Barcelona Shopping Line means belonging to a group of more than 700 businesses that bring their resources and know-how to promoting Barcelona around the world.

Tax Free

Tax Free

If you live outside the European Union you can ask for a VAT refund on purchases over 90.16 euros. VAT refunds are now available at the tourist information office in the city centre.

Contact with Commerce and Barcelona Shopping Line
Tel:
Fax:
Mail:
[+34] 933 689 700
[+34] 933 689 701
shopping@barcelonaturisme.cat
DEBUG LEVEL
    TIME TYPE MESSAGE

  Sat Apr 20 12:54:40 2024 [DEBUG] Start Handler
Sat Apr 20 12:54:40 2024 [DEBUG] Start Section RECURSO (11770)  
Sat Apr 20 12:54:40 2024 [DEBUG] Start Global Section EBDML (11769)  

Sat Apr 20 12:54:40 2024 [DEBUG] End Section Global EBDML (11769)  

Sat Apr 20 12:54:40 2024 [DEBUG] End Section RECURSO (11770)  
Sat Apr 20 12:54:40 2024 [DEBUG] Start Section RECURSO (9044)  
Sat Apr 20 12:54:40 2024 [DEBUG] Start Global Section EBDML (9042)  

Sat Apr 20 12:54:40 2024 [DEBUG] End Section Global EBDML (9042)  

Sat Apr 20 12:54:40 2024 [DEBUG] End Section RECURSO (9044)  
Sat Apr 20 12:54:40 2024 [DEBUG] Start Section RECURSO (8673)  
Sat Apr 20 12:54:40 2024 [DEBUG] Start Global Section EBDML (8672)  

explain this query
Sat Apr 20 12:54:40 2024 [DEBUG]
Rows: 1
Size In/Out: 122 B / 40 B
Time: 21 ms
Write time: 0 ms Query time: 0 ms Read time: 21 ms
SELECT s.idPadre FROM PRO_Secciones s WHERE s.idSeccion='6'

explain this query
Sat Apr 20 12:54:40 2024 [DEBUG]
Rows: 4
Size In/Out: 203 B / 1.07 KB
Time: 3 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
Sat Apr 20 12:54:40 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
Sat Apr 20 12:54:40 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
Sat Apr 20 12:54:40 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
Sat Apr 20 12:54:40 2024 [DEBUG]
Rows: 5
Size In/Out: 335 B / 192 B
Time: 0 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

  Sat Apr 20 12:54:40 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

  Sat Apr 20 12:54:40 2024 [WARNING] Transparència

  Sat Apr 20 12:54:40 2024 [WARNING] Institutional information

  Sat Apr 20 12:54:40 2024 [WARNING] Organisational structure

  Sat Apr 20 12:54:40 2024 [WARNING] Economic information

  Sat Apr 20 12:54:40 2024 [WARNING] Contractor Profile
Sat Apr 20 12:54:40 2024 [DEBUG] Start Section EBDML (10572)  

Sat Apr 20 12:54:40 2024 [DEBUG] End Section EBDML (10572)  

explain this query
Sat Apr 20 12:54:40 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
Sat Apr 20 12:54:40 2024 [DEBUG]
Rows: 4
Size In/Out: 214 B / 1.09 KB
Time: 2 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
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 1
Size In/Out: 120 B / 174 B
Time: 89 ms
Write time: 0 ms Query time: 0 ms Read time: 89 ms
SELECT * FROM previsio WHERE prev_idioma=3 ORDER BY prev_dia ASC LIMIT 1

explain this query
Sat Apr 20 12:54:41 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
Sat Apr 20 12:54:41 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

Sat Apr 20 12:54:41 2024 [DEBUG] End Section Global EBDML (8672)  

Sat Apr 20 12:54:41 2024 [DEBUG] End Section RECURSO (8673)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Page (8906)
Sat Apr 20 12:54:41 2024 [DEBUG] Start Section RECURSO (8909)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Global Section EBDML (8780)  

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 1
Size In/Out: 215 B / 504 B
Time: 1 ms
SELECT s.nombreENG AS tituloSeccion,s.* FROM PRO_Secciones s WHERE s.idSeccion='6'

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 4
Size In/Out: 365 B / 145 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='6' AND p.noVisibleEnMenu ='N' ORDER BY p.orden ASC

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 4
Size In/Out: 244 B / 70 B
Time: 0 ms
SELECT COUNT(*) AS nRegistros FROM PRO_Pagina p WHERE p.noVisible<>'S' AND p.PRO_Secciones_idSeccion='6' GROUP BY _idRegistro

Sat Apr 20 12:54:41 2024 [DEBUG] End Section Global EBDML (8780)  

Sat Apr 20 12:54:41 2024 [DEBUG] End Section RECURSO (8909)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Section EBDML (8907)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Section RECURSO (8910)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Global Section EBDML (8841)  

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 1
Size In/Out: 174 B / 70 B
Time: 1 ms
SELECT _idRegistro, descripcionENG AS intro, nombreENG AS title, imagenCabSeccion FROM PRO_Secciones WHERE idSeccion='6'

Sat Apr 20 12:54:41 2024 [DEBUG] End Section Global EBDML (8841)  

Sat Apr 20 12:54:41 2024 [DEBUG] End Section RECURSO (8910)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Section RECURSO (10015)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Global Section EBDML (9640)  

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 2
Size In/Out: 241 B / 50 B
Time: 0 ms
SELECT idPRO_Pagina FROM PRO_Pagina WHERE PRO_Secciones_idSeccion='6' AND noVisible<>'S' AND (columnaSubhome=1 OR columnaSubhome='' OR columnaSubhome IS NULL OR columnaSubhome=0) ORDER BY orden

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 1
Size In/Out: 416 B / 616 B
Time: 0 ms
SELECT pa.*, pa.Titulo_ENG AS titulo, pa.entradillaENG AS txtdescripcion, IF(pa.bannerENG IS NULL,pa.bannerCAT,pa.bannerENG) AS bimg, IF(pa.bannerENG IS NULL,"bannerCAT","bannerENG") AS campoimg, enlaceENG as enlace, idPagina_ebd,idTipoPagina,idTipoBloque , noVisibleEnMenu, pa.imagenCabSeccion FROM PRO_Pagina pa WHERE pa.idPRO_Pagina='10'

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 1
Size In/Out: 416 B / 612 B
Time: 1 ms
SELECT pa.*, pa.Titulo_ENG AS titulo, pa.entradillaENG AS txtdescripcion, IF(pa.bannerENG IS NULL,pa.bannerCAT,pa.bannerENG) AS bimg, IF(pa.bannerENG IS NULL,"bannerCAT","bannerENG") AS campoimg, enlaceENG as enlace, idPagina_ebd,idTipoPagina,idTipoBloque , noVisibleEnMenu, pa.imagenCabSeccion FROM PRO_Pagina pa WHERE pa.idPRO_Pagina='11'

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 2
Size In/Out: 172 B / 50 B
Time: 0 ms
SELECT idPRO_Pagina FROM PRO_Pagina WHERE PRO_Secciones_idSeccion='6' AND noVisible<>'S' AND columnaSubhome=2 ORDER BY orden

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 1
Size In/Out: 416 B / 632 B
Time: 1 ms
SELECT pa.*, pa.Titulo_ENG AS titulo, pa.entradillaENG AS txtdescripcion, IF(pa.bannerENG IS NULL,pa.bannerCAT,pa.bannerENG) AS bimg, IF(pa.bannerENG IS NULL,"bannerCAT","bannerENG") AS campoimg, enlaceENG as enlace, idPagina_ebd,idTipoPagina,idTipoBloque , noVisibleEnMenu, pa.imagenCabSeccion FROM PRO_Pagina pa WHERE pa.idPRO_Pagina='35'

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 1
Size In/Out: 416 B / 548 B
Time: 1 ms
SELECT pa.*, pa.Titulo_ENG AS titulo, pa.entradillaENG AS txtdescripcion, IF(pa.bannerENG IS NULL,pa.bannerCAT,pa.bannerENG) AS bimg, IF(pa.bannerENG IS NULL,"bannerCAT","bannerENG") AS campoimg, enlaceENG as enlace, idPagina_ebd,idTipoPagina,idTipoBloque , noVisibleEnMenu, pa.imagenCabSeccion FROM PRO_Pagina pa WHERE pa.idPRO_Pagina='36'

Sat Apr 20 12:54:41 2024 [DEBUG] End Section Global EBDML (9640)  

Sat Apr 20 12:54:41 2024 [DEBUG] End Section RECURSO (10015)  

Sat Apr 20 12:54:41 2024 [DEBUG] End Section EBDML (8907)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Section RECURSO (8908)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Global Section EBDML (8792)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Section EBDML (9054)  

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 1
Size In/Out: 182 B / 80 B
Time: 0 ms
SELECT contactaTXTENG AS txtcontacta,contactaTelefono,contactaFax,contactaEmail,contactaTwitter FROM PRO_Secciones WHERE idSeccion='6'

Sat Apr 20 12:54:41 2024 [DEBUG] End Section EBDML (9054)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Section EBDML (10165)  

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 0
Size In/Out: 144 B / 30 B
Time: 0 ms
SELECT _idRegistro FROM PRO_Secciones WHERE idSeccion='6' AND mostrarBloqueNoticies='S' LIMIT 1

Sat Apr 20 12:54:41 2024 [DEBUG] End Section EBDML (10165)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Section EBDML (10643)  

  Sat Apr 20 12:54:41 2024 [WARNING] seccio: 6

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 0
Size In/Out: 344 B / 45 B
Time: 0 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='6' AND s.mostrarBloqueQueFem='S' AND '8671'<>'8906' LIMIT 1

  Sat Apr 20 12:54:41 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='6' AND s.mostrarBloqueQueFem='S' AND '8671'<>'8906' LIMIT 1

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 1
Size In/Out: 115 B / 40 B
Time: 0 ms
SELECT idQueFem FROM PRO_QueFem WHERE visibleHome='S' LIMIT 1

Sat Apr 20 12:54:41 2024 [DEBUG] End Section EBDML (10643)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Section EBDML (9055)  

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 0
Size In/Out: 150 B / 30 B
Time: 1 ms
SELECT _idRegistro FROM PRO_Secciones WHERE idSeccion='6' AND mostrarBloqueDestacats='S' LIMIT 1

Sat Apr 20 12:54:41 2024 [DEBUG] End Section EBDML (9055)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Section EBDML (9837)  

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 3
Size In/Out: 127 B / 240 B
Time: 0 ms
SELECT * FROM PRO_Banners_X_Pagina_O_Seccion WHERE idSeccion='6' ORDER BY Orden

explain this query
Sat Apr 20 12:54:41 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=332 AND fechaFinVisible>='2024-4-20' AND fechaInicioVisible<='2024-4-20' AND visibleENG='S'

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 0
Size In/Out: 947 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=77 AND fechaFinVisible>='2024-4-20' AND fechaInicioVisible<='2024-4-20' AND visibleENG='S'

explain this query
Sat Apr 20 12:54:41 2024 [DEBUG]
Rows: 0
Size In/Out: 948 B / 135 B
Time: 1 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=175 AND fechaFinVisible>='2024-4-20' AND fechaInicioVisible<='2024-4-20' AND visibleENG='S'

Sat Apr 20 12:54:41 2024 [DEBUG] End Section EBDML (9837)  

Sat Apr 20 12:54:41 2024 [DEBUG] End Section Global EBDML (8792)  

Sat Apr 20 12:54:41 2024 [DEBUG] End Section RECURSO (8908)  

Sat Apr 20 12:54:41 2024 [DEBUG] End Page (8906)
Sat Apr 20 12:54:41 2024 [DEBUG] Start Section RECURSO (8676)  
Sat Apr 20 12:54:41 2024 [DEBUG] Start Global Section EBDML (8675)  

Sat Apr 20 12:54:41 2024 [DEBUG] End Section Global EBDML (8675)  

Sat Apr 20 12:54:41 2024 [DEBUG] End Section RECURSO (8676)  

  Sat Apr 20 12:54:41 2024 [DEBUG] End Handler

INSPECTION   WATCHES
 
 
 
 
  KEY VALUE