Frontpage repeated query! - Joomla! Forum - community, help and support
hi, trying optimize joomla queries (even though im beginner) , noticed on front page when turned debug mode on, notice 2 exact queries 1 after other(except 1 small difference mentioned below)
and
and difference last limit line, 1 has it: hmm wondering why is? , if neccessary? can 1 deleted(and where)
also publish 6 articles on frontpage @ time! please help!!
code: select all
select a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.access, case when char_length(a.alias) concat_ws(':', a.id, a.alias) else a.id end slug, case when char_length(cc.alias) concat_ws(":", cc.id, cc.alias) else cc.id end catslug, char_length( a.`fulltext` ) readmore, u.name author, u.usertype, g.name groups, cc.title category, s.title section, s.ordering s_ordering, cc.ordering cc_ordering, a.ordering a_ordering, f.ordering f_ordering
jos2_content a
inner join jos2_content_frontpage f
on f.content_id = a.id
left join jos2_categories cc
on cc.id = a.catid
left join jos2_sections s
on s.id = a.sectionid
left join jos2_users u
on u.id = a.created_by
left join jos2_groups g
on a.access = g.id
1
, a.access <= 2
, a.state >= 0
order by f.ordering
limit 0, 6
and
code: select all
select a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.access, case when char_length(a.alias) concat_ws(':', a.id, a.alias) else a.id end slug, case when char_length(cc.alias) concat_ws(":", cc.id, cc.alias) else cc.id end catslug, char_length( a.`fulltext` ) readmore, u.name author, u.usertype, g.name groups, cc.title category, s.title section, s.ordering s_ordering, cc.ordering cc_ordering, a.ordering a_ordering, f.ordering f_ordering
jos2_content a
inner join jos2_content_frontpage f
on f.content_id = a.id
left join jos2_categories cc
on cc.id = a.catid
left join jos2_sections s
on s.id = a.sectionid
left join jos2_users u
on u.id = a.created_by
left join jos2_groups g
on a.access = g.id
1
, a.access <= 2
, a.state >= 0
order by f.ordering
and difference last limit line, 1 has it:
code: select all
limit 0, 6
also publish 6 articles on frontpage @ time! please help!!
Comments
Post a Comment