Obra de pictorica.
Tempo total de execución: 0.039061069488525 seg.
| Tempo | Consulta |
|---|---|
| 0.0023069381713867 | SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC |
| 0.0047299861907959 | 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="fellini" LIMIT 1 |
| 0.00083589553833008 | 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="fellini" ORDER BY shi.id |
| 0.0014181137084961 | SELECT estilo FROM scms_obras_estilos WHERE id_obra = 3 |
| 0.0011820793151855 | 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="3" AND pa.type_association="obras" ORDER BY pa.id_product DESC |
| 0.00046706199645996 | 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="3" AND pa.type_product="obras" ORDER BY pa.id_product DESC |
| 0.0018329620361328 | SELECT e.uname, e.title, 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) LEFT JOIN scms_category as c ON c.id=e.category_id WHERE e.active = 1 AND e.id IN (22) |
| 0.00018310546875 | SELECT id, uname, parent_id, element_type, name FROM scms_category AS c WHERE c.element_type="entidades" ORDER BY c.ordenation ASC |
| 0.0017640590667725 | 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.00049686431884766 | 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 |