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

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

SELECT FieldName, Text FROM lang_values WHERE TableName = 'config' AND Lang = 'ru' AND Domain IN (0, '72') ORDER BY Domain DESC [] (4.69 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 `Code` = ? AND `CategoryID` = ? AND `BrandID` = ? AND `GroupID` = ? ORDER BY catalog_named_filters.CatSortIndex ASC, NamedFilterGroupID ASC, catalog_named_filters.SortIndex ASC, catalog_named_filters.ID ASC LIMIT 1 [s-razmer-l, 875, 0, 0] (0.53 ms.)

SELECT config_meta_tags.ID,config_meta_tags.ClassName,config_meta_tags.Title,config_meta_tags.Keywords,config_meta_tags.Description,config_meta_tags.Name,config_meta_tags.Domains,config_meta_tags.Sitemap,config_meta_tags.NoIndex FROM config_meta_tags WHERE `ClassName` = ? AND (config_meta_tags.Domains = '' OR FIND_IN_SET('72', config_meta_tags.Domains)) ORDER BY Domains DESC LIMIT 1 [iPage] (0.4 ms.)

SELECT adv_groups_fields_values.ID,adv_groups_fields_values.Resource,adv_groups_fields_values.ResourceID,adv_groups_fields_values.FieldID,adv_groups_fields_values.Content FROM adv_groups_fields_values WHERE `Resource` = ? AND `ResourceID` = ? [iAdvObject, 444] (0.13 ms.)

SELECT adv_groups_fields_values.ID,adv_groups_fields_values.Resource,adv_groups_fields_values.ResourceID,adv_groups_fields_values.FieldID,adv_groups_fields_values.Content FROM adv_groups_fields_values WHERE `Resource` = ? AND `ResourceID` = ? [iAdvObject, 564] (0.1 ms.)

SELECT adv_groups_fields_values.ID,adv_groups_fields_values.Resource,adv_groups_fields_values.ResourceID,adv_groups_fields_values.FieldID,adv_groups_fields_values.Content FROM adv_groups_fields_values WHERE `Resource` = ? AND `ResourceID` = ? [iAdvGroup, 2] (0.1 ms.)

SELECT static_texts.ID,static_texts.CatID,static_texts.Code,static_texts.Text,static_texts.Hide FROM static_texts WHERE static_texts.Code = ? LIMIT 1 [NO] (0.16 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/motoekipirovka/s-proizvoditel-caberg/s-tsvet-2924/s-razmer-l/] (0.38 ms.)

SELECT payment_currencies.ID, payment_currencies.Name, payment_currencies.Code, payment_currencies.CodeNumeric, payment_currencies.Code1C, payment_currencies.Gendec, payment_currencies.CentGendec, payment_currencies.Round, payment_currencies.SeparateBy, payment_currencies.AddSpaces, payment_currencies.Format, payment_currencies.FormatGraph, payment_currencies.IsBase, payment_currencies.Rate, payment_currencies.RateYML, payment_currencies.ModifiedDate FROM payment_currencies WHERE payment_currencies.ID = 5 LIMIT 1 [] (0.31 ms.)

SELECT payment_currencies.ID, payment_currencies.Name, payment_currencies.Code, payment_currencies.CodeNumeric, payment_currencies.Code1C, payment_currencies.Gendec, payment_currencies.CentGendec, payment_currencies.Round, payment_currencies.SeparateBy, payment_currencies.AddSpaces, payment_currencies.Format, payment_currencies.FormatGraph, payment_currencies.IsBase, payment_currencies.Rate, payment_currencies.RateYML, payment_currencies.ModifiedDate FROM payment_currencies WHERE payment_currencies.ID = 1 LIMIT 1 [] (0.24 ms.)

SELECT catalog_statuses.ID,catalog_statuses.Name,catalog_statuses.Color,catalog_statuses.ButtonColor,catalog_statuses.ButtonAction,catalog_statuses.ButtonText,catalog_statuses.ButtonTextAfter,catalog_statuses.ButtonTitle,catalog_statuses.ButtonTitleAfter,catalog_statuses.ButtonClass,catalog_statuses.ButtonOnClick,catalog_statuses.IsDefault,catalog_statuses.Notice,catalog_statuses.SortIndex,catalog_statuses.Domains,catalog_statuses.ItemAvailability,catalog_statuses.SalesNotes FROM catalog_statuses WHERE catalog_statuses.Domains != '' AND NOT FIND_IN_SET('72', catalog_statuses.Domains) ORDER BY ID ASC [] (0.38 ms.)

SELECT catalog_brands.ID,catalog_brands.Parent,catalog_brands.Name,catalog_brands.Code,catalog_brands.LocationID,catalog_brands.CountryOriginID,catalog_brands.Image,catalog_brands.H,catalog_brands.SortIndex,catalog_brands.Hide,catalog_brands.DiscountID,catalog_brands.Title,catalog_brands.Keywords,catalog_brands.Description,catalog_brands.NoIndex,catalog_brands.ModelTitleTemplate,catalog_brands.ModelDescriptionTemplate,catalog_brands.ModelH1Template,catalog_brands.Domains,catalog_brands.ImportID,catalog_brands.SalesNotes,catalog_brands.BrandWarranty,catalog_brands.NumModels,catalog_brands.NumModelsRaw,catalog_brands.NumModelsCp,catalog_brands.ModifiedDate,catalog_brands.SearchSyn,catalog_brands.PriceList,catalog_brands.PresentationID,catalog_brands.Images,catalog_brands.NumBindings,catalog_brands.NumGifts,catalog_brands.NaToStatus,catalog_brands.NaToStatusDiscountID,catalog_brands.Source,catalog_brands.LocalDeliveryCost FROM catalog_brands WHERE (catalog_brands.Code IN (?)) AND (catalog_brands.Domains = '' OR FIND_IN_SET('72', catalog_brands.Domains)) ORDER BY catalog_brands.SortIndex ASC, catalog_brands.Name ASC, catalog_brands.ID ASC [caberg] (0.28 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.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 `PropID` = ? ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC [954] (5.95 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.2 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_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 ('2924') OR catalog_props_vals.Code IN (?)) ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC [190, 2924] (0.21 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, l] (0.18 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) 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 [875, , ] (0.53 ms.)

Мотоэкипировка Caberg черные L купить с доставкой по Астане- цена, отзывы — partner-moto.ru
Время выполнения страницы: 484.17 ms
Время выполнения запросов к БД: 46.51 ms (из них долгих 38.68 ms 83%)
Всего запросов: 57
Пик памяти: 11.8522 mb
Дебаг: 0 ms (0%) вызвано 0 раз
Самые долгие запросы:
13.22 ms SELECT Section, Name, Content FROM config
5.95 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
4.69 ms SELECT FieldName, Text FROM lang_values WHERE TableName = 'config' AND Lang = 'ru' AND Domain IN (0, '72') ORDER BY Domain DESC
3.02 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.TopCatID = '875' 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 (2924)) 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)) AND BrandID > 0 AND (catalog_brands.Domains = '' OR FIND_IN_SET('72', catalog_brands.Domains)) AND catalog_brands.Hide = '' GROUP BY BrandID ORDER BY BrandID DESC
1.1 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` = 'alternative_meta_tags' AND TableID IN (10525,10524,7856,7851,7852,7853) AND `Domain` = '72' AND lang_values.Domain IN (0, 72)
0.95 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.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) AND catalog_groups.Code NOT REGEXP '\/|\:' AND GroupID > 0 GROUP BY GroupID
0.76 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 = '1069' AND catalog_fast_models.Domains = '' AND catalog_fast_models.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.75 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 = '240' AND catalog_fast_models.Domains = '' AND catalog_fast_models.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.73 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.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) AND catalog_fast_models.Domains = '' AND catalog_stores_q.Q > 0
0.73 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.TopCatID = '875' AND (TopBrandID IN (11786)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.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 = '236' AND catalog_fast_models.Domains = '' AND catalog_fast_models.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.7 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.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.69 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.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.69 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.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.68 ms SELECT COUNT(DISTINCT catalog_fast_models.ID) FROM catalog_fast_models 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_fast_models.TopCatID = '875' AND DATEDIFF(CURRENT_DATE, DATE(catalog_fast_models.Created)) <= 30 AND (TopBrandID IN (11786)) 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 (2924)) 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)) AND catalog_fast_models.Domains = '' AND catalog_stores_q.Q > 0
0.68 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 = '237' AND catalog_fast_models.Domains = '' AND catalog_fast_models.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.68 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.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.66 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.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.65 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.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.64 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.TopCatID = '875' AND (TopBrandID IN (11786)) 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 (2924)) GROUP BY catalog_mods_params.ValID ORDER BY filter_num DESC
Обратный звонок
профессиональная консультация
Казахстан, Нур-Султан (Астана), ул. Сыганак, 19, 1
без выходных пн-вс 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.15 ms.)

SELECT catalog_seo_filters.ID,catalog_seo_filters.CategoryID,catalog_seo_filters.BrandID,catalog_seo_filters.GroupID,catalog_seo_filters.Props,catalog_seo_filters.Hide,catalog_seo_filters.H,catalog_seo_filters.Title,catalog_seo_filters.Keywords,catalog_seo_filters.Description FROM catalog_seo_filters WHERE `CategoryID` = ? AND `Props` = ? AND catalog_seo_filters.Hide = ? LIMIT 1 [875, 190,954,s-proizvoditel, ] (0.13 ms.)

SELECT catalog_filter_pages.ID,catalog_filter_pages.H1,catalog_filter_pages.Title,catalog_filter_pages.Keywords,catalog_filter_pages.Description,catalog_filter_pages.Text,catalog_filter_pages.Resource,catalog_filter_pages.ResourceID,catalog_filter_pages.Lang,catalog_filter_pages.Type,catalog_filter_pages.Domain FROM catalog_filter_pages WHERE `Resource` = ? AND `ResourceID` = ? AND `Type` = ? AND catalog_filter_pages.Domain IN (0, 72) ORDER BY catalog_filter_pages.Domain DESC LIMIT 1 [iCatalogCategory, 875, filter] (0.13 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, 72) [catalog_brands, 11786, ru] (0.3 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) AND catalog_groups.Code NOT REGEXP '\/|\:' AND GroupID > 0 GROUP BY GroupID [, 875] (0.95 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) AND catalog_fast_models.Domains = ? AND catalog_stores_q.Q > 0 [875, ] (0.73 ms.)

SELECT COUNT(DISTINCT catalog_fast_models.ID) FROM catalog_fast_models 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_fast_models.TopCatID = ? AND DATEDIFF(CURRENT_DATE, DATE(catalog_fast_models.Created)) <= 30 AND (TopBrandID IN (11786)) 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 (2924)) 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)) AND catalog_fast_models.Domains = ? AND catalog_stores_q.Q > 0 [875, ] (0.68 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.TopCatID = ? 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 (2924)) 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)) AND BrandID > 0 AND (catalog_brands.Domains = '' OR FIND_IN_SET('72', catalog_brands.Domains)) AND catalog_brands.Hide = ? GROUP BY BrandID ORDER BY BrandID DESC [, 875, ] (3.02 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 `CategoryID` = ? AND catalog_named_filters.HideIndex = ? ORDER BY catalog_named_filters.CatSortIndex ASC, NamedFilterGroupID ASC, catalog_named_filters.SortIndex ASC, catalog_named_filters.ID ASC [875, ] (0.2 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.TopCatID = ? AND (TopBrandID IN (11786)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [190, , 875] (0.73 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) GROUP BY catalog_mods_params.ValID ORDER BY filter_num DESC [954, , 875] (0.64 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [181, , 875] (0.69 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [184, , 875] (0.66 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [226, , 875] (0.7 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [227, , 875] (0.65 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [231, , 875] (0.42 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [236, , 875] (0.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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [237, , 875] (0.68 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [240, , 875] (0.75 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [967, , 875] (0.69 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [1034, , 875] (0.68 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.TopCatID = ? AND (TopBrandID IN (11786)) 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 (2924)) 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)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [1069, , 875] (0.76 ms.)

Фильтр товаров
  • Цена
  • Группа
  • Бренд
  • Цвет
  • Размер
  • Материал
  • Пол
  • Сезон
  • Стандарты сертификации
  • Водоотталкивающие свойства
  • Вид обуви
  • Длина перчаток
  • Вид защиты
  • Особенности
  • Модель
  • Серия

Мотоэкипировка бренда Caberg черные L

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` = ? [iCatalogCategory, 875] (0.21 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 (10525,10524,7856,7851,7852,7853) AND `Domain` = ? AND lang_values.Domain IN (0, 72) [alternative_meta_tags, 72] (1.1 ms.)

SELECT config_meta_tags.ID,config_meta_tags.ClassName,config_meta_tags.Title,config_meta_tags.Keywords,config_meta_tags.Description,config_meta_tags.Name,config_meta_tags.Domains,config_meta_tags.Sitemap,config_meta_tags.NoIndex FROM config_meta_tags WHERE `ClassName` = ? AND (config_meta_tags.Domains = '' OR FIND_IN_SET('72', config_meta_tags.Domains)) ORDER BY Domains DESC LIMIT 1 [iCatalogCategory] (0.22 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 [/astana/category/motoekipirovka/s-proizvoditel-caberg/] (0.17 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 `CategoryID` = ? AND catalog_named_filters.HideIndex = ? ORDER BY catalog_named_filters.CatSortIndex ASC, NamedFilterGroupID ASC, catalog_named_filters.SortIndex ASC, catalog_named_filters.ID ASC [875, ] (0.22 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('72', seo_url_meta_tags.Domains)) LIMIT 1 [/astana/category/motoekipirovka/s-proizvoditel-caberg/s-tsvet-2924/s-razmer-l/] (0.1 ms.)

SELECT `Text` FROM seo_url_meta_tags WHERE ID = '0' LIMIT 1 [] (0.05 ms.)

SELECT `Notice` FROM catalog_actions WHERE ID = '24' LIMIT 1 [] (0.06 ms.)

Скидка первосезонникам
Если твоим правам категории А меньше 1 года, приезжай в Партнер-Мото и получи дополнительную скидку 5% на мотоэкипировку.
Фильтр товаров
Не найдено товаров
без выходных пн-вс 11:00-21:00