SET sql_mode='', @@session.time_zone='+00:00', NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' [] (0.07 ms.)

SELECT Section, Name, Content FROM config [] (5.74 ms.)

SELECT FieldName, Text FROM lang_values WHERE TableName = 'config' AND Lang = 'en' AND Domain IN (0, '76') ORDER BY Domain DESC [] (2.09 ms.)

SELECT catalog_named_filters.ID,catalog_named_filters.Type,catalog_named_filters.CategoryID,catalog_named_filters.BrandID,catalog_named_filters.GroupID,catalog_named_filters.NamedFilterGroupID,catalog_named_filters.Name,catalog_named_filters.Code,catalog_named_filters.Image,catalog_named_filters.Image2,catalog_named_filters.Url,catalog_named_filters.NameShort,catalog_named_filters.SortIndex,catalog_named_filters.CatSortIndex,catalog_named_filters.Hide,catalog_named_filters.HideIndex,catalog_named_filters.InMenu,catalog_named_filters.H,catalog_named_filters.Title,catalog_named_filters.Keywords,catalog_named_filters.Description,catalog_named_filters.SearchSyn,catalog_named_filters.Canonical FROM catalog_named_filters WHERE catalog_named_filters.Url = ? LIMIT 1 [/category/motoshlem/s-tsvet-2883/s-razmer-2xl-or-l/s-tip_shlema-integraly-or-otkrytye/] (0.28 ms.)

SELECT catalog_props.ID,catalog_props.Name,catalog_props.Code,catalog_props.Text,catalog_props.GroupID,catalog_props.Type,catalog_props.TypeFilter,catalog_props.IsModable,catalog_props.TypeParam,catalog_props.BaseUnit,catalog_props.IsBase,catalog_props.FontIcon,catalog_props.IsFilterable,catalog_props.SortIndex,catalog_props.CatSortIndex,catalog_props.Hide,catalog_props.HideIndex,catalog_props.ImportID,catalog_props.ShowNumMods,catalog_props.Decl,catalog_props.Unit,catalog_props.Source,catalog_props.NumColumn FROM catalog_props WHERE IsFilterable != '' AND `GroupID` = ? AND catalog_props.HideIndex = ? ORDER BY catalog_props.SortIndex ASC, catalog_props.ID ASC [1, ] (0.32 ms.)

SELECT catalog_props_vals.ID,catalog_props_vals.PropID,catalog_props_vals.Val,catalog_props_vals.FilterVal,catalog_props_vals.Text,catalog_props_vals.Color,catalog_props_vals.IsDefault,catalog_props_vals.SortIndex,catalog_props_vals.ImportID,catalog_props_vals.Image,catalog_props_vals.Unit,catalog_props_vals.Code,catalog_props_vals.Price,catalog_props_vals.Currency,catalog_props_vals.HideInFilter,catalog_props_vals.Source FROM catalog_props_vals WHERE `PropID` = ? ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC [190] (0.35 ms.)

SELECT catalog_props_vals.ID,catalog_props_vals.PropID,catalog_props_vals.Val,catalog_props_vals.FilterVal,catalog_props_vals.Text,catalog_props_vals.Color,catalog_props_vals.IsDefault,catalog_props_vals.SortIndex,catalog_props_vals.ImportID,catalog_props_vals.Image,catalog_props_vals.Unit,catalog_props_vals.Code,catalog_props_vals.Price,catalog_props_vals.Currency,catalog_props_vals.HideInFilter,catalog_props_vals.Source FROM catalog_props_vals WHERE `PropID` = ? ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC [954] (9.61 ms.)

SELECT catalog_props_vals.ID,catalog_props_vals.PropID,catalog_props_vals.Val,catalog_props_vals.FilterVal,catalog_props_vals.Text,catalog_props_vals.Color,catalog_props_vals.IsDefault,catalog_props_vals.SortIndex,catalog_props_vals.ImportID,catalog_props_vals.Image,catalog_props_vals.Unit,catalog_props_vals.Code,catalog_props_vals.Price,catalog_props_vals.Currency,catalog_props_vals.HideInFilter,catalog_props_vals.Source FROM catalog_props_vals WHERE `PropID` = ? ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC [191] (0.23 ms.)

SELECT catalog_props.ID,catalog_props.Name,catalog_props.Code,catalog_props.Text,catalog_props.GroupID,catalog_props.Type,catalog_props.TypeFilter,catalog_props.IsModable,catalog_props.TypeParam,catalog_props.BaseUnit,catalog_props.IsBase,catalog_props.FontIcon,catalog_props.IsFilterable,catalog_props.SortIndex,catalog_props.CatSortIndex,catalog_props.Hide,catalog_props.HideIndex,catalog_props.ImportID,catalog_props.ShowNumMods,catalog_props.Decl,catalog_props.Unit,catalog_props.Source,catalog_props.NumColumn FROM catalog_props WHERE catalog_props.Code = ? LIMIT 1 [tsvet] (0.19 ms.)

SELECT catalog_props.ID,catalog_props.Name,catalog_props.Code,catalog_props.Text,catalog_props.GroupID,catalog_props.Type,catalog_props.TypeFilter,catalog_props.IsModable,catalog_props.TypeParam,catalog_props.BaseUnit,catalog_props.IsBase,catalog_props.FontIcon,catalog_props.IsFilterable,catalog_props.SortIndex,catalog_props.CatSortIndex,catalog_props.Hide,catalog_props.HideIndex,catalog_props.ImportID,catalog_props.ShowNumMods,catalog_props.Decl,catalog_props.Unit,catalog_props.Source,catalog_props.NumColumn FROM catalog_props WHERE catalog_props.Code = ? LIMIT 1 [razmer] (0.15 ms.)

SELECT catalog_props.ID,catalog_props.Name,catalog_props.Code,catalog_props.Text,catalog_props.GroupID,catalog_props.Type,catalog_props.TypeFilter,catalog_props.IsModable,catalog_props.TypeParam,catalog_props.BaseUnit,catalog_props.IsBase,catalog_props.FontIcon,catalog_props.IsFilterable,catalog_props.SortIndex,catalog_props.CatSortIndex,catalog_props.Hide,catalog_props.HideIndex,catalog_props.ImportID,catalog_props.ShowNumMods,catalog_props.Decl,catalog_props.Unit,catalog_props.Source,catalog_props.NumColumn FROM catalog_props WHERE catalog_props.Code = ? LIMIT 1 [tip_shlema] (0.17 ms.)

SELECT catalog_props_vals.ID,catalog_props_vals.PropID,catalog_props_vals.Val,catalog_props_vals.FilterVal,catalog_props_vals.Text,catalog_props_vals.Color,catalog_props_vals.IsDefault,catalog_props_vals.SortIndex,catalog_props_vals.ImportID,catalog_props_vals.Image,catalog_props_vals.Unit,catalog_props_vals.Code,catalog_props_vals.Price,catalog_props_vals.Currency,catalog_props_vals.HideInFilter,catalog_props_vals.Source FROM catalog_props_vals WHERE `PropID` = ? AND (catalog_props_vals.ID IN ('2883') OR catalog_props_vals.Code IN (?)) ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC [190, 2883] (0.24 ms.)

