Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Property`.`id`, `Property`.`public_url` FROM `prowner`.`properties` AS `Property` WHERE `public_url` IS NOT NULL | 499 | 499 | 3 | |
SELECT `Note`.`id`, `Note`.`user_id`, `Note`.`entity`, `Note`.`entity_id`, `Note`.`title`, `Note`.`note`, `Note`.`reminder`, `Note`.`reminder_date`, `Note`.`send_to_user`, `Note`.`created`, `Note`.`modified`, `Note`.`hasreminded`, `Note`.`read_only`, `User`.`id`, `User`.`parent_user_id`, `User`.`type`, `User`.`partner_id`, `User`.`first_name`, `User`.`surname`, `User`.`email`, `User`.`telephone`, `User`.`mobile`, `User`.`address_1`, `User`.`address_2`, `User`.`address_3`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`password`, `User`.`persistent_login_cookie`, `User`.`authentication_token`, `User`.`is_administrator`, `User`.`created`, `User`.`modified`, `User`.`stripeid`, `User`.`stripesubid`, `User`.`company`, `User`.`trial_notification`, `User`.`country`, `User`.`timezone`, `User`.`company_name`, `User`.`company_url`, `User`.`company_logo`, `User`.`company_logo_footer`, `User`.`last_access`, (CONCAT(`User`.`first_name`, `User`.`surname`)) AS `User__fullname`, (CONCAT(`User`.`first_name`, `User`.`surname`, " (", `User`.`email`, ")")) AS `User__fullname_inc_email` FROM `prowner`.`notes` AS `Note` LEFT JOIN `prowner`.`users` AS `User` ON (`Note`.`user_id` = `User`.`id`) WHERE `Note`.`user_id` = '' AND `Note`.`entity` = 'properties' AND `Note`.`entity_id` = 'villa-amarante' | 0 | 0 | 2 | maybe slow |
SELECT `Document`.`id`, `Document`.`user_id`, `Document`.`entity`, `Document`.`entity_id`, `Document`.`document_type_id`, `Document`.`title`, `Document`.`reference`, `Document`.`start`, `Document`.`end`, `Document`.`directory`, `Document`.`filename`, `Document`.`created`, `Document`.`modified`, `Document`.`notify`, `Document`.`send_to_user`, `Document`.`hasreminded`, `DocumentType`.`id`, `DocumentType`.`name`, `User`.`id`, `User`.`parent_user_id`, `User`.`type`, `User`.`partner_id`, `User`.`first_name`, `User`.`surname`, `User`.`email`, `User`.`telephone`, `User`.`mobile`, `User`.`address_1`, `User`.`address_2`, `User`.`address_3`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`password`, `User`.`persistent_login_cookie`, `User`.`authentication_token`, `User`.`is_administrator`, `User`.`created`, `User`.`modified`, `User`.`stripeid`, `User`.`stripesubid`, `User`.`company`, `User`.`trial_notification`, `User`.`country`, `User`.`timezone`, `User`.`company_name`, `User`.`company_url`, `User`.`company_logo`, `User`.`company_logo_footer`, `User`.`last_access`, (CONCAT(`User`.`first_name`, `User`.`surname`)) AS `User__fullname`, (CONCAT(`User`.`first_name`, `User`.`surname`, " (", `User`.`email`, ")")) AS `User__fullname_inc_email` FROM `prowner`.`documents` AS `Document` LEFT JOIN `prowner`.`document_types` AS `DocumentType` ON (`Document`.`document_type_id` = `DocumentType`.`id`) LEFT JOIN `prowner`.`users` AS `User` ON (`Document`.`user_id` = `User`.`id`) WHERE `Document`.`user_id` = '' AND `Document`.`entity` = 'properties' AND `Document`.`entity_id` = 'villa-amarante' | 0 | 0 | 2 | maybe slow |
SELECT `Properties`.`id`, `Properties`.`user_id`, `Properties`.`name`, `Properties`.`address_1`, `Properties`.`address_2`, `Properties`.`address_3`, `Properties`.`city`, `Properties`.`state`, `Properties`.`zip`, `Properties`.`rateband_id`, `Properties`.`currency_id`, `Properties`.`created`, `Properties`.`modified`, `Properties`.`default_check_in`, `Properties`.`default_check_out`, `Properties`.`public`, `Properties`.`public_url`, `Properties`.`country` FROM `prowner`.`properties` AS `Properties` WHERE `Properties`.`user_id` = '' ORDER BY `id` asc | 0 | 0 | 2 | maybe slow |
SELECT `Property`.`id`, `Property`.`user_id`, `Property`.`name`, `Property`.`address_1`, `Property`.`address_2`, `Property`.`address_3`, `Property`.`city`, `Property`.`state`, `Property`.`zip`, `Property`.`rateband_id`, `Property`.`currency_id`, `Property`.`created`, `Property`.`modified`, `Property`.`default_check_in`, `Property`.`default_check_out`, `Property`.`public`, `Property`.`public_url`, `Property`.`country`, `User`.`id`, `User`.`parent_user_id`, `User`.`type`, `User`.`partner_id`, `User`.`first_name`, `User`.`surname`, `User`.`email`, `User`.`telephone`, `User`.`mobile`, `User`.`address_1`, `User`.`address_2`, `User`.`address_3`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`password`, `User`.`persistent_login_cookie`, `User`.`authentication_token`, `User`.`is_administrator`, `User`.`created`, `User`.`modified`, `User`.`stripeid`, `User`.`stripesubid`, `User`.`company`, `User`.`trial_notification`, `User`.`country`, `User`.`timezone`, `User`.`company_name`, `User`.`company_url`, `User`.`company_logo`, `User`.`company_logo_footer`, `User`.`last_access`, (CONCAT(`User`.`first_name`, `User`.`surname`)) AS `User__fullname`, (CONCAT(`User`.`first_name`, `User`.`surname`, " (", `User`.`email`, ")")) AS `User__fullname_inc_email`, `Rateband`.`id`, `Rateband`.`property_id`, `Rateband`.`name`, `Rateband`.`start`, `Rateband`.`end`, `Rateband`.`value`, `Rateband`.`created`, `Rateband`.`modified`, `Currency`.`id`, `Currency`.`name`, `Currency`.`iso`, `Currency`.`symbol` FROM `prowner`.`properties` AS `Property` LEFT JOIN `prowner`.`users` AS `User` ON (`Property`.`user_id` = `User`.`id`) LEFT JOIN `prowner`.`ratebands` AS `Rateband` ON (`Property`.`rateband_id` = `Rateband`.`id`) LEFT JOIN `prowner`.`currencies` AS `Currency` ON (`Property`.`currency_id` = `Currency`.`id`) WHERE `public_url` = '399/villa-amarante' AND `public` = '1' LIMIT 1 | 1 | 1 | 3 | maybe slow |
SELECT `Booking`.`id`, `Booking`.`person_id`, `Booking`.`property_id`, `Booking`.`send_to_user`, `Booking`.`booking_status_id`, `Booking`.`client_name`, `Booking`.`total_value`, `Booking`.`hold_days`, `Booking`.`start`, `Booking`.`end`, `Booking`.`adults`, `Booking`.`children`, `Booking`.`details`, `Booking`.`private_details`, `Booking`.`special_requests`, `Booking`.`created`, `Booking`.`modified` FROM `prowner`.`bookings` AS `Booking` WHERE `Booking`.`property_id` = (264) | 0 | 0 | 2 | maybe slow |
SELECT `Item`.`id`, `Item`.`property_id`, `Item`.`zone_id`, `Item`.`name`, `Item`.`acquisition_value`, `Item`.`acquisition_date`, `Item`.`created`, `Item`.`modified` FROM `prowner`.`items` AS `Item` WHERE `Item`.`property_id` = (264) | 0 | 0 | 2 | maybe slow |
SELECT `Ratebands`.`id`, `Ratebands`.`property_id`, `Ratebands`.`name`, `Ratebands`.`start`, `Ratebands`.`end`, `Ratebands`.`value`, `Ratebands`.`created`, `Ratebands`.`modified` FROM `prowner`.`ratebands` AS `Ratebands` WHERE `Ratebands`.`property_id` = (264) | 0 | 0 | 2 | maybe slow |
SELECT `Zone`.`id`, `Zone`.`property_id`, `Zone`.`name`, `Zone`.`created`, `Zone`.`modified` FROM `prowner`.`zones` AS `Zone` WHERE `Zone`.`property_id` = (264) | 0 | 0 | 2 | maybe slow |
SELECT `CompanyPeopleProperty`.`id`, `CompanyPeopleProperty`.`person_id`, `CompanyPeopleProperty`.`company_id`, `CompanyPeopleProperty`.`property_id`, `CompanyPeopleProperty`.`zone_id` FROM `prowner`.`company_people_properties` AS `CompanyPeopleProperty` WHERE `CompanyPeopleProperty`.`property_id` = (264) | 0 | 0 | 2 | maybe slow |
SELECT `Booking`.`id`, `Booking`.`person_id`, `Booking`.`property_id`, `Booking`.`send_to_user`, `Booking`.`booking_status_id`, `Booking`.`client_name`, `Booking`.`total_value`, `Booking`.`hold_days`, `Booking`.`start`, `Booking`.`end`, `Booking`.`adults`, `Booking`.`children`, `Booking`.`details`, `Booking`.`private_details`, `Booking`.`special_requests`, `Booking`.`created`, `Booking`.`modified`, `Property`.`id`, `Property`.`user_id`, `Property`.`name`, `Property`.`address_1`, `Property`.`address_2`, `Property`.`address_3`, `Property`.`city`, `Property`.`state`, `Property`.`zip`, `Property`.`rateband_id`, `Property`.`currency_id`, `Property`.`created`, `Property`.`modified`, `Property`.`default_check_in`, `Property`.`default_check_out`, `Property`.`public`, `Property`.`public_url`, `Property`.`country`, `BookingStatus`.`id`, `BookingStatus`.`name`, `BookingStatus`.`background_colour`, `BookingStatus`.`border_colour`, `BookingStatus`.`text_colour`, `Person`.`id`, `Person`.`user_id`, `Person`.`first_name`, `Person`.`surname`, `Person`.`email`, `Person`.`email_alt`, `Person`.`telephone`, `Person`.`telephone_alt`, `Person`.`mobile`, `Person`.`address_1`, `Person`.`address_2`, `Person`.`address_3`, `Person`.`city`, `Person`.`state`, `Person`.`zip`, `Person`.`person_type_id`, `Person`.`role`, `Person`.`created`, `Person`.`modified` FROM `prowner`.`bookings` AS `Booking` LEFT JOIN `prowner`.`properties` AS `Property` ON (`Booking`.`property_id` = `Property`.`id`) LEFT JOIN `prowner`.`booking_statuses` AS `BookingStatus` ON (`Booking`.`booking_status_id` = `BookingStatus`.`id`) LEFT JOIN `prowner`.`people` AS `Person` ON (`Booking`.`person_id` = `Person`.`id`) WHERE `property_id` = 264 | 0 | 0 | 3 | maybe slow |