videoarte

Tempo	Consulta
0.00018000602722168	SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC
0.00089597702026367	SELECT h.id, h.id_item, h.type_item, h.ordering, h.active, h.section FROM scms_highlighted AS h INNER JOIN scms_entity AS e ON (h.id_item=e.id) WHERE h.section="2" AND h.type_item="entidades" AND e.active="1" AND h.active="1" ORDER BY h.ordering
0.00052499771118164	SELECT COUNT(*) FROM scms_entity AS e LEFT JOIN scms_image AS i ON (e.image_id=i.id) JOIN scms_category as c ON c.id = e.category_id WHERE e.active="1" AND c.name="videoarte"
0.00056600570678711	SELECT e.id, e.uname, e.category_id, e.admin_customer_id, e.admin_user_id, e.plan_id, e.title, e.description, e.category_image_root_id, e.category_document_root_id, e.category_publicidad_root_id, e.allow_external_url, e.active, e.image_alt, i.filename AS image_filename,c.uname as cat_uname FROM scms_entity AS e LEFT JOIN scms_image AS i ON (e.image_id=i.id) JOIN scms_category as c ON c.id = e.category_id WHERE e.active="1" AND c.name="videoarte" ORDER BY e.id DESC LIMIT 0, 16
0.00014805793762207	SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC
0.0001530647277832	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
9.5844268798828E-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.00018000602722168

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

0.00089597702026367

SELECT h.id, h.id_item, h.type_item, h.ordering, h.active, h.section FROM scms_highlighted AS h INNER JOIN scms_entity AS e ON (h.id_item=e.id) WHERE h.section="2" AND h.type_item="entidades" AND e.active="1" AND h.active="1" ORDER BY h.ordering

0.00052499771118164

SELECT COUNT(*) FROM scms_entity AS e LEFT JOIN scms_image AS i ON (e.image_id=i.id) JOIN scms_category as c ON c.id = e.category_id WHERE e.active="1" AND c.name="videoarte"

0.00056600570678711

SELECT e.id, e.uname, e.category_id, e.admin_customer_id, e.admin_user_id, e.plan_id, e.title, e.description, e.category_image_root_id, e.category_document_root_id, e.category_publicidad_root_id, e.allow_external_url, e.active, e.image_alt, i.filename AS image_filename,c.uname as cat_uname FROM scms_entity AS e LEFT JOIN scms_image AS i ON (e.image_id=i.id) JOIN scms_category as c ON c.id = e.category_id WHERE e.active="1" AND c.name="videoarte" ORDER BY e.id DESC LIMIT 0, 16

0.00014805793762207

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

0.0001530647277832

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

9.5844268798828E-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

Alejandra Delgado