Notice. We use cookies to provide necessary website functionality, improve your experience and analyze our traffic. By using our website, you agree to our legal policies.
# Query soft limit for Debugbar is reached after 100 queries, additional 95 queries onlyshow the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
CategoryController.php#33dev_mihi290μsselect*from `category_descriptions` where `category_descriptions`.`category_id` in (49, 50) and `language_key` ='lt'
CategoryController.php#90dev_mihi170μsselect `option_items`.*, `option_item_product`.`product_id` as `pivot_product_id`, `option_item_product`.`option_item_id` as `pivot_option_item_id` from `option_items` innerjoin `option_item_product` on `option_items`.`id` = `option_item_product`.`option_item_id` where `option_item_product`.`product_id` in (1914, 1951, 1952, 1953, 1954, 1955, 1956, 1957, 1958, 1959, 1967) and `option_id` =2
CategoryController.php#90dev_mihi150μsselect `categories`.*, `option_item_category`.`option_item_id` as `pivot_option_item_id`, `option_item_category`.`category_id` as `pivot_category_id`, `option_item_category`.`sort` as `pivot_sort` from `categories` innerjoin `option_item_category` on `categories`.`id` = `option_item_category`.`category_id` where `option_item_category`.`option_item_id` in (205, 218, 226, 240, 241, 243, 247, 262, 263, 437) and `category_id` =8
dev_mihi540μsselect*from `actions` where `from` <= ? and `to` >= ? and json_contains(`products_id`, ?) limit 1
dev_mihi130μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi100μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi100μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi90μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi270μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi120μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi100μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi100μsselect*from `date_delivery_products` where `date_delivery_products`.`product_id` = ? and `date_delivery_products`.`product_id` isnotnull limit 1
dev_mihi460μsselect*from `actions` where `from` <= ? and `to` >= ? and json_contains(`products_id`, ?) limit 1
dev_mihi110μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi100μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi140μsselect*from `banners` where `status` = ? and `slug` = ? andexists (select*from `banner_images` where `banners`.`id` = `banner_images`.`banner_id` and `language_key` = ?)
dev_mihi140μsselect*from `banners` where `status` = ? and `slug` = ? andexists (select*from `banner_images` where `banners`.`id` = `banner_images`.`banner_id` and `language_key` = ?)
dev_mihi120μsselect*from `banner_images` where `banner_images`.`banner_id` in (6) and `language_key` = ? and `active` = ? and `special_display` = ? orderby `created_at` desc
dev_mihi140μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi100μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi100μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi110μsselect*from `options` where `options`.`id` = ? limit 1
dev_mihi120μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi170μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi100μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi100μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi100μsselect*from `options` where `options`.`id` = ? limit 1
dev_mihi110μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi110μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi130μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi100μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi100μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi100μsselect*from `options` where `options`.`id` = ? limit 1
dev_mihi110μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi120μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi100μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi120μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi100μsselect*from `options` where `options`.`id` = ? limit 1
dev_mihi110μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi120μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi110μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi110μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi100μsselect*from `options` where `options`.`id` = ? limit 1
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi130μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi100μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi100μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi100μsselect*from `options` where `options`.`id` = ? limit 1
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi120μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi100μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi100μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi100μsselect*from `options` where `options`.`id` = ? limit 1
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi110μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi120μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi100μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi100μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi100μsselect*from `options` where `options`.`id` = ? limit 1
dev_mihi110μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi130μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi100μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi100μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi100μsselect*from `options` where `options`.`id` = ? limit 1
dev_mihi110μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi120μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi100μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi100μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi110μsselect*from `options` where `options`.`id` = ? limit 1
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi600μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi140μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi160μsselect*from `prices` where `product_id` = ? and `date_start` <= ? orderby `date_start` desc limit 1
dev_mihi100μsselect `currency_id` from `languages` where `code` = ? limit 1
dev_mihi110μsselect*from `currencies` where `currencies`.`id` = ? limit 1
dev_mihi110μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi110μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi100μsselectexists(select*from `product_last_items` where `product_last_items`.`product_id` = ? and `product_last_items`.`product_id` isnotnull) as `exists`
dev_mihi130μsselect*from `periods` where `start_period` <= ? and `end_period` >= ? limit 1