Skip to content

Instantly share code, notes, and snippets.

@phillipadsmith
Created July 14, 2014 17:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save phillipadsmith/ffe86ae125bf94910654 to your computer and use it in GitHub Desktop.
Save phillipadsmith/ffe86ae125bf94910654 to your computer and use it in GitHub Desktop.
Bricolage slow query
SELECT s.id, s.uuid, s.priority, s.source__id, s.usr__id, s.element_type__id, s.first_publish_date, s.publish_date, s.expire_date, s.current_version, s.published_version, s.workflow__id, s.publish_status, s.primary_uri, s.active, s.desk__id, s.site__id, s.alias_id, i.id, i.name, i.description, i.story__id, i.version, i.usr__id, i.primary_oc__id, i.slug, i.cover_date, i.note, i.checked_out, group_concat( DISTINCT m.grp__id ), group_concat( DISTINCT c.asset_grp_id ), group_concat( DISTINCT w.asset_grp_id )
FROM story_instance i, story_member sm, member m, story__category sc, category c, workflow w, story s
WHERE s.id = i.story__id AND sm.object_id = s.id AND m.id = sm.member__id AND m.active = '1' AND sc.story_instance__id = i.id AND c.id = sc.category__id AND s.workflow__id = w.id AND s.current_version = i.version AND s.active = $1 AND i.checked_out = $2 AND i.usr__id = $3
GROUP BY s.id, s.uuid, s.priority, s.source__id, s.usr__id, s.element_type__id, s.first_publish_date, s.publish_date, s.expire_date, s.current_version, s.published_version, s.workflow__id, s.publish_status, s.primary_uri, s.active, s.desk__id, s.site__id, s.alias_id, i.id, i.name, i.description, i.story__id, i.version, i.usr__id, i.primary_oc__id, i.slug, i.cover_date, i.note, i.checked_out
ORDER BY i.cover_date, s.id
parameters: $1 = 't', $2 = 't', $3 = '2249'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment