Selected Ad For Promotion
Rs. 500.00
  BENCHMARKS  
Loading Time: Base Classes  0.0003
Controller Execution Time ( Promote / View Promote )  0.0928
Total Execution Time  0.0931
  GET DATA  
No GET data exists
  MEMORY USAGE  
966,064 bytes
  POST DATA  
No POST data exists
  URI STRING  
en/ad/1664756-kalutara-Nagoda-Land-for-Sale/promote
  CLASS/METHOD  
Promote/view_promote
  DATABASE:  hitadlive (Promote:$db)   QUERIES: 6 (0.0716 seconds)  (Hide)
0.0008   SELECT GET_LOCK('c5c3df8f05614c2367ea7b512728b436'300) AS ci_session_lock 
0.0009   SELECT `data`
FROM `ci_sessions`
WHERE `id` = 'omgcrc00a20ihfdq2n3a7s70qt9rg3c2' 
0.0011   SELECT `a`.`id` as `ad_id`, `a`.`reference_no`, `a`.`is_top_seller`, `a`.`ad_thumb_img`, `a`.`title`, `a`.`slug`, `a`.`description`, `a`.`price`, `a`.`is_negotiable`, `a`.`phone_one`, `a`.`phone_two`, `a`.`approved_date`, `ds`.`name_en` as `district_name`, `ds`.`district_slug`, `ct`.`name_en` as `city_name`, `ct`.`city_slug`, `at`.`ad_type`, `c`.`category_name`, `c`.`category_slug`, `sc`.`category_slug` as `sub_category_slug`, `sc`.`category_name` as `sub_category_name`
FROM `ads` `a`
LEFT JOIN `ad_types` `atON `at`.`id` = `a`.`ad_type_id`
LEFT JOIN `categories` `cON `c`.`id` = `a`.`category_id`
LEFT JOIN `categories` `scON `sc`.`id` = `a`.`sub_category_id`
LEFT JOIN `districts` `dsON `ds`.`id` = `a`.`district_id`
LEFT JOIN `cities` `ctON `ct`.`id` = `a`.`city_id`
WHERE `a`.`id` = '1664756'
AND `a`.`is_approved` = 1
AND `a`.`archived` = 0
ORDER BY 
`a`.`approved_dateDESC 
0.0496   SELECT `a`.*, `ca`.*
FROM `ads_attributes` `a`
LEFT JOIN `category_attributes` `caON `ca`.`id` = `a`.`attribute_join_id`
WHERE `a`.`ads_id` = '1664756' 
0.0010   SELECT *
FROM `ads_photos`
WHERE `ads_id` = '1664756' 
0.0182   SELECT `c`.*, count(a.category_id) as ads_count
FROM 
`categories` `c`
LEFT JOIN `ads` `aON `a`.`category_id` = `c`.`id`
WHERE `c`.`parent_category_idIS NULL
AND `c`.`is_active` = 1
AND `a`.`is_approved` = 1
AND `a`.`archived` = 0
AND `a`.`approved_date` >= NOW() - INTERVAL 60 DAY
GROUP BY 
`a`.`category_id`
ORDER BY `c`.`order_number
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)