yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/landings/landing.php
BBDD->Prod_Yumping_pt_PT
AMBITO->pt_fr
AMBITO_AJAX->pt_fr
AMBITO_AJAX COOKIE->mx
locale LO_CONFIG->fr_PT
locale php->fr_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->fr
filtro1->karting
filtro2->viana-do-castelo
rel_alternate->1
paginado_ofertas->
npage->
Total queries: 238
Tiempo total: 0.49657964706421
(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', 'fr')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.018831968307495Tiempo acumulado:0.018831968307495
(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.00059819221496582Tiempo acumulado:0.019430160522461
(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 = 'viana-do-castelo'
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 = 'viana-do-castelo' 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 = 'viana-do-castelo'
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 = 'viana-do-castelo' 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 = 'viana-do-castelo'
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 = 'viana-do-castelo' 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 = 'viana-do-castelo'
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 = 'viana-do-castelo' 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 = 'viana-do-castelo'
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 = 'viana-do-castelo' 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 = 'viana-do-castelo'
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 = 'viana-do-castelo' )AS FIND_REGION
GROUP BY ID_PAIS;
Tiempo de la consulta:
0.011077880859375Tiempo acumulado:0.030508041381836
(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_fr')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.015098810195923Tiempo acumulado:0.045606851577759
(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.00039505958557129Tiempo acumulado:0.04600191116333
(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.00039505958557129Tiempo acumulado:0.046396970748901
(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.0004570484161377Tiempo acumulado:0.046854019165039
(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.0004279613494873Tiempo acumulado:0.047281980514526
(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.04764199256897
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[10]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'rel_alternate';
Tiempo de la consulta:
0.00037717819213867Tiempo acumulado:0.048019170761108
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[11]: SELECT G.DESC_GRUPO, G.ID_GRUPO, G.URL AS URL_GRUPO
FROM LO_GRUPOS G
WHERE G.URL = 'karting'
AND G.ID_TROPIC = 84;
Tiempo de la consulta:
0.0015950202941895Tiempo acumulado:0.049614191055298
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[12]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.URL = 'viana-do-castelo'
AND IDIOMA = 'fr';
Tiempo de la consulta:
0.00091910362243652Tiempo acumulado:0.050533294677734
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[13]: SELECT '1', RE.ID_REGION, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, RE.ID_REGION_ADM1, RE.ID_PAIS, LATITUDE, LONGITUDE
FROM LO_REGION RE
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
WHERE RE.ID_REGION = 'viana-do-castelo'
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00053000450134277Tiempo acumulado:0.051063299179077
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[14]: SELECT '2', RE.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, RE.ID_REGION_ADM1, RE.ID_PAIS, LATITUDE, LONGITUDE
FROM LO_REGION_I18N REI
INNER JOIN LO_REGION RE ON REI.ID_REGION=RE.ID_REGION
AND URL = 'viana-do-castelo'
AND IDIOMA = 'fr'
LIMIT 1;
Tiempo de la consulta:
0.00049519538879395Tiempo acumulado:0.051558494567871
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[15]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = 'karting'
AND ID_TROPIC = 84
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
LIMIT 1;
Tiempo de la consulta:
0.0018081665039062Tiempo acumulado:0.053366661071777
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: SELECT ORDER_LANDING
FROM LO_SECTORES SEC
WHERE ID_SECTOR = 2;
Tiempo de la consulta:
0.00036001205444336Tiempo acumulado:0.053726673126221
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[17]: SELECT GRU.URL URL_GRUPO, GRU.DESC_GRUPO, ID_GRUPO
FROM LO_GRUPOS GRU
WHERE GRU.ID_GRUPO = 6
AND (GRU.ID_TROPIC = 84);
Tiempo de la consulta:
0.00066804885864258Tiempo acumulado:0.054394721984863
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[18]: SELECT *
FROM LO_SEO_KEYWORDS_LANDING SKL
WHERE SKL.ID_SECTOR = 2
AND ID_TROPIC = 84;
Tiempo de la consulta:
0.00092601776123047Tiempo acumulado:0.055320739746094
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[19]: SELECT *
FROM LO_REGION_SKI REI
WHERE URL = 'viana-do-castelo'
AND REI.IDIOMA='fr'
AND TIPO = 1;
Tiempo de la consulta:
0.00089383125305176Tiempo acumulado:0.056214570999146
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[20]: 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 = 765
LIMIT 1;
Tiempo de la consulta:
0.0011351108551025Tiempo acumulado:0.057349681854248
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[21]: SELECT SQL_CALC_FOUND_ROWS ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = EMP.ID_EMPRESA
INNER JOIN LO_EMPRESAS_TRADUCCION_FR ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'fr'
WHERE EMP.VALID IN (1)
AND RE.ID_REGION = 765
AND EMP.EMP_MADRE NOT IN (0)
AND EMP.ID_SECTOR=2
GROUP BY EMP.NOMBRE
ORDER BY IF(N_PRECIOS_EST > 0 , 1 ,0) DESC, N_VENTAS_EST DESC,N_ORDER_TSP_EST DESC
LIMIT 0,12;
Tiempo de la consulta:
0.0065550804138184Tiempo acumulado:0.063904762268066
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[22]: SELECT FOUND_ROWS() NEMPRESAS;
Tiempo de la consulta:
0.00056815147399902Tiempo acumulado:0.064472913742065
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[23]: SELECT SQL_CALC_FOUND_ROWS
(SELECT EM2.RESPUESTARAPIDA
FROM LO_EMPRESAS_STAT EM2
WHERE EM2.FK_ID_EST = EMP.ID_MADRE) AS RESPUESTA,
EMP.ID_MADRE, SEC.ID_GRUPO, EMP.ID_EMPRESA,if(EMP.TIPOCUENTA=0,1,EMP.TIPOCUENTA) AS TIPOCUENTA, EMP.NOPINIONES,EMP.COLAB_EMPRESAS,EMP.VALID, EMP.CLIENTE, EMP.PUNTOS,EMP.PRECIO_ACTIVIDAD, EMP.TOPSECTOR_PROVINCIA, EMP.PROMOGRUPO, EMP.URL, EMP.EMP_MADRE, EMP.ID_EMPRESA, EMP.ID_MADRE, EMP.NOMBRE, EMP.DESCRIPCION, EMP.ID_PROVINCIA, EMP.ID_POBLACION, EMP.ID_PAIS,
EMP.COD_POSTAL, EMP.DIRECCION, EMP.MAIL, EMP.TELEFONO, EMP.TELEFONOMOVIL, EMP.FAX, EMP.WEB, EMPS.CENTRAL_ACTIVA,
ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING,
EMP.DESCRIPCION SNIPPET,
REI.DESC_REGION, POI.DESC_POBLACION, SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO, EMP.GALERIA, EMP.GALERIA_DESC, EMP.LONGITUDE, EMP.LATITUDE, EMP.LOGOTIPO, EMP.FOTOPRINCIPAL, EMP.PROMOSECTOR,
REIA.DESC_REGION DESC_REGION_ADM1,EMP.TIPOCUENTA,EMP.VIDEOS_CODE,MULTIFICHA,EMPS.*,SECI.URL URL_SECTOR
,( SELECT (EMP.LICENCIA_EMPRESA)
FROM LO_EMPRESAS EMP3
WHERE (EMP3.ID_EMPRESA= EMP.ID_EMPRESA OR EMP3.ID_EMPRESA = EMP.ID_EMPRESA)
AND EMP3.LICENCIA_EMPRESA IS NOT NULL
AND EMP3.LICENCIA_EMPRESA!='' ) AS LICENCIA_EMPRESA , IF (EMP.EMP_MADRE = 3,
CONCAT((SELECT LATITUDE
FROM LO_REGION
WHERE ID_REGION = 765)),
0) AS LAT_PUBLI
, IF (EMP.EMP_MADRE = 3,
CONCAT((SELECT LONGITUDE
FROM LO_REGION
WHERE ID_REGION = 765)),
0) AS LONG_PUBLI
/* ELIMINAMOS MAX(EMP.LICENCIA_EMPRESA) */
FROM LO_EMPRESAS EMP
INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'fr'
INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA = 'fr'
LEFT JOIN LO_POBLACION PO ON PO.ID_POBLACION = EMP.ID_POBLACION
LEFT JOIN LO_POBLACION_PT POI ON EMP.ID_POBLACION = POI.ID_POBLACION
AND POI.IDIOMA='fr'
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 84
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = EMP.ID_EMPRESA
INNER JOIN LO_EMPRESAS_TRADUCCION_FR ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'fr'
WHERE EMP.ID_EMPRESA IN (19765128)
ORDER BY IF(N_PRECIOS_EST > 0 , 1 ,0) DESC, N_VENTAS_EST DESC,N_ORDER_TSP_EST DESC;
Tiempo de la consulta:
0.020991086959839Tiempo acumulado:0.085464000701904
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[24]: SELECT N_OFERTAS AS NumOfertas, N_EMPRESAS AS TOTAL_EMPRESAS, PRECIO_MIN, IF ( MEDIA_AJUSTADA IS NOT NULL
AND MEDIA_AJUSTADA != 0
AND MEDIA_AJUSTADA < MEDIA_PRECIO, MEDIA_AJUSTADA, MEDIA_PRECIO ) AS MEDIA
FROM LO_REGION_STATS
WHERE ID_REGION = 765
AND ID_SECTOR = 2
GROUP BY ID_SECTOR;
Tiempo de la consulta:
0.0013940334320068Tiempo acumulado:0.086858034133911
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[25]: 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 = 84
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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
WHERE SS.ID_TROPIC = 84
AND VALID_PRE=4
AND ID_SECTOR_SS = '2'
AND (PRE.ID_REGION_PRE = 765 OR (PP.ID_REGION_PP = 765
AND PP.ID_POBLACION_PP IS NULL ))
GROUP BY SS.ID_SUBSECTOR
ORDER BY SS.ID_FAM_SS DESC,SS.ID_SUBFAM_SS DESC,PRINCIPAL_SS DESC,COUNT(*) DESC;
Tiempo de la consulta:
0.020133018493652Tiempo acumulado:0.10699105262756
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[26]: SELECT SEO.DESCRIPTION
FROM LO_SEO_DESCRIPTIONS SEO
WHERE SEO.ID_TROPIC='84'
AND SEO.ID_KEY='S2';
Tiempo de la consulta:
0.0015270709991455Tiempo acumulado:0.10851812362671
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[27]: 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 = 84
WHERE SEOHOME.ID_TROPIC = 84
AND SEOHOME.ID_KEY = 'S2'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='765';
Tiempo de la consulta:
0.0098240375518799Tiempo acumulado:0.11834216117859
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[28]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/fr/karting/viana-do-castelo';
Tiempo de la consulta:
0.00089192390441895Tiempo acumulado:0.11923408508301
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[29]: SELECT *
FROM LO_SEO_DESCRIPTIONS_HOME SEO
WHERE SEO.ID_TROPIC='84'
AND SEO.ID_KEY='S2'
AND SEO.ID_LOCALIZACION='765';
Tiempo de la consulta:
0.0081291198730469Tiempo acumulado:0.12736320495605
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[30]: SELECT TITLE, DESCRIPTION, KEYWORDS, ID_KEY
FROM LO_SEO_HEADERS SEO
WHERE SEO.ID_TROPIC='84'
AND VALID='1'
AND SEO.ID_KEY='S2';
Tiempo de la consulta:
0.0018000602722168Tiempo acumulado:0.12916326522827
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[31]: 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 = 'karting'
AND ID_TROPIC = 84
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
LIMIT 1;
Tiempo de la consulta:
0.00065708160400391Tiempo acumulado:0.12982034683228
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[32]: 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.0005190372467041Tiempo acumulado:0.13033938407898
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[33]: 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.00057196617126465Tiempo acumulado:0.13091135025024
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[34]: 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.00059604644775391Tiempo acumulado:0.131507396698
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[35]: 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=2
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
AND SECI.ID_TROPIC=8;
Tiempo de la consulta:
0.00074195861816406Tiempo acumulado:0.13224935531616
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[36]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055289268493652Tiempo acumulado:0.1328022480011
(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_Language_Regiones'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055599212646484Tiempo acumulado:0.13335824012756
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[38]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'viana-do-castelo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00067782402038574Tiempo acumulado:0.13403606414795
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[39]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00084590911865234Tiempo acumulado:0.1348819732666
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[40]: 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.00051593780517578Tiempo acumulado:0.13539791107178
(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_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.00057506561279297Tiempo acumulado:0.13597297668457
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[42]: 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=765
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00060009956359863Tiempo acumulado:0.13657307624817
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[43]: 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 = 'karting'
AND ID_TROPIC = 84
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
LIMIT 1;
Tiempo de la consulta:
0.00064706802368164Tiempo acumulado:0.13722014427185
(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_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.00063395500183105Tiempo acumulado:0.13785409927368
(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_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.00048685073852539Tiempo acumulado:0.13834095001221
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059199333190918Tiempo acumulado:0.13893294334412
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[47]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM 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=2
AND SECI.FK_ID_IDIOMA_SI18N = 'en'
AND SECI.ID_TROPIC=82;
Tiempo de la consulta:
0.00058794021606445Tiempo acumulado:0.13952088356018
(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_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.00092983245849609Tiempo acumulado:0.14045071601868
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[49]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047612190246582Tiempo acumulado:0.14092683792114
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'viana-do-castelo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00066685676574707Tiempo acumulado:0.14159369468689
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[51]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00080180168151855Tiempo acumulado:0.14239549636841
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[52]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00076913833618164Tiempo acumulado:0.14316463470459
(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_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.00050806999206543Tiempo acumulado:0.14367270469666
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[54]: 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=765
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'en';
Tiempo de la consulta:
0.00053691864013672Tiempo acumulado:0.14420962333679
(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 = 'karting'
AND ID_TROPIC = 84
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
LIMIT 1;
Tiempo de la consulta:
0.00079989433288574Tiempo acumulado:0.14500951766968
(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_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.00061607360839844Tiempo acumulado:0.14562559127808
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00081110000610352Tiempo acumulado:0.14643669128418
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.000640869140625Tiempo acumulado:0.1470775604248
(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=2
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
AND SECI.ID_TROPIC=83;
Tiempo de la consulta:
0.00055885314941406Tiempo acumulado:0.14763641357422
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00062894821166992Tiempo acumulado:0.14826536178589
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00069999694824219Tiempo acumulado:0.14896535873413
(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 = 'viana-do-castelo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00052309036254883Tiempo acumulado:0.14948844909668
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00071501731872559Tiempo acumulado:0.15020346641541
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00064706802368164Tiempo acumulado:0.15085053443909
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[65]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00073099136352539Tiempo acumulado:0.15158152580261
(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=765
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00043296813964844Tiempo acumulado:0.15201449394226
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[67]: 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 = 'karting'
AND ID_TROPIC = 84
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
LIMIT 1;
Tiempo de la consulta:
0.0011050701141357Tiempo acumulado:0.1531195640564
(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_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.00071907043457031Tiempo acumulado:0.15383863449097
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[69]: 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.00073409080505371Tiempo acumulado:0.15457272529602
(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_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.00078797340393066Tiempo acumulado:0.15536069869995
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[71]: 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=2
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC=81;
Tiempo de la consulta:
0.00078105926513672Tiempo acumulado:0.15614175796509
(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_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.00054502487182617Tiempo acumulado:0.15668678283691
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[73]: 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.00046300888061523Tiempo acumulado:0.15714979171753
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[74]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'viana-do-castelo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00051283836364746Tiempo acumulado:0.15766263008118
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[75]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049281120300293Tiempo acumulado:0.15815544128418
(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_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.15861940383911
(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_Data_Base'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046491622924805Tiempo acumulado:0.15908432006836
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[78]: 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=765
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00038695335388184Tiempo acumulado:0.15947127342224
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[79]: 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 = 'karting'
AND ID_TROPIC = 84
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
LIMIT 1;
Tiempo de la consulta:
0.0009009838104248Tiempo acumulado:0.16037225723267
(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_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049901008605957Tiempo acumulado:0.16087126731873
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[81]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.00063204765319824Tiempo acumulado:0.16150331497192
(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_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.00049805641174316Tiempo acumulado:0.16200137138367
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[83]: 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=2
AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
AND SECI.ID_TROPIC=86;
Tiempo de la consulta:
0.00063705444335938Tiempo acumulado:0.16263842582703
(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_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.00071406364440918Tiempo acumulado:0.16335248947144
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[85]: 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.00055098533630371Tiempo acumulado:0.16390347480774
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[86]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'viana-do-castelo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.0006709098815918Tiempo acumulado:0.16457438468933
(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_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.0007469654083252Tiempo acumulado:0.16532135009766
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[88]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042390823364258Tiempo acumulado:0.1657452583313
(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_Data_Base'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053501129150391Tiempo acumulado:0.1662802696228
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[90]: 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=765
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'ch';
Tiempo de la consulta:
0.00037288665771484Tiempo acumulado:0.16665315628052
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[91]: 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 = 'karting'
AND ID_TROPIC = 84
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
LIMIT 1;
Tiempo de la consulta:
0.0010449886322021Tiempo acumulado:0.16769814491272
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[92]: 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.00043511390686035Tiempo acumulado:0.16813325881958
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[93]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.00086092948913574Tiempo acumulado:0.16899418830872
(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_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.0004889965057373Tiempo acumulado:0.16948318481445
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[95]: 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=2
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC=87;
Tiempo de la consulta:
0.00060415267944336Tiempo acumulado:0.1700873374939
(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_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.00050997734069824Tiempo acumulado:0.17059731483459
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[97]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.00043416023254395Tiempo acumulado:0.17103147506714
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[98]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'viana-do-castelo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00052404403686523Tiempo acumulado:0.171555519104
(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_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.00048589706420898Tiempo acumulado:0.17204141616821
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[100]: 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.00047898292541504Tiempo acumulado:0.17252039909363
(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_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.00047993659973145Tiempo acumulado:0.17300033569336
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[102]: 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=765
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.00039291381835938Tiempo acumulado:0.17339324951172
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[103]: 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 = 'karting'
AND ID_TROPIC = 84
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
LIMIT 1;
Tiempo de la consulta:
0.00097393989562988Tiempo acumulado:0.17436718940735
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[104]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.00065112113952637Tiempo acumulado:0.17501831054688
(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_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.00046205520629883Tiempo acumulado:0.17548036575317
(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_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.0004880428314209Tiempo acumulado:0.17596840858459
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[107]: 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=2
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC=85;
Tiempo de la consulta:
0.00065803527832031Tiempo acumulado:0.17662644386292
(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_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.00085306167602539Tiempo acumulado:0.17747950553894
(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_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.00061297416687012Tiempo acumulado:0.17809247970581
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[110]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'viana-do-castelo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.17857146263123
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[111]: 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.00081491470336914Tiempo acumulado:0.17938637733459
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[112]: 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.00066494941711426Tiempo acumulado:0.18005132675171
(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_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.00043416023254395Tiempo acumulado:0.18048548698425
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[114]: 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=765
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.0005190372467041Tiempo acumulado:0.18100452423096
(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', 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.0004570484161377Tiempo acumulado:0.18146157264709
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[116]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 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.00046181678771973Tiempo acumulado:0.18192338943481
(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', 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.00061488151550293Tiempo acumulado:0.18253827095032
(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', 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.00045394897460938Tiempo acumulado:0.18299221992493
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[119]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 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.00048112869262695Tiempo acumulado:0.18347334861755
(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_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.00069904327392578Tiempo acumulado:0.18417239189148
(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_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.00046396255493164Tiempo acumulado:0.18463635444641
(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_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.00059604644775391Tiempo acumulado:0.18523240089417
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[123]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.00050091743469238Tiempo acumulado:0.18573331832886
(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_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.00060701370239258Tiempo acumulado:0.18634033203125
(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_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.0006721019744873Tiempo acumulado:0.18701243400574
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[126]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.00054097175598145Tiempo acumulado:0.18755340576172
(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_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.00049591064453125Tiempo acumulado:0.18804931640625
(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_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.00057196617126465Tiempo acumulado:0.18862128257751
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00070619583129883Tiempo acumulado:0.18932747840881
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[130]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.00041890144348145Tiempo acumulado:0.18974637985229
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[131]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.00058794021606445Tiempo acumulado:0.19033432006836
(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_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.00061607360839844Tiempo acumulado:0.19095039367676
(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_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.00075483322143555Tiempo acumulado:0.19170522689819
(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_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.00042986869812012Tiempo acumulado:0.19213509559631
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[135]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.19262194633484
(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_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.0006098747253418Tiempo acumulado:0.19323182106018
(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_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.00072193145751953Tiempo acumulado:0.1939537525177
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[138]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.19438576698303
(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_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.0005500316619873Tiempo acumulado:0.19493579864502
(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_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.00062012672424316Tiempo acumulado:0.19555592536926
(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_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.0006411075592041Tiempo acumulado:0.19619703292847
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[142]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.00042605400085449Tiempo acumulado:0.19662308692932
(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_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00099396705627441Tiempo acumulado:0.1976170539856
(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_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045084953308105Tiempo acumulado:0.19806790351868
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[145]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.00044989585876465Tiempo acumulado:0.19851779937744
(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_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.00054216384887695Tiempo acumulado:0.19905996322632
(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_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.00043296813964844Tiempo acumulado:0.19949293136597
(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_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.00052809715270996Tiempo acumulado:0.20002102851868
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[149]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.00057697296142578Tiempo acumulado:0.2005980014801
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[150]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_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.0006558895111084Tiempo acumulado:0.20125389099121
(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_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.0004279613494873Tiempo acumulado:0.2016818523407
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[152]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 48
AND IDIOMA = 'fr';
Tiempo de la consulta:
0.00039291381835938Tiempo acumulado:0.20207476615906
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[153]: SELECT SEOHOME.TITLE, SEOHOME.METADESCRIPTION,SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT
FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
WHERE SEOHOME.ID_TROPIC = 84
AND SEOHOME.ID_KEY='S2'
AND SEOHOME.ID_LOCALIZACION='765';
Tiempo de la consulta:
0.0075399875640869Tiempo acumulado:0.20961475372314
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[154]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0010828971862793Tiempo acumulado:0.21069765090942
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[155]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00034809112548828Tiempo acumulado:0.21104574203491
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[156]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
FROM LO_REGION_STATS
WHERE ID_REGION = 765
AND ID_SECTOR = 2;
Tiempo de la consulta:
0.00038385391235352Tiempo acumulado:0.21142959594727
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[157]: 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 = 2
AND PRE.ID_REGION_PRE ='765'
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 = 2
AND PRE.ID_REGION_PRE ='765'
/* 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 = 2
AND PRE.ID_REGION_PRE ='765'
*/ ) AS PRECIO_MIN_MAX;
Tiempo de la consulta:
0.0047450065612793Tiempo acumulado:0.21617460250854
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[158]: SELECT *
FROM LO_SEO_KEYWORDS_LANDING SKL
WHERE SKL.ID_SECTOR = 2
AND SKL.ID_TROPIC = 84;
Tiempo de la consulta:
0.00042080879211426Tiempo acumulado:0.21659541130066
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[159]: SELECT '1' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_REGION_PP = 765
AND PP.ID_POBLACION_PP IS NULL,1,IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', 2, 0)) AS ES_PUBLI , IF (PRE.N_ORDER_VENTAS_TROPIC = '0.0', RCER.DISTANCIA_REAL +10000, RCER.DISTANCIA_REAL) AS DIST_REAL, RCER.DISTANCIA_REAL, RCER.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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
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_REGIONES_CERCANAS RCER ON RCER.ID_PROVINCIA_CERCANA = PRE.ID_REGION_PRE
AND RCER.ID_PROVINCIA = 765
/*
INNER JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='fr'
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 = 2 OR (ID_SECTOR_PP = 2
AND PP.ID_REGION_PP = 765))
AND (PRE.ID_REGION_PRE = 765 OR (PP.ID_REGION_PP = 765
AND PP.ID_POBLACION_PP IS NULL ))
AND (PR.PROVINCIA = 0 OR PR.PROVINCIA IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL,
CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d'))
AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'),
CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d')),
CONCAT( (1+DATE_FORMAT(NOW(), '%Y')),'-',DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT( DATE_FORMAT(NOW(), '%Y'),'-',DATE_FORMAT(NOW(), '%m-%d')))
,1!=1) )
GROUP BY 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.088793992996216Tiempo acumulado:0.30538940429688
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[160]: SELECT count(*) as NOFERTAS
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
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_REGIONES_CERCANAS RCER ON RCER.ID_PROVINCIA_CERCANA = PRE.ID_REGION_PRE
AND RCER.ID_PROVINCIA = 765
/*
INNER JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='fr'
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 = 2 OR (ID_SECTOR_PP = 2
AND PP.ID_REGION_PP = 765))
AND (PRE.ID_REGION_PRE = 765 OR (PP.ID_REGION_PP = 765
AND PP.ID_POBLACION_PP IS NULL ))
AND (PR.PROVINCIA = 0 OR PR.PROVINCIA IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL,
CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d'))
AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'),
CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d')),
CONCAT( (1+DATE_FORMAT(NOW(), '%Y')),'-',DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT( DATE_FORMAT(NOW(), '%Y'),'-',DATE_FORMAT(NOW(), '%m-%d')))
,1!=1) )
GROUP BY PRE.ID_PRECIO;
Tiempo de la consulta:
0.019379854202271Tiempo acumulado:0.32476925849915
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[161]: SELECT '3' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_REGION_PP = 765
AND PP.ID_POBLACION_PP IS NULL,1,IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', 2, 0)) AS ES_PUBLI , IF (PRE.N_ORDER_VENTAS_TROPIC = '0.0', RCER.DISTANCIA_REAL +10000, RCER.DISTANCIA_REAL) AS DIST_REAL, RCER.DISTANCIA_REAL, RCER.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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
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 = 'fr'
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 = 'fr'
AND SECI.ID_TROPIC = 84)
LEFT JOIN LO_REGIONES_CERCANAS RCER ON RCER.ID_PROVINCIA_CERCANA = PRE.ID_REGION_PRE
AND RCER.ID_PROVINCIA = 765
LEFT JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA='fr'
INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA = 'fr'
LEFT JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='fr'
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 (82639)
AND PRE.VALID_PRE = 4
AND (PS.ID_ACTIVIDAD_PS = 2 OR (ID_SECTOR_PP = 2
AND PP.ID_REGION_PP = 765))
AND (PRE.ID_REGION_PRE = 765 OR (PP.ID_REGION_PP = 765
AND PP.ID_POBLACION_PP IS NULL ))
AND (PR.PROVINCIA = 0 OR PR.PROVINCIA IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL,
CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d'))
AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'),
CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d')),
CONCAT( (1+DATE_FORMAT(NOW(), '%Y')),'-',DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT( DATE_FORMAT(NOW(), '%Y'),'-',DATE_FORMAT(NOW(), '%m-%d')))
,1!=1) )
GROUP BY 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.011147975921631Tiempo acumulado:0.33591723442078
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[162]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'O1'
AND SEO.ID_TROPIC = 84
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0019199848175049Tiempo acumulado:0.33783721923828
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[163]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S2'
AND SEO.ID_TROPIC = 84
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0013680458068848Tiempo acumulado:0.33920526504517
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[164]: SELECT *
FROM LO_PRECIOS_CALENDARIO PC
WHERE PC.ID_PRECIO_PC = 82639
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.0034959316253662Tiempo acumulado:0.34270119667053
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[165]: SELECT (PRE.PERIODO_PRE) AS PERIODO
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 82639
UNION ALL
SELECT PD.PERIODO_PD AS PERIODO
FROM LO_PRECIOS_DESCUENTOS PD
WHERE PD.ID_PRECIO_PD = 82639
AND PD.VALID_PD = 1;
Tiempo de la consulta:
0.00052809715270996Tiempo acumulado:0.34322929382324
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[166]: 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 = 84
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 = 82639
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 = 84
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 = 82639
GROUP BY PRE.ID_PRECIO
) AS X;
Tiempo de la consulta:
0.001939058303833Tiempo acumulado:0.34516835212708
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[167]: SELECT *
FROM LO_PRECIOS_MODIFICAR_ORDEN
WHERE ID_PRECIO = 82639
AND DATE_FORMAT(FECHA, '%Y-%m-%d') >= NOW() - INTERVAL 3 MONTH;
Tiempo de la consulta:
0.0013039112091064Tiempo acumulado:0.34647226333618
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[168]: 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_FR ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'fr'
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='fr'
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='fr'
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 = 84
AND SECI.FK_ID_IDIOMA_SI18N = 'fr')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 84)
WHERE EMP.ID_EMPRESA = 19765123
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0018389225006104Tiempo acumulado:0.34831118583679
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[169]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 82639
AND VALID = 1;
Tiempo de la consulta:
0.0061860084533691Tiempo acumulado:0.35449719429016
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[170]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 82639
AND FOTO = 'p-82639-image01671526997_16715272791231.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00064587593078613Tiempo acumulado:0.35514307022095
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[171]: SELECT F_WIDTH, F_HEIGHT
FROM LO_FOTOS
WHERE ID_PRECIO = 82639
AND FOTO = 'p-82639-image01671526997_16715272791231.jpg';
Tiempo de la consulta:
0.005436897277832Tiempo acumulado:0.36057996749878
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[172]: 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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
WHERE PRE.ID_PRECIO = 82639;
Tiempo de la consulta:
0.0039241313934326Tiempo acumulado:0.36450409889221
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[173]: 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 = 82639;
Tiempo de la consulta:
0.0022568702697754Tiempo acumulado:0.36676096916199
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[174]: SELECT N_VENTAS_LAST_MONTH
FROM LO_PRECIOS_STATS PS
WHERE PS.ID_PRECIO = 82639;
Tiempo de la consulta:
0.00089097023010254Tiempo acumulado:0.36765193939209
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[175]: 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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
WHERE ID_PRECIO = 82639
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00061202049255371Tiempo acumulado:0.36826395988464
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[176]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 82639
LIMIT 1;
Tiempo de la consulta:
0.0030651092529297Tiempo acumulado:0.37132906913757
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[177]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 82639;
Tiempo de la consulta:
0.0036101341247559Tiempo acumulado:0.37493920326233
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[178]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 82639
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.0012519359588623Tiempo acumulado:0.37619113922119
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[179]: 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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
WHERE PRE.ID_PRECIO = 82639;
Tiempo de la consulta:
0.0005640983581543Tiempo acumulado:0.37675523757935
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[180]: 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 = 82639;
Tiempo de la consulta:
0.0026109218597412Tiempo acumulado:0.37936615943909
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[181]: 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 = 84)
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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
WHERE SS.ID_SECTOR_SS=2
AND SSF.ID_TROPIC = 84
GROUP BY SSF.ID_SSF
ORDER BY COUNT(SSF.ID_SSF) DESC;
Tiempo de la consulta:
0.0042078495025635Tiempo acumulado:0.38357400894165
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[182]: 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 = 'fr'
AND ID_TROPIC = 84
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
INNER JOIN LO_REGION_STATS RS ON RS.ID_SECTOR = LSR.ID_SECTOR_RELACIONADO
AND RS.ID_REGION = 765
AND RS.N_OFERTAS > 0
WHERE LSR.ID_SECTOR = 2
AND (PR.PROVINCIA = 0 OR PR.PROVINCIA IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL, CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d'))
AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'), CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d')), CONCAT((1+ DATE_FORMAT(NOW(), '%Y')),'-', DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y'),'-', DATE_FORMAT(NOW(), '%m-%d'))),1!=1))
GROUP BY LSR.ID_SECTOR_RELACIONADO;
Tiempo de la consulta:
0.0029470920562744Tiempo acumulado:0.38652110099792
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[183]: 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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
WHERE SS.ID_TROPIC = 84
AND SS.ID_FAM_SS IN (986,929)
AND 1=1
AND (PRE.ID_REGION_PRE = 765 OR (PP.ID_REGION_PP = 765
AND PP.ID_POBLACION_PP IS NULL ))
AND 3=3
AND SHOW_LANDING = 1
GROUP BY ID_SUBSECTOR
ORDER BY ORDER_LANDING ASC;
Tiempo de la consulta:
0.0098569393157959Tiempo acumulado:0.39637804031372
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[184]: SELECT (N_OFERTAS) + (N_EMPRESAS) AS NEMPRESAS,
N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas,
PS.ID_REGION,
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_REGION_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_REGION = 765
AND PS.ID_SECTOR = 2
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.00080299377441406Tiempo acumulado:0.39718103408813
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[185]: SELECT IF(PO.ID_POBLACION = RE.ID_CAPITAL,1,2) AS CAPITAL, IF(ISNULL(N_OFERTAS),0,N_OFERTAS)+IF(ISNULL(N_EMPRESAS),0,N_EMPRESAS) AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas,
PO.ID_POBLACION, PO.DESC_POBLACION, PO.URL_POBLACION AS URL_POBLACION, PO.ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION,
'' AS DESC_SECTOR, '' AS ID_GRUPO
FROM
LO_POBLACION_PT_STATS PS
INNER JOIN LO_POBLACION_PT PO ON PS.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA = 'fr'
AND PO.ID_REGION = 765
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION
AND REI.IDIOMA = 'fr'
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE (PS.N_OFERTAS > 0 /* OR PS.N_EMPRESAS > 0 */)
AND PS.ID_SECTOR = 2
GROUP BY PS.ID_POBLACION
ORDER BY N_OFERTAS DESC;
Tiempo de la consulta:
0.012532949447632Tiempo acumulado:0.40971398353577
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[186]: 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 = 765
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00043702125549316Tiempo acumulado:0.41015100479126
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[187]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 70314
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.0012500286102295Tiempo acumulado:0.41140103340149
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: SELECT LO.ID_PRECIO
FROM LO_LANDING_OFERTAS LO
WHERE LO.STATUS = 2
AND LO.ID_SECTOR = 2
AND LO.ID_PROVINCIA = 765;
Tiempo de la consulta:
0.0010559558868408Tiempo acumulado:0.41245698928833
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: 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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
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 = 2
AND LO.ID_PROVINCIA = 765
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 2
AND ( PRE.ID_REGION_PRE='765' OR PP.ID_REGION_PP='765' )
GROUP BY PRE.ID_PRECIO
ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.010103940963745Tiempo acumulado:0.42256093025208
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: 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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
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 = 'fr'
AND SECI.ID_TROPIC = 84)
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'fr'
INNER JOIN LO_POBLACION_PT PO ON PRE.ID_POBLACION_PRE = PO.ID_POBLACION
AND PO.IDIOMA = 'fr'
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 (82639)
AND PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 2
AND ( PRE.ID_REGION_PRE='765' OR PP.ID_REGION_PP='765' )
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.003572940826416Tiempo acumulado:0.42613387107849
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[191]: 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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
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 = 2
AND LO.ID_PROVINCIA = 765
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 2
AND ( PRE.ID_REGION_PRE='765' OR PP.ID_REGION_PP='765' )
GROUP BY PRE.ID_PRECIO
ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0087821483612061Tiempo acumulado:0.4349160194397
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[192]: 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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
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 = 'fr'
AND SECI.ID_TROPIC = 84)
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'fr'
INNER JOIN LO_POBLACION_PT PO ON PRE.ID_POBLACION_PRE = PO.ID_POBLACION
AND PO.IDIOMA = 'fr'
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 (82639)
AND PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 2
AND ( PRE.ID_REGION_PRE='765' OR PP.ID_REGION_PP='765' )
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0020301342010498Tiempo acumulado:0.43694615364075
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[193]: 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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
WHERE PRE.ID_PRECIO = 82639;
Tiempo de la consulta:
0.00059700012207031Tiempo acumulado:0.43754315376282
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: 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 = 82639;
Tiempo de la consulta:
0.00046300888061523Tiempo acumulado:0.43800616264343
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: 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 = 2
AND ID_REGION = 765
AND ID_POBLACION IS NULL
AND ID_REGION_ADM IS NULL
AND ID_PAIS IS NULL
GROUP BY ID_OPINION
ORDER BY ID_OPINION DESC
LIMIT 6;
Tiempo de la consulta:
0.0031068325042725Tiempo acumulado:0.44111299514771
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[196]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
FROM LO_REGION_STATS
WHERE ID_REGION = 765
AND ID_SECTOR = 2;
Tiempo de la consulta:
0.00040006637573242Tiempo acumulado:0.44151306152344
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_FR ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'fr'
WHERE EMP.ID_EMPRESA = 19765128;
Tiempo de la consulta:
0.00049400329589844Tiempo acumulado:0.44200706481934
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[198]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '2'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
AND SECI.ID_TROPIC = 8;
Tiempo de la consulta:
0.00052285194396973Tiempo acumulado:0.44252991676331
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[199]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '2'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
AND SECI.ID_TROPIC = 84;
Tiempo de la consulta:
0.00089716911315918Tiempo acumulado:0.44342708587646
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765128;
Tiempo de la consulta:
0.0004730224609375Tiempo acumulado:0.4439001083374
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765123;
Tiempo de la consulta:
0.00031590461730957Tiempo acumulado:0.44421601295471
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_FR ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'fr'
WHERE EMP.ID_EMPRESA = 19765128;
Tiempo de la consulta:
0.00095582008361816Tiempo acumulado:0.44517183303833
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[203]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '2'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
AND SECI.ID_TROPIC = 8;
Tiempo de la consulta:
0.00082206726074219Tiempo acumulado:0.44599390029907
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '2'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
AND SECI.ID_TROPIC = 84;
Tiempo de la consulta:
0.00046110153198242Tiempo acumulado:0.44645500183105
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[205]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765128;
Tiempo de la consulta:
0.0006868839263916Tiempo acumulado:0.44714188575745
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765123;
Tiempo de la consulta:
0.00037693977355957Tiempo acumulado:0.44751882553101
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_FR ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'fr'
WHERE EMP.ID_EMPRESA = 19765128;
Tiempo de la consulta:
0.00042581558227539Tiempo acumulado:0.44794464111328
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '2'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
AND SECI.ID_TROPIC = 8;
Tiempo de la consulta:
0.00047802925109863Tiempo acumulado:0.44842267036438
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '2'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
AND SECI.ID_TROPIC = 84;
Tiempo de la consulta:
0.0026490688323975Tiempo acumulado:0.45107173919678
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[210]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765128;
Tiempo de la consulta:
0.00036191940307617Tiempo acumulado:0.45143365859985
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[211]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765123;
Tiempo de la consulta:
0.00043010711669922Tiempo acumulado:0.45186376571655
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[212]: SELECT SECI.DESC_SECTOR,REI.URL,ID_EMPRESA,SECI.URL URL_SECTOR,EMP.ID_EMPRESA, SECI.ID_SECTOR, EMP.EMP_MADRE, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, GRU.ID_GRUPO
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_FR ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'fr'
INNER JOIN LO_REGION RE ON EMP.ID_PROVINCIA=RE.ID_REGION
INNER JOIN LO_REGION_I18N REI ON RE.ID_REGION=REI.ID_REGION
AND REI.IDIOMA = 'fr'
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='84'
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND ( GRU.ID_TROPIC = 84)
WHERE
SECI.FK_ID_IDIOMA_SI18N='fr'
AND EMP.ID_EMPRESA='19765123'
LIMIT 1;
Tiempo de la consulta:
0.0015029907226562Tiempo acumulado:0.45336675643921
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[213]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765128
AND VALID = 1;
Tiempo de la consulta:
0.0048480033874512Tiempo acumulado:0.45821475982666
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[214]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765128
AND FOTO = 'e-19765128-logo-porta-do-mezio167145813716714582988216.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00045418739318848Tiempo acumulado:0.45866894721985
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[215]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765128
AND VALID = 1;
Tiempo de la consulta:
0.00066804885864258Tiempo acumulado:0.45933699607849
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[216]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765128
AND FOTO = 'e-19765128-image0167145810916714582938321.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051283836364746Tiempo acumulado:0.45984983444214
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[217]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19765128;
Tiempo de la consulta:
0.0011920928955078Tiempo acumulado:0.46104192733765
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[218]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765128
AND VALID = 1;
Tiempo de la consulta:
0.00084090232849121Tiempo acumulado:0.46188282966614
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[219]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765128
AND FOTO = 'e-19765128-image0167145810916714582938321.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0006251335144043Tiempo acumulado:0.46250796318054
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[220]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19765128;
Tiempo de la consulta:
0.00064492225646973Tiempo acumulado:0.46315288543701
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[221]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765128
AND VALID = 1;
Tiempo de la consulta:
0.00084495544433594Tiempo acumulado:0.46399784088135
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[222]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765128
AND FOTO = 'e-19765128-image0167145810916714582938321.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00076699256896973Tiempo acumulado:0.46476483345032
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[223]: 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 = 84)
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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
WHERE SS.ID_SECTOR_SS=2
AND SSF.ID_TROPIC = 84
GROUP BY SSF.ID_SSF
ORDER BY COUNT(SSF.ID_SSF) DESC;
Tiempo de la consulta:
0.0046288967132568Tiempo acumulado:0.46939373016357
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[224]: 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 = 'fr'
AND ID_TROPIC = 84
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 = 2
AND (PRE.ID_REGION_PRE = 765 OR ID_REGION_PP = 765)
AND (PR.PROVINCIA = 0 OR PR.PROVINCIA IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL, CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d'))
AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'), CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d')), CONCAT((1+ DATE_FORMAT(NOW(), '%Y')),'-', DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y'),'-', DATE_FORMAT(NOW(), '%m-%d'))),1!=1))
GROUP BY LSR.ID_SECTOR_RELACIONADO;
Tiempo de la consulta:
0.0013790130615234Tiempo acumulado:0.4707727432251
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[225]: 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_FR PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'fr'
WHERE SS.ID_TROPIC = 84
AND SS.ID_FAM_SS IN (986,929)
AND 1=1
AND (PRE.ID_REGION_PRE = 765 OR (PP.ID_REGION_PP = 765
AND PP.ID_POBLACION_PP IS NULL ))
AND SHOW_LANDING = 1
GROUP BY ID_SUBSECTOR
ORDER BY ORDER_LANDING ASC;
Tiempo de la consulta:
0.0085740089416504Tiempo acumulado:0.47934675216675
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[226]: SELECT SEO.DESCRIPTION
FROM LO_SEO_DESCRIPTIONS SEO
WHERE SEO.ID_TROPIC='84'
AND SEO.ID_KEY='S2';
Tiempo de la consulta:
0.00091004371643066Tiempo acumulado:0.48025679588318
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[227]: 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 = 84
WHERE SEOHOME.ID_TROPIC = 84
AND SEOHOME.ID_KEY = 'S2'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='765';
Tiempo de la consulta:
0.0081489086151123Tiempo acumulado:0.48840570449829
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[228]: 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 = 'fr'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
AND REI.IDIOMA = 'fr'
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='84'
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
WHERE
REI.ID_REGION = 765
AND PS.ID_SECTOR = 2
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.0022339820861816Tiempo acumulado:0.49063968658447
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[229]: 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 = 765
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00039792060852051Tiempo acumulado:0.49103760719299
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[230]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 70314
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00036001205444336Tiempo acumulado:0.49139761924744
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[231]: 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 = 'fr'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
AND REI.IDIOMA = 'fr'
INNER JOIN LO_POBLACION_PT_STATS POS ON POS.ID_POBLACION = PO.ID_POBLACION
AND POS.ID_SECTOR = 2
AND POS.N_OFERTAS > 1
WHERE PRM.ID_REGION = 765;
Tiempo de la consulta:
0.0011119842529297Tiempo acumulado:0.49250960350037
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[232]: 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 = 'fr'
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 = 6
INNER JOIN LO_SECTORES_I18N SECI ON PS.ID_SECTOR = SECI.ID_SECTOR
AND SECI.ID_TROPIC='84'
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
WHERE
REI.ID_REGION = 765
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.00086307525634766Tiempo acumulado:0.49337267875671
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[233]: SELECT COUNT(*) AS NEMPRESAS
FROM LO_REGION_STATS
WHERE ID_REGION = 765
AND ID_GRUPO = 6;
Tiempo de la consulta:
0.00041103363037109Tiempo acumulado:0.49378371238708
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[234]: 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 = '765'
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00038290023803711Tiempo acumulado:0.49416661262512
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[235]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S6'
AND (SEO.ID_TROPIC = 84
);
Tiempo de la consulta:
0.00042605400085449Tiempo acumulado:0.49459266662598
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[236]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S2'
AND (SEO.ID_TROPIC = 84
);
Tiempo de la consulta:
0.00040507316589355Tiempo acumulado:0.49499773979187
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[237]: SELECT *
FROM LO_REGION
INNER JOIN LO_REGION_I18N ON LO_REGION.ID_REGION = LO_REGION_I18N.ID_REGION
WHERE IDIOMA = 'fr'
ORDER BY DESC_REGION ASC;
Tiempo de la consulta:
0.00063896179199219Tiempo acumulado:0.49563670158386
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[238]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 84;
Tiempo de la consulta:
0.00094294548034668Tiempo acumulado:0.49657964706421
