Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `MenuLinksUser`.`id`, `MenuLinksUser`.`user_id` FROM `prolegitepura`.`menu_links_users` AS `MenuLinksUser` WHERE 1 = 1 ORDER BY `MenuLinksUser`.`id` ASC | 2 | 2 | 0 | |
SELECT `SocialMedia`.`id`, `SocialMedia`.`name`, `SocialMedia`.`link`, `SocialMedia`.`image_icon`, `SocialMedia`.`active`, `SocialMedia`.`created`, `SocialMedia`.`modified` FROM `prolegitepura`.`social_medias` AS `SocialMedia` WHERE `SocialMedia`.`active` = '1' ORDER BY `SocialMedia`.`id` ASC | 3 | 3 | 0 | |
SELECT `Country`.`id`, `Country`.`name` FROM `prolegitepura`.`countries` AS `Country` WHERE `Country`.`active` = '1' ORDER BY TRIM(`Country`.`name`) ASC | 245 | 245 | 1 | |
SELECT `Plan`.`id`, `Plan`.`user_id`, `Plan`.`pricing_id`, `Plan`.`price_type_id`, `Plan`.`plan_status_id`, `Plan`.`subcription_date`, `Plan`.`total_price`, `Plan`.`plan_expire_date`, `Plan`.`remaining_attemp`, `Plan`.`no_of_propperty_add`, `Plan`.`active`, `Plan`.`created`, `Plan`.`modified` FROM `prolegitepura`.`plans` AS `Plan` WHERE `Plan`.`user_id` IS NULL AND `Plan`.`active` = '1' ORDER BY `Plan`.`id` DESC | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`type`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `prolegitepura`.`settings` AS `Setting` WHERE 1 = 1 ORDER BY `Setting`.`id` ASC | 4 | 4 | 0 | |
SELECT `ProtectionModule`.`id`, `ProtectionModule`.`name`, `ProtectionModule`.`image_file`, `ProtectionModule`.`note`, `ProtectionModule`.`active`, `ProtectionModule`.`created`, `ProtectionModule`.`modified` FROM `prolegitepura`.`protection_modules` AS `ProtectionModule` WHERE 1 = 1 ORDER BY `ProtectionModule`.`id` ASC | 4 | 4 | 0 | |
SELECT `ProtectionModule`.`id`, `ProtectionModule`.`name` FROM `prolegitepura`.`protection_modules` AS `ProtectionModule` WHERE 1 = 1 ORDER BY `ProtectionModule`.`id` ASC | 4 | 4 | 0 | |
SELECT `Blog`.`id`, `Blog`.`user_id`, `Blog`.`product_id`, `Blog`.`blog_category_id`, `Blog`.`blog_author_id`, `Blog`.`title`, `Blog`.`page_slug`, `Blog`.`header_text`, `Blog`.`image_file`, `Blog`.`middle_image`, `Blog`.`note1`, `Blog`.`description`, `Blog`.`active`, `Blog`.`created`, `Blog`.`modified`, `User`.`id`, `User`.`role_id`, `User`.`salutation_id`, `User`.`login_type_id`, `User`.`agent_type_id`, `User`.`state_id`, `User`.`city_id`, `User`.`company_name`, `User`.`first_name`, `User`.`last_name`, `User`.`adhaar_no`, `User`.`pan_cart_no`, `User`.`username`, `User`.`password`, `User`.`dob`, `User`.`email`, `User`.`calling_code`, `User`.`contact_no`, `User`.`login_otp`, `User`.`upload_file`, `User`.`login_status`, `User`.`last_login`, `User`.`activation_date`, `User`.`active`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name`, `Product`.`id`, `Product`.`name`, `Product`.`image_file`, `Product`.`short_note`, `Product`.`description`, `Product`.`setup_price`, `Product`.`active`, `Product`.`page_slug`, `Product`.`created`, `Product`.`modified`, `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`page_slug`, `BlogCategory`.`active`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogAuthor`.`id`, `BlogAuthor`.`author_name`, `BlogAuthor`.`author_image`, `BlogAuthor`.`note`, `BlogAuthor`.`active`, `BlogAuthor`.`created`, `BlogAuthor`.`modified` FROM `prolegitepura`.`blogs` AS `Blog` LEFT JOIN `prolegitepura`.`users` AS `User` ON (`Blog`.`user_id` = `User`.`id`) LEFT JOIN `prolegitepura`.`products` AS `Product` ON (`Blog`.`product_id` = `Product`.`id`) LEFT JOIN `prolegitepura`.`blog_categories` AS `BlogCategory` ON (`Blog`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `prolegitepura`.`blog_authors` AS `BlogAuthor` ON (`Blog`.`blog_author_id` = `BlogAuthor`.`id`) WHERE `Blog`.`page_slug` = 'maximising-your-team-output-with-business-team-setup' ORDER BY `Blog`.`id` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `BlogComment`.`id`, `BlogComment`.`blog_id`, `BlogComment`.`name`, `BlogComment`.`email`, `BlogComment`.`comments`, `BlogComment`.`active`, `BlogComment`.`created`, `BlogComment`.`modified` FROM `prolegitepura`.`blog_comments` AS `BlogComment` WHERE `BlogComment`.`blog_id` = (2) | 4 | 4 | 0 | |
SELECT `Blog`.`id`, `Blog`.`user_id`, `Blog`.`product_id`, `Blog`.`blog_category_id`, `Blog`.`blog_author_id`, `Blog`.`title`, `Blog`.`page_slug`, `Blog`.`header_text`, `Blog`.`image_file`, `Blog`.`middle_image`, `Blog`.`note1`, `Blog`.`description`, `Blog`.`active`, `Blog`.`created`, `Blog`.`modified`, `User`.`id`, `User`.`role_id`, `User`.`salutation_id`, `User`.`login_type_id`, `User`.`agent_type_id`, `User`.`state_id`, `User`.`city_id`, `User`.`company_name`, `User`.`first_name`, `User`.`last_name`, `User`.`adhaar_no`, `User`.`pan_cart_no`, `User`.`username`, `User`.`password`, `User`.`dob`, `User`.`email`, `User`.`calling_code`, `User`.`contact_no`, `User`.`login_otp`, `User`.`upload_file`, `User`.`login_status`, `User`.`last_login`, `User`.`activation_date`, `User`.`active`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name`, `Product`.`id`, `Product`.`name`, `Product`.`image_file`, `Product`.`short_note`, `Product`.`description`, `Product`.`setup_price`, `Product`.`active`, `Product`.`page_slug`, `Product`.`created`, `Product`.`modified`, `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`page_slug`, `BlogCategory`.`active`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogAuthor`.`id`, `BlogAuthor`.`author_name`, `BlogAuthor`.`author_image`, `BlogAuthor`.`note`, `BlogAuthor`.`active`, `BlogAuthor`.`created`, `BlogAuthor`.`modified` FROM `prolegitepura`.`blogs` AS `Blog` LEFT JOIN `prolegitepura`.`users` AS `User` ON (`Blog`.`user_id` = `User`.`id`) LEFT JOIN `prolegitepura`.`products` AS `Product` ON (`Blog`.`product_id` = `Product`.`id`) LEFT JOIN `prolegitepura`.`blog_categories` AS `BlogCategory` ON (`Blog`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `prolegitepura`.`blog_authors` AS `BlogAuthor` ON (`Blog`.`blog_author_id` = `BlogAuthor`.`id`) WHERE `Blog`.`id` = 2 ORDER BY `Blog`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `BlogComment`.`id`, `BlogComment`.`blog_id`, `BlogComment`.`name`, `BlogComment`.`email`, `BlogComment`.`comments`, `BlogComment`.`active`, `BlogComment`.`created`, `BlogComment`.`modified` FROM `prolegitepura`.`blog_comments` AS `BlogComment` WHERE `BlogComment`.`active` = '1' AND `BlogComment`.`blog_id` = (2) | 2 | 2 | 0 | |
SELECT `Blog`.`id`, `Blog`.`user_id`, `Blog`.`product_id`, `Blog`.`blog_category_id`, `Blog`.`blog_author_id`, `Blog`.`title`, `Blog`.`page_slug`, `Blog`.`header_text`, `Blog`.`image_file`, `Blog`.`middle_image`, `Blog`.`note1`, `Blog`.`description`, `Blog`.`active`, `Blog`.`created`, `Blog`.`modified`, `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`page_slug`, `BlogCategory`.`active`, `BlogCategory`.`created`, `BlogCategory`.`modified` FROM `prolegitepura`.`blogs` AS `Blog` LEFT JOIN `prolegitepura`.`blog_categories` AS `BlogCategory` ON (`Blog`.`blog_category_id` = `BlogCategory`.`id`) WHERE `Blog`.`blog_category_id` = 1 AND `Blog`.`active` = '1' AND `Blog`.`id` != 2 ORDER BY `Blog`.`id` DESC | 0 | 0 | 0 | |