Nuts & Dried Fruits

Loading products...

(default) 12 queries took 1 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Config`.`key`, `Config`.`value` FROM `niramoypolli_sohansworld`.`configs` AS `Config` WHERE 1 = 1	59	59	0
2	BEGIN	0	0	0
3	ROLLBACK	0	0	0
4	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `status` = '1' AND `parent_id` = 0 ORDER BY `Category`.`sequence` ASC	12	12	0
5	SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `status` = '1' ORDER BY `sequence` ASC	17	17	0
6	SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `niramoypolli_sohansworld`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC	0	0	0
7	SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, Count(`Product`.`id`) AS item_total FROM `niramoypolli_sohansworld`.`brands` AS `Brand` LEFT JOIN `niramoypolli_sohansworld`.`products` AS `Product` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE `Product`.`status` = '1' AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') GROUP BY `Brand`.`id` HAVING Count(`Product`.`id`) >0 ORDER BY `Brand`.`created` DESC	7	7	0
8	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `Category`.`sequence` ASC	12	12	0
9	SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `niramoypolli_sohansworld`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (1, 3, 4, 5, 6, 2, 7, 8, 9, 10, 16, 22)	5	5	0
10	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`product_id`, `Category`.`parent_id` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `sequence` ASC	12	12	0
11	SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `niramoypolli_sohansworld`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (1, 3, 4, 5, 6, 2, 7, 8, 9, 10, 16, 22)	5	5	0
12	SELECT `Category`.`id`, `Category`.`name`, `Category`.`subtitle`, `Category`.`slug`, `Category`.`spec`, `Category`.`meta_key`, `Category`.`meta_description` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `slug` = 'nuts-dried-fruits' LIMIT 1	1	1	1

(default) 12 queries took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Config`.`key`, `Config`.`value` FROM `niramoypolli_sohansworld`.`configs` AS `Config` WHERE 1 = 1

BEGIN

ROLLBACK

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `status` = '1' AND `parent_id` = 0 ORDER BY `Category`.`sequence` ASC

SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `status` = '1' ORDER BY `sequence` ASC

SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `niramoypolli_sohansworld`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC

SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, Count(`Product`.`id`) AS item_total FROM `niramoypolli_sohansworld`.`brands` AS `Brand` LEFT JOIN `niramoypolli_sohansworld`.`products` AS `Product` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE `Product`.`status` = '1' AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') GROUP BY `Brand`.`id` HAVING Count(`Product`.`id`) >0 ORDER BY `Brand`.`created` DESC

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `Category`.`sequence` ASC

SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `niramoypolli_sohansworld`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (1, 3, 4, 5, 6, 2, 7, 8, 9, 10, 16, 22)

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`product_id`, `Category`.`parent_id` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `sequence` ASC

SELECT `Category`.`id`, `Category`.`name`, `Category`.`subtitle`, `Category`.`slug`, `Category`.`spec`, `Category`.`meta_key`, `Category`.`meta_description` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `slug` = 'nuts-dried-fruits' LIMIT 1

Nuts & Dried Fruits

About Nuts & Dried Fruits