Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Company`.`id`, `Company`.`title`, `Company`.`logo_path`, `Company`.`logo_path_system`, `Company`.`logo_path_open_door`, `Company`.`logo_path_pdf`, `Company`.`logo_path_email`, `Company`.`from_email`, `Company`.`from_name`, `Company`.`messages_email`, `Company`.`site_prefix`, `Company`.`smtp_port`, `Company`.`smtp_user_name`, `Company`.`smtp_password`, `Company`.`smtp_host`, `Company`.`enable_email`, `Company`.`load_email_by_default`, `Company`.`require_email_approval`, `Company`.`twilio_sid`, `Company`.`twilio_token`, `Company`.`twilio_number`, `Company`.`enable_sms`, `Company`.`load_sms_by_default`, `Company`.`require_sms_approval`, `Company`.`send_proposal_to_managment_limit`, `Company`.`aco_id`, `Company`.`department_name`, `Company`.`department_name_singular`, `Company`.`participant_name_singular`, `Company`.`participant_name_plural`, `Company`.`participant_mode`, `Company`.`system_name`, `Company`.`login_bg`, `Company`.`active`, `Company`.`address`, `Company`.`plz`, `Company`.`city`, `Company`.`country`, `Company`.`website`, `Company`.`product_website`, `Company`.`company_email`, `Company`.`company_telephone`, `Company`.`company_mobile`, `Company`.`company_code`, `Company`.`notes`, `Company`.`onMaintenance`, `Company`.`created`, `Company`.`modified`, `Company`.`company_css`, `Company`.`company_js`, `Company`.`bad_bg`, `Company`.`avg_bg`, `Company`.`good_bg`, `Company`.`bad_color`, `Company`.`avg_color`, `Company`.`good_color`, `Company`.`pdf_header_footer_bg_color`, `Company`.`pdf_header_footer_color`, `Company`.`invoice_format`, `Company`.`next_invoice_number`, `Company`.`invoice_number_digits`, `Company`.`appointment_value` FROM `elefter846724_boulaUser`.`companies` AS `Company` WHERE `Company`.`active` = '1' AND `Company`.`id` = 4 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Configuration`.`id`, `Configuration`.`full_path_open_door_develop`, `Configuration`.`full_path_open_door_production`, `Configuration`.`full_path_hr_develop`, `Configuration`.`full_path_hr_production`, `Configuration`.`hr_develop_domain`, `Configuration`.`hr_domain`, `Configuration`.`open_door_develop_domain`, `Configuration`.`open_door_domain`, `Configuration`.`ekg_title`, `Configuration`.`remove_aco_ids`, `Configuration`.`enviroment`, `Configuration`.`template_company_id` FROM `elefter846724_boulaUser`.`configurations` AS `Configuration` WHERE `Configuration`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ContentPage`.`id`, `ContentPage`.`title` FROM `elefter846724_boulaUser`.`content_pages` AS `ContentPage` WHERE 1 = 1 | 13 | 13 | 2 | maybe slow |
SELECT `ParagraphType`.`model`, `ParagraphType`.`id` FROM `elefter846724_boulaUser`.`paragraph_types` AS `ParagraphType` WHERE 1 = 1 | 4 | 4 | 2 | maybe slow |
SELECT `User`.`id`, `User`.`get_all_ekg_email`, `User`.`username`, `User`.`password`, `User`.`role`, `User`.`group_id`, `User`.`company_id`, `User`.`agency_id`, `User`.`email`, `User`.`position`, `User`.`departmentResponsible`, `User`.`first_name`, `User`.`last_name`, `User`.`logo_path`, `User`.`phone`, `User`.`mobile`, `User`.`active`, `User`.`last_login`, `User`.`previous_last_login`, `Company`.`id`, `Company`.`title`, `Company`.`logo_path`, `Company`.`logo_path_system`, `Company`.`logo_path_open_door`, `Company`.`logo_path_pdf`, `Company`.`logo_path_email`, `Company`.`from_email`, `Company`.`from_name`, `Company`.`messages_email`, `Company`.`site_prefix`, `Company`.`smtp_port`, `Company`.`smtp_user_name`, `Company`.`smtp_password`, `Company`.`smtp_host`, `Company`.`enable_email`, `Company`.`load_email_by_default`, `Company`.`require_email_approval`, `Company`.`twilio_sid`, `Company`.`twilio_token`, `Company`.`twilio_number`, `Company`.`enable_sms`, `Company`.`load_sms_by_default`, `Company`.`require_sms_approval`, `Company`.`send_proposal_to_managment_limit`, `Company`.`aco_id`, `Company`.`department_name`, `Company`.`department_name_singular`, `Company`.`participant_name_singular`, `Company`.`participant_name_plural`, `Company`.`participant_mode`, `Company`.`system_name`, `Company`.`login_bg`, `Company`.`active`, `Company`.`address`, `Company`.`plz`, `Company`.`city`, `Company`.`country`, `Company`.`website`, `Company`.`product_website`, `Company`.`company_email`, `Company`.`company_telephone`, `Company`.`company_mobile`, `Company`.`company_code`, `Company`.`notes`, `Company`.`onMaintenance`, `Company`.`created`, `Company`.`modified`, `Company`.`company_css`, `Company`.`company_js`, `Company`.`bad_bg`, `Company`.`avg_bg`, `Company`.`good_bg`, `Company`.`bad_color`, `Company`.`avg_color`, `Company`.`good_color`, `Company`.`pdf_header_footer_bg_color`, `Company`.`pdf_header_footer_color`, `Company`.`invoice_format`, `Company`.`next_invoice_number`, `Company`.`invoice_number_digits`, `Company`.`appointment_value`, `Group`.`id`, `Group`.`name`, `Group`.`company_id`, `Group`.`created`, `Group`.`modified` FROM `elefter846724_boulaUser`.`users` AS `User` LEFT JOIN `elefter846724_boulaUser`.`companies` AS `Company` ON (`User`.`company_id` = `Company`.`id`) LEFT JOIN `elefter846724_boulaUser`.`groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`id` IS NULL AND `User`.`company_id` = 4 LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Company`.`id`, `Company`.`title`, `Company`.`logo_path`, `Company`.`logo_path_system`, `Company`.`logo_path_open_door`, `Company`.`logo_path_pdf`, `Company`.`logo_path_email`, `Company`.`from_email`, `Company`.`from_name`, `Company`.`messages_email`, `Company`.`site_prefix`, `Company`.`smtp_port`, `Company`.`smtp_user_name`, `Company`.`smtp_password`, `Company`.`smtp_host`, `Company`.`enable_email`, `Company`.`load_email_by_default`, `Company`.`require_email_approval`, `Company`.`twilio_sid`, `Company`.`twilio_token`, `Company`.`twilio_number`, `Company`.`enable_sms`, `Company`.`load_sms_by_default`, `Company`.`require_sms_approval`, `Company`.`send_proposal_to_managment_limit`, `Company`.`aco_id`, `Company`.`department_name`, `Company`.`department_name_singular`, `Company`.`participant_name_singular`, `Company`.`participant_name_plural`, `Company`.`participant_mode`, `Company`.`system_name`, `Company`.`login_bg`, `Company`.`active`, `Company`.`address`, `Company`.`plz`, `Company`.`city`, `Company`.`country`, `Company`.`website`, `Company`.`product_website`, `Company`.`company_email`, `Company`.`company_telephone`, `Company`.`company_mobile`, `Company`.`company_code`, `Company`.`notes`, `Company`.`onMaintenance`, `Company`.`created`, `Company`.`modified`, `Company`.`company_css`, `Company`.`company_js`, `Company`.`bad_bg`, `Company`.`avg_bg`, `Company`.`good_bg`, `Company`.`bad_color`, `Company`.`avg_color`, `Company`.`good_color`, `Company`.`pdf_header_footer_bg_color`, `Company`.`pdf_header_footer_color`, `Company`.`invoice_format`, `Company`.`next_invoice_number`, `Company`.`invoice_number_digits`, `Company`.`appointment_value` FROM `elefter846724_boulaUser`.`companies` AS `Company` WHERE `Company`.`id` = 4 LIMIT 1 | 1 | 1 | 1 | |
SELECT `BlogPost`.`id`, `BlogPost`.`title`, `BlogPost`.`summary_text`, `BlogPost`.`summary_image`, `BlogPost`.`meta_keywords`, `BlogPost`.`meta_description`, `BlogPost`.`blog_post_category_id`, `BlogPost`.`likes`, `BlogPost`.`user_id`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPostCategory`.`id`, `BlogPostCategory`.`title`, `BlogPostCategory`.`blog_post_count`, `User`.`id`, `User`.`get_all_ekg_email`, `User`.`username`, `User`.`password`, `User`.`role`, `User`.`group_id`, `User`.`company_id`, `User`.`agency_id`, `User`.`email`, `User`.`position`, `User`.`departmentResponsible`, `User`.`first_name`, `User`.`last_name`, `User`.`logo_path`, `User`.`phone`, `User`.`mobile`, `User`.`active`, `User`.`last_login`, `User`.`previous_last_login` FROM `elefter846724_boulaUser`.`blog_posts` AS `BlogPost` LEFT JOIN `elefter846724_boulaUser`.`blog_post_categories` AS `BlogPostCategory` ON (`BlogPost`.`blog_post_category_id` = `BlogPostCategory`.`id`) LEFT JOIN `elefter846724_boulaUser`.`users` AS `User` ON (`BlogPost`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY rand() ASC LIMIT 2 | 2 | 2 | 1 | maybe slow |
SELECT `Paragraph`.`id`, `Paragraph`.`title`, `Paragraph`.`body`, `Paragraph`.`porder`, `Paragraph`.`fkey_id`, `Paragraph`.`paragraph_type_id`, `Paragraph`.`created`, `Paragraph`.`modified` FROM `elefter846724_boulaUser`.`paragraphs` AS `Paragraph` WHERE paragraph_type_id = 1 AND `Paragraph`.`fkey_id` IN (48, 46) ORDER BY `Paragraph`.`porder` ASC | 6 | 6 | 4 | maybe slow |
SELECT `RelativePromo`.`id`, `RelativePromo`.`master_id`, `RelativePromo`.`master_model`, `RelativePromo`.`related_id`, `RelativePromo`.`related_model` FROM `elefter846724_boulaUser`.`relative_contents` AS `RelativePromo` WHERE master_model = "BlogPost" and related_model = "Promo" AND `RelativePromo`.`master_id` IN (48, 46) ORDER BY `RelativePromo`.`related_model` ASC | 0 | 0 | 1 | maybe slow |
SELECT `RelativeProject`.`id`, `RelativeProject`.`master_id`, `RelativeProject`.`master_model`, `RelativeProject`.`related_id`, `RelativeProject`.`related_model` FROM `elefter846724_boulaUser`.`relative_contents` AS `RelativeProject` WHERE master_model = "BlogPost" and related_model = "Project" AND `RelativeProject`.`master_id` IN (48, 46) ORDER BY `RelativeProject`.`related_model` ASC | 0 | 0 | 1 | maybe slow |
SELECT `RelativeContentPage`.`id`, `RelativeContentPage`.`master_id`, `RelativeContentPage`.`master_model`, `RelativeContentPage`.`related_id`, `RelativeContentPage`.`related_model` FROM `elefter846724_boulaUser`.`relative_contents` AS `RelativeContentPage` WHERE master_model = "BlogPost" and related_model = "ContentPage" AND `RelativeContentPage`.`master_id` IN (48, 46) ORDER BY `RelativeContentPage`.`related_model` ASC | 0 | 0 | 1 | maybe slow |
SELECT `RelativeBlogPost`.`id`, `RelativeBlogPost`.`master_id`, `RelativeBlogPost`.`master_model`, `RelativeBlogPost`.`related_id`, `RelativeBlogPost`.`related_model` FROM `elefter846724_boulaUser`.`relative_contents` AS `RelativeBlogPost` WHERE master_model = "BlogPost" and related_model = "BlogPost" AND `RelativeBlogPost`.`master_id` IN (48, 46) ORDER BY `RelativeBlogPost`.`id` ASC | 0 | 0 | 1 | maybe slow |
SELECT `PageLog`.`id`, `PageLog`.`url`, `PageLog`.`visits` FROM `elefter846724_boulaUser`.`page_logs` AS `PageLog` WHERE `url` = 'http://eleftheriadou-pathologos.gr/users/login' LIMIT 1 | 1 | 1 | 1 | |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `elefter846724_boulaUser`.`page_logs` AS `PageLog` WHERE `PageLog`.`id` = 154 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `elefter846724_boulaUser`.`page_logs` AS `PageLog` WHERE `PageLog`.`id` = 154 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `elefter846724_boulaUser`.`page_logs` AS `PageLog` WHERE `PageLog`.`id` = 154 | 1 | 1 | 0 | |
UPDATE `elefter846724_boulaUser`.`page_logs` SET `id` = 154, `url` = 'http://eleftheriadou-pathologos.gr/users/login', `visits` = 187 WHERE `elefter846724_boulaUser`.`page_logs`.`id` = '154' | 1 | 1 | 1 | |
COMMIT | | | | |
2 duplicate queries run.