Hi,
How does indexing influence speed of epesi? I manualy inserted about 45000 of companies
1. as I dont remember did I manualy inserted value 1 to index column - does it have influence on speed of epesi?
2. Also I inserted ~ 96000 contacts, as I see indexing is runing in background and after 2-3 days only ~ 12000 is indexed at this moment and still indexing
3. And also inserted ~ 280 000 of phonecalls, as epesi started to run very slowly, I decided to reduce phonecalls and deleted from DB (via mysql commands) - I think it had some efect but this is not the option as number of phonecalls, companies and users will be definetely growing up.
So we have tested with the same amount of records on 3 diferent servers (already had read posts about fact cgi, APC, memchache - on two machines they are enabled) but it didint made big diference.
As an example presing on phonecals module with 283 000 records the results are:
====================================================================
Time of loading module /Base_Box|0: 9.3547
Time of loading module /Base_Box|0/Base_Theme|0: 0.0001
Time of loading module /Base_Box|0/CRM_PhoneCall|main_0: 9.3018
Time of loading module /Base_Box|0/CRM_PhoneCall|main_0/Utils_RecordBrowser|phonecall: 9.2972
Time of loading module /Base_Box|0/CRM_PhoneCall|main_0/Utils_RecordBrowser|phonecall/Base_Theme|0: 0.0003
Time of loading module /Base_Box|0/CRM_PhoneCall|main_0/Utils_RecordBrowser|phonecall/Utils_GenericBrowser|phonecall: 0.0275
Time of loading module /Base_Box|0/Base_User_Login|login/Base_Theme|0: 0.0000
Time of loading module /Base_Box|0/Base_User_Login|login: 0.0009
Time of loading module /Base_Box|0/Base_Menu|menu: 0.0131
Time of loading module /Base_Box|0/Base_Menu|menu/Utils_Menu|0: 0.0004
Time of loading module /Base_Box|0/Base_Menu|quick_access_menu: 0.0043
Time of loading module /Base_Box|0/Base_Search|search: 0.0028
Time of loading module /Base_Box|0/Base_Search|search/Base_Theme|0: 0.0000
Time of loading module /Base_Box|0/Base_StatusBar|status: 0.0005
Time of loading module /Base_Box|0/Base_ActionBar|actionbar: 0.0028
Time of loading module /Base_Box|0/Base_ActionBar|actionbar/Base_Theme|0: 0.0000
Time of loading module /Base_Box|0/Base_ActionBar|launchpad: 0.0023
Time of loading module /Base_Box|0/Base_ActionBar|launchpad/Base_Theme|0: 0.0000
Time of loading module /Base_Box|0/Base_ActionBar|launchpad/Base_Theme|1: 0.0000
Time of loading module /Base_Box|0/Base_MainModuleIndicator|moduleindicator: 0.0007
Time of loading module /Base_Box|0/Base_MainModuleIndicator|moduleindicator/Base_Theme|0: 0.0000
Time of loading module /Base_Box|0/CRM_Filters|filter: 0.0084
Time of loading module /Base_Box|0/Base_Help|help: 0.0005
Time of loading module /Base_Box|0/Base_MainModuleIndicator|logo: 0.0006
Time of loading module /Base_Box|0/Base_MainModuleIndicator|logo/Base_Theme|0: 0.0002
Page renderered in 9.4289162158966s
QUERIES
GetOne array ( 0 => 'SELECT GET_LOCK(?,?)', 1 => array ( 0 => '9ped06ka57mbkl8741jd70ucd6', 1 => 30, ), ) 0.0003
GetOne array ( 0 => 'SELECT data FROM session WHERE name = ? AND expires > ?', 1 => array ( 0 => '9ped06ka57mbkl8741jd70ucd6', 1 => 1421345661, ), ) 0.0005
GetAssoc array ( 0 => 'SELECT name,value FROM variables', 1 => array ( ), ) 0.0004
Execute array ( 0 => 'SELECT name,version,priority FROM modules ORDER BY priority', 1 => array ( ), ) 0.0002
Execute array ( 0 => 'SELECT variable, value, module FROM base_user_settings WHERE user_login_id=?', 1 => array ( 0 => 7, ), ) 0.0002
Execute array ( 0 => 'SELECT module,variable,value FROM base_user_settings_admin_defaults', 1 => array ( ), ) 0.0002
GetAll array ( 0 => 'SELECT tab FROM recordbrowser_table_properties', 1 => array ( ), ) 0.0005
Execute array ( 0 => 'SELECT * FROM contact_callback WHERE freezed=1', 1 => array ( ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM contact_field WHERE active=1 AND type!=\'page_split\' ORDER BY position', 1 => array ( ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM contact_data_1 WHERE active=1 AND f_login=?', 1 => array ( 0 => '7', ), ) 0.0002
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 12, ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM utils_commondata_tree WHERE parent_id=? AND akey=?', 1 => array ( 0 => -1, 1 => 'CRM', ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM utils_commondata_tree WHERE parent_id=? AND akey=?', 1 => array ( 0 => 630, 1 => 'Status', ), ) 0.0002
GetAssoc array ( 0 => 'SELECT akey, value FROM utils_commondata_tree WHERE parent_id=? ORDER BY akey ASC', 1 => array ( 0 => 639, ), ) 0.0002
GetRow array ( 0 => 'SELECT caption, icon, recent, favorites, full_history FROM recordbrowser_table_properties WHERE tab=?', 1 => array ( 0 => 'phonecall', ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '9f121d1bcc2b246d18ba60b3390f8f4e', ), ) 0.0003
GetOne array ( 0 => 'SELECT pattern FROM recordbrowser_clipboard_pattern WHERE tab=? AND enabled=1', 1 => array ( 0 => 'phonecall', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM phonecall_callback WHERE freezed=1', 1 => array ( ), ) 0.0001
Execute array ( 0 => 'SELECT * FROM phonecall_field WHERE active=1 AND type!=\'page_split\' ORDER BY position', 1 => array ( ), ) 0.0005
Execute array ( 0 => 'SELECT * FROM phonecall_callback', 1 => array ( ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM base_acl_clearance', 1 => array ( ), ) 0.0001
GetRow array ( 0 => 'SELECT * FROM user_login WHERE id=?', 1 => array ( 0 => 7, ), ) 0.0002
GetRow array ( 0 => 'SELECT * FROM user_login WHERE id=?', 1 => array ( 0 => 7, ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM utils_commondata_tree WHERE parent_id=? AND akey=?', 1 => array ( 0 => -1, 1 => 'Contacts', ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM utils_commondata_tree WHERE parent_id=? AND akey=?', 1 => array ( 0 => 654, 1 => 'Access', ), ) 0.0002
GetAssoc array ( 0 => 'SELECT akey, value FROM utils_commondata_tree WHERE parent_id=? ORDER BY akey ASC', 1 => array ( 0 => 655, ), ) 0.0003
Execute array ( 0 => 'SELECT * FROM phonecall_access AS acs WHERE NOT EXISTS (SELECT * FROM phonecall_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM phonecall_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT id FROM base_acl_permission WHERE name=?', 1 => array ( 0 => 'Watchdog - subscribe to categories', ), ) 0.0005
GetOne array ( 0 => 'SELECT id FROM base_acl_rules AS rule WHERE permission_id=? AND NOT EXISTS (SELECT * FROM base_acl_rules_clearance WHERE rule_id=rule.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 4, 1 => 'ALL', 2 => 'ADMIN', 3 => 'SUPERADMIN', 4 => 'ACCESS:employee', 5 => 'ACCESS:manager', ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '9f121d1bcc2b246d18ba60b3390f8f4e', ), ) 0.0002
GetOne array ( 0 => 'SELECT 1 FROM utils_watchdog_category_subscription WHERE user_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 4, ), ) 0.0003
GetRow array ( 0 => 'SELECT caption, icon, recent, favorites, full_history FROM recordbrowser_table_properties WHERE tab=?', 1 => array ( 0 => 'phonecall', ), ) 0.0002
GetOne array ( 0 => 'SELECT pattern FROM recordbrowser_clipboard_pattern WHERE tab=? AND enabled=1', 1 => array ( 0 => 'phonecall', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM phonecall_callback', 1 => array ( ), ) 0.0001
Execute array ( 0 => 'SELECT * FROM contact_access AS acs WHERE NOT EXISTS (SELECT * FROM contact_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM contact_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_company_name = \'4\' AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_related_companies LIKE CONCAT(\'%\',\'\\\\_\\\\_4\\\\_\\\\_\',\'%\') AND r.f_related_companies IS NOT NULL))) AND (((NOT (false OR (r.f_permission = \'2\' AND r.f_permission IS NOT NULL)) OR created_by = 7)) OR ((false OR (r.f_login = \'7\' AND r.f_login IS NOT NULL))))', 1 => array ( ), ) 0.0002
SelectLimit array ( 0 => 'SELECT id,active,created_by,created_on,f_last_name,f_first_name FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_company_name = \'4\' AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_related_companies LIKE CONCAT(\'%\',\'\\\\_\\\\_4\\\\_\\\\_\',\'%\') AND r.f_related_companies IS NOT NULL))) AND (((NOT (false OR (r.f_permission = \'2\' AND r.f_permission IS NOT NULL)) OR created_by = 7)) OR ((false OR (r.f_login = \'7\' AND r.f_login IS NOT NULL))))', 1 => -1, 2 => 0, 3 => array ( ), ) 0.0004
Execute array ( 0 => 'SELECT * FROM recordbrowser_browse_mode_definitions WHERE tab=?', 1 => array ( 0 => 'phonecall', ), ) 0.0002
Execute array ( 0 => 'SELECT tab, caption, icon, recent, favorites, full_history FROM recordbrowser_table_properties', 1 => array ( ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM utils_attachment_access AS acs WHERE NOT EXISTS (SELECT * FROM utils_attachment_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0004
Execute array ( 0 => 'SELECT * FROM utils_attachment_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '94549d917270ceab3f011449bdd5fd1b', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM company_access AS acs WHERE NOT EXISTS (SELECT * FROM company_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0005
Execute array ( 0 => 'SELECT * FROM company_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '93c731f1c3a84ef05cd54d044c379eaa', ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '2f8a6bf31f3bd67bd2d9720c58b19c9a', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM rc_accounts_access AS acs WHERE NOT EXISTS (SELECT * FROM rc_accounts_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM rc_accounts_access_fields', 1 => array ( ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '03c19e6b2546fb9687a3415b8df0dddd', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM rc_mail_threads_access AS acs WHERE NOT EXISTS (SELECT * FROM rc_mail_threads_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM rc_mail_threads_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => 'da61ed5621a644448aaec2e8df28d83e', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM rc_mails_access AS acs WHERE NOT EXISTS (SELECT * FROM rc_mails_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM rc_mails_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '93e992447d79460cdbe8077a3f6c776e', ), ) 0.0003
Execute array ( 0 => 'SELECT * FROM rc_mails_assoc_access AS acs WHERE NOT EXISTS (SELECT * FROM rc_mails_assoc_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM rc_mails_assoc_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '07840f53e0b7a257f30dca02277668dc', ), ) 0.0003
Execute array ( 0 => 'SELECT * FROM rc_multiple_emails_access AS acs WHERE NOT EXISTS (SELECT * FROM rc_multiple_emails_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0003
Execute array ( 0 => 'SELECT * FROM rc_multiple_emails_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '4b69f6fbd83cadec6bb5e8fa02ede2e6', ), ) 0.0003
Execute array ( 0 => 'SELECT * FROM task_access AS acs WHERE NOT EXISTS (SELECT * FROM task_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM task_access_fields', 1 => array ( ), ) 0.0004
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '478f3a4c51824ad23cb50c1c60670c0f', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM crm_meeting_access AS acs WHERE NOT EXISTS (SELECT * FROM crm_meeting_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM crm_meeting_access_fields', 1 => array ( ), ) 0.0004
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => 'ac7305f48d3761a1209f762996de7ad5', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM test_access AS acs WHERE NOT EXISTS (SELECT * FROM test_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0003
Execute array ( 0 => 'SELECT * FROM test_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '098f6bcd4621d373cade4e832627b4f6', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM crm_assets_access AS acs WHERE NOT EXISTS (SELECT * FROM crm_assets_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM crm_assets_access_fields', 1 => array ( ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => 'fe76cf931ee133da44ecf7bfd52610f1', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM premium_listmanager_access AS acs WHERE NOT EXISTS (SELECT * FROM premium_listmanager_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0003
Execute array ( 0 => 'SELECT * FROM premium_listmanager_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '44748f02ad72641c3855b128221ca187', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM premium_listmanager_element_access AS acs WHERE NOT EXISTS (SELECT * FROM premium_listmanager_element_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0004
Execute array ( 0 => 'SELECT * FROM premium_listmanager_element_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '98020293310ebca6a7b372bd2cc64c21', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM premium_listmanager_history_access AS acs WHERE NOT EXISTS (SELECT * FROM premium_listmanager_history_access_clearance WHERE rule_id=acs.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 'ALL', 1 => 'ADMIN', 2 => 'SUPERADMIN', 3 => 'ACCESS:employee', 4 => 'ACCESS:manager', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM premium_listmanager_history_access_fields', 1 => array ( ), ) 0.0001
GetOne array ( 0 => 'SELECT id FROM utils_watchdog_category WHERE name=?', 1 => array ( 0 => '90a29f6d6a9522671da1f8c38673f857', ), ) 0.0002
GetRow array ( 0 => 'SELECT caption, icon, recent, favorites, full_history FROM recordbrowser_table_properties WHERE tab=?', 1 => array ( 0 => 'phonecall', ), ) 0.0003
GetOne array ( 0 => 'SELECT pattern FROM recordbrowser_clipboard_pattern WHERE tab=? AND enabled=1', 1 => array ( 0 => 'phonecall', ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM phonecall_callback', 1 => array ( ), ) 0.0002
GetOne array ( 0 => 'SELECT quickjump FROM recordbrowser_table_properties WHERE tab=?', 1 => array ( 0 => 'phonecall', ), ) 0.0002
GetOne array ( 0 => 'SELECT COUNT(*) FROM phonecall_data_1 AS r WHERE active=1 AND (NOT (false OR (r.f_permission = \'2\' AND r.f_permission IS NOT NULL)) OR (false OR (r.f_employees LIKE CONCAT(\'%\',\'\\\\_\\\\_12\\\\_\\\\_\',\'%\') AND r.f_employees IS NOT NULL)))', 1 => array ( ), ) 0.0002
[color=#BF0000:j45ga0ps]SelectLimit array ( 0 => 'SELECT * FROM phonecall_data_1 AS r WHERE active=1 AND (NOT (false OR (r.f_permission = \'2\' AND r.f_permission IS NOT NULL)) OR (false OR (r.f_employees LIKE CONCAT(\'%\',\'\\\\_\\\\_12\\\\_\\\\_\',\'%\') AND r.f_employees IS NOT NULL))) ORDER BY f_status ASC, f_date_and_time ASC, f_subject ASC', 1 => '20', 2 => 20, 3 => array ( ), ) 8.8270[/color:j45ga0ps]
Execute array ( 0 => 'SELECT * FROM recordbrowser_processing_methods WHERE tab=?', 1 => array ( 0 => 'phonecall', ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 177, 2 => 4, ), ) 0.0484
GetAll array ( 0 => 'SELECT * FROM utils_bbcode', 1 => array ( ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3895, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3895, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3895, ), ) 0.0003
Execute array ( 0 => 'SELECT * FROM company_callback WHERE freezed=1', 1 => array ( ), ) 0.0002
Execute array ( 0 => 'SELECT * FROM company_field WHERE active=1 AND type!=\'page_split\' ORDER BY position', 1 => array ( ), ) 0.0002
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10029, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10029, ), ) 0.0005
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10029, ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM utils_commondata_tree WHERE parent_id=? AND akey=?', 1 => array ( 0 => 630, 1 => 'Access', ), ) 0.0002
GetAssoc array ( 0 => 'SELECT akey, value FROM utils_commondata_tree WHERE parent_id=? ORDER BY value ASC', 1 => array ( 0 => 635, ), ) 0.0002
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetAssoc array ( 0 => 'SELECT akey, value FROM utils_commondata_tree WHERE parent_id=? ORDER BY value ASC', 1 => array ( 0 => 639, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 177, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 177, ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM contact_data_1 WHERE active=1 AND f_login=?', 1 => array ( 0 => '3', ), ) 0.0002
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 137, 2 => 4, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1061, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1061, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1061, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6066, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6066, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6066, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 5, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 5, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 5, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 137, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 137, ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM contact_data_1 WHERE active=1 AND f_login=?', 1 => array ( 0 => '4', ), ) 0.0002
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 5, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 5, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 190, 2 => 4, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1534, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1534, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1534, ), ) 0.0004
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6541, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6541, ), ) 0.0005
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6541, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 5, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 5, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 190, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 190, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 133, 2 => 4, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6004, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6004, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6004, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9135, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9135, ), ) 0.0005
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9135, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 133, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 133, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 103, 2 => 4, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1859, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1859, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1859, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6876, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6876, ), ) 0.0005
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6876, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 5, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 5, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 103, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 103, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 202, 2 => 4, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 679, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 679, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 679, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 7676, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 7676, ), ) 0.0006
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 7676, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 5, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 5, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 202, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 202, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 241, 2 => 4, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6035, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6035, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6035, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10037, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10037, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10037, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 241, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 241, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 242, 2 => 4, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 2720, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 2720, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 2720, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 8789, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 8789, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 8789, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 242, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 242, ), ) 0.0003
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 267, 2 => 4, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3056, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3056, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3056, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9143, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9143, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9143, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 267, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 267, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 277, 2 => 4, ), ) 0.0007
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6043, ), ) 0.0007
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6043, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6043, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 8793, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 8793, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 8793, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 277, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 277, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 280, 2 => 4, ), ) 0.0008
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6044, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6044, ), ) 0.0005
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6044, ), ) 0.0004
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10043, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10043, ), ) 0.0007
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10043, ), ) 0.0006
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 280, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 280, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 286, 2 => 4, ), ) 0.0010
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3913, ), ) 0.0006
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3913, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3913, ), ) 0.0009
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10047, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10047, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10047, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 286, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 286, ), ) 0.0004
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 292, 2 => 4, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1331, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1331, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 1331, ), ) 0.0005
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6337, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6337, ), ) 0.0006
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 6337, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0005
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 292, ), ) 0.0006
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 292, ), ) 0.0004
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 293, 2 => 4, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6048, ), ) 0.0008
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6048, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6048, ), ) 0.0004
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10049, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10049, ), ) 0.0005
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10049, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 293, ), ) 0.0007
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 293, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 222, 2 => 4, ), ) 0.0002
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10584, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10584, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10584, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3, ), ) 0.0002
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 222, ), ) 0.0004
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 222, ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM contact_data_1 WHERE active=1 AND f_login=?', 1 => array ( 0 => '2', ), ) 0.0002
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 272, 2 => 4, ), ) 0.0006
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 2452, ), ) 0.0007
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 2452, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 2452, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 8501, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 8501, ), ) 0.0007
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 8501, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 272, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 272, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 273, 2 => 4, ), ) 0.0007
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3907, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3907, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3907, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10041, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10041, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10041, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 273, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 273, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 294, 2 => 4, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6049, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6049, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6049, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9383, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9383, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9383, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 294, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 294, ), ) 0.0003
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 299, 2 => 4, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6050, ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6050, ), ) 0.0002
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 6050, ), ) 0.0003
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9483, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9483, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 9483, ), ) 0.0006
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0002
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 299, ), ) 0.0003
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 299, ), ) 0.0002
GetOne array ( 0 => 'SELECT last_seen_event FROM utils_watchdog_subscription WHERE user_id=? AND internal_id=? AND category_id=?', 1 => array ( 0 => 7, 1 => 284, 2 => 4, ), ) 0.0007
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3911, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3911, ), ) 0.0004
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 3911, ), ) 0.0006
GetRow array ( 0 => 'SELECT f_company_name FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10045, ), ) 0.0003
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10045, ), ) 0.0006
GetOne array ( 0 => 'SELECT active FROM company_data_1 WHERE id=?', 1 => array ( 0 => 10045, ), ) 0.0005
GetRow array ( 0 => 'SELECT * FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetOne array ( 0 => 'SELECT active FROM contact_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0003
GetRow array ( 0 => 'SELECT created_on, created_by FROM phonecall_data_1 WHERE id=?', 1 => array ( 0 => 284, ), ) 0.0005
GetRow array ( 0 => 'SELECT edited_on, edited_by FROM phonecall_edit_history WHERE phonecall_id=? ORDER BY edited_on DESC', 1 => array ( 0 => 284, ), ) 0.0002
GetOne array ( 0 => 'SELECT jump_to_id FROM recordbrowser_table_properties WHERE tab=?', 1 => array ( 0 => 'phonecall', ), ) 0.0002
GetOne array ( 0 => 'SELECT login FROM user_login WHERE id=?', 1 => array ( 0 => 7, ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM base_acl_permission WHERE name=?', 1 => array ( 0 => 'Advanced User Settings', ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM base_acl_rules AS rule WHERE permission_id=? AND NOT EXISTS (SELECT * FROM base_acl_rules_clearance WHERE rule_id=rule.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 1, 1 => 'ALL', 2 => 'ADMIN', 3 => 'SUPERADMIN', 4 => 'ACCESS:employee', 5 => 'ACCESS:manager', ), ) 0.0005
GetOne array ( 0 => 'SELECT id FROM base_acl_permission WHERE name=?', 1 => array ( 0 => 'Search', ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM base_acl_rules AS rule WHERE permission_id=? AND NOT EXISTS (SELECT * FROM base_acl_rules_clearance WHERE rule_id=rule.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 3, 1 => 'ALL', 2 => 'ADMIN', 3 => 'SUPERADMIN', 4 => 'ACCESS:employee', 5 => 'ACCESS:manager', ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM base_acl_permission WHERE name=?', 1 => array ( 0 => 'Dashboard', ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM base_acl_rules AS rule WHERE permission_id=? AND NOT EXISTS (SELECT * FROM base_acl_rules_clearance WHERE rule_id=rule.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 2, 1 => 'ALL', 2 => 'ADMIN', 3 => 'SUPERADMIN', 4 => 'ACCESS:employee', 5 => 'ACCESS:manager', ), ) 0.0002
GetAssoc array ( 0 => 'SELECT menu, tab FROM recordbrowser_custom_recordsets WHERE active=1', 1 => array ( ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM base_acl_permission WHERE name=?', 1 => array ( 0 => 'Messenger Alerts', ), ) 0.0004
GetOne array ( 0 => 'SELECT id FROM base_acl_rules AS rule WHERE permission_id=? AND NOT EXISTS (SELECT * FROM base_acl_rules_clearance WHERE rule_id=rule.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 7, 1 => 'ALL', 2 => 'ADMIN', 3 => 'SUPERADMIN', 4 => 'ACCESS:employee', 5 => 'ACCESS:manager', ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM base_acl_permission WHERE name=?', 1 => array ( 0 => 'View Activity Report', ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM base_acl_rules AS rule WHERE permission_id=? AND NOT EXISTS (SELECT * FROM base_acl_rules_clearance WHERE rule_id=rule.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 9, 1 => 'ALL', 2 => 'ADMIN', 3 => 'SUPERADMIN', 4 => 'ACCESS:employee', 5 => 'ACCESS:manager', ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM base_acl_permission WHERE name=?', 1 => array ( 0 => 'Shoutbox', ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM base_acl_rules AS rule WHERE permission_id=? AND NOT EXISTS (SELECT * FROM base_acl_rules_clearance WHERE rule_id=rule.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 10, 1 => 'ALL', 2 => 'ADMIN', 3 => 'SUPERADMIN', 4 => 'ACCESS:employee', 5 => 'ACCESS:manager', ), ) 0.0004
GetRow array ( 0 => 'SELECT * FROM company_data_1 WHERE id=?', 1 => array ( 0 => 4, ), ) 0.0005
GetOne array ( 0 => 'SELECT id FROM base_acl_permission WHERE name=?', 1 => array ( 0 => 'Calendar', ), ) 0.0003
GetOne array ( 0 => 'SELECT id FROM base_acl_rules AS rule WHERE permission_id=? AND NOT EXISTS (SELECT * FROM base_acl_rules_clearance WHERE rule_id=rule.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 8, 1 => 'ALL', 2 => 'ADMIN', 3 => 'SUPERADMIN', 4 => 'ACCESS:employee', 5 => 'ACCESS:manager', ), ) 0.0005
GetOne array ( 0 => 'SELECT id FROM base_acl_permission WHERE name=?', 1 => array ( 0 => 'Manage Perspective', ), ) 0.0002
GetOne array ( 0 => 'SELECT id FROM base_acl_rules AS rule WHERE permission_id=? AND NOT EXISTS (SELECT * FROM base_acl_rules_clearance WHERE rule_id=rule.id AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=? AND clearance!=?)', 1 => array ( 0 => 6, 1 => 'ALL', 2 => 'ADMIN', 3 => 'SUPERADMIN', 4 => 'ACCESS:employee', 5 => 'ACCESS:manager', ), ) 0.0005
Execute array ( 0 => 'SELECT id,name,description FROM crm_filters_group WHERE user_login_id=?', 1 => array ( 0 => 7, ), ) 0.0002
SelectLimit array ( 0 => 'SELECT * FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_company_name = \'4\' AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_related_companies LIKE CONCAT(\'%\',\'\\\\_\\\\_4\\\\_\\\\_\',\'%\') AND r.f_related_companies IS NOT NULL))) AND NOT (false OR r.f_login IS NULL) AND (((NOT (false OR (r.f_permission = \'2\' AND r.f_permission IS NOT NULL)) OR created_by = 7)) OR ((false OR (r.f_login = \'7\' AND r.f_login IS NOT NULL))))', 1 => 15, 2 => 0, 3 => array ( ), ) 0.0003
Number of queries: 348
Queries times: 8.9864540100098
=================================
And also as I click on company with about 40 employees, and then click on phonecalls of that comapany (total 58 phonecalls) fastest install opens it in 17 seconds?
What can we make to run epesi faster?
In one of Jasiek's posts (viewtopic.php?f=8&t=903) he wrote:
"Our largest installation has close to 600 users with recordsets of hundreds of thousands of records - partial screenshots below show: User Management page (572 users), and 2 samples of recordsets - one with over 1 mln records. We did some stress testing loading very large random datasets (200,000 records, 1,000 users) and this allowed us to fine tune the engine (both Generic Browser and the main CRUD engine - Record Browser) with limit queries in such a way that the size of the recordset (number of records in a table) does not really matter much."
What does this part means: with limit queries in such a way that the size of the recordset (number of records in a table) does not really matter much.
Thanks