Check the log file at '/usr/local/flamenco/instances/ChEFS_-_19-09-06/log.txt' for more details. Here are the last few lines:
7 2024-11-23 12:56:01 /ChEFS_-_19-09-06/Wedge?group=facet_ChEBI_R105&q=facet_BIOACTIVE%3A8223%2Ffacet_ChEBI_R105%3A457608%2Ffacet_NTRNT%3A17050
select count(*) from item_facet_BIOACTIVE as item_facet_BIOACTIVE_1, item_facet_ChEBI_R105 as item_facet_ChEBI_R105_2, item_facet_NTRNT as item_facet_NTRNT_3 where item_facet_BIOACTIVE_1.id = 8223 and item_facet_ChEBI_R105_2.id = 457608 and item_facet_ChEBI_R105_2.item = item_facet_BIOACTIVE_1.item and item_facet_NTRNT_3.id = 17050 and item_facet_NTRNT_3.item = item_facet_BIOACTIVE_1.item
PRELOAD
LOGGING SQL
insert into log (interface, userid, taskid, event, detail, sort, count, ipaddr, facet, prevurl, offset, query, groupby) values ('Wedge', 0, 0, 'middle', '', '', 6, '172.31.4.143', '', NULL, 0, 'facet_BIOACTIVE:8223/facet_ChEBI_R105:457608/facet_NTRNT:17050', 'facet_ChEBI_R105')
QUERY
facet_BIOACTIVE:8223/facet_ChEBI_R105:457608/facet_NTRNT:17050
facet_BIOACTIVE:8223/facet_ChEBI_R105:457608/facet_NTRNT:17050
middlegame
select child.id, count(*) as count, child.name as name from facet_ChEBI_R105 as child, item_facet_BIOACTIVE as item_facet_BIOACTIVE_1, item_facet_ChEBI_R105 as item_facet_ChEBI_R105_2, item_facet_ChEBI_R105 as map, item_facet_NTRNT as item_facet_NTRNT_3 where child.parent = 457608 and item_facet_BIOACTIVE_1.id = 8223 and item_facet_ChEBI_R105_2.id = 457608 and item_facet_ChEBI_R105_2.item = item_facet_BIOACTIVE_1.item and item_facet_NTRNT_3.id = 17050 and item_facet_NTRNT_3.item = item_facet_BIOACTIVE_1.item and map.id = child.id and map.item = item_facet_BIOACTIVE_1.item group by child.id having count > 0
---- query: select child.id, count(*) as count, child.name as name from facet_ChEBI_R105 as child, item_facet_BIOACTIVE as item_facet_BIOACTIVE_1, item_facet_ChEBI_R105 as item_facet_ChEBI_R105_2, item_facet_ChEBI_R105 as map, item_facet_NTRNT as item_facet_NTRNT_3 where child.parent = 457608 and item_facet_BIOACTIVE_1.id = 8223 and item_facet_ChEBI_R105_2.id = 457608 and item_facet_ChEBI_R105_2.item = item_facet_BIOACTIVE_1.item and item_facet_NTRNT_3.id = 17050 and item_facet_NTRNT_3.item = item_facet_BIOACTIVE_1.item and map.id = child.id and map.item = item_facet_BIOACTIVE_1.item group by child.id having count > 0
rows: 3, time: 0.12 sec
select child.id, count(*) as count, child.name as name from facet_ChEBI_R105 as child, item_facet_BIOACTIVE as item_facet_BIOACTIVE_1, item_facet_ChEBI_R105 as item_facet_ChEBI_R105_2, item_facet_ChEBI_R105 as map, item_facet_NTRNT as item_facet_NTRNT_3 where child.parent = 457608 and item_facet_BIOACTIVE_1.id = 8223 and item_facet_ChEBI_R105_2.id = 457608 and item_facet_ChEBI_R105_2.item = item_facet_BIOACTIVE_1.item and item_facet_NTRNT_3.id = 17050 and item_facet_NTRNT_3.item = item_facet_BIOACTIVE_1.item and map.id = child.id and map.item = item_facet_BIOACTIVE_1.item group by child.id having count > 0
---- query: select child.id, count(*) as count, child.name as name from facet_ChEBI_R105 as child, item_facet_BIOACTIVE as item_facet_BIOACTIVE_1, item_facet_ChEBI_R105 as item_facet_ChEBI_R105_2, item_facet_ChEBI_R105 as map, item_facet_NTRNT as item_facet_NTRNT_3 where child.parent = 457608 and item_facet_BIOACTIVE_1.id = 8223 and item_facet_ChEBI_R105_2.id = 457608 and item_facet_ChEBI_R105_2.item = item_facet_BIOACTIVE_1.item and item_facet_NTRNT_3.id = 17050 and item_facet_NTRNT_3.item = item_facet_BIOACTIVE_1.item and map.id = child.id and map.item = item_facet_BIOACTIVE_1.item group by child.id having count > 0
rows: 3, time: 0.12 sec
GROUPEDITEMS
select child.id, count(*) as count, child.name as name from facet_ChEBI_R105 as child, item_facet_BIOACTIVE as item_facet_BIOACTIVE_1, item_facet_ChEBI_R105 as item_facet_ChEBI_R105_2, item_facet_ChEBI_R105 as map, item_facet_NTRNT as item_facet_NTRNT_3 where child.parent = 457608 and item_facet_BIOACTIVE_1.id = 8223 and item_facet_ChEBI_R105_2.id = 457608 and item_facet_ChEBI_R105_2.item = item_facet_BIOACTIVE_1.item and item_facet_NTRNT_3.id = 17050 and item_facet_NTRNT_3.item = item_facet_BIOACTIVE_1.item and map.id = child.id and map.item = item_facet_BIOACTIVE_1.item group by child.id having count > 0
---- query: select child.id, count(*) as count, child.name as name from facet_ChEBI_R105 as child, item_facet_BIOACTIVE as item_facet_BIOACTIVE_1, item_facet_ChEBI_R105 as item_facet_ChEBI_R105_2, item_facet_ChEBI_R105 as map, item_facet_NTRNT as item_facet_NTRNT_3 where child.parent = 457608 and item_facet_BIOACTIVE_1.id = 8223 and item_facet_ChEBI_R105_2.id = 457608 and item_facet_ChEBI_R105_2.item = item_facet_BIOACTIVE_1.item and item_facet_NTRNT_3.id = 17050 and item_facet_NTRNT_3.item = item_facet_BIOACTIVE_1.item and map.id = child.id and map.item = item_facet_BIOACTIVE_1.item group by child.id having count > 0
rows: 3, time: 0.16 sec
select child.id, count(*) as count, child.name as name from facet_ChEBI_R105 as child, item_facet_BIOACTIVE as item_facet_BIOACTIVE_1, item_facet_ChEBI_R105 as item_facet_ChEBI_R105_2, item_facet_ChEBI_R105 as map, item_facet_NTRNT as item_facet_NTRNT_3 where child.parent = 457608 and item_facet_BIOACTIVE_1.id = 8223 and item_facet_ChEBI_R105_2.id = 457608 and item_facet_ChEBI_R105_2.item = item_facet_BIOACTIVE_1.item and item_facet_NTRNT_3.id = 17050 and item_facet_NTRNT_3.item = item_facet_BIOACTIVE_1.item and map.id = child.id and map.item = item_facet_BIOACTIVE_1.item group by child.id having count > 0 order by name
8 2024-11-23 12:56:02 /ChEFS_-_19-09-06/Wedge?group=facet_ChEBI_R105&q=facet_ChEBI_R105%3A472156
select count(*) from item_facet_ChEBI_R105 as item_facet_ChEBI_R105_1 where item_facet_ChEBI_R105_1.id = 472156
---- query: select child.id, count(*) as count, child.name as name from facet_ChEBI_R105 as child, item_facet_BIOACTIVE as item_facet_BIOACTIVE_1, item_facet_ChEBI_R105 as item_facet_ChEBI_R105_2, item_facet_ChEBI_R105 as map, item_facet_NTRNT as item_facet_NTRNT_3 where child.parent = 457608 and item_facet_BIOACTIVE_1.id = 8223 and item_facet_ChEBI_R105_2.id = 457608 and item_facet_ChEBI_R105_2.item = item_facet_BIOACTIVE_1.item and item_facet_NTRNT_3.id = 17050 and item_facet_NTRNT_3.item = item_facet_BIOACTIVE_1.item and map.id = child.id and map.item = item_facet_BIOACTIVE_1.item group by child.id having count > 0 order by name
rows: 0, time: 0.16 sec
select p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12, p13, p14, p15, p16, p17, p18, p19, p20, p21, p22, p23, p24, p25, p26, p27, level from facet_ChEBI_R105 where id = 457608