| 0.0010 |
SELECT `property`.*, `member`.`m_fname`, `member`.`m_lname`, `member`.`m_email`
FROM `property`
JOIN `member` ON `property`.`p_userid`=`member`.`m_userid`
WHERE `property`.`p_url` = 'innoftempe.com'
|
| 0.0002 |
SELECT *
FROM `search`
WHERE `s_name_combined` = 'Tempe AZ'
|
| 0.0002 |
UPDATE `property` SET `p_tot` = '14.27'
WHERE `p_id` = '2016'
|
| 0.0003 |
SELECT *
FROM `property_amenities`
WHERE `pa_pid` = '2016'
ORDER BY `pa_sort` ASC
|
| 0.0003 |
SELECT *
FROM `property_attractions`
WHERE `pt_pid` = '2016'
ORDER BY `pt_sort` DESC, `pt_minutes` ASC
|
| 0.0002 |
SELECT `flag_1`, `flag_2`, `weekly_email_quota`, `inactivity_reminder`, `apology_letter`, `signature`
FROM `review_settings`
WHERE `property_id` = '2016'
|
| 0.0002 |
SELECT *
FROM `property_custom_pages`
WHERE `p_id` = '2016'
AND `show_menu` = 1
|
| 0.0002 |
SELECT *
FROM `property_custom_pages`
WHERE `p_id` = '2016'
AND `show_sidebar` = 1
|
| 0.0159 |
SELECT *
FROM `property_rooms`
JOIN `property_rooms_booking` ON `property_rooms`.`pr_id`=`property_rooms_booking`.`prd_prid`
WHERE `property_rooms`.`pr_pid` = '2016'
AND `property_rooms`.`pr_deleted` =0
AND `property_rooms_booking`.`prd_date` = '2017-10-22'
ORDER BY `property_rooms_booking`.`prd_rate`, `property_rooms`.`pr_smoking`, `property_rooms`.`pr_accessible`
|
| 0.0020 |
SELECT *
FROM `property_rooms_booking`
WHERE `prd_prid` = '1309'
AND `prd_date` >= '2017-10-22'
AND `prd_date` < '2017-10-23'
AND `prd_deleted` =0
AND (`prd_rate` <= 0 OR `prd_inventory` - `prd_sold` < 1 )
|
| 0.0020 |
SELECT *
FROM `property_rooms_booking`
WHERE `prd_prid` = '1309'
AND `prd_date` >= '2017-10-22'
ORDER BY `prd_date`
LIMIT 1
|
| 0.0029 |
SELECT *
FROM `property_rooms_booking`
WHERE `prd_prid` = '1310'
AND `prd_date` >= '2017-10-22'
AND `prd_date` < '2017-10-23'
AND `prd_deleted` =0
AND (`prd_rate` <= 0 OR `prd_inventory` - `prd_sold` < 1 )
|
| 0.0109 |
SELECT *
FROM `property_rooms_booking`
WHERE `prd_prid` = '1310'
AND `prd_date` >= '2017-10-22'
ORDER BY `prd_date`
LIMIT 1
|