SELECT catalog_props_vals.ID,catalog_props_vals.PropID,catalog_props_vals.Val,catalog_props_vals.FilterVal,catalog_props_vals.Text,catalog_props_vals.Color,catalog_props_vals.IsDefault,catalog_props_vals.SortIndex,catalog_props_vals.ImportID,catalog_props_vals.Image,catalog_props_vals.Unit,catalog_props_vals.Code,catalog_props_vals.Price,catalog_props_vals.Currency,catalog_props_vals.HideInFilter,catalog_props_vals.Source FROM catalog_props_vals WHERE `PropID` = ? AND (catalog_props_vals.Code IN (?,?)) ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC [954, 2xl, l] (0.25 ms.)

SELECT catalog_props_vals.ID,catalog_props_vals.PropID,catalog_props_vals.Val,catalog_props_vals.FilterVal,catalog_props_vals.Text,catalog_props_vals.Color,catalog_props_vals.IsDefault,catalog_props_vals.SortIndex,catalog_props_vals.ImportID,catalog_props_vals.Image,catalog_props_vals.Unit,catalog_props_vals.Code,catalog_props_vals.Price,catalog_props_vals.Currency,catalog_props_vals.HideInFilter,catalog_props_vals.Source FROM catalog_props_vals WHERE `PropID` = ? AND (catalog_props_vals.Code IN (?,?)) ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC [191, integraly, otkrytye] (0.26 ms.)

SELECT DISTINCT catalog_models.ID FROM catalog_models INNER JOIN catalog_mods ON catalog_mods.ModelID = catalog_models.ID INNER JOIN catalog_stores_q ON catalog_stores_q.ModelID = catalog_models.ID AND catalog_stores_q.StoreID IN (331,334) WHERE catalog_models.CatID = ? AND catalog_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) AND catalog_models.Domains = ? AND catalog_models.HideIndex = ? AND catalog_stores_q.Q > 0 GROUP BY catalog_models.ID ORDER BY (SUM(catalog_stores_q.Q) > 0) DESC, catalog_models.StatusSortIndex ASC, catalog_models.NumModsAvailable DESC, catalog_models.SortIndex ASC, catalog_models.ID ASC LIMIT 0, 17 [827, , ] (7.66 ms.)

SELECT COUNT(DISTINCT catalog_models.ID) FROM catalog_models INNER JOIN catalog_mods ON catalog_mods.ModelID = catalog_models.ID LEFT JOIN catalog_stores_q ON catalog_stores_q.ModelID = catalog_models.ID AND catalog_stores_q.StoreID IN (331,334) WHERE catalog_models.CatID = ? AND catalog_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) AND catalog_models.Domains = ? AND catalog_models.HideIndex = ? AND catalog_stores_q.Q > 0 [827, , ] (7.59 ms.)

SELECT DISTINCT catalog_models.ID,catalog_models.CatID,catalog_models.TopCatID,catalog_models.Name,catalog_models.Code,catalog_models.BrandID,catalog_models.TopBrandID,catalog_models.Articul,catalog_models.BarCode,catalog_models.Weight,catalog_models.WeightBrutto,catalog_models.Volume,catalog_models.Length,catalog_models.Width,catalog_models.Height,catalog_models.BaseUnit,catalog_models.ModelType,catalog_models.Price,catalog_models.Currency,catalog_models.SortIndex,catalog_models.Image,catalog_models.Images,catalog_models.Images360,catalog_models.ImageMarketplace,catalog_models.ImageColorSample,catalog_models.Image3d,catalog_models.Status,catalog_models.StatusSortIndex,catalog_models.Props,catalog_models.Q,catalog_models.Mods,catalog_models.NumModsAvailable,catalog_models.NumParams,catalog_models.DiscountID,catalog_models.MaxDiscountQ,catalog_models.MinQ,catalog_models.Notice,catalog_models.Hide,catalog_models.Groups,catalog_models.NumBindings,catalog_models.NumComplects,catalog_models.BindCode,catalog_models.Code1C,catalog_models.ImportID,catalog_models.H,catalog_models.Title,catalog_models.Keywords,catalog_models.Description,catalog_models.YmlDisabled,catalog_models.Rss2Disabled,catalog_models.LocalDeliveryCost,catalog_models.PreOrderDaysMin,catalog_models.PreOrderDaysMax,catalog_models.Pickup,catalog_models.Delivery,catalog_models.DisableDelivery,catalog_models.Tags,catalog_models.NoIndex,catalog_models.Rating,catalog_models.Created,catalog_models.ModifiedDate,catalog_models.ModifiedBy,catalog_models.AcceptDate,catalog_models.NumComments,catalog_models.NumReviews,catalog_models.NumSales,catalog_models.MiniComment,catalog_models.CountryOriginID,catalog_models.SalesNotes,catalog_models.HideCat,catalog_models.HideBrand,catalog_models.HideIndex,catalog_models.SearchSyn,catalog_models.NumGifts,catalog_models.DigitalResID,catalog_models.Source,catalog_models.SourceID,catalog_models.SourceUrl,catalog_models.SourceName,catalog_models.SourceLogo,catalog_models.SourceUserID,catalog_models.SupplierID,catalog_models.Domains,catalog_models.Tnved,catalog_models.NumViews,catalog_models.MandatoryMarkExists FROM catalog_models INNER JOIN catalog_stores_q ON catalog_stores_q.ModelID = catalog_models.ID AND catalog_stores_q.StoreID IN (331,334) WHERE catalog_models.ID IN ('594130','593872','593133','723111','594152','583114') AND catalog_models.Domains = ? AND catalog_models.HideIndex = ? AND catalog_stores_q.Q > 0 ORDER BY FIELD(catalog_models.ID, 594130,593872,593133,723111,594152,583114) [, ] (1.18 ms.)

