ANDI WARHOL - Geoarte

Tempo	Consulta
0.0026528835296631	SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC
0.011816024780273	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="andi-warhol" LIMIT 1
0.0021309852600098	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="andi-warhol" ORDER BY shi.id
0.0016169548034668	SELECT estilo FROM scms_obras_estilos WHERE id_obra = 4
0.001633882522583	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="4" AND pa.type_association="obras" ORDER BY pa.id_product DESC
0.00036501884460449	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="4" AND pa.type_product="obras" ORDER BY pa.id_product DESC
0.00013399124145508	SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC
0.0032038688659668	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.00055599212646484	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.0026528835296631

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

0.011816024780273

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="andi-warhol" LIMIT 1

0.0021309852600098

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="andi-warhol" ORDER BY shi.id

0.0016169548034668

SELECT estilo FROM scms_obras_estilos WHERE id_obra = 4

0.001633882522583

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="4" AND pa.type_association="obras" ORDER BY pa.id_product DESC

0.00036501884460449

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="4" AND pa.type_product="obras" ORDER BY pa.id_product DESC

0.00013399124145508

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

0.0032038688659668

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.00055599212646484

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