yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/index.php
BBDD->Prod_Yumping_fr_FR
AMBITO->fr
AMBITO_AJAX->fr
AMBITO_AJAX COOKIE->mx_es
locale LO_CONFIG->fr_FR
locale php->fr_FR
Fuente tráfico->0
SESSION VARS
DEFINED VARS
$tpage->
homeCache VARS
NOCFG->memcache_port->11212
CFG->memcache_main_server->172.30.2.194
CFG->memcache_add_servers->172.30.2.194
YMMemcache::memcache_stats->
SERVER VARS
HTTP_REFERER
Request VARS
ambito_lang->fr
Total queries: 84
Tiempo total: 0.52776908874512
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[1]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'fr')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.019268989562988Tiempo acumulado:0.019268989562988
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[2]: SELECT IF(VALUE_PROD IS NULL, VALUE, VALUE_PROD) as VAL, NAME
FROM LO_CONFIG C
WHERE C.NAME in ('Request_Data_Base_Country','Request_Multi_Country')
AND AMBITO = 'es';
Tiempo de la consulta:
0.0052070617675781Tiempo acumulado:0.024476051330566
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[3]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'fr')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.021316051483154Tiempo acumulado:0.045792102813721
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[4]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.016142129898071Tiempo acumulado:0.061934232711792
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[5]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0030910968780518Tiempo acumulado:0.065025329589844
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[6]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';
Tiempo de la consulta:
0.0021491050720215Tiempo acumulado:0.067174434661865
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[7]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/fr';
Tiempo de la consulta:
0.0025980472564697Tiempo acumulado:0.069772481918335
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[8]: SELECT *
FROM LO_SEO_INDEX SI
WHERE ID_TROPIC = 4;
Tiempo de la consulta:
0.020336866378784Tiempo acumulado:0.090109348297119
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[9]: SELECT SUM(NUM_PRECIOS) AS NUM_PRECIOS
FROM (
SELECT s.NUM_PRECIOS
FROM Yumping.LO_YUMPING_STATS s
UNION ALL
SELECT s.NUM_PRECIOS
FROM Yumping_it_IT.LO_YUMPING_STATS s
UNION ALL
SELECT s.NUM_PRECIOS
FROM Yumping_fr_FR.LO_YUMPING_STATS s
UNION ALL
SELECT s.NUM_PRECIOS
FROM Yumping_co_UK.LO_YUMPING_STATS s
UNION ALL
SELECT s.NUM_PRECIOS
FROM Yumping_mx_MX.LO_YUMPING_STATS s
) AS STATS;
Tiempo de la consulta:
0.0053420066833496Tiempo acumulado:0.095451354980469
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[10]: 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_href_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054192543029785Tiempo acumulado:0.095993280410767
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[11]: 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_href_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0016539096832275Tiempo acumulado:0.097647190093994
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[12]: 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_href_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005638599395752Tiempo acumulado:0.098211050033569
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[13]: 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_href_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055289268493652Tiempo acumulado:0.098763942718506
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[14]: 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.00079917907714844Tiempo acumulado:0.099563121795654
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[15]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0011279582977295Tiempo acumulado:0.10069108009338
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[16]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0017280578613281Tiempo acumulado:0.10241913795471
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[17]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055909156799316Tiempo acumulado:0.10297822952271
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[18]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053119659423828Tiempo acumulado:0.10350942611694
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[19]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00078797340393066Tiempo acumulado:0.10429739952087
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[20]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00081300735473633Tiempo acumulado:0.10511040687561
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[21]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00063204765319824Tiempo acumulado:0.10574245452881
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[22]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056815147399902Tiempo acumulado:0.10631060600281
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[23]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012800693511963Tiempo acumulado:0.107590675354
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[24]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052404403686523Tiempo acumulado:0.10811471939087
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[25]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050592422485352Tiempo acumulado:0.10862064361572
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[26]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00064587593078613Tiempo acumulado:0.10926651954651
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[27]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00063896179199219Tiempo acumulado:0.1099054813385
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[28]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00077009201049805Tiempo acumulado:0.110675573349
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[29]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046300888061523Tiempo acumulado:0.11113858222961
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[30]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00069904327392578Tiempo acumulado:0.11183762550354
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[31]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060796737670898Tiempo acumulado:0.11244559288025
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[32]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055694580078125Tiempo acumulado:0.11300253868103
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[33]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045299530029297Tiempo acumulado:0.11345553398132
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[34]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0009911060333252Tiempo acumulado:0.11444664001465
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[35]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00078320503234863Tiempo acumulado:0.115229845047
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[36]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001162052154541Tiempo acumulado:0.11639189720154
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[37]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00070381164550781Tiempo acumulado:0.11709570884705
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[38]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00067710876464844Tiempo acumulado:0.11777281761169
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[39]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0013089179992676Tiempo acumulado:0.11908173561096
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[40]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0017349720001221Tiempo acumulado:0.12081670761108
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[41]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010440349578857Tiempo acumulado:0.12186074256897
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[42]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010600090026855Tiempo acumulado:0.12292075157166
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[43]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056099891662598Tiempo acumulado:0.12348175048828
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[44]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058388710021973Tiempo acumulado:0.1240656375885
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[45]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00076699256896973Tiempo acumulado:0.12483263015747
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[46]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0021700859069824Tiempo acumulado:0.12700271606445
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[47]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00076699256896973Tiempo acumulado:0.12776970863342
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[48]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00044703483581543Tiempo acumulado:0.12821674346924
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[49]: SELECT sum(NUM_PRECIOS) AS NUM_PRECIOS, SUM(NUM_EMPRESAS) AS NUM_EMPRESAS,
SUM(NUM_OPINIONES) AS NUM_OPINIONES, SUM(NUM_COMPRAS) AS NUM_COMPRAS
FROM (
SELECT NUM_PRECIOS, NUM_EMPRESAS,NUM_OPINIONES,NUM_COMPRAS
FROM Yumping.LO_YUMPING_STATS
WHERE TYPE = 1
UNION ALL
SELECT NUM_PRECIOS, NUM_EMPRESAS,NUM_OPINIONES,NUM_COMPRAS
FROM Yumping_co_UK.LO_YUMPING_STATS
WHERE TYPE = 1
UNION ALL
SELECT NUM_PRECIOS, NUM_EMPRESAS,NUM_OPINIONES,NUM_COMPRAS
FROM Yumping_fr_FR.LO_YUMPING_STATS
WHERE TYPE = 1
UNION ALL
SELECT NUM_PRECIOS, NUM_EMPRESAS,NUM_OPINIONES,NUM_COMPRAS
FROM Yumping_it_IT.LO_YUMPING_STATS
WHERE TYPE = 1
UNION ALL
SELECT NUM_PRECIOS, NUM_EMPRESAS,NUM_OPINIONES,NUM_COMPRAS
FROM Yumping_mx_MX.LO_YUMPING_STATS
WHERE TYPE = 1
) AS stats;
Tiempo de la consulta:
0.032530069351196Tiempo acumulado:0.16074681282043
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: SELECT G.ID_GRUPO, G.DESC_GRUPO, G.URL URL_GRUPO
FROM LO_SECTORES SEC
INNER JOIN LO_GRUPOS G ON G.ID_GRUPO = SEC.ID_GRUPO
AND G.ID_TROPIC = 4
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE G.ID_GRUPO != 8
AND G.ID_GRUPO != 10
GROUP BY SEC.ID_GRUPO
ORDER BY SUM(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.032959938049316Tiempo acumulado:0.19370675086975
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[51]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 2
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.0038418769836426Tiempo acumulado:0.19754862785339
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[52]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 4
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 2
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0078470706939697Tiempo acumulado:0.20539569854736
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[53]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 4
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00089788436889648Tiempo acumulado:0.20629358291626
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[54]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 4
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 4
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0066680908203125Tiempo acumulado:0.21296167373657
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[55]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 1
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00096797943115234Tiempo acumulado:0.21392965316772
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[56]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 4
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 1
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0047538280487061Tiempo acumulado:0.21868348121643
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[57]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 6
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.0016739368438721Tiempo acumulado:0.2203574180603
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[58]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 4
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 6
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0016200542449951Tiempo acumulado:0.2219774723053
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[59]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 3
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.0068800449371338Tiempo acumulado:0.22885751724243
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[60]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 4
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 3
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.004770040512085Tiempo acumulado:0.23362755775452
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[61]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 5
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00073504447937012Tiempo acumulado:0.23436260223389
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[62]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 4
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 5
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0047531127929688Tiempo acumulado:0.23911571502686
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[63]: SELECT TEXTO_SINDEX, TEXTO_SINDEX2
FROM LO_SEO_INDEX
WHERE ID_TROPIC='4'
LIMIT 1;
Tiempo de la consulta:
0.00089883804321289Tiempo acumulado:0.24001455307007
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[64]: SELECT *
FROM LO_VENTAS_STATS
WHERE ID_TROPIC = 4;
Tiempo de la consulta:
0.00075507164001465Tiempo acumulado:0.24076962471008
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[65]: SELECT DISTINCT
ST.ID_SECTOR,
SECI.DESC_SECTOR,
SECI.URL AS URL_SECTOR,
IF (POI.ID_REGION, POI.ID_REGION, ST.ID_REGION) AS ID_REGION,
REI.DESC_REGION,
REI.URL AS URL_REGION,
ST.ID_REGION_ADM,
REA.DESC_REGION AS DESC_REGION_ADM,
REA.URL AS URL_REGION_ADM,
ST.ID_POBLACION,
POI.DESC_POBLACION AS DESC_POBLACION,
POI.URL_POBLACION AS URL_POBLACION,
ST.N_VENTAS
, ST.META_TITLE_ALT
FROM
LO_VENTAS_STATS ST
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '4'
LEFT JOIN LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'fr'
LEFT JOIN LO_POBLACION_FR POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'fr'
LEFT JOIN LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'fr'
WHERE MOSTRAR = 1
AND (ST.ID_TROPIC = 0)
ORDER BY
FIJO DESC,
IF(ORDEN IS NOT NULL,ORDEN,100000) ASC,
ANUAL ASC,
N_VENTAS DESC
LIMIT 30;
Tiempo de la consulta:
0.050318002700806Tiempo acumulado:0.29108762741089
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[66]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 64
AND IDIOMA = 'fr';
Tiempo de la consulta:
0.0041611194610596Tiempo acumulado:0.29524874687195
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[67]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005650520324707Tiempo acumulado:0.29581379890442
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[68]: SELECT DISTINCT ST.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, IF (POI.ID_REGION, POI.ID_REGION, ST.ID_REGION) AS ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION, ST.ID_REGION_ADM, REA.DESC_REGION AS DESC_REGION_ADM, REA.URL AS URL_REGION_ADM, ST.ID_POBLACION,
POI.DESC_POBLACION AS DESC_POBLACION, POI.URL_POBLACION AS URL_POBLACION, ST.N_VENTAS , ST.META_TITLE_ALT
FROM Prod_Yumping_es_ES.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_es_ES.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '14'
LEFT JOIN Prod_Yumping_es_ES.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'fr'
LEFT JOIN Prod_Yumping_es_ES.LO_POBLACION_ES POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'fr'
LEFT JOIN Prod_Yumping_es_ES.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'fr'
WHERE MOSTRAR = 1
AND (ST.ID_TROPIC = 0)
ORDER BY FIJO DESC, IF(ORDEN IS NOT NULL,ORDEN,100000) ASC, ANUAL ASC, N_VENTAS DESC
LIMIT 15;
Tiempo de la consulta:
0.039736986160278Tiempo acumulado:0.3355507850647
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[69]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 28
AND IDIOMA = 'fr';
Tiempo de la consulta:
0.0064070224761963Tiempo acumulado:0.34195780754089
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[70]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00094389915466309Tiempo acumulado:0.34290170669556
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[71]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00092196464538574Tiempo acumulado:0.34382367134094
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[72]: SELECT DISTINCT ST.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, IF (POI.ID_REGION, POI.ID_REGION, ST.ID_REGION) AS ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION, ST.ID_REGION_ADM, REA.DESC_REGION AS DESC_REGION_ADM, REA.URL AS URL_REGION_ADM, ST.ID_POBLACION,
POI.DESC_POBLACION AS DESC_POBLACION, POI.URL_POBLACION AS URL_POBLACION, ST.N_VENTAS , ST.META_TITLE_ALT
FROM Prod_Yumping_it_IT.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_it_IT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '34'
LEFT JOIN Prod_Yumping_it_IT.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'fr'
LEFT JOIN Prod_Yumping_it_IT.LO_POBLACION_IT POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'fr'
LEFT JOIN Prod_Yumping_it_IT.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'fr'
WHERE MOSTRAR = 1
AND (ST.ID_TROPIC = 0)
ORDER BY FIJO DESC, IF(ORDEN IS NOT NULL,ORDEN,100000) ASC, ANUAL ASC, N_VENTAS DESC
LIMIT 15;
Tiempo de la consulta:
0.046757936477661Tiempo acumulado:0.3905816078186
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[73]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 29
AND IDIOMA = 'fr';
Tiempo de la consulta:
0.014631986618042Tiempo acumulado:0.40521359443665
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[74]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0033061504364014Tiempo acumulado:0.40851974487305
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[75]: SELECT DISTINCT ST.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, IF (POI.ID_REGION, POI.ID_REGION, ST.ID_REGION) AS ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION, ST.ID_REGION_ADM, REA.DESC_REGION AS DESC_REGION_ADM, REA.URL AS URL_REGION_ADM, ST.ID_POBLACION,
POI.DESC_POBLACION AS DESC_POBLACION, POI.URL_POBLACION AS URL_POBLACION, ST.N_VENTAS , ST.META_TITLE_ALT
FROM Prod_Yumping_co_UK.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '24'
LEFT JOIN Prod_Yumping_co_UK.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'fr'
LEFT JOIN Prod_Yumping_co_UK.LO_POBLACION_GB POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'fr'
LEFT JOIN Prod_Yumping_co_UK.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'fr'
WHERE MOSTRAR = 1
AND (ST.ID_TROPIC = 0)
ORDER BY FIJO DESC, IF(ORDEN IS NOT NULL,ORDEN,100000) ASC, ANUAL ASC, N_VENTAS DESC
LIMIT 15;
Tiempo de la consulta:
0.043044805526733Tiempo acumulado:0.45156455039978
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[76]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 247
AND IDIOMA = 'fr';
Tiempo de la consulta:
0.0012309551239014Tiempo acumulado:0.45279550552368
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[77]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00063490867614746Tiempo acumulado:0.45343041419983
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[78]: SELECT DISTINCT ST.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, IF (POI.ID_REGION, POI.ID_REGION, ST.ID_REGION) AS ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION, ST.ID_REGION_ADM, REA.DESC_REGION AS DESC_REGION_ADM, REA.URL AS URL_REGION_ADM, ST.ID_POBLACION,
POI.DESC_POBLACION AS DESC_POBLACION, POI.URL_POBLACION AS URL_POBLACION, ST.N_VENTAS , ST.META_TITLE_ALT
FROM Prod_Yumping_mx_MX.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_mx_MX.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '54'
LEFT JOIN Prod_Yumping_mx_MX.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'fr'
LEFT JOIN Prod_Yumping_mx_MX.LO_POBLACION_MX POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'fr'
LEFT JOIN Prod_Yumping_mx_MX.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'fr'
WHERE MOSTRAR = 1
AND (ST.ID_TROPIC = 0)
ORDER BY FIJO DESC, IF(ORDEN IS NOT NULL,ORDEN,100000) ASC, ANUAL ASC, N_VENTAS DESC
LIMIT 15;
Tiempo de la consulta:
0.018004894256592Tiempo acumulado:0.47143530845642
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[79]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 301
AND IDIOMA = 'fr';
Tiempo de la consulta:
0.0006558895111084Tiempo acumulado:0.47209119796753
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[80]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 64
AND IDIOMA = 'fr';
Tiempo de la consulta:
0.00096011161804199Tiempo acumulado:0.47305130958557
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[81]: SELECT ID_REGION_ADM1
FROM LO_REGION RE
GROUP BY ID_REGION_ADM1
HAVING count(*) > 1;
Tiempo de la consulta:
0.00199294090271Tiempo acumulado:0.47504425048828
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[82]: SELECT ID_REGION, DESC_REGION, URL_REGION, N_OFERTAS
FROM (
SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL AS URL_REGION, RS.N_OFERTAS
FROM Prod_Yumping_fr_FR.LO_REGION_STATS RS
INNER JOIN Prod_Yumping_fr_FR.LO_REGION RE ON RE.ID_REGION = RS.ID_REGION
AND RE.ID_PAIS = 64
INNER JOIN Prod_Yumping_fr_FR.LO_REGION_I18N REI ON REI.ID_REGION = RS.ID_REGION
AND REI.IDIOMA = 'fr'
WHERE /*RS.N_OFERTAS >= 15
AND*/ RS.ID_SECTOR IS NOT NULL
AND RS.ID_SECTOR != 0
GROUP BY REI.ID_REGION
UNION ALL
SELECT REA.ID_REGION_ADM1 AS ID_REGION, REA.DESC_REGION, REA.URL AS URL_REGION, RAS.N_OFERTAS
FROM Prod_Yumping_fr_FR.LO_REGION_ADM1_STATS RAS
INNER JOIN Prod_Yumping_fr_FR.LO_REGION RE ON RE.ID_REGION_ADM1 = RAS.ID_REGION_ADM1
AND RE.ID_PAIS = 64
INNER JOIN Prod_Yumping_fr_FR.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = RAS.ID_REGION_ADM1
AND REA.IDIOMA = 'fr'
WHERE /*RAS.N_OFERTAS >= 15
AND*/ RAS.ID_SECTOR IS NOT NULL
AND RAS.ID_SECTOR != 0
AND REA.ID_REGION_ADM1 in ( 42,39,23,41,28,36,33,31,40,27,34,22,25,26,30,38,35,37,21,32)
GROUP BY REA.ID_REGION_ADM1
) AS REGIONES
ORDER BY N_OFERTAS DESC
LIMIT 20;
Tiempo de la consulta:
0.04273796081543Tiempo acumulado:0.51778221130371
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[83]: SELECT PAI.ID_PAIS, PAI.DESC_PAIS, PAI.URL URL_PAIS
FROM LO_PAIS PA, LO_PAIS_I18N PAI
WHERE PAI.ID_PAIS=PA.ID_PAIS
AND PAI.IDIOMA='fr'
AND PAI.ID_PAIS='64'
ORDER BY DESC_PAIS;
Tiempo de la consulta:
0.0085890293121338Tiempo acumulado:0.52637124061584
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[84]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 4;
Tiempo de la consulta:
0.0013978481292725Tiempo acumulado:0.52776908874512
