| 0.0002 |
SELECT GET_LOCK('f97172fc07839db52920a3b66f0ab6c883e95001', 300) AS ci_session_lock
|
| 0.0003 |
SELECT `data`
FROM `ci_sessions`
WHERE `id` = 'f97172fc07839db52920a3b66f0ab6c883e95001'
|
| 0.0016 |
SELECT `cityId`, `fk_stateId`, `cityName`, `citySlug`
FROM `mst_cities`
WHERE `citySlug` = 'goa'
AND `cityStatus` = 1
|
| 0.0004 |
SELECT `categoryId`, `categoryName`, `categorySlug`, `categoryImage`, `adCount`
FROM `mst_categories`
WHERE `categoryStatus` = 1
ORDER BY `adCount` DESC
|
| 0.0003 |
SELECT `stateId`, `stateName`, `stateSlug`
FROM `mst_states`
WHERE `stateStatus` = 1
ORDER BY `stateName` ASC
|
| 0.0012 |
SELECT c.categoryId, c.categoryName,c.categorySlug, c.categoryImage, count(p.postId) as adCount FROM mst_categories c LEFT OUTER JOIN posts p ON c.categoryId = p.fk_categoryId AND p.fk_cityId = '698' AND c.categoryStatus = 1 AND p.fk_postStatusId = 1 GROUP BY c.categoryId ORDER BY adCount DESC
|
| 0.0005 |
SELECT s.subCatId, s.fk_categoryId,s.subcatName,s.subCatSlug,s.subCatImg, count(p.postId) as subCatAdCount,c.categorySlug,s.subcatStatus FROM mst_sub_categories s LEFT OUTER JOIN posts p ON s.subCatId = p.fk_subcategoryId LEFT JOIN mst_categories c ON s.fk_categoryId = c.categoryId where p.fk_cityId = '698' AND p.fk_postStatusId = 1 and s.fk_categoryId = '' AND s.subcatStatus = 1 GROUP BY s.subCatId ORDER BY subCatAdCount DESC
|
| 0.0003 |
SELECT count(*) as count
FROM `posts`
WHERE `posts`.`fk_cityId` = '698'
AND `posts`.`fk_postStatusId` = 1
|
| 0.0142 |
SELECT `postId`, `categoryName`, `subcatName`, `price`, `postTitle`, `firstName`, `lastName`, `postUniqueId`, `postDT`, `locationName`, `userType`, `postDesc`, `totalViews`, `postSlug`, `postThumb`, `categorySlug`, `subCatSlug`, `userId`, `posts`.`fk_subcategoryId`, `categoryId`, `oldNewFlag`, `stateName`, `cityName`, `citySlug`, `userSlug`
FROM posts FORCE INDEX (ix_active_offtopic)
LEFT JOIN `post_filters` ON `post_filters`.`fk_postId`=`posts`.`postId`
LEFT JOIN `mst_categories` ON `mst_categories`.`categoryId`=`posts`.`fk_categoryId`
LEFT JOIN `mst_sub_categories` ON `mst_sub_categories`.`subCatId`=`posts`.`fk_subcategoryId`
LEFT JOIN `users` ON `users`.`userId`=`posts`.`fk_userId`
LEFT JOIN `mst_states` ON `mst_states`.`stateId`=`posts`.`fk_stateId`
LEFT JOIN `mst_cities` ON `mst_cities`.`cityId`=`posts`.`fk_cityId`
LEFT JOIN `mst_locations` ON `mst_locations`.`locationId`=`posts`.`fk_locationId`
LEFT JOIN `mst_user_types` ON `mst_user_types`.`userTypeId`=`users`.`fk_userTypeId`
WHERE `posts`.`fk_cityId` = '698'
AND `posts`.`fk_postStatusId` = 1
ORDER BY `posts`.`postDT` DESC
LIMIT 10
|
| 0.0004 |
SELECT `categoryId`, `categoryName`, `categorySlug`, `categoryImage`, `adCount`
FROM `mst_categories`
WHERE `categoryStatus` = 1
ORDER BY `adCount` DESC
|
| 0.0018 |
SELECT `cityId`, `fk_stateId`, `cityName`, `citySlug`
FROM `mst_cities`
WHERE `cityStatus` = 1
AND `populer` = 1
ORDER BY `cityName` ASC
LIMIT 20
|
