Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`id`, `Setting`.`value` FROM `fojeto_live`.`settings` AS `Setting` WHERE 1 = 1 ORDER BY `Setting`.`id` ASC | 7 | 7 | 0 | |
SELECT `CateringService`.`id`, `CateringService`.`name`, `CateringService`.`image_file`, `CateringService`.`is_display_on_homepage`, `CateringService`.`active`, `CateringService`.`created`, `CateringService`.`modified` FROM `fojeto_live`.`catering_services` AS `CateringService` WHERE `CateringService`.`active` = '1' AND `CateringService`.`is_display_on_homepage` = '1' LIMIT 6 | 6 | 6 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`active`, `Category`.`page_slug`, `Category`.`page_url`, `Category`.`canonical_url`, `Category`.`page_title`, `Category`.`meta_keyword`, `Category`.`meta_description`, `Category`.`its_addon_category`, `Category`.`delevery_start_time`, `Category`.`delevery_end_time`, `Category`.`time_gap`, `Category`.`time_diffrence`, `Category`.`credit_limit`, `Category`.`created`, `Category`.`modified` FROM `fojeto_live`.`categories` AS `Category` WHERE `Category`.`active` = '1' AND `Category`.`its_addon_category` = '0' | 2 | 2 | 2 | |
SELECT `SubCategory`.`id`, `SubCategory`.`category_id`, `SubCategory`.`name`, `SubCategory`.`slug`, `SubCategory`.`image_file`, `SubCategory`.`banner_image`, `SubCategory`.`active`, `SubCategory`.`is_dashboard`, `SubCategory`.`created`, `SubCategory`.`modified`, `SubCategory`.`page_title`, `SubCategory`.`page_url`, `SubCategory`.`canonical_url`, `SubCategory`.`meta_description`, `SubCategory`.`meta_keyword` FROM `fojeto_live`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`active` = '1' AND `SubCategory`.`category_id` IN (1, 2) | 26 | 26 | 1 | |
SELECT `Offer`.`id`, `Offer`.`offer_type_id`, `Offer`.`offer_apply_on_id`, `Offer`.`offer_unique_code`, `Offer`.`name`, `Offer`.`image_file`, `Offer`.`start_date`, `Offer`.`end_date`, `Offer`.`offer`, `Offer`.`offer_code`, `Offer`.`term_condition`, `Offer`.`its_priority`, `Offer`.`active`, `Offer`.`created`, `Offer`.`modified` FROM `fojeto_live`.`offers` AS `Offer` WHERE `Offer`.`active` = '1' AND `Offer`.`start_date` <= '2025-10-22' AND `Offer`.`end_date` >= '2025-10-22' ORDER BY `Offer`.`id` DESC | 0 | 0 | 0 | |
SELECT `SubCategory`.`id`, `SubCategory`.`category_id`, `SubCategory`.`name`, `SubCategory`.`slug`, `SubCategory`.`image_file`, `SubCategory`.`banner_image`, `SubCategory`.`active`, `SubCategory`.`is_dashboard`, `SubCategory`.`created`, `SubCategory`.`modified`, `SubCategory`.`page_title`, `SubCategory`.`page_url`, `SubCategory`.`canonical_url`, `SubCategory`.`meta_description`, `SubCategory`.`meta_keyword` FROM `fojeto_live`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`slug` = 'mutton-starter' LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `SubCategory`.`id`, `SubCategory`.`category_id`, `SubCategory`.`name`, `SubCategory`.`slug`, `SubCategory`.`image_file`, `SubCategory`.`banner_image`, `SubCategory`.`active`, `SubCategory`.`is_dashboard`, `SubCategory`.`created`, `SubCategory`.`modified`, `SubCategory`.`page_title`, `SubCategory`.`page_url`, `SubCategory`.`canonical_url`, `SubCategory`.`meta_description`, `SubCategory`.`meta_keyword` FROM `fojeto_live`.`sub_categories` AS `SubCategory` WHERE `SubCategory`.`slug` = 'mutton-starter' LIMIT 1 | 1 | 1 | 1 | |
SELECT `SubCategory`.`id`, `SubCategory`.`category_id`, `SubCategory`.`name`, `SubCategory`.`slug`, `SubCategory`.`image_file`, `SubCategory`.`banner_image`, `SubCategory`.`active`, `SubCategory`.`is_dashboard`, `SubCategory`.`created`, `SubCategory`.`modified`, `SubCategory`.`page_title`, `SubCategory`.`page_url`, `SubCategory`.`canonical_url`, `SubCategory`.`meta_description`, `SubCategory`.`meta_keyword`, `Category`.`id`, `Category`.`name`, `Category`.`active`, `Category`.`page_slug`, `Category`.`page_url`, `Category`.`canonical_url`, `Category`.`page_title`, `Category`.`meta_keyword`, `Category`.`meta_description`, `Category`.`its_addon_category`, `Category`.`delevery_start_time`, `Category`.`delevery_end_time`, `Category`.`time_gap`, `Category`.`time_diffrence`, `Category`.`credit_limit`, `Category`.`created`, `Category`.`modified` FROM `fojeto_live`.`sub_categories` AS `SubCategory` LEFT JOIN `fojeto_live`.`categories` AS `Category` ON (`SubCategory`.`category_id` = `Category`.`id`) WHERE `SubCategory`.`id` = 32 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`sub_category_id`, `Product`.`unit_id`, `Product`.`name`, `Product`.`page_slug`, `Product`.`is_discount`, `Product`.`is_discount_percentage`, `Product`.`price`, `Product`.`vendor_price`, `Product`.`customer_final_price`, `Product`.`vendor_final_price`, `Product`.`is_display_on_homepage`, `Product`.`image_file`, `Product`.`discount_per`, `Product`.`maxmin_order`, `Product`.`its_min_order`, `Product`.`total_quantity`, `Product`.`description`, `Product`.`feature`, `Product`.`page_title`, `Product`.`page_url`, `Product`.`canonical_url`, `Product`.`meta_description`, `Product`.`meta_keyword`, `Product`.`is_offer_applicable`, `Product`.`apply_tax`, `Product`.`tax_value`, `Product`.`active`, `Product`.`created`, `Product`.`modified` FROM `fojeto_live`.`products` AS `Product` WHERE `Product`.`category_id` = (32) | 0 | 0 | 1 | maybe slow |
SELECT `Offer`.`id`, `Offer`.`offer_type_id`, `Offer`.`offer_apply_on_id`, `Offer`.`offer_unique_code`, `Offer`.`name`, `Offer`.`image_file`, `Offer`.`start_date`, `Offer`.`end_date`, `Offer`.`offer`, `Offer`.`offer_code`, `Offer`.`term_condition`, `Offer`.`its_priority`, `Offer`.`active`, `Offer`.`created`, `Offer`.`modified`, `OffersSubCategory`.`id`, `OffersSubCategory`.`offer_id`, `OffersSubCategory`.`sub_category_id` FROM `fojeto_live`.`offers` AS `Offer` JOIN `fojeto_live`.`offers_sub_categories` AS `OffersSubCategory` ON (`OffersSubCategory`.`sub_category_id` = 32 AND `OffersSubCategory`.`offer_id` = `Offer`.`id`) | 0 | 0 | 1 | maybe slow |
SELECT `SubCategory`.`id`, `SubCategory`.`category_id`, `SubCategory`.`name`, `SubCategory`.`slug`, `SubCategory`.`image_file`, `SubCategory`.`banner_image`, `SubCategory`.`active`, `SubCategory`.`is_dashboard`, `SubCategory`.`created`, `SubCategory`.`modified`, `SubCategory`.`page_title`, `SubCategory`.`page_url`, `SubCategory`.`canonical_url`, `SubCategory`.`meta_description`, `SubCategory`.`meta_keyword`, `Category`.`id`, `Category`.`name`, `Category`.`active`, `Category`.`page_slug`, `Category`.`page_url`, `Category`.`canonical_url`, `Category`.`page_title`, `Category`.`meta_keyword`, `Category`.`meta_description`, `Category`.`its_addon_category`, `Category`.`delevery_start_time`, `Category`.`delevery_end_time`, `Category`.`time_gap`, `Category`.`time_diffrence`, `Category`.`credit_limit`, `Category`.`created`, `Category`.`modified` FROM `fojeto_live`.`sub_categories` AS `SubCategory` LEFT JOIN `fojeto_live`.`categories` AS `Category` ON (`SubCategory`.`category_id` = `Category`.`id`) WHERE `SubCategory`.`category_id` = 1 AND `SubCategory`.`active` = '1' | 14 | 14 | 1 | maybe slow |
SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`sub_category_id`, `Product`.`unit_id`, `Product`.`name`, `Product`.`page_slug`, `Product`.`is_discount`, `Product`.`is_discount_percentage`, `Product`.`price`, `Product`.`vendor_price`, `Product`.`customer_final_price`, `Product`.`vendor_final_price`, `Product`.`is_display_on_homepage`, `Product`.`image_file`, `Product`.`discount_per`, `Product`.`maxmin_order`, `Product`.`its_min_order`, `Product`.`total_quantity`, `Product`.`description`, `Product`.`feature`, `Product`.`page_title`, `Product`.`page_url`, `Product`.`canonical_url`, `Product`.`meta_description`, `Product`.`meta_keyword`, `Product`.`is_offer_applicable`, `Product`.`apply_tax`, `Product`.`tax_value`, `Product`.`active`, `Product`.`created`, `Product`.`modified` FROM `fojeto_live`.`products` AS `Product` WHERE `Product`.`category_id` IN (20, 22, 23, 24, 25, 26, 27, 28, 29, 32, 33, 38, 40, 41) | 0 | 0 | 1 | maybe slow |
SELECT `Offer`.`id`, `Offer`.`offer_type_id`, `Offer`.`offer_apply_on_id`, `Offer`.`offer_unique_code`, `Offer`.`name`, `Offer`.`image_file`, `Offer`.`start_date`, `Offer`.`end_date`, `Offer`.`offer`, `Offer`.`offer_code`, `Offer`.`term_condition`, `Offer`.`its_priority`, `Offer`.`active`, `Offer`.`created`, `Offer`.`modified`, `OffersSubCategory`.`id`, `OffersSubCategory`.`offer_id`, `OffersSubCategory`.`sub_category_id` FROM `fojeto_live`.`offers` AS `Offer` JOIN `fojeto_live`.`offers_sub_categories` AS `OffersSubCategory` ON (`OffersSubCategory`.`sub_category_id` IN (20, 22, 23, 24, 25, 26, 27, 28, 29, 32, 33, 38, 40, 41) AND `OffersSubCategory`.`offer_id` = `Offer`.`id`) | 0 | 0 | 3 | maybe slow |
SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`sub_category_id`, `Product`.`unit_id`, `Product`.`name`, `Product`.`page_slug`, `Product`.`is_discount`, `Product`.`is_discount_percentage`, `Product`.`price`, `Product`.`vendor_price`, `Product`.`customer_final_price`, `Product`.`vendor_final_price`, `Product`.`is_display_on_homepage`, `Product`.`image_file`, `Product`.`discount_per`, `Product`.`maxmin_order`, `Product`.`its_min_order`, `Product`.`total_quantity`, `Product`.`description`, `Product`.`feature`, `Product`.`page_title`, `Product`.`page_url`, `Product`.`canonical_url`, `Product`.`meta_description`, `Product`.`meta_keyword`, `Product`.`is_offer_applicable`, `Product`.`apply_tax`, `Product`.`tax_value`, `Product`.`active`, `Product`.`created`, `Product`.`modified`, `Category`.`id`, `Category`.`name`, `Category`.`active`, `Category`.`page_slug`, `Category`.`page_url`, `Category`.`canonical_url`, `Category`.`page_title`, `Category`.`meta_keyword`, `Category`.`meta_description`, `Category`.`its_addon_category`, `Category`.`delevery_start_time`, `Category`.`delevery_end_time`, `Category`.`time_gap`, `Category`.`time_diffrence`, `Category`.`credit_limit`, `Category`.`created`, `Category`.`modified`, `SubCategory`.`id`, `SubCategory`.`category_id`, `SubCategory`.`name`, `SubCategory`.`slug`, `SubCategory`.`image_file`, `SubCategory`.`banner_image`, `SubCategory`.`active`, `SubCategory`.`is_dashboard`, `SubCategory`.`created`, `SubCategory`.`modified`, `SubCategory`.`page_title`, `SubCategory`.`page_url`, `SubCategory`.`canonical_url`, `SubCategory`.`meta_description`, `SubCategory`.`meta_keyword`, `Unit`.`id`, `Unit`.`name`, `Unit`.`active`, `Unit`.`created`, `Unit`.`modified`, `ProductQuatity`.`id`, `ProductQuatity`.`user_id`, `ProductQuatity`.`branch_location_id`, `ProductQuatity`.`product_id`, `ProductQuatity`.`quantity`, `ProductQuatity`.`date`, `ProductQuatity`.`created`, `ProductQuatity`.`modified` FROM `fojeto_live`.`products` AS `Product` LEFT JOIN `fojeto_live`.`categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `fojeto_live`.`sub_categories` AS `SubCategory` ON (`Product`.`sub_category_id` = `SubCategory`.`id`) LEFT JOIN `fojeto_live`.`units` AS `Unit` ON (`Product`.`unit_id` = `Unit`.`id`) LEFT JOIN `fojeto_live`.`product_quatities` AS `ProductQuatity` ON (`ProductQuatity`.`product_id` = `Product`.`id`) WHERE `Product`.`sub_category_id` = 32 AND `Product`.`active` = '1' ORDER BY `Product`.`id` ASC LIMIT 20 | 0 | 0 | 6 | maybe slow |
SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`sub_category_id`, `Product`.`unit_id`, `Product`.`name`, `Product`.`page_slug`, `Product`.`is_discount`, `Product`.`is_discount_percentage`, `Product`.`price`, `Product`.`vendor_price`, `Product`.`customer_final_price`, `Product`.`vendor_final_price`, `Product`.`is_display_on_homepage`, `Product`.`image_file`, `Product`.`discount_per`, `Product`.`maxmin_order`, `Product`.`its_min_order`, `Product`.`total_quantity`, `Product`.`description`, `Product`.`feature`, `Product`.`page_title`, `Product`.`page_url`, `Product`.`canonical_url`, `Product`.`meta_description`, `Product`.`meta_keyword`, `Product`.`is_offer_applicable`, `Product`.`apply_tax`, `Product`.`tax_value`, `Product`.`active`, `Product`.`created`, `Product`.`modified`, `Category`.`id`, `Category`.`name`, `Category`.`active`, `Category`.`page_slug`, `Category`.`page_url`, `Category`.`canonical_url`, `Category`.`page_title`, `Category`.`meta_keyword`, `Category`.`meta_description`, `Category`.`its_addon_category`, `Category`.`delevery_start_time`, `Category`.`delevery_end_time`, `Category`.`time_gap`, `Category`.`time_diffrence`, `Category`.`credit_limit`, `Category`.`created`, `Category`.`modified`, `SubCategory`.`id`, `SubCategory`.`category_id`, `SubCategory`.`name`, `SubCategory`.`slug`, `SubCategory`.`image_file`, `SubCategory`.`banner_image`, `SubCategory`.`active`, `SubCategory`.`is_dashboard`, `SubCategory`.`created`, `SubCategory`.`modified`, `SubCategory`.`page_title`, `SubCategory`.`page_url`, `SubCategory`.`canonical_url`, `SubCategory`.`meta_description`, `SubCategory`.`meta_keyword`, `Unit`.`id`, `Unit`.`name`, `Unit`.`active`, `Unit`.`created`, `Unit`.`modified`, `ProductQuatity`.`id`, `ProductQuatity`.`user_id`, `ProductQuatity`.`branch_location_id`, `ProductQuatity`.`product_id`, `ProductQuatity`.`quantity`, `ProductQuatity`.`date`, `ProductQuatity`.`created`, `ProductQuatity`.`modified` FROM `fojeto_live`.`products` AS `Product` LEFT JOIN `fojeto_live`.`categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `fojeto_live`.`sub_categories` AS `SubCategory` ON (`Product`.`sub_category_id` = `SubCategory`.`id`) LEFT JOIN `fojeto_live`.`units` AS `Unit` ON (`Product`.`unit_id` = `Unit`.`id`) LEFT JOIN `fojeto_live`.`product_quatities` AS `ProductQuatity` ON (`ProductQuatity`.`product_id` = `Product`.`id`) WHERE `Product`.`sub_category_id` = 32 AND `Product`.`active` = '1' ORDER BY `Product`.`id` ASC LIMIT 20 | 0 | 0 | 2 | maybe slow |