| 0.0014 |
SELECT `Mst_SiteSettings`.*
FROM `Mst_SiteSettings`
WHERE `Mst_SiteSettings`.`Id` = 1
|
| 0.0008 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = 0
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '1'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '8'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '14'
AND `Mst_Category`.`Status` = 1
|
| 0.0001 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '15'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '16'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '17'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '18'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '19'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '20'
AND `Mst_Category`.`Status` = 1
|
| 0.0001 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '21'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '22'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '25'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '26'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '27'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '28'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '3'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '4'
AND `Mst_Category`.`Status` = 1
|
| 0.0001 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '5'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '6'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '7'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '9'
AND `Mst_Category`.`Status` = 1
|
| 0.0001 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '10'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '11'
AND `Mst_Category`.`Status` = 1
|
| 0.0001 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '12'
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '13'
AND `Mst_Category`.`Status` = 1
|
| 0.0001 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '23'
AND `Mst_Category`.`Status` = 1
|
| 0.0001 |
SELECT `Mst_Category`.*
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = '24'
AND `Mst_Category`.`Status` = 1
|
| 0.0018 |
SELECT `Mst_Product`.`id`, `Mst_Product`.`slug`, `Mst_Product`.`name`, `Mst_Product`.`isVariable`
FROM `Mst_Product`
WHERE `Mst_Product`.`status` = 1
ORDER BY `Mst_Product`.`id` DESC
LIMIT 8
|
| 0.0009 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '182'
|
| 0.0022 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '182'
|
| 0.0008 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '369'
|
| 0.0021 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '182'
AND `Mst_Price`.`variationId` = '1062'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '335'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '182'
AND `Mst_Price`.`variationId` = '1063'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '370'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '182'
AND `Mst_Price`.`variationId` = '1064'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '5'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '182'
AND `Mst_Price`.`variationId` = '1065'
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '181'
|
| 0.0008 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '181'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '309'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '181'
AND `Mst_Price`.`variationId` = '1061'
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '180'
|
| 0.0009 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '180'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '306'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '180'
AND `Mst_Price`.`variationId` = '1057'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '324'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '180'
AND `Mst_Price`.`variationId` = '1058'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '308'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '180'
AND `Mst_Price`.`variationId` = '1059'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '309'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '180'
AND `Mst_Price`.`variationId` = '1060'
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '179'
|
| 0.0009 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '179'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '324'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1051'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = ''
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1052'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = ''
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1053'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '309'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1054'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = ''
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1055'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = ''
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1056'
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '178'
|
| 0.0008 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '178'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '6'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '178'
AND `Mst_Price`.`variationId` = '1046'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '5'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '178'
AND `Mst_Price`.`variationId` = '1047'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '4'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '178'
AND `Mst_Price`.`variationId` = '1048'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '14'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '178'
AND `Mst_Price`.`variationId` = '1049'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '13'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '178'
AND `Mst_Price`.`variationId` = '1050'
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '177'
|
| 0.0007 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '177'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '366'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '177'
AND `Mst_Price`.`variationId` = '1043'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '367'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '177'
AND `Mst_Price`.`variationId` = '1044'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '368'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '177'
AND `Mst_Price`.`variationId` = '1045'
|
| 0.0001 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '176'
|
| 0.0007 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '176'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '35'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '176'
AND `Mst_Price`.`variationId` = '1041'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '36'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '176'
AND `Mst_Price`.`variationId` = '1042'
|
| 0.0001 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '175'
|
| 0.0007 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '175'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '37'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '175'
AND `Mst_Price`.`variationId` = '1039'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '38'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '175'
AND `Mst_Price`.`variationId` = '1040'
|
| 0.0001 |
SELECT `Mst_Category`.`Id`
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = 1
AND `Mst_Category`.`Status` = 1
|
| 0.0001 |
SELECT `Mst_Category`.`Id`
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` IN('8', '14', '15', '16', '18', '22', '25', '27')
AND `Mst_Category`.`Status` = 1
|
| 0.0001 |
SELECT `Mst_Category`.`Id`
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` IN('17', '19', '20', '21', '26', '28')
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Product`.`id`, `Mst_Product`.`slug`, `Mst_Product`.`name`, `Mst_Product`.`isVariable`
FROM `Mst_Product`
WHERE (
FIND_IN_SET(1,Mst_Product.catId) > 0
OR FIND_IN_SET(8,Mst_Product.catId) > 0
OR FIND_IN_SET(14,Mst_Product.catId) > 0
OR FIND_IN_SET(15,Mst_Product.catId) > 0
OR FIND_IN_SET(16,Mst_Product.catId) > 0
OR FIND_IN_SET(18,Mst_Product.catId) > 0
OR FIND_IN_SET(22,Mst_Product.catId) > 0
OR FIND_IN_SET(25,Mst_Product.catId) > 0
OR FIND_IN_SET(27,Mst_Product.catId) > 0
OR FIND_IN_SET(17,Mst_Product.catId) > 0
OR FIND_IN_SET(19,Mst_Product.catId) > 0
OR FIND_IN_SET(20,Mst_Product.catId) > 0
OR FIND_IN_SET(21,Mst_Product.catId) > 0
OR FIND_IN_SET(26,Mst_Product.catId) > 0
OR FIND_IN_SET(28,Mst_Product.catId) > 0
)
AND `Mst_Product`.`status` = 1
ORDER BY `Mst_Product`.`id` DESC
LIMIT 4
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '182'
|
| 0.0007 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '182'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '369'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '182'
AND `Mst_Price`.`variationId` = '1062'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '335'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '182'
AND `Mst_Price`.`variationId` = '1063'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '370'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '182'
AND `Mst_Price`.`variationId` = '1064'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '5'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '182'
AND `Mst_Price`.`variationId` = '1065'
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '181'
|
| 0.0007 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '181'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '309'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '181'
AND `Mst_Price`.`variationId` = '1061'
|
| 0.0001 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '180'
|
| 0.0007 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '180'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '306'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '180'
AND `Mst_Price`.`variationId` = '1057'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '324'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '180'
AND `Mst_Price`.`variationId` = '1058'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '308'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '180'
AND `Mst_Price`.`variationId` = '1059'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '309'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '180'
AND `Mst_Price`.`variationId` = '1060'
|
| 0.0001 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '179'
|
| 0.0007 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '179'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '324'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1051'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = ''
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1052'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = ''
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1053'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '309'
|
| 0.0005 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1054'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = ''
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1055'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = ''
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '179'
AND `Mst_Price`.`variationId` = '1056'
|
| 0.0001 |
SELECT `Mst_Category`.`Id`
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = 4
AND `Mst_Category`.`Status` = 1
|
| 0.0006 |
SELECT `Mst_Product`.`id`, `Mst_Product`.`slug`, `Mst_Product`.`name`, `Mst_Product`.`isVariable`
FROM `Mst_Product`
WHERE (
FIND_IN_SET(4,Mst_Product.catId) > 0
)
AND `Mst_Product`.`status` = 1
ORDER BY `Mst_Product`.`id` DESC
LIMIT 4
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '18'
|
| 0.0008 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '18'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '39'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '18'
AND `Mst_Price`.`variationId` = '51'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '40'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '18'
AND `Mst_Price`.`variationId` = '52'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '41'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '18'
AND `Mst_Price`.`variationId` = '53'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '42'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '18'
AND `Mst_Price`.`variationId` = '54'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '43'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '18'
AND `Mst_Price`.`variationId` = '55'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '44'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '18'
AND `Mst_Price`.`variationId` = '56'
|
| 0.0002 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '45'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '18'
AND `Mst_Price`.`variationId` = '57'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '46'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '18'
AND `Mst_Price`.`variationId` = '58'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '47'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '18'
AND `Mst_Price`.`variationId` = '59'
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '17'
|
| 0.0009 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '17'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '39'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '17'
AND `Mst_Price`.`variationId` = '42'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '40'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '17'
AND `Mst_Price`.`variationId` = '43'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '41'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '17'
AND `Mst_Price`.`variationId` = '44'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '42'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '17'
AND `Mst_Price`.`variationId` = '45'
|
| 0.0002 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '43'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '17'
AND `Mst_Price`.`variationId` = '46'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '44'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '17'
AND `Mst_Price`.`variationId` = '47'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '45'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '17'
AND `Mst_Price`.`variationId` = '48'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '46'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '17'
AND `Mst_Price`.`variationId` = '49'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '47'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '17'
AND `Mst_Price`.`variationId` = '50'
|
| 0.0001 |
SELECT `Mst_Category`.`Id`
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = 18
AND `Mst_Category`.`Status` = 1
|
| 0.0002 |
SELECT `Mst_Category`.`Id`
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` IN('19', '20', '21')
AND `Mst_Category`.`Status` = 1
|
| 0.0003 |
SELECT `Mst_Product`.`id`, `Mst_Product`.`slug`, `Mst_Product`.`name`, `Mst_Product`.`isVariable`
FROM `Mst_Product`
WHERE (
FIND_IN_SET(18,Mst_Product.catId) > 0
OR FIND_IN_SET(19,Mst_Product.catId) > 0
OR FIND_IN_SET(20,Mst_Product.catId) > 0
OR FIND_IN_SET(21,Mst_Product.catId) > 0
)
AND `Mst_Product`.`status` = 1
ORDER BY `Mst_Product`.`id` DESC
LIMIT 4
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '178'
|
| 0.0009 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '178'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '6'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '178'
AND `Mst_Price`.`variationId` = '1046'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '5'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '178'
AND `Mst_Price`.`variationId` = '1047'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '4'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '178'
AND `Mst_Price`.`variationId` = '1048'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '14'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '178'
AND `Mst_Price`.`variationId` = '1049'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '13'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '178'
AND `Mst_Price`.`variationId` = '1050'
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '177'
|
| 0.0009 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '177'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '366'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '177'
AND `Mst_Price`.`variationId` = '1043'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '367'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '177'
AND `Mst_Price`.`variationId` = '1044'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '368'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '177'
AND `Mst_Price`.`variationId` = '1045'
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '176'
|
| 0.0009 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '176'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '35'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '176'
AND `Mst_Price`.`variationId` = '1041'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '36'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '176'
AND `Mst_Price`.`variationId` = '1042'
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '170'
|
| 0.0009 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '170'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '15'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '170'
AND `Mst_Price`.`variationId` = '1010'
|
| 0.0001 |
SELECT `Mst_Category`.`Id`
FROM `Mst_Category`
WHERE `Mst_Category`.`ParentId` = 24
AND `Mst_Category`.`Status` = 1
|
| 0.0003 |
SELECT `Mst_Product`.`id`, `Mst_Product`.`slug`, `Mst_Product`.`name`, `Mst_Product`.`isVariable`
FROM `Mst_Product`
WHERE (
FIND_IN_SET(24,Mst_Product.catId) > 0
)
AND `Mst_Product`.`status` = 1
ORDER BY `Mst_Product`.`id` DESC
LIMIT 4
|
| 0.0002 |
SELECT `Trn_Product_Attachment`.*
FROM `Trn_Product_Attachment`
WHERE `Trn_Product_Attachment`.`productId` = '149'
|
| 0.0008 |
SELECT `Mst_Variation`.*
FROM `Mst_Variation`
WHERE `Mst_Variation`.`productId` = '149'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '341'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '149'
AND `Mst_Price`.`variationId` = '923'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '342'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '149'
AND `Mst_Price`.`variationId` = '924'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '343'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '149'
AND `Mst_Price`.`variationId` = '925'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '344'
|
| 0.0007 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '149'
AND `Mst_Price`.`variationId` = '926'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '345'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '149'
AND `Mst_Price`.`variationId` = '927'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '346'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '149'
AND `Mst_Price`.`variationId` = '928'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '347'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '149'
AND `Mst_Price`.`variationId` = '929'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '348'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '149'
AND `Mst_Price`.`variationId` = '930'
|
| 0.0001 |
SELECT `Mst_Attribute`.*
FROM `Mst_Attribute`
WHERE `Mst_Attribute`.`id` = '349'
|
| 0.0006 |
SELECT `Mst_Price`.*
FROM `Mst_Price`
WHERE `Mst_Price`.`productId` = '149'
AND `Mst_Price`.`variationId` = '931'
|
| 0.0009 |
SELECT `Mst_Social_Settings`.*
FROM `Mst_Social_Settings`
WHERE `Mst_Social_Settings`.`Id` = 1
|
| 0.0009 |
SELECT `Mst_ContactSettings`.*
FROM `Mst_ContactSettings`
WHERE `Mst_ContactSettings`.`Id` = 1
|
| 0.0001 |
SELECT `Mst_SiteSettings`.*
FROM `Mst_SiteSettings`
WHERE `Mst_SiteSettings`.`Id` = 1
|
| 0.0027 |
SELECT `Mst_Pages` .*
FROM `Mst_Pages`
WHERE `Mst_Pages`.`Status` = 1
|
