Queries | Time | Rows |
Connecting to DB | 0.000 | 1 |
Select * From `route_urls` Where old_url = 'https://www.jansvoboda.cz/Vnitrni-bezzavitove-c7101' | 0.000 | 0 |
SELECT `categories`.*
FROM (`categories`)
WHERE `categories`.`id` = '7101'
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 0.000 | 1 |
ROLLBACK | 0.000 | 0 |
SELECT `settings`.*
FROM (`settings`)
WHERE `alias` = 'main'
ORDER BY `settings`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
SELECT `branches`.*
FROM (`branches`)
WHERE `main` = 1
ORDER BY `branches`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft < 259
AND rgt > 260
ORDER BY `lft` ASC | 0.001 | 4 |
Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_routes' | 0.000 | 0 |
Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'web' | 0.000 | 0 |
SELECT `goods`.`id` AS `id`
FROM (`goods`)
INNER JOIN `categories_goods` ON (`categories_goods`.`category_id` = 7101 AND `goods`.`id` = `categories_goods`.`good_id`)
WHERE categories_goods.id IS NOT NULL
AND `goods`.`visible_retail` = 1
GROUP BY `goods`.`id`
ORDER BY `goods`.`id` ASC | 0.020 | 1 |
INSERT INTO `_sys_request_params` (`data`, `parameters`, `admin_id`, `key`) VALUES ('a:1:{i:1485501;s:7:\"1485501\";}', '||', 0, '5c679e0a21e961225723765') | 0.053 | 1 |
Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_module' | 0.000 | 13 |
SELECT `goods_price_settings`.*
FROM (`goods_price_settings`)
WHERE `default_eshop` = 1
ORDER BY `goods_price_settings`.`sort` ASC
LIMIT 0, 1 | 0.000 | 1 |
SELECT `image`.`id` AS `image:id`, `image`.`name` AS `image:name`, `image`.`good_id` AS `image:good_id`, `image`.`updated` AS `image:updated`, `image`.`description` AS `image:description`, `image`.`auto_admin_update_id` AS `image:auto_admin_update_id`, `image`.`position` AS `image:position`, `image`.`default` AS `image:default`, `image`.`tmp_id` AS `image:tmp_id`, `image`.`ext` AS `image:ext`, `image`.`auto_date_create` AS `image:auto_date_create`, `image`.`auto_date_update` AS `image:auto_date_update`, `image`.`auto_admin_create_id` AS `image:auto_admin_create_id`, `goods`.*
FROM (`goods`)
LEFT JOIN `images` AS `image` ON (`image`.`id` = `goods`.`image_id`)
WHERE `goods`.`visible_retail` = 1
AND `goods`.`id` IN (1485501)
ORDER BY goods.name ASC
LIMIT 0, 25 | 0.001 | 1 |
SELECT COUNT(*) AS `total_rows` FROM (SELECT `image`.`id` AS `image:id`, `image`.`name` AS `image:name`, `image`.`good_id` AS `image:good_id`, `image`.`updated` AS `image:updated`, `image`.`description` AS `image:description`, `image`.`auto_admin_update_id` AS `image:auto_admin_update_id`, `image`.`position` AS `image:position`, `image`.`default` AS `image:default`, `image`.`tmp_id` AS `image:tmp_id`, `image`.`ext` AS `image:ext`, `image`.`auto_date_create` AS `image:auto_date_create`, `image`.`auto_date_update` AS `image:auto_date_update`, `image`.`auto_admin_create_id` AS `image:auto_admin_create_id`, `goods`.*
FROM (`goods`)
LEFT JOIN `images` AS `image` ON (`image`.`id` = `goods`.`image_id`)
WHERE `goods`.`visible_retail` = 1
AND `goods`.`id` IN (1485501)
ORDER BY goods.name ASC) AS `counted_results` | 0.000 | 1 |
Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'pagination' | 0.000 | 0 |
SELECT `states`.*
FROM (`states`)
WHERE `shortcut` = 'cz'
ORDER BY `states`.`ordering` ASC
LIMIT 0, 1 | 0.000 | 1 |
SELECT `exchange_rates`.*
FROM (`exchange_rates`)
WHERE `shortcut` = 'CZK'
ORDER BY `exchange_rates`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
SELECT `exchange_rates`.*
FROM (`exchange_rates`)
WHERE `shortcut` = 'CZK'
ORDER BY `exchange_rates`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
SELECT `exchange_rates`.*
FROM (`exchange_rates`)
WHERE `exchange_rates`.`id` = 1
ORDER BY `exchange_rates`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
SELECT `goods_price_settings`.*
FROM (`goods_price_settings`)
WHERE `default_eshop` = 1
ORDER BY `goods_price_settings`.`sort` ASC
LIMIT 0, 1 | 0.000 | 1 |
SELECT `settings`.*
FROM (`settings`)
WHERE `alias` = 'main'
ORDER BY `settings`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
Select * From `payment_discounts` Where (`goods_price_setting_id` = 1 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 1.960000 between `from` and `to` and `only_logged` = 0 | 0.000 | 0 |
Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 1.960000 between `from` and `to` | 0.000 | 0 |
Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_price' | 0.000 | 0 |
INSERT INTO `_sys_request_params` (`data`, `parameters`, `admin_id`, `key`) VALUES ('a:2:{s:7:\"pending\";a:12:{s:6:\"select\";a:13:{i:0;s:26:\"`image`.`id` AS `image:id`\";i:1;s:30:\"`image`.`name` AS `image:name`\";i:2;s:36:\"`image`.`good_id` AS `image:good_id`\";i:3;s:36:\"`image`.`updated` AS `image:updated`\";i:4;s:44:\"`image`.`description` AS `image:description`\";i:5;s:62:\"`image`.`auto_admin_update_id` AS `image:auto_admin_update_id`\";i:6;s:38:\"`image`.`position` AS `image:position`\";i:7;s:36:\"`image`.`default` AS `image:default`\";i:8;s:34:\"`image`.`tmp_id` AS `image:tmp_id`\";i:9;s:28:\"`image`.`ext` AS `image:ext`\";i:10;s:54:\"`image`.`auto_date_create` AS `image:auto_date_create`\";i:11;s:54:\"`image`.`auto_date_update` AS `image:auto_date_update`\";i:12;s:62:\"`image`.`auto_admin_create_id` AS `image:auto_admin_create_id`\";}s:3:\"set\";a:0:{}s:4:\"from\";a:0:{}s:4:\"join\";a:1:{i:0;a:3:{s:6:\"tables\";a:1:{i:0;s:19:\"`images` AS `image`\";}s:10:\"conditions\";s:35:\"(`image`.`id` = `goods`.`image_id`)\";s:4:\"type\";s:5:\"LEFT \";}}s:5:\"where\";a:2:{i:0;s:28:\"`goods`.`visible_retail` = 1\";i:1;s:29:\"AND `goods`.`id` IN (1485501)\";}s:7:\"orderby\";a:0:{}s:5:\"order\";a:0:{}s:7:\"groupby\";a:0:{}s:6:\"having\";a:0:{}s:8:\"distinct\";b:0;s:5:\"limit\";b:0;s:6:\"offset\";b:0;}s:11:\"total_count\";i:1;}', '||', 0, '5c679e0a44d17992125109') | 0.037 | 1 |
SELECT `contents`.*
FROM (`contents`)
WHERE `category_ids` = '|7101|'
ORDER BY `date` DESC | 0.001 | 0 |
Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_menu' | 0.000 | 0 |
SELECT `basket_items`.*
FROM (`basket_items`)
WHERE good_id > 0
AND `random_customer_id` = 175206217
AND `owner` = 'not_loged'
ORDER BY `basket_items`.`id` ASC | 0.000 | 0 |
SELECT `categories`.*
FROM (`categories`)
WHERE `visible` = 1
AND depth <= 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.000 | 64 |
SELECT `id`, `id`
FROM (`categories`)
WHERE lft <= 259
AND rgt >= 260
ORDER BY `lft` DESC | 0.000 | 5 |
SELECT `categories`.*
FROM (`categories`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.000 | 436 |
SELECT `categories`.*
FROM (`categories`)
WHERE `parent_id` IN (7101,5401,75001,76325,63301,0)
AND `visible` = 1
AND depth <= 0
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.001 | 12 |
Total: 33 | 0.118 | 550 |