Selected Ad For Promotion
Rs. 500.00
  BENCHMARKS  
Loading Time: Base Classes  0.0003
Controller Execution Time ( Promote / View Promote )  0.1470
Total Execution Time  0.1473
  GET DATA  
No GET data exists
  MEMORY USAGE  
980,440 bytes
  POST DATA  
No POST data exists
  URI STRING  
en/ad/1660214-Cokerspaniel-11-month-male-dog-for-sale/promote
  CLASS/METHOD  
Promote/view_promote
  DATABASE:  hitadlive (Promote:$db)   QUERIES: 6 (0.0869 seconds)  (Hide)
0.0016   SELECT GET_LOCK('42d64b5ddbb720863666d679cb3c2e25'300) AS ci_session_lock 
0.0010   SELECT `data`
FROM `ci_sessions`
WHERE `id` = '35kqnqgh0jdieg030n776gpd7btvkd71' 
0.0016   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` = '1660214'
AND `a`.`is_approved` = 1
AND `a`.`archived` = 0
ORDER BY 
`a`.`approved_dateDESC 
0.0537   SELECT `a`.*, `ca`.*
FROM `ads_attributes` `a`
LEFT JOIN `category_attributes` `caON `ca`.`id` = `a`.`attribute_join_id`
WHERE `a`.`ads_id` = '1660214' 
0.0012   SELECT *
FROM `ads_photos`
WHERE `ads_id` = '1660214' 
0.0278   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)