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 `Product`.`id`, `Product`.`name`, `Product`.`image_file`, `Product`.`short_note`, `Product`.`description`, `Product`.`setup_price`, `Product`.`active`, `Product`.`page_slug`, `Product`.`created`, `Product`.`modified` FROM `prolegitepura`.`products` AS `Product` WHERE `Product`.`active` = '1' AND `Product`.`setup_price` = '1' ORDER BY `Product`.`id` ASC | 2 | 2 | 0 | |
SELECT `Pricing`.`id`, `Pricing`.`product_id`, `Pricing`.`price_type_id`, `Pricing`.`currency_id`, `Pricing`.`short_note`, `Pricing`.`is_discount`, `Pricing`.`is_percentage`, `Pricing`.`orignal_price`, `Pricing`.`discount_price`, `Pricing`.`discount`, `Pricing`.`gst_percentage`, `Pricing`.`active`, `Pricing`.`page_slug`, `Pricing`.`page_url`, `Pricing`.`canonical_url`, `Pricing`.`created`, `Pricing`.`modified` FROM `prolegitepura`.`pricings` AS `Pricing` WHERE `Pricing`.`product_id` IN (1, 2) | 4 | 4 | 2 | maybe slow |
SELECT `PriceType`.`name` FROM `prolegitepura`.`price_types` AS `PriceType` WHERE `PriceType`.`id` = 1 | 1 | 1 | 2 | maybe slow |
SELECT `PriceType`.`name` FROM `prolegitepura`.`price_types` AS `PriceType` WHERE `PriceType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `PriceType`.`name` FROM `prolegitepura`.`price_types` AS `PriceType` WHERE `PriceType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `PriceType`.`name` FROM `prolegitepura`.`price_types` AS `PriceType` WHERE `PriceType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `Currency`.`sign` FROM `prolegitepura`.`currencies` AS `Currency` WHERE `Currency`.`id` = 67 | 1 | 1 | 1 | |
SELECT `Currency`.`sign` FROM `prolegitepura`.`currencies` AS `Currency` WHERE `Currency`.`id` = 67 | 1 | 1 | 0 | |
SELECT `Currency`.`sign` FROM `prolegitepura`.`currencies` AS `Currency` WHERE `Currency`.`id` = 67 | 1 | 1 | 0 | |
SELECT `Currency`.`sign` FROM `prolegitepura`.`currencies` AS `Currency` WHERE `Currency`.`id` = 67 | 1 | 1 | 0 | |
SELECT `PriceHighlight`.`id`, `PriceHighlight`.`pricing_id`, `PriceHighlight`.`note`, `PriceHighlight`.`active`, `PriceHighlight`.`created`, `PriceHighlight`.`modified` FROM `prolegitepura`.`price_highlights` AS `PriceHighlight` WHERE `PriceHighlight`.`pricing_id` IN (1, 2, 3, 4) | 20 | 20 | 1 | maybe slow |
SELECT `Pricing`.`id`, `Pricing`.`product_id`, `Pricing`.`price_type_id`, `Pricing`.`currency_id`, `Pricing`.`short_note`, `Pricing`.`is_discount`, `Pricing`.`is_percentage`, `Pricing`.`orignal_price`, `Pricing`.`discount_price`, `Pricing`.`discount`, `Pricing`.`gst_percentage`, `Pricing`.`active`, `Pricing`.`page_slug`, `Pricing`.`page_url`, `Pricing`.`canonical_url`, `Pricing`.`created`, `Pricing`.`modified`, `Product`.`id`, `Product`.`name`, `Product`.`image_file`, `Product`.`short_note`, `Product`.`description`, `Product`.`setup_price`, `Product`.`active`, `Product`.`page_slug`, `Product`.`created`, `Product`.`modified`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`no_of_attemp`, `PriceType`.`active`, `PriceType`.`created`, `PriceType`.`modified`, `Currency`.`id`, `Currency`.`name`, `Currency`.`iso_code`, `Currency`.`iso_code_num`, `Currency`.`sign`, `Currency`.`blank`, `Currency`.`format`, `Currency`.`decimals`, `Currency`.`conversion_rate`, `Currency`.`display_on_frontend`, `Currency`.`active`, `Currency`.`created`, `Currency`.`modified` FROM `prolegitepura`.`pricings` AS `Pricing` LEFT JOIN `prolegitepura`.`products` AS `Product` ON (`Pricing`.`product_id` = `Product`.`id`) LEFT JOIN `prolegitepura`.`price_types` AS `PriceType` ON (`Pricing`.`price_type_id` = `PriceType`.`id`) LEFT JOIN `prolegitepura`.`currencies` AS `Currency` ON (`Pricing`.`currency_id` = `Currency`.`id`) WHERE `Pricing`.`product_id` IN (1,2) ORDER BY `Pricing`.`id` ASC | 4 | 4 | 1 | maybe slow |
SELECT `PriceHighlight`.`id`, `PriceHighlight`.`pricing_id`, `PriceHighlight`.`note`, `PriceHighlight`.`active`, `PriceHighlight`.`created`, `PriceHighlight`.`modified` FROM `prolegitepura`.`price_highlights` AS `PriceHighlight` WHERE `PriceHighlight`.`pricing_id` IN (1, 2, 3, 4) | 20 | 20 | 0 | |