Check the log file at '/usr/local/flamenco/instances/Dietary-Data_-_19-09-05/log.txt' for more details. Here are the last few lines:
287 0.06 secs /Dietary-Data_-_19-09-05/Wedge?q=facet_B%3A2492%2Ffacet_E%3A19%2Ffacet_P%3A2%2Ffacet_S%3A454
288 2025-12-08 08:50:29 /Dietary-Data_-_19-09-05/Wedge?group=facet_B&q=facet_A%3A875%2Ffacet_B%3A2382%2Ffacet_E%3A16%2Ffacet_J%3A30%2Ffacet_S%3A14
select count(*) from item_facet_A as item_facet_A_1, item_facet_B as item_facet_B_2, item_facet_E as item_facet_E_3, item_facet_J as item_facet_J_4, item_facet_S as item_facet_S_5 where item_facet_A_1.id = 875 and item_facet_B_2.id = 2382 and item_facet_B_2.item = item_facet_A_1.item and item_facet_E_3.id = 16 and item_facet_E_3.item = item_facet_A_1.item and item_facet_J_4.id = 30 and item_facet_J_4.item = item_facet_A_1.item and item_facet_S_5.id = 14 and item_facet_S_5.item = item_facet_A_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', '', '', 1, '172.31.10.113', '', NULL, 0, 'facet_A:875/facet_B:2382/facet_E:16/facet_J:30/facet_S:14', 'facet_B')
QUERY
facet_A:875/facet_B:2382/facet_E:16/facet_J:30/facet_S:14
facet_A:875/facet_B:2382/facet_E:16/facet_J:30/facet_S:14
middlegame
select child.id, count(*) as count, child.name as name from facet_B as child, item_facet_A as item_facet_A_1, item_facet_B as item_facet_B_2, item_facet_B as map, item_facet_E as item_facet_E_3, item_facet_J as item_facet_J_4, item_facet_S as item_facet_S_5 where child.parent = 2382 and item_facet_A_1.id = 875 and item_facet_B_2.id = 2382 and item_facet_B_2.item = item_facet_A_1.item and item_facet_E_3.id = 16 and item_facet_E_3.item = item_facet_A_1.item and item_facet_J_4.id = 30 and item_facet_J_4.item = item_facet_A_1.item and item_facet_S_5.id = 14 and item_facet_S_5.item = item_facet_A_1.item and map.id = child.id and map.item = item_facet_A_1.item group by child.id having count > 0
select child.id, count(*) as count, child.name as name from facet_B as child, item_facet_A as item_facet_A_1, item_facet_B as item_facet_B_2, item_facet_B as map, item_facet_E as item_facet_E_3, item_facet_J as item_facet_J_4, item_facet_S as item_facet_S_5 where child.parent = 2382 and item_facet_A_1.id = 875 and item_facet_B_2.id = 2382 and item_facet_B_2.item = item_facet_A_1.item and item_facet_E_3.id = 16 and item_facet_E_3.item = item_facet_A_1.item and item_facet_J_4.id = 30 and item_facet_J_4.item = item_facet_A_1.item and item_facet_S_5.id = 14 and item_facet_S_5.item = item_facet_A_1.item and map.id = child.id and map.item = item_facet_A_1.item group by child.id having count > 0
UNGROUPED ITEMS
SORT
[]
select item_facet_A_1.item from item_facet_A as item_facet_A_1, item_facet_B as item_facet_B_2, item_facet_E as item_facet_E_3, item_facet_J as item_facet_J_4, item_facet_S as item_facet_S_5 where item_facet_A_1.id = 875 and item_facet_B_2.id = 2382 and item_facet_B_2.item = item_facet_A_1.item and item_facet_E_3.id = 16 and item_facet_E_3.item = item_facet_A_1.item and item_facet_J_4.id = 30 and item_facet_J_4.item = item_facet_A_1.item and item_facet_S_5.id = 14 and item_facet_S_5.item = item_facet_A_1.item limit 0,40
select id from item_facet_G where item_facet_G.item = "83" and leaf = 1
select id from item_facet_F where item_facet_F.item = "83" and leaf = 1
select id from item_facet_E where item_facet_E.item = "83" and leaf = 1
select id from item_facet_C where item_facet_C.item = "83" and leaf = 1
289 2025-12-08 08:50:29 select id from item_facet_B where item_facet_B.item = "83" and leaf = 1
/Dietary-Data_-_19-09-05/Wedge?q=facet_A%3A800%2Ffacet_E%3A2%2Ffacet_J%3A15%2Ffacet_M%3A249%2Ffacet_S%3A654
select id from item_facet_A where item_facet_A.item = "83" and leaf = 1
select count(*) from item_facet_A as item_facet_A_1, item_facet_E as item_facet_E_2, item_facet_J as item_facet_J_3, item_facet_M as item_facet_M_4, item_facet_S as item_facet_S_5 where item_facet_A_1.id = 800 and item_facet_E_2.id = 2 and item_facet_E_2.item = item_facet_A_1.item and item_facet_J_3.id = 15 and item_facet_J_3.item = item_facet_A_1.item and item_facet_M_4.id = 249 and item_facet_M_4.item = item_facet_A_1.item and item_facet_S_5.id = 654 and item_facet_S_5.item = item_facet_A_1.item