Helmets зеленые L 2XL интеграл открытый buy with delivery on Великобритании- price, reviews — partner-moto.ru
Время выполнения страницы: 793.37 ms
Время выполнения запросов к БД: 95.54 ms (из них долгих 80.53 ms 84%)
Всего запросов: 88
Пик памяти: 17.3353 mb
Дебаг: 0.32 ms (0.04%) вызвано 1 раз
Самые долгие запросы:
9.61 ms SELECT catalog_props_vals.ID,catalog_props_vals.PropID,catalog_props_vals.Val,catalog_props_vals.FilterVal,catalog_props_vals.Text,catalog_props_vals.Color,catalog_props_vals.IsDefault,catalog_props_vals.SortIndex,catalog_props_vals.ImportID,catalog_props_vals.Image,catalog_props_vals.Unit,catalog_props_vals.Code,catalog_props_vals.Price,catalog_props_vals.Currency,catalog_props_vals.HideInFilter,catalog_props_vals.Source FROM catalog_props_vals WHERE `PropID` = '954' ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC
7.66 ms SELECT DISTINCT catalog_models.ID FROM catalog_models INNER JOIN catalog_mods ON catalog_mods.ModelID = catalog_models.ID INNER JOIN catalog_stores_q ON catalog_stores_q.ModelID = catalog_models.ID AND catalog_stores_q.StoreID IN (331,334) WHERE catalog_models.CatID = '827' AND catalog_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) AND catalog_models.Domains = '' AND catalog_models.HideIndex = '' AND catalog_stores_q.Q > 0 GROUP BY catalog_models.ID ORDER BY (SUM(catalog_stores_q.Q) > 0) DESC, catalog_models.StatusSortIndex ASC, catalog_models.NumModsAvailable DESC, catalog_models.SortIndex ASC, catalog_models.ID ASC LIMIT 0, 17
7.59 ms SELECT COUNT(DISTINCT catalog_models.ID) FROM catalog_models INNER JOIN catalog_mods ON catalog_mods.ModelID = catalog_models.ID LEFT JOIN catalog_stores_q ON catalog_stores_q.ModelID = catalog_models.ID AND catalog_stores_q.StoreID IN (331,334) WHERE catalog_models.CatID = '827' AND catalog_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) AND catalog_models.Domains = '' AND catalog_models.HideIndex = '' AND catalog_stores_q.Q > 0
5.74 ms SELECT Section, Name, Content FROM config
4.71 ms SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = '181' AND catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
4.63 ms SELECT catalog_mods_params.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_mods_params INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_mods_params.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = '954' AND catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_mods_params.ValID ORDER BY filter_num DESC
4.35 ms SELECT DISTINCT BrandID, catalog_brands.Parent, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_fast_models INNER JOIN catalog_brands ON catalog_brands.ID = catalog_fast_models.BrandID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) AND BrandID > 0 AND (catalog_brands.Domains = '' OR FIND_IN_SET('76', catalog_brands.Domains)) AND catalog_brands.Hide = '' GROUP BY BrandID ORDER BY BrandID DESC
4.12 ms SELECT COUNT(DISTINCT catalog_fast_models.ID) FROM catalog_fast_models LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID INNER JOIN catalog_stores_q ON catalog_stores_q.ModelID = catalog_fast_models.ID AND catalog_stores_q.StoreID IN (331,334) WHERE ((catalog_models_to_groups.GroupID = 63 OR (Mods > 1 AND NumModsAvailable > 0 AND NumModsAvailable <= 1)) AND catalog_models_to_groups.GroupID != 33) AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) AND catalog_fast_models.Domains = '' AND catalog_stores_q.Q > 0
3.93 ms SELECT DISTINCT GroupID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_fast_models INNER JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID INNER JOIN catalog_groups ON catalog_groups.ID = catalog_models_to_groups.GroupID WHERE catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) AND catalog_groups.Code NOT REGEXP '\/|\:' AND GroupID > 0 GROUP BY GroupID
3.63 ms SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = '190' AND catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
3.41 ms SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = '967' AND catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
3.36 ms SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = '227' AND catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
3.31 ms SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = '184' AND catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
3.27 ms SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = '1034' AND catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
3.26 ms SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = '226' AND catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
3.13 ms SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = '191' AND catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '827' AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
2.09 ms SELECT FieldName, Text FROM lang_values WHERE TableName = 'config' AND Lang = 'en' AND Domain IN (0, '76') ORDER BY Domain DESC
1.18 ms SELECT DISTINCT catalog_models.ID,catalog_models.CatID,catalog_models.TopCatID,catalog_models.Name,catalog_models.Code,catalog_models.BrandID,catalog_models.TopBrandID,catalog_models.Articul,catalog_models.BarCode,catalog_models.Weight,catalog_models.WeightBrutto,catalog_models.Volume,catalog_models.Length,catalog_models.Width,catalog_models.Height,catalog_models.BaseUnit,catalog_models.ModelType,catalog_models.Price,catalog_models.Currency,catalog_models.SortIndex,catalog_models.Image,catalog_models.Images,catalog_models.Images360,catalog_models.ImageMarketplace,catalog_models.ImageColorSample,catalog_models.Image3d,catalog_models.Status,catalog_models.StatusSortIndex,catalog_models.Props,catalog_models.Q,catalog_models.Mods,catalog_models.NumModsAvailable,catalog_models.NumParams,catalog_models.DiscountID,catalog_models.MaxDiscountQ,catalog_models.MinQ,catalog_models.Notice,catalog_models.Hide,catalog_models.Groups,catalog_models.NumBindings,catalog_models.NumComplects,catalog_models.BindCode,catalog_models.Code1C,catalog_models.ImportID,catalog_models.H,catalog_models.Title,catalog_models.Keywords,catalog_models.Description,catalog_models.YmlDisabled,catalog_models.Rss2Disabled,catalog_models.LocalDeliveryCost,catalog_models.PreOrderDaysMin,catalog_models.PreOrderDaysMax,catalog_models.Pickup,catalog_models.Delivery,catalog_models.DisableDelivery,catalog_models.Tags,catalog_models.NoIndex,catalog_models.Rating,catalog_models.Created,catalog_models.ModifiedDate,catalog_models.ModifiedBy,catalog_models.AcceptDate,catalog_models.NumComments,catalog_models.NumReviews,catalog_models.NumSales,catalog_models.MiniComment,catalog_models.CountryOriginID,catalog_models.SalesNotes,catalog_models.HideCat,catalog_models.HideBrand,catalog_models.HideIndex,catalog_models.SearchSyn,catalog_models.NumGifts,catalog_models.DigitalResID,catalog_models.Source,catalog_models.SourceID,catalog_models.SourceUrl,catalog_models.SourceName,catalog_models.SourceLogo,catalog_models.SourceUserID,catalog_models.SupplierID,catalog_models.Domains,catalog_models.Tnved,catalog_models.NumViews,catalog_models.MandatoryMarkExists FROM catalog_models INNER JOIN catalog_stores_q ON catalog_stores_q.ModelID = catalog_models.ID AND catalog_stores_q.StoreID IN (331,334) WHERE catalog_models.ID IN ('594130','593872','593133','723111','594152','583114') AND catalog_models.Domains = '' AND catalog_models.HideIndex = '' AND catalog_stores_q.Q > 0 ORDER BY FIELD(catalog_models.ID, 594130,593872,593133,723111,594152,583114)
0.82 ms SELECT catalog_prices.ID,catalog_prices.TypeID,catalog_prices.Price,catalog_prices.Currency,catalog_prices.Resource,catalog_prices.ResourceID,catalog_prices.CatSortIndex,catalog_prices.StoreID FROM catalog_prices WHERE `Resource` = 'iModel' AND ResourceID IN ('594130','593872','593133','723111','594152','592317','583114') AND StoreID IN (331, 0) ORDER BY catalog_prices.CatSortIndex ASC, catalog_prices.TypeID ASC, catalog_prices.StoreID ASC
0.73 ms SELECT DISTINCT catalog_models.ID,catalog_models.CatID,catalog_models.TopCatID,catalog_models.Name,catalog_models.Code,catalog_models.BrandID,catalog_models.TopBrandID,catalog_models.Articul,catalog_models.BarCode,catalog_models.Weight,catalog_models.WeightBrutto,catalog_models.Volume,catalog_models.Length,catalog_models.Width,catalog_models.Height,catalog_models.BaseUnit,catalog_models.ModelType,catalog_models.Price,catalog_models.Currency,catalog_models.SortIndex,catalog_models.Image,catalog_models.Images,catalog_models.Images360,catalog_models.ImageMarketplace,catalog_models.ImageColorSample,catalog_models.Image3d,catalog_models.Status,catalog_models.StatusSortIndex,catalog_models.Props,catalog_models.Q,catalog_models.Mods,catalog_models.NumModsAvailable,catalog_models.NumParams,catalog_models.DiscountID,catalog_models.MaxDiscountQ,catalog_models.MinQ,catalog_models.Notice,catalog_models.Hide,catalog_models.Groups,catalog_models.NumBindings,catalog_models.NumComplects,catalog_models.BindCode,catalog_models.Code1C,catalog_models.ImportID,catalog_models.H,catalog_models.Title,catalog_models.Keywords,catalog_models.Description,catalog_models.YmlDisabled,catalog_models.Rss2Disabled,catalog_models.LocalDeliveryCost,catalog_models.PreOrderDaysMin,catalog_models.PreOrderDaysMax,catalog_models.Pickup,catalog_models.Delivery,catalog_models.DisableDelivery,catalog_models.Tags,catalog_models.NoIndex,catalog_models.Rating,catalog_models.Created,catalog_models.ModifiedDate,catalog_models.ModifiedBy,catalog_models.AcceptDate,catalog_models.NumComments,catalog_models.NumReviews,catalog_models.NumSales,catalog_models.MiniComment,catalog_models.CountryOriginID,catalog_models.SalesNotes,catalog_models.HideCat,catalog_models.HideBrand,catalog_models.HideIndex,catalog_models.SearchSyn,catalog_models.NumGifts,catalog_models.DigitalResID,catalog_models.Source,catalog_models.SourceID,catalog_models.SourceUrl,catalog_models.SourceName,catalog_models.SourceLogo,catalog_models.SourceUserID,catalog_models.SupplierID,catalog_models.Domains,catalog_models.Tnved,catalog_models.NumViews,catalog_models.MandatoryMarkExists FROM catalog_models LEFT JOIN catalog_stores_q ON catalog_stores_q.ModelID = catalog_models.ID AND catalog_stores_q.StoreID = 331 WHERE `ModelType` = 'fantom' AND (catalog_stores_q.Q IS NULL OR catalog_stores_q.Q > 0) AND CatID NOT IN (827,1338) AND catalog_models.Domains = '' AND catalog_models.HideIndex = '' ORDER BY RAND() LIMIT 1
For example,  backpack
For example,  backpack
Call back
professional advice
without days mon-sun 11: 00-21:00

