Hi Arek,
sure, there is SQL timing after invoking Phone Calls second time.
QUERIES
GetOne array ( 0 => 'SELECT data FROM session WHERE name = ? AND expires > ?', 1 => array ( 0 => '4bf8644930f5917420032f8786f71e8f', 1 => 1213812036, ), ) 0.00336503982544
GetOne array ( 0 => 'SELECT data FROM session_client WHERE session_name = ? AND client_id=?', 1 => array ( 0 => '4bf8644930f5917420032f8786f71e8f', 1 => 0, ), ) 0.0582449436188
Execute array ( 0 => 'SELECT name,version FROM modules ORDER BY priority', 1 => NULL, ) 0.0218689441681
Execute array ( 0 => 'SELECT name,value FROM variables', 1 => NULL, ) 0.0113379955292
Execute array ( 0 => 'SELECT module, variable, value FROM base_user_settings WHERE user_login_id=?', 1 => array ( 0 => 1, ), ) 0.00843191146851
Execute array ( 0 => 'SELECT module,variable,value FROM base_user_settings_admin_defaults', 1 => NULL, ) 0.00339412689209
Execute array ( 0 => 'UPDATE base_login_audit SET end_time=? WHERE id=?', 1 => array ( 0 => '2008-06-18 20:24:37', 1 => 2, ), ) 0.00519394874573
GetAll array ( 0 => 'SELECT tab FROM recordbrowser_table_properties', 1 => NULL, ) 0.00345993041992
GetOne array ( 0 => 'SELECT contact_id FROM contact_data WHERE field=? AND value=?', 1 => array ( 0 => 'Login', 1 => 1, ), ) 0.00284695625305
Execute array ( 0 => 'SELECT * FROM contact_field WHERE active=1 AND type!=\'page_split\' ORDER BY position', 1 => NULL, ) 0.00527000427246
Execute array ( 0 => 'SELECT * FROM contact_data WHERE contact_id=?', 1 => array ( 0 => 1, ), ) 0.00331091880798
Execute array ( 0 => 'SELECT active, created_by, created_on FROM contact WHERE id=?', 1 => array ( 0 => 1, ), ) 0.0028989315033
GetRow array ( 0 => 'SELECT caption, icon, recent, favorites, full_history FROM recordbrowser_table_properties WHERE tab=?', 1 => array ( 0 => 'phonecall', ), ) 0.00400900840759
Execute array ( 0 => 'SELECT * FROM phonecall_field WHERE active=1 AND type!=\'page_split\' ORDER BY position', 1 => NULL, ) 0.00387501716614
Execute array ( 0 => 'SELECT * FROM phonecall_callback', 1 => NULL, ) 0.00811100006104
Execute array ( 0 => 'SELECT * FROM phonecall_require', 1 => NULL, ) 0.00273609161377
Execute array ( 0 => 'SELECT field FROM phonecall_field WHERE filter=1', 1 => NULL, ) 0.00264692306519
GetRow array ( 0 => 'SELECT caption, icon, recent, favorites, full_history FROM recordbrowser_table_properties WHERE tab=?', 1 => array ( 0 => 'phonecall', ), ) 0.00375509262085
Execute array ( 0 => 'SELECT * FROM phonecall_callback', 1 => NULL, ) 0.0028338432312
Execute array ( 0 => 'SELECT * FROM phonecall_require', 1 => NULL, ) 0.00251507759094
GetOne array ( 0 => 'SELECT quickjump FROM recordbrowser_table_properties WHERE tab=?', 1 => array ( 0 => 'phonecall', ), ) 0.00308680534363
GetOne array ( 0 => 'SELECT COUNT(*) FROM (SELECT id, active, created_by, created_on, concat( \'::\', group_concat( rd0.value ORDER BY rd0.value SEPARATOR \'::\' ) , \'::\' ) AS val0, concat( \'::\', group_concat( rd1.value ORDER BY rd1.value SEPARATOR \'::\' ) , \'::\' ) AS val1 FROM ((phonecall AS r) LEFT JOIN phonecall_data AS rd0 ON r.id=rd0.phonecall_id AND rd0.field="Status") LEFT JOIN phonecall_data AS rd1 ON r.id=rd1.phonecall_id AND rd1.field="Employees" WHERE true AND active=1 GROUP BY id HAVING true AND ((true AND val0 NOT LIKE CONCAT(\'%::\',\'2\',\'::%\') AND val0 NOT LIKE CONCAT(\'%::\',\'3\',\'::%\')) OR val0 IS NULL) AND (false OR val1 LIKE CONCAT(\'%::\',\'1\',\'::%\'))) AS tmp', 1 => array ( ), ) 0.0224170684814
SelectLimit array ( 0 => 'SELECT id, active, created_by, created_on, concat( \'::\', group_concat( rd0.value ORDER BY rd0.value SEPARATOR \'::\' ) , \'::\' ) AS val0, concat( \'::\', group_concat( rd1.value ORDER BY rd1.value SEPARATOR \'::\' ) , \'::\' ) AS val1, concat( \'::\', group_concat( rd2.value ORDER BY rd2.value SEPARATOR \'::\' ) , \'::\' ) AS val2, concat( \'::\', group_concat( rd3.value ORDER BY rd3.value SEPARATOR \'::\' ) , \'::\' ) AS val3, concat( \'::\', group_concat( rd4.value ORDER BY rd4.value SEPARATOR \'::\' ) , \'::\' ) AS val4 FROM (((((phonecall AS r) LEFT JOIN phonecall_data AS rd0 ON r.id=rd0.phonecall_id AND rd0.field="Status") LEFT JOIN phonecall_data AS rd1 ON r.id=rd1.phonecall_id AND rd1.field="Employees") LEFT JOIN phonecall_data AS rd2 ON r.id=rd2.phonecall_id AND rd2.field="Status") LEFT JOIN phonecall_data AS rd3 ON r.id=rd3.phonecall_id AND rd3.field="Date and Time") LEFT JOIN phonecall_data AS rd4 ON r.id=rd4.phonecall_id AND rd4.field="Subject" WHERE true AND active=1 GROUP BY id HAVING true AND ((true AND val0 NOT LIKE CONCAT(\'%::\',\'2\',\'::%\') AND val0 NOT LIKE CONCAT(\'%::\',\'3\',\'::%\')) OR val0 IS NULL) AND (false OR val1 LIKE CONCAT(\'%::\',\'1\',\'::%\')) ORDER BY val2 ASC, val3 ASC, val4 ASC', 1 => 20, 2 => 0, 3 => array ( ), ) 0.0564138889313
Execute array ( 0 => 'SELECT phonecall_id FROM phonecall_favorite WHERE user_id=?', 1 => array ( 0 => 1, ), ) 0.00286102294922
Execute array ( 0 => 'SELECT column_id, column_pos, display FROM generic_browser WHERE name=?', 1 => array ( 0 => '0eff71e4e5f26028bac4df1fc8098461', ), ) 0.00328207015991
Execute array ( 0 => 'SELECT id,name,description FROM crm_filters_group WHERE user_login_id=?', 1 => array ( 0 => 1, ), ) 0.00322294235229
SelectLimit array ( 0 => 'SELECT id, active, created_by, created_on, concat( \'::\', group_concat( rd0.value ORDER BY rd0.value SEPARATOR \'::\' ) , \'::\' ) AS val0, concat( \'::\', group_concat( rd1.value ORDER BY rd1.value SEPARATOR \'::\' ) , \'::\' ) AS val1, concat( \'::\', group_concat( rd2.value ORDER BY rd2.value SEPARATOR \'::\' ) , \'::\' ) AS val2 FROM (((contact AS r) LEFT JOIN contact_data AS rd0 ON r.id=rd0.contact_id AND rd0.field="Company Name") LEFT JOIN contact_data AS rd1 ON r.id=rd1.contact_id AND rd1.field="Last Name") LEFT JOIN contact_data AS rd2 ON r.id=rd2.contact_id AND rd2.field="First Name" WHERE true AND active=1 GROUP BY id HAVING true AND (false OR val0 LIKE CONCAT(\'%::\',\'1\',\'::%\')) ORDER BY val1 ASC, val2 ASC', 1 => -1, 2 => 0, 3 => array ( ), ) 0.0338480472565
Execute array ( 0 => 'SELECT * FROM contact_data WHERE true AND (false OR field=? OR field=?) AND contact_id IN (?)', 1 => array ( 0 => 'Last Name', 1 => 'First Name', 2 => 1, ), ) 0.00990390777588
Best regards,
Artur