Strasznie wolno wyszukuje spotkania, 5 minut czekałem

GetOne array ( 0 => 'SELECT COUNT(*) FROM crm_meeting_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE ? AND r.f_title IS NOT NULL)) OR ((EXISTS (SELECT 1 FROM contact_data_1 AS r_contact_0 WHERE r_contact_0.active=1 AND ((r_contact_0.f_last_name LIKE ? AND r_contact_0.f_last_name IS NOT NULL) OR (r_contact_0.f_first_name LIKE ? AND r_contact_0.f_first_name IS NOT NULL)) AND r.f_employees LIKE CONCAT(\'%\\_\\_\', r_contact_0.id, \'\\_\\_%\')))) OR ((EXISTS (SELECT 1 FROM premium_salesopportunity_data_1 AS r_premium_salesopportunity_0 WHERE r_premium_salesopportunity_0.active=1 AND ((r_premium_salesopportunity_0.f_opportunity_name LIKE ? AND r_premium_salesopportunity_0.f_opportunity_name IS NOT NULL)) AND r.f_opportunity = r_premium_salesopportunity_0.id)))) AND (((r.f_title LIKE ? AND r.f_title IS NOT NULL)) OR ((EXISTS (SELECT 1 FROM contact_data_1 AS r_contact_1 WHERE r_contact_1.active=1 AND ((r_contact_1.f_last_name LIKE ? AND r_contact_1.f_last_name IS NOT NULL) OR (r_contact_1.f_first_name LIKE ? AND r_contact_1.f_first_name IS NOT NULL)) AND r.f_employees LIKE CONCAT(\'%\\_\\_\', r_contact_1.id, \'\\_\\_%\')))) OR ((EXISTS (SELECT 1 FROM premium_salesopportunity_data_1 AS r_premium_salesopportunity_1 WHERE r_premium_salesopportunity_1.active=1 AND ((r_premium_salesopportunity_1.f_opportunity_name LIKE ? AND r_premium_salesopportunity_1.f_opportunity_name IS NOT NULL)) AND r.f_opportunity = r_premium_salesopportunity_1.id)))) AND (((r.f_title LIKE ? AND r.f_title IS NOT NULL)) OR ((EXISTS (SELECT 1 FROM contact_data_1 AS r_contact_2 WHERE r_contact_2.active=1 AND ((r_contact_2.f_last_name LIKE ? AND r_contact_2.f_last_name IS NOT NULL) OR (r_contact_2.f_first_name LIKE ? AND r_contact_2.f_first_name IS NOT NULL)) AND r.f_employees LIKE CONCAT(\'%\\_\\_\', r_contact_2.id, \'\\_\\_%\')))) OR ((EXISTS (SELECT 1 FROM premium_salesopportunity_data_1 AS r_premium_salesopportunity_2 WHERE r_premium_salesopportunity_2.active=1 AND ((r_premium_salesopportunity_2.f_opportunity_name LIKE ? AND r_premium_salesopportunity_2.f_opportunity_name IS NOT NULL)) AND r.f_opportunity = r_premium_salesopportunity_2.id)))) AND (((NOT ((r.f_permission = ? AND r.f_permission IS NOT NULL))) OR ((r.f_employees LIKE ? AND r.f_employees IS NOT NULL)))))', 1 => array ( 0 => '%DREMUS%', 1 => '%DREMUS%', 2 => '%DREMUS%', 3 => '%DREMUS%', 4 => '%GRIGGIO%', 5 => '%GRIGGIO%', 6 => '%GRIGGIO%', 7 => '%GRIGGIO%', 8 => '%GF%', 9 => '%GF%', 10 => '%GF%', 11 => '%GF%', 12 => '2', 13 => '%\\_\\_1\\_\\_%', ), ) 249.2301, Called by Utils_RecordBrowserCommon::get_records_count, File '/var/www/epesi/modules/Utils/RecordBrowser/RecordBrowser_0.php: 919
SelectLimit array ( 0 => 'SELECT r.* FROM crm_meeting_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE ? AND r.f_title IS NOT NULL)) OR ((EXISTS (SELECT 1 FROM contact_data_1 AS r_contact_0 WHERE r_contact_0.active=1 AND ((r_contact_0.f_last_name LIKE ? AND r_contact_0.f_last_name IS NOT NULL) OR (r_contact_0.f_first_name LIKE ? AND r_contact_0.f_first_name IS NOT NULL)) AND r.f_employees LIKE CONCAT(\'%\\_\\_\', r_contact_0.id, \'\\_\\_%\')))) OR ((EXISTS (SELECT 1 FROM premium_salesopportunity_data_1 AS r_premium_salesopportunity_0 WHERE r_premium_salesopportunity_0.active=1 AND ((r_premium_salesopportunity_0.f_opportunity_name LIKE ? AND r_premium_salesopportunity_0.f_opportunity_name IS NOT NULL)) AND r.f_opportunity = r_premium_salesopportunity_0.id)))) AND (((r.f_title LIKE ? AND r.f_title IS NOT NULL)) OR ((EXISTS (SELECT 1 FROM contact_data_1 AS r_contact_1 WHERE r_contact_1.active=1 AND ((r_contact_1.f_last_name LIKE ? AND r_contact_1.f_last_name IS NOT NULL) OR (r_contact_1.f_first_name LIKE ? AND r_contact_1.f_first_name IS NOT NULL)) AND r.f_employees LIKE CONCAT(\'%\\_\\_\', r_contact_1.id, \'\\_\\_%\')))) OR ((EXISTS (SELECT 1 FROM premium_salesopportunity_data_1 AS r_premium_salesopportunity_1 WHERE r_premium_salesopportunity_1.active=1 AND ((r_premium_salesopportunity_1.f_opportunity_name LIKE ? AND r_premium_salesopportunity_1.f_opportunity_name IS NOT NULL)) AND r.f_opportunity = r_premium_salesopportunity_1.id)))) AND (((r.f_title LIKE ? AND r.f_title IS NOT NULL)) OR ((EXISTS (SELECT 1 FROM contact_data_1 AS r_contact_2 WHERE r_contact_2.active=1 AND ((r_contact_2.f_last_name LIKE ? AND r_contact_2.f_last_name IS NOT NULL) OR (r_contact_2.f_first_name LIKE ? AND r_contact_2.f_first_name IS NOT NULL)) AND r.f_employees LIKE CONCAT(\'%\\_\\_\', r_contact_2.id, \'\\_\\_%\')))) OR ((EXISTS (SELECT 1 FROM premium_salesopportunity_data_1 AS r_premium_salesopportunity_2 WHERE r_premium_salesopportunity_2.active=1 AND ((r_premium_salesopportunity_2.f_opportunity_name LIKE ? AND r_premium_salesopportunity_2.f_opportunity_name IS NOT NULL)) AND r.f_opportunity = r_premium_salesopportunity_2.id)))) AND (((NOT ((r.f_permission = ? AND r.f_permission IS NOT NULL))) OR ((r.f_employees LIKE ? AND r.f_employees IS NOT NULL))))) ORDER BY r.f_date DESC, r.f_time DESC, r.f_status DESC', 1 => '50', 2 => 0, 3 => array ( 0 => '%DREMUS%', 1 => '%DREMUS%', 2 => '%DREMUS%', 3 => '%DREMUS%', 4 => '%GRIGGIO%', 5 => '%GRIGGIO%', 6 => '%GRIGGIO%', 7 => '%GRIGGIO%', 8 => '%GF%', 9 => '%GF%', 10 => '%GF%', 11 => '%GF%', 12 => '2', 13 => '%\\_\\_1\\_\\_%', ), ) 246.6112, Called by Utils_RecordBrowserCommon::get_records, File '/var/www/epesi/modules/Utils/RecordBrowser/RecordBrowser_0.php: 946

Time of loading module /Base_Box|0: 496.0472
Time of loading module /Base_Box|0/Base_Theme|0: 0.0000
Time of loading module /Base_Box|0/CRM_Meeting|main_0: 496.0266
Time of loading module /Base_Box|0/CRM_Meeting|main_0/Utils_RecordBrowser|crm_meeting: 496.0264

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge