Ferias

Tempo	Consulta
0.00088405609130859	SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC
0.001910924911499	SELECT h.id, h.id_item, h.type_item, h.ordering, h.active, h.section FROM scms_highlighted AS h INNER JOIN scms_ferias as sh ON h.id_item=sh.id WHERE h.section="2" AND h.type_item="ferias" AND sh.active="1" AND h.active="1" ORDER BY h.ordering LIMIT 6
0.00051999092102051	SELECT COUNT(*) FROM scms_ferias AS sh LEFT JOIN scms_image AS i ON (sh.image_id=i.id) WHERE sh.active="1"
0.00068497657775879	SELECT sh.id, sh.uname, sh.title, sh.description, sh.country_id, sh.state_id, sh.region_id, sh.city_id, sh.url, sh.active , sh.image_alt, i.filename AS image_filename FROM scms_ferias AS sh LEFT JOIN scms_image AS i ON (sh.image_id=i.id) WHERE sh.active="1" ORDER BY sh.date_ini LIMIT 0, 16
0.00023412704467773	SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC
0.000823974609375	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.00044822692871094	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.00088405609130859

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

0.001910924911499

SELECT h.id, h.id_item, h.type_item, h.ordering, h.active, h.section FROM scms_highlighted AS h INNER JOIN scms_ferias as sh ON h.id_item=sh.id WHERE h.section="2" AND h.type_item="ferias" AND sh.active="1" AND h.active="1" ORDER BY h.ordering LIMIT 6

0.00051999092102051

SELECT COUNT(*) FROM scms_ferias AS sh LEFT JOIN scms_image AS i ON (sh.image_id=i.id) WHERE sh.active="1"

0.00068497657775879

SELECT sh.id, sh.uname, sh.title, sh.description, sh.country_id, sh.state_id, sh.region_id, sh.city_id, sh.url, sh.active , sh.image_alt, i.filename AS image_filename FROM scms_ferias AS sh LEFT JOIN scms_image AS i ON (sh.image_id=i.id) WHERE sh.active="1" ORDER BY sh.date_ini LIMIT 0, 16

0.00023412704467773

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

0.000823974609375

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

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

Feriarte

Madatac

Artist experience.

Estampa

ARCO

PICTORICA en ARCO