SELECT catalog_events.ID,catalog_events.Name,catalog_events.Image,catalog_events.Created,catalog_events.IP FROM catalog_events ORDER BY ID DESC LIMIT 4 [] (0.19 ms.)

SELECT lang_values.ID,lang_values.TableName,lang_values.FieldName,lang_values.TableID,lang_values.Text,lang_values.Lang,lang_values.Domain FROM lang_values WHERE `TableName` = ? AND `TableID` = ? AND `Lang` = ? AND lang_values.Domain IN (0, 76) [catalog_events, 41632641, en] (0.27 ms.)

SELECT DISTINCT GroupID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_fast_models INNER JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID INNER JOIN catalog_groups ON catalog_groups.ID = catalog_models_to_groups.GroupID WHERE catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) AND catalog_groups.Code NOT REGEXP '\/|\:' AND GroupID > 0 GROUP BY GroupID [, 827] (3.93 ms.)

SELECT COUNT(DISTINCT catalog_fast_models.ID) FROM catalog_fast_models LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID INNER JOIN catalog_stores_q ON catalog_stores_q.ModelID = catalog_fast_models.ID AND catalog_stores_q.StoreID IN (331,334) WHERE ((catalog_models_to_groups.GroupID = 63 OR (Mods > 1 AND NumModsAvailable > 0 AND NumModsAvailable <= 1)) AND catalog_models_to_groups.GroupID != 33) AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) AND catalog_fast_models.Domains = ? AND catalog_stores_q.Q > 0 [827, ] (4.12 ms.)

SELECT DISTINCT BrandID, catalog_brands.Parent, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_fast_models INNER JOIN catalog_brands ON catalog_brands.ID = catalog_fast_models.BrandID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) AND BrandID > 0 AND (catalog_brands.Domains = '' OR FIND_IN_SET('76', catalog_brands.Domains)) AND catalog_brands.Hide = ? GROUP BY BrandID ORDER BY BrandID DESC [, 827, ] (4.35 ms.)

SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [190, , 827] (3.63 ms.)

SELECT catalog_props_vals.ID,catalog_props_vals.PropID,catalog_props_vals.Val,catalog_props_vals.FilterVal,catalog_props_vals.Text,catalog_props_vals.Color,catalog_props_vals.IsDefault,catalog_props_vals.SortIndex,catalog_props_vals.ImportID,catalog_props_vals.Image,catalog_props_vals.Unit,catalog_props_vals.Code,catalog_props_vals.Price,catalog_props_vals.Currency,catalog_props_vals.HideInFilter,catalog_props_vals.Source FROM catalog_props_vals WHERE catalog_props_vals.ID IN ('2924','2876','2912','3695','3690','3350','2909','2883','3386','3691','2896','3694','2892','3686','2898','2915','2874','2880','3696','3692','3688','3689','3067','2903') ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC [] (0.29 ms.)

SELECT catalog_mods_params.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_mods_params INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_mods_params.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_mods_params.ValID ORDER BY filter_num DESC [954, , 827] (4.63 ms.)

SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [181, , 827] (4.71 ms.)

SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [184, , 827] (3.31 ms.)

SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [191, , 827] (3.13 ms.)

SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [226, , 827] (3.26 ms.)

SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [227, , 827] (3.36 ms.)

SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [967, , 827] (3.41 ms.)

SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 190 AND catalog_props_values.ValID IN (2883)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408,2412)) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 191 AND catalog_props_values.ValID IN (1988,1990)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [1034, , 827] (3.27 ms.)

SELECT catalog_props_vals.ID,catalog_props_vals.PropID,catalog_props_vals.Val,catalog_props_vals.FilterVal,catalog_props_vals.Text,catalog_props_vals.Color,catalog_props_vals.IsDefault,catalog_props_vals.SortIndex,catalog_props_vals.ImportID,catalog_props_vals.Image,catalog_props_vals.Unit,catalog_props_vals.Code,catalog_props_vals.Price,catalog_props_vals.Currency,catalog_props_vals.HideInFilter,catalog_props_vals.Source FROM catalog_props_vals WHERE catalog_props_vals.ID IN ('3353','3141','3634','3633','4579','4578','4565','4708','3632','4568','3204','3208','3207','3352','3179','3139','3140','3142','3178') ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC [] (0.26 ms.)

Filter products

