El Gran. Dali

Obra de Dalí.

La Fundación Gala Salvador Dalí gestiona varias colecciones de obras de Salvador Dalí, un conjunto único en cantidad, amplitud y profundidad. La forman miles de objetos de todos los períodos de la vida de Dalí y más de 4.000 obras.El verdadero pintor es aquel que es capaz de pintar escenas extraordinarias en medio de un desierto vacío. El verdadero pintor es aquel que es capaz de pintar pacientemente una pera rodeado de los tumultos de la historia

Tempo	Consulta
0.00018596649169922	SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC
0.0012121200561523	SELECT sh.id, sh.uname, sh.category_id, sh.title, sh.description, sh.url, sh.active, i.filename, sh.image_alt, date_ini, date_fin, co.name as country_name, s.name as state_name, r.name as region_name, ci.name as city_name, au.title as author_name, au.uname as author_uname FROM scms_obras AS sh LEFT JOIN scms_author AS au ON (sh.author_id=au.id) LEFT JOIN scms_image AS i ON (sh.image_id=i.id) LEFT JOIN scms_country AS co ON (sh.country_id=co.id) LEFT JOIN scms_state AS s ON (sh.state_id=s.id) LEFT JOIN scms_region AS r ON (sh.region_id=r.id) LEFT JOIN scms_city AS ci ON (sh.city_id=ci.id) WHERE sh.uname="el-gran-dali" LIMIT 1
0.00032901763916016	SELECT shi.id, shi.image_id, i.filename, shi.image_alt FROM scms_obras_images AS shi JOIN scms_image AS i ON (shi.image_id=i.id) INNER JOIN scms_obras as sh ON sh.id = shi.obras_id WHERE sh.uname="el-gran-dali" ORDER BY shi.id
0.00049209594726562	SELECT estilo FROM scms_obras_estilos WHERE id_obra = 5
0.00057387351989746	SELECT pa.id_product, pa.id_association, pa.type_product, pa.type_association, pa.id_customer FROM scms_product_association AS pa WHERE pa.id_association="5" AND pa.type_association="obras" ORDER BY pa.id_product DESC
0.00038599967956543	SELECT pa.id_product, pa.id_association, pa.type_product, pa.type_association, pa.id_customer FROM scms_product_association AS pa WHERE pa.id_product="5" AND pa.type_product="obras" ORDER BY pa.id_product DESC
0.00019001960754395	SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC
0.00017809867858887	SELECT s.id, s.image_id, s.category_id, s.url, s.ordering, s.active, sl.image_alt, sl.title_html, i.filename FROM scms_publicidad AS s JOIN scms_publicidad_lang AS sl ON (s.id=sl.publicidad_id) LEFT JOIN scms_image AS i ON (s.image_id=i.id) WHERE sl.lang_id="es" AND s.category_id="1" AND s.active="1" ORDER BY s.ordering ASC, s.id DESC
0.00011205673217773	SELECT s.id, s.image_id, s.category_id, s.url, s.ordering, s.active, sl.image_alt, sl.title_html, i.filename FROM scms_publicidad AS s JOIN scms_publicidad_lang AS sl ON (s.id=sl.publicidad_id) LEFT JOIN scms_image AS i ON (s.image_id=i.id) WHERE sl.lang_id="es" AND s.category_id="2" AND s.active="1" ORDER BY s.ordering ASC, s.id DESC

Tempo

Consulta

0.00018596649169922

SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC

0.0012121200561523

SELECT sh.id, sh.uname, sh.category_id, sh.title, sh.description, sh.url, sh.active, i.filename, sh.image_alt, date_ini, date_fin, co.name as country_name, s.name as state_name, r.name as region_name, ci.name as city_name, au.title as author_name, au.uname as author_uname FROM scms_obras AS sh LEFT JOIN scms_author AS au ON (sh.author_id=au.id) LEFT JOIN scms_image AS i ON (sh.image_id=i.id) LEFT JOIN scms_country AS co ON (sh.country_id=co.id) LEFT JOIN scms_state AS s ON (sh.state_id=s.id) LEFT JOIN scms_region AS r ON (sh.region_id=r.id) LEFT JOIN scms_city AS ci ON (sh.city_id=ci.id) WHERE sh.uname="el-gran-dali" LIMIT 1

0.00032901763916016

SELECT shi.id, shi.image_id, i.filename, shi.image_alt FROM scms_obras_images AS shi JOIN scms_image AS i ON (shi.image_id=i.id) INNER JOIN scms_obras as sh ON sh.id = shi.obras_id WHERE sh.uname="el-gran-dali" ORDER BY shi.id

0.00049209594726562

SELECT estilo FROM scms_obras_estilos WHERE id_obra = 5

0.00057387351989746

SELECT pa.id_product, pa.id_association, pa.type_product, pa.type_association, pa.id_customer FROM scms_product_association AS pa WHERE pa.id_association="5" AND pa.type_association="obras" ORDER BY pa.id_product DESC

0.00038599967956543

SELECT pa.id_product, pa.id_association, pa.type_product, pa.type_association, pa.id_customer FROM scms_product_association AS pa WHERE pa.id_product="5" AND pa.type_product="obras" ORDER BY pa.id_product DESC

0.00019001960754395

SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC

0.00017809867858887

SELECT s.id, s.image_id, s.category_id, s.url, s.ordering, s.active, sl.image_alt, sl.title_html, i.filename FROM scms_publicidad AS s JOIN scms_publicidad_lang AS sl ON (s.id=sl.publicidad_id) LEFT JOIN scms_image AS i ON (s.image_id=i.id) WHERE sl.lang_id="es" AND s.category_id="1" AND s.active="1" ORDER BY s.ordering ASC, s.id DESC

0.00011205673217773

SELECT s.id, s.image_id, s.category_id, s.url, s.ordering, s.active, sl.image_alt, sl.title_html, i.filename FROM scms_publicidad AS s JOIN scms_publicidad_lang AS sl ON (s.id=sl.publicidad_id) LEFT JOIN scms_image AS i ON (s.image_id=i.id) WHERE sl.lang_id="es" AND s.category_id="2" AND s.active="1" ORDER BY s.ordering ASC, s.id DESC