Inventario de Espuma. Anton Patiño

Tempo	Consulta
0.00014591217041016	SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC
0.0014920234680176	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="inventario-de-espuma-anton-patino" LIMIT 1
0.00039482116699219	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="inventario-de-espuma-anton-patino" ORDER BY shi.id
0.00030899047851562	SELECT estilo FROM scms_obras_estilos WHERE id_obra = 2
0.00033807754516602	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="2" AND pa.type_association="obras" ORDER BY pa.id_product DESC
0.0002138614654541	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="2" AND pa.type_product="obras" ORDER BY pa.id_product DESC
9.3936920166016E-5	SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC
0.00010418891906738	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
7.5101852416992E-5	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.00014591217041016

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

0.0014920234680176

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="inventario-de-espuma-anton-patino" LIMIT 1

0.00039482116699219

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="inventario-de-espuma-anton-patino" ORDER BY shi.id

0.00030899047851562

SELECT estilo FROM scms_obras_estilos WHERE id_obra = 2

0.00033807754516602

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

0.0002138614654541

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

9.3936920166016E-5

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

0.00010418891906738

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

7.5101852416992E-5

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