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:
select name from facet_S where parent=639
select name from facet_S where parent=656
select child.id, count(*) as count, child.name as name from facet_Z as child, item_facet_A as item_facet_A_1, item_facet_E as item_facet_E_2, item_facet_M as item_facet_M_3, item_facet_S as item_facet_S_4, item_facet_Z as map where child.parent = 0 and item_facet_A_1.id = 839 and item_facet_E_2.id = 3 and item_facet_E_2.item = item_facet_A_1.item and item_facet_M_3.id = 249 and item_facet_M_3.item = item_facet_A_1.item and item_facet_S_4.id = 623 and item_facet_S_4.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 order by name limit 0,11
304 0.05 secs /Dietary-Data_-_19-09-05/Wedge?group=facet_C&q=facet_A%3A839%2Ffacet_E%3A3%2Ffacet_M%3A249%2Ffacet_S%3A623
305 2025-12-07 14:03:07 /Dietary-Data_-_19-09-05/Wedge?group=facet_C&q=facet_A%3A800%2Ffacet_B%3A1862%2Ffacet_E%3A19%2Ffacet_M%3A249%2Ffacet_P%3A2
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_M as item_facet_M_4, item_facet_P as item_facet_P_5 where item_facet_A_1.id = 800 and item_facet_B_2.id = 1862 and item_facet_B_2.item = item_facet_A_1.item and item_facet_E_3.id = 19 and item_facet_E_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_P_5.id = 2 and item_facet_P_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', '', '', 6, '172.31.62.176', '', NULL, 0, 'facet_A:800/facet_B:1862/facet_E:19/facet_M:249/facet_P:2', 'facet_C')
QUERY
facet_A:800/facet_B:1862/facet_E:19/facet_M:249/facet_P:2
facet_A:800/facet_B:1862/facet_E:19/facet_M:249/facet_P:2
middlegame
GROUPEDITEMS
select child.id, count(*) as count, child.name as name from facet_C as child, item_facet_A as item_facet_A_1, item_facet_B as item_facet_B_2, item_facet_C as map, item_facet_E as item_facet_E_3, item_facet_M as item_facet_M_4, item_facet_P as item_facet_P_5 where child.parent = 0 and item_facet_A_1.id = 800 and item_facet_B_2.id = 1862 and item_facet_B_2.item = item_facet_A_1.item and item_facet_E_3.id = 19 and item_facet_E_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_P_5.id = 2 and item_facet_P_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_C as child, item_facet_A as item_facet_A_1, item_facet_B as item_facet_B_2, item_facet_C as map, item_facet_E as item_facet_E_3, item_facet_M as item_facet_M_4, item_facet_P as item_facet_P_5 where child.parent = 0 and item_facet_A_1.id = 800 and item_facet_B_2.id = 1862 and item_facet_B_2.item = item_facet_A_1.item and item_facet_E_3.id = 19 and item_facet_E_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_P_5.id = 2 and item_facet_P_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 order by name
select distinct parent from facet_C where parent in (114)
select count(*) from item_facet_A as item_facet_A_1, item_facet_B as item_facet_B_2, item_facet_C as item_facet_C_3, item_facet_E as item_facet_E_4, item_facet_M as item_facet_M_5, item_facet_P as item_facet_P_6 where item_facet_A_1.id = 800 and item_facet_B_2.id = 1862 and item_facet_B_2.item = item_facet_A_1.item and item_facet_C_3.id = 0 and item_facet_C_3.item = item_facet_A_1.item and item_facet_C_3.leaf = 1 and item_facet_E_4.id = 19 and item_facet_E_4.item = item_facet_A_1.item and item_facet_M_5.id = 249 and item_facet_M_5.item = item_facet_A_1.item and item_facet_P_6.id = 2 and item_facet_P_6.item = item_facet_A_1.item
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_C as item_facet_C_3, item_facet_E as item_facet_E_4, item_facet_M as item_facet_M_5, item_facet_P as item_facet_P_6 where item_facet_A_1.id = 800 and item_facet_B_2.id = 1862 and item_facet_B_2.item = item_facet_A_1.item and item_facet_C_3.id = 114 and item_facet_C_3.item = item_facet_A_1.item and item_facet_E_4.id = 19 and item_facet_E_4.item = item_facet_A_1.item and item_facet_M_5.id = 249 and item_facet_M_5.item = item_facet_A_1.item and item_facet_P_6.id = 2 and item_facet_P_6.item = item_facet_A_1.item
select id from item_facet_G where item_facet_G.item = "177" and leaf = 1
select id from item_facet_F where item_facet_F.item = "177" and leaf = 1
306 2025-12-07 14:03:07 /Dietary-Data_-_19-09-05/Wedge?group=facet_H&q=facet_B%3A835%2Ffacet_E%3A19%2Ffacet_G%3A28%2Ffacet_H%3A196%2Ffacet_P%3A2
select id from item_facet_E where item_facet_E.item = "177" and leaf = 1
select count(*) from item_facet_B as item_facet_B_1, item_facet_E as item_facet_E_2, item_facet_G as item_facet_G_3, item_facet_H as item_facet_H_4, item_facet_P as item_facet_P_5 where item_facet_B_1.id = 835 and item_facet_E_2.id = 19 and item_facet_E_2.item = item_facet_B_1.item and item_facet_G_3.id = 28 and item_facet_G_3.item = item_facet_B_1.item and item_facet_H_4.id = 196 and item_facet_H_4.item = item_facet_B_1.item and item_facet_P_5.id = 2 and item_facet_P_5.item = item_facet_B_1.item