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) = 43 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` = (43) | | 75 | 75 | 2 |
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 (101, 105, 148, 170, 171, 172, 228, 229, 231, 232, 271, 273, 293, 305, 312, 330, 331, 338, 339, 361, 398, 405, 418, 462, 650, 651, 674, 681, 682, 692, 713, 714, 768, 773, 784, 785, 802, 815, 816, 864, 888, 893, 935, 937, 938, 944, 945, 992, 995, 996, 1035, 1070, 1084, 1095, 1099, 1105, 1125, 1136, 1137, 1138, 1140, 1142, 1143, 1144, 1145, 1147, 1150, 1156, 1157, 1158, 1162, 1173, 1240, 1263, 1277) 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 | | 75 | 75 | 5 |
5 | SELECT `PcComponent`.`id`, (kategorie) AS `PcComponent__component_category_id` FROM `xcompute2`.`komponenty` AS `PcComponent` WHERE `id` IN (101, 650, 815, 995, 996, 1084, 1136, 1142, 1144, 1263) | | 10 | 10 | 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 (101, 105, 148, 170, 171, 172, 228, 229, 231, 232, 271, 273, 293, 305, 312, 330, 331, 338, 339, 361, 398, 405, 418, 462, 650, 651, 674, 681, 682, 692, 713, 714, 768, 773, 784, 785, 802, 815, 816, 864, 888, 893, 935, 937, 938, 944, 945, 992, 995, 996, 1035, 1070, 1084, 1095, 1099, 1105, 1125, 1136, 1137, 1138, 1140, 1142, 1143, 1144, 1145, 1147, 1150, 1156, 1157, 1158, 1162, 1173, 1240, 1263, 1277) | | 27 | 27 | 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 |