DeltaScripts

• Issues
• Login
• Register

• Issues:
• Issue List
• Changelogs
• Roadmaps
• Search

Issues » List

Debug

Query History (16 Queries)

1. SELECT id, category, name, value FROM arctic_config
2. SELECT p.id, p.tag, pt.name AS type_name FROM arctic_permission p JOIN arctic_permission_type pt ON pt.id = p.type_id WHERE p.default_guest = 1
3. SELECT id, manager_id, title, description, private, date_added FROM arctic_project ORDER BY title
4. SELECT id, user_id, built_in, title, options FROM arctic_filter WHERE title = "Closed Issues" AND user_id = 0
5. SELECT id, field_id, model, name, language_category, language_phrase, title, enabled, display_order FROM arctic_issue_column WHERE enabled = 1 ORDER BY display_order
6. SELECT id, user_id, built_in, title, options FROM arctic_filter WHERE user_id = 0
7. SELECT COUNT(i.id) AS count FROM arctic_issue i JOIN arctic_project p ON p.id = i.project_id JOIN arctic_issue_status s ON s.id = i.status_id LEFT JOIN arctic_user uadd ON uadd.id = i.user_id_added LEFT JOIN arctic_user uass ON uass.id = i.user_id_assigned WHERE i.project_id IN (1) AND s.open = 0 AND s.hide = 0
8. SELECT i.id, i.title, i.date_added, i.date_updated, p.id AS project_id, p.title AS project_title, s.title AS status_title, s.prefix AS status_prefix, s.suffix AS status_suffix, s.open AS status_open, tv.number AS version_number, uadd.id AS user_added_id, uadd.username AS user_added_username, uass.id AS user_assigned_id, uass.username AS user_assigned_username FROM arctic_issue i JOIN arctic_project p ON p.id = i.project_id JOIN arctic_issue_status s ON s.id = i.status_id LEFT JOIN arctic_user uadd ON uadd.id = i.user_id_added LEFT JOIN arctic_user uass ON uass.id = i.user_id_assigned LEFT JOIN arctic_project_version tv ON tv.id = i.version_id WHERE ((i.private = 0 AND i.project_id IN (1)) OR (i.private = 1 AND i.project_id IN (0))) AND s.open = 0 AND s.hide = 0 ORDER BY i.id DESC LIMIT 0,10
9. SELECT v.id, v.issue_id, v.field_id, v.value, f.type FROM arctic_custom_field_value v RIGHT JOIN arctic_custom_field f ON v.field_id = f.id AND v.issue_id IN (25, 24, 23, 21, 20, 18, 17, 16, 15, 14)
10. SELECT p.id, p.title FROM arctic_project p JOIN arctic_issue i ON i.project_id = p.id WHERE p.id IN (1) ORDER BY p.title
11. SELECT u.id, u.username FROM arctic_user u JOIN arctic_issue i ON u.id = i.user_id_added ORDER BY u.username
12. SELECT u.id, u.username FROM arctic_user u JOIN arctic_issue i ON u.id = i.user_id_assigned ORDER BY u.username
13. SELECT s.id, s.title, s.open FROM arctic_issue_status s JOIN arctic_issue i ON s.id = i.status_id ORDER BY s.title
14. SELECT DISTINCT s.open FROM arctic_issue_status s JOIN arctic_issue i ON i.status_id = s.id
15. SELECT v.id, v.number, v.project_id FROM arctic_project_version v JOIN arctic_issue i ON v.id = i.version_id WHERE v.project_id IN (1) ORDER BY v.number
16. SELECT id, project_id, type, title, default_value, display_order, options, required, filters FROM arctic_custom_field WHERE type IN ("Checkbox", "Dropdown") AND filters = 1 ORDER BY display_order

Statistics

• Script Execution Time: 0.063 seconds

| 16 Queries Back to DeltaScripts Homepage