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

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

SELECT FieldName, Text FROM lang_values WHERE TableName = 'config' AND Lang = 'en' AND Domain IN (0, '76') ORDER BY Domain DESC [] (2.81 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-white_red_blue, 783, 0, 0] (0.28 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.12 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/motoboty/group-novinki-2020/s-razmer-white_red_blue/] (0.18 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('76', catalog_statuses.Domains) ORDER BY ID ASC [] (0.15 ms.)

SELECT COUNT(DISTINCT catalog_models.ID) 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.CatID = ? AND catalog_models.Domains = ? AND catalog_models.HideIndex = ? AND catalog_stores_q.Q > 0 [783, , ] (15.14 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 = 3 LIMIT 1 [] (0.14 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.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` = ? ORDER BY catalog_props_vals.SortIndex ASC, catalog_props_vals.Val ASC, catalog_props_vals.ID ASC [954] (7.8 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.19 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, white_red_blue] (0.16 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_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 (4631)) 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 [783, , ] (0.48 ms.)

Motorboats (motor shoes) WHITE/RED/BLUE buy with delivery on Великобритании- price, reviews — partner-moto.ru
Время выполнения страницы: 574.83 ms
Время выполнения запросов к БД: 56.46 ms (из них долгих 54.08 ms 96%)
Всего запросов: 39
Пик памяти: 14.0222 mb
Дебаг: 0 ms (0%) вызвано 0 раз
Самые долгие запросы:
15.48 ms SELECT COUNT(DISTINCT catalog_models.ID) 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.CatID = '783' AND catalog_models.Domains = '' AND catalog_models.HideIndex = '' AND catalog_stores_q.Q > 0
15.14 ms SELECT COUNT(DISTINCT catalog_models.ID) 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.CatID = '783' AND catalog_models.Domains = '' AND catalog_models.HideIndex = '' AND catalog_stores_q.Q > 0
7.8 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
6.63 ms SELECT Section, Name, Content FROM config
2.81 ms SELECT FieldName, Text FROM lang_values WHERE TableName = 'config' AND Lang = 'en' AND Domain IN (0, '76') ORDER BY Domain DESC
0.53 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.CatID = '783' 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.52 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 = '783' 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 (4631)) AND catalog_groups.Code NOT REGEXP '\/|\:' AND GroupID > 0 GROUP BY GroupID
0.51 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 = '783' 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.49 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 = '783' 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 (4631)) AND catalog_fast_models.Domains = '' AND catalog_stores_q.Q > 0
0.48 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 = '783' 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 (4631)) 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
0.48 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 = '783' 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 (4631)) 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
0.48 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 = '783' 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.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 = '226' AND catalog_fast_models.Domains = '' AND catalog_fast_models.CatID = '783' 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.4 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.CatID = '783' AND DATEDIFF(CURRENT_DATE, DATE(catalog_fast_models.Created)) <= 30 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 (4631)) AND catalog_fast_models.Domains = '' AND catalog_stores_q.Q > 0
0.4 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 = '783' 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.37 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.CatID = '783' 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.34 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` = 'catalog_events' AND `TableID` = '41632222' AND `Lang` = 'en' AND lang_values.Domain IN (0, 76)
0.34 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 = '783' 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
0.28 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` = 's-razmer-white_red_blue' AND `CategoryID` = '783' AND `BrandID` = '0' AND `GroupID` = '0' ORDER BY catalog_named_filters.CatSortIndex ASC, NamedFilterGroupID ASC, catalog_named_filters.SortIndex ASC, catalog_named_filters.ID ASC LIMIT 1
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 = 'razmer' LIMIT 1
For example,  case
For example,  case
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.17 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, 41632222, en] (0.34 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 [783, 954, ] (0.13 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_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 (4631)) AND catalog_groups.Code NOT REGEXP '\/|\:' AND GroupID > 0 GROUP BY GroupID [, 783] (0.52 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_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 (4631)) AND catalog_fast_models.Domains = ? AND catalog_stores_q.Q > 0 [783, ] (0.49 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.CatID = ? AND DATEDIFF(CURRENT_DATE, DATE(catalog_fast_models.Created)) <= 30 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 (4631)) AND catalog_fast_models.Domains = ? AND catalog_stores_q.Q > 0 [783, ] (0.4 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_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 (4631)) 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 [, 783, ] (0.48 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [190, , 783] (0.51 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [181, , 783] (0.4 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [184, , 783] (0.48 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [226, , 783] (0.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_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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [236, , 783] (0.53 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [967, , 783] (0.34 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 (4631)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC [1069, , 783] (0.37 ms.)

Filter products
  • Price
  • Group
  • Brand
  • Color
  • Size
  • Material
  • Gender
  • Season
  • Type of footwear
  • Features
  • combine on one card

Motorboats (motor shoes) WHITE/RED/BLUE

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, 783] (0.17 ms.)

SELECT COUNT(DISTINCT catalog_models.ID) 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.CatID = ? AND catalog_models.Domains = ? AND catalog_models.HideIndex = ? AND catalog_stores_q.Q > 0 [783, , ] (15.48 ms.)

SELECT `Notice` FROM catalog_cats WHERE ID = '783' LIMIT 1 [] (0.12 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/motoboty/group-novinki-2020/s-razmer-white_red_blue/] (0.14 ms.)

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

without days mon-sun 11: 00-21:00