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->gb_it
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->visite-guidate
filtro2->lisbona
filtro3->mafra
rel_alternate->1
paginado_ofertas->
npage->
Total queries: 326
Tiempo total: 0.66102075576782
>0.1 and < 2 (1)
(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.0069258213043213Tiempo acumulado:0.0069258213043213
(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.00055718421936035Tiempo acumulado:0.0074830055236816
(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 = 'lisbona'
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 = 'lisbona' 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 = 'lisbona'
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 = 'lisbona' 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 = 'lisbona'
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 = 'lisbona' 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 = 'lisbona'
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 = 'lisbona' 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 = 'lisbona'
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 = 'lisbona' 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 = 'lisbona'
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 = 'lisbona' )AS FIND_REGION
GROUP BY ID_PAIS;
Tiempo de la consulta:
0.004141092300415Tiempo acumulado:0.011624097824097
(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.0068531036376953Tiempo acumulado:0.018477201461792
(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.0003969669342041Tiempo acumulado:0.018874168395996
(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.00032305717468262Tiempo acumulado:0.019197225570679
(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.00051307678222656Tiempo acumulado:0.019710302352905
(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.0003511905670166Tiempo acumulado:0.020061492919922
(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.00036001205444336Tiempo acumulado:0.020421504974365
(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 = 'filtro3';
Tiempo de la consulta:
0.0003349781036377Tiempo acumulado:0.020756483078003
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[11]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'rel_alternate';
Tiempo de la consulta:
0.0005650520324707Tiempo acumulado:0.021321535110474
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[12]: SELECT G.DESC_GRUPO, G.ID_GRUPO, G.URL AS URL_GRUPO
FROM LO_GRUPOS G
WHERE G.URL = 'visite-guidate'
AND G.ID_TROPIC = 83;
Tiempo de la consulta:
0.0019471645355225Tiempo acumulado:0.023268699645996
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[13]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.URL = 'lisbona'
AND IDIOMA = 'it';
Tiempo de la consulta:
0.0023798942565918Tiempo acumulado:0.025648593902588
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[14]: 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 = 'lisbona'
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00043702125549316Tiempo acumulado:0.026085615158081
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[15]: 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 = 'lisbona'
AND IDIOMA = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00044894218444824Tiempo acumulado:0.026534557342529
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: 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 = 'visite-guidate'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.0019187927246094Tiempo acumulado:0.028453350067139
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[17]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
FROM LO_POBLACION_PT PO
WHERE ID_REGION='760'
AND ID_POBLACION='mafra'
AND IDIOMA = 'it'
LIMIT 1;
Tiempo de la consulta:
0.0020649433135986Tiempo acumulado:0.030518293380737
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[18]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
FROM LO_POBLACION_PT PO
WHERE ID_REGION='760'
AND URL_POBLACION='mafra'
AND IDIOMA = 'it'
LIMIT 1;
Tiempo de la consulta:
0.003183126449585Tiempo acumulado:0.033701419830322
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[19]: SELECT ORDER_LANDING
FROM LO_SECTORES SEC
WHERE ID_SECTOR = 111;
Tiempo de la consulta:
0.00034189224243164Tiempo acumulado:0.034043312072754
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[20]: SELECT GRU.URL URL_GRUPO, GRU.DESC_GRUPO, ID_GRUPO
FROM LO_GRUPOS GRU
WHERE GRU.ID_GRUPO = 4
AND (GRU.ID_TROPIC = 83);
Tiempo de la consulta:
0.00038290023803711Tiempo acumulado:0.034426212310791
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[21]: SELECT *
FROM LO_SEO_KEYWORDS_LANDING SKL
WHERE SKL.ID_SECTOR = 111
AND ID_TROPIC = 83;
Tiempo de la consulta:
0.0035619735717773Tiempo acumulado:0.037988185882568
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[22]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
FROM LO_POBLACION_PT PO
WHERE ID_REGION='760'
AND ID_POBLACION='77521'
AND IDIOMA = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00037598609924316Tiempo acumulado:0.038364171981812
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[23]: SELECT *
FROM LO_REGION_SKI REI
WHERE URL = 'lisbona'
AND REI.IDIOMA='it'
AND TIPO = 1;
Tiempo de la consulta:
0.0008389949798584Tiempo acumulado:0.03920316696167
(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 = 760
LIMIT 1;
Tiempo de la consulta:
0.00051498413085938Tiempo acumulado:0.039718151092529
(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
LEFT JOIN LO_POBLACION PO ON PO.ID_POBLACION = EMP.ID_POBLACION
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 = 760
AND EMP.EMP_MADRE <> 0
AND PO.ID_POBLACION = 77521
AND EMP.ID_SECTOR = 111
GROUP BY EMP.NOMBRE HAVING ID_EMPRESA IN (SELECT /*IF (EMP.EMP_MADRE = 3, ID_MADRE,*/ ID_EMPRESA AS ID_P
FROM LO_EMPRESAS EMP
WHERE EMP.ID_PROVINCIA = 760)
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.013225078582764Tiempo acumulado:0.052943229675293
(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.00028419494628906Tiempo acumulado:0.053227424621582
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[27]: 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_POBLACION_PT_STATS
WHERE ID_POBLACION = 77521
AND ID_SECTOR = 111
GROUP BY ID_SECTOR;
Tiempo de la consulta:
0.0010550022125244Tiempo acumulado:0.054282426834106
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[28]: 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 = '111'
AND (PRE.ID_POBLACION_PRE = 77521 OR ID_POBLACION_PP = 77521 )
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.035892963409424Tiempo acumulado:0.09017539024353
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[29]: SELECT SEO.DESCRIPTION
FROM LO_SEO_DESCRIPTIONS SEO
WHERE SEO.ID_TROPIC='83'
AND SEO.ID_KEY='S111';
Tiempo de la consulta:
0.015571117401123Tiempo acumulado:0.10574650764465
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[30]: SELECT SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT, SEOHOME.CONTENT_MANAGER, DATE_FORMAT(SEOHOME.FEC_INSERT, '%d/%m/%Y %H:%i') FECHA_INSERT, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d/%m/%Y %H:%i') FECHA_MOD, CA.NOMBRE, CA.ID,DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y-%m-%dT%H:%i') IN_GOOGLE,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y-%m-%dT%H:%i') MOD_GOOGLE,AU.ID_ADMIN, GALERIA, GALERIA_DESC, CA.JOB,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%d') DAY_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%m') MONTH_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y') YEAR_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%H:%i') HORA_INSERT,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d') DAY_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%m') MONTH_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y') YEAR_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%H:%i') HORA_MOD
FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
LEFT JOIN LO_ADMIN_USERS AU ON AU.LOGIN = SEOHOME.CONTENT_MANAGER
LEFT JOIN LO_CONTENIDO_AUTORES CA ON CA.ID_ADMIN = AU.ID_ADMIN
AND CA.ID_TROPIC = 83
WHERE SEOHOME.ID_TROPIC = 83
AND SEOHOME.ID_KEY = 'S111'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='77521';
Tiempo de la consulta:
0.012270927429199Tiempo acumulado:0.11801743507385
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[31]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00052595138549805Tiempo acumulado:0.11854338645935
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[32]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 77521
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00095701217651367Tiempo acumulado:0.11950039863586
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[33]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/it/visite-guidate/lisbona/mafra';
Tiempo de la consulta:
0.0010528564453125Tiempo acumulado:0.12055325508118
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[34]: SELECT *
FROM LO_SEO_DESCRIPTIONS_HOME SEO
WHERE SEO.ID_TROPIC='83'
AND SEO.ID_KEY='S111'
AND SEO.ID_LOCALIZACION='77521';
Tiempo de la consulta:
0.027223110198975Tiempo acumulado:0.14777636528015
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[35]: SELECT TITLE, DESCRIPTION, KEYWORDS, ID_KEY
FROM LO_SEO_HEADERS SEO
WHERE SEO.ID_TROPIC='83'
AND VALID='1'
AND SEO.ID_KEY='S111';
Tiempo de la consulta:
0.015674829483032Tiempo acumulado:0.16345119476318
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[36]: 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 = 'visite-guidate'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00071191787719727Tiempo acumulado:0.16416311264038
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[37]: 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.00053596496582031Tiempo acumulado:0.1646990776062
(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'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050091743469238Tiempo acumulado:0.16519999504089
(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_id_tropic_trad'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005030632019043Tiempo acumulado:0.1657030582428
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[40]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=111
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
AND SECI.ID_TROPIC=8;
Tiempo de la consulta:
0.00054407119750977Tiempo acumulado:0.16624712944031
(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_Regiones'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047612190246582Tiempo acumulado:0.16672325134277
(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_Language_Regiones'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049805641174316Tiempo acumulado:0.16722130775452
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[43]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'lisbona'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00045895576477051Tiempo acumulado:0.16768026351929
(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_Language_Regiones'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048589706420898Tiempo acumulado:0.1681661605835
(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_Language_Regiones'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050497055053711Tiempo acumulado:0.16867113113403
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[46]: 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_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.022450923919678Tiempo acumulado:0.19112205505371
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[47]: 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=760
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00071191787719727Tiempo acumulado:0.19183397293091
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[48]: 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.050858020782471Tiempo acumulado:0.24269199371338
(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', 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.011651992797852Tiempo acumulado:0.25434398651123
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
FROM LO_POBLACION PO, LO_POBLACION_PT POI
WHERE POI.URL_POBLACION='mafra'
AND POI.ID_REGION='760'
AND IDIOMA = 'it'
AND POI.ID_POBLACION=PO.ID_POBLACION
ORDER BY PO.ID_POBLACION;
Tiempo de la consulta:
0.0010929107666016Tiempo acumulado:0.25543689727783
(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', 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.00054788589477539Tiempo acumulado:0.25598478317261
(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', 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.00063896179199219Tiempo acumulado:0.2566237449646
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[53]: 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_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055289268493652Tiempo acumulado:0.25717663764954
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[54]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
WHERE PO.ID_POBLACION = POI.ID_POBLACION
AND PO.ID_POBLACION=77521
AND POI.IDIOMA = 'pt';
Tiempo de la consulta:
0.0022339820861816Tiempo acumulado:0.25941061973572
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[55]: 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 = 'visite-guidate'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.002187967300415Tiempo acumulado:0.26159858703613
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[56]: 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.00061202049255371Tiempo acumulado:0.26221060752869
(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_Language'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0079250335693359Tiempo acumulado:0.27013564109802
(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.00068116188049316Tiempo acumulado:0.27081680297852
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[59]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=111
AND SECI.FK_ID_IDIOMA_SI18N = 'en'
AND SECI.ID_TROPIC=82;
Tiempo de la consulta:
0.0037999153137207Tiempo acumulado:0.27461671829224
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[60]: 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.0005640983581543Tiempo acumulado:0.27518081665039
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[61]: 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.00052213668823242Tiempo acumulado:0.27570295333862
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[62]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'lisbona'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00073909759521484Tiempo acumulado:0.27644205093384
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[63]: 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.00068211555480957Tiempo acumulado:0.27712416648865
(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_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.00060200691223145Tiempo acumulado:0.27772617340088
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00069499015808105Tiempo acumulado:0.27842116355896
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[66]: 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=760
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'en';
Tiempo de la consulta:
0.00089406967163086Tiempo acumulado:0.27931523323059
(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_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.00053286552429199Tiempo acumulado:0.27984809875488
(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_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.00058794021606445Tiempo acumulado:0.28043603897095
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[69]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
FROM LO_POBLACION PO, LO_POBLACION_PT POI
WHERE POI.URL_POBLACION='mafra'
AND POI.ID_REGION='760'
AND IDIOMA = 'it'
AND POI.ID_POBLACION=PO.ID_POBLACION
ORDER BY PO.ID_POBLACION;
Tiempo de la consulta:
0.0041539669036865Tiempo acumulado:0.28459000587463
(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_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.0012500286102295Tiempo acumulado:0.28584003448486
(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_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.00061798095703125Tiempo acumulado:0.28645801544189
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[72]: 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_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00087904930114746Tiempo acumulado:0.28733706474304
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[73]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
WHERE PO.ID_POBLACION = POI.ID_POBLACION
AND PO.ID_POBLACION=77521
AND POI.IDIOMA = 'en';
Tiempo de la consulta:
0.00095295906066895Tiempo acumulado:0.28829002380371
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[74]: 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 = 'visite-guidate'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00083398818969727Tiempo acumulado:0.28912401199341
(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_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.00050187110900879Tiempo acumulado:0.28962588310242
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[76]: 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.00056600570678711Tiempo acumulado:0.2901918888092
(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_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.00055408477783203Tiempo acumulado:0.29074597358704
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[78]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=111
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
AND SECI.ID_TROPIC=84;
Tiempo de la consulta:
0.002051830291748Tiempo acumulado:0.29279780387878
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[79]: 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.0015149116516113Tiempo acumulado:0.2943127155304
(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_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.00055384635925293Tiempo acumulado:0.29486656188965
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[81]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'lisbona'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00049185752868652Tiempo acumulado:0.29535841941833
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[82]: 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.00049400329589844Tiempo acumulado:0.29585242271423
(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_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.00052809715270996Tiempo acumulado:0.29638051986694
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00062704086303711Tiempo acumulado:0.29700756072998
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[85]: 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=760
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00061798095703125Tiempo acumulado:0.29762554168701
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[86]: 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.00052094459533691Tiempo acumulado:0.29814648628235
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[87]: 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.00060606002807617Tiempo acumulado:0.29875254631042
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[88]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
FROM LO_POBLACION PO, LO_POBLACION_PT POI
WHERE POI.URL_POBLACION='mafra'
AND POI.ID_REGION='760'
AND IDIOMA = 'it'
AND POI.ID_POBLACION=PO.ID_POBLACION
ORDER BY PO.ID_POBLACION;
Tiempo de la consulta:
0.00072789192199707Tiempo acumulado:0.29948043823242
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[89]: 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.00055599212646484Tiempo acumulado:0.30003643035889
(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_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.00053215026855469Tiempo acumulado:0.30056858062744
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049591064453125Tiempo acumulado:0.30106449127197
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[92]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
WHERE PO.ID_POBLACION = POI.ID_POBLACION
AND PO.ID_POBLACION=77521
AND POI.IDIOMA = 'fr';
Tiempo de la consulta:
0.002072811126709Tiempo acumulado:0.30313730239868
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[93]: 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 = 'visite-guidate'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.0006718635559082Tiempo acumulado:0.30380916595459
(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_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.00053119659423828Tiempo acumulado:0.30434036254883
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[95]: 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.00050806999206543Tiempo acumulado:0.30484843254089
(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_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.00050783157348633Tiempo acumulado:0.30535626411438
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[97]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=111
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC=81;
Tiempo de la consulta:
0.00054812431335449Tiempo acumulado:0.30590438842773
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[98]: 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.00046896934509277Tiempo acumulado:0.30637335777283
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[99]: 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.00048112869262695Tiempo acumulado:0.30685448646545
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[100]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'lisbona'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00050210952758789Tiempo acumulado:0.30735659599304
(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_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.00046396255493164Tiempo acumulado:0.30782055854797
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[102]: 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.0005028247833252Tiempo acumulado:0.3083233833313
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050997734069824Tiempo acumulado:0.308833360672
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[104]: 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=760
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00048208236694336Tiempo acumulado:0.30931544303894
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[105]: 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.00045609474182129Tiempo acumulado:0.30977153778076
(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_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.00048995018005371Tiempo acumulado:0.31026148796082
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[107]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
FROM LO_POBLACION PO, LO_POBLACION_PT POI
WHERE POI.URL_POBLACION='mafra'
AND POI.ID_REGION='760'
AND IDIOMA = 'it'
AND POI.ID_POBLACION=PO.ID_POBLACION
ORDER BY PO.ID_POBLACION;
Tiempo de la consulta:
0.00064301490783691Tiempo acumulado:0.31090450286865
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[108]: 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.00047016143798828Tiempo acumulado:0.31137466430664
(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_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.00049710273742676Tiempo acumulado:0.31187176704407
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051403045654297Tiempo acumulado:0.31238579750061
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[111]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
WHERE PO.ID_POBLACION = POI.ID_POBLACION
AND PO.ID_POBLACION=77521
AND POI.IDIOMA = 'es';
Tiempo de la consulta:
0.0010700225830078Tiempo acumulado:0.31345582008362
(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 = 'visite-guidate'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00066900253295898Tiempo acumulado:0.31412482261658
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[113]: 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.00046896934509277Tiempo acumulado:0.31459379196167
(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_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.00046801567077637Tiempo acumulado:0.31506180763245
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[115]: 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.00044703483581543Tiempo acumulado:0.31550884246826
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[116]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=111
AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
AND SECI.ID_TROPIC=86;
Tiempo de la consulta:
0.00047802925109863Tiempo acumulado:0.31598687171936
(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_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.00043416023254395Tiempo acumulado:0.3164210319519
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[118]: 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.00043702125549316Tiempo acumulado:0.3168580532074
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[119]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'lisbona'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.0004889965057373Tiempo acumulado:0.31734704971313
(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_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.00043106079101562Tiempo acumulado:0.31777811050415
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[121]: 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.00042510032653809Tiempo acumulado:0.31820321083069
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004420280456543Tiempo acumulado:0.31864523887634
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[123]: 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=760
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'ch';
Tiempo de la consulta:
0.00049185752868652Tiempo acumulado:0.31913709640503
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[124]: 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.0004580020904541Tiempo acumulado:0.31959509849548
(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_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.00044798851013184Tiempo acumulado:0.32004308700562
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[126]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
FROM LO_POBLACION PO, LO_POBLACION_PT POI
WHERE POI.URL_POBLACION='mafra'
AND POI.ID_REGION='760'
AND IDIOMA = 'it'
AND POI.ID_POBLACION=PO.ID_POBLACION
ORDER BY PO.ID_POBLACION;
Tiempo de la consulta:
0.00051712989807129Tiempo acumulado:0.32056021690369
(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_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.0004429817199707Tiempo acumulado:0.32100319862366
(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_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.00045418739318848Tiempo acumulado:0.32145738601685
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046205520629883Tiempo acumulado:0.32191944122314
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[130]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
WHERE PO.ID_POBLACION = POI.ID_POBLACION
AND PO.ID_POBLACION=77521
AND POI.IDIOMA = 'ch';
Tiempo de la consulta:
0.00099396705627441Tiempo acumulado:0.32291340827942
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[131]: 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 = 'visite-guidate'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00066590309143066Tiempo acumulado:0.32357931137085
(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_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.00044703483581543Tiempo acumulado:0.32402634620667
(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_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.00043416023254395Tiempo acumulado:0.32446050643921
(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_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.0004270076751709Tiempo acumulado:0.32488751411438
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[135]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=111
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC=87;
Tiempo de la consulta:
0.00047612190246582Tiempo acumulado:0.32536363601685
(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_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.00045204162597656Tiempo acumulado:0.32581567764282
(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_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.0004420280456543Tiempo acumulado:0.32625770568848
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[138]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'lisbona'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00042200088500977Tiempo acumulado:0.32667970657349
(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_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.00047993659973145Tiempo acumulado:0.32715964317322
(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_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.00043582916259766Tiempo acumulado:0.32759547233582
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004420280456543Tiempo acumulado:0.32803750038147
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[142]: 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=760
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.00038695335388184Tiempo acumulado:0.32842445373535
(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_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.0004429817199707Tiempo acumulado:0.32886743545532
(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_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.00042200088500977Tiempo acumulado:0.32928943634033
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[145]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
FROM LO_POBLACION PO, LO_POBLACION_PT POI
WHERE POI.URL_POBLACION='mafra'
AND POI.ID_REGION='760'
AND IDIOMA = 'it'
AND POI.ID_POBLACION=PO.ID_POBLACION
ORDER BY PO.ID_POBLACION;
Tiempo de la consulta:
0.00052189826965332Tiempo acumulado:0.32981133460999
(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_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.00045108795166016Tiempo acumulado:0.33026242256165
(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_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.0004570484161377Tiempo acumulado:0.33071947097778
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043606758117676Tiempo acumulado:0.33115553855896
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[149]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
WHERE PO.ID_POBLACION = POI.ID_POBLACION
AND PO.ID_POBLACION=77521
AND POI.IDIOMA = 'de';
Tiempo de la consulta:
0.0018670558929443Tiempo acumulado:0.3330225944519
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[150]: 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 = 'visite-guidate'
AND ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
LIMIT 1;
Tiempo de la consulta:
0.00064802169799805Tiempo acumulado:0.3336706161499
(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_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.00049090385437012Tiempo acumulado:0.33416152000427
(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_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.00043702125549316Tiempo acumulado:0.33459854125977
(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_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.33513760566711
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[154]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=111
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC=85;
Tiempo de la consulta:
0.00046110153198242Tiempo acumulado:0.3355987071991
(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_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.00047993659973145Tiempo acumulado:0.33607864379883
(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_Language_Regiones'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044107437133789Tiempo acumulado:0.33651971817017
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[157]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'lisbona'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00043010711669922Tiempo acumulado:0.33694982528687
(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_Language_Regiones'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044393539428711Tiempo acumulado:0.33739376068115
(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_Language_Regiones'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042080879211426Tiempo acumulado:0.33781456947327
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041890144348145Tiempo acumulado:0.33823347091675
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[161]: 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=760
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.0013980865478516Tiempo acumulado:0.3396315574646
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[162]: 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.00046515464782715Tiempo acumulado:0.34009671211243
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[163]: 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.00043106079101562Tiempo acumulado:0.34052777290344
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[164]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
FROM LO_POBLACION PO, LO_POBLACION_PT POI
WHERE POI.URL_POBLACION='mafra'
AND POI.ID_REGION='760'
AND IDIOMA = 'it'
AND POI.ID_POBLACION=PO.ID_POBLACION
ORDER BY PO.ID_POBLACION;
Tiempo de la consulta:
0.00050020217895508Tiempo acumulado:0.3410279750824
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[165]: 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.00043797492980957Tiempo acumulado:0.34146595001221
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[166]: 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.0004119873046875Tiempo acumulado:0.34187793731689
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[167]: 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_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041699409484863Tiempo acumulado:0.34229493141174
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[168]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
WHERE PO.ID_POBLACION = POI.ID_POBLACION
AND PO.ID_POBLACION=77521
AND POI.IDIOMA = 'es';
Tiempo de la consulta:
0.00040006637573242Tiempo acumulado:0.34269499778748
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[169]: 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.00042200088500977Tiempo acumulado:0.34311699867249
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[170]: 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.00045490264892578Tiempo acumulado:0.34357190132141
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[171]: 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.00040602684020996Tiempo acumulado:0.34397792816162
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[172]: 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.00040984153747559Tiempo acumulado:0.3443877696991
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[173]: 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.00041508674621582Tiempo acumulado:0.34480285644531
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[174]: 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.00040793418884277Tiempo acumulado:0.34521079063416
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[175]: 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.00042510032653809Tiempo acumulado:0.34563589096069
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[176]: 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.00042200088500977Tiempo acumulado:0.3460578918457
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[177]: 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.00042080879211426Tiempo acumulado:0.34647870063782
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[178]: 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.0004570484161377Tiempo acumulado:0.34693574905396
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[179]: 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.00041007995605469Tiempo acumulado:0.34734582901001
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[180]: 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.00050687789916992Tiempo acumulado:0.34785270690918
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[181]: 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.00049090385437012Tiempo acumulado:0.34834361076355
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[182]: 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.00043702125549316Tiempo acumulado:0.34878063201904
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[183]: 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.00041985511779785Tiempo acumulado:0.34920048713684
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[184]: 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.00041389465332031Tiempo acumulado:0.34961438179016
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[185]: 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.00041413307189941Tiempo acumulado:0.35002851486206
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[186]: 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.0004279613494873Tiempo acumulado:0.35045647621155
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[187]: 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.00042390823364258Tiempo acumulado:0.35088038444519
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[188]: 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.00060200691223145Tiempo acumulado:0.35148239135742
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[189]: 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.00048685073852539Tiempo acumulado:0.35196924209595
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[190]: 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.00043201446533203Tiempo acumulado:0.35240125656128
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[191]: 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.00042009353637695Tiempo acumulado:0.35282135009766
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[192]: 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.00042200088500977Tiempo acumulado:0.35324335098267
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[193]: 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.00041508674621582Tiempo acumulado:0.35365843772888
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[194]: 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.00041103363037109Tiempo acumulado:0.35406947135925
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[195]: 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.00043010711669922Tiempo acumulado:0.35449957847595
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[196]: 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.00043606758117676Tiempo acumulado:0.35493564605713
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[197]: 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.00042104721069336Tiempo acumulado:0.35535669326782
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[198]: 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.00043916702270508Tiempo acumulado:0.35579586029053
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[199]: 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.00046992301940918Tiempo acumulado:0.35626578330994
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[200]: 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.0004420280456543Tiempo acumulado:0.35670781135559
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[201]: 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.00048494338989258Tiempo acumulado:0.35719275474548
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[202]: 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.00043892860412598Tiempo acumulado:0.35763168334961
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[203]: 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.00048398971557617Tiempo acumulado:0.35811567306519
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[204]: 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.00046110153198242Tiempo acumulado:0.35857677459717
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[205]: 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.00043702125549316Tiempo acumulado:0.35901379585266
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: SELECT *
FROM LO_REGION_STATS RS
WHERE RS.ID_SECTOR = 111
AND RS.ID_REGION = 760
AND ID_GRUPO = 0
AND ID_SUBSECTOR = 0
AND N_OFERTAS > 0;
Tiempo de la consulta:
0.0011420249938965Tiempo acumulado:0.36015582084656
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 48
AND IDIOMA = 'it';
Tiempo de la consulta:
0.00040698051452637Tiempo acumulado:0.36056280136108
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.0003662109375Tiempo acumulado:0.36092901229858
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 77521
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00036096572875977Tiempo acumulado:0.36128997802734
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[210]: SELECT (N_OFERTAS)+(N_EMPRESAS) AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas,
PS.ID_POBLACION,
IF ( MEDIA_AJUSTADA IS NOT NULL
AND MEDIA_AJUSTADA != 0
AND MEDIA_AJUSTADA < MEDIA_PRECIO, MEDIA_AJUSTADA, MEDIA_PRECIO ) AS MEDIA, N_OPIS
FROM
LO_POBLACION_PT_STATS PS
WHERE (IF(ISNULL(PS.N_OFERTAS),0,PS.N_OFERTAS) > 0 OR IF(ISNULL(PS.N_EMPRESAS),0,PS.N_EMPRESAS) > 0 )
AND PS.ID_POBLACION = 77521
AND PS.ID_SECTOR = 111
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.00041007995605469Tiempo acumulado:0.3617000579834
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[211]: 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='S111'
AND SEOHOME.ID_LOCALIZACION='77521';
Tiempo de la consulta:
0.0070178508758545Tiempo acumulado:0.36871790885925
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[212]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0010240077972412Tiempo acumulado:0.36974191665649
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[213]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0003349781036377Tiempo acumulado:0.37007689476013
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[214]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
FROM LO_POBLACION_PT_STATS
WHERE ID_POBLACION = 77521
AND ID_SECTOR = 111;
Tiempo de la consulta:
0.0003669261932373Tiempo acumulado:0.37044382095337
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[215]: 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_SECTORES PSEC ON PSEC.ID_PRECIO_PS = 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 PSEC.ID_ACTIVIDAD_PS = 111
AND PRE.ID_POBLACION_PRE ='77521'
UNION ALL
SELECT MIN(PD.PRECIO_PD) MIN_PRECIO, MAX(PD.PRECIO_PD) MAX_PRECIO
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_SECTORES PSEC ON PSEC.ID_PRECIO_PS = 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 PSEC.ID_ACTIVIDAD_PS = 111
AND PRE.ID_POBLACION_PRE ='77521'
/* 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_SECTORES PSEC ON PSEC.ID_PRECIO_PS = PRE.ID_PRECIO
WHERE EMP.VALID IN (1 )
AND EMP.PRECIO_ACTIVIDAD !=0
AND PSEC.ID_ACTIVIDAD_PS = 111
AND PRE.ID_POBLACION_PRE ='77521'
*/ ) AS PRECIO_MIN_MAX;
Tiempo de la consulta:
0.0036389827728271Tiempo acumulado:0.3740828037262
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[216]: SELECT *
FROM LO_SEO_KEYWORDS_LANDING SKL
WHERE SKL.ID_SECTOR = 111
AND SKL.ID_TROPIC = 83;
Tiempo de la consulta:
0.00042891502380371Tiempo acumulado:0.37451171875
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[217]: SELECT '1' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_POBLACION_PP = 77521,1,IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', 2, 0)) AS ES_PUBLI , IF (PRE.N_ORDER_VENTAS_TROPIC = '0.0', PCER.DISTANCIA_REAL +10000, PCER.DISTANCIA_REAL) AS DIST_REAL, PCER.DISTANCIA_REAL, PCER.DISTANCIA, PCER.DURACION , IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', null, PR.PRIORIZA_ORDEN) AS PRIO_ORDEN , PRE.ID_PRECIO
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
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 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 OR RE.ID_REGION = PP.ID_REGION_PP
LEFT JOIN LO_POBLACION_CERCANAS PCER ON PCER.ID_POBLACION_CERCANA = PRE.ID_POBLACION_PRE
AND PCER.ID_POBLACION = 77521
/*
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_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID = 1
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE*/
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND (PS.ID_ACTIVIDAD_PS = 111 OR (ID_SECTOR_PP = 111
AND PP.ID_POBLACION_PP = 77521))
AND (PRE.ID_POBLACION_PRE = 77521 OR ID_POBLACION_PP = 77521)
AND (PRE.ID_POBLACION_PRE =77521 OR ID_POBLACION_PP = 77521 )
AND (PR.POBLACION = 0 OR PR.POBLACION 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 PRE.ID_PRECIO
ORDER BY PRIO_ORDEN DESC, ES_PUBLI ASC , DIST_REAL ASC , PT.N_ORDER_VENTAS_TROPIC DESC ,PRE.ID_PRECIO ASC
LIMIT 20;
Tiempo de la consulta (slow_query): 0.11442685127258Tiempo acumulado:0.48893857002258
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[218]: SELECT count(*) as NOFERTAS
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
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 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 OR RE.ID_REGION = PP.ID_REGION_PP
LEFT JOIN LO_POBLACION_CERCANAS PCER ON PCER.ID_POBLACION_CERCANA = PRE.ID_POBLACION_PRE
AND PCER.ID_POBLACION = 77521
/*
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_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID = 1
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE*/
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND (PS.ID_ACTIVIDAD_PS = 111 OR (ID_SECTOR_PP = 111
AND PP.ID_POBLACION_PP = 77521))
AND (PRE.ID_POBLACION_PRE = 77521 OR ID_POBLACION_PP = 77521)
AND (PRE.ID_POBLACION_PRE =77521 OR ID_POBLACION_PP = 77521 )
AND (PR.POBLACION = 0 OR PR.POBLACION 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 PRE.ID_PRECIO;
Tiempo de la consulta:
0.016341209411621Tiempo acumulado:0.5052797794342
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[219]: SELECT '3' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_POBLACION_PP = 77521,1,IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', 2, 0)) AS ES_PUBLI , IF (PRE.N_ORDER_VENTAS_TROPIC = '0.0', PCER.DISTANCIA_REAL +10000, PCER.DISTANCIA_REAL) AS DIST_REAL, PCER.DISTANCIA_REAL, PCER.DISTANCIA, PCER.DURACION , IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', null, PR.PRIORIZA_ORDEN) AS PRIO_ORDEN , COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS, PRE.ID_EMPRESA_PRE,
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, EMP.NOMBRE,
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, PRE.FK_ID_PAIS_PRE AS ID_PAIS ,PT.N_ORDER_VENTAS_TROPIC ,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO,
PRE.PRECIO_PRE,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO_D,
IF(PD.PRECIO_PD > 0
AND PD.VALID_PD = 1, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO,
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,
DATE_FORMAT(PR.FECHA_INICIO, '%d/%m') AS FEC_RES_INI, DATE_FORMAT(PR.FECHA_FIN, '%d/%m') AS FEC_RES_FIN,
TRUNCATE(AVG(OP.VALORACION),0) AS VALORACION,COUNT(DISTINCT OP.ID_OPINION) AS OPIS, 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 , PPT.DESCRIPCION_PPT AS DESCRIPCION_PP
,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, REIA.DESC_REGION AS DESC_REGION_ADM, RE.ID_CAPITAL, PO.ID_POBLACION, RE.SIMCAPN, IF(DATE(PRE.FEC_INSERT_PRE) > DATE(NOW()) - INTERVAL 3 MONTH, 1, 0) AS IS_NEW
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_PUBLI_TRADUCCION PPT ON PPT.ID_PUBLI_PP = PP.ID_PUBLI_PP
AND PPT.IDIOMA = 'it'
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE OR RE.ID_REGION = PP.ID_REGION_PP
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_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
AND (SECI.FK_ID_IDIOMA_SI18N = 'it'
AND SECI.ID_TROPIC = 83)
LEFT JOIN LO_POBLACION_CERCANAS PCER ON PCER.ID_POBLACION_CERCANA = PRE.ID_POBLACION_PRE
AND PCER.ID_POBLACION = 77521
LEFT JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
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_PT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
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 (89868)
AND PRE.VALID_PRE = 4
AND (PS.ID_ACTIVIDAD_PS = 111 OR (ID_SECTOR_PP = 111
AND PP.ID_POBLACION_PP = 77521))
AND (PRE.ID_POBLACION_PRE = 77521 OR ID_POBLACION_PP = 77521)
AND (PRE.ID_POBLACION_PRE =77521 OR ID_POBLACION_PP = 77521 )
AND (PR.POBLACION = 0 OR PR.POBLACION 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 PRE.ID_PRECIO
ORDER BY PRIO_ORDEN DESC, ES_PUBLI ASC , DIST_REAL ASC , PT.N_ORDER_VENTAS_TROPIC DESC ,PRE.ID_PRECIO ASC
LIMIT 20;
Tiempo de la consulta:
0.0085539817810059Tiempo acumulado:0.51383376121521
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[220]: 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.0018389225006104Tiempo acumulado:0.51567268371582
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[221]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S111'
AND SEO.ID_TROPIC = 83
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00086808204650879Tiempo acumulado:0.51654076576233
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[222]: SELECT *
FROM LO_PRECIOS_CALENDARIO PC
WHERE PC.ID_PRECIO_PC = 89868
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.0071489810943604Tiempo acumulado:0.52368974685669
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[223]: SELECT (PRE.PERIODO_PRE) AS PERIODO
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 89868
UNION ALL
SELECT PD.PERIODO_PD AS PERIODO
FROM LO_PRECIOS_DESCUENTOS PD
WHERE PD.ID_PRECIO_PD = 89868
AND PD.VALID_PD = 1;
Tiempo de la consulta:
0.00052690505981445Tiempo acumulado:0.5242166519165
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[224]: 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 = 89868
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 = 89868
GROUP BY PRE.ID_PRECIO
) AS X;
Tiempo de la consulta:
0.023339986801147Tiempo acumulado:0.54755663871765
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[225]: SELECT *
FROM LO_PRECIOS_MODIFICAR_ORDEN
WHERE ID_PRECIO = 89868
AND DATE_FORMAT(FECHA, '%Y-%m-%d') >= NOW() - INTERVAL 3 MONTH;
Tiempo de la consulta:
0.0022838115692139Tiempo acumulado:0.54984045028687
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[226]: 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 = 19864376
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0018069744110107Tiempo acumulado:0.55164742469788
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[227]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 89868
AND VALID = 1;
Tiempo de la consulta:
0.0041520595550537Tiempo acumulado:0.55579948425293
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[228]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 89868
AND FOTO = 'p-89868-29738527171-3f1e4006de-k1718706147_17187084233254.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00057697296142578Tiempo acumulado:0.55637645721436
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[229]: SELECT F_WIDTH, F_HEIGHT
FROM LO_FOTOS
WHERE ID_PRECIO = 89868
AND FOTO = 'p-89868-29738527171-3f1e4006de-k1718706147_17187084233254.jpg';
Tiempo de la consulta:
0.00036120414733887Tiempo acumulado:0.55673766136169
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[230]: 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 = 89868;
Tiempo de la consulta:
0.00053191184997559Tiempo acumulado:0.55726957321167
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[231]: 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 = 89868;
Tiempo de la consulta:
0.001121997833252Tiempo acumulado:0.55839157104492
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[232]: SELECT N_VENTAS_LAST_MONTH
FROM LO_PRECIOS_STATS PS
WHERE PS.ID_PRECIO = 89868;
Tiempo de la consulta:
0.003525972366333Tiempo acumulado:0.56191754341125
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[233]: 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 = 89868
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00052118301391602Tiempo acumulado:0.56243872642517
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[234]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 89868
LIMIT 1;
Tiempo de la consulta:
0.0020339488983154Tiempo acumulado:0.56447267532349
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[235]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 89868;
Tiempo de la consulta:
0.0004570484161377Tiempo acumulado:0.56492972373962
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[236]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 89868
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.0010671615600586Tiempo acumulado:0.56599688529968
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[237]: 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 = 89868;
Tiempo de la consulta:
0.00052499771118164Tiempo acumulado:0.56652188301086
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[238]: 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 = 89868;
Tiempo de la consulta:
0.00039982795715332Tiempo acumulado:0.56692171096802
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[239]: 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=111
AND SSF.ID_TROPIC = 83
GROUP BY SSF.ID_SSF
ORDER BY COUNT(SSF.ID_SSF) DESC;
Tiempo de la consulta:
0.0013730525970459Tiempo acumulado:0.56829476356506
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[240]: 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 (926)
AND 1=1
AND (PRE.ID_REGION_PRE = 760 OR (PP.ID_REGION_PP = 760
AND PP.ID_POBLACION_PP IS NULL ))
AND (PRE.ID_POBLACION_PRE = 77521 OR (ID_POBLACION_PP = 77521))
AND 3=3
AND SHOW_LANDING = 1
GROUP BY ID_SUBSECTOR
ORDER BY ORDER_LANDING ASC;
Tiempo de la consulta:
0.011787891387939Tiempo acumulado:0.580082654953
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[241]: SELECT (N_OFERTAS)+(N_EMPRESAS) AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas,
PS.ID_POBLACION,
IF ( MEDIA_AJUSTADA IS NOT NULL
AND MEDIA_AJUSTADA != 0
AND MEDIA_AJUSTADA < MEDIA_PRECIO, MEDIA_AJUSTADA, MEDIA_PRECIO ) AS MEDIA, N_OPIS
FROM
LO_POBLACION_PT_STATS PS
WHERE (IF(ISNULL(PS.N_OFERTAS),0,PS.N_OFERTAS) > 0 OR IF(ISNULL(PS.N_EMPRESAS),0,PS.N_EMPRESAS) > 0 )
AND PS.ID_POBLACION = 77521
AND PS.ID_SECTOR = 111
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.00058889389038086Tiempo acumulado:0.58067154884338
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[242]: 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, IF(PC.DISTANCIA_REAL IS NULL, 20000, PC.DISTANCIA_REAL) AS DISTANCIA_R
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 = 760
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
LEFT JOIN LO_POBLACION_CERCANAS PC ON PC.ID_POBLACION = 77521
AND PC.ID_POBLACION_CERCANA = PO.ID_POBLACION
WHERE (PS.N_OFERTAS > 0 /* OR PS.N_EMPRESAS > 0 */)
AND IF(RE.SIMCAPN = 1,PO.ID_POBLACION != RE.ID_CAPITAL, 1=1)
AND PS.ID_SECTOR = 111
GROUP BY PS.ID_POBLACION
ORDER BY DISTANCIA_R, PC.DISTANCIA ASC, PS.N_OFERTAS DESC;
Tiempo de la consulta:
0.0086979866027832Tiempo acumulado:0.58936953544617
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[243]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00041294097900391Tiempo acumulado:0.58978247642517
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[244]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 84018
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00045418739318848Tiempo acumulado:0.59023666381836
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[245]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00034499168395996Tiempo acumulado:0.59058165550232
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[246]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 71207
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00075697898864746Tiempo acumulado:0.59133863449097
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[247]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00035285949707031Tiempo acumulado:0.59169149398804
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[248]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 80907
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00032186508178711Tiempo acumulado:0.59201335906982
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[249]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00038504600524902Tiempo acumulado:0.59239840507507
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[250]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 69783
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00034809112548828Tiempo acumulado:0.59274649620056
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[251]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00038003921508789Tiempo acumulado:0.59312653541565
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[252]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 77521
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00033712387084961Tiempo acumulado:0.5934636592865
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[253]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.0003349781036377Tiempo acumulado:0.59379863739014
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[254]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 81317
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00073599815368652Tiempo acumulado:0.59453463554382
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[255]: SELECT LO.ID_PRECIO
FROM LO_LANDING_OFERTAS LO
WHERE LO.STATUS = 2
AND LO.ID_SECTOR = 111
AND LO.ID_POBLACION = 77521;
Tiempo de la consulta:
0.0037078857421875Tiempo acumulado:0.59824252128601
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[256]: 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 )
LEFT JOIN LO_LANDING_OFERTAS LO ON LO.ID_PRECIO = PRE.ID_PRECIO
AND LO.STATUS = 1
AND LO.ID_SECTOR = 111
AND LO.ID_POBLACION = 77521
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 111
AND ( PRE.ID_REGION_PRE='760' OR PP.ID_REGION_PP='760' )
AND PRE.ID_POBLACION_PRE = 77521
GROUP BY PRE.ID_PRECIO
ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0013611316680908Tiempo acumulado:0.5996036529541
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[257]: 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_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 (89868)
AND PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 111
AND ( PRE.ID_REGION_PRE='760' OR PP.ID_REGION_PP='760' )
AND PRE.ID_POBLACION_PRE = 77521
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.00201416015625Tiempo acumulado:0.60161781311035
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[258]: 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 )
LEFT JOIN LO_LANDING_OFERTAS LO ON LO.ID_PRECIO = PRE.ID_PRECIO
AND LO.STATUS = 1
AND LO.ID_SECTOR = 111
AND LO.ID_POBLACION = 77521
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 111
AND ( PRE.ID_REGION_PRE='760' OR PP.ID_REGION_PP='760' )
AND PRE.ID_POBLACION_PRE = 77521
GROUP BY PRE.ID_PRECIO
ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0010850429534912Tiempo acumulado:0.60270285606384
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[259]: 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_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 (89868)
AND PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 111
AND ( PRE.ID_REGION_PRE='760' OR PP.ID_REGION_PP='760' )
AND PRE.ID_POBLACION_PRE = 77521
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0017309188842773Tiempo acumulado:0.60443377494812
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[260]: 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 = 89868;
Tiempo de la consulta:
0.00055694580078125Tiempo acumulado:0.6049907207489
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[261]: 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 = 89868;
Tiempo de la consulta:
0.00040507316589355Tiempo acumulado:0.60539579391479
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[262]: SELECT LUO.ID_OPINION, LUO.ID_PRECIO,VALORACION, LUOF.FOTO_OPINION, LUOF.POSICION_FOTO_PRECIO, LUOF.ID_OPINION AS ID_OPINION_FOTO, LUOF.ID_RESERVA AS ID_RESERVA_FOTO, LUO.FEC_OPINION
FROM LO_LISTADOS_ULTIMAS_OPINIONES LUO
LEFT JOIN LO_LISTADOS_ULTIMAS_OPINIONES_FOTOS LUOF ON LUOF.ID_LISTADO_ULTIMAS_OPINIONES = LUO.ID
WHERE ID_SECTOR = 111
AND ID_POBLACION = 77521
AND ID_REGION_ADM IS NULL
AND ID_REGION IS NULL
AND ID_PAIS IS NULL
GROUP BY ID_OPINION
ORDER BY ID_OPINION DESC
LIMIT 6;
Tiempo de la consulta:
0.0047318935394287Tiempo acumulado:0.61012768745422
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[263]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
FROM LO_POBLACION_PT_STATS
WHERE ID_POBLACION = 77521
AND ID_SECTOR = 111;
Tiempo de la consulta:
0.00044608116149902Tiempo acumulado:0.61057376861572
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[264]: 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=111
AND SSF.ID_TROPIC = 83
GROUP BY SSF.ID_SSF
ORDER BY COUNT(SSF.ID_SSF) DESC;
Tiempo de la consulta:
0.0017430782318115Tiempo acumulado:0.61231684684753
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[265]: 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 = 111
AND (PRE.ID_POBLACION_PRE = 77521 OR ID_POBLACION_PP = 77521)
AND (PR.POBLACION = 0 OR PR.POBLACION 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.0042891502380371Tiempo acumulado:0.61660599708557
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[266]: 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 (926)
AND 1=1
AND (PRE.ID_REGION_PRE = 760 OR (PP.ID_REGION_PP = 760
AND PP.ID_POBLACION_PP IS NULL ))
AND (PRE.ID_POBLACION_PRE = 77521 OR (ID_POBLACION_PP = 77521))
AND SHOW_LANDING = 1
GROUP BY ID_SUBSECTOR
ORDER BY ORDER_LANDING ASC;
Tiempo de la consulta:
0.0041718482971191Tiempo acumulado:0.62077784538269
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[267]: SELECT SEO.DESCRIPTION
FROM LO_SEO_DESCRIPTIONS SEO
WHERE SEO.ID_TROPIC='83'
AND SEO.ID_KEY='S111';
Tiempo de la consulta:
0.00086688995361328Tiempo acumulado:0.6216447353363
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[268]: SELECT SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT, SEOHOME.CONTENT_MANAGER, DATE_FORMAT(SEOHOME.FEC_INSERT, '%d/%m/%Y %H:%i') FECHA_INSERT, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d/%m/%Y %H:%i') FECHA_MOD, CA.NOMBRE, CA.ID,DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y-%m-%dT%H:%i') IN_GOOGLE,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y-%m-%dT%H:%i') MOD_GOOGLE,AU.ID_ADMIN, GALERIA, GALERIA_DESC, CA.JOB,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%d') DAY_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%m') MONTH_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y') YEAR_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%H:%i') HORA_INSERT,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d') DAY_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%m') MONTH_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y') YEAR_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%H:%i') HORA_MOD
FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
LEFT JOIN LO_ADMIN_USERS AU ON AU.LOGIN = SEOHOME.CONTENT_MANAGER
LEFT JOIN LO_CONTENIDO_AUTORES CA ON CA.ID_ADMIN = AU.ID_ADMIN
AND CA.ID_TROPIC = 83
WHERE SEOHOME.ID_TROPIC = 83
AND SEOHOME.ID_KEY = 'S111'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='77521';
Tiempo de la consulta:
0.0073590278625488Tiempo acumulado:0.62900376319885
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[269]: 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, 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_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 = 760
AND PS.ID_SECTOR = 111
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.0023431777954102Tiempo acumulado:0.63134694099426
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[270]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00042581558227539Tiempo acumulado:0.63177275657654
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[271]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 84018
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00035405158996582Tiempo acumulado:0.6321268081665
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[272]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00037002563476562Tiempo acumulado:0.63249683380127
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[273]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 71207
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00032997131347656Tiempo acumulado:0.63282680511475
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[274]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00033688545227051Tiempo acumulado:0.63316369056702
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[275]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 80907
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00033688545227051Tiempo acumulado:0.63350057601929
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[276]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00040197372436523Tiempo acumulado:0.63390254974365
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[277]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 69783
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00037407875061035Tiempo acumulado:0.63427662849426
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[278]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00044584274291992Tiempo acumulado:0.63472247123718
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[279]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 77521
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00034999847412109Tiempo acumulado:0.6350724697113
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[280]: 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 = 760
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00037622451782227Tiempo acumulado:0.63544869422913
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[281]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 81317
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00037193298339844Tiempo acumulado:0.63582062721252
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[282]: 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 = 111
AND POS.N_OFERTAS > 1
WHERE PRM.ID_REGION = 760;
Tiempo de la consulta:
0.0030310153961182Tiempo acumulado:0.63885164260864
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[283]: 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 = 760
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.0017750263214111Tiempo acumulado:0.64062666893005
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[284]: SELECT COUNT(*) AS NEMPRESAS
FROM LO_REGION_STATS
WHERE ID_REGION = 760
AND ID_GRUPO = 4;
Tiempo de la consulta:
0.00046706199645996Tiempo acumulado:0.64109373092651
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[285]: 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 = '760'
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00041699409484863Tiempo acumulado:0.64151072502136
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[286]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.00034809112548828Tiempo acumulado:0.64185881614685
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[287]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.00036406517028809Tiempo acumulado:0.64222288131714
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[288]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S111'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.0005040168762207Tiempo acumulado:0.64272689819336
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[289]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.00037813186645508Tiempo acumulado:0.64310503005981
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[290]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.00029802322387695Tiempo acumulado:0.64340305328369
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[291]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S21'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.0011560916900635Tiempo acumulado:0.64455914497375
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[292]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.0003509521484375Tiempo acumulado:0.64491009712219
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[293]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.00031900405883789Tiempo acumulado:0.64522910118103
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[294]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S122'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.00098800659179688Tiempo acumulado:0.64621710777283
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[295]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.00044393539428711Tiempo acumulado:0.64666104316711
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[296]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.0003058910369873Tiempo acumulado:0.6469669342041
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[297]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S107'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.00037789344787598Tiempo acumulado:0.64734482765198
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[298]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.00032711029052734Tiempo acumulado:0.6476719379425
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[299]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.00030207633972168Tiempo acumulado:0.64797401428223
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[300]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S9'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.0013129711151123Tiempo acumulado:0.64928698539734
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[301]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.00033402442932129Tiempo acumulado:0.64962100982666
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[302]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.0003199577331543Tiempo acumulado:0.64994096755981
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[303]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S39'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.0018641948699951Tiempo acumulado:0.65180516242981
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[304]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.00034689903259277Tiempo acumulado:0.6521520614624
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[305]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.00031781196594238Tiempo acumulado:0.65246987342834
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[306]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S24'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.00053906440734863Tiempo acumulado:0.65300893783569
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[307]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.0003359317779541Tiempo acumulado:0.65334486961365
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[308]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.00034213066101074Tiempo acumulado:0.65368700027466
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[309]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S48'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.00040817260742188Tiempo acumulado:0.65409517288208
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[310]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.00035715103149414Tiempo acumulado:0.65445232391357
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[311]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.00033712387084961Tiempo acumulado:0.65478944778442
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[312]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S50'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.00039100646972656Tiempo acumulado:0.65518045425415
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[313]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.00033688545227051Tiempo acumulado:0.65551733970642
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[314]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.0003349781036377Tiempo acumulado:0.65585231781006
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[315]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S120'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.00039196014404297Tiempo acumulado:0.6562442779541
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[316]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.00033283233642578Tiempo acumulado:0.65657711029053
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[317]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.00030684471130371Tiempo acumulado:0.65688395500183
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[318]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S77'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.00040197372436523Tiempo acumulado:0.6572859287262
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[319]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.00037693977355957Tiempo acumulado:0.65766286849976
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[320]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.00030899047851562Tiempo acumulado:0.65797185897827
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[321]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S80'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.00037908554077148Tiempo acumulado:0.65835094451904
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[322]: SELECT ID_REGION
FROM LO_POBLACION
WHERE ID_POBLACION='77521'
LIMIT 1;
Tiempo de la consulta:
0.00034403800964355Tiempo acumulado:0.65869498252869
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[323]: SELECT ID_REGION_ADM1
FROM LO_REGION
WHERE ID_REGION='760'
LIMIT 1;
Tiempo de la consulta:
0.00031280517578125Tiempo acumulado:0.65900778770447
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[324]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S42'
AND (SEO.ID_TROPIC = 83
AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='101') );
Tiempo de la consulta:
0.00040888786315918Tiempo acumulado:0.65941667556763
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[325]: 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.00062012672424316Tiempo acumulado:0.66003680229187
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[326]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 83;
Tiempo de la consulta:
0.00098395347595215Tiempo acumulado:0.66102075576782
