1 | SELECT (ws_name) AS `Composer__title`, (ws_kat) AS `Composer__configuration_category_id`, `Composer`.`ws_id` FROM `xcompute2`.`webses` AS `Composer` WHERE (ws_id) = 36 ORDER BY (ws_order) ASC LIMIT 1 | | 1 | 1 | 1 |
2 | SELECT `ComponentsComposers`.`id`, `ComponentsComposers`.`component_id`, `ComponentsComposers`.`composer_id`, `ComponentsComposers`.`default` FROM `xcompute2`.`components_composers` AS `ComponentsComposers` WHERE `ComponentsComposers`.`composer_id` = (36) | | 66 | 66 | 1 |
3 | SELECT `ComponentCategory`.`id`, `ComponentCategory`.`max_in_configuration`, `ComponentCategory`.`required`, `ComponentCategory`.`allow_empty`, (`ComponentCategory`.`nazev`) AS `ComponentCategory__name` FROM `xcompute2`.`kategorie` AS `ComponentCategory` WHERE 1 = 1 ORDER BY `kat_je_deska` DESC, (priorita) ASC | | 33 | 33 | 1 |
4 | SELECT `PcComponent`.`id`, `PcComponent`.`ext1`, `PcComponent`.`ext2`, `PcComponent`.`ext3`, (`PcComponent`.`nazev`) AS `PcComponent__name`, (popis) AS `PcComponent__description`, (cenadph) AS `PcComponent__price_vat`, (pocet_kusu) AS `PcComponent__pieces`, `PcComponent`.`kategorie` FROM `xcompute2`.`komponenty` AS `PcComponent` WHERE `id` IN (100, 101, 105, 107, 140, 170, 171, 172, 174, 227, 228, 230, 231, 271, 273, 285, 293, 305, 312, 330, 331, 332, 338, 339, 361, 377, 405, 418, 462, 523, 564, 606, 628, 640, 650, 651, 674, 681, 687, 690, 692, 713, 714, 784, 785, 840, 841, 888, 969, 1063, 1095, 1099, 1103, 1105, 1113, 1133, 1136, 1137, 1138, 1150, 1157, 1158, 1162, 1239, 1255, 1337) AND `k_used` = '1' AND `PcComponent`.`kategorie` IN (17, 64, 15, 16, 18, 60, 19, 20, 52, 58, 59, 56, 61, 33, 21, 22, 23, 26, 27, 34, 55, 51, 54, 30, 31, 35, 36, 37, 38, 28, 39, 53, 57) ORDER BY `PcComponent`.`cenadph` * `PcComponent`.`pocet_kusu` ASC | | 66 | 66 | 5 |
5 | SELECT `PcComponent`.`id`, (kategorie) AS `PcComponent__component_category_id` FROM `xcompute2`.`komponenty` AS `PcComponent` WHERE `id` IN (101, 140, 606, 628, 650, 840, 1103, 1133, 1136, 1255, 1337) | | 11 | 11 | 1 |
6 | SELECT `Property`.`description`, `Property`.`vl_id`, (vl_id) AS `Property__id`, (vl_name) AS `Property__name`, (vl_prio) AS `Property__order` FROM `xcompute2`.`vlastnost` AS `Property` WHERE 1 = 1 ORDER BY (vl_prio) ASC | | 5 | 5 | 1 |
7 | SELECT `ComponentCategory`.`id`, `PropertyInfluence`.`id`, `PropertyInfluence`.`property_id`, `PropertyInfluence`.`component_category_id`, `PropertyInfluence`.`influence`, `PropertyInfluence`.`most_dependent` FROM `xcompute2`.`kategorie` AS `ComponentCategory` JOIN `xcompute2`.`property_influence` AS `PropertyInfluence` ON (`PropertyInfluence`.`property_id` IN (34, 35, 38, 33, 37) AND `PropertyInfluence`.`component_category_id` = `ComponentCategory`.`id`) | | 8 | 8 | 1 |
8 | SELECT `PropertyComponent`.`vk_vlastnost`, `PropertyComponent`.`vk_value`, `PropertyComponent`.`vk_komponenta`, `PcComponent`.`kategorie`, `PcComponent`.`id` FROM `xcompute2`.`vlastnost_komponenta` AS `PropertyComponent` LEFT JOIN `xcompute2`.`komponenty` AS `PcComponent` ON (`PropertyComponent`.`vk_komponenta` = `PcComponent`.`id`) WHERE `vk_komponenta` IN (100, 101, 105, 107, 140, 170, 171, 172, 174, 227, 228, 230, 231, 271, 273, 285, 293, 305, 312, 330, 331, 332, 338, 339, 361, 377, 405, 418, 462, 523, 564, 606, 628, 640, 650, 651, 674, 681, 687, 690, 692, 713, 714, 784, 785, 840, 841, 888, 969, 1063, 1095, 1099, 1103, 1105, 1113, 1133, 1136, 1137, 1138, 1150, 1157, 1158, 1162, 1239, 1255, 1337) | | 19 | 19 | 2 |
9 | SELECT (wk_id) AS `ConfigurationCategory__id`, (wk_title) AS `ConfigurationCategory__title`, (wk_url) AS `ConfigurationCategory__url`, `ConfigurationCategory`.`wk_id` FROM `xcompute2`.`webkat` AS `ConfigurationCategory` WHERE 1 = 1 ORDER BY (wk_order) ASC | | 8 | 8 | 1 |
10 | SELECT `Composer`.`ws_order`, (ws_id) AS `Composer__id`, (ws_name) AS `Composer__title`, `Composer`.`ws_kat` FROM `xcompute2`.`webses` AS `Composer` WHERE `public` = '1' AND `Composer`.`ws_kat` IN (7, 22, 6, 15, 24, 23, 5, 25) ORDER BY `ws_order` ASC | | 21 | 21 | 1 |