yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/index.php
BBDD->Prod_Yumping_es_ES
AMBITO->es
AMBITO_AJAX->es
AMBITO_AJAX COOKIE->
locale LO_CONFIG->es_ES
locale php->es_ES
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->es_ES
Total queries: 93
Tiempo total: 0.22131395339966
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[1]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'es')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0070579051971436Tiempo acumulado:0.0070579051971436
(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.00056791305541992Tiempo acumulado:0.0076258182525635
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[3]: SELECT *
FROM LO_CONFIG C
WHERE C.AMBITO = (
SELECT AMBITO
FROM LO_CONFIG C
WHERE CONCAT('/',C.VALUE) = ''
AND NAME = 'Request_url_partner'
LIMIT 1)
AND (NAME = 'subdomain' OR NAME = 'subdomain_lang');
Tiempo de la consulta:
0.00061202049255371Tiempo acumulado:0.0082378387451172
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[4]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'es')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0075209140777588Tiempo acumulado:0.015758752822876
(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.0025069713592529Tiempo acumulado:0.018265724182129
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[6]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00032997131347656Tiempo acumulado:0.018595695495605
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[7]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';
Tiempo de la consulta:
0.00055789947509766Tiempo acumulado:0.019153594970703
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[8]: SELECT *
FROM LO_SEO_INDEX SI
WHERE ID_TROPIC = 1;
Tiempo de la consulta:
0.0029559135437012Tiempo acumulado:0.022109508514404
(Prod_Yumping_es_ES) (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.0028960704803467Tiempo acumulado:0.025005578994751
(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 = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049781799316406Tiempo acumulado:0.025503396987915
(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 = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048398971557617Tiempo acumulado:0.025987386703491
(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 = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042486190795898Tiempo acumulado:0.02641224861145
(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 = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059294700622559Tiempo acumulado:0.027005195617676
(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 = '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.00047802925109863Tiempo acumulado:0.027483224868774
(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 = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042009353637695Tiempo acumulado:0.027903318405151
(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 = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043582916259766Tiempo acumulado:0.028339147567749
(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 = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041604042053223Tiempo acumulado:0.028755187988281
(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 = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041699409484863Tiempo acumulado:0.02917218208313
(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 = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042390823364258Tiempo acumulado:0.029596090316772
(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 = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046586990356445Tiempo acumulado:0.030061960220337
(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 = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042510032653809Tiempo acumulado:0.030487060546875
(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 = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004119873046875Tiempo acumulado:0.030899047851562
(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 = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048589706420898Tiempo acumulado:0.031384944915771
(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 = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043988227844238Tiempo acumulado:0.031824827194214
(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 = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040507316589355Tiempo acumulado:0.032229900360107
(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 = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040793418884277Tiempo acumulado:0.03263783454895
(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 = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040507316589355Tiempo acumulado:0.033042907714844
(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 = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00039911270141602Tiempo acumulado:0.03344202041626
(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 = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042891502380371Tiempo acumulado:0.033870935440063
(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 = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043392181396484Tiempo acumulado:0.034304857254028
(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 = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040316581726074Tiempo acumulado:0.034708023071289
(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 = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00065302848815918Tiempo acumulado:0.035361051559448
(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 = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042104721069336Tiempo acumulado:0.035782098770142
(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 = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042986869812012Tiempo acumulado:0.036211967468262
(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 = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041890144348145Tiempo acumulado:0.036630868911743
(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 = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041294097900391Tiempo acumulado:0.037043809890747
(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 = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042295455932617Tiempo acumulado:0.037466764450073
(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 = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042819976806641Tiempo acumulado:0.03789496421814
(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 = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042319297790527Tiempo acumulado:0.038318157196045
(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 = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041794776916504Tiempo acumulado:0.03873610496521
(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 = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046515464782715Tiempo acumulado:0.039201259613037
(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 = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043582916259766Tiempo acumulado:0.039637088775635
(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 = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042200088500977Tiempo acumulado:0.040059089660645
(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 = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043988227844238Tiempo acumulado:0.040498971939087
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[45]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00041794776916504Tiempo acumulado:0.040916919708252
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[46]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00035595893859863Tiempo acumulado:0.041272878646851
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[47]: 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.00496506690979Tiempo acumulado:0.046237945556641
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[48]: 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 = 1
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.0059020519256592Tiempo acumulado:0.0521399974823
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[49]: 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.0011289119720459Tiempo acumulado:0.053268909454346
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: 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 = 1
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
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.0016648769378662Tiempo acumulado:0.054933786392212
(Prod_Yumping_es_ES) (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.00051593780517578Tiempo acumulado:0.055449724197388
(Prod_Yumping_es_ES) (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 = 1
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
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.0014309883117676Tiempo acumulado:0.056880712509155
(Prod_Yumping_es_ES) (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.00054097175598145Tiempo acumulado:0.057421684265137
(Prod_Yumping_es_ES) (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 = 1
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
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.0013768672943115Tiempo acumulado:0.058798551559448
(Prod_Yumping_es_ES) (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 = 6
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00049400329589844Tiempo acumulado:0.059292554855347
(Prod_Yumping_es_ES) (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 = 1
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
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.0012838840484619Tiempo acumulado:0.060576438903809
(Prod_Yumping_es_ES) (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 = 3
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00046801567077637Tiempo acumulado:0.061044454574585
(Prod_Yumping_es_ES) (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 = 1
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
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.0012269020080566Tiempo acumulado:0.062271356582642
(Prod_Yumping_es_ES) (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 = 5
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00046205520629883Tiempo acumulado:0.06273341178894
(Prod_Yumping_es_ES) (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 = 1
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
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.0012149810791016Tiempo acumulado:0.063948392868042
(Prod_Yumping_es_ES) (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 = 7
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00044798851013184Tiempo acumulado:0.064396381378174
(Prod_Yumping_es_ES) (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 = 1
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
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 = 7
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0012240409851074Tiempo acumulado:0.065620422363281
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[63]: SELECT count(*) AS num_ofertas
FROM LO_PRECIOS PRE
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
AND EMP.VALID = 1
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA = 'es'
INNER JOIN LO_PRECIOS_DIA_ESPECIAL DE ON PRE.ID_PRECIO=DE.ID_PRECIO_DE
AND (DE.ID_TIPO_DE = '1')
AND DE.VALID = 1
WHERE PRE.VALID_PRE=4;
Tiempo de la consulta:
0.0058348178863525Tiempo acumulado:0.071455240249634
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[64]: SELECT count(*) AS num_ofertas
FROM LO_PRECIOS PRE
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
AND EMP.VALID = 1
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA = 'es'
INNER JOIN LO_PRECIOS_DIA_ESPECIAL DE ON PRE.ID_PRECIO=DE.ID_PRECIO_DE
AND (DE.ID_TIPO_DE = '2')
AND DE.VALID = 1
WHERE PRE.VALID_PRE=4;
Tiempo de la consulta:
0.0024569034576416Tiempo acumulado:0.073912143707275
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[65]: SELECT count(*) AS num_ofertas
FROM LO_PRECIOS PRE
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
AND EMP.VALID = 1
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA = 'es'
INNER JOIN LO_PRECIOS_DIA_ESPECIAL DE ON PRE.ID_PRECIO=DE.ID_PRECIO_DE
AND (DE.ID_TIPO_DE = '3')
AND DE.VALID = 1
WHERE PRE.VALID_PRE=4;
Tiempo de la consulta:
0.0012021064758301Tiempo acumulado:0.075114250183105
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[66]: SELECT count(*) AS num_ofertas
FROM LO_PRECIOS PRE
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
AND EMP.VALID = 1
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA = 'es'
INNER JOIN LO_PRECIOS_DIA_ESPECIAL DE ON PRE.ID_PRECIO=DE.ID_PRECIO_DE
AND (DE.ID_TIPO_DE = '4')
AND DE.VALID = 1
WHERE PRE.VALID_PRE=4;
Tiempo de la consulta:
0.0011610984802246Tiempo acumulado:0.07627534866333
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[67]: SELECT count(*) AS num_ofertas
FROM LO_PRECIOS PRE
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
AND EMP.VALID = 1
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA = 'es'
INNER JOIN LO_PRECIOS_DIA_ESPECIAL DE ON PRE.ID_PRECIO=DE.ID_PRECIO_DE
AND (DE.ID_TIPO_DE = '5')
AND DE.VALID = 1
WHERE PRE.VALID_PRE=4;
Tiempo de la consulta:
0.00080990791320801Tiempo acumulado:0.077085256576538
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[68]: SELECT count(*) AS num_ofertas
FROM LO_PRECIOS PRE
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
AND EMP.VALID = 1
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA = 'es'
INNER JOIN LO_PRECIOS_DIA_ESPECIAL DE ON PRE.ID_PRECIO=DE.ID_PRECIO_DE
AND (DE.ID_TIPO_DE = '6')
AND DE.VALID = 1
WHERE PRE.VALID_PRE=4;
Tiempo de la consulta:
0.0033919811248779Tiempo acumulado:0.080477237701416
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[69]: SELECT count(*) AS num_ofertas
FROM LO_PRECIOS PRE
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
AND EMP.VALID = 1
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA = 'es'
INNER JOIN LO_PRECIOS_DIA_ESPECIAL DE ON PRE.ID_PRECIO=DE.ID_PRECIO_DE
AND (DE.ID_TIPO_DE = '9')
AND DE.VALID = 1
WHERE PRE.VALID_PRE=4;
Tiempo de la consulta:
0.00061988830566406Tiempo acumulado:0.08109712600708
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[70]: SELECT TEXTO_SINDEX, TEXTO_SINDEX2
FROM LO_SEO_INDEX
WHERE ID_TROPIC='1'
LIMIT 1;
Tiempo de la consulta:
0.00039911270141602Tiempo acumulado:0.081496238708496
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[71]: SELECT *
FROM LO_VENTAS_STATS
WHERE ID_TROPIC = 1;
Tiempo de la consulta:
0.00085902214050293Tiempo acumulado:0.082355260848999
(Prod_Yumping_es_ES) (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
LO_VENTAS_STATS ST
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '1'
LEFT JOIN LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN LO_POBLACION_ES POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
LEFT JOIN LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'es'
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.006601095199585Tiempo acumulado:0.088956356048584
(Prod_Yumping_es_ES) (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 = 28
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00053310394287109Tiempo acumulado:0.089489459991455
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058102607727051Tiempo acumulado:0.090070486068726
(Prod_Yumping_es_ES) (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_pt_PT.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '81'
LEFT JOIN Prod_Yumping_pt_PT.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_pt_PT.LO_POBLACION_PT POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_pt_PT.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'es'
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.018671035766602Tiempo acumulado:0.10874152183533
(Prod_Yumping_es_ES) (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 = 48
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00044918060302734Tiempo acumulado:0.10919070243835
(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 = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051093101501465Tiempo acumulado:0.10970163345337
(Prod_Yumping_es_ES) (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_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 = '31'
LEFT JOIN Prod_Yumping_it_IT.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_it_IT.LO_POBLACION_IT POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
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 = 'es'
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.017716884613037Tiempo acumulado:0.12741851806641
(Prod_Yumping_es_ES) (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 = 29
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00041317939758301Tiempo acumulado:0.12783169746399
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[80]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053000450134277Tiempo acumulado:0.12836170196533
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[81]: 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_fr_FR.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_fr_FR.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '41'
LEFT JOIN Prod_Yumping_fr_FR.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_fr_FR.LO_POBLACION_FR POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_fr_FR.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'es'
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.015872955322266Tiempo acumulado:0.1442346572876
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[82]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 64
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00041103363037109Tiempo acumulado:0.14464569091797
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[83]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051593780517578Tiempo acumulado:0.14516162872314
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[84]: 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 = '21'
LEFT JOIN Prod_Yumping_co_UK.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_co_UK.LO_POBLACION_GB POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
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 = 'es'
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.014771938323975Tiempo acumulado:0.15993356704712
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[85]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 247
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00044012069702148Tiempo acumulado:0.16037368774414
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[86]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051093101501465Tiempo acumulado:0.16088461875916
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[87]: 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 = '51'
LEFT JOIN Prod_Yumping_mx_MX.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_mx_MX.LO_POBLACION_MX POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
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 = 'es'
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.01355504989624Tiempo acumulado:0.1744396686554
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[88]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 301
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00040102005004883Tiempo acumulado:0.17484068870544
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[89]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 28
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00033020973205566Tiempo acumulado:0.1751708984375
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[90]: SELECT ID_REGION_ADM1
FROM LO_REGION RE
GROUP BY ID_REGION_ADM1
HAVING count(*) > 1;
Tiempo de la consulta:
0.00084114074707031Tiempo acumulado:0.17601203918457
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[91]: 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_es_ES.LO_REGION_STATS RS
INNER JOIN Prod_Yumping_es_ES.LO_REGION RE ON RE.ID_REGION = RS.ID_REGION
AND RE.ID_PAIS = 28
INNER JOIN Prod_Yumping_es_ES.LO_REGION_I18N REI ON REI.ID_REGION = RS.ID_REGION
AND REI.IDIOMA = 'es'
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_es_ES.LO_REGION_ADM1_STATS RAS
INNER JOIN Prod_Yumping_es_ES.LO_REGION RE ON RE.ID_REGION_ADM1 = RAS.ID_REGION_ADM1
AND RE.ID_PAIS = 28
INNER JOIN Prod_Yumping_es_ES.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = RAS.ID_REGION_ADM1
AND REA.IDIOMA = 'es'
WHERE /*RAS.N_OFERTAS >= 15
AND*/ RAS.ID_SECTOR IS NOT NULL
AND RAS.ID_SECTOR != 0
AND REA.ID_REGION_ADM1 in ( 56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,75)
GROUP BY REA.ID_REGION_ADM1
) AS REGIONES
ORDER BY N_OFERTAS DESC
LIMIT 20;
Tiempo de la consulta:
0.041378974914551Tiempo acumulado:0.21739101409912
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[92]: 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='es'
AND PAI.ID_PAIS='28'
ORDER BY DESC_PAIS;
Tiempo de la consulta:
0.0030817985534668Tiempo acumulado:0.22047281265259
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[93]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 1;
Tiempo de la consulta:
0.00084114074707031Tiempo acumulado:0.22131395339966
