Tempo total de execución: 0.0094730854034424 seg.
Tempo | Consulta |
0.0007479190826416 | SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC |
0.0011839866638184 | SELECT e.id, e.uname, e.category_id, e.admin_customer_id, e.admin_user_id, e.title, e.description,
i.filename, e.image_alt, e.logo, e.uname, e.url, c.name, c.uname, e.category_image_root_id, e.category_document_root_id, e.category_publicidad_root_id,
e.allow_external_url, e.active FROM scms_entity AS e LEFT JOIN scms_image AS i ON (e.image_id=i.id)
LEFT JOIN scms_category as c ON c.id=e.category_id WHERE e.uname="montenegro" LIMIT 1 |
0.0006558895111084 | 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="16" AND pa.type_association="entidades" ORDER BY pa.id_product DESC |
0.00032401084899902 | 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="16" AND pa.type_product="entidades" ORDER BY pa.id_product DESC |
0.00016403198242188 | SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC |
0.00081300735473633 | 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.00051498413085938 | 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 |