Advertisement

Tags


No tags found!
Advertisement


(default) 21 queries took 25 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `recipes`17173
2DESCRIBE `users`30302
3DESCRIBE `cookbooks`991
4DESCRIBE `cookbook_recipes`331
5DESCRIBE `reviews`10101
6DESCRIBE `categories`991
7DESCRIBE `entity_fields`881
8DESCRIBE `eav_fields`13131
9DESCRIBE `assets`991
10DESCRIBE `eav_records`551
11DESCRIBE `languages`331
12SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `parent_id` IS NULL ORDER BY `Category`.`name` asc 22220
13SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'Recipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 229
14SELECT `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`, `Category`.`recipe_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`.`day` = 1 AND `Recipe`.`status` = 1 LIMIT 1001
15SELECT `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`, `Category`.`recipe_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`.`status` = 1 ORDER BY `created` DESC LIMIT 3001
16SELECT *, count(Review.id) as count FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `recipes` AS `Recipe` ON (`Review`.`item_id` = `Recipe`.`id`) WHERE 1 = 1 GROUP BY item_id ORDER BY `count` DESC LIMIT 3000
17SELECT `Review`.`id`, `Review`.`title`, `Review`.`body`, `Review`.`status`, `Review`.`user_id`, `Review`.`review_type`, `Review`.`item_id`, `Review`.`date_time`, `Review`.`type`, `Review`.`rating`, `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`, `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` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `recipes` AS `Recipe` ON (`Review`.`item_id` = `Recipe`.`id`) WHERE NOT (`Review`.`body` = '') ORDER BY `date_time` DESC LIMIT 3000
18SELECT `Ad`.`title`, `Ad`.`id`, `Ad`.`placement`, `Ad`.`code`, `Ad`.`published`, `Ad`.`created` FROM `ads` AS `Ad` WHERE `published` = 1 330
19SELECT COUNT(*) AS `count` FROM `tags` AS `Tag` WHERE 1 = 1 110
20SELECT COUNT(*) AS `count` FROM `subscribers` AS `Subscriber` WHERE `Subscriber`.`entity_id` IS NULL 110
21SELECT `Ad`.`title`, `Ad`.`id`, `Ad`.`placement`, `Ad`.`code`, `Ad`.`published`, `Ad`.`created` FROM `ads` AS `Ad` WHERE `Ad`.`placement` = 'module' AND `Ad`.`published` = 1 ORDER BY `created` DESC 000