yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/landings/landing.php
BBDD->Prod_Yumping_pt_PT
AMBITO->pt_it
AMBITO_AJAX->pt_it
AMBITO_AJAX COOKIE->fr_ch
locale LO_CONFIG->it_PT
locale php->it_PT
Fuente tráfico->0
SESSION VARS
DEFINED VARS
$tpage->
Cache VARS
NOCFG->memcache_port->11212
CFG->memcache_main_server->172.30.2.194
CFG->memcache_add_servers->172.30.2.194
YMMemcache::memcache_stats->
SERVER VARS
HTTP_REFERER
Request VARS
ambito_lang->it
filtro1->bungee
filtro2->braga
rel_alternate->1
paginado_ofertas->
npage->
Total queries: 243
Tiempo total: 0.51986598968506
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[1]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'it')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0078549385070801Tiempo acumulado:0.0078549385070801
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[2]: SELECT IF(VALUE_PROD IS NULL, VALUE, VALUE_PROD) as VAL, NAME
FROM LO_CONFIG C
WHERE C.NAME in ('Request_Data_Base_Country','Request_Multi_Country')
AND AMBITO = 'es';
Tiempo de la consulta:
0.00062179565429688Tiempo acumulado:0.008476734161377
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[3]: SELECT ID_PAIS, IS_PROVINCIA, IS_REGION
FROM ( SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
FROM Prod_Yumping_es_ES.LO_REGION_I18N REI
INNER JOIN Prod_Yumping_es_ES.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE REI.URL = 'braga'
UNION ALL
SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
FROM Prod_Yumping_es_ES.LO_REGION_ADM1_I18N REI
INNER JOIN Prod_Yumping_es_ES.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
WHERE REI.URL = 'braga' UNION ALL SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
FROM Prod_Yumping_pt_PT.LO_REGION_I18N REI
INNER JOIN Prod_Yumping_pt_PT.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE REI.URL = 'braga'
UNION ALL
SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
FROM Prod_Yumping_pt_PT.LO_REGION_ADM1_I18N REI
INNER JOIN Prod_Yumping_pt_PT.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
WHERE REI.URL = 'braga' UNION ALL SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
FROM Prod_Yumping_it_IT.LO_REGION_I18N REI
INNER JOIN Prod_Yumping_it_IT.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE REI.URL = 'braga'
UNION ALL
SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
FROM Prod_Yumping_it_IT.LO_REGION_ADM1_I18N REI
INNER JOIN Prod_Yumping_it_IT.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
WHERE REI.URL = 'braga' UNION ALL SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
FROM Prod_Yumping_fr_FR.LO_REGION_I18N REI
INNER JOIN Prod_Yumping_fr_FR.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE REI.URL = 'braga'
UNION ALL
SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
FROM Prod_Yumping_fr_FR.LO_REGION_ADM1_I18N REI
INNER JOIN Prod_Yumping_fr_FR.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
WHERE REI.URL = 'braga' UNION ALL SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
FROM Prod_Yumping_co_UK.LO_REGION_I18N REI
INNER JOIN Prod_Yumping_co_UK.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE REI.URL = 'braga'
UNION ALL
SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
FROM Prod_Yumping_co_UK.LO_REGION_ADM1_I18N REI
INNER JOIN Prod_Yumping_co_UK.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
WHERE REI.URL = 'braga' UNION ALL SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
FROM Prod_Yumping_mx_MX.LO_REGION_I18N REI
INNER JOIN Prod_Yumping_mx_MX.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE REI.URL = 'braga'
UNION ALL
SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
FROM Prod_Yumping_mx_MX.LO_REGION_ADM1_I18N REI
INNER JOIN Prod_Yumping_mx_MX.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
WHERE REI.URL = 'braga' )AS FIND_REGION
GROUP BY ID_PAIS;
Tiempo de la consulta:
0.0042510032653809Tiempo acumulado:0.012727737426758
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[4]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'pt_it')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0080568790435791Tiempo acumulado:0.020784616470337
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[5]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00049304962158203Tiempo acumulado:0.021277666091919
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[6]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00035905838012695Tiempo acumulado:0.021636724472046
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[7]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';
Tiempo de la consulta:
0.00070905685424805Tiempo acumulado:0.022345781326294
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[8]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'filtro1';
Tiempo de la consulta:
0.00041794776916504Tiempo acumulado:0.022763729095459
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[9]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'filtro2';
Tiempo de la consulta:
0.00037693977355957Tiempo acumulado:0.023140668869019
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[10]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'rel_alternate';
Tiempo de la consulta:
0.0003819465637207Tiempo acumulado:0.023522615432739
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[11]: SELECT G.DESC_GRUPO, G.ID_GRUPO, G.URL AS URL_GRUPO
FROM LO_GRUPOS G
WHERE G.URL = 'bungee'
AND G.ID_TROPIC = 83;
Tiempo de la consulta:
0.001223087310791Tiempo acumulado:0.02474570274353
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[12]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.URL = 'braga'
AND IDIOMA = 'it';
Tiempo de la consulta:
0.0016498565673828Tiempo acumulado:0.026395559310913
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[13]: SELECT '1', RE.ID_REGION, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, RE.ID_REGION_ADM1, RE.ID_PAIS, LATITUDE, LONGITUDE
FROM LO_REGION RE
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
WHERE RE.ID_REGION = 'braga'
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.0014300346374512Tiempo acumulado:0.027825593948364
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[14]: SELECT '2', RE.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, RE.ID_REGION_ADM1, RE.ID_PAIS, LATITUDE, LONGITUDE
FROM LO_REGION_I18N REI
INNER JOIN LO_REGION RE ON REI.ID_REGION=RE.ID_REGION
AND URL = 'braga'
AND IDIOMA = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00055980682373047Tiempo acumulado:0.028385400772095
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[15]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = 'bungee'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.0027799606323242Tiempo acumulado:0.031165361404419
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: SELECT '1', SS.*
FROM LO_SUBSECTORES SS
WHERE BINARY ID_SUBSECTOR = BINARY 'bungee'
AND ID_TROPIC = 83;
Tiempo de la consulta:
0.0026898384094238Tiempo acumulado:0.033855199813843
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[17]: SELECT '2', SS.*
FROM LO_SUBSECTORES SS
WHERE URL_SS = 'bungee'
AND ID_TROPIC = 83;
Tiempo de la consulta:
0.0031759738922119Tiempo acumulado:0.037031173706055
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[18]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE BINARY SEC.ID_SECTOR = BINARY '32'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
AND SECI.ID_TROPIC = 83;
Tiempo de la consulta:
0.0010080337524414Tiempo acumulado:0.038039207458496
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[19]: SELECT *
FROM LO_SEO_KEYWORDS_LANDING SKL
WHERE SKL.ID_SUBSECTOR = 207
AND ID_TROPIC = 83;
Tiempo de la consulta:
0.0028741359710693Tiempo acumulado:0.040913343429565
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[20]: SELECT *
FROM LO_REGION_SKI REI
WHERE URL = 'braga'
AND REI.IDIOMA='it'
AND TIPO = 1;
Tiempo de la consulta:
0.0014379024505615Tiempo acumulado:0.042351245880127
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[21]: SELECT SEC.ID_GRUPO,
SECI.ID_SECTOR, SECI.URL URL_SECTOR, SECI.DESC_SECTOR
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SECI.URL = 'bungee'
AND SECI.ID_TROPIC = 83;
Tiempo de la consulta:
0.00071406364440918Tiempo acumulado:0.043065309524536
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[22]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = ''
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00070500373840332Tiempo acumulado:0.043770313262939
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[23]: SELECT SEC.ID_GRUPO, SECI.ID_SECTOR, SECI.URL URL_SECTOR,SECI.DESC_SECTOR
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SECI.ID_SECTOR = '32'
AND SECI.ID_TROPIC = 83;
Tiempo de la consulta:
0.00049281120300293Tiempo acumulado:0.044263124465942
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[24]: SELECT REIA.ID_REGION_ADM1
FROM LO_REGION RE
INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
WHERE RE.ID_REGION = 751
LIMIT 1;
Tiempo de la consulta:
0.0009300708770752Tiempo acumulado:0.045193195343018
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[25]: SELECT SQL_CALC_FOUND_ROWS ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = EMP.ID_EMPRESA
INNER JOIN LO_EMPRESAS_TRADUCCION_IT ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'it'
WHERE EMP.VALID IN (1)
AND RE.ID_REGION = 751
AND EMP.EMP_MADRE NOT IN (0)
AND EMP.ID_SECTOR=32
GROUP BY EMP.NOMBRE
ORDER BY IF(N_PRECIOS_EST > 0 , 1 ,0) DESC, N_VENTAS_EST DESC,N_ORDER_TSP_EST DESC
LIMIT 0,12;
Tiempo de la consulta:
0.0073111057281494Tiempo acumulado:0.052504301071167
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[26]: SELECT FOUND_ROWS() NEMPRESAS;
Tiempo de la consulta:
0.00032687187194824Tiempo acumulado:0.052831172943115
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[27]: SELECT SQL_CALC_FOUND_ROWS
(SELECT EM2.RESPUESTARAPIDA
FROM LO_EMPRESAS_STAT EM2
WHERE EM2.FK_ID_EST = EMP.ID_MADRE) AS RESPUESTA,
EMP.ID_MADRE, SEC.ID_GRUPO, EMP.ID_EMPRESA,if(EMP.TIPOCUENTA=0,1,EMP.TIPOCUENTA) AS TIPOCUENTA, EMP.NOPINIONES,EMP.COLAB_EMPRESAS,EMP.VALID, EMP.CLIENTE, EMP.PUNTOS,EMP.PRECIO_ACTIVIDAD, EMP.TOPSECTOR_PROVINCIA, EMP.PROMOGRUPO, EMP.URL, EMP.EMP_MADRE, EMP.ID_EMPRESA, EMP.ID_MADRE, EMP.NOMBRE, EMP.DESCRIPCION, EMP.ID_PROVINCIA, EMP.ID_POBLACION, EMP.ID_PAIS,
EMP.COD_POSTAL, EMP.DIRECCION, EMP.MAIL, EMP.TELEFONO, EMP.TELEFONOMOVIL, EMP.FAX, EMP.WEB, EMPS.CENTRAL_ACTIVA,
ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING,
EMP.DESCRIPCION SNIPPET,
REI.DESC_REGION, POI.DESC_POBLACION, SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO, EMP.GALERIA, EMP.GALERIA_DESC, EMP.LONGITUDE, EMP.LATITUDE, EMP.LOGOTIPO, EMP.FOTOPRINCIPAL, EMP.PROMOSECTOR,
REIA.DESC_REGION DESC_REGION_ADM1,EMP.TIPOCUENTA,EMP.VIDEOS_CODE,MULTIFICHA,EMPS.*,SECI.URL URL_SECTOR
,( SELECT (EMP.LICENCIA_EMPRESA)
FROM LO_EMPRESAS EMP3
WHERE (EMP3.ID_EMPRESA= EMP.ID_EMPRESA OR EMP3.ID_EMPRESA = EMP.ID_EMPRESA)
AND EMP3.LICENCIA_EMPRESA IS NOT NULL
AND EMP3.LICENCIA_EMPRESA!='' ) AS LICENCIA_EMPRESA , IF (EMP.EMP_MADRE = 3,
CONCAT((SELECT LATITUDE
FROM LO_REGION
WHERE ID_REGION = 751)),
0) AS LAT_PUBLI
, IF (EMP.EMP_MADRE = 3,
CONCAT((SELECT LONGITUDE
FROM LO_REGION
WHERE ID_REGION = 751)),
0) AS LONG_PUBLI
/* ELIMINAMOS MAX(EMP.LICENCIA_EMPRESA) */
FROM LO_EMPRESAS EMP
INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it'
INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA = 'it'
LEFT JOIN LO_POBLACION PO ON PO.ID_POBLACION = EMP.ID_POBLACION
LEFT JOIN LO_POBLACION_PT POI ON EMP.ID_POBLACION = POI.ID_POBLACION
AND POI.IDIOMA='it'
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 83
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = EMP.ID_EMPRESA
INNER JOIN LO_EMPRESAS_TRADUCCION_IT ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'it'
WHERE EMP.ID_EMPRESA IN (19759933)
ORDER BY IF(N_PRECIOS_EST > 0 , 1 ,0) DESC, N_VENTAS_EST DESC,N_ORDER_TSP_EST DESC;
Tiempo de la consulta:
0.0086278915405273Tiempo acumulado:0.061459064483643
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[28]: SELECT N_OFERTAS AS NumOfertas, N_EMPRESAS AS TOTAL_EMPRESAS, PRECIO_MIN, IF ( MEDIA_AJUSTADA IS NOT NULL
AND MEDIA_AJUSTADA != 0
AND MEDIA_AJUSTADA < MEDIA_PRECIO, MEDIA_AJUSTADA, MEDIA_PRECIO ) AS MEDIA
FROM LO_REGION_STATS
WHERE ID_SUBSECTOR = 207
AND ID_REGION = 751;
Tiempo de la consulta:
0.0012428760528564Tiempo acumulado:0.062701940536499
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[29]: SELECT SS.*,PSS.*, SSF.*, PRE.*, EMP.*, PP.*, PPO.*, COUNT(*) AS TOTAL
FROM LO_SUBSECTORES SS
INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON SS.ID_SUBSECTOR = PSS.ID_ACTIVIDAD_PSS
INNER JOIN LO_SUBSECTORES_FAM SSF ON SS.ID_FAM_SS=SSF.ID_SSF
AND SSF.ID_TROPIC = 83
INNER JOIN LO_PRECIOS PRE ON PSS.ID_PRECIO_PSS=PRE.ID_PRECIO
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_POBLACIONES PPO ON PPO.ID_PRECIO = PRE.ID_PRECIO
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
WHERE SS.ID_TROPIC = 83
AND VALID_PRE=4
AND ID_SECTOR_SS = '32'
AND SS.ID_FAM_SS='946'
AND (PRE.ID_REGION_PRE = 751 OR (PP.ID_REGION_PP = 751
AND PP.ID_POBLACION_PP IS NULL ))
GROUP BY SS.ID_SUBSECTOR
ORDER BY SS.ID_FAM_SS DESC,SS.ID_SUBFAM_SS DESC,PRINCIPAL_SS DESC,COUNT(*) DESC;
Tiempo de la consulta:
0.015698909759521Tiempo acumulado:0.078400850296021
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[30]: SELECT SEOHOME.TITLE, SEOHOME.METADESCRIPTION,SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT
FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
WHERE SEOHOME.ID_TROPIC = 83
AND SEOHOME.ID_KEY='SS207'
AND SEO_VALID in(0,1)
AND SEOHOME.ID_LOCALIZACION='751';
Tiempo de la consulta:
0.0089690685272217Tiempo acumulado:0.087369918823242
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[31]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/it/bungee/braga';
Tiempo de la consulta:
0.0011308193206787Tiempo acumulado:0.088500738143921
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[32]: SELECT *
FROM LO_SEO_DESCRIPTIONS_HOME SEO
WHERE SEO.ID_TROPIC='83'
AND SEO.ID_KEY='SS207'
AND SEO.ID_LOCALIZACION='751';
Tiempo de la consulta:
0.0080921649932861Tiempo acumulado:0.096592903137207
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[33]: SELECT TITLE, DESCRIPTION, KEYWORDS, ID_KEY
FROM LO_SEO_HEADERS SEO
WHERE SEO.ID_TROPIC='83'
AND VALID='1'
AND SEO.ID_KEY='SS207';
Tiempo de la consulta:
0.0022928714752197Tiempo acumulado:0.098885774612427
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[34]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = 'bungee'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00074601173400879Tiempo acumulado:0.099631786346436
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[35]: SELECT ID_SUBSECTOR
FROM LO_SUBSECTORES SS
WHERE SS.URL_SS = 'bungee'
AND SS.ID_TROPIC = 83;
Tiempo de la consulta:
0.00046277046203613Tiempo acumulado:0.10009455680847
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[36]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00089311599731445Tiempo acumulado:0.10098767280579
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[37]: SELECT URL_SS
FROM LO_SUBSECTORES
WHERE BINARY ID_SUBSECTOR = BINARY 207
AND ID_TROPIC = 8;
Tiempo de la consulta:
0.0058009624481201Tiempo acumulado:0.10678863525391
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[38]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0021660327911377Tiempo acumulado:0.10895466804504
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[39]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059413909912109Tiempo acumulado:0.10954880714417
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[40]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'braga'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00062203407287598Tiempo acumulado:0.11017084121704
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[41]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053095817565918Tiempo acumulado:0.1107017993927
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[42]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054502487182617Tiempo acumulado:0.11124682426453
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[43]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
WHERE RE.ID_REGION=751
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00044107437133789Tiempo acumulado:0.11168789863586
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[44]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060796737670898Tiempo acumulado:0.11229586601257
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[45]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055503845214844Tiempo acumulado:0.11285090446472
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[46]: SELECT *
FROM Prod_Yumping_pt_PT.LO_SUBSECTORES
WHERE ID_SUBSECTOR = '207'
AND ID_TROPIC = 8;
Tiempo de la consulta:
0.00049901008605957Tiempo acumulado:0.11334991455078
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[47]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = 'bungee'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00072789192199707Tiempo acumulado:0.11407780647278
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[48]: SELECT ID_SUBSECTOR
FROM LO_SUBSECTORES SS
WHERE SS.URL_SS = 'bungee'
AND SS.ID_TROPIC = 83;
Tiempo de la consulta:
0.00042104721069336Tiempo acumulado:0.11449885368347
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[49]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059199333190918Tiempo acumulado:0.11509084701538
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: SELECT URL_SS
FROM LO_SUBSECTORES
WHERE BINARY ID_SUBSECTOR = BINARY 207
AND ID_TROPIC = 82;
Tiempo de la consulta:
0.0011930465698242Tiempo acumulado:0.11628389358521
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[51]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059700012207031Tiempo acumulado:0.11688089370728
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[52]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005500316619873Tiempo acumulado:0.11743092536926
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[53]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'braga'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00054097175598145Tiempo acumulado:0.11797189712524
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[54]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060415267944336Tiempo acumulado:0.11857604980469
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[55]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052118301391602Tiempo acumulado:0.1190972328186
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[56]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
WHERE RE.ID_REGION=751
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'en';
Tiempo de la consulta:
0.0019919872283936Tiempo acumulado:0.121089220047
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[57]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052285194396973Tiempo acumulado:0.12161207199097
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[58]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060415267944336Tiempo acumulado:0.12221622467041
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[59]: SELECT *
FROM Prod_Yumping_pt_PT.LO_SUBSECTORES
WHERE ID_SUBSECTOR = '207'
AND ID_TROPIC = 82;
Tiempo de la consulta:
0.00047516822814941Tiempo acumulado:0.12269139289856
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[60]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = 'bungee'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00071215629577637Tiempo acumulado:0.12340354919434
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[61]: SELECT ID_SUBSECTOR
FROM LO_SUBSECTORES SS
WHERE SS.URL_SS = 'bungee'
AND SS.ID_TROPIC = 83;
Tiempo de la consulta:
0.00042295455932617Tiempo acumulado:0.12382650375366
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[62]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00062799453735352Tiempo acumulado:0.12445449829102
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[63]: SELECT URL_SS
FROM LO_SUBSECTORES
WHERE BINARY ID_SUBSECTOR = BINARY 207
AND ID_TROPIC = 84;
Tiempo de la consulta:
0.0013549327850342Tiempo acumulado:0.12580943107605
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[64]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060892105102539Tiempo acumulado:0.12641835212708
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[65]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058889389038086Tiempo acumulado:0.12700724601746
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[66]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'braga'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00053811073303223Tiempo acumulado:0.12754535675049
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[67]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0021340847015381Tiempo acumulado:0.12967944145203
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[68]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058412551879883Tiempo acumulado:0.13026356697083
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[69]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
WHERE RE.ID_REGION=751
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00054621696472168Tiempo acumulado:0.13080978393555
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[70]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00096988677978516Tiempo acumulado:0.13177967071533
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[71]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050210952758789Tiempo acumulado:0.13228178024292
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[72]: SELECT *
FROM Prod_Yumping_pt_PT.LO_SUBSECTORES
WHERE ID_SUBSECTOR = '207'
AND ID_TROPIC = 84;
Tiempo de la consulta:
0.00046777725219727Tiempo acumulado:0.13274955749512
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[73]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = 'bungee'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00082087516784668Tiempo acumulado:0.13357043266296
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[74]: SELECT ID_SUBSECTOR
FROM LO_SUBSECTORES SS
WHERE SS.URL_SS = 'bungee'
AND SS.ID_TROPIC = 83;
Tiempo de la consulta:
0.00051522254943848Tiempo acumulado:0.1340856552124
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[75]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056314468383789Tiempo acumulado:0.13464879989624
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[76]: SELECT URL_SS
FROM LO_SUBSECTORES
WHERE BINARY ID_SUBSECTOR = BINARY 207
AND ID_TROPIC = 81;
Tiempo de la consulta:
0.0029881000518799Tiempo acumulado:0.13763689994812
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[77]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058913230895996Tiempo acumulado:0.13822603225708
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[78]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0026171207427979Tiempo acumulado:0.14084315299988
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[79]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'braga'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00068211555480957Tiempo acumulado:0.14152526855469
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[80]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0007929801940918Tiempo acumulado:0.14231824874878
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[81]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055718421936035Tiempo acumulado:0.14287543296814
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[82]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
WHERE RE.ID_REGION=751
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.000640869140625Tiempo acumulado:0.14351630210876
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[83]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058317184448242Tiempo acumulado:0.14409947395325
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[84]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005638599395752Tiempo acumulado:0.14466333389282
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[85]: SELECT *
FROM Prod_Yumping_pt_PT.LO_SUBSECTORES
WHERE ID_SUBSECTOR = '207'
AND ID_TROPIC = 81;
Tiempo de la consulta:
0.00058102607727051Tiempo acumulado:0.14524435997009
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[86]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = 'bungee'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00080299377441406Tiempo acumulado:0.14604735374451
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[87]: SELECT ID_SUBSECTOR
FROM LO_SUBSECTORES SS
WHERE SS.URL_SS = 'bungee'
AND SS.ID_TROPIC = 83;
Tiempo de la consulta:
0.0013930797576904Tiempo acumulado:0.1474404335022
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[88]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00068497657775879Tiempo acumulado:0.14812541007996
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[89]: SELECT URL_SS
FROM LO_SUBSECTORES
WHERE BINARY ID_SUBSECTOR = BINARY 207
AND ID_TROPIC = 86;
Tiempo de la consulta:
0.0011868476867676Tiempo acumulado:0.14931225776672
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[90]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059604644775391Tiempo acumulado:0.14990830421448
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[91]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0017340183258057Tiempo acumulado:0.15164232254028
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[92]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'braga'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.0010900497436523Tiempo acumulado:0.15273237228394
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[93]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012340545654297Tiempo acumulado:0.15396642684937
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[94]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049901008605957Tiempo acumulado:0.15446543693542
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[95]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
WHERE RE.ID_REGION=751
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'ch';
Tiempo de la consulta:
0.0023999214172363Tiempo acumulado:0.15686535835266
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[96]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0013570785522461Tiempo acumulado:0.15822243690491
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[97]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0013501644134521Tiempo acumulado:0.15957260131836
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[98]: SELECT *
FROM Prod_Yumping_pt_PT.LO_SUBSECTORES
WHERE ID_SUBSECTOR = '207'
AND ID_TROPIC = 86;
Tiempo de la consulta:
0.0015430450439453Tiempo acumulado:0.1611156463623
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[99]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = 'bungee'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.0022740364074707Tiempo acumulado:0.16338968276978
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[100]: SELECT ID_SUBSECTOR
FROM LO_SUBSECTORES SS
WHERE SS.URL_SS = 'bungee'
AND SS.ID_TROPIC = 83;
Tiempo de la consulta:
0.00094699859619141Tiempo acumulado:0.16433668136597
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[101]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0006258487701416Tiempo acumulado:0.16496253013611
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[102]: SELECT URL_SS
FROM LO_SUBSECTORES
WHERE BINARY ID_SUBSECTOR = BINARY 207
AND ID_TROPIC = 87;
Tiempo de la consulta:
0.0018351078033447Tiempo acumulado:0.16679763793945
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[103]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0018370151519775Tiempo acumulado:0.16863465309143
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[104]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049901008605957Tiempo acumulado:0.16913366317749
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[105]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'braga'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00072002410888672Tiempo acumulado:0.16985368728638
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[106]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00076985359191895Tiempo acumulado:0.1706235408783
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[107]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00087404251098633Tiempo acumulado:0.17149758338928
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[108]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
WHERE RE.ID_REGION=751
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.0021340847015381Tiempo acumulado:0.17363166809082
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[109]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059890747070312Tiempo acumulado:0.17423057556152
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[110]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0075039863586426Tiempo acumulado:0.18173456192017
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[111]: SELECT *
FROM Prod_Yumping_pt_PT.LO_SUBSECTORES
WHERE ID_SUBSECTOR = '207'
AND ID_TROPIC = 87;
Tiempo de la consulta:
0.001230001449585Tiempo acumulado:0.18296456336975
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[112]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = 'bungee'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00099492073059082Tiempo acumulado:0.18395948410034
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[113]: SELECT ID_SUBSECTOR
FROM LO_SUBSECTORES SS
WHERE SS.URL_SS = 'bungee'
AND SS.ID_TROPIC = 83;
Tiempo de la consulta:
0.00081205368041992Tiempo acumulado:0.18477153778076
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[114]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053906440734863Tiempo acumulado:0.18531060218811
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[115]: SELECT URL_SS
FROM LO_SUBSECTORES
WHERE BINARY ID_SUBSECTOR = BINARY 207
AND ID_TROPIC = 85;
Tiempo de la consulta:
0.0011970996856689Tiempo acumulado:0.18650770187378
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[116]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054407119750977Tiempo acumulado:0.18705177307129
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[117]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051784515380859Tiempo acumulado:0.1875696182251
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[118]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'braga'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00056195259094238Tiempo acumulado:0.18813157081604
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[119]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005338191986084Tiempo acumulado:0.18866539001465
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[120]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00067400932312012Tiempo acumulado:0.18933939933777
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[121]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
WHERE RE.ID_REGION=751
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00065183639526367Tiempo acumulado:0.18999123573303
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[122]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060701370239258Tiempo acumulado:0.19059824943542
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[123]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054311752319336Tiempo acumulado:0.19114136695862
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[124]: SELECT *
FROM Prod_Yumping_pt_PT.LO_SUBSECTORES
WHERE ID_SUBSECTOR = '207'
AND ID_TROPIC = 85;
Tiempo de la consulta:
0.0005180835723877Tiempo acumulado:0.19165945053101
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[125]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005340576171875Tiempo acumulado:0.19219350814819
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[126]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058794021606445Tiempo acumulado:0.19278144836426
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[127]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0042269229888916Tiempo acumulado:0.19700837135315
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[128]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00057506561279297Tiempo acumulado:0.19758343696594
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[129]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058078765869141Tiempo acumulado:0.19816422462463
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[130]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00057601928710938Tiempo acumulado:0.19874024391174
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[131]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0007321834564209Tiempo acumulado:0.19947242736816
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[132]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050902366638184Tiempo acumulado:0.19998145103455
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[133]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059390068054199Tiempo acumulado:0.20057535171509
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[134]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053095817565918Tiempo acumulado:0.20110630989075
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[135]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.20158529281616
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[136]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054407119750977Tiempo acumulado:0.20212936401367
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[137]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046801567077637Tiempo acumulado:0.20259737968445
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[138]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046682357788086Tiempo acumulado:0.20306420326233
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[139]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048995018005371Tiempo acumulado:0.20355415344238
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[140]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049614906311035Tiempo acumulado:0.20405030250549
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[141]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050711631774902Tiempo acumulado:0.20455741882324
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[142]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005500316619873Tiempo acumulado:0.20510745048523
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[143]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050210952758789Tiempo acumulado:0.20560956001282
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[144]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050783157348633Tiempo acumulado:0.2061173915863
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[145]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054717063903809Tiempo acumulado:0.20666456222534
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[146]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00066900253295898Tiempo acumulado:0.2073335647583
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[147]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050497055053711Tiempo acumulado:0.20783853530884
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[148]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051689147949219Tiempo acumulado:0.20835542678833
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[149]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054192543029785Tiempo acumulado:0.20889735221863
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[150]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051999092102051Tiempo acumulado:0.20941734313965
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[151]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059294700622559Tiempo acumulado:0.21001029014587
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[152]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00063395500183105Tiempo acumulado:0.21064424514771
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[153]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055718421936035Tiempo acumulado:0.21120142936707
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[154]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00071191787719727Tiempo acumulado:0.21191334724426
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[155]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00077509880065918Tiempo acumulado:0.21268844604492
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[156]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001115083694458Tiempo acumulado:0.21380352973938
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[157]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059390068054199Tiempo acumulado:0.21439743041992
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[158]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055408477783203Tiempo acumulado:0.21495151519775
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[159]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00079202651977539Tiempo acumulado:0.21574354171753
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[160]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053095817565918Tiempo acumulado:0.21627449989319
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[161]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050497055053711Tiempo acumulado:0.21677947044373
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[162]: SELECT *
FROM LO_REGION_STATS RS
WHERE RS.ID_SECTOR = 32
AND RS.ID_REGION = 751
AND ID_GRUPO = 0
AND ID_SUBSECTOR = 0
AND N_OFERTAS > 0;
Tiempo de la consulta:
0.00061297416687012Tiempo acumulado:0.2173924446106
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[163]: SELECT SEOHOME.TITLE, SEOHOME.METADESCRIPTION,SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT
FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
WHERE SEOHOME.ID_TROPIC = 83
AND SEOHOME.ID_KEY='SS207'
AND SEO_VALID in(0,1)
AND SEOHOME.ID_LOCALIZACION='751';
Tiempo de la consulta:
0.0081009864807129Tiempo acumulado:0.22549343109131
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[164]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.002208948135376Tiempo acumulado:0.22770237922668
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[165]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00082612037658691Tiempo acumulado:0.22852849960327
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[166]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
FROM LO_REGION_STATS
WHERE ID_REGION = 751
AND ID_SECTOR = 32;
Tiempo de la consulta:
0.00047492980957031Tiempo acumulado:0.22900342941284
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[167]: SELECT MIN(MIN_PRECIO) AS MIN_PRECIO, MAX(MAX_PRECIO) AS MAX_PRECIO
FROM
(
SELECT MIN(PRE.PRECIO_PRE) MIN_PRECIO, MAX(PRE.PRECIO_PRE) MAX_PRECIO
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_SUBSECTORES ID_PRECIO_PSS ON ID_PRECIO_PSS.ID_PRECIO_PSS = PRE.ID_PRECIO
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE = EMP.ID_EMPRESA
WHERE EMP.VALID IN (1)
AND PRE.VALID_PRE = 4
AND ID_PRECIO_PSS.ID_ACTIVIDAD_PSS = 207
AND PRE.ID_REGION_PRE ='751'
UNION ALL
SELECT MIN(PD.PRECIO_PD) MIN_PRECIO, MAX(PD.PRECIO_PD) MAX_PRECIO
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_SUBSECTORES ID_PRECIO_PSS ON ID_PRECIO_PSS.ID_PRECIO_PSS = PRE.ID_PRECIO
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE = EMP.ID_EMPRESA
INNER JOIN LO_PRECIOS_DESCUENTOS PD ON PRE.ID_PRECIO = PD.ID_PRECIO_PD
WHERE EMP.VALID IN (1)
AND PRE.VALID_PRE = 4
AND PD.VALID_PD = 1
AND ID_PRECIO_PSS.ID_ACTIVIDAD_PSS = 207
AND PRE.ID_REGION_PRE ='751'
/* UNION ALL
SELECT EMP.PRECIO_ACTIVIDAD AS MIN_PRECIO, NULL MAX_PRECIO
FROM LO_EMPRESAS EMP
LEFT JOIN LO_PRECIOS PRE ON PRE.ID_EMPRESA_PRE = EMP.ID_EMPRESA
AND PRE.VALID_PRE = 4
LEFT JOIN LO_PRECIOS_SUBSECTORES ID_PRECIO_PSS ON ID_PRECIO_PSS.ID_PRECIO_PSS = PRE.ID_PRECIO
WHERE EMP.VALID IN (1 )
AND EMP.PRECIO_ACTIVIDAD !=0
AND ID_PRECIO_PSS.ID_ACTIVIDAD_PSS = 207
AND PRE.ID_REGION_PRE ='751'
*/ ) AS PRECIO_MIN_MAX;
Tiempo de la consulta:
0.0037717819213867Tiempo acumulado:0.23277521133423
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[168]: SELECT *
FROM LO_SEO_KEYWORDS_LANDING SKL
WHERE SKL.ID_SUBSECTOR = 207
AND SKL.ID_TROPIC = 83;
Tiempo de la consulta:
0.00046706199645996Tiempo acumulado:0.23324227333069
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[169]: SELECT PRE.ID_PRECIO, COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS , IF(PP.ID_REGION_PP = 751
AND PP.ID_POBLACION_PP IS NULL,1,0) AS ES_PUBLI
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND EMP.VALID = 1
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
AND SECI.ID_TROPIC = 83
INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON PSS.ID_PRECIO_PSS = PRE.ID_PRECIO
INNER JOIN LO_SUBSECTORES SS ON SS.ID_SECTOR_SS = SECI.ID_SECTOR
AND PSS.ID_ACTIVIDAD_PSS = SS.ID_SUBSECTOR
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA='it'
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
INNER JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='it'
LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO=PP.ID_PRECIO_PP
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
AND RC.VALID_RC NOT IN(0,2,6,7)
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND PRE.EXCLUYE_PRE IN (0,1)
AND SS.ID_SUBSECTOR = 207
AND ( PRE.ID_REGION_PRE='751' OR PP.ID_REGION_PP='751' )
GROUP BY PRE.ID_PRECIO
ORDER BY ES_PUBLI ASC, PT.N_ORDER_VENTAS_TROPIC DESC
LIMIT 20;
Tiempo de la consulta:
0.081123828887939Tiempo acumulado:0.31436610221863
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[170]: SELECT FOUND_ROWS() NOFERTAS;
Tiempo de la consulta:
0.00058412551879883Tiempo acumulado:0.31495022773743
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[171]: SELECT SQL_CALC_FOUND_ROWS COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS, PO.DESC_POBLACION, PRE.ID_PRECIO, SECI.DESC_SECTOR, SECI.URL URL_SECTOR,
REI.URL URL_REGION, REI.DESC_REGION,REIA.DESC_REGION AS DESC_REGION_ADM,
PRE.TITULO_PRE, PRE.DESCRIPCION_PRE, PD.OFERTA_PD,PRE.GALERIA_DESC_PRE, SECI.ID_SECTOR,
LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO, REI.ID_REGION,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO_D,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%d') AS DIA_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%m') AS MES_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%Y') AS ANYO_CAD,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM,
OP.VALORACION,COUNT(DISTINCT OP.ID_OPINION) AS OPIS, PD.OFERTA_PD,VALID_PD,PRECIO_UNITARIO_PRE,
PRE.MIN_PERS_PRE, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE,
PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION,PRE.FOTOPRINCIPAL_PRE, PRE.GALERIA_PRE,EMPS.CENTRAL_ACTIVA, PRE.N_ORDER_VENTAS_TROPIC,
PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP,
PRE.MULTIACTIVIDAD_PRE , IF(PP.ID_REGION_PP = 751
AND PP.ID_POBLACION_PP IS NULL,1,0) AS ES_PUBLI
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND EMP.VALID = 1
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
AND SECI.ID_TROPIC = 83
INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON PSS.ID_PRECIO_PSS = PRE.ID_PRECIO
INNER JOIN LO_SUBSECTORES SS ON SS.ID_SECTOR_SS = SECI.ID_SECTOR
AND PSS.ID_ACTIVIDAD_PSS = SS.ID_SUBSECTOR
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA='it'
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA='it'
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
INNER JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='it'
LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
AND RC.VALID_RC NOT IN(0,2,6,7)
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO=PP.ID_PRECIO_PP
LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID=1
WHERE PRE.ID_PRECIO IN (75315)
GROUP BY PRE.ID_PRECIO
ORDER BY ES_PUBLI ASC, PT.N_ORDER_VENTAS_TROPIC DESC;
Tiempo de la consulta:
0.037961006164551Tiempo acumulado:0.35291123390198
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[172]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'O1'
AND SEO.ID_TROPIC = 83
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.004472017288208Tiempo acumulado:0.35738325119019
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[173]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S32'
AND SEO.ID_TROPIC = 83
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00049495697021484Tiempo acumulado:0.3578782081604
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[174]: SELECT *
FROM LO_PRECIOS_CALENDARIO PC
WHERE PC.ID_PRECIO_PC = 75315
AND DATE(PC.FECHA_PC) <= (DATE(NOW()) + INTERVAL 3 MONTH)
AND DATE(PC.FECHA_PC) >= DATE(NOW())
AND TIPO_PC = 2;
Tiempo de la consulta:
0.0036289691925049Tiempo acumulado:0.36150717735291
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[175]: SELECT (PRE.PERIODO_PRE) AS PERIODO
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 75315
UNION ALL
SELECT PD.PERIODO_PD AS PERIODO
FROM LO_PRECIOS_DESCUENTOS PD
WHERE PD.ID_PRECIO_PD = 75315
AND PD.VALID_PD = 1;
Tiempo de la consulta:
0.00054407119750977Tiempo acumulado:0.36205124855042
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[176]: SELECT ID_PRECIO, SUM(VENTAS) VENTAS, SUM(DEVOS) DEVOS, SUM(COMISION) COMISION, SUM(TOTAL) TOTAL, ID_EMPRESA_PRE AS ID_EMPRESA FROM(
SELECT PRE.ID_PRECIO, COUNT(RC.ID_RESERVA_COMPRA) AS VENTAS, 0 AS DEVOS, EMP.COMISION ,
(COUNT(RC.ID_RESERVA_COMPRA) * EMP.COMISION / 100 ) AS TOTAL, PRE.ID_EMPRESA_PRE
FROM LO_PRECIOS PRE
LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
AND VALID_RC NOT IN (0, 2, 7)
AND ID_TROPIC = 83
AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 2 YEAR
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND EMP.VALID = 1
WHERE PRE.VALID_PRE = 4
AND ID_PRECIO = 75315
GROUP BY PRE.ID_PRECIO
UNION ALL
SELECT PRE.ID_PRECIO, 0 AS VENTAS, COUNT(RC.ID_RESERVA_COMPRA) AS DEVOS, 0 ,
0 AS TOTAL, PRE.ID_EMPRESA_PRE
FROM LO_PRECIOS PRE
LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
AND VALID_RC IN (7)
AND ID_TROPIC = 83
AND RC.DEVOLUCION_RC IN (1,2)
AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 2 YEAR
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND EMP.VALID = 1
WHERE PRE.VALID_PRE = 4
AND ID_PRECIO = 75315
GROUP BY PRE.ID_PRECIO
) AS X;
Tiempo de la consulta:
0.0024890899658203Tiempo acumulado:0.36454033851624
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[177]: SELECT *
FROM LO_PRECIOS_MODIFICAR_ORDEN
WHERE ID_PRECIO = 75315
AND DATE_FORMAT(FECHA, '%Y-%m-%d') >= NOW() - INTERVAL 3 MONTH;
Tiempo de la consulta:
0.0010881423950195Tiempo acumulado:0.36562848091125
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[178]: SELECT EMP.COMO_LLEGAR COMO_LLEGAR_ORI, EMP.GALERIA_DESC GALERIA_DESC_ORI, EMP.VIDEOS_TEXT VIDEOS_TEXT_ORI,EMP.VIDEOS_DESC VIDEOS_DESC_ORI,
EMP.EMP_MADRE,EMP.LOGOTIPO,EMP.ID_EMPRESA,EMP.DIRECCION,
PO.DESC_POBLACION, PO.URL_POBLACION, REI.DESC_REGION,EMP.DS_ACTIVO,EMP.ID_PAIS,
EMP.TELEFONO,EMP.NOPINIONES,EMP.VIDEOS_CODE,SEC.ID_GRUPO,SECI.DESC_SECTOR,EMP.FOTOPRINCIPAL,
EMP.GALERIA,EMP.MADRE_NAME,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA,SECI.URL URL_SECTOR,
EMP.LICENCIA_EMPRESA,EMP.ID_POBLACION,EMP.VALID,EMP.ID_PROVINCIA,EMP.ID_SECTOR,
EMP.VIDEOS_CODE,EMP.VIDEOS_DESC,EMP.CLIENTE,RE.ID_REGION,N_VENTAS_EST,
EMP.COLAB_EMPRESAS, EMP.ID_MADRE ID_MADRE,REI.URL URL_REGION,
EMP.LATITUDE LATITUDE,EMP.COD_POSTAL, EMP.LONGITUDE LONGITUDE,PO.URL_POBLACION,
ES.NOPINIONES_EST,ES.N_PRECIOS_EST,ES.VISITAS,PUNTOS_EST,EMP.LOGIN,EMP.PASSWORD,EMP.PERS_CTCTO,
EMP.TELEFONOMOVIL, EMP.FAX,EMP.WEB,EMP.MAIL,EMP.ACCOUNT_MANAGER,RESPUESTARAPIDA,CENTRAL_ACTIVA,
NOPINIONES_EST,EMP.MAIL_CC, EMP.ACEPTAR_CR,EMP.VIDEOS_TEXT,ES.PRECIO_EST, ES.PUNTOS_EST,
ES.RIESGO_EST, ES.ATENCION_EST, EMP.URL,
ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING,
IF (EMP.EMP_MADRE = 0,
CASE EMP.ID_SECTOR
WHEN 13 THEN GRU.DESC_GRUPO
WHEN 16 THEN GRU.DESC_GRUPO
WHEN 2 THEN GRU.DESC_GRUPO
WHEN 3 THEN GRU.DESC_GRUPO
WHEN 56 THEN GRU.DESC_GRUPO
WHEN 67 THEN GRU.DESC_GRUPO
WHEN 7 THEN GRU.DESC_GRUPO
WHEN 93 THEN GRU.DESC_GRUPO
ELSE SECI.DESC_SECTOR
END,
SECI.DESC_SECTOR) AS DESC_SECTOR_BUSCADOR
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_IT ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'it'
LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
LEFT JOIN LO_REGION RE ON EMP.ID_PROVINCIA = RE.ID_REGION
LEFT JOIN LO_REGION_I18N REI ON RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA='it'
LEFT JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_PT PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='it'
INNER JOIN LO_SECTORES SEC ON EMP.ID_SECTOR = SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR = SECI.ID_SECTOR
AND (SECI.ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 83)
WHERE EMP.ID_EMPRESA = 19759936
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0021119117736816Tiempo acumulado:0.36774039268494
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[179]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 75315
AND VALID = 1;
Tiempo de la consulta:
0.0089890956878662Tiempo acumulado:0.3767294883728
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[180]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 75315
AND FOTO = 'p-75315-caida-libre-en-salto-de-bungee1645113232_16451133073723.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00061488151550293Tiempo acumulado:0.37734436988831
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[181]: SELECT F_WIDTH, F_HEIGHT
FROM LO_FOTOS
WHERE ID_PRECIO = 75315
AND FOTO = 'p-75315-caida-libre-en-salto-de-bungee1645113232_16451133073723.jpg';
Tiempo de la consulta:
0.00039196014404297Tiempo acumulado:0.37773633003235
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[182]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
WHERE PRE.ID_PRECIO = 75315;
Tiempo de la consulta:
0.00056099891662598Tiempo acumulado:0.37829732894897
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[183]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 75315;
Tiempo de la consulta:
0.0011601448059082Tiempo acumulado:0.37945747375488
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[184]: SELECT N_VENTAS_LAST_MONTH
FROM LO_PRECIOS_STATS PS
WHERE PS.ID_PRECIO = 75315;
Tiempo de la consulta:
0.0015261173248291Tiempo acumulado:0.38098359107971
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[185]: SELECT DATE_FORMAT(PRE.FEC_ULT_COMPRA, '%Y-%m-%d') AS FEC_ULT_COMPRA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
WHERE ID_PRECIO = 75315
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00053095817565918Tiempo acumulado:0.38151454925537
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[186]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 75315
LIMIT 1;
Tiempo de la consulta:
0.0015549659729004Tiempo acumulado:0.38306951522827
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[187]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 75315;
Tiempo de la consulta:
0.00048494338989258Tiempo acumulado:0.38355445861816
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 75315
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.0010521411895752Tiempo acumulado:0.38460659980774
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
WHERE PRE.ID_PRECIO = 75315;
Tiempo de la consulta:
0.00067782402038574Tiempo acumulado:0.38528442382812
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 75315;
Tiempo de la consulta:
0.00043988227844238Tiempo acumulado:0.38572430610657
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[191]: SELECT SS.ID_SUBSECTOR, N_OFERTAS AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, SS.DESC_SS AS DESC_SECTOR, SS.URL_SS AS URL_SECTOR, PO.DESC_POBLACION, PO.URL_POBLACION, PO.ID_POBLACION, RE.ID_REGION_ADM1, RE.ID_PAIS
FROM
LO_POBLACION_PT_STATS PS
INNER JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PS.ID_POBLACION
AND PO.IDIOMA = 'it'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
AND REI.IDIOMA = 'it'
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
AND IF(RE.ID_CAPITAL = PO.ID_POBLACION
AND RE.SIMCAPN = 1, 1=2, 1=1)
INNER JOIN LO_SUBSECTORES SS ON PS.ID_SUBSECTOR = SS.ID_SUBSECTOR
AND SS.ID_TROPIC ='83'
AND SS.INDEXA_SS = 1
WHERE
REI.ID_REGION = 751
AND PS.ID_SUBSECTOR = 207
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
AND (PS.ID_SECTOR = 0 OR PS.ID_SECTOR IS NULL)
AND (PS.ID_GRUPO = 0 OR PS.ID_GRUPO IS NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.012847185134888Tiempo acumulado:0.39857149124146
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[192]: SELECT IF(PO.ID_POBLACION = RE.ID_CAPITAL,1,2) AS CAPITAL, IF(ISNULL(N_OFERTAS),0,N_OFERTAS)+IF(ISNULL(N_EMPRESAS),0,N_EMPRESAS) AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas,
PO.ID_POBLACION, PO.DESC_POBLACION, PO.URL_POBLACION AS URL_POBLACION, PO.ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION,
'' AS DESC_SECTOR, '' AS ID_GRUPO
FROM
LO_POBLACION_PT_STATS PS
INNER JOIN LO_POBLACION_PT PO ON PS.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA = 'it'
AND PO.ID_REGION = 751
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION
AND REI.IDIOMA = 'it'
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE (PS.N_OFERTAS > 0 /* OR PS.N_EMPRESAS > 0 */)
AND PS.ID_SUBSECTOR = 207
GROUP BY PS.ID_POBLACION
ORDER BY N_OFERTAS DESC;
Tiempo de la consulta:
0.013229846954346Tiempo acumulado:0.4118013381958
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[193]: SELECT URL AS URL_REGION, SIMCAPN, ID_CAPITAL
FROM LO_REGION_I18N REI
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE REI.ID_REGION = 751
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00046086311340332Tiempo acumulado:0.4122622013092
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 81109
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00037312507629395Tiempo acumulado:0.4126353263855
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: SELECT *
FROM LO_SUBSECTORES
WHERE BINARY ID_SUBSECTOR = BINARY '207'
AND ID_TROPIC = 83;
Tiempo de la consulta:
0.0020179748535156Tiempo acumulado:0.41465330123901
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[196]: SELECT SEC.ID_GRUPO, SECI.ID_SECTOR, SECI.URL URL_SECTOR,SECI.DESC_SECTOR
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SECI.ID_SECTOR = '32'
AND SECI.ID_TROPIC = 83;
Tiempo de la consulta:
0.0005180835723877Tiempo acumulado:0.4151713848114
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: SELECT LO.ID_PRECIO
FROM LO_LANDING_OFERTAS LO
WHERE LO.STATUS = 2
AND LO.ID_SECTOR = 32
AND LO.ID_PROVINCIA = 751;
Tiempo de la consulta:
0.0010340213775635Tiempo acumulado:0.41620540618896
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[198]: SELECT PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PRE.ID_PRECIO, SEC.ID_SECTOR, ID_REGION_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND (EMP.VALID = 1 )
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON PRE.ID_PRECIO=PSS.ID_PRECIO_PSS
LEFT JOIN LO_LANDING_OFERTAS LO ON LO.ID_PRECIO = PRE.ID_PRECIO
AND LO.STATUS = 1
AND LO.ID_SECTOR = 32
AND LO.ID_PROVINCIA = 751
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND PSS.ID_ACTIVIDAD_PSS='207'
AND ( PRE.ID_REGION_PRE='751' OR PP.ID_REGION_PP='751' )
GROUP BY PRE.ID_PRECIO
ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0024209022521973Tiempo acumulado:0.41862630844116
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[199]: SELECT '2' as TIPO, PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PO.DESC_POBLACION, PRE.ID_PRECIO,
SECI.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR,
REI.ID_REGION, REI.URL URL_REGION, REI.DESC_REGION,
PP.ID_REGION_PP, PP.DESCRIPCION_PP,
PRE.MIN_PERS_PRE, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE,
PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION,PRE.FOTOPRINCIPAL_PRE,
PRE.GALERIA_PRE,EMPS.CENTRAL_ACTIVA, PRE.MULTIACTIVIDAD_PRE,
LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO_D,
PD.OFERTA_PD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%d') AS DIA_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%m') AS MES_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%Y') AS ANYO_CAD,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM,
TRUNCATE(AVG(OP.VALORACION),0) AS VALORACION, PD.OFERTA_PD,VALID_PD,
PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP,
PRECIO_UNITARIO_PRE
,IF ( PRE.MIN_PERS_PRE > MIN(PD.MIN_PERSONAS_PD)
AND PD.MIN_PERSONAS_PD IS NOT NULL, MIN(PD.MIN_PERSONAS_PD), PRE.MIN_PERS_PRE ) AS MIN_PERSONAS_PD
,IF ( PRE.MAX_PERS_PRE < MAX(PD.MAX_PERSONAS_PD)
AND PD.MAX_PERSONAS_PD IS NOT NULL, MAX(PD.MAX_PERSONAS_PD), PRE.MAX_PERS_PRE ) AS MAX_PERSONAS_PD
,IF(PD.PRECIO_PD > 0
AND PD.VALID_PD = 1, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
AND RC.VALID_RC NOT IN (0, 2, 6, 7)
LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND (EMP.VALID = 1 )
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON PRE.ID_PRECIO=PSS.ID_PRECIO_PSS
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
AND (SECI.FK_ID_IDIOMA_SI18N = 'it'
AND SECI.ID_TROPIC = 83)
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'it'
INNER JOIN LO_POBLACION_PT PO ON PRE.ID_POBLACION_PRE = PO.ID_POBLACION
AND PO.IDIOMA = 'it'
LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID = 1
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE 1 = 1
AND PRE.ID_PRECIO IN (75315)
AND PRE.VALID_PRE = 4
AND PSS.ID_ACTIVIDAD_PSS='207'
AND ( PRE.ID_REGION_PRE='751' OR PP.ID_REGION_PP='751' )
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0038630962371826Tiempo acumulado:0.42248940467834
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: SELECT PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PRE.ID_PRECIO, SEC.ID_SECTOR, ID_REGION_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND (EMP.VALID = 1 )
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON PRE.ID_PRECIO=PSS.ID_PRECIO_PSS
LEFT JOIN LO_LANDING_OFERTAS LO ON LO.ID_PRECIO = PRE.ID_PRECIO
AND LO.STATUS = 1
AND LO.ID_SECTOR = 32
AND LO.ID_PROVINCIA = 751
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND PSS.ID_ACTIVIDAD_PSS='207'
AND ( PRE.ID_REGION_PRE='751' OR PP.ID_REGION_PP='751' )
GROUP BY PRE.ID_PRECIO
ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0020642280578613Tiempo acumulado:0.42455363273621
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT '2' as TIPO, PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PO.DESC_POBLACION, PRE.ID_PRECIO,
SECI.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR,
REI.ID_REGION, REI.URL URL_REGION, REI.DESC_REGION,
PP.ID_REGION_PP, PP.DESCRIPCION_PP,
PRE.MIN_PERS_PRE, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE,
PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION,PRE.FOTOPRINCIPAL_PRE,
PRE.GALERIA_PRE,EMPS.CENTRAL_ACTIVA, PRE.MULTIACTIVIDAD_PRE,
LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO_D,
PD.OFERTA_PD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%d') AS DIA_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%m') AS MES_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%Y') AS ANYO_CAD,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM,
TRUNCATE(AVG(OP.VALORACION),0) AS VALORACION, PD.OFERTA_PD,VALID_PD,
PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP,
PRECIO_UNITARIO_PRE
,IF ( PRE.MIN_PERS_PRE > MIN(PD.MIN_PERSONAS_PD)
AND PD.MIN_PERSONAS_PD IS NOT NULL, MIN(PD.MIN_PERSONAS_PD), PRE.MIN_PERS_PRE ) AS MIN_PERSONAS_PD
,IF ( PRE.MAX_PERS_PRE < MAX(PD.MAX_PERSONAS_PD)
AND PD.MAX_PERSONAS_PD IS NOT NULL, MAX(PD.MAX_PERSONAS_PD), PRE.MAX_PERS_PRE ) AS MAX_PERSONAS_PD
,IF(PD.PRECIO_PD > 0
AND PD.VALID_PD = 1, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
AND RC.VALID_RC NOT IN (0, 2, 6, 7)
LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND (EMP.VALID = 1 )
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON PRE.ID_PRECIO=PSS.ID_PRECIO_PSS
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
AND (SECI.FK_ID_IDIOMA_SI18N = 'it'
AND SECI.ID_TROPIC = 83)
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'it'
INNER JOIN LO_POBLACION_PT PO ON PRE.ID_POBLACION_PRE = PO.ID_POBLACION
AND PO.IDIOMA = 'it'
LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID = 1
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE 1 = 1
AND PRE.ID_PRECIO IN (75315)
AND PRE.VALID_PRE = 4
AND PSS.ID_ACTIVIDAD_PSS='207'
AND ( PRE.ID_REGION_PRE='751' OR PP.ID_REGION_PP='751' )
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0048849582672119Tiempo acumulado:0.42943859100342
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
WHERE PRE.ID_PRECIO = 75315;
Tiempo de la consulta:
0.000579833984375Tiempo acumulado:0.43001842498779
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[203]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 75315;
Tiempo de la consulta:
0.0025360584259033Tiempo acumulado:0.4325544834137
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_IT ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'it'
WHERE EMP.ID_EMPRESA = 19759933;
Tiempo de la consulta:
0.00053691864013672Tiempo acumulado:0.43309140205383
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[205]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '32'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
AND SECI.ID_TROPIC = 8;
Tiempo de la consulta:
0.00067496299743652Tiempo acumulado:0.43376636505127
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '32'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
AND SECI.ID_TROPIC = 83;
Tiempo de la consulta:
0.00049614906311035Tiempo acumulado:0.43426251411438
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19759933;
Tiempo de la consulta:
0.00036215782165527Tiempo acumulado:0.43462467193604
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19759936;
Tiempo de la consulta:
0.0011029243469238Tiempo acumulado:0.43572759628296
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: SELECT SECI.DESC_SECTOR,REI.URL,ID_EMPRESA,SECI.URL URL_SECTOR,EMP.ID_EMPRESA, SECI.ID_SECTOR, EMP.EMP_MADRE, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, GRU.ID_GRUPO
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_IT ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'it'
INNER JOIN LO_REGION RE ON EMP.ID_PROVINCIA=RE.ID_REGION
INNER JOIN LO_REGION_I18N REI ON RE.ID_REGION=REI.ID_REGION
AND REI.IDIOMA = 'it'
INNER JOIN LO_SECTORES SEC ON EMP.ID_SECTOR=SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
AND SECI.ID_TROPIC='83'
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND ( GRU.ID_TROPIC = 83)
WHERE
SECI.FK_ID_IDIOMA_SI18N='it'
AND EMP.ID_EMPRESA='19759936'
LIMIT 1;
Tiempo de la consulta:
0.00095295906066895Tiempo acumulado:0.43668055534363
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[210]: SELECT COUNT(*) AS NUMOPINIONES, (SUM(VALORACION) / COUNT(*)) /20 AS VALORACION
FROM LO_EMPRESAS_OPINIONES OP
LEFT JOIN LO_RESERVAS_COMPRAS RC ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
WHERE (OP.ID_EMPRESA = 19759933 OR OP.ID_MADRE = 19759933)
AND OP.VALID = 1;
Tiempo de la consulta:
0.002593994140625Tiempo acumulado:0.43927454948425
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[211]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19759933
AND VALID = 1;
Tiempo de la consulta:
0.0055129528045654Tiempo acumulado:0.44478750228882
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[212]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19759933
AND FOTO = 'e-19759936-logo-de-diverlanhoso164509659416450987638856.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00048279762268066Tiempo acumulado:0.4452702999115
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[213]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19759933
AND VALID = 1;
Tiempo de la consulta:
0.001121997833252Tiempo acumulado:0.44639229774475
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[214]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19759933
AND FOTO = 'e-19759933-salto-clasico-en-pendulo-portugal164510185016451018975630.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00053811073303223Tiempo acumulado:0.44693040847778
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[215]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19759933;
Tiempo de la consulta:
0.0023128986358643Tiempo acumulado:0.44924330711365
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[216]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19759933
AND VALID = 1;
Tiempo de la consulta:
0.00078606605529785Tiempo acumulado:0.45002937316895
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[217]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19759933
AND FOTO = 'e-19759933-salto-clasico-en-pendulo-portugal164510185016451018975630.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00049209594726562Tiempo acumulado:0.45052146911621
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[218]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19759933;
Tiempo de la consulta:
0.00039815902709961Tiempo acumulado:0.45091962814331
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[219]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19759933
AND VALID = 1;
Tiempo de la consulta:
0.0007472038269043Tiempo acumulado:0.45166683197021
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[220]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19759933
AND FOTO = 'e-19759933-salto-clasico-en-pendulo-portugal164510185016451018975630.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00054502487182617Tiempo acumulado:0.45221185684204
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[221]: SELECT SSF.DESC_SSF,SSF.ID_SSF,SS.INDEXA_SS, SS.ID_SUBFAM_SS
FROM LO_SUBSECTORES_FAM SSF
INNER JOIN LO_SUBSECTORES SS ON SS.ID_FAM_SS=SSF.ID_SSF
AND (SS.ID_TROPIC = 83)
INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON SS.ID_SUBSECTOR=PSS.ID_ACTIVIDAD_PSS
INNER JOIN LO_PRECIOS PRE ON PSS.ID_PRECIO_PSS = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
WHERE SS.ID_SECTOR_SS=32
AND SSF.ID_TROPIC = 83
GROUP BY SSF.ID_SSF
ORDER BY COUNT(SSF.ID_SSF) DESC;
Tiempo de la consulta:
0.0050811767578125Tiempo acumulado:0.45729303359985
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[222]: SELECT LSR.ID_SECTOR_RELACIONADO AS ID_SECTOR, SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, PRE.ID_PRECIO, PRE.FOTOPRINCIPAL_PRE
FROM LO_LANDING_SECTORES_RELACION LSR
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = LSR.ID_SECTOR_RELACIONADO
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
AND ID_TROPIC = 83
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_ACTIVIDAD_PS = LSR.ID_SECTOR_RELACIONADO
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PS.ID_PRECIO_PS
AND PRE.VALID_PRE = 4
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE LSR.ID_SECTOR = 32
AND (PRE.ID_REGION_PRE = 751 OR ID_REGION_PP = 751)
AND (PR.PROVINCIA = 0 OR PR.PROVINCIA IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL, CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d'))
AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'), CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d')), CONCAT((1+ DATE_FORMAT(NOW(), '%Y')),'-', DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y'),'-', DATE_FORMAT(NOW(), '%m-%d'))),1!=1))
GROUP BY LSR.ID_SECTOR_RELACIONADO;
Tiempo de la consulta:
0.0018348693847656Tiempo acumulado:0.45912790298462
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[223]: SELECT *, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, COUNT(PRE.ID_PRECIO) AS TOTAL_PRECIOS
FROM LO_SUBSECTORES SS
INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON PSS.ID_ACTIVIDAD_PSS = SS.ID_SUBSECTOR
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PSS.ID_PRECIO_PSS
AND PRE.VALID_PRE = 4
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND EMP.VALID = 1
LEFT JOIN LO_PRECIOS_POBLACIONES PPO ON PPO.ID_PRECIO = PRE.ID_PRECIO
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
INNER JOIN LO_PRECIOS_TRADUCCION_IT PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'it'
WHERE SS.ID_TROPIC = 83
AND SS.ID_FAM_SS IN (945,946)
AND 1=1
AND (PRE.ID_REGION_PRE = 751 OR (PP.ID_REGION_PP = 751
AND PP.ID_POBLACION_PP IS NULL ))
AND SHOW_LANDING = 1
GROUP BY ID_SUBSECTOR
ORDER BY ORDER_LANDING ASC;
Tiempo de la consulta:
0.038899183273315Tiempo acumulado:0.49802708625793
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[224]: SELECT URL AS URL_REGION, SIMCAPN, ID_CAPITAL
FROM LO_REGION_I18N REI
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE REI.ID_REGION = 751
AND REI.IDIOMA = 'pt'
AND SIMCAPN = 1;
Tiempo de la consulta:
0.00061893463134766Tiempo acumulado:0.49864602088928
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[225]: SELECT PRE.FOTOPRINCIPAL_PRE, PRE.ID_PRECIO
FROM LO_PRECIOS_SUBSECTORES PSS
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PSS.ID_PRECIO_PSS
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA =PRE.ID_EMPRESA_PRE
AND EMP.VALID = 1
INNER JOIN LO_REGION RE ON PRE.ID_REGION_PRE=RE.ID_REGION
LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND 1=1
AND (PRE.ID_REGION_PRE = 751 OR (PP.ID_REGION_PP = 751
AND PP.ID_POBLACION_PP IS NULL ))
AND PSS.ID_ACTIVIDAD_PSS = 207
LIMIT 1;;
Tiempo de la consulta:
0.00097799301147461Tiempo acumulado:0.49962401390076
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[226]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 75315
AND VALID = 1;
Tiempo de la consulta:
0.00063395500183105Tiempo acumulado:0.50025796890259
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[227]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 75315
AND FOTO = 'p-75315-caida-libre-en-salto-de-bungee1645113232_16451133073723.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00044989585876465Tiempo acumulado:0.50070786476135
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[228]: SELECT SEOHOME.TITLE, SEOHOME.METADESCRIPTION,SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT
FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
WHERE SEOHOME.ID_TROPIC = 83
AND SEOHOME.ID_KEY='SS207'
AND SEO_VALID in(0,1)
AND SEOHOME.ID_LOCALIZACION='751';
Tiempo de la consulta:
0.0074961185455322Tiempo acumulado:0.50820398330688
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[229]: SELECT SS.ID_SUBSECTOR, N_OFERTAS AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, SS.DESC_SS AS DESC_SECTOR, SS.URL_SS AS URL_SECTOR, PO.DESC_POBLACION, PO.URL_POBLACION, PO.ID_POBLACION, RE.ID_REGION_ADM1, RE.ID_PAIS
FROM
LO_POBLACION_PT_STATS PS
INNER JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PS.ID_POBLACION
AND PO.IDIOMA = 'it'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
AND REI.IDIOMA = 'it'
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
AND IF(RE.ID_CAPITAL = PO.ID_POBLACION
AND RE.SIMCAPN = 1, 1=2, 1=1)
INNER JOIN LO_SUBSECTORES SS ON PS.ID_SUBSECTOR = SS.ID_SUBSECTOR
AND SS.ID_TROPIC ='83'
AND SS.INDEXA_SS = 1
WHERE
REI.ID_REGION = 751
AND PS.ID_SUBSECTOR = 207
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
AND (PS.ID_GRUPO = 0 OR PS.ID_GRUPO IS NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.0027370452880859Tiempo acumulado:0.51094102859497
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[230]: SELECT URL AS URL_REGION, SIMCAPN, ID_CAPITAL
FROM LO_REGION_I18N REI
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE REI.ID_REGION = 751
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00049805641174316Tiempo acumulado:0.51143908500671
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[231]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 81109
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00036907196044922Tiempo acumulado:0.51180815696716
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[232]: SELECT REI.DESC_REGION, REI.URL AS URL_REGION, PO.DESC_POBLACION, PO.URL_POBLACION, POS.N_OFERTAS
FROM LO_POBLACION_REGION_MULTIPLE PRM
INNER JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PRM.ID_POBLACION
AND PO.IDIOMA = 'it'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
AND REI.IDIOMA = 'it'
INNER JOIN LO_POBLACION_PT_STATS POS ON POS.ID_POBLACION = PO.ID_POBLACION
AND POS.ID_SECTOR = 32
AND POS.N_OFERTAS > 1
WHERE PRM.ID_REGION = 751;
Tiempo de la consulta:
0.001209020614624Tiempo acumulado:0.51301717758179
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[233]: SELECT SECI.ID_SECTOR, N_OFERTAS AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, SECI.DESC_SECTOR, SECI.URL as URL_SECTOR, RE.ID_REGION_ADM1, SEC.ID_GRUPO, RE.ID_PAIS
FROM
LO_REGION_STATS PS
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PS.ID_REGION
AND REI.IDIOMA = 'it'
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_SECTOR
AND SEC.ID_GRUPO = 4
INNER JOIN LO_SECTORES_I18N SECI ON PS.ID_SECTOR = SECI.ID_SECTOR
AND SECI.ID_TROPIC='83'
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
WHERE
REI.ID_REGION = 751
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.000946044921875Tiempo acumulado:0.51396322250366
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[234]: SELECT COUNT(*) AS NEMPRESAS
FROM LO_REGION_STATS
WHERE ID_REGION = 751
AND ID_GRUPO = 4;
Tiempo de la consulta:
0.00050497055053711Tiempo acumulado:0.5144681930542
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[235]: SELECT '1', RE.ID_REGION, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, RE.ID_REGION_ADM1, RE.ID_PAIS, LATITUDE, LONGITUDE
FROM LO_REGION RE
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
WHERE RE.ID_REGION = '751'
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00050210952758789Tiempo acumulado:0.51497030258179
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[236]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S21'
AND (SEO.ID_TROPIC = 83
);
Tiempo de la consulta:
0.00043511390686035Tiempo acumulado:0.51540541648865
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[237]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S32'
AND (SEO.ID_TROPIC = 83
);
Tiempo de la consulta:
0.00043392181396484Tiempo acumulado:0.51583933830261
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[238]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S50'
AND (SEO.ID_TROPIC = 83
);
Tiempo de la consulta:
0.00041413307189941Tiempo acumulado:0.51625347137451
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[239]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S122'
AND (SEO.ID_TROPIC = 83
);
Tiempo de la consulta:
0.00039100646972656Tiempo acumulado:0.51664447784424
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[240]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S3'
AND (SEO.ID_TROPIC = 83
);
Tiempo de la consulta:
0.00037622451782227Tiempo acumulado:0.51702070236206
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[241]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S39'
AND (SEO.ID_TROPIC = 83
);
Tiempo de la consulta:
0.00040221214294434Tiempo acumulado:0.517422914505
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[242]: SELECT *
FROM LO_REGION
INNER JOIN LO_REGION_I18N ON LO_REGION.ID_REGION = LO_REGION_I18N.ID_REGION
WHERE IDIOMA = 'it'
ORDER BY DESC_REGION ASC;
Tiempo de la consulta:
0.00068092346191406Tiempo acumulado:0.51810383796692
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[243]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 83;
Tiempo de la consulta:
0.0017621517181396Tiempo acumulado:0.51986598968506