Helmets зеленые L 2XL интеграл открытый

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q INNER JOIN catalog_stores ON catalog_stores.ID = catalog_stores_q.StoreID WHERE `ModelID` = ? AND catalog_stores.Hide = ? AND `IsSale` = ? ORDER BY catalog_stores.IsSale DESC, catalog_stores.SortIndex ASC, catalog_stores.ID ASC [594130, , on] (0.25 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q INNER JOIN catalog_stores ON catalog_stores.ID = catalog_stores_q.StoreID WHERE `ModelID` = ? AND catalog_stores.Hide = ? AND `IsSale` = ? ORDER BY catalog_stores.IsSale DESC, catalog_stores.SortIndex ASC, catalog_stores.ID ASC [593872, , on] (0.19 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q INNER JOIN catalog_stores ON catalog_stores.ID = catalog_stores_q.StoreID WHERE `ModelID` = ? AND catalog_stores.Hide = ? AND `IsSale` = ? ORDER BY catalog_stores.IsSale DESC, catalog_stores.SortIndex ASC, catalog_stores.ID ASC [593133, , on] (0.17 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q INNER JOIN catalog_stores ON catalog_stores.ID = catalog_stores_q.StoreID WHERE `ModelID` = ? AND catalog_stores.Hide = ? AND `IsSale` = ? ORDER BY catalog_stores.IsSale DESC, catalog_stores.SortIndex ASC, catalog_stores.ID ASC [723111, , on] (0.2 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q INNER JOIN catalog_stores ON catalog_stores.ID = catalog_stores_q.StoreID WHERE `ModelID` = ? AND catalog_stores.Hide = ? AND `IsSale` = ? ORDER BY catalog_stores.IsSale DESC, catalog_stores.SortIndex ASC, catalog_stores.ID ASC [594152, , on] (0.17 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q INNER JOIN catalog_stores ON catalog_stores.ID = catalog_stores_q.StoreID WHERE `ModelID` = ? AND catalog_stores.Hide = ? AND `IsSale` = ? ORDER BY catalog_stores.IsSale DESC, catalog_stores.SortIndex ASC, catalog_stores.ID ASC [583114, , on] (0.21 ms.)

SELECT DISTINCT catalog_models.ID,catalog_models.CatID,catalog_models.TopCatID,catalog_models.Name,catalog_models.Code,catalog_models.BrandID,catalog_models.TopBrandID,catalog_models.Articul,catalog_models.BarCode,catalog_models.Weight,catalog_models.WeightBrutto,catalog_models.Volume,catalog_models.Length,catalog_models.Width,catalog_models.Height,catalog_models.BaseUnit,catalog_models.ModelType,catalog_models.Price,catalog_models.Currency,catalog_models.SortIndex,catalog_models.Image,catalog_models.Images,catalog_models.Images360,catalog_models.ImageMarketplace,catalog_models.ImageColorSample,catalog_models.Image3d,catalog_models.Status,catalog_models.StatusSortIndex,catalog_models.Props,catalog_models.Q,catalog_models.Mods,catalog_models.NumModsAvailable,catalog_models.NumParams,catalog_models.DiscountID,catalog_models.MaxDiscountQ,catalog_models.MinQ,catalog_models.Notice,catalog_models.Hide,catalog_models.Groups,catalog_models.NumBindings,catalog_models.NumComplects,catalog_models.BindCode,catalog_models.Code1C,catalog_models.ImportID,catalog_models.H,catalog_models.Title,catalog_models.Keywords,catalog_models.Description,catalog_models.YmlDisabled,catalog_models.Rss2Disabled,catalog_models.LocalDeliveryCost,catalog_models.PreOrderDaysMin,catalog_models.PreOrderDaysMax,catalog_models.Pickup,catalog_models.Delivery,catalog_models.DisableDelivery,catalog_models.Tags,catalog_models.NoIndex,catalog_models.Rating,catalog_models.Created,catalog_models.ModifiedDate,catalog_models.ModifiedBy,catalog_models.AcceptDate,catalog_models.NumComments,catalog_models.NumReviews,catalog_models.NumSales,catalog_models.MiniComment,catalog_models.CountryOriginID,catalog_models.SalesNotes,catalog_models.HideCat,catalog_models.HideBrand,catalog_models.HideIndex,catalog_models.SearchSyn,catalog_models.NumGifts,catalog_models.DigitalResID,catalog_models.Source,catalog_models.SourceID,catalog_models.SourceUrl,catalog_models.SourceName,catalog_models.SourceLogo,catalog_models.SourceUserID,catalog_models.SupplierID,catalog_models.Domains,catalog_models.Tnved,catalog_models.NumViews,catalog_models.MandatoryMarkExists FROM catalog_models LEFT JOIN catalog_stores_q ON catalog_stores_q.ModelID = catalog_models.ID AND catalog_stores_q.StoreID = 331 WHERE `ModelType` = ? AND (catalog_stores_q.Q IS NULL OR catalog_stores_q.Q > 0) AND CatID NOT IN (827,1338) AND catalog_models.Domains = ? AND catalog_models.HideIndex = ? ORDER BY RAND() LIMIT 1 [fantom, , ] (0.73 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q WHERE `ModelID` = ? AND `ModID` = ? AND `StoreID` = ? ORDER BY catalog_stores_q.ID DESC LIMIT 1 [594130, 0, 331] (0.11 ms.)

SELECT catalog_prices.ID,catalog_prices.TypeID,catalog_prices.Price,catalog_prices.Currency,catalog_prices.Resource,catalog_prices.ResourceID,catalog_prices.CatSortIndex,catalog_prices.StoreID FROM catalog_prices WHERE `TypeID` = ? AND `Resource` = ? AND `ResourceID` = ? AND `StoreID` = ? ORDER BY catalog_prices.CatSortIndex ASC, catalog_prices.TypeID ASC, catalog_prices.StoreID ASC LIMIT 1 [1, iModel, 594130, 331] (0.13 ms.)

SELECT user_filters.ID,user_filters.Gender,user_filters.Groups,user_filters.UserIDs,user_filters.MinAge,user_filters.MaxAge,user_filters.LocationID,user_filters.Was,user_filters.Resource,user_filters.ResourceID FROM user_filters WHERE `Resource` = ? AND `ResourceID` = ? ORDER BY ID ASC LIMIT 1 [iDiscount, 89] (0.13 ms.)

SELECT user_filters.ID,user_filters.Gender,user_filters.Groups,user_filters.UserIDs,user_filters.MinAge,user_filters.MaxAge,user_filters.LocationID,user_filters.Was,user_filters.Resource,user_filters.ResourceID FROM user_filters WHERE `Resource` = ? AND `ResourceID` = ? ORDER BY ID ASC LIMIT 1 [iDiscount, 79] (0.11 ms.)

SELECT catalog_prices.ID,catalog_prices.TypeID,catalog_prices.Price,catalog_prices.Currency,catalog_prices.Resource,catalog_prices.ResourceID,catalog_prices.CatSortIndex,catalog_prices.StoreID FROM catalog_prices WHERE `Resource` = ? AND ResourceID IN ('594130','593872','593133','723111','594152','592317','583114') AND StoreID IN (331, 0) ORDER BY catalog_prices.CatSortIndex ASC, catalog_prices.TypeID ASC, catalog_prices.StoreID ASC [iModel] (0.82 ms.)

SELECT payment_promocodes_cats.ID,payment_promocodes_cats.Name,payment_promocodes_cats.DiscountID,payment_promocodes_cats.Discount,payment_promocodes_cats.Bonus,payment_promocodes_cats.Every,payment_promocodes_cats.MinSum,payment_promocodes_cats.ShowPrice,payment_promocodes_cats.PriceTemplate FROM payment_promocodes_cats WHERE ShowPrice != '' ORDER BY ID ASC [] (0.19 ms.)

SELECT catalog_props_values.ID,catalog_props_values.ModelID,catalog_props_values.PropID,catalog_props_values.ValID,catalog_props_values.Val,catalog_props_values.Price,catalog_props_values.Currency,GroupID FROM catalog_props_values INNER JOIN catalog_props ON catalog_props.ID=catalog_props_values.PropID WHERE `ModelID` = ? AND `IsModable` = ? AND `IsBase` = ? AND catalog_props.HideIndex = ? GROUP BY catalog_props.ID ORDER BY catalog_props.CatSortIndex ASC, GroupID ASC, catalog_props.SortIndex ASC, catalog_props.ID ASC [594130, , important, ] (0.26 ms.)

SELECT catalog_props.ID, catalog_props.ID as PropID, COUNT(DISTINCT ValID) as num, GROUP_CONCAT(DISTINCT catalog_props_vals.Val ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC SEPARATOR '^^' ) as names FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID INNER JOIN catalog_props_vals ON catalog_mods_params.ValID = catalog_props_vals.ID INNER JOIN catalog_props ON catalog_props.ID = catalog_mods_params.PropID WHERE catalog_mods_params.ModelID = ? AND `ShowNumMods` = ? AND catalog_mods.Status = ? GROUP BY catalog_props.ID [594130, on, 1] (0.32 ms.)

SELECT catalog_auto_images.ID,catalog_auto_images.Image,catalog_auto_images.Cats,catalog_auto_images.NoSubCats,catalog_auto_images.Brands,catalog_auto_images.Redefine,catalog_auto_images.PropID,catalog_auto_images.ValsIDs,catalog_auto_images.SortIndex,catalog_auto_images.Hide,catalog_auto_images.Domains FROM catalog_auto_images WHERE (((FIND_IN_SET('827', Cats) OR FIND_IN_SET('1338', Cats)) AND (FIND_IN_SET('11604', Brands))) OR ((FIND_IN_SET('827', Cats) OR FIND_IN_SET('1338', Cats)) AND Brands = '') OR ((FIND_IN_SET('11604', Brands)) AND Cats = '')) AND (catalog_auto_images.Domains = '' OR FIND_IN_SET('76', catalog_auto_images.Domains)) AND catalog_auto_images.Hide = ? ORDER BY catalog_auto_images.SortIndex ASC, catalog_auto_images.ID ASC [] (0.34 ms.)

SELECT catalog_props_values.ID,catalog_props_values.ModelID,catalog_props_values.PropID,catalog_props_values.ValID,catalog_props_values.Val,catalog_props_values.Price,catalog_props_values.Currency FROM catalog_props_values LEFT JOIN catalog_props_vals ON catalog_props_vals.ID = catalog_props_values.ValID WHERE `ModelID` = ? AND catalog_props_values.PropID = ? ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.ID ASC [594130, 967] (0.26 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q WHERE `ModelID` = ? AND `ModID` = ? AND `StoreID` = ? ORDER BY catalog_stores_q.ID DESC LIMIT 1 [593872, 0, 331] (0.13 ms.)

SELECT catalog_prices.ID,catalog_prices.TypeID,catalog_prices.Price,catalog_prices.Currency,catalog_prices.Resource,catalog_prices.ResourceID,catalog_prices.CatSortIndex,catalog_prices.StoreID FROM catalog_prices WHERE `TypeID` = ? AND `Resource` = ? AND `ResourceID` = ? AND `StoreID` = ? ORDER BY catalog_prices.CatSortIndex ASC, catalog_prices.TypeID ASC, catalog_prices.StoreID ASC LIMIT 1 [1, iModel, 593872, 331] (0.17 ms.)

SELECT catalog_props_values.ID,catalog_props_values.ModelID,catalog_props_values.PropID,catalog_props_values.ValID,catalog_props_values.Val,catalog_props_values.Price,catalog_props_values.Currency,GroupID FROM catalog_props_values INNER JOIN catalog_props ON catalog_props.ID=catalog_props_values.PropID WHERE `ModelID` = ? AND `IsModable` = ? AND `IsBase` = ? AND catalog_props.HideIndex = ? GROUP BY catalog_props.ID ORDER BY catalog_props.CatSortIndex ASC, GroupID ASC, catalog_props.SortIndex ASC, catalog_props.ID ASC [593872, , important, ] (0.26 ms.)

SELECT catalog_props.ID, catalog_props.ID as PropID, COUNT(DISTINCT ValID) as num, GROUP_CONCAT(DISTINCT catalog_props_vals.Val ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC SEPARATOR '^^' ) as names FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID INNER JOIN catalog_props_vals ON catalog_mods_params.ValID = catalog_props_vals.ID INNER JOIN catalog_props ON catalog_props.ID = catalog_mods_params.PropID WHERE catalog_mods_params.ModelID = ? AND `ShowNumMods` = ? AND catalog_mods.Status = ? GROUP BY catalog_props.ID [593872, on, 1] (0.33 ms.)

SELECT catalog_auto_images.ID,catalog_auto_images.Image,catalog_auto_images.Cats,catalog_auto_images.NoSubCats,catalog_auto_images.Brands,catalog_auto_images.Redefine,catalog_auto_images.PropID,catalog_auto_images.ValsIDs,catalog_auto_images.SortIndex,catalog_auto_images.Hide,catalog_auto_images.Domains FROM catalog_auto_images WHERE (((FIND_IN_SET('827', Cats) OR FIND_IN_SET('1338', Cats)) AND (FIND_IN_SET('9307', Brands))) OR ((FIND_IN_SET('827', Cats) OR FIND_IN_SET('1338', Cats)) AND Brands = '') OR ((FIND_IN_SET('9307', Brands)) AND Cats = '')) AND (catalog_auto_images.Domains = '' OR FIND_IN_SET('76', catalog_auto_images.Domains)) AND catalog_auto_images.Hide = ? ORDER BY catalog_auto_images.SortIndex ASC, catalog_auto_images.ID ASC [] (0.28 ms.)

SELECT catalog_props_values.ID,catalog_props_values.ModelID,catalog_props_values.PropID,catalog_props_values.ValID,catalog_props_values.Val,catalog_props_values.Price,catalog_props_values.Currency FROM catalog_props_values LEFT JOIN catalog_props_vals ON catalog_props_vals.ID = catalog_props_values.ValID WHERE `ModelID` = ? AND catalog_props_values.PropID = ? ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.ID ASC [593872, 967] (0.25 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q WHERE `ModelID` = ? AND `ModID` = ? AND `StoreID` = ? ORDER BY catalog_stores_q.ID DESC LIMIT 1 [593133, 0, 331] (0.14 ms.)

SELECT catalog_prices.ID,catalog_prices.TypeID,catalog_prices.Price,catalog_prices.Currency,catalog_prices.Resource,catalog_prices.ResourceID,catalog_prices.CatSortIndex,catalog_prices.StoreID FROM catalog_prices WHERE `TypeID` = ? AND `Resource` = ? AND `ResourceID` = ? AND `StoreID` = ? ORDER BY catalog_prices.CatSortIndex ASC, catalog_prices.TypeID ASC, catalog_prices.StoreID ASC LIMIT 1 [1, iModel, 593133, 331] (0.12 ms.)

SELECT user_filters.ID,user_filters.Gender,user_filters.Groups,user_filters.UserIDs,user_filters.MinAge,user_filters.MaxAge,user_filters.LocationID,user_filters.Was,user_filters.Resource,user_filters.ResourceID FROM user_filters WHERE `Resource` = ? AND `ResourceID` = ? ORDER BY ID ASC LIMIT 1 [iDiscount, 34] (0.14 ms.)

SELECT Price FROM catalog_prices WHERE `TypeID` = ? AND `Resource` = ? AND `ResourceID` = ? AND StoreID IN (331, 0) [14, iModel, 593133] (0.34 ms.)

SELECT catalog_props_values.ID,catalog_props_values.ModelID,catalog_props_values.PropID,catalog_props_values.ValID,catalog_props_values.Val,catalog_props_values.Price,catalog_props_values.Currency,GroupID FROM catalog_props_values INNER JOIN catalog_props ON catalog_props.ID=catalog_props_values.PropID WHERE `ModelID` = ? AND `IsModable` = ? AND `IsBase` = ? AND catalog_props.HideIndex = ? GROUP BY catalog_props.ID ORDER BY catalog_props.CatSortIndex ASC, GroupID ASC, catalog_props.SortIndex ASC, catalog_props.ID ASC [593133, , important, ] (0.28 ms.)

SELECT catalog_props.ID, catalog_props.ID as PropID, COUNT(DISTINCT ValID) as num, GROUP_CONCAT(DISTINCT catalog_props_vals.Val ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC SEPARATOR '^^' ) as names FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID INNER JOIN catalog_props_vals ON catalog_mods_params.ValID = catalog_props_vals.ID INNER JOIN catalog_props ON catalog_props.ID = catalog_mods_params.PropID WHERE catalog_mods_params.ModelID = ? AND `ShowNumMods` = ? AND catalog_mods.Status = ? GROUP BY catalog_props.ID [593133, on, 1] (0.31 ms.)

SELECT alternative_meta_tags.ID,alternative_meta_tags.Resource,alternative_meta_tags.ResourceID,alternative_meta_tags.Type,alternative_meta_tags.Content,alternative_meta_tags.Source FROM alternative_meta_tags WHERE `Resource` = ? AND `ResourceID` = ? [iModel, 593133] (0.22 ms.)

SELECT lang_values.ID,lang_values.TableName,lang_values.FieldName,lang_values.TableID,lang_values.Text,lang_values.Lang,lang_values.Domain FROM lang_values WHERE `TableName` = ? AND TableID IN (9663,9662,9661) AND `Domain` = ? AND lang_values.Domain IN (0, 76) [alternative_meta_tags, 76] (0.49 ms.)

SELECT catalog_props_values.ID,catalog_props_values.ModelID,catalog_props_values.PropID,catalog_props_values.ValID,catalog_props_values.Val,catalog_props_values.Price,catalog_props_values.Currency FROM catalog_props_values LEFT JOIN catalog_props_vals ON catalog_props_vals.ID = catalog_props_values.ValID WHERE `ModelID` = ? AND catalog_props_values.PropID = ? ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.ID ASC [593133, 967] (0.25 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q WHERE `ModelID` = ? AND `ModID` = ? AND `StoreID` = ? ORDER BY catalog_stores_q.ID DESC LIMIT 1 [723111, 0, 331] (0.13 ms.)

SELECT ModelID, GROUP_CONCAT(DISTINCT ModID) FROM shop_notifies WHERE SessionID = '' GROUP BY ModelID [] (0.17 ms.)

SELECT catalog_prices.ID,catalog_prices.TypeID,catalog_prices.Price,catalog_prices.Currency,catalog_prices.Resource,catalog_prices.ResourceID,catalog_prices.CatSortIndex,catalog_prices.StoreID FROM catalog_prices WHERE `TypeID` = ? AND `Resource` = ? AND `ResourceID` = ? AND `StoreID` = ? ORDER BY catalog_prices.CatSortIndex ASC, catalog_prices.TypeID ASC, catalog_prices.StoreID ASC LIMIT 1 [1, iModel, 723111, 331] (0.14 ms.)

SELECT catalog_props_values.ID,catalog_props_values.ModelID,catalog_props_values.PropID,catalog_props_values.ValID,catalog_props_values.Val,catalog_props_values.Price,catalog_props_values.Currency,GroupID FROM catalog_props_values INNER JOIN catalog_props ON catalog_props.ID=catalog_props_values.PropID WHERE `ModelID` = ? AND `IsModable` = ? AND `IsBase` = ? AND catalog_props.HideIndex = ? GROUP BY catalog_props.ID ORDER BY catalog_props.CatSortIndex ASC, GroupID ASC, catalog_props.SortIndex ASC, catalog_props.ID ASC [723111, , important, ] (0.26 ms.)

SELECT catalog_props.ID, catalog_props.ID as PropID, COUNT(DISTINCT ValID) as num, GROUP_CONCAT(DISTINCT catalog_props_vals.Val ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC SEPARATOR '^^' ) as names FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID INNER JOIN catalog_props_vals ON catalog_mods_params.ValID = catalog_props_vals.ID INNER JOIN catalog_props ON catalog_props.ID = catalog_mods_params.PropID WHERE catalog_mods_params.ModelID = ? AND `ShowNumMods` = ? AND catalog_mods.Status = ? GROUP BY catalog_props.ID [723111, on, 1] (0.3 ms.)

SELECT catalog_props_values.ID,catalog_props_values.ModelID,catalog_props_values.PropID,catalog_props_values.ValID,catalog_props_values.Val,catalog_props_values.Price,catalog_props_values.Currency FROM catalog_props_values LEFT JOIN catalog_props_vals ON catalog_props_vals.ID = catalog_props_values.ValID WHERE `ModelID` = ? AND catalog_props_values.PropID = ? ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.ID ASC [723111, 967] (0.21 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q WHERE `ModelID` = ? AND `ModID` = ? AND `StoreID` = ? ORDER BY catalog_stores_q.ID DESC LIMIT 1 [594152, 0, 331] (0.12 ms.)

SELECT catalog_prices.ID,catalog_prices.TypeID,catalog_prices.Price,catalog_prices.Currency,catalog_prices.Resource,catalog_prices.ResourceID,catalog_prices.CatSortIndex,catalog_prices.StoreID FROM catalog_prices WHERE `TypeID` = ? AND `Resource` = ? AND `ResourceID` = ? AND `StoreID` = ? ORDER BY catalog_prices.CatSortIndex ASC, catalog_prices.TypeID ASC, catalog_prices.StoreID ASC LIMIT 1 [1, iModel, 594152, 331] (0.16 ms.)

SELECT Price FROM catalog_prices WHERE `TypeID` = ? AND `Resource` = ? AND `ResourceID` = ? AND StoreID IN (331, 0) [14, iModel, 594152] (0.24 ms.)

SELECT catalog_props_values.ID,catalog_props_values.ModelID,catalog_props_values.PropID,catalog_props_values.ValID,catalog_props_values.Val,catalog_props_values.Price,catalog_props_values.Currency,GroupID FROM catalog_props_values INNER JOIN catalog_props ON catalog_props.ID=catalog_props_values.PropID WHERE `ModelID` = ? AND `IsModable` = ? AND `IsBase` = ? AND catalog_props.HideIndex = ? GROUP BY catalog_props.ID ORDER BY catalog_props.CatSortIndex ASC, GroupID ASC, catalog_props.SortIndex ASC, catalog_props.ID ASC [594152, , important, ] (0.26 ms.)

SELECT catalog_props.ID, catalog_props.ID as PropID, COUNT(DISTINCT ValID) as num, GROUP_CONCAT(DISTINCT catalog_props_vals.Val ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC SEPARATOR '^^' ) as names FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID INNER JOIN catalog_props_vals ON catalog_mods_params.ValID = catalog_props_vals.ID INNER JOIN catalog_props ON catalog_props.ID = catalog_mods_params.PropID WHERE catalog_mods_params.ModelID = ? AND `ShowNumMods` = ? AND catalog_mods.Status = ? GROUP BY catalog_props.ID [594152, on, 1] (0.3 ms.)

SELECT catalog_prices.ID,catalog_prices.TypeID,catalog_prices.Price,catalog_prices.Currency,catalog_prices.Resource,catalog_prices.ResourceID,catalog_prices.CatSortIndex,catalog_prices.StoreID FROM catalog_prices WHERE `TypeID` = ? AND `Resource` = ? AND `ResourceID` = ? AND `StoreID` = ? ORDER BY catalog_prices.CatSortIndex ASC, catalog_prices.TypeID ASC, catalog_prices.StoreID ASC LIMIT 1 [1, iModel, 592317, 331] (0.14 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q INNER JOIN catalog_stores ON catalog_stores.ID = catalog_stores_q.StoreID WHERE `ModelID` = ? AND catalog_stores.Hide = ? AND `IsSale` = ? ORDER BY catalog_stores.IsSale DESC, catalog_stores.SortIndex ASC, catalog_stores.ID ASC [592317, , on] (0.17 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q WHERE `ModelID` = ? AND `ModID` = ? AND `StoreID` = ? ORDER BY catalog_stores_q.ID DESC LIMIT 1 [592317, 0, 331] (0.11 ms.)

SELECT catalog_props_values.ID,catalog_props_values.ModelID,catalog_props_values.PropID,catalog_props_values.ValID,catalog_props_values.Val,catalog_props_values.Price,catalog_props_values.Currency,GroupID FROM catalog_props_values INNER JOIN catalog_props ON catalog_props.ID=catalog_props_values.PropID WHERE `ModelID` = ? AND `IsModable` = ? AND `IsBase` = ? AND catalog_props.HideIndex = ? GROUP BY catalog_props.ID ORDER BY catalog_props.CatSortIndex ASC, GroupID ASC, catalog_props.SortIndex ASC, catalog_props.ID ASC [592317, , important, ] (0.22 ms.)

SELECT catalog_props.ID, catalog_props.ID as PropID, COUNT(DISTINCT ValID) as num, GROUP_CONCAT(DISTINCT catalog_props_vals.Val ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC SEPARATOR '^^' ) as names FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID INNER JOIN catalog_props_vals ON catalog_mods_params.ValID = catalog_props_vals.ID INNER JOIN catalog_props ON catalog_props.ID = catalog_mods_params.PropID WHERE catalog_mods_params.ModelID = ? AND `ShowNumMods` = ? AND catalog_mods.Status = ? GROUP BY catalog_props.ID [592317, on, 1] (0.23 ms.)

SELECT catalog_auto_images.ID,catalog_auto_images.Image,catalog_auto_images.Cats,catalog_auto_images.NoSubCats,catalog_auto_images.Brands,catalog_auto_images.Redefine,catalog_auto_images.PropID,catalog_auto_images.ValsIDs,catalog_auto_images.SortIndex,catalog_auto_images.Hide,catalog_auto_images.Domains FROM catalog_auto_images WHERE (((FIND_IN_SET('0', Cats)) AND (FIND_IN_SET('0', Brands))) OR ((FIND_IN_SET('0', Cats)) AND Brands = '') OR ((FIND_IN_SET('0', Brands)) AND Cats = '')) AND (catalog_auto_images.Domains = '' OR FIND_IN_SET('76', catalog_auto_images.Domains)) AND catalog_auto_images.Hide = ? ORDER BY catalog_auto_images.SortIndex ASC, catalog_auto_images.ID ASC [] (0.24 ms.)

SELECT catalog_stores_q.ID,catalog_stores_q.StoreID,catalog_stores_q.ModelID,catalog_stores_q.ModID,catalog_stores_q.Q,catalog_stores_q.Qreserved,catalog_stores_q.Created,catalog_stores_q.ModifiedDate FROM catalog_stores_q WHERE `ModelID` = ? AND `ModID` = ? AND `StoreID` = ? ORDER BY catalog_stores_q.ID DESC LIMIT 1 [583114, 0, 331] (0.11 ms.)

SELECT catalog_prices.ID,catalog_prices.TypeID,catalog_prices.Price,catalog_prices.Currency,catalog_prices.Resource,catalog_prices.ResourceID,catalog_prices.CatSortIndex,catalog_prices.StoreID FROM catalog_prices WHERE `TypeID` = ? AND `Resource` = ? AND `ResourceID` = ? AND `StoreID` = ? ORDER BY catalog_prices.CatSortIndex ASC, catalog_prices.TypeID ASC, catalog_prices.StoreID ASC LIMIT 1 [1, iModel, 583114, 331] (0.13 ms.)

SELECT Price FROM catalog_prices WHERE `TypeID` = ? AND `Resource` = ? AND `ResourceID` = ? AND StoreID IN (331, 0) [14, iModel, 583114] (0.22 ms.)

SELECT catalog_props_values.ID,catalog_props_values.ModelID,catalog_props_values.PropID,catalog_props_values.ValID,catalog_props_values.Val,catalog_props_values.Price,catalog_props_values.Currency,GroupID FROM catalog_props_values INNER JOIN catalog_props ON catalog_props.ID=catalog_props_values.PropID WHERE `ModelID` = ? AND `IsModable` = ? AND `IsBase` = ? AND catalog_props.HideIndex = ? GROUP BY catalog_props.ID ORDER BY catalog_props.CatSortIndex ASC, GroupID ASC, catalog_props.SortIndex ASC, catalog_props.ID ASC [583114, , important, ] (0.27 ms.)

SELECT catalog_props.ID, catalog_props.ID as PropID, COUNT(DISTINCT ValID) as num, GROUP_CONCAT(DISTINCT catalog_props_vals.Val ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC SEPARATOR '^^' ) as names FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID INNER JOIN catalog_props_vals ON catalog_mods_params.ValID = catalog_props_vals.ID INNER JOIN catalog_props ON catalog_props.ID = catalog_mods_params.PropID WHERE catalog_mods_params.ModelID = ? AND `ShowNumMods` = ? AND catalog_mods.Status = ? GROUP BY catalog_props.ID [583114, on, 1] (0.42 ms.)

SELECT seo_url_meta_tags.ID,seo_url_meta_tags.Url,seo_url_meta_tags.H,seo_url_meta_tags.Title,seo_url_meta_tags.Keywords,seo_url_meta_tags.Description,seo_url_meta_tags.Domains,seo_url_meta_tags.Canonical FROM seo_url_meta_tags WHERE `Url` = ? AND (seo_url_meta_tags.Domains = '' OR FIND_IN_SET('76', seo_url_meta_tags.Domains)) LIMIT 1 [/category/motoshlem/s-tsvet-2883/s-razmer-2xl-or-l/s-tip_shlema-integraly-or-otkrytye/] (0.18 ms.)

Filter products
Frequently asked questions on Helmets
How do I choose a helmet size?

The first and only rule by which you can immediately understand your size or not – it should fit snugly at all points on the head (forehead, nape, cheeks). Fit snugly, but don't push. Open the visor, stand in the helmet for 2-3 minutes, if it sits tightly and does not create any pain – this is your size. Keep in mind that in the process of using the pillows a little crush and it will be a little freer. If you choose a helmet remotely, on the page with any motorcycle helmet, click "Find your size" and follow the size selection wizard. For online orders, returns and exchanges are also valid.

How reliable are the helmets you sell?
Absolutely all the helmets that we sell have passed the mandatory strict European certification according to the standard ECE22.05R, and ICON helmets meet simultaneously 4 safety standards (DOT FMVSS 218-USA, ECE 22-05 – Europe, SAI AS1698 – Australia and PSC – Japan), which indicates their exceptional reliability. Certified helmet, will not split in half and most effectively disperse the impact and protect.
Why I have the size of the one, and all helmets sit on ways?
The fact that the reference patterns of all manufacturers are different. The same size index, for example M, from different manufacturers may have a different fit. Moreover, different manufacturers produce helmets for different markets and different head shapes. Therefore, when buying a new helmet, do not be guided only by the size of the previous helmet of another brand. Always measure your head in centimeters and select according to the manufacturer's size table. Master size selection on our website will help.
What type of helmet clasp is better?
There are two types of fasteners: ratchet and 2D ring. 2D ring is considered the most reliable, because it can not unbutton itself in an emergency, only this type of fasteners on helmets has access to professional competitions and Championships.
without days mon-sun 11: 00-21:00