Any fields left blank or unselected will be excluded from the search query.
| ||||||||||||||||||||||||||||||
| Powered by: Hostspring |
| Message: Debug Information |
|
| Query Debug |
|
SET NAMES utf8
(0)
|
|
SET sql_mode = ''
(0)
|
|
SELECT * FROM bugs_datastore
(0.000105142593384)
|
|
SELECT * FROM bugs_template WHERE filename IN ('doctype', 'header', 'headinclude', 'footer', 'selectoption', 'selectoptgroup', 'std_error', 'std_redirect', 'std_message', 'bugfield_input_text', 'bugfield_input_checkbox', 'bugfield_select_single_option', 'bugfield_select_single', 'username_display', 'help_link', 'search', 'search_results', 'search_update', 'search_save', 'trackerhome_bits', 'list_head', 'pagenav_bit', 'pagenav')
(0.000570058822632)
|
|
SHOW VARIABLES LIKE 'ft_min_word_len'
(0.000171899795532)
|
|
DELETE FROM bugs_search WHERE userid = 0 AND dateline < 1337299029
(0.00777506828308)
|
|
SELECT bugfield.*, MAX(permission.mask) AS mask
FROM bugs_bugfield AS bugfield
LEFT JOIN bugs_bugfieldpermission AS permission
ON (bugfield.fieldid = permission.fieldid)
WHERE (permission.mask = 2 OR permission.mask = 1)
AND permission.usergroupid IN (1)
GROUP BY (bugfield.fieldid)
(0.000477075576782)
|