yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/empresa.php
BBDD->Prod_Yumping_co_UK
AMBITO->gb_es
AMBITO_AJAX->gb_es
AMBITO_AJAX COOKIE->gb_mx
locale LO_CONFIG->es_GB
locale php->es_GB
Fuente tráfico->0
SESSION VARS
DEFINED VARS
$tpage->
empresaCache 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->es_ES
id_empresa->19651895
tpage->empresa
nomb_emp->aquanauts-divecentre
rel_alternate->1
Total queries: 221
Tiempo total: 0.27173852920532
(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', 'es')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0070068836212158Tiempo acumulado:0.0070068836212158
(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.00058603286743164Tiempo acumulado:0.0075929164886475
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[3]: SELECT ID_PAIS
FROM ( SELECT EMP.ID_PAIS
FROM Prod_Yumping_es_ES.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19651895
AND fnGoogleUrl(EMP.NOMBRE) = 'aquanauts-divecentre' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_pt_PT.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19651895
AND fnGoogleUrl(EMP.NOMBRE) = 'aquanauts-divecentre' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_it_IT.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19651895
AND fnGoogleUrl(EMP.NOMBRE) = 'aquanauts-divecentre' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19651895
AND fnGoogleUrl(EMP.NOMBRE) = 'aquanauts-divecentre' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19651895
AND fnGoogleUrl(EMP.NOMBRE) = 'aquanauts-divecentre' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_mx_MX.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19651895
AND fnGoogleUrl(EMP.NOMBRE) = 'aquanauts-divecentre' ) AS EMPRESA;
Tiempo de la consulta:
0.012618064880371Tiempo acumulado:0.020210981369019
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[4]: SELECT *
FROM LO_CONFIG C
WHERE C.AMBITO = (
SELECT AMBITO
FROM LO_CONFIG C
WHERE CONCAT('/',C.VALUE) = ''
AND NAME = 'Request_url_partner'
LIMIT 1)
AND (NAME = 'subdomain' OR NAME = 'subdomain_lang');
Tiempo de la consulta:
0.0013730525970459Tiempo acumulado:0.021584033966064
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[5]: 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', 'gb_es')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0070579051971436Tiempo acumulado:0.028641939163208
(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.00037288665771484Tiempo acumulado:0.029014825820923
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[7]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00030803680419922Tiempo acumulado:0.029322862625122
(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 = 'ambito_lang';
Tiempo de la consulta:
0.00048279762268066Tiempo acumulado:0.029805660247803
(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 = 'id_empresa';
Tiempo de la consulta:
0.00035715103149414Tiempo acumulado:0.030162811279297
(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 = 'tpage';
Tiempo de la consulta:
0.0043258666992188Tiempo acumulado:0.034488677978516
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[11]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'nomb_emp';
Tiempo de la consulta:
0.0060100555419922Tiempo acumulado:0.040498733520508
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[12]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'rel_alternate';
Tiempo de la consulta:
0.001539945602417Tiempo acumulado:0.042038679122925
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[13]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
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='es'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_GB PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='es'
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 = 21
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 21)
WHERE EMP.ID_EMPRESA = 19651895
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0104079246521Tiempo acumulado:0.052446603775024
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[14]: SELECT EMP.COMO_LLEGAR COMO_LLEGAR_ORI, EMP.GALERIA_DESC GALERIA_DESC_ORI, EMP.VIDEOS_TEXT VIDEOS_TEXT_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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
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='es'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_GB PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='es'
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 = 21
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 21)
WHERE EMP.ID_MADRE = 19651895
AND EMP.EMP_MADRE IN(2,4)
AND EMP.VALID IN ('1', '-3');
Tiempo de la consulta:
0.00148606300354Tiempo acumulado:0.053932666778564
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[15]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.0014269351959229Tiempo acumulado:0.055359601974487
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: SELECT SEC.EXCLUYE_ALOJAMIENTO
FROM LO_SECTORES SEC
WHERE ID_SECTOR = 8
AND EXCLUYE_ALOJAMIENTO = 0;
Tiempo de la consulta:
0.00036907196044922Tiempo acumulado:0.055728673934937
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[17]: SELECT count(*)*2 AS N_OPIS, ROUND(AVG(VALORACION),2) AS VALORACION, ROUND(AVG(PRECIO),2) AS PRECIO, ROUND(AVG(RIESGO),2) AS RIESGO, ROUND(AVG(ATENCION),2) AS ATENCION, ROUND(AVG(PAREJA),2) AS PAREJA, ROUND(AVG(AMIGOS),2) AS AMIGOS, ROUND(AVG(TEAMBUILDING),2) AS TEAMBUILDING, ROUND(AVG(FAMILIA),2) AS FAMILIA, ROUND(AVG(NINOS),2) AS NINOS, ROUND(AVG(DESPEDIDAS),2) AS DESPEDIDAS, ROUND(AVG(REGALAR),2) AS REGALAR
FROM LO_EMPRESAS_OPINIONES_GOOGLE
WHERE ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00098919868469238Tiempo acumulado:0.056717872619629
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[18]: SELECT TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,
GALERIA_DESC_PRE,HORARIO_PRE, ID_PRECIO , SECI.ID_SECTOR,
SECI.URL URL_SECTOR,REI.URL URL_REGION,PRE.PRECIO_UNITARIO_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, PRE.FK_ID_PAIS_PRE AS ID_PAIS, COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS,
DESCUENTO_MIN_PRE DESCUENTO, PRE.FOTOPRINCIPAL_PRE,
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(MAX(RC.FEC_INSERT_RC),'%Y/%m/%d') AS FECHA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM,
OP.VALORACION,COUNT(OP.ID_OPINION) AS OPIS, PD.OFERTA_PD,VALID_PD,
PRE.MIN_PERS_PRE, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE,
PRE.COMIDA_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,
PRE.TRANSPORTE_PRE,REI.DESC_REGION, PRE.MULTIACTIVIDAD_PRE, SECI.DESC_SECTOR
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
INNER JOIN LO_REGION_I18N REI ON PRE.ID_REGION_PRE=REI.ID_REGION
INNER JOIN LO_SECTORES_I18N SECI ON SECP.ID_ACTIVIDAD_PS=SECI.ID_SECTOR
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
AND RC.VALID_RC NOT IN(0,2,6,7)
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID=1
WHERE SECI.ID_TROPIC='21'
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND REI.IDIOMA='es'
AND VALID_PRE IN(4)
AND SEC.ID_SECTOR = 8
AND REI.ID_REGION = 3137
AND PRE.ID_EMPRESA_PRE !='19651895'
GROUP BY ID_PRECIO
ORDER BY VENTAS DESC, OFERTA_PD DESC, N_ORDER_EMP_PRE IS NULL ASC,N_ORDER_EMP_PRE ASC,N_ORDER_PRE DESC,PRECIO ASC
LIMIT 3;
Tiempo de la consulta:
0.01004695892334Tiempo acumulado:0.066764831542969
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[19]: 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 = '3137'
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.0003960132598877Tiempo acumulado:0.067160844802856
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[20]: SELECT IF(EMP.TIPOCUENTA = '4',
ROUND((RAND() * (500-400))+500),
IF(EMP.TIPOCUENTA = '3',
ROUND((RAND() * (400-300))+400),
IF(EMP.TIPOCUENTA = '2'
AND EMP.PRECIO_ACTIVIDAD != 0,
ROUND((RAND() * (300-400))+300),
0))) AS ORDENA,
EMP.EMP_MADRE,EMP.PUNTOS, EMP.ID_EMPRESA, EMP.ID_MADRE, EMP.DESCRIPCION,EMP.COLAB_EMPRESAS,EMP.CLIENTE , EMP.ID_PROVINCIA, EMP.ID_POBLACION,
EMP.COD_POSTAL, EMP.DIRECCION, EMP.MAIL, EMP.TELEFONO, EMP.TELEFONOMOVIL, EMP.FAX, EMP.WEB,SECI.URL URL_SECTOR,
REI.DESC_REGION, PO.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
,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA,
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.DESC_GRUPO
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
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='es'
LEFT JOIN LO_POBLACION_GB PO ON PO.ID_POBLACION=EMP.ID_POBLACION
AND PO.IDIOMA='es'
/*
LEFT JOIN LO_POBLACION_I18N POI ON POI.ID_POBLACION=PO.ID_POBLACION */
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='21'
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND EMP.EMP_MADRE <> '0'
AND SEC.ID_SECTOR='8'
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND GRU.ID_TROPIC = '21'
/*
LEFT JOIN LO_EMPRESAS_SNIPPETS_RELACIONES ESR ON ESR.ID_EMPRESA = EMP.ID_EMPRESA
AND ESR.ID_TROPIC = '21' */
WHERE EMP.VALID=1
AND EMP.ID_EMPRESA > '19651895'
AND EMP.ID_PROVINCIA='3137'
AND EMP.EMP_MADRE <> '3'
GROUP BY EMP.ID_EMPRESA
ORDER BY EMP.ID_EMPRESA ASC
LIMIT 4;
Tiempo de la consulta:
0.01323413848877Tiempo acumulado:0.080394983291626
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[21]: SELECT GALERIA,GALERIA_DESC
FROM LO_EMPRESAS_OPINIONES OP
WHERE (OP.ID_EMPRESA='19651895'
OR OP.ID_MADRE='19651895' )
AND OP.VALID=1
AND GALERIA IS NOT NULL
AND GALERIA NOT IN('')
ORDER BY OP.FEC_INSERT DESC;
Tiempo de la consulta:
0.00060582160949707Tiempo acumulado:0.081000804901123
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[22]: SELECT EMP_MADRE, ID_MADRE, ID_SECTOR
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00040698051452637Tiempo acumulado:0.081407785415649
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[23]: SELECT PRECIO_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, PRECIO_PD,
ID_DESCUENTO_PD,ID_PRECIO,DATE_FORMAT(FECHA_CADUCIDAD_PD,'%d/%m/%Y') FEC_CAD,
INCLUYE_PRE,GALERIA_PRE,FOTOPRINCIPAL_PRE,PRECIO_PRE,
EMP.URL URL,SECI.URL URL_SECTOR,REI.URL URL_REGION,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO,
if(PRECIO_PD>0, (1-(MIN(PRECIO_PD)/PRECIO_PRE))*100 ,0) DESCUENTO
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
INNER JOIN LO_PRECIOS_DESCUENTOS PD ON PRE.ID_PRECIO=PD.ID_PRECIO_PD
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
INNER JOIN LO_SECTORES SEC ON SECP.ID_ACTIVIDAD_PS=SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
INNER JOIN LO_POBLACION_I18N POI ON POI.ID_POBLACION=PRE.ID_POBLACION_PRE
WHERE SECI.ID_TROPIC='21'
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND REI.IDIOMA='es'
AND ID_EMPRESA='19651895'
AND VALID_PD=1
AND OFERTA_PD=1
AND SECP.ID_ACTIVIDAD_PS = 8
AND PRE.VALID_PRE = 4
ORDER BY FECHA_CADUCIDAD_PD DESC
LIMIT 1;
Tiempo de la consulta:
0.0016930103302002Tiempo acumulado:0.08310079574585
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[24]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00046610832214355Tiempo acumulado:0.083566904067993
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[25]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 247
AND IDIOMA = 'es';
Tiempo de la consulta:
0.0010900497436523Tiempo acumulado:0.084656953811646
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[26]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.`URL` AS URL_REGION, REIA.ID_REGION_ADM1, REIA.DESC_REGION AS DESC_ADM,
REIA.`URL` AS URL_ADM, P.ID_PAIS, P.DESC_PAIS, P.`URL` AS URL_PAIS
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 = 'es'
LEFT JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA = 'es'
AND (SELECT COUNT(RE2.ID_REGION)
FROM LO_REGION RE2
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE2.ID_REGION
AND REI.IDIOMA = 'es'
WHERE RE2.ID_REGION_ADM1 = RE.ID_REGION_ADM1) > 1
INNER JOIN LO_PAIS_I18N P ON P.ID_PAIS = RE.ID_PAIS
AND P.IDIOMA = 'es'
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.001209020614624Tiempo acumulado:0.08586597442627
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[27]: SELECT *
FROM LO_REGION_ADM1_STATS RS
WHERE RS.ID_SECTOR = 8
AND RS.ID_REGION_ADM1 = 82
AND N_OFERTAS > 0;
Tiempo de la consulta:
0.00053000450134277Tiempo acumulado:0.086395978927612
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[28]: SELECT *
FROM LO_REGION_STATS RS
WHERE RS.ID_SECTOR = 8
AND RS.ID_REGION = 3137
AND ID_GRUPO = 0
AND ID_SUBSECTOR = 0
AND N_OFERTAS > 0;
Tiempo de la consulta:
0.00047492980957031Tiempo acumulado:0.086870908737183
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[29]: SELECT *
FROM LO_POBLACION_GB_STATS P
WHERE P.ID_SECTOR = 8
AND ID_POBLACION = 985828
AND N_OFERTAS > 0;
Tiempo de la consulta:
0.00046396255493164Tiempo acumulado:0.087334871292114
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[30]: 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 = 3137
AND REI.IDIOMA = 'en';
Tiempo de la consulta:
0.00039792060852051Tiempo acumulado:0.087732791900635
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[31]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_GB PO
WHERE PO.ID_POBLACION = 985828
AND PO.IDIOMA = 'en';
Tiempo de la consulta:
0.00036096572875977Tiempo acumulado:0.088093757629395
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[32]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00048112869262695Tiempo acumulado:0.088574886322021
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[33]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/buceo/aquanauts-divecentre--e19651895';
Tiempo de la consulta:
0.00073599815368652Tiempo acumulado:0.089310884475708
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055313110351562Tiempo acumulado:0.089864015579224
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[35]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044488906860352Tiempo acumulado:0.090308904647827
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044703483581543Tiempo acumulado:0.090755939483643
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[37]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 2
AND SECI.FK_ID_IDIOMA_SI18N = 'en')
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00055885314941406Tiempo acumulado:0.091314792633057
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[38]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043797492980957Tiempo acumulado:0.091752767562866
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004420280456543Tiempo acumulado:0.092194795608521
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047802925109863Tiempo acumulado:0.092672824859619
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004270076751709Tiempo acumulado:0.09309983253479
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[42]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 23
AND SECI.FK_ID_IDIOMA_SI18N = 'it')
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00056195259094238Tiempo acumulado:0.093661785125732
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[43]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045514106750488Tiempo acumulado:0.094116926193237
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043201446533203Tiempo acumulado:0.094548940658569
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042486190795898Tiempo acumulado:0.094973802566528
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042104721069336Tiempo acumulado:0.095394849777222
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[47]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 24
AND SECI.FK_ID_IDIOMA_SI18N = 'fr')
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00052905082702637Tiempo acumulado:0.095923900604248
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043201446533203Tiempo acumulado:0.09635591506958
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050497055053711Tiempo acumulado:0.096860885620117
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[50]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047183036804199Tiempo acumulado:0.097332715988159
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043201446533203Tiempo acumulado:0.097764730453491
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[52]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 27
AND SECI.FK_ID_IDIOMA_SI18N = 'de')
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.0005648136138916Tiempo acumulado:0.098329544067383
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044989585876465Tiempo acumulado:0.098779439926147
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[54]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004570484161377Tiempo acumulado:0.099236488342285
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[55]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044989585876465Tiempo acumulado:0.09968638420105
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004279613494873Tiempo acumulado:0.10011434555054
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[57]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 28
AND SECI.FK_ID_IDIOMA_SI18N = 'pt')
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00055193901062012Tiempo acumulado:0.10066628456116
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.10109734535217
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[59]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045990943908691Tiempo acumulado:0.10155725479126
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047516822814941Tiempo acumulado:0.10203242301941
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043606758117676Tiempo acumulado:0.10246849060059
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[62]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 25
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00053811073303223Tiempo acumulado:0.10300660133362
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0026609897613525Tiempo acumulado:0.10566759109497
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047707557678223Tiempo acumulado:0.10614466667175
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044703483581543Tiempo acumulado:0.10659170150757
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[66]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043916702270508Tiempo acumulado:0.10703086853027
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[67]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 26
AND SECI.FK_ID_IDIOMA_SI18N = 'ch')
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00057101249694824Tiempo acumulado:0.10760188102722
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048303604125977Tiempo acumulado:0.10808491706848
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043988227844238Tiempo acumulado:0.10852479934692
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042915344238281Tiempo acumulado:0.10895395278931
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[71]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004270076751709Tiempo acumulado:0.10938096046448
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040602684020996Tiempo acumulado:0.10978698730469
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044107437133789Tiempo acumulado:0.11022806167603
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[74]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042486190795898Tiempo acumulado:0.11065292358398
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043010711669922Tiempo acumulado:0.11108303070068
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040984153747559Tiempo acumulado:0.11149287223816
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.11197185516357
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[78]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047397613525391Tiempo acumulado:0.11244583129883
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[79]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043201446533203Tiempo acumulado:0.11287784576416
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042605400085449Tiempo acumulado:0.11330389976501
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045895576477051Tiempo acumulado:0.11376285552979
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.1141939163208
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[83]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042200088500977Tiempo acumulado:0.11461591720581
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043487548828125Tiempo acumulado:0.11505079269409
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042009353637695Tiempo acumulado:0.11547088623047
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[86]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042605400085449Tiempo acumulado:0.11589694023132
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041508674621582Tiempo acumulado:0.11631202697754
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043606758117676Tiempo acumulado:0.11674809455872
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042510032653809Tiempo acumulado:0.11717319488525
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[90]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041413307189941Tiempo acumulado:0.11758732795715
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[91]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041913986206055Tiempo acumulado:0.11800646781921
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041508674621582Tiempo acumulado:0.11842155456543
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044608116149902Tiempo acumulado:0.11886763572693
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044393539428711Tiempo acumulado:0.11931157112122
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[95]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004420280456543Tiempo acumulado:0.11975359916687
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042390823364258Tiempo acumulado:0.12017750740051
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042581558227539Tiempo acumulado:0.12060332298279
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[98]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046610832214355Tiempo acumulado:0.12106943130493
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004270076751709Tiempo acumulado:0.1214964389801
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041604042053223Tiempo acumulado:0.12191247940063
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040793418884277Tiempo acumulado:0.12232041358948
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[102]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045680999755859Tiempo acumulado:0.12277722358704
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[103]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00069689750671387Tiempo acumulado:0.12347412109375
(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 = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.12390518188477
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[105]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00055193901062012Tiempo acumulado:0.12445712089539
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[106]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00035595893859863Tiempo acumulado:0.12481307983398
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[107]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00044798851013184Tiempo acumulado:0.12526106834412
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[108]: 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_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE = EMP.ID_EMPRESA
WHERE EMP.ID_EMPRESA = 19651895
AND EMP.VALID IN (1,-3)
AND PRE.VALID_PRE = 4
UNION ALL
SELECT MIN(PD.PRECIO_PD) MIN_PRECIO, MAX(PD.PRECIO_PD) MAX_PRECIO
FROM LO_PRECIOS PRE
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.ID_EMPRESA = 19651895
AND EMP.VALID IN (1,-3)
AND PRE.VALID_PRE = 4
AND PD.VALID_PD = 1
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
WHERE EMP.ID_EMPRESA = 19651895 OR EMP.ID_MADRE = 19651895
AND EMP.VALID IN (1 ,- 3)
AND EMP.PRECIO_ACTIVIDAD !=0
) AS PRECIO_MIN_MAX;
Tiempo de la consulta:
0.0014851093292236Tiempo acumulado:0.12674617767334
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[109]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00081086158752441Tiempo acumulado:0.12755703926086
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[110]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00036406517028809Tiempo acumulado:0.12792110443115
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[111]: SELECT *
FROM LO_CASAS
WHERE ID_EMPRESA_CA='19651895'
AND VALID_CA=1
AND CLIENTE_CA=1
ORDER BY RAND()
LIMIT 1;
Tiempo de la consulta:
0.0021090507507324Tiempo acumulado:0.13003015518188
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[112]: SELECT *,(6378*acos(cos(radians('50.369'))*cos(radians(LATITUD_CA))*cos(radians(LONGITUD_CA)-radians('-4.13495')) +sin(radians('50.369'))*sin(radians(LATITUD_CA)))) AS DISTANCIA
FROM LO_CASAS WHERE
VALID_CA=1
AND CLIENTE_CA=1
HAVING DISTANCIA < 30
LIMIT 10;
Tiempo de la consulta:
0.00068521499633789Tiempo acumulado:0.13071537017822
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[113]: SELECT *
FROM LO_TOPRURAL_GB
WHERE FK_ID_EMPRESA_TR='19651895'
LIMIT 10;
Tiempo de la consulta:
0.0010671615600586Tiempo acumulado:0.13178253173828
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[114]: SELECT *,(6378*acos(cos(radians('50.369'))*cos(radians(LATITUD_TR))*cos(radians(LONGITUD_TR)-radians('-4.13495')) +sin(radians('50.369'))*sin(radians(LATITUD_TR)))) AS DISTANCIA
FROM LO_TOPRURAL_GB
WHERE ID_PAIS_TR='247'
AND PRECIO_MEDIO_TR<>0
AND COMENTARIOS_TR<>''
AND DIRECCION_TR<>''
AND FK_ID_EMPRESA_TR<>'19651895'
HAVING DISTANCIA < 30
LIMIT 10;
Tiempo de la consulta:
0.00058507919311523Tiempo acumulado:0.1323676109314
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[115]: SELECT COUNT(ID_REGALO) AS CUENTA
FROM LO_REGALOS
WHERE FK_ID_CUSTOMER_REGALO IN (SELECT ID_EMPRESA
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19651895
OR EMP.ID_MADRE= 19651895
AND EMP.VALID=1)
AND STATUS_REGALO='1'
LIMIT 3;
Tiempo de la consulta:
0.0015718936920166Tiempo acumulado:0.13393950462341
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[116]: SELECT ID_EMPRESA, NOMBRE,IF(EMP_MADRE = 0,GRU.URL,SECI.URL) AS URL_SECTOR, ID_MADRE, SECI.ID_SECTOR,
IF(EMP_MADRE = 0,GRU.DESC_GRUPO,SECI.DESC_SECTOR) AS DESC_SECTOR, EMP_MADRE
FROM LO_EMPRESAS EMP
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = EMP.ID_SECTOR
AND SECI.ID_TROPIC = 21
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
LEFT JOIN LO_GRUPOS GRU ON GRU.ID_SECTOR = EMP.ID_SECTOR
AND GRU.ID_TROPIC = 21
WHERE EMP.ID_EMPRESA = 19651895 OR EMP.ID_MADRE = 19651895
AND EMP.VALID = 1
AND EMP.EMP_MADRE NOT IN(1,3)
ORDER BY EMP_MADRE,DESC_SECTOR;
Tiempo de la consulta:
0.00087594985961914Tiempo acumulado:0.13481545448303
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[117]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00047397613525391Tiempo acumulado:0.13528943061829
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[118]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND VALID = 1;
Tiempo de la consulta:
0.0042200088500977Tiempo acumulado:0.13950943946838
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[119]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND FOTO = 'Aquanauts.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00050997734069824Tiempo acumulado:0.14001941680908
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[120]: SELECT EMP_MADRE, ID_MADRE, ID_SECTOR
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00039911270141602Tiempo acumulado:0.1404185295105
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[121]: SELECT PRECIO_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, PRECIO_PD,
ID_DESCUENTO_PD,ID_PRECIO,DATE_FORMAT(FECHA_CADUCIDAD_PD,'%d/%m/%Y') FEC_CAD,
INCLUYE_PRE,GALERIA_PRE,FOTOPRINCIPAL_PRE,PRECIO_PRE,
EMP.URL URL,SECI.URL URL_SECTOR,REI.URL URL_REGION,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO,
if(PRECIO_PD>0, (1-(MIN(PRECIO_PD)/PRECIO_PRE))*100 ,0) DESCUENTO
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
INNER JOIN LO_PRECIOS_DESCUENTOS PD ON PRE.ID_PRECIO=PD.ID_PRECIO_PD
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
INNER JOIN LO_SECTORES SEC ON SECP.ID_ACTIVIDAD_PS=SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
INNER JOIN LO_POBLACION_I18N POI ON POI.ID_POBLACION=PRE.ID_POBLACION_PRE
WHERE SECI.ID_TROPIC='21'
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND REI.IDIOMA='es'
AND ID_EMPRESA='19651895'
AND VALID_PD=1
AND OFERTA_PD=1
AND SECP.ID_ACTIVIDAD_PS = 8
AND PRE.VALID_PRE = 4
ORDER BY FECHA_CADUCIDAD_PD DESC
LIMIT 1;
Tiempo de la consulta:
0.0012478828430176Tiempo acumulado:0.14166641235352
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[122]: SELECT N_VENTAS_EST, FEC_ULT_COMPRA
FROM LO_EMPRESAS_STAT
WHERE FK_ID_EST = 19651895
AND N_VENTAS_EST > 0
LIMIT 1;
Tiempo de la consulta:
0.00037789344787598Tiempo acumulado:0.14204430580139
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[123]: SELECT OP.GALERIA,OP.GALERIA_DESC, OP.RESERVA_FEEDBACK, OP.SOLICITUD_FEEDBACK,
COM.ID_USER,OP.ID_OPINION, COM.NOMBRE, DATE_FORMAT(OP.FEC_INSERT, '%d/%m/%y') AS FECHA
FROM LO_EMPRESAS_OPINIONES OP
INNER JOIN LO_COM_USERS COM ON COM.ID_USER = OP.ID_USER
WHERE (OP.ID_EMPRESA='19651895'
OR OP.ID_MADRE='19651895' )
AND OP.VALID=1
AND OP.GALERIA IS NOT NULL
AND OP.GALERIA NOT IN('')
ORDER BY OP.ID_OPINION DESC;
Tiempo de la consulta:
0.0017430782318115Tiempo acumulado:0.1437873840332
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[124]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND VALID = 1;
Tiempo de la consulta:
0.00065207481384277Tiempo acumulado:0.14443945884705
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[125]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND FOTO = 'Amazing underwater diving.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0035459995269775Tiempo acumulado:0.14798545837402
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[126]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND FOTO = 'Amazing underwater diving.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00047397613525391Tiempo acumulado:0.14845943450928
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[127]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND FOTO = 'Amazing underwater diving.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0012171268463135Tiempo acumulado:0.14967656135559
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[128]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND VALID = 1;
Tiempo de la consulta:
0.00074005126953125Tiempo acumulado:0.15041661262512
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[129]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND FOTO = 'Their RIB.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0005497932434082Tiempo acumulado:0.15096640586853
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[130]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND FOTO = 'Their RIB.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0005340576171875Tiempo acumulado:0.15150046348572
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[131]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND FOTO = 'Their RIB.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0015270709991455Tiempo acumulado:0.15302753448486
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[132]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND VALID = 1;
Tiempo de la consulta:
0.0020380020141602Tiempo acumulado:0.15506553649902
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[133]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND FOTO = 'Underwater creatures.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00050997734069824Tiempo acumulado:0.15557551383972
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[134]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND FOTO = 'Underwater creatures.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0061600208282471Tiempo acumulado:0.16173553466797
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[135]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND FOTO = 'Underwater creatures.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0022790431976318Tiempo acumulado:0.1640145778656
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[136]: SELECT EMP_MADRE, ID_MADRE, ID_SECTOR
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.0016040802001953Tiempo acumulado:0.1656186580658
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[137]: SELECT PRE.ID_PRECIO,PRE.TITULO_PRE,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO, PRE.FOTOPRINCIPAL_PRE, PRE.FK_ID_PAIS_PRE AS ID_PAIS,
POI.URL_POBLACION, POI.DESC_POBLACION, POI.ID_POBLACION, REI.URL URL_REGION, REI.DESC_REGION,REI.ID_REGION, SECI.ID_SECTOR, SECI.URL URL_SECTOR, SECI.DESC_SECTOR,PRE.PRECIO_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, MULTIACTIVIDAD_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD=1
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'es'
INNER JOIN LO_POBLACION_GB POI ON POI.ID_POBLACION = PRE.ID_POBLACION_PRE
AND POI.IDIOMA = 'es'
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND SECI.ID_TROPIC = 21
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE EMP.ID_EMPRESA = 19651895
AND PRE.VALID_PRE = 4
AND (PR.FICHA = 0 OR PR.FICHA 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 N_VENTAS_PRE DESC, PRECIO ASC
LIMIT 3;
Tiempo de la consulta:
0.0071320533752441Tiempo acumulado:0.17275071144104
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[138]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
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='es'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_GB PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='es'
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 = 21
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 21)
WHERE EMP.ID_EMPRESA = 19651895
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0041821002960205Tiempo acumulado:0.17693281173706
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[139]: SELECT TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, PRE.ID_PRECIO ,SECI.ID_SECTOR, SECI.URL URL_SECTOR,REI.URL URL_REGION, PRE.FK_ID_PAIS_PRE AS ID_PAIS,
/*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,
IF(PD.PRECIO_PD > 0
AND PD.VALID_PD = 1,
LEAST(MIN(PD.PRECIO_PD), PRE.PRECIO_PRE),
LEAST(999999999, PRECIO_PRE)) AS PRECIO,
PRECIO_PRE, COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS,
IF(PD.PRECIO_PD > 0
AND PD.VALID_PD = 1,
(1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO,
DESCUENTO_MIN_PRE DESCUENTO, PRE.FOTOPRINCIPAL_PRE,PRE.PRECIO_UNITARIO_PRE,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%d') AS DIA_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%m') AS MES_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%Y') AS ANYO_CAD,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM,
OP.VALORACION,COUNT(OP.ID_OPINION) AS OPIS, PD.OFERTA_PD,VALID_PD,
PRE.MIN_PERS_PRE,
MIN(PD.MIN_PERSONAS_PD) AS MIN_PERSONAS_PD,
PRE.MAX_PERS_PRE,
MAX(PD.MAX_PERSONAS_PD) AS MAX_PERSONAS_PD,
PRE.ALOJAMIENTO_PRE, PRE.FK_ID_PAIS_PRE AS ID_PAIS,
PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION, PRE.MULTIACTIVIDAD_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, SECI.DESC_SECTOR
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
INNER JOIN LO_REGION_I18N REI ON PRE.ID_REGION_PRE=REI.ID_REGION
INNER JOIN LO_SECTORES_I18N SECI ON SECP.ID_ACTIVIDAD_PS=SECI.ID_SECTOR
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
AND RC.VALID_RC NOT IN(0,2,6,7)
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
LEFT JOIN LO_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 SECI.ID_TROPIC='21'
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND REI.IDIOMA='es'
AND VALID_PRE IN(4)
AND PRE.ID_EMPRESA_PRE ='19651895'
AND (PR.FICHA = 0 OR PR.FICHA 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 VENTAS desc, N_ORDER_EMP_PRE IS NULL ASC,N_ORDER_EMP_PRE ASC, OFERTA_PD DESC, N_ORDER_PRE DESC,PRECIO ASC;
Tiempo de la consulta:
0.0051620006561279Tiempo acumulado:0.18209481239319
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[140]: SELECT TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,
GALERIA_DESC_PRE,HORARIO_PRE, ID_PRECIO , SECI.ID_SECTOR,
SECI.URL URL_SECTOR,REI.URL URL_REGION,PRE.PRECIO_UNITARIO_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, PRE.FK_ID_PAIS_PRE AS ID_PAIS, COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS,
DESCUENTO_MIN_PRE DESCUENTO, PRE.FOTOPRINCIPAL_PRE,
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(MAX(RC.FEC_INSERT_RC),'%Y/%m/%d') AS FECHA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM,
OP.VALORACION,COUNT(OP.ID_OPINION) AS OPIS, PD.OFERTA_PD,VALID_PD,
PRE.MIN_PERS_PRE, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE,
PRE.COMIDA_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,
PRE.TRANSPORTE_PRE,REI.DESC_REGION, PRE.MULTIACTIVIDAD_PRE, SECI.DESC_SECTOR
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
INNER JOIN LO_REGION_I18N REI ON PRE.ID_REGION_PRE=REI.ID_REGION
INNER JOIN LO_SECTORES_I18N SECI ON SECP.ID_ACTIVIDAD_PS=SECI.ID_SECTOR
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
AND RC.VALID_RC NOT IN(0,2,6,7)
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID=1
WHERE SECI.ID_TROPIC='21'
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND REI.IDIOMA='es'
AND VALID_PRE IN(4)
AND SEC.ID_SECTOR = 8
AND REI.ID_REGION = 3137
AND PRE.ID_EMPRESA_PRE !='19651895'
GROUP BY ID_PRECIO
ORDER BY VENTAS DESC, OFERTA_PD DESC, N_ORDER_EMP_PRE IS NULL ASC,N_ORDER_EMP_PRE ASC,N_ORDER_PRE DESC,PRECIO ASC
LIMIT 3;
Tiempo de la consulta:
0.0063068866729736Tiempo acumulado:0.18840169906616
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[141]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = ''
AND SEO.ID_TROPIC = 21
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0070719718933105Tiempo acumulado:0.19547367095947
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[142]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S8'
AND SEO.ID_TROPIC = 21
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.004302978515625Tiempo acumulado:0.1997766494751
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[143]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE ID_PRECIO = 81328
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.0013248920440674Tiempo acumulado:0.20110154151917
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[144]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = ''
AND SEO.ID_TROPIC = 21
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00040006637573242Tiempo acumulado:0.2015016078949
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[145]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S8'
AND SEO.ID_TROPIC = 21
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0004279613494873Tiempo acumulado:0.20192956924438
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[146]: 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 = 21
WHERE SEOHOME.ID_TROPIC = 21
AND SEOHOME.ID_KEY = 'S8'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='';
Tiempo de la consulta:
0.0060949325561523Tiempo acumulado:0.20802450180054
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[147]: SELECT COUNT(*) AS NUMOPINIONES, (SUM(VALORACION) / COUNT(*)) /20 AS VALORACION
FROM LO_EMPRESAS_OPINIONES OP
LEFT JOIN LO_RESERVAS_COMPRAS RC ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
LEFT JOIN LO_PRECIOS PRE ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
WHERE PRE.ID_PRECIO = 81328
AND OP.VALID = 1;
Tiempo de la consulta:
0.00051188468933105Tiempo acumulado:0.20853638648987
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[148]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 81328
AND VALID = 1;
Tiempo de la consulta:
0.0044858455657959Tiempo acumulado:0.21302223205566
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[149]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 81328
AND FOTO = 'p-81328-293954307-4979394715504102-5968335999860122987-n1661270591_16613280106465.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00052905082702637Tiempo acumulado:0.21355128288269
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[150]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE PRE.ID_PRECIO = 81328;
Tiempo de la consulta:
0.0010271072387695Tiempo acumulado:0.21457839012146
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[151]: 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 = 81328;
Tiempo de la consulta:
0.0017509460449219Tiempo acumulado:0.21632933616638
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[152]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 81328
LIMIT 1;
Tiempo de la consulta:
0.0007631778717041Tiempo acumulado:0.21709251403809
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[153]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 81328;
Tiempo de la consulta:
0.00039982795715332Tiempo acumulado:0.21749234199524
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[154]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 81328
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.00075888633728027Tiempo acumulado:0.21825122833252
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[155]: SELECT *
FROM LO_PRECIOS_DISPONIBILIDAD_CALENDARIO
WHERE VALID = 1
AND ID_PRECIO = 81328;
Tiempo de la consulta:
0.00068211555480957Tiempo acumulado:0.21893334388733
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[156]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE ID_PRECIO = 81362
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00040984153747559Tiempo acumulado:0.2193431854248
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[157]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = ''
AND SEO.ID_TROPIC = 21
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00035977363586426Tiempo acumulado:0.21970295906067
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[158]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S8'
AND SEO.ID_TROPIC = 21
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00057315826416016Tiempo acumulado:0.22027611732483
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[159]: 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 = 21
WHERE SEOHOME.ID_TROPIC = 21
AND SEOHOME.ID_KEY = 'S8'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='';
Tiempo de la consulta:
0.0045700073242188Tiempo acumulado:0.22484612464905
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[160]: SELECT COUNT(*) AS NUMOPINIONES, (SUM(VALORACION) / COUNT(*)) /20 AS VALORACION
FROM LO_EMPRESAS_OPINIONES OP
LEFT JOIN LO_RESERVAS_COMPRAS RC ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
LEFT JOIN LO_PRECIOS PRE ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
WHERE PRE.ID_PRECIO = 81362
AND OP.VALID = 1;
Tiempo de la consulta:
0.00054502487182617Tiempo acumulado:0.22539114952087
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[161]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 81362
AND VALID = 1;
Tiempo de la consulta:
0.0015561580657959Tiempo acumulado:0.22694730758667
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[162]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 81362
AND FOTO = 'p-81362-122783073-3174825742627684-759349483140908569-n1661517196_16615190632844.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00055885314941406Tiempo acumulado:0.22750616073608
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[163]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE PRE.ID_PRECIO = 81362;
Tiempo de la consulta:
0.00079703330993652Tiempo acumulado:0.22830319404602
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[164]: 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 = 81362;
Tiempo de la consulta:
0.00049996376037598Tiempo acumulado:0.2288031578064
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[165]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 81362
LIMIT 1;
Tiempo de la consulta:
0.00036096572875977Tiempo acumulado:0.22916412353516
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[166]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 81362;
Tiempo de la consulta:
0.00043487548828125Tiempo acumulado:0.22959899902344
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[167]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 81362
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.00037813186645508Tiempo acumulado:0.22997713088989
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[168]: SELECT *
FROM LO_PRECIOS_DISPONIBILIDAD_CALENDARIO
WHERE VALID = 1
AND ID_PRECIO = 81362;
Tiempo de la consulta:
0.00035595893859863Tiempo acumulado:0.23033308982849
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[169]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE ID_PRECIO = 81326
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00043082237243652Tiempo acumulado:0.23076391220093
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[170]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = ''
AND SEO.ID_TROPIC = 21
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00037908554077148Tiempo acumulado:0.2311429977417
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[171]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S8'
AND SEO.ID_TROPIC = 21
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0004889965057373Tiempo acumulado:0.23163199424744
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[172]: 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 = 21
WHERE SEOHOME.ID_TROPIC = 21
AND SEOHOME.ID_KEY = 'S8'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='';
Tiempo de la consulta:
0.0046999454498291Tiempo acumulado:0.23633193969727
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[173]: SELECT COUNT(*) AS NUMOPINIONES, (SUM(VALORACION) / COUNT(*)) /20 AS VALORACION
FROM LO_EMPRESAS_OPINIONES OP
LEFT JOIN LO_RESERVAS_COMPRAS RC ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
LEFT JOIN LO_PRECIOS PRE ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
WHERE PRE.ID_PRECIO = 81326
AND OP.VALID = 1;
Tiempo de la consulta:
0.00054097175598145Tiempo acumulado:0.23687291145325
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[174]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 81326
AND VALID = 1;
Tiempo de la consulta:
0.00058412551879883Tiempo acumulado:0.23745703697205
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[175]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 81326
AND FOTO = 'p-81326-277809563-4718932661550310-8117025405176759764-n1661270183_16612716608766.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.23793601989746
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[176]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE PRE.ID_PRECIO = 81326;
Tiempo de la consulta:
0.00051689147949219Tiempo acumulado:0.23845291137695
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[177]: 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 = 81326;
Tiempo de la consulta:
0.00042915344238281Tiempo acumulado:0.23888206481934
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[178]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 81326
LIMIT 1;
Tiempo de la consulta:
0.0003511905670166Tiempo acumulado:0.23923325538635
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[179]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 81326;
Tiempo de la consulta:
0.0003960132598877Tiempo acumulado:0.23962926864624
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[180]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 81326
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.0003819465637207Tiempo acumulado:0.24001121520996
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[181]: SELECT *
FROM LO_PRECIOS_DISPONIBILIDAD_CALENDARIO
WHERE VALID = 1
AND ID_PRECIO = 81326;
Tiempo de la consulta:
0.00033903121948242Tiempo acumulado:0.24035024642944
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[182]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00046586990356445Tiempo acumulado:0.24081611633301
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[183]: SELECT PED.ID_POBLACION, PED.IDS_SECTORES, PO.DESC_POBLACION, PO.DESC_REGION, PO.URL_REGION, PO.URL_POBLACION,SECI.DESC_SECTOR, SECI.URL
FROM LO_POBLACION_ENLAZADA_DESC PED
INNER JOIN LO_POBLACION_GB PO ON PO.ID_POBLACION = PED.ID_POBLACION
AND PO.IDIOMA = 'es'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
AND REI.IDIOMA = 'es'
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = 8
AND SECI.FK_ID_IDIOMA_SI18N = 'es';
Tiempo de la consulta:
0.0010449886322021Tiempo acumulado:0.24186110496521
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[184]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.`URL` AS URL_REGION, REIA.ID_REGION_ADM1, REIA.DESC_REGION AS DESC_ADM,
REIA.`URL` AS URL_ADM, P.ID_PAIS, P.DESC_PAIS, P.`URL` AS URL_PAIS
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 = 'es'
LEFT JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA = 'es'
AND (SELECT COUNT(RE2.ID_REGION)
FROM LO_REGION RE2
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE2.ID_REGION
AND REI.IDIOMA = 'es'
WHERE RE2.ID_REGION_ADM1 = RE.ID_REGION_ADM1) > 1
INNER JOIN LO_PAIS_I18N P ON P.ID_PAIS = RE.ID_PAIS
AND P.IDIOMA = 'es'
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.0007169246673584Tiempo acumulado:0.24257802963257
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[185]: SELECT (N_OFERTAS) + (N_EMPRESAS) AS NEMPRESAS,
N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas,
PS.ID_REGION_ADM1,
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_ADM1_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_ADM1 = 82
AND (PS.ID_SUBSECTOR = 0 OR PS.ID_SUBSECTOR IS NULL)
AND (PS.ID_GRUPO = 0 OR PS.ID_GRUPO IS NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.00075101852416992Tiempo acumulado:0.24332904815674
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[186]: 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 = 3137
AND (PS.ID_SUBSECTOR = 0 OR PS.ID_SUBSECTOR IS NULL)
AND (PS.ID_GRUPO = 0 OR PS.ID_GRUPO IS NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.00065398216247559Tiempo acumulado:0.24398303031921
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[187]: SELECT N_OFERTAS
FROM
LO_REGION_STATS PS
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PS.ID_REGION
AND REI.IDIOMA = 'es'
WHERE (PS.N_OFERTAS > 0 )
AND PS.ID_REGION = 3137
AND PS.ID_SECTOR = 8
GROUP BY PS.ID_REGION;
Tiempo de la consulta:
0.00042295455932617Tiempo acumulado:0.24440598487854
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: SELECT N_OFERTAS
FROM
LO_POBLACION_GB_STATS PS
INNER JOIN LO_POBLACION_GB PO ON PS.ID_POBLACION = PO.ID_POBLACION
AND PO.ID_REGION = 3137
AND PO.IDIOMA = 'es'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION
AND REI.IDIOMA = 'es'
WHERE (PS.N_OFERTAS > 0 )
AND PO.ID_REGION = 3137
AND PS.ID_POBLACION = 985828
AND PS.ID_SECTOR = 8
GROUP BY PS.ID_POBLACION;
Tiempo de la consulta:
0.00041484832763672Tiempo acumulado:0.24482083320618
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: SELECT SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, REI.DESC_REGION, REI.URL AS URL_REGION
FROM LO_REGION_SKI_STATS RSS
INNER JOIN LO_PRECIOS_PUBLI PP ON PP.ID_REGION_PP = RSS.ID_REGION
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
AND PRE.ID_EMPRESA_PRE = 0
AND PRE.VALID_PRE = 4
INNER JOIN LO_REGION_SKI REI ON REI.ID_REGION = RSS.ID_REGION
AND REI.IDIOMA = 'es'
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
AND PS.ID_ACTIVIDAD_PS = RSS.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
AND SECI.ID_TROPIC = 21
AND SECI.ID_SECTOR = 8
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = SECI.ID_SECTOR
WHERE RSS.N_OFERTAS > 0
AND RSS.N_OFERTAS IS NOT NULL
AND IF(SEC.ID_GRUPO != 3
AND REI.ID_REGION != 10202, 1=2, 1=1)
GROUP BY RSS.ID_REGION, RSS.ID_SECTOR;
Tiempo de la consulta:
0.0022268295288086Tiempo acumulado:0.24704766273499
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: SELECT EE.*, EET.DESCRIPCION, EET.CARGO, EE.IDIOMA AS IDIOMA_EE
FROM LO_EMPRESAS_EQUIPO EE
INNER JOIN LO_EMPRESAS_EQUIPO_TRADUCCION EET ON EET.ID_EQUIPO = EE.ID
AND EET.IDIOMA = 'es'
WHERE EE.ID_EMPRESA = 19651895
AND EE.VALID = 1;
Tiempo de la consulta:
0.0014019012451172Tiempo acumulado:0.2484495639801
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[191]: SELECT MIN(DATE_FORMAT(EMP.FEC_INSERT,'%Y/%m/%d') ) AS FECHA
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19651895 OR ID_MADRE = 19651895
AND EMP.VALID = 1;
Tiempo de la consulta:
0.00056815147399902Tiempo acumulado:0.2490177154541
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[192]: SELECT MAX(DATE_FORMAT(EMP.FEC_ULT_CONNECT,'%Y/%m/%d')) AS FECHA
FROM LO_EMPRESAS EMP
INNER JOIN LO_PRECIOS PRE ON PRE.ID_EMPRESA_PRE = EMP.ID_EMPRESA
AND VALID_PRE = 4
WHERE EMP.ID_EMPRESA = 19651895 OR ID_MADRE = 19651895
AND EMP.VALID = 1;
Tiempo de la consulta:
0.00060606002807617Tiempo acumulado:0.24962377548218
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[193]: SELECT *
FROM LO_RESERVAS_FISCAL
WHERE ID_EMPRESA_RF='19651895';
Tiempo de la consulta:
0.001488208770752Tiempo acumulado:0.25111198425293
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: SELECT EXI.EXITO,EXI.N_VENTAS,EXI.N_DEVOLUCIONES
FROM LO_EMPRESAS EMP
LEFT JOIN LO_EMPRESAS_EXITO EXI ON EMP.ID_EMPRESA = EXI.ID_EMPRESA
WHERE EMP.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00080299377441406Tiempo acumulado:0.25191497802734
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: SELECT *
FROM LO_EMPRESAS_IDIOMAS EI
WHERE EI.ID_EMPRESA = 19651895;
Tiempo de la consulta:
0.00070405006408691Tiempo acumulado:0.25261902809143
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[196]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
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='es'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_GB PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='es'
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 = 21
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 21)
WHERE EMP.ID_EMPRESA = 19651895
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0012280941009521Tiempo acumulado:0.25384712219238
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND VALID = 1;
Tiempo de la consulta:
0.00059390068054199Tiempo acumulado:0.25444102287292
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[198]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19651895
AND FOTO = 'Amazing underwater diving.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00044822692871094Tiempo acumulado:0.25488924980164
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingwrite_deskSQL[199]: INSERT INTO LO_EMPRESAS_VISITAS_DIARIO
(ID_EMPRESA,FECHA, VISITAS)
VALUES
(19651895, SYSDATE(), 1)
ON DUPLICATE KEY UPDATE
VISITAS = VISITAS + 1;
Tiempo de la consulta:
0.0062570571899414Tiempo acumulado:0.26114630699158
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: 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 = 'es'
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 = 1
INNER JOIN LO_SECTORES_I18N SECI ON PS.ID_SECTOR = SECI.ID_SECTOR
AND SECI.ID_TROPIC='21'
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
WHERE
REI.ID_REGION = 3137
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.0012819766998291Tiempo acumulado:0.26242828369141
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT COUNT(*) AS NEMPRESAS
FROM LO_REGION_STATS
WHERE ID_REGION = 3137
AND ID_GRUPO = 1;
Tiempo de la consulta:
0.00046205520629883Tiempo acumulado:0.26289033889771
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: 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 = '3137'
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00039911270141602Tiempo acumulado:0.26328945159912
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[203]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S55'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00041604042053223Tiempo acumulado:0.26370549201965
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S11'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00040102005004883Tiempo acumulado:0.2641065120697
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[205]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S85'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00037002563476562Tiempo acumulado:0.26447653770447
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S36'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00036191940307617Tiempo acumulado:0.26483845710754
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S29'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00036191940307617Tiempo acumulado:0.26520037651062
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S35'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00036406517028809Tiempo acumulado:0.26556444168091
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S69'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00036406517028809Tiempo acumulado:0.2659285068512
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[210]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S51'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00036406517028809Tiempo acumulado:0.26629257202148
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[211]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S8'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.0003509521484375Tiempo acumulado:0.26664352416992
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[212]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S88'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00038409233093262Tiempo acumulado:0.26702761650085
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[213]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S10'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00035905838012695Tiempo acumulado:0.26738667488098
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[214]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S45'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00036287307739258Tiempo acumulado:0.26774954795837
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[215]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S27'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00040507316589355Tiempo acumulado:0.26815462112427
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[216]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S23'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00039792060852051Tiempo acumulado:0.26855254173279
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[217]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S12'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00036501884460449Tiempo acumulado:0.26891756057739
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[218]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S44'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.0003659725189209Tiempo acumulado:0.26928353309631
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[219]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S46'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.0003659725189209Tiempo acumulado:0.26964950561523
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[220]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S7'
AND (SEO.ID_TROPIC = 21
);
Tiempo de la consulta:
0.00041007995605469Tiempo acumulado:0.27005958557129
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[221]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 21;
Tiempo de la consulta:
0.0016789436340332Tiempo acumulado:0.27173852920532
