Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args` FROM `fillerpharma_sklep`.`seo_urls` AS `SeoUrl` WHERE `type` = '1' AND `shops_id` = 0 AND `force_seourl_enabled` = '1' ORDER BY `isold` asc, `modified` desc | 0 | 0 | 1 | maybe slow |
SELECT `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`redirect_header` FROM `fillerpharma_sklep`.`seo_urls` AS `SeoUrl` WHERE `url` = 'dermaheal-hl-10x5ml/lang:UKR/curr:PLN' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 0 LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `SeoUrl`.`force_other_url`, `SeoUrl`.`other_url`, `SeoUrl`.`url`, `SeoUrl`.`prefix`, `SeoUrl`.`plugin`, `SeoUrl`.`controller`, `SeoUrl`.`action`, `SeoUrl`.`args`, `SeoUrl`.`redirect_header` FROM `fillerpharma_sklep`.`seo_urls` AS `SeoUrl` WHERE `url` = 'dermaheal-hl-10x5ml' AND `isold` = '0' AND `type` = '0' AND `shops_id` = 0 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`shops_id` FROM `fillerpharma_sklep`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 't37v65th8fkcn20a5nhk5n9s15' AND `Session`.`shops_id` = 0 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Globalvariable`.`id`, `Globalvariable`.`name`, `Globalvariable`.`content`, `Globalvariable`.`created`, `Globalvariable`.`shops_id` FROM `fillerpharma_sklep`.`globalvariables` AS `Globalvariable` WHERE `name` = 'currencies_costs_obtain' AND `shops_id` = 0 LIMIT 1 | 1 | 1 | 0 | |
BEGIN | | | | |
INSERT INTO `fillerpharma_sklep`.`stats_allenters` (`isajax`, `cookies`, `is_bot`, `is_cron`, `shops_id`, `referer`, `address`, `url`, `date`, `host`, `redirect_status`, `google_keywords`, `ip_address`, `referer_domain`, `browser`, `enters`, `enters_global`, `uid`, `user_agent`, `bot_name`, `action_prefix`, `users_id`, `user_type`) VALUES ('0', '{\"records_per_page\":null}', '1', '0', 0, NULL, 'records/records/view/308/lang:UKR/curr:PLN', '/dermaheal-hl-10x5ml/lang:UKR/curr:PLN', '2025-08-08 14:05:10', '216.73.216.209', '200', NULL, '216.73.216.209', NULL, NULL, 2, 2, '1754654708_287750271_1f02b683c614e96b27f', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'mozilla/5.0 applewebkit/537.36 (khtml, like gecko; compatible; claudebot/1.0; +claudebot@anthropic.com)', '', NULL, NULL) | 1 | 1 | 1 | |
COMMIT | | | | |
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` FROM `fillerpharma_sklep`.`categories` AS `Category` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Producer`.`id`, `Producer`.`name` FROM `fillerpharma_sklep`.`producers` AS `Producer` WHERE `Producer`.`for_compatible_devices` = '1' ORDER BY `Producer`.`name` 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` FROM `fillerpharma_sklep`.`promos` AS `Promo` WHERE `Promo`.`date_start` <= '2025-08-08 14:05:10' AND `Promo`.`date_end` >= '2025-08-08 14:05:10' AND `Promo`.`is_global` = '1' AND `Promo`.`deleted` = '0' AND `Promo`.`shops_id` = 0 AND `Promo`.`allow_user_activation` = '1' | 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`, `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 `fillerpharma_sklep`.`banners_slides` AS `BannersSlide` LEFT JOIN `fillerpharma_sklep`.`records` AS `Record` ON (`BannersSlide`.`type`=1 AND `BannersSlide`.`records_id` = `Record`.`id`) LEFT JOIN `fillerpharma_sklep`.`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` <= '2025-08-08 14:05:10')) AND ((`BannersSlide`.`limit_date_to` = '0') OR (`BannersSlide`.`date_to` >= '2025-08-08 14:05:10')) AND `BannersSlide`.`languages_id` = 3 AND `BannersSlide`.`place` = 2 AND `BannersSlide`.`hidden_for_users_std` = '0' ORDER BY `BannersSlide`.`priority` desc, RAND() ASC LIMIT 12 | 0 | 0 | 3 | 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`, `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 `fillerpharma_sklep`.`records` AS `Record` LEFT JOIN `fillerpharma_sklep`.`availabilities` AS `Availability` ON (`Record`.`availabilities_id` = `Availability`.`id`) LEFT JOIN `fillerpharma_sklep`.`availabilities` AS `AvailabilityForced` ON (`Record`.`forced_availabilities_id` = `AvailabilityForced`.`id`) LEFT JOIN `fillerpharma_sklep`.`producers` AS `Producer` ON (`Record`.`producers_id` = `Producer`.`id`) LEFT JOIN `fillerpharma_sklep`.`producers` AS `Prodimporter` ON (`Record`.`prodimporters_id` = `Prodimporter`.`id`) LEFT JOIN `fillerpharma_sklep`.`traders` AS `Trader` ON (`Record`.`traders_id` = `Trader`.`id`) LEFT JOIN `fillerpharma_sklep`.`shippings_pricelists` AS `ShippingsPricelist` ON (`Record`.`shippings_pricelists_id` = `ShippingsPricelist`.`id`) LEFT JOIN `fillerpharma_sklep`.`orders_subscriptions_plans` AS `OrdersSubscriptionsPlan` ON (`Record`.`orders_subscriptions_plans_id` = `OrdersSubscriptionsPlan`.`id`) WHERE `Record`.`id` = 308 LIMIT 1 | 1 | 1 | 2 | maybe slow |
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 `fillerpharma_sklep`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Record' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`objects_id` = (308) | 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 `fillerpharma_sklep`.`parameters` AS `Parameter` WHERE `Parameter`.`hidden` = '0' AND `Parameter`.`records_id` = (308) ORDER BY `Parameter`.`priority` desc, `Parameter`.`name` asc, `Parameter`.`id` asc | 0 | 0 | 1 | maybe slow |
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 `fillerpharma_sklep`.`photos` AS `Photo` WHERE `Photo`.`hidden` = '0' AND `Photo`.`records_id` = (308) ORDER BY `Photo`.`priority` desc | 1 | 1 | 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 `fillerpharma_sklep`.`records_shippings_costs` AS `RecordsShippingsCost` WHERE `RecordsShippingsCost`.`records_id` = (308) | 0 | 0 | 0 | |
SELECT `RecordsAdditionalProductOption`.`id`, `RecordsAdditionalProductOption`.`additional_product_options_id`, `RecordsAdditionalProductOption`.`records_id`, `RecordsAdditionalProductOption`.`priority` FROM `fillerpharma_sklep`.`records_additional_product_options` AS `RecordsAdditionalProductOption` WHERE `RecordsAdditionalProductOption`.`records_id` = (308) ORDER BY `RecordsAdditionalProductOption`.`priority` desc, `RecordsAdditionalProductOption`.`id` ASC | 0 | 0 | 0 | |
SELECT `RecordsMovie`.`id`, `RecordsMovie`.`records_id`, `RecordsMovie`.`movies_id`, `RecordsMovie`.`priority`, `RecordsMovie`.`hidden` FROM `fillerpharma_sklep`.`records_movies` AS `RecordsMovie` WHERE `RecordsMovie`.`hidden` = '0' AND `RecordsMovie`.`records_id` = (308) ORDER BY `RecordsMovie`.`priority` desc | 0 | 0 | 0 | |
SELECT `RecordsPayment`.`id`, `RecordsPayment`.`payments_id`, `RecordsPayment`.`records_id`, `RecordsPayment`.`parameters_id`, `RecordsPayment`.`shippings_pricelists_id` FROM `fillerpharma_sklep`.`records_payments` AS `RecordsPayment` WHERE `RecordsPayment`.`records_id` = (308) | 0 | 0 | 0 | |
SELECT `RecordsShipping`.`id`, `RecordsShipping`.`records_id`, `RecordsShipping`.`shippings_id`, `RecordsShipping`.`parameters_id`, `RecordsShipping`.`shippings_pricelists_id` FROM `fillerpharma_sklep`.`records_shippings` AS `RecordsShipping` WHERE `RecordsShipping`.`records_id` = (308) | 0 | 0 | 0 | |
SELECT `RecordsName`.`id`, `RecordsName`.`records_id`, `RecordsName`.`title`, `RecordsName`.`producers_id` FROM `fillerpharma_sklep`.`records_names` AS `RecordsName` WHERE `RecordsName`.`records_id` = (308) 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 `fillerpharma_sklep`.`records_packages` AS `RecordsPackage` WHERE `RecordsPackage`.`main_records_id` = (308) ORDER BY `RecordsPackage`.`priority` DESC | 0 | 0 | 0 | |
SELECT `RecordsBox`.`id`, `RecordsBox`.`records_id`, `RecordsBox`.`barcode`, `RecordsBox`.`amount`, `RecordsBox`.`synchro_blocked`, `RecordsBox`.`display_state` FROM `fillerpharma_sklep`.`records_boxes` AS `RecordsBox` WHERE `RecordsBox`.`display_state` < 1 AND `RecordsBox`.`records_id` = (308) 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 `fillerpharma_sklep`.`promos` AS `Promo` JOIN `fillerpharma_sklep`.`promos_records` AS `PromosRecord` ON (`PromosRecord`.`records_id` = 308 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`, `CategoriesRecord`.`id`, `CategoriesRecord`.`categories_id`, `CategoriesRecord`.`records_id`, `CategoriesRecord`.`number`, `CategoriesRecord`.`priority`, `CategoriesRecord`.`override_priority` FROM `fillerpharma_sklep`.`categories` AS `Category` JOIN `fillerpharma_sklep`.`categories_records` AS `CategoriesRecord` ON (`CategoriesRecord`.`records_id` = 308 AND `CategoriesRecord`.`categories_id` = `Category`.`id`) | 1 | 1 | 1 | |
SELECT `VariantsGroup`.`id`, `VariantsGroup`.`is_visible`, `VariantsGroup`.`name`, `RecordsVariant`.`id`, `RecordsVariant`.`records_id`, `RecordsVariant`.`variants_groups_id`, `RecordsVariant`.`priority` FROM `fillerpharma_sklep`.`variants_groups` AS `VariantsGroup` JOIN `fillerpharma_sklep`.`records_variants` AS `RecordsVariant` ON (`RecordsVariant`.`records_id` = 308 AND `RecordsVariant`.`variants_groups_id` = `VariantsGroup`.`id`) WHERE `VariantsGroup`.`is_visible` = '1' | 0 | 0 | 0 | |
SELECT `TaxRate`.`id`, `TaxRate`.`tax_rate_percent` FROM `fillerpharma_sklep`.`tax_rates` AS `TaxRate` WHERE 1 = 1 ORDER BY `display_priority` desc | 74 | 74 | 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 `fillerpharma_sklep`.`countries` AS `Country` WHERE `isdefault` = '1' AND `deleted` = '0' AND `approved` = '1' LIMIT 1 | 1 | 1 | 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 `fillerpharma_sklep`.`orders_subscriptions_periods` AS `OrdersSubscriptionsPeriod` WHERE `orders_subscriptions_plans_id` IS NULL | 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` FROM `fillerpharma_sklep`.`records_languages` AS `RecordsLanguage` WHERE `RecordsLanguage`.`languages_id` = 3 AND `RecordsLanguage`.`records_id` IN (308) | 1 | 1 | 1 | |
SELECT `Translation`.`id`, `Translation`.`table_name`, `Translation`.`field`, `Translation`.`languages_id`, `Translation`.`value`, `Translation`.`enable`, `Translation`.`object_id` FROM `fillerpharma_sklep`.`translations` AS `Translation` WHERE `Translation`.`languages_id` = 3 AND `Translation`.`object_id` = 1 AND `Translation`.`table_name` = 'Availability' | 2 | 2 | 4 | maybe slow |
SELECT `Translation`.`id`, `Translation`.`table_name`, `Translation`.`field`, `Translation`.`languages_id`, `Translation`.`value`, `Translation`.`enable`, `Translation`.`object_id` FROM `fillerpharma_sklep`.`translations` AS `Translation` WHERE `Translation`.`languages_id` = 3 AND `Translation`.`object_id` = 1 AND `Translation`.`table_name` = 'AvailabilityForced' | 0 | 0 | 1 | maybe slow |
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 `fillerpharma_sklep`.`comments` AS `Comment` WHERE `Comment`.`record_id` = 308 AND `Comment`.`active` = '1' AND `Comment`.`comment_type` = 0 ORDER BY `Comment`.`lft` desc | 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 `fillerpharma_sklep`.`comments` AS `Comment` WHERE `Comment`.`record_id` = 308 AND `Comment`.`active` = '1' AND `Comment`.`comment_type` = 1 ORDER BY `Comment`.`lft` desc | 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 `fillerpharma_sklep`.`files_downloads` AS `FilesDownload` WHERE `FilesDownload`.`objects_id` = 308 AND `FilesDownload`.`model` = 'Record' ORDER BY `FilesDownload`.`ordering` asc, `FilesDownload`.`id` asc | 0 | 0 | 1 | maybe slow |
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 `fillerpharma_sklep`.`features` AS `Feature` LEFT JOIN `fillerpharma_sklep`.`features_types` AS `FeaturesType` ON (`Feature`.`features_types_id` = `FeaturesType`.`id`) LEFT JOIN `fillerpharma_sklep`.`features_values` AS `FeaturesValue` ON (`Feature`.`features_values_id` = `FeaturesValue`.`id`) WHERE `FeaturesType`.`hidden` = '0' AND `Feature`.`records_id` = 308 ORDER BY `Feature`.`priority` desc, `Feature`.`id` asc | 0 | 0 | 1 | maybe slow |
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` FROM `fillerpharma_sklep`.`categories_records` AS `CategoriesRecord` LEFT JOIN `fillerpharma_sklep`.`categories` AS `Category` ON (`CategoriesRecord`.`categories_id` = `Category`.`id`) WHERE `CategoriesRecord`.`records_id` = 308 | 1 | 1 | 1 | |
SELECT `Category`.`id`, `title`, `count_records`, `Category`.`parent_id` FROM `fillerpharma_sklep`.`categories` AS `Category` WHERE `id` = 34 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 `fillerpharma_sklep`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Category' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`objects_id` = (34) | 1 | 1 | 1 | |
SELECT `Category`.`id`, `title`, `count_records`, `Category`.`parent_id` FROM `fillerpharma_sklep`.`categories` AS `Category` WHERE `id` = 4 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 `fillerpharma_sklep`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Category' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`objects_id` = (4) | 1 | 1 | 0 | |
SELECT `Category`.`id`, `title`, `count_records`, `Category`.`parent_id` FROM `fillerpharma_sklep`.`categories` AS `Category` WHERE `id` = 1 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 `fillerpharma_sklep`.`seo_urls` AS `SeoUrl` WHERE `SeoUrl`.`model` = 'Category' AND `SeoUrl`.`isold` = '0' AND `SeoUrl`.`type` = '0' AND `SeoUrl`.`objects_id` = (1) | 1 | 1 | 0 | |
SELECT DISTINCT `Related`.`records_id_related`
FROM `fillerpharma_sklep`.`relateds` AS `Related`
LEFT JOIN `fillerpharma_sklep`.`records` AS `Record` ON (`Related`.`records_id_related` = `Record`.`id`)
WHERE `Related`.`records_id` IN (308)
AND (`Related`.`records_id_related` NOT IN (308))
AND `Related`.`relateds_type` = 0
AND `Record`.`active` = 1 AND `Record`.`price` > 0
ORDER BY `Related`.`priority` desc, `Record`.`times_bought` DESC LIMIT 10 | 0 | 0 | 5 | maybe slow |
SELECT DISTINCT `Related`.`records_id_related`
FROM `fillerpharma_sklep`.`relateds` AS `Related`
LEFT JOIN `fillerpharma_sklep`.`records` AS `Record` ON (`Related`.`records_id_related` = `Record`.`id`)
WHERE `Related`.`records_id` IN (308)
AND (`Related`.`records_id_related` NOT IN (308))
AND `Related`.`relateds_type` = 1
AND `Record`.`active` = 1 AND `Record`.`price` > 0
ORDER BY `Related`.`priority` desc, `Record`.`times_bought` DESC LIMIT 10 | 0 | 0 | 1 | maybe slow |
SELECT DISTINCT `Related`.`records_id_related`
FROM `fillerpharma_sklep`.`relateds` AS `Related`
LEFT JOIN `fillerpharma_sklep`.`records` AS `Record` ON (`Related`.`records_id_related` = `Record`.`id`)
WHERE `Related`.`records_id` IN (308)
AND (`Related`.`records_id_related` NOT IN (308))
AND `Related`.`relateds_type` = 2
AND `Record`.`active` = 1 AND `Record`.`price` > 0
ORDER BY `Related`.`priority` desc, `Record`.`times_bought` DESC LIMIT 10 | 0 | 0 | 0 | |
SELECT DISTINCT IF(`CommonRecord`.`record1_id` IN (308), `CommonRecord`.`record2_id`, `CommonRecord`.`record1_id`) AS `records_id`
FROM `fillerpharma_sklep`.`common_records` AS `CommonRecord`
LEFT JOIN `fillerpharma_sklep`.`records` AS `Record1` ON (`CommonRecord`.`record1_id` = `Record1`.`id`)
LEFT JOIN `fillerpharma_sklep`.`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 (308))
AND (`CommonRecord`.`record2_id` NOT IN (308))
))
OR (((`CommonRecord`.`record2_id` IN (308))
AND (`CommonRecord`.`record1_id` NOT IN (308))
)))
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 `fillerpharma_sklep`.`records_packages` AS `RecordsPackage`
LEFT JOIN `fillerpharma_sklep`.`records` AS `Record` ON (`RecordsPackage`.`main_records_id` = `Record`.`id`)
WHERE `Record`.`active` = 1 AND `Record`.`price` > 0 AND `Record`.`id` NOT IN (308)
AND `RecordsPackage`.`records_id` IN (308)
ORDER BY `Record`.`times_bought` DESC, `Record`.`priority` desc, `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` FROM `fillerpharma_sklep`.`records` AS `Record` WHERE `Record`.`id` = 308 LIMIT 1 | 1 | 1 | 1 | |
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 `fillerpharma_sklep`.`payments` AS `Payment` WHERE `Payment`.`active` = '1' ORDER BY `Payment`.`priority` desc | 6 | 6 | 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 `fillerpharma_sklep`.`photos` AS `Photo` WHERE `Photo`.`records_id` = 308 ORDER BY `Photo`.`priority` desc, `Photo`.`id` asc | 1 | 1 | 2 | maybe slow |
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` FROM `fillerpharma_sklep`.`categories` AS `Category` WHERE `Category`.`id` = 34 LIMIT 1 | 1 | 1 | 1 | |
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 `fillerpharma_sklep`.`popups` AS `Popup` WHERE `Popup`.`date_start` <= '2025-08-08 14:08' AND `Popup`.`date_end` >= '2025-08-08 14:08' AND `Popup`.`active` = '1' AND `Popup`.`languages_id` = 3 AND `Popup`.`type` = 0 ORDER BY `Popup`.`priority` desc LIMIT 1 | 1 | 1 | 3 | maybe slow |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `fillerpharma_sklep`.`popups` AS `Popup` WHERE `Popup`.`id` = 86 | 1 | 1 | 4 | maybe slow |
SELECT COUNT(*) AS `count` FROM `fillerpharma_sklep`.`popups` AS `Popup` WHERE `Popup`.`id` = 86 | 1 | 1 | 1 | |
UPDATE `fillerpharma_sklep`.`popups` SET `displayed_count` = 1430093 WHERE `fillerpharma_sklep`.`popups`.`id` = '86' | 1 | 1 | 0 | |
COMMIT | | | | |
SELECT `Translation`.`id`, `Translation`.`table_name`, `Translation`.`field`, `Translation`.`languages_id`, `Translation`.`value`, `Translation`.`enable`, `Translation`.`object_id` FROM `fillerpharma_sklep`.`translations` AS `Translation` WHERE `Translation`.`languages_id` = 3 AND `Translation`.`object_id` = 6 AND `Translation`.`table_name` = 'Shipping' | 2 | 2 | 2 | |
SELECT `Translation`.`id`, `Translation`.`table_name`, `Translation`.`field`, `Translation`.`languages_id`, `Translation`.`value`, `Translation`.`enable`, `Translation`.`object_id` FROM `fillerpharma_sklep`.`translations` AS `Translation` WHERE `Translation`.`languages_id` = 3 AND `Translation`.`object_id` = 21 AND `Translation`.`table_name` = 'Payment' | 10 | 10 | 1 | maybe slow |
SELECT `Translation`.`id`, `Translation`.`table_name`, `Translation`.`field`, `Translation`.`languages_id`, `Translation`.`value`, `Translation`.`enable`, `Translation`.`object_id` FROM `fillerpharma_sklep`.`translations` AS `Translation` WHERE `Translation`.`languages_id` = 3 AND `Translation`.`object_id` = 14 AND `Translation`.`table_name` = 'Payment' | 4 | 4 | 2 | maybe slow |
SELECT `Translation`.`id`, `Translation`.`table_name`, `Translation`.`field`, `Translation`.`languages_id`, `Translation`.`value`, `Translation`.`enable`, `Translation`.`object_id` FROM `fillerpharma_sklep`.`translations` AS `Translation` WHERE `Translation`.`languages_id` = 3 AND `Translation`.`object_id` = 12 AND `Translation`.`table_name` = 'Payment' | 10 | 10 | 1 | maybe slow |
SELECT `Translation`.`id`, `Translation`.`table_name`, `Translation`.`field`, `Translation`.`languages_id`, `Translation`.`value`, `Translation`.`enable`, `Translation`.`object_id` FROM `fillerpharma_sklep`.`translations` AS `Translation` WHERE `Translation`.`languages_id` = 3 AND `Translation`.`object_id` = 22 AND `Translation`.`table_name` = 'Payment' | 10 | 10 | 1 | maybe slow |
SELECT `Translation`.`id`, `Translation`.`table_name`, `Translation`.`field`, `Translation`.`languages_id`, `Translation`.`value`, `Translation`.`enable`, `Translation`.`object_id` FROM `fillerpharma_sklep`.`translations` AS `Translation` WHERE `Translation`.`languages_id` = 3 AND `Translation`.`object_id` = 7 AND `Translation`.`table_name` = 'Shipping' | 2 | 2 | 2 | |
SELECT `Translation`.`id`, `Translation`.`table_name`, `Translation`.`field`, `Translation`.`languages_id`, `Translation`.`value`, `Translation`.`enable`, `Translation`.`object_id` FROM `fillerpharma_sklep`.`translations` AS `Translation` WHERE `Translation`.`languages_id` = 3 AND `Translation`.`object_id` = 1 AND `Translation`.`table_name` = 'Shipping' | 1 | 1 | 2 | maybe slow |
SELECT `Translation`.`id`, `Translation`.`table_name`, `Translation`.`field`, `Translation`.`languages_id`, `Translation`.`value`, `Translation`.`enable`, `Translation`.`object_id` FROM `fillerpharma_sklep`.`translations` AS `Translation` WHERE `Translation`.`languages_id` = 3 AND `Translation`.`object_id` = 5 AND `Translation`.`table_name` = 'Shipping' | 2 | 2 | 1 | maybe slow |
SELECT `CategoriesLanguage`.`id`, `CategoriesLanguage`.`title`, `CategoriesLanguage`.`metakeywords`, `CategoriesLanguage`.`metadescription`, `CategoriesLanguage`.`site_title`, `CategoriesLanguage`.`languages_id`, `CategoriesLanguage`.`categories_id`, `CategoriesLanguage`.`description`, `CategoriesLanguage`.`url`, `CategoriesLanguage`.`title_h1`, `CategoriesLanguage`.`additional_text`, `CategoriesLanguage`.`shorttitle`, `CategoriesLanguage`.`shortdescription`, `CategoriesLanguage`.`date_created`, `CategoriesLanguage`.`author_created`, `CategoriesLanguage`.`author_created_text`, `CategoriesLanguage`.`created_type`, `CategoriesLanguage`.`date_modified`, `CategoriesLanguage`.`author_modified`, `CategoriesLanguage`.`author_modified_text`, `CategoriesLanguage`.`modified_type` FROM `fillerpharma_sklep`.`categories_languages` AS `CategoriesLanguage` WHERE `CategoriesLanguage`.`languages_id` = 3 AND `CategoriesLanguage`.`categories_id` IN (1, 73, 82, 77, 74, 75, 76, 80, 17, 21, 43, 18, 20, 19, 40, 41, 39, 2, 25, 23, 47, 44, 48, 50, 49, 4, 37, 38, 33, 35, 69, 36, 34, 71, 42, 54, 5, 55, 7, 56, 68, 79, 8, 28, 26, 27, 81, 52, 66, 53, 63, 58, 59, 64, 61, 60, 11, 12, 16, 72, 30, 31, 32) | 10 | 10 | 2 | maybe slow |
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` FROM `fillerpharma_sklep`.`records_languages` AS `RecordsLanguage` WHERE `RecordsLanguage`.`languages_id` = 3 AND `RecordsLanguage`.`records_id` IN (665, 625, 240) | 3 | 3 | 1 | maybe slow |
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` FROM `fillerpharma_sklep`.`records_languages` AS `RecordsLanguage` WHERE `RecordsLanguage`.`languages_id` = 3 AND `RecordsLanguage`.`records_id` IN (163) | 0 | 0 | 0 | |