| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Company`.`id`, `Company`.`domain`, `Company`.`title`, `Company`.`company_type`, `Company`.`district_court`, `Company`.`commercial_register_no`, `Company`.`tax_id`, `Company`.`tax_number`, `Company`.`logo_path_system`, `Company`.`logo_path_print`, `Company`.`logo_path_pdf`, `Company`.`address`, `Company`.`plz`, `Company`.`lkz`, `Company`.`city`, `Company`.`website`, `Company`.`company_email`, `Company`.`billing_email`, `Company`.`company_telephone`, `Company`.`company_telefax`, `Company`.`country`, `Company`.`company_code`, `Company`.`bank`, `Company`.`iban`, `Company`.`bic`, `Company`.`vat_number`, `Company`.`from_email`, `Company`.`from_name`, `Company`.`reply_to_name`, `Company`.`reply_to_email`, `Company`.`smtp_port`, `Company`.`smtp_user_name`, `Company`.`smtp_password`, `Company`.`smtp_host`, `Company`.`notes`, `Company`.`active`, `Company`.`invoice_email_title`, `Company`.`invoice_email_body`, `Company`.`cost_per_extra_km`, `Company`.`invoice_format`, `Company`.`next_invoice_number`, `Company`.`invoice_number_digits`, `Company`.`created`, `Company`.`modified`, `Company`.`email_template_invoice_title`, `Company`.`email_template_invoice_body`, `Company`.`email_template_invoice_body_link`, `Company`.`email_template_link_text`, `Company`.`email_template_request_total_title`, `Company`.`email_template_request_total_body`, `Company`.`email_template_pre_invoice_title`, `Company`.`email_template_pre_invoice_body`, `Company`.`invoice_text_1`, `Company`.`invoice_text_2`, `Company`.`manager_title`, `Company`.`manager_salutation`, `Company`.`manager_first_name`, `Company`.`manager_last_name`, `Company`.`delete_chat_after_days`, `Tax`.`id`, `Tax`.`title`, `Tax`.`amount`, `Tax`.`company_id`, `CompanyEmailSetting`.`id`, `CompanyEmailSetting`.`company_id`, `CompanyEmailSetting`.`from_email`, `CompanyEmailSetting`.`from_name`, `CompanyEmailSetting`.`smtp_port`, `CompanyEmailSetting`.`smtp_user_name`, `CompanyEmailSetting`.`smtp_password`, `CompanyEmailSetting`.`smtp_host`, `CompanyEmailSetting`.`created`, `CompanyEmailSetting`.`modified` FROM `elogg-dev`.`companies` AS `Company` LEFT JOIN `elogg-dev`.`taxes` AS `Tax` ON (`Company`.`tax_id` = `Tax`.`id`) LEFT JOIN `elogg-dev`.`company_email_settings` AS `CompanyEmailSetting` ON (`CompanyEmailSetting`.`company_id` = `Company`.`id`) WHERE `Company`.`active` = '1' AND `Company`.`domain` = 'https://tmp-dev.elogg.de' LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT `CompanyFile`.`id`, `CompanyFile`.`company_id`, `CompanyFile`.`logo_path`, `CompanyFile`.`description`, `CompanyFile`.`created`, `CompanyFile`.`modified` FROM `elogg-dev`.`company_files` AS `CompanyFile` WHERE `CompanyFile`.`company_id` = (1) | 0 | 0 | 1 | maybe slow |
| SELECT `Configuration`.`id`, `Configuration`.`enviroment`, `Configuration`.`db_version`, `Configuration`.`mobile_version` FROM `elogg-dev`.`configurations` AS `Configuration` WHERE `id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`token`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`salutation`, `User`.`position`, `User`.`email`, `User`.`firm_telephone`, `User`.`firm_email`, `User`.`start_date`, `User`.`birth_date`, `User`.`logo_path`, `User`.`telephone`, `User`.`telefax`, `User`.`mobile`, `User`.`strabe`, `User`.`plz`, `User`.`city`, `User`.`country`, `User`.`nationality`, `User`.`notes`, `User`.`prev_last_login`, `User`.`group_id`, `User`.`company_id`, `User`.`active`, `User`.`sc_color`, `User`.`last_login`, `User`.`last_version_number_viewed`, `User`.`hire_date`, `User`.`fire_date`, `User`.`fire_reason`, `User`.`created`, `User`.`modified`, `User`.`no_see`, `User`.`full_name`, `User`.`job_count`, `User`.`commission`, `User`.`firm_id`, `User`.`last_mobile_seen`, `User`.`last_active_in_day`, `User`.`first_active_in_day`, `User`.`user_mobile_version`, `User`.`can_open_future_jobs`, `User`.`can_take_pictures_mobile`, `Company`.`id`, `Company`.`domain`, `Company`.`title`, `Company`.`company_type`, `Company`.`district_court`, `Company`.`commercial_register_no`, `Company`.`tax_id`, `Company`.`tax_number`, `Company`.`logo_path_system`, `Company`.`logo_path_print`, `Company`.`logo_path_pdf`, `Company`.`address`, `Company`.`plz`, `Company`.`lkz`, `Company`.`city`, `Company`.`website`, `Company`.`company_email`, `Company`.`billing_email`, `Company`.`company_telephone`, `Company`.`company_telefax`, `Company`.`country`, `Company`.`company_code`, `Company`.`bank`, `Company`.`iban`, `Company`.`bic`, `Company`.`vat_number`, `Company`.`from_email`, `Company`.`from_name`, `Company`.`reply_to_name`, `Company`.`reply_to_email`, `Company`.`smtp_port`, `Company`.`smtp_user_name`, `Company`.`smtp_password`, `Company`.`smtp_host`, `Company`.`notes`, `Company`.`active`, `Company`.`invoice_email_title`, `Company`.`invoice_email_body`, `Company`.`cost_per_extra_km`, `Company`.`invoice_format`, `Company`.`next_invoice_number`, `Company`.`invoice_number_digits`, `Company`.`created`, `Company`.`modified`, `Company`.`email_template_invoice_title`, `Company`.`email_template_invoice_body`, `Company`.`email_template_invoice_body_link`, `Company`.`email_template_link_text`, `Company`.`email_template_request_total_title`, `Company`.`email_template_request_total_body`, `Company`.`email_template_pre_invoice_title`, `Company`.`email_template_pre_invoice_body`, `Company`.`invoice_text_1`, `Company`.`invoice_text_2`, `Company`.`manager_title`, `Company`.`manager_salutation`, `Company`.`manager_first_name`, `Company`.`manager_last_name`, `Company`.`delete_chat_after_days`, `Group`.`id`, `Group`.`name`, `Group`.`scope`, `Group`.`created`, `Group`.`modified` FROM `elogg-dev`.`users` AS `User` LEFT JOIN `elogg-dev`.`companies` AS `Company` ON (`User`.`company_id` = `Company`.`id`) LEFT JOIN `elogg-dev`.`groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`id` IS NULL AND `User`.`company_id` = 1 LIMIT 1 | 0 | 0 | 2 | maybe slow |
| SELECT `DriverNote`.`id`, `DriverNote`.`note`, `DriverNote`.`ready_note`, `DriverNote`.`job_id`, `DriverNote`.`driver_id`, `DriverNote`.`seen`, `DriverNote`.`state`, `DriverNote`.`created`, `Job`.`id`, `Job`.`title`, `Job`.`notes`, `Job`.`driver_notes`, `Job`.`driver_notes_importance`, `Job`.`driver_notes_seen`, `Job`.`driver_job_status`, `Job`.`driver_road_status`, `Job`.`start_date`, `Job`.`start_time`, `Job`.`driver_start_date`, `Job`.`driver_start_time`, `Job`.`driver_end_date`, `Job`.`driver_end_time`, `Job`.`firm_id`, `Job`.`pickup_address`, `Job`.`delivery_address`, `Job`.`pickup_address_text`, `Job`.`delivery_address_text`, `Job`.`distance`, `Job`.`actual_distance`, `Job`.`client_id`, `Job`.`auftragsnummer`, `Job`.`auftrags_idnum`, `Job`.`firm_partner_id`, `Job`.`user_id`, `Job`.`driver_id`, `Job`.`truck_id`, `Job`.`weight`, `Job`.`status`, `Job`.`has_warnings`, `Job`.`invoice_id`, `Job`.`discount_amount`, `Job`.`discount_percentage`, `Job`.`total`, `Job`.`created`, `Job`.`modified`, `Job`.`last_updated`, `Job`.`last_synced`, `Job`.`pageBreakPdf`, `Job`.`lock_price`, `Job`.`driver_seen_note`, `Job`.`end_date`, `Job`.`end_time`, `Job`.`company_id`, `Job`.`mandatory_images`, `Job`.`driver_commission`, `Job`.`driver_commission_percentage`, `Job`.`paid_commission`, `Job`.`planed_start_date`, `Job`.`planed_end_date`, (CONCAT(`Job`.`start_date`, " ", `Job`.`start_time`)) AS `Job__start_datetime`, (CONCAT(`Job`.`end_date`, " ", `Job`.`end_time`)) AS `Job__end_datetime`, (CONCAT(`Job`.`driver_start_date`, " ", `Job`.`driver_start_time`)) AS `Job__driver_start_datetime`, (CONCAT(`Job`.`driver_end_date`, " ", `Job`.`driver_end_time`)) AS `Job__driver_end_datetime`, `Driver`.`id`, `Driver`.`username`, `Driver`.`password`, `Driver`.`token`, `Driver`.`first_name`, `Driver`.`last_name`, `Driver`.`title`, `Driver`.`salutation`, `Driver`.`position`, `Driver`.`email`, `Driver`.`firm_telephone`, `Driver`.`firm_email`, `Driver`.`start_date`, `Driver`.`birth_date`, `Driver`.`logo_path`, `Driver`.`telephone`, `Driver`.`telefax`, `Driver`.`mobile`, `Driver`.`strabe`, `Driver`.`plz`, `Driver`.`city`, `Driver`.`country`, `Driver`.`nationality`, `Driver`.`notes`, `Driver`.`prev_last_login`, `Driver`.`group_id`, `Driver`.`company_id`, `Driver`.`active`, `Driver`.`sc_color`, `Driver`.`last_login`, `Driver`.`last_version_number_viewed`, `Driver`.`hire_date`, `Driver`.`fire_date`, `Driver`.`fire_reason`, `Driver`.`created`, `Driver`.`modified`, `Driver`.`no_see`, `Driver`.`full_name`, `Driver`.`job_count`, `Driver`.`commission`, `Driver`.`firm_id`, `Driver`.`last_mobile_seen`, `Driver`.`last_active_in_day`, `Driver`.`first_active_in_day`, `Driver`.`user_mobile_version`, `Driver`.`can_open_future_jobs`, `Driver`.`can_take_pictures_mobile` FROM `elogg-dev`.`driver_notes` AS `DriverNote` LEFT JOIN `elogg-dev`.`jobs` AS `Job` ON (`DriverNote`.`job_id` = `Job`.`id`) LEFT JOIN `elogg-dev`.`users` AS `Driver` ON (`DriverNote`.`driver_id` = `Driver`.`id`) WHERE `seen` = '0' | 40 | 40 | 45 | maybe slow |
| SELECT `Version`.`id`, `Version`.`version_number`, `Version`.`title`, `Version`.`body`, `Version`.`created`, `Version`.`modified` FROM `elogg-dev`.`versions` AS `Version` WHERE 1 = 1 ORDER BY `Version`.`created` desc LIMIT 1 | 1 | 1 | 1 | |
| SELECT `UserPreference`.`id`, `UserPreference`.`name`, `UserPreference`.`value`, `UserPreference`.`user_id`, `UserPreference`.`controller` FROM `elogg-dev`.`user_preferences` AS `UserPreference` WHERE `user_id` = -1 AND `controller` = 'Users' AND `name` = 'menu_minified' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ServiceTypes`.`id`, `ServiceTypes`.`title` FROM `elogg-dev`.`service_types` AS `ServiceTypes` WHERE 1 = 1 | 6 | 6 | 1 | maybe slow |
| SELECT `UserConversationMessage`.`id` FROM `elogg-dev`.`user_conversation_messages` AS `UserConversationMessage` LEFT JOIN `elogg-dev`.`users` AS `User` ON (`UserConversationMessage`.`user_id` = `User`.`id`) LEFT JOIN `elogg-dev`.`users` AS `Friend` ON (`UserConversationMessage`.`driver_id` = `Friend`.`id`) WHERE `UserConversationMessage`.`created` <= '25-12-08' AND `UserConversationMessage`.`company_id` = 1 GROUP BY `UserConversationMessage`.`id` | 0 | 0 | 1 | maybe slow |