We offer you 10 ideas to spend your birthday in a different and more fun way than usual that you will not easily forget!
In Rome, the Eternal City, you can ensure that the day of your birthday is unforgettable with original and fun activities!
Then you have a list of 10 activities at your disposal, so as not to make the classic birthday parties at the restaurant or at home, together with your family and friends and who are super fun!
1. Paintball: Ready to make war on painting?
Let's start with one of the most requested, cheap and fun activities for a birthday party , a Rome and in the province there are many Paintball fields scattered For the whole region, and being an activity suitable for adults and children you can have fun with painting with all your friends and family.
In all Paintball fields you will have the necessary equipment to play and all the painting ammunition you want to recharge the weapon.
A Valmontone , a few kilometers from Rome there is the perfect field for a Paintball game on your birthday , because it has a picnic area with barbecue and gazebo corner to continue the party after the Paintball game.
2. Escape Room: Will you be able to go out in 60 minutes?
We offer you a challenge: enter a themed room with your friends and solve the various riddles and riddles that will allow you to leave the room set. Will you succeed in 60 minutes?
The escape room set are becoming increasingly popular to celebrate a birthday, and Rome is full of rooms set of which you will only have to choose the theme you prefer and have fun!
The "crazy scientist", the "Castle of Dracula", the "escape from the asylum" or the "Davinci's Secret" room are just some of the rooms set which are located in Rome And once all the riddles are resolved you can continue the party in the various clubs and bars in the vicinity!
For lovers of engines and speed there is the possibility, to sit behind the wheel of a luxurious Ferrari , a Campagnano of Rome .
This is the perfect gift to live an unforgettable birthday and the Vallelunga track will make you experience the emotion of feeling a real automotive pilot.
To finish your party in beauty you will be offered a drink from the staff of experts who will be at your disposal throughout the adrenaline adventure that awaits you!
A horse walk in the province of Rome is the perfect activity to celebrate a birthday in the open area.
You can decide to do your horse excursion to the sea or in the countryside or organize a feast on the farm for your children to ensure that they have fun in nature and approach the zooanthropology !
in Bracciano , for example, a few kilometers from the capital, you can choose the duration of the horse walk according to your experience and to discover the Roman countryside and its ancient Ruins with your friends to spend your birthday day immersed in relaxation and nature.
Finally, you can take advantage of a delicious barbecue in the countryside and an aperitif at the sea to celebrate your birthday in a fun and alternative way!
That there is better than celebrate your birthday with a open sea party together with your friends? This is the perfect way of dealing with Roman summer in the best way!
In the tourist port of Ostia there is a boat with all the comforts necessary to make your unforgettable birthday with a skipper that will be at your disposal throughout the Boat excursion in the sea of Ostia.
6.tour in hot air balloon: high altitude birthday!
Celebrate your birthday at high altitude on the eternal city with your friends, family or partner.
The hot air balloon tours is also the perfect gift for adults and children and the itineraries are varied and all unique to admire the ancient monuments that distinguish Rome With the company flying to hot air balloon!
You can also attend the swelling of the ball and it is very easy to reach the starting points in the car and then enjoy a delicious aperitif to the landing to finish the birthday in the best way.
Bring your friends to celebrate your birthday in a fun and adrenalinic way a, between the streams and rivers of the Valley of Aniene , included in the metropolitan city of Rome !
With the rafting in the Aniene river you will make the birthday an unforgettable day and you can continue your party in one of the restaurants of the park of the Monti Simbruini and spend the night in one of the B&B of the area.
This can be the perfect gift to spend a day immersed in nature without moving away from the city!
Do you think you are a courageous person and you are passionate about adrenaline? Then launched by a plane 4000 meters on the city of Rome at 200 kilometers per hour making this experience the perfect gift for your birthday !
About 20 kilometers from the capital you can take advantage of the shuttle service from the Roma Mount compatri very comfortable to get to the aviosuperficie of Rome and enjoy the famous hills Romans and the architecture that the ancient city offers you.
At the landing you will have the adrenaline to the stars and you will remember the day of your birthday forever.
9. Pilot a helicopter: become a pilot on your birthday!
If you always dream of piloting a helicopter , we make you available the perfect gift for you or for your friends lovers of the high altitude.
In the Rome Urbe airport an expert pilot awaits you which will be at your disposal throughout the activity in which you will be the same to pilot a helicopter on the eternal city in maximum safety !
The birthday is the perfect day to live this experience at the commands of a modern two -seater R22 and from the top of the sky you can glimpse the dome of San Pietro , the altar of the homeland but also the Olympic stadium and the auditorium !
## 11 ##
If the birthday in question happens in the spring - summer season do not doubt in giving the birthday boy an experience in cable wakeboard a few kilometers from Rome. .
The cable Wakeboard is a new, safe and alternative way of doing this sport, being carried out on an electrical aquatic system of which you have the control of the speed
You can also spend the day of your birthday in the Club House Sport whose company disposes and after having fun on the Wakeboard table you can continue your party in the club area or in the seaside area and then spend the night in the farmhouse, immersed in Roman nature, making your birthday more long and certainly unforgettable!
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[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', 'gb')
ORDER BY CFG.NAME;
Tiempo de la consulta: 0.030261993408203
Tiempo acumulado:0.030261993408203
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[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.0045700073242188
Tiempo acumulado:0.034832000732422
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[3]:SELECT ID_PAIS FROM ( SELECT 28 AS ID_PAIS FROM Prod_Yumping_es_ES.LO_CONTENIDOS C
LEFTJOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 1860
/* AND (
fnGoogleUrl(C.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR fnGoogleUrl(CT.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR URL_CT = '10-ideas-to-celebrate-a-birthday-in-rome') */ UNION ALL SELECT 48 AS ID_PAIS FROM Prod_Yumping_pt_PT.LO_CONTENIDOS C
LEFTJOIN Prod_Yumping_pt_PT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 1860
/* AND (
fnGoogleUrl(C.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR fnGoogleUrl(CT.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR URL_CT = '10-ideas-to-celebrate-a-birthday-in-rome') */ UNION ALL SELECT 29 AS ID_PAIS FROM Prod_Yumping_it_IT.LO_CONTENIDOS C
LEFTJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 1860
/* AND (
fnGoogleUrl(C.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR fnGoogleUrl(CT.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR URL_CT = '10-ideas-to-celebrate-a-birthday-in-rome') */ UNION ALL SELECT 64 AS ID_PAIS FROM Prod_Yumping_fr_FR.LO_CONTENIDOS C
LEFTJOIN Prod_Yumping_fr_FR.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 1860
/* AND (
fnGoogleUrl(C.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR fnGoogleUrl(CT.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR URL_CT = '10-ideas-to-celebrate-a-birthday-in-rome') */ UNION ALL SELECT 247 AS ID_PAIS FROM Prod_Yumping_co_UK.LO_CONTENIDOS C
LEFTJOIN Prod_Yumping_co_UK.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 1860
/* AND (
fnGoogleUrl(C.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR fnGoogleUrl(CT.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR URL_CT = '10-ideas-to-celebrate-a-birthday-in-rome') */ UNION ALL SELECT 301 AS ID_PAIS FROM Prod_Yumping_mx_MX.LO_CONTENIDOS C
LEFTJOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 1860
/* AND (
fnGoogleUrl(C.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR fnGoogleUrl(CT.TITULO) = '10-ideas-to-celebrate-a-birthday-in-rome'
OR URL_CT = '10-ideas-to-celebrate-a-birthday-in-rome') */ ) AS CONTENIDO;
Tiempo de la consulta (slow_query): 0.23189401626587
Tiempo acumulado:0.26672601699829
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[4]:SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'it_en')
ORDER BY CFG.NAME;
Tiempo de la consulta: 0.027581930160522
Tiempo acumulado:0.29430794715881
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[5]:SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta: 0.0026719570159912
Tiempo acumulado:0.2969799041748
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[6]:SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta: 0.003460168838501
Tiempo acumulado:0.30044007301331
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[7]:SELECT `TIMESTAMP`, VALUE
FROM LO_CURRENCIES_CONVERSION
WHERE `FROM` = 'EUR'
AND `TO` = 'GBP';
Tiempo de la consulta: 0.0036489963531494
Tiempo acumulado:0.30408906936646
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[8]:SELECT `PARAM`, `TYPE`, `CHECK` FROM Yumping_proc_comun.LO_CHECK_PARAMETERS WHERE PARAM = 'ambito_lang';
Tiempo de la consulta: 0.0031399726867676
Tiempo acumulado:0.30722904205322
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[9]:SELECT `PARAM`, `TYPE`, `CHECK` FROM Yumping_proc_comun.LO_CHECK_PARAMETERS WHERE PARAM = 'id_contenido';
Tiempo de la consulta: 0.0064949989318848
Tiempo acumulado:0.31372404098511
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[10]:SELECT `PARAM`, `TYPE`, `CHECK` FROM Yumping_proc_comun.LO_CHECK_PARAMETERS WHERE PARAM = 'tpage';
Tiempo de la consulta: 0.00061988830566406
Tiempo acumulado:0.31434392929077
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[11]:SELECT `PARAM`, `TYPE`, `CHECK` FROM Yumping_proc_comun.LO_CHECK_PARAMETERS WHERE PARAM = 'rel_alternate';
Tiempo de la consulta: 0.0092501640319824
Tiempo acumulado:0.32359409332275
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[12]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0088791847229004
Tiempo acumulado:0.33247327804565
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[13]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0013248920440674
Tiempo acumulado:0.33379817008972
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[14]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0089969635009766
Tiempo acumulado:0.3427951335907
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[15]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0015978813171387
Tiempo acumulado:0.34439301490784
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[16]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00055599212646484
Tiempo acumulado:0.3449490070343
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[17]:SELECT 'it_en' AS AMBIO, CON.FK_ID_EMPRESA_CON, CON.ID_CONTENIDO,CON.TIPO_CONTENIDOS, CON.TITULO,
CON.DESCRIPCION, CON.TEXTO, CON.OPERATOR_INSERT,
DATE_FORMAT(CON.FEC_INSERT,'%d/%m/%y') AS FEC_INSERT, CON.GALERIA, CON.GALERIA_DESC, CON.FOTOPRINCIPAL,
AD.MAIL, CAT.ID_SECTOR,VIDEOS_CODE_CON,CON.VIDEOS_TEXT_CON,CON.VIDEOS_DESC_CON,CAT.ID_GRUPO_CAT/*,CON.NOMBRE_FIRMA_CON, NOMBRE_FIRMA_CON,PUESTO_FIRMA_CON,ENLACE_FIRMA_CON,FOTO_FIRMA_CON*/,AD.AVATAR,AD.NOMBRE,CAT.ID_CATEG
, CA.JOB, CA.AVATAR, CA.URL, IF(CA.NOMBRE IS NOT NULL, CA.NOMBRE, AD.NOMBRE) AS NOMBRE, CA.ID AS ID_AUTOR,
DATE_FORMAT(CON.FEC_INSERT, '%d') DAY_INSERT,
DATE_FORMAT(CON.FEC_INSERT, '%m') MONTH_INSERT,
DATE_FORMAT(CON.FEC_INSERT, '%Y') YEAR_INSERT,
DATE_FORMAT(CON.FEC_INSERT, '%H:%i') HORA_INSERT,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%d') DAY_MOD,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%m') MONTH_MOD,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%Y') YEAR_MOD,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%H:%i') HORA_MOD, DATE_FORMAT(CON.FEC_INSERT, '%Y-%m-%dT%H:%i') IN_GOOGLE, DATE_FORMAT(CON.FEC_ULT_MODIF, '%Y-%m-%dT%H:%i') MOD_GOOGLE , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_it_IT.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = CON.ID_CONTENIDO AND LANGUAGE = 'en'
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_CATEG CAT ON CON.ID_CATEG=CAT.ID_CATEG
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_CATEG_I18N CATI ON CON.ID_CATEG=CATI.ID_CATEG AND CAT.ID_CATEG=CATI.ID_CATEG
INNERJOIN Prod_Yumping_it_IT.LO_ADMIN_USERS AD ON AD.LOGIN=CON.OPERATOR_INSERT
LEFTJOIN Prod_Yumping_it_IT.LO_CONTENIDO_AUTORES CA ON CA.ID_ADMIN = AD.ID_ADMIN AND CA.ID_TROPIC = 32
WHERE CON.ID_CONTENIDO=1860 AND CON.VALID=1
AND CATI.ID_TROPIC=32;
Tiempo de la consulta: 0.037572860717773
Tiempo acumulado:0.38252186775208
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[18]:SELECT DISTINCT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI, LO_CONTENIDOS CON, LO_CONTENIDOS_CATEG CAT, LO_CONTENIDOS_CATEG_I18N CATI
WHERE SEC.ID_SECTOR='0'
AND CAT.ID_CATEG=CATI.ID_CATEG
AND CON.ID_CONTENIDO='1860'
AND CON.VALID=1
AND SECI.ID_SECTOR=SEC.ID_SECTOR
AND SECI.ID_TROPIC = 32
AND CATI.ID_TROPIC = 3
AND CON.ID_CATEG = CATI.ID_CATEG
AND CAT.ID_SECTOR=SEC.ID_SECTOR;
Tiempo de la consulta: 0.011147022247314
Tiempo acumulado:0.39366888999939
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[19]:SELECT COMUS.ID_USER,COMUS.ROL, COMUS.AVATAR,COMUS.NOMBRE, CONTOP.COMENTARIO_CONTOP,
CONT.TITULO,CONT.ID_CONTENIDO,
DATE_FORMAT(FECHA_CONTOP,'%d/%m/%Y %H:%i') as FECHA_CONTOP
FROM LO_CONTENIDOS_OPINIONES CONTOP
INNERJOIN LO_CONTENIDOS CONT ON CONTOP.FK_ID_CONTENIDO=CONT.ID_CONTENIDO
AND CONT.ID_TROPIC='3'
INNERJOIN LO_COM_USERS COMUS ON CONTOP.ID_USER_CONTOP = COMUS.ID_USER
WHERE CONTOP.ID_USER_CONTOP<>'0'
ORDER BY RAND()
LIMIT 4;
Tiempo de la consulta (slow_query): 0.10063982009888
Tiempo acumulado:0.49430871009827
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[20]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00065898895263672
Tiempo acumulado:0.4949676990509
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[21]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0062580108642578
Tiempo acumulado:0.50122570991516
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[22]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0098581314086914
Tiempo acumulado:0.51108384132385
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[23]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.010179996490479
Tiempo acumulado:0.52126383781433
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[24]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0026860237121582
Tiempo acumulado:0.52394986152649
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[25]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0063278675079346
Tiempo acumulado:0.53027772903442
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[26]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.010195970535278
Tiempo acumulado:0.5404736995697
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[27]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0062639713287354
Tiempo acumulado:0.54673767089844
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[28]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0008699893951416
Tiempo acumulado:0.54760766029358
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[29]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.011555194854736
Tiempo acumulado:0.55916285514832
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[30]: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.0097658634185791
Tiempo acumulado:0.56892871856689
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[31]: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'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0097401142120361
Tiempo acumulado:0.57866883277893
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[32]: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.0097730159759521
Tiempo acumulado:0.58844184875488
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[33]: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.0097510814666748
Tiempo acumulado:0.59819293022156
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[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_con_traducciones'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0097708702087402
Tiempo acumulado:0.6079638004303
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[35]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0074129104614258
Tiempo acumulado:0.61537671089172
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[36]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00072312355041504
Tiempo acumulado:0.61609983444214
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[37]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0070099830627441
Tiempo acumulado:0.62310981750488
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[38]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0038390159606934
Tiempo acumulado:0.62694883346558
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[39]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0097849369049072
Tiempo acumulado:0.63673377037048
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[40]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0072870254516602
Tiempo acumulado:0.64402079582214
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[41]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0022048950195312
Tiempo acumulado:0.64622569084167
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[42]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.009807825088501
Tiempo acumulado:0.65603351593018
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[43]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0055549144744873
Tiempo acumulado:0.66158843040466
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[44]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0039510726928711
Tiempo acumulado:0.66553950309753
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[45]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00095605850219727
Tiempo acumulado:0.66649556159973
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[46]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0098268985748291
Tiempo acumulado:0.67632246017456
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[47]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0085461139678955
Tiempo acumulado:0.68486857414246
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[48]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0086169242858887
Tiempo acumulado:0.69348549842834
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[49]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00058603286743164
Tiempo acumulado:0.69407153129578
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[50]:SELECT SUM(TOTAL) AS TOTAL,TIPO_CONTENIDOS,ID_GRUPO_CAT, DESC_GRUPO, URL FROM (SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_es_ES.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_es_ES.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_es_ES.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_es_ES.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '12'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='1'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_pt_PT.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_pt_PT.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_pt_PT.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_pt_PT.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '82'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='8'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_co_UK.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_co_UK.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_co_UK.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_co_UK.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '2'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='2'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_mx_MX.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_mx_MX.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '52'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='5'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_it_IT.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_it_IT.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '32'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='3'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_fr_FR.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_fr_FR.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_fr_FR.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_fr_FR.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '42'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='4'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
) AS CATEGORIAS
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
ORDER BY ID_GRUPO_CAT ASC;
Tiempo de la consulta (slow_query): 0.11363887786865
Tiempo acumulado:0.80771040916443
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[51]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-3284572794-171698bbeb-o1585827991.0515.jpg' AND VALID=1;
Tiempo de la consulta: 0.0091750621795654
Tiempo acumulado:0.81688547134399
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[52]:SELECT OLD_URL, NEW_URL FROM LO_URL_301 U WHERE U.OLD_URL = '/en/adventure-sports-news/10-ideas-to-celebrate-a-birthday-in-rome--c1860';
Tiempo de la consulta: 0.0037398338317871
Tiempo acumulado:0.82062530517578
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[53]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00064182281494141
Tiempo acumulado:0.82126712799072
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[54]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00051498413085938
Tiempo acumulado:0.82178211212158
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[55]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00052499771118164
Tiempo acumulado:0.82230710983276
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[56]:SELECT C.* , C.DESCRIPCION AS DESC_CORTA,'' as URL_CT ,C.TITULO, C.DESCRIPCION, C.TEXTO, C.GALERIA_DESC, C.VIDEOS_TEXT_CON, C.VIDEOS_DESC_CON
FROM Prod_Yumping_it_IT.LO_CONTENIDOS C
WHERE C.ID_CONTENIDO = 1860;
Tiempo de la consulta: 0.0012528896331787
Tiempo acumulado:0.82355999946594
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[57]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0011060237884521
Tiempo acumulado:0.82466602325439
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[58]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00091290473937988
Tiempo acumulado:0.82557892799377
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[59]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00095796585083008
Tiempo acumulado:0.8265368938446
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[60]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00062990188598633
Tiempo acumulado:0.82716679573059
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[61]:SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_it_IT.LO_CONTENIDOS C
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO AND LANGUAGE = 'es'
WHERE C.ID_CONTENIDO = 1860;
Tiempo de la consulta: 0.0014328956604004
Tiempo acumulado:0.82859969139099
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[62]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00046682357788086
Tiempo acumulado:0.82906651496887
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[63]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00047588348388672
Tiempo acumulado:0.82954239845276
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[64]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00046181678771973
Tiempo acumulado:0.83000421524048
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[65]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00046205520629883
Tiempo acumulado:0.83046627044678
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[66]:SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_it_IT.LO_CONTENIDOS C
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO AND LANGUAGE = 'fr'
WHERE C.ID_CONTENIDO = 1860;
Tiempo de la consulta: 0.0013458728790283
Tiempo acumulado:0.83181214332581
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[67]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00045895576477051
Tiempo acumulado:0.83227109909058
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[68]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00046205520629883
Tiempo acumulado:0.83273315429688
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[69]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00047183036804199
Tiempo acumulado:0.83320498466492
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[70]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00047802925109863
Tiempo acumulado:0.83368301391602
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[71]:SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_it_IT.LO_CONTENIDOS C
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO AND LANGUAGE = 'de'
WHERE C.ID_CONTENIDO = 1860;
Tiempo de la consulta: 0.0013060569763184
Tiempo acumulado:0.83498907089233
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[72]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00051498413085938
Tiempo acumulado:0.83550405502319
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[73]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00045180320739746
Tiempo acumulado:0.83595585823059
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[74]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00081419944763184
Tiempo acumulado:0.83677005767822
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[75]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0004730224609375
Tiempo acumulado:0.83724308013916
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[76]:SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_it_IT.LO_CONTENIDOS C
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO AND LANGUAGE = 'pt'
WHERE C.ID_CONTENIDO = 1860;
Tiempo de la consulta: 0.0015220642089844
Tiempo acumulado:0.83876514434814
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[77]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00044798851013184
Tiempo acumulado:0.83921313285828
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[78]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00047707557678223
Tiempo acumulado:0.83969020843506
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[79]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00048494338989258
Tiempo acumulado:0.84017515182495
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[80]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00044989585876465
Tiempo acumulado:0.84062504768372
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[81]:SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_it_IT.LO_CONTENIDOS C
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO AND LANGUAGE = 'mx'
WHERE C.ID_CONTENIDO = 1860;
Tiempo de la consulta: 0.0013160705566406
Tiempo acumulado:0.84194111824036
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[82]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00086402893066406
Tiempo acumulado:0.84280514717102
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[83]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00045990943908691
Tiempo acumulado:0.84326505661011
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[84]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00044393539428711
Tiempo acumulado:0.84370899200439
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[85]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00043797492980957
Tiempo acumulado:0.8441469669342
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[86]:SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_it_IT.LO_CONTENIDOS C
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO AND LANGUAGE = 'ch'
WHERE C.ID_CONTENIDO = 1860;
Tiempo de la consulta: 0.0013158321380615
Tiempo acumulado:0.84546279907227
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[87]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00049710273742676
Tiempo acumulado:0.84595990180969
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[88]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00045299530029297
Tiempo acumulado:0.84641289710999
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[89]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00047111511230469
Tiempo acumulado:0.84688401222229
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[90]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00046610832214355
Tiempo acumulado:0.84735012054443
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[91]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00042510032653809
Tiempo acumulado:0.84777522087097
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[92]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00043892860412598
Tiempo acumulado:0.8482141494751
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[93]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00044012069702148
Tiempo acumulado:0.84865427017212
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[94]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00054097175598145
Tiempo acumulado:0.8491952419281
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[95]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0035059452056885
Tiempo acumulado:0.85270118713379
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[96]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.003399133682251
Tiempo acumulado:0.85610032081604
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[97]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0031499862670898
Tiempo acumulado:0.85925030708313
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[98]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0034410953521729
Tiempo acumulado:0.8626914024353
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[99]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0060849189758301
Tiempo acumulado:0.86877632141113
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[100]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0045771598815918
Tiempo acumulado:0.87335348129272
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[101]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0026109218597412
Tiempo acumulado:0.87596440315247
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[102]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0010440349578857
Tiempo acumulado:0.87700843811035
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[103]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0053629875183105
Tiempo acumulado:0.88237142562866
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[104]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0027379989624023
Tiempo acumulado:0.88510942459106
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[105]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0025720596313477
Tiempo acumulado:0.88768148422241
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[106]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0023610591888428
Tiempo acumulado:0.89004254341125
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[107]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0037081241607666
Tiempo acumulado:0.89375066757202
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[108]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0029258728027344
Tiempo acumulado:0.89667654037476
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[109]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0069370269775391
Tiempo acumulado:0.90361356735229
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[110]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0028350353240967
Tiempo acumulado:0.90644860267639
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[111]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0068321228027344
Tiempo acumulado:0.91328072547913
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[112]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0010919570922852
Tiempo acumulado:0.91437268257141
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[113]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.011754989624023
Tiempo acumulado:0.92612767219543
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[114]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0092859268188477
Tiempo acumulado:0.93541359901428
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[115]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0098259449005127
Tiempo acumulado:0.94523954391479
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[116]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0083010196685791
Tiempo acumulado:0.95354056358337
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[117]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0052099227905273
Tiempo acumulado:0.9587504863739
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[118]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0025191307067871
Tiempo acumulado:0.96126961708069
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[119]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0028641223907471
Tiempo acumulado:0.96413373947144
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[120]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.005037784576416
Tiempo acumulado:0.96917152404785
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[121]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0045790672302246
Tiempo acumulado:0.97375059127808
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[122]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0025479793548584
Tiempo acumulado:0.97629857063293
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[123]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0069220066070557
Tiempo acumulado:0.98322057723999
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[124]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00057601928710938
Tiempo acumulado:0.9837965965271
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[125]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-3284572794-171698bbeb-o1585827991.0515.jpg' AND VALID=1;
Tiempo de la consulta: 0.0041658878326416
Tiempo acumulado:0.98796248435974
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[126]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-21585827992.262.jpg' AND VALID=1;
Tiempo de la consulta: 0.0014228820800781
Tiempo acumulado:0.98938536643982
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[127]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-31585827992.8349.jpg' AND VALID=1;
Tiempo de la consulta: 0.0014331340789795
Tiempo acumulado:0.9908185005188
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[128]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-41585827993.8614.jpg' AND VALID=1;
Tiempo de la consulta: 0.00064301490783691
Tiempo acumulado:0.99146151542664
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[129]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-51585827995.0037.jpg' AND VALID=1;
Tiempo de la consulta: 0.0069379806518555
Tiempo acumulado:0.99839949607849
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[130]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-61585827995.6715.jpg' AND VALID=1;
Tiempo de la consulta: 0.00066995620727539
Tiempo acumulado:0.99906945228577
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[131]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-71585827996.6844.jpg' AND VALID=1;
Tiempo de la consulta: 0.0025830268859863
Tiempo acumulado:1.0016524791718
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[132]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-81585827997.2957.jpg' AND VALID=1;
Tiempo de la consulta: 0.003183126449585
Tiempo acumulado:1.0048356056213
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[133]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-5-senderos-donde-nunca-deberias-hacerte-un-selfie-pasarela-de-montfalco-11530791977.7253.jpg' AND VALID=1;
Tiempo de la consulta: 0.00085711479187012
Tiempo acumulado:1.0056927204132
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[134]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-101585827997.8041.jpg' AND VALID=1;
Tiempo de la consulta: 0.0023281574249268
Tiempo acumulado:1.0080208778381
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[135]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-111585827999.1302.jpg' AND VALID=1;
Tiempo de la consulta: 0.0037209987640381
Tiempo acumulado:1.0117418766022
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[136]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-1-11585827991.7427.jpg' AND VALID=1;
Tiempo de la consulta: 0.00066089630126953
Tiempo acumulado:1.0124027729034
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[137]:SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta: 0.0011718273162842
Tiempo acumulado:1.0135746002197
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[138]:SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta: 0.0048198699951172
Tiempo acumulado:1.0183944702148
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[139]:SELECT CATEGG.DESC_GRUPO,CATEGG.URL as URL2
FROM LO_CONTENIDOS CON
INNERJOIN LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN LO_CONTENIDOS_CATEG_I18N CAI ON CAI.ID_CATEG=CATEG.ID_CATEG
INNERJOIN LO_CONTENIDOS_GRUPOS CATEGG ON CATEG.id_GRUPO_CAT=CATEGG.ID_GRUPO_CAT
WHERE CATEGG.ID_TROPIC='32'
AND CON.ID_CONTENIDO='1860'
LIMIT 1;
Tiempo de la consulta: 0.0035290718078613
Tiempo acumulado:1.0219235420227
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[140]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-3284572794-171698bbeb-o1585827991.0515.jpg' AND VALID=1;
Tiempo de la consulta: 0.00071191787719727
Tiempo acumulado:1.0226354598999
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[141]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-21585827992.262.jpg' AND VALID=1;
Tiempo de la consulta: 0.0060460567474365
Tiempo acumulado:1.0286815166473
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[142]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-31585827992.8349.jpg' AND VALID=1;
Tiempo de la consulta: 0.0042018890380859
Tiempo acumulado:1.0328834056854
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[143]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-41585827993.8614.jpg' AND VALID=1;
Tiempo de la consulta: 0.00054597854614258
Tiempo acumulado:1.0334293842316
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[144]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-51585827995.0037.jpg' AND VALID=1;
Tiempo de la consulta: 0.0006260871887207
Tiempo acumulado:1.0340554714203
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[145]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-61585827995.6715.jpg' AND VALID=1;
Tiempo de la consulta: 0.0038220882415771
Tiempo acumulado:1.0378775596619
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[146]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-71585827996.6844.jpg' AND VALID=1;
Tiempo de la consulta: 0.00074887275695801
Tiempo acumulado:1.0386264324188
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[147]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-81585827997.2957.jpg' AND VALID=1;
Tiempo de la consulta: 0.00058412551879883
Tiempo acumulado:1.0392105579376
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[148]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-5-senderos-donde-nunca-deberias-hacerte-un-selfie-pasarela-de-montfalco-11530791977.7253.jpg' AND VALID=1;
Tiempo de la consulta: 0.004086971282959
Tiempo acumulado:1.0432975292206
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[149]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-101585827997.8041.jpg' AND VALID=1;
Tiempo de la consulta: 0.00066804885864258
Tiempo acumulado:1.0439655780792
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[150]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-111585827999.1302.jpg' AND VALID=1;
Tiempo de la consulta: 0.0029661655426025
Tiempo acumulado:1.0469317436218
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[151]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1860 AND FOTO = 'c-1108-1-11585827991.7427.jpg' AND VALID=1;
Tiempo de la consulta: 0.002640962600708
Tiempo acumulado:1.0495727062225
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[152]:SELECT C.ID_REGION, DL.ID_SECTOR_1, DL.ID_SECTOR_2, DL.ID_SECTOR_3, DL.ID_SECTOR_4, DL.ID_SECTOR_5, DL.ID_SECTOR_6, DL.ID_SECTOR_7, DL.ID_SECTOR_8, DL.ID_SECTOR_9, DL.ID_SECTOR_10
FROM LO_CONTENIDOS C
INNERJOIN LO_SEO_DESCRIPTIONS_LANDING DL ON (ID_KEY = CONCAT('R',C.ID_REGION) OR ID_KEY = CONCAT('P',C.ID_REGION))
AND DL.ID_TROPIC = 32
WHERE C.TITULO LIKE '10 cosas que hacer en%'
AND C.ID_CONTENIDO = 1860;
Tiempo de la consulta: 0.0064599514007568
Tiempo acumulado:1.0560326576233
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[153]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.031249046325684
Tiempo acumulado:1.087281703949
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[154]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0035660266876221
Tiempo acumulado:1.0908477306366
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[155]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00088191032409668
Tiempo acumulado:1.0917296409607
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[156]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0026810169219971
Tiempo acumulado:1.0944106578827
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[157]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0013539791107178
Tiempo acumulado:1.0957646369934
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[158]:SELECT CON.ID_CONTENIDO , CON.TITULO, CON.DESCRIPCION, CON.TEXTO, CON.GALERIA, CON.GALERIA_DESC,
CON.FOTOPRINCIPAL, DATE_FORMAT(CON.FEC_INSERT,'%d/%m/%y') AS FEC_INSERT,
AD.NOMBRE, AD.MAIL,CON.TIPO_CONTENIDOS
, CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_it_IT.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_it_IT.LO_ADMIN_USERS AD ON AD.LOGIN = CON.OPERATOR_INSERT
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = CON.ID_CONTENIDO AND LANGUAGE = 'en'
WHERE
(CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_CATEG = 55
AND CON.VALID = 1 AND CON.ID_CONTENIDO !=1860
ORDER BY RAND()
LIMIT 4;
Tiempo de la consulta: 0.046881914138794
Tiempo acumulado:1.1426465511322
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[159]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1859 AND FOTO = 'c-1107-tb-p-49632-screenshot-1-149389270760151585140033.6438.jpg' AND VALID=1;
Tiempo de la consulta: 0.0015809535980225
Tiempo acumulado:1.1442275047302
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[160]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1791 AND FOTO = 'Foto 3.jpg' AND VALID=1;
Tiempo de la consulta: 0.0015790462493896
Tiempo acumulado:1.1458065509796
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[161]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1832 AND FOTO = 'Avventura e handicap.jpg' AND VALID=1;
Tiempo de la consulta: 0.0014159679412842
Tiempo acumulado:1.1472225189209
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[162]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1795 AND FOTO = 'Frizzanti Escursioni In Quad.jpg' AND VALID=1;
Tiempo de la consulta: 0.0043859481811523
Tiempo acumulado:1.1516084671021
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[163]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0039219856262207
Tiempo acumulado:1.1555304527283
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[164]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0012109279632568
Tiempo acumulado:1.1567413806915
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[165]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00051093101501465
Tiempo acumulado:1.1572523117065
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[166]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0077111721038818
Tiempo acumulado:1.1649634838104
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[167]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00087404251098633
Tiempo acumulado:1.1658375263214
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[168]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0084371566772461
Tiempo acumulado:1.1742746829987
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[169]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.010993957519531
Tiempo acumulado:1.1852686405182
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[170]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0013110637664795
Tiempo acumulado:1.1865797042847
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[171]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0067441463470459
Tiempo acumulado:1.1933238506317
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[172]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0018000602722168
Tiempo acumulado:1.1951239109039
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[173]: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.0068509578704834
Tiempo acumulado:1.2019748687744
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[174]: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'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00057101249694824
Tiempo acumulado:1.2025458812714
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[175]: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.00056719779968262
Tiempo acumulado:1.203113079071
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[176]: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.00078105926513672
Tiempo acumulado:1.2038941383362
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[177]: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_con_traducciones'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0029408931732178
Tiempo acumulado:1.2068350315094
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[178]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00052809715270996
Tiempo acumulado:1.2073631286621
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[179]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0039591789245605
Tiempo acumulado:1.2113223075867
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[180]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0034089088439941
Tiempo acumulado:1.2147312164307
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[181]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00062990188598633
Tiempo acumulado:1.2153611183167
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[182]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0020389556884766
Tiempo acumulado:1.2174000740051
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[183]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0010619163513184
Tiempo acumulado:1.2184619903564
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[184]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00091886520385742
Tiempo acumulado:1.2193808555603
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[185]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0017211437225342
Tiempo acumulado:1.2211019992828
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[186]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00078296661376953
Tiempo acumulado:1.2218849658966
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[187]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.00502610206604
Tiempo acumulado:1.2269110679626
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[188]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.002112865447998
Tiempo acumulado:1.2290239334106
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[189]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0098409652709961
Tiempo acumulado:1.2388648986816
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[190]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0097239017486572
Tiempo acumulado:1.2485888004303
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[191]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0018670558929443
Tiempo acumulado:1.2504558563232
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread SQL[192]:SELECT IF (CFG.VALUE_PROD IS NOT NULL AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta: 0.0070528984069824
Tiempo acumulado:1.2575087547302
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[193]:SELECT SUM(TOTAL) AS TOTAL,TIPO_CONTENIDOS,ID_GRUPO_CAT, DESC_GRUPO, URL FROM (SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_es_ES.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_es_ES.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_es_ES.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_es_ES.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '12'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='1'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_pt_PT.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_pt_PT.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_pt_PT.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_pt_PT.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '82'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='8'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_co_UK.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_co_UK.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_co_UK.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_co_UK.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '2'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='2'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_mx_MX.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_mx_MX.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '52'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='5'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_it_IT.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_it_IT.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_it_IT.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '32'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='3'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_fr_FR.LO_CONTENIDOS CON
INNERJOIN Prod_Yumping_fr_FR.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNERJOIN Prod_Yumping_fr_FR.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNERJOIN Prod_Yumping_fr_FR.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '42'
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA<>'')
AND CON.ID_TROPIC='4'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
) AS CATEGORIAS
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
ORDER BY ID_GRUPO_CAT ASC;
Tiempo de la consulta: 0.063655138015747
Tiempo acumulado:1.321163892746
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[194]:SELECT PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO,
GALERIA_PRE,NOMBRE,SECI.DESC_SECTOR,REI.DESC_REGION,DESC_POBLACION,FOTOPRINCIPAL_PRE,
EMP.URL URL,SECI.ID_SECTOR ID_SECTOR, SECI.URL URL_SECTOR,REI.URL URL_REGION,
LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO,
DESCUENTO_MIN_PRE DESCUENTO,
DATE_FORMAT(FECHA_CADUCIDAD_PD_PRE,'%d') AS DIA_CAD,
DATE_FORMAT(FECHA_CADUCIDAD_PD_PRE,'%m') AS MES_CAD,
DATE_FORMAT(FECHA_CADUCIDAD_PD_PRE,'%Y') AS ANYO_CAD, PRE.MULTIACTIVIDAD_PRE
FROM LO_PRECIOS PRE
INNERJOIN LO_PRECIOS_TRADUCCION_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT AND PT.IDIOMA_PT = 'en'
INNERJOIN LO_PRECIOS_SECTORES PS ON PRE.ID_PRECIO=PS.ID_PRECIO_PS
INNERJOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA AND( EMP.VALID=1 OR EMP.VALID='-3')
INNERJOIN LO_SECTORES SEC ON PS.ID_ACTIVIDAD_PS=SEC.ID_SECTOR
INNERJOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
AND SECI.ID_TROPIC=32
AND SECI.FK_ID_IDIOMA_SI18N='en'
INNERJOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA='en'
INNERJOIN LO_POBLACION_IT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE AND PO.IDIOMA='en'
INNERJOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE PRE.MULTIACTIVIDAD_PRE=0 AND PRE.VALID_PRE=4
GROUP BY ID_PRECIO
ORDER BY RAND()
LIMIT 5;
Tiempo de la consulta (super_slow_query): 2.1917290687561
Tiempo acumulado:3.5128929615021
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[195]: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 INNERJOIN LO_PRECIOS_TRADUCCION_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT AND PT.IDIOMA_PT = 'en' WHERE PRE.ID_PRECIO = 79925;
Tiempo de la consulta: 0.00066304206848145
Tiempo acumulado:3.5135560035706
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[196]:SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNERJOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 79925;
Tiempo de la consulta: 0.0010771751403809
Tiempo acumulado:3.5146331787109
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[197]:SELECT* FROM LO_FOTOS WHERE ID_PRECIO = 79925 AND VALID = 1;
Tiempo de la consulta: 0.019200086593628
Tiempo acumulado:3.5338332653046
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[198]:SELECT* FROM LO_FOTOS WHERE ID_PRECIO = 79925 AND FOTO = 'p-79925-schermata-2022-06-21-alle-111655806523_16558074583189.49.jpg' AND VALID = 1;
Tiempo de la consulta: 0.0025079250335693
Tiempo acumulado:3.5363411903381
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[199]:SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS FROM LO_COM_IMAGES_NEW_FORMATS WHERE ID_PRECIO =79925;
Tiempo de la consulta: 0.0065460205078125
Tiempo acumulado:3.5428872108459
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[200]: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 INNERJOIN LO_PRECIOS_TRADUCCION_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT AND PT.IDIOMA_PT = 'en' WHERE PRE.ID_PRECIO = 86877;
Tiempo de la consulta: 0.0009160041809082
Tiempo acumulado:3.5438032150269
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[201]:SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNERJOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 86877;
Tiempo de la consulta: 0.0036561489105225
Tiempo acumulado:3.5474593639374
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[202]:SELECT PRE.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, PRE.PRECIO_PRE, PRE.MAX_PERS_PRE, PRE.MIN_PERS_PRE, PRE.ID_PRECIO,
PRE.MULTIACTIVIDAD_PRE, PRE.ID_EMPRESA_PRE, PRE.ID_REGION_PRE,PRE.VALID_PRE, PRE.ALOJAMIENTO_PRE, PRE.EDAD_MINIMA_PRE,
PRE.TRANSPORTE_PRE, PRE.COMIDA_PRE,PRE.GALERIA_PRE, PRE.FOTOPRINCIPAL_PRE, PRECIO_UNITARIO_PRE
,REI.DESC_REGION DESC_REGION, EXI.N_VENTAS, EXI.EXITO, SECI.URL URL_SECTOR,REI.URL URL_REGION,
EMP.*, POI.DESC_POBLACION, POI.URL_POBLACION, SECI.DESC_SECTOR, SECP.ID_ACTIVIDAD_PS,Ceiling(AVG(OP.VALORACION)) AS VALORACION, SECI.DESC_SECTOR_ALT, SECI.DESC_SECTOR_ALT_PLURAL,
COUNT(DISTINCT OP.ID_OPINION) as N_OPINIONES,EMPS.CENTRAL_ACTIVA, REI.ID_REGION, SECI.ID_SECTOR, PD.OFERTA_PD,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA,PERIODO_PRE,ANTELACION_PRE, SEC.ID_GRUPO,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FEC_ULT_COMPRA,
IF(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO,
IF(PRECIO_PD>0 AND VALID_PD=1, (1-(MIN(PRECIO_PD)/PRECIO_PRE))*100 ,0) DESCUENTO,
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,
SIN_FECHA_PRE, PRE.CANTIDAD_UNITARIO_PRE, DATE_FORMAT(PRE.FEC_INSERT_PRE,'%Y/%m/%d') AS FEC_INSERT_PRE, EMP.LATITUDE, EMP.LONGITUDE, PRE.N_VENTAS_PRE
,PRE.ID_POBLACION_PRE, PRE.ID_POBLACION_PRE AS ID_POBLACION
FROM LO_PRECIOS PRE
INNERJOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
INNERJOIN LO_EMPRESAS_STAT EMPS ON EMP.ID_EMPRESA=EMPS.FK_ID_EST
INNERJOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
/* AND SECP.ID_ACTIVIDAD_PS NOT IN (100,101)*/
AND SECP.ID_ACTIVIDAD_PS = (SELECT PS.ID_ACTIVIDAD_PS FROM LO_PRECIOS_SECTORES PS WHERE PS.ID_PRECIO_PS = PRE.ID_PRECIO ORDER BY IF(PS.ID_ACTIVIDAD_PS = 100 OR PS.ID_ACTIVIDAD_PS = 101, 10000, 1) ASC LIMIT 1)
INNERJOIN LO_SECTORES SEC ON SECP.ID_ACTIVIDAD_PS=SEC.ID_SECTOR
INNERJOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N ='en'
AND SECI.ID_TROPIC = 32
INNERJOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE AND REI.IDIOMA ='en'
INNERJOIN LO_POBLACION_IT POI ON POI.ID_POBLACION = PRE.ID_POBLACION_PRE
AND POI.IDIOMA ='en'
LEFTJOIN LO_PRECIOS_EXITO EXI ON PRE.ID_PRECIO = EXI.ID_PRECIO
LEFTJOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
AND RC.VALID_RC NOT IN (7,2,0)
LEFTJOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID = 1
LEFTJOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNERJOIN LO_PRECIOS_TRADUCCION_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT AND PT.IDIOMA_PT = 'en'
WHERE REI.IDIOMA='en'
AND EMP.VALID=1
AND VALID_PRE IN(1,4,3)
AND PRE.ID_PRECIO='89258'
LIMIT 1;
Tiempo de la consulta: 0.02492094039917
Tiempo acumulado:3.5723803043365
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[203]:SELECT* FROM LO_FOTOS WHERE ID_PRECIO = 86877 AND VALID = 1;
Tiempo de la consulta: 0.041156053543091
Tiempo acumulado:3.6135363578796
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[204]:SELECT* FROM LO_FOTOS WHERE ID_PRECIO = 86877 AND FOTO = 'pre-86877-cavalli51689259733.jpg' AND VALID = 1;
Tiempo de la consulta: 0.0027029514312744
Tiempo acumulado:3.6162393093109
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[205]:SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS FROM LO_COM_IMAGES_NEW_FORMATS WHERE ID_PRECIO =86877;
Tiempo de la consulta: 0.018313884735107
Tiempo acumulado:3.634553194046
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[206]: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 INNERJOIN LO_PRECIOS_TRADUCCION_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT AND PT.IDIOMA_PT = 'en' WHERE PRE.ID_PRECIO = 8005;
Tiempo de la consulta: 0.0043330192565918
Tiempo acumulado:3.6388862133026
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[207]:SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNERJOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 8005;
Tiempo de la consulta: 0.0036060810089111
Tiempo acumulado:3.6424922943115
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[208]:SELECT* FROM LO_FOTOS WHERE ID_PRECIO = 8005 AND VALID = 1;
Tiempo de la consulta: 0.019098043441772
Tiempo acumulado:3.6615903377533
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[209]:SELECT* FROM LO_FOTOS WHERE ID_PRECIO = 8005 AND FOTO = 'preparando-attrezzature.jpg' AND VALID = 1;
Tiempo de la consulta: 0.0035130977630615
Tiempo acumulado:3.6651034355164
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[210]:SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS FROM LO_COM_IMAGES_NEW_FORMATS WHERE ID_PRECIO =8005;
Tiempo de la consulta: 0.00045204162597656
Tiempo acumulado:3.6655554771423
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[211]: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 INNERJOIN LO_PRECIOS_TRADUCCION_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT AND PT.IDIOMA_PT = 'en' WHERE PRE.ID_PRECIO = 50446;
Tiempo de la consulta: 0.0022919178009033
Tiempo acumulado:3.6678473949432
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[212]:SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNERJOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 50446;
Tiempo de la consulta: 0.0019381046295166
Tiempo acumulado:3.6697854995728
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[213]:SELECT* FROM LO_FOTOS WHERE ID_PRECIO = 50446 AND VALID = 1;
Tiempo de la consulta: 0.016149997711182
Tiempo acumulado:3.6859354972839
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[214]:SELECT* FROM LO_FOTOS WHERE ID_PRECIO = 50446 AND FOTO = 'p-50446-surfer-2212948-960-720_14970066164719.jpg' AND VALID = 1;
Tiempo de la consulta: 0.00079894065856934
Tiempo acumulado:3.6867344379425
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[215]:SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS FROM LO_COM_IMAGES_NEW_FORMATS WHERE ID_PRECIO =50446;
Tiempo de la consulta: 0.0028820037841797
Tiempo acumulado:3.6896164417267
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[216]: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 INNERJOIN LO_PRECIOS_TRADUCCION_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT AND PT.IDIOMA_PT = 'en' WHERE PRE.ID_PRECIO = 49456;
Tiempo de la consulta: 0.00093507766723633
Tiempo acumulado:3.6905515193939
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[217]:SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNERJOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 49456;
Tiempo de la consulta: 0.00061202049255371
Tiempo acumulado:3.6911635398865
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[218]:SELECT* FROM LO_FOTOS WHERE ID_PRECIO = 49456 AND VALID = 1;
Tiempo de la consulta: 0.0034990310668945
Tiempo acumulado:3.6946625709534
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[219]:SELECT* FROM LO_FOTOS WHERE ID_PRECIO = 49456 AND FOTO = 'p-49456-10177409-738078059548759-2245169528734238097-n_14931973689030.jpg' AND VALID = 1;
Tiempo de la consulta: 0.0063998699188232
Tiempo acumulado:3.7010624408722
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[220]:SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS FROM LO_COM_IMAGES_NEW_FORMATS WHERE ID_PRECIO =49456;
Tiempo de la consulta: 0.0065610408782959
Tiempo acumulado:3.7076234817505
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[221]:SELECT CON.ID_CONTENIDO, CON.TITULO,CON.TIPO_CONTENIDOS, CON.DESCRIPCION, CON.TEXTO, CON.GALERIA,
CON.GALERIA_DESC, CON.FOTOPRINCIPAL, DATE_FORMAT(CON.FEC_INSERT,'%d/%m/%y') AS FEC_INSERT,
AD.NOMBRE, AD.MAIL,CON.NOMBRE_FIRMA_CON,TIPO_CONTENIDOS, CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM LO_CONTENIDOS CON
INNERJOIN LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = CON.ID_CONTENIDO AND LANGUAGE = 'en'
INNERJOIN LO_ADMIN_USERS AD ON AD.LOGIN = CON.OPERATOR_INSERT
INNERJOIN LO_CONTENIDOS_CATEG CATEG ON CATEG.ID_CATEG = CON.ID_CATEG
WHERE (CON.GALERIA IS NOT NULL AND CON.GALERIA <> '')
AND CON.ID_TROPIC = '3'
AND CON.VALID = 1
AND CON.ID_CONTENIDO NOT IN ('1860')
ORDER BY FIELD(TIPO_CONTENIDOS,1) DESC, CON.FEC_INSERT DESC
LIMIT 5;
Tiempo de la consulta: 0.018939971923828
Tiempo acumulado:3.7265634536743
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[222]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1859 AND FOTO = 'c-1107-tb-p-49632-screenshot-1-149389270760151585140033.6438.jpg' AND VALID=1;
Tiempo de la consulta: 0.0022809505462646
Tiempo acumulado:3.7288444042206
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[223]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1855 AND FOTO = '142699e1-ad0e-4a1f-815d-9ddbb26e8ff01702981239.jpg' AND VALID=1;
Tiempo de la consulta: 0.0024979114532471
Tiempo acumulado:3.7313423156738
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[224]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1853 AND FOTO = 'Armi di Paintball - EGO Planet Eclipse.jpg' AND VALID=1;
Tiempo de la consulta: 0.014559984207153
Tiempo acumulado:3.745902299881
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[225]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1854 AND FOTO = 'Stili di sci di fondo.jpg' AND VALID=1;
Tiempo de la consulta: 0.00065898895263672
Tiempo acumulado:3.7465612888336
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[226]:SELECT* FROM LO_FOTOS WHERE ID_CONTENIDO = 1852 AND FOTO = 'quadhptservice-1610630900-2486474670769123430-112340804341700477671.jpg' AND VALID=1;
Tiempo de la consulta: 0.00067901611328125
Tiempo acumulado:3.7472403049469
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[227]:SELECT RS.N_OFERTAS AS NEMPRESAS, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION
FROM LO_PRECIOS PRE
INNERJOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNERJOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS AND SECI.ID_TROPIC = 32 AND SECI.FK_ID_IDIOMA_SI18N = 'en'
INNERJOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE AND REI.IDIOMA = 'en'
INNERJOIN LO_REGION_STATS RS ON RS.ID_REGION = REI.ID_REGION AND RS.N_OFERTAS > 0
WHERE PRE.VALID_PRE = 4 AND (RS.ID_GRUPO IS NULL OR RS.ID_GRUPO = 0) AND (RS.ID_SECTOR IS NULL OR RS.ID_SECTOR = 0) AND (RS.ID_SUBSECTOR IS NULL OR RS.ID_SUBSECTOR = 0)
GROUP BY PRE.ID_REGION_PRE
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta: 0.0044798851013184
Tiempo acumulado:3.7517201900482
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk SQL[228]:SELECT* FROM LO_EQUIPO_EDITORIAL EE WHERE EE.ID_TROPIC = 32;
10 ideas to celebrate a birthday in MilanRead more
Some adventure sports to tryRead more
Adventure and handicapRead more
Do you need ideas to organize a bachelor party?Read more
