Transform your space into a work of art with Rugartisan's Cerulean Custom Rugs. Our bespoke rugs are handcrafted and designed to perfectly fit your unique style and space. Choose from a range of luxurious materials, patterns, and sizes to create a one-of-a-kind rug that will elevate any room in your home or office. With Rugartisan, you can bring your vision to life with our Cerulean Custom Rugs category.
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa310ms
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa240ms
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa380ms
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa270ms
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa220ms
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa210ms
select `attributes`.*, `category_filterable_attributes`.`category_id` as `pivot_category_id`, `category_filterable_attributes`.`attribute_id` as `pivot_attribute_id` from `attributes` innerjoin `category_filterable_attributes` on `attributes`.`id` = `category_filterable_attributes`.`attribute_id` where `category_filterable_attributes`.`category_id` =56rugartisan_com_sa560ms
select*from `attribute_options` where `attribute_options`.`attribute_id` in (11, 27, 28, 29, 38) orderby `sort_order` ascrugartisan_com_sa490ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =14and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa590ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =15and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa370ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =16and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa360ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =17and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa380ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =18and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa320ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =19and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa310ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =20and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa360ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =21and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa320ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =22and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa310ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =23and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa320ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =24and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa310ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =25and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa310ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =26and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa300ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =27and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa340ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =28and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa320ms
select*from `attribute_translations` where `attribute_translations`.`attribute_id` =27and `attribute_translations`.`attribute_id` isnotnullrugartisan_com_sa540ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =10and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa350ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =1345and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa330ms
select*from `attribute_translations` where `attribute_translations`.`attribute_id` =38and `attribute_translations`.`attribute_id` isnotnullrugartisan_com_sa360ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =79and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa320ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =80and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa320ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =83and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa340ms
select*from `locales` where `locales`.`id` =1 limit 1rugartisan_com_sa400ms
select*from `currencies` where `currencies`.`id` =4 limit 1rugartisan_com_sa260ms
select*from `core_config` where `code` ='catalog.dynamicmeta.categories.meta_title'and `channel_code` ='default'and `locale_code` ='en'rugartisan_com_sa530ms
select*from `core_config` where `code` ='catalog.dynamicmeta.categories.meta_description'and `channel_code` ='default'and `locale_code` ='en'rugartisan_com_sa370ms
select*from `core_config` where `code` ='catalog.dynamicmeta.categories.meta_keywords'and `channel_code` ='default'and `locale_code` ='en'rugartisan_com_sa370ms
select*from `core_config` where `code` ='catalog.products.storefront.products_per_page'and `channel_code` ='default'rugartisan_com_sa390ms
select*from `core_config` where `code` ='catalog.products.storefront.sort_by'and `channel_code` ='default'rugartisan_com_sa390ms
select*from `core_config` where `code` ='company.settings.general.phone'and `channel_code` ='default'and `locale_code` ='en'rugartisan_com_sa600ms
Webkul\Product501
Details
Models
0. Webkul\Product\Models\ProductFlat (69)
Queries
selectdistinct `pc`.`category_id` as `id`, `ct`.`name`, `ct`.`url_path`, `ct`.`slug`, count(distinct(pc.product_id)) as total from `product_flat` innerjoin `product_categories` as `pc` on `product_flat`.`product_id` = `pc`.`product_id` innerjoin `categories` as `c` on `c`.`id` = `pc`.`category_id` innerjoin `category_translations` as `ct` on `ct`.`category_id` = `c`.`id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `ct`.`locale` ='en'and `c`.`parent_id` =2and `c`.`status` =1and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') groupby `pc`.`category_id` orderby `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `ct`.`url_path` ascrugartisan_com_sa82.22s
selectdistinct `product_flat`.*from `product_flat` leftjoin `product_categories` as `pc` on `pc`.`product_id` = `product_flat`.`product_id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `pc`.`category_id` =56and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') orderby `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc limit 40offset0rugartisan_com_sa10.18s
selectmax(`price`) as aggregate from `product_flat` leftjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` where `product_categories`.`category_id` =56and `product_flat`.`visible_individually` ='1'rugartisan_com_sa9.27s
selectmin(`price`) as aggregate from `product_flat` leftjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` where `product_categories`.`category_id` =56and `product_flat`.`visible_individually` ='1'and `product_flat`.`price` >0rugartisan_com_sa7.62s
select `pa`.`attribute_id`, `pa`.`text_value`, count(distinct(pa.product_id)) as total from `product_flat` innerjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` leftjoin `product_attribute_values` as `pa` on `product_flat`.`product_id` = `pa`.`product_id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_categories`.`category_id` =56and `pa`.`attribute_id` in (11, 27, 28, 38) groupby `pa`.`attribute_id`, `pa`.`text_value`rugartisan_com_sa70.21s
select*from `category_translations` where `category_translations`.`category_id` in (56)300μs/packages/Webkul/Category/src/Repositories/CategoryRepository.php:187rugartisan_com_sa
select*from `category_translations` where `category_translations`.`category_id` in (56)320μs/packages/Webkul/Core/src/Eloquent/Repository.php:57rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')310μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')240μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
selectdistinct `pc`.`category_id` as `id`, `ct`.`name`, `ct`.`url_path`, `ct`.`slug`, count(distinct(pc.product_id)) as total from `product_flat` innerjoin `product_categories` as `pc` on `product_flat`.`product_id` = `pc`.`product_id` innerjoin `categories` as `c` on `c`.`id` = `pc`.`category_id` innerjoin `category_translations` as `ct` on `ct`.`category_id` = `c`.`id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `ct`.`locale` ='en'and `c`.`parent_id` =2and `c`.`status` =1and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') groupby `pc`.`category_id` orderby `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `ct`.`url_path` asc82.22ms/packages/Webkul/Product/src/Repositories/ProductRepository.php:577rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')380μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')270μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')220μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')210μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
selectcount(*) as aggregate from (selectdistinct `product_flat`.*from `product_flat` leftjoin `product_categories` as `pc` on `pc`.`product_id` = `product_flat`.`product_id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `pc`.`category_id` =56and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Eight') and `product_flat`.`weavingtype_label` in ('Hand Tufted') orderby `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc) c18.64ms/packages/Webkul/Product/src/Repositories/ProductRepository.php:595rugartisan_com_sa
select*from `category_translations` where `category_translations`.`category_id` in (2)410μs/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161rugartisan_com_sa
select `attributes`.*, `category_filterable_attributes`.`category_id` as `pivot_category_id`, `category_filterable_attributes`.`attribute_id` as `pivot_attribute_id` from `attributes` innerjoin `category_filterable_attributes` on `attributes`.`id` = `category_filterable_attributes`.`attribute_id` where `category_filterable_attributes`.`category_id` =56560μs/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161rugartisan_com_sa
selectmax(`price`) as aggregate from `product_flat` leftjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` where `product_categories`.`category_id` =56and `product_flat`.`visible_individually` ='1'9.27ms/packages/Webkul/Product/src/Repositories/ProductFlatRepository.php:39rugartisan_com_sa
selectmin(`price`) as aggregate from `product_flat` leftjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` where `product_categories`.`category_id` =56and `product_flat`.`visible_individually` ='1'and `product_flat`.`price` >07.62ms/packages/Webkul/Product/src/Repositories/ProductFlatRepository.php:397rugartisan_com_sa
select `pa`.`attribute_id`, `pa`.`text_value`, count(distinct(pa.product_id)) as total from `product_flat` innerjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` leftjoin `product_attribute_values` as `pa` on `product_flat`.`product_id` = `pa`.`product_id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_categories`.`category_id` =56and `pa`.`attribute_id` in (11, 27, 28, 38) groupby `pa`.`attribute_id`, `pa`.`text_value`70.21ms/packages/Webkul/Product/src/Repositories/ProductFlatRepository.php:208rugartisan_com_sa