News | Business | Cricket | Showbiz | Pictures | Videos | Weather Blog | Forum




One Pakistan - Pakistan News & General Entertainment Web Portal

Mobile RSS / Alerts Sitemap
Get Social with Us!

Use of this site is governed by our Terms and Privacy Policy | About | Copyright | Contact

© Onepakistan.com 2012. All rights reserved.
(default) 21 queries took 36 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Language`.`code` FROM `languages` AS `Language` WHERE `status` = 1 LIMIT 1110
2SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`image`, `Category`.`description` FROM `categories` AS `Category` WHERE `Category`.`slug` = 'eid-ul-adha-special' LIMIT 1111
3SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`image`, `Category`.`description` FROM `categories` AS `Category` WHERE `parent_id` = 86 000
4SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` LEFT JOIN `users` AS `User` ON (`Recipe`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Recipe`.`category_id` = `Category`.`id`) WHERE `Recipe`.`category_id` = 86 AND `Recipe`.`status` = 1 118
5SELECT `Recipe`.`id`, `Recipe`.`name`, `Recipe`.`slug`, `Recipe`.`main_ingredients`, `Recipe`.`method`, `Recipe`.`short_description`, `Recipe`.`ingredients`, `Recipe`.`user_id`, `Recipe`.`prepration_time`, `Recipe`.`cooking_time`, `Recipe`.`status`, `Recipe`.`count_search`, `Recipe`.`created`, `Recipe`.`view`, `Recipe`.`day`, `Recipe`.`step_by_step_instruction`, `Recipe`.`category_id`, `User`.`id`, `User`.`userType`, `User`.`fullname`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`date_joined`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`deactivate`, `User`.`last_login_date`, `User`.`rank`, `User`.`blog_status`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`self_intro`, `User`.`dob`, `User`.`cooking_level`, `User`.`hobbies`, `User`.`cooking_interest`, `User`.`do_not_like`, `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`image`, `Category`.`description` FROM `recipes` AS `Recipe` LEFT JOIN `users` AS `User` ON (`Recipe`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Recipe`.`category_id` = `Category`.`id`) WHERE `Recipe`.`category_id` = 86 AND `Recipe`.`status` = 1 ORDER BY `created` DESC LIMIT 12121210
6SELECT `Asset`.`id`, `Asset`.`item_id`, `Asset`.`user_id`, `Asset`.`type`, `Asset`.`name`, `Asset`.`time`, `Asset`.`description`, `Asset`.`upload_type`, `Asset`.`status` FROM `assets` AS `Asset` WHERE `type` = 'Recipe' AND `Asset`.`item_id` IN (2076, 1888, 1852, 1763, 1762, 1229, 1078, 824, 823, 822, 813, 800) 12123
7SELECT `Review`.`id`, `Review`.`title`, `Review`.`body`, `Review`.`status`, `Review`.`user_id`, `Review`.`review_type`, `Review`.`item_id`, `Review`.`date_time`, `Review`.`type`, `Review`.`rating` FROM `reviews` AS `Review` WHERE `type` = 'Recipe' AND `Review`.`item_id` IN (2076, 1888, 1852, 1763, 1762, 1229, 1078, 824, 823, 822, 813, 800) 000
8SELECT `Cookbook`.`id`, `Cookbook`.`title`, `Cookbook`.`description`, `Cookbook`.`pic`, `Cookbook`.`user_id`, `Cookbook`.`view`, `Cookbook`.`featured`, `Cookbook`.`block_status`, `Cookbook`.`created`, `CookbookRecipe`.`id`, `CookbookRecipe`.`recipe_id`, `CookbookRecipe`.`cookbook_id` FROM `cookbooks` AS `Cookbook` JOIN `cookbook_recipes` AS `CookbookRecipe` ON (`CookbookRecipe`.`recipe_id` IN (2076, 1888, 1852, 1763, 1762, 1229, 1078, 824, 823, 822, 813, 800) AND `CookbookRecipe`.`cookbook_id` = `Cookbook`.`id`) WHERE 1 = 1 000
9SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `entity_id` IN (2076, 1888, 1852, 1763, 1762, 1229, 1078, 824, 823, 822, 813, 800) AND `entity` = 'Recipe' 12122
10SELECT `EavValuesInt`.`id`, `EavValuesInt`.`entity_field_id`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `eav_record_id` IN (810, 823, 832, 833, 834, 1088, 1239, 3682, 3683, 3772, 3808, 3996) AND `entity_field_id` IN (1, 2, 3, 4) 24241
11SELECT `EavValuesVarchar`.`id`, `EavValuesVarchar`.`entity_field_id`, `EavValuesVarchar`.`value`, `EavValuesVarchar`.`eav_record_id` FROM `eav_values_varchar` AS `EavValuesVarchar` WHERE `eav_record_id` IN (810, 823, 832, 833, 834, 1088, 1239, 3682, 3683, 3772, 3808, 3996) AND `entity_field_id` IN (1, 2, 3, 4) 001
12SELECT `EavValuesOther`.`id`, `EavValuesOther`.`entity_field_id`, `EavValuesOther`.`value`, `EavValuesOther`.`eav_record_id` FROM `eav_values_other` AS `EavValuesOther` WHERE `eav_record_id` IN (810, 823, 832, 833, 834, 1088, 1239, 3682, 3683, 3772, 3808, 3996) AND `entity_field_id` IN (1, 2, 3, 4) 000
13SELECT `Asset`.`id`, `Asset`.`item_id`, `Asset`.`user_id`, `Asset`.`type`, `Asset`.`name`, `Asset`.`time`, `Asset`.`description`, `Asset`.`upload_type`, `Asset`.`status` FROM `assets` AS `Asset` WHERE `item_id` IN (2076, 1888, 1852, 1763, 1762, 1229, 1078, 824, 823, 822, 813, 800) AND `Asset`.`status` = 1 AND `type` = 'Recipe' 12123
14SELECT `Ad`.`title`, `Ad`.`id`, `Ad`.`placement`, `Ad`.`code`, `Ad`.`published`, `Ad`.`created` FROM `ads` AS `Ad` WHERE `Ad`.`placement` = 'header' LIMIT 1110
15SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`image`, `Category`.`description` FROM `categories` AS `Category` WHERE `parent_id` IS NULL 34340
16SELECT `Ad`.`title`, `Ad`.`id`, `Ad`.`placement`, `Ad`.`code`, `Ad`.`published`, `Ad`.`created` FROM `ads` AS `Ad` WHERE `Ad`.`placement` = 'left_column' LIMIT 1110
17SELECT COUNT(*) AS `count` FROM `tags` AS `Tag` WHERE 1 = 1 110
18SELECT `Tag`.`tag`, `Tag`.`slug`, Count(`TaggedItem`.`id`) as count FROM `tagged_items` AS `TaggedItem` LEFT JOIN `tags` AS `Tag` ON (`TaggedItem`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 GROUP BY tag_id ORDER BY `Tag`.`tag` ASC 61610
19SELECT `Ad`.`title`, `Ad`.`id`, `Ad`.`placement`, `Ad`.`code`, `Ad`.`published`, `Ad`.`created` FROM `ads` AS `Ad` WHERE `Ad`.`placement` = 'right_column' LIMIT 1110
20SELECT `Ad`.`title`, `Ad`.`id`, `Ad`.`placement`, `Ad`.`code`, `Ad`.`published`, `Ad`.`created` FROM `ads` AS `Ad` WHERE `Ad`.`placement` = 'right_column' ORDER BY RAND() ASC LIMIT 1117
21SELECT COUNT(*) AS `count` FROM `subscribers` AS `Subscriber` WHERE `Subscriber`.`entity_id` IS NULL 110