SELECT user_node.node_id,
user_node.path_string,
user_tree.contentobject_id
FROM ezcontentobject_tree user_node,
ezcontentobject_tree user_tree
WHERE user_node.node_id IN ( 108, 388, 394, 529, 463, 509, 557, 567, 687, 701, 715, 717, 731, 733, 741, 750, 754, 756, 759, 765, 773, 785, 821, 849, 871, 894, 930, 986, 992, 1012, 1047, 1080, 1082, 1172, 1208, 1217, 1236, 1289, 1300, 1306, 1355, 1362, 1371, 1389, 1450, 1452, 1483, 1534, 1540, 1582, 1587, 1597, 1603, 1643, 1686, 1697, 1703, 1716, 1743, 1771, 1795, 1807, 1810, 1936, 1998, 2004, 2013, 2028, 2036, 2080, 2106, 2132, 2187, 2343, 2478, 2662, 2692, 2710, 2907, 3386, 3459, 3601, 3722, 3734, 3878, 4238, 4427, 4803, 4925, 5109, 5144, 5319, 5388, 5579, 5959, 6218, 6360, 6466, 6755, 6759, 6853, 6970, 7082, 7240, 7367, 7917, 8205, 9056, 10004, 10268, 11103, 11386, 11388, 11884, 13569, 13596, 13815, 14258, 14305, 15554, 15599, 15768, 15826, 16139, 17309, 17576, 19369, 19588, 19765, 20123, 21274, 21432, 21725, 21934, 22220, 23516, 23630, 23691, 24357, 24465, 25093, 26248, 29968, 30241, 30489, 30714, 30715, 31769, 31799, 31923, 32121, 33064, 33068, 33088, 33226, 34113, 34136, 34228, 34239, 34308, 34351, 34614, 35490, 35595, 35753, 35785, 36761, 37745, 39019, 39056, 39109, 39722, 39915, 40205, 41053, 41069, 41417, 42547, 44272, 44285, 44492, 44731, 45845, 52005, 52033, 52168, 52419, 52830, 53531, 53841, 55231, 58937, 59500, 61938, 62703, 62887, 63430, 64039, 64140, 66878, 66932, 67786, 69109, 70028, 71940, 72392, 75698, 77877, 79058, 80126, 81261) AND
user_node.path_string LIKE concat( user_tree.path_string,'%' )

I have attached a screenshot from JetProfiler.