Any ideas why this query is called 9 times?

[John Cox]

I got started working on the themes and profiler today (don't laugh at
how bad it is;) and for a proof of concept I started dumping the query
log. Any idea where this query might be generated? It's called 9
times, and it's looking for the themes module....


[19] => Array
(
[event_time] => 2010-06-20 18:09:11
[query] => SELECT mods.xar_regid, mods.xar_directory,
mods.xar_mode, mods.xar_id, modstates.xar_state, mods.xar_name FROM
sf_modules mods LEFT JOIN sf_module_states modstates ON
modstates.xar_regid = mods.xar_regid WHERE mods.xar_name = 'themes' OR
mods.xar_directory = 'themes'
)

[20] => Array
(
[event_time] => 2010-06-20 18:09:11
[query] => SELECT mods.xar_regid, mods.xar_directory,
mods.xar_mode, mods.xar_id, modstates.xar_state, mods.xar_name FROM
sf_modules mods LEFT JOIN sf_module_states modstates ON
modstates.xar_regid = mods.xar_regid WHERE mods.xar_name = 'themes' OR
mods.xar_directory = 'themes'
)

[21] => Array
(
[event_time] => 2010-06-20 18:09:11
[query] => SELECT mods.xar_regid, mods.xar_directory,
mods.xar_mode, mods.xar_id, modstates.xar_state, mods.xar_name FROM
sf_modules mods LEFT JOIN sf_module_states modstates ON
modstates.xar_regid = mods.xar_regid WHERE mods.xar_name = 'themes' OR
mods.xar_directory = 'themes'
)

[22] => Array
(
[event_time] => 2010-06-20 18:09:11
[query] => SELECT mods.xar_regid, mods.xar_directory,
mods.xar_mode, mods.xar_id, modstates.xar_state, mods.xar_name FROM
sf_modules mods LEFT JOIN sf_module_states modstates ON
modstates.xar_regid = mods.xar_regid WHERE mods.xar_name = 'themes' OR
mods.xar_directory = 'themes'
)

[23] => Array
(
[event_time] => 2010-06-20 18:09:11
[query] => SELECT mods.xar_regid, mods.xar_directory,
mods.xar_mode, mods.xar_id, modstates.xar_state, mods.xar_name FROM
sf_modules mods LEFT JOIN sf_module_states modstates ON
modstates.xar_regid = mods.xar_regid WHERE mods.xar_name = 'themes' OR
mods.xar_directory = 'themes'
)

[24] => Array
(
[event_time] => 2010-06-20 18:09:11
[query] => SELECT mods.xar_regid, mods.xar_directory,
mods.xar_mode, mods.xar_id, modstates.xar_state, mods.xar_name FROM
sf_modules mods LEFT JOIN sf_module_states modstates ON
modstates.xar_regid = mods.xar_regid WHERE mods.xar_name = 'themes' OR
mods.xar_directory = 'themes'
)

[25] => Array
(
[event_time] => 2010-06-20 18:09:11
[query] => SELECT mods.xar_regid, mods.xar_directory,
mods.xar_mode, mods.xar_id, modstates.xar_state, mods.xar_name FROM
sf_modules mods LEFT JOIN sf_module_states modstates ON
modstates.xar_regid = mods.xar_regid WHERE mods.xar_name = 'themes' OR
mods.xar_directory = 'themes'
)

[26] => Array
(
[event_time] => 2010-06-20 18:09:11
[query] => SELECT mods.xar_regid, mods.xar_directory,
mods.xar_mode, mods.xar_id, modstates.xar_state, mods.xar_name FROM
sf_modules mods LEFT JOIN sf_module_states modstates ON
modstates.xar_regid = mods.xar_regid WHERE mods.xar_name = 'themes' OR
mods.xar_directory = 'themes'
)

[27] => Array
(
[event_time] => 2010-06-20 18:09:11
[query] => SELECT mods.xar_regid, mods.xar_directory,
mods.xar_mode, mods.xar_id, modstates.xar_state, mods.xar_name FROM
sf_modules mods LEFT JOIN sf_module_states modstates ON
modstates.xar_regid = mods.xar_regid WHERE mods.xar_name = 'themes' OR
mods.xar_directory = 'themes'
)

[John Cox]

Nevermind, stray modvars running around.  I got most of them,

[jojodee]

On 21 June 2010 08:11, John Cox <john.cox.ky@gmail.com> wrote:

I got started working on the themes and profiler today (don't laugh at
how bad it is;) and for a proof of concept I started dumping the query
log.  Any idea where this query might be generated?  It's called 9
times, and it's looking for the themes module....

 

Sorry for the delay on response. Have been travelling. In one place now for a few days and have an internet connection so should be around a little more.

Regarding this query, I see you found it. It also reminded me that we should rip out all the site/system code as well as I doubt it will be used and is in any case not scaleable. What do you think?