| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `RecordsPackage`.`id`, `RecordsPackage`.`main_records_id`, `RecordsPackage`.`records_id`, `RecordsPackage`.`index`, `RecordsPackage`.`amount`, `RecordsPackage`.`priority`, `RecordsPackage`.`auto_add_description`, `RecordsPackage`.`auto_add_photos`, `RecordsPackage`.`auto_add_features` FROM `baltrade_hurtnew`.`records_packages` AS `RecordsPackage` WHERE `RecordsPackage`.`main_records_id` IN (19144, 20486, 21443, 21444, 21752, 21993, 21994, 22119, 22259, 22261, 22262) ORDER BY `RecordsPackage`.`priority` asc | 0 | 0 | 0 | |
| SELECT `RecordsBox`.`id`, `RecordsBox`.`records_id`, `RecordsBox`.`barcode`, `RecordsBox`.`amount`, `RecordsBox`.`synchro_blocked`, `RecordsBox`.`display_state` FROM `baltrade_hurtnew`.`records_boxes` AS `RecordsBox` WHERE `RecordsBox`.`display_state` < 1 AND `RecordsBox`.`records_id` IN (19144, 20486, 21443, 21444, 21752, 21993, 21994, 22119, 22259, 22261, 22262) ORDER BY `RecordsBox`.`amount` ASC, `RecordsBox`.`barcode` ASC | 0 | 0 | 0 | |
| SELECT `Promo`.`id`, `Promo`.`percent`, `Promo`.`name`, `Promo`.`url_code`, `Promo`.`description`, `Promo`.`date_start`, `Promo`.`date_end`, `Promo`.`is_global`, `Promo`.`hidden`, `Promo`.`promo_type`, `Promo`.`is_for_registered`, `Promo`.`allow_user_activation`, `Promo`.`uses_limit`, `Promo`.`used_count`, `Promo`.`is_used`, `Promo`.`mingain`, `Promo`.`virtual`, `Promo`.`used_amount`, `Promo`.`popup_display`, `Promo`.`popups_id`, `Promo`.`mingain_type`, `Promo`.`percent_safe`, `Promo`.`percent_safe_from_margin`, `Promo`.`show_wholesale`, `Promo`.`units_min`, `Promo`.`turnover_lastmonth_min`, `Promo`.`allow_any_payment`, `Promo`.`auto_activated`, `Promo`.`url_address`, `Promo`.`is_for_newsletter_active_email`, `Promo`.`generate_aliases_for_newsletter_emails`, `Promo`.`affiliate_comission`, `Promo`.`affiliate_users_id`, `Promo`.`priority_group`, `Promo`.`deleted`, `Promo`.`shippings_free_shipping_min_condition`, `Promo`.`payments_additional_cost_per_transaction_condition`, `Promo`.`basket_products_sum_min`, `Promo`.`display_ending_info`, `Promo`.`shops_id`, `Promo`.`is_external`, `Promo`.`external_id`, `Promo`.`promo_terms_description`, `Promo`.`gifts_units_limit`, `Promo`.`gifts_products_limit`, `PromosRecord`.`id`, `PromosRecord`.`records_id`, `PromosRecord`.`promos_id`, `PromosRecord`.`percent`, `PromosRecord`.`promo_type`, `PromosRecord`.`units_min`, `PromosRecord`.`turnover_lastmonth_min`, `PromosRecord`.`created`, `PromosRecord`.`modified`, `PromosRecord`.`basket_products_sum_min` FROM `baltrade_hurtnew`.`promos` AS `Promo` JOIN `baltrade_hurtnew`.`promos_records` AS `PromosRecord` ON (`PromosRecord`.`records_id` IN (19144, 20486, 21443, 21444, 21752, 21993, 21994, 22119, 22259, 22261, 22262) AND `PromosRecord`.`promos_id` = `Promo`.`id`) | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information`, `CategoriesRecord`.`id`, `CategoriesRecord`.`categories_id`, `CategoriesRecord`.`records_id`, `CategoriesRecord`.`number`, `CategoriesRecord`.`priority`, `CategoriesRecord`.`override_priority` FROM `baltrade_hurtnew`.`categories` AS `Category` JOIN `baltrade_hurtnew`.`categories_records` AS `CategoriesRecord` ON (`CategoriesRecord`.`records_id` IN (19144, 20486, 21443, 21444, 21752, 21993, 21994, 22119, 22259, 22261, 22262) AND `CategoriesRecord`.`categories_id` = `Category`.`id`) | 13 | 13 | 0 | |
| SELECT `VariantsGroup`.`id`, `VariantsGroup`.`is_visible`, `VariantsGroup`.`name`, `RecordsVariant`.`id`, `RecordsVariant`.`records_id`, `RecordsVariant`.`variants_groups_id`, `RecordsVariant`.`priority` FROM `baltrade_hurtnew`.`variants_groups` AS `VariantsGroup` JOIN `baltrade_hurtnew`.`records_variants` AS `RecordsVariant` ON (`RecordsVariant`.`records_id` IN (19144, 20486, 21443, 21444, 21752, 21993, 21994, 22119, 22259, 22261, 22262) AND `RecordsVariant`.`variants_groups_id` = `VariantsGroup`.`id`) WHERE `VariantsGroup`.`is_visible` = '1' | 0 | 0 | 0 | |
| SELECT `TaxRate`.`id`, `TaxRate`.`tax_rate_percent` FROM `baltrade_hurtnew`.`tax_rates` AS `TaxRate` WHERE 1 = 1 ORDER BY `display_priority` asc | 5 | 5 | 0 | |
| SELECT `Country`.`id`, `Country`.`title`, `Country`.`approved`, `Country`.`date_created`, `Country`.`author_created`, `Country`.`author_created_text`, `Country`.`date_modified`, `Country`.`author_modified`, `Country`.`author_modified_text`, `Country`.`deleted`, `Country`.`isdefault`, `Country`.`symbol`, `Country`.`is_eu_member` FROM `baltrade_hurtnew`.`countries` AS `Country` WHERE `isdefault` = '1' AND `deleted` = '0' AND `approved` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`lft`, `Category`.`rght` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE `Category`.`id` = 3375 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 2375 AND `Category`.`rght` >= 2376 ORDER BY `Category`.`lft` asc | 3 | 3 | 0 | |
| SELECT `BannersSlide`.`id`, `BannersSlide`.`title`, `BannersSlide`.`description`, `BannersSlide`.`is_hidden`, `BannersSlide`.`place`, `BannersSlide`.`place_for_events`, `BannersSlide`.`records_id`, `BannersSlide`.`priority`, `BannersSlide`.`languages_id`, `BannersSlide`.`name`, `BannersSlide`.`type`, `BannersSlide`.`promos_id`, `BannersSlide`.`parameters`, `BannersSlide`.`hidden_for_users_std`, `BannersSlide`.`hidden_for_users_wholesale`, `BannersSlide`.`limit_date_from`, `BannersSlide`.`date_from`, `BannersSlide`.`limit_date_to`, `BannersSlide`.`date_to`, `BannersSlide`.`categories_id`, `BannersSlide`.`file_url_big`, `BannersSlide`.`file_url_small`, `BannersSlide`.`url_additional`, `BannersSlide`.`file_title`, `BannersSlide`.`file_alt`, `BannersSlide`.`class_additional`, `Record`.`id`, `Record`.`users_id`, `Record`.`producers_id`, `Record`.`title`, `Record`.`title_h1`, `Record`.`shorttitle`, `Record`.`description`, `Record`.`shortdescription`, `Record`.`active`, `Record`.`onmainpage`, `Record`.`priority`, `Record`.`keywords`, `Record`.`opinions_off`, `Record`.`price`, `Record`.`app_id`, `Record`.`shipping_promo`, `Record`.`in_promotion`, `Record`.`vat`, `Record`.`is_hit`, `Record`.`is_new`, `Record`.`is_outlet`, `Record`.`product_of_the_day`, `Record`.`units`, `Record`.`banner_desc`, `Record`.`max_promo`, `Record`.`provider_price`, `Record`.`price2`, `Record`.`price3`, `Record`.`weight`, `Record`.`newsletter_desc`, `Record`.`box_items`, `Record`.`box_items_name`, `Record`.`unlimited_units`, `Record`.`warranty_time`, `Record`.`warranty_description`, `Record`.`availabilities_id`, `Record`.`times_bought`, `Record`.`created`, `Record`.`model`, `Record`.`ceneo_id`, `Record`.`wholesale`, `Record`.`min_margin`, `Record`.`grade`, `Record`.`traders_id`, `Record`.`EAN`, `Record`.`master_EAN`, `Record`.`producer_code`, `Record`.`master_producer_code`, `Record`.`additional_text`, `Record`.`metadescription`, `Record`.`metakeywords`, `Record`.`site_title`, `Record`.`fbtitle`, `Record`.`fbdescription`, `Record`.`ceneo_group_id`, `Record`.`fake_price`, `Record`.`modified`, `Record`.`visits`, `Record`.`per_item`, `Record`.`master_weight`, `Record`.`packages_num`, `Record`.`type`, `Record`.`order_minvalue_required`, `Record`.`order_minvalue_value`, `Record`.`enable_common_records`, `Record`.`active_change_estimated`, `Record`.`active_notes`, `Record`.`active_change_reason`, `Record`.`compatibles_name`, `Record`.`models_name`, `Record`.`active_change_user_id`, `Record`.`active_change_user_name`, `Record`.`active_change_date`, `Record`.`force_availability`, `Record`.`forced_availabilities_id`, `Record`.`special_type`, `Record`.`price4`, `Record`.`price5`, `Record`.`price6`, `Record`.`price7`, `Record`.`force_export_original`, `Record`.`visible`, `Record`.`price_update`, `Record`.`modified_users_id`, `Record`.`prodimporters_id`, `Record`.`description2`, `Record`.`price8`, `Record`.`price9`, `Record`.`price10`, `Record`.`class_name`, `Record`.`popups_id`, `Record`.`google_category_id`, `Record`.`shopee_category_id`, `Record`.`introdescription`, `Record`.`hidden_for_wholesale`, `Record`.`shippings_pricelists_id`, `Record`.`old_description_format`, `Record`.`offer_not_ready`, `Record`.`seo_do_not_index`, `Record`.`max_units_per_order`, `Record`.`additional_order_notification_emails`, `Record`.`send_notification_if_ordered`, `Record`.`dimensions_length`, `Record`.`dimensions_width`, `Record`.`dimensions_height`, `Record`.`points_calculation_type`, `Record`.`points_multiplier`, `Record`.`points_fixed_amount`, `Record`.`is_virtual`, `Record`.`virtual_product_filename`, `Record`.`virtual_product_filename_2`, `Record`.`virtual_product_filename_3`, `Record`.`policies_returns_id`, `Record`.`policies_complaints_id`, `Record`.`policies_warranties_id`, `Record`.`orders_subscriptions_plans_id`, `Record`.`tax_rates_id`, `Record`.`price_min_suggested_by_provider`, `Record`.`last_allegro_offers_auto_generation_attempt`, `Record`.`provider_price_min_suggested_by_provider`, `Record`.`provider_price_suggested_addon`, `Record`.`max_units_left_for_gifts`, `Record`.`current_units_used_for_gifts`, `Record`.`gpsr_templates_id`, `Record`.`safety_information`, `Promo`.`id`, `Promo`.`percent`, `Promo`.`name`, `Promo`.`url_code`, `Promo`.`description`, `Promo`.`date_start`, `Promo`.`date_end`, `Promo`.`is_global`, `Promo`.`hidden`, `Promo`.`promo_type`, `Promo`.`is_for_registered`, `Promo`.`allow_user_activation`, `Promo`.`uses_limit`, `Promo`.`used_count`, `Promo`.`is_used`, `Promo`.`mingain`, `Promo`.`virtual`, `Promo`.`used_amount`, `Promo`.`popup_display`, `Promo`.`popups_id`, `Promo`.`mingain_type`, `Promo`.`percent_safe`, `Promo`.`percent_safe_from_margin`, `Promo`.`show_wholesale`, `Promo`.`units_min`, `Promo`.`turnover_lastmonth_min`, `Promo`.`allow_any_payment`, `Promo`.`auto_activated`, `Promo`.`url_address`, `Promo`.`is_for_newsletter_active_email`, `Promo`.`generate_aliases_for_newsletter_emails`, `Promo`.`affiliate_comission`, `Promo`.`affiliate_users_id`, `Promo`.`priority_group`, `Promo`.`deleted`, `Promo`.`shippings_free_shipping_min_condition`, `Promo`.`payments_additional_cost_per_transaction_condition`, `Promo`.`basket_products_sum_min`, `Promo`.`display_ending_info`, `Promo`.`shops_id`, `Promo`.`is_external`, `Promo`.`external_id`, `Promo`.`promo_terms_description`, `Promo`.`gifts_units_limit`, `Promo`.`gifts_products_limit` FROM `baltrade_hurtnew`.`banners_slides` AS `BannersSlide` LEFT JOIN `baltrade_hurtnew`.`records` AS `Record` ON (`BannersSlide`.`type`=1 AND `BannersSlide`.`records_id` = `Record`.`id`) LEFT JOIN `baltrade_hurtnew`.`promos` AS `Promo` ON (`BannersSlide`.`type`=4 AND `BannersSlide`.`promos_id` = `Promo`.`id`) WHERE `BannersSlide`.`is_hidden` = '0' AND (`BannersSlide`.`type` != 1 or (`Record`.`id` > 0 and `Record`.`active`=1 and `Record`.`price`>0 and `Record`.`offer_not_ready`=0)) AND (`BannersSlide`.`type` != 4 or (`Promo`.`id` > 0)) AND (`BannersSlide`.`type` != 9 or (`BannersSlide`.`parameters` != '')) AND ((`BannersSlide`.`limit_date_from` = '0') OR (`BannersSlide`.`date_from` <= '2026-05-29 18:24:37')) AND ((`BannersSlide`.`limit_date_to` = '0') OR (`BannersSlide`.`date_to` >= '2026-05-29 18:24:37')) AND `BannersSlide`.`languages_id` = 1 AND `BannersSlide`.`place` = 3 AND `BannersSlide`.`hidden_for_users_std` = '0' ORDER BY `BannersSlide`.`priority` asc, RAND() ASC LIMIT 12 | 0 | 0 | 1 | maybe slow |
| SELECT `Category`.`lft`, `Category`.`rght` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE `Category`.`id` = 3371 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 2377 AND `Category`.`rght` >= 2378 ORDER BY `Category`.`lft` asc | 3 | 3 | 0 | |
| SELECT `Category`.`lft`, `Category`.`rght` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE `Category`.`id` = 3373 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 2516 AND `Category`.`rght` >= 2517 ORDER BY `Category`.`lft` asc | 2 | 2 | 0 | |
| SELECT `Category`.`lft`, `Category`.`rght` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE `Category`.`id` = 3388 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 2520 AND `Category`.`rght` >= 2521 ORDER BY `Category`.`lft` asc | 2 | 2 | 0 | |
| SELECT `Event`.`id`, `Event`.`title`, `Event`.`description`, `Event`.`date`, `Event`.`url`, `Event`.`shortdescription`, `Event`.`url_title`, `Event`.`hidden_on_main`, `Event`.`active`, `Event`.`visits`, `Event`.`vote_up`, `Event`.`vote_down`, `Event`.`meta_keywords`, `Event`.`meta_description`, `Event`.`old_description_format`, `Event`.`authors_id` FROM `baltrade_hurtnew`.`events` AS `Event` WHERE `Event`.`hidden_on_main` = '0' AND `Event`.`active` = '1' ORDER BY RAND() ASC LIMIT 8 | 8 | 8 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Event' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (14, 69, 79, 64, 73, 131, 75, 135) | 0 | 0 | 0 | |
| SELECT `Event`.`id`, `Event`.`title`, `Event`.`description`, `Event`.`date`, `Event`.`url`, `Event`.`shortdescription`, `Event`.`url_title`, `Event`.`hidden_on_main`, `Event`.`active`, `Event`.`visits`, `Event`.`vote_up`, `Event`.`vote_down`, `Event`.`meta_keywords`, `Event`.`meta_description`, `Event`.`old_description_format`, `Event`.`authors_id` FROM `baltrade_hurtnew`.`events` AS `Event` WHERE `Event`.`id` > 14 AND `Event`.`active` = '1' AND `Event`.`hidden_on_main` = '0' ORDER BY `Event`.`id` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Event' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` = (47) | 0 | 0 | 0 | |
| SELECT `Event`.`id`, `Event`.`title`, `Event`.`description`, `Event`.`date`, `Event`.`url`, `Event`.`shortdescription`, `Event`.`url_title`, `Event`.`hidden_on_main`, `Event`.`active`, `Event`.`visits`, `Event`.`vote_up`, `Event`.`vote_down`, `Event`.`meta_keywords`, `Event`.`meta_description`, `Event`.`old_description_format`, `Event`.`authors_id` FROM `baltrade_hurtnew`.`events` AS `Event` WHERE `Event`.`id` < 135 AND `Event`.`active` = '1' AND `Event`.`hidden_on_main` = '0' ORDER BY `Event`.`id` desc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Event' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` = (134) | 0 | 0 | 0 | |
| SELECT `BannersSlide`.`id`, `BannersSlide`.`title`, `BannersSlide`.`description`, `BannersSlide`.`is_hidden`, `BannersSlide`.`place`, `BannersSlide`.`place_for_events`, `BannersSlide`.`records_id`, `BannersSlide`.`priority`, `BannersSlide`.`languages_id`, `BannersSlide`.`name`, `BannersSlide`.`type`, `BannersSlide`.`promos_id`, `BannersSlide`.`parameters`, `BannersSlide`.`hidden_for_users_std`, `BannersSlide`.`hidden_for_users_wholesale`, `BannersSlide`.`limit_date_from`, `BannersSlide`.`date_from`, `BannersSlide`.`limit_date_to`, `BannersSlide`.`date_to`, `BannersSlide`.`categories_id`, `BannersSlide`.`file_url_big`, `BannersSlide`.`file_url_small`, `BannersSlide`.`url_additional`, `BannersSlide`.`file_title`, `BannersSlide`.`file_alt`, `BannersSlide`.`class_additional`, `Record`.`id`, `Record`.`users_id`, `Record`.`producers_id`, `Record`.`title`, `Record`.`title_h1`, `Record`.`shorttitle`, `Record`.`description`, `Record`.`shortdescription`, `Record`.`active`, `Record`.`onmainpage`, `Record`.`priority`, `Record`.`keywords`, `Record`.`opinions_off`, `Record`.`price`, `Record`.`app_id`, `Record`.`shipping_promo`, `Record`.`in_promotion`, `Record`.`vat`, `Record`.`is_hit`, `Record`.`is_new`, `Record`.`is_outlet`, `Record`.`product_of_the_day`, `Record`.`units`, `Record`.`banner_desc`, `Record`.`max_promo`, `Record`.`provider_price`, `Record`.`price2`, `Record`.`price3`, `Record`.`weight`, `Record`.`newsletter_desc`, `Record`.`box_items`, `Record`.`box_items_name`, `Record`.`unlimited_units`, `Record`.`warranty_time`, `Record`.`warranty_description`, `Record`.`availabilities_id`, `Record`.`times_bought`, `Record`.`created`, `Record`.`model`, `Record`.`ceneo_id`, `Record`.`wholesale`, `Record`.`min_margin`, `Record`.`grade`, `Record`.`traders_id`, `Record`.`EAN`, `Record`.`master_EAN`, `Record`.`producer_code`, `Record`.`master_producer_code`, `Record`.`additional_text`, `Record`.`metadescription`, `Record`.`metakeywords`, `Record`.`site_title`, `Record`.`fbtitle`, `Record`.`fbdescription`, `Record`.`ceneo_group_id`, `Record`.`fake_price`, `Record`.`modified`, `Record`.`visits`, `Record`.`per_item`, `Record`.`master_weight`, `Record`.`packages_num`, `Record`.`type`, `Record`.`order_minvalue_required`, `Record`.`order_minvalue_value`, `Record`.`enable_common_records`, `Record`.`active_change_estimated`, `Record`.`active_notes`, `Record`.`active_change_reason`, `Record`.`compatibles_name`, `Record`.`models_name`, `Record`.`active_change_user_id`, `Record`.`active_change_user_name`, `Record`.`active_change_date`, `Record`.`force_availability`, `Record`.`forced_availabilities_id`, `Record`.`special_type`, `Record`.`price4`, `Record`.`price5`, `Record`.`price6`, `Record`.`price7`, `Record`.`force_export_original`, `Record`.`visible`, `Record`.`price_update`, `Record`.`modified_users_id`, `Record`.`prodimporters_id`, `Record`.`description2`, `Record`.`price8`, `Record`.`price9`, `Record`.`price10`, `Record`.`class_name`, `Record`.`popups_id`, `Record`.`google_category_id`, `Record`.`shopee_category_id`, `Record`.`introdescription`, `Record`.`hidden_for_wholesale`, `Record`.`shippings_pricelists_id`, `Record`.`old_description_format`, `Record`.`offer_not_ready`, `Record`.`seo_do_not_index`, `Record`.`max_units_per_order`, `Record`.`additional_order_notification_emails`, `Record`.`send_notification_if_ordered`, `Record`.`dimensions_length`, `Record`.`dimensions_width`, `Record`.`dimensions_height`, `Record`.`points_calculation_type`, `Record`.`points_multiplier`, `Record`.`points_fixed_amount`, `Record`.`is_virtual`, `Record`.`virtual_product_filename`, `Record`.`virtual_product_filename_2`, `Record`.`virtual_product_filename_3`, `Record`.`policies_returns_id`, `Record`.`policies_complaints_id`, `Record`.`policies_warranties_id`, `Record`.`orders_subscriptions_plans_id`, `Record`.`tax_rates_id`, `Record`.`price_min_suggested_by_provider`, `Record`.`last_allegro_offers_auto_generation_attempt`, `Record`.`provider_price_min_suggested_by_provider`, `Record`.`provider_price_suggested_addon`, `Record`.`max_units_left_for_gifts`, `Record`.`current_units_used_for_gifts`, `Record`.`gpsr_templates_id`, `Record`.`safety_information`, `Promo`.`id`, `Promo`.`percent`, `Promo`.`name`, `Promo`.`url_code`, `Promo`.`description`, `Promo`.`date_start`, `Promo`.`date_end`, `Promo`.`is_global`, `Promo`.`hidden`, `Promo`.`promo_type`, `Promo`.`is_for_registered`, `Promo`.`allow_user_activation`, `Promo`.`uses_limit`, `Promo`.`used_count`, `Promo`.`is_used`, `Promo`.`mingain`, `Promo`.`virtual`, `Promo`.`used_amount`, `Promo`.`popup_display`, `Promo`.`popups_id`, `Promo`.`mingain_type`, `Promo`.`percent_safe`, `Promo`.`percent_safe_from_margin`, `Promo`.`show_wholesale`, `Promo`.`units_min`, `Promo`.`turnover_lastmonth_min`, `Promo`.`allow_any_payment`, `Promo`.`auto_activated`, `Promo`.`url_address`, `Promo`.`is_for_newsletter_active_email`, `Promo`.`generate_aliases_for_newsletter_emails`, `Promo`.`affiliate_comission`, `Promo`.`affiliate_users_id`, `Promo`.`priority_group`, `Promo`.`deleted`, `Promo`.`shippings_free_shipping_min_condition`, `Promo`.`payments_additional_cost_per_transaction_condition`, `Promo`.`basket_products_sum_min`, `Promo`.`display_ending_info`, `Promo`.`shops_id`, `Promo`.`is_external`, `Promo`.`external_id`, `Promo`.`promo_terms_description`, `Promo`.`gifts_units_limit`, `Promo`.`gifts_products_limit` FROM `baltrade_hurtnew`.`banners_slides` AS `BannersSlide` LEFT JOIN `baltrade_hurtnew`.`records` AS `Record` ON (`BannersSlide`.`type`=1 AND `BannersSlide`.`records_id` = `Record`.`id`) LEFT JOIN `baltrade_hurtnew`.`promos` AS `Promo` ON (`BannersSlide`.`type`=4 AND `BannersSlide`.`promos_id` = `Promo`.`id`) WHERE `BannersSlide`.`is_hidden` = '0' AND (`BannersSlide`.`type` != 1 or (`Record`.`id` > 0 and `Record`.`active`=1 and `Record`.`price`>0 and `Record`.`offer_not_ready`=0)) AND (`BannersSlide`.`type` != 4 or (`Promo`.`id` > 0)) AND (`BannersSlide`.`type` != 9 or (`BannersSlide`.`parameters` != '')) AND ((`BannersSlide`.`limit_date_from` = '0') OR (`BannersSlide`.`date_from` <= '2026-05-29 18:24:37')) AND ((`BannersSlide`.`limit_date_to` = '0') OR (`BannersSlide`.`date_to` >= '2026-05-29 18:24:37')) AND `BannersSlide`.`languages_id` = 1 AND `BannersSlide`.`place` = 2 AND `BannersSlide`.`hidden_for_users_std` = '0' ORDER BY `BannersSlide`.`priority` asc, RAND() ASC LIMIT 12 | 0 | 0 | 1 | maybe slow |
| SELECT `Record`.`id`, `Record`.`users_id`, `Record`.`producers_id`, `Record`.`title`, `Record`.`title_h1`, `Record`.`shorttitle`, `Record`.`description`, `Record`.`shortdescription`, `Record`.`active`, `Record`.`onmainpage`, `Record`.`priority`, `Record`.`keywords`, `Record`.`opinions_off`, `Record`.`price`, `Record`.`app_id`, `Record`.`shipping_promo`, `Record`.`in_promotion`, `Record`.`vat`, `Record`.`is_hit`, `Record`.`is_new`, `Record`.`is_outlet`, `Record`.`product_of_the_day`, `Record`.`units`, `Record`.`banner_desc`, `Record`.`max_promo`, `Record`.`provider_price`, `Record`.`price2`, `Record`.`price3`, `Record`.`weight`, `Record`.`newsletter_desc`, `Record`.`box_items`, `Record`.`box_items_name`, `Record`.`unlimited_units`, `Record`.`warranty_time`, `Record`.`warranty_description`, `Record`.`availabilities_id`, `Record`.`times_bought`, `Record`.`created`, `Record`.`model`, `Record`.`ceneo_id`, `Record`.`wholesale`, `Record`.`min_margin`, `Record`.`grade`, `Record`.`traders_id`, `Record`.`EAN`, `Record`.`master_EAN`, `Record`.`producer_code`, `Record`.`master_producer_code`, `Record`.`additional_text`, `Record`.`metadescription`, `Record`.`metakeywords`, `Record`.`site_title`, `Record`.`fbtitle`, `Record`.`fbdescription`, `Record`.`ceneo_group_id`, `Record`.`fake_price`, `Record`.`modified`, `Record`.`visits`, `Record`.`per_item`, `Record`.`master_weight`, `Record`.`packages_num`, `Record`.`type`, `Record`.`order_minvalue_required`, `Record`.`order_minvalue_value`, `Record`.`enable_common_records`, `Record`.`active_change_estimated`, `Record`.`active_notes`, `Record`.`active_change_reason`, `Record`.`compatibles_name`, `Record`.`models_name`, `Record`.`active_change_user_id`, `Record`.`active_change_user_name`, `Record`.`active_change_date`, `Record`.`force_availability`, `Record`.`forced_availabilities_id`, `Record`.`special_type`, `Record`.`price4`, `Record`.`price5`, `Record`.`price6`, `Record`.`price7`, `Record`.`force_export_original`, `Record`.`visible`, `Record`.`price_update`, `Record`.`modified_users_id`, `Record`.`prodimporters_id`, `Record`.`description2`, `Record`.`price8`, `Record`.`price9`, `Record`.`price10`, `Record`.`class_name`, `Record`.`popups_id`, `Record`.`google_category_id`, `Record`.`shopee_category_id`, `Record`.`introdescription`, `Record`.`hidden_for_wholesale`, `Record`.`shippings_pricelists_id`, `Record`.`old_description_format`, `Record`.`offer_not_ready`, `Record`.`seo_do_not_index`, `Record`.`max_units_per_order`, `Record`.`additional_order_notification_emails`, `Record`.`send_notification_if_ordered`, `Record`.`dimensions_length`, `Record`.`dimensions_width`, `Record`.`dimensions_height`, `Record`.`points_calculation_type`, `Record`.`points_multiplier`, `Record`.`points_fixed_amount`, `Record`.`is_virtual`, `Record`.`virtual_product_filename`, `Record`.`virtual_product_filename_2`, `Record`.`virtual_product_filename_3`, `Record`.`policies_returns_id`, `Record`.`policies_complaints_id`, `Record`.`policies_warranties_id`, `Record`.`orders_subscriptions_plans_id`, `Record`.`tax_rates_id`, `Record`.`price_min_suggested_by_provider`, `Record`.`last_allegro_offers_auto_generation_attempt`, `Record`.`provider_price_min_suggested_by_provider`, `Record`.`provider_price_suggested_addon`, `Record`.`max_units_left_for_gifts`, `Record`.`current_units_used_for_gifts`, `Record`.`gpsr_templates_id`, `Record`.`safety_information`, `Availability`.`id`, `Availability`.`title`, `Availability`.`description`, `Availability`.`nokaut_value`, `Availability`.`ceneo_value`, `Availability`.`skapiec_value`, `Availability`.`sklepy24_value`, `Availability`.`isdefault`, `Availability`.`skapiec13_value`, `Availability`.`deliverydaysfrom`, `Availability`.`deliverydaysto`, `Availability`.`deliverydaystypical`, `Availability`.`deliverytimeallegro`, `Availability`.`send_notification_if_ordered`, `AvailabilityForced`.`id`, `AvailabilityForced`.`title`, `AvailabilityForced`.`description`, `AvailabilityForced`.`nokaut_value`, `AvailabilityForced`.`ceneo_value`, `AvailabilityForced`.`skapiec_value`, `AvailabilityForced`.`sklepy24_value`, `AvailabilityForced`.`isdefault`, `AvailabilityForced`.`skapiec13_value`, `AvailabilityForced`.`deliverydaysfrom`, `AvailabilityForced`.`deliverydaysto`, `AvailabilityForced`.`deliverydaystypical`, `AvailabilityForced`.`deliverytimeallegro`, `AvailabilityForced`.`send_notification_if_ordered`, `Producer`.`id`, `Producer`.`name`, `Producer`.`url`, `Producer`.`link`, `Producer`.`for_compatible_devices`, `Producer`.`on_site`, `Producer`.`isproducer`, `Producer`.`isimporter`, `Producer`.`default_producers_contacts_id`, `Producer`.`overwrite_producer_contact_in_template`, `Producer`.`default_gpsr_templates_id`, `Prodimporter`.`id`, `Prodimporter`.`name`, `Prodimporter`.`url`, `Prodimporter`.`link`, `Prodimporter`.`for_compatible_devices`, `Prodimporter`.`on_site`, `Prodimporter`.`isproducer`, `Prodimporter`.`isimporter`, `Prodimporter`.`default_producers_contacts_id`, `Prodimporter`.`overwrite_producer_contact_in_template`, `Prodimporter`.`default_gpsr_templates_id`, `Trader`.`id`, `Trader`.`name`, `Trader`.`last_name`, `Trader`.`description`, `Trader`.`photo`, `Trader`.`telephone`, `Trader`.`fax`, `Trader`.`mobile`, `Trader`.`email`, `Trader`.`gadu`, `Trader`.`skype`, `Trader`.`option_name`, `Trader`.`description_for_notifications`, `Trader`.`additional_order_notification_emails`, `ShippingsPricelist`.`id`, `ShippingsPricelist`.`title`, `ShippingsPricelist`.`forced_shipping_promo`, `OrdersSubscriptionsPlan`.`id`, `OrdersSubscriptionsPlan`.`name` FROM `baltrade_hurtnew`.`records` AS `Record` LEFT JOIN `baltrade_hurtnew`.`availabilities` AS `Availability` ON (`Record`.`availabilities_id` = `Availability`.`id`) LEFT JOIN `baltrade_hurtnew`.`availabilities` AS `AvailabilityForced` ON (`Record`.`forced_availabilities_id` = `AvailabilityForced`.`id`) LEFT JOIN `baltrade_hurtnew`.`producers` AS `Producer` ON (`Record`.`producers_id` = `Producer`.`id`) LEFT JOIN `baltrade_hurtnew`.`producers` AS `Prodimporter` ON (`Record`.`prodimporters_id` = `Prodimporter`.`id`) LEFT JOIN `baltrade_hurtnew`.`traders` AS `Trader` ON (`Record`.`traders_id` = `Trader`.`id`) LEFT JOIN `baltrade_hurtnew`.`shippings_pricelists` AS `ShippingsPricelist` ON (`Record`.`shippings_pricelists_id` = `ShippingsPricelist`.`id`) LEFT JOIN `baltrade_hurtnew`.`orders_subscriptions_plans` AS `OrdersSubscriptionsPlan` ON (`Record`.`orders_subscriptions_plans_id` = `OrdersSubscriptionsPlan`.`id`) WHERE `Record`.`id` = 20051 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Producer' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` = (759) | 0 | 0 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Record' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` = (20051) | 0 | 0 | 0 | |
| SELECT `Parameter`.`id`, `Parameter`.`records_id`, `Parameter`.`name`, `Parameter`.`number`, `Parameter`.`hidden`, `Parameter`.`app_id`, `Parameter`.`active`, `Parameter`.`provider_price`, `Parameter`.`price`, `Parameter`.`price2`, `Parameter`.`price3`, `Parameter`.`units`, `Parameter`.`unlimited_units`, `Parameter`.`availabilities_id`, `Parameter`.`created`, `Parameter`.`modified`, `Parameter`.`active_inherit`, `Parameter`.`provider_price_inherit`, `Parameter`.`price_inherit`, `Parameter`.`price2_inherit`, `Parameter`.`price3_inherit`, `Parameter`.`units_inherit`, `Parameter`.`unlimited_units_inherit`, `Parameter`.`availabilities_id_inherit`, `Parameter`.`app_id_inherit`, `Parameter`.`priority`, `Parameter`.`isdefault`, `Parameter`.`price4`, `Parameter`.`price4_inherit`, `Parameter`.`price5`, `Parameter`.`price5_inherit`, `Parameter`.`price6`, `Parameter`.`price6_inherit`, `Parameter`.`price7`, `Parameter`.`price7_inherit`, `Parameter`.`price8`, `Parameter`.`price8_inherit`, `Parameter`.`price9`, `Parameter`.`price9_inherit`, `Parameter`.`price10`, `Parameter`.`price10_inherit`, `Parameter`.`shippings_pricelists_id`, `Parameter`.`shippings_pricelists_id_inherit`, `Parameter`.`weight`, `Parameter`.`weight_inherit`, `Parameter`.`EAN`, `Parameter`.`EAN_inherit`, `Parameter`.`producer_code`, `Parameter`.`producer_code_inherit`, `Parameter`.`dimensions_length`, `Parameter`.`dimensions_length_inherit`, `Parameter`.`dimensions_width`, `Parameter`.`dimensions_width_inherit`, `Parameter`.`dimensions_height`, `Parameter`.`dimensions_height_inherit`, `Parameter`.`points_multiplier`, `Parameter`.`points_multiplier_inherit`, `Parameter`.`points_fixed_amount`, `Parameter`.`points_fixed_amount_inherit`, `Parameter`.`points_calculation_type`, `Parameter`.`points_calculation_type_inherit` FROM `baltrade_hurtnew`.`parameters` AS `Parameter` WHERE `Parameter`.`hidden` = '0' AND `Parameter`.`records_id` = (20051) ORDER BY `Parameter`.`priority` asc, `Parameter`.`name` asc, `Parameter`.`id` asc | 0 | 0 | 0 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`hidden` = '0' AND `Photo`.`records_id` = (20051) ORDER BY `Photo`.`priority` ASC | 9 | 9 | 0 | |
| SELECT `RecordsShippingsCost`.`id`, `RecordsShippingsCost`.`shippings_id`, `RecordsShippingsCost`.`records_id`, `RecordsShippingsCost`.`parameters_id`, `RecordsShippingsCost`.`shippings_pricelists_id`, `RecordsShippingsCost`.`cost_product`, `RecordsShippingsCost`.`cost_basket`, `RecordsShippingsCost`.`cost_product_cod`, `RecordsShippingsCost`.`cost_basket_cod`, `RecordsShippingsCost`.`cost_basket_force`, `RecordsShippingsCost`.`cost_reduce_by_other`, `RecordsShippingsCost`.`cost_reduce_by_other_id`, `RecordsShippingsCost`.`cost_next`, `RecordsShippingsCost`.`amount_in_pack` FROM `baltrade_hurtnew`.`records_shippings_costs` AS `RecordsShippingsCost` WHERE `RecordsShippingsCost`.`records_id` = (20051) | 0 | 0 | 0 | |
| SELECT `RecordsAdditionalProductOption`.`id`, `RecordsAdditionalProductOption`.`additional_product_options_id`, `RecordsAdditionalProductOption`.`records_id`, `RecordsAdditionalProductOption`.`priority` FROM `baltrade_hurtnew`.`records_additional_product_options` AS `RecordsAdditionalProductOption` WHERE `RecordsAdditionalProductOption`.`records_id` = (20051) ORDER BY `RecordsAdditionalProductOption`.`priority` asc, `RecordsAdditionalProductOption`.`id` ASC | 0 | 0 | 0 | |
| SELECT `RecordsMovie`.`id`, `RecordsMovie`.`records_id`, `RecordsMovie`.`movies_id`, `RecordsMovie`.`priority`, `RecordsMovie`.`hidden` FROM `baltrade_hurtnew`.`records_movies` AS `RecordsMovie` WHERE `RecordsMovie`.`hidden` = '0' AND `RecordsMovie`.`records_id` = (20051) ORDER BY `RecordsMovie`.`priority` ASC | 0 | 0 | 0 | |
| SELECT `RecordsPayment`.`id`, `RecordsPayment`.`payments_id`, `RecordsPayment`.`records_id`, `RecordsPayment`.`parameters_id`, `RecordsPayment`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_payments` AS `RecordsPayment` WHERE `RecordsPayment`.`records_id` = (20051) | 0 | 0 | 0 | |
| SELECT `RecordsShipping`.`id`, `RecordsShipping`.`records_id`, `RecordsShipping`.`shippings_id`, `RecordsShipping`.`parameters_id`, `RecordsShipping`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_shippings` AS `RecordsShipping` WHERE `RecordsShipping`.`records_id` = (20051) | 0 | 0 | 0 | |
| SELECT `RecordsName`.`id`, `RecordsName`.`records_id`, `RecordsName`.`title`, `RecordsName`.`producers_id` FROM `baltrade_hurtnew`.`records_names` AS `RecordsName` WHERE `RecordsName`.`records_id` = (20051) ORDER BY `RecordsName`.`title` asc | 0 | 0 | 0 | |
| SELECT `RecordsPackage`.`id`, `RecordsPackage`.`main_records_id`, `RecordsPackage`.`records_id`, `RecordsPackage`.`index`, `RecordsPackage`.`amount`, `RecordsPackage`.`priority`, `RecordsPackage`.`auto_add_description`, `RecordsPackage`.`auto_add_photos`, `RecordsPackage`.`auto_add_features` FROM `baltrade_hurtnew`.`records_packages` AS `RecordsPackage` WHERE `RecordsPackage`.`main_records_id` = (20051) ORDER BY `RecordsPackage`.`priority` asc | 0 | 0 | 0 | |
| SELECT `RecordsBox`.`id`, `RecordsBox`.`records_id`, `RecordsBox`.`barcode`, `RecordsBox`.`amount`, `RecordsBox`.`synchro_blocked`, `RecordsBox`.`display_state` FROM `baltrade_hurtnew`.`records_boxes` AS `RecordsBox` WHERE `RecordsBox`.`display_state` < 1 AND `RecordsBox`.`records_id` = (20051) ORDER BY `RecordsBox`.`amount` ASC, `RecordsBox`.`barcode` ASC | 0 | 0 | 0 | |
| SELECT `Promo`.`id`, `Promo`.`percent`, `Promo`.`name`, `Promo`.`url_code`, `Promo`.`description`, `Promo`.`date_start`, `Promo`.`date_end`, `Promo`.`is_global`, `Promo`.`hidden`, `Promo`.`promo_type`, `Promo`.`is_for_registered`, `Promo`.`allow_user_activation`, `Promo`.`uses_limit`, `Promo`.`used_count`, `Promo`.`is_used`, `Promo`.`mingain`, `Promo`.`virtual`, `Promo`.`used_amount`, `Promo`.`popup_display`, `Promo`.`popups_id`, `Promo`.`mingain_type`, `Promo`.`percent_safe`, `Promo`.`percent_safe_from_margin`, `Promo`.`show_wholesale`, `Promo`.`units_min`, `Promo`.`turnover_lastmonth_min`, `Promo`.`allow_any_payment`, `Promo`.`auto_activated`, `Promo`.`url_address`, `Promo`.`is_for_newsletter_active_email`, `Promo`.`generate_aliases_for_newsletter_emails`, `Promo`.`affiliate_comission`, `Promo`.`affiliate_users_id`, `Promo`.`priority_group`, `Promo`.`deleted`, `Promo`.`shippings_free_shipping_min_condition`, `Promo`.`payments_additional_cost_per_transaction_condition`, `Promo`.`basket_products_sum_min`, `Promo`.`display_ending_info`, `Promo`.`shops_id`, `Promo`.`is_external`, `Promo`.`external_id`, `Promo`.`promo_terms_description`, `Promo`.`gifts_units_limit`, `Promo`.`gifts_products_limit`, `PromosRecord`.`id`, `PromosRecord`.`records_id`, `PromosRecord`.`promos_id`, `PromosRecord`.`percent`, `PromosRecord`.`promo_type`, `PromosRecord`.`units_min`, `PromosRecord`.`turnover_lastmonth_min`, `PromosRecord`.`created`, `PromosRecord`.`modified`, `PromosRecord`.`basket_products_sum_min` FROM `baltrade_hurtnew`.`promos` AS `Promo` JOIN `baltrade_hurtnew`.`promos_records` AS `PromosRecord` ON (`PromosRecord`.`records_id` = 20051 AND `PromosRecord`.`promos_id` = `Promo`.`id`) | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information`, `CategoriesRecord`.`id`, `CategoriesRecord`.`categories_id`, `CategoriesRecord`.`records_id`, `CategoriesRecord`.`number`, `CategoriesRecord`.`priority`, `CategoriesRecord`.`override_priority` FROM `baltrade_hurtnew`.`categories` AS `Category` JOIN `baltrade_hurtnew`.`categories_records` AS `CategoriesRecord` ON (`CategoriesRecord`.`records_id` = 20051 AND `CategoriesRecord`.`categories_id` = `Category`.`id`) | 3 | 3 | 0 | |
| SELECT `VariantsGroup`.`id`, `VariantsGroup`.`is_visible`, `VariantsGroup`.`name`, `RecordsVariant`.`id`, `RecordsVariant`.`records_id`, `RecordsVariant`.`variants_groups_id`, `RecordsVariant`.`priority` FROM `baltrade_hurtnew`.`variants_groups` AS `VariantsGroup` JOIN `baltrade_hurtnew`.`records_variants` AS `RecordsVariant` ON (`RecordsVariant`.`records_id` = 20051 AND `RecordsVariant`.`variants_groups_id` = `VariantsGroup`.`id`) WHERE `VariantsGroup`.`is_visible` = '1' | 0 | 0 | 0 | |
| SELECT `OrdersSubscriptionsPeriod`.`id`, `OrdersSubscriptionsPeriod`.`value`, `OrdersSubscriptionsPeriod`.`unit`, `OrdersSubscriptionsPeriod`.`orders_subscriptions_plans_id`, `OrdersSubscriptionsPeriod`.`title_displayed`, `OrdersSubscriptionsPeriod`.`discount_percent`, `OrdersSubscriptionsPeriod`.`discount_value`, `OrdersSubscriptionsPeriod`.`description` FROM `baltrade_hurtnew`.`orders_subscriptions_periods` AS `OrdersSubscriptionsPeriod` WHERE `orders_subscriptions_plans_id` IS NULL | 0 | 0 | 0 | |
| SELECT `Comment`.`id`, `Comment`.`record_id`, `Comment`.`name`, `Comment`.`body`, `Comment`.`rate`, `Comment`.`choice_rate`, `Comment`.`price_rate`, `Comment`.`time_rate`, `Comment`.`contact_rate`, `Comment`.`quality_rate`, `Comment`.`service_rate`, `Comment`.`package_rate`, `Comment`.`email`, `Comment`.`user_id`, `Comment`.`ip`, `Comment`.`host`, `Comment`.`useragent`, `Comment`.`active`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`parent_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`vote_up`, `Comment`.`vote_down`, `Comment`.`events_id`, `Comment`.`comment_type`, `Comment`.`order_hash_id` FROM `baltrade_hurtnew`.`comments` AS `Comment` WHERE `Comment`.`record_id` = 20051 AND `Comment`.`active` = '1' AND `Comment`.`comment_type` = 1 ORDER BY `Comment`.`lft` desc | 0 | 0 | 0 | |
| SELECT `GpsrTemplate`.`id`, `GpsrTemplate`.`title`, `GpsrTemplate`.`producers_id`, `GpsrTemplate`.`responsible_entities_id`, `GpsrTemplate`.`description`, `GpsrTemplate`.`date_created`, `GpsrTemplate`.`author_created`, `GpsrTemplate`.`author_created_text`, `GpsrTemplate`.`date_modified`, `GpsrTemplate`.`author_modified`, `GpsrTemplate`.`author_modified_text`, `GpsrTemplate`.`deleted`, `ResponsibleEntity`.`id`, `ResponsibleEntity`.`name`, `ResponsibleEntity`.`address`, `ResponsibleEntity`.`postcode`, `ResponsibleEntity`.`city`, `ResponsibleEntity`.`country`, `ResponsibleEntity`.`country_code`, `ResponsibleEntity`.`phone`, `ResponsibleEntity`.`email`, `ResponsibleEntity`.`www_address`, `ResponsibleEntity`.`date_created`, `ResponsibleEntity`.`author_created`, `ResponsibleEntity`.`author_created_text`, `ResponsibleEntity`.`date_modified`, `ResponsibleEntity`.`author_modified`, `ResponsibleEntity`.`author_modified_text`, `ResponsibleEntity`.`deleted`, `ProducerEntity`.`id`, `ProducerEntity`.`name`, `ProducerEntity`.`address`, `ProducerEntity`.`postcode`, `ProducerEntity`.`city`, `ProducerEntity`.`country`, `ProducerEntity`.`country_code`, `ProducerEntity`.`phone`, `ProducerEntity`.`email`, `ProducerEntity`.`www_address`, `ProducerEntity`.`date_created`, `ProducerEntity`.`author_created`, `ProducerEntity`.`author_created_text`, `ProducerEntity`.`date_modified`, `ProducerEntity`.`author_modified`, `ProducerEntity`.`author_modified_text`, `ProducerEntity`.`deleted` FROM `baltrade_hurtnew`.`gpsr_templates` AS `GpsrTemplate` LEFT JOIN `baltrade_hurtnew`.`producers_contacts` AS `ResponsibleEntity` ON (`GpsrTemplate`.`responsible_entities_id` = `ResponsibleEntity`.`id`) LEFT JOIN `baltrade_hurtnew`.`producers_contacts` AS `ProducerEntity` ON (`GpsrTemplate`.`producers_id` = `ProducerEntity`.`id`) WHERE `GpsrTemplate`.`id` = 28 AND `GpsrTemplate`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `FilesDownload`.`id`, `FilesDownload`.`title`, `FilesDownload`.`description`, `FilesDownload`.`url`, `FilesDownload`.`filename`, `FilesDownload`.`files_id`, `FilesDownload`.`date_created`, `FilesDownload`.`author_created`, `FilesDownload`.`author_created_text`, `FilesDownload`.`date_modified`, `FilesDownload`.`author_modified`, `FilesDownload`.`author_modified_text`, `FilesDownload`.`downloads_count`, `FilesDownload`.`model`, `FilesDownload`.`objects_id`, `FilesDownload`.`ordering` FROM `baltrade_hurtnew`.`files_downloads` AS `FilesDownload` WHERE `FilesDownload`.`objects_id` = 28 AND `FilesDownload`.`model` = 'GpsrTemplate' ORDER BY `FilesDownload`.`ordering` asc, `FilesDownload`.`id` asc | 0 | 0 | 0 | |
| SELECT `FilesDownload`.`id`, `FilesDownload`.`title`, `FilesDownload`.`description`, `FilesDownload`.`url`, `FilesDownload`.`filename`, `FilesDownload`.`files_id`, `FilesDownload`.`date_created`, `FilesDownload`.`author_created`, `FilesDownload`.`author_created_text`, `FilesDownload`.`date_modified`, `FilesDownload`.`author_modified`, `FilesDownload`.`author_modified_text`, `FilesDownload`.`downloads_count`, `FilesDownload`.`model`, `FilesDownload`.`objects_id`, `FilesDownload`.`ordering` FROM `baltrade_hurtnew`.`files_downloads` AS `FilesDownload` WHERE `FilesDownload`.`objects_id` = 20051 AND `FilesDownload`.`model` = 'Record' ORDER BY `FilesDownload`.`ordering` asc, `FilesDownload`.`id` asc | 0 | 0 | 0 | |
| SELECT `Feature`.`id`, `Feature`.`features_types_id`, `Feature`.`records_id`, `Feature`.`priority`, `Feature`.`features_values_id`, `Feature`.`parameters_id`, `Feature`.`records_id_parameter`, `Feature`.`feature_general_label`, `FeaturesType`.`id`, `FeaturesType`.`name`, `FeaturesType`.`description`, `FeaturesType`.`hidden`, `FeaturesType`.`name_normalized`, `FeaturesType`.`measurement_units_id`, `FeaturesType`.`value_type`, `FeaturesType`.`decimals_number`, `FeaturesType`.`value_min`, `FeaturesType`.`value_max`, `FeaturesType`.`is_multiple_choice`, `FeaturesType`.`multiple_display_type`, `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features` AS `Feature` LEFT JOIN `baltrade_hurtnew`.`features_types` AS `FeaturesType` ON (`Feature`.`features_types_id` = `FeaturesType`.`id`) LEFT JOIN `baltrade_hurtnew`.`features_values` AS `FeaturesValue` ON (`Feature`.`features_values_id` = `FeaturesValue`.`id`) WHERE `FeaturesType`.`hidden` = '0' AND `Feature`.`records_id` = 20051 ORDER BY `Feature`.`priority` asc, `Feature`.`id` asc | 9 | 9 | 0 | |
| SELECT `MeasurementUnit`.`id`, `MeasurementUnit`.`name`, `MeasurementUnit`.`symbol`, `MeasurementUnit`.`superior_id`, `MeasurementUnit`.`multiplier` FROM `baltrade_hurtnew`.`measurement_units` AS `MeasurementUnit` WHERE `MeasurementUnit`.`id` = 3 | 1 | 1 | 0 | |
| SELECT `MeasurementUnit`.`id`, `MeasurementUnit`.`name`, `MeasurementUnit`.`symbol`, `MeasurementUnit`.`superior_id`, `MeasurementUnit`.`multiplier` FROM `baltrade_hurtnew`.`measurement_units` AS `MeasurementUnit` WHERE `MeasurementUnit`.`id` = 4 | 1 | 1 | 0 | |
| SELECT `MeasurementUnit`.`id`, `MeasurementUnit`.`name`, `MeasurementUnit`.`symbol`, `MeasurementUnit`.`superior_id`, `MeasurementUnit`.`multiplier` FROM `baltrade_hurtnew`.`measurement_units` AS `MeasurementUnit` WHERE `MeasurementUnit`.`id` = 7 | 1 | 1 | 0 | |
| SELECT `FeaturesWithValue`.`id`, `FeaturesWithValue`.`features_id`, `FeaturesWithValue`.`ordering`, `FeaturesWithValue`.`features_values_id`, `FeaturesWithValue`.`features_values_label`, `FeaturesWithValue`.`features_valuesto_id`, `FeaturesWithValue`.`features_valuesto_label` FROM `baltrade_hurtnew`.`features_with_values` AS `FeaturesWithValue` WHERE `FeaturesWithValue`.`features_id` IN (26245, 26246, 26247, 26248, 26250, 26249, 26251, 26252, 26253) ORDER BY `FeaturesWithValue`.`ordering` asc | 13 | 13 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 6240 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 5279 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 6154 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 5272 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 5289 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 6241 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 2101 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 20 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 5132 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 6151 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 5292 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 6152 | 1 | 1 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` = 6239 | 1 | 1 | 0 | |
| SELECT `FeaturesInGroup`.`features_types_id`, `FeaturesInGroup`.`features_groups_id` FROM `baltrade_hurtnew`.`features_in_groups` AS `FeaturesInGroup` WHERE `features_types_id` IN (1, 154, 153, 112, 67, 111, 60, 15, 14) | 53 | 53 | 0 | |
| SELECT `FeaturesGroup`.`id`, `FeaturesGroup`.`name`, `FeaturesGroup`.`categories_id`, `FeaturesGroup`.`important` FROM `baltrade_hurtnew`.`features_groups` AS `FeaturesGroup` WHERE `id` IN (33, 32, 21, 23, 31, 14, 33, 33, 30) AND `important` = '1' ORDER BY `name` asc | 0 | 0 | 0 | |
| SELECT `CategoriesRecord`.`id`, `CategoriesRecord`.`categories_id`, `CategoriesRecord`.`records_id`, `CategoriesRecord`.`number`, `CategoriesRecord`.`priority`, `CategoriesRecord`.`override_priority`, `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information` FROM `baltrade_hurtnew`.`categories_records` AS `CategoriesRecord` LEFT JOIN `baltrade_hurtnew`.`categories` AS `Category` ON (`CategoriesRecord`.`categories_id` = `Category`.`id`) WHERE `CategoriesRecord`.`records_id` = 20051 | 3 | 3 | 0 | |
| SELECT `Category`.`id`, `title`, `count_records`, `Category`.`parent_id` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE `id` = 3069 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Category' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` = (3069) | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `title`, `count_records`, `Category`.`parent_id` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE `id` = 122 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Category' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` = (122) | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `title`, `count_records`, `Category`.`parent_id` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE `id` = 121 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Category' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` = (121) | 0 | 0 | 0 | |
| SELECT `Record`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` left join records_datas as RecordsData on RecordsData.records_id=Record.id left join categories_records as CategoriesRecord on CategoriesRecord.records_id=Record.id WHERE `Record`.`active` = '1' AND `Record`.`price` > 0 AND `Record`.`offer_not_ready` = 0 AND `Record`.`special_type` = 0 AND ((`units` > 0) OR (`unlimited_units` = '1')) AND `CategoriesRecord`.`categories_id` IN (3069) AND ((`Record`.`id` IN (21060, 21061, 21062, 21052, 21123, 21122, 21121, 21120, 21119, 21118, 21109, 21270)) OR (`Record`.`id` NOT IN (21057, 21058, 21059, 21053, 21054, 21055))) ORDER BY `Record`.`is_hit` DESC, IF(Record.is_hit OR RecordsData.sold_number_30days IS NULL,Record.times_bought, RecordsData.sold_number_30days) DESC, Record.times_bought DESC, Record.priority asc, Record.id desc LIMIT 10 | 1 | 1 | 0 | |
| SELECT `Record`.`id`, `Record`.`producers_id`, `Record`.`title`, `Record`.`title_h1`, `Record`.`shorttitle`, `Record`.`shortdescription`, `Record`.`active`, `Record`.`opinions_off`, `Record`.`price`, `Record`.`app_id`, `Record`.`shipping_promo`, `Record`.`in_promotion`, `Record`.`vat`, `Record`.`tax_rates_id`, `Record`.`is_hit`, `Record`.`is_new`, `Record`.`is_outlet`, `Record`.`product_of_the_day`, `Record`.`units`, `Record`.`max_promo`, `Record`.`provider_price`, `Record`.`price2`, `Record`.`price3`, `Record`.`weight`, `Record`.`box_items`, `Record`.`box_items_name`, `Record`.`unlimited_units`, `Record`.`warranty_time`, `Record`.`warranty_description`, `Record`.`availabilities_id`, `Record`.`times_bought`, `Record`.`created`, `Record`.`model`, `Record`.`wholesale`, `Record`.`min_margin`, `Record`.`grade`, `Record`.`traders_id`, `Record`.`EAN`, `Record`.`producer_code`, `Record`.`fake_price`, `Record`.`modified`, `Record`.`visits`, `Record`.`per_item`, `Record`.`master_weight`, `Record`.`packages_num`, `Record`.`type`, `Record`.`master_EAN`, `Record`.`master_producer_code`, `Record`.`force_availability`, `Record`.`forced_availabilities_id`, `Record`.`price4`, `Record`.`price5`, `Record`.`price6`, `Record`.`price7`, `Record`.`visible`, `Record`.`prodimporters_id`, `Record`.`price8`, `Record`.`price9`, `Record`.`price10`, `Record`.`shippings_pricelists_id`, `Record`.`class_name`, `Record`.`dimensions_width`, `Record`.`dimensions_height`, `Record`.`dimensions_length`, `Record`.`points_calculation_type`, `Record`.`points_multiplier`, `Record`.`points_fixed_amount`, `Availability`.`id`, `Availability`.`title`, `Availability`.`deliverydaysfrom`, `Availability`.`deliverydaysto`, `Producer`.`id`, `Producer`.`name`, `Producer`.`url`, `Producer`.`link`, `ShippingsPricelist`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` LEFT JOIN `baltrade_hurtnew`.`availabilities` AS `Availability` ON (`Record`.`availabilities_id` = `Availability`.`id`) LEFT JOIN `baltrade_hurtnew`.`producers` AS `Producer` ON (`Record`.`producers_id` = `Producer`.`id`) LEFT JOIN `baltrade_hurtnew`.`shippings_pricelists` AS `ShippingsPricelist` ON (`Record`.`shippings_pricelists_id` = `ShippingsPricelist`.`id`) WHERE `Record`.`id` IN (20597) ORDER BY Field(`Record`.`id`,20597) ASC LIMIT 10 | 1 | 1 | 0 | |
| SELECT `Parameter`.`id`, `Parameter`.`records_id`, `Parameter`.`name`, `Parameter`.`number`, `Parameter`.`hidden`, `Parameter`.`app_id`, `Parameter`.`active`, `Parameter`.`provider_price`, `Parameter`.`price`, `Parameter`.`price2`, `Parameter`.`price3`, `Parameter`.`units`, `Parameter`.`unlimited_units`, `Parameter`.`availabilities_id`, `Parameter`.`created`, `Parameter`.`modified`, `Parameter`.`active_inherit`, `Parameter`.`provider_price_inherit`, `Parameter`.`price_inherit`, `Parameter`.`price2_inherit`, `Parameter`.`price3_inherit`, `Parameter`.`units_inherit`, `Parameter`.`unlimited_units_inherit`, `Parameter`.`availabilities_id_inherit`, `Parameter`.`app_id_inherit`, `Parameter`.`priority`, `Parameter`.`isdefault`, `Parameter`.`price4`, `Parameter`.`price4_inherit`, `Parameter`.`price5`, `Parameter`.`price5_inherit`, `Parameter`.`price6`, `Parameter`.`price6_inherit`, `Parameter`.`price7`, `Parameter`.`price7_inherit`, `Parameter`.`price8`, `Parameter`.`price8_inherit`, `Parameter`.`price9`, `Parameter`.`price9_inherit`, `Parameter`.`price10`, `Parameter`.`price10_inherit`, `Parameter`.`shippings_pricelists_id`, `Parameter`.`shippings_pricelists_id_inherit`, `Parameter`.`weight`, `Parameter`.`weight_inherit`, `Parameter`.`EAN`, `Parameter`.`EAN_inherit`, `Parameter`.`producer_code`, `Parameter`.`producer_code_inherit`, `Parameter`.`dimensions_length`, `Parameter`.`dimensions_length_inherit`, `Parameter`.`dimensions_width`, `Parameter`.`dimensions_width_inherit`, `Parameter`.`dimensions_height`, `Parameter`.`dimensions_height_inherit`, `Parameter`.`points_multiplier`, `Parameter`.`points_multiplier_inherit`, `Parameter`.`points_fixed_amount`, `Parameter`.`points_fixed_amount_inherit`, `Parameter`.`points_calculation_type`, `Parameter`.`points_calculation_type_inherit` FROM `baltrade_hurtnew`.`parameters` AS `Parameter` WHERE `Parameter`.`hidden` = '0' AND `Parameter`.`records_id` = (20597) ORDER BY `Parameter`.`priority` asc, `Parameter`.`name` asc, `Parameter`.`id` asc | 0 | 0 | 0 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`hidden` = '0' AND `Photo`.`records_id` = (20597) ORDER BY `Photo`.`priority` ASC | 6 | 6 | 0 | |
| SELECT `RecordsShippingsCost`.`id`, `RecordsShippingsCost`.`shippings_id`, `RecordsShippingsCost`.`records_id`, `RecordsShippingsCost`.`parameters_id`, `RecordsShippingsCost`.`shippings_pricelists_id`, `RecordsShippingsCost`.`cost_product`, `RecordsShippingsCost`.`cost_basket`, `RecordsShippingsCost`.`cost_product_cod`, `RecordsShippingsCost`.`cost_basket_cod`, `RecordsShippingsCost`.`cost_basket_force`, `RecordsShippingsCost`.`cost_reduce_by_other`, `RecordsShippingsCost`.`cost_reduce_by_other_id`, `RecordsShippingsCost`.`cost_next`, `RecordsShippingsCost`.`amount_in_pack` FROM `baltrade_hurtnew`.`records_shippings_costs` AS `RecordsShippingsCost` WHERE `RecordsShippingsCost`.`records_id` = (20597) | 0 | 0 | 0 | |
| SELECT `RecordsAdditionalProductOption`.`id`, `RecordsAdditionalProductOption`.`additional_product_options_id`, `RecordsAdditionalProductOption`.`records_id`, `RecordsAdditionalProductOption`.`priority` FROM `baltrade_hurtnew`.`records_additional_product_options` AS `RecordsAdditionalProductOption` WHERE `RecordsAdditionalProductOption`.`records_id` = (20597) ORDER BY `RecordsAdditionalProductOption`.`priority` asc, `RecordsAdditionalProductOption`.`id` ASC | 0 | 0 | 0 | |
| SELECT `RecordsPayment`.`id`, `RecordsPayment`.`payments_id`, `RecordsPayment`.`records_id`, `RecordsPayment`.`parameters_id`, `RecordsPayment`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_payments` AS `RecordsPayment` WHERE `RecordsPayment`.`records_id` = (20597) | 0 | 0 | 0 | |
| SELECT `RecordsShipping`.`id`, `RecordsShipping`.`records_id`, `RecordsShipping`.`shippings_id`, `RecordsShipping`.`parameters_id`, `RecordsShipping`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_shippings` AS `RecordsShipping` WHERE `RecordsShipping`.`records_id` = (20597) | 0 | 0 | 0 | |
| SELECT `RecordsPackage`.`id`, `RecordsPackage`.`main_records_id`, `RecordsPackage`.`records_id`, `RecordsPackage`.`index`, `RecordsPackage`.`amount`, `RecordsPackage`.`priority`, `RecordsPackage`.`auto_add_description`, `RecordsPackage`.`auto_add_photos`, `RecordsPackage`.`auto_add_features` FROM `baltrade_hurtnew`.`records_packages` AS `RecordsPackage` WHERE `RecordsPackage`.`main_records_id` = (20597) ORDER BY `RecordsPackage`.`priority` asc | 0 | 0 | 0 | |
| SELECT `RecordsBox`.`id`, `RecordsBox`.`records_id`, `RecordsBox`.`barcode`, `RecordsBox`.`amount`, `RecordsBox`.`synchro_blocked`, `RecordsBox`.`display_state` FROM `baltrade_hurtnew`.`records_boxes` AS `RecordsBox` WHERE `RecordsBox`.`display_state` < 1 AND `RecordsBox`.`records_id` = (20597) ORDER BY `RecordsBox`.`amount` ASC, `RecordsBox`.`barcode` ASC | 0 | 0 | 0 | |
| SELECT `Promo`.`id`, `Promo`.`percent`, `Promo`.`name`, `Promo`.`url_code`, `Promo`.`description`, `Promo`.`date_start`, `Promo`.`date_end`, `Promo`.`is_global`, `Promo`.`hidden`, `Promo`.`promo_type`, `Promo`.`is_for_registered`, `Promo`.`allow_user_activation`, `Promo`.`uses_limit`, `Promo`.`used_count`, `Promo`.`is_used`, `Promo`.`mingain`, `Promo`.`virtual`, `Promo`.`used_amount`, `Promo`.`popup_display`, `Promo`.`popups_id`, `Promo`.`mingain_type`, `Promo`.`percent_safe`, `Promo`.`percent_safe_from_margin`, `Promo`.`show_wholesale`, `Promo`.`units_min`, `Promo`.`turnover_lastmonth_min`, `Promo`.`allow_any_payment`, `Promo`.`auto_activated`, `Promo`.`url_address`, `Promo`.`is_for_newsletter_active_email`, `Promo`.`generate_aliases_for_newsletter_emails`, `Promo`.`affiliate_comission`, `Promo`.`affiliate_users_id`, `Promo`.`priority_group`, `Promo`.`deleted`, `Promo`.`shippings_free_shipping_min_condition`, `Promo`.`payments_additional_cost_per_transaction_condition`, `Promo`.`basket_products_sum_min`, `Promo`.`display_ending_info`, `Promo`.`shops_id`, `Promo`.`is_external`, `Promo`.`external_id`, `Promo`.`promo_terms_description`, `Promo`.`gifts_units_limit`, `Promo`.`gifts_products_limit`, `PromosRecord`.`id`, `PromosRecord`.`records_id`, `PromosRecord`.`promos_id`, `PromosRecord`.`percent`, `PromosRecord`.`promo_type`, `PromosRecord`.`units_min`, `PromosRecord`.`turnover_lastmonth_min`, `PromosRecord`.`created`, `PromosRecord`.`modified`, `PromosRecord`.`basket_products_sum_min` FROM `baltrade_hurtnew`.`promos` AS `Promo` JOIN `baltrade_hurtnew`.`promos_records` AS `PromosRecord` ON (`PromosRecord`.`records_id` = 20597 AND `PromosRecord`.`promos_id` = `Promo`.`id`) | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information`, `CategoriesRecord`.`id`, `CategoriesRecord`.`categories_id`, `CategoriesRecord`.`records_id`, `CategoriesRecord`.`number`, `CategoriesRecord`.`priority`, `CategoriesRecord`.`override_priority` FROM `baltrade_hurtnew`.`categories` AS `Category` JOIN `baltrade_hurtnew`.`categories_records` AS `CategoriesRecord` ON (`CategoriesRecord`.`records_id` = 20597 AND `CategoriesRecord`.`categories_id` = `Category`.`id`) | 2 | 2 | 0 | |
| SELECT `VariantsGroup`.`id`, `VariantsGroup`.`is_visible`, `VariantsGroup`.`name`, `RecordsVariant`.`id`, `RecordsVariant`.`records_id`, `RecordsVariant`.`variants_groups_id`, `RecordsVariant`.`priority` FROM `baltrade_hurtnew`.`variants_groups` AS `VariantsGroup` JOIN `baltrade_hurtnew`.`records_variants` AS `RecordsVariant` ON (`RecordsVariant`.`records_id` = 20597 AND `RecordsVariant`.`variants_groups_id` = `VariantsGroup`.`id`) WHERE `VariantsGroup`.`is_visible` = '1' | 0 | 0 | 0 | |
| SELECT `Feature`.`id`, `Feature`.`features_types_id`, `Feature`.`records_id`, `Feature`.`priority`, `Feature`.`features_values_id`, `Feature`.`parameters_id`, `Feature`.`records_id_parameter`, `Feature`.`feature_general_label` FROM `baltrade_hurtnew`.`features` AS `Feature` WHERE `Feature`.`records_id` IN (20597) | 11 | 11 | 0 | |
| SELECT `FeaturesType`.`id`, `FeaturesType`.`name`, `FeaturesType`.`description`, `FeaturesType`.`hidden`, `FeaturesType`.`name_normalized`, `FeaturesType`.`measurement_units_id`, `FeaturesType`.`value_type`, `FeaturesType`.`decimals_number`, `FeaturesType`.`value_min`, `FeaturesType`.`value_max`, `FeaturesType`.`is_multiple_choice`, `FeaturesType`.`multiple_display_type` FROM `baltrade_hurtnew`.`features_types` AS `FeaturesType` WHERE `FeaturesType`.`id` IN (1, 163, 153, 154, 46, 15, 67, 60, 53, 23, 112) AND `FeaturesType`.`hidden` = '0' | 11 | 11 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` IN (8774, 3309, 5290, 6011, 5295, 20, 8776, 5140, 5274, 6773, 5293) | 11 | 11 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Record' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (20597) | 0 | 0 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Producer' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (759) | 0 | 0 | 0 | |
| SELECT DISTINCT `Related`.`records_id_related`
FROM `baltrade_hurtnew`.`relateds` AS `Related`
LEFT JOIN `baltrade_hurtnew`.`records` AS `Record` ON (`Related`.`records_id_related` = `Record`.`id`)
WHERE `Related`.`records_id` IN (20051)
AND (`Related`.`records_id_related` NOT IN (20051))
AND `Related`.`relateds_type` = 0
AND `Record`.`active` = 1 AND `Record`.`price` > 0
ORDER BY `Related`.`priority` asc, `Record`.`times_bought` DESC LIMIT 10 | 0 | 0 | 0 | |
| SELECT DISTINCT `Related`.`records_id_related`
FROM `baltrade_hurtnew`.`relateds` AS `Related`
LEFT JOIN `baltrade_hurtnew`.`records` AS `Record` ON (`Related`.`records_id_related` = `Record`.`id`)
WHERE `Related`.`records_id` IN (20051)
AND (`Related`.`records_id_related` NOT IN (20051))
AND `Related`.`relateds_type` = 1
AND `Record`.`active` = 1 AND `Record`.`price` > 0
ORDER BY `Related`.`priority` asc, `Record`.`times_bought` DESC LIMIT 10 | 0 | 0 | 0 | |
| SELECT DISTINCT `Related`.`records_id_related`
FROM `baltrade_hurtnew`.`relateds` AS `Related`
LEFT JOIN `baltrade_hurtnew`.`records` AS `Record` ON (`Related`.`records_id_related` = `Record`.`id`)
WHERE `Related`.`records_id` IN (20051)
AND (`Related`.`records_id_related` NOT IN (20051))
AND `Related`.`relateds_type` = 2
AND `Record`.`active` = 1 AND `Record`.`price` > 0
ORDER BY `Related`.`priority` asc, `Record`.`times_bought` DESC LIMIT 10 | 0 | 0 | 0 | |
| SELECT DISTINCT IF(`CommonRecord`.`record1_id` IN (20051), `CommonRecord`.`record2_id`, `CommonRecord`.`record1_id`) AS `records_id`
FROM `baltrade_hurtnew`.`common_records` AS `CommonRecord`
LEFT JOIN `baltrade_hurtnew`.`records` AS `Record1` ON (`CommonRecord`.`record1_id` = `Record1`.`id`)
LEFT JOIN `baltrade_hurtnew`.`records` AS `Record2` ON (`CommonRecord`.`record2_id` = `Record2`.`id`)
WHERE `Record2`.`active` = 1 AND `Record2`.`price` > 0
AND `Record1`.`active` = 1 AND `Record1`.`price` > 0
AND `CommonRecord`.`count` > 0
AND ((((`CommonRecord`.`record1_id` IN (20051))
AND (`CommonRecord`.`record2_id` NOT IN (20051))
))
OR (((`CommonRecord`.`record2_id` IN (20051))
AND (`CommonRecord`.`record1_id` NOT IN (20051))
)))
ORDER BY `CommonRecord`.`count` desc, `Record1`.`times_bought` DESC, `Record2`.`times_bought` DESC LIMIT 10 | 0 | 0 | 1 | maybe slow |
| SELECT DISTINCT RecordsPackage.main_records_id AS `records_id`
FROM `baltrade_hurtnew`.`records_packages` AS `RecordsPackage`
LEFT JOIN `baltrade_hurtnew`.`records` AS `Record` ON (`RecordsPackage`.`main_records_id` = `Record`.`id`)
WHERE `Record`.`active` = 1 AND `Record`.`price` > 0 AND `Record`.`id` NOT IN (20051)
AND `RecordsPackage`.`records_id` IN (20051)
ORDER BY `Record`.`times_bought` DESC, `Record`.`priority` asc, `Record`.`visits` DESC LIMIT 10 | 0 | 0 | 0 | |
| SELECT `Record`.`id`, `Record`.`users_id`, `Record`.`producers_id`, `Record`.`title`, `Record`.`title_h1`, `Record`.`shorttitle`, `Record`.`description`, `Record`.`shortdescription`, `Record`.`active`, `Record`.`onmainpage`, `Record`.`priority`, `Record`.`keywords`, `Record`.`opinions_off`, `Record`.`price`, `Record`.`app_id`, `Record`.`shipping_promo`, `Record`.`in_promotion`, `Record`.`vat`, `Record`.`is_hit`, `Record`.`is_new`, `Record`.`is_outlet`, `Record`.`product_of_the_day`, `Record`.`units`, `Record`.`banner_desc`, `Record`.`max_promo`, `Record`.`provider_price`, `Record`.`price2`, `Record`.`price3`, `Record`.`weight`, `Record`.`newsletter_desc`, `Record`.`box_items`, `Record`.`box_items_name`, `Record`.`unlimited_units`, `Record`.`warranty_time`, `Record`.`warranty_description`, `Record`.`availabilities_id`, `Record`.`times_bought`, `Record`.`created`, `Record`.`model`, `Record`.`ceneo_id`, `Record`.`wholesale`, `Record`.`min_margin`, `Record`.`grade`, `Record`.`traders_id`, `Record`.`EAN`, `Record`.`master_EAN`, `Record`.`producer_code`, `Record`.`master_producer_code`, `Record`.`additional_text`, `Record`.`metadescription`, `Record`.`metakeywords`, `Record`.`site_title`, `Record`.`fbtitle`, `Record`.`fbdescription`, `Record`.`ceneo_group_id`, `Record`.`fake_price`, `Record`.`modified`, `Record`.`visits`, `Record`.`per_item`, `Record`.`master_weight`, `Record`.`packages_num`, `Record`.`type`, `Record`.`order_minvalue_required`, `Record`.`order_minvalue_value`, `Record`.`enable_common_records`, `Record`.`active_change_estimated`, `Record`.`active_notes`, `Record`.`active_change_reason`, `Record`.`compatibles_name`, `Record`.`models_name`, `Record`.`active_change_user_id`, `Record`.`active_change_user_name`, `Record`.`active_change_date`, `Record`.`force_availability`, `Record`.`forced_availabilities_id`, `Record`.`special_type`, `Record`.`price4`, `Record`.`price5`, `Record`.`price6`, `Record`.`price7`, `Record`.`force_export_original`, `Record`.`visible`, `Record`.`price_update`, `Record`.`modified_users_id`, `Record`.`prodimporters_id`, `Record`.`description2`, `Record`.`price8`, `Record`.`price9`, `Record`.`price10`, `Record`.`class_name`, `Record`.`popups_id`, `Record`.`google_category_id`, `Record`.`shopee_category_id`, `Record`.`introdescription`, `Record`.`hidden_for_wholesale`, `Record`.`shippings_pricelists_id`, `Record`.`old_description_format`, `Record`.`offer_not_ready`, `Record`.`seo_do_not_index`, `Record`.`max_units_per_order`, `Record`.`additional_order_notification_emails`, `Record`.`send_notification_if_ordered`, `Record`.`dimensions_length`, `Record`.`dimensions_width`, `Record`.`dimensions_height`, `Record`.`points_calculation_type`, `Record`.`points_multiplier`, `Record`.`points_fixed_amount`, `Record`.`is_virtual`, `Record`.`virtual_product_filename`, `Record`.`virtual_product_filename_2`, `Record`.`virtual_product_filename_3`, `Record`.`policies_returns_id`, `Record`.`policies_complaints_id`, `Record`.`policies_warranties_id`, `Record`.`orders_subscriptions_plans_id`, `Record`.`tax_rates_id`, `Record`.`price_min_suggested_by_provider`, `Record`.`last_allegro_offers_auto_generation_attempt`, `Record`.`provider_price_min_suggested_by_provider`, `Record`.`provider_price_suggested_addon`, `Record`.`max_units_left_for_gifts`, `Record`.`current_units_used_for_gifts`, `Record`.`gpsr_templates_id`, `Record`.`safety_information` FROM `baltrade_hurtnew`.`records` AS `Record` WHERE `Record`.`id` = 20051 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Payment`.`id`, `Payment`.`title`, `Payment`.`description`, `Payment`.`additional_info`, `Payment`.`plug_type`, `Payment`.`special_type`, `Payment`.`is_cod`, `Payment`.`mail_title`, `Payment`.`mail_description`, `Payment`.`start_orders_status`, `Payment`.`platnosci_fail_mail_title`, `Payment`.`platnosci_fail_mail_body`, `Payment`.`success_orders_status`, `Payment`.`active`, `Payment`.`priority`, `Payment`.`hidden`, `Payment`.`disabled_if_promo`, `Payment`.`disabled_if_promo_text`, `Payment`.`disabled_text`, `Payment`.`title_internal`, `Payment`.`additional_cost_multiplier`, `Payment`.`additional_cost_per_transaction`, `Payment`.`additional_cost_smart_calculation`, `Payment`.`additional_cost_per_transaction_promo_condition` FROM `baltrade_hurtnew`.`payments` AS `Payment` WHERE `Payment`.`active` = '1' ORDER BY `Payment`.`priority` asc | 5 | 5 | 0 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`records_id` = 20051 ORDER BY `Photo`.`priority` asc, `Photo`.`id` asc | 9 | 9 | 0 | |
| SELECT `Record`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` left join records_datas as RecordsData on RecordsData.records_id=Record.id left join categories_records as CategoriesRecord on CategoriesRecord.records_id=Record.id WHERE `Record`.`active` = '1' AND `Record`.`price` > 0 AND `Record`.`offer_not_ready` = 0 AND `Record`.`special_type` = 0 AND ((`units` > 0) OR (`unlimited_units` = '1')) AND `CategoriesRecord`.`categories_id` IN (3069) AND ((`Record`.`id` IN (21060, 21061, 21062, 21052, 21123, 21122, 21121, 21120, 21119, 21118, 21109, 21270)) OR (`Record`.`id` NOT IN (21057, 21058, 21059, 21053, 21054, 21055))) ORDER BY `Record`.`is_hit` DESC, IF(Record.is_hit OR RecordsData.sold_number_30days IS NULL,Record.times_bought, RecordsData.sold_number_30days) DESC, Record.times_bought DESC, Record.priority asc, Record.id desc LIMIT 40 | 1 | 1 | 0 | |
| SELECT `Record`.`id`, `Record`.`producers_id`, `Record`.`title`, `Record`.`title_h1`, `Record`.`shorttitle`, `Record`.`shortdescription`, `Record`.`active`, `Record`.`opinions_off`, `Record`.`price`, `Record`.`app_id`, `Record`.`shipping_promo`, `Record`.`in_promotion`, `Record`.`vat`, `Record`.`tax_rates_id`, `Record`.`is_hit`, `Record`.`is_new`, `Record`.`is_outlet`, `Record`.`product_of_the_day`, `Record`.`units`, `Record`.`max_promo`, `Record`.`provider_price`, `Record`.`price2`, `Record`.`price3`, `Record`.`weight`, `Record`.`box_items`, `Record`.`box_items_name`, `Record`.`unlimited_units`, `Record`.`warranty_time`, `Record`.`warranty_description`, `Record`.`availabilities_id`, `Record`.`times_bought`, `Record`.`created`, `Record`.`model`, `Record`.`wholesale`, `Record`.`min_margin`, `Record`.`grade`, `Record`.`traders_id`, `Record`.`EAN`, `Record`.`producer_code`, `Record`.`fake_price`, `Record`.`modified`, `Record`.`visits`, `Record`.`per_item`, `Record`.`master_weight`, `Record`.`packages_num`, `Record`.`type`, `Record`.`master_EAN`, `Record`.`master_producer_code`, `Record`.`force_availability`, `Record`.`forced_availabilities_id`, `Record`.`price4`, `Record`.`price5`, `Record`.`price6`, `Record`.`price7`, `Record`.`visible`, `Record`.`prodimporters_id`, `Record`.`price8`, `Record`.`price9`, `Record`.`price10`, `Record`.`shippings_pricelists_id`, `Record`.`class_name`, `Record`.`dimensions_width`, `Record`.`dimensions_height`, `Record`.`dimensions_length`, `Record`.`points_calculation_type`, `Record`.`points_multiplier`, `Record`.`points_fixed_amount`, `Availability`.`id`, `Availability`.`title`, `Availability`.`deliverydaysfrom`, `Availability`.`deliverydaysto`, `Producer`.`id`, `Producer`.`name`, `Producer`.`url`, `Producer`.`link`, `ShippingsPricelist`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` LEFT JOIN `baltrade_hurtnew`.`availabilities` AS `Availability` ON (`Record`.`availabilities_id` = `Availability`.`id`) LEFT JOIN `baltrade_hurtnew`.`producers` AS `Producer` ON (`Record`.`producers_id` = `Producer`.`id`) LEFT JOIN `baltrade_hurtnew`.`shippings_pricelists` AS `ShippingsPricelist` ON (`Record`.`shippings_pricelists_id` = `ShippingsPricelist`.`id`) WHERE `Record`.`id` IN (20597) ORDER BY Field(`Record`.`id`,20597) ASC LIMIT 40 | 1 | 1 | 0 | |
| SELECT `Parameter`.`id`, `Parameter`.`records_id`, `Parameter`.`name`, `Parameter`.`number`, `Parameter`.`hidden`, `Parameter`.`app_id`, `Parameter`.`active`, `Parameter`.`provider_price`, `Parameter`.`price`, `Parameter`.`price2`, `Parameter`.`price3`, `Parameter`.`units`, `Parameter`.`unlimited_units`, `Parameter`.`availabilities_id`, `Parameter`.`created`, `Parameter`.`modified`, `Parameter`.`active_inherit`, `Parameter`.`provider_price_inherit`, `Parameter`.`price_inherit`, `Parameter`.`price2_inherit`, `Parameter`.`price3_inherit`, `Parameter`.`units_inherit`, `Parameter`.`unlimited_units_inherit`, `Parameter`.`availabilities_id_inherit`, `Parameter`.`app_id_inherit`, `Parameter`.`priority`, `Parameter`.`isdefault`, `Parameter`.`price4`, `Parameter`.`price4_inherit`, `Parameter`.`price5`, `Parameter`.`price5_inherit`, `Parameter`.`price6`, `Parameter`.`price6_inherit`, `Parameter`.`price7`, `Parameter`.`price7_inherit`, `Parameter`.`price8`, `Parameter`.`price8_inherit`, `Parameter`.`price9`, `Parameter`.`price9_inherit`, `Parameter`.`price10`, `Parameter`.`price10_inherit`, `Parameter`.`shippings_pricelists_id`, `Parameter`.`shippings_pricelists_id_inherit`, `Parameter`.`weight`, `Parameter`.`weight_inherit`, `Parameter`.`EAN`, `Parameter`.`EAN_inherit`, `Parameter`.`producer_code`, `Parameter`.`producer_code_inherit`, `Parameter`.`dimensions_length`, `Parameter`.`dimensions_length_inherit`, `Parameter`.`dimensions_width`, `Parameter`.`dimensions_width_inherit`, `Parameter`.`dimensions_height`, `Parameter`.`dimensions_height_inherit`, `Parameter`.`points_multiplier`, `Parameter`.`points_multiplier_inherit`, `Parameter`.`points_fixed_amount`, `Parameter`.`points_fixed_amount_inherit`, `Parameter`.`points_calculation_type`, `Parameter`.`points_calculation_type_inherit` FROM `baltrade_hurtnew`.`parameters` AS `Parameter` WHERE `Parameter`.`hidden` = '0' AND `Parameter`.`records_id` = (20597) ORDER BY `Parameter`.`priority` asc, `Parameter`.`name` asc, `Parameter`.`id` asc | 0 | 0 | 0 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`hidden` = '0' AND `Photo`.`records_id` = (20597) ORDER BY `Photo`.`priority` ASC | 6 | 6 | 0 | |
| SELECT `RecordsShippingsCost`.`id`, `RecordsShippingsCost`.`shippings_id`, `RecordsShippingsCost`.`records_id`, `RecordsShippingsCost`.`parameters_id`, `RecordsShippingsCost`.`shippings_pricelists_id`, `RecordsShippingsCost`.`cost_product`, `RecordsShippingsCost`.`cost_basket`, `RecordsShippingsCost`.`cost_product_cod`, `RecordsShippingsCost`.`cost_basket_cod`, `RecordsShippingsCost`.`cost_basket_force`, `RecordsShippingsCost`.`cost_reduce_by_other`, `RecordsShippingsCost`.`cost_reduce_by_other_id`, `RecordsShippingsCost`.`cost_next`, `RecordsShippingsCost`.`amount_in_pack` FROM `baltrade_hurtnew`.`records_shippings_costs` AS `RecordsShippingsCost` WHERE `RecordsShippingsCost`.`records_id` = (20597) | 0 | 0 | 0 | |
| SELECT `RecordsAdditionalProductOption`.`id`, `RecordsAdditionalProductOption`.`additional_product_options_id`, `RecordsAdditionalProductOption`.`records_id`, `RecordsAdditionalProductOption`.`priority` FROM `baltrade_hurtnew`.`records_additional_product_options` AS `RecordsAdditionalProductOption` WHERE `RecordsAdditionalProductOption`.`records_id` = (20597) ORDER BY `RecordsAdditionalProductOption`.`priority` asc, `RecordsAdditionalProductOption`.`id` ASC | 0 | 0 | 0 | |
| SELECT `RecordsPayment`.`id`, `RecordsPayment`.`payments_id`, `RecordsPayment`.`records_id`, `RecordsPayment`.`parameters_id`, `RecordsPayment`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_payments` AS `RecordsPayment` WHERE `RecordsPayment`.`records_id` = (20597) | 0 | 0 | 0 | |
| SELECT `RecordsShipping`.`id`, `RecordsShipping`.`records_id`, `RecordsShipping`.`shippings_id`, `RecordsShipping`.`parameters_id`, `RecordsShipping`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_shippings` AS `RecordsShipping` WHERE `RecordsShipping`.`records_id` = (20597) | 0 | 0 | 0 | |
| SELECT `RecordsPackage`.`id`, `RecordsPackage`.`main_records_id`, `RecordsPackage`.`records_id`, `RecordsPackage`.`index`, `RecordsPackage`.`amount`, `RecordsPackage`.`priority`, `RecordsPackage`.`auto_add_description`, `RecordsPackage`.`auto_add_photos`, `RecordsPackage`.`auto_add_features` FROM `baltrade_hurtnew`.`records_packages` AS `RecordsPackage` WHERE `RecordsPackage`.`main_records_id` = (20597) ORDER BY `RecordsPackage`.`priority` asc | 0 | 0 | 0 | |
| SELECT `RecordsBox`.`id`, `RecordsBox`.`records_id`, `RecordsBox`.`barcode`, `RecordsBox`.`amount`, `RecordsBox`.`synchro_blocked`, `RecordsBox`.`display_state` FROM `baltrade_hurtnew`.`records_boxes` AS `RecordsBox` WHERE `RecordsBox`.`display_state` < 1 AND `RecordsBox`.`records_id` = (20597) ORDER BY `RecordsBox`.`amount` ASC, `RecordsBox`.`barcode` ASC | 0 | 0 | 0 | |
| SELECT `Promo`.`id`, `Promo`.`percent`, `Promo`.`name`, `Promo`.`url_code`, `Promo`.`description`, `Promo`.`date_start`, `Promo`.`date_end`, `Promo`.`is_global`, `Promo`.`hidden`, `Promo`.`promo_type`, `Promo`.`is_for_registered`, `Promo`.`allow_user_activation`, `Promo`.`uses_limit`, `Promo`.`used_count`, `Promo`.`is_used`, `Promo`.`mingain`, `Promo`.`virtual`, `Promo`.`used_amount`, `Promo`.`popup_display`, `Promo`.`popups_id`, `Promo`.`mingain_type`, `Promo`.`percent_safe`, `Promo`.`percent_safe_from_margin`, `Promo`.`show_wholesale`, `Promo`.`units_min`, `Promo`.`turnover_lastmonth_min`, `Promo`.`allow_any_payment`, `Promo`.`auto_activated`, `Promo`.`url_address`, `Promo`.`is_for_newsletter_active_email`, `Promo`.`generate_aliases_for_newsletter_emails`, `Promo`.`affiliate_comission`, `Promo`.`affiliate_users_id`, `Promo`.`priority_group`, `Promo`.`deleted`, `Promo`.`shippings_free_shipping_min_condition`, `Promo`.`payments_additional_cost_per_transaction_condition`, `Promo`.`basket_products_sum_min`, `Promo`.`display_ending_info`, `Promo`.`shops_id`, `Promo`.`is_external`, `Promo`.`external_id`, `Promo`.`promo_terms_description`, `Promo`.`gifts_units_limit`, `Promo`.`gifts_products_limit`, `PromosRecord`.`id`, `PromosRecord`.`records_id`, `PromosRecord`.`promos_id`, `PromosRecord`.`percent`, `PromosRecord`.`promo_type`, `PromosRecord`.`units_min`, `PromosRecord`.`turnover_lastmonth_min`, `PromosRecord`.`created`, `PromosRecord`.`modified`, `PromosRecord`.`basket_products_sum_min` FROM `baltrade_hurtnew`.`promos` AS `Promo` JOIN `baltrade_hurtnew`.`promos_records` AS `PromosRecord` ON (`PromosRecord`.`records_id` = 20597 AND `PromosRecord`.`promos_id` = `Promo`.`id`) | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information`, `CategoriesRecord`.`id`, `CategoriesRecord`.`categories_id`, `CategoriesRecord`.`records_id`, `CategoriesRecord`.`number`, `CategoriesRecord`.`priority`, `CategoriesRecord`.`override_priority` FROM `baltrade_hurtnew`.`categories` AS `Category` JOIN `baltrade_hurtnew`.`categories_records` AS `CategoriesRecord` ON (`CategoriesRecord`.`records_id` = 20597 AND `CategoriesRecord`.`categories_id` = `Category`.`id`) | 2 | 2 | 0 | |
| SELECT `VariantsGroup`.`id`, `VariantsGroup`.`is_visible`, `VariantsGroup`.`name`, `RecordsVariant`.`id`, `RecordsVariant`.`records_id`, `RecordsVariant`.`variants_groups_id`, `RecordsVariant`.`priority` FROM `baltrade_hurtnew`.`variants_groups` AS `VariantsGroup` JOIN `baltrade_hurtnew`.`records_variants` AS `RecordsVariant` ON (`RecordsVariant`.`records_id` = 20597 AND `RecordsVariant`.`variants_groups_id` = `VariantsGroup`.`id`) WHERE `VariantsGroup`.`is_visible` = '1' | 0 | 0 | 0 | |
| SELECT `Feature`.`id`, `Feature`.`features_types_id`, `Feature`.`records_id`, `Feature`.`priority`, `Feature`.`features_values_id`, `Feature`.`parameters_id`, `Feature`.`records_id_parameter`, `Feature`.`feature_general_label` FROM `baltrade_hurtnew`.`features` AS `Feature` WHERE `Feature`.`records_id` IN (20597) | 11 | 11 | 0 | |
| SELECT `FeaturesType`.`id`, `FeaturesType`.`name`, `FeaturesType`.`description`, `FeaturesType`.`hidden`, `FeaturesType`.`name_normalized`, `FeaturesType`.`measurement_units_id`, `FeaturesType`.`value_type`, `FeaturesType`.`decimals_number`, `FeaturesType`.`value_min`, `FeaturesType`.`value_max`, `FeaturesType`.`is_multiple_choice`, `FeaturesType`.`multiple_display_type` FROM `baltrade_hurtnew`.`features_types` AS `FeaturesType` WHERE `FeaturesType`.`id` IN (1, 163, 153, 154, 46, 15, 67, 60, 53, 23, 112) AND `FeaturesType`.`hidden` = '0' | 11 | 11 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` IN (8774, 3309, 5290, 6011, 5295, 20, 8776, 5140, 5274, 6773, 5293) | 11 | 11 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Record' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (20597) | 0 | 0 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Producer' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (759) | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE `Category`.`id` = 3069 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Record`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` left join records_datas as RecordsData on RecordsData.records_id=Record.id left join categories_records as CategoriesRecord on CategoriesRecord.records_id=Record.id WHERE `Record`.`active` = '1' AND `Record`.`price` > 0 AND `Record`.`offer_not_ready` = 0 AND `Record`.`special_type` = 0 AND ((`units` > 0) OR (`unlimited_units` = '1')) AND `CategoriesRecord`.`categories_id` IN (122, 2139, 2566, 3069, 2387) AND ((`Record`.`id` IN (21060, 21061, 21062, 21052, 21123, 21122, 21121, 21120, 21119, 21118, 21109, 21270)) OR (`Record`.`id` NOT IN (21057, 21058, 21059, 21053, 21054, 21055))) ORDER BY `Record`.`is_hit` DESC, IF(Record.is_hit OR RecordsData.sold_number_30days IS NULL,Record.times_bought, RecordsData.sold_number_30days) DESC, Record.times_bought DESC, Record.priority asc, Record.id desc LIMIT 40 | 40 | 40 | 1 | |
| SELECT `Record`.`id`, `Record`.`producers_id`, `Record`.`title`, `Record`.`title_h1`, `Record`.`shorttitle`, `Record`.`shortdescription`, `Record`.`active`, `Record`.`opinions_off`, `Record`.`price`, `Record`.`app_id`, `Record`.`shipping_promo`, `Record`.`in_promotion`, `Record`.`vat`, `Record`.`tax_rates_id`, `Record`.`is_hit`, `Record`.`is_new`, `Record`.`is_outlet`, `Record`.`product_of_the_day`, `Record`.`units`, `Record`.`max_promo`, `Record`.`provider_price`, `Record`.`price2`, `Record`.`price3`, `Record`.`weight`, `Record`.`box_items`, `Record`.`box_items_name`, `Record`.`unlimited_units`, `Record`.`warranty_time`, `Record`.`warranty_description`, `Record`.`availabilities_id`, `Record`.`times_bought`, `Record`.`created`, `Record`.`model`, `Record`.`wholesale`, `Record`.`min_margin`, `Record`.`grade`, `Record`.`traders_id`, `Record`.`EAN`, `Record`.`producer_code`, `Record`.`fake_price`, `Record`.`modified`, `Record`.`visits`, `Record`.`per_item`, `Record`.`master_weight`, `Record`.`packages_num`, `Record`.`type`, `Record`.`master_EAN`, `Record`.`master_producer_code`, `Record`.`force_availability`, `Record`.`forced_availabilities_id`, `Record`.`price4`, `Record`.`price5`, `Record`.`price6`, `Record`.`price7`, `Record`.`visible`, `Record`.`prodimporters_id`, `Record`.`price8`, `Record`.`price9`, `Record`.`price10`, `Record`.`shippings_pricelists_id`, `Record`.`class_name`, `Record`.`dimensions_width`, `Record`.`dimensions_height`, `Record`.`dimensions_length`, `Record`.`points_calculation_type`, `Record`.`points_multiplier`, `Record`.`points_fixed_amount`, `Availability`.`id`, `Availability`.`title`, `Availability`.`deliverydaysfrom`, `Availability`.`deliverydaysto`, `Producer`.`id`, `Producer`.`name`, `Producer`.`url`, `Producer`.`link`, `ShippingsPricelist`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` LEFT JOIN `baltrade_hurtnew`.`availabilities` AS `Availability` ON (`Record`.`availabilities_id` = `Availability`.`id`) LEFT JOIN `baltrade_hurtnew`.`producers` AS `Producer` ON (`Record`.`producers_id` = `Producer`.`id`) LEFT JOIN `baltrade_hurtnew`.`shippings_pricelists` AS `ShippingsPricelist` ON (`Record`.`shippings_pricelists_id` = `ShippingsPricelist`.`id`) WHERE `Record`.`id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) ORDER BY Field(`Record`.`id`,17738,20028,21622,21681,21676,20922,21678,17736,19018,21981,19019,20923,17737,20921,21982,18214,22270,20302,22274,18495,19224,17991,20107,19418,19849,17695,21986,21453,21987,22161,22198,22162,22159,22195,22208,22256,16589,17982,19090,19356) ASC LIMIT 40 | 40 | 40 | 0 | |
| SELECT `Parameter`.`id`, `Parameter`.`records_id`, `Parameter`.`name`, `Parameter`.`number`, `Parameter`.`hidden`, `Parameter`.`app_id`, `Parameter`.`active`, `Parameter`.`provider_price`, `Parameter`.`price`, `Parameter`.`price2`, `Parameter`.`price3`, `Parameter`.`units`, `Parameter`.`unlimited_units`, `Parameter`.`availabilities_id`, `Parameter`.`created`, `Parameter`.`modified`, `Parameter`.`active_inherit`, `Parameter`.`provider_price_inherit`, `Parameter`.`price_inherit`, `Parameter`.`price2_inherit`, `Parameter`.`price3_inherit`, `Parameter`.`units_inherit`, `Parameter`.`unlimited_units_inherit`, `Parameter`.`availabilities_id_inherit`, `Parameter`.`app_id_inherit`, `Parameter`.`priority`, `Parameter`.`isdefault`, `Parameter`.`price4`, `Parameter`.`price4_inherit`, `Parameter`.`price5`, `Parameter`.`price5_inherit`, `Parameter`.`price6`, `Parameter`.`price6_inherit`, `Parameter`.`price7`, `Parameter`.`price7_inherit`, `Parameter`.`price8`, `Parameter`.`price8_inherit`, `Parameter`.`price9`, `Parameter`.`price9_inherit`, `Parameter`.`price10`, `Parameter`.`price10_inherit`, `Parameter`.`shippings_pricelists_id`, `Parameter`.`shippings_pricelists_id_inherit`, `Parameter`.`weight`, `Parameter`.`weight_inherit`, `Parameter`.`EAN`, `Parameter`.`EAN_inherit`, `Parameter`.`producer_code`, `Parameter`.`producer_code_inherit`, `Parameter`.`dimensions_length`, `Parameter`.`dimensions_length_inherit`, `Parameter`.`dimensions_width`, `Parameter`.`dimensions_width_inherit`, `Parameter`.`dimensions_height`, `Parameter`.`dimensions_height_inherit`, `Parameter`.`points_multiplier`, `Parameter`.`points_multiplier_inherit`, `Parameter`.`points_fixed_amount`, `Parameter`.`points_fixed_amount_inherit`, `Parameter`.`points_calculation_type`, `Parameter`.`points_calculation_type_inherit` FROM `baltrade_hurtnew`.`parameters` AS `Parameter` WHERE `Parameter`.`hidden` = '0' AND `Parameter`.`records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) ORDER BY `Parameter`.`priority` asc, `Parameter`.`name` asc, `Parameter`.`id` asc | 0 | 0 | 0 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`hidden` = '0' AND `Photo`.`records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) ORDER BY `Photo`.`priority` ASC | 349 | 349 | 1 | |
| SELECT `RecordsShippingsCost`.`id`, `RecordsShippingsCost`.`shippings_id`, `RecordsShippingsCost`.`records_id`, `RecordsShippingsCost`.`parameters_id`, `RecordsShippingsCost`.`shippings_pricelists_id`, `RecordsShippingsCost`.`cost_product`, `RecordsShippingsCost`.`cost_basket`, `RecordsShippingsCost`.`cost_product_cod`, `RecordsShippingsCost`.`cost_basket_cod`, `RecordsShippingsCost`.`cost_basket_force`, `RecordsShippingsCost`.`cost_reduce_by_other`, `RecordsShippingsCost`.`cost_reduce_by_other_id`, `RecordsShippingsCost`.`cost_next`, `RecordsShippingsCost`.`amount_in_pack` FROM `baltrade_hurtnew`.`records_shippings_costs` AS `RecordsShippingsCost` WHERE `RecordsShippingsCost`.`records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) | 0 | 0 | 0 | |
| SELECT `RecordsAdditionalProductOption`.`id`, `RecordsAdditionalProductOption`.`additional_product_options_id`, `RecordsAdditionalProductOption`.`records_id`, `RecordsAdditionalProductOption`.`priority` FROM `baltrade_hurtnew`.`records_additional_product_options` AS `RecordsAdditionalProductOption` WHERE `RecordsAdditionalProductOption`.`records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) ORDER BY `RecordsAdditionalProductOption`.`priority` asc, `RecordsAdditionalProductOption`.`id` ASC | 0 | 0 | 0 | |
| SELECT `RecordsPayment`.`id`, `RecordsPayment`.`payments_id`, `RecordsPayment`.`records_id`, `RecordsPayment`.`parameters_id`, `RecordsPayment`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_payments` AS `RecordsPayment` WHERE `RecordsPayment`.`records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) | 0 | 0 | 0 | |
| SELECT `RecordsShipping`.`id`, `RecordsShipping`.`records_id`, `RecordsShipping`.`shippings_id`, `RecordsShipping`.`parameters_id`, `RecordsShipping`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_shippings` AS `RecordsShipping` WHERE `RecordsShipping`.`records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) | 8 | 8 | 0 | |
| SELECT `RecordsPackage`.`id`, `RecordsPackage`.`main_records_id`, `RecordsPackage`.`records_id`, `RecordsPackage`.`index`, `RecordsPackage`.`amount`, `RecordsPackage`.`priority`, `RecordsPackage`.`auto_add_description`, `RecordsPackage`.`auto_add_photos`, `RecordsPackage`.`auto_add_features` FROM `baltrade_hurtnew`.`records_packages` AS `RecordsPackage` WHERE `RecordsPackage`.`main_records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) ORDER BY `RecordsPackage`.`priority` asc | 0 | 0 | 0 | |
| SELECT `RecordsBox`.`id`, `RecordsBox`.`records_id`, `RecordsBox`.`barcode`, `RecordsBox`.`amount`, `RecordsBox`.`synchro_blocked`, `RecordsBox`.`display_state` FROM `baltrade_hurtnew`.`records_boxes` AS `RecordsBox` WHERE `RecordsBox`.`display_state` < 1 AND `RecordsBox`.`records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) ORDER BY `RecordsBox`.`amount` ASC, `RecordsBox`.`barcode` ASC | 14 | 14 | 0 | |
| SELECT `Promo`.`id`, `Promo`.`percent`, `Promo`.`name`, `Promo`.`url_code`, `Promo`.`description`, `Promo`.`date_start`, `Promo`.`date_end`, `Promo`.`is_global`, `Promo`.`hidden`, `Promo`.`promo_type`, `Promo`.`is_for_registered`, `Promo`.`allow_user_activation`, `Promo`.`uses_limit`, `Promo`.`used_count`, `Promo`.`is_used`, `Promo`.`mingain`, `Promo`.`virtual`, `Promo`.`used_amount`, `Promo`.`popup_display`, `Promo`.`popups_id`, `Promo`.`mingain_type`, `Promo`.`percent_safe`, `Promo`.`percent_safe_from_margin`, `Promo`.`show_wholesale`, `Promo`.`units_min`, `Promo`.`turnover_lastmonth_min`, `Promo`.`allow_any_payment`, `Promo`.`auto_activated`, `Promo`.`url_address`, `Promo`.`is_for_newsletter_active_email`, `Promo`.`generate_aliases_for_newsletter_emails`, `Promo`.`affiliate_comission`, `Promo`.`affiliate_users_id`, `Promo`.`priority_group`, `Promo`.`deleted`, `Promo`.`shippings_free_shipping_min_condition`, `Promo`.`payments_additional_cost_per_transaction_condition`, `Promo`.`basket_products_sum_min`, `Promo`.`display_ending_info`, `Promo`.`shops_id`, `Promo`.`is_external`, `Promo`.`external_id`, `Promo`.`promo_terms_description`, `Promo`.`gifts_units_limit`, `Promo`.`gifts_products_limit`, `PromosRecord`.`id`, `PromosRecord`.`records_id`, `PromosRecord`.`promos_id`, `PromosRecord`.`percent`, `PromosRecord`.`promo_type`, `PromosRecord`.`units_min`, `PromosRecord`.`turnover_lastmonth_min`, `PromosRecord`.`created`, `PromosRecord`.`modified`, `PromosRecord`.`basket_products_sum_min` FROM `baltrade_hurtnew`.`promos` AS `Promo` JOIN `baltrade_hurtnew`.`promos_records` AS `PromosRecord` ON (`PromosRecord`.`records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) AND `PromosRecord`.`promos_id` = `Promo`.`id`) | 141 | 141 | 1 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information`, `CategoriesRecord`.`id`, `CategoriesRecord`.`categories_id`, `CategoriesRecord`.`records_id`, `CategoriesRecord`.`number`, `CategoriesRecord`.`priority`, `CategoriesRecord`.`override_priority` FROM `baltrade_hurtnew`.`categories` AS `Category` JOIN `baltrade_hurtnew`.`categories_records` AS `CategoriesRecord` ON (`CategoriesRecord`.`records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) AND `CategoriesRecord`.`categories_id` = `Category`.`id`) | 120 | 120 | 1 | |
| SELECT `VariantsGroup`.`id`, `VariantsGroup`.`is_visible`, `VariantsGroup`.`name`, `RecordsVariant`.`id`, `RecordsVariant`.`records_id`, `RecordsVariant`.`variants_groups_id`, `RecordsVariant`.`priority` FROM `baltrade_hurtnew`.`variants_groups` AS `VariantsGroup` JOIN `baltrade_hurtnew`.`records_variants` AS `RecordsVariant` ON (`RecordsVariant`.`records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) AND `RecordsVariant`.`variants_groups_id` = `VariantsGroup`.`id`) WHERE `VariantsGroup`.`is_visible` = '1' | 0 | 0 | 0 | |
| SELECT `Feature`.`id`, `Feature`.`features_types_id`, `Feature`.`records_id`, `Feature`.`priority`, `Feature`.`features_values_id`, `Feature`.`parameters_id`, `Feature`.`records_id_parameter`, `Feature`.`feature_general_label` FROM `baltrade_hurtnew`.`features` AS `Feature` WHERE `Feature`.`records_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) | 538 | 538 | 1 | |
| SELECT `FeaturesType`.`id`, `FeaturesType`.`name`, `FeaturesType`.`description`, `FeaturesType`.`hidden`, `FeaturesType`.`name_normalized`, `FeaturesType`.`measurement_units_id`, `FeaturesType`.`value_type`, `FeaturesType`.`decimals_number`, `FeaturesType`.`value_min`, `FeaturesType`.`value_max`, `FeaturesType`.`is_multiple_choice`, `FeaturesType`.`multiple_display_type` FROM `baltrade_hurtnew`.`features_types` AS `FeaturesType` WHERE `FeaturesType`.`id` IN (1, 163, 153, 28, 154, 46, 27, 15, 67, 60, 93, 14, 53, 168, 169, 170, 171, 111, 192, 140, 210, 196, 201, 36, 84, 23, 7) AND `FeaturesType`.`hidden` = '0' | 27 | 27 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` IN (5206, 3307, 4849, 48, 2886, 4963, 4982, 20, 5207, 2394, 598, 509, 4852, 4943, 4941, 4942, 4944, 4981, 4946, 4947, 4948, 46, 4949, 4950, 4951, 1006, 4891, 4889, 4890, 4892, 4893, 4894, 4895, 4858, 4859, 4896, 4850, 4860, 4851, 4853, 4855, 4856, 4857, 2826, 6696, 3308, 64, 5248, 5143, 6698, 6699, 6728, 6722, 6725, 6724, 6729, 6727, 4953, 4952, 4954, 6220, 9272, 4957, 4958, 4959, 6688, 2889, 5130, 113, 6689, 4888, 4897, 6685, 6683, 6684, 5269, 5127, 4960, 5138, 5268, 4531, 5132, 6661, 6704, 6706, 5264, 5260, 5263, 2461, 5801, 5122, 2892, 5124, 5797, 5140, 6218, 5193, 4975, 6221, 10755, 6222, 6223, 1083, 6290, 7858, 6882, 7859, 80, 7860, 6488, 5003, 5004, 5007, 6489, 6490, 6664, 9271, 9273, 9301, 9287, 9288, 2438, 9274, 9275, 9302, 9303, 9285, 9304, 9278, 9298, 9297, 2418, 9296, 9299, 10217, 10330, 7013, 10329, 10332, 9588, 10387, 4965, 10390, 10391, 10392, 10397, 10399, 10400, 10401, 10403, 10398, 10406, 5254, 4985, 9974, 10407, 10868, 9678, 9607, 10869, 2773, 10870, 10872, 8975, 10210, 10880, 10874, 10875, 10873, 10883, 10884, 10886, 4526, 9144, 10887, 10888, 10890, 11194, 5265, 4987, 11080, 11196, 11081, 11197, 11199, 11200, 2408, 11201, 11265, 11267, 11268, 11269, 11273, 9051, 2762, 11331, 11206, 11205, 11434, 11455, 5252, 11460, 11458, 11459, 11457, 11473, 11472, 11474, 11476, 11479, 11480, 11481) | 212 | 212 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Record' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356) | 0 | 0 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Producer' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (673, 759, 704, 786, 457) | 0 | 0 | 0 | |
| SELECT `Record`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` left join records_datas as RecordsData on RecordsData.records_id=Record.id left join categories_records as CategoriesRecord on CategoriesRecord.records_id=Record.id WHERE `Record`.`active` = '1' AND `Record`.`price` > 0 AND `Record`.`offer_not_ready` = 0 AND `Record`.`special_type` = 0 AND ((`units` > 0) OR (`unlimited_units` = '1')) AND `CategoriesRecord`.`categories_id` IN (3274) AND ((`Record`.`id` IN (21060, 21061, 21062, 21052, 21123, 21122, 21121, 21120, 21119, 21118, 21109, 21270)) OR (`Record`.`id` NOT IN (21057, 21058, 21059, 21053, 21054, 21055))) ORDER BY `Record`.`is_hit` DESC, IF(Record.is_hit OR RecordsData.sold_number_30days IS NULL,Record.times_bought, RecordsData.sold_number_30days) DESC, Record.times_bought DESC, Record.priority asc, Record.id desc LIMIT 40 | 1 | 1 | 0 | |
| SELECT `Record`.`id`, `Record`.`producers_id`, `Record`.`title`, `Record`.`title_h1`, `Record`.`shorttitle`, `Record`.`shortdescription`, `Record`.`active`, `Record`.`opinions_off`, `Record`.`price`, `Record`.`app_id`, `Record`.`shipping_promo`, `Record`.`in_promotion`, `Record`.`vat`, `Record`.`tax_rates_id`, `Record`.`is_hit`, `Record`.`is_new`, `Record`.`is_outlet`, `Record`.`product_of_the_day`, `Record`.`units`, `Record`.`max_promo`, `Record`.`provider_price`, `Record`.`price2`, `Record`.`price3`, `Record`.`weight`, `Record`.`box_items`, `Record`.`box_items_name`, `Record`.`unlimited_units`, `Record`.`warranty_time`, `Record`.`warranty_description`, `Record`.`availabilities_id`, `Record`.`times_bought`, `Record`.`created`, `Record`.`model`, `Record`.`wholesale`, `Record`.`min_margin`, `Record`.`grade`, `Record`.`traders_id`, `Record`.`EAN`, `Record`.`producer_code`, `Record`.`fake_price`, `Record`.`modified`, `Record`.`visits`, `Record`.`per_item`, `Record`.`master_weight`, `Record`.`packages_num`, `Record`.`type`, `Record`.`master_EAN`, `Record`.`master_producer_code`, `Record`.`force_availability`, `Record`.`forced_availabilities_id`, `Record`.`price4`, `Record`.`price5`, `Record`.`price6`, `Record`.`price7`, `Record`.`visible`, `Record`.`prodimporters_id`, `Record`.`price8`, `Record`.`price9`, `Record`.`price10`, `Record`.`shippings_pricelists_id`, `Record`.`class_name`, `Record`.`dimensions_width`, `Record`.`dimensions_height`, `Record`.`dimensions_length`, `Record`.`points_calculation_type`, `Record`.`points_multiplier`, `Record`.`points_fixed_amount`, `Availability`.`id`, `Availability`.`title`, `Availability`.`deliverydaysfrom`, `Availability`.`deliverydaysto`, `Producer`.`id`, `Producer`.`name`, `Producer`.`url`, `Producer`.`link`, `ShippingsPricelist`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` LEFT JOIN `baltrade_hurtnew`.`availabilities` AS `Availability` ON (`Record`.`availabilities_id` = `Availability`.`id`) LEFT JOIN `baltrade_hurtnew`.`producers` AS `Producer` ON (`Record`.`producers_id` = `Producer`.`id`) LEFT JOIN `baltrade_hurtnew`.`shippings_pricelists` AS `ShippingsPricelist` ON (`Record`.`shippings_pricelists_id` = `ShippingsPricelist`.`id`) WHERE `Record`.`id` IN (22016) ORDER BY Field(`Record`.`id`,22016) ASC LIMIT 40 | 1 | 1 | 0 | |
| SELECT `Parameter`.`id`, `Parameter`.`records_id`, `Parameter`.`name`, `Parameter`.`number`, `Parameter`.`hidden`, `Parameter`.`app_id`, `Parameter`.`active`, `Parameter`.`provider_price`, `Parameter`.`price`, `Parameter`.`price2`, `Parameter`.`price3`, `Parameter`.`units`, `Parameter`.`unlimited_units`, `Parameter`.`availabilities_id`, `Parameter`.`created`, `Parameter`.`modified`, `Parameter`.`active_inherit`, `Parameter`.`provider_price_inherit`, `Parameter`.`price_inherit`, `Parameter`.`price2_inherit`, `Parameter`.`price3_inherit`, `Parameter`.`units_inherit`, `Parameter`.`unlimited_units_inherit`, `Parameter`.`availabilities_id_inherit`, `Parameter`.`app_id_inherit`, `Parameter`.`priority`, `Parameter`.`isdefault`, `Parameter`.`price4`, `Parameter`.`price4_inherit`, `Parameter`.`price5`, `Parameter`.`price5_inherit`, `Parameter`.`price6`, `Parameter`.`price6_inherit`, `Parameter`.`price7`, `Parameter`.`price7_inherit`, `Parameter`.`price8`, `Parameter`.`price8_inherit`, `Parameter`.`price9`, `Parameter`.`price9_inherit`, `Parameter`.`price10`, `Parameter`.`price10_inherit`, `Parameter`.`shippings_pricelists_id`, `Parameter`.`shippings_pricelists_id_inherit`, `Parameter`.`weight`, `Parameter`.`weight_inherit`, `Parameter`.`EAN`, `Parameter`.`EAN_inherit`, `Parameter`.`producer_code`, `Parameter`.`producer_code_inherit`, `Parameter`.`dimensions_length`, `Parameter`.`dimensions_length_inherit`, `Parameter`.`dimensions_width`, `Parameter`.`dimensions_width_inherit`, `Parameter`.`dimensions_height`, `Parameter`.`dimensions_height_inherit`, `Parameter`.`points_multiplier`, `Parameter`.`points_multiplier_inherit`, `Parameter`.`points_fixed_amount`, `Parameter`.`points_fixed_amount_inherit`, `Parameter`.`points_calculation_type`, `Parameter`.`points_calculation_type_inherit` FROM `baltrade_hurtnew`.`parameters` AS `Parameter` WHERE `Parameter`.`hidden` = '0' AND `Parameter`.`records_id` = (22016) ORDER BY `Parameter`.`priority` asc, `Parameter`.`name` asc, `Parameter`.`id` asc | 0 | 0 | 0 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`hidden` = '0' AND `Photo`.`records_id` = (22016) ORDER BY `Photo`.`priority` ASC | 13 | 13 | 0 | |
| SELECT `RecordsShippingsCost`.`id`, `RecordsShippingsCost`.`shippings_id`, `RecordsShippingsCost`.`records_id`, `RecordsShippingsCost`.`parameters_id`, `RecordsShippingsCost`.`shippings_pricelists_id`, `RecordsShippingsCost`.`cost_product`, `RecordsShippingsCost`.`cost_basket`, `RecordsShippingsCost`.`cost_product_cod`, `RecordsShippingsCost`.`cost_basket_cod`, `RecordsShippingsCost`.`cost_basket_force`, `RecordsShippingsCost`.`cost_reduce_by_other`, `RecordsShippingsCost`.`cost_reduce_by_other_id`, `RecordsShippingsCost`.`cost_next`, `RecordsShippingsCost`.`amount_in_pack` FROM `baltrade_hurtnew`.`records_shippings_costs` AS `RecordsShippingsCost` WHERE `RecordsShippingsCost`.`records_id` = (22016) | 0 | 0 | 0 | |
| SELECT `RecordsAdditionalProductOption`.`id`, `RecordsAdditionalProductOption`.`additional_product_options_id`, `RecordsAdditionalProductOption`.`records_id`, `RecordsAdditionalProductOption`.`priority` FROM `baltrade_hurtnew`.`records_additional_product_options` AS `RecordsAdditionalProductOption` WHERE `RecordsAdditionalProductOption`.`records_id` = (22016) ORDER BY `RecordsAdditionalProductOption`.`priority` asc, `RecordsAdditionalProductOption`.`id` ASC | 0 | 0 | 0 | |
| SELECT `RecordsPayment`.`id`, `RecordsPayment`.`payments_id`, `RecordsPayment`.`records_id`, `RecordsPayment`.`parameters_id`, `RecordsPayment`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_payments` AS `RecordsPayment` WHERE `RecordsPayment`.`records_id` = (22016) | 0 | 0 | 0 | |
| SELECT `RecordsShipping`.`id`, `RecordsShipping`.`records_id`, `RecordsShipping`.`shippings_id`, `RecordsShipping`.`parameters_id`, `RecordsShipping`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_shippings` AS `RecordsShipping` WHERE `RecordsShipping`.`records_id` = (22016) | 0 | 0 | 0 | |
| SELECT `RecordsPackage`.`id`, `RecordsPackage`.`main_records_id`, `RecordsPackage`.`records_id`, `RecordsPackage`.`index`, `RecordsPackage`.`amount`, `RecordsPackage`.`priority`, `RecordsPackage`.`auto_add_description`, `RecordsPackage`.`auto_add_photos`, `RecordsPackage`.`auto_add_features` FROM `baltrade_hurtnew`.`records_packages` AS `RecordsPackage` WHERE `RecordsPackage`.`main_records_id` = (22016) ORDER BY `RecordsPackage`.`priority` asc | 0 | 0 | 0 | |
| SELECT `RecordsBox`.`id`, `RecordsBox`.`records_id`, `RecordsBox`.`barcode`, `RecordsBox`.`amount`, `RecordsBox`.`synchro_blocked`, `RecordsBox`.`display_state` FROM `baltrade_hurtnew`.`records_boxes` AS `RecordsBox` WHERE `RecordsBox`.`display_state` < 1 AND `RecordsBox`.`records_id` = (22016) ORDER BY `RecordsBox`.`amount` ASC, `RecordsBox`.`barcode` ASC | 1 | 1 | 0 | |
| SELECT `Promo`.`id`, `Promo`.`percent`, `Promo`.`name`, `Promo`.`url_code`, `Promo`.`description`, `Promo`.`date_start`, `Promo`.`date_end`, `Promo`.`is_global`, `Promo`.`hidden`, `Promo`.`promo_type`, `Promo`.`is_for_registered`, `Promo`.`allow_user_activation`, `Promo`.`uses_limit`, `Promo`.`used_count`, `Promo`.`is_used`, `Promo`.`mingain`, `Promo`.`virtual`, `Promo`.`used_amount`, `Promo`.`popup_display`, `Promo`.`popups_id`, `Promo`.`mingain_type`, `Promo`.`percent_safe`, `Promo`.`percent_safe_from_margin`, `Promo`.`show_wholesale`, `Promo`.`units_min`, `Promo`.`turnover_lastmonth_min`, `Promo`.`allow_any_payment`, `Promo`.`auto_activated`, `Promo`.`url_address`, `Promo`.`is_for_newsletter_active_email`, `Promo`.`generate_aliases_for_newsletter_emails`, `Promo`.`affiliate_comission`, `Promo`.`affiliate_users_id`, `Promo`.`priority_group`, `Promo`.`deleted`, `Promo`.`shippings_free_shipping_min_condition`, `Promo`.`payments_additional_cost_per_transaction_condition`, `Promo`.`basket_products_sum_min`, `Promo`.`display_ending_info`, `Promo`.`shops_id`, `Promo`.`is_external`, `Promo`.`external_id`, `Promo`.`promo_terms_description`, `Promo`.`gifts_units_limit`, `Promo`.`gifts_products_limit`, `PromosRecord`.`id`, `PromosRecord`.`records_id`, `PromosRecord`.`promos_id`, `PromosRecord`.`percent`, `PromosRecord`.`promo_type`, `PromosRecord`.`units_min`, `PromosRecord`.`turnover_lastmonth_min`, `PromosRecord`.`created`, `PromosRecord`.`modified`, `PromosRecord`.`basket_products_sum_min` FROM `baltrade_hurtnew`.`promos` AS `Promo` JOIN `baltrade_hurtnew`.`promos_records` AS `PromosRecord` ON (`PromosRecord`.`records_id` = 22016 AND `PromosRecord`.`promos_id` = `Promo`.`id`) | 5 | 5 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information`, `CategoriesRecord`.`id`, `CategoriesRecord`.`categories_id`, `CategoriesRecord`.`records_id`, `CategoriesRecord`.`number`, `CategoriesRecord`.`priority`, `CategoriesRecord`.`override_priority` FROM `baltrade_hurtnew`.`categories` AS `Category` JOIN `baltrade_hurtnew`.`categories_records` AS `CategoriesRecord` ON (`CategoriesRecord`.`records_id` = 22016 AND `CategoriesRecord`.`categories_id` = `Category`.`id`) | 3 | 3 | 0 | |
| SELECT `VariantsGroup`.`id`, `VariantsGroup`.`is_visible`, `VariantsGroup`.`name`, `RecordsVariant`.`id`, `RecordsVariant`.`records_id`, `RecordsVariant`.`variants_groups_id`, `RecordsVariant`.`priority` FROM `baltrade_hurtnew`.`variants_groups` AS `VariantsGroup` JOIN `baltrade_hurtnew`.`records_variants` AS `RecordsVariant` ON (`RecordsVariant`.`records_id` = 22016 AND `RecordsVariant`.`variants_groups_id` = `VariantsGroup`.`id`) WHERE `VariantsGroup`.`is_visible` = '1' | 0 | 0 | 0 | |
| SELECT `Feature`.`id`, `Feature`.`features_types_id`, `Feature`.`records_id`, `Feature`.`priority`, `Feature`.`features_values_id`, `Feature`.`parameters_id`, `Feature`.`records_id_parameter`, `Feature`.`feature_general_label` FROM `baltrade_hurtnew`.`features` AS `Feature` WHERE `Feature`.`records_id` IN (22016) | 8 | 8 | 0 | |
| SELECT `FeaturesType`.`id`, `FeaturesType`.`name`, `FeaturesType`.`description`, `FeaturesType`.`hidden`, `FeaturesType`.`name_normalized`, `FeaturesType`.`measurement_units_id`, `FeaturesType`.`value_type`, `FeaturesType`.`decimals_number`, `FeaturesType`.`value_min`, `FeaturesType`.`value_max`, `FeaturesType`.`is_multiple_choice`, `FeaturesType`.`multiple_display_type` FROM `baltrade_hurtnew`.`features_types` AS `FeaturesType` WHERE `FeaturesType`.`id` IN (6, 1, 190, 105, 10, 61, 84, 153) AND `FeaturesType`.`hidden` = '0' | 8 | 8 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` IN (512, 10948, 8246, 1386, 12, 10953, 10955, 10409) | 8 | 8 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Record' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (22016) | 0 | 0 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Producer' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (673) | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information` FROM `baltrade_hurtnew`.`categories` AS `Category` WHERE `Category`.`id` = 3274 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Record`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` left join records_datas as RecordsData on RecordsData.records_id=Record.id left join categories_records as CategoriesRecord on CategoriesRecord.records_id=Record.id WHERE `Record`.`active` = '1' AND `Record`.`price` > 0 AND `Record`.`offer_not_ready` = 0 AND `Record`.`special_type` = 0 AND ((`units` > 0) OR (`unlimited_units` = '1')) AND `CategoriesRecord`.`categories_id` IN (3272, 3273, 3274, 3275) AND ((`Record`.`id` IN (21060, 21061, 21062, 21052, 21123, 21122, 21121, 21120, 21119, 21118, 21109, 21270)) OR (`Record`.`id` NOT IN (21057, 21058, 21059, 21053, 21054, 21055))) ORDER BY `Record`.`is_hit` DESC, IF(Record.is_hit OR RecordsData.sold_number_30days IS NULL,Record.times_bought, RecordsData.sold_number_30days) DESC, Record.times_bought DESC, Record.priority asc, Record.id desc LIMIT 40 | 40 | 40 | 1 | |
| SELECT `Record`.`id`, `Record`.`producers_id`, `Record`.`title`, `Record`.`title_h1`, `Record`.`shorttitle`, `Record`.`shortdescription`, `Record`.`active`, `Record`.`opinions_off`, `Record`.`price`, `Record`.`app_id`, `Record`.`shipping_promo`, `Record`.`in_promotion`, `Record`.`vat`, `Record`.`tax_rates_id`, `Record`.`is_hit`, `Record`.`is_new`, `Record`.`is_outlet`, `Record`.`product_of_the_day`, `Record`.`units`, `Record`.`max_promo`, `Record`.`provider_price`, `Record`.`price2`, `Record`.`price3`, `Record`.`weight`, `Record`.`box_items`, `Record`.`box_items_name`, `Record`.`unlimited_units`, `Record`.`warranty_time`, `Record`.`warranty_description`, `Record`.`availabilities_id`, `Record`.`times_bought`, `Record`.`created`, `Record`.`model`, `Record`.`wholesale`, `Record`.`min_margin`, `Record`.`grade`, `Record`.`traders_id`, `Record`.`EAN`, `Record`.`producer_code`, `Record`.`fake_price`, `Record`.`modified`, `Record`.`visits`, `Record`.`per_item`, `Record`.`master_weight`, `Record`.`packages_num`, `Record`.`type`, `Record`.`master_EAN`, `Record`.`master_producer_code`, `Record`.`force_availability`, `Record`.`forced_availabilities_id`, `Record`.`price4`, `Record`.`price5`, `Record`.`price6`, `Record`.`price7`, `Record`.`visible`, `Record`.`prodimporters_id`, `Record`.`price8`, `Record`.`price9`, `Record`.`price10`, `Record`.`shippings_pricelists_id`, `Record`.`class_name`, `Record`.`dimensions_width`, `Record`.`dimensions_height`, `Record`.`dimensions_length`, `Record`.`points_calculation_type`, `Record`.`points_multiplier`, `Record`.`points_fixed_amount`, `Availability`.`id`, `Availability`.`title`, `Availability`.`deliverydaysfrom`, `Availability`.`deliverydaysto`, `Producer`.`id`, `Producer`.`name`, `Producer`.`url`, `Producer`.`link`, `ShippingsPricelist`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` LEFT JOIN `baltrade_hurtnew`.`availabilities` AS `Availability` ON (`Record`.`availabilities_id` = `Availability`.`id`) LEFT JOIN `baltrade_hurtnew`.`producers` AS `Producer` ON (`Record`.`producers_id` = `Producer`.`id`) LEFT JOIN `baltrade_hurtnew`.`shippings_pricelists` AS `ShippingsPricelist` ON (`Record`.`shippings_pricelists_id` = `ShippingsPricelist`.`id`) WHERE `Record`.`id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) ORDER BY Field(`Record`.`id`,17738,20028,21681,21676,20922,21678,17736,19018,21981,19019,20923,17737,20921,21982,18214,22270,20302,22274,18495,19224,17991,19418,19849,17695,21986,21453,21987,22161,22198,22162,22159,22195,22208,22256,16589,17982,19090,19356,21176,20003) ASC LIMIT 40 | 40 | 40 | 1 | |
| SELECT `Parameter`.`id`, `Parameter`.`records_id`, `Parameter`.`name`, `Parameter`.`number`, `Parameter`.`hidden`, `Parameter`.`app_id`, `Parameter`.`active`, `Parameter`.`provider_price`, `Parameter`.`price`, `Parameter`.`price2`, `Parameter`.`price3`, `Parameter`.`units`, `Parameter`.`unlimited_units`, `Parameter`.`availabilities_id`, `Parameter`.`created`, `Parameter`.`modified`, `Parameter`.`active_inherit`, `Parameter`.`provider_price_inherit`, `Parameter`.`price_inherit`, `Parameter`.`price2_inherit`, `Parameter`.`price3_inherit`, `Parameter`.`units_inherit`, `Parameter`.`unlimited_units_inherit`, `Parameter`.`availabilities_id_inherit`, `Parameter`.`app_id_inherit`, `Parameter`.`priority`, `Parameter`.`isdefault`, `Parameter`.`price4`, `Parameter`.`price4_inherit`, `Parameter`.`price5`, `Parameter`.`price5_inherit`, `Parameter`.`price6`, `Parameter`.`price6_inherit`, `Parameter`.`price7`, `Parameter`.`price7_inherit`, `Parameter`.`price8`, `Parameter`.`price8_inherit`, `Parameter`.`price9`, `Parameter`.`price9_inherit`, `Parameter`.`price10`, `Parameter`.`price10_inherit`, `Parameter`.`shippings_pricelists_id`, `Parameter`.`shippings_pricelists_id_inherit`, `Parameter`.`weight`, `Parameter`.`weight_inherit`, `Parameter`.`EAN`, `Parameter`.`EAN_inherit`, `Parameter`.`producer_code`, `Parameter`.`producer_code_inherit`, `Parameter`.`dimensions_length`, `Parameter`.`dimensions_length_inherit`, `Parameter`.`dimensions_width`, `Parameter`.`dimensions_width_inherit`, `Parameter`.`dimensions_height`, `Parameter`.`dimensions_height_inherit`, `Parameter`.`points_multiplier`, `Parameter`.`points_multiplier_inherit`, `Parameter`.`points_fixed_amount`, `Parameter`.`points_fixed_amount_inherit`, `Parameter`.`points_calculation_type`, `Parameter`.`points_calculation_type_inherit` FROM `baltrade_hurtnew`.`parameters` AS `Parameter` WHERE `Parameter`.`hidden` = '0' AND `Parameter`.`records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) ORDER BY `Parameter`.`priority` asc, `Parameter`.`name` asc, `Parameter`.`id` asc | 0 | 0 | 0 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`hidden` = '0' AND `Photo`.`records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) ORDER BY `Photo`.`priority` ASC | 344 | 344 | 1 | |
| SELECT `RecordsShippingsCost`.`id`, `RecordsShippingsCost`.`shippings_id`, `RecordsShippingsCost`.`records_id`, `RecordsShippingsCost`.`parameters_id`, `RecordsShippingsCost`.`shippings_pricelists_id`, `RecordsShippingsCost`.`cost_product`, `RecordsShippingsCost`.`cost_basket`, `RecordsShippingsCost`.`cost_product_cod`, `RecordsShippingsCost`.`cost_basket_cod`, `RecordsShippingsCost`.`cost_basket_force`, `RecordsShippingsCost`.`cost_reduce_by_other`, `RecordsShippingsCost`.`cost_reduce_by_other_id`, `RecordsShippingsCost`.`cost_next`, `RecordsShippingsCost`.`amount_in_pack` FROM `baltrade_hurtnew`.`records_shippings_costs` AS `RecordsShippingsCost` WHERE `RecordsShippingsCost`.`records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) | 0 | 0 | 0 | |
| SELECT `RecordsAdditionalProductOption`.`id`, `RecordsAdditionalProductOption`.`additional_product_options_id`, `RecordsAdditionalProductOption`.`records_id`, `RecordsAdditionalProductOption`.`priority` FROM `baltrade_hurtnew`.`records_additional_product_options` AS `RecordsAdditionalProductOption` WHERE `RecordsAdditionalProductOption`.`records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) ORDER BY `RecordsAdditionalProductOption`.`priority` asc, `RecordsAdditionalProductOption`.`id` ASC | 0 | 0 | 0 | |
| SELECT `RecordsPayment`.`id`, `RecordsPayment`.`payments_id`, `RecordsPayment`.`records_id`, `RecordsPayment`.`parameters_id`, `RecordsPayment`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_payments` AS `RecordsPayment` WHERE `RecordsPayment`.`records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) | 0 | 0 | 0 | |
| SELECT `RecordsShipping`.`id`, `RecordsShipping`.`records_id`, `RecordsShipping`.`shippings_id`, `RecordsShipping`.`parameters_id`, `RecordsShipping`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_shippings` AS `RecordsShipping` WHERE `RecordsShipping`.`records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) | 8 | 8 | 0 | |
| SELECT `RecordsPackage`.`id`, `RecordsPackage`.`main_records_id`, `RecordsPackage`.`records_id`, `RecordsPackage`.`index`, `RecordsPackage`.`amount`, `RecordsPackage`.`priority`, `RecordsPackage`.`auto_add_description`, `RecordsPackage`.`auto_add_photos`, `RecordsPackage`.`auto_add_features` FROM `baltrade_hurtnew`.`records_packages` AS `RecordsPackage` WHERE `RecordsPackage`.`main_records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) ORDER BY `RecordsPackage`.`priority` asc | 0 | 0 | 0 | |
| SELECT `RecordsBox`.`id`, `RecordsBox`.`records_id`, `RecordsBox`.`barcode`, `RecordsBox`.`amount`, `RecordsBox`.`synchro_blocked`, `RecordsBox`.`display_state` FROM `baltrade_hurtnew`.`records_boxes` AS `RecordsBox` WHERE `RecordsBox`.`display_state` < 1 AND `RecordsBox`.`records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) ORDER BY `RecordsBox`.`amount` ASC, `RecordsBox`.`barcode` ASC | 13 | 13 | 0 | |
| SELECT `Promo`.`id`, `Promo`.`percent`, `Promo`.`name`, `Promo`.`url_code`, `Promo`.`description`, `Promo`.`date_start`, `Promo`.`date_end`, `Promo`.`is_global`, `Promo`.`hidden`, `Promo`.`promo_type`, `Promo`.`is_for_registered`, `Promo`.`allow_user_activation`, `Promo`.`uses_limit`, `Promo`.`used_count`, `Promo`.`is_used`, `Promo`.`mingain`, `Promo`.`virtual`, `Promo`.`used_amount`, `Promo`.`popup_display`, `Promo`.`popups_id`, `Promo`.`mingain_type`, `Promo`.`percent_safe`, `Promo`.`percent_safe_from_margin`, `Promo`.`show_wholesale`, `Promo`.`units_min`, `Promo`.`turnover_lastmonth_min`, `Promo`.`allow_any_payment`, `Promo`.`auto_activated`, `Promo`.`url_address`, `Promo`.`is_for_newsletter_active_email`, `Promo`.`generate_aliases_for_newsletter_emails`, `Promo`.`affiliate_comission`, `Promo`.`affiliate_users_id`, `Promo`.`priority_group`, `Promo`.`deleted`, `Promo`.`shippings_free_shipping_min_condition`, `Promo`.`payments_additional_cost_per_transaction_condition`, `Promo`.`basket_products_sum_min`, `Promo`.`display_ending_info`, `Promo`.`shops_id`, `Promo`.`is_external`, `Promo`.`external_id`, `Promo`.`promo_terms_description`, `Promo`.`gifts_units_limit`, `Promo`.`gifts_products_limit`, `PromosRecord`.`id`, `PromosRecord`.`records_id`, `PromosRecord`.`promos_id`, `PromosRecord`.`percent`, `PromosRecord`.`promo_type`, `PromosRecord`.`units_min`, `PromosRecord`.`turnover_lastmonth_min`, `PromosRecord`.`created`, `PromosRecord`.`modified`, `PromosRecord`.`basket_products_sum_min` FROM `baltrade_hurtnew`.`promos` AS `Promo` JOIN `baltrade_hurtnew`.`promos_records` AS `PromosRecord` ON (`PromosRecord`.`records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) AND `PromosRecord`.`promos_id` = `Promo`.`id`) | 137 | 137 | 1 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information`, `CategoriesRecord`.`id`, `CategoriesRecord`.`categories_id`, `CategoriesRecord`.`records_id`, `CategoriesRecord`.`number`, `CategoriesRecord`.`priority`, `CategoriesRecord`.`override_priority` FROM `baltrade_hurtnew`.`categories` AS `Category` JOIN `baltrade_hurtnew`.`categories_records` AS `CategoriesRecord` ON (`CategoriesRecord`.`records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) AND `CategoriesRecord`.`categories_id` = `Category`.`id`) | 118 | 118 | 1 | |
| SELECT `VariantsGroup`.`id`, `VariantsGroup`.`is_visible`, `VariantsGroup`.`name`, `RecordsVariant`.`id`, `RecordsVariant`.`records_id`, `RecordsVariant`.`variants_groups_id`, `RecordsVariant`.`priority` FROM `baltrade_hurtnew`.`variants_groups` AS `VariantsGroup` JOIN `baltrade_hurtnew`.`records_variants` AS `RecordsVariant` ON (`RecordsVariant`.`records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) AND `RecordsVariant`.`variants_groups_id` = `VariantsGroup`.`id`) WHERE `VariantsGroup`.`is_visible` = '1' | 0 | 0 | 0 | |
| SELECT `Feature`.`id`, `Feature`.`features_types_id`, `Feature`.`records_id`, `Feature`.`priority`, `Feature`.`features_values_id`, `Feature`.`parameters_id`, `Feature`.`records_id_parameter`, `Feature`.`feature_general_label` FROM `baltrade_hurtnew`.`features` AS `Feature` WHERE `Feature`.`records_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) | 547 | 547 | 1 | |
| SELECT `FeaturesType`.`id`, `FeaturesType`.`name`, `FeaturesType`.`description`, `FeaturesType`.`hidden`, `FeaturesType`.`name_normalized`, `FeaturesType`.`measurement_units_id`, `FeaturesType`.`value_type`, `FeaturesType`.`decimals_number`, `FeaturesType`.`value_min`, `FeaturesType`.`value_max`, `FeaturesType`.`is_multiple_choice`, `FeaturesType`.`multiple_display_type` FROM `baltrade_hurtnew`.`features_types` AS `FeaturesType` WHERE `FeaturesType`.`id` IN (1, 163, 153, 28, 154, 46, 27, 15, 67, 60, 93, 14, 53, 168, 169, 170, 171, 111, 192, 140, 7) AND `FeaturesType`.`hidden` = '0' | 21 | 21 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` IN (5206, 3307, 4849, 48, 2886, 4963, 4982, 20, 5207, 2394, 598, 509, 4852, 4943, 4941, 4942, 4944, 4981, 4946, 4947, 4948, 46, 4949, 4950, 4951, 1006, 4891, 4889, 4890, 4892, 4893, 4894, 4895, 4858, 4859, 4896, 4850, 4860, 4851, 4853, 4855, 4856, 4857, 2826, 6696, 3308, 64, 5248, 5143, 6698, 6699, 6728, 6722, 6725, 6724, 6729, 6727, 4953, 4952, 4954, 6220, 9272, 4957, 4958, 4959, 6688, 2889, 5130, 113, 6689, 4888, 4897, 6685, 6683, 6684, 5269, 5127, 4960, 5138, 5268, 4531, 5132, 6661, 6704, 6706, 5264, 5260, 5263, 2461, 5801, 5122, 2892, 5124, 5797, 5140, 6160, 5003, 5004, 5007, 6161, 6162, 4871, 6666, 6218, 5193, 4975, 6221, 10755, 6222, 6223, 1083, 6290, 6488, 6489, 6490, 6664, 9271, 9273, 9301, 9287, 9288, 2438, 9274, 9275, 9302, 9303, 9285, 9304, 9278, 9298, 9297, 2418, 9296, 9299, 9675, 9678, 9677, 10217, 10387, 4965, 10390, 10391, 10392, 10397, 10399, 10400, 10401, 10403, 10398, 10406, 5254, 4985, 9974, 10407, 10868, 9607, 10869, 2773, 10870, 10872, 8975, 10210, 10880, 10874, 10875, 10873, 10883, 10884, 10886, 4526, 9144, 10887, 10888, 10890, 11194, 5265, 4987, 11080, 11196, 11081, 11197, 11199, 11200, 2408, 11201, 11265, 11267, 11268, 11269, 11273, 9051, 2762, 11331, 11206, 11205, 11434, 11455, 5252, 11460, 11458, 11459, 11457, 11473, 11472, 11474, 11476, 11479, 11480, 11481) | 209 | 209 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Record' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (17738, 20028, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 21176, 20003) | 0 | 0 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Producer' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (673, 759, 704, 786, 457) | 0 | 0 | 0 | |
| SELECT `Record`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` left join records_datas as RecordsData on RecordsData.records_id=Record.id left join categories_records as CategoriesRecord on CategoriesRecord.records_id=Record.id WHERE `Record`.`active` = '1' AND `Record`.`price` > 0 AND `Record`.`offer_not_ready` = 0 AND `Record`.`special_type` = 0 AND ((`units` > 0) OR (`unlimited_units` = '1')) AND `CategoriesRecord`.`categories_id` IN (3342) AND ((`Record`.`id` IN (21060, 21061, 21062, 21052, 21123, 21122, 21121, 21120, 21119, 21118, 21109, 21270)) OR (`Record`.`id` NOT IN (21057, 21058, 21059, 21053, 21054, 21055))) ORDER BY `Record`.`is_hit` DESC, IF(Record.is_hit OR RecordsData.sold_number_30days IS NULL,Record.times_bought, RecordsData.sold_number_30days) DESC, Record.times_bought DESC, Record.priority asc, Record.id desc LIMIT 40 | 35 | 35 | 0 | |
| SELECT `Record`.`id`, `Record`.`producers_id`, `Record`.`title`, `Record`.`title_h1`, `Record`.`shorttitle`, `Record`.`shortdescription`, `Record`.`active`, `Record`.`opinions_off`, `Record`.`price`, `Record`.`app_id`, `Record`.`shipping_promo`, `Record`.`in_promotion`, `Record`.`vat`, `Record`.`tax_rates_id`, `Record`.`is_hit`, `Record`.`is_new`, `Record`.`is_outlet`, `Record`.`product_of_the_day`, `Record`.`units`, `Record`.`max_promo`, `Record`.`provider_price`, `Record`.`price2`, `Record`.`price3`, `Record`.`weight`, `Record`.`box_items`, `Record`.`box_items_name`, `Record`.`unlimited_units`, `Record`.`warranty_time`, `Record`.`warranty_description`, `Record`.`availabilities_id`, `Record`.`times_bought`, `Record`.`created`, `Record`.`model`, `Record`.`wholesale`, `Record`.`min_margin`, `Record`.`grade`, `Record`.`traders_id`, `Record`.`EAN`, `Record`.`producer_code`, `Record`.`fake_price`, `Record`.`modified`, `Record`.`visits`, `Record`.`per_item`, `Record`.`master_weight`, `Record`.`packages_num`, `Record`.`type`, `Record`.`master_EAN`, `Record`.`master_producer_code`, `Record`.`force_availability`, `Record`.`forced_availabilities_id`, `Record`.`price4`, `Record`.`price5`, `Record`.`price6`, `Record`.`price7`, `Record`.`visible`, `Record`.`prodimporters_id`, `Record`.`price8`, `Record`.`price9`, `Record`.`price10`, `Record`.`shippings_pricelists_id`, `Record`.`class_name`, `Record`.`dimensions_width`, `Record`.`dimensions_height`, `Record`.`dimensions_length`, `Record`.`points_calculation_type`, `Record`.`points_multiplier`, `Record`.`points_fixed_amount`, `Availability`.`id`, `Availability`.`title`, `Availability`.`deliverydaysfrom`, `Availability`.`deliverydaysto`, `Producer`.`id`, `Producer`.`name`, `Producer`.`url`, `Producer`.`link`, `ShippingsPricelist`.`id` FROM `baltrade_hurtnew`.`records` AS `Record` LEFT JOIN `baltrade_hurtnew`.`availabilities` AS `Availability` ON (`Record`.`availabilities_id` = `Availability`.`id`) LEFT JOIN `baltrade_hurtnew`.`producers` AS `Producer` ON (`Record`.`producers_id` = `Producer`.`id`) LEFT JOIN `baltrade_hurtnew`.`shippings_pricelists` AS `ShippingsPricelist` ON (`Record`.`shippings_pricelists_id` = `ShippingsPricelist`.`id`) WHERE `Record`.`id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) ORDER BY Field(`Record`.`id`,20302,19224,19418,19849,22161,22162,22159,22208,20003,22165,22206,18020,19225,19844,20427,19333,19078,19331,19819,20004,19332,19334,19772,18992,20597,22103,22189,22203,21798,22164,22102,22160,22184,22187,22186) ASC LIMIT 40 | 35 | 35 | 0 | |
| SELECT `Parameter`.`id`, `Parameter`.`records_id`, `Parameter`.`name`, `Parameter`.`number`, `Parameter`.`hidden`, `Parameter`.`app_id`, `Parameter`.`active`, `Parameter`.`provider_price`, `Parameter`.`price`, `Parameter`.`price2`, `Parameter`.`price3`, `Parameter`.`units`, `Parameter`.`unlimited_units`, `Parameter`.`availabilities_id`, `Parameter`.`created`, `Parameter`.`modified`, `Parameter`.`active_inherit`, `Parameter`.`provider_price_inherit`, `Parameter`.`price_inherit`, `Parameter`.`price2_inherit`, `Parameter`.`price3_inherit`, `Parameter`.`units_inherit`, `Parameter`.`unlimited_units_inherit`, `Parameter`.`availabilities_id_inherit`, `Parameter`.`app_id_inherit`, `Parameter`.`priority`, `Parameter`.`isdefault`, `Parameter`.`price4`, `Parameter`.`price4_inherit`, `Parameter`.`price5`, `Parameter`.`price5_inherit`, `Parameter`.`price6`, `Parameter`.`price6_inherit`, `Parameter`.`price7`, `Parameter`.`price7_inherit`, `Parameter`.`price8`, `Parameter`.`price8_inherit`, `Parameter`.`price9`, `Parameter`.`price9_inherit`, `Parameter`.`price10`, `Parameter`.`price10_inherit`, `Parameter`.`shippings_pricelists_id`, `Parameter`.`shippings_pricelists_id_inherit`, `Parameter`.`weight`, `Parameter`.`weight_inherit`, `Parameter`.`EAN`, `Parameter`.`EAN_inherit`, `Parameter`.`producer_code`, `Parameter`.`producer_code_inherit`, `Parameter`.`dimensions_length`, `Parameter`.`dimensions_length_inherit`, `Parameter`.`dimensions_width`, `Parameter`.`dimensions_width_inherit`, `Parameter`.`dimensions_height`, `Parameter`.`dimensions_height_inherit`, `Parameter`.`points_multiplier`, `Parameter`.`points_multiplier_inherit`, `Parameter`.`points_fixed_amount`, `Parameter`.`points_fixed_amount_inherit`, `Parameter`.`points_calculation_type`, `Parameter`.`points_calculation_type_inherit` FROM `baltrade_hurtnew`.`parameters` AS `Parameter` WHERE `Parameter`.`hidden` = '0' AND `Parameter`.`records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) ORDER BY `Parameter`.`priority` asc, `Parameter`.`name` asc, `Parameter`.`id` asc | 0 | 0 | 0 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`hidden` = '0' AND `Photo`.`records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) ORDER BY `Photo`.`priority` ASC | 283 | 283 | 1 | |
| SELECT `RecordsShippingsCost`.`id`, `RecordsShippingsCost`.`shippings_id`, `RecordsShippingsCost`.`records_id`, `RecordsShippingsCost`.`parameters_id`, `RecordsShippingsCost`.`shippings_pricelists_id`, `RecordsShippingsCost`.`cost_product`, `RecordsShippingsCost`.`cost_basket`, `RecordsShippingsCost`.`cost_product_cod`, `RecordsShippingsCost`.`cost_basket_cod`, `RecordsShippingsCost`.`cost_basket_force`, `RecordsShippingsCost`.`cost_reduce_by_other`, `RecordsShippingsCost`.`cost_reduce_by_other_id`, `RecordsShippingsCost`.`cost_next`, `RecordsShippingsCost`.`amount_in_pack` FROM `baltrade_hurtnew`.`records_shippings_costs` AS `RecordsShippingsCost` WHERE `RecordsShippingsCost`.`records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) | 0 | 0 | 0 | |
| SELECT `RecordsAdditionalProductOption`.`id`, `RecordsAdditionalProductOption`.`additional_product_options_id`, `RecordsAdditionalProductOption`.`records_id`, `RecordsAdditionalProductOption`.`priority` FROM `baltrade_hurtnew`.`records_additional_product_options` AS `RecordsAdditionalProductOption` WHERE `RecordsAdditionalProductOption`.`records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) ORDER BY `RecordsAdditionalProductOption`.`priority` asc, `RecordsAdditionalProductOption`.`id` ASC | 0 | 0 | 0 | |
| SELECT `RecordsPayment`.`id`, `RecordsPayment`.`payments_id`, `RecordsPayment`.`records_id`, `RecordsPayment`.`parameters_id`, `RecordsPayment`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_payments` AS `RecordsPayment` WHERE `RecordsPayment`.`records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) | 0 | 0 | 0 | |
| SELECT `RecordsShipping`.`id`, `RecordsShipping`.`records_id`, `RecordsShipping`.`shippings_id`, `RecordsShipping`.`parameters_id`, `RecordsShipping`.`shippings_pricelists_id` FROM `baltrade_hurtnew`.`records_shippings` AS `RecordsShipping` WHERE `RecordsShipping`.`records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) | 0 | 0 | 0 | |
| SELECT `RecordsPackage`.`id`, `RecordsPackage`.`main_records_id`, `RecordsPackage`.`records_id`, `RecordsPackage`.`index`, `RecordsPackage`.`amount`, `RecordsPackage`.`priority`, `RecordsPackage`.`auto_add_description`, `RecordsPackage`.`auto_add_photos`, `RecordsPackage`.`auto_add_features` FROM `baltrade_hurtnew`.`records_packages` AS `RecordsPackage` WHERE `RecordsPackage`.`main_records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) ORDER BY `RecordsPackage`.`priority` asc | 0 | 0 | 0 | |
| SELECT `RecordsBox`.`id`, `RecordsBox`.`records_id`, `RecordsBox`.`barcode`, `RecordsBox`.`amount`, `RecordsBox`.`synchro_blocked`, `RecordsBox`.`display_state` FROM `baltrade_hurtnew`.`records_boxes` AS `RecordsBox` WHERE `RecordsBox`.`display_state` < 1 AND `RecordsBox`.`records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) ORDER BY `RecordsBox`.`amount` ASC, `RecordsBox`.`barcode` ASC | 0 | 0 | 0 | |
| SELECT `Promo`.`id`, `Promo`.`percent`, `Promo`.`name`, `Promo`.`url_code`, `Promo`.`description`, `Promo`.`date_start`, `Promo`.`date_end`, `Promo`.`is_global`, `Promo`.`hidden`, `Promo`.`promo_type`, `Promo`.`is_for_registered`, `Promo`.`allow_user_activation`, `Promo`.`uses_limit`, `Promo`.`used_count`, `Promo`.`is_used`, `Promo`.`mingain`, `Promo`.`virtual`, `Promo`.`used_amount`, `Promo`.`popup_display`, `Promo`.`popups_id`, `Promo`.`mingain_type`, `Promo`.`percent_safe`, `Promo`.`percent_safe_from_margin`, `Promo`.`show_wholesale`, `Promo`.`units_min`, `Promo`.`turnover_lastmonth_min`, `Promo`.`allow_any_payment`, `Promo`.`auto_activated`, `Promo`.`url_address`, `Promo`.`is_for_newsletter_active_email`, `Promo`.`generate_aliases_for_newsletter_emails`, `Promo`.`affiliate_comission`, `Promo`.`affiliate_users_id`, `Promo`.`priority_group`, `Promo`.`deleted`, `Promo`.`shippings_free_shipping_min_condition`, `Promo`.`payments_additional_cost_per_transaction_condition`, `Promo`.`basket_products_sum_min`, `Promo`.`display_ending_info`, `Promo`.`shops_id`, `Promo`.`is_external`, `Promo`.`external_id`, `Promo`.`promo_terms_description`, `Promo`.`gifts_units_limit`, `Promo`.`gifts_products_limit`, `PromosRecord`.`id`, `PromosRecord`.`records_id`, `PromosRecord`.`promos_id`, `PromosRecord`.`percent`, `PromosRecord`.`promo_type`, `PromosRecord`.`units_min`, `PromosRecord`.`turnover_lastmonth_min`, `PromosRecord`.`created`, `PromosRecord`.`modified`, `PromosRecord`.`basket_products_sum_min` FROM `baltrade_hurtnew`.`promos` AS `Promo` JOIN `baltrade_hurtnew`.`promos_records` AS `PromosRecord` ON (`PromosRecord`.`records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) AND `PromosRecord`.`promos_id` = `Promo`.`id`) | 4 | 4 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`description`, `Category`.`title_h1`, `Category`.`additional_text`, `Category`.`lft`, `Category`.`rght`, `Category`.`count_records`, `Category`.`url`, `Category`.`temp_id`, `Category`.`hidden`, `Category`.`producers_filter`, `Category`.`producers_priority`, `Category`.`price_filter`, `Category`.`price_priority`, `Category`.`imp_catid`, `Category`.`imp_prodgrp`, `Category`.`metakeywords`, `Category`.`metadescription`, `Category`.`site_title`, `Category`.`ceneo_group_id`, `Category`.`main_prio`, `Category`.`on_main`, `Category`.`order_minvalue_required`, `Category`.`order_minvalue_value`, `Category`.`compatibles_name`, `Category`.`max_promo`, `Category`.`models_name`, `Category`.`search_text`, `Category`.`device_filter`, `Category`.`class_name`, `Category`.`popups_id`, `Category`.`google_category_id`, `Category`.`shopee_category_id`, `Category`.`shortdescription`, `Category`.`shorttitle`, `Category`.`hidden_for_records_browsing`, `Category`.`priority_for_breadcrumbs`, `Category`.`safety_information`, `CategoriesRecord`.`id`, `CategoriesRecord`.`categories_id`, `CategoriesRecord`.`records_id`, `CategoriesRecord`.`number`, `CategoriesRecord`.`priority`, `CategoriesRecord`.`override_priority` FROM `baltrade_hurtnew`.`categories` AS `Category` JOIN `baltrade_hurtnew`.`categories_records` AS `CategoriesRecord` ON (`CategoriesRecord`.`records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) AND `CategoriesRecord`.`categories_id` = `Category`.`id`) | 104 | 104 | 0 | |
| SELECT `VariantsGroup`.`id`, `VariantsGroup`.`is_visible`, `VariantsGroup`.`name`, `RecordsVariant`.`id`, `RecordsVariant`.`records_id`, `RecordsVariant`.`variants_groups_id`, `RecordsVariant`.`priority` FROM `baltrade_hurtnew`.`variants_groups` AS `VariantsGroup` JOIN `baltrade_hurtnew`.`records_variants` AS `RecordsVariant` ON (`RecordsVariant`.`records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) AND `RecordsVariant`.`variants_groups_id` = `VariantsGroup`.`id`) WHERE `VariantsGroup`.`is_visible` = '1' | 0 | 0 | 0 | |
| SELECT `Feature`.`id`, `Feature`.`features_types_id`, `Feature`.`records_id`, `Feature`.`priority`, `Feature`.`features_values_id`, `Feature`.`parameters_id`, `Feature`.`records_id_parameter`, `Feature`.`feature_general_label` FROM `baltrade_hurtnew`.`features` AS `Feature` WHERE `Feature`.`records_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) | 436 | 436 | 0 | |
| SELECT `FeaturesType`.`id`, `FeaturesType`.`name`, `FeaturesType`.`description`, `FeaturesType`.`hidden`, `FeaturesType`.`name_normalized`, `FeaturesType`.`measurement_units_id`, `FeaturesType`.`value_type`, `FeaturesType`.`decimals_number`, `FeaturesType`.`value_min`, `FeaturesType`.`value_max`, `FeaturesType`.`is_multiple_choice`, `FeaturesType`.`multiple_display_type` FROM `baltrade_hurtnew`.`features_types` AS `FeaturesType` WHERE `FeaturesType`.`id` IN (1, 163, 153, 28, 154, 46, 27, 15, 67, 93, 14, 53, 192, 60, 61, 111, 23, 112, 7) AND `FeaturesType`.`hidden` = '0' | 19 | 19 | 0 | |
| SELECT `FeaturesValue`.`id`, `FeaturesValue`.`features_types_id`, `FeaturesValue`.`value`, `FeaturesValue`.`value_for_filtering`, `FeaturesValue`.`value_numeric`, `FeaturesValue`.`hidden_for_description`, `FeaturesValue`.`hidden_for_filtering` FROM `baltrade_hurtnew`.`features_values` AS `FeaturesValue` WHERE `FeaturesValue`.`id` IN (5129, 3307, 4849, 5127, 5128, 5130, 4982, 46, 5131, 598, 5132, 4852, 6660, 5137, 5136, 5138, 5133, 20, 5139, 5140, 5198, 5269, 4960, 5268, 4531, 6661, 5266, 5142, 5141, 5143, 5144, 5145, 5192, 5195, 5193, 5194, 4954, 5196, 818, 5255, 5252, 5253, 5257, 5258, 6662, 5264, 5260, 5263, 2461, 5723, 100, 5749, 2951, 4944, 4981, 5750, 2090, 5796, 5122, 2892, 5124, 5797, 5801, 6160, 5003, 5004, 5007, 6161, 6162, 4871, 6666, 6163, 6488, 6489, 6490, 6664, 6659, 8774, 3309, 5290, 6011, 5295, 8776, 5274, 6773, 5293, 10608, 10589, 8983, 10591, 10596, 1083, 10595, 11079, 4941, 5265, 4987, 11080, 2394, 11081, 11194, 11196, 11197, 11198, 11199, 11200, 5254, 2408, 11201, 11202, 11206, 11205, 11209, 11233, 11235, 11236, 11237, 11289, 11288, 11299, 11298, 11325, 4874, 6755, 5247, 4873, 11329, 11331) | 128 | 128 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Record' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (20302, 19224, 19418, 19849, 22161, 22162, 22159, 22208, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 20597, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186) | 0 | 0 | 0 | |
| SELECT `SeoUrl`.`id`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`isold`, `SeoUrl`.`languages_id`, `SeoUrl`.`model`, `SeoUrl`.`objects_id`, `SeoUrl`.`created`, `SeoUrl`.`modified`, `SeoUrl`.`type`, `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`redirect_header`, `SeoUrl`.`force_seourl_enabled`, `SeoUrl`.`shops_id` FROM `baltrade_hurtnew`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Producer' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 1 AND `force_seourl_enabled` = '1' AND `SeoUrl`.`objects_id` IN (759) | 0 | 0 | 0 | |
| SELECT `Popup`.`id`, `Popup`.`name`, `Popup`.`show_title`, `Popup`.`title`, `Popup`.`body`, `Popup`.`priority`, `Popup`.`active`, `Popup`.`date_start`, `Popup`.`date_end`, `Popup`.`type`, `Popup`.`displayed_count`, `Popup`.`cookie_days`, `Popup`.`languages_id`, `Popup`.`disable_close`, `Popup`.`display_repeat_if_no_postcode` FROM `baltrade_hurtnew`.`popups` AS `Popup` WHERE `Popup`.`date_start` <= '2026-05-29 18:05' AND `Popup`.`date_end` >= '2026-05-29 18:05' AND `Popup`.`active` = '1' AND `Popup`.`languages_id` = 1 AND `Popup`.`type` = 0 ORDER BY `Popup`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `RecordsLanguage`.`id`, `RecordsLanguage`.`title`, `RecordsLanguage`.`title_h1`, `RecordsLanguage`.`shorttitle`, `RecordsLanguage`.`description`, `RecordsLanguage`.`shortdescription`, `RecordsLanguage`.`keywords`, `RecordsLanguage`.`box_items_name`, `RecordsLanguage`.`metakeywords`, `RecordsLanguage`.`metadescription`, `RecordsLanguage`.`site_title`, `RecordsLanguage`.`fbdescription`, `RecordsLanguage`.`fbtitle`, `RecordsLanguage`.`banner_desc`, `RecordsLanguage`.`newsletter_desc`, `RecordsLanguage`.`languages_id`, `RecordsLanguage`.`records_id`, `RecordsLanguage`.`description2`, `RecordsLanguage`.`introdescription`, `RecordsLanguage`.`additional_text`, `RecordsLanguage`.`date_created`, `RecordsLanguage`.`author_created`, `RecordsLanguage`.`author_created_text`, `RecordsLanguage`.`created_type`, `RecordsLanguage`.`date_modified`, `RecordsLanguage`.`author_modified`, `RecordsLanguage`.`author_modified_text`, `RecordsLanguage`.`modified_type`, `RecordsLanguage`.`safety_information` FROM `baltrade_hurtnew`.`records_languages` AS `RecordsLanguage` WHERE `RecordsLanguage`.`languages_id` = 3 AND `RecordsLanguage`.`records_id` IN (20597, 17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 22016, 21176, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186, 20051) | 70 | 70 | 2 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`records_id` = 20051 ORDER BY `Photo`.`priority` asc, `Photo`.`id` asc | 9 | 9 | 0 | |
| SELECT `RecordsLanguage`.`id`, `RecordsLanguage`.`title`, `RecordsLanguage`.`title_h1`, `RecordsLanguage`.`shorttitle`, `RecordsLanguage`.`description`, `RecordsLanguage`.`shortdescription`, `RecordsLanguage`.`keywords`, `RecordsLanguage`.`box_items_name`, `RecordsLanguage`.`metakeywords`, `RecordsLanguage`.`metadescription`, `RecordsLanguage`.`site_title`, `RecordsLanguage`.`fbdescription`, `RecordsLanguage`.`fbtitle`, `RecordsLanguage`.`banner_desc`, `RecordsLanguage`.`newsletter_desc`, `RecordsLanguage`.`languages_id`, `RecordsLanguage`.`records_id`, `RecordsLanguage`.`description2`, `RecordsLanguage`.`introdescription`, `RecordsLanguage`.`additional_text`, `RecordsLanguage`.`date_created`, `RecordsLanguage`.`author_created`, `RecordsLanguage`.`author_created_text`, `RecordsLanguage`.`created_type`, `RecordsLanguage`.`date_modified`, `RecordsLanguage`.`author_modified`, `RecordsLanguage`.`author_modified_text`, `RecordsLanguage`.`modified_type`, `RecordsLanguage`.`safety_information` FROM `baltrade_hurtnew`.`records_languages` AS `RecordsLanguage` WHERE `RecordsLanguage`.`languages_id` = 4 AND `RecordsLanguage`.`records_id` IN (20597, 17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 22016, 21176, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186, 20051) | 70 | 70 | 2 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`records_id` = 20051 ORDER BY `Photo`.`priority` asc, `Photo`.`id` asc | 9 | 9 | 0 | |
| SELECT `RecordsLanguage`.`id`, `RecordsLanguage`.`title`, `RecordsLanguage`.`title_h1`, `RecordsLanguage`.`shorttitle`, `RecordsLanguage`.`description`, `RecordsLanguage`.`shortdescription`, `RecordsLanguage`.`keywords`, `RecordsLanguage`.`box_items_name`, `RecordsLanguage`.`metakeywords`, `RecordsLanguage`.`metadescription`, `RecordsLanguage`.`site_title`, `RecordsLanguage`.`fbdescription`, `RecordsLanguage`.`fbtitle`, `RecordsLanguage`.`banner_desc`, `RecordsLanguage`.`newsletter_desc`, `RecordsLanguage`.`languages_id`, `RecordsLanguage`.`records_id`, `RecordsLanguage`.`description2`, `RecordsLanguage`.`introdescription`, `RecordsLanguage`.`additional_text`, `RecordsLanguage`.`date_created`, `RecordsLanguage`.`author_created`, `RecordsLanguage`.`author_created_text`, `RecordsLanguage`.`created_type`, `RecordsLanguage`.`date_modified`, `RecordsLanguage`.`author_modified`, `RecordsLanguage`.`author_modified_text`, `RecordsLanguage`.`modified_type`, `RecordsLanguage`.`safety_information` FROM `baltrade_hurtnew`.`records_languages` AS `RecordsLanguage` WHERE `RecordsLanguage`.`languages_id` = 5 AND `RecordsLanguage`.`records_id` IN (20597, 17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 22016, 21176, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186, 20051) | 70 | 70 | 2 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`records_id` = 20051 ORDER BY `Photo`.`priority` asc, `Photo`.`id` asc | 9 | 9 | 0 | |
| SELECT `RecordsLanguage`.`id`, `RecordsLanguage`.`title`, `RecordsLanguage`.`title_h1`, `RecordsLanguage`.`shorttitle`, `RecordsLanguage`.`description`, `RecordsLanguage`.`shortdescription`, `RecordsLanguage`.`keywords`, `RecordsLanguage`.`box_items_name`, `RecordsLanguage`.`metakeywords`, `RecordsLanguage`.`metadescription`, `RecordsLanguage`.`site_title`, `RecordsLanguage`.`fbdescription`, `RecordsLanguage`.`fbtitle`, `RecordsLanguage`.`banner_desc`, `RecordsLanguage`.`newsletter_desc`, `RecordsLanguage`.`languages_id`, `RecordsLanguage`.`records_id`, `RecordsLanguage`.`description2`, `RecordsLanguage`.`introdescription`, `RecordsLanguage`.`additional_text`, `RecordsLanguage`.`date_created`, `RecordsLanguage`.`author_created`, `RecordsLanguage`.`author_created_text`, `RecordsLanguage`.`created_type`, `RecordsLanguage`.`date_modified`, `RecordsLanguage`.`author_modified`, `RecordsLanguage`.`author_modified_text`, `RecordsLanguage`.`modified_type`, `RecordsLanguage`.`safety_information` FROM `baltrade_hurtnew`.`records_languages` AS `RecordsLanguage` WHERE `RecordsLanguage`.`languages_id` = 7 AND `RecordsLanguage`.`records_id` IN (20597, 17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 22016, 21176, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186, 20051) | 70 | 70 | 2 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`records_id` = 20051 ORDER BY `Photo`.`priority` asc, `Photo`.`id` asc | 9 | 9 | 0 | |
| SELECT `RecordsLanguage`.`id`, `RecordsLanguage`.`title`, `RecordsLanguage`.`title_h1`, `RecordsLanguage`.`shorttitle`, `RecordsLanguage`.`description`, `RecordsLanguage`.`shortdescription`, `RecordsLanguage`.`keywords`, `RecordsLanguage`.`box_items_name`, `RecordsLanguage`.`metakeywords`, `RecordsLanguage`.`metadescription`, `RecordsLanguage`.`site_title`, `RecordsLanguage`.`fbdescription`, `RecordsLanguage`.`fbtitle`, `RecordsLanguage`.`banner_desc`, `RecordsLanguage`.`newsletter_desc`, `RecordsLanguage`.`languages_id`, `RecordsLanguage`.`records_id`, `RecordsLanguage`.`description2`, `RecordsLanguage`.`introdescription`, `RecordsLanguage`.`additional_text`, `RecordsLanguage`.`date_created`, `RecordsLanguage`.`author_created`, `RecordsLanguage`.`author_created_text`, `RecordsLanguage`.`created_type`, `RecordsLanguage`.`date_modified`, `RecordsLanguage`.`author_modified`, `RecordsLanguage`.`author_modified_text`, `RecordsLanguage`.`modified_type`, `RecordsLanguage`.`safety_information` FROM `baltrade_hurtnew`.`records_languages` AS `RecordsLanguage` WHERE `RecordsLanguage`.`languages_id` = 6 AND `RecordsLanguage`.`records_id` IN (20597, 17738, 20028, 21622, 21681, 21676, 20922, 21678, 17736, 19018, 21981, 19019, 20923, 17737, 20921, 21982, 18214, 22270, 20302, 22274, 18495, 19224, 17991, 20107, 19418, 19849, 17695, 21986, 21453, 21987, 22161, 22198, 22162, 22159, 22195, 22208, 22256, 16589, 17982, 19090, 19356, 22016, 21176, 20003, 22165, 22206, 18020, 19225, 19844, 20427, 19333, 19078, 19331, 19819, 20004, 19332, 19334, 19772, 18992, 22103, 22189, 22203, 21798, 22164, 22102, 22160, 22184, 22187, 22186, 20051) | 70 | 70 | 3 | |
| SELECT `Photo`.`id`, `Photo`.`records_id`, `Photo`.`title`, `Photo`.`url`, `Photo`.`filename`, `Photo`.`priority`, `Photo`.`hidden`, `Photo`.`watermark`, `Photo`.`files_id`, `Photo`.`modified`, `Photo`.`variants_specific` FROM `baltrade_hurtnew`.`photos` AS `Photo` WHERE `Photo`.`records_id` = 20051 ORDER BY `Photo`.`priority` asc, `Photo`.`id` asc | 9 | 9 | 0 | |